| Perhaps there is a better way with EOModeler. For one example, I would like to put lowercase() around some of the columns being queried in order to be case-insensitive. Can EOModeler do that?
I guess I am not impressed with EOModeler's sql. Another case... I have a table that looks like this: id name parent_id
This table represents a tree. I want to query based on the name of a node, and the parent's name. I create a relationship from the object to its parent (linking parent_id to id), and I tried to create a query based on name and parent.name. The sql it wants to use is: SELECT name, id, location_id, parent_id FROM table WHERE (name = ? AND name = ?) AND parent_id = id Which clearly won't work. The sql I would elect to use is: select * from table where name=? and parent_id=(select id from table where name=?) On Apr 10, 2006, at 4:24 PM, Chuck Hill wrote: Randy,
On Apr 10, 2006, at 3:12 PM, Randy Wigginton wrote: If someone can point me to an example, I’d be most grateful.
I want to create a fetch spec with two bind variables, yet using custom sql. Is there a way to do it?
I don't know, but I will ask why? Are you sure you need custom SQL? I've done a bit of WebObjects, and I don't recall ever having to use custom SQL in a fetch spec. EOF is remarkably flexible when it comes to generating SQL. Perhaps there is another, better, more portable solution to your problem.
Chuck I’ve created a fetch spec with two keys, and I’ve executed it. As soon as I click the button for “raw sql”, I get an oracle error (not all variables bound).
Is there some kind of trick? This seems incredibly simple, yet I can’t get it to work.
--
|