Adding Value to number to database

J

Jehuty

Im trying to figure out how i can click a website hyperlink then having it
add a value(+1) to a number field from Access. How can i do this?

(Kinda like a click counter basically)
 
S

Stefan B Rusynko

You will need a custom ASP script to read the current DB value and add 1 to it (as a parameter passed from the link)
- what if they open the link w/o clicking it (say from a bookmark w/o a parameter)




| Im trying to figure out how i can click a website hyperlink then having it
| add a value(+1) to a number field from Access. How can i do this?
|
| (Kinda like a click counter basically)
 
T

Thomas A. Rowe

You would have to write it, as it would have to be written to your specific needs.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
J

Jehuty

I've been doing research for the past 5 hours to see if I can succeed in this
task I a can't find anything to help me. Please, is there any web-site or
source that can help me in this task?
 
K

Kevin Spencer

Actually, you don't need to fetch the number from the database. You would
simply do an UPDATE. Example:

UPDATE myTable SET NumericField1 = NumericField1 + 1
WHERE CriteriaField = Criteria

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.
 
J

Jehuty

Ok, now im trying to figure out how to insert that code in a why so that
every time someone clicks 'download' the counter will increase 1. Im using
the FrontPage Database Results Region.
 
J

Jehuty

I did a spelling error in the post before this :)

Ok, now im trying to figure out how to insert that code in a way so that
every time someone clicks 'download' the counter will increase 1. Im using
the FrontPage Database Results Region so each counter will have to be in its
own field.
 
K

Kevin Spencer

I'm afraid I'm no expert with the FrontPage database tools. I do all my own
coding. There are others here that should be able to help, though.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.
 
Top