Redirect If User Exists In Database - Having Problems With Apostrophes...
I have a page where students can choose activities in a day... this then directs them to their timetable for that day.
However, if they go back to the choose.asp page and they have already registered, I redirect them to timetable.asp - because I don't want them to change their options.
I have their username stored as a session variable and it works fine for most students - however for the example student O'SMITH-JONESMark the page falls over.
I am using Dreamweaver's 'redirect if username exists' server behaviour. Code below... Can anyone tell me how to fix this so the code is not tripping up over the odd characters? Code:
I'm wanting to do a simple controlled voting page. I too our webserver off anonymous and everyone who accesses the website is a domain authenticated user. I've already done some control structure pages based on Request.ServerVariables("AUTH_USER"), which works great. That's also how I would do this page, in my basic thinking.
My idea is to have an access database with two tables. One table will have the vote written to it and the other table will have the AUTH_USER written to it when the employee casts their vote.
I'm wondering how I would do a test against that table to see if their name has already been written to the table. So, if an employee votes already, when they go to vote again, their user logon would be tested against all entries in the table and if it exists, the vote would not be written and they would be redirected to another page that politely tells them they've already voted.
I'm currently workin on a project where by users have to register. I picked up some code from the internet but i get the following error: That username is already in use. Please choose another even though there is no data in my database yet. I'm using access 2000 as my database program. Code:
You'd think this would be the most basic sql query in the world but noooooo! I've tried this:
on error resume next strsql = "SELECT * FROM " & session("TablePrefix") & CurrentTable SET rs = conn.execute(strsql)
tableExists = 0
if (Err.number = 0) then tableExists = 1 end if
But it doesn't return an error if the table doesn't exist. I'm searching on the internet and hitting these long complicatred solutions involving the database "shema". Surely there is a simple way of telling with one line of sql if a table exists or not?
I've got a form that adds a record to a database. What I want to do is on submit, look at the records in the database to make sure no value in a particular column matches what the individual is trying to submit.
More simply, Form A has a field called "collection" which inserts into the database column named "collection" I want to make sure that the value in the collection field hasn't been used.
How can i check if a vlaue exists ? Sample to get the idea: Code:
set con=server.createobject("adodb.connection") con.open "Menu1" sTempquery ="Select * FROM Voorkeur Where gebruikersnaam = '"& Request.Servervariables("LOGON_USER") &"'" Set autor=Server.CreateObject("adodb.recordset") autor.Open STempquery, Con
The idea is that if the "LOGON_USER" does not exist in the Dbase he must execute code. How can i do that?
How do you set up the code to fire on a specific time. For example you want the user to see the page and the informaiton. But you want them to be redirected to a new page in 5 seconds.
How do you set up the script to execute the code in 5 seconds since the page was loaded.or maybe 10 seconds etc. Also is there anyway to have this count down on the screen using ASP? or would you have to use vbscript or javascript to do this?
i am making a web based kiosk. Just a bit stuck trying to find some code to re-direct users back to a 'start' page after a set time of inactivity from the mouse / keyboard.
I'm sure this is pretty simple stuff to a lot of you guys so hoping someone can help. Dont know if it would be a server or client side thing or what?
I'm trying to set up an asp script that redirects a user after a few seconds on a page- I cant use meta tags to redirect due to the page structure.does anyone have any similar scripts they could share?
Is it possible to redirect a user to another web page using ASP code located in page body?
I have some ASP code that runs after generating some output to the browser.It checks for a condition that can only be calculated using the values produced in the output, so redirecting the user before the <html> tag isn't possible without running the code twice.so RESPONSE.REDIRECT "url" won't work.
I have a SQL table with two fields (userID, and userName). I would to create a UserVerification page that would you either the AUTH_USER or LOGON_USER to validate their access. If they have access, send them page to the page(s) they tried to open and display the userName, etc; if not, redirect to an not authorized page. The trouble I am having (other than being fairly new to ASP) is:
How do I set up two session variables - one to hold the authorized status and second to hold the UserName from the UserVerfication page. Secondly, how to you set up the verification page to redirect them back to the requesting page, if authorized.
I have set of mp3 files as a list (DownloadFiles.asp). The user can click on any of the mp3 files to download(Download_Porcess.asp).After downloading the file the user has to redirect to the DownloadFiles.asp.
In Download_Process.asp to force the save dialog box. This works fine. This allows the user to download the file. After downloading this mp3 file, this file should not be displayed in the list ie in (DownloadFiles.asp).
How can i do this?
I am not able to redirect from Download_Process.asp to DownloadFiles.asp, b'coz I used response.binarywrite.
I have an apostrophe in an access database in a name. e.g. O'Brien. When I read this value back into some script the apostrophe seems to be terminating my script.Unless of course I have mis-understood what's going on Are there any rulesguidelines for this sort of data handling
Been a while since I've done any asp coding, but happy to be getting back into it. My question is what is the best way (now) to handle apostrophes coming in from forms and going into the database? I remember I used to use a replace function replacing single quotes with two single quotes in one of my old apps.
Is this still the best way, use this function on all fields I think an apostrophe may come in, or on all fields? Or should I use a javascript regular function (which may not even work due to a client disabling this feature on their browser)?
I did a search about inserting names that have apostrophe, and found something about escape apostrophe? how to do that? When the user tries to insert a name with an apostrophe it blows up. Also the delete page I have doesn't like names with apostrophes in the where clause.
I need to insert field data with apostrophes into Access. However, I keep getting "object expected" errors when I post. I heard about using the replace function like this:
var incidentlocation = Replace(Request.Form("incidentlocation"), "'", "''");
but I get the "object expected" error. What I am doing wrong? My code is below in the text file.
I am looking for script that redirects the user to another page if their IP address is in the database. I'm not sure how to deal with the extra quote marks in the server variable and I get "expected end of statement."
<% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/STEM/Social/survey/survey.mdb")) set rs=Server.CreateObject("ADODB.recordset") sql="SELECT ipinput FROM soctable where " & " request.servervariable("remote_addr") = ipinput"
if rs.eof =false then close rs close conn Response.Redirect ("results.asp")
I have a login pages right now that prompts the user for login and password and redirect the authenticated user to a URL (see code sample below).
Now instead of this I would like it to pick a URL (different for each user) listed in my access database (URLredirect) and redirect them to their personalized homepage. How can I solve this problem? Can anyone guide me in the right direction? Code:
I'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
I have been thinking about storing some data, which my users upload, in text files rather than database, since often I do not know how much information users submit for things like item description or images URL paths.
This information may be very short or very long. MS SQL Server requires a maximum field length to be set. Thus, if user enters 5 characters into 5000 character field, a lot of space will be wasted. On the other hand, the database reference would point to the text files to read users' data and display it on page.
Is there any way to use asp to determine a users SQL Server database access rights. I.e I have given a users data read only/ data write only in SQL server, how can I pick that up in an application so that only write only users can see a hyper link. I know I could create a few more pages with a table in a database with various rights but I just want to read rights directly allocated from SQL Server.
I am writing a small ASP booking engine which allows users to book a ticket provided the num_tickets field in my db table is > 0. Each booking causes the num_tickets field to be decremented. So if a user tries to book when there are no tickets left he gets an appropriate error message. However, if a user books the last remaining ticket and the num_tickets field is set to 0, he can simply hit the "back" button and book again (which decrements num_tickets to -1 and so on). Is there a way I can make the page refresh or expire to stop this from happening? is it a sessions problem?
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.
But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.
I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
I need code to capture a users ip address once they agree to a disclaimer (a form yes/no). If the user states no a message telling them they do not have access and a redirect back to the home page.
I need to put the ip address along with the date a sql server database. I am lost as to how to code this and also how to set it up in my directories.
I am having trouble trying to detect if no records are retrieved by the search. There doesn't seem to be a problem with the connection to the database or the SQL query. I think the problem is somewhere in my If statement. Code:
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
