Thread: ERROR: parser: parse error at or near "'"

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 world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Single single quote literals, double quote literals.

'profiles' =3D> "profiles"

On Tue, 2002-09-03 at 10:56, * * wrote:
> 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.
>=20
> SQL =3D "Select users.first_name, users.last_name, profiles.profile_name,=
=20
> countries.city, countries.province" +
>             "countries.country, users.email_address FROM 'profiles' INNER=
=20
> JOIN companies ON profiles.owner_id_bus. =3D companies.company_id" +
>             "INNER JOIN users ON companies.default_contact_id =3D=20
> users.user_id INNER JOIN countries ON companies.location_id =3D countries=
.id"=20
> +
>             "WHERE profiles.profile_name =3D'" + strName + "'";ERROR:  pa=
rser:=20
> parse error at or near "'"
>=20
>=20
>=20
> _________________________________________________________________
> Join the world=92s largest e-mail service with MSN Hotmail.=20
> http://www.hotmail.com
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
> http://www.postgresql.org/users-lounge/docs/faq.html
>=20