Re: So many lookers, hey smith micro

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54341
interpreted = N
texte = On Thursday, November 20, 2003, at 01: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. It is that easy. In fact, with the current version (we're still using 4.5.1 actually) searching with sql seems easier than with WebDNA... Here is a simple query with our db via ODBC: [SQL dsn=OnlineStore&statement=select * from department_order where cart_id = '[cart]';] Found [NumFound] items
[FoundItems] [first_name] [last_name] ...
[/FoundItems] [/SQL] All the connect info -- username, password, database, hostname, etc. -- are all in our dsn, which is in a secure location on the file system. -lucas On Thursday, November 20, 2003, at 01:27 AM, Jesse Proudman wrote: > > On Nov 20, 2003, at 1:21 AM, Nitai @ ComputerOil wrote: > >> No, we will have to use SQL statements, which you will have to define >> in a >> "variable" and then use that variable further on the template to >> search in >> the SQL-DB. > > 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. > > -- > Jesse Williams-Proudman > Blue Box Development :: Custom Web Solutions > +1.206.778.8777 :: jesse@blueboxdev.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)
On Thursday, November 20, 2003, at 01: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. It is that easy. In fact, with the current version (we're still using 4.5.1 actually) searching with sql seems easier than with WebDNA... Here is a simple query with our db via ODBC: [SQL dsn=OnlineStore&statement=select * from department_order where cart_id = '[cart]';] Found [NumFound] items
[founditems] [first_name] [last_name] ...
[/FoundItems] [/SQL] All the connect info -- username, password, database, hostname, etc. -- are all in our dsn, which is in a secure location on the file system. -lucas On Thursday, November 20, 2003, at 01:27 AM, Jesse Proudman wrote: > > On Nov 20, 2003, at 1:21 AM, Nitai @ ComputerOil wrote: > >> No, we will have to use SQL statements, which you will have to define >> in a >> "variable" and then use that variable further on the template to >> search in >> the SQL-DB. > > 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. > > -- > Jesse Williams-Proudman > Blue Box Development :: Custom Web Solutions > +1.206.778.8777 :: jesse@blueboxdev.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/ Lucas Rockwell

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:

username = 115 (1999) Spell Check (2003) & in Lookups (1997) Re:2nd WebCatalog2 Feature Request (1996) Navigator 4.01 (1997) WebCat2 - Getting to the browser's username/password data (1997) [LOOKUP] (1997) Sizes/Colors Options (2006) WC2b15 File Corruption (1997) too many nested tags ... (1997) Separate SSL Server (1997) [isfile] ? (1997) [WriteFile] problems (1997) restart needed???? (1997) off topic - dna snipets (1997) [Announce]: Web server security and password protection (1997) Location of Browser Info.txt file (1997) Explorer 3.0 (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) [WebDNA] Date weirdness (2014)