Download & Extend
Type-local nids » Issues

Make INSERT INTO syntax ANSI compliant

Posted by thekevinday on September 21, 2009 at 6:09pm
Project:Type-local nids
Version:6.x-1.x-dev
Component:Code
Category:task
Priority:normal
Assigned:jbrown
Status:closed (fixed)

Issue Summary

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.

AttachmentSize
type_local_nids-sql_syntax_fix-1.patch581 bytes
Login or register to post comments

Comments

#1

Posted by jbrown on September 22, 2009 at 5:57pm
Title:invalid SQL insert into syntax» Make INSERT INTO syntax ANSI compliant
Version:6.x-1.3» 6.x-1.x-dev
Category:bug report» task
Priority:critical» normal
Assigned to:Anonymous» jbrown
Status:active» fixed

I guess this should work on postgres now. :-)

#2

Posted by jbrown on September 22, 2009 at 5:58pm

http://drupal.org/cvs?commit=266310

#3

Posted by System Message on October 6, 2009 at 6:00pm
Status:fixed» closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.