Re: SQLite - Time to build a database

l completely on an error... Unless the data gets prescreened. In Perl. -- Bart Lateur bart.lat...@telenet.be

Re: SQLite - Time to build a database

It SQLite's scratchpad, where it stores its intentions for each transaction. If the computer goes down before a transaction is finalized, this could likely be used to redo the action and this time, complete it. Or, roll it back properly. -- Bart Lateur bart.lat...@telenet.be

Re: Trying to safely compare user input name against database

ased on the value of a function for a row, instead of on the raw column values. -- Bart Lateur bart.lat...@telenet.be

Re: anyone accessing "h2" java database with DBI?

y fast, open source, JDBC API Well, duh... Look no further than JDBC, that's what I would say. -- Bart Lateur bart.lat...@telenet.be

Re: parameter issues in DBD:Oracle

On Fri, 26 Mar 2010 14:32:52 -0400, Bobak, Mark wrote: >Is there a way to pass an unquoted list as a parameter? I can't do it >as 'in(?,?,?,?)' etc, because the number of list elements varies from >execution to execution. There's a special feature in DBIx::Simple to tackle this exact case. Lo

Re: DBI.pm package not found

On Thu, 10 Dec 2009 16:30:58 +0530, Kallol Chakraborty wrote: >I am having DBI.pm package in > /oracle/app/oracle/product/10.2.0/in-dwh/perl/lib/site_perl/5.8.3/i686-linux-thread-multi > , which is coming with Oracle 10G . >In my perl code I am using > >use lib >/app/oracle/prod

Re: Problems installing DBI and DBD::mysql to a local directory

On Thu, 08 Jan 2009 13:48:02 +, Martin Evans wrote: >Looks like you are not the only one with this chopblanks problem: > >http://www.nabble.com/Bundle::Bugzilla-install-hangs-td20363858.html >http://lists.mysql.com/perl/4296 >http://ppm4.activestate.com/i686-linux/5.8/818/C/CA/CAPTTOFU/DBD-mys

Re: Mailing list

On Sat, 29 Nov 2008 17:24:44 +0530, Sureshkumar M (HCL Financial Services) wrote: >Can someone send the maid's for Perl forum where I can clear >all my doubts? I would like to discuss lot of doubts and get answer and >get quick answers. It depends on the subject of the question. You c

Re: [rt.cpan.org #36395]

On Wed, 25 Jun 2008 03:12:42 -0400, [EMAIL PROTECTED] via RT wrote: > Queue: DBI > Ticket http://rt.cpan.org/Ticket/Display.html?id=36395 > > >Hi Tim > >On Tue, 2008-06-24 at 17:17 -0400, Tim_Bunce via RT wrote: >> Queue: DBI >> Ticket http://rt.cpan.org/Ticket/Display.html?id=36395 > >> >

Re: Fw: How to Retrieve Table Name from Statement Handle

On Wed, 7 May 2008 12:41:01 -0700 (PDT), Lamb Joseph wrote: >I will have to break apart the SQL statement with a regex and store it that >way. > >Thanks for the input. More input: take a look at Ovid's article "Lexing Your Data" on perl.com, at http://www.perl.com/pub/a/2006/01/05/par

Re: DBD-ODBC and DBI 1.21

On Fri, 25 Apr 2008 07:48:35 -0700 (PDT), jbeadles wrote: >This upgrade is requiring me to reload DBI and DBD-ODBC. The issue is >that the DBD-ODBC install fails because it requires DBI 1.21. Googling >everything I can find over the past couple of days indicates that this >is a popular problem. Th

Re: DBI error

On Tue, 29 Jan 2008 13:44:16 -0700, Kirthi Prabhu wrote: > I get the pg.pm file and I have placed that in DBD/ folder. Generally not a good sign... >When I use DBI -> Connect I get the following error >install_driver(Pg) failed: Can't locate loadable object for module >DBD::Pg in @INC I was ex

Re: make test for DBI fails on Win98

On Mon, 27 Aug 2007 10:17:16 +0100, Tim Bunce wrote: >Try the appended patch and let me know if it works for you. Yes, after the patch all tests pass. Funny, CPAN.pm also recently introduced similar code with similar problems. Is this a conspiracy, or just thoughtlessness? :) Win98 has other ty

