RE: Minor gotcha with bind variables and type CHAR.

I would expect to have to pad the field in my where clause against a char field, regardless of how I submitted the query to Oracle. select count (*) from webuserparm where usercd = "MYUSER " and cltid = 10101 ; If you want to not have to pad, then it should be a varchar2. You would

Minor gotcha with bind variables and type CHAR.

A note on bind variables: I'm running Oracle 10gR2 and select stateens with bind variables of type CHAR do not behave as expected. For example, one of my DB's has the following table in it: SQL> desc webuserparm; Name Null?Type -- - U

RE: FAQ? (ps: oracle.xs make failure)

You don't say which version of DBD::Oracle you are building, but if you google for this error, I believe you will find there is a specific version of the module that works with 8.1.7. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Hugh Shedd [mailto:[EMAIL PROTECTED]

FAQ? (ps: oracle.xs make failure)

We are building CPAN modules on an AIX box. I want to look at the FAQ for this group. Is there one? In case anyone can key on any of this, I'll dump our error. I think it some custom stuff... I don't know yet. But I really want to poke around in the FAQ first. But, who knows, maybe someone has

Re: Problem with DBI retrieving data entered

On 10/08/06, Russbucket <[EMAIL PROTECTED]> wrote: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at insertmember.cgi line 56. Code: #Insert data $sth = $dbh->prep

RE: techniques for proper quoting?

Corey [mailto:[EMAIL PROTECTED] wrote: > > On Tuesday 08 August 2006 09:07, Garrett, Philip (MAN-Corporate) wrote: > > You should use placeholders. Here's how: > > > > @fields = qw( country firstname lastname ); > > > > $sql = "INSERT INTO FOO (" > >. join(",", @fields) > >.

Re: techniques for proper quoting?

On Thursday 10 August 2006 13:13, Corey wrote: > On Tuesday 08 August 2006 09:07, Garrett, Philip (MAN-Corporate) wrote: > > You should use placeholders. Here's how: > > > > @fields = qw( country firstname lastname ); > > > > $sql = "INSERT INTO FOO (" > >. join(",", @fields) > >

RE: Newbie - Access to SQL Server db thru Perl

Chris, Yes, you must install both modules. When you specify your connect string (or DSN in ODBC lingo), it will define which database specific driver you will use. Read this http://dbi.perl.org/about/ for a description of how the DBI works. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Or

Re: techniques for proper quoting?

On Tuesday 08 August 2006 09:07, Garrett, Philip (MAN-Corporate) wrote: > You should use placeholders. Here's how: > > @fields = qw( country firstname lastname ); > > $sql = "INSERT INTO FOO (" >. join(",", @fields) >. ") VALUES (" >. join(",", ("?") x @fields) # a ?

Problem with DBI retrieving data entered

Fairly new o using Perl and DBI. Have mysql database on SUSE 10.0, perl-5.8.7-5.3, mysql-4.1.13-3.6. I am able to insert the data from an html form but I want to print the last data entered for verification. I keep getting the following errors (code shown below): /usr/bin/perl insertmember.cgi

Re: ANNOUNCE: DBD::Oracle 1.18

On Thu, 2006-08-10 at 17:52 +0100, Tim Bunce wrote: > On Thu, Aug 10, 2006 at 11:04:29AM -0400, Garrett, Philip (MAN-Corporate) > wrote: > > > > Is there a reason I would want to use execute_array() with > > ArrayTupleFetch instead of execute_for_fetch()? > > Probably not. Just use what comes mo

Re: ANNOUNCE: DBD::Oracle 1.18

On Thu, Aug 10, 2006 at 11:04:29AM -0400, Garrett, Philip (MAN-Corporate) wrote: > > Is there a reason I would want to use execute_array() with > ArrayTupleFetch instead of execute_for_fetch()? Probably not. Just use what comes most naturally for your code, which is typically execute_for_fetch().

RE: ANNOUNCE: DBD::Oracle 1.18

John Scoles wrote: > DBD::Oracle 1.18 has been released. > > With this release DBD::Oracle finally implements Oracle's native > Array Interface. You will see very dramatic increase in speed. For > example; the time for a 2 million plus insert query dropped from well > over an hour to less than 10 m

100% CPU Usage on installing dbd-Oracle

Hi, please can you help me (ore give me a hint) about my Problem on installing the Perl Modul dbd-Oracle 1.17 on a W2K Server with Active State Perl 5.8.8 Build 817 and ppm Installer Version 3.4. The Installation hang's with 100% CPU Usage after the Message: Fechting oraoc

Newbie - Access to SQL Server db thru Perl

Hello, I'm just trying to come up to speed on all of this and wanted to make sure I'm following along with what I need to do: In order for me to use Perl to access MS SQL Server, I need to install both the DBI-1.52 module & the DBD-ODBC module, is this correct? The DBI module will install dbi.