Everything here, save the @APPEND note at the bottom, will work in every version of Tango, Witango and TeraScript I know of.
From: Bishop Weiss [mailto:bishop...@gmail.com] Sent: Thursday, March 05, 2015 11:37 PM To: TeraScript-Talk@terascript.com Subject: Re: TeraScript-Talk: Concatenating Text Robert, I let me ask again, I am still running a 5.5 server. I thought I tried these kind of things and it didn’t seem to work. Mark On Mar 5, 2015, at 6:49 PM, Robert Shubert <rshub...@tronics.com <mailto:rshub...@tronics.com> > wrote: TS does concatenation of any strings, variables and tags at any place where TML is acceptable. So you can select the value from the database and resave it right away with the concatenation. Let's say you so select just the column and record you want to edit: SELECT column FROM table WHERE primary_key = 1 So resultset is now a 1x1 array of the value you want to append. Then just update the record with the additional string: UPDATE table SET column = '<@VAR resultset[1,1]> additional text' WHERE primary_key = 1 I'm illustrating with SQL, but you would simply place: <@VAR resultset[1,1]> additional text In the value column of the update action. As a more advanced way, you can have SQL do the concatenation in one query with the + operator: UPDATE table set column = column + 'additional text' WHERE primary_key = 1 The upside is that you only execute one query, the downside is that you don't have the value afterwards. You can do this with the update action but you must handle your own quoting. A Custom SQL (directDBMS) would also work. In 7.0.3 I added @APPEND (<@APPEND varname string>) so that you can write clearer code when doing concatenation. Using the above resultset you would <@APPEND resultset[1,1] 'additional text'> which, in my opinion, is obvious code. Robert -----Original Message----- From: Mark Weiss [mailto:bishop...@gmail.com] Sent: Thursday, March 05, 2015 6:33 PM To: TeraScript-Talk@terascript.com <mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: Concatenating Text I can’t figure out how to select text from the db, assign it to a variable, add text to that variable i.e. concatenate it, and then resave that new variable back to the db so that it contains the original text and then the new added text. I am sure this is simple, but I can’t figure it out. Help. Mark ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe terascript-talk" in the body. _____ To unsubscribe from this list, please send an email to lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.
