Webmaster Forum / ASP / Database Access / October 2007

I have designed a webpage for my office and have published the site
from my system. In my webpage, I have a drop down which contains
different activities we work on, which is stored in a database. My
requirement is that, as

In a drop down box i am populating all the weeks from 1 to 52,  but
whenever the page loads, i want it show the current week number as
selected value.
Below is what is did:

i am trying to insert some records through ASP. In order to insert new
record, i have a link "Add New". Problem is when i click on link "Add
New" and go back to the view page,  without saving any data, my page
still inserts blank data into the database. i am using the below code:

I am trying to connect to the database through DSN. i have set it up
as System DSN, but when i open the page, i get error "(0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified.

Hi, I need to create a ranking column wich will be the row number... it is
the seller wich most sells... example below:
NOME_EMPRESA   Ranking   NOME_PROMOTOR   VL_CREDITO
EMPRESA                 1              Paul

i have page which shows supplier information in a table format.
Supplier Name       Contact        Email
AAA                       xxxxx          xxxxxxx
In order to change or update information for the supplier, i want to

I've a couple of asp web pages that pull data from an Excel 2003 spreadsheet
and this works absolutely fine.  However, should I refresh the web page
within 60 seconds or so I get the following error
Provider error '80004005'

My ASP page is accessed from a form, the aim is to update a record.
The SQL generated is:
UPDATE tblSales SET ItemDescription='Seven',
ItemBriefDescription='Sev', ItemCost=0, ItemPhotoURL='', Current='No'