I receive the same error with that, "missing comma". However, I have just had
an epiphany and this worked:
#createODBCDateTime(registered.date_added)#
I didn't realize it needed to be an ODBC Date, nor do I really know what an
ODBC date is.
~~~
Daniel,
Try this:
to_date(, "mm/dd/ HH24:MI:SS") to do the insert. This will cause
Oracle to interpret the date correctly.
-Drew Nathanson
> I have a date/time that I made using SYSDATE and inserted into an
> oracle table. It looks like "2010-09-30 13:34:17.0". I have queried
> for th
I have a date/time that I made using SYSDATE and inserted into an oracle table.
It looks like "2010-09-30 13:34:17.0". I have queried for that date to insert
into another table, but when I go to insert it, I receive a "missing comma"
error. I assume that it has to do with the date because wh
AH I exported the table and re-imported it and the identity switch got
changed to "No".
Now it works.
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Saturday, November 01, 2008 11:50 AM
> To: cf-talk
> Subject: RE: insert error
Follow up... updates works, selects work. I dont know why the insert is
failing.
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Saturday, November 01, 2008 11:42 AM
> To: cf-talk
> Subject: insert error
>
> What is up with this?
>
What is up with this?
How can an insert fail with this error?
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into
column 'PageID', table 'SocialCards4You.dbo.Pages'; column does not allow
nulls. INSERT fails.
PageID is an autoincrementing column in my MS SQL databas
One last thing, I have a bad habit of not using cfqueryparam, and I don't
want to pass that on to you. Here's how you *should* do it:
On Feb 12, 2008 3:57 PM, Ben Conner <[EMAIL PROTECTED]> wrote:
> Interesting. That did it! One more subtle difference between Access
> and SQL Server. Thanks
de:
>>>
>>>njuice', '', 1903, 189, 123.45, , , 'clamprack
>>>
>>>
>>>See the three commas in a row? There should be something there... An
>>>
>>>
>>empty
>>
>>
>>>string.. .a zero... The wor
;the same for ShipBase.
>
>Other than that, it looks okay to me.
>
>
>-Original Message-
>From: Ben Conner [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, February 12, 2008 1:35 PM
>To: CF-Talk
>Subject: DB Insert error in SQL Server
>
>Hi,
>
>I ported an
ero... The word "null" Something..
> >
> >-Original Message-
> >From: Ben Conner [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, February 12, 2008 12:35 PM
> >To: CF-Talk
> >Subject: DB Insert error in SQL Server
> >
> >Hi,
> >
>
>-Original Message-
>From: Ben Conner [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, February 12, 2008 1:35 PM
>To: CF-Talk
>Subject: DB Insert error in SQL Server
>
>Hi,
>
>I ported an application from Access to MS SQL Server and am getting an
>error wh
re... An empty
>string.. .a zero... The word "null" Something..
>
>-Original Message-
>From: Ben Conner [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, February 12, 2008 12:35 PM
>To: CF-Talk
>Subject: DB Insert error in SQL Server
>
>Hi,
>
>I p
To: CF-Talk
Subject: DB Insert error in SQL Server
Hi,
I ported an application from Access to MS SQL Server and am getting an
error when inserting a test record into a table:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 21: Incorrect syntax
near ',
be something there... An empty
string.. .a zero... The word "null" Something..
-Original Message-
From: Ben Conner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 12, 2008 12:35 PM
To: CF-Talk
Subject: DB Insert error in SQL Server
Hi,
I ported an application from Access
Hi,
I ported an application from Access to MS SQL Server and am getting an
error when inserting a test record into a table:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 21: Incorrect syntax
near ','.
The error occurred in
D:\sites\adrenalinebikes.com\htdocs\
>'Invalid data for CFSQLTYPE CF_SQL_NUMERIC'
>
>That would suggest that the value you're passing in is not numeric, or the
>column name is an Integer, in which case you might need to use
>CF_SQL_INTEGER, I've not used ORACLE so can't be sure about that, first
None of the columns in the table struc
d do is dump the variable you're passing in from CF and check
its value.
Rob
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: 05 June 2007 12:38
To: CF-Talk
Subject: sql insert error
Lost.
I'm doing a loop to insert values into a db (Oracle). I keep g
Daniel Kessler wrote:
>
> I'm doing a loop to insert values into a db (Oracle). I keep getting
> an error 'Invalid data for CFSQLTYPE CF_SQL_NUMERIC.' This is just
> one example, but I don't see the problem.
> One other thing though, in my cftry/error output, it says it's on
> field 'pa_in
Lost.
I'm doing a loop to insert values into a db (Oracle). I keep getting
an error 'Invalid data for CFSQLTYPE CF_SQL_NUMERIC.' This is just
one example, but I don't see the problem.
One other thing though, in my cftry/error output, it says it's on
field 'pa_int_other_text, and it seems t
On Friday 25 May 2007, [EMAIL PROTECTED] wrote:
> Thing is, I was just trying to do a one-time move of data from a text file
> to a database and then was going to not use the code again. They never
CFQueryParam would have speed it up, at the very least, even in one-time jobs.
--
Tom Chiverton
H
>> Oh man, how simple.
>Do I need to say that cfqueryparam takes care of that for you ?
Sure, point out that it would've been easy for me to do that ;-)
Thing is, I was just trying to do a one-time move of data from a text file to a
database and then was going to not use the code again. Th
>Use to_date(#datevar#,'DD-MON-) replaceing
>#datvar# wtht he variable creating that time stamp.
I originally had it that way, mainly cause to_date was something that I learned
recently and I wanted to use my new trick and solidify it in my head - it also
would've have been much simpler. I
On Thursday 24 May 2007, daniel kessler wrote:
> Oh man, how simple.
Do I need to say that cfqueryparam takes care of that for you ?
--
Tom Chiverton
Helping to completely negotiate sticky platforms
on: http://thefalken.livejournal.com
Thi
rsday, May 24, 2007 1:20 PM
To: CF-Talk
Subject: Re: insert error
> Well, that did work and it worked through a few entries, so I suspect
> that it's reasonably sound now.
>
> BUT, it's breaks down on third entry with a "missing comma" entry
> again. Back to deb
: Thursday, May 24, 2007 9:41 AM
To: CF-Talk
Subject: insert error
I've been at this for awhile and I just don't see the error. The
error is:
ORA-00936: missing expression which leads me to believe I have the
wrong number of values, but in checking and rechecking and
rechecking, I don
t;From: daniel kessler [mailto:[EMAIL PROTECTED]
>Sent: Thursday, May 24, 2007 2:20 PM
>To: CF-Talk
>Subject: Re: insert error
>
>> Well, that did work and it worked through a few entries, so I suspect
>> that it's reasonably sound now.
>>
>> BUT, it'
Your text values in the query need to have single quote around them.
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 2:20 PM
To: CF-Talk
Subject: Re: insert error
> Well, that did work and it worked through a few entries, so I susp
Daniel Kessler wrote:
>> Get the output of one iteration of the insert statement by
>> outputting the
>> end result of the SQL. Take the SQL statement and execute it directly
>> against your DB. If the insert works fine, it may be how you handle
>> different data types.
>
> I can't output the
> Well, that did work and it worked through a few entries, so I suspect
> that it's reasonably sound now.
>
> BUT, it's breaks down on third entry with a "missing comma" entry
> again. Back to debugging...
OK, I have Teddy's suggestion going and the one that's giving the missing comma
problem
ah, thank you very much
>Something like this:
>
>
>SELECT ...
>FROM ...
>WHERE ...
>GROUP BY ...
>ORDER BY ...
>
>
>
>#theSQL#
>
>
>Add s as required.
>
>
>Confidentiality Notice: This message including any
>attachments is for the sole use of the intended
>recipient(s) and may contain confidentia
Something like this:
SELECT ...
FROM ...
WHERE ...
GROUP BY ...
ORDER BY ...
#theSQL#
Add s as required.
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorize
ring.
>
>- Original Message -
>From: "Daniel Kessler" <[EMAIL PROTECTED]>
>To: "CF-Talk"
>Sent: Thursday, May 24, 2007 12:57 PM
>Subject: insert error
>
>>
~|
Upgrade to
Well, that did work and it worked through a few entries, so I suspect that it's
reasonably sound now.
BUT, it's breaks down on third entry with a "missing comma" entry again. Back
to debugging...
oh the entry looks like (nothing special):
1/7/2005|21:25:05|[EMAIL
PROTECTED]|Nicki|Burch|1|1|1|
analyze it for validity. You can test it manually just by executing it
between another cfquery tag block once you are done analyzing the string.
- Original Message -
From: "Daniel Kessler" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, May 24, 2007 12:57 PM
Sub
>Daniel Kessler wrote:
>> ORA-00936: missing expression
>
>>
>>
>>
>>
>>
>
>So here you are inserting spaces for your empty list elements.
That does appear to be the problem. I figured entering empty would be fine and
would leave it empty. It's one-time-use code so I didn't do any extra wo
> Get the output of one iteration of the insert statement by
> outputting the
> end result of the SQL. Take the SQL statement and execute it directly
> against your DB. If the insert works fine, it may be how you handle
> different data types.
I can't output the end-result. I put in debug=yes
Daniel Kessler wrote:
> ORA-00936: missing expression
>
>
>
>
>
So here you are inserting spaces for your empty list elements.
>
>INSERT INTO fsnep_ha_budgeting
> (
> budgeting_id,
>
AIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, May 24, 2007 10:40 AM
Subject: insert error
> I've been at this for awhile and I just don't see the error. The
> error is:
> ORA-00936: missing expression which leads me to believe I have the
> wrong number of values,
> On Thursday 24 May 2007, Daniel Kessler wrote:
>> ORA-00936: missing expression which leads me to believe I have the
>> wrong number of values, but in checking and rechecking and
>> rechecking, I don't see the problem. I even gave up on the loop and
>> wrote it all out.
Not necessarily the wr
On Thursday 24 May 2007, Daniel Kessler wrote:
> ORA-00936: missing expression which leads me to believe I have the
> wrong number of values, but in checking and rechecking and
> rechecking, I don't see the problem. I even gave up on the loop and
> wrote it all out.
Turn debugging on and see wh
It's probably your tmp_line list. If a list has empty items, CF drops it
completely, so this list:
1||2|3|4||5 only has 5 items as far as CF is concerned - you may realize
this, since you seem to be adding spaces with the replace() function, but
I'm fairly sure a space isn't sufficient to keep CF
I've been at this for awhile and I just don't see the error. The
error is:
ORA-00936: missing expression which leads me to believe I have the
wrong number of values, but in checking and rechecking and
rechecking, I don't see the problem. I even gave up on the loop and
wrote it all out
ation."
From: "Aaron DC" <[EMAIL PROTECTED]>
Sent: Friday, June 17, 2005 3:56 AM
To: CF-Talk
Subject: Re: insert error
Yes, 94 is an integer. Did you try viewing the source of the webpage to make
sure it isnt " 94" or "94 " or ot
;
Sent: Friday, June 17, 2005 5:08 PM
Subject: insert error
> Invalid data 94 for CFSQLTYPE CF_SQL_INTEGER.isnt 94 an integer?
>
> ~Dave the disruptor~
> "A criminal is a person with predatory instincts who has not sufficient
capital to form a corporation."
>
>
>
>
Invalid data 94 for CFSQLTYPE CF_SQL_INTEGER.isnt 94 an integer?
~Dave the disruptor~
"A criminal is a person with predatory instincts who has not sufficient capital
to form a corporation."
~|
Logware (www.logware.us): a new
> Now you've suggested it though, I've given the suggestion
> some thought and I don't see where it can be better in all
> cases. Especially when you consider that using a
> cftransaction can potentially lock the entire table when this
> may not be necessary.
>
> Achieving the correct level o
> Out of curiosity, why do you recommend using CFLOCK instead of
> CFTRANSACTION? The CFLOCK tag only affects CF code, and any decent
database
> provides transactional support. Using the database's own transactional
> support seems superior in several respects, to me.
To be totally honest, it ne
> One thing I would say about the use of MAX(ID) is that if you
> are going to use it, you need to lock access down to it using
> cflock to avoid the situation described above
>
> Place this around the entire section of code from just
> before the select query until just after the insert
> It is very
> possible to return the same ID to two different "users" if they make a
> request at the "same" time. Personally I avoid this method of finding a
> unique id.
One thing I would say about the use of MAX(ID) is that if you are going to
use it, you need to lock access down to it using c
AIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]>
net.com> cc:
Subject: Re: SQL INSE
I got it to work. I use CFSQLTYPE="CF_SQL_LONGVARCHAR"
Thanks for help.
Do you know what could be causeing the other problems?
> No I was not, I was using ParagraphFormat. I tride the cfqueryparam
> but that cut the text down to a few lines. I tride useing MaxLength
> attribute but nothing h
No I was not, I was using ParagraphFormat. I tride the cfqueryparam but that cut the text down to a few lines. I tride useing MaxLength attribute but nothing happen. This is my script:
NAME="NewID"
datasource="VFP"
dbtype="ODBC">
SELECT max(id) as LastID from News
INSERT INTO News(id,ctopi
com> cc:
Subject: SQL INSERT error on large amount of text
04/07/2004
I am getting a problem in inserting data into a table. I have a form, which is made up of INPUT and TEXTAREA fields. When trying to insert into a memo field from a textarea through I get an error [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro Driver]Command contains
16, 2003 7:20 PM
To: CF-Talk
Subject: Re: CDATA dup insert error Again
By the way... Deb, if you're reading this... I asked the second client today
if their CFMX installation was an upgrade from CF5 and they told me it was.
So perhaps the issue has something to do with CF5 to CFMX upgrades?
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 1:54 PM
Subject: Re: CDATA dup insert error Again
> [EMAIL PROTECTED] wrote:
> > I have personally witnessed two i
[EMAIL PROTECTED] wrote:
> I have personally witnessed two instances where clients of mine were running
> CFMX and their CDATA/CGLOBAL tables were not being purged.
Have you tried manual purging with a scheduled task?
http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=11
Jochem
~~~
?
-Novak
- Original Message -
From: "Debbie Dickerson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 12:51 PM
Subject: RE: CDATA dup insert error Again
> I'm not aware of an issue with client variable purging in M
Sent: Thursday, January 16, 2003 3:32 PM
To: CF-Talk
Subject: Re: CDATA dup insert error Again
Is there a hotfix for CFMX as well?
-Novak
- Original Message -
From: "Debbie Dickerson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday,
Is there a hotfix for CFMX as well?
-Novak
- Original Message -
From: "Debbie Dickerson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 11:06 AM
Subject: RE: CDATA dup insert error Again
> The issue with clien
Cantrell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, January 16, 2003 9:16 AM
> Subject: Re: CDATA dup insert error Again
>
>
>> On Thursday, January 16, 2003, at 10:33 AM, WebMaster wrote:
>>
>>> Do they e
PROTECTED]]
Sent: Thursday, January 16, 2003 1:57 PM
To: CF-Talk
Subject: Re: CDATA dup insert error Again
Christian,
Thanks for posting a response. I'm sure it would be a lot easier to not
comment and hopefully let it all blow over unnoticed. There are many of us
on the list that do appre
some disk space) ;-)
-Novak
- Original Message -
From: "Christian Cantrell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 9:16 AM
Subject: Re: CDATA dup insert error Again
> On Thursday, January 16, 2003, at 10:33 AM,
ginal Message -
From: "WebMaster" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 7:19 AM
Subject: Re: CDATA dup insert error Again
> Yeah, I thought of that, unfortunately, I can't rely on cookies. Life
would
>
ry 16, 2003 12:16 PM
Subject: Re: CDATA dup insert error Again
> On Thursday, January 16, 2003, at 10:33 AM, WebMaster wrote:
>
> > Do they even listen to this list???
>
> Several people from Macromedia follow this list very closely. When I
> read your post, I contacted people in
On Thursday, January 16, 2003, at 10:33 AM, WebMaster wrote:
> Do they even listen to this list???
Several people from Macromedia follow this list very closely. When I
read your post, I contacted people in tech support to see if the bug
still exists in CFMX (since it has been around since 4.5,
essage -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 9:53 AM
Subject: Re: CDATA dup insert error Again
> I know this doesn't solve your problem... but... you can always "roll your
> own". Heck, all
January 16, 2003 9:56 AM
Subject: Re: CDATA dup insert error Again
> >Have you double checked your own cookies to make sure that the
CFID/CFTOKEN
> >you're getting is indeed a UUID? I don't think the issue is that you're
> >the
> >only one getting the erro
essage -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 9:53 AM
Subject: Re: CDATA dup insert error Again
> I know this doesn't solve your problem... but... you can always "roll your
> own". Heck, all
>Have you double checked your own cookies to make sure that the CFID/CFTOKEN
>you're getting is indeed a UUID? I don't think the issue is that you're
>the
>only one getting the error. I've seen several people who get the same
>thing. It's just that most either 1) Don't know what it is and there
lly have never relied on client variables for much more than
session stuff. I purge my CDATA and CGLOBAL tables every night and never
have any problems.
-Novak
- Original Message -
From: "Webmaster" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent:
PROTECTED]>
Sent: Wednesday, January 15, 2003 8:22 PM
Subject: CDATA dup insert error Again
> Hi,
> I am still getting this error. The last time I asked the list we went
> around in circles about locking and purging the client var data store.
> Well, the purge is working fine. I
I just read a long thread on this and MM has it as a bug, but it seems they
are not going to fix it. What a rip...
- Original Message -
From: "Webmaster" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:22 PM
Hi,
I am still getting this error. The last time I asked the list we went
around in circles about locking and purging the client var data store.
Well, the purge is working fine. I have it set to one week and there are
only a weeks worth of entries in the db. I don't understand how this can
hap
Are you using CFINSERT? you may want to try to switch to a normal query.
At 02:55 PM 08/24/2001 +0800, you wrote:
>hi
>i juz upgraded my server to CF5.0. When we try to do a insert, we
>realised that CF will automatically append a lot of garbage together with
>the values. Why is this so ?
INSERT ERROR (URGENT)
Are you talking about db inserts? what db?
I use access & sql server with no problems.
would help to see some code!
Dick
At 2:55 PM +0800 8/24/01, JAIME HOI wrote:
>hi
>i juz upgraded my server to CF5.0. When we try to do a insert, we
>realised that CF will
Are you talking about db inserts? what db?
I use access & sql server with no problems.
would help to see some code!
Dick
At 2:55 PM +0800 8/24/01, JAIME HOI wrote:
>hi
>i juz upgraded my server to CF5.0. When we try to do a insert, we
>realised that CF will automatically append a lot of g
hi
i juz upgraded my server to CF5.0. When we try to do a insert, we
realised that CF will automatically append a lot of garbage together with
the values. Why is this so ?? and what can we do to resolve this?
~~
Structure your ColdFusion code
hi,
i tried to insert a new record into DB2 database and it show me this error :
DB2 Error Code = -7008
[IBM][CLI Driver][AS] SQL7008N REXX variable "EHTEMP " contains inconsistent
data. SQLSTATE=55019
never see this before, anyone have any idea what wents wrong?
~~~
> I'm trying to insert a date into an Oracle table and get the following
> error. Help!!
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
> SQL = "INSERT INTO emirf (FIRST_NAME, REQUE
You are missing a parenthesis after the completion of TO_Date section.
dave
At 11:30 AM 4/26/2001 -0700, you wrote:
>I'm trying to insert a date into an Oracle table and get the following
>error. Help!!
>
> Error Diagnostic Information
>ODBC Error Code = 37000 (Syntax error or access violatio
You're missing a ')'.
- Original Message -
From: "Greenberg, Lisa" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 1:30 PM
Subject: ORACLE DATE INSERT ERROR.. Help.
> I'm trying to insert a
the closing parenthesis on the to_date() function
-Original Message-
From: Greenberg, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 1:31 PM
To: CF-Talk
Subject: ORACLE DATE INSERT ERROR.. Help.
I'm trying to insert a date into an Oracle table and get the following
e
I'm trying to insert a date into an Oracle table and get the following
error. Help!!
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = "INSERT INTO emirf (FIRST_NAME, REQUEST_DATE,
> Hi, does anyone know what might cause this to occur when using CFINSERT?
>
> Error Occurred While Processing Request
>
> Error Diagnostic Information
> ODBC Error Code = 22001 (String data right truncation)
>
> [Microsoft][ODBC SQL Server Driver]String data, right truncation
> The error occurred
Pardeep,
>
> Hi, does anyone know what might cause this to occur when using CFINSERT?
>
> Error Occurred While Processing Request
>
> Error Diagnostic Information
> ODBC Error Code = 22001 (String data right truncation)
>
> [Microsoft][ODBC SQL Server Driver]String data, right truncation
> The er
Your variable is bigger than the column in the database, eg. variable is 50
chars, column is 10 chars
HTH
Bjorn Jensen
-Original Message-
From: Pardeep Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 3:11 PM
To: CF-Talk
Subject: Re: Insert error (String data right
A field that's too short?
Michel Vuijlsteke
-Original Message-
From: Pardeep Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 3:11 PM
To: CF-Talk
Subject: Re: Insert error (String data right truncation)
Hi, does anyone know what might cause this to occur when
Hi, does anyone know what might cause this to occur when using CFINSERT?
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)
[Microsoft][ODBC SQL Server Driver]String data, right truncation
The error occurred while processi
89 matches
Mail list logo