Re: So many lookers, hey smith micro

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54319
interpreted = N
texte = as long as we only have to setup the connection ONCE and not every time w= e search a database. and you definitely want to use SQL syntax... trying to emulate: select * from tbl_users left outer join tbl_group on tbl_users.group_id =3D= tbl_group.group_id and tbl_group.country_code exists in (select country_= code from tbl_country where tbl_country.taxcode is not null and tbl_count= ry.purchase =3D 'YES') order by tbl_user.username group by tbl_group.groupname limit 30; with eqFIELD_NAMEdatarq would be a waste of having the SQL database. > The cool thing about native SQL support is unions, joins etc .. not > having to nest multiple webDNA searches all the time .. > > On 20/11/2003, at 10:50 PM, Nitai @ ComputerOil wrote: > > > On 20/11/03 10:46 AM, "Jesse Proudman" wrote:= > > > >> That way actually seem too bad... I wish I knew enough SQL to conver= t > >> my forum into a SQL system so it'd run faster... > > > > Honestly I don=C2=B9t think it is so hard to learn. I have made just = a > > simple > > Excel file that will show you how WebDNA tags are and compared to SQL= > > tags. > > I will send that over to you, nothing big just very simple. Maybe thi= s > > will > > help a little? > > > > Nitai > > > ------------------------------------------------------------- > 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)
as long as we only have to setup the connection ONCE and not every time w= e search a database. and you definitely want to use SQL syntax... trying to emulate: select * from tbl_users left outer join tbl_group on tbl_users.group_id =3D= tbl_group.group_id and tbl_group.country_code exists in (select country_= code from tbl_country where tbl_country.taxcode is not null and tbl_count= ry.purchase =3D 'YES') order by tbl_user.username group by tbl_group.groupname limit 30; with eqFIELD_NAMEdatarq would be a waste of having the SQL database. > The cool thing about native SQL support is unions, joins etc .. not > having to nest multiple webDNA searches all the time .. > > On 20/11/2003, at 10:50 PM, Nitai @ ComputerOil wrote: > > > On 20/11/03 10:46 AM, "Jesse Proudman" wrote:= > > > >> That way actually seem too bad... I wish I knew enough SQL to conver= t > >> my forum into a SQL system so it'd run faster... > > > > Honestly I don=C2=B9t think it is so hard to learn. I have made just = a > > simple > > Excel file that will show you how WebDNA tags are and compared to SQL= > > tags. > > I will send that over to you, nothing big just very simple. Maybe thi= s > > will > > help a little? > > > > Nitai > > > ------------------------------------------------------------- > 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/ "Andrew Simpson"

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:

WebCat2b13 Command Reference Doc error (1997) List Address Changed! (1998) RE: [WebDNA] Send URL Get without waiting for response (2014) pass a captured value (2004) Smart caching problems with 2.1b3? (1997) RE: E-mailer error codes (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) Error with [applescript] (1999) [OT] HTML Table Cell Problem (2003) DataBaseHelper Flawed (1997) Secure Server not remembering discounts (1998) [ModDate] & [ModTime] ? (1997) [ModDate] & [ModTime] ? (1997) Nested vs conditional (1997) WebCatalog for Postcards ? (1997) Removing [showif] makes a big difference in speed (1997) Search design (1997) New Plug-in and Type 11 errors (1997) orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000) selling? (2001)