Passing Parameters help (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


99bird -> Passing Parameters help (12/8/2006 12:20:27)


I have a page that has image rollovers ( http://www.krenekrv.com/used/newinv21.asp?VehId=1064) and I need to pass them to another page and be able to scroll through them. The parameters are being passed and the first image is being shown. But I am unable to get the pictures change when I click on the forward and back buttons. I have only called 2 images for demonstration purposes. In total there will be a total of 12 images. I hope that I have explained this correctly. Any help would be greatly appreciated.
Thanks in advance you all of you help.
Code being used is listed below.



**********************Image rollover and sending parameters********************8

<p align="left"> <a href="DisplayLargePhoto.asp?VehId=<%=FP_FieldURL(fp_rs,"VehId")%>&PhotoName1=<%=FP_FieldURL(fp_rs,"PhotoName1")%>&PhotoName2=<%=FP_FieldURL(fp_rs,"PhotoName2")%>&PhotoName3=<%=FP_FieldURL(fp_rs,"PhotoName3")%>&PhotoName4=<%=FP_FieldURL(fp_rs,"PhotoName4")%>&PhotoName5=<%=FP_FieldURL(fp_rs,"PhotoName5")%>"><img src="<%=FP_FieldURL(fp_rs,"PhotoName1")%>" name="bigpic" alt="" id="bigpic" border=0></a>

<td align=center height="247">
<a onClick="MM_swapImage('bigpic','','<%=FP_FieldURL(fp_rs,"PhotoName1")%>',1)">
<img src="<%=FP_FieldURL(fp_rs,"PhotoName1")%>" alt="" name="mini1" width="62" height="46" border="0" id="mini1"></a>
<a onClick="MM_swapImage('bigpic','','<%=FP_FieldURL(fp_rs,"PhotoName2")%>',1)">
<img src="<%=FP_FieldURL(fp_rs,"PhotoName2")%>" alt="" name="mini2" width="62" height="46" border="0" id="mini2"></a>
<a onClick="MM_swapImage('bigpic','','<%=FP_FieldURL(fp_rs,"PhotoName3")%>',1)">
<img src="<%=FP_FieldURL(fp_rs,"PhotoName3")%>" alt="" name="mini3" width="62" height="46" border="0" id="mini3"></a>
<a onClick="MM_swapImage('bigpic','','<%=FP_FieldURL(fp_rs,"PhotoName4")%>',1)">
<img src="<%=FP_FieldURL(fp_rs,"PhotoName4")%>" alt="" name="mini4" width="62" height="46" border="0" id="mini4"></a>
<a onClick="MM_swapImage('bigpic','','<%=FP_FieldURL(fp_rs,"PhotoName5")%>',1)">
<img src="<%=FP_FieldURL(fp_rs,"PhotoName5")%>" alt="" name="mini5" width="62" height="46" border="0" id="mini5"></a>




*************************DisplayLargePhoto.asp****************************

<html>

<head>
<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">
</head>

<body>

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<form method="POST" action="--WEBBOT-SELF--">
<input type="Hidden" name="Vehid" value="<%=Request("VehId")%>" size="20"><input type="Hidden" name="PhotoName1" value="<%=Request("PhotoName1")%>" size="20"><input type="Hidden" name="PhotoName2" value="<%=Request("PhotoName2")%>" size="20">

<img src="<%=Request("PhotoName1")%>" height="200" width=300 img border="0">
<INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" |< "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" < "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" > "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" >| "> [1/5]
<br>
<thead>
</thead>
<tbody>

<td width="100%">
<!--webbot bot="DatabaseRegionStart" s-columnnames="VehId,Manuf,StockNbr,ModelNbr,Vin,Msrp,Year,Mileage,Price,spprice,NewUsed,Length,FuelType,Class,Floorplan,Floorplan_pic,Engine,Slides,Chassis,Color,Option25,Option26,Option27,Option1,Option2,Option3,Option4,Option5,Option6,Option7,Option8,Option9,Option10,Option11,Option12,Option13,Option14,Option15,Option16,Option17,Option18,Option19,Option20,Option21,Option22,Option23,Option24,PhotoName1,PhotoName2,PhotoName3,PhotoName4,PhotoName5,PhotoName6,PhotoName7,PhotoName8,PhotoName9,PhotoName11,PhotoName12,PhotoName13,PhotoName10,window_pic,wspecial,newarav,views" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,11,11,2" s-dataconnection="cardealer" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="FALSE" b-listseparator="FALSE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="VehId,PhotoName1,PhotoName2,PhotoName3,PhotoName4,PhotoName5" s-criteria s-order s-sql="SELECT * FROM tblVehicles WHERE (PhotoName1 = '::PhotoName1::' AND PhotoName2 = '::PhotoName2::' AND PhotoName3 = '::PhotoName3::' AND PhotoName4 = '::PhotoName4::' AND PhotoName5 = '::PhotoName5::' ) = VehId " b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="PhotoName1=&PhotoName2=&PhotoName3=&PhotoName4=&PhotoName5=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" 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" align="left"><font color="#000000">This is the start of a Database Results region.</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 tblVehicles WHERE (PhotoName1 = '::PhotoName1::' AND PhotoName2 = '::PhotoName2::' AND PhotoName3 = '::PhotoName3::' AND PhotoName4 = '::PhotoName4::' AND PhotoName5 = '::PhotoName5::' ) = VehId "
fp_sDefault="PhotoName1=&PhotoName2=&PhotoName3=&PhotoName4=&PhotoName5="
fp_sNoRecords="No records returned."
fp_sDataConn="cardealer"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&VehId=3&Manuf=202&StockNbr=202&ModelNbr=202&Vin=202&Msrp=202&Year=202&Mileage=202&Price=202&spprice=202&NewUsed=202&Length=202&FuelType=202&Class=202&Floorplan=202&Floorplan_pic=202&Engine=202&Slides=202&Chassis=202&Color=202&Option25=202&Option26=202&Option27=202&Option1=202&Option2=202&Option3=202&Option4=202&Option5=202&Option6=202&Option7=202&Option8=202&Option9=202&Option10=202&Option11=202&Option12=202&Option13=202&Option14=202&Option15=202&Option16=202&Option17=202&Option18=202&Option19=202&Option20=202&Option21=202&Option22=202&Option23=202&Option24=202&PhotoName1=202&PhotoName2=202&PhotoName3=202&PhotoName4=202&PhotoName5=202&PhotoName6=202&PhotoName7=202&PhotoName8=202&PhotoName9=202&PhotoName11=202&PhotoName12=202&PhotoName13=202&PhotoName10=202&window_pic=202&wspecial=11&newarav=11&views=2&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-CheckSum="22624" --><p>
 </p>
<p>
 </p>
<p>
 </p>
<p>
 </p>
<p>
 </p>
<p>
 </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" align="left"><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="56926" --><p> </td>
</tr>
<tr>
<td width="100%">

</form>
<p> </td>
</tr>
</table>

</body>

</html>




blockhead -> RE: Passing Parameters help (12/9/2006 16:56:31)

Hi - I know the feeling of being stuck.
The first thing, your page is http://www.krenekrv.com/used/newinv21.asp?VehId=1064 without the ending ")"

If I were you, I'd break this down into two different parts - your asp code, and your rollover code. For both of your asp pages, it would probably help to put them on the Spooky diet, so you can change them without messing with the Front Page wizard - http://www.outfront.net/spooky/adv_drw.htm

Make sure your parameters are being passed by doing a response.write in your DisplayLargePhotos page. It looked to me like both pics/9794_01.jpg and pics/9794_02.jpg came in.

Dim tempPhoto1 = request.queryString("PhotoName1")
Dim tempPhoto2 = request.queryString("PhotoName2")
response.write tempPhoto1 & "<br>"
response.write tempPhoto2


Once you're sure the names are coming in and displaying correctly, all you have to do is work with the variable names, instead of whatever names the rollover page would use if it were all by itself. It looks to me like this is the problem page.




99bird -> RE: Passing Parameters help (12/11/2006 8:57:27)

Thanks Blockhead for your reply and insight.
Being a novice when it comes to coding, especially using variables. I was wondering if you could you elaborate a bit more on the variables part?
Thank you again for your help in advance.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875