depending on the database, if you have access you can have an auto
number field... I think thats what the field is called.. whenever a
record is inserted it increments the field.
If you use oracle, you could build a sequence and when the page is
loaded have a query
<cfquery name="out" database="#ds#">
select seq_pagehit.nextval
</cfquery>

then have the query that inserts that value into the database.

hth

On Tue, 17 Aug 2004 08:21:30 -0400, James McCann <[EMAIL PROTECTED]> wrote:
> hi, im new to cf, ive learnt the basics and want to build a hit counter using a database, ive looked on the internet but cant find anything that helps me with this.
>
> the database i have made has page_hit, page_hits and date as the fields, this is as basic as it gets i know but thats all i need to do, how do i go about doing this has anyone got an example???
>
> thanks for any help you can give me.
>
> James
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to