Hi,
I am using DBI and DBD-ODBC to connect to my MS-SQL database.
It seems that when I perform a prepare, any :\d+ regexs I passed in
is turned into a question mark on the way to the database.
And this bad, becos I'm trying to insert a date into the database.
Anyone has any idea why this is happening?
If I do this:
my $endtime = localtime;
$sth = $dbh->prepare("pro_upd_mailStat 167, \@endDate = \"$endtime\", \
\@found = 1, \@sent = 2, \@nocategory = 3");
$rc = $sth->execute if $sth;
The stored procedure receive 'Wed May 31 11?? 2000' for the @endDate
If I do this:
my $endtime = localtime;
$endtime =~ s/:/:+/g;
$sth = $dbh->prepare("pro_upd_mailStat 167, \@endDate = \"$endtime\", \
\@found = 1, \@sent = 2, \@nocategory = 3");
$rc = $sth->execute if $sth;
The stored procedure receive 'Wed May 31 11:+35:+22 2000' for the @endDate
I know this is not a database issue, becos it works when I run it from
the Query Analyser.
PS - Any idea why my IP is in the forbidden list when I try to access the
webpage to subscribe to the Perl-Win32-Database Mailing List?
Alan Swan.
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
