Placing commas between returned values

[Roberta Gales]

I am pulling a set of skills to a job post page from a database. I want to
insert commas between the skills, but none after the last skill. The previous
page owner used

SR = Stmt.executeQuery("SELECT skill from SKILL")
String skills = "";
while (SR.next()){
skills += SR.getString("skill") + ", ";
}
String fmtSkills = skills.substring(0, skills.lastIndexOf(","));
out.print(fmtSkills);

on a JSP page, but I need to do the same thing in ASP. How can I do this?

[Michael]

Roberta, here is one way to do it in ASP.
(assuming same table being used)

dim dbConn, skillsRS, skillsTotal, totalLeft

set dbConn = server.createObject("adodb.connection")
set skillsRS = server.createObject("adodb.recordset")
set skillsTotal = server.createObject("adodb.recordset")

dbConn.open(connection string here)

skillsRS.open("select skill from SKILL"), dbConn
skillsTotal.open("select count(skill) as total from SKILL"), dbConn

totalLeft = skillsTotal("total")


do while not skillsRS.eof
if totalLeft > 1 then
response.write(skillsRS("skill") & ", ")
totalLeft = totalLeft - 1
else
response.write(skillsRS("skill"))
end if
skillsRS.moveNext
loop

skillRS.close
set skillsRS = nothing
skillsTotal.close
set skillsTotal = nothing
dbConn.close
set dbConn = nothing

Good luck!
Michael


"Roberta Gales" <roberta_gales@rac.ray.com> wrote:
>
>I am pulling a set of skills to a job post page from a database. I want
to
>insert commas between the skills, but none after the last skill. The previous
>page owner used
>
>SR = Stmt.executeQuery("SELECT skill from SKILL")
>String skills = "";
>while (SR.next()){
> skills += SR.getString("skill") + ", ";
>}
>String fmtSkills = skills.substring(0, skills.lastIndexOf(","));
>out.print(fmtSkills);
>
>on a JSP page, but I need to do the same thing in ASP. How can I do this?