a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Submitting to table with URL String in a field

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Submitting to table with URL String in a field 		Page: [1]
 
abdulsamikhan

 

Posts: 105
Joined: 12/23/2003
From: Pakistan
Status: offline

  		Submitting to table with URL String in a field - 9/2/2005 12:36:44   
I have made an Access Database based website, the page is showing records well on the base of ID comparing to the ID, I want to rate the record and store the (Rating, A, B, C, D, E) to another Table (Rating)(Every thing is well till this point) Furthermore, I want to store the Record ID (which is coming from another table) alongwith the rating... How can I do all this using DRW or ASP?
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Submitting to table with URL String in a field - 9/2/2005 13:21:56   
So your problem with this is grabbing the ID and passing to the second query?

One way would to be with a session. For instance, on the first page that you get the ID from, write that to a session:

Session("myID") = Request("ID")

Then on the page that writes to the rating table, include:

Session("ID") where you'd normally use Request("ID").


If that's not enough:

You said you had the first two working. If you post just the *dieted* DRW, I'll see if I can show you exactly where.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 105
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: Submitting to table with URL String in a field - 9/3/2005 4:04:15   
Thank you for the reply...
Here is the actual situation..
Please check this site:

http://www.dabclub.com/poetrynew/

When user clicks on the poetry:
It reaches to this page:
http://dabclub.com/poetrynew/poetrydisplay.asp?PID=50

Here is the PID=50, which I want to enter to the new table named: Ratings. (Rating table has two fields PID and Rating: Where Rating is the Option Button Group, there are five Option Buttons with Value A, B, C, D and E) The Option buttons based Rating system in below the Poem and with separate Form, the name of form is Ratings, it can easily post the Rating Value to the Table but I want that when rate the poem, it automatically enter the PID value from the URL to the Rating Table's PID field, so that the Rating will be relevant to the Poem)

I hope you will have understood, what I want to do...

Another Problem is with me, I have made all the website using DRW, and I am not very good to use ASP based code.

For your convenience, if you want I can send you the entire website or paste the code of the page here...

The database is stored in fpdb folder with connection name poetry.

Waiting for your reply.



(in reply to rdouglass)
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Submitting to table with URL String in a field - 9/3/2005 12:21:19   
quote:

For your convenience, if you want I can send you the entire website or paste the code of the page here...


How about just the DRW code(s). Don't need the whole page, just the HTML that makes up the form and DRW code relating to the Ratings table will be a good start.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 105
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: Submitting to table with URL String in a field - 9/4/2005 6:31:47   
I hope it would be enough to understand.... wouldn't it be? 
 <%
' 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
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("poetry_ConnectionString")
	FP_DumpError strErrorUrl, "Cannot open database"

	fp_rs.Open "Rating", 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(1)
	Dim arFormDBFields0(1)
	Dim arFormValues0(1)

	arFormFields0(0) = "Rating"
	arFormDBFields0(0) = "Rating"
	arFormValues0(0) = Request("Rating")

	FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


	fp_rs.Update
	FP_DumpError strErrorUrl, "Cannot update the database"

	fp_rs.Close
	fp_conn.Close

	FP_FormConfirmation "text/html; charset=windows-1252",_
						"Form Confirmation",_
						"Thank you for submitting the following information:",_
						"poetrydisplay.asp",_
						"Return to the form."

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<html>

<!-- #BeginTemplate "other.dwt" -->

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<!-- #BeginEditable "doctitle" -->
<title>Poetry @ dabclub.com</title>
<!-- #EndEditable -->
<meta name="keywords" content="Poetry, Pakistani Poetry, Indian Poetry, Urdu Poetry, Ghalib, Allama Iqbal, Meer Taqi Meer, Submi Poetry, Urdu Adab, Urdu Literature, Love, Romance, Sadness, Quotation and many more...">
<meta name="description" content="This section of dabclub.com is dedicated to only for those who can sense the touch of sensitive feelings of poetry in real sense... We the team of dabclub.com are welcoming you to our this section...">
<link rel="stylesheet" type="text/css" href="css/jics.css">
<link rel="stylesheet" type="text/css" href="css/MSEducation.css">
<style>
<!--
-->
</style>
</head>

