string delimiter

[boux123]

Hi,

As explained in the previous thread, I am create a webpage that displays server info from a database. What servers the user selects will be added to a new table created in the sql database. However, when more than one server is selected, these servernames are inserted into the table as a string.

For ex:

server1 and server 2 are selected.

In the table the two servers are displayed like this

server1/, server2/

In order to solve this problem I attemped split the names.

While Not oRs.EOF

serverString = oRs("serverName")
MyArray = Split(serverString, "/,")



'tempID = Trim(oRs("serverName"))
Response.write "<br /><font size='2'>Server:&nbsp;&nbsp;<b>" & oRs("serverName") & "</b>&nbsp;&nbsp;&nbsp;Server Location:&nbsp;&nbsp;<b>" & oRs("serverLocation") & "</b>"
Response.write "<br /><i>Select This Server:</i>&nbsp;&nbsp;<input type='checkbox' name='server' id='serverSelect' value=" & tempID & "/></font><br />"
oRs.MoveNext
Wend

However, this does not work. The only thing that is shown now in the SQL database is: /,

Thx

 

[Sheco]

Try this for debugging:

Do While Not oRs.EOF 
  serverString = oRs("serverName") & ""
  if serverString <> "" then
    MyArray = Split(serverString, "/,")

    For iCount = 0 to uBound(MyArray)
      Response.Write cStr(iCount) & " - " & MyArray(iCount) & "<BR>" & vbCrLf
    Next 
  else
    Response.Write "Data field was empty. <BR>" & vbCrLf
  end if 

  oRs.MoveNext
Loop

Also be sure that the real values are actually stored in the database field as expected.

 

[boux123]

Hey,

I tried you code. However, when the servers are submitted into the database, it still shows these servers as: server1/, server/.

Thx

 

[Sheco]

I am not clear on the goal you wish to achieve.

The purpose of the debug code posted above is to convert a string from one format to another.

Input is this format: [tt]server1/,server2/,server3[/tt]

Output is:[tt]
server1
server2
server3
[/tt]

I was under the impression that the issue is not how the items are STORED in the database, but rather how to control the DISPLAY of items stored in that particular format.

Please clarify.

 

[boux123]

In the database:

The servers that are selected as displayed like this:

server1/, server2,

However, in the database, I want the servers to be displayed in this format:

server1, server2

Basically i want the "/" character to be taken out.

 

[Sheco]

Maybe, before inserting the values, you could use the Replace() function to replace all slashes for an empty string.

Ex:<%
TheString = "server1/,server2/,server3"
TheString = Replace(TheString, "/", "")
Response.Write TheString
%>

 

[boux123]

Ye i tried that. It works. Thx!