mycoolross — Thu, 18 Oct 2001 14:02:10 +0000

That is why I hang out here! You guys know everything.

Peter J. Boettcher — Thu, 18 Oct 2001 13:47:20 +0000

Can I join in?

I might be missing the point, but wouldn't it have been simpler to just use a counter?

Something like:

intCounter = 0

do while not rs.eof
For Each Cell in RS.Fields
Response.Write ""& cell.value &" "
intCounter = intCounter + 1
next
rs.movenext
loop

mycoolross — Wed, 17 Oct 2001 21:25:02 +0000

Ok it seems as though I am talking to myself.

As soon as I post a qustion I think "I could do it like this"

Well maybe someone can use this stuff.

If you guys think of a better way let me know.

I am doing a Replace() to remove the space and replace it with with a _ . Then I will replace (in the query string) the _ with a space.

mycoolross — Wed, 17 Oct 2001 21:08:30 +0000

This is working:

Response.Write ""& cell.value &" "

However if the value in the recordset is
more than one word it gets truncated. I have had this problem before.

For example:

If Mike Ross is returned from the database.
the name of the checkbox would be "Mike"
How do I get the whole string to be the name?

Is it possible?

Thanks,

Mike

mycoolross — Wed, 17 Oct 2001 20:15:43 +0000

I think this will work: