mao
04-18-2007, 04:56 PM
This is the case.
Lenguage used: ASP
DB: SQL
Problem:
I am running a SELECT query and need to display the result values of a table column in multiple rows.
QUERY:
mySQL="SELECT items FROM products WHERE items=new"
The result is
Ball, ballon, baseball, basktball, football
I need the result to be in the following format (by rows)
Ball
Ballon
Baseball
Basketball
Football
The code that I am using to perform this task is
NewItems = split(items,",")
when I use this code I do NOT get any results displayed.
Can anyone help me with the correct code to make this happen???
PLEASE HELP.
Lenguage used: ASP
DB: SQL
Problem:
I am running a SELECT query and need to display the result values of a table column in multiple rows.
QUERY:
mySQL="SELECT items FROM products WHERE items=new"
The result is
Ball, ballon, baseball, basktball, football
I need the result to be in the following format (by rows)
Ball
Ballon
Baseball
Basketball
Football
The code that I am using to perform this task is
NewItems = split(items,",")
when I use this code I do NOT get any results displayed.
Can anyone help me with the correct code to make this happen???
PLEASE HELP.