penguinspeaks
Technical User
I may be tired but I am pulling my hair out at this one.
Here is the error
here is my BASIC code that I feel as if I have written a million times
Now the first_, second_, third_, fourth_, fields are Decimal 4,2 because this is to reflect money
the player_ is INT as it will always be a whole number
the date_ is a date field
here is the response.write (strSQL)
I know this is simple stuff, but what am I missing here?
Here is the error
Code:
icrosoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.6.16]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(date_, first_, second_, third_, fourth_, players_) values (2014-9-13,40,25,13,0' at line 1
/payoutsasp.asp, line 15
here is my BASIC code that I feel as if I have written a million times
Code:
strSQL = "insert into payouts set (date_, first_, second_, third_, fourth_, players_)"
strSQL = strSQL & " values "
strSQL = strSQL & "("&var6&","&var1&","&var2&","&var3&","&var4&","&var5&")"
conn.execute (strSQL)
'response.write (strsQL)
Now the first_, second_, third_, fourth_, fields are Decimal 4,2 because this is to reflect money
the player_ is INT as it will always be a whole number
the date_ is a date field
here is the response.write (strSQL)
Code:
insert into payouts set (date_, first_, second_, third_, fourth_, players_) values (2014-9-13,40,25,13,0,16)
I know this is simple stuff, but what am I missing here?