User-1211567575 posted
Hi.
I have an active, legacy website built with Frontpage 2000, where I use an Access 2000 database, for which Frontpage's "wizard" has created many classic .asp pages to update the existing 32-bit Access 2000 database . I will be replacing
(ultimately) the Frontage-built website with a VS/asp.net-built website, but am just starting to learn VS/ASP.net, and still need to resolve the following issue within the existing classic .asp pages of the FP website:
Issue:
I have created a very large query in the access database that is getting too big (too many fields to update within one .asp page..as the query is starting to exceed Access's apparent query field (column) limit of 255 fields, and Frontage's .asp
wizard is also "caving in" when too many fields are being updated within one .asp page)
To accommodate more fields, I will have to break up this large and growing query into 2-3 separate queries (I was hoping to be able to update and display over 350-400 fields from the one query on a single .asp page, but I think I would have to
jump to MySQL express with VS/ASP.NET to accomplish that, and I don't want my tiny brain to explode by attempting all of that right now ).
However, I should have thought of breaking up this query into separate queries a long time ago.
If I use 3-4 separate .asp pages (each page updating a different query for the same record), I currently only know how to have each page opened separately with the typical form at the top and enter the code for a specific field contained in the form
results.
Is there a way that I can have the submission of the first .asp form (or a create a link within the .asp form with a hyperlink parameter) update the fields, and then it
automatically opens the next .asp form in the chain for the same record (instead of having to keep entering the code at the top for each .asp form for the same record?)
Can I set up a hyperlink with parameters(s) that accomplishes that? I have already created links in .asp "database result pages" pages, where a hyperlink will take the user to the appropriate page, but the parameter settings of these hyperlinks are only
set take the user to a specific .htm page, not another .asp page for the same record.
For example, the following is a hyperlink parameter on an .asp page where "HypeName " is the field that takes the user (in this case) to an .htm page with the same name as the HypeName:
http://www.MyWebsite.com/Folder/Page Name/ .htm
Can the same type of hyperlink parameter take the user to an .asp page instead, where the criteria for opening the linked .asp page is the field that contains the client's code within the same query contained in the first .asp pa "results
page (where "HypeName" also resides.)
I am also hosting a Sample Frontpage2000 website, which is being used solely for the purpose of showing and discussing samples of forms I have created in the current, active FP website, so that (hopefully) it will make transitioning over to VS/ASP.net
easier with regards to forum questions and discussions.
Will it help answer this question if I can show you what I mean on the sample FP Website?
When I start in with VS/ASP.net, I will first be using an Access 2018 (64-bit) database...but one step at a time.
I had also built and hosted a website in ExpressionWeb a few years ago, but I never attempted to recreate the same database and form functionality, as I have been able to maintain that separately with the active FP website. However, as the hosting
of my FP website is not an issue (for now) with my host company, I am buying myself some time to learn VS/ASP.net ultimately, to make the full "switchover" to VS/ASP.net and finally get away from Windows XP Pro/Virtual XP.
I need to make the move over VS/ASP.net asp.net as quickly as possible, but I need to develop a few more pages in my existing FP web first. Can you help me with this particular issue?
Thanks, Ron
