Write a check for a form field to have a value greater then null and then
put your query and output in side that if statement.
if form.field gt ''
do query
if not form.field gt ''
do whatever
end if
Bill
> -----Original Message-----
> From: Richard Hart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 13, 2000 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: RE: search results produce everything in the table...
>
>
> 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.
------------------------------------------------------------------------------
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.
