--=====================_24857699==_
Content-Type: text/plain; charset="us-ascii"; format=flowed
Greetings,
We host about 40 CF sites on a server and recently one of my client's form
submissions started causing Dr. Watson errors which stop the web server,
WebSite Pro. This is scary. We have a development server and have not been
able to duplicate the problem there.
The template in question is attached and contains a number of CFINCLUDEs
and lots of hidden fields within CFIFs. My client suspects that the problem
may have something to do with the hidden fields, which maintain the session
variables. I'm no longer a CF developer and I have never seen hidden fields
contained within CFIF tags before.
The form is submitted in a SSL state and the server is a dual PIII 550, 512
Mb RAM, three 18 Gb SCSI hard drives in a hardware RAID5 array, CF Pro
server 4.51, WebSite Pro 2.4.27, NT 4.0 SP 6a. The server also runs MS SQL
7.0, however, this site uses an Access datasource.
I will be installing Shilo's Website Stay Alive, however, I'd rather solve
the problem instead of addressing the symptoms. Any recommendations would
be much appreciated.
Thanks.
Alf
<CFCOOKIE NAME="Description" VALUE="#FORM.description#" EXPIRES=1>
<form action="save_listing.cfm?username=#member_info.username#" method="post">
<input type="hidden" name="memID" value="#cookie.memID#">
<input type="hidden" name="itemID" value="#URL.itemID#">
<input type="hidden" name="item" value="#form.item#">
<input type="hidden" name="catID" value="#cat_name.catID#">
<input type="hidden" name="qty" value="#qty#">
<input type="hidden" name="auction" value="#form.auction#">
<input type="hidden" name="price" value="#form.price#">
<cfif #form.auction# IS 1>
<input type="hidden" name="reserve_price" value="#form.reserve_price#"></cfif>
<input type="hidden" name="shipping" value="#form.shipping#">
<input type="hidden" name="pic_URL" value="#form.pic_URL#">
<input type="hidden" name="location" value="#form.location#">
<input type="hidden" name="ship_area" value="#form.ship_area#">
<input type="hidden" name="listfee" value="#listfee#">
<input type="hidden" name="date_expire" value="#date_expire#">
<cfif #parameterexists(form.pay1)# IS 1>
<input type="hidden" name="pay1" value="1">
</cfif>
<cfif #parameterexists(form.pay2)# IS 1>
<input type="hidden" name="pay2" value="1">
</cfif>
<cfif #parameterexists(form.pay3)# IS 1>
<input type="hidden" name="pay3" value="1">
</cfif>
<cfif #parameterexists(form.pay4)# IS 1>
<input type="hidden" name="pay4" value="1">
</cfif>
<cfif #parameterexists(form.pay5)# IS 1>
<input type="hidden" name="pay5" value="1">
</cfif>
<cfif #parameterexists(form.pay6)# IS 1>
<input type="hidden" name="pay6" value="1">
</cfif>
<cfif #parameterexists(form.pay7)# IS 1>
<input type="hidden" name="pay7" value="1">
</cfif>
<cfif #parameterexists(form.pay8)# IS 1>
<input type="hidden" name="pay8" value="1">
</cfif>
<cfif #parameterexists(form.main_feat)# IS 1>
<input type="hidden" name="main_feat" value="1">
</cfif>
<cfif #parameterexists(form.cat_feat)# IS 1>
<input type="hidden" name="cat_feat" value="1">
</cfif>
<cfif #parameterexists(form.bold_title)# IS 1>
<input type="hidden" name="bold_title" value="1">
</cfif>
<td align="center"><input type="submit" name="accept" value="ACCEPT
LISTING"> <input type="submit" name="edit" value="Edit Listing"
onclick="javascript:history.back()"></form>
--=====================_24857699==_
Content-Type: text/plain; charset="us-ascii"
Content-Disposition: attachment; filename="preview_item.cfm"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!--- BLANK FIELDS --->
<cfif #form.item# IS "" OR #form.description# IS "" OR #form.location# IS "" OR
#form.price# IS "">
<cfinclude template="blank_fields.cfm">
<cfabort>
<!--- MISSING OPTIONS --->
<cfelseif #parameterexists(form.pay1)# IS 0 AND #parameterexists(form.pay2)# IS 0 AND
#parameterexists(form.pay3)# IS 0 AND #parameterexists(form.pay4)# IS 0 AND
#parameterexists(form.pay5)# IS 0 AND #parameterexists(form.pay6)# IS 0 AND
#parameterexists(form.pay7)# IS 0 AND #parameterexists(form.pay8)# IS 0>
<cfinclude template="no_payment.cfm">
<cfabort>
<!--- CONFLICTING FEATURE OPTIONS --->
<cfelseif #parameterexists(form.main_feat)# IS "Yes" AND
#parameterexists(form.cat_feat)# IS "Yes">
<cfinclude template="feature_conflict.cfm">
<cfabort>
<!--- MISSING SHIPPING OPTIONS --->
<cfelseif #parameterexists(form.shipping)# IS "No">
<cfinclude template="no_ship.cfm">
<cfabort>
<!--- INCORRECT PICTURE URL --->
<cfelseif #form.pic_URL# IS NOT "http://" AND (#right(form.pic_URL, 4)# DOES NOT
CONTAIN ".jpg" AND #right(form.pic_URL, 4)# DOES NOT CONTAIN ".gif")>
<cfinclude template="pic_error.cfm">
<cfabort>
<!--- BEGIN ITEM PREVIEW --->
<cfelse>
<cfset memID = #form.memID#>
<cfset date_listed = Now()>
<cfif #form.auction# IS 1>
<cfset auction_dur = #form.auction_dur#>
<cfif #form.auction_dur# IS 1>
<cfset date_expire = Now()+5>
<cfelseif #form.auction_dur# IS 2>
<cfset date_expire = Now()+7>
<cfelseif #form.auction_dur# IS 3>
<cfset date_expire = Now()+10>
</cfif>
<cfset qty = '1'>
<cfelse>
<cfset date_expire = Now()+30>
</cfif>
<cfset qty = '#form.qty#'>
<html>
<head>
<title>jABOS.com - Item Listing Preview</title>
</head>
<cfset today = Now()>
<BODY marginheight="0" marginwidth="0" leftmargin="0" topmargin="0"
background="../images/listing_background.gif">
<table width="100%" cellspacing="0" cellpadding="0" border="0" height="100%">
<tr>
<!--- PAGE HEADER --->
<td valign="top">
<cfinclude template="../inc/items_page_header.cfm">
</td>
</tr>
<!--- END PAGE HEADER --->
<tr>
<td align="left" height="20"></td>
</tr>
<tr>
<td align="left" valign="top"><img src="../images/list_item.gif" width="450"
height="50" alt="" border="0">
<table align="left" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table align="left" width="100%" cellpadding="5" cellspacing="5">
<tr>
<td>
<table align="left" width="600" cellpadding="5" cellspacing="3">
<tr>
<td align="left">
<font face="Tahoma" size="2">Please review your item's listing carefully before
confirming it. You may go back and edit any part of the listing. If you are
satisfied with the preview of this listing, click the CONFIRM LISTING button at the
bottom of the page.</font>
</td>
</tr>
</table></td></tr>
<!--- BEGIN ITEM LISTING PREVIEW --->
<cfquery datasource="jabosmdb" name="cat_name">
SELECT * FROM categories
WHERE catID = #form.catID#
</cfquery>
<cfoutput>
<tr><td colspan="2" align="left">
<table align="center" width="100%" cellpadding="5" cellspacing="3">
<tr>
<td align="center" bgcolor="000000"><font face="Tahoma" size="4"
color="ffffff"><b>#form.item#</b></font><br><font face="Tahoma" size="2"
color="ffffff"><b>Item No.: 000000</b></font><br></td>
</tr>
<tr>
<td align="center"><font face="Tahoma" size="2"><b>Category:</font> <font
face="Tahoma" size="2" color="006633">#cat_name.category#</b></font></td>
</tr>
<tr>
<td align="center">
<!--- AUCTION LISTING HEADER --->
<cfif #form.auction# IS 1>
<table align="center" width="100%" cellpadding="2" cellspacing="1">
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2" color="006633"><b>Current
Price:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>$#NumberFormat(form.price, 'L_____.__')#</b></font> <cfif
#form.reserve_price# IS NOT ""><font size="1" face="Tahoma" color="red">(Reserve not
met)</font></cfif></td><td align="right" width="25%"><font face="Tahoma" size="2"
color="006633"><b>Opening Bid:</b></font></td><td align="left" width="25%"><font
size="2" face="Tahoma"><b>$#NumberFormat(form.price, 'L_____.__')#</b></font></td>
</tr>
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2" color="006633"><b>Bids
Placed:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>0</b></font></td>
<td align="right" width="25%"><font face="Tahoma" size="2"
color="006633"><b>Quantity:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#NumberFormat(qty, 99999)#</b></font></td></tr>
<tr>
<cfif #form.auction# IS 1>
<cfif #form.auction_dur# IS 1>
<cfset day_remain = 5>
<cfelseif #form.auction_dur# IS 2>
<cfset day_remain = 7>
<cfelseif #form.auction_dur# IS 3>
<cfset day_remain = 10>
</cfif>
<cfelse>
<cfset date_expire = Now()+30>
</cfif>
<td align="right" width="25%"><font face="Tahoma" size="2" color="006633"><b>Time
Remaining:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#day_remain# Days, 0 Hours</b></font></td><td align="right"
width="25%"><font face="Tahoma" size="2"
color="006633"><b>Location:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#form.location#</b></font></td></tr>
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2" color="006633"><b>Item
Listed:</b></font></td><td align="left" width="75%" colspan="3"><font size="2"
face="Tahoma">#DateFormat(date_listed, 'mm/dd/yy')# - #TimeFormat(date_listed,
'HH:mm:ss')# CST</font></td></tr><tr><td align="right" width="25%"><font face="Tahoma"
size="2" color="006633"><b>Auction Ends:</b></font></td><td align="left" width="75%"
colspan="3"><font size="2" face="Tahoma">#DateFormat(date_expire, 'mm/dd/yy')# -
#TimeFormat(date_expire, 'HH:mm:ss')# CST</font></td></tr>
</table>
<cfelse>
<!--- CLASSIFIED LISTING HEADER --->
<table align="center" width="100%" cellpadding="2" cellspacing="1">
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2"
color="006633"><b>Price:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#NumberFormat(form.price, 'L_____.__')# USD</b></font></td><td
align="right" width="25%"><font face="Tahoma" size="2" color="006633"><b>Sale
Ends:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#DateFormat(date_expire, 'mm/dd/yy')#</b></font></td>
</tr>
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2"
color="006633"><b>Quantity:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#NumberFormat(qty, 9999)#</b></font></td><td align="right"
width="25%"><font face="Tahoma" size="2"
color="006633"><b>Location:</b></font></td><td align="left" width="25%"><font size="2"
face="Tahoma"><b>#form.location#</b></font></td></tr>
</table>
</cfif>
</td></tr>
<!--- BASIC INFORMATION --->
<cfquery datasource="jabosmdb" name="member_info">
SELECT * FROM members
WHERE memID = #cookie.memID#
</cfquery>
<tr>
<td align="center">
<table align="center" width="100%" cellpadding="2" cellspacing="1">
<tr>
<td align="right" width="25%" valign="top"><font face="Tahoma" size="2"
color="006633"><b>Seller (Rating):</b></font></td><td align="left" width="75%"
valign="top"><font size="2" face="Tahoma"><b>#member_info.username#
(#NumberFormat(member_info.rating, '99.99')#)</b></font><br><font size="1"
face="Tahoma" color="006633">Email Seller with Questions<br>View Seller's Other
Listings<br>View Comments in Seller's Rating Feedback<br></font></td></tr>
<tr>
<cfif #form.auction# IS 1>
<td align="right" width="25%" valign="top"><font face="Tahoma" size="2"
color="006633"><b>High Bidder (Rating):</b></font></td><td align="left" width="75%"
valign="top"><font size="2" face="Tahoma"><b>None</b></font></td></tr></cfif>
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2" color="006633"><b>Payment
Accepted:</b></font></td><td align="left" width="75%"><font size="2"
face="Tahoma"><cfif #parameterexists(form.pay1)# IS 1>Check/Money Order. </cfif><cfif
#parameterexists(form.pay2)# IS 1>COD. </cfif><cfif #parameterexists(form.pay3)# IS
1>VISA. </cfif><cfif #parameterexists(form.pay4)# IS 1>MasterCard. </cfif><cfif
#parameterexists(form.pay5)# IS 1>American Express. </cfif><cfif
#parameterexists(form.pay6)# IS 1>Discover. </cfif><cfif #parameterexists(form.pay7)#
IS 1>iEscrow. <br></cfif><cfif #parameterexists(form.pay8)# IS 1>See item
description.</cfif></font></td></tr>
<tr>
<td align="right" width="25%"><font face="Tahoma" size="2"
color="006633"><b>Shipping:</b></font></td><td align="left" width="75%"><font size="2"
face="Tahoma">#form.shipping#. #form.ship_area#.</font></td></tr></table></td></tr>
<tr>
<td colspan="2" align="center" bgcolor="000000"><font face="Tahoma" size="4"
color="ffffff"><b>Item Description</b></font></td>
</tr>
</table>
</td></tr>
<tr>
<td>
<!--- ITEM DESCRIPTION & IMAGE --->
<table align="center" width="100%" cellpadding="5" cellspacing="3">
<tr>
<td align="left">
<table align="center" width="100%" cellpadding="2" cellspacing="1">
<tr>
<td align="left"><font face="Tahoma" size="2">#form.description#</font><p></td></tr>
<cfif #form.pic_url# IS NOT "http://"><tr>
<td align="center">
<img src="#form.pic_URL#" border="0" alt="">
</td>
</tr></cfif>
</table></td>
</tr>
</table></td>
</tr>
<!--- END ITEM DESCRIPTION & IMAGE --->
</td>
</tr>
<tr>
<td>
<!--- ITEM LISTING FEES AND CONFIRMATION --->
<table align="left" width="100%" cellpadding="3" cellspacing="1">
<tr>
<td align="center" bgcolor="000000"><font face="Tahoma" size="4"
color="ffffff"><b>Listing Confirmation</b></font></td></tr>
<tr>
<td align="left">
<font face="Tahoma" size="2" color="006633"><b>If this listing is satisfactory to you,
review your listing fees, if any, and click the ACCEPT LISTING button below.<p>If you
need to edit this listing, click the EDIT LISTING button to go back and make any
necessary changes.</b></font>
</td>
</tr>
<tr>
<td align="center">
<table align="center" width="250" cellpadding="3" cellspacing="0">
<tr>
<td align="center" bgcolor="000000" colspan="2"><font face="Tahoma" size="2"
color="ffffff"><b>Listing Fees</b></font></td></tr>
<tr>
<td align="right" width="65%"><font face="Tahoma" size="2" color="006633"><b>Standard
Listing:</b></font></td><td align="right" width="35%"><font face="Tahoma" size="2"
color="red"><b>FREE</b></font></td></tr>
<cfset listfee = 0>
<cfif #parameterexists(form.bold_title)# IS "Yes">
<cfset listfee = #listfee# + 2>
<tr>
<td align="right" width="65%"><font face="Tahoma" size="2" color="006633"><b>Bold
Title:</b></font></td><td align="right" width="35%"><font face="Tahoma" size="2"
color="red"><b>$2.00</b></font></td></tr>
</cfif>
<cfif #parameterexists(form.main_feat)# IS "Yes">
<cfset listfee = #listfee# + 20>
<tr>
<td align="right" width="65%"><font face="Tahoma" size="2" color="006633"><b>Featured
- Main:</b></font></td><td align="right" width="35%"><font face="Tahoma" size="2"
color="red"><b>$20.00</b></font></td></tr>
</cfif>
<cfif #parameterexists(form.cat_feat)# IS "Yes">
<cfset listfee = #listfee# + 10>
<tr>
<td align="right" width="65%"><font face="Tahoma" size="2" color="006633"><b>Featured
- Category:</b></font></td><td align="right" width="35%"><font face="Tahoma" size="2"
color="red"><b>$10.00</b></font></td></tr>
</cfif>
<tr>
<td align="right" width="65%" bgcolor="d1d1d1"><font face="Tahoma" size="2"
color="006633"><b>TOTAL:</b></font></td><td align="right" width="35%"
bgcolor="d1d1d1"><font face="Tahoma" size="2"
color="000000"><b>$#Numberformat(listfee, 'L__.__')#</b></font></td></tr>
<cfif #listfee# GT 0>
<tr><td align="center" colspan="2"><font face="Tahoma" size="1" color="000000"><b>The
TOTAL amount above will be charged to your account when you accept this
listing.</b></font></td></tr></cfif>
</table>
</td></tr>
</table></td></tr>
<!--- END ITEM LISTING FEES AND CONFIRMATION --->
<tr>
<td>
<table align="left" width="100%" cellpadding="3" cellspacing="1">
<tr>
<CFCOOKIE NAME="Description" VALUE="#FORM.description#" EXPIRES=1>
<form action="save_listing.cfm?username=#member_info.username#" method="post">
<input type="hidden" name="memID" value="#cookie.memID#">
<input type="hidden" name="itemID" value="#URL.itemID#">
<input type="hidden" name="item" value="#form.item#">
<input type="hidden" name="catID" value="#cat_name.catID#">
<input type="hidden" name="qty" value="#qty#">
<input type="hidden" name="auction" value="#form.auction#">
<input type="hidden" name="price" value="#form.price#">
<cfif #form.auction# IS 1>
<input type="hidden" name="reserve_price" value="#form.reserve_price#"></cfif>
<input type="hidden" name="shipping" value="#form.shipping#">
<input type="hidden" name="pic_URL" value="#form.pic_URL#">
<input type="hidden" name="location" value="#form.location#">
<input type="hidden" name="ship_area" value="#form.ship_area#">
<input type="hidden" name="listfee" value="#listfee#">
<input type="hidden" name="date_expire" value="#date_expire#">
<cfif #parameterexists(form.pay1)# IS 1>
<input type="hidden" name="pay1" value="1">
</cfif>
<cfif #parameterexists(form.pay2)# IS 1>
<input type="hidden" name="pay2" value="1">
</cfif>
<cfif #parameterexists(form.pay3)# IS 1>
<input type="hidden" name="pay3" value="1">
</cfif>
<cfif #parameterexists(form.pay4)# IS 1>
<input type="hidden" name="pay4" value="1">
</cfif>
<cfif #parameterexists(form.pay5)# IS 1>
<input type="hidden" name="pay5" value="1">
</cfif>
<cfif #parameterexists(form.pay6)# IS 1>
<input type="hidden" name="pay6" value="1">
</cfif>
<cfif #parameterexists(form.pay7)# IS 1>
<input type="hidden" name="pay7" value="1">
</cfif>
<cfif #parameterexists(form.pay8)# IS 1>
<input type="hidden" name="pay8" value="1">
</cfif>
<cfif #parameterexists(form.main_feat)# IS 1>
<input type="hidden" name="main_feat" value="1">
</cfif>
<cfif #parameterexists(form.cat_feat)# IS 1>
<input type="hidden" name="cat_feat" value="1">
</cfif>
<cfif #parameterexists(form.bold_title)# IS 1>
<input type="hidden" name="bold_title" value="1">
</cfif>
<td align="center"><input type="submit" name="accept" value="ACCEPT
LISTING"> <input type="submit" name="edit" value="Edit Listing"
onclick="javascript:history.back()"></form>
</tr>
</table>
</td>
</tr>
</table>
</tr></td></cfoutput>
</table></td>
</tr>
<!--- PAGE BOTTOM --->
<tr>
<td colspan="2">
<cfinclude template="../inc/page_footer.cfm">
</td><td></td>
</tr>
</table></cfif>
</body>
</html>
--=====================_24857699==_
Content-Type: text/plain; charset="us-ascii"; format=flowed
Alf Gardner Bringing Commerce and
COMFLUENT the Internet Together
910 15th St., Suite 751 303.376.1600
Denver, Colorado 80202 USA 303.376.1601 fax
[EMAIL PROTECTED] http://www.comfluent.net
--=====================_24857699==_--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
