Query Error...Not sure why!

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default 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 &apos;(unknown)&apos;.

    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

  2. Similar Questions and Discussions

    1. [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...
    2. 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...
    3. 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...
    4. 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...
    5. Error Query
      Error Executing Database Query. Syntax error (missing operator) in query expression 'StatusNum = 10'. The Error Occurred in...
  3. #2

    Default 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

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139