Thanks Bob, If it weren't for the fact that I'm a hobbyist and don't make any money from Rev, then purchasing sqlYoga might make cents. But for the want of one method, I might have to nut it out.
If Rev has a single call that does it, I'm guessing the Val API can, it just appears the documentation is a little lacking. I see also that Trevor swaps between API and RevDB calls, so if I can figure out why I get 'invalid DB type', I'd be more than happy to follow the master and use the occasional RevDB call, if it saves time. Again I just need help figuring out what's wrong. Here's hoping :-) 2010/6/16 Bob Sneidar <b...@twft.com> > Since runrev Can ONLY access an SQL database via the revdb API, ALL methods > are at some point doing what you need them to. > > I highly recommend sqlYoga as he has a built in function that does exactly > what you are trying to do. > > It takes a bit of getting used to, but once you see that his main objective > is to firewall you off from the actual SQL itself, it makes a lot of sense. > > Bob Sneidar > IT Manager > Calvary Chapel CM > Sent from iPhone > > > On Jun 15, 2010, at 17:59, Kay C Lan <lan.kc.macm...@gmail.com> wrote: > > If this is not what I'm looking for I'm assuming someone out there has >> already invented the wheel (generic function) that takes any Cursor >> returned >> from VDatabase_SqlSelect, and does a nested repeat through each field of >> each record and returns the content either into a multi-line list or an >> array? Care to share… please :-) >> > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution