I have a input box wher I am getting the value for my where clause. INstead I
am getting the error Error converting the varchar value to a column of data
type int
<cfquery name="infoNote" datasource="XXXXX" >
SELECT apr.reqid, apr.requirement,
aprm.sortorder,apr.req_prereq,apr.hidden,ap.school_division
FROM trnAcademicProgramsAndRequirementsMapping aprm INNER JOIN
trnAcademicProgramRequirements apr ON aprm.reqid = apr.reqid INNER
JOIN
trnAcademicPrograms ap ON aprm.degreeid = ap.id
WHERE ap.school_division='#session.schoolcode#' and ap.id =cast('#form.test#'
as int(4))
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
