Problem inserting latitude longitude data
Hello,
I've started a new thread because once again this seems to be an unrelated problem. I've finally got the forms figured out with the exception of problems inserting data into 3 fields, they are one for latitude, one for longitude and one that is a decimal and I can't get them to insert correctly no matter what I try.
I've got to get my business going which means going live by March 1st so I really need your help. I would like to do this by hand coding if at all possible since this page has a ton of checkbox fields that have to be renamed so it takes a long time to rebuild this page after CSS FB renames the fields, I've already rebuilt it a number of times. By the way, just a second comment, I'm putting the form into a CSS content wrapper that is within a page wrapper and if I reedit anything in the CSS FB it eliminates the form wrapper and covers up the rest of the page content when it rebuilds the form so if I make any changes to the form I have to completely start over.
The Google maps documentation recommends the columns to be "float 10,6" so that's what I started with. The form field was set to "numeric" originally. I've now even tried the columns as VARCHAR and the field type set to "text" and even that doesn't work if you try to input the decimal point or a minus sign, the complete form insert fails. If you take out the decimal and minus sign then the form will insert the data but of course that's not an option. I've also tried "integer" and "text" column settings and nothing has worked.
I've attached the code and would greatly appreciate your help.
Thanks,