Forums

This topic is locked

Drop down list on search criteria

Posted 23 years ago
1
has voted
23 years ago Steve Copelin posted:
I have a multi search criteria, three text fields and a drop down list/menu. Its running very nicely, but i need to know how i can have an entry in the list/menu to show all values in my db. like a show all or something.
portfox

Replies

Replied 23 years ago
23 years ago Viktor Farcic replied:
Value for 'Show All' entry should be '%'.
SQL needs to look like:
SELECT *
FROM SomeTable
WHERE SomeField LIKE '%SomeVariable%'

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have a multi search criteria, three text fields and a drop down list/menu. Its running very nicely, but i need to know how i can have an entry in the list/menu to show all values in my db. like a show all or something.
portfox


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
viktor@udzone.com
TalkZone Manager

Reply to this topic