I am trying to do the following:


Code:

SET @sql=SELECT CONCAT("<img src='thumbs/",s.Thumbnail,"' alt=''
class='teaserImage' /><h3><a href=\"javascript:NewWindow('free.aspx?
sid=",c.ScheduleID,"','mypopup','1024','768','cent er','front');
\"><u>",s.title,"</u></a><h3><p>",LEFT(s.Description, 100),"...</p>")
As Event,
c.StartDate As Date, c.ScheduleType As Type, c.StartDate As
Status, GROUP_CONCAT(p.DisplayName) As Presenters
From CommonSchedule c
inner join schedulemetadata s on (c.ScheduleID = s.ScheduleID)
inner join presenter p on (c.ScheduleID = p.ScheduleID)
where l_where_clause
group by c.ScheduleID;



I am getting all sorts of errors.

This is the end of a sort stored procedure where the l_where_clause is
dynamically generated before this code block.
I want to set this code into @sql for further processing.

Does anybody see what I am doing wrong and could you please
suggest corrections?

THanks.

On 10 Apr, 06:52, pbd22 <dush...@gmail.com> wrote:
> I am trying to do the following:
>
> Code:
>
> SET @sql=SELECT CONCAT("<img src='thumbs/",s.Thumbnail,"' alt=''
> class='teaserImage' /><h3><a href=\"javascript:NewWindow('free.aspx?
> sid=",c.ScheduleID,"','mypopup','1024','768','cent er','front');
> \"><u>",s.title,"</u></a><h3><p>",LEFT(s.Description, 100),"...</p>")
> As Event,
> c.StartDate As Date, c.ScheduleType As Type, c.StartDate As
> Status, GROUP_CONCAT(p.DisplayName) As Presenters
> From CommonSchedule c
> inner join schedulemetadata s on (c.ScheduleID = s.ScheduleID)
> inner join presenter p on (c.ScheduleID = p.ScheduleID)
> where l_where_clause
> group by c.ScheduleID;
>
> I am getting all sorts of errors.
>
> This is the end of a sort stored procedure where the l_where_clause is
> dynamically generated before this code block.
> I want to set this code into @sql for further processing.
>
> Does anybody see what I am doing wrong and could you please
> suggest corrections?
>
> THanks.

If you are getting "all sorts of errors" then there are going to be
all sorts of fixes.

Since you haven't actually told us any of the "all sorts of errors"
you are getting, that is as much as we can be.