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