> 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:262491 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
