If I have two different kinds of users on my website say simple posters and moderators, how do I differentiate between the two on my site while they move from page to page. I mean, I cannot append the user type ids with the web address to transfer the value from page to page since anyone wold be able to alter it. If the value is accessed from the DB every time a user requests for a page, then the program will become inefficient, wouldn't it?
View RepliesI am doing a webpage which allows different users from various departments to do a search/print information of people within their own department. I have a login page for user to key in the correct password and id before they enter the system. However, in order for the restriction to take place, I will have to ensure that the system recognises the person that is logged into the system.
View Replies View RelatedI am looking for some help creating a login page. I want to have a Access DB with the username/password/forward address. I want it to forward the user to there page depending on the username. I have seen many login pages but none that will forward to a web page depending on the username.
View Replies View RelatedHow to identify with ASP that value is a Numeric or Date or String ?
View Replies View RelatedI have been using css to identify what link (page) the user is on by using body id. The site I am developing has alot of pages, so i am hoping this can be done easily using asp.
Here is an example of what I am after The user clicks on say Testimonials goes to the testimonials page and that link is highlighted.
i have created an array from recordset containing user names eg. (davidp, davidp, evenf, patricka, rebeccah). which i have sorted in alphabetical order, but i need to
identify duplicates in this array and the number of times it has been duplicated.
We've created a video application that allows "voting" for videos, to determine prize winners. We want to restrict each computer to one vote per day. What is the best way to do this without requiring the user to log in? A login app is not in the client's budget, nor is it doable from a time standpoint. Is detecting IP address in ASP reliable for the average user? Cookies seem easiest, but they also are easy to wipe out.
View Replies View RelatedI need to write some special logic in my ASP.NET page. If the page is visited by a human visitor, I want to show an advertisement. If the hit is from any search engines, I do not want to show the Ad.
How can I identify if the hit is from a human visitor or search engine? Is there a server variable I can compare with the list of available search engine names?
in one part of my application i have some kind of user and password form. it asks for e-mail and a costumer id (as password), the costumer id must be a number, it's an INT in the SQL table. i tried to use a javascript checking method, but this kind of checking method seems not to work at all in firefox, so i'll do the checking via asp. what i need to know is how to check if a some VAR got anything except numbers in it?
View Replies View Relateddoes anyone know of a way to check if a process is running on the server... using asp ? I basically have an html form and upon submittal of the form ... i would like to redirect to the response page when a certain process is no longer running . the logic is as follows Code:
1) user enters form values and clicks submit button
2) server side asp checks the server for a process "wpuba.exe"
3) if "wpuba.exe" is not running .. redirect to page2.asp
basically I want to wait for the "wpuba.exe" process to terminate before redirecting to the response page.
i have 2 application variables called totalAdminLoggedIn and totalUserLoggedIn
when ever an admin login, I increment the totalAdminLoggedIn value by one
and when a normal user logg in, the totalUserLoggedIn value will be incremented by one.
how can i change the values when the session expire ? i can reduce the value manually when they logoff like:
if session("userCategory")="admin" then
Application("totalAdminLoggedIn")=Application("totalAdminLoggedIN")-1
elseif session("userCategory")="user" then
Application("totalUserLoggedIn")=Application("totalUserLoggedIn")-1
end if
session.contents.remove "userCategory"
but what if the session expires automatically or if they close the window suddenly?
ie. i want to do something like below? Code:
I got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";")
For nX = 0 to UBound(aList)
strarry=split(aList(nX),"_")
var_year=left(strarry(2),4)
var_month=mid(strarry(2),5,2)
var_day=mid(strarry(2),7,2)
var_date=var_day&"-"&var_month&"-"&var_year
var_time1=mid(strarry(2),9,2)
var_time2=mid(strarry(2),11,2)
var_time=var_time1&":"&var_time2
set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')")
Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
I have written an ASP.NET 2.0 application that uses Active Directory or ADAM
to manage account users - the site has a page that allows people to create an
account (much like any site). The page populates the AD with all the
information and the user account but I am unable to enable the account.
Microsoft has information on how to do that here -->
http://msdn.microsoft.com/library/d...ting_a_user.asp
(the sample is for Visual Basic) - and I am unable to complete the bottom
portion of the script. Can some one point me in the right direction - or can
you tell me how I can add a snippet of VBscript code to an ASP.NET page.
I am using the Active DS Type library - not sure why there are multiple ones
(System.DirectoryServices) but it is rather confusing - I seem to accomplish
one thing with one and another with the other (they did have trouble
co-existing however). Anyway my script works very well but I am not able to
access the properties required to enable the account.
Here is a simple version (no error checking) of the code.....
how to go about setting up an asp script or flash action script to take the input from a user of his/her username and password then send an email to the user with the information. I am able to do all of this but the problem is that the users pc is the one sending the email. I want the server to send the email instead.
View Replies View RelatedI am trying to send a fax from my asp application and am getting the follwoing error on the hghlighted line:
Error Type:
(0x80004005)
Unspecified error
If anyone knows why..Code:
I have a table with four fields, ID (auto increment), question (varchar(200)), answer (Text), and shop (tinyint(3). When I connect to the database in an ASP page and write this code
Response.Write rs("question") & "<br />" & rs("answer")
I get an error that reads "Type Mismatch"
but if I change the type of the answer field to type varchar I don't get the error but am limited in the length of the field's contents. I just also noticed that if I keep the type at TEXT and change the collation to ascii_general_ci I don't get the mismatch error but all the ' characters turn into ? characters? Oh woe is me.
I was looking for an app that i could use as a glossary, though i'm not sure how you would refer to it.
Basically, something that has 0-9 and A-Z with a search feature, by hitting G, all the items starting with G would appear, etc.
I am moving a mySQL db from one server to another. My backup sql is coming from phpMyadmin and I am using another 3rd party db admin program on the server. I am copying and pasting this code:
View Replies View RelatedI have an access database, with a form field "scores", which is a text field. This is the code (i have included the database code in the script btw):
<%
Dim scoresql,scorers
scoresql = "SELECT * FROM users"
Set scorers = conn.execute(scoresql)
Do
scores = Split(scorers.fields("scores"),"~")
Response.Write(scores)
scorers.movenext
Loop while not scorers.eof
%>
I can't tell what's wrong.
if you can I am getting this errror:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'FormatDateTime' /bb/aspBoardDetail.asp, line 57
<tr><td><font face="<%=abFont%>" size="-1">When: <%=FormatDateTime(adoRs.Fields("msgTime").Value, 2)%> <%=FormatDateTime(adoRs.Fields("msgTime").Value, 3)%></font></td></tr>
After about 30 minutes of frustration I finally discovered what was
causing a general 500 internal server error and to my surprise it was
something I seem to always take for granted for its simplicity. A type
mismatch error trying to compare a string to a numerical value, which
is something that PHP has no problem or qualms with. However, this
continuous problem continues to haunt me year after year and has
brought me to tears with frustration. This is the line that raises the
error:
nID = Request("ID")
If IsNull(nID) Or IsEmpty(nID) Or nID = 0 Then
.... (and so on)
In the past I've written a function 30 lines long that compares values
by confirming value types of the variables first, but I would rather
put a gun to my head than do that. Since there are obviously other
bright PHP and ASP developers out there that constantly trip over this
problem, I would like to know your suggestions or methods of working
around this.
I am new to ASP programming and I am trying to get an existing website to work.
I have created the following function to get the day:
function nrDate()
nrDate = DAY(Date())
end function
But when I use the page it gives the following runtime error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'DAY'
I have googled the problem for hours but cannot find anything that may be helpfull. Does anyone have any ideas because this is getting quite urgent and I cannot move forward without this function.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getTableFields'
Line is commented.
set exclusions = Server.CreateObject("Scripting.Dictionary")
exclusions.Add "id", true
exclusions.Add "timestamp",true
set tableKey = getTableFields("CIL_Addresses",exclusions) ''''TYPE MISMATCH ON THIS LINE
May be helpful to see getTableFields()
Code:
Any Idea what this might mean?
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]' /App/Director_Appraisal_Results_Saved.asp, line 444
Does anyone know this type of error means?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use ''(unknown)''; file already in use.
/asp/PPLMain/memberpage.asp, line 10
and in my line 1o is
RsMember.ActiveConnection = MM_connPPL2_STRING
This works before but then it went like this. Anyone can help?
I am receiving the following error:
Type Mismatch '[String ""]'
Here is the code that the error seems to be referring to:
For i = 0 To UBound(Duties)
dblTotal = dblTotal + Duties(i)
Next
Do I need to convert these variables to Integers?
How do I set the Files of Type to only jpg extensions from this <input type="file" value=".jpg" name="File1" size="20"> the red above wont work.
View Replies View RelatedI use Server.CreateObject("MSXML2.ServerXMLHTTP") etc to grab the content of
another asp page.
I want the other asp page to look like an xml document. So I set the header
to text/xml with the line
response.contenttype="text/xml"
I set this on the calling page and the page that is called.
When I view the headers with http://pgl.yoyo.org/http/server-headers.php it
is still set to text/HTML. Also the browser displays the page as if it were
HTML, not XML
What data type do you use for this input -- uyen8976? how do you convert it to a string? how do you query it?
I tried to create a table in sql with this field
invoice char not null
inv=request.form("inv")
qInvoice= "select invoice from ItemMaster where invoice=" + cstr(inv)
rs.open qInvoice, "dsn......"
when i tried to query this field, computer didn't understand what cstr(inv) was. It kept reporting errors.
However, i couldn't use varchar data type for uyen8976 either. The computer didn't let me convert "uyen8976" into a string.
I pass session variables in a querystring to another page, which increments an array and adds them to it. This had been working absolutley fine on my local machine and I uploaded the scripts to a remote server. Everything worked fine (and still does) on the remote server.
I then decided to try opening the script that receives the querystring in a popup with javascript window.open, to display the results in the popup instead of a full new page as before.
When I tried this I got a Type Mismatch on the receiving page. I hadn't changed any of the code in any of the pages apart from calling the receiving page with window.open, so I thought it just didn't like being called/opened that way. So I removed the window.open and went back to the old way - and I still get the Type Mismatch.
I couldn't see why it was throwing this now, so I downloaded the scripts from the remote server (which work fine) to my local machine and I still get the Type Mismatch on the local machine. I tried stopping and starting IIS and then rebooting, but to no avail. It still works remotely but not locally.
The mismatch is occuring apparently between the String I'm trying to add to the array and the array index (which is also a session variable): Code:
i am getting a type mismatch for a page i am trying to write. Code:
View Replies View Relatedi'm getting a type mismatch error
conn.Execute "DELETE FROM Bmemo WHERE (tDate <= '" & date() & "')"
tDate is a date field in an Access database
Like so many, I will preface my question by saying I'm a complete ASP noob. I am however very experienced with PHP/MYSQL so I understand the concepts, it's just a syntax problem.
I have the following:Code:
sqlGroups = "select groupName from Groups where groupID = '" & rsParts("groupID") & "'"
set rsGroups = Server.CreateObject("ADODB.Recordset")
rsGroups.Open sqlGroups, strConn
response.write(rsGroups("groupName"))
This is resulting in a type mismatch error. rsParts("groupID") is from another recordset in the script, of type Long Int. groupID in the Groups table is autonumber, also of type Long Int.