aspx problem displaying dyanmic RTB data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

aspx problem displaying dyanmic RTB data

Author

Topic

ChrisL
Starting Member

2 Posts

Posted - 2004-06-08 : 10:33:52

I have a dynamic input page (aspx) that uses a rich text box to allow a user to upload information about their center to a sql db. The page serves multiple users and is populated based on their location (there are over 100 locations). Everything works great except for one location. On the dynamic page for that location the RTB input box is not visible nor is any data. The RTB functions do show up, however. The RTB works fine for all other locations so I believe the aspx is correct. Has anyone encountered an issue like this? Thanks in advance.-Chris

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-06-08 : 10:47:52

Can you post the value for that location?

ChrisL
Starting Member

2 Posts

Posted - 2004-06-08 : 12:13:17

Thank you for your reply. I'm not sure I understand what you are asking. The value for this location is 38. Here is the entire page sans security and some superfluous navigation code:

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="True" EnableSessionState="True"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Register TagPrefix="RTB" Namespace="RichTextBoxControl" Assembly="RichTextBox" %>
<script runat="server">
Dim centerid as Integer
Dim userid as Integer

centerid = session("dynacent")
userid = session("uid")
myRTB.DisableToolbarItem(ToolbarItem.ParagraphMenu)
myRTB.DisableToolbarItem(ToolbarItem.FontSizeMenu)
myRTB.DisableToolbarItem(ToolbarItem.FontMenu)
myRTB.DisableToolbarItem(ToolbarItem.InsertImage)

If Not isPostBack then
BindList()
end if

End Sub

Sub Insert(Sender As Object, E As EventArgs)
dim s as New centers.centers
dim StatusOf as string
dim y as string
StatusOf = s.PutCenterInfo(centerid, Replace(myRTB.TextXhtml, "'", "|"))
lblStatus.Text = StatusOf
BindList()
End Sub

Public Sub BindList()
dim s as New centers.centers
dim rsList as SqlDataReader
rsList = s.GetCenterInfo(centerid)
While rsList.read
myRTB.Text = Replace(rsList("CenterInfo"), "|", "'")
end while
End Sub

</script>
<html>
<head>

<title>Your Center Page</title>
<script language="JavaScript">

</script>


<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="198" valign="top"> <br>

</td>
<td width="582" valign="top"><div align="left">
<p><strong><font size="3" face="Verdana, Arial, Helvetica, sans-serif"> <br>
</font></strong><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><strong>Center
Information</strong></font></p>
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Inform
readers from other locations about your center.</font></p>
<Form ID="PostMessage" Runat="Server">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="23%" height="26"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">About
Our Center:</font></td>
<td width="77%"><a href="javascript:InsertTag('<B> </B>')"> </a></td>
</tr>
<tr valign="top">
<td colspan="2"> <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> <RTB:RichTextBox id="myRTB" runat="server" />
</font><font color="#FF0000"> <br>
<asp:label ID="lblStatus" runat="server"></asp:label>
</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<asp:button ID="btnSubmit" runat="server" Text="Submit" onClick="Insert"/>
</font></p>
</td>
</tr>
</table>
</Form>
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></p>
</div>
<div align="center"></div></td>
</tr>
</table>

<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="/Images/Dynamic/footer.gif" width="780" height="15"></td>
</tr>
<tr>
<td><td>
</tr>
</table>
<p> </p>
</body>
</html>

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-06-08 : 13:08:52

I am referring to the value of myRTB.CenterInfo where you are experiencing problems. My thought is there might be a value ( such as "/>" for example , which is confusing the .net tags.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources