pinkesh-
a query object in coldfusion is simply an array of structures. you can
access a list of the columns in the object by referencing
queryName.columnList.
On the datatype note, I'm sure that some people have written custom tags to
do this for you. Check out the allaire tag gallery. On the other hand, CF is
a typeless language so if you're just trying to display a value, you don't
need to specify it's datatype as you do in java...
----- Original Message -----
From: "pinkesh" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 2:34 PM
Subject: RE: getting datatype information for the columns in a query
> I'd like to get a generalized solution, but would also like to hear how to
> get that for SQL server.
>
> Thanks
>
> regards,
> Pinkesh
>
> -----Original Message-----
> From: Shain, Jeff [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 28, 2000 2:28 PM
> To: CF-Server
> Subject: RE: getting datatype information for the columns in a query
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C05971.4D7E0A7A
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Isn't this kind of a general question? I mean this is basic SQL and
Database
> knowledge?
>
> What kind of db are you using?
>
> -----Original Message-----
> From: pinkesh [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 28, 2000 2:24 PM
> To: CF-Server
> Subject: getting datatype information for the columns in a query
>
>
> Greetings,
> How do I access the names of different columns in a CF query object?
>
> How do I get information about their datatypes?
>
> regards,
> Pinkesh
> --------------------------------------------------------------------------
--
> --
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
> ------_=_NextPart_001_01C05971.4D7E0A7A
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2650.12">
> <TITLE>RE: getting datatype information for the columns in a =
> query</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=3D2>Isn't this kind of a general question? I mean this is =
> basic SQL and Database knowledge? </FONT>
> </P>
>
> <P><FONT SIZE=3D2>What kind of db are you using?</FONT>
> </P>
>
> <P><FONT SIZE=3D2>-----Original Message-----</FONT>
> <BR><FONT SIZE=3D2>From: pinkesh [<A =
> HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
> <BR><FONT SIZE=3D2>Sent: Tuesday, November 28, 2000 2:24 PM</FONT>
> <BR><FONT SIZE=3D2>To: CF-Server</FONT>
> <BR><FONT SIZE=3D2>Subject: getting datatype information for the =
> columns in a query</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=3D2>Greetings,</FONT>
> <BR><FONT SIZE=3D2>How do I access the names of different columns in a =
> CF query object?</FONT>
> </P>
>
> <P><FONT SIZE=3D2>How do I get information about their =
> datatypes?</FONT>
> </P>
>
> <P><FONT SIZE=3D2>regards,</FONT>
> <BR><FONT SIZE=3D2>Pinkesh </FONT>
> <BR><FONT =
> SIZE=3D2>---------------------------------------------------------------=
> ---------------</FONT>
> <BR><FONT SIZE=3D2>To unsubscribe, send a message to =
> [EMAIL PROTECTED] with 'unsubscribe' in the body or =
> visit the list page at www.houseoffusion.com</FONT></P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01C05971.4D7E0A7A--
> --------------------------------------------------------------------------
--
> --
> To unsubscribe, send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
> --------------------------------------------------------------------------
----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
>
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
