> For instance, what if the fields contain quotes? > > ... > > And it works! Now, that isn't the behaviour I'd expect, so what am > I missing?
CF escapes the existing single quotes first from the argument given to ListQualify, then ListQualify adds them around each list item. It's the way it has always worked, before there even was a CFQUERYPARAM tag. > Anyway, the main thrust of my code was to say that <cfqueryparam> made > the type of the list unimportant. It just makes inserting lists into > queries a bit easier. Again, though, it doesn't. I'm not trying to be annoying about this, but there are perfectly good reasons to use CFQUERYPARAM; there's no reason to provide specious ones. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:195261 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
