CFinsert misbehaves

[H3ath0r]

Any ideas why a CFinsert tag would work on my partner's desktop and not on my
laptop? Both are using CF 6.0 and MS Access database. All the files are
identical.

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
Driver]Numeric value out of range (null)

The Error Occurred in C:\CFusionMX\wwwroot\SRpublisher\zeus\adddo.cfm: line 26

24 :
25 : <cfif #duplicates.RecordCount# IS "0">
26 : <cfinsert datasource="sider" tablename="article">
27 : </cfif>
28 :

[zoeski80]

From the error it sounds like a number is trying to be added that is too big
for the field. You get that error if you try and add something like 9 999 999
999 to an integer field. Are you both adding the same data into the table?

Also, have you compared the default values and the data types for that table
in the database?

Zoe

[H3ath0r]

Found it! There was a numeric field where a 'byte' setting SHOULD have been
good enough (the value was only 147). Setting it to 'integer' solved the
problem. I had to add the FORMFIELDS attribute to the CFinsert tag and go
through the fields one by one to determine which one was fouling it up. Ugh.