Pass Variable To Sql Statement
I have created a hyperlink in one page (all.asp) using this code:
<a href="cat.asp"><%= rsProds("category")%></a>
How do I create the sql statement in cat.asp to show only the categories listed by the link in all.asp?
I have this in cat.asp so far:
strQuery = "SELECT * FROM biz WHERE category = ' " & strVariable & " ' ORDER BY bizname ASC"
which shows nothing since the string variable had not been passed.
How do I get the hyperlink category name into cat.asp sql query as a variable?
View Replies
ADVERTISEMENT
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.
View Replies
View Related
I am using this code to display a dropdown list of employees
How do i pass the selected name to another page, all i need to pass is emp_id? Code:
View Replies
View Related
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.
<%
siteid = Request.QueryString("SiteID");
whosent= Request.QueryString("WhoSent");
objShell = Server.CreateObject("WScript.Shell");
objShell.Run("cmd /c call rsh host -l username lockunlockRSL.sh siteid whosent", 1, 1);
%>
Does anyone know how to pass 2 varible siteid and whosent value to this command if not use batch file?
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
How can I pass the variable in two button situation see below code
<html>
<body>
<form action="" method="post">
<input type="text" name="name">
<input type="button" value="Add"
onclick="this.form.action='add.asp?name=<%=name%>';this.form.submit();"><br>
<input type="button" value="Delete"
onclick="this.form.action='delete.asp';this.form.submit();">
</form>
</body>
</html>
As a result, I got to the next page , but showing error.
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Ive done this in various ways before but im doing it in java wit asp Code:
a0=("Managing Director")
<a href=javascript:openpopup("EditSupplierContact.asp?a0=<%response.write(a0)%>")>Edit</a>
only the word "Managing" is being passed into the string if i join the variable toghther its works.
works if a0=("ManagingDirector")
View Replies
View Related
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.
View Replies
View Related
Is it possible to pass a variable into an include statement?
I have a link as follows:
http://mywebsite/page.asp?project=tsc
My page.asp has three include statements.
<!--#include virtual="/nav_table.asp"-->
<!--#include virtual="/directory/project.asp"-->
<!--#include virtual="/menu.asp"-->
I'm hoping to replace "directory" with the variable in the link so that I get:
<!--#include virtual="/tsc/project.asp"-->
How does one get the variable in to the line above?
View Replies
View Related
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?
View Replies
View Related
I'm using ASP to run a batch file. I need to know how to pass a variable to this .bat file.
Is this possible? I'm using the following code but need to know how to pass ASP variable.
set wshell = server.createobject("wscript.shell")
wshell.run "c:file.bat"
set wshell = nothing
Any ideas? Or a work around?
View Replies
View Related
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.
View Replies
View Related
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.
Code from page 1:
<%response.write "<a href='Page_2.asp?Severity=" & varCombo_Severity &
"&Owner=" & varCombo_Owner & "'>" & "<i> Go to Page 2 </i>" & "</a>"
%>
Code from page 2:
<%varCombo_Severity = Request.Querystring ("Severity")%>
<%varCombo_Owner = Request.Querystring ("Owner")%>
Result: No % wildcards are passed though to page 2
Any ideas?
View Replies
View Related
Is there any way to pass session variables between two websites ( diff domains) ?
I've two websites and I want to integrate them.
I used to use the querystring but there is a limit to length of the querystring.
I've tried ASP-TEAR but I doubt it can work.
Is there any other way to pass any variable to another website.
View Replies
View Related
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:
View Replies
View Related
I have an input box when the user clicks on the button.
var number=prompt("enter journal number");
How is it possible to pass this variable forward but to vbscript? So i could use that variable in an sql procedure?
View Replies
View Related
I have a dropdown that calls a javascript function onChange. One of the lines in the script is:
tmp = document.form1.familyID.options[document.form1.familyID.selectedIndex].value;
How do I change it to allow familyID to be a variable passed to the function?
View Replies
View Related
I need to add the following variable into an SQL statement and not sure how to do it. strGCID needs to be inserted into the following statement:
SQL = "SELECT tblContacts.* FROM tblContacts INNER JOIN tblGC ON
tblContacts.GCID = tblGC.gcID WHERE (((tblContacts.GCID)=strGCID))"
i am just not sure of the proper syntax.
View Replies
View Related
sql = "SELECT * FROM & console &'news'"
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?
View Replies
View Related
I need this variable = to a loop statement
Here is my str
form_bcc = Cstr(If Not objRS.EOF Then objRS.MoveFirst Do While Not objRS.EOF objRS.Fields("Email") Response.Write ";" objRS.MoveNext Loop End If)
And help on how to get this to work?
View Replies
View Related
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?
View Replies
View Related
i'm trying to change the following include statement :
<div id="contents">
<!-- #include file="includes/main_page.asp" -->
</div>
on an ASP page into something that receives the file name as a variable :
<div id="contents">
<!-- #include file="<%=fileToInclude%>" -->
</div>
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 ?
View Replies
View Related
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:
View Replies
View Related
How can i store the JavaScript "screen.width" variable as an ASP variable?
Or is there a VBScript ASP equivalent of:
<script language="JavaScript1.2">
var mywidth = screen.width;
document.write (mywidth);
</script>
?
View Replies
View Related
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:
View Replies
View Related
I'm turning my application into a "DLL". Everything worked fine untill I try to do a "While" in my asp code. Then I recieve an error like this:
"Object variable or With block variable not set"
My vb code look like this.....
View Replies
View Related
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
View Replies
View Related
How do I convert an ASP variable to a Javascript variable?
View Replies
View Related
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%%"
View Replies
View Related
