Re: SOT Oracle query OR problem

2009-01-16 Thread daniel kessler
>SELECT passport_attendance_id >FROM passport_attendance >WHERE > >people_id = cfsqltype="CF_SQL_INTEGER"> > >student_id = cfsqltype="CF_SQL_INTEGER"> > > > >Last one did not work because syntax should be "IS NULL" not "= NULL" That one worked fine and is very straight-forward. Makes total sens

Re: SOT Oracle query OR problem

2009-01-16 Thread John M Bliss
Oops. Try this: SELECT passport_attendance_id FROM passport_attendance WHERE people_id = student_id = Last one did not work because syntax should be "IS NULL" not "= NULL" On Fri, Jan 16, 2009 at 4:14 PM, daniel kessler wrote: > > > >SELECT passport_attendance_id > >FROM passport_atte

Re: SOT Oracle query OR problem

2009-01-16 Thread daniel kessler
> >SELECT passport_attendance_id >FROM passport_attendance >WHERE student_id = value="#passport_registration.student_id[pr]#" cfsqltype="CF_SQL_INTEGER" >null="#YesNoFormat(passport_registration.student_id[pr] is '')#"> >OR people_id = cfsqltype="CF_SQL_INTEGER" >null="#YesNoFormat(passport_registr

Re: SOT Oracle query OR problem

2009-01-16 Thread John M Bliss
SELECT passport_attendance_id FROM passport_attendance WHERE student_id = OR people_id = On Fri, Jan 16, 2009 at 2:13 PM, daniel kessler wrote: > I'm doing this query in Oracle and am encountering the error: > > Encountered "student_id = OR. Incorrect conditional expression, Expected > one

SOT Oracle query OR problem

2009-01-16 Thread daniel kessler
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, SELECT passport_attendance_id FROM passport_attendance WHERE student_id = #pass