well, I am using $dbh->{mysql_insertid} a lot (MySQL 3.23.*), and haven't had
any problems. Hmmm, try to upgrade to 3.23, since I have no clue what might
be wrong.
Ruben Safir wrote:
RS: That's bad.
RS:
RS: That breaks a lot of legacy code without reason
RS:
RS:
RS: Ruben
RS:
RS: On 2001.12.04 17:40:38 -0500 Nick Tonkin wrote:
RS: >>
RS: >> IIRC it's $sth->{insertid} these days .... check the docs for your new
RS: >> version.
RS: >>
RS: >>
RS: >> ~~~~~~~~~~~
RS: >> Nick Tonkin
RS: >>
RS: >> On Tue, 4 Dec 2001, Vaughan, Penny wrote:
RS: >>
RS: >>> Hello all,
RS: >>>
RS: >>> I was using $dbh->{'mysql_insertid'} to return the auto_increment
RS: >> number with no problem until a recent server upgrade. We moved
RS: >> everything to a new box, but had to re-install the mysql perl modules.
RS: >> We're running mysql 3.22.25. Now, I'm just getting 0 whether I use the
RS: >> database handle or the statement handle in my cgi. No error messages
RS: >> are
RS: >> showing up so it thinks it's working.
RS: >>>
RS: >>> Clues or red herrings:
RS: >>> When I ran select last_insert_id() at the mysql command line I was
also
RS: >> was getting zero until I added a record and then I got a correct number,
RS: >> but still zeros through the DBI.
RS: >>>
RS: >>> When I was trying anything, I used the old $sth->{insert_id} and
got a
RS: >> message telling me that this has been deprecated so I'm guessing that
RS: >> means the modules are working?
RS: >>>
RS: >>> I ran the auto_increment.tst; it looked good. We restarted the mysql
RS: >> server and last_insert_id() gave zero again at the mysql prompt.
RS: >>>
RS: >>> Any suggestions?
RS: >>>
RS: >>> Thanks,
RS: >>> Penny
RS: >>>
RS: >>>
RS: >>>
RS: >>>
RS: >>
RS: >>
RS: >> ---------------------------------------------------------------------
RS: >> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
RS: >> before
RS: >> posting. To request this thread, e-mail
RS: >> msql-mysql-modules-thread1549@stripped
RS: >>
RS: >> To unsubscribe, send a message to the address shown in the
RS: >> List-Unsubscribe header of this message. If you cannot see it,
RS: >> e-mail msql-mysql-modules-unsubscribe@stripped instead.
RS: >>
RS: --
RS: __________________________
RS:
RS: Brooklyn Linux Solutions
RS: __________________________
RS: http://www.mrbrklyn.com - Consulting
RS: http://www.brooklynonline.com - For the love of Brooklyn
RS: http://www.nylxs.com - Leadership Development in Free Software
RS: http://www.nyfairuse.org - The foundation of Democracy
RS: http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and
RS: articles from around the net
RS: http://www2.mrbrklyn.com/mp3/annie.mp3 - Armed and Dangerous....
RS: http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn....
RS:
RS: 1-718-382-5752
RS:
RS:
RS:
RS:
RS:
RS: ---------------------------------------------------------------------
RS: Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
RS: posting. To request this thread, e-mail
msql-mysql-modules-thread1550@stripped
RS:
RS: To unsubscribe, send a message to the address shown in the
RS: List-Unsubscribe header of this message. If you cannot see it,
RS: e-mail msql-mysql-modules-unsubscribe@stripped instead.
RS:
--
sherzodR <sherzodr@stripped>
use CGI::Session;
