hmm, tried that, didn't make any diference...
http://test.artsoutheast.co.uk/reviews.cfm?CFID=1395609&CFTOKEN=3136743&action=view&reviewid=1010&thisaction=all&the_start=1&records_to_display=20
very odd...
Ian W
----- Original Message -----
From: "Dave Phipps" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 12:38 PM
Subject: Re: [ cf-dev ] weird one...
> Perhaps the reviews.* is causing problems with the DISTINCT due to
> duplicate columns being called. Remove the reviews.* and replace with all
> the column names you want to output.
>
> 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]
>
--
** 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]
