display correct data mySQL statement
Ben Rubinstein
benr_mc at cogapp.com
Tue Jun 27 12:25:35 EDT 2006
On 27/6/06 17:13, Robert Mann wrote:
> I run my statement and get the info from the mysql table place it info a fld
> spaced by tabs
> I have tried this
> put word 34 of fld "Select springcalc" into fld "views"
> to then display the data,which works fine if you have data in each cell of
> the table, any cell that does not have data then gets put into the wrong
> cell there after so if 32 has no data it will put 33 into the spot where 32
> should go and so on
>
> so is there a way to select the data from the fld by tabs, if so how?
> If I look at the data in the fld it shows the empty spaces(tabs)
set the itemDelimiter to tab
then use "item 34" etc in place of "word 34".
Word separation is 'funny' (aka 'smart') so it does things like collapse runs
of whitespace. Item delimiting is 'dumb' (aka 'straightforward') so two blank
tabs (or whatever the delimiter is) count as having an empty item in between them.
Ben Rubinstein | Email: benr_mc at cogapp.com
Cognitive Applications Ltd | Phone: +44 (0)1273-821600
http://www.cogapp.com | Fax : +44 (0)1273-728866
More information about the use-livecode
mailing list