LiveCode Forums

Thank you very much!
Works clean .

Marek.

Hi b, Mark. Thank you guys for the replies! Both of your scripts worked perfectly, tested. I have another question. In my query there are more than one column with "WHERE..AND.." filters and so one... Sooo... I wanna make my days result in the separate columns in the result, but when I do this way +...

Sorry for bothering you guys. Wanna ask you smth. In LiveCode If I have a result in MySQL like: SELECT days from travel; I get: column1 1234567 123456- 123456- 123---- 12345-7 (days from monday till sunday) Question. How can I make my result in form look like: when i get for example: 1234567 -> i sh...

I'm trying to do:
how to use data from other table in the same query for filtering:

SELECT A, B ,C, (SELECT D FROM TABLE2 WHERE C[from table2] < B[from table1]) FROM TABLE1; <-- the stucture of query

help :/

What do you mean joined? Thats's the question, how to get data in the same query from other table which will form the data in a query from table 1. Tables are in the same DataBase.

First of all thanks for the replies mwieder :), sorry, I just want to make it work. The query works fine, until i put something like this: put "SELECT isv_laik,atv_laik, atstum ,(SELECT info FROM table_home WHERE info < atstum ) FROM reisas where gal='3' ORDER BY isv_laik" into tSQL So the question ...

In MySQL it's fine.
In LC I don't get any data without revDataFromQuery

put " SELECT atstum FROM reisas" into tSQL
put tSQL into field "ats"

gives me:SELECT atstum FROM reisas.

so again... put "SELECT isv_laik,atv_laik,atstum,(select kaina from tarifai use index (tarifas) where (kg_nuo<'"& sGalutine1 &"' and '"& sGalutine1 &"'<=kg_iki) and (km_nuo< atstum and atstum <=km_iki) as dynamicCol FROM reisas where gal='"& sResaultSave & "'ORDER BY isv_laik" into tSQL put revDataF...

it doesn't. look, I will take a more simple query: put " SELECT atstum FROM reisas where gal='"& sResaultSave & "' ORDER BY isv_laik" into tSQL #put revDataFromQuery(tab, cr, sDatabaseID, tSQL) into tAtstum put tSQL into field "test" field test gives: SELECT atstum FROM reisas where gal='"& sResault...

Hmmm... putting tSQL into a field without evDataFromQuery call gives me the SQL query i've writen.

Hmmm, I've tried something like this as you said: put "SELECT isv_laik,atv_laik,atstum, ( select kaina from tarifai use index (tarifas) where (kg_nuo<'"& sGalutine1 &"' and '"& sGalutine1 &"'<=kg_iki) and (km_nuo< atstum and atstum <=km_iki ) as dynamicCol FROM reisas where gal='"& sResaultSave & "'...

Thank for the reply: I think... I need to have MySQL making itself a calculation when I do a SELECT. The 4th columns values are from ANOTHER table, but the whole calculation of the query must be with the values of column3 etc. ###this will form a table (filled in my example: column 1,2,3...perhaps I...

Hello, Need help. I'm new in LiveCode. The problem is, that I have a database, which has 3 colums which are from query normal, but the 4th column in field(table or smth) must take values from rowns on the left and make some calculations with them automaticly.... Any advice ? Please... id distance we...