I know, if it is simple whay are you asking?
Here is my Query:
------------------------------------------
<CFQUERY NAME="GetContacts" DBTYPE="ODBC" DATASOURCE="#request.datasource#">
SELECT ContactType.*, Contact.*
FROM Contact, ContactType
WHERE
ContactType.ContactType = 'Web Sign-Up' AND
Contact.AccountID = #session.AccountID#
</CFQUERY>
---------------------------------------
Here is my output:
---------------------------------------
<CFOUTPUT QUERY="GetContacts">You Have #RecordCount# Subscribers</CFOUTPUT>
----------------------------------------
The problem is that my output is giving me the right number of records but it is reapeating it the 13 times (the amount of records in DB)
Please help.
Thanks,
Eric
Here is my Query:
------------------------------------------
<CFQUERY NAME="GetContacts" DBTYPE="ODBC" DATASOURCE="#request.datasource#">
SELECT ContactType.*, Contact.*
FROM Contact, ContactType
WHERE
ContactType.ContactType = 'Web Sign-Up' AND
Contact.AccountID = #session.AccountID#
</CFQUERY>
---------------------------------------
Here is my output:
---------------------------------------
<CFOUTPUT QUERY="GetContacts">You Have #RecordCount# Subscribers</CFOUTPUT>
----------------------------------------
The problem is that my output is giving me the right number of records but it is reapeating it the 13 times (the amount of records in DB)
Please help.
Thanks,
Eric