I needed to print the values of a multidim array. I know it can be done by saying <%=array(i,j)%>. But my array is three dimensional and doesn't print any values if i say <%=array(i,j,k)%>. This array was declared as Dim vretdata and what it does it retrieves data from the database through a function. Code:
View RepliesI needed to print the values of a multidim array. I know it can be done by saying <%=array(i,j)%>. But my array is three dimensional and doesn't print any values if i say <%=array(i,j,k)%>. This array was declared as Dim vretdata and what it does it retrieves data from the database through a function. Code:
View Replies View Relatedwhat 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..
I want to save the details of a SQL search into an Array, Im dabbling and tryin the script below but i get an error Script:
SQL = "select item, number from table"
Set rsTarg = Conn.Execute(SQL)
i = 0
Dim TargArray()
Redim TargArray(i, 1)
do until rsTarg.eof
TargArray(i, 0) = rsTarg("item")
TargArray(i, 1) = rsTarg("number")
i = i + 1
Redim Preserve TargArray(i, 1)
rsTarg.movenext
loop
rsTarg.close
i = i -1
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?
I am trying to develop a shopping cart using a dictionary object to represent the shopping basket. I have a products page which displays all the products for the user to click on to add products to the basket. This works fine.
The problem I am having is when I want to display the content of the shopping cart. The dictionary object can only contain the product id / quantity, so I have written a function which uses the product ID to retrieve the product details from the database.
Whilst I can output the values in the function which retrieves the data from table into the array, I can't output the values in the procedure which receives the array. 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 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.
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:
I released to open source a while back but forgot to post in here a DLL that was used in some of our older developments. It's not really a live project, but may be of use to peeps in here given some of the recent queries:Quote:
DBSite: Written in Visual Basic this DLL helps solve issues for ASP web developers, e.g. handling uploads, safe parameter population for stored procedures (sql injection checks), SQL XML calls, file system browsing, etc.
I was trying:
Code:
<!--#include file="lang/<%= Request.QueryString("lang") %>.asp"-->
But it doesn’t work.
How can i create a multi tab page in asp.net 2.0?
create a frame and a number of page with hyperlink?
Would i have some directives?
How can I update/delete a record which is linked to another table with a
unique field. I know the select inner join, but no update/delete.
Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.
View Replies View RelatedI need to create in asp/access/javascript a questionnaire that shows a single question on each page of which there are five then after the last question create a new record in the access db and write the answers.
View Replies View Relatedlets say we have a ms db with two cols
id value
1 4
2 7
3 9
4 1
is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.
I have written a asp application whihc uses a number of pages and each page connects to a sql database.
Currently I have the connection script coded on each page however if i need to change the database I have to change every page.
I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page
As part of the development of a shopping basket function, I've a two dimensional aray which I'm storing in the session variable.
I want the array to be dynamic to store any amount of products which may added.
I am getting a problem when trying to write to the second row to the array, saying that the subscript is out of range...
You can see an example of this at:
http://www.foulkestudios.com/session.asp
I am getting what should be the first empty row by getting rows=UBound(myArray,2)
I'm then trying to add into the next row by using rows + 1
I am b-testing a community site, with currently 1,000 or so membership,
and low concurrency, say no more than 5 on-line at once.
The site is hosted on a shared server, which is sufferening from
intermittent accute slowness, affecting all other hosted sites as well as
mine.
The finger of suspicion is pointing at me and possible sloppy code. As
this is the first site I have done of this nature, could someone recommend
reading matter (knowledge bases etc), especially coding samples, in
connection with data connections (opening and closing connections and
objects) and record locking issues, which if improperly coded, could
contribute to throughput bottlenecks due to inefficient use of resources so
that I can check out my pages and correct any nasties..
I am think to write a code that will need more then 2 servers.
Can anyone give me some information to do code like that?
Like yahoo, google, msn.
I need to develop an application that will span 12 or so pages, and on the
last page, it lets the user review the data and then insert it all. This is
kind of like selling something on eBay, you give it information, click next,
enter more info and then at the end you review and submit the item. I was
thinking about sessions, but some of the fields are pretty big, like
varchar(5000) so I didn't know if there was a way to handle these big
fields.
I am in the process of developing several web sites that will accommodate up to 3 or 4 languages. The sites are not that complex, but will use an Access database for some data presentation/storage. Each page will have a series of flags for respective languages. Ideally, if someone enters on a "gateway" page for say Gallery, and they choose another language, I would like the same page to display but in a different language (there might be a page for each language, but if I can avoid that I'd rather).
So here are my thoughts on how to approach this. Have a session var for language preference and set it in a Global.asa file. I would think it could be set dependant on the origin of the request, .de, .co.uk, .it, etc. Then, if the code is not too verbose, use Case statements in the code to display content based on language preference. One thing of a bit challenging for me is that if the "flags" are in an include file, how can I get them to when clicked go to a script, change the session variable and return to the page from which it was clicked. Am I on the right track with this approach.
I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc.
How do I go about actually filtering the database to only produce 10 results per page? I was trying to use:
results.Move 10
and things like that, but I'm not sure of the best way around this.
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?
View Replies View RelatedI was wondering if anyone had any links to some resources / tutorials or could offer up some help with regards to my current project.
The concept is pretty simple. Multiple user login - which are then presented with a page where they need to answer some questions (drop-down responses). These responses are then checked against the answers and the points are then added and the results list the different users in descending order.
Help and suggestions with any part of this would be greatly appreciated!
I know this will be linked to a database (open to suggestions about which to use) and then how to structure my tables.
Will the Request.form show the correct order that they were displyed in or
will it do something different. I have been testing and it always shows the
order they were displayed.Is this just coincidental?
Simple question no doubt -
I am trying to send an email to a form variable as well as a list of addresses, but I can't seem to get it to work. Please help.
I want to combine these two lines - what is the syntax?
Code:
MyCDONTSMail.To= "xxxxxxx@nzl.xerox.com"
Code:
MyCDONTSMail.To= creat_email
They work individually (I have declared creat_email).
I have two multi-select boxes...selLeft and selRight. The user moves choices from selLeft to selRight with arrow buttons. selLeft is populated using XML.
My question is, when clearing everything on the screen, how do I repopulate selLeft, without losing items in selRight or repeating items left in selLeft.
I'm a newbie and not familiar with the code used to build the multi select box in the first place. Code:
How would you go about inserting data from two forms into one record? using access/javascript
View Replies View RelatedIam working on a search that needs to fetch words from other languages for any given word entered in english. I use an access database to store the english words and its equalent words in other languages. For example:
When i search for chinese equalent of Invoice (or any other word), the retrieved result is?.
I am currently creating a multi-language site using ASP .NET and was wondering what people think the best way to do this. Keeping a session variable of the users's choice? Cookies?
View Replies View RelatedI have a table (Software Table) in a database that is linked with a many to one relation to another table (Computer Table). I wrote a simple ASP page to return the records for the software table which shares a one to many realtion with the Computer Table.
One (Software Table) to Many (Computer Table)
At persent the only records that are returned are the ones from the software table. Is there some way to return or display the many computers (one to many) for each record.I cant think how to start to do this. Can I link to computer table and have a drop down that lists the many computers?a better way to display this information?
how I can make a dhtml menu into a dynamic menu that pulls its links from an access database instead of the hardcoded html.
I would like to know because I'm working on a site that needs such a menu and most of my administrators using my site don't understand html and won't be able to update the menu unless I can give them a simple form that allows them to add links.