Hello all-

I know this is a bit off topic but it's been bugging me for awhile(years!).

Unless I'm mistaken (which happens more often that I'd like to admit!), when I create a new record using a standard inline within Lasso, I have always made a subsequent call to the database for the last "record id" ( I always have an auto-increment int field called ID).
Not working with sites getting 100,000's of "records added" each day, this works. I know however that there is a big window for failure.

If there was ever anything I liked about FileMaker "on the web" is was the feature to grab this data in the same call.

I'm trying to work with MySQL's "SELECT LAST_INSERT_ID()" to do the same thing but can't seem to get it to work. Hell, I can't even figure out where to put it!

Is there a way to get this working, or another way to grab the newly created record ID in the same call that I'm missing?


James Sheffer,

The HigherPowered Team!

support@higherpowered.com sales@higherpowered.com
Web Design & Development http://www.higherpowered.com
phone: 469-256-0268
"We help businesses succeed on the web!"
-------------------------------------------


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>