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:
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:
Record size (1998)
Explorer 3.0/ Access Denied! (1997)
Multiple prices (1997)
Serial Number Question (1997)
mac os HOG? (2001)
Fun with Dates - revisited (1997)
[WebDNA] Stores (2013)
Rumpus/Typhoon modules included in Typhoon ... (1997)
Re:no [search] with NT (1997)
Search design (1997)
WebCat2 several catalogs? (1997)
ssl/empty cart problem (2003)
Cancel Subscription (1996)
Resume Catalog ? (1997)
[WebDNA] Image resizing on the fly (2012)
Navigator 4.01 (1997)
WebDNA Book? (2003)
[WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (2012)
Global variables are not always global ... (2000)
RE: extended ASCII with middle command (1999)