Re: SQL statements
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42548
interpreted = N
texte = Which platform are you on Clint?I've got it working, thanks to others before me, and will be glad to help if it's on OS X.> 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?You'll need it on the machine with WebDNA, and you'll configure it to talk to your MySQL server.-Jason Tyler> > > 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/ > ------------------------------------------------------------- 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:
Which platform are you on Clint?I've got it working, thanks to others before me, and will be glad to help if it's on OS X.> 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?You'll need it on the machine with WebDNA, and you'll configure it to talk to your MySQL server.-Jason Tyler> > > 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/ > ------------------------------------------------------------- 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:
AppleScript question (1997)
Include vs. lookup? (1998)
Cart # Starting at 1000 (2000)
Search results templates (1996)
Undeliverable Mail (1997)
Removing user entered whitespace... (2004)
Generating a random image, but avoiding repeated images. (1999)
multiple selected Checkboxes (1998)
Webcatalog server support (1997)
Ampersand Character (&) (1997)
default error on NT? (1997)
HELP (2000)
Question about replacing words (1998)
Multiple catalog databases and showcart (1997)
[WebDNA] Seriously what is wrong here? (2011)
[WebDNA] Which WebDNA version? (2009)
Country & Ship-to address & other fields ? (1997)
[include file=filename.inc&strip=t] (2002)
SM's FAXstf Server (2004)
question: webdelivery folder and file (1997)