SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-17-2008, 06:13 AM
| ||||
| ||||
 why isn't my temporary table returning any results? hi. the temporary table does not return results but the select statement on its own does: CREATE TEMPORARY TABLE t2 AS SELECT CONCAT("<a href= \"javascript:NewWindow('live.aspx? sid=70','mypopup','1024','768','center','front');\ "><u>",s.title,"</ u></a>", LEFT(CONCAT('<p>',s.Description,'</p>'), 100)) AS Events, c.StartDate As Date, c.ScheduleType As Type, c.ScheduleType As Status, p.DisplayName As Presenter from CommonSchedule c inner join schedulemetadata s on (c.ScheduleID = s.ScheduleID) inner join presenter p on (c.ScheduleID = p.ScheduleID);      |
 |
« MySql Cron Job For Date Manipulation
|
how to append the % to a IN parameter for stored procedure »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 06:42 PM.
