Build a watch-item page (like shopping cart) in coldfusion.

one thing u said u want to delete the item ,what exactly you mean by delete you want to delete the item permanently or  you dont want to show to only that particulat user,.  ( you said no need to log in to view this page )

if it is  like deleting permanently then u can delete from the master table or change the flag to inactive if ur using falgs.

Hello srikanthmadishetti:
I mean like the shopping card.If you don't realy want to buy something you delete it in your basket and than you see the rest of your basket.
In this case i want to watch cars.If i'm not anymore interested in one car i can delete it (from my watching itemspage ,Not from the DB)

You need a new table. The table primary keys are the user key and the item key (the wached item). Additional columns could be whatchlist item creation date, report creation frequency for that item, and so on.

hi panosms

you want  no user log in right i mean user can shop with out logging in and at check out u will ask for the user  details.

Hello again.
If you go to sites like search cars,you don't have to be logged on to watch items.Looking at mobile.de you will se in the english version that there is a link to :My Park.
Here you send the items from the result page.i think that is working with cookies or session.

I do not think that all whatchlist data is stored in Cookies, so if not logged in then you are "logged" by a cookie that is generated for you by that web site. As soon as you come again with that cookie you are recognised as former "user" of that page and your old cookie with the generated userid is reused. But all the other information about your visit and your wish list or watch list is stored on server side in some sort of persitant storage, and that is mostly a database.
So your userid in my upper table is the "userid" from the cookie vistor id.