Re: DBI-quote with DBD::Sysbase

2004-04-10 Thread Tim Bunce
On Fri, Apr 09, 2004 at 01:12:14PM -0400, Chris Faust wrote: Hello, I'm using the combination of DBI, DBD::Sysbase and FreeTDS to connect to an MS-SQL server. Due to the issues with placeholders and sp's (specifically not being able to use them), I'm forced to properly deal with any

Re: Accessing large CSV files

2004-04-10 Thread Michael Gerdau
Is there a buildin limit on the number of records DBD::CSV can handle ? There is no built in limit. Yours is the first report I've had of the problem. My guess is that in most situations for files of that size you'd be better off loading them into into SQLite and doing your querying

Do DBI or DBD::Sybase strip spaces from padded VARCHARs?

2004-04-10 Thread ndronen
Hi, (I posted this to perl.dbi.users, which probably doesn't get much traffic, being an archive and all, so I'm trying the list itself.) I'm using DBD::Sybase 1.02 and DBI 1.42. The stored procedure writer here is telling me that she's sending a VARCHAR that's padded with spaces, but the spaces

Re: Accessing large CSV files

2004-04-10 Thread Tim Bunce
On Sat, Apr 10, 2004 at 12:27:35PM +0200, Michael Gerdau wrote: Is there a buildin limit on the number of records DBD::CSV can handle ? There is no built in limit. Yours is the first report I've had of the problem. My guess is that in most situations for files of that size you'd be

Re: DBI-quote with DBD::Sysbase

2004-04-10 Thread Tim Bunce
On Sat, Apr 10, 2004 at 06:24:35AM -0400, Chris Faust wrote: Do double quotes really need to be doubled when embedded within a single quoted string? In other words, isn't 'foobar' correct for Sybase? Are you quoting literal strings or schema identifiers? Thanks for the reply Tim, I'm

DBI and my.cnf socket file different

2004-04-10 Thread JupiterHost.Net
Hello Group, Via the command line I can connect to MySQL and do what I want fine. Via DBI I get the classic Can't connect to local MySQL server through socket '/tmp/MySQL.sock' (2) So MySQL seesmt to not be running but it is! The socket is '/usr/local/MySQL/run/MySQL_socket' and is setup that

Re: Do DBI or DBD::Sybase strip spaces from padded VARCHARs?

2004-04-10 Thread Michael Peppler
On Sat, 2004-04-10 at 11:51, [EMAIL PROTECTED] wrote: I'm using DBD::Sybase 1.02 and DBI 1.42. The stored procedure writer here is telling me that she's sending a VARCHAR that's padded with spaces, but the spaces aren't there when I retrieve them with fetchrow_arrayref. When a varchar()

Re: DBI-quote with DBD::Sysbase

2004-04-10 Thread Michael Peppler
On Sat, 2004-04-10 at 03:24, Chris Faust wrote: Do double quotes really need to be doubled when embedded within a single quoted string? In other words, isn't 'foobar' correct for Sybase? Are you quoting literal strings or schema identifiers? Tim. Thanks for the reply Tim, I'm