Re: Click-through/Referral --Thanks for insight!

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34736
interpreted = N
texte = Now I get it. Duh. I've learned a lot tonight about interacting with the cart and Orders.db. Thanks guys. >From: Robert McPeak >Reply-To: (WebCatalog Talk) >To: (WebCatalog Talk) >Subject: Re: Click-through/Referral tracking solution needed >Date: Fri, 14 Jul 2000 21:44:34 EDT > >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/________________________________________________________________________ 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:

    
  1. Re: Click-through/Referral --Thanks for insight! (Robert McPeak 2000)
Now I get it. Duh. I've learned a lot tonight about interacting with the cart and Orders.db. Thanks guys. >From: Robert McPeak >Reply-To: (WebCatalog Talk) >To: (WebCatalog Talk) >Subject: Re: Click-through/Referral tracking solution needed >Date: Fri, 14 Jul 2000 21:44:34 EDT > >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/________________________________________________________________________ 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:

$Quit, $CloseDatabase corrections (1997) WC 2.0 frames feature (1997) gateway application timeouts (1998) RE: Promise of future help (1998) off topic fetch vs PCS photomaster (1997) searchable list archive (1997) WC TableGrinder (1997) [date] problem with %d%m%Y (1998) question: search return in order (1997) Resume Catalog ? (1997) [Sum] function? (1997) Re(2): text area input and convertchars (2002) showif and cart (1997) Help SM: Duplicate cart #'s - still! (2003) WebCat name recognition (1998) Duplicate Cart ID (2001) Seeking Better Display of results... (1997) PSC recommends what date format yr 2000??? (1997) can WC render sites out? (1997) WebDNA Trouble... (1999)