Im having a bit of a trouble with this piece of code , basically what it does is allow a user to register with the site , then their deatails are added to a database , now what i want to do is RETRIEVE THE USERID value so that it can be passed to other ASp pages. when i run the register page i get this error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code:
I have a comments form that when filled in posts the comments from a text field into a database.Due to a bit of duff coding (Doh!) the database was not getting updated and i lost 50 or so posts worth ofcomments.
Is there any way of retrieving the posted forms from theserver?The form uses the post method, with asp doing the work.
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig/default.asp
or
http://localhost/site/craig/test.asp
or
http://localhost/site/craig/roger.asp?dan=1
is there anyway of retrieving the word craig so to use it in the page, I just want the word Craig
This is because i could have other addresses that are for example
http://localhost/site/jon/default.asp
or
http://localhost/site/jon/test.asp
or
http://localhost/site/jon/roger.asp
where i need to retrieve the word jon
at the moment i use the code
strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "")
intStart = instrRev(strURL, "/") + 1
strName = mid(strURL, intStart)
this worked fine until new pages are added ie a page that isnt default.asp
Obviously i cant use strURL = Replace(Request.ServerVariables("URL"), "/default.asp", "") because default.asp will change...
I am having a slight problem. I have an asp page called custfeedback.asp. This page contains fields where the customer fills in name, email address comments etc. The form gets submitted to feedback_complete.asp, where a message is displayed thanking the user.
My problem is that the variables in custfeedback.asp are not "retaining" their values when the user is redirected to the feedback_complete.asp page. I know the asp is working, because I have the following line in that displays correctly:
<% Response.Write (now()) %>
I have no idea why the variables aren't retaining their values. Does any one perhaps have any idea how or why this is happening, and how to resolve this problem?
within the intranet, all user are required to login.
How can I get the User ID and Domain in ASP page?
In ASP page, does any one knows how to get user network login ID from user email address? In my company, we use win 2000 server with active directory. In my ASP page, when input an email address, I need search to find the user network login ID.
View Replies View RelatedIs there any way I can get the logged in NT user ID from asp
page.
I tried "Request.ServerVariables("LOGON_USER")" but no use.
Our IIS 5.0 settings are as follows:
Authentications methods:
1)Anonymus access checked
2)Authenticated access - Integrated windows
authentication checked.
In my asp server page, I would like to collect the USERID, Client Machine Name, IP Address information and passing it back to the server for validation control. How can I achieve it in Jscript?
View Replies View RelatedI have the following page managerlogin.asp with a form and two fields: UserID and Password. After sending the form, login.asp is used to manage the login details Code:
View Replies View RelatedI have got rs6 to display the Usernames but when i try and link the username with the userID it shows this error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/viewpub.asp, line 121
set rs6 = objconn.execute ("SELECT * FROM favepub INNER JOIN members ON favepub.UserID = members.UserID WHERE PubID=" & PubID)
Pubbers: <% WHILE NOT rs6.EOF%>
<a href="viewmember.asp?UserID=<%=rs6("UserID")%>"><%=rs6("rsUser")%></a>,
<%rs6.MoveNext
WEND
%>
my page request userid and pass and after i login it loads to the main page but the problem is when i leave the page for 15-20 mins and comeback and click some links, i redirected to Page cannot displayed, and i wonder why?
View Replies View RelatedI see it everywhere.... Forgot username? Enter your Email and we'll send it to you.
How is this accomplished?
When a new record is inserted into access db it creates an id, how can I return this value for a record I have just created?
View Replies View RelatedI have the following code in my form:
Response.Write("<form name='Testing'>");
Response.Write("<INPUT type=hidden id='Testing_txtbox'
name='Testing_txtbox' value='a simple test'>");
Response.Write("</form>");
If I type the following in the very next line, I get a value of
"undefined".
Response.Write("value="+Request.Form("Testing_txtbox"));
why this won't work. and how I can retrieve values of hidden controls via Server side code?
I have a DTD xml doc and need to read the data from it and display it using ASP.
View Replies View RelatedI want to know if there is a way to retrieve the tag from the URL, I don't know if thats its name, so I'll just explain what it is:
showmsg.asp?FID=mn&ID=2467#2529
the tag, as I call it is what follows the # sign, the number 2529, in this case. so, is there a way I can retrieve the tag with ASP, by the request object, or any other way, any Ideas? Another thing I wanted to know, not related to this subject, is how do I change value of a textarea that is placed in another window with VBscript or JAVA. is it possible?
I have three different tables I will be pulling stuff from: user_info, img_inv, activitylog:
user_info I will be using their ID and state
img_inv I will be using part number
activitylog I will be using part number and date
I'm trying to select the part number from the activities list and match it with the img_inv to make sure it still exist. If it exist I want it to do a total count of how many times it has been looked at by 7 states within a given quarter. Code:
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in)
Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying:
<%
Response.write Request.Cookies(UserLName)
%>
But it gives me an error - I used Checky to make sure the cookies are there and they do exist:
Name:mascot
Value: UserLName=Tarby
Can someone give me some advice?
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
View Replies View RelatedIs there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig
is there anyway of retrieving the word craig so to use it in the page
This is because i could have other addresses that are for example
http://localhost/site/Jon
where i need to retrieve the word jon
I have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
I am trying to get a field populated in an oracle database with a time stamp of when a form is submitted.
I have found out that there is a table in Oracle called DUAL which holds the current date and time. At present i can populate the date when the form is submitted using objrs('sub_date')=date() but when i query the database the time element of the field sub_date, the time displayed is 00:00 which is the default time.
So can anyone give me any help in how i can capture the time. I know about select to_char(sub_date,'DD-MON-YYYY HH24:MI') which will bring up the time but i can seem to populate the field sub_date with the time.
I am trying to retrieve the page name. I know this is possible using Server Variable PATH_INFO. The problem I am having though is that when I get to a page in one of my subdirectories the subdirectory name is displayed.
Example: my page index.asp is in the the admin directory so the PATH_INFO displays as /admin/index.asp. How can I strip the page name out so I get index.asp. I cannot use the function Right() since the page name could be any length.
How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder)
- MikesWork.doc
- MyResume.xls
- HouseExpenses.xls
Situation
Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder.
eg.
Your Documents
1. MikesWork.doc (last modified 10/24/2003)
2. MyResume.xls (last modified 10/30/2003)
3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
I'm writing a vbscript application that reads UTF-8 XML containing Chinese
characters and stores the data in MySql 4.0.x.
Does anybody have any experience in this area with regarding codepage and
character sets? Ideally I want the scripts to be able to handle Standard
European characters and Chinese characters as well.
Are there any special considerations for using MySql/ODBC and ADO to get and
put the data.
Right I have my files going into the database, and once successfully uploaded, a user is shown a few bits of information in a table such as the primary key, name of file, its size and the content type.Now i want to create <a href> links on the homepage etc so that browsers/users can download these files one at a time. So when they click the link, the Save.Open or Cancel dialog box appears. Have been trying different things for few days now but finally thought I better ask for some help as Im gettin nowhere.
View Replies View RelatedI have a zipfile that is created dynamically for me on a webserver. I have the url of the zip sent as a post value to an asp script on my website.
In my asp script I need to be able to retrieve the zip file so that i may extract content from it using an asp zip component. Any idea how to retrieve the file?
I have a SQL statement to retreive results based on keywords entered
I only want to show the first 200 characters of the field though, how would I modify this code to do just that?
SQL = SQL + " instr( 1, lcase( description ), lcase( '" + aKeywords(i) + "' ), 1 ) > 0"
I thought it would have been something like:
SQL = SQL + " (left(instr( 1, lcase( description ), lcase( '" + aKeywords(i) + "' ), 1 ), 200) > 0"
i have a checkout page which lists the user and what they have puchased. however, theres a problem with this page as I cant retrieve the user from both tables in my db, Customer & Corporate. The error message that I received is:
Microsoft VBScript compilation (0x800A03F4)
Expected 'If'
/shop/check_out.asp, line 412, column 3
End
--^
which refers to the red line in the code below: Code:
I have an .ASP page that comes up, and I am trying retrieve a variable from
the previous .ASP page. However none of the variables from the previous .ASP
page are available to the current .ASP page. There are three pages in this
chain.
1. NewUser.html
Information is input in this page, and posted to the next page using this
tag <form method="post" action="newUser_response.asp">.
2. NewUser_response.asp
Information is retrieved from the previous page using the
<%=request.form("strADLocation") %tag, and then posted to the next page
using the <form method="post" action="newUser.asp" This page is basically
just a confirmation page, and just displays the information from the
previous page, and sends it to the next page.
3. NewUser.asp
This page is supposed to retrieve all of the variables from the previous
..asp page using this syntax strADLocation = request.form("strADLocation"),
and create a user account, but none of the variables are available to the
script portion of this page from the previous .asp page
I had a similar problem when I was trying to make variables available to a
..asp page from a .html page, and later found out that I had to re-declare
the variables in the second page which was an .asp page using this syntax
strADLocation = request.form("strADLocation"). Everything worked great at
this point(HTML to .ASP). The problem I am having is that I added an
additional .ASP page(NewUser_response.asp) in the middle, and I can't seem
to retrieve the variables from the previous .asp page. Now the chain is HTML
to .ASP to .ASP. If Code:
when i retrieving date the dates come out in american format
eg 01/28/2006
how do i get it so it come out in 31/01/2006 ?
is there anyway of retrieving the whole name from a file input rather than just the file name.I need to know which directory the file is located.
View Replies View RelatedI've got code to parse XML files locally, but I don't know how to retrieve them from a remote host. Can anyone upload some sample code?
View Replies View Related