Recordset Inside A Loop
Is it common practice to create a recordset object inside of a loop? Does it create multiple connections to the database?
View Replies
ADVERTISEMENT
For Loop Inside Do While
is it possible to do a for loop inside of a Do while not.
View Replies View RelatedDb Search Inside A Loop
There are two table in my Access database e.g. people and orders. There is a one-to-many relationship between these. At the moment I get a recordset of all the people. I put the results of this into an array (using GetRows) and close the array and set it to Nothing.
Then on the page I have a loop which goes through the array of people and for each one performs a different db search of all the order linked to that person. On the page I have got it displaying the people perfectly but for each search the RecordCount is coming out as -1. Yet, I know there are orders associated with each person.
Passing Values Into Text Box Inside The FOR LOOP
I am trying to pass a value into the text field on selecting the option in a drop down. The code works if the 'For' loop is not included. What should I do to make it work inside the loop? Code:
View Replies View RelatedUse Variable Inside A Recordset
Having an issue trying to access a variable that is populated by a value inside a recordset that I want to use in another statement. I've included the source code below:
" Do While Not objRSZone.EOF
strSuburb = objRSZone("suburb")
strZone = objRSZone("zone")
strPostCode = objRSZone("postcode")
If frmSuburb = strSuburb Then
Response.Write "Zone for " & strSuburb & " = " & strZone & " , Postcode = " & strPostCode & "<br>"
strShipZone = strZone
Response.Write strShipZone
End If
objRSZone.MoveNext
Loop "
So what I want is to use the strShipZone variable somewhere other than this place above. But it doesnt work, as it is on the loop, if i put it outside the loop it is populated by a wrong value.
Recordset Controlled By Another Recordset Within A Loop
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
Loop Through Recordset
Is it possible to loop through recordsets using javascript? If possible, can show me an example.
View Replies View RelatedRecordset Loop
Given a page with 12 thumbnails numbered one through 12 I am trying to figure out how I can let a user click on any of the twelve thumbnails and be taken to page that has a forward and backward arrow so they can go through the other images in order.
So if someone clicks on the 7th image the next page shows that image enlarged with a foward arrow taking them to image 8 or a reverse arrow taking them to image 6. When the controls get to image 1 (or image 12) the navigation adjusts to just keep going through the images.
Loop Through Recordset
I have a recordset and an array which i get from a form submission. I want to loop through all recordsets and compare one by one with the values I get from the array. Is it possible to give me the general construction because I am stuck?
View Replies View RelatedFor Loop Through Recordset
I currently use Do while loop, but I'd rather use a For Loop though I have never gotten the hang of them. Would some one please be so kind as to show me how to loop through a
recordset.
Speeding Up Recordset Loop
I've got this code that loops through a recordset and prints the whole thing out in an html table. Sometimes it takes 30 seconds to a minute to display a little over 2000 records (like 25 columns). My boss feels that it needs to be faster even though another internal reporting system that works similarly takes far longer than mine.
I've ruled out the database execution. I have code that prints out after it finishes going to the database. It shows up almost immediately.
I set up a javascript timer that says the entire execution, including the database, is taking around 1.5 seconds every time.e.
Loop Through A Recordset And Send Emails
I need to send an .ASP page as an email template using VBScript. I'd like to do so using CDONTS or CDOSYS. the script needs to loop through a recordset and send emails using data from SQL 2000.
when i try to send using a script i built the asp page pulls in without rendering the asp. how can i pull the rendered asp into my vb for emailing?
Create Recordset, Loop, Update Second Table
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
Parameter Not Passed From For Loop To While Loop
I'm trying to pass a parameter from a for loop to the nested while loop
but only the first counter is passed. Here is the code:
Nesting One Loop Within Another, Using 1st Loop As Criteria For 2nd
I have a recordset that I loop through all of the data within a table, within the same loop, I am trying to add another loops that pulls information from the first recordset to base the second recordset off of: Code:
View Replies View RelatedError Type: ADODB.Recordset (0x800A0BADODB.Recordset (0x800A0BCD)
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
VBA Code Inside ASP
I have a front end with all the code and a backend with some tables. Want to convert this into website database. Most probably convert the frontend into ASP. Is this the only way? Can one use the VBA code inside ASP with translating the VBA into ASP?
View Replies View RelatedDo Inside An If-statement?
I need to do a loop with some criterias that depends on an earlier database
query. I tried to do it this way, but it seems not to accept that the do
is inside the if:
if not objrs.EOF then
Do until updatearray(0) < objrs("updated")
else
Do While not fso.AtEndOfStream
end if
Blabla my repeating script here...
Loop
I'm getting this error:
Microsoft VBScript compilation error '800a03fb'
Expected 'Loop'
/x.asp, line 46
else
^
It seems somehow that the do is "stronger" than the if statement, as it didn't
even help doing it this way: Code:
Using ASP Inside An ASP.NET Page
I've inherited webmaster duties for a website done in ASP.NET. After much trial and error I've figured out the architecture of the site, and have a template for the area of the page that contains the content. I need to pop in a dropdown menu, nothing fancy, like the one on this Post New Thread page for "Category".
Does anyone know where I can get the syntax for one? Or does someone know ASP.NET and can write out a simple dropdown menu code for me?
100% Height Of A Div Inside A TD
I've put a div red with some text inside a TD, but its height is less than 100% of TD height as you can see.
I've defined the following styles:
div.test { background-color:red; height:100%; width: 100%; }
table.test { border: 1px solid #CCCCCC; background-color:yellow; }
td.test { border: 1px solid #CCCCCC; }
does anyone know a solution ? Code:
HTML Can Be Inside ASP, Can PHP
I see that you can have HTML code inside an asp file.
Can you have php code inside an asp file
ASP.Net Inside ASP Code
I need to make a search to search our database that can be put on different customers websites. So I was planning on making the search a reusable asp.net control. But a lot of our customers websites are written is ASP. So Is it possible to call an asp.net control inside an asp page?
View Replies View RelatedIframe Inside A Form
I have a form which consists of Iframe
<Form method="pst" action="test.asp">
<iframe src="testingframe.asp" id="testfram" frameborder="1"
scroll="auto">
</iframe>
</Form>
testingframe.asp has
<table>
<td>
<tr>
<input type=checkbox id="checkedName" name="checkedName"/>
</tr>
</td>
</table>
How do i acess checkedName value in my main form .... ?
ASP Inside Javascript Function
is it possible to put an ASP function inside the javascript function?
e.g.
<script language=javascript>
function sample()
{
<%
here goes the asp code
%>
}
</script>
Website Inside Frame
We need to display certain websites inside a frame on our website and I use the response.redirect command in VBScript.
The problem is that some websites take over the whole browser, how can I stop this and force a website to be loaded inside a frame?
Getting Text Inside A String
Could anyone tell me how to select the first three characters in a string, then put inside into another string.
View Replies View RelatedSearch Inside A PDF Document
I need to write a search function which should be able to search text within PDF documents and (if possible) creat a link to that document / page .
View Replies View RelatedMessage Box Inside Page
How can I send messages to user like messageBox from a ASP page without doing postback over the page.
View Replies View RelatedPut Code Inside HTML Tag
How do you put an asp code inside an html tag?
This is not working:
<a href="contact.asp?subject=Question about group
<%=(Recordset1.Fields.Item("group_name").Value)%>">Send a message</a>
I am actually putting above info in an Access field. People would be able to send me email through a form in contact.asp and I want the subject line reflect which page they came from.
Input Inside A Asp Page.
Was thinking of having an array inside a asp page. I'm rather new to this.How do I begin. my asp page should work as follows.One html page include mail adresses. We receive a lot of junk mail and I was thinking of how to avoid this. Was thinking of creating a asp page with an inout string inside the asp page. The input number should refer to the users mail adress.
We are only four people in our office, so that should be simple to manage.The html code should be like "redirect.asp?" for the first mail adress. and redirect.asp?What's the syntax inside the asp page?
Validation Inside Classes
I'm currently new to OO programming with Classic ASP and have been stopped dead in my tracks on the issue of validation inside classes and if I should be doing things that way. I have been using a User class and it has methods such as Save(), Update() and Delete(). Particularly with the Update() method I'm unsure if I should be validating my form(s) within the class or on the actual edit.asp page that uses the Update() method?
I have two types of edit pages; one for Admin users and one for the My Account page. On the My Account page if the user wants to change their password they have to enter their current password, a new password and then their new password again to confirm .
If an Admin user is updating that same user's info they do not have to go through those steps and they can simple just change the password by typing it in. The point here is that there are two separate cases of validation rules on two separate pages that both use the Update() method. Do you validate your forms inside your classes or outside?
Put A Semicolon Inside A String
how I can get a semicolon inside a string? So far, when I've tried to put a semicolon inside a string, I've gotten this error:
Quote: /Default.asp, line 39
Response.Write("<h4 class=""news_headline""><a href=""news.asp?fileindex=" & arrayLine(i) & ""&;mon=" & lCase(Left(MonthName(month(date)), 3)) & year(date) & """>")
CheckBox Inside A Repeater
I'm still learning .Net and have an ASP.Net app that I'm working on. On this particular page, I need to put a bunch of checkboxes on the side of the page, and the text for each is derived from the database. So I can't just hardcode the checkboxes. I'll have any number of them, and possibly even 0.
I am told that you use a Repeater control for this, but beyond that, am not sure what to do. Can someone show me?