Solved

Problems with selecting all fields with a star in coldfusion MX

Posted on 2004-10-19
13
137 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Suggested Solutions

Title # Comments Views Activity
I starting with php 12 131
SPLUNK REST  API call to Splunk to create and index? 2 118
javascript to html map 8 79
whm high memory usage in processes 7 87
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

785 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