Joe
|
| Posted: 01/06/2005, 8:15 AM |
|
I have a Page that generates a report. On the top of the page I have a link that says save page. All it does is takes the url of that page and inserts it into a field on the next page. The next page is obliviously a record insert page. The record insert page has the following fields. UserID, URL, Page Name. This works perfect. It has been working for about 9 months now. But now I want to be able to do now is. Have a list of customers where I can save that page to. Example, I click save page. And on the next page a record insert form is there with all my info. But below that is everyone else’s info with check boxes next to there names. If I check a list box the record will also insert a record with there: UserID, URL, Page Name, when I hit insert at the bottom of the page.
.ASP
CCS
Thanks
|
|
|
 |
kevind
Posts: 251
|
| Posted: 02/04/2005, 12:04 PM |
|
This sounds fairly complicated but, I'd try this sequence of events.
(this assumes you have a list of the customer names you can build a table from - the table would have columns UserID, URL, PageName, SavePage as CheckBox data type)
- add some custom SQL code to:
- erase all records from the temp db table of UserID's
- append all the UserID's to the table you MIGHT want to save the page for
- update the URL, page name etc for all records in this new temp table
- present an editable grid page bound to the temp data table you just created (no insert row)
- check off the names you want to save something for
- click Update button, button's return page should be another page with SQL code
- the page called when grid is updated should do the following:
- perform a custom SQL statement to 'insert into CustomerSavedPages' from 'TempDBTable'
- maybe present a results grid of those just saved if you put some date stamp in the data
let me know if you found this useful / need assistance
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
|
|
