Flash Displays the Data

Flash 'n' ASP Guest-Book Displays the first record

  Flash 'n' ASP Guest-Book navigates through the records

1. Activate the navigation buttons: Double click each button to write the action scripts given below in their actions tab.

• Reset button: To display the first entry displayed again.
       Set Variable: "x" = lower_bound
        Set Variable: "y" = count
        Set Variable: "startN" = eval("name" & x)
        Set Variable: "startE" = eval("email" & x)
        Set Variable: "startM" = eval("mess" & x)
        Set Variable: "startD" = eval("date" & x)
        Set Property ("/LoadNext", Visibility) = False
  Logic: This assigns the record count variable 'x' the index of the first record displayed (this changes from 1 to 0 if the user has submitted a guestbook entry). The current record variable 'y' gets the value count because we are going to display the top most record. The display variables are assigned the new data and the Load Next Batch movie clip instance called 'LoadNext' is made invisible.
  
  
• Previous button: To display the entry displayed before the current one.
       If (x > lower_bound)
              Set Variable: "x" = x - 1
              Set Variable: "y" = y+1
              Set Variable: "startN" = eval("name" & x)
              Set Variable: "startE" = eval("email" & x)
              Set Variable: "startM" = eval("mess" & x)
              Set Variable: "startD" = eval("date" & x)
              Set Property ("/LoadNext", Visibility) = False
        End If
  Logic: This decreases the record count variable 'x' by 1 and increases the current record variable 'y' by 1 because we are going to display the entry that was filled after the currently displayed record. This operation is carried out only if the value of x is greater than the lower_bound variable. The display variables are assigned the new data and the Load Next Batch movie clip instance called 'LoadNext' is made invisible because when we move previous it can never be required to be visible.



• Next button: To display the next entry.
       If (x <= upper_bound)
              Set Variable: "x" = x + 1
              Set Variable: "y" = y-1
              Set Variable: "startN" = eval("name" & x)
              Set Variable: "startE" = eval("email" & x)
              Set Variable: "startM" = eval("mess" & x)
              Set Variable: "startD" = eval("date" & x)
              If (x=upper_bound AND NoLoad=False)
                    Set Property ("/LoadNext", Visibility) = True
              End If
        End If
  Logic: This increases the record count variable 'x' by 1 and decreases the current record variable 'y' by 1 because we are going to display the entry that was filled before the currently displayed record. This operation is carried out only if the value of x is less than or equal to the upper_bound variable. The display variables are assigned the new data. The Load Next Batch movie clip instance called 'LoadNext' is made visible only if x is equal to the upper bound and the variable 'NoLoad' (which indicates whether there is another batch of data in the recordset) is equal to false.
  
  
• Load Next batch of Entries button: This button if you would recall is placed inside the 'LoadNextBatch' movie clip. Open the movie clip and double clicking the button place the following action script in its actions tab:
       Set Variable: "/:loadNo" = /:loadNo+1
        Set Variable: "/:load" = True
        Begin Tell Target ("/")
              Go to and Play ("Load")
        End Tell Target
  Logic: This increases the batch number variable 'loadNo' by 1. Assigns the preloader variable 'load' the value True and tells flash to play the 'Load' frame as the next batch of data gets loaded (you will learn more about this in the preloader page).

Flash 'n' ASP Guest-Book : Action scripting of all remaining buttons

1. Activating the other buttons in the forms: To complete the guest-book we need to link up the input form to the display form and provide a means to exit the guest-book. Double click each button to write (or cut and paste) the action scripts given below.

• New Entry button: To go to the Input Form if the form hasn't been submitted previously and set the defaults.
        If (submit=False)
              Set Variable: "name" = ""
              Set Variable: "email" = ""
              Set Variable: "mess" = ""
              Play
        End If
  Logic: If the user has not written in the guestbook then the defaults for the fields in the input form are set and the form is displayed else the button is inactive. The variable iSuccess as you may recall was used by the submit counter to check if the data from the input form has been inserted into the database.
  
  
• Exit button: To display the recent most entry.
       Get URL ("closewindow.htm")
  Logic: This button just calls the closewindow.htm page that closes the window in which the guestbook is displayed.

2. Activating other buttons in the GuestBook:

• Exit Buttons: Double click the exit buttons in the 'Success' and 'Failed' frames and give the same action script given above for the exit button.
  
  
• Return Buttons:
  • Double click the return button in the 'Success' frame and give the following action script:
    Go to and Stop ("Main")
  • Double click the return button in the 'Failed' frame and give the following action script:
    Go to and Stop ("NewEntry")