Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Form problems with database

I have a asp page with 3 select menu's pulling there data from an odbc datasource
(access97). When data is selected and then submited the record set created
based on the items in the select boxes its only writting the values of the
boxes up to a <space> or a " ie, if i pick the value testing 1 2 3 from the
drop down and then hit submit it only writes testing back to the recordset.
[410 byte] By [Sean] at [2007-11-9 15:35:50]
# 1 Re: Form problems with database
Sean,

Make sure to place your value for each item in ". So for your pick list
to have the choice testing 1 2 3 the value should be "testing 1 2 3". If
the pick list choices are coming from a datasource then your OPTION line
should read:
<OPTION value="<%=rs("data")%>"><%=rs("data")%></OPTION>

Good Luck, I hope that this helps
Steve

NOTES: = is 'short hand' for Response.Write

"Sean" <molson_dry@usa.net> wrote:
>
>I have a asp page with 3 select menu's pulling there data from an odbc datasource
>(access97). When data is selected and then submited the record set created
>based on the items in the select boxes its only writting the values of the
>boxes up to a <space> or a " ie, if i pick the value testing 1 2 3 from
the
>drop down and then hit submit it only writes testing back to the recordset.
Steve at 2007-11-11 23:41:18 >