Ron, you just hijacked a list thread. This is a new topic; in the future,
please start a new thread.
As for your question, the Create scripts should be run against MySQL using
either the MySQL command line tool, or the MySQL Query Browser if you've
installed the tools. The script runs in bulk and creates/populates your
database, outside of ColdFusion.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ron Mast
> Sent: Thursday, February 22, 2007 9:45 AM
> To: [email protected]
> Subject: RE: [Reactor for CF] Insert multiple records question
>
> Hello All,
>
> I just downloaded reactor and I'm trying to get the
> ContactManager example working.
>
> In the ReadMe.txt file it has this:
> To get this sample to work you will need to create the
> database using a create script. When this document was
> written the options were:
>
> MSSQL Create Database.sql - For Microsoft SQL
> MySQL Create Database.sql - For MySQL (4 or 5, I think)
>
> I installed MySQL 5.0, can someone point me in the
> right direction how I can create the database using a
> create script?
>
> I already have the DSN created as well and I can run
> each method by surrounding it with <cfquery
> datasource="ContactManager" dbtype="ODBC"></cfquery>...e.g:
>
> <cfquery datasource="ContactManager" dbtype="ODBC">
> <!--- this is what I consider a method sorry if I don't
> have the correct terminology...:) ---> CREATE TABLE `Contact` (
> `contactId` int NOT NULL auto_increment ,
> `firstName` varchar(50) NOT NULL ,
> `lastName` varchar(50) NOT NULL ,
> PRIMARY KEY (`contactId`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> </cfquery>
>
> I got the method above from the MySQL Create
> Database.sql file. Problem is there are a gazillion
> methods in that file to create the database...:)
>
> Please help, thanks!
>
> Ron Mast
> Truth Hardware
> Webmaster
> 507-444-4693
>
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- Reactor for ColdFusion
> Mailing List [email protected] Archives at:
> http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- --
>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