<body bgcolor="#CC3300">

<div align="center">
	<br>
	<a name="Top"></a>
	<table cellpadding="0" cellspacing="0" width="775" height="681">
		<!-- MSTableType="layout" -->
		<tr>
			<td colspan="3" bgcolor="#CC00CC" align="center" background="images/PoetryTopBar.jpg">
			<b><font face="Arial" color="#FFFFFF" style="font-size: 9pt">WELCOME 
			TO<br>
			</font><font face="Arial" color="#FFFFFF" size="3">DABCLUB POETRY 
			CLUB</font></b></td>
			<td height="78"></td>
		</tr>
		<tr>
			<td colspan="3" bgcolor="#000000" align="center">
			<font color="#FFCC00">
			<a href="default.asp"><font color="#FFFFFF">Poetry Home</font></a><font color="#FFFFFF"> 
			</font></font>
			<font color="#FFFFFF">|  </font><font color="#FFCC00">
			<a href="../default.asp">
			<font color="#FFFFFF">Home</font></a></font><font color="#FFFFFF">  | 
			<a target="_blank" href="http://www.dabclub.com/wallpaperz">
			<font color="#FFFFFF">Wallpapers</font></a> | </font><a href="http://www.dabclub.com/feedback.asp">
			<font color="#FFFFFF">Feedback</font></a><font color="#FFFFFF"> 
		| </font><font color="#E9C839"> 
			<a href="http://www.dabclub.com/egreetings/skrifa.asp">
		<font color="#FFFFFF">eGreetings</font></a></font><font color="#FFFFFF"> | 
		</font><font color="#E9C839"> 
			<a target="_blank" href="http://www.dabclub.net"><font color="#FFFFFF">Songs</font></a><font color="#FFFFFF"> | 
		</font> 
		<a href="http://www.dabclub.com/jokes.asp"><font color="#FFFFFF">Jokes</font></a><font color="#FFFFFF"> | 
		</font> 
		<a href="http://www.dabclub.com/funnysms.asp"><font color="#FFFFFF">Quotations</font></a><font color="#FFFFFF"> | 
		</font> 
		<a href="http://www.dabclub.com/ourguests.asp"><font color="#FFFFFF">Guestbook</font></a><font color="#FFFFFF"> 
			| <a href="search.asp"><font color="#FFFFFF">Search the Poetry Club</font></a></font></font></td>
			<td height="22"></td>
		</tr>
		<tr>
			<td valign="top" rowspan="5" colspan="2">
			<table cellpadding="0" cellspacing="0" border="0" width="100%" height="100%">
				<!-- MSCellFormattingTableID="6" -->
				<tr>
					<td bgcolor="#CC00CC" colspan="3" height="1">
					<img alt="" width="1" height="1" src="images/MsSpacer.gif"></td>
				</tr>
				<tr>
					<td bgcolor="#CC00CC" width="1">
					<img alt="" width="1" height="1" src="images/MsSpacer.gif"></td>
					<td valign="top" bgcolor="#FFCCFF" width="100%">
					<!-- MSCellFormattingType="content" -->
					<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table9">
	<tr>
		<td>
					<table border="0" cellpadding="5" cellspacing="5" width="100%" id="table10" height="191">
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="allpoetry.asp">Poetry Categories</a></b></td>
	</tr>
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="allquotations.asp">Quotation Categories</a></b></td>
	</tr>
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="allshaamicollection.asp">Shaami's Collection</a></b></td>
	</tr>
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="toptwentyghazals.asp">Top 20 Ghazals</a></b></td>
	</tr>
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="toptwentyquotations.asp">Top 20 Quotations</a></b></td>
	</tr>
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="submitpoetry.asp">Submit a Poetry</a></b></td>
	</tr>
	<tr>
		<td style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" bordercolor="#CC00CC">
		<b>
		<a href="submitquotation.asp">Submit a Quotation</a></b></td>
	</tr>
					</table>
					</td>
	</tr>
	<tr>
		<td>
					<table border="0" cellpadding="3" cellspacing="3" width="100%" id="table11">
	<tr>
		<td>
		<p style="line-height: 150%"><img border="0" src="images/square.gif" width="7" height="6"> <a href="../general/islamandquran/islamquran.htm">Islam 
		& Quran</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../general/cookbook/cookbook.htm">Cookbook 
		(Recipe)</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../general/beautytips/beautytips.htm">Beauty 
		Tips</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../general/healthtips/healthtips.htm">Health 
		Tips</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../general/newspapersofpakistan.htm">Newspapers 
		of <br></a>
		<img border="0" src="images/square.gif" width="7" height="6"><a href="../general/newspapersofpakistan.htm"> Pakistan</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../general/magazines.htm">Magazines 
		of Pakistan</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../hazara/pryertimings.htm">Prayer 
		Timings</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"><a href="../information/dialingcodes.htm"> Dialing 
		Codes</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../information/horoscope/horocscope.htm">Horoscope</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../information/isp.htm">ISP 
		Index</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../information/railway.htm">Railway 
		Timings</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../hazara/impnumbers.htm">Important 
		Numbers</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../hazara/introduction.htm">Hazara 
		(An Introduction)</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../hazara/abbottabad.htm">About 
		Abbottabad</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../hazara/mansehra.htm">About 
		Mansehra</a><br>
		<img border="0" src="images/square.gif" width="7" height="6"> <a href="../hazara/haripur.htm">About 
		Haripur</a><br>
		<img border="0" src="images/square.gif" width="7" height="6">
		<a href="../htm/telephonedirectoryofpakistan.htm">Telephone Directory</a><br>
		<img border="0" src="images/square.gif" width="7" height="6">
		<a href="http://www.dabclub.com/discussion">Discussion Forum</a></td>
	</tr>
					</table>
					</td>
	</tr>
					</table>
					</td>
					<td bgcolor="#CC00CC" height="100%" width="1">
					<img alt="" width="1" height="1" src="images/MsSpacer.gif"></td>
				</tr>
				<tr>
					<td bgcolor="#CC00CC" colspan="3" height="1">
					<img alt="" width="1" height="1" src="images/MsSpacer.gif"></td>
				</tr>
			</table>
			</td>
			<td background="images/TopBar.jpg" align="center">
			<!-- #BeginEditable "Header" -->
		<!--webbot bot="DatabaseRegionStart" s-columnnames="PCatID,PID,Poetry,Name,Email,Title,Date" s-columntypes="3,3,203,202,202,202,135" s-dataconnection="poetry" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-listformat="1" b-makeform="FALSE" s-recordsource="Poetry" s-displaycolumns="Title" s-criteria="{PID} EQ {PID} +" s-order s-sql="SELECT * FROM Poetry WHERE (PID =  ::PID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="PID=" s-norecordsfound="No records returned." i-maxrecords="1" i-groupsize="0" botid="4" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" startspan --><!--#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 Poetry WHERE (PID =  ::PID::)"
