Re: Click-through/Referral tracking solution needed
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34734
interpreted = N
texte = Robert McPeak wrote:> How do I search my orders.db for the contents of a header field or for the > criteria you suggested?this kind of thing:say you save all values of an orderfile to your own custom Orders.db when someone orders something... (where for example I stick the value of [header1] - where I was keeping the affillID during the user's shopping trip - into the 'AffilID' field of my Orders.db). Then on an admin page, you could do something like this:[Search db=Orders.db&neAffilIDdatarq=[blank]&AffilIDsum=T] [!]---now finding all the orders which have any value at all in the 'affilID' field - ie those which stemmed from an affil link - and summarizing by unique affilID--[/!] [FoundItems] Affil # [affilID] has these orders which belong to him:[Search db=Orders.db&eqAffilIDdatarq=[AffilID]&DayOrderedsort=1...] [!]---now finding all the orders which belong to just this one affiliate---[/!] [FoundItems] On [DayOrdered] at [timeOrdered], affil # [AffilID] earned a commission of $[math show=T][OrderTotal]*[CommissionRate][/math] [/FoundItems][/Search][/FoundItems][/Search]> > I tried to search orders from my admin page for a known good entry (I can > see it when I look at the order) in header10 but no luck.We would need to see the code for this admin page to have any idea what you are talking about, let alone troubleshoot it. But at least in my case, I usually don't wade thru long posts full of code. I would recommend trying to learn one idea/technique at a time as you build something you need and get frequent quick help here as you get stuck rather than post a big fat ole chunck of code and say Why doesn't it work?...When you say you tried to seach orders what orders? Stored in a db? What db? Is your search syntax right? Does the db even store the value for header10? If not in a db, where are these orders that you are trying to search and how are you trying to search them? See what I mean? Break it down.Many new users assume we all use storebuilder and know its internal code and know that is what you are asking about. But your best help often comes from people who prefer to write their own custom solutions and may have never even used storebuilder...-John ------------------------------------------------------------- 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:
Robert McPeak wrote:> How do I search my orders.db for the contents of a header field or for the > criteria you suggested?this kind of thing:say you save all values of an orderfile to your own custom Orders.db when someone orders something... (where for example I stick the value of [header1] - where I was keeping the affillID during the user's shopping trip - into the 'AffilID' field of my Orders.db). Then on an admin page, you could do something like this:[Search db=Orders.db&neAffilIDdatarq=[blank]&AffilIDsum=T] [!]---now finding all the orders which have any value at all in the 'affilID' field - ie those which stemmed from an affil link - and summarizing by unique affilID--[/!] [founditems] Affil # [affilID] has these orders which belong to him:[Search db=Orders.db&eqAffilIDdatarq=[AffilID]&DayOrderedsort=1...] [!]---now finding all the orders which belong to just this one affiliate---[/!] [founditems] On [DayOrdered] at [timeOrdered], affil # [AffilID] earned a commission of $[math show=T][OrderTotal]*[CommissionRate][/math] [/FoundItems][/Search][/FoundItems][/Search]> > I tried to search orders from my admin page for a known good entry (I can > see it when I look at the order) in header10 but no luck.We would need to see the code for this admin page to have any idea what you are talking about, let alone troubleshoot it. But at least in my case, I usually don't wade thru long posts full of code. I would recommend trying to learn one idea/technique at a time as you build something you need and get frequent quick help here as you get stuck rather than post a big fat ole chunck of code and say Why doesn't it work?...When you say you tried to seach orders what orders? Stored in a db? What db? Is your search syntax right? Does the db even store the value for header10? If not in a db, where are these orders that you are trying to search and how are you trying to search them? See what I mean? Break it down.Many new users assume we all use storebuilder and know its internal code and know that is what you are asking about. But your best help often comes from people who prefer to write their own custom solutions and may have never even used storebuilder...-John ------------------------------------------------------------- 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/
John Butler
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:
Authorize.net? (2003)
[addlineitems] (1997)
[OT] re - Webcat run amuk (2002)
PIXO support (1997)
tab deliminated txt file (2001)
RE: [WebDNA] Sending 100 mails an hour then pausing (2010)
redirect with frames (1997)
RE: [WebDNA] Basic Search (2008)
2.0 Info (1997)
[isfile] ? (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Admin Edit prob. (1997)
memory leaks (2005)
Some Advise needed (1997)
Fun with Dates - any progress? (1997)
EIMS Problems (1997)
Country & Ship-to address & other fields ? (1997)
Multiple fields on 1 input (1997)
Createdate Bug? (2002)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)