Try this:
<cfquery name="qget_members"
dbtype="dynamic"
connectstring="driver={mysql};
server=servername;database=dbname;uid=username;pwd=password;option=163
86;">
BLAH BLAH BLAH
</cfquery>
The connectstring attribute should be all on one line, and the MySQL
ODBC
drivers need to be installed. They can be downloaded from
www.mysql.com.
tom
www.basic-ultradev.com
"Fcc Paragon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> Somebody Please HELP!!
>
> I have just been converted to Mysql database and I am now in the
testing
> stages, I am having trouble understanding the concepts of DSN Less
> connections, I have an NT server running CF 4.5 and Mysql server
all on
the
> same machine.....How do reference the database from within a query.
>
> <cfquery name="qget_members" datasource="WHAT GOES HERE">
> BLAH BLAH BLAH
> </cfquery>
>
>
> In desperation
> Mark Bryden
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
