Re: So many lookers, hey smith micro

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54340
interpreted = N
texte = Well...I really did not want to get into specifics as there may still be changes. >Then you need to "create" the statement: >[SQLexecute theconnection and a var] >Select * from table >[/sqlexecute] This not only creates the SQL query, it executes it. SQL statements can become very large and complex, so we thought it best to wrap the SQL statement (and its execution) in its own context. Now that the '[founditems]' is freed, this context can be neatly tucked away into an include file, pre-parse script, or function definition. >[sqlresult the var above] >[founditems] >[/founditems] >[/sqlresult] Correct. The sqlresult context provides 'space' (in lieu of a wrapping search context) for the retrieval of SQL result details, numfound, field META data, etc... This is far from a complete description of the new native SQL support, but it's a nice sneak peek. -----Original Message----- From: Nitai @ ComputerOil [mailto:nitai@computeroil.com] Sent: Thursday, November 20, 2003 1:41 AM To: WebDNA Talk Subject: Re: So many lookers, hey smith micro On 20/11/03 10:27 AM, "Jesse Proudman" wrote: > That's a bizarre way to do it... wonder why they don't just have > [search sql=DATABASE&query=[query]]. Guess it's time to go take the > Database Design course. I hope Scott allows me to go on, if not he will tell:-) Anyhow, for SQL to work you need to issue a connection: [Sqlconnect xxxxxxx] Then you need to "create" the statement: [SQLexecute theconnection and a var] Select * from table [/sqlexecute] [sqlresult the var above] [founditems] [/founditems] [/sqlresult] Seems to me a normal way to interact with SQL. But in any case a "normal" WebDNA like search would be even cooler. Then Scott would have to come up with a conversion table which will convert the WebDNA tag to SQL statements:-) Yo, that would be something, or Scott? Nitai -- Redakto - Content Management that simply works ComputerOil® GmbH Unionstrasse 4 8032 Zürich / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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: So many lookers, hey smith micro ( "Scott Anderson" 2003)
  2. Re: So many lookers, hey smith micro ( Kenneth Grome 2003)
  3. Re: So many lookers, hey smith micro ( Lucas Rockwell 2003)
  4. Re: So many lookers, hey smith micro ( "Scott Anderson" 2003)
  5. Re: So many lookers, hey smith micro ( "Scott Anderson" 2003)
  6. Re: So many lookers, hey smith micro ( Glenn Busbin 2003)
  7. Re: So many lookers, hey smith micro ( Kenneth Grome 2003)
  8. Re: So many lookers, hey smith micro ( Clint Davis 2003)
  9. Re: So many lookers, hey smith micro ( "flingo" 2003)
  10. Re: So many lookers, hey smith micro ( "Nitai @ ComputerOil" 2003)
  11. Re: So many lookers, hey smith micro ( Alain Russell 2003)
  12. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  13. Re: So many lookers, hey smith micro ( Alain Russell 2003)
  14. Re: So many lookers, hey smith micro ( "Nitai @ ComputerOil" 2003)
  15. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  16. Re: So many lookers, hey smith micro ( "Nitai @ ComputerOil" 2003)
  17. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  18. Re: So many lookers, hey smith micro ( Alain Russell 2003)
  19. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  20. Re: So many lookers, hey smith micro ( "Nitai @ ComputerOil" 2003)
  21. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  22. Re: So many lookers, hey smith micro ( "Nitai @ ComputerOil" 2003)
  23. Re: So many lookers, hey smith micro ( Matthew A Perosi 2003)
  24. Re: So many lookers, hey smith micro ( Donovan Brooke 2003)
  25. Re: So many lookers, hey smith micro ( Kalin Mintchev 2003)
  26. Re: So many lookers, hey smith micro ( Glenn Busbin 2003)
  27. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  28. Re: So many lookers, hey smith micro ( Kenneth Grome 2003)
  29. Re: So many lookers, hey smith micro ( Stuart Tremain 2003)
  30. Re: So many lookers, hey smith micro ( CN Stuff 2003)
  31. Re: So many lookers, hey smith micro ( Alain Russell 2003)
  32. Re: So many lookers, hey smith micro ( "Scott Anderson" 2003)
  33. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  34. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  35. Re: So many lookers, hey smith micro ( "Scott Anderson" 2003)
  36. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  37. Re: So many lookers, hey smith micro ( Kenneth Grome 2003)
  38. Re: So many lookers, hey smith micro ( Phillip Bonesteele 2003)
  39. Re: So many lookers, hey smith micro ( Kalin Mintchev 2003)
  40. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  41. Re: So many lookers, hey smith micro ( "WebDna @" 2003)
  42. Re: So many lookers, hey smith micro ( Kalin Mintchev 2003)
  43. Re: So many lookers, hey smith micro ( Andrew Thompson 2003)
  44. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  45. Re: So many lookers, hey smith micro ( Kenneth Grome 2003)
  46. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  47. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  48. Re: So many lookers, hey smith micro ( Kalin Mintchev 2003)
  49. Re: So many lookers, hey smith micro ( Jesse Proudman 2003)
  50. Re: So many lookers, hey smith micro ( Andrew Thompson 2003)
  51. Re: So many lookers, hey smith micro ( Kenneth Grome 2003)
  52. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  53. Re: So many lookers, hey smith micro ( Andrew Thompson 2003)
  54. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  55. Re: So many lookers, hey smith micro ( Andrew Thompson 2003)
  56. Re: So many lookers, hey smith micro ( "Andrew Simpson" 2003)
  57. Re: So many lookers, hey smith micro ( Alain Russell 2003)
  58. Re: So many lookers, hey smith micro ( Marc Kaiwi 2003)
  59. So many lookers, hey smith micro ( Jeff Logan 2003)
