Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50055
interpreted = N
texte = Nitai,Using the MacOS X ODBC Administrator app, I created a couple of DSNs likethis:User DSN TabName: MySQLDescription: MySQLDriver: MySQL-MyODBCServer: localhostDatabase: MyDatabaseNameSystem DSN TabName: MyDatabaseNameDescription: MySQLDriver: MySQL-MyODBCServer: localhostDatabase: MyDatabaseNameDrivers TabDriver: MySQL-MyODBCFile: /Library/MyODBC/lib/libmyodbc3_r.bundleMySQL 3.23.55This is not the Entropy version, but I don't remember how I installed it.Sample WeDNA query:[SQL dsn=MyDSN&username=MyUsername&password=MyPassword&statement=SELECT *from contacts WHERE (first_name LIKE '%[dna_first_name]%') ORDER BYlast_name,first_name;]Hope this help!On 5/6/03 7:37 AM, Nitai @ ComputerOil
wrote:> Thanks Clint,> > Would be cool to let me know some more infos.> > TIA.> > On 6.5.2003 14:33 Uhr, Clint Davis wrote:> >> Nitai,>> >> I'm running this combo under OSX 10.2.4, but I can't give you a step by step>> procedure because it took me a couple of tries to get it working.>> >> I'm using MySQL 3.23.55 with the built-in OSX ODBC app. Make sure you setup>> MySQL with a username and password for use by WebDNA. Also, make sure you>> setup your DSNs in the ODBC app.>> >> I'll provide more info when I get into the office.>> >> >> On 5/6/03 2:35 AM, Nitai @ ComputerOil wrote:>> >>> I somehow got stuck with ODBC and MySQL. I got MySQL running and all is>>> working fine, just cant get ODBC talk to MySQL. Also MyODBC is installed,>>> but unixODBC does only make with errors and alike.>>> >>> Would anybody be so kind and tell me in a step like way how to do it, or>>> give me a URL so I can find it out?---------------------------------------------------------------------Clint DavisWebmaster / Interactive Media SpecialistGray Loon Marketing Group, Inc. http://www.grayloon.com204 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Nitai,Using the MacOS X ODBC Administrator app, I created a couple of DSNs likethis:User DSN TabName: MySQLDescription: MySQLDriver: MySQL-MyODBCServer: localhostDatabase: MyDatabaseNameSystem DSN TabName: MyDatabaseNameDescription: MySQLDriver: MySQL-MyODBCServer: localhostDatabase: MyDatabaseNameDrivers TabDriver: MySQL-MyODBCFile: /Library/MyODBC/lib/libmyODBC3_r.bundleMySQL 3.23.55This is not the Entropy version, but I don't remember how I installed it.Sample WeDNA query:[SQL dsn=MyDSN&username=MyUsername&password=MyPassword&statement=SELECT *from contacts WHERE (first_name LIKE '%[dna_first_name]%') ORDER BYlast_name,first_name;]Hope this help!On 5/6/03 7:37 AM, Nitai @ ComputerOil wrote:> Thanks Clint,> > Would be cool to let me know some more infos.> > TIA.> > On 6.5.2003 14:33 Uhr, Clint Davis wrote:> >> Nitai,>> >> I'm running this combo under OSX 10.2.4, but I can't give you a step by step>> procedure because it took me a couple of tries to get it working.>> >> I'm using MySQL 3.23.55 with the built-in OSX ODBC app. Make sure you setup>> MySQL with a username and password for use by WebDNA. Also, make sure you>> setup your DSNs in the ODBC app.>> >> I'll provide more info when I get into the office.>> >> >> On 5/6/03 2:35 AM, Nitai @ ComputerOil wrote:>> >>> I somehow got stuck with ODBC and MySQL. I got MySQL running and all is>>> working fine, just cant get ODBC talk to MySQL. Also MyODBC is installed,>>> but unixODBC does only make with errors and alike.>>> >>> Would anybody be so kind and tell me in a step like way how to do it, or>>> give me a URL so I can find it out?---------------------------------------------------------------------Clint DavisWebmaster / Interactive Media SpecialistGray Loon Marketing Group, Inc. http://www.grayloon.com204 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://webdna.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:
WebCatalog2 Feature Feedback (1996)
Search inside Include (1998)
I have troubles to send message out (1998)
Re:no [search] with NT (1997)
Re:Running 2 two WebCatalog.acgi's (1996)
[format 40s]text[/format] doesn't work (1997)
http://www.smithmicro.com/WebDNAReference/ current? (2000)
Emailer setup (1997)
docs for WebCatalog2 (1997)
Up and running ... at last !! (1997)
bug in [SendMail] (1997)
Robots fill event log (1997)
WCS Newbie question (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Stumpted Again (1997)
RE: New WebCatalog Version !!! (1997)
How to check post code? (2002)
unique ascending numbers (2003)
New Plug-in and Type 11 errors (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)