LiveCode Forums.

Good Day Livecoders,

I need your help. I have a query my problem is how can I able to pass it to the txt field?

I have 2 columns in my table named "name and address"

I have query here's my script

local Ldisplay
local Tdisplay
put "select * from contact_details where email = 'dede'" into ldisplay
put revdatafromQuery (,,gConnectionID,ldisplay) into display

I am successful displaying in datagrid but i want to put it the data into the txt field.

from my query into the txtfield.

Need your help.

Any help will very much appreciated.

Thanks Livecoders.. )

Hi Snop21,

what about:
...
put revdatafromQuery (,,gConnectionID,ldisplay) into display
put display into fld "your field here"
...
Since "revdatafromQuery" will return just text, you can simply put this into a field!


Best

Klaus

-klaus

Thanks klaus,

I tried it but it display all the data from my query into the a single txtfield I want to display it one column per txtfield.
---sample my query "select name,email from contacts where name = 'snop21'"

the result
txtfield1 == the value of name from my query
txtfield2 == the value of email from my query

- Thanks

-snop21

Hi.

Is it possible that you are trying to put an array into a text field? This will not work. The array must first be converted into the clear, likely with the "combine" command.

If you already have your data in a dataGrid, the same issue applies, so you might take the "dgData" from the DG, since this is also clear data, not an array, like the dgData would be.

Craig Newman

I see.

Why not parse your data according to the delimiters it is formatted with? I assume these are tab and return? You can loop through each line quickly and extract the item of interest from each line. These will form the "column" you want.

Craig

Hi Craig,

I am new in Livecode that's why I am getting difficulty honestly I don't have an Idea how to do it regarding to your suggestion. But thanks anyway.. )

- snop21

Hi snop21,

snop21 wrote:I tried it but it display all the data from my query into the a single txtfield

but that was your question!

...i want to put it the data into the txt field...

What "revdatafromquery" returns is TEXT, as I already mentioned, in the format:
1 record per LINE and the fields delimited by TAB in each line in the order as you queried them.

So this:
...
select name,email from contacts where name = 'snop21'
...
will probably return ONE line/record, so you can do this:
...
put revdatafromQuery (,,gConnectionID,ldisplay) into display
set itemdel to TAB
put item 1 of display into fld "name"
put item 2 of display into fld "email"
...

Best

Klaus

Something like this. In a button somewhere: Craig

-Klus

Got it.. Thank you.. )

Kudos..!

-snop21

snop21 wrote:-Klus

KLAUS, my name is KLAUS!
KLAUS! &#*¢¢$$"§

What a Majer mistake!

Simon

-Klaus

it's a mortal sin.. hehe )

I am Very Sorry.. Didn't Noticed I spelled it wrong.

-snop21

Simon wrote:What a Majer mistake!
Simon

Very funny, Sayman!