Thanks, one further follow up question, is there a way that I can then get the datatype of the columns and other bits of info (max size for a string etc?)
Cheers, CHris > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 17 July 2003 11:42 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Would this work? > > > No reason why it wouldn't work. > > queryName.ColumnList will return the columns of a table as a > comma separated > list, loop through it and use it as you will > > Ade > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 17 July 2003 11:35 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Would this work? > > > Hi, > > Am at the design stage for a site, and am wondering if the > following would > work: > > <cfquery name="name" datasource="datasource"> > SELECT * > FROM TABLE > WHERE #THE_FIELD#=#THE_VALUE# > </cfquery> > > Also is there a way that I can loop through all of the Fields > in a table > (ie. if i have a table called USERS I want to loop using the > name of each > field (ie. USER_LOGIN, USER_FORENAMES...). > > Cheers, > > Chris Cormack > > British Telecommunications plc > Registered office: 81 Newgate Street London EC1A 7AJ > Registered in England no. 1800000 > This electronic message contains information from British > Telecommunications > plc which may be privileged or confidential. The information > is intended to > be for the use of the individual(s) or entity named above. If > you are not > the intended recipient be aware that any disclosure, copying, > distribution > or use of the contents of this information is prohibited. If you have > received this electronic message in error, please notify us > by telephone or > email (to the numbers or address above) immediately. > Activity and use of the British Telecommunications plc E-mail > system is > monitored to secure its effective operation and for other > lawful business > purposes. Communications using this system will also be > monitored and may be > recorded to secure effective operation and for other lawful business > purposes. > Any views expressed in this email do not reflect those of BT > and any of > partners and assosiates. Responsiblity for the opinions > expressed are those > of the sender only > > > -- > ** 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]
