i have the same problem, its new, never happened before, and is now happening, same kind of code, almost exact actually.
but same problem. what gives? ps. its works in shhhhhhhh... (bla**st**) just fine, just not in cfmx 6.1???? tw On Wed, 3 Nov 2004 17:21:40 -0700, Charlie Griefer <[EMAIL PROTECTED]> wrote: > what's the exact datatype of the field in the database? > > On Wed, 03 Nov 2004 15:31:59 -0800, Brook Davies > > > <[EMAIL PROTECTED]> wrote: > > Actually, I added the val function AFTER getting the error - it makes no > > difference... > > > > > > > > At 03:09 PM 11/3/2004, you wrote: > > >do you need the val() function? is the value coming in as a string or > > >numeric? > > > > > >what happens if you simply <cfoutput>#val(arguments.case_id)#</cfoutput>? > > > > > > > > >On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies > > ><[EMAIL PROTECTED]> wrote: > > > > This query was working fine, with the arguments.case_id variable being > > > > 30026 (and the function it is in is set to receive the case_id as numeric. > > > > Bottom line is it IS numeric. > > > > > > > > <cfquery datasource="#request.datasource#" name="getExpenseRecord"> > > > > select payment_mode from expense > > > > where case_id = <cfqueryparam cfsqltype="cf_sql_integer" > > > > value="#val(arguments.case_id)#"> > > > > </cfquery> > > > > > > > > Now all of a sudden I get this error unless I remove the <cfqueryparam> and > > > > do it without. So its not a big deal, I'm just curious as to what the hecks > > > > happening: > > > > > > > > "Error Executing Database Query. > > > > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested > > > > type. " > > > > > > > > Is this a bug? > > > > > > > > Brook D. > > > > logiforms.com > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
