RunRev crashes when you experiment with database queries
bill at bluewatermaritime.com
Fri Mar 18 09:18:25 CST 2005
I tried that command (which is what you use to find the last insert in the
whole database instead of just one table -- the name of the table I'm
dealing with is "tripulantes" which means crewmembers) and it also didn't
work. The command is behaving very strangely as I can run the query over and
over again and it keeps returning a number that it increments by one each
time even though no records have been added in the database.
On 3/18/05 11:06 AM, "Gordon Tillman" <got at mindspring.com> wrote:
> Hi Bill,
> On Mar 18, 2005, at 08:58, Bill wrote:
>> I am trying to get the ID number of the last inserted record in a MySQL
>> database. Can anyone help me do this?
>> put "SELECT LAST_INSERT_ID() from tripulantes" into dbQuery
>> put revQueryDatabase(tConnection, dbQuery) into LastInsertID
> I don't know if this is your problem or not, but I just use SELECT
> LAST_INSERT_ID() as the entire SQL command, omitting the "from..."
> part. I just just my MySQL user manual and I don't see the "from ..."
> as being a valid part of the command, unless maybe you are using a
> newer version than what I have.
> use-revolution mailing list
> use-revolution at lists.runrev.com
| | |
)_) )_) )_)
-------\ /--------- http://www.bluewatermaritime.com
^^^^ ^^^^ ^^^ ^^
24 hour cell: (787) 378-6190
fax: (787) 809-8426
Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740
More information about the use-livecode