NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
use Perl Log In
runrig (3385)
runrig
dougwNO@SPAMcpan.org
dougwNO@SPAMcpan.org
Just another perl hacker somewhere near Disneyland
I have this homenode [perlmonks.org] of little consequence on Perl Monks [perlmonks.org] that you probably have no interest in whatsoever.
I also have some modules [cpan.org] on CPAN [cpan.org] some of which are marginally [cpan.org] more [cpan.org] useful [cpan.org] than others.
Thursday March 08, 2007
09:05 PM
Sybase annoyances/quirks
New job, new database, new annoyances to get over. Same ol' same ol'.
- Default datetime format not ISO format.
- Datetime to char conversion function doesn't have ISO as a choice (but lots of others)
- Table and column names are case sensitive ("select foo" ne "select FOO").
- ODBC driver prepares statements, but barfs after executing a few times.
Updating the ODBC driver might fix the problem (Data type for parameter x has changed since first SQLExecute call), but it's a commercial driver, I don't have admin rights on my pc, and I'd have to get the planets aligned first.
And, writing an "iso_format(datetime)" stored procedure might be a good idea, but there's plenty of code already that depends on the current date format.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
an endless discussion thread about what features to include.
-- Jarkko Hietaniemi
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
Case (Score:1)