*** Create Tables CF8

[Guest]

Hi
I am on Mac Pro Intel 10.5
I am trying to learn coldfusion 8 developer edition with flex3
All I want is to create db tables in coldfusion 8. I believe this is a derby db
I have copied a script from Ben Forta site

CREATE TABLE ACTORS (
ACTORID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 21) CONSTRAINT ACTORS_PK PRIMARY KEY,
NAMEFIRST CHAR(50) NOT NULL,
NAMELAST CHAR(50) NOT NULL,
AGE SMALLINT NOT NULL,
NAMEFIRSTREAL CHAR(50) NOT NULL,
NAMELASTREAL CHAR(50) NOT NULL,
AGEREAL SMALLINT NOT NULL,
ISEGOMANIAC SMALLINT NOT NULL,
ISTOTALBABE SMALLINT NOT NULL,
GENDER CHAR(1) NOT NULL
);

Now the silly part part...
I have created the data base from with in CF
It runs fine from localhost in the CF root
I have created a cfm page with cfquery the ben forta code inside, no luck.
<cfquery datasource="database dsn">  
</cfquery>

I have gone iinto flex builder pro 3, query builder pasted it in and execute query no luck

Please how do I create tables in the coldfusion 8 environment.
A step by step would be most grateful as all tutorials seem to skip this part and assume we all know it. I do not and I am not ashamed to say as I want to learn
Please can anyone help. I also have dreamweaver cs3
Thanks in advance
TeeFX

[Dan_Bracuk]

Did you create a cold fusion datasource?

[Guest]

Yes I have created a datasource pointing to a new database I created in CF it tested and works fine as I explained earlier. I tried a cfquery tag on a .cfm page with the Ben Forta( create table code) inside the cfquery tag and no luck. I just need to know how and where to create the relationship tables. A step by step would be nice.
Or point me to some clear concise tutorials
thanks

TeeFX

[Dan_Bracuk]

What was the actual error?

[Guest]

Please Dan can you help?
I have tried so many ways and no tables.
As a senior member do you know the proper way, if so can you help?
As I believe going back and trying something when in fact I do not even know for sure it is the right way of doing it, is not the best way forward. There must be a right way and that is what I am trying to achieve..

Thanks

[Guest]

Thanks Dan
But as there was no more help, I just decided to install MySQL as it seems no one is prepared to give me some help or point me to a tutorial. I do not want it on a plate I just want pointers or a tutorial as I am sure after that I can work it out... But thanks for you reply. I am sure I will be back as I am learning a lot by just reading other peoples problems and the great help the site is giving them.
Thanks to you all
TeeFX

[Newsgroup_User]

see if these can help you with Derby:

http://www.carehart.org/resourcelists/derby_for_CFers/
http://db.apache.org/derby/

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Newsgroup_User]

although, i might add, switching to MySQL is probably a good thing in
the long run... MySQL is a great rdbms, with a huge user-base and great
on-line resources and support.

you may also want to check out the GUI tools for it, like SQLYog and
NaviCat (gui db administration) and the gui tools available from
mysql.com (MySQL Administrator & Query Browser specifically)

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/