bind_param and dates

2001-04-29 Thread Curt Russell Crandall
I'm getting conversion errors (VARCHAR to [SMALL]DATETIME) on an insert. I have a structure that contains a list of params that need to be inserted into a db table. Prior to insertion, I make sure that undef values are treated as SQL NULLs: for (my $i = 0; $i = $#array; $i++) { if

Re: bind_param and dates

2001-04-29 Thread Curt Russell Crandall
Correction, those dates I was sending are OK I mistakenly sent the reference to them instead of the value. However, the value NULL still doesn't work. In one case, I'm getting the value straight from an SQL query... so it's actually undef... then I quote() it which is supposed to properly