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:

Frames and WebCat (1997) 2 easy questions re: [showif] and [sendmail] (1997) PCS Emailer's role ? (1997) Date problems-more (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997) Foreign Chars ( éàöä and so on) (1998) Math Bug (1999) [LOOKUP] (1997) attacment pdf (2001) much help needed NEWBIE alert (2000) WebDNA 4.5 under IIS6, Win2003 (2003) Where is f2? (1997) Users and groups for local directories (1999) 'page impression' techniques for banner ads (1999) WCS Newbie question (1997) Avery 5160 Mailing Labels (2003) [WebDNA] Two file tags don't work as expected (2009) Dumb Question about Docs (1997) Requiring that certain fields be completed (1997) AddLineItem Problem (1997)