Dmitry from Russia
|
| Posted: 01/27/2005, 5:34 AM |
|
When I preaper "Data source" for listbox wery usefull to put Checkbox field for Distinct selection. Now I am white this code mannually.
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 01/27/2005, 12:17 PM |
|
Hi,
You can currently do this. Just enter your SQL (with DISTINCT) into the Data Source of the listbox. Make sure that the SQL returns 2 fields: the key and the text to show as listbox values.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
matheus
Posts: 386
|
| Posted: 01/28/2005, 2:32 AM |
|
The problem with distinct in SQL was the sql count from the navigator, the count remove all things before the clause from and put select count(*).
In Java I couldn't use distinct.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
|
peterr
Posts: 5971
|
| Posted: 01/28/2005, 2:36 AM |
|
This should not cause problems with the listbox as there is no Navigator involved in listboxes.
Distinct can also be used with grids but that's a different topic.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Eugene
|
| Posted: 03/23/2005, 2:19 PM |
|
Peter,
I have the same problem but with a grid. I use SQL datasource, with DISTINCT, but that breaks the navigator (it shows more pages than there are.
How can I fix it?
Eugene W.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/23/2005, 2:21 PM |
|
This may depend on the programming language, but usually would be fixed by adjusting the CountSQL.
Search for CountSQL at http://forums.codecharge.com/search.php?s_keyword=count...[]=21&s_period=
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/23/2005, 2:22 PM |
|
And here is more specific solution for PHP:
http://forums.codecharge.com/posts.php?post_id=47234
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Eugene
|
| Posted: 03/23/2005, 4:50 PM |
|
Peter,
Thanks so much for the prompt solution! I looked at the links you referenced, played around with the php source and got it working!
Eugene 
|
|
|
|
