Webmaster Forum / ASP / Database Access / March 2004

Here's my quandry...
I have a table called addrTable with the following fields:
storename, storeAddr, address2,City,State,phone, prods
I want to return a recordset based upon the search criteria of prods.

Im in the final stages of cleaning up an xtensive ASP/Access-db
project. I've ran everything through with Option Explicit - and that
proved to be VERY helpful.
Now - is there a similar command to put in that helps tracing declared

I know you ask for a schema of the tables, etc, but I think this is more an
ASP thing than a T-SQL thing.
I can get the row-by-row data that I want into a recordset (auto-sorted by
SALESCENTREID and then STOCKCATEGORYID), but what I need to do is sub-total

I have a working ASP System  containing the code listed under 'Target Code
in a longish loop which reproduces on the web page
the sections of the customer catalogue that the client is interested in. The
code determines if a Customer has logged on and tailors some of the links on

Would someone please be able to help me write the code to update the details in a record on a table. I want to update the value of a field within the record.   For instance I need to be able to change the details in a table which look like as follow
AccountNo      Agent Name       ...

I'm using WinXP-Pro, ASP classic, IIS 5.0.
I regularly get this error, but I know I am the only user accessing the
website at the time of the error.
I looked it up on the MS support webiste.  Their recommendation is this ...

I've seen a few examples of multi-language ASP web sites, but none that seem
to do it very well.
Basically I can see that all of the strings need to be kept in the database
and that the relevant table needs to be constructed as follows:

Few logic queries again.
I've seen a lot of sites that display categories in a sort of table with the
number of items/products that are available in each category being
represented by a number next to each category, eg:

Got a question for you guys... thanks for taking a look at this.
Question:
I have a link which pops-up a form.  I have a validation script which
checks the values in the form upon submission.  I have all this working

I have a requirement in which customer fills in a form.
The provided form fields are searched against the coulmns
in customer table. For example FirstName is searched
against FirstName in the table and so on. If the form data

Hey there
I'm working on revamping an application I originally helped architect. At the time I first created it, it was my first DB/ASP project and a lot of things in it now seem glaringly wrong about it. Namely, there is one field in the table we use that breaks the cardinal rule ...

I am developing a small website using ASP scripts to format data retrieved
from an Access database. It will run on a Windows 2003 server supporting
FrontPage extensions 2002 hosted by the company 1&1 with only limited server
configuration via a web based control panel.

I know these are probably a very general questions, but I'd like to know
your thoughts all the same.
Basically my shopcart is taking shape and I want to do the following:
1) A user's product has a set price and then an option to enter a price for

I am writing some code for a customer.  The code integrates with his current
SQL Server Database which resides on his server.  We agreed that he will not
pay me until the project is complete.  Because I do not have a long history
with this person I am somewhat uncomfortable just ...