make test for DBI fails on Win98

What are the plans on supporting DBI on older platforms? Since DBI 1.57 (also in 1.58 and 1.59), some tests fail on Win98 (ActivePerl 5.8.8 build 822, module compiled with MinGW 3.4.2 (+ nmake)), while all tests pass on XP. The culprit appears to be in DBI::ProfileDumper. A typical error message l

Re: ShowErrorStatement

On Tue, 14 Aug 2007 16:01:21 +, [EMAIL PROTECTED] wrote: >To oversimplify somewhat: > >* PrintError prints an error message whenever there is an error. > >* RaiseError does the same as PrintError and also dies. I've always wondered, and now seems a good time to ask as any: why are PrintError

Re: DBD::ODBC does not support bind_param_inout?

Sorry for the late reply, but I'm only scanning my inbox now. On Wed, 18 Jul 2007 17:35:51 +0800, hu.darren wrote: >my $csr = $dbh->prepare(q{ >BEGIN >:whoami := PLSQL_EXAMPLE_DARREN.FUNC_NP; >END; > }); >but I failed with: >Can't bind unknown placeholder ':whoami'

Re: problem with installing dbi module

On Sat, 10 Feb 2007 05:30:40 + (GMT), Jai chandru wrote: >iam using pxperl 5.8.1 on windows and when i tried to install following error >was reported . > >nmake > "gcc" cannot be recoganised as a internal command. > fatal error... PXPerl works well with Min

Re: DBD-ODBC.ppd

On Thu, 18 Jan 2007 11:14:11 +0100 (MET), Alexander Foken wrote: >http://ppm.activestate.com/PPMPackages/zips/ >http://search.cpan.org > >On 18.01.2007 10:32, Pamal Dias wrote: >> Hi, >> >> Please send me the DBD-ODBC.ppd file for perl 5.8.8. If that is not >> available please send me a the lates

Re: Retrying a fetch after an error, without restarting the whole loop?

On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote: >>And 2), in a fetch loop, is it possible to adjust a property like >> {ReadLongLen}, and retry the same fetch without restarting the whole >> loop? Because this error typically happened several minutes into the >> loop. > > >Highly unlik

Retrying a fetch after an error, without restarting the whole loop?

