[mapguide-users] How to get selected feature information in popup window

Tue Sep 11 12:35:15 PDT 2012

error 500 on SQL Server means the actual DB connection wasn't made (or
lost), or timed out

so you might be looking more at your connection settings and ensure those
channels are valid etc.
or perform simple tests on a super small table..

like...

select * from Table1 where ID<5

just to ensure you get your connection up and working right

On Tue, Sep 11, 2012 at 3:24 PM, elliott17 <elliottd at ae.ca> wrote:

> I am running php 5.4.6 on Server 2008 with MGOS 2.2 and SQL server 2008 r2.
>
> I have set up a php page to call an image for the Fusion map tip and keep
> getting an error (500 internal server error).  I created an identical php
> file on the server and it works.  My post message is "Test Test!!
> ../images/Walls/Mariner Way/sw10/P1020533.JPG Image ID: 25 "
>
> Is there a setting that I am missing to have this work?
>
> My php file is:
>
> <html xmlns="http://www.w3.org/1999/xhtml">
>
> <head>
> <HEAD>
>
> <title>Gregs Test</title>
>
> </head>
> <body>
> Test Test!!
>
> <?php
>
> $oid = $_GET["ImageID"];
>
> $serverName = "XXXXXX\sqlexpress";
>
> $connectionInfo = array( "Database"=>"database name", "UID"=>"Username to
> SQL", "PWD"=>"pwd to SQL");
>
> $conn = sqlsrv_connect($serverName, $connectionInfo);
>
> if(!$conn)
> {
>         echo "<br/>Couldn't connect to SQL Server on $serverName";
> }
>
> $result = sqlsrv_query( $conn, 'select URL from wall_lines where OID = (?)
> ', array( $oid ));
>
> while($row = sqlsrv_fetch_array($result))
> {
>         echo($row['URL']);
> }
>
> echo "Image ID: " . $oid;
>
> ?>
>
> </body>
> </html>
>
> Thanks.
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/How-to-get-selected-feature-information-in-popup-window-tp4999139p5001157.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20120911/3ab2534b/attachment.html>