Moving to next recordset

347 100+

Hi everyone

i am trying to make a page that goes to the next recorset when i click on a button so the page only shows one record at a time, this is for updating so i need to be able to go to the next recodset from the page that updates the database also.

the code for the page that i have which lists all the records is as follows

Expand|Select|Wrap|Line Numbers

 <%@LANGUAGE=VBSCRIPT%>

<%voiceid=Request.Querystring("id")%>

<%

Response.Expires=0

Set YaketyConnection=Server.CreateObject("ADODB.Connection")

DatabaseDetails="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("database.mdb") & ";"

YaketyConnection.Open DatabaseDetails

YaketyQuery="SELECT * FROM mp3 INNER JOIN celebs ON mp3.celebid = celebs.idnumber WHERE mp3.celebid = "&voiceid&""

Set YaketyRecordset=YaketyConnection.execute(YaketyQuery)

%>
 
<HTML>

<HEAD>
 
<TITLE>Update Record</TITLE>
 
<SCRIPT language="javascript" src="admincheck.js"></SCRIPT>
 
<SCRIPT src="../../Scripts/AC_RunActiveContent.js" type="text/javascript"></SCRIPT>

</HEAD>

<BODY>

<BR>
 
<TABLE width="90%" border="1" align="center">

                        <%

Do Until(yaketyRecordset.EOF)

%>

<%

If Not yaketyRecordset.EOF Then %>

  <TR> 

    <TD valign="top">

      <FORM action="updateok.asp" method="post">

        <P align="center"><SPAN class="headertextCopy">UPDATE RECORD</SPAN><SPAN><BR>

          <BR>

          <FONT color="#FF0000">DO NOT USE ANY PUNCTATION</FONT></SPAN></P>

        <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" bordercolor="#CCFFFF" class="background">

          <TR>

            <TD class="admintext" align="right">filename</TD>

            <TD colspan="2" align="left" class="admintext"><INPUT name="filename" type="text" id="filename" value="<%=YaketyRecordset("filename")%>" size="100"></TD>

          </TR>

          <TR> 

            <TD class="admintext" width="25%" align="right"><P>&nbsp;</P>            </TD>

            <TD colspan="2" align="left" class="admintext"><SCRIPT type="text/javascript">

AC_FL_RunContent( 'data','../pages/player_mp3.swf','type','application/x-shockwave-flash','width','50','height','20','movie','../pages/player_mp3','bgcolor','#ef007b','flashvars','mp3=../search/<%=yaketyRecordset("surname")%>/<%=yaketyRecordset("filename")%>.mp3&showvolume=0&showslider=0&showstop=1&width=50&bgcolor1=ef007b&bgcolor2=ef007b&buttonovercolor=000000' ); //end AC code

                                    </SCRIPT>

                <NOSCRIPT>

                <OBJECT data="../pages/player_mp3.swf" type="application/x-shockwave-flash" width="50" height="20">

                  <PARAM name="movie" value="../pages/player_mp3.swf" />

                  <PARAM name="bgcolor" value="#ef007b" />

                  <PARAM name="FlashVars" value="mp3=../search/<%=yaketyRecordset("surname")%>/<%=yaketyRecordset("filename")%>.mp3&amp;showvolume=0&amp;showslider=0&amp;showstop=1&amp;width=50&amp;bgcolor1=ef007b&amp;bgcolor2=ef007b&amp;buttonovercolor=000000" />

                </OBJECT>

            </NOSCRIPT></TD>

          </TR>

          <TR> 

            <TD class="admintext" width="25%" align="right">search terms</TD>

            <TD class="admintext" width="25%" align="left"> 

              <TEXTAREA name="new_information" cols="100" rows="5"><%=YaketyRecordset("mp3type")%></TEXTAREA>            </TD>

          </TR>

        </TABLE>

        <DIV align="center"> 

        <INPUT name="id_number" type="text" value="<%=YaketyRecordset("idnumbermp3")%>">

        <BR>

          <INPUT type="submit" name="Submit" value="Submit">

          <INPUT type="button" name="reset" value="Reset">

        </DIV>

      </FORM>
 
    </TD>

  </TR>

<%  yaketyRecordset.MoveNext

End If

%>

                        <%

Loop
 
%>

</TABLE>

<BR>      <% 

YaketyRecordset.Close

YaketyConnection.Close

%>

</BODY>

Jul 23 '09 #1

Subscribe Post Reply

3858

GazMathias

228

Expert 128KB

Hi,

If your table has a unique incremented ID field you could simply track which record you are on via a session variable and simply call that ID + 1 in the query.

Obviously, the recordset would only include the one record.

Gaz

Jul 24 '09 #2

by: RT | last post by:

Hello; I'm trying to create a updates pages that I can move either to the previous record or the next record within a recordset without having to return to the repeating list of records after...

PHP

Access - crash when moving to next record...

by: hinrich | last post by:

Hello, I have a completely new system (windows xp prof.), office xp 2002 with sp 3. When I create a new and empty Accesss database, create an empty table and then create a new form using a...

Microsoft Access / VBA

Moving from one form to another and then back

by: scottallenmccullough | last post by:

I'm sure there is an easy solution for this problem. On "FORM A" is a combobox with a separate table as its record source. If the data required in the combobox is not one of the available choices...

Microsoft Access / VBA

moving next recordset

by: sexy_shot | last post by:

hello friends i am devloping an application using ms-access database. I want to move next on the recordset.Please send me solution with source code. i am in hurry please send as...

Visual Basic 4 / 5 / 6

Access and SQL Backend - moving to next record - HHHELLLPPP!

by: scsTiger | last post by:

I am using Access 2000 as the front end and MS SQL 2000 as the backend. I have a one record form that I set using something like: strSQL = "SELECT * FROM dbo_WBACCT WHERE...

Microsoft Access / VBA

Moving Data from one RS to another RS

by: maiami2 | last post by:

Hi Guys, I'm very new to access and I've been trying to get the hang of it over the last few days, but I've become very confused with various aspects of how to code it. Introduction: I am...

Microsoft Access / VBA

Moving listview to module help

by: Shaolin | last post by:

Hi guys I;m trying to move all my Listview content into a module because I have to call it several times and it becomes annoying having to type it a number of times. I'm a little stuck though....

Visual Basic 4 / 5 / 6

Calculate a Moving Average and Update Table

by: SuzK | last post by:

I am trying to calculate in VBA in Access 2002 a moving average and update a table with the calculations. Fields in my WeeklyData table are Week Ending (date) ItemNbr (double) Sales Dollars...

Microsoft Access / VBA

moving pairs

by: mcjason | last post by:

I saw something interesting about a grid pair puzzle problem that it looks like a machine when you find each that work out the way it does and say with all the others that work out the way they...

C / C++

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics