RE: cfqueryparam oddity
Right, I understand that I originally agreed to an NDA for Beta 1, but at MAX, all attendees were given a copy of Beta 2 and told to try it out. Even during the sneak peaks of products no NDAs had to be signed or anything. I'm just wondering if Macromedia has now just thrown the NDAs out the window or how that would work. John Burns From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thu 11/4/2004 11:26 AM To: CF-Talk Subject: Re: cfqueryparam oddity Burns, John D wrote: Speaking of Blackstone, are NDAs out the window now because of MAX? I seriously doubt that. Previous NDA's from Macromedia never expired, but allowed you to talk about information that was public, i.e. also obtainable through other channels. Presuming Macromedia has not changed the text of the NDA, if Ben Forta says X about Blackstone, you are allowed to talk about X, but your NDA still applies to Y and Z. Presuming you are in the Blackstone beta: just take a few minutes to actually *read* the NDA you have agreed to. Understanding a simple legal document should not be out of reach for any native speaker who is willing to spend the effort. Jochem ~| 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:183513 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
RE: cfqueryparam oddity
Answers my question :-) Thanks Tony. John From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thu 11/4/2004 1:44 PM To: CF-Talk Subject: Re: cfqueryparam oddity and to answer the question about the nda even though the cd went out to all in their bag @ max, they all still have to sign up for the beta, and accept the nda. and that my friends is straight from a horses mouth! :) tw On Thu, 4 Nov 2004 12:42:16 -0600, Tony Weeg [EMAIL PROTECTED] wrote: regardless of the nda... any idea whats up with this query param shite? tw On Thu, 04 Nov 2004 17:26:08 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Burns, John D wrote: Speaking of Blackstone, are NDAs out the window now because of MAX? I seriously doubt that. Previous NDA's from Macromedia never expired, but allowed you to talk about information that was public, i.e. also obtainable through other channels. Presuming Macromedia has not changed the text of the NDA, if Ben Forta says X about Blackstone, you are allowed to talk about X, but your NDA still applies to Y and Z. Presuming you are in the Blackstone beta: just take a few minutes to actually *read* the NDA you have agreed to. Understanding a simple legal document should not be out of reach for any native speaker who is willing to spend the effort. Jochem ~| 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:183514 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
RE: cfqueryparam oddity
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 s... (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
Re: cfqueryparam oddity
NDAs will all still apply. I'm pretty sure even at the end of the beta you can't actually 'freely discuss' what went on during the beta, jb. On Thu, 4 Nov 2004 11:01:39 -0500, Burns, John D [EMAIL PROTECTED] wrote: 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 s... (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:183363 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
Re: cfqueryparam oddity
Burns, John D wrote: Speaking of Blackstone, are NDAs out the window now because of MAX? I seriously doubt that. Previous NDA's from Macromedia never expired, but allowed you to talk about information that was public, i.e. also obtainable through other channels. Presuming Macromedia has not changed the text of the NDA, if Ben Forta says X about Blackstone, you are allowed to talk about X, but your NDA still applies to Y and Z. Presuming you are in the Blackstone beta: just take a few minutes to actually *read* the NDA you have agreed to. Understanding a simple legal document should not be out of reach for any native speaker who is willing to spend the effort. Jochem ~| 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:183367 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
Re: cfqueryparam oddity
regardless of the nda... any idea whats up with this query param shite? tw On Thu, 04 Nov 2004 17:26:08 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Burns, John D wrote: Speaking of Blackstone, are NDAs out the window now because of MAX? I seriously doubt that. Previous NDA's from Macromedia never expired, but allowed you to talk about information that was public, i.e. also obtainable through other channels. Presuming Macromedia has not changed the text of the NDA, if Ben Forta says X about Blackstone, you are allowed to talk about X, but your NDA still applies to Y and Z. Presuming you are in the Blackstone beta: just take a few minutes to actually *read* the NDA you have agreed to. Understanding a simple legal document should not be out of reach for any native speaker who is willing to spend the effort. Jochem ~| 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:183390 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
Re: cfqueryparam oddity
and to answer the question about the nda even though the cd went out to all in their bag @ max, they all still have to sign up for the beta, and accept the nda. and that my friends is straight from a horses mouth! :) tw On Thu, 4 Nov 2004 12:42:16 -0600, Tony Weeg [EMAIL PROTECTED] wrote: regardless of the nda... any idea whats up with this query param shite? tw On Thu, 04 Nov 2004 17:26:08 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Burns, John D wrote: Speaking of Blackstone, are NDAs out the window now because of MAX? I seriously doubt that. Previous NDA's from Macromedia never expired, but allowed you to talk about information that was public, i.e. also obtainable through other channels. Presuming Macromedia has not changed the text of the NDA, if Ben Forta says X about Blackstone, you are allowed to talk about X, but your NDA still applies to Y and Z. Presuming you are in the Blackstone beta: just take a few minutes to actually *read* the NDA you have agreed to. Understanding a simple legal document should not be out of reach for any native speaker who is willing to spend the effort. Jochem ~| 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:183391 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
Re: cfqueryparam oddity
regardless of the nda... any idea whats up with this query param shite? I had was having much the same problem intermittently for a while when using a SQL server db. Usually when I restarted CF, the problem disappeared - for a while. As a last resort, I started using the Microsoft SQL Server JDBC Driver, and haven't had any problems since. The Microsoft driver seems a LOT more stable than the bundled datadirect versions (even post CFMX 6.1 Updater). Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138-2AA54BFDC03Adisplaylang=en Install notes: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_config_mssql2000.htm ~| 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:183433 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
cfqueryparam oddity
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:183314 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
Re: cfqueryparam oddity
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 ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183316 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
Re: cfqueryparam oddity
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=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183319 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
Re: cfqueryparam oddity
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 ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183322 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
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 s... (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