Ketan, This is a very old message from months ago. Also, as I said then, there is no WHERE clause on an INSERT. You have to do an UPDATE. Hope this helps.
On Thu, Sep 9, 2010 at 11:02 AM, Ketan Jetty <[email protected]> wrote: > > 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:5098 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
