Ask a Question related to Coldfusion Database Access, Design and Development.
-
chrson #1
Re: Query returns no rows...
Any more input on this? I still can?t get this resolved :(
chrson Guest
-
DBI Query rows Benchmark
Hello! I have a questionto those lovers of DBI and Databases: which method is faster to know the number of rows of a query: $sth->rows or ... -
Deleting specific rows from a returned query result
I execute a <cfquery> statement block, and that works fine. However, I need to manipulate the return query rows by deleting the ones that do not... -
CFFILE output multiple rows from a query
I have a quiestion about the below. I am working with this method, but I find that my code results in the first record being outputed twice in the... -
How to limit # of rows returned from query
I am looking at setting a limit to the number of rows returned on some of my queries. I was looking at doing something like: <cfoutput... -
Query returns first record everytime?
I have a .cfm page that takes an email address and qureies the database for proper record. The query seems not to accept the "where" statement and... -
Pete L. #2 Re: Query returns no rows...
I'm having exactly the same issue. A client of ours had us upgrade their
development server (thank god it wasn't production) from CF 5 to CFMX 6.1. The
installer migrated all the settings but these odd ODBC connections didn't work
after that. I deleted them in the CF Administrator and re-added them using the
ODBC Sockets. I don't have any username or password in the setup as the
connection does not require one and I have the Trusted Connection box checked.
If I add/change any other settings in the Administrator, the connection
fails. We are using an ODBC driver from OpenLink to connect to a Progress
database.
Pete L. Guest
-
chrson #3 Re: Query returns no rows...
Good to see that I?m not alone on this...
Please let me know if you?re having any luck with this Pete, in the meantime I?ll keep pulling my hair :)
Christian
chrson Guest
-
Pete L. #4 Re: Query returns no rows...
Hi Christian: We finally ended up convincing the client to move to (i.e.
purchase) an additional OpenLink License for the JDBC dirver. After a little
bit of trial and error getting that connected, they are now working very well.
Not sure if you are using an OpenLink driver as well, but we could not get it
to work through ODBC Sockets. In our tests the ODBC sockets for most any
database are quite a bit slower than a JDBC driver with MX, so if you can get a
JDBC driver, it is highly recommended.
Pete L. Guest
-
ColonelNusterd #5 Re: Query returns no rows...
Hey Christian, what fields would be returned from this query? Specifically
what datatypes are the fields? I'm running into this problem as well, but it
only occurs when there is 1 bit field in the result set. It doesn't matter if
there is 1 or 2000 rows normally returned, if its a single bit field, we get
zero records through coldfusion. I have tried w/ various ODBC driver versions
(we use sybase) and both CFMX 6.1 & 7. The issue still persists.
ColonelNusterd Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
