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,
>
> 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 name="data" datasource="dsn">
> SELECT sug_suggestions.suggestion_id,
> sug_suggestions.suggestion_name,
> sug_suggestions.submit_date,
> sug_suggestions.status_code,
> sug_suggestions.eval_disposition,
> sug_suggestions.primary_suggestor_userid,
> sug_suggestions.eval_disposition_date,
> sug_suggestions.actual_evaluator_userid,
> sug_more_suggestors.suggestion_id,
> sug_more_suggestors.suggestor_userid,
> sug_evaluators.evaluator_id,
> sug_evaluators.evaluator_userid,
> web_profile.AT_users.userid,
> sug_status_codes.status_code,
> sug_status_codes.status_name
> FROM sug_suggestions, sug_more_suggestors, web_profile.AT_users.userid,
> sug_status_codes
> WHERE sug_suggestions.suggestion_id=sug_suggestions.suggestion_id AND
> sug_suggestions.status_code=sug_status_codes.status_code AND
> sug_suggestions.actual_evaluator_userid=sug_evaluators.evaluator_userid
AND
> sug_evaluators.evaluator_userid=web_profile.at_users.userid AND
> sug_suggestions.suggestion_id=sug_more_suggestors.suggestion_id AND
> sug_more_suggestors.userid=web_profile.at_users.userid AND
> sug_suggestions.primary_suggestor_userid=web_profile.at_users.userid
>
> <cfif form.suggestion_name is not "">
> AND suggestion_name LIKE '#form.suggestion_name#%'
> </cfif>
> <other conditional statements for the other form fields...>
> ORDER BY suggestion_name
>
> </cfquery>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
