ables, SQL will figure out which table an
> unqualified column name belongs to.
>
> Pete
>
> On Tue, Mar 20, 2012 at 8:46 AM, Ken Ray wrote:
>
> >
> > On Mar 20, 2012, at 4:20 AM, Marek Reichenbach wrote:
> >
> > > Thanks for the replies.
> > >
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
> > wrote:
> > >
> > >> Thanks a lot! That helped me a lot man.
> > >>
>
Hi Mark.
Sorry for bothering you again. Wanna ask you smth. In LiveCode
If I have a result in MySQL like:
SELECT days from travel;
I get:
1234567
123456-
123456-
123
12345-7
(days from monday till sunday)
Question.
How can I make my result in form like:
when i get for example: 1234567
Sorry Mark, one more question. Is there a way for example to do: SELECT
A,B,C,D FROM table1 WHERE A>B... BUT in the result SHOW only A column
result. HIDE B column
?
Please.
On 17 March 2012 14:08, Marek Reichenbach wrote:
> I'll try.
>
> Thanks Mark.
>
>
> On
; Mark Schonewille
>
> Economy-x-Talk Consulting and Software Engineering
> Homepage: http://economy-x-talk.com
> Twitter: http://twitter.com/xtalkprogrammer
> KvK: 50277553
>
> Download the Installer Maker Plugin 1.7 for LiveCode here
> http://qery.us/za
>
> On 17 mrt 201
w.Col2) WHERE id=NEW.id
>
> You would also have a second trigger defined as AFTER UPDATE.
>
> With those triggers in place, just SELECT PRICE FROM theTable.
>
> Hope that helps.
>
> Pete
>
> On Wed, Mar 14, 2012 at 9:30 AM, Marek Reichenbach <
> reiche
