db doesn't accept decimal numbers

skydiver_jim · skydiver_jim

I have an access databse, the connection is fine. I have a series of elements
in my insert statement that I generate: last name, first name, address, etc.
and all that goes into the database ok. but I have two fields: latitude and
longitude that bombs out the insert statement, and I can't figure out why.
I've tried altering acess in design mode with decimal, number, integer, long
integer, nothing works! Can anyone shed some light on this? Thanks.

This is the processing page:
<cflock scope="Session" type="ReadOnly" timeout="30" throwontimeout="no">
<cfset
MM_Username=Iif(IsDefined("Session.MM_Username")," Session.MM_Username",DE(""))>
<cfset
MM_UserAuthorization=Iif(IsDefined("Session.MM_Use rAuthorization"),"Session.MM_U
serAuthorization",DE(""))>
</cflock>
<cfif MM_Username EQ "" OR MM_UserAuthorization EQ "" OR
ListFind("Administrator",MM_UserAuthorization) EQ 0>
<cfset MM_referer=CGI.SCRIPT_NAME>
<cfif CGI.QUERY_STRING NEQ "">
<cfset MM_referer=MM_referer & "?" & CGI.QUERY_STRING>
</cfif>
<cfset MM_failureURL="myErrorFile.cfm?accessdenied=" &
URLEncodedFormat(MM_referer)>
<cflocation url="#MM_failureURL#" addtoken="no">
</cfif>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFINSERT DATASOURCE="fco_red_cross" dbtype="ODBC" TABLENAME="fco_contact">
<link href="css/Chesapeake.css" rel="stylesheet" type="text/css">
<body bgcolor="#66CCFF">
<h2>Thanks! your data has been inserted. </h2>

 <CFOUTPUT> The data you entered was: 

CHERS ID: #Form.CHERS_ID# 
First Name: #Form.F_Name# 
Last Name: #Form.L_Name# 
Address: #Form.Addr# 
City: #Form.City# 
State: #Form.State# 
Zip: #Form.Postal_Code# 
Home Telephone: #Form.Home_phone# 
Work Telephone: #Form.Work_phone# 
Cell Telephone: #Form.Cell_phone# 
ARC Phone: #Form.ARC_phone# 
Direct Connect: #Form.Direct_connect# 
Primary Email: #Form.Pri_Email# 
Secondary Email: #Form.Sec_Email# 
DAT Status: #Form.DAT_Status# 
Function: #Form.Funct# 
Coverage:#Form.Cover# 
Notes:#Form.Notes# 
Latitude:#Form.Lat# 
Longitude:#Form.Long#

mxstu · mxstu

Originally posted by: skydiver_jim
I have two fields: latitude and longitude that bombs out the insert
statement, and I can't figure out why.

It is probably that you are using "Long" as a field name. "Long" is a type of
number and is reserved word. Change the column name to something else like
"Longitude" and the insert should work fine.

For future reference, posting the complete error message (including the sql
statement) makes it easier for people to help you diagnose the problem :-)

skydiver_jim · skydiver_jim

Duh, do I feel stupid. Thanks! I appreciate you helping out. And I'll post more info the next time.

Cheers,

Jim

db doesn't accept decimal numbers

Thread Tools

Display

db doesn't accept decimal numbers

Similar Questions and Discussions

#26314 [Opn->Bgs]: Decimal numbers starting with 0 always treated as octals, even when invalid

#26314 [Bgs->Opn]: Decimal numbers starting with 0 always treated as octals, even when invalid

#26314 [Opn->Bgs]: Decimal numbers starting with 0 wrongly treated as octals, even when invalid

#26314 [NEW]: Decimal numbers starting with 0 wrongly treated as octals, even when invalid

Changes won't accept.

Re: db doesn't accept decimal numbers

Re: db doesn't accept decimal numbers

Posting Permissions