Well...I really did not want to get into specifics as there may still be changes. >Then you need to "create" the statement: >[SQLexecute theconnection and a var] >Select * from table >[/sqlexecute] This not only creates the SQL query, it executes it. SQL statements can become very large and complex, so we thought it best to wrap the SQL statement (and its execution) in its own context. Now that the '[founditems]' is freed, this context can be neatly tucked away into an include file, pre-parse script, or function definition. >[sqlresult the var above] >[founditems] >[/founditems] >[/sqlresult] Correct. The sqlresult context provides 'space' (in lieu of a wrapping search context) for the retrieval of SQL result details, numfound, field META data, etc... This is far from a complete description of the new native SQL support, but it's a nice sneak peek. -----Original Message----- From: Nitai @ ComputerOil [mailto:nitai@computeroil.com] Sent: Thursday, November 20, 2003 1:41 AM To: WebDNA Talk Subject: Re: So many lookers, hey smith micro On 20/11/03 10:27 AM, "Jesse Proudman" wrote: > That's a bizarre way to do it... wonder why they don't just have > [search sql=DATABASE&query=[query]]. Guess it's time to go take the > Database Design course. I hope Scott allows me to go on, if not he will tell:-) Anyhow, for SQL to work you need to issue a connection: [Sqlconnect xxxxxxx] Then you need to "create" the statement: [SQLexecute theconnection and a var] Select * from table [/sqlexecute] [sqlresult the var above] [founditems] [/founditems] [/sqlresult] Seems to me a normal way to interact with SQL. But in any case a "normal" WebDNA like search would be even cooler. Then Scott would have to come up with a conversion table which will convert the WebDNA tag to SQL statements:-) Yo, that would be something, or Scott? Nitai -- Redakto - Content Management that simply works ComputerOil® GmbH Unionstrasse 4 8032 Zürich / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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:

Version 4? (2000) Mac: LModelDirector bug fix (1997) Mime Headers for Mail (1998) WebCat2b15MacPlugin - showing [math] (1997) webcat (2000) Please post more "exceptions to the rules" ... (2005) problems with 2 tags shakur (1997) WebDNA-Talk Digest mode broken (1997) Revisit: speed test (2002) counting characters and/or words (1997) Occasional crashes with $remove (1997) too many nested tags ... (1997) Hyperboard users wanting a quoted message (1998) RAM issue (2006) photo upload snippet (2006) website pro trouble (1998) [group] ? (1997) New Year Trigger Problem (2003) pc (1997) WebCat2 - Getting to the browser's username/password data (1997)