Add database lookup page

[coyote_ptm]

I had a page on my old site ( pre-zen and static ) that allowed users to enter their in-store gift card number and I'd look it up and display the remaining value. I did it with a java servlet and jsp - pretty straightforward. I'd like to implement the same thing on my current site - have a page that displays verbiage regarding in-store gift cards as well as the db lookup for the current value.

I'm looking for a high level overview of a "best practice" way to do this in zen. Is there a straightforward way to accomplish this? The database is the same mysql DB that contains zen.

Thanks!

[Ajeh]

Can you use the Gift Certificate as the credit?

This would then allow the built in system to manage thing for you ...

How many do you have that need to be updated/added with an existing balance?

[coyote_ptm]

Thanks for the reply - I un-installed gift certificates from our site and had pretty much forgotten that they were there!! I think we may use the zen gift cards at some point, but not currently.

I'm not sure that they would work for this situation though... Our in-store gift cards are not tied to a customer and we require the card to use - and most importantly, can't be used on the web-site.

Anybody do something like this?

Thanks!