I have a query that is getting a string for the WHERE clause from the a URL variable, and I am building the URL variable in JS on the form submit. What happens is that the JS puts a comma at the end of the string. No big deal. I figured that I would just use the RIGHT function to rebuild the string on the submitted page, stripping the comma off the end. However, it is not working. The original string looks like this:
3, 4, 5, 6, When I do this: <cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'')> I get 3 4, 5, 6, I am not sure why this is happening. The only thing that I can think of is that the space between the comma and number is making CF think that 3, is the end of the string. Does this sound correct? Thanks, -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
