Hello, I am porting an application over to OpenBD where the previous programmer used cfscript heavily.
Is the following supported in OpenBD? <cfscript> chkLogin = new query(); chkLogin.setDatasource(Application.DS); chkLogin.setSQL( "SELECT user_id FROM " & variables.instance.UserTable & " WHERE email iLIKE :email AND password=:password LIMIT 1" ); chkLogin.addParam(name="email",value=arguments.email,CFSQLTYPE="CF_SQL_VARCHAR"); chkLogin.addParam(name="password",value=password,CFSQLTYPE="CF_SQL_VARCHAR"); results = chkLogin.execute().getResult(); If not, would the best solution to rewrite with <cfquery>? OpenBD is throwing this error: Detail A request was made to a resource that could not be located Missing File query Thanks! Randy -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
