Various Basic Questions Regarding Two-dimensional Arrays
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
ADVERTISEMENT
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 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
ASP And Visual Basic Interview questions and answers
I have listed over 100 ASP and Visual Basic interview questions and
answers
in my website
http://www.geocities.com/myintervie...VisualBasic.htm
So please have a look and make use of it.
View Replies
View Related
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
View Related
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
Q1. How do I send 2 dates to a stored query in access. What I have in the
query so far is
Select * from tblOrders where Date_Archived between #3/01/04# and #3/31/04#
What I want is to send to variables to this query that the user inputs.
Q2. I know that this is probably not the right group but I am trying to
trim a string (first name to 1 letter) in an SQL statement.
Does any one know how to do this? I do not want to use ASP as I will be
build a complete CSV file on the file (column names and data)
View Replies
View Related
I never used any ASP or ASP.NET and i want to know if this is something worth learning.
I am about to start learning PHP (i know PHP a litle bit already) but will it be better to learn ASP.NET instead?
How does ASP.NET compares to PHP? I know that PHP is free, what about ASP.NET? Which is easier to learn/implement? Which is faster? Which is more powerful? What are the strong/weak points of each?
View Replies
View Related
i hope no one is getting sick of my server.execute/transfer questions..
does server.execute return a value? im wondering what happens if an error
occurs in the .asp file that i'm calling with the server.execute command??
is there a value/flag i can set in the case of an error that can be seen
once i return to the calling page? if not i was thinking that i would have
to use a session variable for my error handling.
i want to stay true to the model, view, control architecture so i don't want
to simply redirect in the case of an error - i want to send a value back to
my control page which will decide where to go.
View Replies
View Related
First, how can I get asp to create a table in en existing DB that is an atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58 as the name. Along with this, I need to copy the fields from table temp, into the above DB. Can this be done?
View Replies
View Related
I was reading up on sessions, and on websites they don't mention "passing" session varables. But the guys on this form are asking questions about passing session variables. So what is it? Can you or can you not pass variables? I don't think you can pass session variables, since they are just cookies.
Second, does the session expire when the brower closes? I know it expires with Session.Abandon or it times out.
For my project I need to the user to login and do his/her stuff. The session should expire by timeout, or logout link (Session.Abandon) and when they close the browser. My guess is that when the browser window closes the session expires. I just need to make sure about those two things.
View Replies
View Related
I am trying to create a hashtable in ASP. I need this to be on the application level,
i.e. each page from different users calls the same table. I figured the best way to
do this is through a recordset.
I need it super fast so I want it loaded into memory (RAM) and be altered in memory. What is the best way to do this? I found all these different connection types, but nothing seems to fit this purpose.
View Replies
View Related
I have questions relating to TabView and Tabbed Navigation.
Currently, this is what I have
[code]<DIV id="divTabs" style="LEFT: 5%; WIDTH: 450px; POSITION: absolute; TOP: 10%; HEIGHT: 10px">
<%=strTabs%>
</DIV>
[code]
That displays the tabs...but heres my quesiton
Now what I would like to be able to do, is throw those tabs on the bottom of the page. Is this possible? How do I go about doing this? Could someone supply me with the changes in code I need to make?
View Replies
View Related
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
When using such objects as the one above, where is dbConn actually comming from?
How do I store session variables using the session("") in the code below? Everytime I try doing it, I get an error page.
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
<object RUNAT="Server" ID="spEssRtd_loginValidate" PROGID="adodb.command"></object>
<%@ LANGUAGE=vbscript enablesessionstate=false %> ......
View Replies
View Related
i have a scenario where i have to serve users of my site questions on daily basis,but before they can answer a question they must answer a previous question correctly served previously before the current day .
This means to me that i have to keep a log of each questions served each day and users response whether they attempt the questions or not .i am scared to keep a scenario of a million users each day,their actions on a particular questions.what is the smartest way to achieve this.
View Replies
View Related
A week or so ago, I needed to find the HTTP_REFERER environment
variable to check and see if a user is coming from a certain website:
If Request.ServerVariables("HTTP_REFERER")_
= "http://localhost/mydir/page1.aspx" then
response.write "Click on a menu choice"
else
response.write "check back later
end if
I have a page nested in an IFRAME (for example framepage1.aspx or
..asp), and I need to check to see if a user is coming to (not coming
from ) a certain page where the framepage1.aspx is (the
framepage1.aspx could appear in not only page1.aspx, but page2.aspx ,
or page3). I'm not sure how to accomplish this given that the
HTTP_REFERER checks on address only incoming.
View Replies
View Related
I have seen sites that have asp searches and have a textbox and a search button and when the search button is clicked a search results field is displayed on the same page. Im having problems grasping how this works.
I am assuming that it states that if search is clicked then display the search results field. But how does it do this? Does the entire page reload? Is it a table that have attributes set to invisible then are change to visible? Anyone with an example or that can point me in the right direction please let me know.
View Replies
View Related
A week or so ago, I needed to find the HTTP_REFERER environment
variable to check and see if a user is coming from a certain website:
If Request.ServerVariables("HTTP_REFERER")_
= "http://localhost/mydir/page1.aspx" then
response.write "Click on a menu choice"
else
response.write "check back later
end if
I have a page nested in an IFRAME (for example framepage1.aspx or ..asp), and I need to check to see if a user is coming to (not coming from ) a certain page where the framepage1.aspx is (the framepage1.aspx could appear in not only page1.aspx, but page2.aspx , or page3). I'm not sure how to accomplish this given that the HTTP_REFERER checks on address only incoming.
View Replies
View Related
I am designing a Web site with about 500 - 600 pages of festivals on it and would like opinions on two ASP subjects. I have designed about 20 pages or so as of now. These are the contact us, FAQ, about us pages and such. I also have a template to go by for each festival's page. But I have two problems I need fixed before I start to replicate.
(1) SSI and styles - There are four sections to each page. I use SSI (ASP virtual version) for the top, bottom and a small section of featured festivals (which is above the bottom) on each page. Between the top and featured festivals is the actual page. This way I can change a link on the top or bottom and it is fixed on all pages.
But, I have an enormous amount of styles listed (all styles on four pages) in the code from each page's fonts. Each page's styles are called something different. For example, the festival page itself has the styles as normal, ".style1." But the styles on the top the links, which once again is an ASP include, would be called ".style1top." I used that approach because .style1 on the festival page and top links could be different.
It works, but I have dirty code and I want the site to be as Google friendly as possible. I have thought about adding all the styles to a page and using it as an ASP include on all pages, but that would have way too many styles each page and be even dirtier. What is the best practice for this? Code:
View Replies
View Related
I keep reading that Session variables are evil things to be avoided. Is it
really that awful to use them? If you shouldn't use them, then what is the
preferred alternate method for accessing data across an entire solution?
Would it really be so bad to set something as simple as Session("login") =
true Session(user)=username when a user logs in and just read those
variables on an include for every page to display the user name?
Is it true that a user has to allow cookies in order for a session variable
to be used? I thought the point of session variables was to set things on
the server side so that you didn't have to worry about cookies being allowed
by the user?
What is the generally preferred method of storing a shopping cart?
Database, cookies or server variables? All I need to save is the product #
and quantity. Would it be evil to store that in a dictionary object or a
collection? My profs at the college said cookies were the way to go. My
co-workers say use a database. My mentor says use a dictionary object.
View Replies
View Related
an idea of the type of ASP questions asked in an interview?
View Replies
View Related
I've made an access script user based for a forum, so, I'm not sure what to store in the cookie. I think to store just the user_id (the one in the users table referred to the logged user) but is this way sure ? is anyway to hack it simple ? I know that nothing is 100% secured, but not too simple to hack.
Have I to store other informations like session id or something other ?
Another question is for the login form... Somebody checks if the session.id of the user is the same between the page containing the login form and the page that checks informations... but is this really useful ? infact is an user stops on the first page (the one where is the login form too) reading something until the session goes to timeout then the check session fails...
View Replies
View Related
I have a voting system that works perfect. It calculates the % of votes and shows the total percentage that people picked 1st, 2nd, and 3rd, and a total.
However, I want to be able to select the top 3 of those, and highlight the row, using a bgColor variable that I have defined. The problem with this is that I am calculating the %'s as I am writing the rows, and do not know how to check to see if that row is one of the top 3.
Here is my code:
View Replies
View Related
I've got an application setup that uses freightquote.com API to receive XML responses containing shipping information. A basic response example is as follows: Code:
View Replies
View Related
I normally work with MS Access databases using ASP pages. I have been
given the opprotunity to work on some available SQL server space, and
wanted to ask a couple of questions. The following is a simple update
query that I use. It is an ASP page that connects to an MS Access Db:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN = myDSN & "DBQ=xxxxxxxxxxxxxxxdatabase003.mdb"
mySQL="UPDATE SKUList SET SKUList.Department='Furniture' WHERE
SKU='123456'"
Conn.Open(myDSN)
Conn.Execute(mySQL)
Conn.Close
Set Conn = Nothing
%>
I was wondering if someone could tell me (or better yet show me) how
this code would look in a SQL server enviroment. I have no information
on the server itself as the database will be setup for me, and I will
just need to create ASP pages to connect.
View Replies
View Related
I am developing a system for a certain use and now all the major programming is done. The next step is to include error checking for all the forms (there are 9 pages with forms to add data and 7 for editing, so total 16 forms)
I just started with the most simplest and I was wondering if anyone had a good suggestion on how to validate Dates?
I was also wondering if its possible for example to write a data validation script which I can use for all pages, because like one page has 90% date fields.
If so, how can I accomplish that? Won't I need to pass the name of the text fields in some way too?
Is it possible to do that for other similar fields too, like first name, last name, phone number?
Oh yeah, the way the entering of dates works is that there are three separate text boxes, for Month, Day and Year. So a case date is divided into, case_mm, case_dd and case_yyyy.
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
