Re: using listfiles to build a database?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27317
interpreted = N
texte = If you need unique numbers you can put [index] on the end of the [cart][index]or you could make your first record a cart number then just keep adding one to it for every new record. You would need to search you db find the largest number then add one to it and use this new number as your next unique number[search db=yourdb.db&neCARTIDdatarq=findall&CARTIDsort=1&CARTIDtype=num] [math show=f]NEWCARTID=0[founditems]+[CARTID][/founditems]+1[/math] [/search]On WC 3.0.7 crashing on Solaris: I sent the problem to QCTechnical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Dale Therio Sent: Thursday, February 10, 2000 1:50 AM To: WebCatalog Talk Subject: Re: using listfiles to build a database? WebCatalog 3.0.7 on Solaris (and WebCat still keeps quiting, with no response from SM yet).Hi All,I looked at Micheals code fromthe archive and have only (I think) one minor problem with adapting it for what I am tring to do. I am trying to navigate down the hierarchy of a hard drive to get the file names and stick them in a database. This is done with [listfiles]. The other thing I am trying to do is create a unique [cart] number for each of these files as I build the database. Unfortunately it appears that looping through a [listfiles] doesn't cause [cart] to refresh I guess because it is the same single page.So the question is, how do I get a unique [cart] value for each file? I want to use the [cart] as I will later be manually adding new files to this database and want to insure that all of the numbers are unique (as described they will be if I continue to use the [cart] tag).Thanks! Wed, 9 Feb 2000 11:50:35>>Hi all, >> >>I need to build a database from files on the hard drive. I am thinking >I >>should use listfiles then pull the data and append it to a file to >buiild my >>DB. How would I get listfiles to work down the directories and get the >other >>files? >> >>I am using WebCat 3.07 on Solaris with apache. >> >>Thanks >Therio, >If you make the [listfiles] an include in your template and showif >[isfolder]=T you can descend the dir tree. >I posted similar code to delete shopping carts recursively. If you >search the archives you should be able to modify it to suit your >needs. >Hope this helps. > > > >Micheal O Shea Email:micheal@com4u.ch >com4u.ch http://www.com4u.ch >Breitistrasse 7B PGP key available upon request. > >CH-5506 Maegenwil Tel: +41 62 896 46 26 >Switzerland > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging >Server. >To end your Mail problems go to . > >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 > -- Dale Therio Dresdner Kleinwort Benson Research +49 (0) 69 26 31 9977 (o) Jürgen-Ponto-Platz 1 +49 (0) 69 26 31 1379 (f) 60301 Frankfurt +49 (0) 170 93 43 610 (m) Germany ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: using listfiles to build a database? more (Dale Therio 2000)
  2. Re: using listfiles to build a database? more (Kenneth Grome 2000)
  3. Re: using listfiles to build a database? more (Therio, Dale 2000)
  4. Re: using listfiles to build a database? more (Kenneth Grome 2000)
  5. Re: using listfiles to build a database? more (WebDNA Support 2000)
  6. Re: using listfiles to build a database? (WebDNA Support 2000)
  7. Re: using listfiles to build a database? more (Joseph D'Andrea 2000)
  8. Re: using listfiles to build a database? more (Dale Therio 2000)
  9. Re: using listfiles to build a database? more (Michael O Shea 2000)
  10. Re: using listfiles to build a database? more (Dale Therio 2000)
  11. Re: using listfiles to build a database? more (Michael O Shea 2000)
  12. Re: using listfiles to build a database? more (Michael O Shea 2000)
  13. Re: using listfiles to build a database? more (Therio, Dale 2000)
  14. Re: using listfiles to build a database? more (Dale Therio 2000)
  15. Re: using listfiles to build a database? (Michael O Shea 2000)
  16. Re: using listfiles to build a database? (Kenneth Grome 2000)
  17. Re: using listfiles to build a database? (Dale Therio 2000)
  18. Re: using listfiles to build a database? (Therio, Dale 2000)
  19. Re: using listfiles to build a database? (Michael O Shea 2000)
  20. using listfiles to build a database? (Therio, Dale 2000)
If you need unique numbers you can put [index] on the end of the [cart][index]or you could make your first record a cart number then just keep adding one to it for every new record. You would need to search you db find the largest number then add one to it and use this new number as your next unique number[search db=yourdb.db&neCARTIDdatarq=findall&CARTIDsort=1&CARTIDtype=num] [math show=f]NEWCARTID=0[founditems]+[CARTID][/founditems]+1[/math] [/search]On WC 3.0.7 crashing on Solaris: I sent the problem to QCTechnical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Dale Therio Sent: Thursday, February 10, 2000 1:50 AM To: WebCatalog Talk Subject: Re: using listfiles to build a database? WebCatalog 3.0.7 on Solaris (and WebCat still keeps quiting, with no response from SM yet).Hi All,I looked at Micheals code fromthe archive and have only (I think) one minor problem with adapting it for what I am tring to do. I am trying to navigate down the hierarchy of a hard drive to get the file names and stick them in a database. This is done with [listfiles]. The other thing I am trying to do is create a unique [cart] number for each of these files as I build the database. Unfortunately it appears that looping through a [listfiles] doesn't cause [cart] to refresh I guess because it is the same single page.So the question is, how do I get a unique [cart] value for each file? I want to use the [cart] as I will later be manually adding new files to this database and want to insure that all of the numbers are unique (as described they will be if I continue to use the [cart] tag).Thanks! Wed, 9 Feb 2000 11:50:35>>Hi all, >> >>I need to build a database from files on the hard drive. I am thinking >I >>should use listfiles then pull the data and append it to a file to >buiild my >>DB. How would I get listfiles to work down the directories and get the >other >>files? >> >>I am using WebCat 3.07 on Solaris with apache. >> >>Thanks >Therio, >If you make the [listfiles] an include in your template and showif >[isfolder]=T you can descend the dir tree. >I posted similar code to delete shopping carts recursively. If you >search the archives you should be able to modify it to suit your >needs. >Hope this helps. > > > >Micheal O Shea Email:micheal@com4u.ch >com4u.ch http://www.com4u.ch >Breitistrasse 7B PGP key available upon request. > >CH-5506 Maegenwil Tel: +41 62 896 46 26 >Switzerland > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging >Server. >To end your Mail problems go to . > >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 > -- Dale Therio Dresdner Kleinwort Benson Research +49 (0) 69 26 31 9977 (o) Jürgen-Ponto-Platz 1 +49 (0) 69 26 31 1379 (f) 60301 Frankfurt +49 (0) 170 93 43 610 (m) Germany ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 WebDNA Support

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:

Showif, Hideif reverse logic ? (1997) Cart Number sequence (1997) hideif/showif causes error if wrapped around searches (2003) [WebDNA] WebDNA Host needed urgently (2013) Moment of Thanks (1997) WebCat2: Items xx to xx shown, etc. (1997) multiple prices (1998) Re:no [search] with NT (1997) Misunderstanding?? (1997) DON'T use old cart file! (1997) Thanks Grant (1997) [format xs] freeze (1997) webdelivery.html and webna (1997) SSL data to/from webcatalog? (2000) Search design (1997) HELP! Search finding too much! (1998) 2nd WebCatalog2 Feature Request (1996) Pull Down Search (2000) IIS4 (1998) Meet your competition (2000)