| From: | "* *" <southpark2407(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | ERROR: parser: parse error at or near "'" |
| Date: | 2002-09-03 14:56:04 |
| Message-ID: | F1197JCL5bFfPMsSNDE00017484@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I'm getting the error ERROR: parser: parse error at or near "'"
This is my sql statement in my servlet and i don't see what's wrong with it.
SQL = "Select users.first_name, users.last_name, profiles.profile_name,
countries.city, countries.province" +
"countries.country, users.email_address FROM 'profiles' INNER
JOIN companies ON profiles.owner_id_bus. = companies.company_id" +
"INNER JOIN users ON companies.default_contact_id =
users.user_id INNER JOIN countries ON companies.location_id = countries.id"
+
"WHERE profiles.profile_name ='" + strName + "'";ERROR: parser:
parse error at or near "'"
_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2002-09-03 14:59:08 | Re: ERROR: parser: parse error at or near "'" |
| Previous Message | fpussault | 2002-09-02 12:03:46 | pg_statistic cannot open pg_statistic: No such file or directory |