Forums: » Register « |  Free Tools |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support |
 User Name: Password: Remember me

New Free Tools on Dev Shed!
We're Excited to announce that Dev Shed now has 70 free tools on the site. To learn more, click here!

 Dev Shed Forums Sponsor:
#1
September 7th, 2003, 08:58 PM
 EHunt7
Junior Member

Join Date: Sep 2003
Posts: 7
Time spent in forums: < 1 sec
Reputation Power: 0
CFML IF ELSE Problems

I am a novice at CFML and I need some help.

I am modifying a shopping cart programming that was built in CFML. I need to be able to adjust the price of an item depending on the quantity purchased. For example, the more a person buuys, the less expensive the per item cost becomes. Basically, each item will have up to 5 different prices depending on the amount purchased.

Anyway, I am trying to write an IF ELSE statement that looks at the quantity being purchased and then determines which price to charge the person. The information is taken from my MySQL database and includes the UNITPRICE of the item and then the 5 alternate prices and 5 quantity ranges. So basically, once a quantity is entered by the purchaser, the IF ELSE statement checks it against the upper limits of each quantity range, selects the correct price and then sets the original UNITPRICE of the item to be equal to the new "discounted" price (e.g., price1 is set if person purchases 1-100 of the same item; price2 is set if person purchases 101-200, and so on.)

The new price is then used in the calculation of the total, etc.

Here's part of the code:

<!--- // === [ Set default quantity number If no number is passed ONE SKU will be added ] === // --->
<cfparam name="Attributes.Quantity" default="1">
<!--- //Pull Product Data From Database // --->
SELECT SKU, ItemID, UnitPrice, ID, Name, Stock, Size, Weight, price1, price2, price3, price4, price5, range1, range2, range3, range4, range5 FROM ProductSKUs,
Products WHERE SKU = '#Attributes.SKU#' AND ItemID = ID
</cfquery>
<!---// We should have one Database match // --->
<cfif GetProduct.RecordCount EQ 1>
<!--- //Determine Array index (New Item vs. just an update) // --->
<!--- //If SKU exists, Update Quantity // --->
<cfif ListFind(ArrayToList(Session.Cart.SKU),GetProduct.SKU) NEQ 0>
<cfset ThisItem=ListFind(ArrayToList(Session.Cart.SKU),GetProduct.SKU)>
<!--- //Set Quantity // --->
<cflock timeout="2" throwontimeout="No" type="EXCLUSIVE" scope="SESSION">
<cfset Session.Cart.Quantity[ThisItem]=Session.Cart.Quantity[ThisItem] + Attributes.Quantity>
</cflock>

<!--THE IF ELSE -->

<cfif Session.Cart.Quantity[ThisItem] GTE GetProduct.range5>
<cfset GetProduct.UnitPrice=GetProduct.price5>
<cfelseif Session.Cart.Quantity[ThisItem] GTE GetProduct.range4>
<cfset GetProduct.UnitPrice=GetProduct.price4>
<cfelseif Session.Cart.Quantity[ThisItem] GTE GetProduct.range3>
<cfset GetProduct.UnitPrice=GetProduct.price3>
<cfelseif Session.Cart.Quantity[ThisItem] GTE GetProduct.range2>
<cfset GetProduct.UnitPrice=GetProduct.price2>
<cfelse>
<cfset GetProduct.UnitPrice=GetProduct.price1>
</cfif>

<!--END OF DISCOUNTPRICE STATEMENT

<!--- // === [ If SKU doesn't exist, add it to the end of the array ] === // --->
<cfelse>
<cfset ThisItem=ArrayLen(Session.Cart.SKU) +1 >

<!--- === [ Add to cart ] === // --->
<cflock timeout="5" throwontimeout="No" type="EXCLUSIVE" scope="SESSION">
<cfset Session.Cart.SKU[ThisItem]=GetProduct.SKU>
<cfset Session.Cart.ItemID[ThisItem]=GetProduct.ItemID>
<cfset Session.Cart.Name[ThisItem]=GetProduct.Name>
<cfset Session.Cart.Descrip[ThisItem]=GetProduct.Size>
<cfset Session.Cart.UnitPrice[ThisItem]=GetProduct.UnitPrice>
<cfset Session.Cart.UnitWeight[ThisItem]=GetProduct.Weight>
</cflock>

<cflock timeout="5" throwontimeout="No" type="EXCLUSIVE" scope="SESSION">
<cfset Session.Cart.Quantity[ThisItem]=Attributes.Quantity>
</cflock>

</cfif>

I'm getting the following error with this code:

An error occurred while evaluating the expression:

GetProduct.UnitPrice=GetProduct.price5

Error near line 219, column 9.
--------------------------------------------------------------------------------

Cannot add value to query

The operation you have requested is invalid. Only query columns can be added to query objects. It is likely that you have omitted the indexing brackets of a query column you are trying to set.

For example, can produce this error message. The correct syntax is

The error occurred while processing an element with a general identifier of (CFSET), occupying document position (219:3) to (219:48).

***********
Any help is appreciated. I can provide more code if necessary.

#2
September 9th, 2003, 09:11 AM
 kiteless
Moderator

Join Date: Jun 2002
Location: Raleigh, NC
Posts: 5,205
Time spent in forums: 2 Weeks 5 Days 19 h 43 m 23 sec
Reputation Power: 967
I think the issue is that you are trying to change an element inside a query result set, which is more like an array than a "normal" variable". Try setting the unit price to a separate variable like "thisUnitPrice" and see if that works.

