Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [charly] dbman -> dbman sql (paragraph indenting)

Quote Reply
Re: [charly] dbman -> dbman sql (paragraph indenting) In reply to
Hi Charly,

I e-mailed gossamer-threads with my problem and here's what Alex responded with:

Quote:


> When I add a new file line feeds and returns
> do not show up. Can you please let me know what I need to do to fix this?

By default, DBMan shows exactly what was entered. So it's displaying the
line feeds as line feeds. HTML however ignores line feeds, and in order
for your browser to display the line feeds you need to replace it with
an HTML <BR> tag.

To do this for all your tags, you could add a global called
'convert_linefeeds' (without quotes) that has:

sub {
my $tags = shift;
foreach my $tag (%$tags) {
$tags->{$tag} =~ s/\r\n/<BR>\n/g;
}
}

and then add:

<%convert_linefeeds%>

at the top of your template. This will alter all your tags so that
linefeeds get <BR> tags inserted.

> AIso, I imported my flatfile dbman database to dbman sql, and everything
> looks fine except for the paragraphs. The paragraph indentations do not
> come up. For example,
>
> ----------------------------------------------
> ``the same manufacturing lots.````If you have any questions regarding the
> analysis performed on these units,``or need any additional information
> please feel free to contact me.````Best regards,``
> ----------------------------------------------
>
> should be:
> ----------------------------------------------
>
> the same manufacturing lots.
>
> If you have any questions regarding the analysis performed on these units,
> or need any additional information please feel free to contact me.

Hmm, the import should have handled this. The `` are from the flatfile
version. A quick fix would be to go to SQL Monitor and type:

UPDATE table SET col = REPLACE(col, "``", "\n");

where table is the name of the SQL table and col is the column name that
has the `` chars in it.

Let me know if you have any other problems.

Cheers,

Alex
Hopefully this will help you out.Crazy hehe
Reena
Subject Author Views Date
Thread dbman -> dbman sql (paragraph indenting) Reena0330 3651 Jun 10, 2002, 1:13 PM
Thread Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 3578 Jun 10, 2002, 1:46 PM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 3579 Jun 10, 2002, 1:57 PM
Thread Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 3560 Jun 12, 2002, 9:05 AM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
charly 3573 Jun 15, 2002, 1:44 PM
Post Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 3531 Jun 21, 2002, 4:01 PM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 3518 Jun 27, 2002, 5:14 PM
Post Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 3499 Jun 28, 2002, 2:26 AM
Post Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
YoYoYoYo 3166 Feb 12, 2003, 7:10 AM