EasyCFM.COM ColdFusion Forums / Coding Help! / Login Application Error, need help

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Login Application Error, need help

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Warcry
08-14-2003 @ 4:42 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 0
Joined: Aug 2003

I've run the entire EasyCFM Login page, complete with application.cfm, members_only.cfm, login.cfm, and login_process.cfm at least 3 different times, and still get the same error.

When it hits the:
<cfif MM_rsUser.RecordCount NEQ 0> part, it dies.
I've reset it to EQ 1, EQUALS 1, NOT EQUAL TO 0, etc. Everything I could find, and it still doesn't work.

Is this a server misconfig of my database, or something non-related to the cfm pages I'm building?

Any help is greatly appreciated.

Please forgive the novel below, but I've posted the error text below:

(I'm wondering if the "Unkown Source" is causing the problem...?)

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with the LIKE or IS NULL predicates.

The Error Occurred in C:\CFusionMX\wwwroot\newcfm\login.cfm: line 10

8 :   SELECT user_ID,user_pass FROM dbo.users WHERE user_ID='#FORM.select#' AND user_pass='#FORM.textfield#'
9 :   </cfquery>
10 :   <cfif MM_rsUser.RecordCount NEQ 0>
11 :     <cftry>
12 :       <cflock scope="Session" timeout="30" type="Exclusive">

SQL    SELECT user_ID,user_pass FROM dbo.users WHERE user_ID='10' AND user_pass='monkey'
DATASOURCE   IS_Data
VENDORERRORCODE   306
SQLSTATE   HY000
Please Try The Following:

    * Check the CFML Reference Manual to verify that you are using the correct syntax.

    * Search the Knowledge Base to find a solution to your problem.

Browser   Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
Remote Address   127.0.0.1
Referer   http://localhost:8500/newcfm/login.cfm
Date/Time   14-Aug-03 03:48 PM
Stack Trace
at cflogin2ecfm1487639243.runPage(C:\CFusionMX\wwwroot\newcfm\login.cfm:10) at cflogin2ecfm1487639243.runPage(C:\CFusionMX\wwwroot\newcfm\login.cfm:10)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with the LIKE or IS NULL predicates.
     at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
     at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
     at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
     at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
     at macromedia.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
     at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
     at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
     at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
     at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
     at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
     at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
     at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
     at jrun.sql.JRunStatement.execute(JRunStatement.java:304)
     at coldfusion.sql.Executive.executeQuery(Unknown Source)
     at coldfusion.sql.Executive.executeQuery(Unknown Source)
     at coldfusion.sql.SqlImpl.execute(Unknown Source)
     at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
     at cflogin2ecfm1487639243.runPage(C:\CFusionMX\wwwroot\newcfm\login.cfm:10)
     at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
     at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
     at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
     at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
     at coldfusion.filter.RequestMonitorFilter.invoke(Unknown Source)
     at coldfusion.filter.PathFilter.invoke(Unknown Source)
     at coldfusion.filter.LicenseFilter.invoke(Unknown Source)
     at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
     at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
     at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
     at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
     at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
     at coldfusion.CfmServlet.service(Unknown Source)
     at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
     at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
     at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
     at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
     at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
     at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
     at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
     at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
     at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


"Nosce te Ipsum"


Website Designed and Developed by Pablo Varando.