pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ari Nepon <anepon@verveinternet.com>
To: Pgsql-Sql <pgsql-sql@postgresql.org>
Subject: You have an error in your SQL syntax near '' at line 1
Date: Fri, 13 Jul 2001 13:38:50 -0400
Message-ID: <JMEEKPBGBOBMKNANAGILMEMBCDAA.anepon@verveinternet.com> (raw)

Hi,

I keep getting this error "You have an error in your SQL syntax near '' at
line 1" when I try to run the below query. Does anyone know what I'm
missing? Maybe some of the variables need to be in single or double qoutes?
I tried a bunch of things, but no change.

tbl_all holds the foreign keys and some columns of non-relational data. the
other tbl_somethinghere tables hold two columns, the primary key and a name.

	$columns_to_select ="tbl_users.username_field, tbl_client.name,
tbl_project.project_name, tbl_task.task_name, tbl_all.description,
tbl_all.hours, tbl_all.date_field";
	$left_join ="LEFT JOIN tbl_users ON tbl_all.employee_ID =
tbl_users.username_field LEFT JOIN tbl_client ON
tbl_all.client_ID=tbl_client.name LEFT JOIN tbl_project ON
tbl_all.project_ID=tbl_project.project_name";
	$left_join2="LEFT JOIN tbl_task ON tbl_all.task_ID=tbl_task.task_name";
	$where="WHERE tbl_all.client_ID = $clients";
	$all_query ="SELECT $columns_to_select FROM tbl_all $left_join $left_join2
$where";

Thanks,

Ari

~~~~~~~~~~~~~~~~~~~~~~~~~
Ari Nepon
MRB Communications
4520 Wilde Street, Ste. 2
Philadelphia, PA 19127
p: 215.508.4920
f: 215.508.4590
http://www.mrbcomm.com

-----------------------------------------------------------------------
Sign up for our email list and receive free information about
topics of interest to nonprofit communications, marketing, and
community building professionals. Free resources, articles, tips.
Go to http://www.mrbcomm.com and use the Mailing List form.
-----------------------------------------------------------------------




view thread (2+ messages)  latest in thread

Message-ID: <JMEEKPBGBOBMKNANAGILMEMBCDAA.anepon@verveinternet.com>
Permalink:  ../JMEEKPBGBOBMKNANAGILMEMBCDAA.anepon@verveinternet.com/
Also on:    postgresql.org/message-id/JMEEKPBGBOBMKNANAGILMEMBCDAA.anepon@verveinternet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: anepon@verveinternet.com
  Subject: Re: You have an error in your SQL syntax near '' at line 1
  In-Reply-To: <JMEEKPBGBOBMKNANAGILMEMBCDAA.anepon@verveinternet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox