MySQL joined select

Pete pete at mollysrevenge.com
Mon Mar 19 17:15:00 EDT 2012


I wonder if there might be a less ugly way to do this in LC instead of
SQL...
Pete

On Mon, Mar 19, 2012 at 2:04 PM, Marek <reichenbach.marek at gmail.com> wrote:

> Thanks a lot! That helped me a lot man.
>
> Marek Reichenbach
>
> On 2012 Kov. 19, at 19:29, Ken Ray <kray at sonsothunder.com> wrote:
>
> >
> > On Mar 19, 2012, at 3:44 AM, Marek Reichenbach wrote:
> >> when i get for example: 1234567 -> i should get result +++++++, 123-56-
>  I
> >> would get +++-++- .
> >
> > The only way I know is kind of ugly, requiring seven nested REPLACE
> statements:
> >
> > SELECT
> REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("123-56-","1","+"),"2","+"),"3","+"),"4","+"),"5","+"),"6","+"),"7","+")
> >
> > This would return:
> >
> > +++-++-
> >
> >
> > Ken Ray
> > Sons of Thunder Software, Inc.
> > Email: kray at sonsothunder.com
> > Web Site: http://www.sonsothunder.com/
> >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>


-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>



More information about the use-livecode mailing list