You will need a RCF although in the examples you will only see a while loop or a format option.. There is one other way to do this if you are only returning one row of data... Think of the RCF as a function in itself to get a record.. ie; fetch. <RCQcachename sql="select count(*) from table"> <RCFcachename RC$variable = RCDcachename.1>
These 2 lines (or combine them on one long line) will assign your variable to the first field in the first row returned. Danny On 06/Feb/2004 11:53:08, Christopher Dixon wrote: > Peter > > You seem to understand mysql and RC Script better and I for sure. Maybe > you can help me with something I am working on. I want to set the > returned value of <RCQcachename sql="select count(*) from table"> to a > RC$var. Can this be done? and if so can you please show me how? > > Thanks > > Chris > > > > > ------------------------------------------------------- > To unsubscribe please go to http://www.sambar.ch/list/ > > > > > > > ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
