Getting cloumn data types in access via SQL

Article View: comp.databases.ms-access

Article #180

Back to comp.databases.ms-access Previous Next

#180

From: Giles Roadnight
Date: Thu, 21 Jun 2001 07:57

38 lines
2469 bytes

Hi all
I am doing a page that will let you view any datasource remotely. It list
all of the tables, lets you add, delete and modify tables, shows you the
contents of all of the tables and lets you add, delete and modify columns
and add delete and modify rows.
I need to be able to get the column attributes like datatype and so on. I
have got the table list like this:

<cfquery name="tables" datasource=#variable.datasource#>
select name
from msysobjects
where flags = 0
and type = 1
</cfquery>

the columns like this:

<CFQUERY name="Columns" datasource=#variable.datasource#>
SELECT *
FROM #url.tablename#
</CFQUERY>
<CFLOOP INDEX="FieldName" LIST="#columns.ColumnList#" DELIMITERS=",">
#FieldName#<BR>
</CFLOOP>

But cannot work out how to get the data types. I really need this or I
cannot alter records as I do not know if I should put quotes around the
where and and clauses (where column_name = value [or 'value'].

Hope someone can help me out with this or I am really stuck.

Thanks

--

Giles Roadnight
Web Master Gold Cockerel Books
www.goldcockerelbooks.co.uk

Technical Details

Message-ID: <9gs9j0$nab$1@neptunium.btinternet.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!dispose.news.demon.net!demon!btnet-peer0!btnet-peer1!btnet-feed5!btnet!mendelevium.btinternet.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,ec453cdc760d4337,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 104e26,ec453cdc760d4337,start
X-Google-Attributes: gid104e26,public
X-Google-Thread: 10779a,ec453cdc760d4337,start
X-Google-Attributes: gid10779a,public
X-Google-Thread: 10bb27,ec453cdc760d4337,start
X-Google-Attributes: gid10bb27,public
X-Google-Thread: ff490,ec453cdc760d4337,start
X-Google-Attributes: gidff490,public
X-Google-ArrivalTime: 2001-06-21 01:01:20 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!dispose.news.demon.net!demon!btnet-peer0!btnet-peer1!btnet-feed5!btnet!mendelevium.btinternet.com!not-for-mail
From: "Giles Roadnight" <giles.roadnight@goldcockerelbooks.co.uk>
Newsgroups: comp.databases.ms-access,cz.comp.microsoft.sql,git.sql-help,microsoft.public.access,microsoft.public.access.queries
Subject: Getting cloumn data types in access via SQL
Date: Thu, 21 Jun 2001 08:57:09 +0100
Organization: BT Internet
Lines: 42
Message-ID: <9gs9j0$nab$1@neptunium.btinternet.com>
NNTP-Posting-Host: host213-123-135-156.btopenworld.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200