Re: DBD::DB2 query fails with tainted placeholders

I might be way off here, especially since I haven't done much with "taint"ed data, but here's my first thought - you need to untaint your data, and then call execute with the untainted data. I believe that the tainted data needs to be run through a regular expression to "untaint" it. HTH. -- H

DBD::DB2 query fails with tainted placeholders

The easiest way to explain this is with an example #!/usr/bin/perl -wT $ENV{'DB2INSTANCE'} = 'X'; $ENV{'INSTHOME'} = '/X/X/X'; use DBI; my $dbh = DBI->connect("dbi:DB2:X", "", "", {RaiseError=>1, PrintError=>0, AutoCommit=>0}); my $tainted_input = shift; my $sth =

RE: DBI->connect using 'old-style' syntax

Hi Everyone, Can someone tell me how to unsubscribe from this alias? Thanks Juan Arturo Veliz Carmona <[EMAIL PROTECTED]> wrote: Ok Michael... then I am going to remove it Thank you. -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 1

Re: Odd behavior from DBD::CSV

Thomas A. Lowery wrote: The default behavior (from the docs) looks carriage return, line feed. csv_csv The attributes csv_eol ... Defaults are "\015\012" Right, the default record separater is "\015\012", so you need to specifically set the eol to "\n" if the file uses a platform-specific

RE: DBI->connect using 'old-style' syntax

Ok Michael... then I am going to remove it Thank you. -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 12:16 AM To: Juan Arturo Veliz Carmona; [EMAIL PROTECTED] Subject: Re: DBI->connect using 'old-style' syntax On Mon, 25 Aug 2003 17:0

which method should i use?

hello, i'm relatively new to using DBI. i'm attempting to execute the following query against a MS SQL 2000 db. only the first instance of the results are being returned. i'm not sure if i'm using the correct method and hope that someone can point me in the right direction... thanks, -adam part

Re: Trying to store a file into the Oracle

Ok, this is the same code that you posted to the list. 1) I tested the "read" syntax you have, and it should work but apparently is not. Try printing the contents of $buf to see what's in it. 2) Try the changes I suggested, and post further replies to the list. J

Re: Trying to store a file into the Oracle

To start with, you are trying to insert the size of your file rather than the actual content of it: $stmt = $db->prepare("INSERT INTO hr.documents (documentid , document_name, document) VALUES ('1','john.doc','$bytes')") || die "\nPrepare error: $DBI::err $DBI::errstr\n

Re: Database and Web Server on Different Machines

W liście z pon, 25-08-2003, godz. 17:24, Herbert Braun, Berlin Tourismus Marketing GmbH pisze: > I have set up the scenario you describe below and got a dummy connection > running - even though 'make test' of DBD::mysql massively complained about > not finding a database server ... I just took a

DBI, BLOB, Oracle

How to insert a file. Does anyone know?

Re: DBI does not give any error.

On Sun, 24 Aug 2003 01:53:25 +0530 Parmod Chander Goyal <[EMAIL PROTECTED]> wrote: > My perl executable .pl file is not giving any error. I have debugged > it and found that @dbh=DBI->connect() is not working (these were > working for last 1 year). The correct list for this is [EMAIL PROTECTED],

Re: DBI->connect using 'old-style' syntax

On Mon, 25 Aug 2003 17:02:03 -0400 Juan Arturo Veliz Carmona <[EMAIL PROTECTED]> wrote: > Tim: You should be writing to [EMAIL PROTECTED] Writing directly to Tim delayed the initial response by about 9 hours. > I corrected the problem in the script of the following form: > > my $dbh = DBI->con