nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Najděte více příspěvků označených jako

Accepted answers

All comments

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.

ZahidChaudhry

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

Zahid

NasifAlshaier

Hi..

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

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

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

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

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

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

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.