Hi Nigel,
> >
$key,$sessionData->{'UnixTimestamp'},$sessionData->{'UnixTimestamp'},$whitelist
> I'm at a loss here, I cannot see how that query can fail, especially
> with a syntax-like error.
After playing with it a bit today I believe the problem is you should be
using $sessionData->{'Timestamp'} instead of
$sessionData->{'UnixTimestamp'} otherwise you are getting uninitialised
values in the SQL and hence it bombs...
BUT I still cannot get the format you are using to work. Instead I
tried this and it seems to work
$sth = DBDo("
INSERT INTO greylisting_autowhitelist
(TrackKey,Added,LastSeen,Comment)
VALUES
(".DBQuote($key).",".$sessionData->{'Timestamp'}.",".$sessionData->{'Timestamp'}.",".DBQuote($whitelist).")
");
--
Regards,
Peter Kiem
Zordah IT - IT Consultancy and Internet Services
Ph: (0414) 724-766 Fax: (07) 3112-4237
Web: www.zordah.net Email: [email protected]
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
