Recordset Problem

[Flog]

I have a weird problem that seems to have popped up on its own.
It seems that every one of my application recordsets are messing up.

When I edit or create a new recordset, the wizard shows my table selection (from clause) as follows. (This is an example)

cfquery name="Recordset1" datasource="SVMC"
SELECT *
FROM C:\Data Sources\SVMC.users


It should be

cfquery name="Recordset1" datasource="SVMC">
SELECT *
FROM users

As a result, no application will work until I manually modify the from clause.

Any Ideas?

[BKBK]

As a result, no application will work until I manually modify the from clause.
I would manually modify it. Prevents another headache later.

[Flog]

Thanks for the reply , but I am looking for a solution, not just a work around, to the strange behaviour. Can anyone provide some more insight?

[paross1]

Sounds like a wizard problem, not a ColdFusion one. What are you using to generate your queries?

Phil

[Flog]

This seems to have started after applying the Dreamweaver MX 8.0.2 update on this particular server however not on my other one. Therefore the common denominator would be Coldfusion as one Dreamweaver works and this one doesn't.

Also it does not matter if I create a new recordset or veiw an existing one - the from clause changes.

The error I get is MM_ERROR: -1

[paross1]

I would disagree and suggest that it is probably a Dreamweaver issue, but since I don't use Dreamweaver myself, I can't offer any recommendations as to where to look there.

Looks like someone else may be having a similar problem over in the Dreamweaver forum. Databases Panel in Dreamweaver 8 displays the full filepath

Phil

[BKBK]

I am looking for a solution, not just a work around
The suggestion is not a workaround. The standard way to write a query in Coldfusion is indeed

<cfquery name="Recordset1" datasource="SVMC">
SELECT *
FROM users
</cfquery>

It therefore doesn't surprise me that this version works.