May not make a difference - but I read somewhere that using table.* was a lot slower than requesting the individual column names.
HTH
Dave
At 8/28/2003 12:28, you wrote:
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
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
