Terri,
It actually looks fine to me, the wildcard, however you have a table
sug_evaluators in the select statement and not in the from statement, also
i'd use aliases for the table names to cut down the clutter, you've also
joined on sug_suggestions.suggestion_id=sug_suggestions.suggestion_id
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 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.
