<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div><script type="text/javascript" defer="defer">var YAHOO = {'Shortcuts' : {}};
if (typeof YAHOO == "undefined") {
var YAHOO = {};
}
YAHOO.Shortcuts = YAHOO.Shortcuts || {};
YAHOO.Shortcuts.hasSensitiveText = false;
YAHOO.Shortcuts.sensitivityType = [];
YAHOO.Shortcuts.doUlt = false;
YAHOO.Shortcuts.location = "us";
YAHOO.Shortcuts.document_id = 0;
YAHOO.Shortcuts.document_type = "";
YAHOO.Shortcuts.document_title = "[postgis-users] newbie: Error in first atttempt to use postgis with mapserver?";
YAHOO.Shortcuts.document_publish_date = "";
YAHOO.Shortcuts.document_author = "srph124@yahoo.com";
YAHOO.Shortcuts.document_url = "";
YAHOO.Shortcuts.document_tags = "";
YAHOO.Shortcuts.document_language = "english";
YAHOO.Shortcuts.annotationSet = {
"lw_1232013652_0": {
"text": "query string",
"extended": 0,
"startchar": 645,
"endchar": 656,
"start": 645,
"end": 656,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 0.393738,
"relScore": 6.17683,
"type": ["shortcuts:/concept"],
"category": ["CONCEPT"],
"wikiId": "Query_string",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "ERROR: column \u0022oid\u0022 does not exist LINE 1: ...inary(force_collection(force_2d(the_geom)),\u0027NDR\u0027),OID::text ... ^ With query string: DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),\u0027NDR\u0027),OID::text from bc_municipality WHERE",
"metaData": {
"visible": "true"
}
},
"lw_1232013652_1": {
"text": "497368421",
"extended": 0,
"startchar": 854,
"endchar": 862,
"start": 854,
"end": 862,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/ups_tracking"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "",
"metaData": {
"verified": "false",
"visible": "true"
}
}
};
YAHOO.Shortcuts.headerID = "9170a5ad7850b6327592e7202c387997";
</script>
<style type="text/css"><!--DIV {margin:0px;}--></style><link rel="stylesheet" href="http://d.yimg.com/jq/css/contextual_shortcuts.css" type="text/css" media="all"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div>Hi everyone.<br>i've used workshop material of FOSS4G2007 (PostGIS workshop)to learn postgis along with its data. but there is a problem<br>i got this error in first attempt to retrieve data from postgis:<br><br>msDrawMap():
Image handling error. Failed to draw layer named 'bc_municipality'.
prepare_database(): Query error. Error declaring cursor: ERROR: column
"oid" does not exist LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^
With <span style="border-bottom: 1px dashed rgb(0, 102, 204); cursor: pointer;" class="yshortcuts" id="lw_1232013652_0">query string</span>:
DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
bc_municipality WHERE the_geom && setSRID('BOX3D(458426.1
260651.<span class="yshortcuts" id="lw_1232013652_1">497368421</span>,1943216.4
1373313.90263158)'::BOX3D, find_srid('','bc_municipality ','the_geom')
) msPOSTGISLayerRetrievePGVersion(): Query error. Error executing
POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select
substring(version() from 12 for (position('on' in version()) - 13)) <br><br>i don't know what causes the problem although it sounds easy.<br>THX<br></div></div><br>
<span id="lw_beacon_1232013798031"></span><!-- kill --><div><br><br>-----Inline Attachment Follows-----<br><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div><div style="top: -400px; left: -400px; position: absolute;" class="module overlay yui-module yui-overlay" id="lwPreview"><div class="hd"></div><div class="bd"></div><div class="ft"></div></div></div></div><br>
</body></html>