I've been saving picture files that had been stored in a blob field in an MS-Access database (aka an "OLE Object") to files, and I've bumped onto some LongReadLen related problems: through trial and error I finally succeeded in making LongreadLen long enough to reliable extract all the files. (in A

Re: MSAccess from SQL

On Tue, 4 Apr 2006 23:40:27 -0600, Siegfried Heintze wrote: >Is there an example somewhere of accessing an MSAccess database from a SuSE >or RedHat machine via perl DBI? An Access database is best served on a Windows PC. In my experience, you don't even need to have Access installed for DBI to b

Re: DBD::ASAny

I see no replies to this post, so here goes... On Thu, 26 Jan 2006 15:49:09 +0800, nyem wrote: >I'm using DBD::ASAny on my development machine (win2000) but when I >copied them to the production server (win2003) I got this error: > >install_driver(ASAny) failed: Can't load >'H:/perl/site/lib/aut

Re: Why no [dbi-users] in subject

On Sun, 13 Nov 2005 19:22:49 -0600, Jay Strauss wrote: >How come this list doesn't have a [dbi-users] in the subject? > >That would be handy for message filtering There are various list related headers. For example: List-Id: That's enough for my mail client. -- Bart.

Re: ANNOUNCE:: DBIx::MyParse 0.20

On Sun, 11 Sep 2005 12:38:07 +0300, Philip Stoev wrote: >* Provide the same interface to Postgresql's parser the way it is being done >for MySQL, and at that time "My" in MyParse will no longer stand for MySQL. That sounds like the worst idea for a module name ever. It reminds me of the "My Docum

Re: DBI v2 - The Plan and How You Can Help

On Wed, 17 Aug 2005 10:39:43 +0100, Tim Bunce wrote: >> I think it'll take years, and much actual production experience building >> Perl 6 modules before the community learns what works and what doesn't for a >> Perl 6 API (let alone implementation). So trying to pin down a "properly >> Perl-6-is

Re: Q: Any proven method of exporting data from Postgres as SQL and importing it into MySQL?

On Wed, 03 Aug 2005 14:37:44 +1000, Ron Savage wrote: (nothing) Please put your question in the mail body. A subject line only serves to give an idea what the post is about, now we actually have to read it as a (nontrivial) sentence. And take a look at SQL-Fairy, a project on Sourceforge...

Re: inserting data coming from a hash

On Thu, 21 Apr 2005 09:36:33 -0400, Robert wrote: >This is my hash structure: > >"Veterans Day" => { >date=> '2005', >type=> 'US', >federal => 'true', >active => 'true', > }, > >Would I just use a placeholder (?) in my statement and pass it in via that? Use DBIx::Sim

Re: db or file access?

On Wed, 13 Apr 2005 20:06:44 +1000, Ron Savage wrote: >Well, I thought I'd better put my keyboard where my mouth is, so I wrote an >article on this: > >http://savage.net.au/Ron/html/images-in-files.html I've thought of another aspect which you didn't address in that article, and which can be ver

Re: DBI, MS Access, inserting/updating a Access Date/Time value

On Tue, 12 Apr 2005 23:34:09 -0700, Robb wrote: >Does anyone have any idea what is up with Microsoft Access and its >ridiculous Date/Time formatting options? I am guessing that MS-Access formats dates according to your settings in the "Regional Settings" control panel. -- Bart.

Re: db or file access?

On Wed, 13 Apr 2005 20:06:44 +1000, Ron Savage wrote: >Well, I thought I'd better put my keyboard where my mouth is, so I wrote an >article on this: > >http://savage.net.au/Ron/html/images-in-files.html It would be nice, IMHO, if your site had some sort of blog-like structure, so that people cou

Re: A good Perl Book

On Fri, 25 Mar 2005 21:36:40 +0800, Gav wrote: >what would you recomend as a good book to become an expert of sorts.? You could do worse than looking around at , or even at if you're really new to Perl. -- Bart.

Re: Bug in DBD::Pg 1.32 with bytea columns

Just my two cents... On Thu, 06 Jan 2005 20:31:10 +1300, Sam Vilain wrote: >The design flaw as I see it, is that the common idiom : > > my $sth = $dbh->prepare("SELECT foo from bar where baz = ?"); > $sth->execute($value); > > while ($sth->fetch...) { > ... > } > >Is not a portable a

Re: Is foreign_key_info() generic?

On Wed, 15 Dec 2004 12:46:16 +, Tim Bunce wrote: >> It's one of those things why people say Mysql isn't a proper database. > >This isn't the place to start that particular flame-fest, so I'd >appreciate it if no one does. Sorry, I didn't mean to start a flamefest, honestly. I just wanted to g

Re: Is foreign_key_info() generic?

On Wed, 15 Dec 2004 01:06:38 +0100, Sebastian Riedel wrote: >Does foreign_key_info behave the same for all dbd's? >Especially SQLite and mysql? I never heard people entering foreign key info into Mysql databases. Is that even possible? Ah, yes, only starting with the InnoDB table type. Not with

documentation bugs on LongRealLen

There's a few bugs in the code of the section of LongReadLen, even in the latest version of DBI that is on CPAN. I quote: If you can't be sure what value to use you could execute an extra select statement to determine the longest value. For example: $dbh->{LongR

Re: Announcement/Request for Comments: DBIx::Call

On Fri, 26 Nov 2004 09:36:18 +0900, Thilo Planz wrote: >It used to be called Oracle::Procedures, but since only the current >implementation is Oracle-dependent >and the interface is not (I think, but I really know only Oracle) I >changed the name. I like DBIx::Procedures, with DBIx::Procedures:

Re: Perl Question:

On Fri, 29 Oct 2004 17:18:20 -0600, Reidy, Ron wrote: >Or (from Bart Lateur): > >> my $SQL = 'SELECT * FROM students WHERE id NOT IN (' >> . join ',' , @ids >> . ')' >> ; I'd only ever do that for

Re: DBI Installation Problem on Microsoft Windows.

On Wed, 20 Oct 2004 12:01:31 -0400, Jeff Urlwin wrote: >Or, see http://ftp.esoftmatic.com/DBI 1.45, that's even better. But I don't get it, why the separate subdirectories for the perl versions? All 5.8.x versions are supposed to be binary compatible. (Except for that 5.8.1 lapse, but Activesta

Re: DBI Installation Problem on Microsoft Windows.

On Wed, 20 Oct 2004 11:17:24 +0530, Murthy Pydikondala wrote: >While I am trying to install perl DBI on >Windows 2000 Professional, I am getting the following error after I >executed nmake.exe >'cl' is not recognized as an internal or external command, >Binary build 810 provided by ActiveState C

Re: passing array as subquery to a SQL query

On Mon, 27 Sep 2004 12:26:03 -0700, Jeff Zucker wrote: >> my $SQL = "select * from students where id in (@ids)"; > >Instead use: > > my $SQL = 'SELECT * FROM students WHERE id NOT IN (' > . join ',' , @ids > . ')' > ; > >Because a) you want NOT IN and b) The values

