Hello. Is there a way to return a datatype list from
your query along with the column list? Example:
IIRC, there is no direct method. But you could certainly extract that
information using getMetaData()
cfdump var=#getMetaData(qryTest)#
You can usually get that info from the database's system tables, depending
on your RDBMS. (In the following queries, 'typename' will give you the
datatype.)
MSSQL:
SELECT syscolumns.colid,
syscolumns.name,
syscolumns.colorder AS sortorder,
In CF8 there is cfdbinfo This function below will return a query object the
following fields (see below).
http://www.cfquickdocs.com/cf8/?getDoc=cfdbinfo#cfdbinfo
If you don't have CF 8 you will have to query the metadata based on the SQL
dialect for that particular database. You can look at the
3 matches
Mail list logo