Ubound In Array
what role does ubound play here?like whats the diff between
--------
for j=0 to ubound(arrMsgid)
-------
and
--------
for j=0 to arrMsgid
-------
where arrMsgid is an array
ADVERTISEMENT
Ubound(array) = -1
I just got an odd result when I tried to split() a string that didn't have the delimitor in it...it looks like an array without any elements (which is weird - I've never seen one of those in VBS).
UBound says the upper bound on the array is -1, but isArray() says that it is indeed an array. Is there an easy way to check for this condition (or do I have to do both isArray AND UBound)? My VBS docs say nothing about split() returning an undefined array nor UBound() returning a -1. What the dilly, yo?
UBOUND
<% if UBOUND(Arr) > 0 then%>
<% end if %>
I am getting the following error:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'UBOUND'
How do I solve the problem.
Split And Ubound Function
this code gives me one short of the ubound function, what is wrong?
e.g if i have 353425432,325423,2542354
it gives me 2 instead of 3
jumvar = request.QueryString("one")
jumvarsplt = split(jumvar,",")
valnum = CInt(ubound(jumvarsplt))
Error Handling With Ubound
Error is:
Subscript out of range: '[number: 0]'
or
Subscript out of range: '[number: 1]'
or
Subscript out of range: '[number: 2]'
This is correct in that the variable is empty if user does not fill in correctly. However how do i stop it falling over and just get it to error handle?
e.g. If Subscript out of range: '[number: 2]' empty how do I 'know' this without an error? Code:
Creating Arrays In ASP (Ubound Function)
I am currently using arrays to store values that a user inputs into text fields which represent cells in an access table. I am currently coding them like this:
*********
HomeScore = Array(0,1,2,3,4,5,6,7)
HomeScore(0) = Request("Home_score1")
HomeScore(1) = Request("Home_score2")
HomeScore(2) = Request("Home_score3")
HomeScore(3) = Request("Home_score4")
HomeScore(4) = Request("Home_score5")
HomeScore(5) = Request("Home_score6")
HomeScore(6) = Request("Home_score7")
HomeScore(7) = Request("Home_score8")
*********
And then later refering to these values using a for loop like so:
*********
For x = 0 to 7
strsql = "Update CUPFirstRound Set Home_Score=(" & HomeScore(x) & "),...
conn.execute(strSQL)
Next
*********
I know that it is possible to shorten this cpodiong using the Ubound function but i really dont know how to use it and i cant find any where useful on the net that explains it how i need to know.
If anyone can help me from what they see above then it would be Really appreciated, if you need more code just let me know. I didnt paste the whole code because that is pretty pointless because its virtually all the same except for the names of the arrays and the fields it is requesting (Request("..."))
Error Type:Microsoft VBScript Runtime (0x800A000D) Type Mismatch: 'UBound'
I got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";")
For nX = 0 to UBound(aList)
strarry=split(aList(nX),"_")
var_year=left(strarry(2),4)
var_month=mid(strarry(2),5,2)
var_day=mid(strarry(2),7,2)
var_date=var_day&"-"&var_month&"-"&var_year
var_time1=mid(strarry(2),9,2)
var_time2=mid(strarry(2),11,2)
var_time=var_time1&":"&var_time2
set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')")
Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
Rebuilding Of An Array From An Existing Array
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.
Array Integers Vs Array Variables
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:
Create A New Array From An Array
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?
Array In Sql
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.
Array
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)?
Array
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
ASP Array?
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:
Array
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?
Array
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.
Asp Array
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?
Array
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)
Add Something To An Array
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]
An Array
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";
ASP Array
how to store request multiple value(Select box) in an array.
View Replies View Related2D Array
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:
Array
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, "'", "''"))
Array
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.
2D Array
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
Array Value
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');
Add Value To Array
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)?
Array
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?
How Do Dim Array?
how do you dim a 3d (?) array?
somearray(x,y) ?
Populating An Array
I have two recordsets that I want to populate within an array.
The array will always have two columns, but the number of rows is unknown (sometimes 2 rows other times 200 rows). I'm not too familiar working with arrays.
I want populate the array using a loop. How would I define and populate the array within loop so that I don't lose values and each new set of values are populated into the array through each iteration of the loop? Code:
Getting Values From Array
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'
Cookie Array
Is there a way to store an array of information in a cookie? ie. a user can have a "x" long list of a variable stored in a cookie, so when they return to the site this information can be retrieved.
View Replies View RelatedArray Entering Into DB
I have two tables, one called tblManufacturers and one called tblModels. tblManufacturers is already populated but now I have to enter the following models which correspond to the ID of the manufacturer into the tblModels table. Any ideas of how I can do this. Code:
View Replies View Related