lbillett

I've got a problem very similar to that discussed in this older thread. Basically, if left alone for a few minutes, attempting a page load can take quite a few seconds (10-20) or sometimes time out! However, after one page is served, successive page loads are of nice speed. It's an XP WAMP machine using Mediawiki. It's on our local Intranet and it doesn't seem to matter if I use hostnames or the IP address. The loading is quite light, so I have a hard time believing it's traffic related. The machine it's on runs the MySQL server and the webserver ONLY. Oh, and get this, I can see almost the same kind of behavior when PINGING the machine! Take a look. C:\Documents and Settings\lbillett>ping 10.183.12.5 Pinging 10.183.12.5 with 32 bytes of data: Request timed out. Reply from 10.183.12.5: bytes=32 time<1ms TTL=128 Reply from 10.183.12.5: bytes=32 time<1ms TTL=128 Reply from 10.183.12.5: bytes=32 time<1ms TTL=128 Ping statistics for 10.183.12.5: Packets: Sent = 4, Received = 3, Lost = 1 (25% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms On a local network! This makes me think it's not PHP related at all. Any ideas on how to trouble shoot this? Thanks!!

I think establishing a direct connection sounds a little over my head. At this stage my experience has been limited to making sql connections/queries and coming up with cute customized output in our mediawiki installation. It looks like I might be able to connect to this same type of resource using ODBC, which would be preferable but I can't seem to get any meaningful data from it... It seems I could also purchase some kind of connector, but I'm not confident I could make it work either. I found one thread about folks using SOAP to connect to OPC, but I couldn't quite figure out wtf they were talking about. If somebody could embellish it I might have a chance, though I still don't really understand what SOAP accomplishes. Guess I may have to figure that out before too long.

I want to fetch information from an OPC Server and was hoping to use PHP to do it. However, googling hasn't gotten me very far. It doesn't appear to be a very popular thing to do, which I find strange considering the reasonably large presence and multitude of other connectors OPC seems to have. Anybody out there ever try something like this? My problem could be that it's so simple I just don't realize the way through. I'm trying to display values from a Foxboro DCS on our intranet with PHP via OPC. Thanks!

Worked first try. There are literally wave's of ecstasy are rolling over me. Wow, how lame am I? Thank you tons.

Hello Freaks! First time poster, long time reader. I'm making a simple standalone blog extension in mediawiki for work and am getting KILLED trying to use the IN() condition. Fighting with it recently actually made me realize I've never actually gotten one work before. EVER! I usually end up using a loop to build an outrageous looking bunch of OR's into a query string to get around it. This madness has to stop. I've done everything I can think of to tweak the syntax. I still get query errors. Can anyone see what I'm doing wrong? From what I can see, I'm following the usage perfectly! I have a table called simpleblog_perms looking something like this: id (INT) group (TEXT) logid (INT) perm (TEXT) --------- --------------- ------------ ------ 1 Staff 1 R 2 sysop 1 W The following queries all result in an error! SELECT * FROM simpleblog_perms WHERE group IN (Staff,bureaucrat,sysop) SELECT * FROM simpleblog_perms WHERE group IN (Staff, bureaucrat, sysop) SELECT * FROM simpleblog_perms WHERE group IN ('Staff','bureaucrat','sysop') SELECT * FROM simpleblog_perms WHERE group IN ('Staff', 'bureaucrat', 'sysop') SELECT * FROM simpleblog_perms WHERE (group IN ('Staff','bureaucrat','sysop')) They each return something like MySQL returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group IN ('Staff','bureaucrat','sysop')' at line 2 (localhost)". I'm using MySQL 5.1.30 with PHP 5.2.9-2