Nested Recordsets
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
ADVERTISEMENT
Nested Recordsets
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?
Repeated Recordsets (nested)
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:
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:
Nested Menu
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
Nested Subroutines
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 RelatedNested SHAPE
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.
Nested Loop
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 RelatedNested If Else Conditional Statament
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
^
Nested SQL SELECT Commands?
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:
Error Messages Nested
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.
Triple Nested Quotes
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?
Nested For Each Overload Array
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
Read Nested Nodes In XML File With ASP
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 RelatedPassing Value With Nested Repeating Region
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:
Nested Includes Not Working As Intended
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.
Too May Recordsets?
im building a page which has a few while loops. this means that im inevitably going to end up with about 20 recordsets on the page. will this slow the page down at all? its quite a lot of hits to the database/server. the results the recordsets will be returning wont be that big though.
View Replies View RelatedCan ADO Recordsets
My ASP code creates an ADO recordset object on the server.
Later on the same page, I have a javascript code snippet that I use to
dynamically populate a drop-down box based on choices made in another
drop-down box. Can this javascript (or a server-side equivalent)
Multiple Recordsets
Is there a way of using multiple recordsets with the same connection?
My recordset at the moment inserts data into the database, and i want to have a drop down box with data already within the database, as well as the insert recordset, is there a way of doing this?
Multiple Recordsets
Am having trouble opening multiple recordsets - keep getting the er:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/eft/postflight4.asp, line 146
Have checked the permissions and the user has full access.
Code:
Creating Sub-recordsets
How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn
Show Recordsets
I create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
Recordsets Vs. Arrays?
Is there a performance advantage to parsing thru a recordset verus using an array?
I'm currently trying to populate a listbox by returning data from my database, then either parsing thru the recordset until I reach the EOF, or putting the data into an array.
Sorting Recordsets
I 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:
Pagination Recordsets
Let's say you have pages 1 | 2 | 3 | 4 | 5 and you're on page 3. How do you make the code so that 3 will be without url?
View Replies View RelatedDestroying Recordsets
Assuming I had a recordset set up like this:
Set rs = Server.CreateObject("ADODB.Recordset")
is it enough to close out the code with
set rs=nothing
or is there a benefit to
rs.close
set rs=nothing ?
Using Multiple Recordsets?
im building a site for a clinic. they want to have a calendar which displays the times for each day that are available for appointments.
at the moment i have a calendar on my page. i want to display the correct times for each day. should i use one big recordset that gets all the times/dates from the db or cycle through each day and create a recordset for each day that there are times available (some days the clinic wont be open)?
if i go with the latter option, i could potentially have 30 recordsets open. is there a fast way to execute recordsets.
Sorting By Recordsets Value
I have a table that is just dumping an entire database data. I would like to have the values of the columns re-sort the data. Not the column heads for the data displayed under the column head varies.
For example, one column, Components, displays 80 components types and another column, Category, displays 40 categories types. When a visitor clicks on one of the component values, it should then display only that data. I've done this before but, it has been a very long time. I remember creating a link surrounding the recordset in my table but what was written.
How Do I Compare 2 Recordsets?
I have 2 recordsets. One contains all customer info data, the other recordset contains 1 field of customer id's.
How do I create a recordset that contains all customer information (from the 1st recordset)for only the customers in the customer id recordset (2nd recordset)?
Working With 2 Recordsets
I have two different query in my ASP page:
- the first is the list of all my users:
"SELECT DISTINCT lastname, id FROM table1"
- the second is the list of users that join a meeting:
"SELECT DISTINCT lastname, id FROM table1, table2 WHERE table2.codeMeeting = " & Request("code") & " AND table1.id = table2.id"
I want to show all the users in a table (with a FOR loop), with a checkbox that is checked if the users join the meeting (= if users is in the 2° recordset)
How can I do?
IF Statement Using Recordsets
I need the IF statement to check 2 recordsets.
If the first recordset has data within then write this to the asp page, If not and the second recordset has data in, then write this to the asp page, then finally if neither of the recordests contain data and are NULL to write 'No Records'
Closing Recordsets
I realize that sometimes you can use recordsets that were never opened (like when you're adding a record to a db) and I realize that you cannot close a recordset such as this.
But for the ones that ARE open, should they be closed first and then set to nothing?
Also,I'm trying to create code that checks if a recordset is open. If so, I wnat to close it. How would I do that?
JOIN Recordsets
Is it possible to INNER JOIN two recordsets in ASP?I don't mean the normal JOIN you would use with two tables, but actually join the recordsets in ASP?
View Replies View Related