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: "Saxena, Arun" <arun dot saxena at csfb dot com>
Subject: RE: General question
Date: Jul 2 1999 5:49PM

This fails  when I use stored procs
instead.

$sql  = "ProcA  host=A";
$sql2 = "ProcA host=B";

The error message  is "ProcA is not arecognized paramter option"

Arun

> -----Original Message-----
> From:	Michael Peppler [SMTP:mpeppler@peppler.org]
> Sent:	Friday, July 02, 1999 11:27 AM
> To:	SybPerl Discussion List
> Subject:	Re: General question
> 
> Saxena, Arun writes:
>  > 
>  > I am doing the folowing, but does not seem to work..
>  > 
>  > $sql = "select ....";
>  > $sql2 = "select...";
>  > 
>  > $syb_login->dbsqlcmd($sql);
>  > $syb_login->dbsqlcmd($sql2);
>  > $syb_login->dbsqlexec;
>  > $syb_login->dbresults;
>  > 
>  > Am I doing somethinh wrong ?
> 
> well, you need to call dbresults() in a loop, because you're executing 
> two SELECT statements.
> 
> you should use something like:
> 
> while($syb_login->dbresults() != NO_MORE_RESULTS) {
>     while(@data = $syb_login->dbnextrow) {
> 	... # do something with the @data from the select
>     }
> }
> 
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com