Hi Adam, 1. Verify if poemID, rating accept numeric data and username accepts string data. 2. Try the trim() function to remove any whitespace.
INSERT INTO table (poemID, rating, username) VALUES (#trim(url.id)#, #trim(form.rating)#, '#trim(session.username)#') WHERE poemID = #url.id# Ketan Jetty http://KetanJetty.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5096 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
