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:

How can I Add several Items into the cart at once? (1997) RE: creating writefile data from a nested search (1997) [WebDNA] Lookup inside grep?... (2011) timing out? (1997) [item] appears after 'remove last item' ... (1997) Authenticate (1997) Help! WebCat2 bug (1997) [shownext] and descending order (1997) [WebDNA] filter out the exclaimation point (2017) Time comparison question (1998) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) RE: Other Databases, access, filemaker etc. (2000) corrupted jpgs (2003) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Math with Time (1997) Postgresql books/resources? (2002) tcpconnect/tcpsend frustrations (2002) Date problems (1997) Problem upgrading from 3.0.8 to 4.0 on MS Windoze 98 / PWS (2000) Error.html (1997)