got a weird one here.
this is the query:
<cfquery datasource="#dsn#" name="getreviews">
SELECT DISTINCT reviews.reviewid AS reviewid, diary.reviewid, reviews.companyid AS
companyid, reviews.*, diary.title, directory.id, directory.fullname
FROM reviews, diary, directory
<cfif IsDefined("url.reviewid")>
WHERE reviews.reviewid = #url.reviewid#
<cfelse>
WHERE reviews.reviewid = #form.reviewid#
</cfif>
AND reviews.publish = 'yes'
AND reviews.companyid = directory.id
AND reviews.reviewid = diary.reviewid
ORDER BY reviews.dateadded
</cfquery>
but the review that this outputs is truncated and gets cut off.
If I remove the DISTINCT I get the full review as I should, but I get it three times.
there's nothing weird about the output, just a standard:
<tr bgcolor="#bg#">
<td align="right" valign="top"><b>Review:</b></td>
<td>#Replace(review, Chr(13), "<br>", "ALL")#<br><br></td>
</tr>
anyone any ideas?
TIA
Ian W
