I use the following sql
INSERT INTO malware (file, location, md5, size, sig, sig_name, cnt,
clam_result, date_found, date_removed, ref) VALUES
('Setup.exe-IRAD0n', '/Users/tshaw/malware/Setup.exe-IRAD0n',
'1186b3a97de73f924dcfb12cba0bb1bf', 15360, '', '', 1,
'/Users/tshaw/virus_archive/Setup.exe-IRAD0n: Worm.Koobface-20 FOUND
', 1243947206, 1243947206, NULL);
and get the following error
Error!: SQLSTATE[HY000]: General error: 1 near ",": syntax error code:HY000
This occur whenever I try to do a second insert with a unique
variable which is fine but why the error message above and not a
message about duplicate uniques?
TIA,
Tom
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
