ODBC Sybase driver returning zero rows

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. 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...
    2. 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...
    3. (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...
    4. [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...
    5. 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...
  3. #2

    Default 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

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139