Search puzzle...selectSearch2databases

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 58925
interpreted = N
texte = Hello folks.I have a puzzle that has frozen my brain today...Would like to look in my photo.db sort the libraries and then find out how many photos are in each library and display them as such.daves library -(25)I have two databases. The first is a photo library where I add libraries.Then I add photos to another database, using a pull down that renders libraries from library.db.I would like to display the number of photos in each library, but that means I have to traverse the photo.db, find all the libraries and total up the number of photos that are associated with each library and display that in the pull down select.I was thinking something like this.......Select a Library[search db=library.db&neidNumberdata=[blank]&LIBRARYNAMEsumm=t&LIBRARYNAMEsort=1 &LIBRARYNAMEsdir=as][founditems][LIBRARYNAME][search db=photos.db&geLIBRARYdata=[blank]&LIBRARYsumm=t........- Here's where I'm lost. How do I sort the LIBRARY in photo.db and find the total pictures per library. The code goes on to establish a value named _numphoto which is the numerice value.[text]_numphotos=[numfound][/text][/search]- ([_numphotos])[/founditems][/search]  > Values in library.db are LIBRARYNAME > Values in photos.db are LIBRARYThanks!!!David CateDirectorThe GoTriCities Networkhttp://www.gotricities.net-------------------------------------------------------------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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Search puzzle...selectSearch2databases ( "Gary Krockover" 2004) Re: Search puzzle...selectSearch2databases ( Jim Lanford 2004) Search puzzle...selectSearch2databases ( David Cate 2004)

Hello folks.I have a puzzle that has frozen my brain today...Would like to look in my photo.db sort the libraries and then find out how many photos are in each library and display them as such.daves library -(25)I have two databases. The first is a photo library where I add libraries.Then I add photos to another database, using a pull down that renders libraries from library.db.I would like to display the number of photos in each library, but that means I have to traverse the photo.db, find all the libraries and total up the number of photos that are associated with each library and display that in the pull down select.I was thinking something like this.......Select a Library[search db=library.db&neidNumberdata=[blank]&LIBRARYNAMEsumm=t&LIBRARYNAMEsort=1 &LIBRARYNAMEsdir=as][founditems][LIBRARYNAME][search db=photos.db&geLIBRARYdata=[blank]&LIBRARYsumm=t........- Here's where I'm lost. How do I sort the LIBRARY in photo.db and find the total pictures per library. The code goes on to establish a value named _numphoto which is the numerice value.[text]_numphotos=[numfound][/text][/search]- ([_numphotos])[/founditems][/search]  > Values in library.db are LIBRARYNAME > Values in photos.db are LIBRARYThanks!!!David CateDirectorThe GoTriCities Networkhttp://www.gotricities.net-------------------------------------------------------------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://webdna.smithmicro.com/ David Cate

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:

formatting search results (1999) Updating checkboxes made easy !!! (1998) [text] variable assignment within [search] context (2000) Multiple fields on 1 input (1997) [quantity] - spoke too soon (1997) search not so good (2002) Striping Characters (1998) [isfolder] and [filename] (1997) Generating Options for a Form. (1997) HTML text cannot be copied to clipboard? (1999) passing large amount of text in post form (2005) [WebDNA] Friday's.. WIP thread (2009) Banner DNA (1997) WC 2.0 frames feature (1997) RE: [WebDNA] Suddenly, lots of WebDNA problems with FastCGI (2013) Authenticate (1997) TCPConnect / Current Temperature (2004) Size Limitation through a POST via SSL? (2005) emailer (1997) Grepping text variable tags (was: No subject given) (2000)