Ask a Question related to Coldfusion Database Access, Design and Development.
-
coryd218 #1
Query Error...Not sure why!
when i run this query:
<cfquery name="GetUser" datasource="myDSN">
SELECT *
FROM UDM_LOGIN
WHERE UDM_ID = '#Form.UDM_ID#'
AND Password = '#Form.Password#'
</cfquery>
I receive the following error:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Could not find file '(unknown)'.
The error occurred in server path is here.cfm: line 6
4 : FROM UDM_LOGIN
5 : WHERE UDM_ID = '#Form.UDM_ID#'
6 : AND Password = '#Form.Password#'
7 : </cfquery>
8 :
--------------------------------------------------------------------------------
SQL SELECT * FROM UDM_LOGIN WHERE UDM_ID = '43 cs/udm' AND Password = 'udm'
DATASOURCE MyDSN
VENDORERRORCODE -1811
SQLSTATE HY000
any help would be greatly appreciated. thanks.
coryd218 Guest
-
[microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when... -
Query of Query Error
This is the error I get - Query Of Queries syntax error. Encountered ". Query Of Queries runtime error. The Cold Fusion server is running MX... -
SQL Query error
Hello, I have a simple query that i'm passing over to an Excel output page using a ValueList that contains categoryID's, when I pass these ID's... -
Another Query of Query cast error
Just in case somebody else is getting this error I thought I'd leave this here. I have a shopping cart that is stored in a session variable. When at... -
Error Query
Error Executing Database Query. Syntax error (missing operator) in query expression 'StatusNum = 10'. The Error Occurred in... -
coryd218 #2
Re: Query Error...Not sure why!
lol...i fixed it. i thought i copied my DB to another location but i moved it. wow!
coryd218 Guest



Reply With Quote

