Re: SQL statements
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42544
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Jason Tyler
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:
Summary search -- speed (1997)
[cart]= (2004)
Shownext problems (1999)
PCS Frames (1997)
[BoldWords] WebCat.acgib15Mac (1997)
WebCat2b15MacPlugin - [protect] (1997)
emailer (1997)
Stinkin' [Referrer] (1998)
with Link i need to (1997)
Ampersand (1997)
Calendar Snippet (1998)
Creating 404 Not Found pages (1999)
Multiple Merchant Accounts? (1997)
Help! (1996)
redirect with frames (1997)
[replace] has protection feature like [delete]? (2000)
Protect (1997)
Thanks Grant (1997)
Updating product information (2002)
[OT] Boredom (was: Search Engine Tips) (2003)