#3
September 12th, 2003, 07:35 AM
 Shiju Rajan
.Net Developer

Join Date: Feb 2000
Location: London
Posts: 987
Time spent in forums: 3 h 26 m 22 sec
Reputation Power: 14
Yes, you may declare a local variable and change your price. If you want to change a query set value then you have to use QuerySetCell() function to do that. but in you code the value can be changed using another local variable.

<!--THE IF ELSE -->
<cfif Session.Cart.Quantity[ThisItem] GTE GetProduct.range5>
<cfset ThisUnitPrice=GetProduct.price5>
<cfelseif Session.Cart.Quantity[ThisItem] GTE GetProduct.range4>
<cfset ThisUnitPrice=GetProduct.price4>
<cfelseif Session.Cart.Quantity[ThisItem] GTE GetProduct.range3>
<cfset ThisUnitPrice=GetProduct.price3>
<cfelseif Session.Cart.Quantity[ThisItem] GTE GetProduct.range2>
<cfset ThisUnitPrice=GetProduct.price2>
<cfelse>
<cfset ThisUnitPrice=GetProduct.price1>
</cfif>

<!--- now you can add the changed prince to the cart --->
<cfset Session.Cart.UnitPrice[ThisItem]=ThisUnitPrice>
__________________
SR -
webshiju.com
www.lizratechnologies.com

"The fear of the LORD is the beginning of knowledge..."

 Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > CFML IF ELSE Problems

## Developer Shed Advertisers and Affiliates

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Rate This Thread Linear Mode Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox Forum Jump Please select one User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home -------------------- Programming Languages    PHP Development        PHP FAQs and Stickies    Perl Programming        Perl FAQs and Stickies    C Programming        C Programming FAQs and Stickies    Java Help        Java FAQs    Python Programming        Python Programming FAQs    Ruby Programming        Ruby Programming FAQs    Game Development        Game Development FAQs Programming Languages - More    ASP Programming        ASP Programming FAQs    .Net Development        .Net Development FAQs    Visual Basic Programming        Visual Basic Programming FAQs    Software Design        Software Design FAQs    ColdFusion Development        ColdFusion Development FAQs    Delphi Programming        Delphi Programming FAQs    Regex Programming        Regex Programming FAQs    XML Programming        XML Programming FAQs    Other Programming Languages        Other Programming Languages FAQs Web Design    HTML Programming        HTML Programming FAQs    JavaScript Development        JavaScript Development FAQs    CSS Help        CSS Help FAQs    Flash Help        Flash Help FAQs    Photoshop Help        Photoshop Help FAQs    Web Design Help        Web Design Help FAQs    Website Critiques        Website Critiques FAQs    Search Engine Optimization        Search Engine Optimization FAQs Mobile Programming    Mobile Programming        Mobile Programming FAQs    iPhone SDK Development        iPhone SDK Development FAQs    Android Development        Android Development FAQs    BlackBerry Development        BlackBerry Development FAQs Web Site Management    Business Help        Business Help FAQs    Development Software        Development Software FAQs    Scripts        Scripts FAQs Databases    Database Management        Database Management FAQs    DB2 Development        DB2 Development FAQs    MySQL Help        MySQL Help FAQs    PostgreSQL Help        PostgreSQL Help FAQs    Firebird SQL Development        Firebird SQL Development FAQs    MS SQL Development        MS SQL Development FAQs    Oracle Development        Oracle Development FAQs    LDAP Programming        LDAP Programming FAQs System Administration    Mail Server Help        Mail Server Help FAQs    Apache Development        Apache Development FAQs    Security and Cryptography        Security and Cryptography FAQs    Antivirus Protection        Antivirus Protection FAQs    DNS        DNS FAQs    IIS        IIS FAQs    Networking Help        Networking Help FAQs    FTP Help        FTP Help FAQs Operating Systems    BSD Help        BSD Help FAQs    Linux Help        Linux Help FAQs    UNIX Help        UNIX Help FAQs    Windows Help        Windows Help FAQs    Mac Help        Mac Help FAQs Web Hosting    Web Hosting        Web Hosting FAQs    Free Web Hosting        Free Web Hosting FAQs    Web Hosting Requests        Web Hosting Requests FAQs    Web Hosting Offers        Web Hosting Offers FAQs Computer Hardware    Computer Hardware    CPUs        CPUs FAQs    Cooling        Cooling FAQs    Embedded Programming        Embedded Programming FAQs    Motherboards        Motherboards FAQs    Multimedia Hardware        Multimedia Hardware FAQs Other    Dev Shed Lounge        Dev Shed Lounge FAQs    Development Articles        Development Articles FAQs    Beginner Programming        Beginner Programming FAQs    Hire A Programmer        Hire A Programmer FAQs    Project Help Wanted        Project Help Wanted FAQs Latest News Updated Hourly    Technology News    Business News    Science News Forum Information    Forum Rules/Guidelines        Forum Rules/Guidelines FAQs    Forum Announcements        Forum Announcements FAQs    Dev Shed Gaming Center        Go to the Dev Shed Battle Arena        Go to the Dev Shed Arcade Games        Go to the Legend of the Green Dragon    Suggestions & Feedback        Suggestions & Feedback FAQs

 Forums: » Register « |  Free Tools |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support |