On Mon, 24 Mar 2003 13:18:58 +0100 "Illera, Fernando" <[EMAIL PROTECTED]> wrote:
> I'm trying to insert date type values in SQL Server 7.0, but I always
> get the next error:
>
> DBD::ODBC::st execute failed: [unixODBC] Msg 8115, Level 16, State 2,
> Server PROSDK01, Line 1
>
> The table in SQL Server is defined as:
> create table pruebas (char codigo not null, char valor not null,
> datetime fecha null);
>
> I use the next perl code :
>
> my($dbh) = DBI->connect ("dbi:ODBC(RaiseError=>1, Taint=>1,
> AutoCommint=>1):DSN=<DSN>", "user", "pwd");
>
> my($transaction) = $dbh->prepare("INSERT into PRUEBAS(CODIGO, VALOR,
> FECHA) VALUES(?, ?, CONVERT(datetime, $now)");
Is the value in $now properly quoted? If possible, it would be better
to use a VARCHAR or CHAR placeholder in that location. Make sure the
string is properly formatted for CONVERT() to convert.
> $transaction->bind_param(1, '10101', {TYPE => SQL_CHAR});
> $transaction->bind_param(2, '20202', {TYPE => SQL_CHAR});
> $transaction->execute;
>
> I have also tried with:
>
> my($transaction) = $dbh->prepare("INSERT into PRUEBAS(CODIGO, VALOR,
> FECHA) VALUES(?, ?, ?)");
> $transaction->bind_param(1, '10101', {TYPE => SQL_CHAR});
> $transaction->bind_param(2, '20202', {TYPE => SQL_CHAR});
> $transaction->bind_param(3, $now, {TYPE => SQL_TYPE_TIMESTAMP});
> $transaction->execute;
This might work better with the CONVERT() function as in the first
example, but with a VARCHAR or CHAR placeholder where the $now value
goes.
> Perl version is 5.8, DBI version is 1.34 and DBD::ODBC version is 1.05.
> ODBC Driver is freeTDS v0.61.
> OS from I have running perl is Linux Red Hat 7.3
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
