Query Drop View

[ftroute]

I have a programs that creates (and uses) 3 query VIEWs. Currently I have to go
into the database and delete the views before I can re-run the program. Access
supports the Query DROP VIEW <i>viewname</i> syntax.
The code:
<cfquery name="dropview" datasource=#dbsource# username=#dbuser#
password=#dbpass#>
DROP VIEW devsused
</cfquery>
The above results in the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error in DROP TABLE or DROP INDEX.

Can somebody point me in the right direction?

[ftroute]

Don't think that using 3 queries and Q of Q is a viable option. Already doing Q
of Q on the views. Will look at it again.

Although Access supports the DROP VIEW syntax, it appears that CF does not. I
have used DROP TABLE and DROP INDEX in the past with no problem.

[Dan Bracuk]

Regarding q of q from 3 queries. It takes a bit of work, but you can get
results.

3 real queries
<cfquery name="a" datasource="dw">
select event_code, event_name from event
</cfquery>

<cfquery name="b" datasource="dw">
select event_code, event_name from event
</cfquery>

<cfquery name="c" datasource="dw">
select event_code, event_name from event
</cfquery>

*****************************
Q of Q
<cfquery name="d" dbtype="query">
select a.event_code as event_code, b.event_name as event_name
from a, b
where a.event_code = b.event_code
</cfquery>

<cfquery name="e" dbtype="query">
select a.event_name as aa
from a, d
where a.event_code = d.event_code
</cfquery>

Notice in the 2nd one, that one of my queries, d, was a q of q.

[ftroute]

Got me really thinking and stepping back to look at the whole picture. Realized
that what I was doing in the first place could be modified and eliminate a
whole step deleted by doing so. My new approach will use 1 query and two Q of
Q. Thanks for forcing me to open my eyes.