><CFQUERY NAME="passport_attendance" dbtype="query"> >SELECT passport_attendance_id >FROM passport_attendance >WHERE student_id = <cfqueryparam >value="#passport_registration.student_id[pr]#" cfsqltype="CF_SQL_INTEGER" >null="#YesNoFormat(passport_registration.student_id[pr] is '')#"> >OR people_id = <cfqueryparam value="#passport_registration.people_id[pr]#" >cfsqltype="CF_SQL_INTEGER" >null="#YesNoFormat(passport_registration.people_id[pr] is '')#"> ></CFQUERY>
That's interesting. I believe that I understand it fine. However, I am still getting an error. Here's the whole error: Query Of Queries syntax error. Encountered "student_id = NULL. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, The error occurred in /afs/.glue.umd.edu/department/oit/eis/webhosting/sph/htdocs/home/passport/attendance/attendance2.cfm: line 129 127 : student_id = <cfqueryparam value="#passport_registration.student_id[pr]#" cfsqltype="CF_SQL_INTEGER" null="#YesNoFormat(passport_registration.student_id[pr] is '')#"> 128 : OR 129 : people_id = <cfqueryparam value="#passport_registration.people_id[pr]#"cfsqltype="CF_SQL_INTEGER"null="#YesNoFormat(passport_registration.people_id[pr] is '')#"> 130 :</CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:318111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
