sorry quick mail.
You can do this with metadata too for that x-platform feeling.
Here is some untested psuedocode..
<cfquery name="gettable" datasource="#Attributes.DS#">
SELECT *
FROM #Attributes.TABLENAME#
</cfquery>
<cfset metadata = gettable.getMetaData() />
<cfset numColumns = gettable.getColumnCount()>
<cfset MYRS = QueryNew("Columnname,ColumnType") />
<cfloop from="1" to="#ListLen(gettable.ColumnList)#" index="i">
<cfset temp = QuerySetCell(MYRS , "Columnname", "#column#", i)>
<cfset temp = QuerySetCell(MYRS , "ColumnType",
"#gettable.getColumnTypeName(metadata.getColumnType(gettable.findColumn(colu
mn)))#", i)>
</cfloop>
<cfset "caller." & Attributes.QueryName = MYRS />
If you need more details for each column check out..
http://www.cfdev.com/mx/undocumentation/query.cfm
justin
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 10 October 2003 14:02
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Database schema tool
:-) LOL
-----Original Message-----
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 10 October 2003 14:03
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Database schema tool
I know god damb it.... But I wanted the flippin tag, cozz it does lots
of other nice things.
Don't u start doing Neil impressions Justin...
> -----Original Message-----
> From: Justin [mailto:[EMAIL PROTECTED]
> Sent: 10 October 2003 12:48
> To: [EMAIL PROTECTED]
> Subject: RE: [ cf-dev ] Database schema tool
>
>
> Is you are using MS SQL , there are sp_table , and
> sp_Column[s] sprocs that do all that....
>
> Justin
>
> -----Original Message-----
> From: Snake Hollywood [mailto:[EMAIL PROTECTED]
> Sent: 10 October 2003 12:15
> To: [EMAIL PROTECTED]
> Subject: RE: [ cf-dev ] Database schema tool
>
>
> Yes I know that, I'm not so lazy I can't write a one line
> query, but as I stated, I need all the column info for the
> tables as well.
>
> > -----Original Message-----
> > From: Robertson-Ravo, Neil (RX)
> > [mailto:[EMAIL PROTECTED]
> > Sent: 10 October 2003 11:49
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: [ cf-dev ] Database schema tool
> >
> >
> > well...
> >
> > select name from sysobjects where type = 'U'
> >
> > will give you all user tables....
> >
> >
> >
> > -----Original Message-----
> > From: Snake Hollywood [mailto:[EMAIL PROTECTED]
> > Sent: 10 October 2003 11:48
> > To: [EMAIL PROTECTED]
> > Subject: [ cf-dev ] Database schema tool
> >
> >
> > I know someone here, possibly Spike, wrote a tag to query
> the system
> > tables and give back all user tables and column info for a
> specified
> > database. Anyone got a copy to save me writing it.
> >
> > Russ Michaels
> > Macromedia/Allaire Certified ColdFusion Developer
> >
> > Satachi Internet Development
> >
> > Phone: 0870 787 3610
> > Tech Support: 0906 9607800
> > FAX: 0709 2212 636
> > http://www.satachi.com
> > email general: [EMAIL PROTECTED]
> > email support: [EMAIL PROTECTED]
> >
> > Join our ColdFusion Developer discussion lists.
> > Send an e-mail to [EMAIL PROTECTED]
> >
> >
> > --
> > ** Archive:
> http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/
> >
>
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > For additional commands, e-mail:
> [EMAIL PROTECTED] For
> > human help, e-mail: [EMAIL PROTECTED]
> >
> > --
> > ** Archive:
> http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/
> >
>
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > For additional commands, e-mail:
> [EMAIL PROTECTED] For
> > human help, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
