jomlian wrote:
> ATM I'm stuck with creating the right dsn
> query to include in bluedragon.xml to 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 the bluedragon.xml is a piece of cake. Then put this into the
bluedragon.xml file inside the <cfquery> tags.
-- insert to bluedragon.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 !!
-~----------~----~----~----~------~----~------~--~---
