Make INSERT INTO syntax ANSI compliant
thekevinday - September 21, 2009 - 18:09
| Project: | Type-local nids |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | normal |
| Assigned: | jbrown |
| Status: | closed |
Jump to:
Description
You have probably copied the UPDATE .. SET .. syntax for the INSERT INTO .. syntax.
The valid SQL syntax is actually different.
You need to use INSERT INTO (..) VALUES (..)
See: http://www.w3schools.com/SQL/sql_insert.asp
I have attached a patch that fixes this where I have noticed the problem.
| Attachment | Size |
|---|---|
| type_local_nids-sql_syntax_fix-1.patch | 581 bytes |
#1
I guess this should work on postgres now. :-)
#2
http://drupal.org/cvs?commit=266310
#3
Automatically closed -- issue fixed for 2 weeks with no activity.