This content has been marked as final.
Show 3 replies
-
1. Re: Help with MySQL Form Search
bregent Jan 30, 2009 7:49 PM (in response to Mike_Watt)>I tried %, but that's not
That would only work with the 'like' operator. If you are using DW behaviors to build the query, I'm not sure what you can do; I have not used those in a long time. The correct way is to test the field and if it is null, leave it out of the where clause completely. -
2. Re: Help with MySQL Form Search
Mike_Watt Jan 31, 2009 10:54 PM (in response to bregent)I am completely self-taught to this point... testing the fields for content and adjusting the WHERE clause accordingly is a bit beyond my level. However, if anyone knows of any good content on the web that can help me get it that would be helpful... i just need to see a couple examples of this in action in order to comprehend it.
I know that this is (or should be) an incredibly basic function of DB query... this shouldn't be THAT hard to find... I've googled and come up short... -
3. Re: Help with MySQL Form Search
DwFAQ Jan 31, 2009 11:09 PM (in response to Mike_Watt)Use a php if/else conditional region to determine database query.
See Günter's "quick & dirty pointer" HERE




