RE: How to insert a question mark?

2002-12-01 Thread Sterin, Ilya
That's definitely a bug. For now, try to escape it with \?, or if that doesn't work, then try using a placeholder ? and then bind 'val?' to it. Ilya -Original Message- From: Anton Pitts To: [EMAIL PROTECTED] Sent: 12/1/02 11:16 PM Subject: How to insert a question mark? I'm running post

RE: Connecting to MS Access

2002-12-01 Thread Sterin, Ilya
Tom, no longer it is there:-) That was my home server, and I no longer maintain it, it's now on a better server at www.xmlproj.com/cgi/fom.cgi DBI FAQ (www.xmlproj.com/cgi/fom.cgi) Ilya -Original Message- From: Thomas A. Lowery To: DBI List Sent: 12/1/02 5:19 PM Subject: Re: Connecting

How to insert a question mark?

2002-12-01 Thread Anton Pitts
I'm running postgresql 7.3, perl 5.6.0, DBI 1.30 on mac os x 10.2 and am having trouble with inserting values ending in a question mark. I first tried interpolating the value into a query string: $dbh->do("INSERT INTO ref (citekey, title) VALUES ('why?', 'bob')"); This doesn't raise an error, b

Re: DBI-Performace-Problem

2002-12-01 Thread Jared Still
It can be. Even a soft parse requires a latch in the database SGA, and since all latches are serialized, it could be a problem in a busy system. I am far from the expert in parsing and latching, but i do plan to run some tests comparing standard (easy) and DBMS_SQL (somewhat hard) cursors in PL/

Re: Connecting to MS Access

2002-12-01 Thread Thomas A. Lowery
See FAQ: See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom On Sun, Dec 01, 2002 at 12:01:50PM -0600, Mike(mickako)Blezien wrote: > I'm sure this must have been discussed many time in the past, but I just > need to get some refresher information or directions. I believe data can be -- Thomas A.

Re: Paradox

2002-12-01 Thread Michael A Chase
On Sun, 1 Dec 2002 16:30:15 -0500 Brian Spindler <[EMAIL PROTECTED]> wrote: > I need to know how to compare dates in a paradox database. I am using perl, > dbi and odbc to access the paradox tables, but everything I use in my select > statement returns a "missing operator/bad syntax" Can someon

ANNOUNCE: DBI 1.32

2002-12-01 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.32.tar.gz size: 277594 bytes md5: 5a6b8fb4433da1a9363a0b2ab1d6f21e =head2 Changes in DBI 1.32,1st December 2002 Fixed to work with 5.005_03 thanks to Tatsuhiko Miyagawa (I've not tested it). Reenabled taint tests (accidentally left disabled) s

CPAN Upload: T/TI/TIMB/DBI-1.32.tar.gz

2002-12-01 Thread PAUSE
The uploaded file DBI-1.32.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.32.tar.gz size: 277594 bytes md5: 5a6b8fb4433da1a9363a0b2ab1d6f21e No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Sun, 01 Dec 2002 23:00:33 GMT Re

Paradox

2002-12-01 Thread Brian Spindler
Guys/Gals, I need to know how to compare dates in a paradox database. I am using perl, dbi and odbc to access the paradox tables, but everything I use in my select statement returns a "missing operator/bad syntax" Can someone please explain. Thank you in advance! Brian

Re: FAIL DBI-1.31 MSWin32-x86-multi-thread 4.0

2002-12-01 Thread Tim Bunce
Seems like a flawed test: assuming that the cost of the method call would always be measurable on any platform. I'll change it. Thanks. Tim. On Sun, Dec 01, 2002 at 04:17:47AM +, [EMAIL PROTECTED] wrote: > This distribution has been tested as part of the cpan-testers > effort to test as man

Re: DBI-Performace-Problem

2002-12-01 Thread Tim Bunce
Thanks. So the next question... Is an extra soft parse a significant overhead? (For some value of 'significant' :) Tim. On Thu, Nov 28, 2002 at 06:23:11PM -0800, Jared Still wrote: > > The first parse is a 'hard' parse. This is the parse that > checks for existance of tables, privileges, and

Re: FAIL DBI-1.31 i686-linux 2.4.20-pre7

2002-12-01 Thread Tim Bunce
Thanks! By commenting out the unlink at the end of the test I can see that my dbi.prof file looks like this: --snip-- DBI::ProfileDumper 1.0 Path = [ DBIprofile_Statement, DBIprofile_MethodName ] Program = t/42prof_data.t + 1 + 2 FETCH =1 0.000117 0.000117 0.000117 0.000117 103877602

Re: Subtle binding bug

2002-12-01 Thread Tim Bunce
On Sun, Dec 01, 2002 at 06:17:48PM +, Tony Bowden wrote: > On Fri, Nov 29, 2002 at 12:33:42PM +0100, Bart Lateur wrote: > > I hadn't looked at this thread until now, but now that I do, I do > > recognize the pattern. I've had the same kind of problems with Access. > > What can fix this, is havi

Re: Subtle binding bug

2002-12-01 Thread Tony Bowden
On Fri, Nov 29, 2002 at 12:33:42PM +0100, Bart Lateur wrote: > I hadn't looked at this thread until now, but now that I do, I do > recognize the pattern. I've had the same kind of problems with Access. > What can fix this, is having an explicit bind on the variable type, > after the pepare phase, b

Re: "SQL Injection" attacks - database security issues

2002-12-01 Thread Jared Still
You may also be interested in several papers on SQL Injection available at: http://www.nextgenss.com/research/papers.html These refer to SQL Server, but much of it is relevant for any database. Jared On Friday 29 November 2002 03:18, Tim Bunce wrote: > An interesting article on SQL Inje

Connecting to MS Access

2002-12-01 Thread Mike(mickako)Blezien
Hello all, I'm sure this must have been discussed many time in the past, but I just need to get some refresher information or directions. I believe data can be entered into a MS Access database, via Perl and DBI, but not real sure how this is done. I would be much appreciative if someone could

DBI 1.31 broken on perl5.005_03 (was: ANNOUNCE: DBI 1.31)

2002-12-01 Thread Tim Bunce
Excellent. Many thanks. (I wasn't able to test on 5.5.3 before release as it no longer builds on FreeBSD.) I'll make a new release soon. Tim. On Sat, Nov 30, 2002 at 03:34:09PM +0900, Tatsuhiko Miyagawa wrote: > DBI 1.31 can't compile with perl 5.005_03. Patch applied. I know > there's a plan t

FAIL DBI-1.31 i686-linux 2.4.20-pre7

2002-12-01 Thread Conrad Heiney
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- This is an error report ge