Search Query Logging
how I should log search queries, perhaps adding the queries to a text file. I want a way to be ble to log srch queries on my site search.
View Replies
ADVERTISEMENT
Search Query
I made a little search query asp page connected to a database everything works. Just I added a if then statement but...I don't think I am doing it correctly...
This is my code:
strSQL = "SELECT last_name, first_name, zip, email " _
& "FROM [sample] " _
& "WHERE last_name LIKE '%" & Replace(strSearch, "'", "''") & "%' " _
& "OR first_name LIKE '%" & Replace(strSearch, "'", "''") & "%' " _
& "OR zip LIKE '%" & Replace(strSearch, "'", "''") & "%' " _
& "ORDER BY last_name;"
Set rstSearch = cnnSearch.Execute(strSQL)
%>
<% If strSearch = "true" then %>
<% Response.Write "Search Result" %>
<% Else %>
<% Response.Write "We are sorry your search could not be found" %>
<% End If %>
Sql Search Query Problem
I have been working through a search distance by postcode tutorial. the script works fine when used with an access database however i need to use it with mySql but its throwing up this error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.11-standard]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND Selectmake = 'Audi'' at line 1
the code its refering to is this:
Dim rsResults
Dim rsResults_numRows
Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.ActiveConnection = MM_conNatCarSearch_STRING
rsResults.Source = "SELECT * FROM Adverts WHERE Trim(Left(yrPostcode, 4)) IN (" & yrpostcode & ") AND Selectmake = '"& _
Replace(rsResults__MMColParam, "'", "''") & "'"
rsResults.CursorType = 0
rsResults.CursorLocation = 2
rsResults.LockType = 1
rsResults.Open()
Ive tried altering the code but nothing seems to work. does anyone know what it could be as i'm stumped!
Search Query Problem
have a search.asp page with results.asp page drawing data from an SQL db,
problem is the user has to type the whole field value into the search box to
retrieve the value on results.asp, what I need is to type in just a few
characters e.g. at the moment to search for all pickups at Heathrow Terminal
1 the user has to type in
Heathrow Terminal 1
When really I just want them to type in
Heathrow or even Heath etc.
Query below
SELECT * FROM booking_form WHERE AirportStation LIKE '" +
Replace(BookingForm__varAirportStation, "'", "''") + "'
Advance Search Query
I have an Access db with a table which contains some fields. I have also created a page in which I have created a form with textfields, listmenus, radio buttons and checkboxes.
I would like to pass the values from the form in another asp page in which I will retrieve the records according to the selections made in the form.
If I select all the form fields it works great but if I want to select
only two or one field I get nothing. That is because in the SELECT code I have used AND...AND.... Is it possible with if statements to avoid this problem?
Weird Error On Search Query
i'm trying to make a form that will pull details from a record that is found with (asset Number) but comes up with this error: 2342 "A RunSQL action requires an argument consisting of an SQL Statement"
Dim SQL As String
SQL = "SELECT *"
SQL = SQL + " FROM Computer"
SQL = SQL + " WHERE (((Computer.Asset)=" & TxtAsset.Value & "));"
DoCmd.RunSQL SQL
Search MySQL Database Query
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
ASP Search Using Query In Access Database
I have an Access database that I created a query in. The query brings fields from related tables and prompts users to perform a search based on 3 criterias.
NOTE: the prompts can be bypassed by just leaving it blank and selecting OK. So in other words, the user does not need to fill in each prompt for the search to work, it just give them a more narrowed down search if they fill more in...
Now for the ASP part... I want to create an ASP page where the use selects from 3 drop downs. These drop downs are named the same as the field names in my query. How do I get this to work??
Mission Impossible, Or Possibility - Search Query
I have a field storing Multiple information in a string (ex: <Select name="MUnionCode" Multiple>
This allows the user to select multiple options. These options are stored in an spl database as: option1, option2, option3 etc..
Now, if I want to search that field how can I have it check to see if any of those options are within that string..? Instead of just checking the first option...?
Asp Search Returns No Results From Access Query
here's what i want to do. from an asp page, perform a search on a
table in access. i have used sql code in the asp page itself, but i'd
rather execute a query in access. i have success in running any query
(basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for
some reason, when i execute the query below from the asp page, i get
no results.
the search.asp page just has a text box in a form that submits the
srchBOX field to the results.asp page.
here's the asp code from the results.asp page: Code:
Logging Downloads
I need to log how many times one spesific file is downloaded from my
website. First I thought this could be done simply by routing via a script
that count number of downloads, and then redirect to the spesific file. But
this soultion will not work when a user right click on the file/link and
choose "save target as...". How can I solute this?
Logging Out W/o Going Back In
I'm trying to make a logout link to where once someone logs out, not only will they be sent to another page, but they will not be able to go back into their account by pressing the back button, but by logging back in.
View Replies View RelatedLogging In Session
how would the site know that that specific user has logged in?i know that once the user registers, the username and the password gets stored in a database and once the user logs in, the password and the usrname gets searched against the password and the username in the database.what if i want the users details to be outputed such as address and name once they log in?
View Replies View RelatedLogging Users Log
i would like to automitically log when a user signs in, presumably using a seperate Access database. Can anyone point to to a simple way of accomplishing this?
View Replies View RelatedLogging IP Address
I would like to log the IP Address of users browsing my page. Hoewever, using the "REMOTE_USER" from the Request.Servervariables only logs the proxy that all users who access the page willl have to through.
Is there any way how I can log the actual IP address of the user? I thought of Cookies or something like that, but i really do not have any clue. Or tell me if its not possible so I can stop working on it.
Custom 404 And Logging
I'm developing an application that uses a custom 404 page to deliver all of my site's content. However, doing things this way renders IIS's regular log files pretty much useless.
Are there any established "best practices" for creating your own logging system? I know that others use this technique and I'm hoping someone has some ideas they can pass along. For example, do you log every single page request or do you just log totals per day, week, or month? How do you deal with the increasing volumes of data? Do you collect referrer data, etc.?
Update Logging
I've got a number of ASP scripts updating a particular SQL Server table. However, this table is being updated incorrectly by one of the 10 scripts. Is there a way to log all updates so I can troubleshoot the problem?
View Replies View RelatedASP Error Logging
I have experienced some ASP errors in my web application and I'm unable to reproduce those errors because IIS is configured in a way that does not send any debugging messages to the user (and I cannot change it). Only standard string "An error occured on the web server when processing the url..." is sent.
So Is there any way to log such situations to the eventlog, a file, database or any other storage? OR Is there any way to allow me to send only piece on debugging information to the user. In other words: I'd like to send error code that would be understandable only by me?
Logging In System
I have a page where a user enters his or her login details after registering. After clicking login it takes them through an asp page which verifies that they are a valid user. However I have come across a problem Code:
View Replies View RelatedLogging Off From A Website
I am amazed at how much help I have had in creating my first asp based
website from this forum. There are obviously a significant number of real
experts who are happy to take the time to help us novices. My site which now
does what it aims to would not be working without this assistance and I am
extremely grateful. Code:
Logging Read Receipts
How can I log read receipts?
Is it possible to insert or grab an existing message ID (from the header
etc), log it into my DB, than once the read receipt is sent from the clients
machine, pull it off my pop server, parse it and than log that it was read?
Any suggestions?
Logging Access Attempts
I have an asp application that allows users to access certain documents based on their ID and security level. This works fine, but I want to be able to log access attempts so that any potential abuser can be given proper warnings, etc. Basically, if I'm Attorney A then I should be able to access info on Case X, but Attorney B should not be able to, and any of his attempts to access Case X should be logged somehow.
I found the following script online that should capture the IP address of the offending machine, but when I test it I only get errors: Code:
Logging Off Inactive Users
On my site when people log in it changes a field in my database from 0 to 1 the website reads in all users marked as 1 as online.
When the users log off it marks them back to 0 and they are marked as offline unfortunately most people never log off. Whats the easiest way to log them off automatically? I have included some of my code below: This shows the members online: Code:
Logging In Pull More Info
this is a continuation of my little login page I am setting up.
the login pages authenticates the user using Active Directory.
I also have a Database locally in MSSQL that has the users ref number (primary key, incrementing) first name, last name, and user id (same user id as ldap/AD etc)
what I want to do is when the user logs in the page will call the Database and grab the full name as well as the ref number. Later in the page if the user submits a form to add data to another database I want it to populate a column in a table using the ref number. that should be rather easy once I actually have that ref number.so how would I tell the page to go to my database and grab his ref number (as well as his name to be able to display Welcome first Lastname instead of userid?
Logging Off Windows 2000 From IIS
I will be traveling and I will need to show someone a
secure folder in an IIS website and I will be on a public
computer. When we are done, I will need to be able to log
off so no one else using that computer will find
their way into that part of the website. The security is
Windows authentitication using Clear Text.
Can ASP log me off. If so I will need to code this before
I leave. Can anyone point me to where I can get some
examples of code to do this ?
Call Logging Scrpt
Has anyone seen any ASP code that will use and Access database for users to log into and Document calls they recive inbound and make outbound
View Replies View RelatedLogging User Visit
I am building an ASP application, in this application, one of the functions is that I have to know exactly how long a user has used a certain page of the application. so I need a way to long the time a user enters a page and when he leaves again.
when the user closes the browser, no time for leaving isrecorded.Is there a way to run a web service that can read cookies of all the users and write them to a database? Or am I looking too far for the solution.I'd like a clean solution, not with popups, or opening other windows in order to run extra asp code.
Logging In To View Information
What is the easiest way to set up an area on my site where I can allow people to register and login to view information? I know this shouldn't be too hard, but I've never had to mess with it before. I have a mySQL database at my disposal.
View Replies View RelatedLogging Off By OnUnload Caused By Refreshing
I have a application online using ASP in which users log in and log out. However, a lot of users simply close the window, bypassing my log-out script. I have tried using the Javascript onUnload function with success, but refreshing the screen also triggers this at the wrong time
View Replies View RelatedLogging A Session End Time To Sql Table
I have a web app that doesn't utilize a specific logout screen (even if it existed, the clients would probably just "x" out of the app anyway).
I would like to track users' sessions, and I can insert into a user_log table as part of the login process, but how do I capture when a user ends their session? Can I update a sql table somehow in a global.asa file - using "onSessionEnd"?
Dynamic Online Logging Form
Basically i want to pull a record from a table and based on a few records build a input form.
The idea: I want to be able to design a online logging form, using 4 fields in the table inc_label, inc_group, inc_required and inc_type.
Inc_Label is the name of the item.
Inc_Group is the name of the Group.
Inc_Requried is if the item is required.
Inc_Type is the item type.
Code:
Type Mismatch: 'CDbl' When Logging In
I have login page that fails the login on the validate page and gives me the Type mismatch: 'CDbl' error.What I find funny is that I didn't notice that was happening until I assigned one User a longer password (xxxxxxxxx2004) but if I login in with password for another user and they have been using this (xxxxxx2004) then everything is fine.
I can't see the code to be the problem or can it. Password field is a varchar (200).
Would somebody have a suggestion,because earlier in the day I was able to create a smaller lenght wise password for this case and it worked if I do that now it fails as if I have incorrect userName or password.
Logging Errors With ASP 404 Error Pages
When I had just setup my web site with IIS 5.0 the error
log contained the 3 things I needed for my site stats
page.
The page that had that not been found (i.e.
site.com/nofile.html), the error number (404) and the
referrer (where the person came from to get to the bad
page); Now when I try to use my custom 404 page it only
logs the error number. How can I setup my page to log the
referrer and bad file page?