Re: FEA REQ: One .hdr, multiple .db's

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52372
interpreted = N
texte = >>>HOWEVER, doing a join on multiple database files when searching would be REALLY nice. I realize, though, that this is one step away from doing SQL and at that point why not just use a well supported SQL database on the rear end. We are working on this now. Native support for MySQL/Oracle/SQL Server, via the appropriate C++ APIs. A sneak peek: [SQLConnect var=SQL_1&server=123.123.12.12&type=mysql&username=...&pass=...&etc...] This would create a persistent connection to the SQL server for the duration of the template execution. Then one or more [SQLRun] contexts can be used, for example: [SQLRun ref=SQL_1&command=] [founditems] .... [/founditems] [/SQLRun] [SQLRun ref=SQL_1&command=] [founditems] .... [/founditems] [/SQLRun] and so on... The connection will terminate when template execution ends, or when [SQLDetach ref=...] is used. -----Original Message----- From: John Hill [mailto:johnh@genericaddress.com] Sent: Wednesday, August 20, 2003 11:05 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: FEA REQ: One .hdr, multiple .db's There are so many work-arounds for this right now that it doesn't seem like something that would benefit a lot of people. HOWEVER, doing a join on multiple database files when searching would be REALLY nice. I realize, though, that this is one step away from doing SQL and at that point why not just use a well supported SQL database on the rear end. >That sounds like it could be useful. Although it might get confusing, after >a while, remembering which hdr files belong to which databases, when viewing >web-site contents. Any other opinions out there with regard to this feature >request? > >-----Original Message----- >From: Matthew Bohne [mailto:matthewbohne@sanduskyregister.com] >Sent: Wednesday, August 20, 2003 6:50 AM >To: WebDNA-Talk@talk.smithmicro.com >Subject: FEA REQ: One .hdr, multiple .db's > > >Something like: > >[search db=august2003.db&geskudatarq=0&hdr=calendar.hdr] > >-- >Matthew C. Bohne >Web Developer >Sandusky Register >314 W. Market St. >Sandusky, OH 44870 >419-625-5500 ext. 253 >matthewbohne@sanduskyregister.com >http://www.sanduskyregister.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://webdna.smithmicro.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://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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://webdna.smithmicro.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: FEA REQ: One .hdr, multiple .db's ( "WebDna @" 2003)
  2. Re: FEA REQ: One .hdr, multiple .db's ( Terry Wilson 2003)
  3. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  4. Re: FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
  5. Re: FEA REQ: One .hdr, multiple .db's ( "Gary Krockover" 2003)
  6. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  7. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  8. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  9. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  10. Re: FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
  11. Re: FEA REQ: One .hdr, multiple .db's ( Terry Wilson 2003)
  12. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  13. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  14. Re: FEA REQ: One .hdr, multiple .db's ( "Scott Anderson" 2003)
  15. Re: FEA REQ: One .hdr, multiple .db's ( "Scott Anderson" 2003)
  16. Re: FEA REQ: One .hdr, multiple .db's ( Stuart Tremain 2003)
  17. Re: FEA REQ: One .hdr, multiple .db's ( Donovan 2003)
  18. Re: FEA REQ: One .hdr, multiple .db's ( Scott Anderson 2003)
  19. Re: FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
  20. Re: FEA REQ: One .hdr, multiple .db's ( Brian Fries 2003)
  21. Re: FEA REQ: One .hdr, multiple .db's ( John Hill 2003)
  22. Re: FEA REQ: One .hdr, multiple .db's ( John Peacock 2003)
  23. Re: FEA REQ: One .hdr, multiple .db's ( "Scott Anderson" 2003)
  24. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  25. Re: FEA REQ: One .hdr, multiple .db's ( Donovan 2003)
  26. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  27. Re: FEA REQ: One .hdr, multiple .db's ( "WebDna @" 2003)
  28. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  29. FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
>>>HOWEVER, doing a join on multiple database files when searching would be REALLY nice. I realize, though, that this is one step away from doing SQL and at that point why not just use a well supported SQL database on the rear end. We are working on this now. Native support for MySQL/Oracle/SQL Server, via the appropriate C++ APIs. A sneak peek: [SQLConnect var=SQL_1&server=123.123.12.12&type=mysql&username=...&pass=...&etc...] This would create a persistent connection to the SQL server for the duration of the template execution. Then one or more [SQLRun] contexts can be used, for example: [SQLRun ref=SQL_1&command=] [founditems] .... [/founditems] [/SQLRun] [SQLRun ref=SQL_1&command=] [founditems] .... [/founditems] [/SQLRun] and so on... The connection will terminate when template execution ends, or when [SQLDetach ref=...] is used. -----Original Message----- From: John Hill [mailto:johnh@genericaddress.com] Sent: Wednesday, August 20, 2003 11:05 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: FEA REQ: One .hdr, multiple .db's There are so many work-arounds for this right now that it doesn't seem like something that would benefit a lot of people. HOWEVER, doing a join on multiple database files when searching would be REALLY nice. I realize, though, that this is one step away from doing SQL and at that point why not just use a well supported SQL database on the rear end. >That sounds like it could be useful. Although it might get confusing, after >a while, remembering which hdr files belong to which databases, when viewing >web-site contents. Any other opinions out there with regard to this feature >request? > >-----Original Message----- >From: Matthew Bohne [mailto:matthewbohne@sanduskyregister.com] >Sent: Wednesday, August 20, 2003 6:50 AM >To: WebDNA-Talk@talk.smithmicro.com >Subject: FEA REQ: One .hdr, multiple .db's > > >Something like: > >[search db=august2003.db&geskudatarq=0&hdr=calendar.hdr] > >-- >Matthew C. Bohne >Web Developer >Sandusky Register >314 W. Market St. >Sandusky, OH 44870 >419-625-5500 ext. 253 >matthewbohne@sanduskyregister.com >http://www.sanduskyregister.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://webdna.smithmicro.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://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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://webdna.smithmicro.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://webdna.smithmicro.com/ "Scott Anderson"

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:

All choice in popups (1997) Username/Password with [Protect] (2000) really wierd browser truncating (1997) Dynamic Pop up menu? (1997) Error Lob.db records error message not name (1997) Bug or syntax error on my part? (1997) Trouble Searching (1999) Big Databases (1997) How much is too much? I can never remember the answer. (2002) Img in goodpath (2001) FlushDatabase Suggestion (1998) YACBQ.....(Yet another checkbox question) (2000) problems with WebCat-Plugin (1997) problems with 2 tags (1997) can you take a look (2003) WebCat2b12plugin - [search] is broken ... not! (1997) [TCPConnect] Errors (2003) [Shownext] (1997) Odd [math] behaviour (2003) Emailer Erreur 551 (2001)