dik mus
|
| Posted: 06/02/2005, 6:48 AM |
|
Hi,
In a listbox, i want to show my products sorted by productname, AND unioned with sorted by productcode. For two products the list would look like this
id item
1 car (12)
2 bicycle (13)
1 12 (car)
2 13 (bicycle)
If i look at the dataset (revieuw data) it shows all the productitems exactly as I want them. But when i preview the listbox i only get about half the items. Anyone knows how to get them back?
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 06/02/2005, 7:29 AM |
|
Dik,
If you haven’t modified page’s code manually (changed code snippets have white background) and there’s no custom events code that modifies SQL or WHERE of s listbox I recommend you to contact YesSoftware support.
_________________
Regards,
Nicole |
 |
|
dikmus
Posts: 19
|
| Posted: 06/03/2005, 7:07 AM |
|
Hi nicole,
It sees the listbox can only show records with a unique identifieer in the first row. But i will ask support to be sure.
_________________
www.musit.nl |
|
|
|
dik mus
|
| Posted: 06/08/2005, 12:08 PM |
|
just incase anybody is reading this forum and wants to know..
asp.net only shows unique primary keys.
If you need to show the same id more then once change the field to a decimal, and add some random numbers as decimals to make the key unique.
|
|
|
|
|
