Ask a Question related to Coldfusion Database Access, Design and Development.
-
GreatBlue #1
Detect CFQuery Column Data Type
Is it possible to detect the data type of a column in an ODBC Select CFQuery with MS Access or SQL Server?
This solution will save me a lot of effort.
Thanks
GreatBlue Guest
-
Filter table by column data type
Hello everyone, I'm using VB Script, SQL 2K. Is it possible to create a recordset from a table based on the column data type? Hypothetically,... -
Length of column with 'text' data type
Hi. I'm getting various data about columns in a table by using sp_column. Everything is working as I expected, except one thing. When I get the... -
MSAccess query : detect data type
"deleteID" in the following query could be either alpha or numeric. How to modify the query to accomodate both cases? <CFQUERY... -
Converting data type varchar to data type money
Hi all, Tearing my hair out trying to figure this out. If anyone can provide any help i would greatly appreciate it. When I try to do an insert... -
How to cast cfquery object to type java.util.Map
In the LiveDocs it says: "..The following table lists how ColdFusion converts ColdFusion data values to Java data types when passing arguments. The... -
mxstu #2 Re: Detect CFQuery Column Data Type
If you are using MX 7, take a look at the
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0000488.htm function used
with a query object.
mxstu Guest
-
GreatBlue #3 Re: Detect CFQuery Column Data Type
Unfortunately I am using CF5.
Thanks for the help.
GreatBlue Guest
-
mxstu #4 Re: Detect CFQuery Column Data Type
MS SQL 2000+ provides information about database objects through the INFORMATION_SCHEMA views. It would require a separate query, but it is a starting point.
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
