Adding Value to number to database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
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.
==============================================
 
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?
 
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.
 
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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Jeopardy on Powerpoint 0
Hyperlinks to ASP Pages 5
Getting Hit Counter to work. 2
Trouble with hyperlinking pdf file 2
How to subtract a number from a Mergefield? 0
Access Macro Repeat Expression using value of a field in table 0
Adding Searchable Database to website 6
Database Results with hyperlink fields 2

Back
Top