I am new to aspx so I would like for someone to create me a simple sample page. The page will pull the oldest used amazonid from the database using the sql statement "select Top 1 * from tbl_amazon_id order by lastused ASC" It will then update that id to the new datetime of now(), then use that id in two amazon widgets and store it in a session for JUST THAT DAY so all other pages that are visited will pull the amazon id from the session and not the database. I have attached the basic overview. I know this is a very simple project for someone to code, so the first person who sends me the entire project will get the bid. I need the project right away. I will award the bidder at 11:30 EST today. The database is very simple: amazonid nvarchar(25) and lastused as datetime. included the basic html with the widgets and layout that will of course have to be put into the aspx page instead. thankyou for your time.
The lastused field stores the date and time the id was last used. This will allow you to find a new id for a new user visiting the website based on the oldest id (the oldest date and time) in the table (which cannot be the same day as the new user). The lastused field is update when a customer first visits a website. The idea is when you create a session for the user when they load the first page of your website you will assign an Amazon id to them and also store that assignment in your database.
on page load()
if session(amazonid) = "" then
grab oldest amazon id from database.
update the amazon id to todays date time
set the session for today only on the users computer for the new amazon id
load the amazon widgets with the amazon id.
grab amazon id from session
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<div style="position: absolute; width: 141px; height: 438px; z-index: 1; left: 17px; top: 7px" id="layer1">
<div style="position: absolute; width: 572px; height: 435px; z-index: 1 left: 158px; top:5px ; left:176px" id="layer2">
<iframe src="[url removed, login to view]" marginwidth="0" marginheight="0" width="468" height="336" border="0" frameborder="0" style="border:none;" scrolling="no"></iframe>