Hi all, I'm relatively new to ASP and web development and I've got a bit of problem.
I have a page with a form that submits details to an Access database. I have added an ADO command to increase a value in the database. However, I want this increase to only occur when I submit the form and I already have something occupying the ACTION form tag. At the moment, I've tried adding the function name to a button OnClick (function called test: OnClick="<%test%>" ) Now the code actually runs and the database gets updated but it happens when the page is loaded and I want it to happen when the form is submitted.

Any ideas? :)

Hi there,

You are mixing two concepts: ASP code runs at the server while JavaScript like OnClick runs at the client. Your current code runs fine (well, at least it runs) because just before the page is sent to the browser, all ASP code is executed at the server. That's why the test method runs when you load the page.

So, they only way to access ASP code is at the server, after you have submitted the data to the server, using GET or POST.

Usually, you'll want to do something like this:

1. Add a client side handler that submits the form (like a button click, or MyForm.submit() from some JavaScript)

2. At the server, check whether the page has been submitted (that is, Request.Form("btnMyButton") has a value, for example)

3. If the page has been resubmitted, do your database insert based on the form values.

I am not sure what you mean with "I already have something occupying the ACTION form tag" Are you saying that you don't want to post to the page currently set in the action attribute?

If that's the case, you have a few options:

1. Define multiple forms on the page. Each form can have its own submit methods and action attributes.

2. Submit to another (or hidden) frame

3. Use some JavaScript to open a new page that submits a form.

HtH

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for the reply :) I had already considered using javascript to open a new page to submit but was wondering if there was another way. I'll probably end up doing that.

woohoo!! I spent another couple of days banging my head against a brick wall trying to figure a way of sending the variable to another page with javascript. And as I was sipping on a much needed fizzy beverage, the answer came to me in the form of the SQL COUNT function :) In the database itself I was already calculating the number of people booked on to a specific course using the DCOUNT function. Now I've recreated the same calculation on the web page to count up the number of records associated with the course the user is looking at and written a script to redirect them if the current places booked is greater or equal to max places. And it works....I think I need to go lie down :D