On Fri, 2004-04-30 at 20:37, Chuck Fox wrote: > [EMAIL PROTECTED] wrote: >
> >Note that Sybase (via DBD::Sybase) will NOT accept a placeholder (?) > >that does not directly refer to a column, so using something like > > where isnull(?, '~') ... > >won't work. Similarly the code snippet mentioned in the DBI docs to > >handle NULL parameters > > where foo = ? or (? is null and foo is null) > >will NOT work, because Sybase's API can't figure out what type the > >second ? refers to. > > > >Ah the fun of writing portable SQL... :-) > Personally, I prefer stored procedures, but I can understand how that > portability thing can get in the way :-) Oh, me too, for lots of reasons (maintainability and performance being the main points from my DBA perspective)... Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.peppler.org/ Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.peppler.org/resume.html
