[mapguide-users] Mapguide and ODBC

[Hans Milling]

If your string column is e.g. "typeofhouse" and it is either:
villa
cityhouse
appartment
school
government

create a new int column named typeid
and set an id to each type.
update houses set typeid=1 where typeofhouse='villa'

You then have the typeid column updated as this:
villa=1
cityhouse = 2
appartment = 3
school = 4
government = 5

Add the same typeid column in the other table and update this the same way.

Tjen you can join using the int column instead of the text column.

Best regards
  Hans Milling...




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365p5202427.html
Sent from the MapGuide Users mailing list archive at Nabble.com.