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 like this:User DSN Tab Name: MySQL Description: MySQL Driver: MySQL-MyODBC Server: localhost Database: MyDatabaseNameSystem DSN Tab Name: MyDatabaseName Description: MySQL Driver: MySQL-MyODBC Server: localhost Database: MyDatabaseNameDrivers Tab Driver: MySQL-MyODBC File: /Library/MyODBC/lib/libmyodbc3_r.bundle MySQL 3.23.55 This 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 BY last_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 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://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 like this:User DSN Tab Name: MySQL Description: MySQL Driver: MySQL-MyODBC Server: localhost Database: MyDatabaseNameSystem DSN Tab Name: MyDatabaseName Description: MySQL Driver: MySQL-MyODBC Server: localhost Database: MyDatabaseNameDrivers Tab Driver: MySQL-MyODBC File: /Library/MyODBC/lib/libmyODBC3_r.bundle MySQL 3.23.55 This 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 BY last_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 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://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:
Google Sitemap generator (2005)
Base64 encryption limitations? (1999)
UPDATE PROBLEM (1997)
PROBLEM (1997)
WebCommerce: Folder organization ? (1997)
Bug? (1997)
emailer settings and control questions (1997)
Shownext! (1998)
Multi-Row Tables from a search. (1997)
PIXO (1997)
Opposite of Summ=T? (2000)
[WebDNA] SEARCH question - SHOWIF - HIDEIF question (2011)
Random (2000)
2 databases (1998)
mass mailing (1998)
RE: [WebDNA] How to valuate a domain name? (2010)
Problems appending to database (1997)
paymethod=cc allows all zeros (1999)
[OT] Mozilla | Was: R.I.P. Netscape (2003)
FW: WebDNA-Talk searchable? (1997)