From: Bob Barrows on
..Net Sports wrote:
>
> If i don't need to change the Level when editing the record, then i
> want to leave what their existing level number is in the first line of
> the select option box: <select name=level><option value= SELECTED>"&
> RSFORM("level")&"</option><option value=1>1</option><option
> value=2>2</
> option></select>
>
> I tried response.writing the request("level") on the next page, and it
> is blank , so something is not coming across in the post right:
>


Look at the value attributes of each of your option elements ... which one
is selected when you submit the form? What is the value of that selected
option?


--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


From: Dan on

".Net Sports" <ballz2wall(a)cox.net> wrote in message
news:c9397400-1b7d-4a4b-bc33-98bc9e43b5b2(a)z35g2000prh.googlegroups.com...
> I have an item that goes into sql database coming from a select
> pulldown list.:
>
> <br>ACCESS LEVEL:<br> <select name=level><option value= SELECTED>"&
> RSFORM("level")&"</option>

There's your problem, right there, at the value=. Where's the value? For
example, is RSFORM("level") is the value 1, the HTML becomes

<select name=level><option value= SELECTED>1</option>

so if the user picks 1 from the list (which is pre-selected so is highly
likely), the value is blank because you have not provided the value. The
change for this line should be something like

<br>ACCESS LEVEL:<br> <select name=level><option value=" & RSFORM("level") &
" SELECTED>" & RSFORM("level") & "</option>


--
Dan


From: Evertjan. on
Bob Barrows wrote on 22 dec 2009 in
microsoft.public.inetserver.asp.general:

> Evertjan. wrote:
>> Bob Barrows wrote on 21 dec 2009 in
>> microsoft.public.inetserver.asp.general:
>>
>>> .Net Sports wrote:
>>>> I have an item that goes into sql database coming from a select
>>>> pulldown list.:
>>>>
>>>> <br>ACCESS LEVEL:<br> <select name=level><option value= SELECTED>"&
>>>> RSFORM("level")&"</option><option value=1>1</option><option
>>>> value=2>2</ option></select>
>>> Show us the result of
>>>
>>> Response.Write request("level")
>>
>> This will possibly not help you, Bob,
>> as you cannot see the difference between
>> "1" and +1.
>>
>
> Are you sure? Did you look at his source?

Possibly I was,

.... but not now, as both will be accepted by cint()


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
From: Bob Barrows on
Evertjan. wrote:
> Bob Barrows wrote on 22 dec 2009 in
> microsoft.public.inetserver.asp.general:
>
>> Evertjan. wrote:
>>> Bob Barrows wrote on 21 dec 2009 in
>>> microsoft.public.inetserver.asp.general:
>>>
>>>> .Net Sports wrote:
>>>>> I have an item that goes into sql database coming from a select
>>>>> pulldown list.:
>>>>>
>>>>> <br>ACCESS LEVEL:<br> <select name=level><option value=
>>>>> SELECTED>"& RSFORM("level")&"</option><option
>>>>> value=1>1</option><option value=2>2</ option></select>
>>>> Show us the result of
>>>>
>>>> Response.Write request("level")
>>>
>>> This will possibly not help you, Bob,
>>> as you cannot see the difference between
>>> "1" and +1.
>>>
>>
>> Are you sure? Did you look at his source?
>
> Possibly I was,
>
> ... but not now, as both will be accepted by cint()
>
>
I guess you're missing the point. If the form above is submitted with
the default selection,
request("level")
, or, more correctly (as you pointed out):
request.form("level")
, will return an empty string, in which case cint("") will raise a type
mismatch error.

--
HTH,
Bob Barrows