FROM statement , can i pull from a query residing in Access?

Posted on 2003-03-07
Medium Priority
Last Modified: 2013-12-24
Basic question...

 Can I use coldfusion SQL to reference a query I made in my Access database. It is not a table, it is a query!

my statement would be (assume the query resides in access under the name qry_by_name)

SELECT * FROM qry_by_name

How can i tell coldfusion this is not a table, but it is a query??

Question by:finnstone
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

HamdyHassan earned 400 total points
ID: 8088042
you don't need to tell this is query not table, it's driver work.

Try it and let us know with the result.

don't forget inside Access, you can join query and table, so no difference.

LVL 17

Expert Comment

ID: 8088163
u dont have to do ne-thing

it's as good as hitting a query on a query

just do as uve mentioned in ur question & i think it will surely work !

let me know


Author Comment

ID: 8090686
how do i award this answer  . ..  ? you both answered. should i give 100 to first answer. 50 to both? if i can split , how do i do that?

thanks for letting me know...thats awesome....! yes! why would people bother writing all the joins etc in Coldfusion SQL if you can do it all easily and visually in the access platform?


Expert Comment

ID: 8090834
That's nice idea but valid only at MS-access...etc
In Sybase/Oracle, we have storeproc which is more powerful.

Good Luck ( About rewards points , it's up to you )

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question