Navigating Between Detail Records

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Navigating Between Detail Records

    Does anyone know of a way that I can navigate records from a search query from
    a details window? Let me explain. I have a search utility where the user can
    search by date range, program name, region code, etc. Say for example they
    search for all records with a Region code of 'Q', and it returns 45 records. A
    'high-level' information list is displayed, displaying the program name, date,
    and region code. However, each record contains numerous other fields that can
    be viewed by clicking the link to a specific record, and launching a popup
    window with the details. If the user wants to view the details for more than
    that one record--the first ten records, for instance--they have to close the
    detail window and click on the next link in the high-level information list to
    launch its respective details. The database has a key of an autonumbered
    field, and the search criteria may be limited, therefore the records may not be
    retrieved in sequential order for that field. Is there a way for me to make a
    '<< Previous Record' link and a '>> Next Record' link in the detail window to
    allow the user to navigate the query results without having to close the window
    and individually select each search result? The navigation I am looking for is
    similar to the way Access navigates between records in its form-based view.
    Please help!! Thanks for your time and help!!!

    Unamailer Guest

  2. Similar Questions and Discussions

    1. Can I delete from the detail of a master/detail datagrid?
      Hi Mark, As for the delte certain items in the detailed grid items in MASTER/DETAIL grids. Here are my suggestions; The DataGrid, DataList or...
    2. navigating through records
      Using asp/ado/IE: Let say I have a recordset contianing 1000 records. I don't want to show *all* 1000 records in one long table on a page so how do...
    3. Navigating through records in a subform
      I am trying to add some record navigation buttons using a command button. For example, in the command button wizard, i choose the "go to next...
    4. Navigating records in web form
      Dear Sir I biging in asp.net and i want desine a data entry form with single record at time. i need navigate records but i dont now. Plese help...
    5. Restricting detail records in a portal
      I have a typical order/order detail pair of tables. The main order table has fields like client, date, and other fields that pertain to the entire...
  3. #2

    Default Re: Navigating Between Detail Records

    Javacript in your popup window can access CF data from the parent window.
    Therefore, one solution is to store the ID's of the query results (or whatever
    you use to specify the record to 'drill down') in a CF variable on your parent
    page. Then in your popup window, you can use javascript to access that CF
    variable. I know I'm kind of vague, so if that's not clear enough, just let me
    know. - Shawn

    shawnwindler Guest

  4. #3

    Default Re: Navigating Between Detail Records

    Shawn:

    Thanks for the response. However, I am not 100% clear on what you are saying.
    Should I use an array or something to load all of the program names from the
    search results?

    Thanks for taking the time to respond.

    Unamailer Guest

  5. #4

    Default Re: Navigating Between Detail Records

    An array might work.
    Just store the results of your query (i.e. the ID's that get passed to the
    open window) in an array.
    Then from your pop-up window, you can access that array.
    Find the current position of the ID your pop-up is using, and use the ID in
    front of/behind it for your next/prev links.

    Hope that helps.
    - Shawn

    (If you need more help, I'll have to check it out at home when I get some free
    time. I can throw some code together to get a more detailed explanation for
    you.)

    shawnwindler Guest

  6. #5

    Default Re: Navigating Between Detail Records

    you should be able to achieve that using RECORDCOUNT and CURRENTROW

    uchil Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139