Thanks for the tip, Jeff, but that returned another type of error
about the variable not being a "simple" variable...
I think I found the answer, however...I moved some of the lines
of code around, specifically placing the CFLOCK's outside of all the
code below on the event_photo_cart.cfm page and that seemed to do the trick.
Looking at the code below, I didn't have CFLOCK's around the <CFLOOP
Query="Session.Cart">
line and CF wasn't complaining about the lack of CFLOCK's...
But when I put the locks completely outside the code below, it worked.
I think, it had to do with placing the first CFLOCK inside a
<CFIF>...</CFIF> statement grouping.
I've found on other occasions that CF doesn't like either the <CFLOCK> or
the closing </CFLOCK>
inside of a <CFIF>...</CFIF> with the other part of the tag outside...
I moved several things around and not sure if that was it...but at least now
it's working!
Thanks!
Rick
> -----Original Message-----
> From: Jeff Beer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 10:24 AM
> To: CF-Talk
> Subject: RE: Why am I getting this "not an available query" error?
>
>
> First, try using:
>
> <CFLOOP Query="#Session.Cart#">
>
> CF needs to know that "Session.Cart" is a variable.
>
> -----Original Message-----
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 9:55 AM
> To: CF-Talk
> Subject: Why am I getting this "not an available query" error?
>
>
> Good morning...
>
> CF 4.5 / Win 2000 Pro
>
> Trying to setup a shopping cart and was doing fine last night testing
> this code. This morning when I start running it, I get the error
> message: (The CFLOOP at 21:1 to 21:29 is the <CFLOOP
> Query="Session.Cart"> at the
> bottom)
>
> Why would the Session.Cart query suddenly not be available?
> The Application.cfm should be creating it, even if it's
> undefined.......????
>
> Rick
>
> -------------------------------------------------------------
> -----------
> ----
> -------------
>
> Error Diagnostic Information
> QUERY
>
> The QUERY attribute of the tag does not specify the name of
> an available
> query
>
> The error occurred while processing an element with a
> general identifier
> of (CFLOOP), occupying document position (21:1) to (21:29).
>
> -------------------------------------------------------------
> -----------
> ----
> --------------------------
>
>
> - SessionManagement is enabled
>
>
> - Code from Application.cfm
>
> <CFIF Not IsDefined("Session.Cart")>
>
> <CFSET Session.Cart = QueryNew("PhotoFileName,
> Quantity, Size, Amount")>
>
> </CFIF>
>
>
> - Code from event_photo_cart.cfm
>
> <CFIF Form.Size4x6 is not "0">
>
> <CFLOCK Scope="Session" Type="Exclusive"
> TimeOut="5">
>
> <CFSET Temp = QueryAddRow(Session.Cart)>
> <CFSET Temp = QuerySetCell(Session.Cart,
> "PhotoFileName", "<CFOUTPUT>#Form.PhotoFileName#</CFOUTPUT>")>
> <CFSET Temp = QuerySetCell(Session.Cart,
> "Quantity", "<CFOUTPUT>#Form.Size4x6#</CFOUTPUT>")>
> <CFSET Temp = QuerySetCell(Session.Cart,
> "Size", "4 x 6")>
> <CFSET Temp = QuerySetCell(Session.Cart,
> "Amount",
> "<CFOUTPUT>#DollarFormat(Evaluate(Form.Size4x6*3.95))#</CFOUTPUT>")>
>
> </CFLOCK>
>
> </CFIF>
>
> <CFLOOP Query="Session.Cart">
> <CFOUTPUT>
> PhotoFileName: #PhotoFileName# &n
> bsp; Q
> uant
> ity: #Quantity# Size:
>  
> ;#Si
> ze# Amount: #Amount#
> </CFOUTPUT>
> </CFLOOP>
>
> <CFABORT>
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~|
> Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137481
> Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
> Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
> Unsubscribe:
> http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
>
> Signup for the Fusion Authority news alert and keep up with
> the latest news in ColdFusion and related topics.
> http://www.fusionauthority.com/signup.cfm
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137489
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
