[BEGINNER] Using DBLib and MySQL

[Shawn Blc]

I'm using DBLib and I'm having trouble inserting into a MySQL database.  My
database connection is working.

My database name:  names
Table name:  names

My table fields are:

fldID
fldFullName
fldEmailAddress
fldRegistered

My controls on my form are:

fldFullName
fldEmailAddress
fldRegistered

My button code looks like this (for submitting to the database):

on mouseUp
   put "http://mydomain.on-rev.com/nope.png" into field "fldRegistered"

   put field "fldRegistered" into tDataA["fldRegistered"]
   put field "fldFullName" into tDataA["fldFullName"]
   put field "fldEmailAddress" into tDataA["fldEmailAddress"]

   put dbInsert["names", tDataA] into tResult
   if it is a number then
      answer it && "Database Updated"
   else
      answer error it
   end if
end mouseUp


What am I doing wrong?




Regards,

Shawn