Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Problems with selecting all fields with a star in coldfusion MX

Posted on 2004-10-19
13
Medium Priority
?
147 Views
Last Modified: 2013-12-24
I'm using SELECT * statement in  query from a mySQL database in Coldfusion MX. It all worked untill upgrading to MX. Also I'm having a problem with text fields in the MySQL database. I tried changing to blob but still the same problems. Any ideas as to what it could be?
0
Comment
Question by:rcopeman
12 Comments
 
LVL 14

Expert Comment

by:Renante Entera
ID: 12345937
Hello rcopeman!

Try to double-check the Datasource that you created on the CF Administrator.  Be sure that the account has a permission on your MySQL Database.  Verify the connection.


Goodluck!
eNTRANCE2002 :-)
0
 

Author Comment

by:rcopeman
ID: 12346017
I've tried that and it is fine.
0
 
LVL 10

Expert Comment

by:Mause
ID: 12346728
Do you get an error?
can you show us the code
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:rcopeman
ID: 12346755
It seems that the problem is caused by the text fields in the database. If I change the firld type to varchar(255) it all works fine. However I need a much longer text field and as soon as I use text or blob if all falls over!
0
 
LVL 10

Expert Comment

by:Mause
ID: 12346842
Do you get an error??
Or is the code working but nothing is displayed when outputting the TEXT field?
0
 

Author Comment

by:rcopeman
ID: 12346962
No. No error message but if I look at the debugging information the CFQUERY returns no records when the text fields are included. As I mentioned before if I change the text fields to varchar then it returns the correct record.

Thanks for your help. It doesnt seem to make much sence since it all worked in CF5

0
 
LVL 10

Expert Comment

by:Mause
ID: 12347028
Can you post your query / code
0
 

Author Comment

by:rcopeman
ID: 12347091
     
Nothing complex:

<CFQUERY NAME="getDetails" DATASOURCE="enpod" MAXROWS="1" DBTYPE="ODBC">
      select *
      from enp_advert
      where advert_ref = #URL.id#
</CFQUERY>      

enpod is a mySQL database

Thanks
0
 
LVL 10

Expert Comment

by:Mause
ID: 12347256
Did you try the same query in mysql and did it return the record you want ?
0
 

Author Comment

by:rcopeman
ID: 12347282
Yes and it works fine!
0
 

Author Comment

by:rcopeman
ID: 12348729
OK I have found the problem. It is to do with the native drivers. I reloaded the myodbc after upgrading to MX and everything is now working fine.

Thanks for your comments.


0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12591851
PAQed with points refunded (125)

modulo
Community Support Moderator
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
What You Need to Know when Searching for a Webhost Provider
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question