Connection timeout when using Apache::DBI in mod_perl

Is there anything foreseen to disconnect a DBI connection, in a mod_perl (2) setup with Apache::DBI, in case nothing has been requested in several minutes time? Do the connections stay open forever, or does the database timeout all by itself? (I suspect it does, anyway) The only thing I see in Apa

Re: DBD::SQLite: Migration to SQLite 3.0

On Sat, 17 Jul 2004 10:51:55 +0100, Matt Sergeant wrote: >Anyone who has read my journal will know that I now have DBD::SQLite >ported to SQLite 3.0, which provides better datatypes, better >concurrency, proper blob support, etc. I thought you also said SQLite 3 was still very buggy? --

Re: How to insert CR/LF into Sql Server database?

On Thu, 15 Jul 2004 17:53:44 -0400, Bowen, Mark wrote: >I am trying to insert multi-lne data into a text type column in SQL Server. MS says >this can be accomplished with the CHAR(13) & CHAR(10) functions, however I cannot get >these to work in DBI. If I write my text with these functions in

Re: no DBD:MSSQL?

On Tue, 13 Jul 2004 15:47:21 -0400, Janet Goldstein wrote: >Thanks to all who replied. I ended up selling out and using >Win32::ODBC. Eh... why not DBD::ODBC? -- Bart.

Re: Automating binding the parameter type

Here's an example of where specifying the parameter bind type is necessary... at least for me, as I am in a country where the decimal point is not a dot. In MS Access, I have the following query: UPDATE mytable SET info = ? WHERE id = ? The type of info is, in Access terminology, a single

Re: Automating binding the parameter type

On Mon, 19 Apr 2004 14:25:41 -0700, Dean Arnold wrote: >Now I'm confused. Are we talking about the same processing here ? I don't think so. I am talking about fetching the type for the bind parameters for an UPDATE query, out of the TYPE attribute (array ref) for a query SELECT * FROM m

Automating binding the parameter type

I'm working on a next generation of a DBI abstraction module... Sometimes it's necessary to specify the type of placeholder parameter, like use DBI ':sql_types'; $dbh = DBI->connect(...); $sth = $dbh->prepare(...); $sth->bind_param(1, undef, SQL_INTEGER);

Re: DBD::ODBC Connection no longer working

On Mon, 19 Apr 2004 12:08:40 +0200, Bart Lateur wrote: > my $dbh = DBI->connect("ddbi:ODBC:$dsn", "", ""); Oops, sorry for the typo. > my $dbh = DBI->connect("dbi:ODBC:$dsn", "", ""); -- Bart.

Re: DBD::ODBC Connection no longer working

On Mon, 19 Apr 2004 11:56:41 +0200, Bart Lateur wrote: >On Mon, 19 Apr 2004 13:06:26 +1000 (EST), Dennis M. Gray wrote: > >>$dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver >>(*.mdb);dbq=F:/GROUPS/BUSINESS/BSS/safeguards/systems/testing/safeguards_test.md

Re: DBD::ODBC Connection no longer working

On Mon, 19 Apr 2004 13:06:26 +1000 (EST), Dennis M. Gray wrote: >$dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver >(*.mdb);dbq=F:/GROUPS/BUSINESS/BSS/safeguards/systems/testing/safeguards_test.mdb') > or die "Cannot connect to Safeguards Test database"; I doubt that this ever wo

Re: DBI

