Re: Click-through/Referral tracking solution needed

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 34735
interpreted = N
texte = Thanks. I can nest founditems & search contexts. That is helpful.The search was from the WebMerchant Administer Orders page.Is that page not interacting with Orders.db? I guess I better look around my directories for an Orders.db. I guess that if I don't find one that I can make and modify one as I like, but if I do find one, is it safe to toy with it?Looking...>From: John Butler >Reply-To: (WebCatalog Talk)>To: (WebCatalog Talk)>Subject: Re: Click-through/Referral tracking solution needed>Date: Fri, 14 Jul 2000 21:38:59>>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/________________________________________________________________________Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com-------------------------------------------------------------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:

Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (Robert McPeak 2000) Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (Robert McPeak 2000) Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (Robert McPeak 2000) Re: Click-through/Referral tracking solution needed (Robert McPeak 2000) Re: Click-through/Referral tracking solution needed (Robert McPeak 2000) Re: Click-through/Referral tracking solution needed (John Butler 2000) Re: Click-through/Referral tracking solution needed (John Winningham 2000) Click-through/Referral tracking solution needed (Robert McPeak 2000)

Thanks. I can nest founditems & search contexts. That is helpful.The search was from the WebMerchant Administer Orders page.Is that page not interacting with Orders.db? I guess I better look around my directories for an Orders.db. I guess that if I don't find one that I can make and modify one as I like, but if I do find one, is it safe to toy with it?Looking...>From: John Butler >Reply-To: (WebCatalog Talk)>To: (WebCatalog Talk)>Subject: Re: Click-through/Referral tracking solution needed>Date: Fri, 14 Jul 2000 21:38:59>>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/________________________________________________________________________Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com-------------------------------------------------------------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/ Robert McPeak

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:

WebCat2b13MacPlugIn - more [date] problems (1997) A little syntax help (1997) Listfiles (1998) Emailer program? (2000) Image Library (2003) Now when I send TeaRoom Order fields it does not post in Invoice. (1997) PCS Emailer's role ? (1997) Append File help needed (2000) Hard Questions ? (1997) b12 cannot limit records returned and more. (1997) The beginning (1997) Hosting (2000) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) NetSplat and WebCat2 (1997) problems with 2 tags shakur (1997) [TaxableTotal] - not working with AOL and IE (1997) declined orders webmerchant not showing up? (2005) [Sum] function? (1997) Preloading code? (2002) Automatic thumbnail images (1998)