Help with Lookup

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39268
interpreted = N
texte = Hello all,I am trying to get this to work, without success.[text]cook=[GetCookie name=Interchill-ID][/text][text]cart=[lookup db=subscribers.db&lookinfield=COOKIE&value=[cook]&returnfield=SKU¬found=[ cart][/text][interpret][cart][/interpret] at the end doesnąt work either.If a cookie exists lookup should find cart number from db, if not provide new one. Well that was the plan...Then my next line repeats the lookup (backwards) in a poor attempt to determine if Webcat has issued a new cart or not.[hideif [lookup db=subscribers.db&lookinfield=SKU&value=[cart]&returnfield=COOKIE¬found=N EW_USER]=NEW_USER] [text]action=display[/text] [/hideif]The objective of this is to route existing customers (with Cookie) usingAction=displayCan anyone help with a simpler solution for this same end. I'm suffering from screen haze!-- Edell & Co. Ltd.T 01857 644 256 F 01857 644 257 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Help with Lookup (p 2001)
Hello all,I am trying to get this to work, without success.[text]cook=[GetCookie name=Interchill-ID][/text][text]cart=[lookup db=subscribers.db&lookinfield=COOKIE&value=[cook]&returnfield=SKU¬found=[ cart][/text][interpret][cart][/interpret] at the end doesnąt work either.If a cookie exists lookup should find cart number from db, if not provide new one. Well that was the plan...Then my next line repeats the lookup (backwards) in a poor attempt to determine if Webcat has issued a new cart or not.[hideif [lookup db=subscribers.db&lookinfield=SKU&value=[cart]&returnfield=COOKIE¬found=N EW_USER]=NEW_USER] [text]action=display[/text] [/hideif]The objective of this is to route existing customers (with Cookie) usingAction=displayCan anyone help with a simpler solution for this same end. I'm suffering from screen haze!-- Edell & Co. Ltd.T 01857 644 256 F 01857 644 257 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ p

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:

Multiple Merchant Accounts? (1997) system crashes, event log (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Newbie Question about seeting price to 0 (1998) Where is f2? (1997) The future of WebCatalog is coming with 4.0... (2000) spaces in [texta] (1998) Alpha List for Catagory (1998) Searching multiple fields (1997) Newbie Help Needed (1998) HELP..Changing Price after adding to cart. (1999) Re:quit command on NT (1997) service stop and restart (1997) Exclamation point (1997) WebCat2b12 - nesting [tags] (1997) Am I going senile? (Price recalc based on quantity) (1997) What is WebDNA (1997) [append] vs. [appendfile] delta + question? (1997) graphics server, SSL, Netscape 4.0 (off topic) (1998) ExclusiveLock (2000)