[plug] SQL Statement Error

[Jason Belcher]

J Michael Gilks wrote:

>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.
>
I don't know much about VB, but in PHP you can do stuff like:
$qry="...";
echo $qry;

Can you do something similar in VB so we can see some values in there 
(so we can see what the server's seeing) rather than variable names?



-- 
Gates' Law: Every 18 months, the speed of software halves.