sorry I didn't make myself clear.
When the user types in nothing I want them to get nothing.
> -----Original Message-----
> From: Olive, Christopher M Mr USACHPPM
> [mailto:[EMAIL PROTECTED]]
> Sent: 11 April 2000 18:38
> To: '[EMAIL PROTECTED]'
> Subject: RE: search results produce everything in the table...
>
>
> 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.
------------------------------------------------------------------------------
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.
