[plug] SQL Statement Error
J Michael Gilks
gilksjm at iinet.net.au
Wed Sep 12 23:06:19 WST 2001
Can someone please tell me if they see something wrong with this statement.
I have been looking for hours and I know it will be something simple. All
recordset variables are correct and variables Q1, Q2, Q3 have values
"INSERT INTO Calculations(date_id, state_id, sub_class_id, quartile1,
quartile2, quartile3, " & _
"ncount, nmax, nmin, nave )" & _
"VALUES(" & rstSel.Fields("cDate") & ", " & rstSel.Fields("cState") &
_
", " & rstSel.Fields("cClass") & ", " & Q1 & ", " & Q2 & ", " & Q3 & _
", " & rstCount.Fields("iCount") & ", " & rstCount.Fields("iMax") & _
", " & rstCount.Fields("iMin") & ", " & rstCount.Fields("iAve") & ")"
It is being used in Visual Basic, no choice of mine (PHP rules OK).
Thanks for any help.
Love
Mike.
More information about the plug
mailing list