[prev in list] [next in list] [prev in thread] [next in thread] 

List:       gambas-user
Subject:    Re: [Gambas-user] Help with converting text in field to number
From:       werner 007 <admin () micro-source ! ch>
Date:       2009-02-02 19:45:14
Message-ID: 21796806.post () talk ! nabble ! com
[Download RAW message or body]


Hello Richard

For me it looks you want use "Group By" instead Unions in SQL to get the
Resultset like



> xaxes-text|count|display_order
> -------------------------------------------
> 5-6             5               1
> 6-7           100            2
> over 7       10              3
> 

And to deal with Number vs Text you could use Regexp in MySQL (maybe other
SQL engines too)



> select 
> reference_range as XAxes_text,
> ,count (value) as count
> ,@row:=@row+1 as display_order 
> From (SELECT @row:=0) as r, clin_requests.vwResults  
> Where value RegExp '[0-1]'
> Group by reference_range
> 

Just as idea.


Regards, Werner(007)
-- 
View this message in context: \
http://www.nabble.com/Help-with-converting-text-in-field-to-number-tp21675635p21796806.html
 Sent from the gambas-user mailing list archive at Nabble.com.


------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


[prev in list] [next in list] [prev in thread] [next in thread]