[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