473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Is there a character limit on bound controls?

I'm trying to build a mini-CMS for a friend (ASP.NET 2.0/VB) - just a
simple admin page w/ a text box and button that inserts some text into
a database (I'm using Access 2003 - text is going into a Memo field)
that will subsequently be fed to a page to display. The insert works
just fine - I've put more than 1,000 characters in without incident.
However, on the page that needs to display the text, the text is
truncated to about 200 characters.

On the display page I have my Access datasource that is pulling the
last updated record from the database. Then, I have tried a "details
view" and a Form View with the text bound to a label inside an item
template. In either case, the text is truncated.

More info: The text will contain basic HTML tags. In the form view,
the HTML is rendered properly, but in the details view it was coming
out as text tags. The truncation happens regardless of whether there
are tags or not.

I'm sure there's a simple solution, but I've looked through all the
properties on the controls and can't find anything that might be
limiting the length of the text.

Please help.

TIA,
Laura

Aug 25 '06 #1
4 3137
No, there is no limit.

Are you sure all 1000 characters are going into the database? Just because
there is no error, doesn't mean they all went into the database.

"pedalchick" <pe********@hotmail.comwrote in message
news:11*********************@p79g2000cwp.googlegro ups.com...
I'm trying to build a mini-CMS for a friend (ASP.NET 2.0/VB) - just a
simple admin page w/ a text box and button that inserts some text into
a database (I'm using Access 2003 - text is going into a Memo field)
that will subsequently be fed to a page to display. The insert works
just fine - I've put more than 1,000 characters in without incident.
However, on the page that needs to display the text, the text is
truncated to about 200 characters.

On the display page I have my Access datasource that is pulling the
last updated record from the database. Then, I have tried a "details
view" and a Form View with the text bound to a label inside an item
template. In either case, the text is truncated.

More info: The text will contain basic HTML tags. In the form view,
the HTML is rendered properly, but in the details view it was coming
out as text tags. The truncation happens regardless of whether there
are tags or not.

I'm sure there's a simple solution, but I've looked through all the
properties on the controls and can't find anything that might be
limiting the length of the text.

Please help.

TIA,
Laura

Aug 25 '06 #2

Marina Levit [MVP] wrote:
No, there is no limit.

Are you sure all 1000 characters are going into the database? Just because
there is no error, doesn't mean they all went into the database.

"pedalchick" <pe********@hotmail.comwrote in message
news:11*********************@p79g2000cwp.googlegro ups.com...
I'm trying to build a mini-CMS for a friend (ASP.NET 2.0/VB) - just a
simple admin page w/ a text box and button that inserts some text into
a database (I'm using Access 2003 - text is going into a Memo field)
that will subsequently be fed to a page to display. The insert works
just fine - I've put more than 1,000 characters in without incident.
However, on the page that needs to display the text, the text is
truncated to about 200 characters.

On the display page I have my Access datasource that is pulling the
last updated record from the database. Then, I have tried a "details
view" and a Form View with the text bound to a label inside an item
template. In either case, the text is truncated.

More info: The text will contain basic HTML tags. In the form view,
the HTML is rendered properly, but in the details view it was coming
out as text tags. The truncation happens regardless of whether there
are tags or not.

I'm sure there's a simple solution, but I've looked through all the
properties on the controls and can't find anything that might be
limiting the length of the text.

Please help.

TIA,
Laura
Yes - I can open Access and see everything. I just put text + spaces,
no special characters...
The text is being truncated to 225 characters.

Here is the display page code (my latest attempt)
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master"
Title="Untitled Page" %>
<script runat=server>
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

AccessDataSource1.SelectParameters.Item("event_id" ).DefaultValue =
ConfigurationManager.AppSettings("event_id")

End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/database/FC1.mdb"
SelectCommand="SELECT MAX([stage_num]), [event_id],
[stage_overview] FROM [tblStage] WHERE ([event_id] = ?) and
[stage_overview] IS NOT NULL GROUP BY [event_id], [stage_overview]">
<SelectParameters>
<asp:Parameter Name="event_id" Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>
<br />
<asp:Repeater ID="Repeater1" runat="server"
DataSourceID="AccessDataSource1">
<ItemTemplate>
<asp:Label ID="lblOverview" CssClass=default runat="server"
Text='<%# Bind("stage_overview") %>' />
</ItemTemplate>
</asp:Repeater>
</asp:Content>

Aug 25 '06 #3
When you look at the generated HTML, does it still have just 225 characters?
Do you have more then one item in your repeater, and every one is just 225?
Are any of the characters special HTML characters that your text contains
that could be messing it up?

Also, try a textbox instead of a label.

225 in general does not have any significance, as far as I know.

"pedalchick" <pe********@hotmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
>
Marina Levit [MVP] wrote:
>No, there is no limit.

Are you sure all 1000 characters are going into the database? Just
because
there is no error, doesn't mean they all went into the database.

"pedalchick" <pe********@hotmail.comwrote in message
news:11*********************@p79g2000cwp.googlegr oups.com...
I'm trying to build a mini-CMS for a friend (ASP.NET 2.0/VB) - just a
simple admin page w/ a text box and button that inserts some text into
a database (I'm using Access 2003 - text is going into a Memo field)
that will subsequently be fed to a page to display. The insert works
just fine - I've put more than 1,000 characters in without incident.
However, on the page that needs to display the text, the text is
truncated to about 200 characters.

On the display page I have my Access datasource that is pulling the
last updated record from the database. Then, I have tried a "details
view" and a Form View with the text bound to a label inside an item
template. In either case, the text is truncated.

More info: The text will contain basic HTML tags. In the form view,
the HTML is rendered properly, but in the details view it was coming
out as text tags. The truncation happens regardless of whether there
are tags or not.

I'm sure there's a simple solution, but I've looked through all the
properties on the controls and can't find anything that might be
limiting the length of the text.

Please help.

TIA,
Laura

Yes - I can open Access and see everything. I just put text + spaces,
no special characters...
The text is being truncated to 225 characters.

Here is the display page code (my latest attempt)
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master"
Title="Untitled Page" %>
<script runat=server>
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

AccessDataSource1.SelectParameters.Item("event_id" ).DefaultValue =
ConfigurationManager.AppSettings("event_id")

End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/database/FC1.mdb"
SelectCommand="SELECT MAX([stage_num]), [event_id],
[stage_overview] FROM [tblStage] WHERE ([event_id] = ?) and
[stage_overview] IS NOT NULL GROUP BY [event_id], [stage_overview]">
<SelectParameters>
<asp:Parameter Name="event_id" Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>
<br />
<asp:Repeater ID="Repeater1" runat="server"
DataSourceID="AccessDataSource1">
<ItemTemplate>
<asp:Label ID="lblOverview" CssClass=default runat="server"
Text='<%# Bind("stage_overview") %>' />
</ItemTemplate>
</asp:Repeater>
</asp:Content>

Aug 25 '06 #4

Marina Levit [MVP] wrote:
When you look at the generated HTML, does it still have just 225 characters?
Do you have more then one item in your repeater, and every one is just 225?
Are any of the characters special HTML characters that your text contains
that could be messing it up?

Also, try a textbox instead of a label.

225 in general does not have any significance, as far as I know.
Hello Marina,
It doesn't matter what the control is - text box, label, gridview,
detail view: it always comes up truncated. I've never come up against
this problem before. It seems like the truncation must be occuring
when I retrieve the data from the database. It may be a MS Access
issue, but I have never had this problem before...

Aug 25 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Hal Davison | last post by:
I have read that most people do not like bound controls? What is the reasoning for this point of view? -- Hal Davison Davison Consulting
4
by: Aaron Ackerman | last post by:
I am using typed datasets in an N-Tier Windows app using VB.NET. I know this posting cannot be fully explained in a single post that is why I am asking for someone to point me to a real world...
1
by: Rob NYS | last post by:
I have a bound form for employee evaluations. This form brings in the Name, Employee Number, SSN etc. I have 8 unbound text boxes for evaluation info to be entered into. From my understanding these...
19
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate...
3
by: ILCSP | last post by:
Heello, I'm using Access 2000. I have a form with a combo box that has a query as its row source and it's bound to column 1. This combo box is unbound to a record like the rest of the form...
4
by: kaborka | last post by:
I have a WinForm with controls bound to a typed recordset that was generated by the Dataset Designer. There are several ComboBox controls with their DataSource bound to different lookup tables. ...
2
by: Alfredo Barrientos | last post by:
Hi, I have been reading information about asp.net webcontrols, and i have found a term "List bound controls". What are "List Bound Controls"?? Which are the differences between these controls...
0
by: HP | last post by:
Hi there I have a datalist control with some bound controls in its Item Template and a gridview bound to one of those fields (residing also in Item Template). I've found out that when I click...
0
by: Mike | last post by:
So here's the situation (.NET 2.0 btw): I have a form, and on this form is a textbox among many other databound controls. The textbox is bound to a field in a data table via the Text property. ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.