Re: [sqlite] Adding data to the end of a column

[jose isaias cabrera]

"P Kishor" wrote...



On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:

Punkish,

I don't want to replace it.  I want to add to the end of field.  So, I 
did

not know that I could do,

UPDATE table SET field = field && 'data to be added' WHERE id = 55;


first, you should use || as the string concat operator, although &&
might also work. I haven't tried it though.

That said, I hate to tell you that whether you do

field = field || 'data to be added'

or given

field = 'value'

you do

field = 'value with more text'

you are replacing the value of the field, and that was what I was
trying to illustrate. I should have really said

field = field || ' with more text'


Ok, just to complete this thread, this works,

UPDATE table SET field = field || 'data to be added' WHERE id = 55

thanks.

josé



So, I think this should do it.  I will give it a try and get back to the
group.

thanks all.

josé

- Original Message -
From: "P Kishor" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, January 30, 2008 2:59 PM
Subject: Re: [sqlite] Adding data to the end of a column


> replace the field with new value.
>
> UPDATE table SET field = 'value with more data' WHERE field = 'value'
>
> On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>>
>> Greetings.
>>
>> Is there a way to add data to the end of a field?  I know I select 
>> that
>> field, import the data into a variable and then add whatever to the 
>> end.

>> What I am trying to do is exactly NOT that. :-)  So, instead, just add
>> say a
>> line or two of text to a field.
>>
>> Is this possible?
>>
>> thanks,
>>
>> josé
>>
>>
>> -
>> To unsubscribe, send email to [EMAIL PROTECTED]
>> -
>>
>>
>
>



-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Adding data to the end of a column

[P Kishor]

On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
> Punkish,
>
> I don't want to replace it.  I want to add to the end of field.  So, I did
> not know that I could do,
>
> UPDATE table SET field = field && 'data to be added' WHERE id = 55;

first, you should use || as the string concat operator, although &&
might also work. I haven't tried it though.

That said, I hate to tell you that whether you do

field = field || 'data to be added'

or given

field = 'value'

you do

field = 'value with more text'

you are replacing the value of the field, and that was what I was
trying to illustrate. I should have really said

field = field || ' with more text'



>
> So, I think this should do it.  I will give it a try and get back to the
> group.
>
> thanks all.
>
> josé
>
> - Original Message -
> From: "P Kishor" <[EMAIL PROTECTED]>
> To: 
> Sent: Wednesday, January 30, 2008 2:59 PM
> Subject: Re: [sqlite] Adding data to the end of a column
>
>
> > replace the field with new value.
> >
> > UPDATE table SET field = 'value with more data' WHERE field = 'value'
> >
> > On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
> >>
> >> Greetings.
> >>
> >> Is there a way to add data to the end of a field?  I know I select that
> >> field, import the data into a variable and then add whatever to the end.
> >> What I am trying to do is exactly NOT that. :-)  So, instead, just add
> >> say a
> >> line or two of text to a field.
> >>
> >> Is this possible?
> >>
> >> thanks,
> >>
> >> josé
> >>
> >>
> >> -
> >> To unsubscribe, send email to [EMAIL PROTECTED]
> >> -
> >>
> >>
> >
> >
>

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Adding data to the end of a column

[jose isaias cabrera]

Punkish,

I don't want to replace it.  I want to add to the end of field.  So, I did 
not know that I could do,


UPDATE table SET field = field && 'data to be added' WHERE id = 55;

So, I think this should do it.  I will give it a try and get back to the 
group.


thanks all.

josé

- Original Message - 
From: "P Kishor" <[EMAIL PROTECTED]>

To: 
Sent: Wednesday, January 30, 2008 2:59 PM
Subject: Re: [sqlite] Adding data to the end of a column



replace the field with new value.

UPDATE table SET field = 'value with more data' WHERE field = 'value'

On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:


Greetings.

Is there a way to add data to the end of a field?  I know I select that
field, import the data into a variable and then add whatever to the end.
What I am trying to do is exactly NOT that. :-)  So, instead, just add 
say a

line or two of text to a field.

Is this possible?

thanks,

josé


-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Adding data to the end of a column

[P Kishor]

replace the field with new value.

UPDATE table SET field = 'value with more data' WHERE field = 'value'

On 1/30/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>
> Greetings.
>
> Is there a way to add data to the end of a field?  I know I select that
> field, import the data into a variable and then add whatever to the end.
> What I am trying to do is exactly NOT that. :-)  So, instead, just add say a
> line or two of text to a field.
>
> Is this possible?
>
> thanks,
>
> josé
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Adding data to the end of a column

[Shawn Milochik]

-Original Message-
From: jose isaias cabrera <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: [sqlite] Adding data to the end of a column
Date: Wed, 30 Jan 2008 14:34:17 -0500

Greetings.

Is there a way to add data to the end of a field?  I know I select that 
field, import the data into a variable and then add whatever to the end. 
What I am trying to do is exactly NOT that. :-)  So, instead, just add say a 
line or two of text to a field.

Is this possible?

thanks,

josé 





Try:

UPDATE tablename SET something = something + " addition";

Not sure of the exact syntax for contacenation -- could be + or . or something 
else.

Shawn




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Adding data to the end of a column

[jose isaias cabrera]

Greetings.

Is there a way to add data to the end of a field?  I know I select that 
field, import the data into a variable and then add whatever to the end. 
What I am trying to do is exactly NOT that. :-)  So, instead, just add say a 
line or two of text to a field.


Is this possible?

thanks,

josé 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-