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:
View Replies
ADVERTISEMENT
I have a table in SQL2000 called EmployeeID and a column called UserName
I have a form which grabs the data inputted: Code:
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
there is any way i can check if the database Exists. I mean from the code side. I dont want it to throw me any error thats the reason.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
I want to redirect the user to the page that they came from?could someone give me the code
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
For this i used:
response.contenttype="audio/mpeg3",
response.binarywrite("binarystreamofmp3file)
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.
View Replies
View Related
When I insert info into a DB from a form, it cuts the string off at the first apostrophe (").
How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data:
View Replies
View Related
I put in some code to keep apostrophes from being a problem. However, on the
display page, they have double quotes. What am I doing wrong?
Here is the code on the page which captures the data from the form, right
before it gets entered into the database:
------------------------------------------
strInternalDesc =
Replace(Replace(Trim(Request.Form("InternalDesc")),"'","''"),vbCrLf,"<br>")
------------------------------------------
then, on the page where it gets displayed, I get:
View Replies
View Related
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
View Replies
View Related
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)?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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")
else
close rs
close conn
end if
%>
View Replies
View Related
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:
View Replies
View Related
i got an error saying file not found 404 when redirect to html page
and i ensure that the file is found in the same directory and in the database :
response.redirect results("Url")
where Url is the column name in the database that contain the page name.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
i'm going to ask the way to use database to check user permission level in asp..
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
