Rick,
>what the heck is this?
>
>19 >= 19
>
>
>The error occurred in
>E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20
>
>18 : A.*, B.name as PRMLNAME
>19 : FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
>20 : where id=<cfqueryparam cfsqltype="cf_sql_integer" value="#id#">
>21 : </CFQUERY>
>22 : <cfoutput query="data">
The error may be because you've used an ambigious column name of "id". Try:
where A.id = <cfqueryparam cfsqltype="cf_sql_integer" value="#id#"
/>
(I'm assuming the "id" column is in the results table.)
-Dan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237754
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
