>I should clarify this.
>
>I have an option group that determines the sort
>order of a list. The option group calls a method
>to reload the list.
>
>Option buttons 2-4 reload ordered by a single field
>and they work fine.
>
>Option button 1 requires a reload ordered by
>field 1 + field 2.
>
>In the reload method, I do:
>
>DO CASE
>
> CASE nOpt = 1
> cOrder = "Field1 + Field2"
>
> CASE nOpt = 2
> cOrder = "Field3"
>
> CASE nOpt = 3
> cOrder = "Field4"
>
>ENDCASE
>
>Then I do the SQL. It work fine except
>when I select option 1. I get 'invalid
>order by clause'
>
>Any thoughts?

cOrder = "Field1,Field2"
It's comma!