sql logging problem

[Martin Hepworth]

Hmm the plot thickens....

If use the values as qiven, there are 'empty' or null values being put
in the string. When I use this syntax on a manual insert mysql complains
about syntax error. However if I fill in these values to be the default
then it's fine and the insert happens...
eg

  insert into maillog values ( '2003-07-24 14:40:57', 'h6ODerXL062460',
1066, 'martinh at soloman.solid-state-logic.com',
'martinh at solid-state-logic.com', 'test9', '127.0.0.1', , 0, 0, , , 0, 0,
, 0, 0, 0, , 'soloman.solid-state-logic.com');

doesn't work..

insert into maillog values ( '2003-07-24 14:40:57', 'h6ODerXL062460',
1066, 'martinh at soloman.solid-state-logic.com',
'martinh at solid-state-logic.com', 'test9', '127.0.0.1',0 , 0, 0,0 ,0 , 0,
0,0 , 0, 0, 0,0 , 'soloman.solid-state-logic.com');


does work..


mysql is version 4.0.13

time to hit the manuals..


--
Martin