I'm making life harder on myself than I need to. Salient facts: CFMX7, SQL Server 2000
I'm trying to insert an address. The contact address table has the usual fields, i.e. id, contactID, address1, address2, city, state, zip, etc., but it also has an addressTypeID that is a lookup column that references values in an addressType table that has typeid, typename What I _WANT_ to be able to do is something like this: INSERT INTO tblContactAddress(contactID,addressTypeID,address1, etc.) VALUES (#contactIDValue#, (SELECT ID FROM tblAddressType WHERE typename = 'General'), '#address1Value#',etc.) Of course, I would be using cfqueryparam for all variables. SQL Server doesn't like this. Is there a way to accomplish what I'm after? Thanks! Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202168 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