fp_sDefault="PID="
fp_sNoRecords="No records returned."
fp_sDataConn="poetry"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PCatID=3&PID=3&Poetry=203&Name=202&Email=202&Title=202&Date=135&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=4
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="42688" --><p><b>
		<font color="#CC3300" face="Arial" style="font-size: 12pt">
		<!--webbot bot="DatabaseResultColumn" s-columnnames="PCatID,PID,Poetry,Name,Email,Title,Date" s-column="Title" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Title<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Title")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8773" --></font></b></p>
		<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><!-- #EndEditable --></td>
			<td height="30"></td>
		</tr>
		<tr>
			<td valign="top" bgcolor="#FFFFFF">
			<table cellpadding="0" cellspacing="0" border="0" width="100%" height="100%">
				<!-- MSCellFormattingTableID="3" -->
				<tr>
					<td valign="top" width="100%" height="100%">
					<!-- MSCellFormattingType="content" -->
					<!-- #BeginEditable "Main" -->
					<!--webbot bot="DatabaseRegionStart" s-columnnames="PCatID,PID,Poetry,Name,Email,Title,Date" s-columntypes="3,3,203,202,202,202,135" s-dataconnection="poetry" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="1" b-makeform="FALSE" s-recordsource="Poetry" s-displaycolumns="Title,Poetry,Name,Date" s-criteria="{PID} EQ {PID} +" s-order s-sql="SELECT * FROM Poetry WHERE (PID =  ::PID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="PID=" s-norecordsfound="No records returned." i-maxrecords="1" i-groupsize="0" botid="3" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" startspan --><!--#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 Poetry WHERE (PID =  ::PID::)"
