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_01C05973.CBDBABFA
Content-Type: text/plain;
charset="iso-8859-1"
Well, SQL Server has built in Query Runner, you can use that to execute your
SQL statements. As for determining your data types, weren't you aware of
them before you set up your DB?
-----Original Message-----
From: pinkesh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 2:35 PM
To: CF-Server
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
------_=_NextPart_001_01C05973.CBDBABFA
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>Well, SQL Server has built in Query Runner, you can =
use that to execute your SQL statements. As for determining your data =
types, weren't you aware of them before you set up your DB?</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:35 PM</FONT>
<BR><FONT SIZE=3D2>To: CF-Server</FONT>
<BR><FONT SIZE=3D2>Subject: RE: getting datatype information for the =
columns in a query</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I'd like to get a generalized solution, but would =
also like to hear how to</FONT>
<BR><FONT SIZE=3D2>get that for SQL server.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks</FONT>
</P>
<P><FONT SIZE=3D2>regards,</FONT>
<BR><FONT SIZE=3D2>Pinkesh</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Shain, Jeff [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, November 28, 2000 2:28 PM</FONT>
<BR><FONT SIZE=3D2>To: CF-Server</FONT>
<BR><FONT SIZE=3D2>Subject: RE: getting datatype information for the =
columns in a query</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>This message is in MIME format. Since your mail =
reader does not understand</FONT>
<BR><FONT SIZE=3D2>this format, some or all of this message may not be =
legible.</FONT>
</P>
<P><FONT SIZE=3D2>------_=3D_NextPart_001_01C05971.4D7E0A7A</FONT>
<BR><FONT SIZE=3D2>Content-Type: text/plain;</FONT>
<BR> <FONT =
SIZE=3D2>charset=3D"iso-8859-1"</FONT>
</P>
<P><FONT SIZE=3D2>Isn't this kind of a general question? I mean this is =
basic SQL and Database</FONT>
<BR><FONT SIZE=3D2>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>--</FONT>
<BR><FONT SIZE=3D2>To unsubscribe, send a message to =
[EMAIL PROTECTED] with</FONT>
<BR><FONT SIZE=3D2>'unsubscribe' in the body or visit the list page at =
www.houseoffusion.com</FONT>
</P>
<P><FONT SIZE=3D2>------_=3D_NextPart_001_01C05971.4D7E0A7A</FONT>
<BR><FONT SIZE=3D2>Content-Type: text/html;</FONT>
<BR> <FONT =
SIZE=3D2>charset=3D"iso-8859-1"</FONT>
<BR><FONT SIZE=3D2>Content-Transfer-Encoding: quoted-printable</FONT>
</P>
<P><FONT SIZE=3D2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML =
3.2//EN"></FONT>
<BR><FONT SIZE=3D2><HTML></FONT>
<BR><FONT SIZE=3D2><HEAD></FONT>
<BR><FONT SIZE=3D2><META HTTP-EQUIV=3D3D"Content-Type" =
CONTENT=3D3D"text/html; =3D</FONT>
<BR><FONT SIZE=3D2>charset=3D3Diso-8859-1"></FONT>
<BR><FONT SIZE=3D2><META NAME=3D3D"Generator" =
CONTENT=3D3D"MS Exchange Server version =3D</FONT>
<BR><FONT SIZE=3D2>5.5.2650.12"></FONT>
<BR><FONT SIZE=3D2><TITLE>RE: getting datatype information for =
the columns in a =3D</FONT>
<BR><FONT SIZE=3D2>query</TITLE></FONT>
<BR><FONT SIZE=3D2></HEAD></FONT>
<BR><FONT SIZE=3D2><BODY></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>Isn't this kind of a =
general question? I mean this is =3D</FONT>
<BR><FONT SIZE=3D2>basic SQL and Database knowledge? =
</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>What kind of db are =
you using?</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>-----Original =
Message-----</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>From: pinkesh =
[<A =3D</FONT>
<BR><FONT SIZE=3D2>HREF=3D3D"<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>">=
<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A></A>=
]</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>Sent: Tuesday, =
November 28, 2000 2:24 PM</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>To: =
CF-Server</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>Subject: getting =
datatype information for the =3D</FONT>
<BR><FONT SIZE=3D2>columns in a query</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
<BR><FONT SIZE=3D2><BR></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT =
SIZE=3D3D2>Greetings,</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>How do I access the =
names of different columns in a =3D</FONT>
<BR><FONT SIZE=3D2>CF query object?</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>How do I get =
information about their =3D</FONT>
<BR><FONT SIZE=3D2>datatypes?</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT =
SIZE=3D3D2>regards,</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>Pinkesh =
</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT =3D</FONT>
<BR><FONT =
SIZE=3D2>SIZE=3D3D2>-------------------------------------------------=
--------------=3D</FONT>
<BR><FONT SIZE=3D2>---------------</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>To unsubscribe, =
send a message to =3D</FONT>
<BR><FONT SIZE=3D2>[EMAIL PROTECTED] with =
'unsubscribe' in the body or =3D</FONT>
<BR><FONT SIZE=3D2>visit the list page at =
www.houseoffusion.com</FONT></P></FONT>
</P>
<P><FONT SIZE=3D2></BODY></FONT>
<BR><FONT SIZE=3D2></HTML></FONT>
<BR><FONT SIZE=3D2>------_=3D_NextPart_001_01C05971.4D7E0A7A--</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-------------</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>To unsubscribe, send a message to =
[EMAIL PROTECTED] with</FONT>
<BR><FONT SIZE=3D2>'unsubscribe' in the body or visit the list page at =
www.houseoffusion.com</FONT>
</P>
<P><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_01C05973.CBDBABFA--
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
