smithproject.org

never mind, I got it working. Thanks for the reply it help.

I got it working.

Sergio

ok, I downloaded the driver for mySQL, set it up in the admin section.
check for the connection I got a heck mark (it means it connected Ok)

but, when I execute the CFQuery command I get this error:

Error executing "inventory" query!
No database selected

here is my query's first line:
<CFquery name="inventory" datasource="product">

and th name in the admin section for the mysql DB connection is product.
also, it worked properly before with coldfusion & sql server.

the code is the same what has changed now its that its SMith Project & mySQL.

any idea whats going on?

I'm going from adobe coldfusion to smith project.

I need to know how to connect to a database using a datasource name
or how to connect to an MS access.

ist been a while since I've done Java Development, so the whole JDBC...
I dont remeber to well.

any help?

Thanks