I cannot get a MS-SQL coldfusion datasource to work correctlyusing auto-increment (identity = yes). MS Access seems to handleAutonumber just fine however.I let the CF Wizard generate my component scripts and there'san option to allow the primary key to be handled by the user if thedatabase won't auto-increment. Well, I'd like to use this option,but I don't know what needs to be done after the scripts aregenerated.Can anyone provide some insight on what code needsmodified?

I'm using a ColdFusion data source assigned to a MS-SQLdatabase. The database has a primary key with data type set tosmallint, auto-increment/identity = yes.I'm using the CFC wizard to create my CFCs and actionscriptvalueObject. My application is basic so far, just a data grid and a3-field form. When I run my app, the data grid populates properlywith the data from my MS-SQL db. I can fill out the form and submitthe data, which adds another record to my database and isimmediately reflected in the...

While I can develop flex apps that use CF data sources on FDSwith my local test machine (using integrated JRun), I'm clueless asto getting the same results on my production server.My production server is Windows 2003 and it has a stand-aloneCF 7.0.2 application server. I need to be able to run FDS so I canput my apps into production so I can connect my apps to mycoldfusion data sources and have "live data" (reason for usingFDS).How can I do this?

I'm confused on which server-type installation I shouldchoose when installing Flex Data Services. It gives me the optionof JRUN or J2EE. I've installed them both and couldn't figure outhow to path my Flex to J2EE. They both installed into C:\FDS2, butJRUN had a directory for the server and J2EE did not.I am also trying to run this off a server with ColdFusion aswell. Anyone able to give insight on JRUN or J2EE?