SQL Query Based On Session Variable

I have a SQL DB with a number of tables and queries (views) in.

In front of this is my ASP app I am designing.

When my users log in, their User ID is stored in a session variable.

One of the views determines which User ID can access which records, and
obviously then I want to base all my app around this so that a user can only
ever be working on data relevant to them.

Is there any way of using a variable in my SQL View outside of DWMX so that
once my users log in, the SQL View is automatically filtered based on their
User ID in the session variable?

Is there a way of inserting a variable/parameter into SQL so this happens?

View Replies


ADVERTISEMENT

Query Based Report

I have a MS SQL database on a server which is [ublished on the web (ASP pages) I need to give the user a button to click on it and print a stored procedure based report. I dont know how to generate the report in ASP ?

View Replies View Related

Query Based On Username

I am diong a query based on a username that is being passed over. here is what i have:

sqltext = "select from sage where username = request.form(username)"

i've tried variations of it and i keep getting error message. i have written so that it will pull everything the db, and that works. so i know that it has to be w/ this one portion. but i'm getting an error message.

View Replies View Related

Redirection Based On Query Result...?

I have a quiz that writes the results to an Access db. When the user logs in, I want it to redirect them based on their score.

I want them to login and get directed to page 2. Page 2 queries the db based on the user/pass. If the quizcompleted=0, they get directed to the quiz.

If the quizcompleted=1, they get directed to a page that says "You've taken the quiz and your score was _________ ."

View Replies View Related

Redirecting Based On Query String

I want to do something which must be very simple. If I open default.asp, it creates my frameset and opens my home page. This is what I want to happen.

However, if I create an URL along the lines of
http://www.domain.com/default.asp?r..._page=page2.asp, then I want it to open
page2.asp, but still within the frameset.

Is this possible?

View Replies View Related

Connecting To DB And Pulling Record Based On Variable

Im having another issue with connecting to a db and pulling only a record matching the one posted im using the following code to connect Code:

View Replies View Related

Session Based Shopping Cart

I'd been using an Access database based shopping cart, but wanted to change
it so that it would use session variables. I have a form that's submitted
to a page called addtocart.asp that contains the following information: Code:

View Replies View Related

Dump Query Into Variable

I need to loop through a query and dump the result into a variable that I can assign to the body of an email. something like: Code:

While Not objRS.EOF
Response.Write objRS("email") & "<BR>"
objRS.MoveNext
Wend

Mail.Body = objRS

View Replies View Related

Setting Variable In Query

I have a sql query that runs on my asp page.

select
contactname,contactnumber,contactnumber1,contactem ail,address,city,state
,zip,type,sqft,0,bedrooms,baths,lotsize,acreage,ga rage,comments,price,0,
0,county from table1 where active='Y'

I need HASPHOTO to equal 1 if hasphoto <> 0 and HASPHOTO=0 when
hasphoto=0. Make sense? HASPHOTO usually equals a number, but in this
case, I want it to equal a 1 or 0 because I am exporting this to a CSV
file. I know how to do everything else, just not this part.

View Replies View Related

Constructing An If Query From An URL Variable

I am trying to construct an If Statement from an URL variable.

Basically if a string in the URL variable, reads, 'Technology, then I want to response.write something. If its anything different, then i would like to response.write something different. The URL = news.asp?type=technology

I have already declared that the lngRecord = Request.QueryString("type") and I have constructed the following If statement off the top of my head, but its not working properly.

I have also been able to access an individual page depending on the URL variable so it's definitely a problem with only my poorly-constructed If statement and nothing else

Code:

View Replies View Related

How Do I Use A Passed Variable In A Query?

i need to add a variable brought into the
script like: script.asp?variable=var

and i need to make it for use in

var1 = request.querystring("var")
mySQL = "SELECT * FROM members WHERE nick = 'VAR1'"

can anyone tell me how to do this?

View Replies View Related

Adding Variable To Query Line

The form post an agent name to the next page it then takes that name and matches it to the database and shows all entries that agent has. my problem is with calling the variable in the query I just cant seem to get the syntax right Code:

View Replies View Related

Session Variable

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

Session Variable

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

ASP Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable

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

Asp Variable Session

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

Session Variable

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

Session Variable

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

Session Variable

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

Session Variable Or Cookie

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

Passing Session Variable

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

ASP Session Variable Manipulation

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







Copyrights 2005-15 www.BigResource.com, All rights reserved