Returning a partial string

[Ruslan Zasukhin]

On 7/9/05 9:45 PM, "jda" <jda at his.com> wrote:

>> But Jon, in v1 did work only methods.
>> Formulas in SELECT did not work at all in v1
>> 
> 
> Hm, I was able to do this in V1 (the temp field named 'fld' let me
> sort by author names, and if there were no authors in the record, by
> editor names, and if both were NULL sort by title):
> 
> Create temp method:
> 
> fld = 
> myDatabase.myReferences.createVarCharField("authorEditorSortMethod",
> 2000, EVFlag.fNone, "IFNULL(authors, IFNULL(editors,title))")

Aha, so you have create method. This was my point.
Just you name it TMP.

 
> Use:
> 
> s = "select *,authorEditorSortMethod from thereferences where hit>0
> ORDER BY authorEditorSortMethod,thedate"
> 
> 
> This is pretty much what I want to do now -- create temporary
> *methods* that return values I can sort by. This is just like V1, I
> think (no?).

But his should work in 2.0 also.
any problems here ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]