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

x
?
Solved

does cfsqltype support mediumtext?

Posted on 2010-08-27
1
Medium Priority
?
497 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 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
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…
Suggested Courses

824 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