Sitemap

Amicuk Programming Answers

Null Values from a Data Source

2015-10-11   Views:0

Advertisement

This is more of an implementation question than a troubleshooting question. Also, since I've been unable to find any documentation on this I was wondering if anyone has come across this behavior or found a bug with it. Yesterday I was working on an a

This is more of an implementation question than a
troubleshooting question. Also, since I've been unable to find any
documentation on this I was wondering if anyone has come across
this behavior or found a bug with it.
Yesterday I was working on an application to explore some
proof of concept aspects of Flex for an application I'm developing.
I started running into a problem with Flex Data Services throwing
back an 'Unknown Property: "clientaddress1"' error whenever I tried
to update data. It seemed that whenever I tried to update a record
in the database it would thrown the Unknown Property error. I spent
a good chunk of the day trying to figure out what was causing this
and finally gave up and called it a day.
This morning I was reassessing what the problem was and
trying to find the differences between my database and my code and
I stumbled upon the fact that I could add no records and modify
them without a problem, however if I tried to access an existing
record and update it I'd get the Unknown Property error.
I start analyzing the database and found that I'd configured
the database to use null values for empty values and the records
that I created with the database had null values, however, any of
the values inserted from Flex were inserted as blank values. As
matching my action script class as clientaddress1 = ""; So, upon
further testing I fould that Flex was not processing the null
values correctly, so that when it came back and rightly generated a
Conflict Error...and then called AcceptServer() it was unable to
find the clientaddress1 property of the class.
Also, if any of the properties in the database are null it
throws the same error. Basically it seems to have invalidated the
object just because one value was null. So if all of my values from
the DB are set to something and only one field is set to null it's
still throwing the error on the first alphabetical item of the
properties.
I can resolve the problem by not using null values in the
database, but...what sort of effect would this have on someone
working with a large legacy database that extensively uses nulls
for undefined values?
Also, if a Flex guru could explain the reasoning for this
happening I would greatly appreciate it!
Best regards,
Chris Maloney

The replay answer
Advertisement
I realize that I didn't clarify that I am using ColdFusion
for getting the data. This class was generated by the Create CFC
wizard in Flex Builder.
package com.generated
[Managed]
[RemoteClass(alias="components.generated.clients.Clients")]
public class Clients
public var clientid:Number = 0;
public var clientfirstname:String = "";
public var clientlastname:String = "";
public var clientaddress1:String = "";
public var clientaddress2:String = "";
public var clientcity:String = "";
public var clientstate:String = "";
public var clientzip:String = "";
public var clientphone:String = "";
public var clientemail:String = "";
public function Clients()
}

Go to See the other 6 answers

Null Values from a Data Source

Category:DefaultRelease time:2015-10-11Views:130

This is more of an implementation question than a troubleshooting question. Also, since I've been unable to find any documentation on this I was wondering if anyone has come across this behavior or found a bug with it. Yesterday I was working on an a[More]

Unable to find data source null [Caused by: jdbc/Apps1DataSource not found]

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am using OA Adapter which listens to an EBiz HRMS event, and I am encountering the following error in $Home\j2ee\oc4j_soa\log\oc4j_soa_default_group_1\oc4j\log.xml while registering the ESB service. Error details: <MSG_TEXT>Failed to process c[More]

Refresh data source view gets 'column' argument cannot be null

Category:DefaultRelease time:2015-10-11Views:130

When I try to refresh a data source view in SQL Server 2008 BIDS, I get the error: System.Data   'column' argument cannot be null.  Parameter name: column.   How to resolve this?  The underlying tables have no data yet.Hi PCSQL66, The error message s[More]

Data source value for data source reportData was null

Category:DefaultRelease time:-0001-11-30Views:130

hi i'm using struts 2 and jasperreports my problem is it generate a pdf file with labels but no data in it.. and when i try to look at the logs of my sun application server it says Data source value for datasource reportData was null. reportData is a[More]

Null pointer in Data Source deployment in WebLogic 8.1

Category:DefaultRelease time:-0001-11-30Views:130

I'm using WebLogic 8.1 in Eclipse 3.0. In the Weblogic console, my datasource tests out fine. But when I startup the WebLogic Server in Eclipse I get the error: Data Source "Datasource-Secondary" deployment failed with the following error: null.[More]

