Re: [sqlite] Trim everything that is entered into database

2008-09-10 Thread Josh Millstein
On 9/10/08 11:11 AM, "Dennis Cote" <[EMAIL PROTECTED]> wrote: > Josh Millstein wrote: >> On 9/9/08 11:46 AM, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >>> Josh Millstein <[EMAIL PROTECTED]> >>> wrote: Is there anyway to perform a trim to everything that is entered into a table

Re: [sqlite] Trim everything that is entered into database

2008-09-10 Thread P Kishor
On 9/10/08, Josh Millstein <[EMAIL PROTECTED]> wrote: > The trim before I put data in was based on using a programming language and > not the db language. I want to do it all in sql syntax > What Igor suggested *is* SQL syntax INSERT INTO table (col) VALUES (trim()) > > > On 9/9/08 12:52

Re: [sqlite] Trim everything that is entered into database

2008-09-10 Thread Dennis Cote
Josh Millstein wrote: > On 9/9/08 11:46 AM, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >> Josh Millstein <[EMAIL PROTECTED]> >> wrote: >>> Is there anyway to perform a trim to everything that is entered into >>> a table instead of trimming before I put data in? >> >> update mytable set

Re: [sqlite] Trim everything that is entered into database

2008-09-10 Thread Josh Millstein
Yes, automatically like using triggers. That is exactly what I'm talking about On 9/9/08 2:03 PM, "Enrique Ramirez" <[EMAIL PROTECTED]> wrote: > I'm guessing he means like automatically (IE using triggers). > > Which also would be my answer (use triggers). > > On Tue, Sep 9, 2008 at 1:52 PM,

Re: [sqlite] Trim everything that is entered into database

2008-09-10 Thread Josh Millstein
The trim before I put data in was based on using a programming language and not the db language. I want to do it all in sql syntax On 9/9/08 12:52 PM, "P Kishor" <[EMAIL PROTECTED]> wrote: > On 9/9/08, Josh Millstein <[EMAIL PROTECTED]> wrote: >> Hello, >> >> Is there anyway to perform a

Re: [sqlite] Trim everything that is entered into database

2008-09-10 Thread Josh Millstein
On 9/9/08 11:46 AM, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > Josh Millstein <[EMAIL PROTECTED]> > wrote: >> Is there anyway to perform a trim to everything that is entered into >> a table instead of trimming before I put data in? > > I'm not sure I understand the question. Are you perhaps

Re: [sqlite] Trim everything that is entered into database

2008-09-09 Thread Enrique Ramirez
I'm guessing he means like automatically (IE using triggers). Which also would be my answer (use triggers). On Tue, Sep 9, 2008 at 1:52 PM, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/9/08, Josh Millstein <[EMAIL PROTECTED]> wrote: >> Hello, >> >> Is there anyway to perform a trim to everything

Re: [sqlite] Trim everything that is entered into database

2008-09-09 Thread P Kishor
On 9/9/08, Josh Millstein <[EMAIL PROTECTED]> wrote: > Hello, > > Is there anyway to perform a trim to everything that is entered into a table > instead of trimming before I put data in? aren't "perform a trim to everything that is entered into a table" and "trimming before I put data in" the

Re: [sqlite] Trim everything that is entered into database

2008-09-09 Thread Igor Tandetnik
Josh Millstein <[EMAIL PROTECTED]> wrote: > Is there anyway to perform a trim to everything that is entered into > a table instead of trimming before I put data in? I'm not sure I understand the question. Are you perhaps thinking of update mytable set myfield=trim(myfield); Igor Tandetnik

[sqlite] Trim everything that is entered into database

2008-09-09 Thread Josh Millstein
Hello, Is there anyway to perform a trim to everything that is entered into a table instead of trimming before I put data in? Thanks, Josh -- ___ sqlite-users mailing list sqlite-users@sqlite.org