How to check if row exists or retrieve last inserted id after insert when using Torque OM?

Hi there, How do I either check if a certain record exists in the table using Torque OM class, or insert a new record, and retrieve the last_inserted_id? Thanks, David - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: Problems to set up a subquery

Thomas Fischer wrote: > Hm, writing SQL is one of the the things that Torque wants to avoid. One > of the reasons for this is portability between databases. Though Torque > is certainly not perfectly portable, it is much better than plain SQL. [...] > So in my eyes, one should think twice before us

Re: Torque as avalon service and use of the DataSourceSelector service

Stefano Bagnara wrote: > Hi all, > > we integrated Torque in Apache James trunk for our IMAP storage needs. > James is currently Avalon based and works on Avalon. > [...] > I see Torque need a static configuration of the class used as the > datasource factory while using DataSourceSelector the da

RE: left or right join in torque

"Kintzel Levente" <[EMAIL PROTECTED]> schrieb am 19.10.2006 12:57:46: > Hi! > > Is there any possibility to implement LEFT or RIGHT join with Torque? > Yes. Read the docs. http://db.apache.org/torque/releases/torque-3.2 /runtime/reference/read-from-db.html Thomas ---

left or right join in torque

Hi! Is there any possibility to implement LEFT or RIGHT join with Torque? Thank you! Regards, Levi

RE: find or create method using Torque

Hi, I would be surprised if something like this exists. Cheers, Thomas "David Zhao" <[EMAIL PROTECTED]> schrieb am 18.10.2006 23:51:33: > Hi there, > > Is there a way using peer class in Torque to either retrieve an > existing record's ID or create a new record and return the new ID

RE: javaName ignored?

Greg, Thanks for the speedy and detailed response! I never thought about creating a view, I might try that, although others with the same problem might not have that option (assuming I can get away with it). It might be a good idea to put all the information you've just given me in the official do

AW: Problems to set up a subquery

I did not see this message before nor do I know what it means. I would have thought this should work But then, village comes up with surprises now and then. >From the message, village does not seem to allow just a single column. Have you tried to add another ? Thomas "Pfiester, Jan" <[EMA