Duncan,
Free beer for you! Send me your paypal address off list.
(I don't get down your way and im serious about the free beer)
That bug could drive you nuts. I played with this all Sunday as I was convinced that all was OK as everything was being outputted ok. Even in the debugger the values show up correctly.
In fact it was only when I changed the actual values of the select option that it made any diference.
The IF had no effect and could still use GetCartItems.ItemSize. How weird is that!
<cfif Getsizes.Size eq #ItemSize#> <!--- Makes no difference which variable is used --->
<option value="#ItemSize#" selected>#ItemSize#</option><!--- Must be a local variable --->
Many thanks
Regards - Paul
From: "Paul Swingewood" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:56:43 +0100
and just as he saves the changes to his development server ..... It crashes and dies with a reboot ....
Im having a bad day ..... :(
Regards - Paul
--->From: [EMAIL PROTECTED] Reply-To: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:53:01 +0100
you've done it on the itemID's, but you also need to replace references to GetCartItems.ItemSize (in the cfloop) with a local variable instead.
"Paul Swingewood"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: Re: [ cf-dev ] Free Beer!
19/07/2004 10:50
Please respond to
dev
Yeah I did that further up the code to ensure the itemID's were being
returned ok. I remembered that from something I did a while ago. Its weird
though that the values must be returned properly to populate the dropdowns.
I'll give it a go and see what happens ....
Regards - Paul
>From: [EMAIL PROTECTED]
>Reply-To: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Re: [ cf-dev ] Free Beer!
>Date: Mon, 19 Jul 2004 10:46:04 +0100
>
>
>Paul, this *may* be connected to the bug where this code wouldn't work:
>
><cfoutput query="whatever">
> <cfloop query="something else">
> #reference to whatever.variable#
> </cfloop>
></cfoutput>
>
>in the above instance, #whatever.variable# would always equal the first
>value from that query, not the one currently being looped. you have to
set
>a temp variable before you enter the cfloop, and reference that instead:
><cfoutput query="whatever">
> <cfset somevariable = whatever.variable>
> <cfloop query="something else">
> #somevariable#
> </cfloop>
></cfoutput>
>
>This bug might have been fixed in CFMX, not sure...?
>
>
>
>
> "Paul Swingewood"
> <[EMAIL PROTECTED] To:
>[EMAIL PROTECTED]
> tmail.com> cc:
> Subject: Re: [ cf-dev
]
>Free Beer!
> 19/07/2004 10:40
> Please respond to
> dev
>
>
>
>
>
>Heres the problem.
>
>Best viewed visually at http://217.43.93.212/store/
>
>Select Footwear, Stilettos, Choose a shoe, put this in my basket.
>
>Change the size and the new size change is reflected in the drop down
list.
>
>Perfect!
>Now add another stiletto to the basket change size (Dispear! - Angst and
>stress)
>
>
>You will see ive added a few debugging lines to the table to show the
>values.
>I can't understand why this works first time but then not for any other
>item
>added....
>
>Now for the code ....
>
>
><cfoutput query = "GetCartItems">
> <cfset tblitemsItemID =
>GetCartItems.ItemIdPK>
> <!--- Get sizess relevant for this item
---> > <CFQUERY NAME="Getsizes" datasource=" >#application.dsn#"> > SELECT tblItemSizes.FKItemID, > tblSizes.Size, > tblItemSizes.FKSizeID, > tblSizes.SizeID > FROM tblSizes > INNER JOIN tblItemSizes > ON tblSizes.SizeID = >tblItemSizes.FKSizeID > WHERE (tblItemSizes.FKItemID >= #tblitemsItemId#) > </cfquery> > <tr><td BGCOLOR="##cc0000" colspan="7"> > Possible Sizes for this item are : > <cfloop query="GetSizes"> >#GetSizes.Size#,</cfloop> > </td></tr> > <!--- Get colours relevant for this item
--->
> <CFQUERY NAME="GetColours" datasource="
>#application.dsn#">
> SELECT tblItemColours.FKItemID,
> tblColours.Colour,
>
>tblItemColours.FKColourID,
> tblColours.ColourID
> FROM tblColours
> INNER JOIN tblItemColours
> ON tblColours.ColourID =
>tblItemColours.FKColourID
> WHERE
>(tblItemColours.FKItemID = #tblitemsItemId#)
> Order By ColourID ASC
> </cfquery>
> <tr><td BGCOLOR="##cc0000" colspan="7">Get
>Cart Items Size(Outer loop) =
>#GetCartItems.ItemSize#</td></tr>
> <TR>
> <TD BGCOLOR="##cc0000">
>#PartNum#</TD>
> <TD BGCOLOR="##cc0000">
>#ItemName#</TD>
> <td BGCOLOR="##cc0000">
> <cfif GetSizes.size
eq
>"">
> N/A
> <cfelse>
> <select
name
>="selectSize#Replace(ItemIDPK,"-","_","ALL")#">
>
<cfloop
>query="Getsizes"><!--- Sizes relevant for this item only>only --->
> <cfif Getsizes.Size eq GetCartItems.ItemSize>
>
> <option value="#GetCartItems.ItemSize#"
>selected>#GetCartItems.ItemSize#</option>
>
> <!--- Increment the cart query here? --->
>
> <cfelse>
>
> <option value="#GetSizes.Size#">#GetSizes.Size#</option>
>
> </cfif>
>
></cfloop>
> </select>
> </cfif>
> </td>
> <td BGCOLOR="##cc0000">
> <select name
>="selectColour#Replace(ItemIDPK,"-","_","ALL")#">
> <cfloop query
>="GetColours"><!--- Colours relevant for this item>
><cfif GetColours.ColourID eq GetCartItems.ItemColour>
>
> <option value="#GetColours.ColourID#"
>selected>#GetColours.Colour#</option>
>
><cfelse>
>
> <option value="#GetColours.ColourID#">#GetColours.Colour#</option>
>
></cfif>
> </cfloop>
> </select>
> </td>
> <td ALIGN="RIGHT" bgcolor="
>##cc0000">#lscurrencyFormat(ItemCost)#</TD>
> <td bgcolor="##cc0000">
> <input type="Text"
>name
>="Quantity#Replace(ItemIDPK,"-","_","ALL")#"
>value="#Quantity#" align="RIGHT" size="3">
> </TD>
> <TD BGCOLOR="##cc0000" ALIGN
>="RIGHT">
>
>#lscurrencyFormat(ItemCost * Quantity)#
> </TD>
> </TR>
> <!--- Add cost of current item(s) to total
>cost --->
> <CFSET TotalCost = TotalCost +
>(GetCartItems.ItemCost *
>GetCartItems.Quantity)>
> </cfoutput>
>
>Regards- Paul
>
>
>
>--
>These lists are syncronised with the CFDeveloper forum at
>http://forum.cfdeveloper.co.uk/
>Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
>CFDeveloper Sponsors and contributors:-
>*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
>by activepdf.com*
> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
>proworkflow.com*
> *Tutorials provided by helmguru.com* :: *Lists hosted by
>gradwell.com*
>
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
>
>--
>These lists are syncronised with the CFDeveloper forum at
>http://forum.cfdeveloper.co.uk/
>Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
>CFDeveloper Sponsors and contributors:-
>*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
>by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by >proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by >gradwell.com* > >To unsubscribe, e-mail: [EMAIL PROTECTED] >
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
