I'm doing this query in Oracle and am encountering the error:
Encountered "student_id = OR. Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition,
<CFQUERY NAME="passport_attendance" dbtype="query">
SELECT passport_attendance_id
FROM passport_attendance
WHERE student_id = #passport_registration.student_id[pr]#
OR people_id = #passport_registration.people_id[pr]#
</CFQUERY>
The problem appears to be that sometimes passport_registration.student_id[pr]
is empty. It's a numeric, so when I wrapped it in quotes, it didn't like that
either cause it was comparing different types.
How do I handle that sort of situation? One of the two is always gonna be
empty.
daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318103
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
