Also in the CF Application log the error is shown as "Arithmetic overflow error converting numeric to data type numeric."
> -----Original Message----- > From: Derek Westfall [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 23, 2002 1:41 PM > To: Spectra-Talk > Subject: Updating 1.01 datastore -- so close! > > > I'm having a problem with the > /151/q_alterpropertiesnumericfielddefinition.cfm: > > Insert into temp_properties select ... from properties where > numericdata is > not null > > Returns a Numeric Value out of Range error. > > I ran the same query in Access and the data looked fine to me. > The largest # > was 1,964,000,000. Is that too large? > > Any ideas why it might be choking? > > This is on Win2K, CF5, Spectra 1.51 with the latest Spectrasource update, > datastore is on MSSQL7. > > Derek > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
