Update Using Session Variable
I have looked and just can't get my head around any of it...maybe that's the problem when using Dreamweaver as it seems to put a lot of unnecessary code in!
Anyway, I have a user login page and i'm creating a session variable called Session("sessUsername")
I want to give the user the ability to change their password but I just can't do it.
The form has 2 textboxes to enter the new password twice (just as a check nothing more), how do I do the update where the Username = Session("sessUsername")
I hope this makes sense, here is the code that I have upto now. Code:
View Replies
ADVERTISEMENT
I've declared a variable for the current date and want to use the UPDATE function to update the date field in a single record.
UPDATE lms_users Set leaver_date ="&MakeDate" WHERE user_id="473"
I know I have the date format in the variable as if I response.write it to the screen is displays correctly (28/08/2004). I must be doing something really silly, but can't see it.
View Replies
View Related
i have a table 'Accounts' in my database, which contains a bunch of
users. From the main menu i choose "edit user" and all users in the db
are presented in a table. The first column 'Pnr' is a unique ID for
each user that i made appear as a link. clicking on one userID should
present a form where the picked users userdata is already filled in so
i can easily edit it and then move on to submit the form to update the
db. i get to the part where all users are listed nicely in a table,
but clicking on one, i get this error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested
name or ordinal.
/VS_Files/updateUserForm.asp, line 19
I think i'm doing something wrong with passing a value with the
querystring...? Code:
View Replies
View Related
i got a quick one for you guys. i've this session variable that is updated by calling a server method (i set this value when the user hits a submit button in my form. The server method is called when i load all my asp forms.). I'd like to be able to update this session variable, without being forced to submit my form or refresh my form (something that will call my server method each 2 min lets say, without refreshing my page or submit)...is there anyway to do this??? Maybe a remote scripting with the setinterval() method?? but i'm
having trouble using this with XP and IE 6!
View Replies
View Related
this is dependant on whether or not I can get my sessionID. This is assigned
by the server yes?
so...when I log in, I query what my session ID is, and then store that in a
DB along with a flag that says I'm logged in.
now, along comes someone else who has me in their buddy list, I think I can
query the sessionIDs and remove any records from the DB where the sessionID
no longer exisits. (not sure how yet but I'll work on it).
Then the second user will query the DB to see if I have logged in (and a
sessionID still exists). if so, his buddylist will show me as logged
on...although it could be 20 mins out of date, it's getting closer to the
real thing. Code:
View Replies
View Related
how to declare session variables and use it in insert and update sql statements... the scenario is I have:
2 html forms
2 ASP FILES
I am able to trap data from the first form into the acces table..but my second form(which is continuation of first form) has a update query....(ie...it shld update the same record the one inserted from the 1st form )..both the forms work on table in access db
its an annonymus...questionnaite...therefore i am not trapping any user name or login id...but the requirement is the survey made shld be unique....as in no user shld be able to answer the questions twice.
View Replies
View Related
I delete the files/cookies and clear history from the IE 6.0 browser and try to write in a text file use FSO but it dont write any thing in the file needs Code:
View Replies
View Related
I'm trying to set a session variable after displaying a form, then capture
the Session variable on postback. For some reason, the below code always
returns the form, not the "Step 2" results part.
What am I doing wrong? It's on a local network server, not on the web if
that matters.
<%
'* Step 2: Display results
'**********************************************
If Session("PageAction") = "view2" Then
Response.Write "Results"
'* Step 1: Display form
'**********************************************
View Replies
View Related
I have created a session variable.... and i have to write code to check for
this session for each ASP webpage in my website....Is there a alternative
I do not want to repeat the same code for valid session.... in each page..
View Replies
View Related
I first create a session variable 'client' in the login.asp file
The login.asp file opens a file (xxx.asp) with an include file
If I write
<!--#include file="../../../data/" & session("client") &
"/language_ger.inc"-->
I have a message stating that the application can't find the file.
If I write the path without the variable (" & session("client") & ")
<!--#include file="../../../data/eurovini/language_ger.inc"-->
it works without any problem.
Question
- is there is an error in the syntax?
- is it possible to include this kind of variable in an include file.
And if not, any idea to get the same result?
View Replies
View Related
I'm new and I hope I explain this correctly.I have a products page which populate products dynamically with checkboxes. when the form is submitted, I check for selected boxes using the split(). My problem is, products page submits the form to client.asp, and within that page is client info. then the client page is submitted to confirmOrders.asp, which will display client info, and products selected. the split() works fine within the client.asp page. I'm trying to assign the checkboxs to a Session variable and use it on confirmOrder.asp. Then display the session variable on confirmOrders.asp page. I know I can do everything in one shot with confirmOrders.asp, but the client wants to display the client.asp page then the latter. hmm...hope this makes sense.
<client.asp>
Session("myarray") = Request.Form("chkproduct")
<orderConfirm.asp>
strP = Session("myarray")
p_Array = Split(strP,",")
For i = 0 to UBound(p_Array)
Response.Write p_Array(i) & "<br>"
Next
View Replies
View Related
Is there a simple way to store session variable on the client-side
javascript or retrieve the value of the session variable from the
server-side session("variable") script onto the client-side script?
I want to keep the value of user entry on the text field of an html form
after refreshing.
View Replies
View Related
I have variables declared like this:
<p class = "hide">
<input type="text" name="nameVal" value="">
</p>
How do I make the "nameVal" as Session variable?
View Replies
View Related
Quit simple: I try to make a session variable on a hiddenframe like:
document.contexthiddenform.URLattach.value = URLvar;
document.contexthiddenform.target = 'hiddenframe';
document.contexthiddenform.action = 'context_hiddenframe.asp';
document.contexthiddenform.submit();
}
</script>
<%
session("sesURLattach") = Request("URLattach")
Response.Write "<script>" & vbcrlf
Response.Write "alert('" & session("sesURLattach") & "');" & vbcrlf
Response.Write "alert('" & Session.Timeout & "');" & vbcrlf
Response.Write "</script>" & vbcrlf
%>
</form>
The value of session variable is shown and the timeout value (60) shown as well. But immediately I get the error message "a timeout has been occurred, you have to log in again". If I make the highlighted sentence comment then I don't get the error.
Has somebody an idea why I receive immediately the timeout error?
View Replies
View Related
A user field called 'Custom1' exists in my data base. This user field is used to hold a URL path to a custom download page for clients. Each client has their own unique URL which directs them to specific locations.What would the proper format be for the variable:
=Session("Cutstom1")
to be able to be displayed as a hyperlink with the label: "DOWNLOADS" while at the same time sending the current user to the 'value' / 'path' to which the Custom1 field contains? I am not an advanced coder and am just starting out with basics.
View Replies
View Related
I assume that mostly,asp programmers use their own session variable to know whether a user is to be considered is-logged-on(together with a home-written log-on form web page).
However, I wonder if there is a convention for the name of such a variable?And does asp/iis have a built-in is-logged-on status variable? For example when IIS is to render a normal html page with an acl that invokes a basic authentication, can I as an asp programmer make use of that status variable, and can I write to it to force a logout programatically?
So, this is not about it there is a session as such, it is about beeing logge-on inside an asp-session. I've looked around but haven't found any good info on this.
View Replies
View Related
I have drop down for selection of council - it is then passed to a session variable - it works fine to display the variable, but when I put it into a hidden field, if the value was Milwaukee it is fine, but if the value was Green Hills, it only puts Green in the hidden field. How can I fix this - I need it to put Green Hills in the hidden field.
View Replies
View Related
when a session variable is declared,how long does that variable last?this isn't coming out of the global.asa.i'm pulling a field out of a db and declaring it with session(whatever)=whatever and then calling it out on the page.
View Replies
View Related
i don't know where else to go, if there is a better or more appropriate forum for this question please let me know.
I have just moved to another isp host and some of my pages use session variables. I have a session variable, amongst others that hold the username and customer number to display data. The session variable value keeps disappearing giving me ADODB.Fielderror '800a0bcd' errors.
If i hot the refresh button a few times the session variable data comes back. Somebody please tell me they've experienced this 'cos i'm losing my mind ! I've updated the page to show the variable, and it does and i've removed underscores from filenames (apparently a possible problem with IIS 6)
View Replies
View Related
i'm using the dundas freelib upload code to upload files in my website. when the user choses to upload a file a new window is opened and the upload procedure goes fine and the file is uploaded successfully. but the problem is the i want to know the name of the file in the parent window to save it in the database.
i tried to use a session variable which contains the name of the file but it dosen't work. the parent window contains a form which is used to insert new data in the database so i can't use the upload window to insert the filename in the database.
View Replies
View Related
i don't know how to retreive the session variable from the previious page..i have also problem querystring application because the browser execute very slowly..and sometimes page will not be displayed.
View Replies
View Related
I need to create an array with a session variable. According to my book, the following should work,. but if fails
for each key in request.QueryString
if left(key,6) = "cboRun" then
iIndex = cint(mid (key,7))
response.Write(iIndex & "<br>")
session.Contents("iRunNo")(iIndex)=iIndex
end if
next
it is the (iIndex) part which fails. If I remove this, then I can create a
single session variable.
View Replies
View Related
i m receiving username from the user using form's post method (request.form("username"))and then created session variable as follow..
Code:
username = request.form("username")
session("username") = username
on other page i get username from session variable as follow.
Code:
username = session("username")
this workes fine when i run it on the same PC that is hosting my page(on which IIS is running)..however problem arises when i request page through different PC in the LAN.Nothing is assigned to variable username.
View Replies
View Related
Can I prevent session varaible shared by the new opened browser? For example, if the user has login and viewing a page, when he opens another browser, the user has to login again if he want to veiw the same page in the new browser.
View Replies
View Related
First, I like to know if I can specify how long a session variable could expire?
I am having problem with user logged in period when using session variable.
When I logged in and go away from keyboard for like 10mins. By then I have to login again in order to post or any website features that requires login.
I have not yet create a cookie for the user when they are login.
What is the proper way of doing it?
View Replies
View Related
Im trying to pass the 'month' variable which is a session variable from one page to another. It manage to appear on the other page in a textbox but when I try to pass it to the recordset, it fails. Can I know why?? This is the page which I'm passing the variable to. Code:
View Replies
View Related
I was wondering if there is a way to "trim" the session value in ASP. I know that "trim" takes the spaces but what I want is to shorten the actual txt. For Example I have a Session.MM_Username.
This session return the users email address because I am using this as there username for when they log in. Is is possible to only return the characters before the "@" symbol? when they log in I want the user to see "Welcome abc" not
see their email address .
View Replies
View Related
I am storing my site name as a variable in global.asa. I am trying to retrieve it and use it in a page title. The following is what I am using.
<% title="Homes in "& session("communityName") & ", " & session("cityName") & " | Online Resources" %>
I can use Code:
<%= Session ( "communityName" ) %>
anywhere in the body and it works. So I know that the variable is not empty.
View Replies
View Related
I'm unable to update a session variable
btween pages. I can read them after I set in global.asa
and I can change its value within the same script but when
I go to another page, the session variable remains
unchanged.
View Replies
View Related
Does anyone know how to update a session variable to the database.
I can get the session variable to appear on the screen but I can't seem to get it to be send to the database using a form and hidden fields. Does anyone know how to go about this. What do I need to do to maken it work. I'm using ASP/ VBScript & an access database.
View Replies
View Related
I have a declared a session variable array. I want to create an array in my client side vbscript with the same values. I know you can set an array in server side script equal to the session variable array.
Ex.
AryDocCache() = Session("DocCache")
How do you set an array in client side script equal to the session variable array?
I know this does not work.
AryDocCache()= <%=Session ("DocCache")%>
View Replies
View Related
I have a form submission page that I am using some session variables that are created on the page in order to keep track of the information that they have already inputted - so when they click submit if there are any errors the fields that are correct remain populated.However, I am wondering is there a way that if they navigate away from this one page all the session variables that are created are removed so if they come back to the page they need to re-enter the information?
Something like "on page exit - remove session("name")..." ?
View Replies
View Related
I have an ecommerce site that works okay. My problem is that at the point where credit cards are put in I get an unique ID from the database which gets put into a session variable and then the user goes through makes the transaction and all is well.
The problem comes where if the browser isn't shut down you can go through the shopping process again but the session variable stays the same and this is causing me concern.
What I want to do is if the person leaves the site then the session variable is destroyed. Is there a line of code that can do such a thing or am I being simplistic in my approch?
View Replies
View Related
