Railo4, windows server, mysql5.1
I wrote the below code so that a user on my real estate site could send their agent a list of their saved favorite properties.
Lets say I have 4 saved favorites, what is happening is that instead of sending one email with links to my 4 favs, it sends 4 emails. The first email has one fav, the 2nd has 2 favs, the 3rd has 3, etc..
Any help getting this debugged is appreciated!
<cfquery datasource="myds" name="sendtoAgent">
FROM usr INNER JOIN fagents ON fagents.Agent = usr.AgentID INNER JOIN usr_residential_fav ON usr.pk_usr = usr_residential_fav.k_usr where usr.pk_usr = <cfqueryparam value="#URL.usrID#" cfsqltype="cf_sql_integer"
<h2>Here is a list of my Favs...</h2>