fp_sDefault="PID="
fp_sNoRecords="No records returned."
fp_sDataConn="poetry"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PCatID=3&PID=3&Poetry=203&Name=202&Email=202&Title=202&Date=135&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="43040" --><table border="0" cellpadding="3" cellspacing="3" width="100%" id="table12">
						<tr>
							<td colspan="2" height="105">
							<p align="center"><font face="Verdana" size="2">
							<%=Replace(FP_FieldVal(fp_rs,"Poetry"),vbCrLf,"<br>")%></font></p>
							<p align="center"> </p>
							</td>
						</tr>
						<tr>
							<td width="84%">
							<p align="right"><font face="Arial" color="#CC00CC">
							<i>
							<!--webbot bot="DatabaseResultColumn" s-columnnames="PCatID,PID,Poetry,Name,Email,Title,Date" s-column="Name" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Name<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3900" --></i></font></td>
							<td width="13%">
							<p align="right"><font face="Arial" color="#CC3300">
							<i>
							<!--webbot bot="DatabaseResultColumn" s-columnnames="PCatID,PID,Poetry,Name,Email,Title,Date" s-column="Date" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Date<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3267" --></i></font></td>
						</tr>
					</table>
					<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><p align="center">
					<a href="javascript:history.go(-1)">Back to Previous Page</a><form method="POST" action="--WEBBOT-SELF--">
						<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="poetry" S-RecordSource="Rating" U-Database-URL="fpdb/poetry.mdb" S-Form-Fields="Rating" S-Form-DBFields="Rating" U-ASP-Include-Url="_fpclass/fpdbform.inc" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" i-checksum="40548" endspan -->
						<table border="1" width="100%" id="table13">
							<tr>
								<td align="center" width="20%">
								<img border="0" src="images/star.jpg" width="20" height="20"></td>
								<td align="center" width="20%">
								<img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"></td>
								<td align="center" width="20%">
								<img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"></td>
								<td align="center" width="20%">
								<img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"></td>
								<td align="center" width="20%">
								<img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"><img border="0" src="images/star.jpg" width="20" height="20"></td>
							</tr>
							<tr>
								<td align="center" width="20%">
								<input type="radio" value="E" name="Rating" checked></td>
								<td align="center" width="20%">
								<input type="radio" value="D" name="Rating"></td>
								<td align="center" width="20%">
								<input type="radio" value="C" name="Rating"></td>
								<td align="center" width="20%">
								<input type="radio" value="B" name="Rating"></td>
								<td align="center" width="20%">
								<input type="radio" value="A" name="Rating"></td>
							</tr>
						</table>
						<p align="center">
						<input type="submit" value="Rate It" name="Rate">						
						</p>
						
						
					</form>
					<p align="center">
					 <!-- #EndEditable --></td>
					</tr>
			</table>
			</td>
			<td height="281"></td>
		</tr>
		<tr>
			<td align="center" bgcolor="#F2F2F2"><a href="#top">Back to Top</a></td>
			<td height="23"></td>
			</tr>
		<tr>
			<td colspan="2" height="25" background="images/HeaderBarPurple.jpg" align="center">
			<b><font face="Arial" color="#FFFFFF">POETRY CATEGORIES</font></b></td>
		</tr>
		<tr>
			<td valign="top" bgcolor="#FFDFFF">
			<table cellpadding="0" cellspacing="0" border="0" width="100%" height="100%">
				<!-- MSCellFormattingTableID="2" -->
				<tr>
					<td valign="top" width="100%" height="100%">
					<!-- MSCellFormattingType="content" -->
					<div align="center">
					<table width="98%" id="table3">
	<thead>
	</thead>
	<tbody>
		<!--webbot bot="DatabaseRegionStart" s-columnnames="PCatID,PCatName" s-columntypes="3,202" s-dataconnection="poetry" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="PCat" s-displaycolumns="PCatName" s-criteria s-order="[PCatName] +" s-sql="SELECT * FROM PCat ORDER BY PCatName ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="15" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" startspan --><!--#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 PCat ORDER BY PCatName ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="poetry"
