Re: Summary layout

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15006
interpreted = N
texte = Marty Schmid wrote: > > Pat, > Here's a code snippet you posted earlier. I'm curious as to whether this > was actually working for you. No. Sorry, but I don't thing is allowed - I think the commented math thing only allows numbers. I tested this approach & it works, is fast & efficient:-------------------------------- [search db=cars.db&gebranddata=0&brandsort=1&typesort=2][founditems] [hideif [lookup db=cars.db&value=[math]lastsku[/math]&lookinfield=sku&returnfield=brand]=[brand]] [/hideif] [/hideif] [/founditems]
[brand]
[sku][type][color]
[/search] --------------------------------The database I tested it with is:-------------------------------- sku brand type color 1 ford car red 2 ford truck red 3 ford van white 4 ford car blue 5 chevy car orange 6 chevy truck grey 7 chevy van yellow 8 chevy car purple 9 yugo wagon green 10 honda motorcycle silver 11 gm van white --------------------------------Notes: You must sort the field you're summarizing so WC can see when it changes MAKE SURE SKU IS A NUMBER - NOT TEXT because won't hold text strings - only numbers.Sorry about my first batch of crap - hope this makes up for any time I may have cost you.Pat Associated Messages, from the most recent to the oldest:

    
  1. Re: Summary layout (Marty Schmid 1997)
  2. Re: Summary layout (Pat McCormick 1997)
  3. Re: Summary layout (Marty Schmid 1997)
  4. Re: Summary layout (Pat McCormick 1997)
  5. Re: Summary layout (Pat McCormick 1997)
  6. Re: Summary layout (Grant Hulbert 1997)
  7. Summary layout (Pat McCormick 1997)
Marty Schmid wrote: > > Pat, > Here's a code snippet you posted earlier. I'm curious as to whether this > was actually working for you. No. Sorry, but I don't thing [math]textholder=[textfield][/math]> is allowed - I think the commented math thing only allows numbers. I tested this approach & it works, is fast & efficient:-------------------------------- [search db=cars.db&gebranddata=0&brandsort=1&typesort=2][founditems] [hideif [lookup db=cars.db&value=[math]lastsku[/math]&lookinfield=sku&returnfield=brand]=[brand]] [/hideif] [/hideif] [math]lastsku=[sku][/math]>[/founditems]
[brand]
[sku][type][color]
[/search] --------------------------------The database I tested it with is:-------------------------------- sku brand type color 1 ford car red 2 ford truck red 3 ford van white 4 ford car blue 5 chevy car orange 6 chevy truck grey 7 chevy van yellow 8 chevy car purple 9 yugo wagon green 10 honda motorcycle silver 11 gm van white --------------------------------Notes: You must sort the field you're summarizing so WC can see when it changes MAKE SURE SKU IS A NUMBER - NOT TEXT because [math]lastsku=[sku][/math]> won't hold text strings - only numbers.Sorry about my first batch of crap - hope this makes up for any time I may have cost you.Pat Pat McCormick

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:

ShowNext & Showif together (1999) Apache on windows and WebDNA (2004) Dreamweaver Extensions (2001) Webmerchant + Hubby (1998) Can't test the beta (2000) Wanted: More Math Functions (or, Can You Solve This?) (1997) [WebDNA] New list (2008) Plugin or CGI or both (1997) OT Hosting Q again. (2002) WC --> printer (1998) Big Databases (1997) SAVECART (1997) Emailer choke (1997) Lastautonumber (2005) WebCatalog f2 Installation (1997) Multiple 'Users.db' files not possible (1997) WCS Newbie question (1997) OK, here's a new one (2002) Time for a hard questions. (1997) Dumb Question about Docs (1997)