well, I've confirmed it by removing the DISTINCT, in which case teh review isn't truncated but I get it 3 times...
Ian ----- Original Message ----- From: "Kevin Faulkner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 28, 2003 2:17 PM Subject: RE: [ cf-dev ] weird one... > Have you confirmed with debug that the truncation is definately from your > sql and not the output? > > -----Original Message----- > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > Sent: 28 August 2003 14:07 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] weird one... > > > the query is now: > > <cfquery datasource="#dsn#" name="getreviews"> > SELECT DISTINCT reviews.reviewid AS reviewid, reviews.userid, reviews.id, > reviews.companyid AS companyid, reviews.review, reviews.publish, > reviews.dateadded, diary.reviewid, 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> > > reviews.review is a memo field, but reviews.reviewid is a number... > > and I've never seen truncation like that before, either. as I say, if I take > the DISTINCT away I get the full review, but three times. very odd... > > Ian W > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 28, 2003 1:41 PM > Subject: Re: [ cf-dev ] weird one... > > > > > > Correct me if I'm wrong, but I thought you couldn't do a SELECT DISTINCT > > with memo fields? I'm assuming review is a memo field, not a text field. > > Not sure though why that would just truncate it rather than throw an > error. > > > > > > 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: > <[EMAIL PROTECTED]> > > <[EMAIL PROTECTED] cc: > > eam.net> Subject: Re: [ cf-dev ] weird > one... > > > > 28/08/2003 > > 13:30 > > Please > > respond to > > dev > > > > > > > > > > > > > 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] > > > > > > > > > > > > > > -- > > ** 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] > DISCLAIMER: This e-mail is confidential and may also be legally privileged. > If you are not the intended recipient, use of the information contained in > this e-mail (including disclosure, copying or distribution) is prohibited > and may be unlawful. Please inform the sender and delete the message > immediately from your system. This e-mail is attributed to the sender and > may not necessarily reflect the views of the Patsystems Group and no member > of the Patsystems Group accepts any liability for any action taken in > reliance on the contents of this e-mail (other than where it has a legal or > regulatory obligation to do so) or for the consequences of any computer > viruses which may have been transmitted by this e-mail. The Patsystems Group > comprises Patsystems plc and its subsidiary group of companies. > > -- > ** 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]
