homepage Welcome to WebmasterWorld Guest from 54.161.133.166
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Access database count of items query
How to do this with aspx?
luvfords




msg:4292184
 4:06 am on Apr 5, 2011 (gmt 0)

I have an Access database which formerly ran with FP, and a web bot that gave the count of a particular field, for instance 25000 then when another item was added that count changed to 25001. It only worked on an old FP .asp page.

Now I want to achieve similar results on an .aspx page by Expression Web 4. Does anyone know of a query or web bot which will do this?

Thank You.
John

 

eelixduppy




msg:4292609
 6:49 pm on Apr 5, 2011 (gmt 0)

Welcome to WebmasterWorld, John!

Try this search for help on querying an access database: [google.com...]

Then once you can connect to your access table, you have to query it using the count() aggregate function. See if you can't implement this yourself, and if you still need help feel free to ask.

luvfords




msg:4292658
 7:56 pm on Apr 5, 2011 (gmt 0)

Thanks for the suggestion.... all I get when I click on the link is Google, I guess the problem I have been having is that I do not know how to search for it in Google. I see there is a long link here, but as I said it does nothing except to go to the Google page, maybe I am missing something obvious... I get the impression it was a structured Google search there? I believe if I have the query I can implement it as I seem to do OK with others.

eelixduppy




msg:4292660
 8:00 pm on Apr 5, 2011 (gmt 0)

Apologies, been on leave for awhile it seems the URL redirect script does not allow links to google searches any longer. Try this:

[webwiz.co.uk...]

luvfords




msg:4292662
 8:02 pm on Apr 5, 2011 (gmt 0)

What I meant was.... I know how to use Google, I do not know how to ask for what it is I am looking for, concisely and correctly. So maybe I need help in asking the question, too.
John

luvfords




msg:4292672
 8:27 pm on Apr 5, 2011 (gmt 0)

Yes, that page will of immense help to me! I will study it tonight when I get home. Thank you very much.
John

luvfords




msg:4292705
 9:04 pm on Apr 5, 2011 (gmt 0)

Reading that page you suggested helped me formulate what I wanted to ask, and I quickly found this SQL help page: [techonthenet.com...]
Maybe someone else can use its advice too.

luvfords




msg:4293388
 8:37 pm on Apr 6, 2011 (gmt 0)

I was successful in finding what I needed it really is not a complicated query but without the help of this Forum I could not get my needs properly stated. Thanks for your assistance.

eelixduppy




msg:4293686
 2:15 pm on Apr 7, 2011 (gmt 0)

Glad everything is sorted out.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved