Jump to content
conradin

<CFQUERY datasource> question

Recommended Posts

Hi all, when I use the <CFQUERY name="getData" datasource="Data">the Data.mdb is assumed to be in the 1 directory up from the script that called it.(is that right? -- Thats what I think)anyways, Im working on a page that has the Data.mdb inside the web accessible directories. I want to change itso the data.mdb is not internet accessible. Can I specify another filepath for the local directory such as D:\Data or D:\Data.mdbAlternatively, should I use ../ notation to navigate to the data source?

Share this post


Link to post
Share on other sites
Hi all, when I use the <CFQUERY name="getData" datasource="Data">the Data.mdb is assumed to be in the 1 directory up from the script that called it.(is that right? -- Thats what I think)anyways, Im working on a page that has the Data.mdb inside the web accessible directories. I want to change itso the data.mdb is not internet accessible. Can I specify another filepath for the local directory such as D:\Data or D:\Data.mdbAlternatively, should I use ../ notation to navigate to the data source?
Your datasource needs to be defined in the ColdFusion Administrator. The tag attribute "datasource" doesn't work like other physical file attributes like "src" or "href". If you have access to the ColdFusion Administrator then login and goto your database settings and define your mdb there.Let me know if you have more questions.

Share this post


Link to post
Share on other sites

Ah, well it did work as described. There was some trouble. When I went to edit the datasource it simply refused to make the edit. The Database check returned ok, but then no one could log in, and ###### started breaking loose. Finaly, I deleted the old data source and wrote in a new one, and that worked fine. Thanks For the assistance! --Also, do I need to mark this thread as solved?

Your datasource needs to be defined in the ColdFusion Administrator. The tag attribute "datasource" doesn't work like other physical file attributes like "src" or "href". If you have access to the ColdFusion Administrator then login and goto your database settings and define your mdb there.Let me know if you have more questions.

Share this post


Link to post
Share on other sites

You can add [solved] to the title or subtitle, if you want.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×