AW: Problem with inserting NULL values.

2003-08-03 Thread Andreas.Mock
Hi all, first of all, thank you very much for your quick answers. But I don't think it has something to do want you mentioned so far. The relevant code is really nothing more than this snippet: -%<--- print "Before connect\n"; $dbh = DBI->connect($DSN, $DBU

Weired Transactions with ODBC and MS SQL 2000

2003-08-03 Thread Andreas.Mock
Hallo all, while making some tests with DBI, DBD::ODBC, freetds and MS SQL 2000, I had the following problem. When I start a little program with the following code snippet, I get an unexplainable error: -%<-- print "Before connect\n"; $dbh

DBD::Oracle - NLS and numbers

2003-08-03 Thread Steve Baldwin
I was intending to use ALTER SESSION SET NLS_TERRITORY='GERMANY' to allow me to subsequently use the G and D formatting characters in a TO_CHAR format string. For example SELECT TO_CHAR (Invoice_Total, '999G999G999D') from ... However, once I issue the ALTER SESSION, *all* numeric values c

Re: MySQL, DATETIME, bind, insert problem

2003-08-03 Thread Michael A Chase
On Sun, 03 Aug 2003 09:49:12 + Stephen Collyer <[EMAIL PROTECTED]> wrote: > Michael A Chase wrote: > > >On Sat, 02 Aug 2003 12:32:42 + Stephen Collyer > <[EMAIL PROTECTED]> wrote: >>>2. When @bind_params contains, say, ('NOW()', 'Doctor', 30, 'Bill'), >>>it all goes horribly wrong, and M

(Fwd) Perl and Oracle

2003-08-03 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Perl and Oracle Date: Wed, 30 Jul 2003 11:12:09 -0500 Mr. Bunce, I just completed viewing your 2001 presentation on Integrating PERL with Databases (Geek Cruise 2001

Re: SQL::Statement and 0-length strings

2003-08-03 Thread Jeff Zucker
[EMAIL PROTECTED] wrote: I remember Jeff saying that a new SQL::Statement has been in the works Yes, unfortunately delayed. I'm hoping for September now. From:Matthew O. Persico <[EMAIL PROTECTED]> The problem was that I had a value that was the empty string, When I generated the SQL, the e

Re: q.:

2003-08-03 Thread Jeff Zucker
Nikolay Nikolaev wrote: We have two variants 1. perl API use::Mysql; 2. DBD driver use::DBI; it is Correct Sort of. The "perl API" is not recommended. You need to install DBI and install DBD::mysql and then in the script: use DBI; my $dbh = DBI->connect('dbi:mysql ... -- Jeff

Re: MySQL, DATETIME, bind, insert problem

2003-08-03 Thread Stephen Collyer
Michael A Chase wrote: On Sat, 02 Aug 2003 12:32:42 + Stephen Collyer <[EMAIL PROTECTED]> wrote: 2. When @bind_params contains, say, ('NOW()', 'Doctor', 30, 'Bill'), it all goes horribly wrong, and MySQL fails to interpret the 'NOW()' string as an attempt to call a MySQL specific function.

q.:

2003-08-03 Thread Nikolay Nikolaev
Hi All! I am only start study interacyion Perl with MySQL! I read too much article, how-to ... etc if I don't right correct me (plz): We have two variants 1. perl API use::Mysql; 2. DBD driver use::DBI; it is Correct Thank you. P.S. and sorry for may be dumb question...