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:

WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) New 4.5 installer (2002) [showif] with ! (2000) Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998) can WC render sites out? (1997) Nested tags count question (1997) shipcost (1997) Time for a hard questions. (1997) PCS Frames (1997) GuestBook example (1997) The & Problem (1998) HELP!? (2002) Appending Record Prob (2001) Caching [include] files ... (1997) New syntax feedback for 4.0 (2000) LetterRip and WebCat (1998) Search logic? (1998) (slightly off) using menu and [search] (1998) Error:Too many nested [xxx] contexts (1997) [append] vs. [appendfile] delta + question? (1997)