RE: Data Truncation on CFquery Update: SOLVED
Thanks Rob Parkhill. It was the Max data length in cf admin.It was set to 64,000 characters by default. Adjusting that solved the problem. Robert Harrison Director of Interactive Services Austin & Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Truncation on TEXT field
yes certainly something you need to remember. Every argument you have on a list gets Googled and will show up in search results :-) Even twitter posts get Googled. On Mon, Mar 14, 2011 at 10:58 PM, Bobby Hartsfield wrote: > > Even the ones** > > > .:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > -Original Message- > From: Bobby Hartsfield [mailto:bo...@acoderslife.com] > Sent: Monday, March 14, 2011 5:41 PM > To: cf-talk > Subject: RE: Data Truncation on TEXT field > > > Enable Blob/Clob on the datasoruce. > > FYI, this is a public list indexed by Google... Client's can search for > your > name... if the ones with no sense haha ;-) > > > .:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > -Original Message- > From: Robert Harrison [mailto:rob...@austin-williams.com] > Sent: Monday, March 14, 2011 1:39 PM > To: cf-talk > Subject: Data Truncation on TEXT field > > > Hi, > > I have a client with no sense who want to type a book into a single field. > They have over 200,000 characters they are typing into the edit file. > > Data base is: > MS SQL 2008 R2 > Field type is: >text > > When an update is done the data is truncated at around 63,000 characters. > I've output that data before update the update can see that all the data is > being passed to the next page. I also tried hardcoding the data into the > SQL > statement to see if it gets truncated and it still does. > > With a data type of TEXT I can see no reason truncation is occurring. > > Anyone have any ideas on this? > > Thanks > > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Data Truncation on TEXT field
Even the ones** .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Monday, March 14, 2011 5:41 PM To: cf-talk Subject: RE: Data Truncation on TEXT field Enable Blob/Clob on the datasoruce. FYI, this is a public list indexed by Google... Client's can search for your name... if the ones with no sense haha ;-) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, March 14, 2011 1:39 PM To: cf-talk Subject: Data Truncation on TEXT field Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base is: MS SQL 2008 R2 Field type is: text When an update is done the data is truncated at around 63,000 characters. I've output that data before update the update can see that all the data is being passed to the next page. I also tried hardcoding the data into the SQL statement to see if it gets truncated and it still does. With a data type of TEXT I can see no reason truncation is occurring. Anyone have any ideas on this? Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Data Truncation on TEXT field
Enable Blob/Clob on the datasoruce. FYI, this is a public list indexed by Google... Client's can search for your name... if the ones with no sense haha ;-) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, March 14, 2011 1:39 PM To: cf-talk Subject: Data Truncation on TEXT field Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base is: MS SQL 2008 R2 Field type is: text When an update is done the data is truncated at around 63,000 characters. I've output that data before update the update can see that all the data is being passed to the next page. I also tried hardcoding the data into the SQL statement to see if it gets truncated and it still does. With a data type of TEXT I can see no reason truncation is occurring. Anyone have any ideas on this? Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Truncation on TEXT field
Rob, The Text, NText, and Image data types come from the previous versions of SQL Server. It is recommended that you use the newer varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types instead. Results to text only allows a maximum of 8192 characters. Perhaps this is also your issue in querying the database directly. [image: Screenshot] You could try using the TSQL len() function (not the CF len function) to find the length of the data and see if it has actually been truncated in the database, or just when you select it. On Mon, Mar 14, 2011 at 5:45 PM, Robert Harrison wrote: > > Going straight to just the SQL update I have: > > > UPDATE tbl_capabilities_categories > SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS' > WHERE id=#id#; > > > capability_cat_txt2 field type is TEXT > > Only about 63,000 of the update characters are being updated to the field. > The remainder is truncated. I am getting no truncation warning and I've > certainly makde sure there is no ' in the string to cause an early end to > the data. > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Data Truncation on TEXT field
That's it. Thank You. Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Monday, March 14, 2011 1:43 PM To: cf-talk Subject: Re: Data Truncation on TEXT field Check the advanced settings on the datasource in the CF Adminstrator. Make sure "CLOB" (Enable long text retrival) is checked , and increase the long text buffer to handle the larger data field size. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342998 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Data Truncation on TEXT field
Going straight to just the SQL update I have: UPDATE tbl_capabilities_categories SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS' WHERE id=#id#; capability_cat_txt2 field type is TEXT Only about 63,000 of the update characters are being updated to the field. The remainder is truncated. I am getting no truncation warning and I've certainly makde sure there is no ' in the string to cause an early end to the data. Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Truncation on TEXT field
Check the advanced settings on the datasource in the CF Adminstrator. Make sure "CLOB" (Enable long text retrival) is checked , and increase the long text buffer to handle the larger data field size. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342996 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Data Truncation on TEXT field
Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base is: MS SQL 2008 R2 Field type is: text When an update is done the data is truncated at around 63,000 characters. I've output that data before update the update can see that all the data is being passed to the next page. I also tried hardcoding the data into the SQL statement to see if it gets truncated and it still does. With a data type of TEXT I can see no reason truncation is occurring. Anyone have any ideas on this? Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data truncation:
*facepalm* Syntax gets you every time, doesn't it? --Ben Doom Deepak Gupta wrote: > got it > > instead of AND i have to use comma. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Data truncation:
got it instead of AND i have to use comma. >Hi >I am getting this error >Data truncation: Truncated incorrect DOUBLE value > >from query > > > > > Update #Table# SET > > > > #arr1[i]#='#arr2[i]#' > > > > AND > > > > > > WHERE ID=#UID# > > > > > >The column names are of type varchar(50) > >Can anyone help me with this issue?Its killing me right now. > >DG ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Data truncation:
Hi I am getting this error Data truncation: Truncated incorrect DOUBLE value from query Update #Table# SET #arr1[i]#='#arr2[i]#' AND WHERE ID=#UID# The column names are of type varchar(50) Can anyone help me with this issue? Its killing me right now. DG ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
its Friday afternoon.. almost beer time.. my brian is not working but... Update tableName SET FirstName='D' AND LastName='G' shouldnt the update statement be Update tableName SET FirstName='D', LastName='G' Joel - Original Message - From: "Deepak Gupta" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, March 09, 2007 2:16 PM Subject: Re: Data truncation: Truncated incorrect DOUBLE > This is what i get when i output the query > > Update tableName SET FirstName='D' AND LastName='G' > and firstName and lastName are varchar in my table that too varchar(256) > > DG > >>Are you sure that the value in arr1 which lines up with D points to a >>char, varchar, etc.? Try removing the cfquery from around the query to >>show what is actually being produced. Also, check your schema to make >>sure that the columns are correctly defined. >> >>--Ben Doom >> >>Deepak Gupta wrote: >>>> --Ben > > ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
Can anyone help me with this issue >Is it some mysql issue??? > >DG >>> My query is ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
Is it some mysql issue??? DG >Is the datasource empty in the live version, or did you remove it to >post here? > >--Ben Doom > >Deepak Gupta wrote: >> HI >> >> I am getting this error >> >> Data truncation: Truncated incorrect DOUBLE value: 'Value1' >> >> My query is ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
I removed it to post here. DG >Is the datasource empty in the live version, or did you remove it to >post here? > >--Ben Doom > >Deepak Gupta wrote: >> HI >> >> I am getting this error >> >> Data truncation: Truncated incorrect DOUBLE value: 'Value1' >> >> My query is ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Data truncation: Truncated incorrect DOUBLE
Is the datasource empty in the live version, or did you remove it to post here? --Ben Doom Deepak Gupta wrote: > HI > > I am getting this error > > Data truncation: Truncated incorrect DOUBLE value: 'Value1' > > My query is ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
This is what i get when i output the query Update tableName SET FirstName='D' AND LastName='G' and firstName and lastName are varchar in my table that too varchar(256) DG >Are you sure that the value in arr1 which lines up with D points to a >char, varchar, etc.? Try removing the cfquery from around the query to >show what is actually being produced. Also, check your schema to make >sure that the columns are correctly defined. > >--Ben Doom > >Deepak Gupta wrote: >>> --Ben ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Data truncation: Truncated incorrect DOUBLE
Are you sure that the value in arr1 which lines up with D points to a char, varchar, etc.? Try removing the cfquery from around the query to show what is actually being produced. Also, check your schema to make sure that the columns are correctly defined. --Ben Doom Deepak Gupta wrote: > I dumped arr2 and i got the value D which is correct. But somehow its > recognizing it as double . I dont understand my column name is > actually firstName and the value i am passing is 'derek'. I cut down > to D even then it gives me error. Its the D value that i am setting > using an update query. > > > DG >> Wait. What is actually stored in arr2? It looks like you're >> trying to store the value "Value1" in a double. Try dumping arr2 >> -- you may be getting value names instead of values. >> >> --Ben ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Data truncation: Truncated incorrect DOUBLE
I dumped arr2 and i got the value D which is correct. But somehow its recognizing it as double . I dont understand my column name is actually firstName and the value i am passing is 'derek'. I cut down to D even then it gives me error. Its the D value that i am setting using an update query. DG >Wait. What is actually stored in arr2? It looks like you're trying to >store the value "Value1" in a double. Try dumping arr2 -- you may be >getting value names instead of values. > >--Ben > >Deepak Gupta wrote: >> ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
Wait. What is actually stored in arr2? It looks like you're trying to store the value "Value1" in a double. Try dumping arr2 -- you may be getting value names instead of values. --Ben Deepak Gupta wrote: > I tried using single quotes too. Still it doesnt work > > DG >> Offhand, if arr2 contains values, you should use single quotes around >> it, not double quotes. >> >> --Ben Doom >> >> Deepak Gupta wrote: >>> HI >>> >>> I am getting this error >>> >>> Data truncation: Truncated incorrect DOUBLE value: 'Value1' >>> >>> My query is > > ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
I tried using single quotes too. Still it doesnt work DG >Offhand, if arr2 contains values, you should use single quotes around >it, not double quotes. > >--Ben Doom > >Deepak Gupta wrote: >> HI >> >> I am getting this error >> >> Data truncation: Truncated incorrect DOUBLE value: 'Value1' >> >> My query is ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data truncation: Truncated incorrect DOUBLE
Offhand, if arr2 contains values, you should use single quotes around it, not double quotes. --Ben Doom Deepak Gupta wrote: > HI > > I am getting this error > > Data truncation: Truncated incorrect DOUBLE value: 'Value1' > > My query is ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Data truncation: Truncated incorrect DOUBLE
HI I am getting this error Data truncation: Truncated incorrect DOUBLE value: 'Value1' My query is Update tableName SET #arr1[i]#="#arr2[i]#" AND what can be the problem with this DG ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: data truncation??
Perhaps your field lengths are too short. Check the length of the fields in the database for each parameter (especially those long ones) Joseph Christina, RN Web Programmer Children's Hospital of Philadelphia -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: data truncation??
> From: "AKBAR" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, May 04, 2000 8:25 PM > Subject: data truncation?? > > > > hello everybody, > > > > can anyone plzz tell me wat this error stands for?? i am > not able to proceed > > further. > > > > plzz, tell me the solution for this. I just ran into this error myself yesterday. Our problem was that we were trying to put an 11 character string into a field that was only 10 characters wide. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: data truncation??
i dunno. actually wat i was trying to do is to invoke a PLP. and it was working fine till yesterday. > ok here is the query code. i am running spectra. > > Queries > > > qGetRecords (Records=0, Time=0ms) > SQL = > select * from plpinstances > > > where > > plpid > > = ? > > > > > > and > > username > > = ? > > Query Parameter Value(s) - > Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > Parameter #2 = system > > qGetRecords (Records=1, Time=15ms) > SQL = > select * from wddxdata > > > where > > plpid > > = ? > > Query Parameter Value(s) - > Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > > qGetRecords (Records=0, Time=0ms) > SQL = > select * from plpinstances > > > where > > plpid > > = ? > > Query Parameter Value(s) - > Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > > -- -- > > > Error Occurred While Processing Request > Error Diagnostic Information > ODBC Error Code = 01004 (Data truncated) > > > [Microsoft][ODBC SQL Server Driver]Fractional truncation > > > SQL = "insert into plpinstances ( > dtexpires,plpid,plpinstanceid,username,wddxid ) values ( ? ,? ,? ,? ,? )" > > Query Parameter Value(s) - > > Parameter #1 = 36651.4121181 > > Parameter #2 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > > Parameter #3 = 87150BD4-218A-11D4-BF53000629EE5322 > > Parameter #4 = system > > Parameter #5 = 87150BD3-218A-11D4-BF53000629EE5322 > > Data Source = "slogis" > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (3:1) to (3:67) in the template file > C:\PROGRAM > FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDI NSERT_BP.CFM. > > > > > -Original Message- > From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 05, 2000 9:31 AM > To: [EMAIL PROTECTED] > Subject: Re: data truncation?? > > > You'll need to show the query code as well. > > - Original Message - > From: "AKBAR" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, May 04, 2000 8:25 PM > Subject: data truncation?? > > > > hello everybody, > > > > can anyone plzz tell me wat this error stands for?? i am > not able to proceed > > further. > > > > plzz, tell me the solution for this. > > > > thanx in advance > > > > akbar > > > > Error Diagnostic Information > > ODBC Error Code = 01004 (Data truncated) > > [Microsoft][ODBC SQL Server Driver]Fractional truncation > > The error occurred while processing an element with a > general identifier of > > (CFQUERY), occupying document position (3:1) to (3:67). > > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: data truncation??
the question mark is really there? - Original Message - From: "AKBAR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 04, 2000 8:44 PM Subject: RE: data truncation?? > ok here is the query code. i am running spectra. > > Queries > > > qGetRecords (Records=0, Time=0ms) > SQL = > select * from plpinstances > > > where > > plpid > > = ? > > > > > > and > > username > > = ? > > Query Parameter Value(s) - > Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > Parameter #2 = system > > qGetRecords (Records=1, Time=15ms) > SQL = > select * from wddxdata > > > where > > plpid > > = ? > > Query Parameter Value(s) - > Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > > qGetRecords (Records=0, Time=0ms) > SQL = > select * from plpinstances > > > where > > plpid > > = ? > > Query Parameter Value(s) - > Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > > -- -- > > > Error Occurred While Processing Request > Error Diagnostic Information > ODBC Error Code = 01004 (Data truncated) > > > [Microsoft][ODBC SQL Server Driver]Fractional truncation > > > SQL = "insert into plpinstances ( > dtexpires,plpid,plpinstanceid,username,wddxid ) values ( ? ,? ,? ,? ,? )" > > Query Parameter Value(s) - > > Parameter #1 = 36651.4121181 > > Parameter #2 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 > > Parameter #3 = 87150BD4-218A-11D4-BF53000629EE5322 > > Parameter #4 = system > > Parameter #5 = 87150BD3-218A-11D4-BF53000629EE5322 > > Data Source = "slogis" > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (3:1) to (3:67) in the template file > C:\PROGRAM > FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDI NSERT_BP.CFM. > > > > > -Original Message- > From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 05, 2000 9:31 AM > To: [EMAIL PROTECTED] > Subject: Re: data truncation?? > > > You'll need to show the query code as well. > > - Original Message - > From: "AKBAR" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, May 04, 2000 8:25 PM > Subject: data truncation?? > > > > hello everybody, > > > > can anyone plzz tell me wat this error stands for?? i am > not able to proceed > > further. > > > > plzz, tell me the solution for this. > > > > thanx in advance > > > > akbar > > > > Error Diagnostic Information > > ODBC Error Code = 01004 (Data truncated) > > [Microsoft][ODBC SQL Server Driver]Fractional truncation > > The error occurred while processing an element with a > general identifier of > > (CFQUERY), occupying document position (3:1) to (3:67). > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li > sts/cf_talk or send a message to > [EMAIL PROTECTED] with 'unsubscribe' in the > body. > > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: data truncation??
ok here is the query code. i am running spectra. Queries qGetRecords (Records=0, Time=0ms) SQL = select * from plpinstances where plpid = ? and username = ? Query Parameter Value(s) - Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 Parameter #2 = system qGetRecords (Records=1, Time=15ms) SQL = select * from wddxdata where plpid = ? Query Parameter Value(s) - Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 qGetRecords (Records=0, Time=0ms) SQL = select * from plpinstances where plpid = ? Query Parameter Value(s) - Parameter #1 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 01004 (Data truncated) [Microsoft][ODBC SQL Server Driver]Fractional truncation SQL = "insert into plpinstances ( dtexpires,plpid,plpinstanceid,username,wddxid ) values ( ? ,? ,? ,? ,? )" Query Parameter Value(s) - Parameter #1 = 36651.4121181 Parameter #2 = FA3A8C98-D2CC-11D3-BB4C00A0D21C0F39 Parameter #3 = 87150BD4-218A-11D4-BF53000629EE5322 Parameter #4 = system Parameter #5 = 87150BD3-218A-11D4-BF53000629EE5322 Data Source = "slogis" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:67) in the template file C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDINSERT_BP.CFM. -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Friday, May 05, 2000 9:31 AM To: [EMAIL PROTECTED] Subject: Re: data truncation?? You'll need to show the query code as well. - Original Message - From: "AKBAR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 04, 2000 8:25 PM Subject: data truncation?? > hello everybody, > > can anyone plzz tell me wat this error stands for?? i am not able to proceed > further. > > plzz, tell me the solution for this. > > thanx in advance > > akbar > > Error Diagnostic Information > ODBC Error Code = 01004 (Data truncated) > [Microsoft][ODBC SQL Server Driver]Fractional truncation > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (3:1) to (3:67). > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: data truncation??
You'll need to show the query code as well. - Original Message - From: "AKBAR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 04, 2000 8:25 PM Subject: data truncation?? > hello everybody, > > can anyone plzz tell me wat this error stands for?? i am not able to proceed > further. > > plzz, tell me the solution for this. > > thanx in advance > > akbar > > Error Diagnostic Information > ODBC Error Code = 01004 (Data truncated) > [Microsoft][ODBC SQL Server Driver]Fractional truncation > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (3:1) to (3:67). > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
data truncation??
hello everybody, can anyone plzz tell me wat this error stands for?? i am not able to proceed further. plzz, tell me the solution for this. thanx in advance akbar Error Diagnostic Information ODBC Error Code = 01004 (Data truncated) [Microsoft][ODBC SQL Server Driver]Fractional truncation The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:67). -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: data truncation
I got the same error when trying to insert more characters than the table field length in the datasource is set to. Kent Runyan Konnections, Inc. > -Original Message- > From: Ben Densmore [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 19, 2000 8:07 AM > To: [EMAIL PROTECTED] > Subject: data truncation > > > This is a multi-part message in MIME format. > > --=_NextPart_000_0059_01BFA9E6.FE00C9E0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > has anyone run into this problem before? I only get this error message = > once in a while. some people that submit the form have no problem. about = > 3 out of 50 people a day get this error.=20 > Thanks > > Error Occurred While Processing Request > > Error Diagnostic Information > > ODBC Error Code =3D 22001 (String data right truncation) > > [Microsoft][ODBC SQL Server Driver]String data right truncation > > Data Source =3D "BIOSReference" > > SQL =3D "INSERT INTO "europeleads" ( "FirstName" , "TodaysDate" , > "BiosIdString" , "SuperIO" , "CPU" , "CompanyName" , "CpuSpeed" , > "PhoneEve" , "Email" , "OEMSignon" , "LastName" , "BiosInfo" , "BIOS" , > "BiosDate" , "PhoneDay" , "Chipset" , "Comments" ) VALUES ( > ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" > > The error occurred while processing an element with a general > identifier of (CFINSERT), occupying document position (53:1) to (53:249) > in the > template file D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM > > The specific sequence of files included or processed is: > D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM . > > Date/Time: 04/18/00 18:42:41 > Browser: Mozilla/4.72 [en] (Win98; I) > Remote Address: 195.38.97.174 > HTTP Referer: > > http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDate=3D10/= > 22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A69KA1AC-GX&uSIO=3D= > Winbond > 977TF rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev 3&uOEM=3DGREEN > AGP/PCI/ISA SYSTEM > Template: D:\WebSite\register\htdocs\leads\submit_biosform.cfm > > > > Ben Densmore > Webmaster > eSupport.com, Inc > TouchStone Software Corp. > > > --=_NextPart_000_0059_01BFA9E6.FE00C9E0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > > has anyone run into this problem = > before? I=20 > only get this error message once in a while. some people that submit the = > form=20 > have no problem. about 3 out of 50 people a day get this error. = > > Thanks > > Error Occurred While Processing=20 > Request Error Diagnostic Information ODBC = > Error Code =3D=20 > 22001 (String data right truncation) [Microsoft][ODBC SQL = > Server=20 > Driver]String data right truncation Data Source =3D=20 > "BIOSReference" SQL =3D "INSERT INTO "europeleads" ( = > "FirstName" ,=20 > "TodaysDate" ,"BiosIdString" , "SuperIO" , "CPU" , "CompanyName" ,=20 > "CpuSpeed" , "PhoneEve" , "Email" , "OEMSignon" , "LastName" ,=20 > "BiosInfo" , "BIOS" ,"BiosDate" , "PhoneDay" , "Chipset" , = > "Comments" )=20 > VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" The = > error=20 > occurred while processing an element with a generalidentifier of = > (CFINSERT),=20 > occupying document position (53:1) to (53:249)in = > the template file=20 > D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM The = > specific=20 > sequence of files included or processed=20 > is: D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM &n= > bsp; =20 > . Date/Time: 04/18/00 18:42:41 Browser: = > Mozilla/4.72 [en]=20 > (Win98; I) Remote Address: 195.38.97.174 HTTP=20 > Referer: href=3D"http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDa= > te=3D10/22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A69= > KA1AC-GX&uSIO=3DWinbond">http://register.unicore.com:8081/leads/bios_= > upgrade_form.cfm?uBDate=3D10/22/98&uBType=3DAward&uBID=3D10/22/19= > 98-i440BX-W83977-2A69KA1AC-GX&uSIO=3DWinbond 977TF=20 > rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev=20 > 3&uOEM=3DGREENAGP/PCI/ISA SYSTEM Template:=20 > D:\WebSite\register\htdocs\leads\submit_biosform.cfm DIV> > Ben = > DensmoreWebmastereSupport.com,=20 > IncTouchStone Software Corp. > > --=_NextPart_000_0059_01BFA9E6.FE00C9E0-- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: data truncation
One of the form fields allows more info than your db field allows. add maxlength="??" to your form fields to equal the field size of your corresponding db fields. Jeff Craig -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: data truncation
You are trying to insert a string into a field, with a value longer than the maximum width of the field. This is the cause of the message. You will need to limit the maximum length that can be entered by the user to match the maximum size of the field. DC - Original Message - From: Ben Densmore <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 19, 2000 14:06 Subject: data truncation > This is a multi-part message in MIME format. > > --=_NextPart_000_0059_01BFA9E6.FE00C9E0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > has anyone run into this problem before? I only get this error message = > once in a while. some people that submit the form have no problem. about > = > 3 out of 50 people a day get this error.=20 > Thanks > > Error Occurred While Processing Request > > Error Diagnostic Information > > ODBC Error Code =3D 22001 (String data right truncation) > > [Microsoft][ODBC SQL Server Driver]String data right truncation > > Data Source =3D "BIOSReference" > > SQL =3D "INSERT INTO "europeleads" ( "FirstName" , "TodaysDate" , > "BiosIdString" , "SuperIO" , "CPU" , "CompanyName" , "CpuSpeed" , > "PhoneEve" , "Email" , "OEMSignon" , "LastName" , "BiosInfo" , "BIOS" , > "BiosDate" , "PhoneDay" , "Chipset" , "Comments" ) VALUES ( > ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" > > The error occurred while processing an element with a general > identifier of (CFINSERT), occupying document position (53:1) to (53:249) > in the > template file D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM > > The specific sequence of files included or processed is: > D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM . > > Date/Time: 04/18/00 18:42:41 > Browser: Mozilla/4.72 [en] (Win98; I) > Remote Address: 195.38.97.174 > HTTP Referer: > > http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDate=3D10 > /= > 22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A69KA1AC-GX&uSIO=3 > D= > Winbond > 977TF rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev 3&uOEM=3DGREEN > AGP/PCI/ISA SYSTEM > Template: D:\WebSite\register\htdocs\leads\submit_biosform.cfm > > > > Ben Densmore > Webmaster > eSupport.com, Inc > TouchStone Software Corp. > > > --=_NextPart_000_0059_01BFA9E6.FE00C9E0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > > has anyone run into this problem = > before? I=20 > only get this error message once in a while. some people that submit the > = > form=20 > have no problem. about 3 out of 50 people a day get this error. = > > Thanks > > Error Occurred While Processing=20 > Request Error Diagnostic Information ODBC = > Error Code =3D=20 > 22001 (String data right truncation) [Microsoft][ODBC SQL = > Server=20 > Driver]String data right truncation Data Source =3D=20 > "BIOSReference" SQL =3D "INSERT INTO "europeleads" ( = > "FirstName" ,=20 > "TodaysDate" ,"BiosIdString" , "SuperIO" , "CPU" , "CompanyName" > ,=20 > "CpuSpeed" , "PhoneEve" , "Email" , "OEMSignon" , "LastName" > ,=20 > "BiosInfo" , "BIOS" ,"BiosDate" , "PhoneDay" , "Chipset" , = > "Comments" )=20 > VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" The = > error=20 > occurred while processing an element with a generalidentifier of = > (CFINSERT),=20 > occupying document position (53:1) to (53:249)in = > the template file=20 > D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM The = > specific=20 > sequence of files included or processed=20 > is: D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM & > n= > bsp; =20 > . Date/Time: 04/18/00 18:42:41 Browser: = > Mozilla/4.72 [en]=20 > (Win98; I) Remote Address: 195.38.97.174 HTTP=20 > Referer: href=3D"http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBD > a= > te=3D10/22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A6 > 9= > KA1AC-GX&uSIO=3DWinbond">http://register.unicore.com:8081/leads/bios > _= > upgrade_form.cfm?uBDate=3D10/22/98&uBType=3DAward&uBID=3D10/22/1 > 9= > 98-i440BX-W83977-2A69KA1AC-GX&uSIO=3DWinbond 977TF=20 > rev 0 f
data truncation
This is a multi-part message in MIME format. --=_NextPart_000_0059_01BFA9E6.FE00C9E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable has anyone run into this problem before? I only get this error message = once in a while. some people that submit the form have no problem. about = 3 out of 50 people a day get this error.=20 Thanks Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code =3D 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver]String data right truncation Data Source =3D "BIOSReference" SQL =3D "INSERT INTO "europeleads" ( "FirstName" , "TodaysDate" , "BiosIdString" , "SuperIO" , "CPU" , "CompanyName" , "CpuSpeed" , "PhoneEve" , "Email" , "OEMSignon" , "LastName" , "BiosInfo" , "BIOS" , "BiosDate" , "PhoneDay" , "Chipset" , "Comments" ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (53:1) to (53:249) in the template file D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM The specific sequence of files included or processed is: D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM . Date/Time: 04/18/00 18:42:41 Browser: Mozilla/4.72 [en] (Win98; I) Remote Address: 195.38.97.174 HTTP Referer: http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDate=3D10/= 22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A69KA1AC-GX&uSIO=3D= Winbond 977TF rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev 3&uOEM=3DGREEN AGP/PCI/ISA SYSTEM Template: D:\WebSite\register\htdocs\leads\submit_biosform.cfm Ben Densmore Webmaster eSupport.com, Inc TouchStone Software Corp. --=_NextPart_000_0059_01BFA9E6.FE00C9E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable has anyone run into this problem = before? I=20 only get this error message once in a while. some people that submit the = form=20 have no problem. about 3 out of 50 people a day get this error. = Thanks Error Occurred While Processing=20 Request Error Diagnostic Information ODBC = Error Code =3D=20 22001 (String data right truncation) [Microsoft][ODBC SQL = Server=20 Driver]String data right truncation Data Source =3D=20 "BIOSReference" SQL =3D "INSERT INTO "europeleads" ( = "FirstName" ,=20 "TodaysDate" ,"BiosIdString" , "SuperIO" , "CPU" , "CompanyName" ,=20 "CpuSpeed" , "PhoneEve" , "Email" , "OEMSignon" , "LastName" ,=20 "BiosInfo" , "BIOS" ,"BiosDate" , "PhoneDay" , "Chipset" , = "Comments" )=20 VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" The = error=20 occurred while processing an element with a generalidentifier of = (CFINSERT),=20 occupying document position (53:1) to (53:249)in = the template file=20 D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM The = specific=20 sequence of files included or processed=20 is: D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM &n= bsp; =20 . Date/Time: 04/18/00 18:42:41 Browser: = Mozilla/4.72 [en]=20 (Win98; I) Remote Address: 195.38.97.174 HTTP=20 Referer:http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDa= te=3D10/22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A69= KA1AC-GX&uSIO=3DWinbond">http://register.unicore.com:8081/leads/bios_= upgrade_form.cfm?uBDate=3D10/22/98&uBType=3DAward&uBID=3D10/22/19= 98-i440BX-W83977-2A69KA1AC-GX&uSIO=3DWinbond 977TF=20 rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev=20 3&uOEM=3DGREENAGP/PCI/ISA SYSTEM Template:=20 D:\WebSite\register\htdocs\leads\submit_biosform.cfm Ben = DensmoreWebmastereSupport.com,=20 IncTouchStone Software Corp. --=_NextPart_000_0059_01BFA9E6.FE00C9E0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
