Write a SQL Select Statement in Flex

[BrentKastor]

Hello,

I am looking to write a SQL Select Statement to populate a text field in my flex project.  I am running into some difficulties.  I want to select data from a SQL 2005 database using a variable that gets returned from a map click event.  Do I need to set up a connection to the SQL Server database first?  I found some Flex documentation, but it was not clear to me.  Any help would be greatly appreciated.  Thanks!

Brent Kastor
Coweta County, GA GIS

[DasaPaddock]

You'll need to create a web service on your server that accesses your database and returns the data you want. There are many ways this can be done. If the payload is small, then I'd recommend implementing it in whatever way you're most comfortable with.

See here from more info:
http://livedocs.adobe.com/flex/3/html/data_intro_2.html#188004

[NasifAlshaier]

Hi Brent...
were you able to implement the SQL select/populate? if so, can you share your steps.?
Thanks
Nasif

[ZahidChaudhry]

You have to use some sort of server side scripting easiest one to implement is PHP and especially Zend framework. if you hav php running on your machine. FlEX directly connect to SQL and writes all the codes for you using AMF which is very fast and robust and you do not need to publish the data as map service. I am using this technique to fetch data out of oracle and then create a dynamic graphics layer. I have to write all php script as FLEX only support SQL server...
But it is very easy and simple. if not you can use .NET web services to do the same thing...

[NasifAlshaier]

Thanks  for the posting.. can you share you code?

[ZahidChaudhry]

Thanks  for the posting.. can you share you code?

Here is a link to a video, that will explain step by step process to conncet to SQL server using php and FLEX

I hope it will help

[NasifAlshaier]

Hi..

I did not see any link to the video...Can you pls re-post it.
Thanks in advance

[ZahidChaudhry]

Sorry i forgot to add the link. but here it
http://www.adobe.com/devnet/flex/articles/flashbuilder4_php_code.html
Thanks

Zahid

[EricPaitz]

The approach we have used was to create some server side java code that connects and queries the database. This java code is called via a Remote Object call from Flex. The Flex to Java connection is made using BlazeDS. This book was a great way to get started.

http://www.amazon.com/Enterprise-Flex-Blazeds-Tutorial-Approach/dp/1440495661

From the flex side its just like calling the Query and QueryTask objects from the ArcGIS Flex API.