perl dbi sybase number of columns?

[jcharth]

hello i am using perl dbi with sybase, i know that in php is easy to
find out the number of columns with any sql query. is there a way to
know how many values are stored in the array that stores the result of
the query? any code samples? thank.s

 

[DJ Stunks]

hello i am using perl dbi with sybase

The whole point of the DBI is to (and I quote) "provide a consistent
database interface, independent of the actual database being used."
Therefore it is entirely unimportant that you are querying a Sybase
database.

i know that in php is easy to
find out the number of columns with any sql query.

Isn't PHP great?

is there a way to
know how many values are stored in the array that stores the result of
the query? any code samples? thank.s

did you read the documentation for the module you're trying to use? or
did you think it would be easier to have us read it to you?

perldoc DBI

hint: pay particular attention to the section on "Statement Handle
Attributes"

-jp

PS: I've got $5 that says the response to this message will have no
context at all or will be a top post. I can feel it!

 

[jcharth]

Thanks guys, yes php is great. I got it with

foreach (@row){
print "$_ ,"

 

[DJ Stunks]

Thanks guys, yes php is great. I got it with

foreach (@row){
print "$_ ,"

lmao

I think you all owe me $5. please make cheques or money orders payable
to DJ Stunks

-jp