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:
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 having a bit of trouble with an ASP form that I'm maintaining. Someone else wrote it and I'm new to CDO objects. I have a CDO.Message and a CDO.Configuration.
I set up the configuraton fields for the port and smtp server's ip address to be used. The configuration property of the message is set to be the new configuration object.
Then there's a ton of stuff appending bits and pieces to the text body.
Finally we have the message's Send method being called. That's where it breaks.
It seemed to just stop working one day. When I submit the form, the message returned is simply:
error '8004020f'
I know from the MSDN website that this error code means 'Failure in obtaining user token.' What I don't know is how to fix it!
I have a problem when a user login to the site and when they tried to write or reply a message to other user I got this error message:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/write.asp, line 122
800401f3
I am running windows 2003 server with IIS6 installed with all the access component install. I am not sure what causing it. The weird part it sent or reply messages to the user but it just give that error messages. I had include the error code below write.asp I only copy and paste half the text in here. Code:
I want to do error handling in my application. I have made a complete application. but when I encounter errors. I want to do error handling. how can I do it?
I mean like in this case I can see if the record is being added duplicate then I can always check for duplicate records and throw a message. but I will face so many errors like this??? do we have a list ..whereby I can get all the error numbers and there meanings and I generate my own user-friendly errors?
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
I have created a New Users registration form for my database. The User enters there details such as email, account, name etc, and then clicks a Register button. This should send an e-mail to the User with a link for them to click to activate there account.
When i click on register however, i get a page not found message. When i try to diplay my Confirmation page, i get the error mention ed above.
I have a form that I want the user to fill out. If they dont fill out the whole thing, I want the form to reload and an error message to be displayed at the top of the page. Here is the jist of my code:
Error Type: Microsoft JET Database Engine (0x80004005) The Microsoft Jet database engine cannot open the file 'c:inetpubwwwrootannoneil\_databaseannoneil_AN D.mdb'. It is already opened exclusively by another user, or you need permission to view its data. /annoneil/artist.asp, line 96
The code was working fine a few days ago but now I cannot figure this out.
I have a database that holds information in many tables. I have created an "Update" and an "Insert" form in dreamweaver MX 2004 which work fine but it allows me to add duplicate names in to the database. Does anyone know of any codeto stop this. If possible i would like it to bring up a pop up saying "Client Name Already Exists" etc
I have an .asp page that correctly queries a table and returns data if a 'job number' and week ending date exist and the user can update the information that is there. What I need to do is, if a record does not exist the page needs to create one and then refresh/requery so the user can edit the data. Any suggestions on how to accomplish this?
i have a textbox for user to put there loginid...and one button login valiablity...where user can click to check this userid is available...till here everything is ine...suppose between this another user registerd with same userid..and now first user will put this user id than it will get non avaliblity of this id.so in such case what should i do?
I have built a page that lists all our databases, the users connected to each database, and what application they are using. Because these databases are moved, or removed from time to time I need to check if the database still exists before trying to query it. Otherwise I get funny SID errors when it tries to process this command:-
Just wondering if someone could look at this and see where I may be going wrong. The basic concept is to use FileSystemObject to see if an image exists. If it does, display the image. If not, display image does not exists message.
<% Set fs=Server.CreateObject("Scripting.FileSystemObject") strFilename = ="e:path oimageprodPixscienceTN" & (RecordSet1.Fields.Item("ID").Value) & ".jpg" If (fs.FileExists(strFilename))=true Then %> <%=(Recordset1.Fields.Item("ID").Value)%> <% Else Response.Write("No Image Available") End If set fs=nothing %>
I populate a recordset and dump it into an array. How can I check if a value exist in the array? I want to check if the c_Member_mgr has a particular value or not?
Dim rs2 set rs2 = Server.CreateObject("ADODB.Recordset") rs2.open sub_Emp_Source, Conn
Dim aSubordinates
If not rs2.EOF then
aSubordinates = rs2.GetRows()
'Close Recordset to use the new array with the 2 columns data rs2.Close() set rs2 = Nothing
'Declare Constants for the above SQL columns for better readability 'Use these Constants instead of referring to the array numeric indexes Const c_Member_Mgr = 0 Const c_Subordinate = 1 Const c_EmpID = 3 Const c_EmpName = 4
I'm building some dynamic image links based on if the image file exists. How can I check 'if files exists' using asp or javascript? I've messed around some with FileSystemObject but so far no success.
is it possible to check a table exists before opening the record set? We have a sql query that requests information from a table depending on what information the user enters. So if the user enters information that requests a table that does not exist then I get the following error -:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'y2005m12'
therefore is there a way to check the table exists before running the query or opening the recordset, and therefore redirecting the user to a different pages informing them of the problem?
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 want to check whether a particular table exists or not in a database as we check whether a particular record exists in the table using Count(*) function.I get the table name from the user and will have to check whether the entry that he has given is a valid one or not. how to do this?
I have a left menu that is accessed and displayed via XMLHTTP (it resides on the same server). Some sections of the web site don't have a "menu.asp", so a "Page Not Found" page is returned, which doesn't look great in the menu column.. Is there a way to know if a page exists before using xml.responseText to pull it?
I have a problem with asp encrypt. I always encouter this error message when i try to log in my system thru an IP address. The strange thing i that, onli my computer is experiencing this problem. I tried loggin in using another computer, with the same IP address.. and it's sucuessful. Izzit the problem wif my ASP encrypt or wad? The error i have is:
how could I know if a specific sessionid still exists or not. If there is a method or anything that can tell me about the existence of a specific sessionid .