> what's your database? Access db, CF4.5
Ian ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 28, 2003 12:40 PM Subject: Re: [ cf-dev ] weird one... > > 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] > -- ** 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]
