--- Josh Mellicker <[EMAIL PROTECTED]> wrote: > Just wondering, > > After you execute a revExecuteSQL INSERT, how do you > get the auto- > incremented record ID MySQL automatically assigned > (from within Rev)? > > (Rather than doing an inelegant search for the > record you just > inserted and reading it's ID?) > > Thanks! >
Hi Josh, For a second I thought that the result of revExecuteSQL might be the ID, but according to the docs you'll get the number of records affected by your query. So it looks like searching your record is the only option. Jan Schenkel. Quartam Reports for Revolution <http://www.quartam.com> ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
