sqlite blob fields in c++ 5.5.1

im having trouble displaying a blob field in a console game i made.

here is the function:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
int
look(void)
/* inspect current room */
{
     short loc;
     sqlite3_stmt *statement;
     const char *tail;

     chrptr=&player[usrnum];
     
     loc = chrptr->location;

     sprintf(sqlbuf,"select * from 'rooms' where rowid=%d limit 0,%d",loc,numroom);

     if(sqlite_prepare_v2(database,sqlbuf,strlen(vdatmp),&statement,&tail)==SQLITE_OK)
     {
        while(sqlite3_step(statement)==SQLITE_ROW)
        {
           pmlt("\r%s\r",sqlite3_column_blob(statement,1));
           outmlt(usrnum);  
        }
        sqlite3_finalize(statement);
     }
     return(1);
}


it does everything i want it to except it adds spaces between each line of text.
when i originall wrote this game back in the 90's i used dbase V and had no problem displaying my memo fields, since porting it all over to sqlite it all works great with the exception of my memo fields printing all wierd.

example:

You're in a newly created room
==============================
you are in a newly created room.
a small road leads to the north.
there is a sign on a large oak tree.

prints like this:

You're in a newly created room

==============================

you are in a newly created room.

a small road leads to the north.

there is a sign on a large oak tree.

any help would be appreciated.
Topic archived. No new replies allowed.