Re: Fetch Specifications and boolean values

2006-04-21 Thread Chuck Hill
On Apr 21, 2006, at 7:20 PM, Art Isbell wrote: On Apr 21, 2006, at 4:03 PM, Daniel DeCovnick wrote: I THINK 1 is working. It's generating what looks like valid SQL at least: SELECT customerID FROM CUSTOMER WHERE hasShipped = ? AND customerID = customerID ORDER BY creationTime asc Isn't

Re: Fetch Specifications and boolean values

2006-04-21 Thread Art Isbell
On Apr 21, 2006, at 4:03 PM, Daniel DeCovnick wrote:I THINK 1 is working. It's generating what looks like valid SQL at least:SELECT customerID FROM CUSTOMER WHERE hasShipped = ? AND customerID = customerID ORDER BY creationTime asc Isn't hasShipped a QueueSpot property?  If so, the above SQL is inv

Re: Fetch Specifications and boolean values

2006-04-21 Thread Daniel DeCovnick
On Apr 21, 2006, at 8:50 PM, Chuck Hill wrote:On Apr 21, 2006, at 5:30 PM, Daniel DeCovnick wrote: Hi Chuck,What you said was about what I'd figured, but here's the result from the SQL tab when I do (queuespots.hasShipped) = trueError - could not generate valid SQL.Exception reason: sqlStringForKey

Re: Fetch Specifications and boolean values

2006-04-21 Thread Chuck Hill
On Apr 21, 2006, at 5:30 PM, Daniel DeCovnick wrote: Hi Chuck, What you said was about what I'd figured, but here's the result from the SQL tab when I do (queuespots.hasShipped) = true Error - could not generate valid SQL. Exception reason: sqlStringForKeyComparisonQualifier:: attempt to

Re: Fetch Specifications and boolean values

2006-04-21 Thread Daniel DeCovnick
Hi Chuck,What you said was about what I'd figured, but here's the result from the SQL tab when I do (queuespots.hasShipped) = trueError - could not generate valid SQL. Exception reason: sqlStringForKeyComparisonQualifier:: attempt to generate SQL for EOKeyComparisonQualifier 0x1356ba80 '(queuespots

Re: Fetch Specifications and boolean values

2006-04-21 Thread Chuck Hill
Hi Dan, On Apr 21, 2006, at 4:28 PM, Daniel DeCovnick wrote: I'm trying to create a fetch specification in EOModeler, where it returns all the objects where a particular boolean value therein is true. I've got a "Customer" entity, with a to-many to a "QueueSpot" entity. I want to create a

Fetch Specifications and boolean values

2006-04-21 Thread Daniel DeCovnick
I'm trying to create a fetch specification in EOModeler, where it returns all the objects where a particular boolean value therein is true. I've got a "Customer" entity, with a to-many to a "QueueSpot" entity. I want to create a fetch specification "shipping history" on Customer where the qualifier