I know I can use
Dim Array1(item1,item2,item3)
Session("Array2") = Array1
To copy a local array to a session array. What syntax do I use to copy a local array to another local array (without using a loop to load each element)?
I don't know if this is possible, but I have a Do While Not rs.EOF loop that is pulling values from a SQL database and writes it to an html form. I'm trying to figure out how to tally the values as they are siphoned from the database -- I'm assuming I have to set a unique variable equal to that value as it goes through the loop, but I'm not certain how to pull it off. Code:
View Replies View RelatedHow can I assign the result of a SQL-query to an ASP variable? This is what I have so far but it doesn't seem to work. Code:
dim strSQL
strSQL="select TestID FROM TestID_Description WHERE CL1='" &Request.Form("CL1")& "' AND CL2='" &Request.Form("CL2")& "'AND CL3='" &Request.Form("CL3")& "'AND CL4='" &Request.Form("CL4")& "'AND CL5='" &Request.Form("CL5")& "'AND CL6='" &Request.Form("CL6")& "'"
objRS("TC_Number")=objConn.execute(strSQL)
Maybe it's interesting to know that TC_Number is the primary key of the table.
I have an ASP variable containing an XML object, i want to pass this object to a javascript object .... how can i do that?
one solution i know of is to write the xml in the page as an xml island and retriving this code using the document.getElementById....
is there another way where i can do that directly?
I have a catalog of books which need to be categorized into different
groups. Some of the books can be listed under more than one category.
I'm creating a page where I can assign a group of books to a category
by checking the checkbox next to their name (say I've looped out 100
of them, and check some, and not others) then submitting the form for
processing, so that those titles where the checkbox is checked will
get the categoryid number assigned to them on a one-to-many table
I need to know how to read the checkbox value as it comes in if it is
selected or not, if it is, I'll send the isbn in one direction, and if
not, I won't send it at all.
So, how would I read this on the sheet that grabs the values?
I'd like to have a variable that I assign a value to for an entire website. It's a variable that contains the DSN name for my ADODB Connection.
This variable value is necessary on every page on the website. Is it incorrect to assign a variable the value in global.asa so it just stays for the entire site?
I am trying to assign an invoice number to orders that are made on my website so that i can combine multiple order numbers into one invoice number. Here is the code i am using to insert the invoice number into the orders table.
It works if there is only one order in the table but if you try and order again it multiplies the orders by the number of invoice rows for example if there was 3 invoice fields it would add the same order 3 times into the order table. Its got stuck in some sort of loop. Code:
Well, it's quite simple, it's easily done in C, but in ASP (and VB in
general) i haven't been able to see it done...
function setvalues(var1, var2="a", var3="b")
if var2="a" then
response.write("Var2 wasn't defined")
end if
if var3="b" then
response.write("Var3 wasn't defined")
end if
end function
I hope it makes sense, and that someone has the solution to it...
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
View Replies View RelatedI 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 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.
Is 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'
1) User selects something from an ASP generated list
2) Javascript then populates a nearby div with the text from this list
HTML/ASP: Code:
I am facing with a problem of getting Drop Down Values. How do I get Drop Down Values in a array.e.g,
On Submit, I hv to display records based on similar MergeIDs,
Like, e.g for MergeID - 1001 i have 2 records in database
So I will hv to display those two rows in a concatened form.
But these two records hv different IDs.
ASP Display
DropDown MergeID Username Task ID
3 1001 Ashish,Kamal Design,Test 21,22
5 1002 Sunil,Anil Data,Design 25,26
Now, when I Select 3 and 5 in drop down,I want that for MergeID it should show DD value as 3 and for MergeID 1002 as 5.I am not getting that.I am able to get IDs 21,22 in an array.
I have the following line of code in my asp page:
Dim ix
For ix = 1 to Request.Form.Count
fieldName = Request.Form.Key(ix)
fieldValue = Request.Form.Item(ix)
Response.Write fieldName
Response.Write fieldValue &
Next
Response.End
It is not returning the results of any field on the previous form page.
Does anyone know what I might look for?
I'm a (moderate) newbie to and I'm building an ASP/VB db-driven site where the user selects a brand from a menu, this determines the contents for another menu with models. Selecting a model displays details about that model. Nothing too original here Its a small low traffic site with no ecommerce elements - just window shopping.
My questions is : I need to know on all pages what the current brand and model are (and modify these when the user changes them).
From what I understand there are 3 (?) methods: server vars, session vars or hidden fields. Which should I use for this purpose and can anyone point me to some good related examples/tutorials? (I've read the stuff on this site of course).
I have a form which the user fills and submits.i have insert statement there.
When i submit the form to itself ,the values get submitted and inserted in DB easily.
<form method="post" action="Infoviewagentver212.asp" name="form">
Now when i want the user to hit submit and go to other page i change the above to:
<form method="post" action="newpage.asp" name="form">
but here what happens is my values are not getting inserted in the DB??
How do i do this?
How is it possible to execute an exe from asp and get a returned string (no http headers in exe) ?
To run exe I use :
<%
cmdExe = sPath & "cgi-bin
equest.exe"
Set WshShell = Server.CreateObject("WScript.Shell")
sResult = WshShell.Run(cmdExe, 1, True)
Set WshShell = Nothing
Response.write sResult
%>
sResult always content "0" and not the string returned by exe file (something like "!!-1!blabla!blablablabla!")
- How is it possible to get the exe returned value ?
- Is there a solution with asp.net ?
I'm trying to determine if I can use transactions in my ASP applciation against one of our Oracle 9i databases. My WROX manual says I can do this if the Transaction DDL property of my connection object is equal to 8. I've checked my connection properties with the following script and determined that my Transaction DDL property is 2
'============================================
Set conn = Server.CreateObject("ADODB.Connection"
conn.open Session("PROVIDER")
For Each Item In Conn.Propertie
response.write Item.Name & " = " & Item & "<br>
Nex
'============================================
But what is 2? MSDN (http://msdn.microsoft.com/library/d...oprg04_83jt.asp) says there are a number of possible vaues for Transaction DDL such as
DBPROPVAL_TC_NON
DBPROPVAL_TC_DM
DBPROPVAL_TC_DDL_COMMI
DBPROPVAL_TC_DDL_IGNOR
DBPROPVAL_TC_DDL_LOC
DBPROPVAL_TC_AL
But which one relates to value 2
I have a submit form that collects my values, and if my form action is "mailto" the values are passed, but if I try to pass to another asp page the values aren't sent and the asp doesn't execute.
View Replies View Relatedi m using frontpage to create a login form using SQL SERver database. i want 2 redirect the value of username & password to another page.
View Replies View Related