Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50074
interpreted = N
texte = Hi Clint - Sounds like you have Complete MySQL from Aaron Faby ..Can you let me know the value of 'SQLLibraryPath' in WebCatalog Prefs file ?ThanksAlain> 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: MyDatabaseName> > System DSN Tab> Name: MyDatabaseName> Description: MySQL> Driver: MySQL-MyODBC> Server: localhost> Database: MyDatabaseName> > Drivers 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/-------------------------------------------------------------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:
Hi Clint - Sounds like you have Complete MySQL from Aaron Faby ..Can you let me know the value of 'SQLLibraryPath' in WebCatalog Prefs file ?ThanksAlain> 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: MyDatabaseName> > System DSN Tab> Name: MyDatabaseName> Description: MySQL> Driver: MySQL-MyODBC> Server: localhost> Database: MyDatabaseName> > Drivers 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/-------------------------------------------------------------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/
Alain Russell
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:
WebCat editing, SiteGuard & SiteEdit (1997)
[WebDNA] Mass email using WebDNA (2008)
Mondo amounts of Mail [long] (1999)
Physical Security for WebCatalog Directories (1997)
Refering page (1998)
bannerads example idiot (1997)
Newbie search question (between two dates) (2001)
Locking up with WebCatalog... (1997)
expired beta (1997)
[WebDNA] Base 64 (2010)
emailer (1997)
I'm new (2001)
DON'T use old cart file! (1997)
Webcat no longer supported? (2006)
All of a Sudden Type 2 errors (1999)
Here we go again... (2006)
[WebDNA] Passing a text variable via copyfile (2019)
[ELSEIF] was hideif [x]=1,2,3..: (2003)
More on the email templates (1997)
Switching from merge to tab delimited..(v 2.x) (2000)