Gossamer Forum
Home : Products : DBMan : Discussions :

'Missing' Data... HTML Tag Issue?

Quote Reply
'Missing' Data... HTML Tag Issue?
I have a text field [length 255] in which I enter a book title, which is actually a link to Amazon.

After entering 100 records, everything displays fine.

When I go to Modify mode, I notice the 'title' field data appears truncated after about the 5th character. To resolve this, I need to re-enter the field and save.

Some 'error text' displays next to the field:

The Power of a Praying Wife, Omartian, Stormie" MAXLENGTH="255">

The actual data in the field should be:

<a href="http://www.amazon.com/exec/obidos/ASIN/1565075722">The Power of a Praying Wife</a>, Omartian


The complete data always exists in the db. It seems that the modify screen somehow truncates
the data.

The field is set to the 255 max -- both in the htm.pl and in the cfg.

Seems I'm only having trouble with this field -- Could it be because I'm entering an HTML tag?
Other fields, even fields with more data, are not a problem.

I'm in the process now of re-entering all records [deleted db and count records] just in case something was corrupted.


Quote Reply
Re: 'Missing' Data... HTML Tag Issue? In reply to

for what's it's worth, Yes, it does sound like an html tag issue. I have:
<INPUT TYPE="TEXT" NAME="Title" VALUE="$rec{'Title'}" SIZE="40" MAXLENGTH="255">
which means that in the browser on 40 characters are shown but up to 255 characters are allowed.

good luck

on the pages in between ...
Quote Reply
Re: 'Missing' Data... HTML Tag Issue? In reply to
I suspected that too.

Here's what I have for the problem field:

'Title' => [ 2, 'alpha', 255, 255, 1, '', ''],


<INPUT TYPE="TEXT" NAME="Title" SIZE="255" VALUE="$rec{'Title'}" MAXLENGTH="255">


A new record saves okay. But if I go back and modify it,
only the characters "<a href=" [with no double quotes]display and I need to re-enter the entire string again.

It doesn't matter which field in the db I try -- All produce the same problem when entering an href tag.


Quote Reply
Re: 'Missing' Data... HTML Tag Issue? In reply to
Okay. I have success entering the href tag WITHOUT the double quotes like this:

<a href=http://www.amazon.com/exec/obidos/ASIN/031022151X>Boundaries in Marriage</a>, Cloud

Instead of this [had problems with the code below]:

<a href="http://www.amazon.com/exec/obidos/ASIN/031022151X">Boundaries in Marriage</a>, Cloud


Tell me if this makes sense.

Only problem now is that the field displays [list all] like this:

Boundaries in Marriage, Cloud"

Note the double quote at the end. Where would this be coming from?

Quote Reply
Re: 'Missing' Data... HTML Tag Issue? In reply to
Looks like leaving out the double quotes does the trick. Undocumented feature?

Quote Reply
Re: 'Missing' Data... HTML Tag Issue? In reply to
Actually, that is browser-specific...always a good idea to include double quotes in attributes inside HTML anchors and tags.


Eliot Lee Wink