thanks Paul!
(will code for beer tokens)
"Paul Swingewood"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: Re: [ cf-dev ] Free Beer!
19/07/2004 11:17
Please respond to
dev
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
>--->
>> >
>> > <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
>only --->
>> >
>> ><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]
--
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]
