I'm having a real problem with retrieving the results I want with sambar scripting. I have been through 3 turotials and none have been any help so I'm hoping someone here has an idea for me.
In a nutshell I'm grouping byte counts on a daily basis from a table. The querry below does what it should but the date format comes out 20030121 not a pretty 2003/01/21 if I remove the left() I get the full date time which I don't want either. <RCQmylog sql="select left(tstamp,10),sum(bytes) from RC$tbl group by left (tstamp,10);"> <RCwhile RCFmylog = 1> <b>Traffic on:</b> <RCDmylog.1> - <i><RCDmylog.2></i> bytes<br> <RCendwhile Regards Peter ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
