From: "Weaver, Scott" <[EMAIL PROTECTED]> > Are you using "native" or "idBroker" for your id's?
That should be "idbroker" with a lowercase "b". > If you are using "native", you will not be able to access the primary key > after an insert. "native" uses the RDBMS' internal ability to generate the > id, which consequently happens during/after the actual insert into the db, > and at this point it is out of Torque's control. For the key to be > available to a Torque OM object, Torque would have to query the db after the > insert transaction was completed, which it does not. What you are saying appears to make sense but I do recall being able to retrieve an id immediately after an insert when using MySQL and autoincrement. I also recall other users having this same problem - check out: http://marc.theaimsgroup.com/?l=turbine-user&m=100434715720285&w=2 I bet the problem the user had in the archived message was the "I" in "autoIncrement". > However, you could add this functionality by overriding the save() method in > your OM class query the db for it's key. Unnecessary > On the other hand, if you use "idBroker", which uses Torque's api to > generate id's, you will have access to the primary key because the key is > generated and stored in the OM class before the insert into the db not > during/after as is with the "native" id method. Native methods are good in that you can use other tools to insert data and have consistent ids generated. On the other hand they are not usually the best keys to use (high-low ids would be better). >> I have the following code... after the save (which is successful) I cannot >> get back the key (which I know was made and used because I see it in the DB) >> the same results if the primary key method is idbroker or auto_increment in >> the Map file... I am using mysql.. That should be "autoincrement" without the "_". No doubt this is your problem. It is quite easy to catch these problems by validating your schema file. Cheers, A different Scott -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
