how to parse field properties

2002-04-27 Thread oguz haslak
hi my name is oguz i am trying to parse field properties (using mysql) but get blob instead of text $type_of_field = $sth->[mysql_type_info]->[int]; __ Free Email - http://www.lycos.co.uk

Re: Problem with DBD::Pg and $sth->{pg_type}

2002-04-27 Thread Jeffrey Baker
On Tue, Apr 23, 2002 at 03:54:49PM -0400, Jeff Boes wrote: > I've encountered a problem with the statement handle's pg_type > attribute, under DBI 1.21 and DBD::Pg 1.12. > [...] > If you run this, you'll get some unprintable output from the first print > statement, and the second print causes a se

Re: General Any::Data questions

2002-04-27 Thread Jeff Zucker
Jeff Thies wrote: > > After trying for a week to get the DBD::mysql driver loaded in FreeBSD > (couldn't find DBI during install) virtual server I thought I'd try > DBD::AnyData. > > Much to my surprise, I could do this: > my $sql='create table table1(field1 varchar(12),field2 varchar(12))';

General Any::Data questions

2002-04-27 Thread Jeff Thies
After trying for a week to get the DBD::mysql driver loaded in FreeBSD (couldn't find DBI during install) virtual server I thought I'd try DBD::AnyData. Much to my surprise, I could do this: my $sql='create table table1(field1 varchar(12),field2 varchar(12))'; Are any other data types suppor

Re: fetchall_arrayref contents

2002-04-27 Thread BAO RuiXian
How about the following: foreach my $row_ref (@{$array_ref}) { print @{$row_ref}, "\n"; } The above loop will print all the rows, each row has its own line, and there is no space between two values in a row though. Bao Brad wrote: > I've been struggling with this and getting n

fetchall_arrayref contents

2002-04-27 Thread Brad
I've been struggling with this and getting nothing but gibberish. my $array_ref=$sth->fetchall_arrayref() I can't get anything out of $array_ref though, I can't work out how to manipulate it. The query was "select filename, size, score from files where codeID=\"".$codeID."\" which should return