Instead of cast('#form.test#' as int(4)) I'd try #val(form.test)# and a
cfqueryparam would probably help the situation as well
Original Message -----------------------
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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
