Yes, I've seen it. I tried entering a number that was over 10 digits into a normal
LONG INTEGER field. I believe I resolved the problem by changing the datatype for
that field to DOUBLE.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Olson, Kelly [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 10:10 AM
> To: [EMAIL PROTECTED]
> Subject: OT: ODBC Strange Problem
>
>
> Help Anyone!!
>
> Anyone seen this, that can give me a little info. This is comming out
> of a 2 field table AccountID and AccountDescription. It works great up
> to 5 records and on the 6 record or above it generates the error above.
>
> It is basically a list of choices that are selected and a record inputed
> into a second table. Nothing special and it works great as long as I
> only have 5 records in the selecting table. There is no validation. I
> have tried deleting the table and recreating it with the same problem.
>
>
>
>
>
> Error Diagnostic Information
>
> ODBC Error Code = 22003 (Numeric value out of range)
>
> [Microsoft][ODBC Microsoft Access 97 Driver]Numeric value out of range
>
> The error occurred while processing an element with a general
> identifier of (CFINSERT), occupying document position (3:2) to (3:61).
>
> Date/Time: 07/06/00 13:19:51
> Browser: Mozilla/4.73 [en] (Windows NT 5.0; U)
> Remote Address: 63.238.222.92
> HTTP Referer:
> http://www.mfglinks.org/scenarios/scenario/create_scenario5.cfm
> Template:
> D:\webclients\mfglinks.org\scenarios\scenario\create_scenario5.cfm
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.