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