One Dimensional Array
If I have an Array declared like this:
MyArray = array (“value 1”, “value 2”, value 3”)
Will this array physically be a long single row or a single column (like below)?
Value 1 value 2 value 3
Or
Value 1
Value 2
Value 3
View Replies
ADVERTISEMENT
I need to loop through a two-dimesnional array (x,y) until a value in x is empty or the end of the array is reached, whichever comes first. Example array:
Dim myArray(4,1)
myArray(0,0) = "part 1"
myArray(0,1) = quantity
myArray(1,0) = "part 2"
myArray(1,1) = quantity
myArray(2,0) = "part 3"
myArray(2,1) = quantity
myArray(3,0) = ""
myArray(3,1) = quantity
myArray(4,0) = "part 5"
myArray(4,1) = quantity
In the example above, the loop should stop once it determines myArray(3,0) is empty. If myArray(3,0) was not empty, the loop would continue until the end of the array was reached. Anybody have a code example to do this?
View Replies
View Related
how do I resize a two-dimensional array? The array I'm working with is "data(X)(Y)" where X is 0 or 1 and Y grows to a dynamic number.If "data(1)(highest element)" IsNull, then I need to strike it from the array. I believe this should be doable by simply resizing the second dimension down by one. Through researching I established the following set of code:
I = UBound(data(0)) - 1
ReDim Preserve data(2,I)
But it results in a "Subscript out of range" message on the latter line. Short of looping through and building a new array.
View Replies
View Related
I'm working on developing (yet another) shopping cart for my work. I was wondering if anybody knows which approach leaves a smaller footprint in memory on a server: an ADODB Recordset which stores arrays one-dimensional arrays or a two-dimensional array?
We are currently hosing our web site on a shared machine at Verio. The cart I have to build needs separate carts because a customer's products can come from different locations. Each location will have a different cart. On the cart page itself, I would like to display each cart in a separate location.
Logically, it make the most sense (to me, anyway) to use an ADODB Recordset to manage each individual cart (array) than to write the code to manage the arrays. What are the disadvantages of using ADODB recordset instead of a two-dimensional array in this case?
Which approach would be easier to manage and manipulate? Are there any reasons why I shouldn't use a two-dimensional array? The nice thing about ADODB is that I will not need to program certain features and have access to FILTERS.
Any suggestions about how each approach would scale as site traffic increases? Will one approach bog down the server more than the other? I'm also open to suggestions about a possible, yet illusive, 3rd way.
View Replies
View Related
what i want to do is have a (multi dimensional?) array, so that each second dimension represnts a row of radiobuttons. The trouble is i don't know what to name the arrays as. Obviously for each row the names for the different radio buttons will be the same, meaning you can only select one.
in php you could do it with a single array as you name each row of radio button differently:
1st row:
name='array[0]'
2nd:
name='array[1]'
in asp it doesn't look like you can do it this way, because to create a similar array you'd do something like
1st row:
name='array'
2nd
name='array'
then use split in the recipient script. This does not work however, because each radiobutton (on all rows) has the same name, and therefore when you click one all the rest on every row are unclicked..
View Replies
View Related
I understand the logic behind a multi dimensional array (sort of). What I need to do is be able to capture the product information (that is in a product session) that a user has selected and email it to a specific address.
The email coding page is written in javascript. This page is already being used to also send the customer credit information. If anyone has some insight in this I would be very appreciative. Code:
View Replies
View Related
I guess one should declare the array using empty brackets.
Dim MyArray()
Later I set MyArray to:
Redim MyArray(2,3)
The problem comes now. How should I use Redim again? I have heard that only one of the two dimensions can be enlarged or decreased. Is that correct? If so, which dimension would be ok to set to 5 in MyArray. Is ReDim MyArray (2,5) correct or should it be (5,2)?
View Replies
View Related
how to get and assign the first dimension of a two dimensional array to another array? For example, I have a recordset object (rsObj) and then I take that object and assign to array (via GetRows() method). I would like to take just the first dimension and assign to another array, but I get a "Subscript Out of Range" error.... any ideas?
temp_array = rsObj.GetRows
new_array = temp_array(0)
View Replies
View Related
Does anyone know how to store multi-dimensional arrays in the Application object? And if so please show an example.
Also, how do you loop through multi-dimensional arrays? I just can't seem to get my head wrapped around this.
View Replies
View Related
I would like to know how many rows and columns are created in the following array. Is it 10 rows and 2 columns or is it 10 columns and 2 rows? Dim Array(9,1)
I have searched for some info about it but not found any consensus. Some sources claim that the first number symbolizes the rows and the second number the columns and other sources claim the opposite. I am confused.
What is it really like? How many rows and columns?
Assume that I need an array with 2 columns and 5 rows then how should it be declared (4,1) or (1,4)?
Which is the first dimension and which dimension it the second one? Horizontally (first/second) vs vertically (first/second)?
How are the various elements called, for example how is the element on the first row in the 5th column called. By using (0,4) or (4,0)?
Assume that I want to store first and last names in two separate columns in an array and then expand the array by using Redim/preserve. The dimension I want to expand is the one with the rows because I view the array as a table with two columns.
I know there are certain rules that apply when it comes to using Redim/preserve on multidimensional arrays. Only the last dimension can be changed etc. How could that be done in this case? I am mainly interested in the declaration (1,x) or (x,1), where 1 is the number of columns and x number of rows (that is increased).
View Replies
View Related
I am trying to setup a 2 dimensional array which i can populate on the fly with data coming frtom a database.
I understand that you have to set a specfic size for the array in ASP, but I am looking at making the array dynamic and using the Redim function to increase the size by 1 each time. Code:
View Replies
View Related
I am trying to create a dynamic multi-dimensional array, based on a count from a database. The count is correct, but when I try to Redim preserve my array, I get an error...
Subscript out of range
referring to the line of code...
ReDim Preserve builderArray(CInt(builderCount),5)
How can I do this redim successfully?
View Replies
View Related
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
View Replies
View Related
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
View Replies
View Related
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
View Replies
View Related
i want to excute given logic
select * from Product_Table where Product_Code in
ARRAY
i.e i want to select Product_Code from VB array and not from a query
is it possible.
View Replies
View Related
I know I can do this programatically using a loop but I thought there might be
some easier or more effective way.
I am trying to invert an array.
i.e.
array1 = 1,2,3,4,5
but I want to get
array2 = 5,4,3,2,1
Is there something like array2 = invert(array1)?
View Replies
View Related
I have to following code:Code:
dim arrRes(9),getal,som
arrRes=Array(4,4,4,4,4,5,5,5,5,5)
for getal=0 to 9
som=som+arrRes(getal)
next
response.write("Het klasgemiddelde is " &som/10)
I get a type not match error on the second line
View Replies
View Related
I have a page in my admin system where the user can edit products they
have added. The problem I am having is with Related Products. These are
all listed in a multiple list. What I need to do is have those selected
when the product was added, already be highlighted in the multiple list
on the product edit page. Here is my post from another forum.
Code:
View Replies
View Related
For some reason, when I try to run the following array, I'm getting an
error:
dim cat(0)
cat(0)="0407"
cat(1)="0102"
'I will be adding more to this array, but just trying with two for
starts.
for counter = 0 to 1
itno=cat(counter)
'I get an error when it runs through this function
Function rightvar(theVar,lengthNeeded)
Dim sResult
sResult=theVar
if Len(theVar)< lengthNeeded then sResult= String(lengthNeeded -
Len(theVar)," ")& theVar
rightvar=sResult
End Function
Can someone help me understand why?
View Replies
View Related
The problem is that in my 5 years of programming in various languages i have never really understood arrays (DUMB @$${lol})
What i want to do is offer an advanced search of a database table on my website. I currently offer the functionality so that the whole of the database can be viewed within the web page so that it doesn't need to be downloaded/need access to view it.
What i need to do is run a script that takes all of the column headings that i have and put them into an array. Then with the array i need to output each element into a drop down box.
View Replies
View Related
Ok what I have is a little script which runs through my stock compares how many of one item we have compared to what we need and displays the out come.
What id like to do is make an array with the item name so lets say If how many is needed is greater then 0 then add the name of that consumable to an array and move on until the end.
Then I want to use the arry to display each consumable on an order form. Anyone have any idea how to do this in ASP or can give me any advice on a better way to do it?
View Replies
View Related
I am doing the following:
Code:
dim n
n=4'ubound(arrsequences)
response.write "n:" & n
dim arrproductNames(n)
dim arrproductSeq(n)
and getting the following error:
Microsoft VBScript compilation error '800a0402'
Expected integer constant
process.asp, line 33
dim arrproductNames(n)
View Replies
View Related
How can I add something to an array, e.g
[VBS]
Dim MyArray
MyArray = Array("Item 1", "Item 2", "Item 3")
'Do some code here
'I now want to add another item to my array, how?
[/VBS]
View Replies
View Related
Is there a way of determining whether or not a value or values are present in an array.
Is there something nice and easy as with php's
if(in_array($SomeValue,$myArray)){
echo "The value is here";
}
else{
echo "The value is not here";
View Replies
View Related
how to store request multiple value(Select box) in an array.
View Replies
View Related
im trying to write a script that will allow me to take names and addresses
from a coma delimetered text file and insert them into a db.
ive managed to come up with this script which deals with works well if i
only have names in the text file. ie:
bob smith, peter smith, brian smith
but now i want to do something simular with a text file formatted like so
bob smith, bob smiths address, peter smith, peter smiths address,
i think i have to use a 2 demensional array but really have no idea how to
go about it. any help appreciated. here is what i have so far. Code:
View Replies
View Related
I have a form that has fields named Title1, Title2, and so on to title 12
I want to set up an array that goes through all the input feild values that I already put into variables such as Title1, Title2...so on. It then replaces ' with '' so the apostrophe can be entered into the database. So it:
Creates an array by looping through the variables that get the form feilds.
Then loops through the array and replaces the ' with '':
Title1=(Replace(Title2, "'", "''"))
View Replies
View Related
I'm looking to make an admin page for a web photo gallery, and I need to make a drop down menu showing all files in a given directory that do not have comments in a database for the given filename.
I'm curious about the most efficient way to do this. I don't want to query the database separately for each file as this would be horribly inefficient. I'm thinking about two arrays, one containing all filenames in the photo directory, and one containing filenames from the database that have descriptions.
Is there a simple way in ADO to do a set operation on arrays, that is to produce array C that has all elements in array A that are not contained in array B?I can do this with while loops, but there must be a better way.
View Replies
View Related
Can someone tell me how to do add a 2D array in a table
this is how my tables looks like
OrderID
Product_Code
Product_Item
Size
Color
Logo
Price
Unit
Total
View Replies
View Related
How will I replace the array values from database to this javascript static array value?
Quote: var photos = new Array('Blue hills-01.jpg','Sunset-01.jpg','Water lilies-01.jpg','Winter-01.jpg');
View Replies
View Related
I am editing an old mail script that uses a a sendTO array to designate who actually gets the email. I want to add a value (an email address) at the end of the array so it is sent the same mail as any mail that goes through the form(teh form has one huge dropdown list now).
I just don't know how to simply add the value to the bottom of the list
Any clues (i found some examples but there was way to much extra code that i was having trouble sifting out)?
View Replies
View Related
I'm working on a project using arrays like this:
thisArray = array("value1", "value2", "value3")
It's seems to work great, but now I'm confronted with adding to that array at a later point. How can I add to an existing array?
View Replies
View Related