I agree with Eric in the suggestion to normalize your structure (a single script/update statement could take care of updating your several months of records and make your life simpler in the future...)
But, since I've worked in similar situations with databases that make no sense, I understand that you can't always have the perfect design to build on. So perhaps you could use a LIKE statement to retrieve all filepaths LIKE '%123.txt'. You could "cheat" and do this in two steps in CF very easily, or do it in straight SQL. -----Original Message----- From: Todd [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 8:23 AM To: CF-Talk Subject: Re: MySQL query question A couple of reasons. 1. This wasn't thought about ahead of time and there is several months worth of data in the table already. 2. I have no control over the database. This makes for a bad combination :) So. I have to work with what I have. ----- Original Message ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186460 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
