some ready-made code that will loop through the values in an array and sort them in ascending or descending order? I'm about to start building some new functionality that will need to sort the values in an array and then present them in ascending order. My initial thoughts are to loop through the initial array, find the lowest value and then load that value (and all associated values) into a new array.
View RepliesI need a array with x numbers (1 to x) mixed. Like this:
Using 4 numbers (1 to 4), i need:
array(1) = 3
array(2) = 2
array(3) = 4
array(4) = 1
This is random. I make this: Code:
point me to a good online tutorial (preferably for slow learners) about advanced handling of arrays, like re-sorting the data, etc.?
View Replies View RelatedI am trying to sort a multi dimensional array but am getting an error. Can someone please help me out. Here is a sample of the array (it is created dynamically from the db): Code:
View Replies View RelatedI have an array, PositionArray(), which contains a variable number of integers. I need to sort these array elements numerically. Seems I've done this before in VB, but I can't seem to get my mind around it now. Does anyone have a simple bubble-sort code, or is there an ASP way to do this?
My ultimate goal is to take a chunk of text, and highlight (bold, color, whatever) words that are contained in a string array. My thought is to find the position of each word with the InStr() function, then find out which position occurs 1st, which position occurs 2nd, etc., then build a string from the beginning of the text chunk to the position where the first word begins, add a bold tag, add the word, add a </B> tag, and continue until the end of the chunk.
i have a sorted array of 43 columns. dynamically altered the array and added a new row to the existing array. i need to sort the array based on 2nd column. how to sort a multidimensional array?
View Replies View RelatedI have some information that I want to put into an array and display the next 3 events based on the date.
I don't want to display any events that have already have already expired. Also, I ONLY want to display the next 3 events...nothing more. So how do I go about this? I am a HORRIBLE ASP programmer, so consider me a newbie. There are 4 pieces of info that I want to display with this..."Show", "Location", "Booth", and "Dates".
What I need to do is sort an dimention array by the name field and the best way I can think of to do this is by a bubble sort. However, I'm running into a problem with the bubble sort and I'm sure I'm just missing something simple.Here is the code I have Code:
Dim objAllBrands, objBubbleArray, a, i
For i = 1 to objAllBrands.count
For a = 1 to objAllBrands.count
If objAllBrands.item(a).Name < objAllBrands.item(i).Name then
objBubbleArray = objAllBrands.item(i)
objAllBrands.item(i) = objAllBrands.item(a)
objAllBrands.item(a) = objBubbleArray
End if
Next
Next
It doesn't like this line objBubbleArray = objAllBrands.item(i) and I'm sure there are other problems. Can anyone give me a hand with this?
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'
i have my database in MS Access. a table name products contains fields:
pro_name
no_of_comp
inserting data from form where products field is mutiline text box. split this and store in array then insert records.
now i want to facilitate let user edit their data.
during editing new products are entered with no_of_comp = 1 and already exisiting products gets no_of_comp= no_of_comp + 1.
if user delete product then no_of_company = no_of_comp - 1.
what i want to do is: Code:
How can I remove a value from an array. Like: remove from array where value=bla-bla?
View Replies View RelatedI have an array which has days of the month stored in it. For example at one
time it might have the values
1,2,3,6,7,8,9
at another time it might have the value
4,5,12,14,19,25
These are days of the month that have been selected and read into an array.
What i would like to do is to write them out and put a "X" where the days
were selected Code:
i m getting these value from a query n stored it in an array:
FY2005 P1 (8/1/2005 - 8/31/2005),
FY2005 P2 (9/1/2005 - 9/31/2005) and so on.
i need to use eg
8/1/2005 as startdate and 8/31/2005 as enddate
similarly
9/1/2005 as startdate and ,9/31/2005 as enddate.
and so on
we can split FY2005 P1 (8/1/2005 - 8/31/2005),
FY2005 P2 (9/1/2005 - 9/31/2005) by using split func in vbscript. But how can we use its subparts.i mean 8/1/2005 etc ...
I am wondering if its possible to load two array ad use one as item title and the other as value, ex:
array1 = "Sally, Jason, Jackson, Marie"
array2 = "24, 54, 21, 33"
For ....
TempSally(Sally) = 24
TempJason(Jason) = 54
....
Next....
I have the following code to check if a field number matches a specific value. here is the code:
View Replies View RelatedI first retrieve the values stored in a session variable (where I have stored an array). Then I assign the session variable to a local array called "myarray".
Assume that "myarray" now contains 5 records. What would the code look like if I want to create a loop that transfers the 5 values from "myarray" into a select box/dropdown list?
How is that done?
I have 24 checkboxes all with the same naming convention, each box has a
value ranging from 1 to 23, what I need to do is fill in the gaps with a
0 value where the user doesn't select a value.
So lets say that the user selects:
1,2,3,4,5,6,7,15,18,19,20
what I want to do is use the split function on the next page to convert
into an array but then I want to redim the array and fill in the missing
values, so I would end up with:
1,2,3,4,5,6,7,0,0,0,0,0,0,0,15,0,0,18,19,20,0,0,0
is it possible to do this and if so how?
I know that cookies can store an array of values, which can be accessed like this:
tempid = Request("cookiename")(i)
Is it possible to use session variables in the same way? Store a array of values in the same session variable and access them on another page by indexing?
I've looked around alot and I've not found anything suggesting that this is possible.
Right now I'm using a single set of cookies to store info on a series of purchaces of the same type of item. I'm hoping to use session variables to replace the cookies.
Does anyone know for certain if this is not possible?
I have part of a keyword search function that is acting supernatural - I have a bubble-sort function that sorts the content of an array, then returns an array containing the item numbers of the original array, arranged in order according to their content. Code:
View Replies View Relatedhow to create an array of checkboxes that were selected from a form on one page and pass them into hidden fields in a form on the next page? I have this massive project I've been working on and am having trouble with this.
View Replies View RelatedI am trying to filter a table of users to select only those records
whose roleID matches a value in an array. There could be any number of
IDs held in the array from one to a few hundred. The array is
generated by splitting a comma delimited memo field from a second
table in an Access DB. I can split the memo field OK, I can
response.write its values, but what I now want to do is add a value
from another table to my reponse write loop. Code:
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
if i have a vbscript function on a certain form and I assigned some values on an array variable on that function, is there a way for me to retrieve the values of that array on another asp page once i submitted the form?
View Replies View RelatedI've had an ASP project dumped on me written in VBScript. I'm actually a
C#/ASP.NET developer and am struggling trying to find a way to sort the
result of a XPath query executed using SelectNodes?
I'd rather not rely on external XSL files if possible.
I have this database that contains four columns (ID, Name, Qty1, Qty2). I can display the data on an ASP just fine but what I want is to display the data in Ascending order of the total number between Qty1 and Qty2 of each record (Qty1 + Qty2 = QtyTotal). Obviously the total number is not stored somewhere in the database. So how can I accomplish this?
View Replies View RelatedI try to find a script in ASP that combines sorting and paging. I already found various scripts that do one or the other but none does it both. I know I should combine them, but it is very difficult at my level of asp knowledge.
View Replies View RelatedI wanna ask how to do the following sorting function, for example
Name Age
Brian 22
Alice 17
Patrick 21
when click on name, it will sort by
Alice
Brain
Patrick
when click on age, it will sort by
17
21
22
Is it execute the SQL by hyperlink..? Can anyone give me an example?
I created a script which suppose to sort on 2 fields. Everything works fine with no errors except when I click on the field that suppose to sort the data it does nothing.
This is the code: Created on test table name Reports2 3 fields id, r_date, r_doc_title
Code:
Can someone please explain to me why the hyperlinked column headings will sort in Firefox and IE 7 but not in IE6. Code:
View Replies View RelatedI have a set of records which are sorted AtoZ in display. Problem comes is like:
A.1
A.10
A.2
A.20
A.3
A.4
A.5
A.6
A.7
A.8
A.9
Actually A.10 is required after A.9 and A.20 after A.19.
I have searched for this, but found that on every page it sorts records like this. Also, I can not sort items based on ID (auto increment) because certain items are added at later time and some first.
I'm programming as ASP site to show the results of dynamically querying a MS Access database and outputting the results in a table. I've got that part to work. But, what I can't get to work is for the header row of the table to be links to sort the data ascending or descending by that particular field. All I can get to work is having a little +/- next to the column header and those sort it, but I can't figure out how to get the headers themselves to do both sorts when clicked.....can anyone out there help??? Thank you in advance!!! Also, if anyone knows about Access 2000, I've never tried doing this in it before, but I need to export one of the field to be links to HTML pages that describe those seminars, has anyone done that? Just figured I'd ask while I'm typing this
View Replies View RelatedIs there any way to sort the files and folders according to different things (i.e. size, date, etc.)? I'm using For...Next loops.
View Replies View RelatedI have never sorted a recordset - using rs.Sort - i have no problem sorting it in SQL.
All the tutorials i get say that i have to use a client cursor location, so this is my code: