I posted this yesterday, but since I haven't received any replies, I'm not sure the post went through. If this is redundant, I'm sorry.
====================================================================
Hi,
I'm working on a small sample app using MG/CS/Reactor, and while it's going well in general, I've run into a problem when creating a query and adding "where" attributes.
I'm using MG 1.1. Versions of CS and Reactor are not the BERs, since there's been so much ongoing development lately. In both cases, the versions are about three weeks old. That said, I'm sure that what's happening is just my lack of understanding of Reactor's workings.
Model-Glue stuff is firing fine. ColdSpring seems to wiring things up. The basic database structure is two related tables -- Documents and Categories. I can retrieve Documents by Category, lists of Categories, all that stuff.
But I need to allow a Document Search. If I do documentGateway.getAll(), the records are returned correctly, using all the correct aliases for table and field names. But when I do this:
<cfset var searchQuery = variables.DocumentGateway
.createQuery() />
<cfset where = searchQuery.getWhere() />
<cfset where.IsLike("Document", "Title", searchString) />
<cfset searchResults = variables.documentGateway.getByQuery(searchQuery) />
I receive an error saying, "Field Does Not Exist. The field 'document_v_title' does not exist in the object 'tblLPWebDocs_Documents'."
However, the field does exist. The table "tblLPWebDocs_Documents" is aliased to "Document" and the field "document_v_title" aliased to "Title." Both of these aliases are read correctly in other areas of retrieving documents.
Can someone point me to my mistake? I'll be happy to post more code if it's useful. I just didn't want to overload the initial post.
- <cfset where = searchQuery.getWhere() />
<cfset where.IsLike("Document", "Title", searchString) />
<cfset searchResults = variables.documentGateway.getByQuery(searchQuery) />
I receive an error saying, "Field Does Not Exist. The field 'document_v_title' does not exist in the object 'tblLPWebDocs_Documents'."
However, the field does exist. The table "tblLPWebDocs_Documents" is aliased to "Document" and the field "document_v_title" aliased to "Title." Both of these aliases are read correctly in other areas of retrieving documents.
Can someone point me to my mistake? I'll be happy to post more code if it's useful. I just didn't want to overload the initial post.
Thanks,
Tom
Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560 -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
