select all help with DRW

[Paul M]

Hi
I have a search form created by the DRW with a text boxes and drop down
boxes in the drop boxes when I want to include all in the search I put %
in the first value field. but the text box has this in the value field
<%=Server.HtmlEncode(Request("Project_ID"))%>
how do I fix it so that if I put nothing in project ID field it ignores it
and moves on to the next field
At the moment I get a database error untill a value is typed into the text
box
Thanks
Paul M

 

[Jim Buyens]

Try a custom query that specifies something like

....WHERE ((Project_ID = 0:rojectId: OR roject_ID:: = "")), ...

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------