RE: SQL question

The boxes are definitely the carriage return line feed
characters that I put in.  However, I need to figure
out how to actually create the new line in the field
itself -- obviously the method I am using isn't
working.

Rebecca

--- Ann Ezzell <amcbainezzell(at)alum.mit.edu> wrote:
> 
> Have you tried pulling the data back out, to see
> what it looks like? Maybe
> those little boxes are simply the carriage return
> and line feed characters.
> 
> > Hi all!
> >
> > I've been banging my head up against the wall for
> the
> > better part of the day today over the following
> > problem:
> >
> > I need to do something that seems so simple.  I'm
> > running an insert SQL statement from an ASP page. 
> The
> > database is SQL Server 7.0.  This database has a
> text
> > field with a len of 16.  Another application
> running
> > off of this database and entering data into it.
> >
> > I need to match what its entering so that my
> system
> > won't upset the current system.  In this text
> field,
> > its entering what appears to be carriage returns
> into
> > the data, just as if you typed the data directly
> into
> > the field and pressed shift + enter to get a new
> line.
> >  I'm trying to create the SQL statement that will
> > write out a string into that field including those
> > character returns.
> >
> > I understand VB very well and have done versions
> of
> > this in Access database.  I included a chr(10) and
> > chr(13) (line-feed and character returns) in the
> SQL
> > statement.  Its writing the characters to the
> field in
> > the database, but they are not having the desired
> > effect.  Instead of showing as a new line, they
> are
> > just showing as two boxes.
> >
> > I know this is possible, and I know I've got to be
> > close.  Any suggestions???
> >
> > TIA
> >
> > Rebecca
> >
> > =====
> > Do while Project<>Completed
> >    if impossible = true then
> >       rethink(approach)
> >       set impossible = false
> >    end if
> > loop
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email alerts & NEW webcam video instant
> messaging with Yahoo!
> > Messenger
> > http://im.yahoo.com
> 


=====
Do while Project<>Completed
   if impossible = true then
      rethink(approach)
      set impossible = false
   end if
loop

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA