Solved

does cfsqltype support mediumtext?

Posted on 2010-08-27
1
482 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction A frequently used term in Object-Oriented design is "SOLID" which is a mnemonic acronym that covers five principles of OO design.  These principles do not stand alone; there is interplay among them.  And they are not laws, merely princ…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

760 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

23 Experts available now in Live!

Get 1:1 Help Now