Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Unamailer #1
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
-
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... -
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... -
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... -
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... -
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... -
shawnwindler #2
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
-
Unamailer #3
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
-
shawnwindler #4
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
-
uchil #5
Re: Navigating Between Detail Records
you should be able to achieve that using RECORDCOUNT and CURRENTROW
uchil Guest



Reply With Quote

