Re: DBD-CSV taint mode

Does an open(FILE, '', $csvfile) works right before a CUD-operation? If not, move this open()-call step by step to the top of Your script to catch the point where the tainted data enters. BTW: if Your filename is composed from tainted bits it is tained too. greetings Robert -- Am

Re: Error on Make command - gcc: odule_wrap.o: No such file or directory

It looks like a typo to me. Have You tried to look for module_wrap.*? Greetings Robert Am 24.11.2010 19:56, schrieb Mike Towery: Here is what I get when I do that. [r...@l2rac2 DBI-1.615]# gcc -shared -L/usr/local/lib odule_wrap.o -o blib/arch/auto/odule/module.so gcc: odule_wrap.o: No such

Re: How to connect DBI module in my local server

Hi, Am 23.10.2010 07:22, schrieb yugandhar sompalle: Hi, I have query .I wrote simple program in perl it is simple program to connet local DBI server. What is a DBI server? Please provide me procedure how to do ?. Please have a look at http://search.cpan.org/~timb/DBI/DBI.pm especially

Re: DBI and DBD Installation on Different Unix (Solaris, AIX, HP and Linux)

Satish Bora schrieb: Hello, I am asking a very basic question here. Is there any standard instruction set which can guarantee the successful installation of DBI and DBD on Unix env. I tried this for last month of or so (using README files from DBI-DBD packages or based on the search on

Re: need help on $sth-bind_param

Palla, James schrieb: PERL.ORG DBI-USERS, Where can I find the valid syntax for the DBI command $sth-bind_param. The perldoc DBI command shows me this: $rc = $sth-bind_param($p_num, $bind_value); $rc = $sth-bind_param($p_num, $bind_value, $bind_type); $rc =

Re: What is the meaning of the return value from a DBI do statement?

Larry W. Virden schrieb: I'm using DBI to interact with ORACLE . I have a number of statements - select, insert, update, and delete - that are executed depending on the logic. When I execute the $handle-do statement, is the return code a simple In Your code example You do NOT use

Re: 'AllTables' method in DBIx:.Database returns nothing with CSV files

(); The directory 'db' contains the CSV files. Is this a bug in DBIx::Database that should be reported, or am I missing something? -- == Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachbereich Mathematik

Re: Help needed.

Can You show us the part of the code which have the problem. Try to minimise Your program to the problematic core. Greetings Robert --- Agarwal, Gopal K schrieb: Hi, I am connecting the Oracle DB with perl DBI. For short queries (execution time 2 sec) I am able to fetch the data but for

Re: DBD version for Sybase 15

The latest Version of DBD::Sybase is 1.09 (at CPAN). You should try this. By the way: What went wrong while installing or running Your program? Greetings Robert kanisorn.inthac...@dstglobalsolutions.com schrieb: Hi There, I'm looking to run the perl script on the Windows 2003 server that

Re: Info needed about version compatibility

-- == Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachbereich Mathematik / Informatik Universitaet Osnabrueck Albrechtstr. 28a 49069 Osnabrueck Germany Tel ++49/541/969-2540 Fax -2770 rrogg...@uos.de http://www.iwi-iuk.org ==

Re: DBD::SQLite: Nullable Primary Key?

) ) Not nice, but it is a way... Greetings Robert --- Mark Lawrence schrieb: On Mon Oct 12, 2009 at 02:54:38PM +0200, Robert Roggenbuck wrote: I detected that it is possible to enter NULL in a table-column defined as PRIMARY KEY. Is it a bug or a feature of the manifest typing of SQLite

DBD::SQLite: Nullable Primary Key?

I detected that it is possible to enter NULL in a table-column defined as PRIMARY KEY. Is it a bug or a feature of the manifest typing of SQLite? Or is there something in DBD::SQLite going wrong? Here is a test code: ## use strict; use warnings; use DBI; my $dbh =

Re: DBD::CSV data types

You will find the supported data-types in SQL::Dialiects::CSV of the SQL::Statement package. There in no POD, but the section [VALID DATA TYPES] lists all possible types. DATE is unfortunately not there (DBD::CSV 0.22). Hope that helps Robert -- larry s schrieb: Does anyone know why the

