Yep, what you'll need to do is output the query using cfoutput. You'll want to format the outputted data in either CSS or a plain ole table.
You can also see if this will work with CF 4.5: http://www.cflib.org/udf.cfm?ID=548 Its mimics cfdump but I can't remember is CF 4.5 supports UDFs. My offer of CF 5 still stands so let me know. Rey... Rick Faircloth wrote: > Yes, it's true... up to this point, 4.5 has always been able to do > everything I've needed. However, now I'm finding myself so far > behind functionally that I can't discuss programming solutions > with other programmers. > > Yes, Daemach has been helping me, and so has Michael Carluen. > > He sent detailed code, but I haven't been able to get it to work, yet. > I've modified it some to fit the data in an existing database. > > I also don't have the use (being still in 4.5) of cfdump which is part > of his code. I don't know if that's critical to the function of the entire > code > or not. > > Here's what I've got so far... > > mycfpage.cfm > ---------------------------------------------------------------------------- > ------------------------- > > <CFQUERY Name="get_realtor_info" datasource="resm_users"> > > Select User_First_Name, User_Last_Name > from resm_users > where User_ID = '#URL.User_ID#' > > </CFQUERY> > > <CFDUMP var="#get_realtor_info#"> > > > Form_Page.cfm > ---------------------------------------------------------------------------- > -------------------------- > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> > > <html> > <head> > <title>Form_Page</title> > > <script type="text/javascript" src="jquery-latest.js"></script> > > <script type="text/javascript"> > > $(function(){ > $("#User_ID").change( function() { > var User_ID = $(this).val(); > $("#mycfpagecontent").load("mycfpage.cfm?User_ID=" + User_ID); > }); > }); > > </script> > > > </head> > > <body> > > <form action="Form_Page.cfm" method="post" name="Form_Post"> > > <select id="User_ID"> > <option value="1">Ricky</option> > <option value="2">Jacqui</option> > <option value="3">Julie</option> > </select> > > </form> > > <div id="mycfpagecontent"></div> > > </body> > </html> > ---------------------------------------------------------------------------- > ------------------------------ > > Does this look right? What changes are needed? > > Remember, I can't use the cfdump at the end of the mycfpage.cfm page. > Is there a work around for the lack of that function? > > Thanks for your help! > > Rick > > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Rey Bango > Sent: Friday, February 23, 2007 10:43 AM > To: jQuery Discussion. > Subject: Re: [jQuery] Best way to do AJAX... CF or jQuery? > > No way! CF 4.5??? Dude, I have a copy of CF 5.0 Enterprise just sitting > on my shelf collecting dust. Let me know if you want it and I'll send it > to you. :) > > Also, it sounds like Daemach helped you. If you need another example, > sans CFCs, let me know and I'll whip something up. > > Rey > > > > > > _______________________________________________ > jQuery mailing list > [email protected] > http://jquery.com/discuss/ > _______________________________________________ jQuery mailing list [email protected] http://jquery.com/discuss/
