Techware Labs Header

Forums have moved

See this announcement for more details, or just go directly there.

Prev Previous Post   Next Post Next
  #1  
Old 07-03-2002, 11:29 AM
Aemon_ Aemon_ is offline
Platinium Techie
 
Join Date: Apr 2002
Location: Brandon, UK
Posts: 928
Send a message via AIM to Aemon_
Default SQL problem! help!

ok people, i've been messing with this for a few days, and just cant figure it out.  its a stupid easy problem i think, that i just cant figure it out!  grrrr, one of those days.  ok, i want to search two fields in my database, from one dropdown box.  if thats not a very clear explaniation, heres what i have in the way of code right now.  i'm using coldfusion by the way.

<cfquery datasource="mapbase" name="mapdb">
SELECT      ALAV, MUNICI, COUNTY, LNUMBER, BIBTITLE, MAINTRY, DATE, SUBHEAD1, SUBHEAD2, SUBHEAD3
FROM         Mapdb
WHERE 0=0
<cfif #form.sub3# is not "">
AND SUBHEAD1 LIKE '%#FORM.sub3#%'
OR SUBHEAD2 LIKE '%#FORM.sub3#%'
</cfif>

</cfquery>

any and all help is very very very appreciated guys. thanks!

later.
__________________

Reply With Quote
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 01:13 PM. Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Forum style by ForumMonkeys.