Re: why my compile failed

2002-08-15 Thread Jonathan Leffler
Levine, Peter wrote: > Hi, > > I found the cause of my problem compiling the DBI module. > > DBIXS.h:347: stray '\' in program > DBIXS.h:391: parse error before `}' > DBIXS.h:427: parse error before `=' > DBIXS.h:427: stray '\' in program > DBIXS.h:428: stray '\' in program > DBIXS.h:429: stray

ANNOUNCE: DBD::Chart 0.71

2002-08-15 Thread Dean Arnold
DBD::Chart 0.71 is now available at www.presicient.com/dbdchart, and should be available on CPAN shortly. DBD::Chart is a Perl DBI driver that uses a simple SQL syntax to render graphs and charts. Version 0.71 includes the following features/fixes: - fixed LINEWIDTH property to be applied to in

VARRAYS with DBD::Oracle.

2002-08-15 Thread vanHardenbergP
Greetings, I'm working on putting together an oceanographic database, and I'd like to use DBI to pull and submit datasets. The datasets are stored in an Oracle8i database in a table called Channel. Channel has four columns: datasetid -> a pointer to a parent table (there are several cha

Re: Off topic question on data modeling tools

2002-08-15 Thread Steven Lembark
> http://search.cpan.org/author/DROLSKY/Alzabo-0.68/lib/Alzabo.pm http://www.alzabo.org/ is a better place to start. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762

Re: Off topic question on data modeling tools

2002-08-15 Thread Kevin Spencer
Ian Harisay wrote: > Is anyone out there using a RDBMS data modeling tool on Linux. I haven't used it personally but you could take a peek at Dave Rolsky's Alzabo. I hear good things about it :-) http://search.cpan.org/author/DROLSKY/Alzabo-0.68/lib/Alzabo.pm -- Kevin.

why my compile failed

2002-08-15 Thread Levine, Peter
Hi, I found the cause of my problem compiling the DBI module. DBIXS.h:347: stray '\' in program DBIXS.h:391: parse error before `}' DBIXS.h:427: parse error before `=' DBIXS.h:427: stray '\' in program DBIXS.h:428: stray '\' in program DBIXS.h:429: stray '\' in p Maybe this can help you. My UN

Re: Off topic question on data modeling tools

2002-08-15 Thread Tom
Ian Harisay wrote: > Hi, > > Is anyone out there using a RDBMS data modeling tool on Linux. I've > looked around but haven't found anything. Data Architect from theKompany (www.thekompany.com) looked nice. I haven't used it though. I did a search of modelling tools last year, and this was

Off topic question on data modeling tools

2002-08-15 Thread Ian Harisay
Hi, Is anyone out there using a RDBMS data modeling tool on Linux. I've looked around but haven't found anything. Thanks in advance for the help. -Ian

RE: ODBC and SQL Server, return value from stored procedure

2002-08-15 Thread Jeff Urlwin
Yes, from around .3x, but for the best support so far and, what I believe to be the most bug free, try the latest (0.45_14). In that archive are some examples, both in t/20SqlServer.t and mytest/*. If there are no bugs reported in that version, I'm going to re-release it as ..5 or even 1.0... T

DBD:ODBC and SQL Server, return value from stored procedure

2002-08-15 Thread Roger Perttu
Hi, I need the return value from a stored procedure. Usually I do like this: $sth = $dbh->prepare('Declare @RETURN_VALUE int; exec @RETURN_VALUE=some_procedure @param0=?, @param1=?; select @RETURN_VALUE') but that will result in multiple result sets and in this special case I can't handle

Re: Escaping sql strings

2002-08-15 Thread Michael A Chase
On Thu, 15 Aug 2002 10:03:07 -0400 "Vorce, Tim (T.)" <[EMAIL PROTECTED]> wrote: > This is a bigger problem than I thought. I am constructing a sequence for a > stored procedure. I'm getting in several values, and constructing the call > to the stored procedures. I thought that oracle would sup

RE: Escaping sql strings

2002-08-15 Thread Vorce, Tim (T.)
This is a bigger problem than I thought. I am constructing a sequence for a stored procedure. I'm getting in several values, and constructing the call to the stored procedures. I thought that oracle would support placeholders, but that is not working. So what I have is several variables (and t

RE: Escaping sql strings

2002-08-15 Thread Gordon . Dewis
How about... $sql="select * from table where column=?"; $sth=$dbh->prepare($sql); $sth->execute(qq/What you're looking for/); Gordon Dewis Production Officer Geography Division Statistics Canada (613)951-4591 -Original Message- From: Vorce, Tim (T.) [mailto:[EMAIL PROTECTED]] Sent: T

Re: Escaping sql strings

2002-08-15 Thread Hardy Merrill
Tim, read the perldocs on placeholders by doing perldoc DBI at a command prompt, and search(with the "/" forward slash) for "placeholder". Using placeholders has many advantages, one of which is properly quoting data to be inserted into the database - so that you don't have to worry about it

Escaping sql strings

2002-08-15 Thread Vorce, Tim (T.)
Currently, I pass in sql strings as a quoted string, and single quotes around variables like this: $sql="select * from table where column='$code' "; I now am encountering data that contains a single quote - so that won't work. How do you suggest passing this in Tim Vorce Ford Motor Compan

Re: stored function DBI::Pg

2002-08-15 Thread Thomas A. Lowery
Pg function testme() $func_call = 'select testme()'; $dbh->do( $func_call ); or $res = $dbh->selectall_arrayref( $func_call ); or $sth = $dbh->prepare( $func_call ); $sth->execute; The type of call depends on the results of the function. Tom On Wed, Aug 14, 2002 at 10:42:17PM +0200, Som