|
JOIN String Functions 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.
JOIN(array,delimiter)
takes an array and converts it to one string with delimiters.
The user can enter a state or multiple states. We write the program using
the JOIN function to demonstrate how this function can be used.
statejoin.asp
filename=/learn/test/statejoin.asp
<html><head>
<title>statejoin.asp</title>
</head><body bgcolor="#FFFFFF">
<form action="statejoinrespond.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>
statejoinrespond.asp
filename=/learn/test/statejoinrespond.asp
<!--#include virtual="/learn/test/lib_dbtable.asp"-->
<html><head>
<title>statejoinrespond.asp</title></head>
<body>
<%
mySQL="select * from publishers "
myDSN="DSN=student;uid=student;pwd=magic"
public allstates
tempinput=request("states")
allstates=split(tempinput,",")
whereclause=" where state='" & JOIN(allstates, "' OR state='") & "'"
mySQL=mySQL & whereclause
response.write mySQL
Call Query2Table(mySQL,myDSN)
%>
</body></html>
|