Three tables: Registration, Session, Payment: Joined with 1 to many rel. starting with registration, moving to session and ending with payment. Form 1: Registration= INSERT INTO statement works fine. Reg table now has fields populated with form data. Form 2: Session= <<<<<this is where the problem occurs>>>>> Form 3: <<<<<<problem as well>>>>>>
When i want to do another INSERT INTO statement, I have to know the RegID from the earlier table join(registration). Of course, I can't run either Form 2 or Form 3 without knowing the RegID from the Registration table begin point.
I don't know how to increment the RegID as a foreign key in a joined table over the internet. Using Access over the network it's real easy to pass the foreign keys and the design seems to be more flexible this way, but I need to update tables and present stored data to the user across the internet.
I want to pass 2 auguments to this command like below, but the red line of following java script (server side) doesn't work, which means it doesn't took siteid and whosent vaule.
I'm trying to add a variable to the url that is going to be sent but when it is sent my additions are removed! I've tried numberous variations of action="caldelete.asp?curid="<%=iRecord%> and every time it removes everything! What am I doing wrong? Code:
I need to pass a variable in a URL to set up a dynamic page where the content shown is based on the recordet queried on the value passed in the URL.So when the user pulls down a menu list and clicks on Todler Clothes, I need it to go to URL store.asp and pass the choice of Tolder clothes in the URL variable.
Then I need to have my recordset query (WA Querry Builder) use that variable to pull the correct items from the db.How do I add the variable to the URL and what is the ASP statement to get it.
If an affiliate sends a visitor to my site I want to be able to carry that 'partner' variable throughout my pages and eventually onto the registration page so that they may get credit for the member registration.
I am not a coder and can't find an easy way to do this could someone help. I am an expert interpreter and rearranged but not a writer of the code.
BG INFO: asp.net AFF URL FORMAT: www.mysite.com/index.html?partner=20051111987623
I have a session variable session("loginid) which can be passed from A.asp to B.asp. Then In B.asp I have a hyperlink to C.asp e.g. < A href..C.asp>. The session variable cannot be passed to C.asp. The session variable is empty. What can I do to debug this problem?
I'm trying to pass a session variable "session("sibvar") to a hidden form field on an HTML page from an ASP page. In the 'value' paramter of the hidden field I cannot therefore put <% =session("sibvar") %> as this is ASP, I am however allowed to use Javascript in the hidden field, is there some way of doing this.
Is there any way to pass a variable back through a for next loop? Right now the variable resets to nothing after each pass. I need to assign the resetting variable the previous value + 1.
i want to upload my file from the first form and then keep passing the destination path (obtained from File.Path) as a hidden variable to all other forms. and in the end to upload it... how can i do this?
I am simply trying to pass a variable to another page. I know my second page can do Request("str") to retrieve that variable, but how do I pass it in the first place?
I tried Server.Execute("P2.asp?str="hello") but I get errors. I tried Response.Redirect("P2.asp?str="hello") but the variable is empty
I tried setting variables like you would in VB:
str="hello" Server.Execute("P2.asp")
and hoping the second page would pick it up, but I don't know how to make that str variable global.
I am not using forms, I am not using cookies, I was told not to use Session or Application variables, it's a variable being passed just the first time a page is accessed, after that links will send the variables.
I'm trying to pass the wildcard variable % to another page via request.querystring.
When I go to pick up the variable through request.querystring, it will never diplay the "%" if one is included. It will diplay any other characters included in the variable though.
Want to trim, replace etc... a variable then pass it to the javascript, how can I do this? I can not put the javascript outside the loop without splitting it to put the onfocus part seperatly which I don't fancy doing.
Any ideas how to get it to to the ASP then JS? I would have though it would do it that way but there we are. Code:
I got that right now but i want the variable, console to be placed along with news so when it selects from the db it selects from gcnnews or whatever variable it's on. How do I do that?
I'm trying to use a variable of retrieved via request from a form to select records.I'm pretty sure I am having a basic syntax error or something else basic. I retrieve the variable from a prevous form:
section_id = request("section_id")
I then retrieve some records and run the compare, if i use the actual value it works: if rsArticles("tbl_articles.section_id") = "1" then
however if I substitute the variable section_id which equals 1 , it fails the compare and moves on to the else:
if rsArticles("tbl_articles.section_id") = section_id then
if I call the section_id value elsewhere it shows that it is set to 1, so I know it's being passed, <%=section_id%> returns 1 . What am I missing?
however, this doesn't seem to work, as i get the following error message :
The include file '<%=fileToInclude%>' was not found.
it obviously is trying to find a file named <%=fileToInclude%> instead of seeing the variable my question is : is it possible to feed a variable into an include statement ? if yes, how should i go about it ? if not, are there any alternatives ?
I'm trying to calculate the total time using values from database I run a select statement to find the timein column in my database.
Now how do i assign the result to a variable so that it can be used? There is only going to be one result because i'm checking it against an autonumber field. that is used as time 1. Code:
I have a page that calls itself using a form. The form has two select elements. In the sql statement I am attempting to match the values of the select element to populate a recordset.
The two fields in teh Access db are of type Text and of type Integer. What baffles me is that one sql statement works fine and the other returns nothing. I am having the issue matching on the bedrooms.
In the first statement I took out all other doo-doo and just matched bedrooms = request("bedrooms"). On the other one I used p.bedrooms but it keeps turning up empty. Code:
I would like to pass the value %%LAST_NAME%% to another asp document.... I wanted to pass this value by doing a response.redirect, but, it truncates the double percentage signs
I know it works on a SUBMIT example: <form> <input type=text name="lname" value="%%LAST_NAME%%"> </form>
but, I would like to skip the submit and do a response.redirect... even if I create a variable using 'server.urlencode' it still truncates the %% example: response.redirect "newfile.asp?lname=%%LAST_NAME%%"