Re: Using LIKE with PostgreSQL
Re: Using LIKE with PostgreSQL
- Subject: Re: Using LIKE with PostgreSQL
- From: "Colin Shreffler" <email@hidden>
- Date: Wed, 10 Aug 2005 10:53:56 -0600 (MDT)
- Importance: Normal
I'm using postgreSQL 8 with the latest JDBC driver. I used EOModeler to
construct the query which only required me to add the qualifier:
(lastName LIKE $lastName)
It is EOModeler that is adding the ESCAPE clause to the end, and
postgreSQL doesn't seem to like it :)
Any ideas?
> Colin Shreffler wrote:
>> Here is my code:
>>
>> if(searchParam.objectForKey("lastName") != null)
>> searchParam.takeValueForKey(searchParam.objectForKey("lastName")
>> +
>> "*", "lastName");
>>
>> This seems pretty standard. Can you see any flaw in it?
>>
>> -c
>
> What's your database setup? Postgres Plugin, version etc. Looks like
> the escape statement in the SQL is wrong. Did you use
> objectMatchingKeyAndValue or some other way to create the SQL?
>
>
Thank you,
Colin Shreffler
Principal
303.349.9010 - cell
928.396.1099 - fax
email@hidden
Warp 9 Software, LLC.
6791 Halifax Avenue
Castle Rock, CO 80104
Confidentiality Notice: The information in this e-mail may be confidential
and/or privileged. This e-mail is intended to be reviewed by only the
individual or organization named in the e-mail address. If you are not the
intended recipient, you are hereby notified that any review, dissemination
or copying of this e-mail and attachments, if any, or the information
contained herein, is strictly prohibited.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden