Well I have gotten to the point that I can take a string of numbers
convert it to checkboxes and then take the altered checkboxes and put
the values back into a string. Now what I'm having a problem with is
sending the string to database.
<!=============== Check for Value in array Function ===============!>
<% Function ElementInArray(aMyArray, strLookingFor, compare)
ElementInArray = (UBound(Filter(aMyArray, strLookingFor, True,
compare)) > -1)
End Function %>
<!================= Convert String to Checkboxes ==================!>
strDiscOwned = "1,3,6,8,12,16,17,18,20" 'usually a database field
arrDiscOwned = split(strDiscOwned,",")
strDiscInSeries = 20 'usually a database field
For i=1 to strDiscInSeries
HaveIt=ElementInArray(arrDiscOwned,i,compare)%>
<input type="checkbox" name="HaveDisc" value="<%=i%>" <%
if HaveIt=true then
response.write "checked"
end if %>/>
<% 'create rows of ten
if i mod 10=0 then
response.write "<BR>"
End If
Next
%>
<!================= Convert Checkboxes to String ==================!>
strNewString=request.form("HaveDisc")
strNewString=replace(strNewString,chr(32),"")'remove spaces
strOwnedDisc=request.form("HaveDisc").count 'Number of disc I have
<!================= ============================ ==================!>
Now here's my dilema how do I take strNewString and send it to the
database. I tryed assigning it's value to a hidden input field and
then added it the "record update" behavior, but it didn't work. My
Guess is it's because the request.form function does not occur till
after the rest of the form is submited to the database.
Is There anyway to submit this value to the database?
--- In [email protected], "swatpup32"
<[EMAIL PROTECTED]> wrote:
> <form name="completion" id="form1" method="post" action="">
> <%
> Dim strNumbers, arrNumbers, numCheckValue, NumToValue, i, M
> strNumbers = "1,3,6,8,12,16,17,20" 'Typically this would be a
string
> from the database
> arrNumbers = split(strNumbers,",")
> NumToValue = rsAnime.Fields.Item("intDiscInSeries").Value
> For i=1 to NumToValue
> M=ElementInArray(arrNumbers,i,compare)%>
> <input type="checkbox" name="HaveDisc" value="<%=i%>" <%if M=true
> then response.write "checked="& chr(34) & i & chr(34) end if %>/>
> <%if i mod 10=0 then
> response.write "<BR>"
> End If
> Next
> %>
> </Form>
> Now at this point two have rows of checkboxes, which values are
> determined by the comma-delimited string in the database. Now here
is
> where I'm having the problem. How do i take checkbox's value= for
the
> checkboxes that are checked and rejoin them into comma-delimited
> string and then send it off to the database.
>
> I'm guessing that if I create a hidden input type in the form. I
can
> put the string as the value and update the "update record" server
> behavior in Dreamweaver, but I'm not sure.
>
> Is it possible to do this without creating two pages?
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