fp_iMaxRecords=15
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PCatID=3&PCatName=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="31779" -->
<%
count = count + 1
If count = 1 Then
%> <tr><%
End If
%> 

			<td bgcolor="#FFFFFF" width="25%">
			<b><font face="Verdana">
			 <a href="pcatlist.asp?PCatID=<%=FP_FieldURL(fp_rs,"PCatID")%>"><!--webbot bot="DatabaseResultColumn" s-columnnames="PCatID,PCatName" s-column="PCatName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PCatName<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PCatName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="10815" --></a></font></b></td>
<%
If count = 4 Then
count = 0
%> </tr><%
End If
%> 

		<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
					</table>
					</div>
					</td>
					</tr>
			</table>
			</td>
			<td height="96"></td>
			</tr>
		<tr>
			<td colspan="4" height="84" bgcolor="#000000" align="center">
			 
			
			
			
			
<script type="text/javascript"><!--
google_ad_client = "pub-2845548483016482";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "333333";
google_color_bg = "000000";
google_color_link = "FFFFFF";
google_color_url = "999999";
google_color_text = "CCCCCC";
//--></script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>			
			
			
			
			
			
			
			
			
			
			</td>
		</tr>
		<tr>
			<td></td>
			<td colspan="3" bgcolor="#000000" background="images/HeaderBarPurple.jpg" align="center" height="26">
			<font color="#FFFFFF">All rights reserved.
			<a target="_blank" href="http://www.jixoft.com">
			<font color="#FFFFFF">Site developed and maintained by JiXoft</font></a> 
			| <b><a href="webmaster.asp"><font color="#FFFFFF">Webmaster</font></a></b></font></td>
			</tr>
		<tr>
			<td width="2"></td>
			<td width="160"> </td>
			<td width="611"> </td>
			<td height="16" width="2"></td>
		</tr>
	</table>
</div>

</body>

<!-- #EndTemplate -->

</html>

(in reply to rdouglass)
abdulsamikhan

 

Posts: 105
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: Submitting to table with URL String in a field - 9/8/2005 1:57:07   
I don't think my question is very tough that it took very long to be answered....:)

(in reply to abdulsamikhan)
rubyaim

 

Posts: 757
Joined: 6/22/2005
Status: offline

  		RE: Submitting to table with URL String in a field - 9/8/2005 18:15:49   
Hi, sometimes people get busy, I always think that it's great that so many questions here are answered as often as they are :)

As you are passing the value of the PID to that page, could it be requested in a hidden field in your form?

Something like: 

<input type="hidden" name="PID" value="<%=Request.Querystring("PID")%>">


Right click on your form, then click on 'Form Properties, then 'Advanced', then 'Add'. The name is the field name , and the value would be ="<%=Request.Querystring("PID")%> . You will also have to add this to your saved fields in the 'Send to Database' Options.

Is this the sort of thing you are looking for?

Sally

(in reply to abdulsamikhan)
abdulsamikhan

 

Posts: 105
Joined: 12/23/2003
From: Pakistan
Status: offline

  		RE: Submitting to table with URL String in a field - 9/9/2005 2:42:48   
Thank you very much Rubyaim.

This is what I was looking for... :)

(in reply to rubyaim)
Page:   [1]
OutFront Discoveries

All Forums >> Web Development >> ASP and Database >> Submitting to table with URL String in a field 		Page: [1]
Jump to: 1





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


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2009 All Rights Reserved
  Click here to view our privacy statement.