Hi, me again.
So, this is what I'm up to this time:
- I have a postgis database
- I want to extract different bits of it to a CAD file, using the published
parameter to specify the 'where' clause
The problem I'm having is that the where clause contains spaces. This is not
a problem if you enter the text directly into the Properties/Parameters box,
but if you try to pass it as a published parameter, Workbench immediately
throws a wobbler:
fme.exe export_postgis_DWG.fmw
--SourceDataset_POSTGIS [db]
--DestDataset_ACAD [file]
--postgis_sql_where_clause "field = 'value'"
2007-03-06 13:56:15| 0.7| 0.0|ERROR |Error executing SQL command
('DECLARE [table]_crsr____ CURSOR FOR SELECT [fields] FROM [table] WHERE
field'): 'ERROR: argument of WHERE must be type boolean, not type integer
'.
Clearly it's just trimming off everything after the space.
So, 2 questions:
1. is there an alternative character I can use that will still be
understood? i.e. if I change all my spaces to (for example) carets, will FME
and PostGIS still happily accept this as a query?
2. is there any obvious way round this? The only alternative I can see is to
somehow convert all the bits of the query into AttributeFilters, which would
be very troublesome
Thanks!
Roland.
