Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Re: Syntax error converting datetime from character string.


Message #1 by jprentice@e... on Mon, 9 Dec 2002 22:42:03
I figured my problem out by changing the CASE statement from its original 
state:  

ORIGINAL:

> : ORDER BY
> : CASE @Sort
> :   When  'Date' then v.Begin_Date
> :   When  'OAvg' then v.OAvg
> :   When  'Instr' then ie.LastName
> :   When  'txtCourse' then e.[name]
> :   When  'MAvg' then v.MAvg
> :   When  'IAvg' then IAvg
> : When  'RecPcnt' then v.RecPcnt
> : Else v.Begin_Date
> : END

to this one:

WORKING:

ORDER BY
	CASE When @Sort = 1 then v.Begin_Date END,
  	CASE When @Sort = 2 then v.OAvg END,
  	CASE When @Sort = 3 then ie.LastName END,
  	CASE When @Sort = 4 then e.[name] END,
  	CASE When @Sort = 5 then v.MAvg END,
  	CASE When @Sort = 6 then IAvg END,
	CASE When @Sort = 7 then v.RecPcnt
	Else v.Begin_Date
	END

...And then assigned each string variable an integer in my asp page.

  Return to Index