Re: DBD::CSV - UPDATE corrupts data!

; ### Robert Roggenbuck schrieb: Thank You for Your reply. The most important thing first: I tried the script on a slightly newer environment (but still a very old one) and it works: Perl, v5.8.8 built for i586-linux-thread-multi (SuSe-Linux, kernel 2.6.18) DBI 1.52 DBD::CSV 0.22 Interesting to see

Re: DBD::CSV - UPDATE corrupts data!

::st (DBI::st=HASH(0x18e7698)~0x18e75c0 '20050701' '20100430' 'ID003') thr#1880010 - execute for DBD::CSV::st (DBI::st=HASH(0x18e7698)~0x18e75c0 '20050301' '20091231' 'ID002') thr#1880010 But may be this is only a matter of reporting... Greetings Robert Robert Roggenbuck schrieb: Hi

Re: disconnect and non-'Active' statement handles

John Scoles schrieb: As I see this is a .cgi script I will hazard a guess that you are using an apache server. Thats right! If this is so what mostlikly is happening is apache::DBI is leaving those session/connections open for reuse. apache::DBI will overload the disconnect method of DBI

disconnect and non-'Active' statement handles

Hi all, while calling $dbh-disconnect() at the end of my database operations, I get the warning that there are still active statement handles. But when I ckeck it I could not see any active statement handles. Any ideas how this could happen? Here is the output of my debugging:

Re: Very slow mail-transport to the list

I changed my subscription address. And now mailing goes as fast as it should. Thanx 8-) Robert rrogg...@uni-osnabrueck.de schrieb: Thank You very much for this clarification! I will try to change my email next week. The rest of this week I am at home and can not access the address from wich I

Re: DBD::CSV - UPDATE corrupts data!

is the same. Other things inlined ... Alexander Foken schrieb: Hello, On 30.06.2009 14:41, Robert Roggenbuck wrote: Hi all, [snip] Running the code below copied and pasted on Linux 2.6.26.5, Perl 5.8.8, DBI 1.607, DBD::CSV 0.20, both runs deliver the same result from your first run. Even several

Re: Insert records in table with perl DBD::Mysql

If You use do() with placeholers / bind variables, You have to put a 'undef' between the SQL-statement and the variable list. This gap is reserved for a poiter to an argument hash (which is very seldom used). You see this in the second example of the DBD::Mysql-documentation. Greetings

DBD::CSV - UPDATE corrupts data!

Hi all, I stumbled over somthing very strange: When I try to update data in a table, the input parameters are going into the right fields - exept the first data row in the table / file. Below is a script which demonstrate the thing. Running the first time, it creates the table 'Projects' and

Re: bind_params: Not identifying ? as a parameter placeholder

Why not $sth-bind_param(4, $int); ? I see 4 placeholders in Your statement. Do not rely on the values of statement handle attributes (like NUM_OF_PARAMS) unless You executed the statement handle. By the way: How does Your code fails? Any error message? Greetings Robert Tim Bowden

Re: Datatype-support of DBD::SQLite

DEFAULT, are available within DBD::SQLite. :-) Greetings Robert --- Owen schrieb: On Wed, 27 May 2009 16:19:28 +0200 Robert Roggenbuck rrogg...@uni-osnabrueck.de wrote: Hi all, while looking at the SQLite-Documentation at http://www.sqlite.org I detected that there are only a few

Re: Difference between DBD::SQLite and DBD::SQLite2?

