Ask a Question related to Coldfusion Database Access, Design and Development.
-
ColonelNusterd #1
ODBC Sybase driver returning zero rows
ODBC Sybase driver returning zero rows for result sets which contain only a
single bit field. Very strange error to encounter. Any query using a sybase
odbc driver which selects a single bit field will have zero records returned.
It doesn't matter if there are 1 or 1000 records that should be returned, it is
always zero with ColdFusion MX and higher. Example Query: SELECT BitField
FROM Web..TestDB The query returns the proper number of records if we simply
select the same bit field a second time with an alias. Example Query: SELECT
BitField as BitFieldOne, BitField as BitFieldTwo FROM Web..TestDB This is a
workaround but a very strange workaround at that. Any help will be greatly
appreciated. We've tried the same query with several ODBC driver versions as
well as on CFMX, CFMX 6.1 and CFMX 7. All combinations have this issue.
ColonelNusterd Guest
-
ODBC driver does not show up in driver list in ODBC data source administrator
Installed an ODBC driver on a Windows Server 2003 machine. A key shows up in the registry under HKEY_LOCAL_MACHINE- seperate listing under... -
SQL Server triggers (dbi:ODBC vs dbi:Sybase)
Hello If I use dbi:Sybase, when I insert a row (SQL Server 2000) in one table from my perl script a trigger is 'trigged' and I can view the... -
(0x80004005) ][ODBC Driver Manager] Data source name not found and no default driver specified
Ok, I don't think this is that complicated, but I can't get it working right. I could work this fine under PWS and Win98. Having various... -
[PHP-DEV] database driver: no more rows
Hi, I would appreciate it if the database extensions would no longer return false when no rows are left in the result set but instead return... -
Sybase driver / client lib still alive?
Is anyone still working on sybase ruby bindings? If so, can I help? If not, would anyone else be interested in such a thing? Cheers, Mike... -
ColonelNusterd #2
ODBC Sybase driver returning zero rows
ODBC Sybase driver returning zero rows for result sets which contain only a
single bit field. Very strange error to encounter. Any query using a sybase
odbc driver which selects a single bit field will have zero records returned.
It doesn't matter if there are 1 or 1000 records that should be returned, it is
always zero with ColdFusion MX and higher. Example Query: SELECT BitField FROM
Web..TestDB The query returns the proper number of records if we simply
select the same bit field a second time with an alias. Example Query: SELECT
BitField as BitFieldOne, BitField as BitFieldTwo FROM Web..TestDB This is a
workaround but a very strange workaround at that. Any help will be greatly
appreciated. We've tried the same query with several ODBC driver versions as
well as on CFMX, CFMX 6.1 and CFMX 7. All combinations have this issue.
ColonelNusterd Guest



Reply With Quote

