Hi Mark,
Thanks! With the Visualizer I was able to see that the "Extra Attribute", "entityid", was actually "ENTITYID. Once I changed the case, it worked. Best Regards, Tom Arter ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mark2atsafe Sent: Wednesday, March 21, 2007 9:27 AM To: [email protected] Subject: [fme] Re: SQLxecutor Results Hi Tom, In a situation like this we really need to pin down where the problem is occurring. What I'd suggest is that you add Visualizer transformers after the SQLExecutor and after the location where you expose the list element, and also set Destination Data > Redirect to Visualizer. That way you'll get to see the data in the FME Viewer. Turn all the layers off then turn each layer on one at a time and query a feature. Now you'll be able to see what works and what fails: the SQLExecutor, the exposing of the list element, or the writing of the attribute. Also check the log file for WARNings and ERRORs. It's likely that if the problem is in writing the attribute that it would throw up a warning message of some kind. Hopefully that'll help show where the problem is, and you'll be able to figure out what's wrong - if not then let us know. Regards, Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] <mailto:support%40safe.com> http://www.safe.com <http://www.safe.com> Solutions for Spatial Data Translation, Distribution and Access --- In [email protected] <mailto:fme%40yahoogroups.com> , "tartery" <[EMAIL PROTECTED]> wrote: > > Greetings, > > I am having trouble in accessing the results of an SQL query. > > A part of an FME Workspace,I am using an SQLExecutor into which I > entered the following SQL to be sent to Oracle: > > select entityid from pierce.landbase where entityid > 260000 > > gave a List Name of: > > rows > > and Add Extra Attributes the value of: > > > entityid > > I've verified that the SQL executed using a ListElementCounter which > returns an _element_count of 4178 rows. > > I then try to access one row by exposing: > > rows{}.entityid and map the result, such as rows{1}.entityid, to > an attribute at my Destination. When I do that I get nothing. > > Can anyone show me the error of my ways? > > Thanks in advance, > > Tom Arter > Tacoma Power >
