Okay, this query should be simple...

Hey All, Maybe some fresh eyes can detect where I've messed up here. I'm building a search screen for users to search across multiple criteria. No matter what I do, I keep getting an Oracle error that the SQL command is not peroperly ended. Do I need to use a different wildcard? cfquery

Re: Okay, this query should be simple...

Stab in the dark... with a very inadequate stabbing utensil... Maybe ORACLE requires an end semi-colon. - Original Message - From: Terri Stocke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 2:03 PM Subject: Okay, this query should be simple... Hey All

Re: Okay, this query should be simple...

Thanks for your response, Chris :) Nope, semicolon wasn't the solution... Any other ideas out there? Original Message Follows From: "Chris Hayes" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Okay, this query should be simple... Date: Thu, 3

Okay, this query should be simple...

iontax.com [EMAIL PROTECTED] Direct: 205.380.8164 -- - Original Message - From: Terri Stocke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 2:03 PM Subject: Okay, this query should be simple... Hey All, Maybe some fresh eyes can detect

RE: Okay, this query should be simple...

] Subject: Okay, this query should be simple... Hey All, Maybe some fresh eyes can detect where I've messed up here. I'm building a search screen for users to search across multiple criteria. No matter what I do, I keep getting an Oracle error that the SQL command is not peroperly ended. Do I need

RE: Okay, this query should be simple...

Stew -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: 31 August 2000 14:03 To: [EMAIL PROTECTED] Subject: Okay, this query should be simple... Hey All, Maybe some fresh eyes can detect where I've messed up here. I'm building a search screen for users to search

RE: Okay, this query should be simple...

Terri, can we see the whole cfquery? Can't see anything wrong with what you posted. Any other ideas out there? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you

RE: Okay, this query should be simple...

PROTECTED]] Sent: Thursday, August 31, 2000 9:03 AM To: [EMAIL PROTECTED] Subject: Okay, this query should be simple... Hey All, Maybe some fresh eyes can detect where I've messed up here. I'm building a search screen for users to search across multiple criteria. No matter what I do, I keep getting

RE: Okay, this query should be simple...

-- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: 31 August 2000 14:03 To: [EMAIL PROTECTED] Subject: Okay, this query should

Re: Okay, this query should be simple...

Terri Stocke" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 2:29 PM Subject: Re: Okay, this query should be simple... Thanks for your response, Chris :) Nope, semicolon wasn't the solution... Any other ideas out there? Original Message Follows From: &q

RE: Okay, this query should be simple...

From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 9:03 AM To: [EMAIL PROTECTED] Subject: Okay, this query should be simple... Hey All, Maybe some fresh eyes can detect where I've messed up here. I'm building a search screen for users to search across multiple crite

RE: Okay, this query should be simple...

From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 9:03 AM To: [EMAIL PROTECTED] Subject: Okay, this query should be simple... Hey All, Maybe some fresh eyes can detect where I've messed up here. I'm building a search screen for users to search across multiple crite