On Thu, 8 Apr 2004 11:42:41 +1000, Simon Jordan wrote: >What is the equivalent dbi syntax for the following win32:odbc syntax ? > >@FieldNames = $O->FieldNames(); I don't know Win32::ODBC... but I guess you want @FieldNames = @{ $sth->{NAME} }; where $sth is a DBI statement handle for a

modifying RaisError/PrintError for one SQL statement

I've been playing a little with the module Tie::DBI, and I noticed that it died for me, using a DBI handle I provided, on this line: my $sth = $dbh->prepare("LISTFIELDS $table"); (line 376 in the latest Tie::DBI, 0.93) The reason is because I connected using: { RaiseError => 1,

Re: Installing dbish causing problems

On Fri, 2 Apr 2004 10:02:36 +1000 (EST), Dennis M. Gray wrote: >I installed 11.91 and now get this when trying to bring up ppm: > > >D:\>ppm >"break_at" is not exported by the Text::Reform module >Can't continue after import errors at C:/Perl/site/lib/Text/Reform.pm line 43 >BEGIN failed--compilat

Re: getting table structure out of MS-Access

On Wed, 24 Mar 2004 22:37:37 -0500 (EST), David N Murray wrote: >I thought this worked, but when I test it now, I can't get it to work. It works for recent enough versions of DBD::ODBC. More or less. Except that column_info returns NULLABLE true for columns that can't be NULL, doubles (float) ha

getting table structure out of MS-Access

I'd like to automate exporting data out of an existing Access database, using DBI/DBD::ODBC, I guess. I need a proper description of each column in a table, in order to reconstruct a complete CREATE TABLE statement. My guess is that the func() method in DBD::ODBC could help. I've experimented a li

Re: getting rid of the "Issuing rollback()" warning

On Thu, 12 Feb 2004 10:55:56 +, Tim Bunce wrote: >All I'm proposing to change is to add a way for drivers to indicate >if they are in a transaction or not, and then to use that to disable >the warning. That reminds me... I haven't used it in years, but I recall that last time I used DBD::ODBC

Re: getting rid of the "Issuing rollback()" warning

