Hi, I'm almost there but need to know where 'mydatasource' comes from (e.g. is it the name of the database?). HOST = localhost USER = root PASSWORD = jom datasource = ??
Thanks, Jom On Oct 22, 7:48 am, jomlian <[EMAIL PROTECTED]> wrote: > 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 !! -~----------~----~----~----~------~----~------~--~---
