alnoir
Last Activity: Jan 2 '14, 03:43 AM
Joined: Apr 11 '07
Location:
-
Thank you for your response. I'm not actually trying to directly compare the values from the two databases. This sql query is more of a test. After which, I will try and do some automation. I'm simply viewing the first database and picking one record out (visually, not programmaticall y). Then, since I know that the row I'm looking at is also a record in the second database, the condition is hard coded with those values, so that I can pull a... -
updating one table using a query of another table
I'm trying to update some records using the UPDATE and SELECT query.
I have two databases. The first database (db1) is a subset of the second database (db2). However, the first database is missing information in some of the columns that is found in the second database. So I want to query the second database for that information and update the records in the first database.
DB1:
_______________ _________... -
Alright then. That's one convenience they're going to have to do without. Thanks.Leave a comment:
-
Auto-Fill Forms By Clicking On Link To Them?
I have a web page that has links to another web page containing a form. Is there any way to pass information to the form fields by clicking on the original link?
For example:
In the original web page, there is a link:
<a href="someurl.h tml">to_another _page_link</a>
Upon arriving at that page is it possible to have the fields (originally blank) already filled in with... -
I got it working! Thank you everyone for all of your help.Leave a comment:
-
I'm using the get() method on the LWP::UserAgent object n the script code. I assume it's the same as using the get() method of an LWP::Simple object. I'm using LWP::UserAgent, because it lets me examine the content that is returned. I've been looking through html parsers, but I haven't found one yet that will take the content returned and put it into an array line by line (with each line of the content being an element in the array). Does anyone...Leave a comment:
-
text store line by line in an array
I'm writing a script that take web pages and stores the content into an array. Before, I was looping through a text file and stored each line into an array. With a file I could read it by line and store that into the array. Now I want to do the same thing, except instead of a text file I want to use text that is stored as an element in an array.
I've got an array with a block of text as each element. I want to take each line... -
With help from a friend, I finally got the script to work. Instead of using the module that I was, I tried using LWP and it worked great. Thank you to all the people who took time to help me with the problems I was encountering. I appreciate the help.Leave a comment:
-
I think I misdiagnosed the problem. I believe now that what I'm getting back from these web pages is raw php content, because the forums (english or foreign) I tried were all written in php.
This is what I get back:
By alnoir
It doesn't seem to be formatted or even recognizable code, however, that's what it is. Does this familiar to anyone? Can perl interpret this so that information can be...Leave a comment:
-
Thanks for your input!
I'm developing this script for web sites from many different countries. The first that I it tried on was another russian pages. I simply provided russia.ru as an example. I want to be able to search the content retrieved for different strings, but I don't know how I can do that if the content isn't normal html.Leave a comment:
-
Translating Foreign HTML Code
I'm working on this script that grabs a web page from a foreign site, searches it for specific information, and grabs web pages from links on the original page. Once I had it working, I tried it out on the foreign site. However, the information I got back was nonsensical. I'm guessing the code I get back from the web page is written in that foreign language, but when I [view]->[page source] of the same page, it looks like normal html code.... -
WWW::Mechanize works great! So simple too! Thanks again.Leave a comment:
-
It searches the profile pages for users on a forum. It then collects their name, date they joined, and who they are talking to. It does this by following the 'threads started by user' link and then looks at all the names that have posted in that thread. Getting the information isn't a problem, the part that I'm going to have trouble with is retrieving those web pages and following the links on the profile pages.
I'll check CPAN....Leave a comment:
-
Web Perl Module Recommendation
I'm developing a perl script that searches forums for user information. For this project I need a perl module that will allow me to retrieve the html if i provide the url. I can then search the html code for the information I need. I saw a few out there, but I wanted to know if anyone had any preference or recommendations . Thanks! -
Ah! You're right. I needed to do this for another part of the program and didn't need it there. So I did away with that and now it works fine. Thanks again.Leave a comment:
-
I think this might explain more about how the code works.
The conditional statement is within a for-loop:
foreach $line (@weblist)
{
:
:
}
As described in the original post, you can see that this is where the $line scalar is coming from.
@weblist is an array of strings from the text file that contains the information from the web-pages. The code building...Leave a comment:
-
OK. That's interesting. It seems when I did that it prints out every line as expected. However, it is only printing the string up until the first space. After that, nothing else from the scalar '$line' is printed.
Why wouldn't it print out the entire content of the string?
Thank you....Leave a comment:
-
Perl Won't Display URL Strings From A Text File
I'm having a small problem with a perl script. It's probably something very small that I'm overlooking, but I haven't been able to find anything that has helped.
I have a plain text file that contains some information from a few web pages. For instance:
Path-Name: http://blahblahblah.bl ahblah.htm
Content-Length: 2732
Last-Mtime: 1145848708
Document-Type: html*
<html>
... -
Thank you. I got it to work now. I'm curious though. How could I make my code more efficient? I'm new to perl so I did what looked straight-forward. Thanks.Leave a comment:
-
String Matching Using Scalar Variables. What am I doing wrong?
I've looked around online and have even had a friend help me, however, for some reason I can't compare two strings.
I'm doing this at the end of the code (within the two foreach loops), above where the 'print "found"' code is located. It works when I use a string rather than the scalar variable '$word'. However, this just isn't feasible in the program that is being developed.
If anyone sees anything that...
No activity results to display
Leave a comment: