Single single quote literals, double quote literals. 'profiles' => "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. > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
