CF Query MySQL

[metaphiz]

I've been working with MS databases and am giving MySQL a shot. I'm getting an error with the query below, and am battling with the host over whose fault it is! Can someone verify syntax for me?

<cfquery datasource="datasource" name="GetStaff" username="username" password="password">
SELECT *
FROM "staff"
</cfquery>

Here's the error:
Security: The requested template has been denied access to datasource name.

The following is the internal exception message: access denied (coldfusion.sql.DataSourcePermission)

 

[r937]

hmm... it seems you don't have permissions

once you clear that up, you're going to discover that mysql doesn't support the same syntax as you've been using with Access or SQL Server

remove the doublequotes from the table name

SELECT * FROM staff



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon