Thanks Phillip! That was EXACTLY what I was looking for.
Oh, and hoses might be a slang term used by only me.... I just meant it times out.
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
"There is no right price for the wrong product, even if it is inexpensive and delivered on time."
>>> [EMAIL PROTECTED] 5/6/2004 10:29:21 AM >>>
At 10:24 AM 5/6/2004, you wrote:
>WHERE
><CFIF IsDefined("Keyword") AND Len(Trim(Keyword))>
>Question_Text LIKE '%#Keyword#%'
>OR
>Answer_Text LIKE '%#Keyword#%'
>OR
>User_First_Name LIKE '%#Keyword#%'
>OR
>User_Last_Name LIKE '%#Keyword#%'
>AND
></CFIF>
>
>And it hoses the page.
What do you mean by 'hoses'?
Also, you should enclose the ORs like so:
<CFIF IsDefined("Keyword") AND Len(Trim(Keyword))>
(Question_Text LIKE '%#Keyword#%'
OR
Answer_Text LIKE '%#Keyword#%'
OR
User_First_Name LIKE '%#Keyword#%'
OR
User_Last_Name LIKE '%#Keyword#%')
AND
</CFIF>
--
Phillip Beazley
Onvix -- Website Hosting, Development & E-commerce
Visit http://www.onvix.com/ or call 727-578-9600.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Need some SQL help Candace Cottrell
- Re: Need some SQL help Phillip Beazley
- RE: Need some SQL help Philip Arnold
- RE: Need some SQL help Shawn Regan
- RE: Need some SQL help Candace Cottrell
- RE: Need some SQL help Philip Arnold
- Re: Need some SQL help Candace Cottrell
- Re: Need some SQL help Phillip Beazley
- RE: Need some SQL help Harkins, Patrick
- RE: Need some SQL help Candace Cottrell
- RE: Need some SQL help Candace Cottrell
- RE: Need some SQL help Harkins, Patrick