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

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

TalkZone Manager