[plug] SQL Statement Error

[J Michael Gilks]

Found the problem. My mate was helping out and put a few test values in the
changed table. Of course these had no valid foreign key variables, but the
only message I got was an error in the SQL statement. Mates, got to love em.
Anyway thanks for your time
Love
Mike.

-----Original Message-----
From: J Michael Gilks [mailto:gilksjm at iinet.net.au]
Sent: Thursday, 13 September 2001 12:05 AM
To: plug at plug.linux.org.au
Subject: RE: [plug] SQL Statement Error


Thanks, not as easy as PHP but Debug.print works if you can find the window.
Output was
INSERT INTO Calculations(date_id, state_id, sub_class_id, quartile1,
quartile2, quartile3, ncount, nmax, nmin, nave)
 VALUES(1, 3, 108, 254, 0, 0, 1, 254, 254, 254)
Looks good to me. I may have to look inside the tables. Yuk.
Thanks again
Love
Mike.

-----Original Message-----
From: Jason Belcher [mailto:jason at whatever.iinet.net.au]
Sent: Wednesday, 12 September 2001 11:07 PM
To: plug at plug.linux.org.au
Subject: Re: [plug] SQL Statement Error


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.