Ask a Question related to Coldfusion Database Access, Design and Development.
-
wittsdd #1
No records found for MySQL Table
Hello, We have a MySQL table that we had been using PHP to query, but now we
want to query the table using CF 5.0 on a windows 2000 server. The datasource
verifies just fine, however, the CF Query returns 0 results on a simple query
such as this... select * from rentals Do I need to add something to the
query? Thanks, Danny
wittsdd Guest
-
How to get All Records in Table A that don't havematching ID in Table B
I thought this would be a breeze, but I cannot seem to get it to work. I have two tables (Table A) and (Table B). (Table A) = all productid's ... -
Found Records
is there a function that allows you to distinguish between found and omitted records? For example, a certain field = 0 for omitted, 1 for in the... -
Message for 0 Records Found
if ($data = mysql_fetch_array($result)) { echo "<table>\n" do { echo "<tr>"; echo "<td>".$data."</td>\n"; echo "<td>".$data."</td>\n"; /* Add... -
newbie : trying to count records in mysql table
Help, I get no output on this code // Connect to database. $dbh = mysql_connect("localhost","user","password"); mysql_select_db("survey"); ... -
Delete from one table with matching records in another table
I'm an Access programmer making the migration to SQL Server, and I want to delete all the records from one table with matching records in another... -
Defuse #2 Re: No records found for MySQL Table
What does your output look like? Any errors?
Defuse Guest
-
wittsdd #3 Re: No records found for MySQL Table
No error messages at all. In the cfm page it just returns 0 for the recordcount of the query. There are over 5,000 records in the table.
wittsdd Guest
-
-
wittsdd #5 Re: No records found for MySQL Table
False Alarm Sorry for bother, my admin just told me he had the odbc connection
pointed to the dev database. This is after swearing to me for hours that is
pointed to production :( Thanks Again for the responses
wittsdd 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
