How To Assign A Variable And Store The Value Getting From XSL
I would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View RepliesI would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View Repliesitemname = "select sw_item_itemid, sw_item_item , sw_item_lowquantity"
itemname = itemname & " from sw_item"
itemname = itemname & " where sw_itemcategory_catid = "&catid&""
set displayitem = objconn.execute(itemname)
if displayitem.bof and displayitem.eof then
counting = counting + 1
("countnotitem" & counting ) = filtercategory("sw_cat_catlabel")
how can I assign countnoitem with a digit ?
I have a code somewhat like this:
Dim screenSize
If Request.Form("resScreen") = "1024x768" Then
screenSize = "big"
Else
screenSize = "small"
End If
this works fine, but when this page is reloaded, it doesn't
find this Request.Form("resScreen")
(this form is also on another page, which explains why) but can I store this variable "big" the first time it loads somehow?
For Each objitem in Request.Form
if request.form(objitem).count > 0 then
For intLoop = 1 to Request.Form(objitem).count
Objitem = request.form(objitem)
End if
Next
server error in line of "end if"
I want to collect the values from the form and assign a variable to each value field
If I assign VBScript server side variable a to javascript variable x, it is fine.
<%
Dim a, b
a = 10
%>
var x = <%= a %>;
alert(x);
But if I do the other way around, then it has 500 error. any ideas??
<% b %> = x;
How can one 'assign' value of a session variable to a variable, something
like: temp = session("variable").
how do i store a value from a XML into a ASP variable
I need to store "maxpage" into a variable call "totalpages" in my asp file...how do i do it?
I want to maintain the user's session variable while moving from HTTP to HTTPS. I learned that you can store the sesison in a database, but I am not sure about the logic behind this method.Can someone explain how this works?
View Replies View RelatedI've spent ages hunting for this but no joy, another user suggested cookies, but was ideally hoping to use Session Variables so its just stored while a user is on the site.
Basically I need to capture a section of a URL i.e.
www.myurl.com?ref=thisiswhatIneed!
I then need to simply save 'thisiswhatIneed' into a session variable and then enter it into a form box on another page (which I know how to do).
I just don't know how to get/store the part of the URL?
I'm using a session variable to store a log in so the user only has to log in once every time they come to the site for multiple features that require a password check.
What I'm doing is using one central login page that pops up when they click on whatever locked feature they're going for. The password form's action is back to this same page, which has this code towards the top: Code:
I got a session variable for username. Now, i want to assign this value to the textbox.
HOW WOULD I ACHIEVE THIS?
I put in a request recently for a script which would return 9 random numbers between 1 and 30. I got a reply which gave me this script, which writes them out.
It works great, but in the loop that writes them out, instead I would like to assign each value to a variable, such as img1,img2,img3,img4, etc. in the for loop, is this possible, or should I write out 9 statement lines, each assigning a value to a variable. I intend to plug the values into a java applet which rotates images.
Come to think of it, I could just put each value of the array right into the img tag, no? <img src="images/<%=random_number(1)=>.jpg"> Code:
I am using Visual Studio I have created a website using HTML code and the pages look fine I now need to do the following.
I have a picture where if some one clicks on it it then needs to query an SQL database and return on a different page the results. How do I assign a sql database to my website and how do I connect to it ?
I'm retrieving the screen resoltion with javascript code, but i can't assign the correct value to asp. the response.write is displaying zero (0) for screen res., although when i do a document.write in the javascript part, then my screen res. is 1004 ...
View Replies View RelatedI have this simple application that I put together using ASP. It has an html form that submits to an access database through a simple ASP file. It’s a survey form basically. One of the departments here wants to get some feedback from their students and in return for filling out the survey they will be entered into a drawing for a gift certificate. The catch is that the survey is anonymous. What they want to happen is each person is given a unique number at the end of the survey and they will pick one of those numbers randomly to see who the winner is. How can I possibly do this? I am stuck.
I think I may know what I need to do:
Pull a unique number from a database and post it onto the HTML form near the submit button. Notate on the page that the user write the number down and when they hit submit it is inserted into the database along with the record. I have absolutely no idea how to do that.
The HTML form submits into the database using this "add.asp" file:
Code: ....
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
I'm setting the title attribute of an input box to assign a tooltip. If I assign title the value "Agent does not exist", when hovering over the textbox the tooltip will only display "Agent" it's the same with all my tooltips (only the first word is displayed).
View Replies View RelatedI'm having a bit of a problem and I was hoping someone could help me out. I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc. I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
URLURLOn page load there is a variable called "id" it has already got the value (say 7170)
I have a query in a function that executes a dataset, the query is "select Col1, Col2 from persons where id = " & id
Therefore, on page load - how do I call the function. Assign the value of Col1 to textbox1 and the value of Col2 to textbox2.
In the text box I would use <%=var %>
But how do I assign the result of the query to the variable?
Would it be worth using a datareader instead?
Before there was XML my world was in order, I would once a year write some small ASP script, it would perhaps take me all weekend, but it was doable, now the devil has entered my life, in form of an XML file ... Code:
View Replies View RelatedI am trying to update an integer field in an Access database with a null value (ie, make the field empty). It currently has an integer in it. Here's the code I've tried, which normally works for all other updates:
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = sConnString
rs.Source = "SELECT * FROM tblFixtures WHERE FixtureID = " & strFixtureIDcurrent
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
rs("ArticleID") = ""
rs("Result") = ""
rs.update
rs.close
set rs = nothing
However I am getting a Type Mismatch error on the rs("ArticleID") = "" line. Where have I gone wrong?
Is it possible to assign javascript variables values to ASP?
e.g. How would I store the following JS variable as an ASP variable in VBScript?
<script type="text/javascript">
var intJavaScriptNumber = 25;
</script>
The problem is I've got about 50 of these variables on a page, and they all need to be used in a simple equation which slows the browser down. If I could get them all into ASP then I could process this server side much more comfortably.
Currently, my repeat region is showing all of my repeated records that are being brought in from my database. I would like to display these records in a confirmation page, but I am having problems having them display in my confirmation page.
I tried to assign a hidden value to the repeat region, but I am getting no data to come across. Below is the code that I'm using: Code:
I have a web page that submits a form to a database. Each time a form is submitted, I need to assign it a unique case number and insert the case number into the database along with the information entered in the form.
I am able to insert all the data into the database, but am not sure how to generate the case number to insert. Is there a way to do this based on number from the previous entry, like just add 1 to it?
I am bringing in a repeated field from a database and I would like to assign values to radio buttons to be associated with each record. The number of repeated fields will be different for each person, so I cannot enter values for each repeated record. I need a way to assign a variable as well as a value to each record that is being brought in from the database. For instance:
Radio Button Value 3 4 5
Repeated Record 1 O O O
Repeated Record 2 O O O
Repeated Record 3 O O O
I had received some great code from Memnoch, but it created one group for the entire Repeated field, so I was only able to select one radio button for all of the repeated fields. I need to select them seperately and I then need to Request the variable so that i can add, multiply and divide that variable with other repeated variables.
how to write store procedure in asp?
View Replies View Relatedwhere I can find an asp script(free) to do a store locator.
I've only been able to find 2 on the web, and they are both at a cost.
I am looking for some ASP - SQL server 2000 online store application that i can buy for my company. This store is completely internal for the company and will be on our intranet server and will be utilized by the company employees to buy company merchantdize.
Also at this time there will be no credit card processing as the amount of purchase will be deducted from the payrol. I will be needing the shopping cart and product view. Later if we provide the credit card processing, we have already installed PayFlowPro from verisign and do creadit card procesing on our main site.
Does any one know such application that i can integrate with our style sheets and general layout?
I am using ASP and VBScript to access an Oracle database and display query results to my users.
However, my query is huge! and I want to keep the query separate from my ASP/VBScript code.
How do I store the query on one page and then call it from another page?
I have this problems regarding "storing New values into session".
Take the "online movie tix booking" as an exmaple. When i click on one seat, beside storing the seatNo into a session, i also want to store the number of seats he has clicked throughout. How can store the incremental of seats clicked into a session by overriding new Values
i am stuck with the following error message
"Application uses a value of the wrong type for the current operation."
did anyone know the reson this occur?
just because of my store procedure....
I have an ASP page and a Store Procedure but I keep getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_searchresultsZIP' expects parameter '@xDateTo', which was not supplied. Code:
what is the diference between these two cache control header.no-cache and no-store.I have read the w3.org explanation.So lets say I am using only no-cache ....my understanding is thatnothing is cached and nothing is writen to disk.but what happens when we use no-store....i think..nothing is written to disk but it could be cached.
Now my question where is this cache located...is it only in memory ?....if it is written to disk how log is it there and when does it gets cleaned.Is no-cache more secure than no-store ..why?