Thanks for the clarification. Greetings Robert -- David Dooling schrieb: On Tue, May 26, 2009 at 12:29:08PM +0200, Robert Roggenbuck wrote: can someone explain the difference between the DBD::SQLite and the DBD::SQLite2 divers? DBD::SQLite2 is deprecated and (as you indicate below

Datatype-support of DBD::SQLite

-- == Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachbereich Mathematik / Informatik Universitaet Osnabrueck Germany http://www.iwi-iuk.org ==

Difference between DBD::SQLite and DBD::SQLite2?

in it's NAME-chapter it is for sqlite 2.x? Hope someone can unconfuse me. Greetings Robert -- == Robert Roggenbuck Institut fuer wissenschaftliche Information e.V. (IWI) Fachbereich Mathematik / Informatik Universitaet Osnabrueck Germany

Re: Beginners Question: Can I have more the one statement-handle from same db-handle at a time?

test myself because my the mysql db on my iphone is broken and I have no other here at the moment :-( A simple yes or no will do. Thanks, B. -- === Robert Roggenbuck Universitaetsbibliothek Osnabrueck Alte Muenze 16 D-49074 Osnabrueck Germany Tel ++49/541/969

Re: How to write a (My)SQL statement with REGEX / RLIKE containing a scalar variable?

To use the LOCATE-example, You should replace LOCATE(?, t.name) by POSITION(? IN t.name). While LOCATE() is MySQL specific, POSITION() is Standard SQL (SQL99) and supported by MySQL (and others) - but as far as my SQL handbook from 2001 states, it is not suppoted by Oracle and Microsoft SQL

Re: [rt.cpan.org #36696] DBI AutoCommit perldebug eval $@ problem

Doesn't the fact this only happens in the debugger point to a problem with the debugger? -- === Robert Roggenbuck Universitaetsbibliothek Osnabrueck Germany ===

Re: Installing package

This sounds to be a permission problem. Check Your install aim and Your permissions there. Greetings Robert Nirmaladevi Venkataraman schrieb: Hi when I tried to install DBD-ODBC package I get following error message ppm install failed: All available install areas are readonly. Could you

Re: Segmentation Fault(Core dumped)

Please give us some more information. Can You figure out where (= which lines) in Your script the code crashes? Greetings Robert Kasi, Vijay (London) schrieb: Hello, I am receiving 'Segmentation Fault (core dumped)' error while executing perl script on unix host. I am using oracle 10.2.0

Re: DBI problem...

included in squid2mysql package delivery? thanks alot guys best regards Didi Send instant messages to your online friends http://uk.messenger.yahoo.com -- === Robert Roggenbuck Universitaetsbibliothek Osnabrueck Germany ===

Re: DBD::CSV: make test fails

Jeff Zucker schrieb: My guess is that you are either missing some prerequisites or that the older linux perl has some old copies of them. Try to first install the latest DBD-File, SQL::Statement, and Text::CSV_XS. If you still get errors, please let me know what versions of those modules

Re: DBD::CSV: make test fails

function - but it is a DBD::CSV privat feature. So again DBD::CSV is wrong in using DBD::Adabas and applying it's own feature to a foreign driver. Cleaning the test codes from using foreign drivers will also solve this issue. Best regards Robert Robert Roggenbuck schrieb: I looked

Re: DBD::CSV: make test fails

Jeff Zucker schrieb: Robert Roggenbuck wrote: The DBD::Adabas-error comes during the tests t/20createdrop, t/30insertfetch, t/40bindparam, and then I stopped going though the others. The message is exactly the same in every test. If these are Jeff Zucker's private tests, there is something

Re: DBD::CSV: make test fails

Hi Ron, Ron Savage schrieb: Robert Roggenbuck wrote: Hi Robert Looking at the code and the first error msg you got: YOU ARE MISSING REQUIRED MODULES: [ ] makes me suspect the method you are using to test the module. Are you using 'The Mantra' of standard commands? Something like: As I said

Re: DBD::CSV: make test fails

Zucker's private tests. Don't do that! -- === Robert Roggenbuck Universitaetsbibliothek Osnabrueck Alte Muenze 16 D-49074 Osnabrueck Germany Tel ++49/541/969-4344 Fax -4482 [EMAIL PROTECTED] Postbox: Postfach 4496 D-49034 Osnabrueck ===

DBD::CSV: make test fails

Hello, since a longer time I am using DBD::CSV for several purposes and were quite happy with it. But now I try to install it on an old Linux Server and the 'make test' fails in nearly every case. Can someone give some hints? Here is the 'make test' part from the automated installation from

Re: Recovering records from corrupted MSSQL tables

It should be possible to reformulate the while-loop like this: while (1) { my $row_ref = $walk_sth-fetchrow_arrayref(); if (not defined $row_ref) { if ($walk_sth-err()) { warn found invalid record\n; # implicit

Re: DBI:CSV join ... flashback to 2002

The problem seems to be the dot in the table names. The dot have special meanings in SQL for table names and is not just an allowed character (for example it is used as scheme separator 'scheme.tablename'). Just try to rename Your CSV-files by cutting of the extension '.csv'. May be all the

Re: escaping % AND \%

What about changing / fixing the escape character just for that query? $sql = SELECT * FROM Table WHERE Field LIKE ? ESCAPE '!'; $sth = $dbh-prepare($sql); $user_input =~ s/([_%!])/!$1/g;# SQL-escape $user_input =~ s/([$%\\])/\\$1/g; # Perl-escape $sth-execute( '%' . $user_input . '%' );

Re: DBD::CSV and multi character separator

-- === Robert Roggenbuck, M.A. Konrad Zuse Zentrum fuer Informationstechnik Berlin Takustr. 7 D-14195 Berlin [EMAIL PROTECTED] http://www.mathematik-21.de/ http://www.zib.de/ Buero: Universitaet Osnabrueck Fachbereich Mathematik / Informatik Albrechtstr. 28aFon: ++49 (0)541

Re: DBD::CSV and multi character separator

|++|5.10|++|sparc 101|++|abd|++|1.2.3.5|++|SunOS|++|5.10|++|sparc 102|++|abe|++|1.2.3.6|++|SunOS|++|5.10|++|sparc 103|++|abf|++|1.2.3.7|++|SunOS|++|5.10|++|sparc Column separator is (|++|) and Line separator is newline (\n) Thanks - Santosh On 4/27/07, Robert Roggenbuck [EMAIL PROTECTED] wrote: Hi

Re: perl dbi memory error?

By the way: In the 3rd step You are using in Your code $sth-execute (and not $dbh-execute, as You typed in Your message)? Don't You? Best regards Robert ravi kumar schrieb: Hai, I am using perl DBI module for fetching data from database. My database table contains almost 70

Re: Balasan: Re: Where does MoveNext belong to?

the MoveNext and -{EOF} from. I wrote the very simple sample to ease my friends here to understand my problem but practically I am writing a database dumping tool for my boss. Please help me. Thank you very much in advance. --- Robert Roggenbuck [EMAIL PROTECTED] wrote: I do not know anything

Re: Where does MoveNext belong to?

I do not know anything special about ADO, but try the more usual way to fetch results: my $tab4l; while ( ($tab4l) = $rsnya-fetchrow_array) { print \$tab4l: $tab4l \n; } Does it work this way? Best regards Robert Patrix Diradja schrieb: Dear my friends I am writing a program

Re: Help Needed :: urgent

Can You add some more details about error messages, relevant code snippets and used versions (of Perl, DBI, used drivers, mySQL)? Robert veera sekar schrieb: Hello, I used perl DBI module for my threading concept.but i am getting problem, few things not working because of DBI resource break

Re: DBI Module

or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ -- === Robert Roggenbuck, M.A. Konrad Zuse Zentrum fuer Informationstechnik

Re: RFC: SQL::KeywordSearch 1.1

','brown'); I did not tested the syntax, but regarding the SQL-rules it should be possible. This will shorten the statements and may be improve the performance. Best regards Robert Mark Stosberg wrote: Robert Roggenbuck wrote: Hi Mark, is a nice idea, but why don't You do

Re: RFC: SQL::KeywordSearch 1.1

Hi Mark, is a nice idea, but why don't You do it in standard SQL using LIKE? Robert Mark Stosberg wrote: Hello, I thought some people here would be interested in reviewing this: I plan to publish a small module to generate SQL for simple keyword searches. The docs are here for easy HTML

Re: Checking if a table exist

Hi Peter, in case You just want to be shure not to destroy an already existing table by creating it again, You can just isse an $dbh-do(CREATE TABLE...). An already existing table will never desroyed and a warning will be raised. Greetings Robert - Loo, Peter # PHX wrote: Hi All,

Accessing an MS Access-db remote from a Unix-system

Hi, until now I thought it is impossible to access remotely an Access-db in an Windows NT/2000 environment. But someone told me that it is possible (she heard it from someone else, and so on...). Does anyone knows something about it? Greetings Robert Roggenbuck (Germany)