| Author |
Can ASP or ACCESS create a database search report?
|
|
| MalRom 2005-12-30, 3:17 am |
| Hey there, can anyone advise if the following is possible and if so how it
might be done?
I have created a site using DWMX04, ASP & ACCESS.
I would like to be able to have some sort of report on what is being searched
on the database.
Can this be done in ACCESS or by using ASP?
Any ideas or suggestions would be great.
Mally.
| |
| John Waller 2005-12-30, 3:17 am |
| > I have created a site using DWMX04, ASP & ACCESS.
Good information.
So your site is remotely hosted on an ASP-enabled server?
Your web page connects to the database on the host?
Got a URL?
> I would like to be able to have some sort of report on what is being
> searched
> on the database.
Can you outline your vision in a series of steps?
You want to know what is being read from the database?
What info do you want?
> Can this be done in ACCESS or by using ASP?
Probably. See above.
--
Regards
John Waller
| |
| MalRom 2005-12-30, 3:17 am |
| Hey there, my site is not hosted yet but will be in the next week or two. The
site will mostlikely be hosted on a server that supports ASP as it is the only
language I am remotley familiar with.
All I am looking for is some sort of report on what items are being searched
on the Access database.
A good exaple is we have 50 types of cloth on a database. We just want know
know how many times each cloth detail was called up. This would give us a good
idea on what cloth is more popular.
Information can be simply just a column in the database or even a asp file on
the web which the admin department can view at any time.
Nothing too flash, just looking for a number realy.
Cloth A Searched 54 times
Cloth B Searched 01 times
Etc.
Mally
| |
| MalRom 2005-12-30, 3:17 am |
| Also, who searched and when they searched would be good to but not realy neccesary.
| |
| MalRom 2005-12-30, 3:17 am |
| Also, who searched and when they searched would be good to but not realy neccesary.
| |
|
| MalRom wrote:
> Also, who searched and when they searched would be good to but not realy neccesary.
>
Hi
You could grab the search form value and insert the value into the
database. Once in the database you can use Distinct and Count to tot up
the information from the database.
This tutorial should help with the totals, the addition of the search
info should be straight forward, it would just be a basic insert of the
search form values, asp isn't my bag so I'm not 100% sure of the syntax
for the value checking.
http://www.communitymx.com/content/...e.cfm?cid=88C8C
--
Cheers jojo
Team Macromedia Member Volunteer for Dreamweaver 8
http://www.webade.co.uk
http://www.cmsforbusiness.co.uk
----------------------------------------------------
Extending Knowledge, Daily.
http://www.communityMX.com/
Free 10 day trial
http://www.communitymx.com/joincmx.cfm
----------------------------------------------------
| |
| bregent 2005-12-30, 6:29 pm |
| >Also, who searched and when they searched would be good to but not realy
neccesary.
You are basically in need of an audit database. Your criteria is simple
enough. Just create a table to store the info you want to audit, and then as
JoJo suggests, insert a row when the user hits the search button. The row will
include the user id and search criteria. The table can be setup in access with
a timestamp column that automatically logs the time, so no need to worry about
that in ASP.
|
|
|
|
| Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |