Re^2: last_insert_id did not work

I am using placeholders like this:

$_pstmt .= ',' if $_pstmt;
$_pstmt .= '`fsb_details` = ?';
push(@placeholder,"$_fsbdotnot");
[download]

then I put $_pstmt for the places ???
then the @placeholder for the things to put on it...

Comment on Re^2: last_insert_id did not work Download Code

Replies are listed 'Best First'.
Re^3: last_insert_id did not work by haukex (Archbishop) on Mar 27, 2021 at 08:41 UTC
Ok, that's good to know, and the code you've shown so far is fine, so if you're doing it that way everywhere it's good. Anytime you interpolate strings into SQL is a place for potential quoting and similar issues, which is why I made that comment. Note that there are also modules to help you generate SQL, like SQL::Abstract.	[reply]