Is this part right?
>FROM sug_suggestions, sug_more_suggestors, web_profile.AT_users.userid,
> sug_status_codes
> WHERE sug_suggestions.suggestion_id=sug_suggestions.suggestion_id AND
should web_profile.AT_users.userid not be web_profile?
~Justin
----- Original Message -----
From: "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: "Chris Hayes" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: <[EMAIL PROTECTED]>
> Subject: Re: Okay, this query should be simple...
> Date: Thu, 31 Aug 2000 14:13:07 +0100
>
> 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.
>
> _________________________________________________________________________
> 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.
