I can not seem to get the code below to work inside a CFC tag. I put it on a
page all by itself and it runs fine. But when I run it as a CFC I get an error,
and openBD doesn't record the error that it is. I just get this message in
firebug
<html><head><title>Apache Tomcat/7.0.23 - Error report</title><style><!--H1
{font-family:Tahoma,Arial
,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2
{font-family:Tahoma,Arial,sans-serif
;color:white;background-color:#525D76;font-size:16px;} H3
{font-family:Tahoma,Arial,sans-serif;color
:white;background-color:#525D76;font-size:14px;} BODY
{font-family:Tahoma,Arial,sans-serif;color:black ;background-color:white;} B
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76 ;} P
{font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
{color : black ;}A.name {color : black;}HR {color : #525D76;}--></style>
</head><body><h1>HTTP Status 500 - General Runtime Error</h1><HR size="1"
noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>General
Runtime Error</u></p><p><b>description</b> <u>The server encountered an
internal error (General Runtime Error) that prevented it from fulfilling this
request.</u></p><HR size="1" noshade="noshade" ><h3>Apache
Tomcat/7.0.23</h3></body></html>
<cfset currentDirectory = GetDirectoryFromPath(GetTemplatePath())>
<cfset charLen = Len(currentDirectory)>
<cfset cutOff = charLen - 5>
<cfset currentDirectory = Left(currentDirectory, cutOff)>
<cfset currentDirectory = Replace("#currentDirectory#","\","/","all") >
<cfset rootDirectory = currentDirectory >
<cfset imageDir = #currentDirectory# & "/images/products">
<cfset upcDir = #currentDirectory# & "/images/upc">
<cfset arguments.thisID = 18 >
<cfquery name="qChk" datasource="#Session.dbsource#"
username="#Session.dbuname#" password="#Session.dbpass#">
SELECT ID
FROM sales
WHERE prodID = #arguments.thisID#
</cfquery>
<cfif qChk.RecordCount EQ 0>
<!--- delete product and all it's attachments --->
<!--- products, inventory, upc, supplierList, catTable, prodNutri, prodIngred,
products.photos --->
<cfquery name="qP" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
SELECT photo
FROM products
WHERE ID = #arguments.thisID#
</cfquery>
<cfset photo = #qP.photo#>
<cfset pAr = ListToArray(photo)>
<cfloop from="1" to="#ArrayLen(pAr)#" index="i">
<cfif pAr[i] NEQ "noImage.png">
<cffile action="delete" file="#imageDir#/#pAr[i]#" />
<cffile action="delete" file="#imageDir#/t_#pAr[i]#" />
</cfif>
</cfloop>
<cfquery name="qUpc" datasource="#Session.dbsource#"
username="#Session.dbuname#" password="#Session.dbpass#">
SELECT upcImg
FROM upc
WHERE prodID = #arguments.thisID#
</cfquery>
<cfloop query="qUpc">
<cfif upcImg NEQ ''>
<cffile action="delete" file="#upcDir#/#upcImg#" />
</cfif>
</cfloop>
<!---
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM products
WHERE ID = #arguments.thisID#
</cfquery>
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM inventory
WHERE prodID = #arguments.thisID#
</cfquery>
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM upc
WHERE prodID = #arguments.thisID#
</cfquery>
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM supplierList
WHERE prodID = #arguments.thisID#
</cfquery>
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM catTable
WHERE prodID = #arguments.thisID#
</cfquery>
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM prodNutri
WHERE prodID = #arguments.thisID#
</cfquery>
<cfquery name="q" datasource="#Session.dbsource#" username="#Session.dbuname#"
password="#Session.dbpass#">
DELETE FROM prodIngred
WHERE prodID = #arguments.thisID#
</cfquery>
<!--- delete images that need to be deleted --->
--->
<cfelse>
<!--- turn on archive flag --->
</cfif>
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
