View Full Version : getString() problems

02-20-2003, 09:02 PM
I have a notes table where each note has a peronID and a sequence number attatched to it. So if I pull personID 8 then all rows of notes with personID 8 are pulled..duh. I use getString to concatenate? all rows together. The problem is that it puts a carriage return between each row. The problem is the there is html in these notes so if there is a
<div <--row1
> <--row2

THen in the html it is :

and the browser ignores the div because it is broken. Is there a way to use getString() with it not putting carriage returns for each row.

Code Is pretty standard:

rsMgr.Open sSQL, APNewConn, adOpenStatic, adLockOptimistic
strMgrIds = rsMgr.GetString()

Roy Sinclair
02-20-2003, 09:07 PM
Just remove the carriage returns after you get them:

strMgrIds = replace(rsMgr.GetString(),vbCR,"")