index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Spurious added to data....corrupts URL :: (7) Post a New Message | Post a Reply
Jul 7 2006, 7:08 AM	Spurious added to data....corrupts URL Post a Reply
scotthibbs from: Philadelphia, PA	A field contains HTML formatting.......a link.  The wizard adds an unwanted break tag that destroys the URL. Here's the data coming back from the database: ------------------------------------------------------------------------------------------------------ PDF Reference Document is Attached to this Reading:<br>     <A HREF='https://www.secure.webview2000.com/DM_view_document.asp?docid=458&ver=1'><font face='Tahoma' size=2>Click Here To View</font></A> ------------------------------------------------------------------------------------------------------ This is what the wizard is putting in the report: ------------------------------------------------------------------------------------------------------ PDF Reference Document is Attached to this Reading:<br>     <A HREF='https://www.<br>secure.webview2000.com/DM_view_document.asp?docid=458&ver=1'><font face='Tahoma' size=2>Click Here To View</font></A> ------------------------------------------------------------------------------------------------------ Note the "<BR>" between "www." and "secure". How do you stop this behavior?
Jul 7 2006, 9:50 AM	Re: Spurious added to data....corrupts URL Post a Reply
ghost from: Washington, DC	The wizard usally replaces line breaks with <br/> tags. It seems this is what is causing the problem. Please check the raw data directly or by exporting to text to make sure that these fields do not contain line-feeds ------------------------- Ghost
Jul 7 2006, 10:05 AM	Re: Spurious added to data....corrupts URL Post a Reply
scotthibbs from: Philadelphia, PA	There are definitely no line feeds in the data as it resides in the database. Here is an example of the data: ________________________________________________________ PDF Reference Document is Attached to this Reading:<br>     <A HREF='https://www.secure.webview2000.com/DM_view_document.asp?docid=443&ver=1'><font face='Tahoma' size=2>Click Here To View</font></A> ________________________________________________________ There is a break tag in the data, but no linefeeds.  The problem is that the wizard decides to put the break tag in the middle of an HREF, as you can see in the first post.
Jul 7 2006, 10:43 AM	Re: Spurious added to data....corrupts URL Post a Reply
ghost from: Washington, DC	It's seems to be a line feed - remember, HTML does't recognize line-feeds. Anyway, what kind of DB are you using? ------------------------- Ghost
Jul 7 2006, 10:48 AM	Re: Spurious added to data....corrupts URL Post a Reply
scotthibbs from: Philadelphia, PA	There are no line feeds in the text in the database......and certainly not in the middle of "www.secure", where the wizard is adding the break tag. The database is SQL Server 2000.  The field is varchar(8000), although the contents are rarely more than a few hundred bytes. The data is being selected via a view that does nothing other than pick up the text data and return it.
Jul 7 2006, 11:03 AM	Re: Spurious added to data....corrupts URL Post a Reply
ghost from: Washington, DC	I've just been told that the text content is more than 100 characters long and since it happens to have as spaces within the string, they are being replaced with line feeds - (since the parser is not stripping off HTML first.) This bug will be fixed by tuesday. thanx! ------------------------- Ghost
Jul 11 2006, 2:11 PM	Re: Spurious added to data....corrupts URL Post a Reply
ghost from: Washington, DC	This bug has been fixed as of the current version 2.6.17 ------------------------- Ghost
Pages: (1)   [1]

search this forum: