>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
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
>
>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
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
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
5 matches
Mail list logo