Split help please

[Joey Martin]

I need some basic SPLIT help. I need to be able to display the results
for the split function.
The SQL query will pull results like

123.jpg,ab123.jpg,whatever.jpg

CURRENT CODE:
SQLCommand = "Select PHOTO From IMAGES Where id= '" & rs("ID") & "'"
set rsca=datasource.execute (SQLCommand)
thetest=rsca("photo")
allsplit=split(thetest,",")
Response.Write allsplit & "<br>"

I am getting a TYPE MISMATCH error. The PHOTO field is a VARCHAR.

I need to be able to write something like:
for each result in the split
response.write PHOTO & <BR>
and then the next one and so on.

Any help is appreciated
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Peter Foti]

"Joey Martin" <jo********@qx.net> wrote in message
news:OJ*************@TK2MSFTNGP11.phx.gbl...

I need some basic SPLIT help. I need to be able to display the results
for the split function.
The SQL query will pull results like

123.jpg,ab123.jpg,whatever.jpg

CURRENT CODE:
SQLCommand = "Select PHOTO From IMAGES Where id= '" & rs("ID") & "'"
set rsca=datasource.execute (SQLCommand)
thetest=rsca("photo")
allsplit=split(thetest,",")
Response.Write allsplit & "<br>"

I am getting a TYPE MISMATCH error. The PHOTO field is a VARCHAR.

I need to be able to write something like:
for each result in the split
response.write PHOTO & <BR>
and then the next one and so on.

I think this will work:

For i = 1 to UBound(allsplit)
Response.Write "<div>" & allsplit(i-1) & "</div>"
Next

Regards,
Peter Foti

[Joey Martin]

Perfect! Thanks so much.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Aaron Bertrand - MVP]

> Response.Write allsplit & "<br>"

This array is a complex data structure; you can't response.write an array
(just like you can't response.write a recordset or a dictionary object).

You can try this:

Response.Write Join(allsplit, "<br>")

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/