Re: WebDNA tags in WebMerchant email templates ...
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15802
interpreted = N
texte = > Yes, I know I can pass the SN thru to WebMerchant using one of the> header fields (or the textA-E lineitem fields). I also know that> WebMerchant will put this data into its approved email message that> gets sent to the buyer if I want it to.>> But that still doesn't solve my problem ...>> Because before I can put those SN's into the order file in the first> place, I have to *assign* them to that order ... which basically> means removing them from the SN database (or flagging them as> unavailable for future purchases) ... BEFORE they are paid for.>> That means every time a cc purchase fails, I have to go into the SN> database and *un-issue* the SN's which were improperly issued to the> failed purchase.>> Basically, this is the wrong way to go about it. Not that it won't> work, but the fact is that SN's should not be assigned until AFTER> the appropriate credit card charges are authorized ... right?>> All I want is to assign the SN's AFTER cc approval, not before, so I> don't have to go into the SN database every time an attempted> software purchase fails, just to reverse WebCat's assignment of SN's> that should never have been assigned in the first place.I don't think this was already suggested but you might do all of the serialnumber delivery on the Pick up page. (An email containing the serialnumbers can be sent from this page as well. This isn't in the WebDNAbelow.) This solves the problem of un-issuing serial numbers. Here's somesample 'DNA:[lineItems]
[TEXTA][name] is licenced for[quantity] cop[showif [quantity]=1]y[/showif][hideif[quantity]=1]ies[/hideif] of this product. [showif [textb]=T]
Your serial number(s) are:
[showif [interpret][lookupdb=db/serialnumbers.db&lookinfield=cartnumb&value=[cart]&returnfield=taken¬found=F][/interpret]=T] [includefile=dispenseWO.inc&cart=[cart]&quantity=[quantity]] [/showif] [showif [interpret][lookupdb=db/serialnumbers.db&lookinfield=cartnumb&value=[cart]&returnfield=taken¬found=F][/interpret]=F] [includefile=dispenseW.inc&cart=[cart]&quantity=[quantity]] [/showif] [/showif]
[/lineItems]dispenseW.inc contains: [loop start=1&end=[quantity]] [Searchdb=db/serialnumbers.db&eqtakendata=F&max=1&startat=1] [founditems] [serialnumber]
[replacedb=db/serialnumbers.db&eqserialnumberdata=[serialnumber]&max=1&startat=1]taken=T&cartnumb=[cart][/replace] [/founditems] [/search] [/loop]dispenseWO.inc is a search for the cart number in the database if they'vealready been issued a serial number. [Search db=db/serialnumbers.db&eqcartnumbdata=[cart]&startat=1] [founditems] [serialnumber]
[/founditems] [/search]Hope this helps.Nathan HydeInternet ServicesCasady & Greeneemail: nh_is@casadyg.com, nhyde@mail3.casadyg.comweb page: http://www.casadyg.comand now http://www.macbundle.com
Associated Messages, from the most recent to the oldest:
> Yes, I know I can pass the SN thru to WebMerchant using one of the> header fields (or the textA-E lineitem fields). I also know that> WebMerchant will put this data into its approved email message that> gets sent to the buyer if I want it to.>> But that still doesn't solve my problem ...>> Because before I can put those SN's into the
order file in the first> place, I have to *assign* them to that order ... which basically> means removing them from the SN database (or flagging them as> unavailable for future purchases) ... BEFORE they are paid for.>> That means every time a cc purchase fails, I have to go into the SN> database and *un-issue* the SN's which were improperly issued to the> failed purchase.>> Basically, this is the wrong way to go about it. Not that it won't> work, but the fact is that SN's should not be assigned until AFTER> the appropriate credit card charges are authorized ... right?>> All I want is to assign the SN's AFTER cc approval, not before, so I> don't have to go into the SN database every time an attempted> software purchase fails, just to reverse WebCat's assignment of SN's> that should never have been assigned in the first place.I don't think this was already suggested but you might do all of the serialnumber delivery on the Pick up page. (An email containing the serialnumbers can be sent from this page as well. This isn't in the WebDNAbelow.) This solves the problem of un-issuing serial numbers. Here's somesample 'DNA:
[lineitems] [TEXTA][name] is licenced for[quantity] cop[showif [quantity]=1]y[/showif][hideif[quantity]=1]ies[/hideif] of this product. [showif [textb]=T]
Your serial number(s) are:
[showif
[interpret][lookupdb=db/serialnumbers.db&lookinfield=cartnumb&value=
[cart]&returnfield=taken¬found=F][/interpret]=T] [includefile=dispenseWO.inc&cart=
[cart]&quantity=[quantity]] [/showif] [showif
[interpret][lookupdb=db/serialnumbers.db&lookinfield=cartnumb&value=
[cart]&returnfield=taken¬found=F][/interpret]=F] [includefile=dispenseW.inc&cart=
[cart]&quantity=[quantity]] [/showif] [/showif]
[/lineItems]dispenseW.inc contains: [loop start=1&end=[quantity]] [Searchdb=db/serialnumbers.db&eqtakendata=F&max=1&startat=1]
[founditems] [serialnumber]
[replacedb=db/serialnumbers.db&eqserialnumberdata=[serialnumber]&max=1&startat=1]taken=T&cartnumb=
[cart][/replace] [/founditems] [/search] [/loop]dispenseWO.inc is a search for the cart number in the database if they'vealready been issued a serial number. [Search db=db/serialnumbers.db&eqcartnumbdata=
[cart]&startat=1]
[founditems] [serialnumber]
[/founditems] [/search]Hope this helps.Nathan HydeInternet ServicesCasady & Greeneemail: nh_is@casadyg.com, nhyde@mail3.casadyg.comweb page: http://www.casadyg.comand now http://www.macbundle.com
Nathan Hyde
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
SiteGuard Admin Feature ? (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
TRAINING videos - Prove IT. (1998)
Re:Email Problem (1997)
OT: fckeditor weirdness (2005)
InSecureTextVariables.... (2000)
raw=T is broken in [include] (1997)
all records returned. (1997)
Quitting WebMerchant ? (1997)
Database Field Additions (2000)
PIXO support (1997)
deadlock (2000)
PIXO support (1997)
Support ?? (1997)
Share cost of training videos! (1998)
Multiple 'Users.db' files not possible (1997)
Deleting with contexts (2001)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Setting up shop (1997)
Searchable Archives? (2000)