RE: search results produce everything in the table...

[Olive, Christopher M Mr USACHPPM]

well, that's what you designed it to do.  what do you want your default no
criteria selected results to be?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-----Original Message-----
From: Richard Hart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 12:23 PM
To: House of Fusion
Subject: search results produce everything in the table...


Hi,

I have a simple search form on which you can search on three criteria.
However when I type nothing in the form and hit submit it gives me
everything in
the table. I have tried to over-ride this to no effect. Can anyone point me
in the right direction?

Thanks,

Richard

..........................

In the results page I have something like:


<CFQUERY NAME="blahblah" DATASOURCE="blahblah">

   blahblah

<CFIF Trim(VariableOne) IS NOT "">
    AND FieldOne LIKE '%#Trim(Form.VariableOne)#%'
</CFIF>

<CFIF Trim(VariableTwo) IS NOT "">
    AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%'
</CFIF>

<CFIF Trim(VariableThree) IS NOT "">
    AND FieldThree LIKE '%#Trim(Form.VariableThree)#%'
</CFIF>

   balhblah

</CFQUERY>


----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.