For primary key, you can use "db:" + YourEntity.<YourEntityPkColumn>_PK_COLUMN
For a foreign key, you could do the same, but it'd be cleaner to use the objRelationship name. On 3/23/07, Michael Lepine <[EMAIL PROTECTED]> wrote:
In my application, I have a few queries that I've created with the SelectQuery class. In some instances, I'd like to order the results by the primary or foreign keys in the table using the addOrdering() method. I have not found a way to do this. I believe I get an error that the column does not exist in the ObjEntity instance referenced by the SelectQuery object. Maybe I'm approaching this the wrong way. Is there a way to add an "order by" clause to a query that includes a primary or foreign key? Thanks for your time and any help. - Mike
