So FORM[FORM.FIELD] didn't work instead of Evaluate("FORM.#FORM.Field#")?
On Wed, Sep 10, 2008 at 11:03 PM, David Moore, Jr. wrote: > How then would you approach the following without Evaluate, because it was > the only way I could get it to work: (oh, let the fun begin, the shame. I > probably committed at least 7 deadly sins alone. And yes, I am using Access. > Moan. Laughter.) In my ever growing need to expand my knowledge base (and > look less like an idiot to this list) HELP? It's a query that accepts > information from a Search field to run a query. > > <cfquery name="getPhysicianRecords" datasource="#DSN#">SELECT *FROM > ContactsWHERE Contacts.ContactType = 'Physician' > AND Contacts.#FORM.Field# = '#Evaluate("FORM.#FORM.Field#")#'ORDER BY > Contacts.LastName~David -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4