[thelist] [SQL] INSERT INTO syntax

[Mattias Thorslund]

Doesn't Access requie #'s around the date, to indicate it's a date and 
not a simple string?

I.e. #02/05/2007#

HTH, Mattias

Tim Burgan wrote:

> Hello,
>
>
> I've really clogged everyone email box the last for days with my mass 
> of post for help. Sorry about that and thanks for all your help.
>
>
> I'm getting this syntax error regarding my INSERT INTO SQL statement:
>
> Warning: (null)(): Invoke() failed: Exception occurred. Source: 
> Microsoft OLE DB Provider for ODBC Drivers Description: 
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO 
> statement. in 
> C:\www\xampp\htdocs\_YWAM\_site\02_templates\rebuild_\inc\admin_countdown_create.php122* 
>
>
>
> *I really must be missing something really small. My SQL is:
>
>   INSERT INTO tblCountdown (event, date)
>   VALUES ('eventName', '2/05/2007');
>
>
> If I exclude the date field, everything works fine. When I include it 
> again.. errors. The database is Access.
>
> The data-type format of the field within Access is short date (eg. 
> 2/05/2007).
>
>
> Where is my syntax error?
>
>
> Tim
>
>

-- 
More views at http://www.thorslund.us