freelanceprogrammers.org Forum Index » Cold Fusion

View previous topic :: View next topic

Finding Data Types

Chrystalheart Posted: Sun Jul 24, 2005 8:57 am

Joined: 05 Apr 2005

Posts: 37

Finding Data Types

Hi. Do any of you know of a way to query a table and find out which
data type is related to which field name?

Jen

ny5i Posted: Sun Jul 24, 2005 8:42 pm

Joined: 25 Apr 2005

Posts: 10

Finding Data Types

> Hi. Do any of you know of a way to query a table and find out which
> data type is related to which field name?

That depends on what the database system used is.

Hatton

Chrystalheart Posted: Sun Jul 24, 2005 11:21 pm

Joined: 05 Apr 2005

Posts: 37

Finding Data Types

Oh, duh.. sorry. I`m using CF 5.0 on Access.

--- In cold_fusion@yahoogroups.com, "C. Hatton Humphrey"
<chumphrey@g...> wrote:
> > Hi. Do any of you know of a way to query a table and find out
which
> > data type is related to which field name?
>
> That depends on what the database system used is.
>
> Hatton

janewilliams20 Posted: Mon Jul 25, 2005 2:49 pm

Joined: 12 Jul 2005

Posts: 20

Finding Data Types

> > > Hi. Do any of you know of a way to query a table and find out
> which
> > > data type is related to which field name?

>I`m using CF 5.0 on Access.

ISTR looking into this a while back, and finding that it`s quite hard.

There`s no query you can do on the database that will return the
meta-data you`re after. What I found was some MS-specific methods,
invoking COM or something like it. Too complicated for me at the time,
and browser-specific too. Could be worth another Google, though, just
because I found it too complex then doesn`t mean a lot :)

Chrystalheart Posted: Mon Jul 25, 2005 6:30 pm

Joined: 05 Apr 2005

Posts: 37

Finding Data Types

All I found was some coding using getcolumntype and getcolumntypename,
but I couldn`t get it to work.

Argh.

Thanks for your response Jane!

Jen

--- In cold_fusion@yahoogroups.com, "Williams, Jane"
<jane.williams@u...> wrote:

> There`s no query you can do on the database that will return the
> meta-data you`re after.... Could be worth another Google, though,
just because I found it too complex then doesn`t mean a lot :)

janewilliams20 Posted: Mon Jul 25, 2005 6:44 pm

Joined: 12 Jul 2005

Posts: 20

Finding Data Types

It just occurred to me that the last time I looked into this, it was
probably via this group. So I searched the archives.

The thread starts here

http://groups.yahoo.com/group/cold_fusion/message/4417

and the nearest we got to a conclusion was here
http://groups.yahoo.com/group/cold_fusion/message/4425

> -----Original Message-----
> From: cold_fusion@yahoogroups.com
> [mailto:cold_fusion@yahoogroups.com] On Behalf Of Jennifer
> Sent: 25 July 2005 14:31
> To: cold_fusion@yahoogroups.com
> Subject: [cold_fusion] Re: Finding Data Types
>
>
> All I found was some coding using getcolumntype and
> getcolumntypename,
> but I couldn`t get it to work.
>
> Argh.
>
> Thanks for your response Jane!
>
> Jen
>
> --- In cold_fusion@yahoogroups.com, "Williams, Jane"
> <jane.williams@u...> wrote:
>
> > There`s no query you can do on the database that will return the
> > meta-data you`re after.... Could be worth another Google, though,
> just because I found it too complex then doesn`t mean a lot :)

freelanceprogrammers.org Forum Index » Cold Fusion

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help