On 3/8/06, Fabian Peña <fapenia@adinet.com.uy> wrote:
DB('somefile'):Select('name,phone'):From('employes'):Where('ID
>0'):OrderBy('name'):Go()
Yes, something along those lines.
One thing though:
Shouldn't the 'where' clause be 'exploded' in its components (e.g. key, operator, value)?
Where( 'id', '>', 0 )
Otherwise you will have to parse it to be able to make any sense of it, no?
Also, what about 'and', 'or' and such? If you pass them as literal string, you will need to parse them. Perhaps something like this, where each argument is a simple where clause:
And( Where( 'id', '>', 0 ), Where( 'id', '<', 10 ) )
--
Cheers