Microsoft Access Text Driver missing! and ...Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

Category:DefaultRelease time:-0001-11-30Views:130

In order to use OpenRowSet, I installded Microsoft Access Database Engine 2010. However, I could not find Microsoft Access Text Driver in Drivers of ODBC Data Source Administrator.  Could I get some help with that? Thank you very much!I am local admi[More]

SSRS CatalogItem method not working for deploying a shared data source

Category:DefaultRelease time:2015-10-11Views:130

I have been working with the SSRS CreateCatalogItem method to deploy reports to a SSRS 2012 in SharePoint integrated mode with SharePoint Server Enterprise 2013. I am using Powershell. The CreateCatalogItem method works fine when I deploy RDL files,[More]

Update Routine to populate 0VENDOR from either of the 2 data source fields

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a requirement to write an update routine for 0VENDOR based on the below logic : Create routines to populated BW Info Object u201CVendoru201D (0VENDOR) based on the following logic: IF field u201CVendoru201D (ITM_VENDOR_ID) is populated fro[More]

Unable to connect with new Data Source

Category:DefaultRelease time:2015-10-11Views:130

Hi everybody, After many developpment, I finally get my class to do what we need with crystal and webi report using Rebean and RAS SDK's. But, today we found a special case that I was thinking to solve following examples but the solutions given by th[More]

ADF application to access WLS data source .

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have developed an ADF application in Jdeveloper 10.3.3 and deployed on Weblogic server. Now I want my application to access the data from data source created in WLS. I have created a data source (ds_demo) using the WebLoigc server option Servic[More]

Using DAO using a JDBC data source with struts

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have created a number of Data Access Objects and Transfer Objects to use in a non EJB, struts web application I am developing. I had tested these with a kind of a Service Locator custom class to provide access to a JDBC connection. My custom[More]

Hot
Hi, My apology if it's not right place to talk about this. I get following error when I use Eclipse 3.1 find/update. Network connection problems encountered during search. Unable to access "http://update.eclipse.org/updates/3.0". Unable to acces [More]
This is my unit: Model Name: PowerBook G4 15" Model Identifier: PowerBook5,6 Processor Name: PowerPC G4 (1.2) Processor Speed: 1.5 GHz Number Of CPUs: 1 L2 Cache (per CPU): 512 KB Memory: 2 GB Bus Speed: 167 MHz Boot ROM Version: 4.9.1f3 I was on a t [More]
I have typed a website to send to someone in an email. How do I get it to highlight so that they can click on it and go to the website?How would this question relate to an AirPort Express, AirPort Extreme or Time Capsule....the products shown below t [More]
Hi, I am looking for a bapi or method to set the user status of a task. We have created a status profile for user status and need to set the user status of the task in the dpr_attributes badi based on some conditions. I tried bapi BAPI_BUS2175_SET_ST [More]
I had written the below qery : its showing error that:for pooled tble,cluster tble,projection veiws join is not allowd : 'CDPOS'.   SELECT ekkoebeln cdhdrudate cdhdrtcode cdhdrtabname INTO CORRESPONDING FIELDS OF TABLE it_cdhdr   FROM ( ( ekko AS ekk [More]
Hi , When i try to start the DB Control 11g service in Windows XP , it fails displaying : The OracleDBConsoleoracle11g service terminated with service-specific error 2 (0x2).Is there something i can do except for trying to drop the EM repository and [More]
Hello, Can anyone tell me what inbound interface the SAR (schedule agreement release) uses?  I am unable to find the inbound interface in SPROXY. Also, any good links for implementing Schedule Agreements in SUS. Thanks, Mattthere is no seperate inbou [More]
Hi There, I'm currently building a restricted catalogue for one of our connected users to view a defined subset of the items in MDM through our web connection. the restriction is done through creating MDM users and then applying a named search to tha [More]
We're now up to Flash version 8 and we still don't have a multiline checkbox / radio button component. Has anyone either: a. Figured out how to add a multiline text label to the existing Flash components; or b. Found a third party component that has [More]
Hello, I run Windows 7 on my iMAC via Parallells without any problems normally. It works e.g. fine to run the Windows Office programs. But I run into problems when I try to run Windows Movie Maker. I get the instruction to run dxdiag.exe to verify my [More]