Syntax Error Help

Dev Shed Forums Sponsor:

July 9th, 2012, 12:03 PM

syedmahtab

Registered User

Join Date: Jul 2012

Posts: 2

Time spent in forums: 42 m 57 sec
Reputation Power: 0

Syntax Error Help

May you all live in peace!

I have a little problem and I am very hopeful that I will get a solution over here.
I have created a php page which runs this SQL statement:

SELECT * FROM mdl_trainings WHERE manager_id = $1 AND end IS NULL
[array (
0 => '15',
)]

Here is the error I receive,

"Error Reading Database"
Debug info: ERROR: syntax error at or near "end"

I hope someone here can definitely guide me what syntax error is there in the statement and how can I correct that.
Note: The same statement works perfect for MySQL database but does not work for PostgreSQL database.

With warm regards,

Mahtab Hussain

July 9th, 2012, 02:50 PM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,685

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 53 m 13 sec
Reputation Power: 284

end is a reserved word.

This should work:

Code:

SELECT * 
FROM mdl_trainings 
WHERE manager_id = $1 
AND "end" IS NULL

And please use [code] tags in the future to format your SQL code.

__________________
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
http://forums.devshed.com/misc.php?do=bbcode#code

Tips on how to ask better questions:
http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
http://wiki.postgresql.org/wiki/SlowQueryQuestions
http://catb.org/esr/faqs/smart-questions.html

July 10th, 2012, 11:47 AM

syedmahtab

Registered User

Join Date: Jul 2012

Posts: 2

Time spent in forums: 42 m 57 sec
Reputation Power: 0

Quote:

Originally Posted by shammat

end is a reserved word.

This should work:

Code:

SELECT * 
FROM mdl_trainings 
WHERE manager_id = $1 
AND "end" IS NULL

And please use [code] tags in the future to format your SQL code.

Thanks Shammat. You were exactly right. I have renamed the field names to avoid reserved word and updated relevant code. It solved my issue.

Thanks once again.

Regards,
Mahtab

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Syntax Error Help

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump