Thanks for the replie!!! :), I'll make some research.
On 20 March 2012 18:38, Pete wrote:
> Hi Ken,
> Good catch on the multiple FROM clauses, not sure what that's all about.
> Probably just needs to qualify the columns in the condition with the table
> name.
>
> The SELECT statement has a lot
Hi Ken,
Good catch on the multiple FROM clauses, not sure what that's all about.
Probably just needs to qualify the columns in the condition with the table
name.
The SELECT statement has a lot of problems in general. There's no JOIN
statement to link table1 and table2 together, for example. Tha
Hi Marek,
I think you're confusing what you get back from the SELECT statement with
what you display to your users - they are two different things. I'm going
to assume that you need all the columns you name in your SELECT statement
for some processing reasons but that doesn't mean you have to show
On Mar 20, 2012, at 4:20 AM, Marek Reichenbach wrote:
> Thanks for the replies.
> I've made it workin, but I wanna add something else:
>
> So the question in SQL is:
>
> Maybe there is a way to hide columns it the result, like:
> SELECT car_nr, model, travel_days FROM table1,table2 WHERE number
Any columns you define in the select statement will be in the returned data.
You do not have to retrieve a column to use it in the select statement. This
works:
select zip from addresses where state = "CA"
Besides that, I do not know what you mean by "hide". Hide from what? Your user
interface
Thanks for the replies.
I've made it workin, but I wanna add something else:
So the question in SQL is:
Maybe there is a way to hide columns it the result, like:
SELECT car_nr, model, travel_days FROM table1,table2 WHERE number <> 414
AND (car_nr > truck_nr) from transport;
and show only result o
Seems like either Peter or Mark's solution would be a lot better than
trying to do it with an SQL SELECT, but I'm also not sure of what Marek is
trying to achieve - seems strange to want to replace all the numbers with
plus signs. Maybe he wants a floating plus sign at the start of the
number, dun
Hi,
put replacetext(theInput,"[1-7]","+") into theInput
is shorter. I don't know if it is also quicker.
(I also wrote this on the forum, earlier today).
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twit
repeat with n = 1 to length(tInput)
if char n of tInput is a number
then put "+" into char n of tInput
else put "-" into char n of tInput
end repeat
Or am I missing something?
-- Peter
Peter M. Brigham
pmb...@gmail.com
http://home.comcast.net/~pmbrig
On Mar 19, 2012, at 5:15 PM, Pete w
Pete writes:
>
> I wonder if there might be a less ugly way to do this in LC instead of
> SQL...
put replacetext(inputString, "[1-7]", "+") into tNewText
--
Mark Wieder
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this
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 wrote:
> Thanks a lot! That helped me a lot man.
>
> Marek Reichenbach
>
> On 2012 Kov. 19, at 19:29, Ken Ray wrote:
>
> >
> > On Mar 19, 2012, at 3:44 AM, Marek Reichenbach
Thanks a lot! That helped me a lot man.
Marek Reichenbach
On 2012 Kov. 19, at 19:29, Ken Ray 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
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
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
Hi,
Sure, just don't include B in your column list:
SELECT A,C,D FROM table1,table2 WHERE table1.key = table2.key AND
table2.C < table1.B
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkpr
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 17 March 2012 14:05, Mark Schonewill
I'll try.
Thanks Mark.
On 17 March 2012 14:05, Mark Schonewille
wrote:
> Hi,
>
> If the unique numbers are the same in both tables and indicate that the
> respective records belong together, then it is what I'm talking about.
>
> --
> Best regards,
>
> Mark Schonewille
>
> Economy-x-Talk Consult
Hi,
If the unique numbers are the same in both tables and indicate that the
respective records belong together, then it is what I'm talking about.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.co
Hi,
You need something to identify the rows in the tables. Somehow you need to know
which rows belong together. If this doesn't help you, then you need to be more
specific about the type of data in your two tables and what you are trying to
achieve.
--
Best regards,
Mark Schonewille
Economy-
Hi,
First, you need to create one big table. You do this with
SELECT * FROM table1,table2
This table will be way too big, so you need to add a way to select only the
relevant rows from that very big table, e.g.
SELECT * FROM table1,table2 WHERE table1.key = table2.key
You need to test and cha
20 matches
Mail list logo
