|
| |
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
 |
DB update form confirmation page - 10/2/2005 0:55:19
I have an FP form that posts to a database. Works fine.
I would like the confirmation page to return the record's ID field so it can be loaded into a link that would allow the visitor to view the record they just updated.
Something like:
<a href="details.asp?ID=<% If Not IsEmpty(fp_rs) And Not(fp_rs Is Nothing) Then Response.Write CStr(fp_rs("ID")) %>">
I figure out how to get the ID field loaded into a link. I can return the ID using an FP Confirmation Field, but that cannot be dynamically loaded into a hyperlink.
Any ideas?
_____________________________
|
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/3/2005 1:54:15
I am currently using an customized FP ASP confirmation page. It will display the confirmation field just fine. But I can't figure out how to load that confirmation field into a query string -
something like:
<a href="details.asp?ID=ConfirmationField"> (where ConfirmationField = a record ID)
But that doesn't work. I can actually load the confirmation field web bot into the link, but it doesn't work through the browser.
Here's the task in a nutshell. The record ID is currently passed via a link to the form. When the form is submitted, it is passed via a hidden field to the database along with the additional information contained on the form. This all works just fine. Now I need to make some sort of confirmation page that will get that record ID loaded into a hyperlink, so the person who just added that record can see it.
Todd
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/10/2005 16:24:15
OK, I can only assume you simply can’t do this operation using an FP form to post to a database, or someone would have answered this.
If that’s the case, perhaps I shouldn’t be using an FP form here. Perhaps I should be using an “Insert” asp command. I must admit, I’m not too familiar with this and this is not the form to teach me from scratch. Can someone suggest a link or two or three with some tutorials on the subject. The only OutFront tutorials I could find that were close to this subject were for Update commands.
Thanks,
Todd
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/11/2005 13:58:33
quote:
ORIGINAL: Spooky
You are currently doing just that with an asp page though?
Spooky, I'm not sure I understand your question - the confirmation page is a simple asp page with a couple FP confirmation fields. What I need is to generate the link though.
Todd
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DB update form confirmation page - 10/11/2005 16:31:25
Is the insert sql on the confirmation page itself? If so, then the Request.Form object is still available to you and you can form your URL like this:
http://www.alea1.org/memorial/details_thoughts.asp?ID=<%=Request.Form("ID")%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/11/2005 17:44:07
Duane:
I'm using an FP form to post to the DB. As this thread continues, I think that's my problem.
Can you or someone else point me towards another thread or tutorial that deals with Insert SQL strings, so I can go that route and dump the FP form?
Todd
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DB update form confirmation page - 10/11/2005 22:59:57
I think the problem is he is using the "Send to Database" option with a custom confirmation page so the form values are dumped before getting to the confirmation page. However, Todd, you already know the ID number before you submit to the db so just append it to the URL in the redirect. On the page with your form, find the line that looks like this:
Response.Redirect "details_thoughts_input_confirm.asp"
and change to:
Response.Redirect "details_thoughts_input_confirm.asp?ID="&Request.QueryString("ID")
Then on the confirmation page use:
http://www.alea1.org/memorial/details_thoughts.asp?ID=<%=Request.QueryString("ID")%>
That should work for you.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 6:15:42
quote:
ORIGINAL: BeTheBall
Response.Redirect "details_thoughts_input_confirm.asp"
and change to:
Response.Redirect "details_thoughts_input_confirm.asp?ID="&Request.QueryString("ID")
Then on the confirmation page use:
http://www.alea1.org/memorial/details_thoughts.asp?ID=<%=Request.QueryString("ID")%>
I think we're real close on this, but something seems to be amiss with one of the two commands Duane has above. The link is appearing on the confirmation page, but no "ID" is displayed within the link, so it simply comes up: http://www.alea1.org/memorial/details_thoughts.asp?ID=
We've got to have one little parameter off somewhere.
Todd
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 10:11:52
Can you post the code for details_thoughts_input.asp?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 14:27:56
I noticed something when copying the code for this reply.
When I change the line:
Response.Redirect "details_thoughts_input_confirm.asp"
to
Response.Redirect "details_thoughts_input_confirm.asp?ID="&Request.QueryString("ID")
as Duane suggested, everything looks fine after I save it. However, when I close the file and reopen it, the line still reads:
Response.Redirect "details_thoughts_input_confirm.asp
Here is ALL the code for details_thoughts_input.asp:
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Session.LCID = 1033
Err.Clear
strErrorUrl = ""
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear
Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"
Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"
fp_conn.Open Application("memorial_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"
fp_rs.Open "thoughts", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"
fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(3)
Dim arFormDBFields0(3)
Dim arFormValues0(3)
arFormFields0(0) = "thought"
arFormDBFields0(0) = "thought"
arFormValues0(0) = Request("thought")
arFormFields0(1) = "ID"
arFormDBFields0(1) = "ID"
arFormValues0(1) = Request("ID")
arFormFields0(2) = "name"
arFormDBFields0(2) = "name"
arFormValues0(2) = Request("name")
FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0
FP_SaveFieldToDB fp_rs, Now, "date"
fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"
fp_rs.Close
fp_conn.Close
Session("FP_SavedFields")=arFormFields0
Session("FP_SavedValues")=arFormValues0
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
Response.Redirect "details_thoughts_input_confirm.asp"
End If
End If
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" type="text/css" href="../memorial.css">
<title>ALEA - Fallen Hero Memorial - Thoughts & Memories Input Form</title>
</head>
<body marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" rightmargin="0">
<body>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="100%">
<!--webbot bot="Include" U-Include="../includes/memorial_mast.htm" TAG="BODY" --></td>
</tr>
<tr>
<td width="100%" valign="top">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="550" id="AutoNumber2">
<tr>
<td width="100%">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="550" id="AutoNumber3">
<tr>
<td width="15" height="30">
<img border="0" src="images/box/upper_left.jpg"></td>
<td height="30" background="images/box/top.jpg"></td>
<td width="15" height="30">
<img border="0" src="images/box/upper_right.jpg"></td>
</tr>
<tr>
<td width="15" background="images/box/left.jpg"></td>
<td>
<!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM names WHERE (ID = ::ID::) ORDER BY lastname ASC,firstname ASC"
fp_sDefault="ID="
fp_sNoRecords="No records returned."
fp_sDataConn="memorial"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="date"
fp_sMenuValue="date"
fp_sColTypes="&ID=3&date=135&lastname=202&firstname=202&agency=203&state=202&aircraft=202&details=203&link=202&photo=202&patch=202&reviewed=11&"
fp_iDisplayCols=10
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="475" id="AutoNumber4">
<tr>
<td width="475" colspan="3">
<p align="center">
<b>
<i>In Memory Of</i></b></p>
<h1 align="center">
<b>
<%=FP_FieldVal(fp_rs,"firstname")%>
<%=FP_FieldVal(fp_rs,"lastname")%></b></h1>
<h2 align="center">
<span style="font-style: normal">
<%=FP_FieldVal(fp_rs,"agency")%>,
<%=FP_FieldVal(fp_rs,"state")%><br>
End of watch:
<%=FP_FieldVal(fp_rs,"date")%><br>
Aircraft:
<%=FP_FieldVal(fp_rs,"aircraft")%></span></h2>
</td>
</tr>
<tr>
<td width="237">
<div align="right">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber6">
<tr>
<td width="5" height="5">
<img border="0" src="images/photo_box/upper_left.jpg"></td>
<td height="5" background="images/photo_box/top.jpg"></td>
<td width="12" height="5">
<p align="right">
<img border="0" src="images/photo_box/upper_right.jpg"></td>
</tr>
<tr>
<td width="5" background="images/photo_box/left.jpg"></td>
<td width="100" height="125" background="images/photo_box/spacer.gif">
<p align="center">
<img border="0" src="images/heros/<%=FP_FieldLink(fp_rs,"photo")%>"></td>
<td width="12" background="images/photo_box/right.jpg"></td>
</tr>
<tr>
<td width="5" height="13">
<img border="0" src="images/photo_box/lower_left.jpg"></td>
<td background="images/photo_box/bottom.jpg" height="13"></td>
<td width="12" height="13">
<img border="0" src="images/photo_box/lower_right.jpg"></td>
</tr>
</table>
</div>
</td>
<td width="9">
</td>
<td width="229">
<img border="0" src="images/patches/<%=FP_FieldLink(fp_rs,"patch")%>" align="left"></td>
</tr>
</table>
</center>
</div>
<h3 align="center"><span style="font-weight: 400">Leave your Thoughts or Memories
of </span>
<b>
<span style="font-weight: 400">
<%=FP_FieldVal(fp_rs,"firstname")%></span>
<span style="font-weight: 400">
<%=FP_FieldVal(fp_rs,"lastname")%>.</span></b></h3>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
<table border="0" cellpadding="10" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber7">
<tr>
<td width="100%">
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" suggestedext="asp" u-asp-include-url="../_fpclass/fpdbform.inc" s-dataconnection="memorial" s-recordsource="thoughts" u-database-url="../fpdb/memorial.mdb" u-confirmation-url="details_thoughts_input_confirm.asp" s-builtin-fields="Timestamp" s-builtin-dbfields="date" s-form-fields="thought ID name" s-form-dbfields="thought ID name" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="34604" --><p>
Your Name (may be left anonymous):<br>
<input type="text" name="name" size="35" value="anonymous"></p>
<p>Your Thoughts or Memories of this fallen hero:<br>
<textarea rows="10" name="thought" cols="56"></textarea><br>
</p>
<p align="center"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
<input type="hidden" name="ID" value="<%=Request.querystring("ID")%>">
</form>
<p> </td>
</tr>
</table>
</td>
<td width="15" background="images/box/right.jpg"> </td>
</tr>
<tr>
<td width="15" height="17">
<img border="0" src="images/box/lower_left.jpg"></td>
<td height="17" background="images/box/bottom.jpg"> </td>
<td width="15" height="17">
<img border="0" src="images/box/lower_right.jpg"></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
<tr>
<td width="100%">
<p align="justify"><br>
Do you have more information about this fallen
hero? Help us maintain an accurate and fitting tribute to the men and
women who have made the ultimate sacrifice.
<a href="http://www.alea.org/public/memorial/updates/update_form.htm">Please provide us with
corrections and/or additional information</a>.</p>
</td>
</tr>
</table>
</center>
</div>
<p> </td>
</tr>
<tr>
<td width="100%">
<!--webbot bot="Include" U-Include="../includes/copyrights_footer.htm" TAG="BODY" --></td>
</tr>
</table>
</body>
</html>
Todd
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 16:04:32
I don't think the idea of adding the parameter at the end of the Response.Redirect will work any way so don't worry about the fact that FP undoes the change. Instead, for the URL to go from the confirmation page back to the record, try this:
http://www.alea1.org/memorial/details_thoughts.asp?ID=<%=Session("("FP_SavedValues")(1)%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 16:32:07
Adding that link anywhere on the confirmation page, causes the page to crash and display:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
HTTP 500 - Internal server error
Internet Explorer
Remove the link and the page displays fine.
The form does post to the DB irregardless of whether the confirmation page displays or not.
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 16:54:16
Oops. typo. Try this one.
http://www.alea1.org/memorial/details_thoughts.asp?ID=<%=Session("FP_SavedValues")(1)%>
If you get the same error message, go into IE, then tools, then Internet Options, Advanced tab and then scroll down and uncheck the box labeled, "Show friendly http error messages". This will give us a better idea of what the error is.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 17:14:05
OK, that link on details_thoughts_input_confirm.asp returns:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/memorial/details_thoughts_input_confirm.asp, line 122
This is the code for details_thoughts_input_confirm.asp
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" type="text/css" href="../memorial.css">
<title>ALEA - Fallen Hero Memorial - Details</title>
</head>
<body marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" rightmargin="0">
<body>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="100%">
<!--webbot bot="Include" U-Include="../includes/memorial_mast.htm" TAG="BODY" --></td>
</tr>
<tr>
<td width="100%" valign="top">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="550" id="AutoNumber2">
<tr>
<td width="100%">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="550" id="AutoNumber3">
<tr>
<td width="15" height="30">
<img border="0" src="images/box/upper_left.jpg" width="30" height="30"></td>
<td height="30" background="images/box/top.jpg"></td>
<td width="15" height="30">
<img border="0" src="images/box/upper_right.jpg" width="24" height="30"></td>
</tr>
<tr>
<td width="15" background="images/box/left.jpg"></td>
<td>
<p align="center">Thank you for taking the time to share your <br>
Thoughts and Memories of this Fallen Hero.</p>
<p align="center"><font color="#FF0000">Testing information only:</font></p>
<p align="center">The following lines are simple FP confirmation fields:</p>
<p align="center">ID = <b>
<!--webbot bot="ConfirmationField" S-Field="ID" --></b></p>
<p align="center">Your name = <b>
<!--webbot bot="ConfirmationField" S-Field="name" --></b></p>
<p align="center">Comments = <b>
<!--webbot bot="ConfirmationField" S-Field="thought" --></b></p>
<p align="center">The following link should take you back to the "thoughts"
page:</p>
<p align="center"><b>
<a href="details_thoughts.asp?ID=<%=Session("FP_SavedValues")(1)%>">Test link
back to thoughts page</a></b></p>
<p align="center"> </p>
<p> </td>
<td width="15" background="images/box/right.jpg"> </td>
</tr>
<tr>
<td width="15" height="17">
<img border="0" src="images/box/lower_left.jpg" width="30" height="24"></td>
<td height="17" background="images/box/bottom.jpg"> </td>
<td width="15" height="17">
<img border="0" src="images/box/lower_right.jpg" width="25" height="24"></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
<tr>
<td width="100%">
<p align="justify"><br>
Do you have more information about this fallen
hero? Help us maintain an accurate and fitting tribute to the men and
women who have made the ultimate sacrifice.
<a href="http://www.alea.org/public/memorial/updates/update_form.htm">Please provide us with
corrections and/or additional information</a>.</p>
</td>
</tr>
</table>
</center>
</div>
<p> </td>
</tr>
<tr>
<td width="100%">
<!--webbot bot="Include" U-Include="../includes/copyrights_footer.htm" TAG="BODY" --></td>
</tr>
</table>
</body>
</html>
Todd
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: DB update form confirmation page - 10/12/2005 18:33:31
I am stumped. I tested this and have the following link on the confirmation page:
<a href="details.asp?FName=<%=Session("FP_SavedValues")(0)%>">
It works perfectly.
On your confirmation page, see if you get the same error if you try to simply write the session variable, i.e.,
<%=Session("FP_SavedValues")(1)%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
ttjager
Posts: 95
Joined: 3/25/2002
From:
Status: offline
|
RE: DB update form confirmation page - 10/13/2005 1:49:38
It was the !@#$% FrontPage confirmation fields! I had them on the confirmation page just as a reference. They came before the link we have been working on. As soon as I removed those !@#$% confirmation fields, the last link Duane provided worked perfectly!
details_thoughts.asp?ID=<%=Session("FP_SavedValues")(1)%>
Thanks for all help Duane and Spooky! You guys are my heros - I must admit I thought I had stumped you this time though.
Thanks again!!
Todd
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
