ORDER BY on generated stored procs

Hi.

 
Is there anyway to specify a sort order (Order by clause) for the auto generated stored procs?

~Brett 

xxx_GetPaged has the sort order on it.

BTW: you could also do a sort on your TList (not so efficient I know)

HTH

swin

Hi Robert,

I looked at my generated xxx_Find SP's and I don't see any use of the "ORDER BY".

I'm using templates from the 10/10 with sql2000.

Don't these templates have it or am I missing something?

swin

Hi Robert,

Thanks for the info.

Conincidently I had to use .Find today and I added a filter parameter of a datetime column. I set the value to be DateTime.Now.ToString("yyyy-MM-dd HH:mm") and the filter type as GreaterThanOrEquals but I find that the filter doesn't seem to be applied.

I tried the logic direct in SQL and it returns what I expected.

I also tried creating a "where" clause as "myfield >= '2006-11-10 21:00'" but this just gave me an exception saying that it wasn't supported in this version of Find??

Any ideas on how I can get a Find to work with my DateTime column?

TIA

swin

Hey Swin,

It would look like:
EducationParameterBuilder build = new EducationParameterBuilder(false, false);
build.AppendLessThanOrEqual(EducationColumn.LastDateUpdated, DateTime.Today.ToString());
DataRepository.EducationProvider.Find(build.GetParameters());

Hey Robert,

Is there any way to construct a order by query in the same way so that it hits the data base only once.

thanks in advance, 

cheers

knuckels23