I don't get it anymore.
The one moment my queries are working fine, a second later, after making some small changes to the query itself, I get the error below.
Any idea what this "Column count doens't match..." means?
My logging
2004/04/21 12:03:07 - OPen - Connection Verified
2004/04/21 12:03:07 - 10. rsRecordset - Error: -2147352567 - COM exception error "Execute" (Microsoft OLE DB Provider
for ODBC Drivers - [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt]Column count doesn't match value count at row 1) [-2147352567/80020009]
2004/04/21 12:03:07 - Close - The operation completed successfully.
My query:
Code:
$retcode = DBExecuteSQL($objConn,"INSERT INTO software (Sid, Workstation, Application, Version, Publisher, Path, DateTime)
VALUES('', '@wksta', '', '', '', '', '$DateTime')")
Also tried:
Code:
$retcode = DBExecuteSQL($objConn,"INSERT INTO software (Sid, Workstation, DateTime) VALUES('', '@wksta', '$DateTime')")
