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]
