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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
