You can do exactly what he wants by loading the data into a JS array. Then his function would simply look in the array rather than trying to do a query.
the cfquery in his function is querying for a specific record based on a value passed to the function. if he does a query without the WHERE and loops over that query, he can create a JS array easily. On 11/14/06, Munson, Jacob <[EMAIL PROTECTED]> wrote: > Charlie and Ray, > > You can't do what he wants without something like Ajax. He is passing > the UPC to a query and then doing something with the results in > JavaScript. Yes, you can create JS vars with CF, but if you want to hit > your DB like he's attempting, you'd use ajax or flash remoting. > > And comon', ajax is not very hard. To do what he wants with ajaxCFC > would mean dropping the core files in, creating a basic CFC including > his cfquery, and then cfreturn the result. I'd imagine it's similar in > mxajax. > > > -----Original Message----- > > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, November 14, 2006 11:42 AM > > To: CF-Talk > > Subject: Re: Mixing CF and JavaScript. > > > > yeah, that's why I threw in the mention of AJAX, but really didn't > > pursue that as the solution. He's probably got enough things on his > > plate at the moment without introducing a new technology :) > > > > On 11/14/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > > > Don't you think that maybe suggesting AJAX or CFAJAX might > > be a little much > > > for this user at this point? He did mention that he's on > > DAY 5 of CF > > > development, you know. > > > > > > I like Charlie's idea. Use CF to create the structure > > you're looking to > > > use, then use JS to do the lookup on that. > > > > > > > -----Original Message----- > > > > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > > > > Sent: Tuesday, November 14, 2006 1:17 PM > > > > To: CF-Talk > > > > Subject: RE: Mixing CF and JavaScript. > > > > > > > > > You need to use AJAX. > > > > > > > > I agree, but I wouldn't recommend CFAjax. It's outdated, > > and the guy > > > > that wrote it has moved on to MXAjax: > > > > http://www.indiankey.com/mxajax/ > > > > > > > > Personally I prefer ajaxCFC: > > > > http://ajaxcfc.riaforge.org/ > > ------------------------------------------------------------------------------ > This transmission may contain information that is privileged, confidential > and/or exempt from disclosure under applicable law. If you are not the > intended recipient, you are hereby notified that any disclosure, copying, > distribution, or use of the information contained herein (including any > reliance thereon) is STRICTLY PROHIBITED. If you received this transmission > in error, please immediately contact the sender and destroy the material in > its entirety, whether in electronic or hard copy format. Thank you. > > ============================================================================== > "EMF <idahopower.com>" made the previous annotations. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4