Just a quick question, I'm hoping someone can help. I've got everything working in my forms but I'm stuck at the insert for MySql. I have a couple of related tables, so I pull the appropriate information to fill out the form drop down selection & create a session handler. I then pass it on to a second form for confirmation before adding the new record to the DB. After the "Add" button is clicked its get passed into the script to add the information. My insert query is working ok, because information stored as text is written fine. However, other fields which contain numbers (like the average cost) are stored as zeros. My average cost field in the record table is set as a Decimal, 4,2 to accomodate a number rather than a string. I suspect that when I fill out the forms the variables are assigned as strings instead of numbers which is why I'm having a problem. Is there a way to convert strings to the numeric value or how can I get around this?
