Re: Reviewing Rows from MSSQL SELECT statement

by Nevtlathiel (Friar)

on Jun 08, 2005 at 08:50 UTC ( [id://464593]=note: print w/replies, xml )

Need Help??

Update: Whoops, my bad, that'll teach me not to read the question properly. VSarkiss is correct and thanks for pointing it out :)

my $sth = $dbh->prepare("SELECT * FROM $table");
$sth->execute;
while (my $array_ref = $sth->fetch) {
    #
    #do something
    #
}
[download]

And if you're not you should probably check that your query executes too :)

----------
My cow-orkers were talking in punctuation the other day. What disturbed me most was that I understood it.

Comment on Re: Reviewing Rows from MSSQL SELECT statement Download Code

Replies are listed 'Best First'.
Re^2: Reviewing Rows from MSSQL SELECT statement by VSarkiss (Monsignor) on Jun 08, 2005 at 13:38 UTC
Did you notice the OP is asking about MSSQL::Sqllib and not DBI? Your reply (which doesn't make the distinction clear) may only confuse the issue. Do not rebuke them with harsh words ... but rather lead them gently - with URLs - so that they may learn wisdom.	[reply]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://464593]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others cooling their heels in the Monastery: (5)

As of 2024-04-25 04:48 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found