Hi there Just checked if nothing is selected then the value p[assed from the form is "Please Select" if all states is selected the value passed is "All States"
Looks like that is probably the problem. Sorry I'm not thinking well today - I have been out fighting bushfires in Sydney Australia the last 2 days. Regards -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 January 2007 7:43 AM To: CF-Talk Subject: Re: Problems with a query On 1/22/07, Pete <[EMAIL PROTECTED]> wrote: > <!--- Search by procedureid ---> > <cfif FORM.ProcedureID IS NOT ""> > AND tbl_procedures.ProcedureID = '#Form.ProcedureID#' > </cfif> > <!--- Search by stateid ---> > <cfif FORM.stateid IS NOT ""> > AND tbl_states.stateid = '#FORM.stateid#' > </cfif> > ) > > </cfquery> what's the value coming from the form if the user chooses all states or does not choose a state? -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
