Re: SOT Oracle query OR problem

2009-01-16 Thread John M Bliss
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

Re: SOT Oracle query OR problem

2009-01-16 Thread daniel kessler
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

Re: SOT Oracle query OR problem

2009-01-16 Thread John M Bliss
Oops. Try this: CFQUERY NAME=passport_attendance dbtype=query SELECT passport_attendance_id FROM passport_attendance WHERE cfif passport_registration.student_id[pr] is people_id = cfqueryparam value=#passport_registration.people_id[pr]# cfsqltype=CF_SQL_INTEGER cfelse student_id = cfqueryparam

Re: SOT Oracle query OR problem

2009-01-16 Thread daniel kessler
CFQUERY NAME=passport_attendance dbtype=query SELECT passport_attendance_id FROM passport_attendance WHERE cfif passport_registration.student_id[pr] is people_id = cfqueryparam value=#passport_registration.people_id[pr]# cfsqltype=CF_SQL_INTEGER cfelse student_id = cfqueryparam