Solved

does cfsqltype support mediumtext?

Posted on 2010-08-27
1
485 Views
Last Modified: 2012-06-21
I am creating an insert form with Coldfusion and I have a database column that has a data type set to mediumtext. When I am writing the query it does not show me mediumtext in the <cfsqltype=""> code hinting. Is there another I can use here?
0
Comment
Question by:RNB
1 Comment
 
LVL 28

Accepted Solution

by:
strickdd earned 500 total points
ID: 33541335
Here are the valid type cfsqltype has:

BIGINT
BIT
CHAR
DATE
DECIMAL
DOUBLE
FLOAT
IDSTAMP
INTEGER
LONGVARCHAR
MONEY
MONEY4
NUMERIC
REAL
REFCURSOR
SMALLINT
TIME
TIMESTAMP
TINYINT
VARCHAR

http://www.adobe.com/livedocs/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/queryDB6.htm

It looks like LONG and LONGVARCHAR can be used to map to medium text (http://dev.mysql.com/doc/refman/5.0/en/blob.html)
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Developer tools in browsers have been around for a while, yet they are still heavily underused by developers. Developers still fix html or CSS then refresh page to see effect, or they put alert or debugger in JavaScript and then try again and again …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now