3 messages in com.mysql.lists.perlRe: Use one variable for multiple binds
FromSent OnAttachments
Jochen Wiedmann13 Sep 2004 00:34 
Newbedford.net13 Sep 2004 01:53 
Newbedford.net13 Sep 2004 10:38 
Subject:Re: Use one variable for multiple binds
From:Jochen Wiedmann (joch@freenet.de)
Date:09/13/2004 12:34:13 AM
List:com.mysql.lists.perl

Newbedford.net wrote:

I dont know if this is possible. when calling execute with one variable that holds multiple placeholders.

Similar to this. $dbh->execute($variable) the $variable holds multiple values ie.. $variable="bindinfo1,bindinfo2"

Hopefully, this will never be the case. IMO, it is completely up to you, to implement the logic, if, and when, to apply something as simple as

my @vars; if (hasMultipleVars($variable)) { @vars = split(/,/, $variable); } else { @vars = ($variable); }

If you disagree, I'd be interested to learn, how you suggest the drivers implementation of hasMultipleVars($variable).

Jochen