Contents

 
Home
ASPRunner Professional 7.0 manual
Prev Page Next Page
 
 

Select multiple values from checkboxes or a list field and have them appear as individual database entries

 

To select multiple values from check boxes or a list field and have them appear as individual database entries use the following code in Add page: Before Record Added event.

yellowbulbNote: Change the values listed in red to match your specific needs.

Dim arr

if values("fieldname")<>"" then

  arr = Split(values("fieldname"),",")

  ' This is the name of the multi check box or

  ' list select field, its value becomes arr

  for i=lbound(arr) to ubound(arr)

    strInsert = "insert into TableName (field) values ('" & arr(i) & "')"

    ' add more fields from the add page to be inserted into database

    dbConnection.Execute strInsert

  next

  Response.Redirect "MyPage_list.asp"

  ' Exit and Redirect to the list page after updating database

  exit function

end if

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)