CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 DB & ColdFusion Question

Print topic Send  topic

Author Message
shp10021
Posted: 09/13/2003, 7:08 PM

I am developing a shopping cart based on the Bookstore example. A user logs
in and depending on the member_level, I would like the price field in Orders
to be updated with either the memberrate or nonmemberrate from Items. I
have the following tables with these fields

Items: itemid; memberrate; nonmemberrate
Login: loginid; login; password; member_level
Orders: itemid; loginid; price

Any help would be greatly appreciated.

Michael Rachow
Posted: 09/30/2003, 7:55 AM

An idea:
Select both fields from the database.
Set field memberrate to Label and
nonmemberrate to Hidden.
In Event: Before Show
check for member_level and if to "low" set
fldmemberrate = fldnonmemberrate;

"shp10021" <shp10021@yahoo.com> schrieb im Newsbeitrag
news:bk0ijo$ivj$1@news.codecharge.com...
> I am developing a shopping cart based on the Bookstore example. A user
logs
> in and depending on the member_level, I would like the price field in
Orders
> to be updated with either the memberrate or nonmemberrate from Items. I
> have the following tables with these fields
>
> Items: itemid; memberrate; nonmemberrate
> Login: loginid; login; password; member_level
> Orders: itemid; loginid; price
>
> Any help would be greatly appreciated.
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.