Forums

ASP

This topic is locked

repeat region with show if

andy bertaut

Posted 26 Jan 2006 16:37:33

has voted

Vote

26 Jan 2006 16:37:33 andy bertaut posted:

After not getting anywhere with the problem i outlined in my last post, i have decided to rework my pages....i will spare everyone the long boring story and just ask is there some issue with using repeat regions with a show if behaviour? The show ifs are working fine, but the repeat region isnt showing at all. code below. thanks.

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>



<%
var rsPAPERA34__MMColParam = "1";
if (String(Request.QueryString("ProductCode"

) != "undefined" &&
String(Request.QueryString("ProductCode"

) != ""

{
rsPAPERA34__MMColParam = String(Request.QueryString("ProductCode"

);
}
%>
<%
var rsPAPERA34 = Server.CreateObject("ADODB.Recordset"

;
rsPAPERA34.ActiveConnection = MM_connWIZARD06_STRING;
rsPAPERA34.Source = "SELECT * FROM paper_a3_4 WHERE ProductCode = '"+ rsPAPERA34__MMColParam.replace(/'/g, "''"

+ "'";
rsPAPERA34.CursorType = 2;
rsPAPERA34.CursorLocation = 3;
rsPAPERA34.LockType = 1;
rsPAPERA34.Open();
var rsPAPERA34_numRows = 0;
%>
<%
var rsBOOKSACC__MMColParam = "1";
if (String(Request.QueryString("ProductCode"

) != "undefined" &&
String(Request.QueryString("ProductCode"

) != ""

{
rsBOOKSACC__MMColParam = String(Request.QueryString("ProductCode"

);
}
%>
<%
var rsBOOKSACC = Server.CreateObject("ADODB.Recordset"

;
rsBOOKSACC.ActiveConnection = MM_connWIZARD06_STRING;
rsBOOKSACC.Source = "SELECT * FROM books_accounts WHERE ProductCode = '"+ rsBOOKSACC__MMColParam.replace(/'/g, "''"

+ "'";
rsBOOKSACC.CursorType = 2;
rsBOOKSACC.CursorLocation = 3;
rsBOOKSACC.LockType = 1;
rsBOOKSACC.Open();
var rsBOOKSACC_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
rsPAPERA34_numRows += Repeat1__numRows;
%>
<%
var Repeat2__numRows = 10;
var Repeat2__index = 0;
rsPAPERA34_numRows += Repeat2__numRows;
%>
<%
// WA eCart AddToCart
if (String(Request.Form("Wizard_Cart_1_ATC"

) != "undefined" || String(Request.Form("Wizard_Cart_1_ATC.x"

) != "undefined"

{
var ATC_itemID = String(Request.Form("Wizard_Cart_1_ID_Add"

);
var ATC_AddIfIn = 0;
var ATC_RedirectAfter = "";
var ATC_RedirectIfIn = "";
var ATC_RSPos = rsPAPERA34.AbsolutePosition;
rsPAPERA34.MoveFirst();
while (!rsPAPERA34.EOF) {
if (String(rsPAPERA34.Fields("ProductCode"

.value) == String(ATC_itemID)) {
var ATC_itemName = "" + String((rsPAPERA34.Fields.Item("Description"

.Value)) + "";// column binding
var ATC_itemDescription = "";// column binding
var ATC_itemWeight = parseFloat("0"

;// column binding
var ATC_itemQuantity = "" + String(Request.Form("Wizard_Cart_1_Quantity_Add"

) + "";// column binding
var ATC_itemPrice = parseFloat("" + String((rsPAPERA34.Fields.Item("Expr2"

.Value)) + ""

;// column binding
break;
}
rsPAPERA34.MoveNext()
}
rsPAPERA34.AbsolutePosition = ATC_RSPos;
ATC_itemQuantity = parseFloat(ATC_itemQuantity);
if (!isNaN(ATC_itemQuantity) && ATC_itemQuantity != 0) {
Wizard_Cart.AddToCart(ATC_AddIfIn, ATC_RedirectIfIn, ATC_itemID, ATC_itemName, ATC_itemDescription, ATC_itemWeight, ATC_itemQuantity, ATC_itemPrice);
if (ATC_RedirectAfter != "" && Wizard_Cart_redirStr == ""

{
Wizard_Cart_redirStr = ATC_RedirectAfter;
}
Session("WAEC_ContinueRedirect"

= String(Request.ServerVariables("Script_Name"

) + "?" + String(Request.QueryString());
}
}
%>
<%
// WA eCart AddToCart
if (String(Request.Form("Wizard_Cart_2_ATC"

) != "undefined" || String(Request.Form("Wizard_Cart_2_ATC.x"

) != "undefined"

{
var ATC_itemID = String(Request.Form("Wizard_Cart_2_ID_Add"

);
var ATC_AddIfIn = 0;
var ATC_RedirectAfter = "";
var ATC_RedirectIfIn = "";
var ATC_RSPos = rsBOOKSACC.AbsolutePosition;
rsBOOKSACC.MoveFirst();
while (!rsBOOKSACC.EOF) {
if (String(rsBOOKSACC.Fields("ProductCode"

.value) == String(ATC_itemID)) {
var ATC_itemName = "" + String((rsBOOKSACC.Fields.Item("Description"

.Value)) + "";// column binding
var ATC_itemDescription = "";// column binding
var ATC_itemWeight = parseFloat("0"

;// column binding
var ATC_itemQuantity = "" + String(Request.Form("Wizard_Cart_2_Quantity_Add"

) + "";// column binding
var ATC_itemPrice = parseFloat("" + String((rsBOOKSACC.Fields.Item("Expr2"

.Value)) + ""

;// column binding
break;
}
rsBOOKSACC.MoveNext()
}
rsBOOKSACC.AbsolutePosition = ATC_RSPos;
ATC_itemQuantity = parseFloat(ATC_itemQuantity);
if (!isNaN(ATC_itemQuantity) && ATC_itemQuantity != 0) {
Wizard_Cart.AddToCart(ATC_AddIfIn, ATC_RedirectIfIn, ATC_itemID, ATC_itemName, ATC_itemDescription, ATC_itemWeight, ATC_itemQuantity, ATC_itemPrice);
if (ATC_RedirectAfter != "" && Wizard_Cart_redirStr == ""

{
Wizard_Cart_redirStr = ATC_RedirectAfter;
}
Session("WAEC_ContinueRedirect"

= String(Request.ServerVariables("Script_Name"

) + "?" + String(Request.QueryString());
}
}
%>
<%
// WA eCart Redirect
if (Wizard_Cart_redirStr != ""

{
Response.Redirect(Wizard_Cart_redirStr);
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "www.w3.org/TR/html4/loose.dtd">
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
function DoCurrency(str, nDigitsAfterDecimal, nLeadingDigit, nUseParensForNeg, nGroupDigits)
DoCurrency = FormatCurrency(str, nDigitsAfterDecimal, nLeadingDigit, nUseParensForNeg, nGroupDigits)
End Function
</SCRIPT>
<html>
<head>
<title>Wizard - Your Quality Office Products Supplier                     </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META name="Wizard.ie" content="Your Quality Office Products Supplier.">
<meta name="description" content="Wizard - Your Quality Office Products Supplier. Ireland's Premier Office Products Supplier.">
<meta name="keywords" content="wizard, office supplies, stationery, stationary, online ordering, online catalogue, safety & hygiene, pc media & accessories, postroom & packaging, quality office supplier, quality office products, clearance sale, special offers">
<meta name="Author" content="This site designed by Andy Bertaut for Wizard">
<meta name="Copyright" content="(C) 2006 Slevin-Group">
<style type="text/css">

</style>
<link href="../wiz.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">function mmLoadMenus() {
if (window.mm_menu_0103133907_0) return;
window.mm_menu_0103133907_0 = new Menu("root",181,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103133907_0.addMenuItem("Adhesives & Tapes","location='../asp/adhesives_tapes.asp'"

;
mm_menu_0103133907_0.addMenuItem("Artist & Graphic Supplies","location='../asp/artist_graphic.asp'"

;
mm_menu_0103133907_0.addMenuItem("Bespoke Printing","location='../asp/bespoke_print.asp'"

;
mm_menu_0103133907_0.addMenuItem("Books & Pads","location='../asp/books_pads.asp'"

;
mm_menu_0103133907_0.addMenuItem("Catering","location='../asp/catering.asp'"

;
mm_menu_0103133907_0.addMenuItem("Computer Accessories","location='../asp/computer_accessories.asp'"

;
mm_menu_0103133907_0.addMenuItem("Computer Hardware","location='../asp/computer_hardware.asp'"

;
mm_menu_0103133907_0.addMenuItem("Computer Media Supplies","location='../asp/computer_media_sup.asp'"

;
mm_menu_0103133907_0.fontWeight="bold";
mm_menu_0103133907_0.hideOnMouseOut=true;
mm_menu_0103133907_0.bgColor='#6A63CB';
mm_menu_0103133907_0.menuBorder=1;
mm_menu_0103133907_0.menuLiteBgColor='#6A63CB';
mm_menu_0103133907_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103151900_0 = new Menu("root",172,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103151900_0.addMenuItem("Desktop Accessories","location='../asp/desktop_accessories.asp'"

;
mm_menu_0103151900_0.addMenuItem("Envelopes","location='../asp/envelopes.asp'"

;
mm_menu_0103151900_0.addMenuItem("Files, Pockets & Binding","location='../asp/files_pockets_bind.asp'"

;
mm_menu_0103151900_0.addMenuItem("Furniture","location='../asp/furniture.asp'"

;
mm_menu_0103151900_0.fontWeight="bold";
mm_menu_0103151900_0.hideOnMouseOut=true;
mm_menu_0103151900_0.bgColor='#6A63CB';
mm_menu_0103151900_0.menuBorder=1;
mm_menu_0103151900_0.menuLiteBgColor='#6A63CB';
mm_menu_0103151900_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152132_0 = new Menu("root",182,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152132_0.addMenuItem("Janitorial","location='../asp/janitorial.asp'"

;
mm_menu_0103152132_0.addMenuItem("Labels","location='../asp/labels.asp'"

;
mm_menu_0103152132_0.addMenuItem("Legal & Personal Supplies","location='../asp/legal_personal.asp'"

;
mm_menu_0103152132_0.fontWeight="bold";
mm_menu_0103152132_0.hideOnMouseOut=true;
mm_menu_0103152132_0.bgColor='#6A63CB';
mm_menu_0103152132_0.menuBorder=1;
mm_menu_0103152132_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152132_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152215_0 = new Menu("root",170,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152215_0.addMenuItem("Mailroom Warehouse","location='../asp/mailroom_warehouse.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Envirnoment","location='../asp/office_env.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Machine Supplies","location='../asp/office _mach_supp.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Machines","location='../asp/office _mach.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Planning","location='../asp/office_planning.asp'"

;
mm_menu_0103152215_0.fontWeight="bold";
mm_menu_0103152215_0.hideOnMouseOut=true;
mm_menu_0103152215_0.bgColor='#6A63CB';
mm_menu_0103152215_0.menuBorder=1;
mm_menu_0103152215_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152215_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152326_0 = new Menu("root",221,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152326_0.addMenuItem("Paper","location='../asp/paper.asp'"

;
mm_menu_0103152326_0.addMenuItem("Personal Planning & Accessories","location='../asp/personal_plan_acc.asp'"

;
mm_menu_0103152326_0.addMenuItem("Presentation Equipment","location='../asp/presentation_equip.asp'"

;
mm_menu_0103152326_0.addMenuItem("Presentation Supplies","location='../asp/presentation_supp.asp'"

;
mm_menu_0103152326_0.addMenuItem("Printer/Fax/Copier/WP Supplies","location='../asp/printer_copier.asp'"

;
mm_menu_0103152326_0.fontWeight="bold";
mm_menu_0103152326_0.hideOnMouseOut=true;
mm_menu_0103152326_0.bgColor='#6A63CB';
mm_menu_0103152326_0.menuBorder=1;
mm_menu_0103152326_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152326_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152527_0 = new Menu("root",129,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152527_0.addMenuItem("Safety & Security","location='../asp/safety_sec.asp'"

;
mm_menu_0103152527_0.fontWeight="bold";
mm_menu_0103152527_0.hideOnMouseOut=true;
mm_menu_0103152527_0.bgColor='#6A63CB';
mm_menu_0103152527_0.menuBorder=1;
mm_menu_0103152527_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152527_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152559_0 = new Menu("root",159,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152559_0.addMenuItem("Wall & Notice Boards","location='../asp/wall_notice.asp'"

;
mm_menu_0103152559_0.addMenuItem("Writing Supplies","location='../asp/writing_supp.asp'"

;
mm_menu_0103152559_0.fontWeight="bold";
mm_menu_0103152559_0.hideOnMouseOut=true;
mm_menu_0103152559_0.bgColor='#6A63CB';
mm_menu_0103152559_0.menuBorder=1;
mm_menu_0103152559_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152559_0.menuBorderBgColor='#6A63CB';

window.mm_menu_0109142338_0 = new Menu("root",100,17,"Verdana, Arial, Helvetica, sans-serif",11,"#059EB0","#036A76","#E7EBEC","#FFFFFF","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0109142338_0.addMenuItem("No Products"

;
mm_menu_0109142338_0.fontWeight="bold";
mm_menu_0109142338_0.hideOnMouseOut=true;
mm_menu_0109142338_0.bgColor='#CCCCCC';
mm_menu_0109142338_0.menuBorder=1;
mm_menu_0109142338_0.menuLiteBgColor='#FFFFFF';
mm_menu_0109142338_0.menuBorderBgColor='#079DAE';

mm_menu_0109142338_0.writeMenus();
} // mmLoadMenus()

function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#"

!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--

function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape"

&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);

function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"

)>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function tmt_compareField(f1,f2,rule,errorMsg){ var myErr = ""; if(eval("MM_findObj('"+f1+"').value"+rule+"MM_findObj('"+f2+"').value"

){ alert(unescape(errorMsg));myErr += 'errorMsg';} document.MM_returnValue = (myErr == ""

;}
//-->
</script>
<style type="text/css">

</style>
<script language="JavaScript" src="../mm_menu.js"></script>
</head>

<body>
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100" valign="top" bgcolor="#3C349C"> </td>
<td width="375" align="left" valign="top"><img src="../images/banner_lrg.gif" alt="Wizard - Your Quality Office Products Supplier!" width="375" height="77"></td>
<td width="282" align="left" valign="top"><img src="../images/logo.gif" alt="Wizard - Your Quality Office Products Supplier" width="282" height="77"></td>
<td align="left" valign="middle" style="filter<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>rogid

XImageTransform.Microsoft.Gradient(startColorstr='#FCEE04', endColorstr='#FFFFFF', gradientType='1');" >
<table width="281" height="53" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" rowspan="2" valign="bottom"><div align="right"></div>
<div align="left"></div> <div align="right"></div> <div align="right"></div></td>
<td width="156" rowspan="2" valign="top"><div align="right"></div> <div align="right"><a href="shopping_cart.asp"><img src="../images/cart.gif" alt="View Cart and Checkout" width="150" height="50" border="0"></a></div> <div align="right"></div></td>
<td width="46" height="27" align="center" valign="middle"><div align="right"></div></td>
</tr>
<tr>
<td width="46" align="center" valign="middle"><div align="right"> </div></td>
</tr>
</table>
</td>
</tr>
</table>
<br/>
<table width="990" height="615" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="170" height="10" valign="top"> </td>
<td width="820" height="10" valign="top"> </td>
</tr>
<tr>
<td width="170" height="539" valign="bottom">

<div id="navdiv">
<ul>
<li>
<div align="center"><a href="#" class="style1">Product Index </a></div>
</li>
<li>
<div align="center"><a href="#" name="link17" id="link1" onMouseOver="MM_showMenu(window.mm_menu_0103133907_0,116,0,null,'link17')" onMouseOut="MM_startTimeout();">A - C</a></div>
</li>
<li>
<div align="center"><a href="#" name="link14" id="link3" onMouseOver="MM_showMenu(window.mm_menu_0103151900_0,116,0,null,'link14')" onMouseOut="MM_startTimeout();">D - F</a></div>
</li>
<li>
<div align="center"><a href="#" name="link4" id="link12" onMouseOver="MM_showMenu(window.mm_menu_0109142338_0,116,0,null,'link4')" onMouseOut="MM_startTimeout();">G - I</a></div>
</li>
<li>
<div align="center"><a href="#" name="link2" id="link5" onMouseOver="MM_showMenu(window.mm_menu_0103152132_0,116,0,null,'link2')" onMouseOut="MM_startTimeout();">J - L</a></div>
</li>
<li>
<div align="center"><a href="#" name="link15" id="link7" onMouseOver="MM_showMenu(window.mm_menu_0103152215_0,116,0,null,'link15')" onMouseOut="MM_startTimeout();">M - O</a></div>
</li>
<li>
<div align="center"><a href="#" name="link6" id="link9" onMouseOver="MM_showMenu(window.mm_menu_0103152326_0,116,0,null,'link6')" onMouseOut="MM_startTimeout();">P - R</a></div>
</li>
<li>
<div align="center"><a href="#" name="link8" id="link11" onMouseOver="MM_showMenu(window.mm_menu_0103152527_0,116,0,null,'link8')" onMouseOut="MM_startTimeout();">S - U</a></div>
</li>
<li>
<div align="center"><a href="#" name="link10" id="link13" onMouseOver="MM_showMenu(window.mm_menu_0103152559_0,116,0,null,'link10')" onMouseOut="MM_startTimeout();">V - Z</a></div>
</li>
<li><a href="#"></a></li>
<li>
<div align="center"><a href="quick_order.asp">Quick Order</a></div>
</li>
<li>
<div align="center"><a href="terms_conditions.asp" class="style2">Terms & Conditions</a></div>
</li>
</ul>
</div>

</td>
<td align="left" valign="top">
<% if (!rsPAPERA34.EOF || !rsPAPERA34.BOF) { %>
<% while ((Repeat1__numRows-- != 0) && (!rsPAPERA34.EOF)) { %>
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" rowspan="4"><img src="<%=(rsPAPERA34.Fields.Item("Expr1"

.Value)%>" width="80" height="80"></td>
<td colspan="4" class="buttonstyle"><%=(rsPAPERA34.Fields.Item("Description"

.Value)%></td>
<td> </td>
</tr>
<tr id="maintbl">
<td width="100">Product Code </td>
<td width="100"><%=(rsPAPERA34.Fields.Item("ProductCode"

.Value)%></td>
<td width="100">Price</td>
<td width="100"><%= DoCurrency((rsPAPERA34.Fields.Item("Expr2"

.Value), 2, -2, -2, -2) %></td>
<td width="170"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td colspan="2"><form name="Wizard_Cart_1_ATC_<%=rsPAPERA34.Fields("ProductCode"

.value%>" method="POST" action="<%=String(Request.ServerVariables("SCRIPT_NAME"

)%><%=((String(Request.ServerVariables("QUERY_STRING"

) != "undefined" && Request.ServerVariables("QUERY_STRING"

!= ""

?"?"+Request.ServerVariables("QUERY_STRING"

:""

%>">
<input type="hidden" name="Wizard_Cart_1_ID_Add" value="<%=rsPAPERA34.Fields("ProductCode"

.value%>" >
<input type="text" name="Wizard_Cart_1_Quantity_Add" value="1" size="4" >
<input type="submit" value="Add To Cart" name="Wizard_Cart_1_ATC">
</form></td>
</tr>
</table>
<%
Repeat1__index++;
rsPAPERA34.MoveNext();
}
%>
<% } // end !rsPAPERA34.EOF || !rsPAPERA34.BOF %>
<br/>
<% while ((Repeat2__numRows-- != 0) && (!rsPAPERA34.EOF)) { %>
<% if (!rsBOOKSACC.EOF || !rsBOOKSACC.BOF) { %>
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" rowspan="4"><img src="<%=(rsBOOKSACC.Fields.Item("Expr1"

.Value)%>" width="80" height="80"></td>
<td colspan="4" class="buttonstyle"><%=(rsBOOKSACC.Fields.Item("Description"

.Value)%></td>
<td width="170"> </td>
</tr>
<tr id="maintbl">
<td width="100">Product Code </td>
<td width="100"><%=(rsBOOKSACC.Fields.Item("ProductCode"

.Value)%></td>
<td width="100">Price</td>
<td width="100"><%= DoCurrency((rsBOOKSACC.Fields.Item("Expr2"

.Value), 2, -2, -2, -2) %></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td colspan="2"><form name="Wizard_Cart_2_ATC_<%=rsBOOKSACC.Fields("ProductCode"

.value%>" method="POST" action="<%=String(Request.ServerVariables("SCRIPT_NAME"

)%><%=((String(Request.ServerVariables("QUERY_STRING"

) != "undefined" && Request.ServerVariables("QUERY_STRING"

!= ""

?"?"+Request.ServerVariables("QUERY_STRING"

:""

%>">
<input type="hidden" name="Wizard_Cart_2_ID_Add" value="<%=rsBOOKSACC.Fields("ProductCode"

.value%>" >
<input type="text" name="Wizard_Cart_2_Quantity_Add" value="1" size="4" >
<input type="submit" value="Add To Cart" name="Wizard_Cart_2_ATC">
</form></td>
</tr>
</table>
<% } // end !rsBOOKSACC.EOF || !rsBOOKSACC.BOF %>
<%
Repeat2__index++;
rsPAPERA34.MoveNext();
}
%>
</td>
</tr>
<tr valign="bottom">
<td colspan="2">

<link href="../wiz.css" rel="stylesheet" type="text/css">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td height="1" bgcolor="#000000"><img src="../images/spacer.gif"></td
></tr>
<tr id="quicknav">
<td height="20" align="center" valign="middle" id="quicknav" style="color:white;"> <a href="default.asp" id="quicknav">Home</a> |  <a href="search.asp" id="quicknav">Search</a> |  <a href="category_list.asp" id="quicknav">Categories</a> |  <a href="shopping_cart.asp" id="quicknav">Shopping
Cart</a>  |  <a href="catalogue_request.asp" id="quicknav">Request
Catalogue</a>  | <a href="quick_order.asp" id="quicknav">Quick Order </a> | 
<a href="about_us.asp" target="_self" id="quicknav">About
Us</a> |  <a href="contact_us.asp" target="_self" id="quicknav">Contact Us</a> | <a href="mailto: ?subject=I%20Wish%20To%20Report%20An%20Error" id="quicknav">Report Error </a></td>
</tr>
<tr>
<td height="1" bgcolor="#000000"><img src="../images/spacer.gif"></td>
</tr>
<tr>
<td align="center" valign="top" class="smallboldfooter">©2005 Wizard
Direct  FREEPHONE: 1800 923 200   FREEFAX: 1800 923
400 <br>
</td>
</tr>
</table>

</td>
</tr>
</table>
<iframe src="file:///C|/Documents%20and%20Settings/abertaut/My%20Documents/My%20Webs/Wizard/asp/cart_prv.asp" name="preview" scrolling="yes" id="preview" style="position:absolute; left:3px; top:400px; width:165px; height:115px; z-index:1"> </iframe>
</body>
</html>
<%
rsPAPERA34.Close();
%>
<%
rsBOOKSACC.Close();
%>

Replies

Tom Theys

Replied 26 Jan 2006 17:29:31

26 Jan 2006 17:29:31 Tom Theys replied:

When I take a quick look at your code, you are using the wrong recordset for the repeat2

<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
rsPAPERA34_numRows += Repeat1__numRows;
%>
<%
var Repeat2__numRows = 10;
var Repeat2__index = 0;
rsPAPERA34_numRows += Repeat2__numRows;
%>

I think it needs to be

<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
rsPAPERA34_numRows += Repeat1__numRows;
%>
<%
var Repeat2__numRows = 10;
var Repeat2__index = 0;
rsBOOKSACC_numRows += Repeat2__numRows;
%>

Don't know for sure

Edited by - tothprod on 26 Jan 2006 17:35:20

andy bertaut

Replied 26 Jan 2006 18:47:48

26 Jan 2006 18:47:48 andy bertaut replied:

Hi Thom, thanks for the reply
i spotted that right after i posted and fixed it but it didnt change anything relatign to the problem. Thanks anyhoo.

andy bertaut

Replied 30 Jan 2006 10:57:53

30 Jan 2006 10:57:53 andy bertaut replied:

hasnt ANYone come across this? I am really up against the clock on this one......

Tom Theys

Replied 31 Jan 2006 13:49:14

31 Jan 2006 13:49:14 Tom Theys replied:

try this code, maybe you missed some code in the repeat region.

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>



<%
var rsPAPERA34__MMColParam = "1";
if (String(Request.QueryString("ProductCode"

) != "undefined" &&
String(Request.QueryString("ProductCode"

) != ""

{
rsPAPERA34__MMColParam = String(Request.QueryString("ProductCode"

);
}
%>
<%
var rsPAPERA34 = Server.CreateObject("ADODB.Recordset"

;
rsPAPERA34.ActiveConnection = MM_connWIZARD06_STRING;
rsPAPERA34.Source = "SELECT * FROM paper_a3_4 WHERE ProductCode = '"+ rsPAPERA34__MMColParam.replace(/'/g, "''"

) != "undefined" &&
String(Request.QueryString("ProductCode"

) != ""

{
rsBOOKSACC__MMColParam = String(Request.QueryString("ProductCode"

);
}
%>
<%
var rsBOOKSACC = Server.CreateObject("ADODB.Recordset"

;
rsBOOKSACC.ActiveConnection = MM_connWIZARD06_STRING;
rsBOOKSACC.Source = "SELECT * FROM books_accounts WHERE ProductCode = '"+ rsBOOKSACC__MMColParam.replace(/'/g, "''"

+ "'";
rsBOOKSACC.CursorType = 2;
rsBOOKSACC.CursorLocation = 3;
rsBOOKSACC.LockType = 1;
rsBOOKSACC.Open();
var rsBOOKSACC_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
rsPAPERA34_numRows += Repeat1__numRows;
%>
<%
var Repeat2__numRows = 10;
var Repeat2__index = 0;
rsBOOKSACC_numRows += Repeat2__numRows;
%>
<%
// WA eCart AddToCart
if (String(Request.Form("Wizard_Cart_1_ATC"

) != "undefined" || String(Request.Form("Wizard_Cart_1_ATC.x"

) != "undefined"

{
var ATC_itemID = String(Request.Form("Wizard_Cart_1_ID_Add"

.value) == String(ATC_itemID)) {
var ATC_itemName = "" + String((rsPAPERA34.Fields.Item("Description"

.Value)) + "";// column binding
var ATC_itemDescription = "";// column binding
var ATC_itemWeight = parseFloat("0"

;// column binding
var ATC_itemQuantity = "" + String(Request.Form("Wizard_Cart_1_Quantity_Add"

) + "";// column binding
var ATC_itemPrice = parseFloat("" + String((rsPAPERA34.Fields.Item("Expr2"

.Value)) + ""

{
Wizard_Cart_redirStr = ATC_RedirectAfter;
}
Session("WAEC_ContinueRedirect"

= String(Request.ServerVariables("Script_Name"

) + "?" + String(Request.QueryString());
}
}
%>
<%
// WA eCart AddToCart
if (String(Request.Form("Wizard_Cart_2_ATC"

) != "undefined" || String(Request.Form("Wizard_Cart_2_ATC.x"

) != "undefined"

{
var ATC_itemID = String(Request.Form("Wizard_Cart_2_ID_Add"

.value) == String(ATC_itemID)) {
var ATC_itemName = "" + String((rsBOOKSACC.Fields.Item("Description"

.Value)) + "";// column binding
var ATC_itemDescription = "";// column binding
var ATC_itemWeight = parseFloat("0"

;// column binding
var ATC_itemQuantity = "" + String(Request.Form("Wizard_Cart_2_Quantity_Add"

) + "";// column binding
var ATC_itemPrice = parseFloat("" + String((rsBOOKSACC.Fields.Item("Expr2"

.Value)) + ""

{
Wizard_Cart_redirStr = ATC_RedirectAfter;
}
Session("WAEC_ContinueRedirect"

= String(Request.ServerVariables("Script_Name"

) + "?" + String(Request.QueryString());
}
}
%>
<%
// WA eCart Redirect
if (Wizard_Cart_redirStr != ""

{
Response.Redirect(Wizard_Cart_redirStr);
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "www.w3.org/TR/html4/loose.dtd">
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
function DoCurrency(str, nDigitsAfterDecimal, nLeadingDigit, nUseParensForNeg, nGroupDigits)
DoCurrency = FormatCurrency(str, nDigitsAfterDecimal, nLeadingDigit, nUseParensForNeg, nGroupDigits)
End Function
</SCRIPT>
<html>
<head>
<title>Wizard - Your Quality Office Products Supplier </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META name="Wizard.ie" content="Your Quality Office Products Supplier.">
<meta name="description" content="Wizard - Your Quality Office Products Supplier. Ireland's Premier Office Products Supplier.">
<meta name="keywords" content="wizard, office supplies, stationery, stationary, online ordering, online catalogue, safety & hygiene, pc media & accessories, postroom & packaging, quality office supplier, quality office products, clearance sale, special offers">
<meta name="Author" content="This site designed by Andy Bertaut for Wizard">
<meta name="Copyright" content="(C) 2006 Slevin-Group">
<style type="text/css">

</style>
<link href="../wiz.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">function mmLoadMenus() {
if (window.mm_menu_0103133907_0) return;
window.mm_menu_0103133907_0 = new Menu("root",181,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103133907_0.addMenuItem("Adhesives & Tapes","location='../asp/adhesives_tapes.asp'"

;
mm_menu_0103133907_0.addMenuItem("Artist & Graphic Supplies","location='../asp/artist_graphic.asp'"

;
mm_menu_0103133907_0.addMenuItem("Bespoke Printing","location='../asp/bespoke_print.asp'"

;
mm_menu_0103133907_0.addMenuItem("Books & Pads","location='../asp/books_pads.asp'"

;
mm_menu_0103133907_0.addMenuItem("Catering","location='../asp/catering.asp'"

;
mm_menu_0103133907_0.addMenuItem("Computer Accessories","location='../asp/computer_accessories.asp'"

;
mm_menu_0103133907_0.addMenuItem("Computer Hardware","location='../asp/computer_hardware.asp'"

;
mm_menu_0103133907_0.addMenuItem("Computer Media Supplies","location='../asp/computer_media_sup.asp'"

;
mm_menu_0103133907_0.fontWeight="bold";
mm_menu_0103133907_0.hideOnMouseOut=true;
mm_menu_0103133907_0.bgColor='#6A63CB';
mm_menu_0103133907_0.menuBorder=1;
mm_menu_0103133907_0.menuLiteBgColor='#6A63CB';
mm_menu_0103133907_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103151900_0 = new Menu("root",172,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103151900_0.addMenuItem("Desktop Accessories","location='../asp/desktop_accessories.asp'"

;
mm_menu_0103151900_0.addMenuItem("Envelopes","location='../asp/envelopes.asp'"

;
mm_menu_0103151900_0.addMenuItem("Files, Pockets & Binding","location='../asp/files_pockets_bind.asp'"

;
mm_menu_0103151900_0.addMenuItem("Furniture","location='../asp/furniture.asp'"

;
mm_menu_0103152132_0.addMenuItem("Labels","location='../asp/labels.asp'"

;
mm_menu_0103152132_0.addMenuItem("Legal & Personal Supplies","location='../asp/legal_personal.asp'"

;
mm_menu_0103152132_0.fontWeight="bold";
mm_menu_0103152132_0.hideOnMouseOut=true;
mm_menu_0103152132_0.bgColor='#6A63CB';
mm_menu_0103152132_0.menuBorder=1;
mm_menu_0103152132_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152132_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152215_0 = new Menu("root",170,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152215_0.addMenuItem("Mailroom Warehouse","location='../asp/mailroom_warehouse.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Envirnoment","location='../asp/office_env.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Machine Supplies","location='../asp/office _mach_supp.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Machines","location='../asp/office _mach.asp'"

;
mm_menu_0103152215_0.addMenuItem("Office Planning","location='../asp/office_planning.asp'"

;
mm_menu_0103152326_0.addMenuItem("Personal Planning & Accessories","location='../asp/personal_plan_acc.asp'"

;
mm_menu_0103152326_0.addMenuItem("Presentation Equipment","location='../asp/presentation_equip.asp'"

;
mm_menu_0103152326_0.addMenuItem("Presentation Supplies","location='../asp/presentation_supp.asp'"

;
mm_menu_0103152326_0.addMenuItem("Printer/Fax/Copier/WP Supplies","location='../asp/printer_copier.asp'"

;
mm_menu_0103152527_0.fontWeight="bold";
mm_menu_0103152527_0.hideOnMouseOut=true;
mm_menu_0103152527_0.bgColor='#6A63CB';
mm_menu_0103152527_0.menuBorder=1;
mm_menu_0103152527_0.menuLiteBgColor='#6A63CB';
mm_menu_0103152527_0.menuBorderBgColor='#6A63CB';
window.mm_menu_0103152559_0 = new Menu("root",159,17,"Verdana, Arial, Helvetica, sans-serif",11,"#FCEE04","#FFFFFF","#3C349C","#6A63CB","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0103152559_0.addMenuItem("Wall & Notice Boards","location='../asp/wall_notice.asp'"

;
mm_menu_0103152559_0.addMenuItem("Writing Supplies","location='../asp/writing_supp.asp'"

){ alert(unescape(errorMsg));myErr += 'errorMsg';} document.MM_returnValue = (myErr == ""

;}
//-->
</script>
<style type="text/css">

</style>
<script language="JavaScript" src="../mm_menu.js"></script>
</head>

<body>
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100" valign="top" bgcolor="#3C349C"> </td>
<td width="375" align="left" valign="top"><img src="../images/banner_lrg.gif" alt="Wizard - Your Quality Office Products Supplier!" width="375" height="77"></td>
<td width="282" align="left" valign="top"><img src="../images/logo.gif" alt="Wizard - Your Quality Office Products Supplier" width="282" height="77"></td>
<td align="left" valign="middle" style="filterrogid

XImageTransform.Microsoft.Gradient(startColorstr='#FCEE04', endColorstr='#FFFFFF', gradientType='1');" >
<table width="281" height="53" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" rowspan="2" valign="bottom"><div align="right"></div>
<div align="left"></div> <div align="right"></div> <div align="right"></div></td>
<td width="156" rowspan="2" valign="top"><div align="right"></div> <div align="right"><a href="shopping_cart.asp"><img src="../images/cart.gif" alt="View Cart and Checkout" width="150" height="50" border="0"></a></div> <div align="right"></div></td>
<td width="46" height="27" align="center" valign="middle"><div align="right"></div></td>
</tr>
<tr>
<td width="46" align="center" valign="middle"><div align="right"> </div></td>
</tr>
</table>
</td>
</tr>
</table>
<br/>
<table width="990" height="615" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="170" height="10" valign="top"> </td>
<td width="820" height="10" valign="top"> </td>
</tr>
<tr>
<td width="170" height="539" valign="bottom">

<div id="navdiv">
<ul>
<li>
<div align="center"><a href="#" class="style1">Product Index </a></div>
</li>
<li>
<div align="center"><a href="#" name="link17" id="link1" onMouseOver="MM_showMenu(window.mm_menu_0103133907_0,116,0,null,'link17')" onMouseOut="MM_startTimeout();">A - C</a></div>
</li>
<li>
<div align="center"><a href="#" name="link14" id="link3" onMouseOver="MM_showMenu(window.mm_menu_0103151900_0,116,0,null,'link14')" onMouseOut="MM_startTimeout();">D - F</a></div>
</li>
<li>
<div align="center"><a href="#" name="link4" id="link12" onMouseOver="MM_showMenu(window.mm_menu_0109142338_0,116,0,null,'link4')" onMouseOut="MM_startTimeout();">G - I</a></div>
</li>
<li>
<div align="center"><a href="#" name="link2" id="link5" onMouseOver="MM_showMenu(window.mm_menu_0103152132_0,116,0,null,'link2')" onMouseOut="MM_startTimeout();">J - L</a></div>
</li>
<li>
<div align="center"><a href="#" name="link15" id="link7" onMouseOver="MM_showMenu(window.mm_menu_0103152215_0,116,0,null,'link15')" onMouseOut="MM_startTimeout();">M - O</a></div>
</li>
<li>
<div align="center"><a href="#" name="link6" id="link9" onMouseOver="MM_showMenu(window.mm_menu_0103152326_0,116,0,null,'link6')" onMouseOut="MM_startTimeout();">P - R</a></div>
</li>
<li>
<div align="center"><a href="#" name="link8" id="link11" onMouseOver="MM_showMenu(window.mm_menu_0103152527_0,116,0,null,'link8')" onMouseOut="MM_startTimeout();">S - U</a></div>
</li>
<li>
<div align="center"><a href="#" name="link10" id="link13" onMouseOver="MM_showMenu(window.mm_menu_0103152559_0,116,0,null,'link10')" onMouseOut="MM_startTimeout();">V - Z</a></div>
</li>
<li><a href="#"></a></li>
<li>
<div align="center"><a href="quick_order.asp">Quick Order</a></div>
</li>
<li>
<div align="center"><a href="terms_conditions.asp" class="style2">Terms & Conditions</a></div>
</li>
</ul>
</div>

</td>
<td align="left" valign="top">
<% if (!rsPAPERA34.EOF || !rsPAPERA34.BOF) { %>
<% while ((Repeat1__numRows-- != 0) && (!rsPAPERA34.EOF)) { %>
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" rowspan="4"><img src="<%=(rsPAPERA34.Fields.Item("Expr1"

.Value)%>" width="80" height="80"></td>
<td colspan="4" class="buttonstyle"><%=(rsPAPERA34.Fields.Item("Description"

.Value)%></td>
<td> </td>
</tr>
<tr id="maintbl">
<td width="100">Product Code </td>
<td width="100"><%=(rsPAPERA34.Fields.Item("ProductCode"

.Value)%></td>
<td width="100">Price</td>
<td width="100"><%= DoCurrency((rsPAPERA34.Fields.Item("Expr2"

.Value), 2, -2, -2, -2) %></td>
<td width="170"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td colspan="2"><form name="Wizard_Cart_1_ATC_<%=rsPAPERA34.Fields("ProductCode"

.value%>" method="POST" action="<%=String(Request.ServerVariables("SCRIPT_NAME"

)%><%=((String(Request.ServerVariables("QUERY_STRING"

) != "undefined" && Request.ServerVariables("QUERY_STRING"

!= ""

?"?"+Request.ServerVariables("QUERY_STRING"

:""

%>">
<input type="hidden" name="Wizard_Cart_1_ID_Add" value="<%=rsPAPERA34.Fields("ProductCode"

.value%>" >
<input type="text" name="Wizard_Cart_1_Quantity_Add" value="1" size="4" >
<input type="submit" value="Add To Cart" name="Wizard_Cart_1_ATC">
</form></td>
</tr>
</table>
<%
Repeat1__index++;
rsPAPERA34.MoveNext();
}
%>
<% } // end !rsPAPERA34.EOF || !rsPAPERA34.BOF %>
<br/>
<% while ((Repeat2__numRows-- != 0) && (!rsBOOKSACC.EOF)) { %>
<% if (!rsBOOKSACC.EOF || !rsBOOKSACC.BOF) { %>
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" rowspan="4"><img src="<%=(rsBOOKSACC.Fields.Item("Expr1"

.Value)%>" width="80" height="80"></td>
<td colspan="4" class="buttonstyle"><%=(rsBOOKSACC.Fields.Item("Description"

.Value)%></td>
<td width="170"> </td>
</tr>
<tr id="maintbl">
<td width="100">Product Code </td>
<td width="100"><%=(rsBOOKSACC.Fields.Item("ProductCode"

.Value)%></td>
<td width="100">Price</td>
<td width="100"><%= DoCurrency((rsBOOKSACC.Fields.Item("Expr2"

.Value), 2, -2, -2, -2) %></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td colspan="2"><form name="Wizard_Cart_2_ATC_<%=rsBOOKSACC.Fields("ProductCode"

.value%>" method="POST" action="<%=String(Request.ServerVariables("SCRIPT_NAME"

)%><%=((String(Request.ServerVariables("QUERY_STRING"

) != "undefined" && Request.ServerVariables("QUERY_STRING"

!= ""

?"?"+Request.ServerVariables("QUERY_STRING"

:""

%>">
<input type="hidden" name="Wizard_Cart_2_ID_Add" value="<%=rsBOOKSACC.Fields("ProductCode"

.value%>" >
<input type="text" name="Wizard_Cart_2_Quantity_Add" value="1" size="4" >
<input type="submit" value="Add To Cart" name="Wizard_Cart_2_ATC">
</form></td>
</tr>
</table>
<% } // end !rsBOOKSACC.EOF || !rsBOOKSACC.BOF %>
<%
Repeat2__index++;
rsBOOKSACC.MoveNext();
}
%>
</td>
</tr>
<tr valign="bottom">
<td colspan="2">

<link href="../wiz.css" rel="stylesheet" type="text/css">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td height="1" bgcolor="#000000"><img src="../images/spacer.gif"></td
></tr>
<tr id="quicknav">
<td height="20" align="center" valign="middle" id="quicknav" style="color:white;"> <a href="default.asp" id="quicknav">Home</a> | <a href="search.asp" id="quicknav">Search</a> | <a href="category_list.asp" id="quicknav">Categories</a> | <a href="shopping_cart.asp" id="quicknav">Shopping
Cart</a> | <a href="catalogue_request.asp" id="quicknav">Request
Catalogue</a> | <a href="quick_order.asp" id="quicknav">Quick Order </a> |
<a href="about_us.asp" target="_self" id="quicknav">About
Us</a> | <a href="contact_us.asp" target="_self" id="quicknav">Contact Us</a> | <a href="mailto: ?subject=I%20Wish%20To%20Report%20An%20Error" id="quicknav">Report Error </a></td>
</tr>
<tr>
<td height="1" bgcolor="#000000"><img src="../images/spacer.gif"></td>
</tr>
<tr>
<td align="center" valign="top" class="smallboldfooter">©2005 Wizard
Direct FREEPHONE: 1800 923 200 FREEFAX: 1800 923
400 <br>
</td>
</tr>
</table>

</td>
</tr>
</table>
<iframe src="file:///C|/Documents%20and%20Settings/abertaut/My%20Documents/My%20Webs/Wizard/asp/cart_prv.asp" name="preview" scrolling="yes" id="preview" style="position:absolute; left:3px; top:400px; width:165px; height:115px; z-index:1"> </iframe>
</body>
</html>
<%
rsPAPERA34.Close();
%>
<%
rsBOOKSACC.Close();
%>

andy bertaut

Replied 01 Feb 2006 16:47:02

01 Feb 2006 16:47:02 andy bertaut replied:

Thanks Tom
Tired it, but while it does only show the correct set of results, the repeat region isn't happening.
Andy

Javier Castro

Replied 01 Feb 2006 17:09:59

01 Feb 2006 17:09:59 Javier Castro replied:

Perhaps its nothing but this doesn't seem right:

src="file:///C|/Documents%20and%20Settings/abertaut/My%20Documents/My%20Webs/Wizard/asp/cart_prv.asp"

if you are testing it on a server this source address may not work.

Cheers,
Javier

PS. sometimes it's only a period or coma, but affects the whole thing.

andy bertaut

Replied 02 Feb 2006 16:02:39

02 Feb 2006 16:02:39 andy bertaut replied:

hi
I had a look at that, its an iframe which for some reason keep sretaining the local address not the site relative one, but i have fixed it and it doesnt fix the problem. thanks anyway.

Reply to this topic

Latest Extensions

App Connect Summernote File Upload Upload different files in Summernote Editor
App Connect Summernote Simple, yet powerful and modern WYSIWYG Editor
Bootstrap 4 Dynamic Table Generator 2 Automatically generate dynamic data tables
Bootstrap 4 Dynamic Form Generator 2 Auto generate perfect Bootstrap 4 dynamic forms in seconds
App Connect Bootstrap 4 Dynamic Paging Generator Auto generate awesome dynamic Bootstrap 4 paging in seconds
App Connect Event Calendar The most powerful full-sized event calendar for Dreamweaver
DMXzone App Connect Next generation client side framework for data-driven web sites and apps
DMXzone Database Custom Query Create advanced, complex custom SQL queries with ease

Latest Videos

Using App Connect Autocomplete Learn how to add autocomplete functionality on your page, using the App Connect Autocomplete
Creating Custom SQL Queries Learn how to create custom SQL Queries with DMXzone Database Custom Query
Restricting Access to Your Pages Learn how to restrict access to your pages, using DMXzone Security Provider 2
Adding Log Out Functionality with DMXzone Security Provider 2 Learn how to add log out functionality to your page with DMXzone Security Provider 2
Creating a Log In Page with DMXzone Security Provider 2 Learn how to create a log in page with DMXzone Security Provider 2
Setting Up Site Security Settings Learn how to setup your site security, using DMXzone Security Provider 2
Generating an Update Record Form Learn how to create an update record form, using the Bootstrap 4 Dynamic Form Generator 2
Generating an Insert Record Form Learn how to create an insert record form, using the Bootstrap 4 Dynamic Form Generator 2