> 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>
>
I tried this and it does not seems to be working. I this the id does not get
passed from the first tab
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291827
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
