ed08724 Posted December 21, 2012 Report Posted December 21, 2012 Hi guys, I need to read the contents of a mysql database field. It is remote and I have total access to it so can write a php program to simply output the text to a bare html page. I can enclose it with whatever I need to make it easier for ME. I want to take that string field and input it into a ME variable so I can texttype it. The webpage will not be previously loaded. I need to load IE first then read the only data on the page into a ME text variable. Then close IE. Thanks, Ed Quote
ed08724 Posted December 22, 2012 Author Report Posted December 22, 2012 How do I load the contents of a webpage into a variable? The webpage would have a maximum size of 255 characters. Quote
acantor Posted December 23, 2012 Report Posted December 23, 2012 This should work as long as a field is not focused, in which case it is the field that is selected and copied rather than the page. Text Type (Simulate Keystrokes): <CONTROL>a // Select all Text Type (Simulate Keystrokes): <CONTROL>c // Copy to clipboard Variable Set String %Clip% from the clipboard contents Quote
Cory Posted December 24, 2012 Report Posted December 24, 2012 You might be thinking there's a way to invisibly grab the contents but no such way. You need to use the WebPage command and do as Alan describes above. I often had to do this a great deal and opted instead to use a VBScript in the External Command command to grab a webpage's HTML contents and parse what I needed. I think I posted an example someplace here on the forum of one that downloads the entire contents of the page to a file which you can then load into a variable but in this case I'd rather return the desired text to the console which you could then read directly into a variable. If you are interested please let me know and I'll make you one. In fact I've been meaning to make a general purpose script to do a simple HTTP GET of the contents of a webpage from a given URL. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.