Thank you very much. I'll give it a try today and let you know how I get on.
Jomlian On Oct 22, 7:16 am, Alan Williamson <[EMAIL PROTECTED]> wrote: > jomlian wrote: > > ATM I'm stuck with creating the right dsn > > query to include inbluedragon.xmlto hook into my myql db. I don't > > Why don't you ask? :) > > It's very easy, assuming your MySQL server is setup properly. > > What is your mysql host [DBHOST]? > username [DBUSER]? password [DBPASS]? database name [DBNAME]? > > once you have that information, then creating the necessary <datasource> > for thebluedragon.xmlis a piece of cake. Then put this into > thebluedragon.xmlfile inside the <cfquery> tags. > > -- insert tobluedragon.xml------------- > <cfquery> > <datasource name="mydatasource"> > <name>mydatasource</name> > <logintimeout>120</logintimeout> > <databasename>DBNAME</databasename> > <username>DBUSER</username> > <password>DBPASS</password> > <sqlstoredprocedures>true</sqlstoredprocedures> > <hoststring>jdbc:mysql://DBHOST:3306/DBNAME</hoststring> > <sqlupdate>true</sqlupdate> > <drivername>org.gjt.mm.mysql.Driver</drivername> > <sqlinsert>true</sqlinsert> > <description>Sample configuration for mySQL</description> > <sqldelete>true</sqldelete> > <sqlselect>true</sqlselect> > <connectiontimeout>120</connectiontimeout> > <maxconnections>10</maxconnections> > </datasource> > </cfquery> > ------------------------------ > > restart your bluedragon and thats you. > > ------------------------------ > <cfquery name="t" datasource="mydatasource"> > select now() > </cfquery> > <cfdump var="#t#"> > ------------------------------ --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