On Tue, 10 Feb 2004 18:10:42 -0500, Andrew Pimlott wrote: >Is there any way to prevent the following from warning "Issuing >rollback() for database handle being DESTROY'd without explicit >disconnect()."? > >use DBI; > >my $dbh = DBI->connect('dbi:Pg:dbname=...', undef, undef, >

Re: old database newbie --bad data in foxpro file?

On Thu, 13 Nov 2003 01:07:45 -0500, Michael Higgins wrote: >map { $total += $_=~m#[\r\f]+#g } @data; This won't do what I think you want it to do. m//g in scalar context will match once or not a t all, but never mutliple times, even if it could match more than once. I think dropping the /g wouldn

Re: DBD module

On Fri, 7 Nov 2003 09:48:12 -0500, Hardy Merrill wrote: >But this doesn't work - just comes back to the command prompt >without printing anything: > > perl -MDBD::mysql -e "print $DBD::mysql::VERSION" Just enable warnings, and you'll see why it doesn't work. perl -MDBD::mysql -lwe "print $D

Re: DBD module

On Fri, 7 Nov 2003 03:17:45 -0800 (PST), Michael A Chase wrote: >You can usually find the version of a module with something like: > > perl -MDBD::xyz -e "print $DBD::xyz::VERSION" # UNIX > perl -MDBD::xyz -e 'print $DBD::xyz::VERSION' # MSWin Reverse that. Doiuble quotes for windows, single

Re: Better way to get column names with values?

On Tue, 23 Sep 2003 09:37:42 +1000, Fox, Michael wrote: >If you are not worried about the order in which the columns come back, you >could select straight into a hash and save a few lines of code Or blend the two aproaches, use $sth->{NAME} to get an array of names in the proper order, and use a

Re: What to do with UTF-8 data?

On Thu, 11 Sep 2003 12:31:52 +0100, Steve Hay wrote: >It would be cool if something akin to "binmode STDOUT, ':utf8';" could >be applied when sending data to the driver -- i.e. my data is in "Perl's >internal format", whether that be Latin-1 or UTF-8 in the case of the >string at hand, and it a

Re: What to do with UTF-8 data?

On Wed, 10 Sep 2003 10:40:29 +0100, Steve Hay wrote: >But the question was: How can I arrange for such conversions to be >performed automatically by DBI whenever it receives or returns data? Well, there are two options... either does the dtabase somewhere stores the flag indicating that some str

Re: What to do with UTF-8 data?

On Wed, 10 Sep 2003 08:33:03 +0100, Steve Hay wrote: >And when I retrieve the data (again >without conversion) I just get octet sequences into my Perl scalars - >not flagged, UTF-8 character strings as I would like. If you're *sure* that this is UTF-8, only perl doesn't flag it as such, you can

Re: MySQL LIMIT statement

On 29 Jul 2003 19:08:23 +0100, Dan Rowles wrote: >2) Does anyone know if there's a way of getting the DBI to revert to >it's old behaviour of not automatically quoting placeholder-values? So MySQL cares now, does it? I'm still on MySQL 3.x, and I know that there you may quote any type of field,

Re: MySQL LIMIT statement

On 29 Jul 2003 19:08:23 +0100, Dan Rowles wrote: >To go through and change all of these methods to do a >"$sth->bind_param(n, $val, SQL_INTEGER)" is a lot of work! Er, you don't have to. It's the first occurrence of using a value for some placeholder that defines how it'll be used further on. So

Re: Make dbi socket.h errors....

On Mon, 28 Jul 2003 10:37:08 +0200, <[EMAIL PROTECTED]> wrote: >anybody can help me whats the problem of dbi installation on my hpux >workstation with HPUX 11.11??? >Could it be that perl is compiled with ansi/c and the dbi uses gcc? If you're using a perl that was preinstalled on your system, i

Re: RFC: SQL Extensions for SQL::Statement [Long]

On Wed, 04 Jun 2003 09:15:28 -0700, Jeff Zucker wrote: > For per-table connections > - > CONNECT TO '$dsn1' AS tbl1 > CONNECT TO '$dsn2' AS tbl2 Euh... you connect to a database, not to a table, no? -- Bart.

Re: RFC: SQL Extensions for SQL::Statement [Long]

On Thu, 5 Jun 2003 10:50:45 +0100, Tim Bunce wrote: [quoting from the root message:] >> >> SELECT $cols FROM tbl1@"$dsn1" ... JOIN tbl2@"$dsn2" ... >I think we're very much in the realms of inventing our own syntax here. >We're just using 'standard sql' as a guide for everyones sanity. FWIW

Re: DBI Newbie

On Mon, 24 Mar 2003 05:45:59 -0800, Barlow, Neil wrote: >That's is correct - I am attempting to connect a MS SQL7 DB that is not >located on the Webserver. You could start by using Windows' ODBC Data Sources control panel to create a (system) DSN. Next, all you have to do is use the DSN name in y

Re: How do I respond to a thread?

On Sat, 01 Mar 2003 12:02:15 -0800, G S wrote: >I have been posting messages here by emailing to [EMAIL PROTECTED] Is >there a way to post messages so that they are part of an ongoing thread? Select "reply" to respond. Make sure "[EMAIL PROTECTED]" is amongst the recipients. That's it, basica

Re: Strange security problem...

On Fri, 28 Feb 2003 20:21:29 -0500, Cory Rau wrote: >I >purposely mistyped the url with 'cgi-bin' rather than what it actually >is, 'CGI-BIN' just to see what would happen. I ended up getting the >entire *code* of the perl script in my web browser This is OT for perl-DBI, but... I think that

Re: How to Connect MSSQL Server from a Linux machine using Perl

On 8 Feb 2003 11:58:56 -, Jeyaraj wrote: >I am new to this environment I don't know how to establish connection >to SQL Server from Linux machine using Perl Pls help me in this >issue It's a FAQ: See questions 4 through 7. --

Re: platform independence and ISNULL/nolock with MsSQL?

On Sun, 2 Feb 2003 13:20:38 +0100, alex wrote: >i ask myself how to prog my select statments platform independend if i need >ISNULL function on varchar fields in MsSQL2K... this will not work on a move >to MySQL and so on... I don't know for sure about MS-SQL, but this works in MySQL: S

Re: What's with ?

On Wed, 15 Jan 2003 11:08:24 -0700, Sterin, Ilya wrote: >Matt Sergeant is hosting xmlproj.com on his AxKit server. That server is >down as well, maybe he's upgrading or something, I'll ping him in a bit. Ah, OK, now I see. See Matts' journal on . From what I gather, his own

What's with ?

I tried to check out some of the latest modules for Windows, using the URL . (I tried "www.xmlproj.com", too.) After some time, I get a DNS lookup error. It looks like this domain has expired. If so, can anyone tell where the modules that were available there, have moved

Re: DBI/ODBC for windows

On Wed, 15 Jan 2003 11:20:54 -0500, Jeff Thies wrote: > Shared Hosting win2000 server, with an unresponsive tech staff. > I understand that there is a pure perl version of DBI. Is there a way >to install DBD::ODBC just having FTP? The last win server I was able to >PPM install. Yes. Install i

Re: selecting a range of records from my result set

On Mon, 06 Jan 2003 09:59:41 -0700, Ian Harisay wrote: >In mysql is it possible to retrieve records 50-75 from your result set? Yes. Add a "LIMIT" clause to your SELECT statement. SELECT * FROM table LIMIT 50,25 It works well from within DBI (but don't append the semi-colon at the end o

Re: but it is not intended for this build of Perl (MSWin32-x86-multi-thread) error

On Thu, 2 Jan 2003 17:09:56 +0800, pevee wrote: >Now, I got the "but it is not intended for this build of Perl >(MSWin32-x86-multi-thread)" >I am using ActivePerl-5.6.633-MSWin32-x86.msi and DBI from ActivePerl 5xx >(e.g. ActivePerl522) ActivePerl 5.005 and 5.6.x are not biunary compatible. The P

Re: Error installing package 'DBD-Proxy': Could not locate a PPD file for package DB

On Tue, 31 Dec 2002 14:52:41 +0800, pevee wrote: >I am lookign for Comm.pm module, anyone knows where I can find it? > > >DBI-1.32]# Can't locate RPC/PlServer/Comm.pm in @INC (@INC contains: You must interpret the error message correctly. It's not Comm, but RPC::PIserver::Comm you're looking for.

Re: Invalid Precision error

On Mon, 30 Dec 2002 00:12:40 -0500, Jeff Thies wrote: >> I'm getting a weird error when I try to update a text field (Access, >> latest ODBC and DBI) sometimes: > >This is a placeholder problem. Changing the script so the affected field >is not a placeholder eliminates the problem. ie: set text_fi

Re: Access and placeholders

On Fri, 20 Dec 2002 01:14:43 -0500, Jeff Thies wrote: > I've used my usual insert using placeholders and got an error about a >count mismatch. Does Access not support placeholders? It does. But you'll get this confusing error message when using a field name that Access doesn't recognise. Apparent

Re: Nested prepares

On Wed, 18 Dec 2002 09:49:28 -0500, John Day wrote: >I would like to rewrite an application using DBI, DBD and mySQL so that >I can prepare a several statements once using placeholders and then >execute them within a loop without re-preparing them. I just don't get why you call these "nested". Th

Re: DBD::SQLite win32 binary

On Fri, 13 Dec 2002 22:36:31 -0800, Bill Kurland wrote: >Does anyone know of a source for a win32 binary of DBD::SQLite? Any leads >are much appreciated. A "source"? Do you mean the source code, or a location whjere you can download a binary from? For the latter, version 0.17 (while the version o

Re: SQL_LONVARBINARY question

On Fri, 06 Dec 2002 06:50:57 -0500, Brad Smith wrote: >I was just looking at the 'longbin.pl' test script that is bundled with >DBD::ODBC, which has raised a few questions: Hmm... I don't seem to have it, but I could find it on CPAN.

Re: Subtle binding bug

On Thu, 28 Nov 2002 11:29:04 +, Tony Bowden wrote: >> I don't know how MySQL handles placeholders, so this is just a guess. It >> may simply be interpolating the string 'nine' into the query string, in the >> same way it interpolated the number 9, that is, without qotes: >> INSERT INTO user

Re: Table Names

On Wed, 27 Nov 2002 08:07:39 -0500, Chris Rogers wrote: >Thanks to all. I never imagined that I could simply issue standard sql >statements. I prepared and executed "DESCRIBE tablename" with a >fetchrow_hashref. It returned a nice hash reference containing all the >information I see when I exec

Re: execute and null values in quote

On Thu, 21 Nov 2002 15:12:47 -0800, Daniel Olson wrote: > $sth = $dbh->prepare("insert into ul_info >(ul_id,ul_len,ul_wid,ul_dep,ul_tun,ul_sin,ul_und,ul_und_fr,ul_und_to,ul_edge,ul_stat,ul_skin,ul_drain_typ,ul_drain_amt,ul_drain_col,ul_drain_od,ul_stage,timestamp,clinician) > values (?,?,?,

Re: execute fails in loops only

On Mon, 18 Nov 2002 11:11:47 -0800 (PST), Michael A Chase wrote: >I'm not sure about Access, but some underlying databases don't like >multiple statements open at the same time on a single database handle. >Just for testing, try opening separate database connections for each >statement and see if

Re: execute fails in loops only

On Mon, 18 Nov 2002 12:44:44 -0500 (EST), Paul Boutros wrote: >Now, that sub function, process($$$) checks the input parameters and >chooses the correct statement-handle based on that. For instance: > >if ($_[0] == 532) { > if ($_[1] eq 'A') { > $sth = $sth_crosstab_all; >

Re: How to use DBI to connect to MS Access?

On Thu, 14 Nov 2002 15:51:07 -0500, Changhong Tang wrote: >But I get this error: >install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC(@INC You don't have DBD::ODBC installed. >How do I tell if DBD::ODBC perl module is fully installed? >I do have these files: >c:/Perl/lib/Win32/Odbc.pm

Re: Checking userid before inserting into database

On Thu, 7 Nov 2002 15:07:09 -0600 , Nguyen, David M wrote: >I am writting a script using DBI::Oracle to insert user account into >database, before inserting I need to verify to make sure userid is not >already existed. I have script written, ran it but nothing seems happen. >Can someone look into

Re: timeout, disconnect on DBD Oracle 9i causes ORA internal error

On Wed, 23 Oct 2002 16:54:25 +1000, Mike McCauley wrote: ># Run this for a few secs, then unplug from the network. ># the execute times out,tries ># to disconnect, get internal error If you pull the plug, the disconnect() cannot possibly work either. -- Bart.

Re: relationship of dbi dsn to uri?

On Mon, 21 Oct 2002 10:02:44 +0100, Tim Bunce wrote: >Anyone interested in following the procedures to get a "dbi:" scheme >registered? (I don't have the time, though I'd be very happy to see it done.) My question is: why? What good would it do to us? I just can't imagine anything. -- B

Re: problem compiling dbd-oracle 1.12 on win32

On Wed, 16 Oct 2002 00:56:11 -0700, Knut Herzog wrote: >the perl I use is delivered with Oracle HTTP webserver. I am pretty sure I will never >find out what compiler Oracle used. You can try `perl -V`. -- Bart.

Re: existance of a select statement

On Thu, 26 Sep 2002 21:46:16 +0100, Tim Bunce wrote: >If that may happen then it's safer to try the insert first and if that >fails due to a duplicate key then do the update. At least MS Access has the problem that an autoincrement field (or whatever it is called in Access) IS incremented even i

Re: How to execute file containing sql statements using dbi.

On Thu, 19 Sep 2002 15:10:50 -0700 (PDT), Arvind Raina wrote: >My requirement is to execute a set of sql statements which are stored in a file . > >I wanted to know if there is any method of doing the same using dbi . > >If not can you suggest some methods of doing the same. What database? If it

Re: doubt

On Mon, 2 Sep 2002 20:32:28 +0530 , Agarwal, Ramakant wrote: > I want that if someone kills the process while the script is in >execution then it should log off from the database and then should exit. >Does the log off from the db happen automatically whenever a process is >killed or we do need t

Re: dbi perl

On Fri, 30 Aug 2002 15:44:54 -0700 (MST), Michele Francis wrote: >Is there a good dbi with perl book? Thanks. Can one somehow miss the plug on the DBI's official homepage? Yes it's a good book. In a way, it's the docs that come with DBI, plus some; but yet, it of

Re: Installing DBI without shell or PPM

On Wed, 21 Aug 2002 15:13:49 -0700, Jim Clark wrote: >I know this isn't the best way to move modules between machines but my >options are limited. Can anyone help point me to what files I may be >missing or what else I may need to do to update the web server to use >these files? Check for the DL

  1   2   3   >