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 providenew one. Well that was the plan...Then my next line repeats the lookup (backwards) in a poor attempt todetermine if Webcat has issued a new cart or not.[hideif [lookup db=subscribers.db&lookinfield=SKU&value=[cart]&returnfield=COOKIE¬found=NEW_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 sufferingfrom screen haze!-- Edell & Co. Ltd.T 01857 644 256F 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:
|
- 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 providenew one. Well that was the plan...Then my next line repeats the lookup (backwards) in a poor attempt todetermine if Webcat has issued a new cart or not.[hideif [lookup db=subscribers.db&lookinfield=SKU&value=[cart]&returnfield=COOKIE¬found=NEW_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 sufferingfrom screen haze!-- Edell & Co. Ltd.T 01857 644 256F 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 fields on 1 input (1997)
WebCat2: multiple currency support (1997)
Large sites (2003)
WebMerchant Q (2000)
WebCat2b15MacPlugin - showing [math] (1997)
Image maps/Webcat (1997)
Forwarding Orders Via Email (1998)
[/application] error? (1997)
Emailer Error: 158 (2003)
The Depths of Credit Card Payment (2003)
Moment of Thanks (1997)
WebCat2 several catalogs? (1997)
Banner DNA (1997)
Just Testing (1997)
More Applescript (1997)
Server crash (1997)
[WebDNA] Reformatting database headers (2009)
TCPConnect and Sandbox (2003)
[WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019)
Problem displaying search result (1997)