in reply to last_insert_id() in sybase

Did you also do a $sth->execute after your prepare statement? A do combines both of those into one operation.

You must always remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.

Replies are listed 'Best First'.
Re^2: last_insert_id() in sybase
by Shreyak (Novice) on Jul 12, 2014 at 03:59 UTC

    Yes i did $sth->execute(@bindValues) after preparing the statement at start of the database connection and executing with bind variables whenever required in code ,and then did $sth->finish() just before disconnecting database. Also i used different statement handlers for insert and update statement.

[reply]

      Then all I can say at this point is what others have mentioned below, show us what you have that failed and what worked. :)

      You must always remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.
[reply]

In Section Seekers of Perl Wisdom