yeah, its auto# pulled straight from db, i gave up and changed it to a varchar and it worked fine. was strange that try/catch werent getting it either.
~Dave the disruptor~ "A criminal is a person with predatory instincts who has not sufficient capital to form a corporation." ---------------------------------------- From: "Aaron DC" <[EMAIL PROTECTED]> Sent: Friday, June 17, 2005 3:56 AM To: CF-Talk <[email protected]> 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 other combinations of similar (invisible) things? HTH Aaron ----- Original Message ----- From: "dave" To: "CF-Talk" 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." > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209776 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
