Hi Burkhard, Try modifying this slightly. First add the extra () for WKT Polygon and close the Polygon: INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES (GeomFromText('POLYGON((2530665 5614074,2530643 614038,2530687 5614030.782426778,2530665 5614067,2530665 5614074 ))'),1,'orange')
Randy -----Original Message----- From: Burkhard Stollenwerk [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 7:43 AM To: svg-developers@yahoogroups.com Subject: [svg-developers] MySQL AText(ogc) -->GeomFromText Hello I have a problem with Mysql and geomdatasaving. 1.) INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES (GeomFromText('POINT(10 10)'),1,'orange') 2.) INSERT INTO ownerpolygons (ogc_geom,nutzer,style) VALUES (GeomFromText('POLYGON(2530665 5614074,2530643 614038,2530687 5614030.782426778,2530665 5614067)'),1,'orange') SELECT id,AsText(ogc_geom) as ogc FROM ownerpolygons 1:) ogc is given as correct text back 2.) ogc is empty? Is MySQL 4.1.7 not correct or why ist second query empty? Burkhard Stollenwerk ----- Original Message ----- From: Dale Ellis To: svg-developers@yahoogroups.com Sent: Wednesday, March 09, 2005 11:30 AM Subject: [svg-developers] Re: Quiz in SVG To anyone interested, I have improved the SVG quiz, got the question randoming properly so questions don't come out twice, and there's more questions available. SVG QUIZ http://a.1asphost.com/svggames/games/SVGQuiz/index.asp SVG GAMES http://a.1asphost.com/svggames/index.asp --- In svg-developers@yahoogroups.com, "Dale Ellis" <[EMAIL PROTECTED]> wrote: > > Hi all, > > Just created a Quiz in SVG on the Simpsons which is on my SVG Games > site. > > Im quite happy with it, it works well in SVG I think, any > comments/suggestions are very welcome. Links are listed below. > > Made a little interface so I can add Questions easily so the number > of questions increase all the time. > > SVG QUIZ > http://a.1asphost.com/svggames/games/SVGQuiz/index.asp > > SVG GAMES > http://a.1asphost.com/svggames/index.asp > > Thanks > Dale Ellis ----- To unsubscribe send a message to: [EMAIL PROTECTED] -or- visit http://groups.yahoo.com/group/svg-developers and click "edit my membership" ---- Yahoo! Groups Sponsor ADVERTISEMENT ---------------------------------------------------------------------------- -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/svg-developers/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ----- To unsubscribe send a message to: [EMAIL PROTECTED] -or- visit http://groups.yahoo.com/group/svg-developers and click "edit my membership" ---- Yahoo! Groups Links ----- To unsubscribe send a message to: [EMAIL PROTECTED] -or- visit http://groups.yahoo.com/group/svg-developers and click "edit my membership" ---- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/svg-developers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/