Re: SQL statements

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42615
interpreted = N
texte = Sure, send me (us) the steps!-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Jason Tyler Sent: Wednesday, August 14, 2002 3:51 PM To: WebCatalog Talk Subject: Re: SQL statements 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 TylerOn 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 > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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)
Sure, send me (us) the steps!-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Jason Tyler Sent: Wednesday, August 14, 2002 3:51 PM To: WebCatalog Talk Subject: Re: SQL statements 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 TylerOn 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 > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ Ben Swihart

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:

[WebDNA] [FormVariables] Template (2013) [WebDNA] HTML/OS vs. WebDNA ? (2008) New iMac, now ... how do I make webdna serve .html files? (2005) question: webmerchant connection (1997) [isfile] ? (1997) Template transformed itself into a database? (1998) How far do [showif]s go? (1997) WebCat2b13MacPlugIn - [include] (1997) OT: 800x600 (2003) [WebDNA] 30 Minute Cookies (2016) Searching multiple Databases (1997) Setting a range in a search (1998) Server crash (1997) PSC recommends what date format yr 2000??? (1997) Webcat Hosting in London or UK (2003) Multiple instances of database (2003) updating with ProductEditor (1998) Thanks Grant (1997) Nesting format tags (1997) Using Currencies other than Dollars (1997)