|
|
|
|
 |
|
꼭지 / 2001-08-24 / 오전 11:37:34 / 168.126.91.65
조회수 : 129
|
| [질문] select문에서 비교하는 문법을 모르겠어요 |
> 쿼리 select말고 걍 select문에서요
>
> 문법을 모르겠네요 갈켜주세요
>
> 이러케 하니까 틀리네요
>
> 원본소스
> <%
> select case(weight)
> case =< 0.3 : a=1
> case =< 0.5 : a=2
> case =< 1.0 : a=3
> case =< 1.5 : a=4
> case =< 2.0 : a=5
> case =< 2.5 : a=6
> case =< 3.0 : a=7
> case =< 3.5 : a=8
> case =< 4.0 : a=9
> case =< 4.5 : a=10
> case =< 5.0 : a=11
> end select
> %>
-----------------------------------------------------------
VB하고는 약간 틀린듯 싶네요..
If weight =< 0.3 Then
a=1
ElseIf 0.3 < weight And weight =< 0.5 Then
a=2
ElseIf 0.5 < weight And weight =< 1.0 Then
a=3
ElseIf 1.0 < weight And weight =< 1.5 Then
a=4
ElseIf 1.5 < weight And weight =< 2.0 Then
a=5
ElseIf 2.0 < weight And weight =< 2.5 Then
a=6
ElseIf 2.5 < weight And weight =< 3.0 Then
a=7
ElseIf 3.0 < weight And weight =< 3.5 Then
a=8
ElseIf 3.5 < weight And weight =< 4.0 Then
a=9
ElseIf 4.0 < weight And weight =< 4.5 Then
a=10
ElseIf 4.5 < weight And weight =< 5.0 Then
a=11
End If
|
|
|
|