Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problems with selecting all fields with a star in coldfusion MX

Posted on 2004-10-19
13
Medium Priority
?
145 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
13 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
Suggested Courses

886 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