Re: SQL statements

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42547
interpreted = N
texte = I've been asked to make queries to a MySQL db using WebDNA, but I was surprised at how much downloading and configuring was needed in order to make this happen (unixODBC, etc.). Has anyone on the list successfully installed and configured all the software necessary in order to accomplish this?I didn't even know this was going to be an issue until I wrote an SQL context that kept returning Error: SQL not supported on the page.By the way, does all the ODBC stuff get installed on the server running WebDNA or the other one running MySQL?On 8/14/02 2:50 PM, Jason Tyler wrote:> I just recently spent way, way, way too much time fighting with a > similar setup. (you are running OS X right??) > > It was recommended by Simon Cotsworth to give up and buy MacODBC from > theKompany.com for $10. It installs easily, though a bit quirky and > works perfectly. I can send you a full copy of the steps. > > Alternatively if you're running 10.2 (according to sites it's now > shipping) there is a built in ODBC manager based on iOdbc. Can anyone > from SmithMicro comment on support for this feature since 10.2 is now > in public hands? > > -Jason Tyler > > On Wednesday, August 14, 2002, at 03:32 PM, dale's stuff wrote: > >> I am also getting ready to start dealing with a huge db in MySQL - >> can't get the darn unixodbc installed though :( >> >> I am considering trying out Pstgresql (spelling?) as the odbc stuff is >> already installed on my system for it. Has anyone had any experience >> using it over mysql with Webcat? >> >> In this case the DB is about 1.5 gig in size (including indexes) so >> not really practical for putting in a webcat db - that and it will >> probably only be accessed a few hundred times per day once the initial >> matching is done. >> >> On Wednesday, August 14, 2002, at 06:56 PM, Ben Swihart wrote: >> >>> I'm about to build a pretty large MySQL database that will be queried >>> by >>> webDNA. Does the [sql] context accept ANY sql query? Has anyone out >>> there >>> encountered any problems with this interface? >>> >>> Ben M. Swihart >>> Web Designer, SysAdmin : The GoTriCities Network --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL statements (Jason Tyler 2002)
  2. Re: SQL statements (Ben Swihart 2002)
  3. Re: SQL statements (Bjørn Are Solstad 2002)
  4. Re: SQL statements (John Peacock 2002)
  5. Re: SQL statements (Jason Tyler 2002)
  6. Re: SQL statements (Clint Davis 2002)
  7. Re: SQL statements (dale's stuff 2002)
  8. Re: SQL statements (Jason Tyler 2002)
  9. Re: SQL statements (John Peacock 2002)
  10. Re: SQL statements (dale's stuff 2002)
  11. Re: SQL statements (Pedro Rivera 2002)
  12. Re: SQL statements (Jesse Williams-Proudman 2002)
  13. Re: SQL statements (Ben Swihart 2002)
  14. Re: SQL statements (Pedro Rivera 2002)
  15. SQL statements (Ben Swihart 2002)
I've been asked to make queries to a MySQL db using WebDNA, but I was surprised at how much downloading and configuring was needed in order to make this happen (unixODBC, etc.). Has anyone on the list successfully installed and configured all the software necessary in order to accomplish this?I didn't even know this was going to be an issue until I wrote an SQL context that kept returning Error: SQL not supported on the page.By the way, does all the ODBC stuff get installed on the server running WebDNA or the other one running MySQL?On 8/14/02 2:50 PM, Jason Tyler wrote:> I just recently spent way, way, way too much time fighting with a > similar setup. (you are running OS X right??) > > It was recommended by Simon Cotsworth to give up and buy MacODBC from > theKompany.com for $10. It installs easily, though a bit quirky and > works perfectly. I can send you a full copy of the steps. > > Alternatively if you're running 10.2 (according to sites it's now > shipping) there is a built in ODBC manager based on iODBC. Can anyone > from SmithMicro comment on support for this feature since 10.2 is now > in public hands? > > -Jason Tyler > > On Wednesday, August 14, 2002, at 03:32 PM, dale's stuff wrote: > >> I am also getting ready to start dealing with a huge db in MySQL - >> can't get the darn unixODBC installed though :( >> >> I am considering trying out Pstgresql (spelling?) as the ODBC stuff is >> already installed on my system for it. Has anyone had any experience >> using it over mysql with Webcat? >> >> In this case the DB is about 1.5 gig in size (including indexes) so >> not really practical for putting in a webcat db - that and it will >> probably only be accessed a few hundred times per day once the initial >> matching is done. >> >> On Wednesday, August 14, 2002, at 06:56 PM, Ben Swihart wrote: >> >>> I'm about to build a pretty large MySQL database that will be queried >>> by >>> webDNA. Does the [SQL] context accept ANY sql query? Has anyone out >>> there >>> encountered any problems with this interface? >>> >>> Ben M. Swihart >>> Web Designer, SysAdmin : The GoTriCities Network --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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://search.smithmicro.com/ Clint Davis

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:

Requiring that certain fields be completed (1997) Bulk capture for Authorize.net (2004) [ShowIf] a either fields are blank (1998) color and size options / ARCHIVES (1997) Aaron kant add (or whatever it was) (2000) Dates - Search and Sorting (1999) Online expense management tool (2004) ListFiles Bug (1998) Upgrading old WebCat Database Files (1997) Looking for a host (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) webcat 2.1 new cart fields - please explain more (1998) DON'T use old cart file! (1997) WebCatalog f2 Installation (1997) WebCat b13 CGI -shownext- (1997) Great product and great job ! (1997) MacAuthorize order data fields WAS:How To question... (1997) Webcatalog and foreign languages (1998) Pre-flight public flag (1997) Further tests with the infamous shipCost (1997)