topic Re: Write a SQL Select Statement in Flex in ArcGIS API for Flex Questions

Write a SQL Select Statement in Flex

BrentKastor — Wed, 14 Apr 2010 20:01:58 GMT

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

Write a SQL Select Statement in Flex

DasaPaddock — Wed, 14 Apr 2010 21:14:15 GMT

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

Question

NasifAlshaier — Wed, 21 Apr 2010 14:27:48 GMT

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

Write a SQL Select Statement in Flex

ZahidChaudhry — Fri, 23 Apr 2010 11:53:11 GMT

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...

code

NasifAlshaier — Tue, 27 Apr 2010 13:13:58 GMT

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

Re: code

ZahidChaudhry — Fri, 30 Apr 2010 12:19:32 GMT

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

Re: Write a SQL Select Statement in Flex

NasifAlshaier — Mon, 03 May 2010 16:21:16 GMT

Hi..

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

Re: Write a SQL Select Statement in Flex

ZahidChaudhry — Mon, 03 May 2010 16:43:03 GMT

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

Zahid

Re: Write a SQL Select Statement in Flex

EricPaitz — Mon, 03 May 2010 16:43:44 GMT

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.