> This doesn't work, but I'm guessing you guys know what I'm trying to > accomplish.
By "doesn't work" do you mean you're getting an error, or does it execute and give unexpected results? Does the query produce desired results when executed directly against the database, or only when run through ColdFusion? What is the database platform/version? If you run that where clause on a SELECT * FROM Wishlist query do you get any results? -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3391 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
