Re: Missing a bind variable, but where?

One of the param values is undef. You need to ensure that they are all defined. ie:

do { $q->param($_,'') unless defined $q->param($_) } for qw( dbms_name
+ ... etc )
[download]

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

Comment on Re: Missing a bind variable, but where? Download Code

Replies are listed 'Best First'.
Re: Missing a bind variable, but where? by Abigail-II (Bishop) on Feb 27, 2003 at 17:31 UTC
Passing in undefined values as bind values is perfectly OK. That's how you pass in NULL. Abigail	[reply]
Re: Re: Missing a bind variable, but where? by tachyon (Chancellor) on Feb 27, 2003 at 17:39 UTC
Not in this context it is not. In list context if one of the param values is undef CGI.pm will return an empty list, and thus we get a 7 not 8 member list passed and so the bind error: `@ary = ( (), ('val'),('val'),('val'),('val'),('val'),('val'),('val') ) +; print scalar @ary; __DATA__ 7` [download] Thus as I suggested defining the values or setting undef ones to 'NULL' will work fine. cheers tachyon s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print	[reply] [d/l]