Currently have
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT [firstname], [lastname], [homepage], [aim], [location], [interests], [email] FROM tblUsers WHERE ID =" & userID
need to use session variable but need to select records form another table based on the logged in user (session variable) Code:
I've got three tables:
tblEvent
--------
Id (PK) | Event_Name
tblDelegate
--------
Id (PK) | Delegate_Name
tblBooking
--------
Id (PK) | Event_Id (FK) | Delegate_Id (FK)
I need to retrieve a recordset with the following information:
Booking Id | Event_Name | Delegate_Name
Can anyone see how to do a SELECT statement to do this?
strSQL = "SELECT x.CountryId, x.CountryName, y.SiteId, y.SiteName, z.LocationId, z.Level FROM TableCountry AS x"
strSQL = strSQL & " INNER JOIN TableSite AS y ON (x.CountryId = y.CountryId)"
strSQL = strSQL & " INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)"
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression '(x.CountryId = y.CountryId) INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)'.
/system1.asp, line 21
how do i do this?
View Replies View RelatedI have a MSAccess 2000 mdb where 2 tables must be connected with a fieldname "book_spoke".
This is what I have so far. Is it right? The purpose is to find within the search result all the book_spoke s and link with the proper url for each book_spoke. Code:
I have an access database called employment.mdb The fields that I have in this database are:
Company, Location, Dates, Position, Signing, and Duties.
The problem I am having, I can go in and create a Drop Down pulling information from the Company field, but I can not get the information from the rest of the fields to
populate. I want the Database column values to change when I select a different company.
I will be honest, my only experience with it has been thru Frontpage, I can go in and create a drop down, but get errors if I try to add other database connections into that query. I have enough experience at working with html, but not the asp side of it. I would really appreciate some help with this.
I have a question about JOIN'ed table in Access. I have 2 tables in my database with one being tbl_Events and the other tbl_VolunteerSchedule. tbl_Events contains information regarding upcoming Events. tbl_VolunteerSchedule contains the names of Volunteers plus information from tbl_Events pertaining to the event the volunteer is volunteering for.
What I need is for tbl_Volunteer to Update when I make changes to the Events in tbl_Events. I thought that it was working correctly when I used a LEFT JOIN. However if I make updates to tbl_Events it adding additional record to tbl_Volunteer. It should only Update tbl_VolunteerSchedule when the fields EventID match. Does this make sense? Code:
how do i join tables in access and how do i get asp to output information from two separate tables that have the same primary key?
View Replies View Relatedi have this code that join 2 tables, Reservation and Customer. Next, i wanted to add another table, Staf to get the name of staf that responsibled on a particular reservation. there is a field name staffCode (FK at Reservation table, PK at Staf table) at the Reservation table. Code:
View Replies View RelatedI have some code I need modified and I can't seem to figure it out. Here's the section of code I need to change: ....
View Replies View RelatedI've two tables:
First Table Player
tbl_player (fld_id, fld_dor, fld_tname, fld_tpass, fld_name, fld_email, fld_mobile)
Second Table Attempt
tbl_attempt (fld_attempt_id, fld_dop, fld_tname, fld_pid, fld_pscore)
Relation of First Table with Second Table is fld_tname and fld_pid of tbl_attempt with fld_id of tbl_player
Basically this is a 2-player game in which tbl_player contains both player a and player b details (they are identified by same Team Name). Table Attempt (tbl_attempt) holds individual scores which again can be grouped as a team score by the field fld_tname. Code:
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 RelatedI'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
'**********************************************
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..
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?
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
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.
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?
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?
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.
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.
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 Relatedwhen 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 Relatedi 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)
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.
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 RelatedI 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.
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.
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 RelatedFirst, 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?
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 RelatedI 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 .
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.