LOL - R&D cough cough
-----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Database schema tool Justin, I don't think your employer keeps you busy enough :-) > -----Original Message----- > From: Justin [mailto:[EMAIL PROTECTED] > Sent: 10 October 2003 14:43 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Database schema tool > > > 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.f > indColumn(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] > -- ** 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]
