flash data integration: I am under the following platforms: CF MX 6.1 and SQL Server 2000. I cannot
populate the DateField Component with a date data type from a SQL Server Web
service. I have basically tried every configuration with format and encoding
in the bindings tab on the dataset and the datefield. I can populate a
textinput with the date but not the datefield. I have tried the following from
two other posts and cannot get them to work either.
1.---------------------------------- Add connector, add schema with a date
field (myDate) and give it a data type of date. Set the encoder on the schema
to properly recieve your date. i.e. if it's coming from SQL server, set the
encoder to date, with an encoder option of YYYY-MM-DDTHH:NN:SS. (note the 'T'
inbetween the time and date) Add your dataset and add a property to the schema
called myDate and give it a data type of date. Now, I don't think the encoder
and formatter options on the dataset schema for myDate matter, but try using
the same for both. i.e. YYYY-MM-DD Add a dateField component and on the schema
set it's selectedDate property formatter to date, with options YYYY-MM-DD Bind
the selectedDate of the dateField with the myDate property of the dataset, and
leave the binding formatter on none. -----------------------------
2.-------------------------------------- 1) dataSet: create a schema item with
type string 2) dateField: leave selectedDate set to type date. 3) Either:
create a TWO-WAY binding between the dataSet and dateField.selectedDate 4)
Either: UNDER THE BINDINGS TAB, set the formatter to Date and the formatter
options to MM/DD/YYYY. You can change the formatter options if you want, but
you apparently need to use a four year date if you want it to translate from
the dataSet to the dateField properly. ----------------------------------------
Thanks in advance for any help provided!

I have had no success with the DateField component tied to an Access database.
I have tried the schema stuff and cannot get it to show the date in the proper
format and still have it save back to the database without errors. Have you
been able to make this work? DAN

WSDL SQL Data connection from DataSet to DateField components with Formatter
1. On the dataSet Schema add a component property and name it in all UPPER
CASE. Do not add any formatting to this. 2. On the date field component
make sure there is Schema of selectedDate and add formatter Date and a format
of YYYY-MM-DDTHH:NN:SS (notice this is the SQL Server formatting needed in the
Schema) If you search the macromedia forums you can find the formatting needed
here for Access? 3. In the bindings tab for the dateField + Add Binding and
bind it to correct field in the dataSet component that has your query array.
Once you have bound the dateField to the dataSet component select Date under
the formatter and format with YYYY-MM-DD Test the Flash movie
and it should show the date in the field like so? thedanster, I have a word
doc file with the screenshots of this if you want it. Just send me an email to
bribas1@comcast.net and I will reply with the file attachment. brian