|
 |
asp_web_howto thread: Get Fields' Type
Message #1 by "SR" <v.steele@u...> on Fri, 30 Mar 2001 01:34:18 -0300
|
|
Hello everyone
Is there any way to get the type (e.g.: int, varchar) of the fields of
tables through code (asp or other technology)?
If yes, how?
Thanks for the answers, thanks everyone!
Regards,
Samuel
Message #2 by Gregory_Griffiths@c... on Fri, 30 Mar 2001 11:57:35 +0100
|
|
You should be able to a DESC on the table, some DB's provide
information in other ways, which DB are you using ?
> -----Original Message-----
> From: v.steele@u... [mailto:v.steele@u...]
> Sent: 30 March 2001 05:34
> To: asp_web_howto@p...
> Cc: v.steele@u...
> Subject: [asp_web_howto] Get Fields' Type
>
>
> Hello everyone
>
> Is there any way to get the type (e.g.: int, varchar) of the fields of
> tables through code (asp or other technology)?
> If yes, how?
>
> Thanks for the answers, thanks everyone!
> Regards,
> Samuel
>
>
Message #3 by "Deepa" <deepa@e...> on Fri, 30 Mar 2001 17:17:35 +0530
|
|
recordset.FIELDS(column no).TYPE
-----Original Message-----
From: Gregory_Griffiths@c...
[mailto:Gregory_Griffiths@c...]
Sent: 30/03/2001 4:28 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Get Fields' Type
You should be able to a DESC on the table, some DB's provide
information in other ways, which DB are you using ?
> -----Original Message-----
> From: v.steele@u... [mailto:v.steele@u...]
> Sent: 30 March 2001 05:34
> To: asp_web_howto@p...
> Cc: v.steele@u...
> Subject: [asp_web_howto] Get Fields' Type
>
>
> Hello everyone
>
> Is there any way to get the type (e.g.: int, varchar) of the fields of
> tables through code (asp or other technology)?
> If yes, how?
>
> Thanks for the answers, thanks everyone!
> Regards,
> Samuel
>
>
Message #4 by "SR" <v.steele@u...> on Fri, 30 Mar 2001 23:52:14 -0300
|
|
Hello
I'd like to know how to do it with SQL SERVER 7/2000 and Oracle 8i.
Regards,
Samuel
----- Original Message -----
From: <Gregory_Griffiths@c...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Friday, March 30, 2001 7:57 AM
Subject: [asp_web_howto] RE: Get Fields' Type
> You should be able to a DESC on the table, some DB's provide
> information in other ways, which DB are you using ?
>
> > -----Original Message-----
> > From: v.steele@u... [mailto:v.steele@u...]
> > Sent: 30 March 2001 05:34
> > To: asp_web_howto@p...
> > Cc: v.steele@u...
> > Subject: [asp_web_howto] Get Fields' Type
> >
> >
> > Hello everyone
> >
> > Is there any way to get the type (e.g.: int, varchar) of the fields of
> > tables through code (asp or other technology)?
> > If yes, how?
> >
> > Thanks for the answers, thanks everyone!
> > Regards,
> > Samuel
> >
> >
>
|
|
|
View Cart
