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: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: Sql or Sybperl advice needed
Date: Jun 19 2002 2:28PM

On Tue, 2002-06-18 at 19:11, Matthew O. Persico wrote:
>  
> Or what about:
>  
> select
>    Prod_ID, Account_Type, Rate_Code, Product_Line, Wt_Min, Wt_Max
> from
>    info_table
> where
>      @acct_type = isnull(Account_Type,@acct_type)
> and  @rate_code = isnull(Rate_Code,@rate_code)
> -- ditto for Product_Line
> and     @weight bewteen isnull(Wt_Min,@weight) 
>                     and isnull(Wt_Max,@weight)
> order by --all the columns, either asc or desc, whichever puts the NULL row AFTER the non-nulls

Neat idea - you can use isnull() in the order by clause to achieve the
correct order.

> 
> Then just use the Sybperl equivilent of DBI's selectrow_array() if there is one. If not, fetch one row and cancel the query. You should then have your data.

That's just a normal fetch (ct_fetch() for Sybase::CTlib)

Michael
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!