more CFIF help please

hi all, i had some help yesterday with a CFIF statement that placed a standard image in my cart if an image was available for a particular product. so instead of seeing a horrible mess where an image should be the user see a 'sorry no image avialable' image.

i'm trying to do the same thing except this time on a different page.

my shoppng cart 'product' page uses this to display the image and then opens a new window if the image is clicked on.

the code that fixed this last time for me was:
<a href="../product/#product.fileName#" >
<cfif fileexists ("D:\inetpub\wwwroot\mydomain\wwwroot\#product.mediaPath##product.thumbnail#")>
<img src="#product.mediaPath##product.thumbnail#" alt="#HTMLEditFormat(product.metaTitle)#"  />
<cfelse>
<img src="../../media/product/defaultimage.jpg" alt="#HTMLEditFormat(product.metaTitle)#"  />
</cfif>
</a>

if i use the above code on this new page it works until i click on the image and the new pop up window opens then it displays an error:

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.  
 
 
The error occurred in D:\inetpub\wwwroot\mydomain\wwwroot\mediaviewer.cfm: line 37
 
35 :             SELECT fileName, type, thumbnail, title, buildDate, editDate, status, '/media/product/' + dbo.GetDirectory(productID, '/') + '/' AS mediaPath
36 :             FROM #request.mediaTable#
37 :             WHERE mediaID = <cfqueryparam value="#url.mediaID#" cfsqltype="CF_SQL_INTEGER">
38 :       </cfquery>
39 :       <table width="100%" cellpadding="20">
 



thank you in advance.

zac

Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

<!--- Display Page Image --->
 
<cfoutput>
<cfif (getMedia.fileName Is 0) OR (getMedia.fileName Is "")>
No Image Avaialble
<cfelse>
<cfif getDetailMedia.fileName Neq 0>
<a href="../mediaviewer.cfm?mediaID=#getDetailMedia.mediaID#&productID=#variables.productID#" rel="popup standard 600 600 noicon">
<img src="#getProduct.mediaPath##getMedia.fileName#" alt="#urlencodedformat(getProduct.title)#" /></a>
<cfelse>
<img src="#getProduct.mediaPath##getMedia.fileName#" alt="#urlencodedformat(getProduct.title)#" />
</cfif>
</cfif>
                
</cfoutput>
</span>
</div>
<cfoutput>
<cfif getDetailMedia.fileName Neq 0>
<p>
<a href="../mediaviewer.cfm?mediaID=#getDetailMedia.mediaID#" rel="popup console 600 600 noicon" class="detailed-view">Detailed View</a>
</p>
</cfif>
</cfoutput>