Post Query Result Values to Next Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Frontpage 2003, I'm trying to use database result values from one page,
and POST them to another for an insert, update, or delete.
ie: INSERT INTO Table_01 ( First_Name, Last_Name )
VALUES ( '::First_Name::', '::Last_Name::' )
This syntax had previously worked using Frontpage 2000. Is there something
that needs to be done to make this work in 2003 ?
 
No, it works about the same.

In the first page, you have to form a custom query such as

SELECT '<a href=page2.asp? First_Name=' & [ First_Name] & '&Last_Name=' +
[Last_name] + '>' & [First_Name] & ' ' & [Last_name] & '</a>' AS page2link,
....

and then display the page2link field with Column Value Contains HTML in
effect.

To code your own Insert statement in the second page, you would have to
write your own ASP or ASP.NET page as described at

Saving Form Data in a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=44

or use JavaScript to copy the query string variables into the textboxes of a
form, and submit the form using the Save Results To Database feature.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Back
Top