I'm working on a script that allows user to rate a item. the script
works fine for inserting the data and seamlessly returning to the page
(using Ajax). The problem I'm having is when the page reloads or, when
I load another item page, I get a JDBC internal error on the select
statement (see below). I am using MySQL 5 and CFMX 7. I've run the
select statement through the MySQL Query Browser and it runs fine. The
script works if I remove the AVG function. But, that means I have to
add extra code to get the average rating for the unit, which I'd rather
not do.
<cfquery name="getRating" datasource="#dsn#">
select avg(fldrating) as Rating from tblrate where id = #uID#
</cfquery>
Any ideas/suggestions appreciated.
thanks,
Chris
--
"Fortune favors the prepared mind."
- Louis Pasteur
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
