Thanks - on my way there right now, Mic.
--- In [email protected], "smitade" <smit...@...> wrote: > > 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 [email protected], "Mic" <chigwell23@> 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. > > >
