|
SPLIT String Function by Charles Carroll
The various string functions can be used
interchangeably often. We will write the same script using SPLIT, REPLACE and JOIN to
demonstrate all 3 functions and how they often are used for similar tasks. However, your
programming situations may be especially suited for 1 out of 3 of the functions.
SPLIT(string,delimiter)
is a function that returns an array with as many elements as are separated by
delimiters within the string.
The user can enter a state or multiple states. We write the program
utilizing SPLIT to demonstrate how this can be used.
statesplit.asp
filename=/learn/test/statesplit.asp
<html><head>
<title>states.asp</title>
</head><body bgcolor="#FFFFFF">
<form action="statesplitrespond.asp" method="post">
Enter State (or many states separated by <b>,<b><p>
<input NAME="states" size="40"><p>
<input type="submit" value="Get The Publishers!">
</form>
</body></html>
statesplitrespond.asp
filename=/learn/test/statesplitrespond.asp
<!--#include virtual="/learn/test/lib_dbtable.asp"-->
<html><head>
<title>statesrespond.asp</title></head>
<body>
<%
mySQL="select * from publishers " & whereclause
myDSN="DSN=student;uid=student;pwd=magic"
public allstates
tempinput=request("states")
allstates=split(tempinput,",")
maxcounter=ubound(allstates)
whereclause=" where state='" & allstates(0) & "'"
FOR counter=1 TO maxcounter
thisstate=allstates(counter)
whereclause=whereclause & " OR state='" & thisstate & "'"
NEXT
mySQL=mySQL & whereclause
Call Query2Table(mySQL,myDSN)
%>
</body></html>
|