quick response write question from a db

hi,

iis5, Access 2000 db

I am writing some values from one field to a page using response write and a
loop. Here's my code to do the write:

<%
Response.Write (rstRespond.Fields("eMail").Value & ";")
rstRespond.MoveNext
Loop
%>

This is successful, but it is returning the text in a column and I want it
to be one long string with each email addy separated by a semi-colon.

I've tried sticking it in a table cell with the NOWRAP parameter -- doesn't
work. I've tried searching the web a bit via google, but can't really seem
to locate any ideas on how to do it. Is it because it treats each record as
an auto linebreak?

Any suggestions would be appreciated.

Re: quick response write question from a db

"Kevin" wrote in message
news:OJ9ObPBAGHA.3864@tk2msftngp13.phx.gbl...
> hi,
>
> iis5, Access 2000 db
>
> I am writing some values from one field to a page using response write and
> a
> loop. Here's my code to do the write:
>
> <%
> Response.Write (rstRespond.Fields("eMail").Value & ";")
> rstRespond.MoveNext
> Loop
> %>
>
> This is successful, but it is returning the text in a column and I want it
> to be one long string with each email addy separated by a semi-colon.
>
> I've tried sticking it in a table cell with the NOWRAP parameter --
> doesn't
> work. I've tried searching the web a bit via google, but can't really seem
> to locate any ideas on how to do it. Is it because it treats each record
> as
> an auto linebreak?
>
> Any suggestions would be appreciated.

Google "getstring"
Here's one hit:
http://www.4guysfromrolla.com/webtech/121598-1.shtml

Re: quick response write question from a db

worked ... you da man.

thanks a bundle Raymond


"Raymond D'Anjou" wrote in message
news:u7$FxUBAGHA.264@tk2msftngp13.phx.gbl...
> "Kevin" wrote in message
> news:OJ9ObPBAGHA.3864@tk2msftngp13.phx.gbl...
> > hi,
> >
> > iis5, Access 2000 db
> >
> > I am writing some values from one field to a page using response write
and
> > a
> > loop. Here's my code to do the write:
> >
> > <%
> > Response.Write (rstRespond.Fields("eMail").Value & ";")
> > rstRespond.MoveNext
> > Loop
> > %>
> >
> > This is successful, but it is returning the text in a column and I want
it
> > to be one long string with each email addy separated by a semi-colon.
> >
> > I've tried sticking it in a table cell with the NOWRAP parameter --
> > doesn't
> > work. I've tried searching the web a bit via google, but can't really
seem
> > to locate any ideas on how to do it. Is it because it treats each record
> > as
> > an auto linebreak?
> >
> > Any suggestions would be appreciated.
>
> Google "getstring"
> Here's one hit:
> http://www.4guysfromrolla.com/webtech/121598-1.shtml
>
>