Pascal
> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 15 juni 2004 20:27
> To: CF-Talk
> Subject: OT: SQL search query
>
> I'm still new to SQL. I want to search two tables from a
> form. The search below does not give me any errors, but
> neither does it generate any hits even though I enter the
> correct items to look for. How do I edit the SQL to make it
> search info in both the "purchaseorders" and/or
> "itemsordered" tables? Thanks.
>
> <cfquery name="Getpo" datasource="purchaseorders"> SELECT *
> FROM purchaseorders p, itemsordered i Where 0=0
>
> <CFIF IsDefined("FORM.ponumber")>
> And ponumber LIKE '%#FORM.ponumber#%'
> </CFIF>
>
> <CFIF IsDefined("FORM.invoicenumber")>
> And invoicenumber LIKE '%#FORM.invoicenumber#%'
> </CFIF>
>
> <CFIF IsDefined("FORM.vendor")>
> And vendor LIKE '#trim(FORM.vendor)#'
> </CFIF>
>
> Order by p.cnumber DESC
>
> Robert O.
> ô�ô
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
