Skip to main content
A
Anonymous
October 5, 2007
Answered

dbtype attribute does not support dynamic

  • October 5, 2007
  • 1 reply
  • 423 views
I am new in CoulFusion and I am trying to use the CFQUERY to validate data from Sql Server 2000 with the following code:

<cfquery name="GetUser" datasource="GMP">
SELECT USERNAME FROM GMP.GMPUSER
WHERE USERNAME = '#username#'AND PASSW = '#passw#'
</cfquery>

The DNS GMP was created and validated.

I am receiving the " ColFusion 6.0 the dbtype attribute does notsupport dynamic' validadtion error.

How can I fix this error???

Thanks in advance.
This topic has been closed for replies.
Correct answer Dan_Bracuk
To start troubleshooting, try this
<cfquery name="GetUser" datasource="GMP">
SELECT count(*)
FROM GMPUSER
WHERE 1 = 2
</cfquery>
If that works, start adding things until it crashes.

1 reply

D
Dan_BracukCorrect answer
Inspiring
October 5, 2007
To start troubleshooting, try this
<cfquery name="GetUser" datasource="GMP">
SELECT count(*)
FROM GMPUSER
WHERE 1 = 2
</cfquery>
If that works, start adding things until it crashes.
A
Anonymous
October 5, 2007
Does not work. When I validated the page in Dreamwaever CS3 I received this message error. I tried just SELECT * FROM GMPUSER and failed. This page was runing in ColdFusion MX7 but a moved to ColdFusion MX8 and I got this problem.

I am crazy with this problem...

Thanks
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices