Getting rid of DOUBLE SPACING!

I just took over admin control of a website at http://www.lyricster.com and
I am having a hell of a time trying to pin down the problem of double
spacing when I add new lyrics to the database.

The thing is, most all of the db items (lyrics) on the website are single
spaced, and yet when I try to post new lyrics, it comes out double-spaced.
I even tried to log in as a normal user and post lyrics that way...same
problem.

If you need example of the problem go to the site, click on "Runnin' With
The Devil - Van Halen" and then click on a few other of the song
titles...all of the ones that have double spaced text are mine.

HELP!!!!I should add that the double spacing problem is not on the input side, but
how the database info is parsed out to the screen. Hope this clears it up
a bit more.

"Moviesounds.com" <aarrowstar@.yahoo.com> wrote in message
news:oy8Mb.13906$6y6.377982@.bgtnsc05-news.ops.worldnet.att.net...
> I just took over admin control of a website at http://www.lyricster.com
and
> I am having a hell of a time trying to pin down the problem of double
> spacing when I add new lyrics to the database.
> The thing is, most all of the db items (lyrics) on the website are single
> spaced, and yet when I try to post new lyrics, it comes out double-spaced.
> I even tried to log in as a normal user and post lyrics that way...same
> problem.
> If you need example of the problem go to the site, click on "Runnin' With
> The Devil - Van Halen" and then click on a few other of the song
> titles...all of the ones that have double spaced text are mine.
> HELP!!!!|||Moviesounds.com (aarrowstar@.yahoo.com) writes:
> I just took over admin control of a website at http://www.lyricster.com
> and I am having a hell of a time trying to pin down the problem of
> double spacing when I add new lyrics to the database.
> The thing is, most all of the db items (lyrics) on the website are single
> spaced, and yet when I try to post new lyrics, it comes out double-spaced.
> I even tried to log in as a normal user and post lyrics that way...same
> problem.
> If you need example of the problem go to the site, click on "Runnin' With
> The Devil - Van Halen" and then click on a few other of the song
> titles...all of the ones that have double spaced text are mine.

The HTML for the Van Halen thing looks like this:

So tell me why can't this be love <br />
<BR><br />
Straight from my heart oh tell me why <br />
<BR><br /
The extra <BR><br /> explains the double spacing. But neither the
single-spaced are OK:

you\'re always there <br />
<br />
\'Cause you\'re everywhere to me <br />
And when I close my eyes it\'s you I see <br /
What is that backslash doing before the single quotes?

Now, if you believe that this is a problem with SQL Server, then you
really have to provide your information. When you perform a SELECT
on the tables from Query Analyzer what do you see?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns946DA89388BC0Yazorman@.127.0.0.1...
> Moviesounds.com (aarrowstar@.yahoo.com) writes:
> > I just took over admin control of a website at http://www.lyricster.com
> > and I am having a hell of a time trying to pin down the problem of
> > double spacing when I add new lyrics to the database.
> > The thing is, most all of the db items (lyrics) on the website are
single
> > spaced, and yet when I try to post new lyrics, it comes out
double-spaced.
> > I even tried to log in as a normal user and post lyrics that way...same
> > problem.
> > If you need example of the problem go to the site, click on "Runnin'
With
> > The Devil - Van Halen" and then click on a few other of the song
> > titles...all of the ones that have double spaced text are mine.
> The HTML for the Van Halen thing looks like this:
> So tell me why can't this be love <br />
> <BR><br />
> Straight from my heart oh tell me why <br />
> <BR><br />
> The extra <BR><br /> explains the double spacing. But neither the
> single-spaced are OK:
> you\'re always there <br />
> <br />
> \'Cause you\'re everywhere to me <br />
> And when I close my eyes it\'s you I see <br />
> What is that backslash doing before the single quotes?
> Now, if you believe that this is a problem with SQL Server, then you
> really have to provide your information. When you perform a SELECT
> on the tables from Query Analyzer what do you see?
>
No idea, dude...I'm just a hack trying to figure out why the single-spaced
text I'm inputting into the myPHPserver interface with the SQL server is
parsing out as double spaced text when the request is made for a database
item.

In other words, I have no idea what a query analyzer is or where I could
find it. The myPHP documentation is definitely written for those already in
the know.

Also, I am not inputting any markup tags on the text...the server is doing
that on it's own.|||Moviesounds.com (aarrowstar@.yahoo.com) writes:
> No idea, dude...I'm just a hack trying to figure out why the
> single-spaced text I'm inputting into the myPHPserver interface with the
> SQL server is parsing out as double spaced text when the request is made
> for a database item.
> In other words, I have no idea what a query analyzer is or where I could
> find it. The myPHP documentation is definitely written for those
> already in the know.

Query Analyzer is a tool that comes with SQL Server, unless you only have
MSDE, in which case it is not included. I believe that with MSDE you may
still have OSQL, a command-line tool with which you can submit queries.

PHP I don't know anything about.

> Also, I am not inputting any markup tags on the text...the server is
> doing that on it's own.

Maybe the myPHPserver thing does. SQL Server does not, unless they are
part of the queries.

I'm afraid that you will not get much help here. If you don't know what
your system is doing, don't exepect people who don't have access to it
to find out.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Moviesounds.com" <aarrowstar@.yahoo.com> wrote in message news:<GrmMb.4866$VS4.160767@.bgtnsc04-news.ops.worldnet.att.net>...
> "Erland Sommarskog" <sommar@.algonet.se> wrote in message
> news:Xns946DA89388BC0Yazorman@.127.0.0.1...
> > Moviesounds.com (aarrowstar@.yahoo.com) writes:
> > > I just took over admin control of a website at http://www.lyricster.com
> > > and I am having a hell of a time trying to pin down the problem of
> > > double spacing when I add new lyrics to the database.
> > > > The thing is, most all of the db items (lyrics) on the website are
> single
> > > spaced, and yet when I try to post new lyrics, it comes out
> double-spaced.
> > > I even tried to log in as a normal user and post lyrics that way...same
> > > problem.
> > > > If you need example of the problem go to the site, click on "Runnin'
> With
> > > The Devil - Van Halen" and then click on a few other of the song
> > > titles...all of the ones that have double spaced text are mine.
> > The HTML for the Van Halen thing looks like this:
> > So tell me why can't this be love <br />
> > <BR><br />
> > Straight from my heart oh tell me why <br />
> > <BR><br />
> > The extra <BR><br /> explains the double spacing. But neither the
> > single-spaced are OK:
> > you\'re always there <br />
> > <br />
> > \'Cause you\'re everywhere to me <br />
> > And when I close my eyes it\'s you I see <br />
> > What is that backslash doing before the single quotes?
> > Now, if you believe that this is a problem with SQL Server, then you
> > really have to provide your information. When you perform a SELECT
> > on the tables from Query Analyzer what do you see?
> No idea, dude...I'm just a hack trying to figure out why the single-spaced
> text I'm inputting into the myPHPserver interface with the SQL server is
> parsing out as double spaced text when the request is made for a database
> item.
> In other words, I have no idea what a query analyzer is or where I could
> find it. The myPHP documentation is definitely written for those already in
> the know.
> Also, I am not inputting any markup tags on the text...the server is doing
> that on it's own.

I believe that MyPHP is used to link PHP to MySQL, not to MSSQL
(Microsoft SQL Server). So you will probably get a better response in
a newsgroup for MySQL and/or PHP than for MSSQL.

If I had to guess (and I do, since I know nothing about PHP or MySQL),
I would say that the problem is more likely to be in the PHP code, not
in the database.

Simon