CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Database Update Problem

Print topic Send  topic

Author Message
Posted: 11/26/2002, 11:22 AM


I am fairly new to CodeChargeStudio and am trying to implement a fairly
straight forward solution that I can do with regular asp scripting.

I am trying to add a form that will update a database and add to a
connection table depending on if a checkbox is clicked or not.

The database has 3 tables.
1. Store table (All stores available).
2. StoreCouponConnection Table (All Stores with coupons activated).
3. StoreCoupon Table (All Coupons Available).

A: I have a form that lists a specific store with a grid of all the coupons
available and a checkbox for each coupon (I have an update button that they
can click to activate as many coupons as the user wants activated depending
if the check box is clicked or not, however I can't seem to get this to work
with code charge studio) .
B: I would also like the grid to check the StoreCouponConnection table when
it loads to see if the specific store has a coupon activated and make the
check box active or not depending on if there is a record in the
StoreCouponConnection table with the specific StoreID and CouponID.

A: The way I would do this with straight asp is have a loop through each
coupon record and check if the check box is clicked or not. If its checked
then I would update the StoreCouponConnection database and add a recorded
with the StoreID and CouponID, however if its not checked then I would check
to see if there is a record available with the specific StoreID and CouponID
and delete it. However, I am trying to implement this solution with
CodeCharge and would like any suggestions, examples or any comments would be

B: I would do the same thing here and loop through each storecoupon record
to see if there is a record for the specific store and coupon. If so then
make the Checkbox active and if not then leave it a inactive.

Any examples I could use for reference would be great.

Thank you in advance.

Trevor Sandor
Web Development
Telin Systems Ltd
403.297.0270 ext 74

"This message contains confidential information. Unless you are the
addressee (or authorized to receive for the addressee), you may not copy,
use or distribute this information. If you have received this message in
error, please call 403 297 0270 or return it promptly by mail."


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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