Speaking of Blackstone, are NDAs out the window now because of MAX? Can we talk freely? Or does the MAX copy say something about "Opening this means you accept the NDA" and maybe "this message will self destruct in 30 seconds"? John
________________________________ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thu 11/4/2004 1:00 AM To: CF-Talk Subject: Re: cfqueryparam oddity 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 > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183360 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
