what's your database?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Ian Westbrook" To: "cfug dev list" <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: eam.net> Subject: [ cf-dev ] weird one... 28/08/2003 12:28 Please respond to dev 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]
