Posted by iceman on 03/09/07 20:17

alex.waldner@gmail.com napisał(a):
> Sorry - here you've got the whole error message.
>
> An Error Was Encountered
> Error Number: 1064
>
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'Dual, Night, Instrument, CC, landingsDay, landingsNight,
> comment) VALUES (NULL, ' at line 1
>
> INSERT INTO logbook (id, pilot, date, acModel, acReg, blockOffAP,
> blockOff, blockOnAP, blockOn, totalTime, PIC, Dual, Night, Instrument,
> CC, landingsDay, landingsNight, comment) VALUES (NULL, '1',
> '2007-03-08', 'C172', 'SELZF', 'ESOW', '1234', 'ESSA', '1256', '0.4',
> '0', '0.4', '0', '0', '0', '0', '0', NULL)
>

could you show me how do you create this table? maybe id field cann't be
NULL

• Next in forum: Re: Problems with SQL Query
• Prev in forum: Re: help with dadabik pull down from foreing key
• Thread view: Re: Problems with SQL Query

[Reply to this message]