strValues = Split(strValue, ",")
dblTotal = 0
For i = 0 To UBound(strValues)
dblTotal = dblTotal + strValues(i)
Next
Response.Write "The total is: " & dblTotal
If I wanted to divide dblTotal by the number of records that are being brought in by the database and then multiply that by .333, what variable would I divide by?
I'm entereing values into repeated textboxes in a form that are associated with repeated fields in a database. I am able to request the values, but the associated questions and values are seperated by commas.
The repeat field on the page that I am confirming the selections is repeating but showing the same results on each line. In other words, all of the values are showing up on each line. Is there a way to break these up?
I have some values I'm passing from one form to another. When I press
the submit button, I want the quantity I have in the text box on form
a to pass to and display in the text box on form b.
form b is on an asp page, and I'm trying to display the values in this
fashion:
myquantity=request.form("quantity")
response.write "<input type =text name=mybox value=" & myquantity &
">"
However, this is not working, and I can't figure out why.
how to i passing values to text field?
<input type="text" name="Usrname" size="20" value=<%= fullname %> >
i knew this is wrong.. but how do i solve this problem?
I am trying to pass a value into the text field on selecting the option in a drop down. The code works if the 'For' loop is not included. What should I do to make it work inside the loop? Code:
View Replies View RelatedI've got a SQL server database, and am using ASP to create a simple recordset.
Everything is fine, except that one column of the database is of 'text' data type. I can't seem to be able to pull anything from this field in my ASP script. All names and variables are correct, and there is data in the text field, it just comes out blank when I pull this field into my recordset.
I have a radio button, a check box and a text box in a web page. From this page, I go to a series of other pages. In one of the following webpages I am providing an option to come back to the first page which has the radio button, check box and the text box.
When doing so, I need to retain the values I originally checked in teh radio button and the text box, and also the text in the text box. I understand that I need to carry it through a session variable, but I dont know how I can do it.
I have a log file from my email software program. Each entry is on a line and the values are seperated by tabs. How can I read through this text file such that I insert its contents into a database? Thanks. Tom
Here is one entry from that file:
11/30/06 00:00:21SMTP-IN25AA24076F2041D7B35E97EE7748D06C.MAI65284.244.91.208EHLOEHLO [84.244.91.208]250-home [84.244.91.208], this server offers 4 extensions11922
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
i need to convert the escape values which are by mistake updated in DB.
example:
this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string
here %20 is the space.
like wise there are many entries for :,'
is there way that i can update all this in a update statement?
or use asp to to update the records?
I have a variable SET which has the value Of 1, 2, 3, .., N.
SET=val1, val2, val3, val4, ..., valN
What is the commend or procedure to extract individual values, val1, val2, ...
I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have a text area which I want to limit the number of words or number of text entered into it. Is this possible?
<textarea name="textarea" cols="35" rows="5"></textarea>
In the text area above, can I say limit the person filling in the text area to say 100 characters?
I have a form on asp page that pulls info from a DB when the page loads.
It them puts the info into text boxes on the page that are editable by the
user.
The only problem I have is say in the description text box it should
read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP"
.. It does this on all the text boxes? I can't seem to figure out why it
is doing it. Here is the sample code:
With quotes around <%= vdesc%>
<td><input name="desc" type="text" id="desc" size="45" value="<%=
vdesc%>"></td>
And I tried it without.
I have text in a field coming from a database. The text has various
forms such as:
text1
text1 or text2
text1 or text2 or text3
text1; or text2
text1; or text2; or text3
etc...
how can I parse this with a reg ex? I tried this:
(.+);? or
but it only captures 1 submatch (text1) and only if theres an "or"
after it
I'd like to get 1 submatch for each piece of text separated by the
"or", just the text itself if there is no or.
Anyone know how to do it?
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
View Replies View RelatedI have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
View Replies View RelatedI have a search page, after search returns value I want to display fields in text box instead of table.
View Replies View RelatedI have to get values from table using arrays can anyone tell me how this can be done here is my code
Code:
For i = LBound(arrCart, 2) to UBound(arrCart, 2)
Set rssubcat = Server.CreateObject("ADODB.Recordset")
strprod="select Member_Price from Products_Price where Products_Price.Product_Id= '" & arrCart(cartProduct_Id,i)"'"
rssubcat.Open strsubcat, Conn
total=rssubcat("Member_Price") * int(arrCart(cartQty, i))
subtotal=subtotal+ total
Next
I have a main data entry form which has a link to a detailed data entry form. The value of the link in the main form is the sum total of all the line items in the detailed form. The detailed form has fields to capture the individual line items like contracted service expense, travel expense etc. I am capturing the total of individual line items using session variables so that when the values of the main form is saved these total of line item values get saved. However, if one gets to the mainform via login and tries to resave the values (which is already saved), the above session variables (from the detailed form that contains the sum of line items) get null values. However, just navigating to the detailed form through the link and coming back to the main form sets the value in the session variables.My question is how to get the session variable values without having to go to the detailed form and come back to the main
View Replies View Relatedif it is possable in ASP i could store a value in one ASP page and look at it on anouther ASP page. for example:
On a login page i want that page to store a value called rights that is a number. when it goes to any of the other pages EG add user, Delete users if the user does not have the needed rights to takes it back to the main screen.
I wish to get and set values on child controls on a formview.For example. Changing the text in textbox. Hiding or unhiding child controls based on user. Replacing a blank with a default or calculated value that will need to be generated at runtime.It seems as though this should be thoroughly documented, but I'm not finding much.
View Replies View Relatedi need to know if i have a loop that outputs values for each month how do i get it to add the values and only display them every 3 months,(every quarter)?
jan
123
feb
234
mar
432
first Q
789<---------how do i do this?
Apr
125
may
548
jun
323
second Q
So on..
Is this possible. I have a drop down menu.
<select name="dd1" onChange="somefunction(this)">
<option value="<%=rs("Image")%>" > <%=rs("Iname")%> </option>
</select>
I need to use the value=rs("image") in a javascript function, but i need the selected value of rs("iname") in an ASP array. Request.form("dd1") will always give me the value of rs("image"). Is there any way around this?
How can I get all the values of the previous form without having to hardcode the the names of the all the form elements? Something like:
Form Element Name: Form Element Value.
I want to pass the value of a variable through a form to another page URL
[CODE]
<form name="form" method="post" action="AgentReceipt.asp?date=" & strDateStamp>
<p>Date Stamp: <input type="text" name="datestamp" value="<% =strDateStamp %>"
[CODE]
I do not get the value of strDateStamp on the URL of the other page.
Using a query statement, I am trying to add values into the textbox of an ASP page to enable users to edit it. But it only displays the first word of the record. The rest of it gets chopped off. Code:
<P>Company Name:<INPUT NAME ="CompanyName" style="WIDTH: 371px; HEIGHT: 22px" size=47 Value=<%=objRec.Fields("company_name")%>></P>
The value in the textbox only shows R1 when the value in the SQL database is R1 International Pte Ltd. The datatype in SQL is char if it makes any diff.
i have a ASP search page, and when i go to submit the search and the page refreshes, id like the search box to still have the same value.
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies View RelatedIs there a code, or something that scrambles the value being passed fromone asp page to another??
what I mean is this:
if i want to pass a value from a database (record id #721) from my page records.asp to recordview.asp
it might appear like this in the browser window, or when u highlight the link on records.asp:
recordsview.asp?K=751
I don't want users to see exactly what record number is being access... so I'd like it to show some garbage in the browser like
recordsview.asp?@$@#$=DSFSD+jklsjkld
you get my drift...
for i = 2 to NOD
newdate = DateAdd("d", 1, newdate)
strdate = strdate & newdate & ", "
next
MyArray = split(strdate, ", ")
I have the above code written in one of my asp pages, the date array is splitted, but how do I get the first and last date assign to a variable.....
int min = MyArray(MyArray.Length-1)
int max = MyArray(0)
I got this code from the web, however it gives me an error:
Code:
Microsoft VBScript runtime error '800a01a8'
Object required: 'MyArray'