Calling mssql procs through flex can be done using pyamf. Here's some code
using pyamf: http://freevryheid.x10hosting.com/drupal/?q=node/15
--- In flexcoders@yahoogroups.com, "Mic" <chigwel...@...> wrote:
>
> I have to embed my SQL within Flex until I can work out how to call a
> SQLServer proc from within Flex (any pointers here would be much
> appreciated), and am writing functions:
>
> private function sel_mrkt_pln_yrs(p_string:String = null):String{
> var sqlString:String = "select distinct issue_yr, cast(issue_yr as Int) as
> ID from MKT_PLN where (case when " + p_string + " is not null then case when
> mkt_pln_typ = " + p_string + " then 1 end else 1 end) = 1 order by 1 desc;";
>
>
> return sqlString;
> }
>
> I would like to format the SQL so I can read it:
>
> select distinct
> issue_yr,
> cast(issue_yr as Int) as ID
> from
> MKT_PLN
> where
> (case when @p_mkt_pln_typ is not null then
> case when mkt_pln_typ = @p_mkt_pln_typ then
> 1
> end
> else
> 1
> end) = 1
> order by
> 1 desc;
>
> but var sqlString:String = ... will not take the separate lines etc. How are
> people doing this? TIA,
>
> Mic.
>
