2011/3/18 Roger Bedell <[email protected]> > I found this: > > SELECT (select count(*) from QQHeader where PKey<=a.PKey) AS RowNo, a.* > FROM QQHeader AS a > >
The problem with this (and with the ROW_NUMBER option as well) is that the order of the rows may be undeterministic unless an orderby clause is used. I would rather suggest to use a function (either an UDF or the checksum) to create and integer is from guid. BTW: In the development version having an oid should not necessarily be a requirment in order to have the query option to work. So you may probably omit the using unique section in the layer definition (not tested by me). Best regards, Tamas
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
