Informix and Active Server Pages 1

[MSMINNICH]

I'm having a problem with my ASP proogram and IDS 2000... I have a pretty simple program to output the contents of a table to an ASP page. It works on all of the tables except one that has a Memo field in it. Has anyone seen this?
Scott

 

[Miditen]

There was a bug that made it necessary to have any memo fields referenced at the end of your statements. I've gotten into the habit of designing all my tables as well any statements like UPDATE or INSERT with the memo fields last. It was more than a year ago that I read about this so I could be completely off, but it's worth a try. Good luck.

 

[MSMINNICH]

Thanks, I got it. The problem was that there were unprinable charachters in the memo fields that were causing problems in my VB Script. I was concating as such..
str = str & rs(&quot;memo_field&quot & &quot;</td>&quot;
and the page source of the resulting page showed
...This is the memo field (no </td>)
It seems that the non-printable charachters were triggering VB's null propogation thingie.
so...
It worked fine on MSIE, but not on Netscape, which is less tolerant of malformed HTML.