I have two 2-dimensional arrays (made by using GetRows()) What I need to do is:
Loop
If Arr1(0) = Arr2(0) then
do an update....
End if
End Loop
Basically I need to compare each value in Arr1(0) to the values in Arr2(0) - if I get a match, I have to do an update in the database. What is the easiest way to do this .
What I have is a recordset listing out a group of names. I've retrieved the field that lists the id numbers for the array and split them to a list. Then I want it to loop through the names listing trying to highlight the ids that need to be hightlighted.
What I am getting is my list repeats the names according to how many ids are in the array. So if I have 2 numbers in the array I see every name on the list twice and the two that I need selected.
I want the list to show the names one time with the correct names selected. What is wrong with this code? Code:
Attached is the code that I am trying to put together. Does anyone know how to loop (see bold text below) this so it will display all the data from the columns in this row? Code:
View Replies View RelatedI am not sure how exactly to put this, but what I need to do is the following: taking into account that there are multiple URL's pointing to the same server
If url=blah.com do nothing
if url=blah-blah.com *break out of frameset.
Now I remember there being an easy way to do this but can't for the life of me remember where to find it?
i have 2 loops that give me 2 sets of 25 numbers. code:
do while not rs.eof
value = rs("value1")
rs.movenext
loop
do while not rs.eof
value = rs("value2")
rs.movenext
loop
i need to subtract value 1 from value 2 for each value in the loop?
I was hoping someone would be able to explain the "For Each In Loop" set up.
What I'm really asking is when it can be used and how it is set up.
For example:
If I had something like...
Quote: For Each X in objSomeObject
Response.Write X & "<br /">
Next 'X
How do I know I can use the For Each In Loop and what must I do to be able to use the X portion of it?
Sorry if this is a very general question but I want to understand how one can recognise when it is possible to use this structure and when it's not.
More background to this is that I'm going to attempt to use this structure on a listbox in .NET and possible ASP and I want to ensure that I loop through each and every item.
What I'm trying to do is match all buyer requirements in a database table to all available properties in another table. I then want all these matches displayed in a report with the buyer name followed by the relevant matching properties, this should occur until all buyers have been displayed with their matching properties.
The problem is that it only works correctly for the first buyer for which the correct properties are displayed, after that all I get is the buyer names without their matching properties... so it seems to loop perfectly the first time but from then on forgets about the inner loop! Code:
I want to find the next event in my sql database. To do this, I have a query in a while loop. I set a new DateTime variable to the current date and run the query, it checks to see if it found a suitable event, if not, I want to increase the day by one and loop again.
View Replies View Relatedthere are various of loops but i am analyzing to use which one. maybe i could get some opinions from u all. there are
while wend, for loop, do loop
my situation is if i need 2 execute on a daily basis data on the particular month and will stop on the last day of the month.. without interseeing to the next month
can anyone might help me by suggesting on the suitable loop 2 use for this problem?
I have some difficulty with deep inner loop. What I want is Eg
Product Category: Air-Cond
Company: ABC
Address: 121, Time City, Malaysia.
Company: XYZ
Address: 1, City, Malaysia.
Product Category: Fridge
Company: MAS
Address: 2, Old Building, Singapore.
Company: SAM
Address: 11 Kiosk, Malaysia.
Basically, the first the first loop is to get all product category and one by one insert into the second inner loop. But, I need another inner loop under the second one, which is to categorized by country. Code:
I have successfully paged through a recordset on my page using the .recordCount, etc. methods, the only thing is I have 2 independent recordsets looping on the page, which when there was not paging involved this worked fine, however now I need to span the results of BOTH of these across pages, I just cannot seem to figure out how!
I have one set of records paging fine, but the other either messes the page up, or shows on the first page of results and no more of the other recordset, etc.... so yeah that is basically the problem I am hitting, so I was just wondering is there any examples or ways you could tell me to do this??
I have trouble working with arrays in asp.. I have the following error :Microsoft VBScript runtime (0x800A0009)
Subscript out of range: '[number: 0]'
the line that gives me the error is the following:
Door_OpeningValH= aDoor_OpeningVal(0)
and my code is this:
Door_OpeningVal= rs("Door_Open_Dimension")
aDoor_OpeningVal = split(Door_OpeningVal, "x", -1, 1)
Door_OpeningValH = aDoor_OpeningVal(0)
aDoor_OpeningValW = split(aDoor_OpeningVal(1)," ",-1,1)
Door_OpeningValW = aDoor_OpeningValW(0)
Door_OpeningValUnit = aDoor_OpeningValW(1)
what i'm doing is recivieng values from 2 textboxes and a combo box.I want it to save in my database like this:
2x5 ft
I need to create a multidimensional array using another int as one of the criteria but I keep getting probs with my code, what am I doing wrong?
Code:
intMonthName = Cint(Month(field_in_my_database))
Dim myarray(intMonthName,2,5)
I get this error message:
Quote: Microsoft VBScript compilation error '800a0402'
Expected integer constant
I am using ASP with VBScript and I want to know how to seperate a 2 dimensional array into 1 Dimensional arrays:
like if
MyArray is a 2 D array and I want to store the first row of this array in another array , like in C
MyArray[5][5] //this is a 2D array
OneDimArray=MyArray[0] // stores the first row of the 2D array in OneDimArray
is there a way to do it in VBScript ????
I couldn't find a way
I don't want to do it with loops I hate code with too much loops,
How can display unique values from an array. I dont want to loop thru all the values and do it. Is there a better way?.
View Replies View RelatedWhat does the numeral '1' mean in the following statement?
For J = 0 to UBound(QArray, 1)
I have an array in ASP and I am populating the array with the values from database on checking a condition. Lets say i have array of arr(5). Initially I made all the array items null ...
View Replies View RelatedI have an array in ASP called WordsArray() which contains several words. What I would like to do is search the array for a word, and if its not there, add it to another array ResultsArray()
So far, a loop in my code only checks the current array value, and not the rest of the array, adding the search word to the end of the resultsArray regardless.
I have two related tables in my database. One stores events and the other stores a list of key topics.
I have an interface set up where users can add / edit events.
In the add event page, I am querying the "key topics" table and returning them as options (array of checkboxes). The user makes their pick, and submits. All the data saves in the 'event" table, including the primary id of the "topics".
That part works great. The problem I am having is when the EDIT event page resolves, I am trying to "check" the options that were previously saved.
First thing I do (at the top of the page) is to query the events table to pull all of the data out. I use the 'events" table to do this.
For the checkboxes, I am once again looping through them in a query that uses the "key topics" table. So the boxes are displayed, but I can't seem to get the logic right to have the appropriate ones checked. here is my current code:
i want to create a dynamic list or array in asp as we have arraylist in asp.net. what i want is that i want to hold the values selected by the user in a list and in advance i dont know that how much values the user will select. i also tried to use array with redim but that did not work as we can create array with only constant integer parameter.
View Replies View Relatedat the moment i am creating a shopping cart of sorts. Simply the user selects the check boxes of the items he wants and clicks submit. The items are dynamically created and they could select anything from 1 to 100 items..
so processing the form is clear not possible by hard coding. How could i read all the values from the POST into an array instead of processing each item at a time.
I have a string that looks like this: a|b|c|d%e|f| ...
I split once on "%"
ar1 = Split(Mystring, "%")
then when I try and split the ar1 by
ar2 = Split(ar1, "|")
I get error '800a000d' Type mismatch
I have tried
ar2 = Split(Cstr(ar1), "|")
How can I split this string?
I have run into a unique issue, what I want to be able to do is store a collection or array into a database or xml file. The main reason for doing this, is I don't want to use Sessions as they are volatile to server hiccups or resets. I don't want to use cookies as they are insecure, but I will use one cookie to store a UniqueID to relate to the data in the database or XML file.Can anyone think of a way to store an array in Access, MySQL, or XML file?
View Replies View RelatedI'm trying to create a table summary from SQLServer.
There are ten questions that the user must answer.
I can create the ten arrays, np, but I'm just thinking, say Question 9 never has anyone answer with the value 1, then the following step in the code (the way I see it) would fall on its face.
There are two ways round it that I can see. Test for an empty array 'index', i.e if Array9(1) = "" then ...
But my question is this, is there a way to initialise an array so that all it's values are zero? This would solve the need to test for "" later.
I have the following:
dim app_ids, irowloop, icolloop
app_ids = get_app_logins(session("stremail"))
for irowloop = 0 to ubound(app_ids, 2)
for icolloop = 0 to ubound(app_ids, 1)
response.write(app_ids(icolloop, irowloop) & ",")
next 'icolloop
response.write("|")
next 'irowloop
That returns:
0,0,bobsmith,pAssWord,|0,71,tom,tom,|0,71,tomf,pAs sWord,|1,5,tom,a1,|
Is it possible to remove the final ',' before the '|' ??
Is there a performance advantage to parsing thru a recordset verus using an array?
I'm currently trying to populate a listbox by returning data from my database, then either parsing thru the recordset until I reach the EOF, or putting the data into an array.
Can someone explain to me the performance implications of using Dictionaries rather than arrays? I imagine arrays are lighter but how much lighter?
View Replies View RelatedIs it possible with ASP to use arrays with names (e.g user("username") = "ble") instead of numbers (e.g user(1) = "ble")?(I do know of the dictionary object, but is it wise to use that 7 times or more a page?
View Replies View RelatedI'm trying to figure out if there is an easy way to combine the contents of two arrays into one array. Order does not matter, I just want them all together. I'm sort of new to working with arrays, so I don't know if there is a really basic way to do this.
View Replies View RelatedI have an array of product names what I am storing in a session variable.I am looking at being able to delete a specific item but am having trouble acheiving this. I am retreiving the Session variable and initialising it to a new array, then I want to copy this across to a new array apart from the item that I want deleted. I am having difficulty creating an array using a variable as the new array length.
Code:
Expected integer constant
I have one ASP and sends XML data to another ASP which returns Data from a Database. Pretty straight forward, however the XML string is quite long and I would like to pass it to the second ASP via a POST rather then a GET. Problem is that the only way to retrieve the data is to use the BinaryRead method of the Request object.
This data is only text, but I can not find any reference of how to use the data once I have retrieved it?how do I access the Data from the REQUEST.BINARYREAD?
WINXP/FP2000/IIS4
Is is possible to pass a populated static array to a new page - as session variable, maybe or cookie?
i would assume it should go outside the inner for/loop so it would print a line for each record, since your outer loop is for each record and your inner loop is the columns. don't see how it's working that way.
View Replies View Related