Dhtml?

They have: 82 posts

Joined: Oct 2001

OK Guys,

I query the database and write the info out to a table.

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

What I need to do is put a checkbox beside each cell.value
that the user can click. Once the user clicks the checkbox
I will take the value of the selected item and query another database.

I am guessing I will need to create an array.

Any Ideas?

Thanks,

Mike

Blessed is the man who fears the LORD, who delights greatly in his commandments. Psalms 112:1

They have: 82 posts

Joined: Oct 2001

I think this will work:

They have: 82 posts

Joined: Oct 2001

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

Blessed is the man who fears the LORD, who delights greatly in his commandments. Psalms 112:1

They have: 82 posts

Joined: Oct 2001

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.

Blessed is the man who fears the LORD, who delights greatly in his commandments. Psalms 112:1

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Can I join in? Smiling

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

PJ | Are we there yet?
pjboettcher.com

They have: 82 posts

Joined: Oct 2001

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

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.