WOW something new every day... never knew about LIST THANKS a ton Guys/Gals!
On 12/1/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > The *BIG* Question is do I need to use a cfqueryparam in the > > second query ... > > Yes, you do. Any time you take data from the browser and use it in an SQL > statement, you need to use CFQUERYPARAM. > > > and IF I do, how would I put the info into it IE what cfsqltype? > > You'd use whatever datatype the column value should be - in this case, > REC_ID is presumably an integer. You will also need to use the LIST > attribute of CFQUERYPARAM: > > WHERE REC_ID IN (<cfqueryparam cfsqltype="cf_sql_integer" > value="#kidlist#" > list="yes"> > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
