Nested Loops
What I'm trying to do is match all buyer requirements in a database table to all available properties in another table. I then want all these matches displayed in a report with the buyer name followed by the relevant matching properties, this should occur until all buyers have been displayed with their matching properties.
The problem is that it only works correctly for the first buyer for which the correct properties are displayed, after that all I get is the buyer names without their matching properties... so it seems to loop perfectly the first time but from then on forgets about the inner loop! Code:
View Replies
ADVERTISEMENT
Attached is the code that I am trying to put together. Does anyone know how to loop (see bold text below) this so it will display all the data from the columns in this row? Code:
View Replies
View Related
I am not sure how exactly to put this, but what I need to do is the following: taking into account that there are multiple URL's pointing to the same server
If url=blah.com do nothing
if url=blah-blah.com *break out of frameset.
Now I remember there being an easy way to do this but can't for the life of me remember where to find it?
View Replies
View Related
i have 2 loops that give me 2 sets of 25 numbers. code:
do while not rs.eof
value = rs("value1")
rs.movenext
loop
do while not rs.eof
value = rs("value2")
rs.movenext
loop
i need to subtract value 1 from value 2 for each value in the loop?
View Replies
View Related
I was hoping someone would be able to explain the "For Each In Loop" set up.
What I'm really asking is when it can be used and how it is set up.
For example:
If I had something like...
Quote: For Each X in objSomeObject
Response.Write X & "<br /">
Next 'X
How do I know I can use the For Each In Loop and what must I do to be able to use the X portion of it?
Sorry if this is a very general question but I want to understand how one can recognise when it is possible to use this structure and when it's not.
More background to this is that I'm going to attempt to use this structure on a listbox in .NET and possible ASP and I want to ensure that I loop through each and every item.
View Replies
View Related
I want to find the next event in my sql database. To do this, I have a query in a while loop. I set a new DateTime variable to the current date and run the query, it checks to see if it found a suitable event, if not, I want to increase the day by one and loop again.
View Replies
View Related
What I have is a recordset listing out a group of names. I've retrieved the field that lists the id numbers for the array and split them to a list. Then I want it to loop through the names listing trying to highlight the ids that need to be hightlighted.
What I am getting is my list repeats the names according to how many ids are in the array. So if I have 2 numbers in the array I see every name on the list twice and the two that I need selected.
I want the list to show the names one time with the correct names selected. What is wrong with this code? Code:
View Replies
View Related
I have two 2-dimensional arrays (made by using GetRows()) What I need to do is:
Loop
If Arr1(0) = Arr2(0) then
do an update....
End if
End Loop
Basically I need to compare each value in Arr1(0) to the values in Arr2(0) - if I get a match, I have to do an update in the database. What is the easiest way to do this .
View Replies
View Related
there are various of loops but i am analyzing to use which one. maybe i could get some opinions from u all. there are
while wend, for loop, do loop
my situation is if i need 2 execute on a daily basis data on the particular month and will stop on the last day of the month.. without interseeing to the next month
can anyone might help me by suggesting on the suitable loop 2 use for this problem?
View Replies
View Related
I have some difficulty with deep inner loop. What I want is Eg
Product Category: Air-Cond
Company: ABC
Address: 121, Time City, Malaysia.
Company: XYZ
Address: 1, City, Malaysia.
Product Category: Fridge
Company: MAS
Address: 2, Old Building, Singapore.
Company: SAM
Address: 11 Kiosk, Malaysia.
Basically, the first the first loop is to get all product category and one by one insert into the second inner loop. But, I need another inner loop under the second one, which is to categorized by country. Code:
View Replies
View Related
I have successfully paged through a recordset on my page using the .recordCount, etc. methods, the only thing is I have 2 independent recordsets looping on the page, which when there was not paging involved this worked fine, however now I need to span the results of BOTH of these across pages, I just cannot seem to figure out how!
I have one set of records paging fine, but the other either messes the page up, or shows on the first page of results and no more of the other recordset, etc.... so yeah that is basically the problem I am hitting, so I was just wondering is there any examples or ways you could tell me to do this??
View Replies
View Related
My last (maybe) problem is to make a nested menu (I think is possible only with Java) and I must take the names of the selections from a DB ...
is possible? I can't find documents where is explained how to use MDB files with Java
View Replies
View Related
I have an array of items and for each item I need to find sizes and and for each size I need to find colors The array of items comes from the previous page. Code:
View Replies
View Related
I am using IIS 5.0, ASP and VBScript. I am puzzled by recurrences of errors when I nest subroutines, and I'd like to know if there are rules for that which I don't know. Would functions work better instead? I am not much of a coder.
View Replies
View Related
I'm using the following SHAPE command:
SHAPE {SELECT * FROM Chapters WHERE SchoolID=320}
APPEND ({SELECT * FROM ChapterLink}
RELATE ID TO ChapterID) AS Advisors
({SELECT FirstName, LastName FROM LocalAdvisors }
RELATE UserName TO UserName) AS AdvName
I get an error, "Column (UserName) does not exist in the appropriate rowset", which is correct, the UserName column actually exists in the ChapterLink table. But, I can't figure out how to construct this SHAPE command so that it works like that.
View Replies
View Related
I want to loop through a certain number of records in the recordset and then create a second loop for the remaining records. How do I capture the last record on the first loop to use in the second loop?
View Replies
View Related
I have taken over a program that uses a mixture of javascript and clasic ASP. However i am trying to get rid of the javascript and just use ASP.
However the code uses a nested recordset as the secpnd recordset needs a result from the first to run correctly. I have managed to change the code so that it goes through the first record but I can't get it to loop through the other recordsets. So it writes one results and then just a blanks.
Is it possible to use nested recordsets for more than one result? If not what are my options for fixing this problem?
View Replies
View Related
I am not too sure wats wrong w the if-else statement below!
<%if(grp==grp2)%>
{
<%if (start==req || end==req)%>
{
<%=grp%>
<%=start%>
<%=end%>
}
<%else%>
{
<%="There is no such record found"%>
}
}
<%else%>
{
<%="There is no such record found!"%>
}
<%endif%>
Error: 'else' without 'if'.
else
^
View Replies
View Related
I have an ASP page where I build a html table dynamically by reading a database table and populating the <TD> cells with the fields of each record.
I want the last field to be a html drop down list that contains values read from another db relation in the same db. It would seem to me, (i'm novice) that this would require nesting SQL SELECT Code:
View Replies
View Related
I am trying to produce a results page where the results come from three seperate tables.
e.g. The main query gets a list of results, for each one of those results I need to display data from another table. I have a list of bars, restaurants, hotels etc.
I want to display the details of those in sections (a bar section showing all the bars etc) each one of the bars is ranked by members. When I do this I get a "type mismatch" which I guess comes from the fact I am trying to equate an array to a single value. How do I get round this? Code:
View Replies
View Related
When an HTTP 500.100 occure in IIS 5.0, I was getting redirected to a HTTP 500.100 -'page cannot be displayed' error page when there was an error, but now in IIS 6.0, I get 'Microsoft VBScript runtime error '800a01c2' ' nested within the page.
I'm trying to create my own error messages so it will re-direct to my own error page and send me an email. I used to be able to do this in IIS 5.0 but I can't seem to get it going in IIS 6.0 as it doesn't re-direct to a default error message.how to get IIS 6.0 to work like IIS 5.0, or is there another way of doing it, or is this not even an IIS problem.
View Replies
View Related
Can someone tell me how to write this line so I don't get an error - I've tried various ways to nest the quotes,but I still get an error saying that an ")" is expected.
Code:
response.write("document.write('<form method="post" action="message_send.asp?subject=" & _
Request.QueryString("subject") & "" onsubmit="return preValidate(this);">);")
Is there any other way to feed the result of an ASP function into Javascript other than by getting ASP to write out the JS as above?
View Replies
View Related
I would like to know what I'am doing wrong with this loop & Array's... Keeps over oading but unsure why... Would anyone know why and know a sollution?
ERROR:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: '6'
CODE:
For Each i in TArrSpl
For Each e in TId_Arr
IF TId_Arr(e) = TArrSpl(i) THEN
' CODE
ELSE
' CODE
END IF
Next
Next
View Replies
View Related
I have to read a XML file in ASP and save the values in a database. I can get this work, but I cannot read some nested nodes of the xml file. This is a part of the XML file: Code:
View Replies
View Related
I am passing values from Supplier_Details.asp to Supplier_Products.asp, when I click to view the details of the supplier I want, their values goe to the other page ( supplier_product)that I want all his products to be displayed.
so far I can pass values and could be displayed, no problem but when it comes to displaying all the products, it;s then where I am stuck, with the previous tutorials ( nested repeat region) I can get it working and I tried to have that example working for all this, so far it;s not, so is it possible to do it ? Code:
View Replies
View Related
I'm working on a new site that has a nearly empty index file (variable
location) that includes a template file (set location) which in turn
includes two data files (variable location dependent on index file's
location). This concept worked in PHP and I'm just playing around with it
in ASP to see if it can make my site management easier because I can't move
to Apache for a while.
It seems that the template file can only include relative to itself and also
with specific paths, but it can't include relative to the original index
file.
View Replies
View Related
