PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Pete Walker <walker_pete at jpmorgan dot com>
Subject: Re: Silently failing query
Date: Mar 11 1996 6:02PM

Tim,

You are calling select twice so you are getting 2 sets of results.

Your call to dbnextrow is returning the first set which has no rows in
it (the result of select  \@tdate = '$date1'.

If you call dbresults again then you should get your date.

Cheers,

Pete.