> 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>
Yes it would work (although it's not recommended). Imagine the cfquery tag is like a cfoutput tag, but it sends the output to a db as a query. > 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...). <queryname>.columnlist is a list you can loop over containing all of the returned fields in a select query -- ** 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]
