Removing commas after posting data to database

[vdesio]

I am new to ASP. I am using the free ezscheduler asp program to create a calendar for my website. The idea is for employees to schedule their work shifts online. I have modified some of the programmin from its original format.

Here is my problem. The information that people enter are going into a database as comma delimited. When the information is pulled from the database and placed on the website it leaves the commas from the fields. I do not want the commas.

Here is the code inserting into database:

    strSQL = "INSERT INTO tbl_calendar ([schDate],[shift_time],[shift_type],[special_events],[other_hours],[employee]) VALUES ('"&strSchedDate&"',"&_
             "'"&rplStringIn(Request.Form("shift_time"))&"','" & rplStringIn(Request.Form("shift_type"))&"','" & rplStringIn(Request.Form("special_events")) & "','"&rplStringIn(Request.Form("other_hours"))&"','" & rplStringIn(Request.Form("employee"))&"')"
 

Here is the code inserting from the database to the website:

<td style="background-color:<%= strColor3 %>;color:<%= strColor6 %>" width="15%" align="center" valign="middle"><%= rplStringOut(rsCal("shift_time")) %> <%= rplStringOut(rsCal("other_hours")) %></td>
 

Here is what shows up on the website:
7am-7pm, or 4pm-,7am,

Can someone show me how to remove these commas? I am very new to this and so please make the instructions simple for me to understand.

Thanks!

[jhardman]

1- what type of db are you using

2- show the code for how the script opens the db (to show data, not to add data)

Jared