1. data base keys

I have written a program to import comma delimited ascii date from another
OS and added the keys and records to the EU database system. The data
appears to come back out fine, however the keys put in apparently have been
modified by a trim function which removes all but one interior blank. Is
this so? Or do I have a bug that I can't find?

here's where I get the key

     key = db_record_key(cur_row)

here's how I print it

    puts(html,"\""&key&"\"")

here's what comes out

    " 1 1"

it has had blanks trimm'ed out. this is what went into the data base. one
blank before the 1st one and 4 blanks betweenthe 2 one's.

  " 1    1"

does anyone have this problem, or know if I did something wrong? I check the
incomming key here and it is correct.

key = record[1..loc-1]
  puts(1,key&"\n") <------------ correct here comming in to the data base
from the ascii file.

and added to the database here

    a = insertRecord(key,outRecord)

..george

new topic     » topic index » view message » categorize

2. Re: data base keys

George Walters writes:
> ... the keys put in apparently have been
> modified by a trim function which removes 
> all but one interior blank. Is this so? 
> Or do I have a bug that I can't find?

> here's how I print it
>
>    puts(html,"\""&key&"\"")

> here's what comes out
>
>    " 1 1"
>
> it has had blanks trimm'ed out. 
> this is what went into the data base. one
> blank before the 1st one and 4 blanks between the 2 one's.
>
>  " 1    1"

It looks like you are writing this to a .html file,
and displaying it with a Web browser.
In HTML, multiple blanks are equivalent to one blank,
unless you force the issue by using &nbsp;
( ampersand nbsp semicolon )
I hope this shows up on the Web interface!
You can also make a pre-formatted section
using   <pre> ... </pre>
(  pre ... end-pre )

Regards,
   Rob Craig
   Rapid Deployment Software
   http://www.RapidEuphoria.com

new topic     » goto parent     » topic index » view message » categorize

3. Re: data base keys

thanks, you're absolutely correct... I've printed them out directly in EU
and they are correct...I had forgotten that browsers trim'd blanks...

..thanks..

..george

----- Original Message -----
From: "Robert Craig" <rds at RapidEuphoria.com>
To: "EUforum" <EUforum at topica.com>
Subject: Re: data base keys


>
> George Walters writes:
> > ... the keys put in apparently have been
> > modified by a trim function which removes
> > all but one interior blank. Is this so?
> > Or do I have a bug that I can't find?
>
> > here's how I print it
> >
> >    puts(html,"\""&key&"\"")
>
> > here's what comes out
> >
> >    " 1 1"
> >
> > it has had blanks trimm'ed out.
> > this is what went into the data base. one
> > blank before the 1st one and 4 blanks between the 2 one's.
> >
> >  " 1    1"
>
> It looks like you are writing this to a .html file,
> and displaying it with a Web browser.
> In HTML, multiple blanks are equivalent to one blank,
> unless you force the issue by using &nbsp;
> ( ampersand nbsp semicolon )
> I hope this shows up on the Web interface!
> You can also make a pre-formatted section
> using   <pre> ... </pre>
> (  pre ... end-pre )
>
> Regards,
>    Rob Craig
>    Rapid Deployment Software
>    http://www.RapidEuphoria.com
>
>
>
>
>

new topic     » goto parent     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu