Hello, I'm having the same problem as Jonverve. Mine also works when I put all of the code in the same page as my table. My code is also stored in the templates area and the template shows up in my Insert Template tool drop-down. I've included my source text:
Originally Posted by neilw
Also, when I have the code in the same page, the text of the column titles have a border around them, which looks very odd as it is inside the border the cell of the table and it goes right through the sort button...
stolenvehicles.table("SELECT top 25 Color1 as Color, YR as Year, Make, Model,
Lic_Plate as License, Location, convert(varchar,RPT_Date,1) as Date FROM stolens
where recovered=0 order by rpt_date desc") </pre>