Multiple Variables
I have an asp page that reads in a variable name via the url.but I need to recall the asp page with another variable but don't want to loose the first variable in the url.This piece of code sits at the top of the calllog.asp page,I am wondering if I can use the "choice" variable in the bottom portion of my code
choice = InsertAP(Request.QueryString("companychoice"))
This is the actual calling snippet of code - this is where I would like to use the choice variable as an option
<%
Response.Write "<a href=""calllog.asp?pNum=" & pageNo + 1 & """>Next Page</a>
%>
I have attempted this as well:
Response.Write "<a href=""calllog.asp?pNum=""& pageNo +1 & ""+companychoice=' & choice &'"">Next Page</a>"
View Replies
ADVERTISEMENT
On a form I have 8 combo boxes. When the form is submitted I want to make sure the combo boxes all contain unique values.
So I have eight variables. I tried to test them using:
If a<>b<>c<>d<>e<>f<>g<>h Then
but apparently that doesn't work. They are not in an array.
What's the easiest way to test them against each other to make sure they are all different?
View Replies
View Related
i have many different variables like addr, addr1, addr2 addr3 etc and i want this to occur
if addr = "" then
error = "ERROR:You have not entered all the required information. <br>Press the Back Button on your web browser and try again."
Response.Write error
But that only works for addr. Is there any way to include addr2 and the rest of the variables in that statement without writing it out 50 times
View Replies
View Related
Before I created this thread, I've searched Google and used the search feature of this forum numerous times on how to do this, but couldn't find much.
Basically, I'm trying to pass multiple sets of values from the search form to the ASP into an SQL statement (Access Database).
I can only make it display different prices of a certain music type, eg all prices of rock. But it doesn't output all types of music for certain prices, eg viewing Classic and Rock records with prices of 8.99 and 10.99 only.
I've used the REPLACE command I've found and got around that problem of syntax with numeric/alpha data. Code:
View Replies
View Related
I need to pass multple variables in a link in order to go to a asp page with
the two varables.
The following are the values of the variables using response.write:
<%'Response.Write Mypage & "<br>"%>
Exp
<%'Response.Write GrantID & "<br>"%>
4836
The link which I wrote is as follows:
<A HREF="mainreportagain1.asp?grantid=<%=GrantID%> & page=<%mypage%>">Report
Main Page</A>
However, when I am refreshing the page to click this link I am getting the
following error: Microsoft VBScript runtime (0x800A000D)
Type mismatch
View Replies
View Related
Does anyone know the detail of how session variables are actually stored?
The question I'm trying to answer is:
Is it more efficient to store and retrieve multiple short strings :
a) in multiple small session variables
b) concatenated and stored as one large session variable
c) inserted into an array and stored in a session variable
d) it's all the same. Who cares?
Keeping in mind that for this application each piece of data will be
retrieved for every page.
I've read that storing a dictionary object in a session variable is bad
ews - something to do with ending up with thread in your apartment, or
something ;-)
What I'd really like to do is create an XML object and store that in a
session variable, but I'm guessing that would be pretty inefficient unless
it had quite a lot of data in it.
View Replies
View Related
This is a simple question, but is been a while since I program in ASP and I forgot.
I have a variable like this: 01-00005-03
I need to have 3 variables from that single one... Something like this, from that variable, let for example that is called fullvariable, split it and get the following variable values from it.
variable1 = 01
variable2 = 00005
variable3 = 03
View Replies
View Related
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
can anyone tell me difference between environment variables and server variables.
View Replies
View Related
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
View Replies
View Related
I'm not sure how to best describe my problem, so a simple example should help explain things:
I have two arrays, called set1_data and set2_data
if I create a variable like so:
firstPart = "set1"
and then assign like this:
copyOfArray = firstPart & "_data"
how do I make copyOfArray reference the set1_array, as opposed to just a string "set1_array" which is what it's doing?
I've had a good rummage round ye olde Internet but couldn't find anything there must be a keyword or function to achieve this?!?
View Replies
View Related
I am trying to build a web based database using Access and ASP. I can retreive data form the database in a web page. I can send data from one page to another. However, I am stuck trying to figure out how to make the data variable. I would like the second page to display only data the user selected from a drop down list in the previous web page. I tried using the WHERE function and replace the hard coded information with a variable, but it isn't accepting the code. Could someone please help with this? I have research mulitple sites and can't find this particular piece of code or in tutorials. I must be missing something because seems like it would be basic stuff.
View Replies
View Related
I'm trying to reference a username variable that is saved after the user
logs in. I can reference it using $(Username) in standard html parts of the
page but how do i use it in the script sections enclosed with <% %>
View Replies
View Related
How can I get the value of a variable set in ASP from
inside vbscript tags. Here an exampleCode:
<%
Dim x
x = "something"
%>
<script language=vbscript>
msgbox(x)
</script>
I need to display the variable in a msgbox but can within
ASP.
View Replies
View Related
on the page.asp it searches the database for the specific record with id=3.
now i cant use : variable = Request.Form("id"), because the information does not come from a form, and request.querystring doesn't want to work either.
View Replies
View Related
I am new to asp and have tried a few things and cannot get it to work. I thought this code:
<input type="hidden" name="x_cust_id" value="<%= x_email %>">
would work for making the x_cust_id value equal what was put in the x_email field - but that doesnt work - any idea what Im doing wrong.
View Replies
View Related
I have a webpage with a list of items with checkboxes and a submit button. On the click of the submit button, I call a vbscript that loops through the items and put the values of the checked items in an array or string, and then jump to a new page.
Now I either want to send this variable to the new page, or I want to save the values to a mySQL database table, so I can use the values on the new page.
It seems I can't use session variables (session.contents) for this because that's server-side only.
View Replies
View Related
how can we use variables in sql statements
View Replies
View Related
Does anyone know how to get a variable to transfer from ASP.NET to an ASP page?
View Replies
View Related
Is there any way to get input boxes by thier id rather than
thier name? (Request.Form("elementname")) I don't want to
have to give every box its own id and name when they are just
going to be the same.
View Replies
View Related
I know that it's possible to pass more than one url variable using '&' querying 2 columns in the database.However,I want to pass both the words 'piano' and 'keyboard' to the same column [instruments] in a database).
Here is the code for just 'piano' and this works fine.
Search_quick.asp?<%="search="&"piano"%>
This is processed by a request.querystring("search")
View Replies
View Related
I'm building an application that allows visitors to our site to view GPS survey data. The data is collected several times a day and the files written to a different directory each day. Thus, for July, there are 31 folders.
There is a calendar on the site that people can click on the date they want to get the data for. Then, a window will open and the contents of that days directory will be displayed in the window.
Our app is at http://test.c-b.com/CORS/ - the data is supposed to be accessed from the calendar but now all I can do is view the root files. I just can't figure out how to target another directory with the FSO using a variable passed from a querystring.
View Replies
View Related
How do I write variables in the URL like in PHP? Then, How do I pick up variables that are in the URL!
E.g. in PHP = main.php?name=David
Because i've just started in ASP from PHP and I was wondering how you goto a URL with variuables in...! And how ASP gets them from the address URL as it seems not to automatically pick them up.
View Replies
View Related
I need to write a if statment to find a part of a word. By Example:
variable = "ASP Free forums"
if % variables % = "ASP" then
statment
else
exit
end if
I've tryed to uses the '%' like in SQL queries but didnt work. Is there any idea?
View Replies
View Related
I have a number of form fields that I wish to temporarily record into
variables and pass to a small number of subsequent pages.
Is the best way to save each one to a session variable when I submit the
form and then to clear the variables when I no longer need them?
Also, if this is the best method, what is the code for saving a form field
to a session variable when the form has not yet been submitted. For
example, when I submit Form1, I want the contents of Field1 to be entered
into SessionVariable1 and then the form to be submitted as normal.
View Replies
View Related
how do I set & use variables in Global.asax. i ve missed that chapter in the book i read.
View Replies
View Related
I have a database being updated by a text file every ten minutes, so in the code that is why the column names are messed up.
My problem is I get all the sums, and counts all working. What I need to do is at the end of it have a sum for for all the columns returned, i.e. col002, I need all the sums in that column added up for a total at the bottom. The following code works but when I try to do column totals I can't get it to work, Code:
View Replies
View Related
I am requesting a variable for the users' network username:
<%=Request.ServerVariables("LOGON_USER")%>
This returns the following:
NETWORKJ.Bloggs
Instead I would like it to return J.Bloggs on it's own with out the "NETWORK" bit so basically I am saying how do I cut out the first 8 characters of a variable.
View Replies
View Related
I am using Session variables in my ASP application. I have tested the
application on a Win2k professional and it works fine. When the same web
app is installed on a win2k advanced server from the client browser when the
app is accessed the session variable returns null inspite of a value being
already set. I have checked the IIS enable session state settings. When i
use the server machine as client and access the app as localhost then the
session variable has correct value.
How can this be solved? What other settings if any, need to be changed to
get it work.
View Replies
View Related
Do session variables carry over if you've left your site and come back?
My shopping cart uses PayPal/IPN to transact and then enter details of the transaction into my database. All of the data entry takes place after IPN has returned all of the data to my site.
A couple of the fields I need to populate are held in session variables throughout the application. When the customer clicks on the checkout button, and is sent over to PayPal's server to complete the transaction, will the session variables still be available to me upon returning to my site?
View Replies
View Related
I am trying to pass a variable from another page to a sql statment. The variable specifies the one of the columns that I want the sql query to return. I also want to display field contents of the column later in my page. I can't seem to get this to work. Can someone give me a hand? Here is my code:
View Replies
View Related
My goal is this - to use cookies to remember items viewed by a specific user.
There is no registration process so need to identify each visitor & was thinking about using the session ID of the first visit as the identifier, is this okay?
So now I've identified a user I wish to attach to the cookie the imageID of every item that person has viewed i.e.
response.cookies("Mysite")(SessionID)=1.jpg
then
response.cookies("Mysite")(SessionID)=2.jpg
View Replies
View Related
