Re^3: MySQL access denied

Thanks for tip. All working now. Had a time with the relative path

sub UpdateUserTable
{
my $dbh = shift;
my ($sth, $stmt);
my $infile = "../securefiles/accesscontrol.txt";
    warn("Entered sub UpdateUserTable");
    $stmt =    "DELETE
                FROM users";

    $sth = $dbh->prepare ($stmt);
    $sth->execute () or die "Unable to execute query: " . $sth->errstr
+;


    #$stmt =    "LOAD DATA LOCAL INFILE '/home/jalamior/public_html/ht
+tpsdocs/securefiles/accesscontrol.txt'
    $stmt =    "LOAD DATA LOCAL INFILE '$infile' INTO TABLE users
                FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";





    $sth = $dbh->prepare ($stmt);
    $sth->execute () or die "Unable to execute query: " . $sth->errstr
+;
}
[download]

Comment on Re^3: MySQL access denied Download Code

Replies are listed 'Best First'.
Re^4: MySQL access denied by tultalk (Monk) on Mar 13, 2017 at 18:19 UTC
Hi: The code above posts a message "complete" on a new blank page. UGLY. I would like to pop up a windows message instead. Have any of you ever used this: Net::NetSend? Reading the description sounds like it gets the netbios and IP it needs itself. Don't want the client (machine) to have to do anything. Search on monks found nothing. Any insight appreciated before I attack this	[reply]
Re^5: MySQL access denied by huck (Prior) on Mar 13, 2017 at 21:09 UTC
What should be on the page instead? You do realize that in the cgi processing model you send a request to a server and the server sends back some html. http://search.cpan.org/~greb/Net-NetSend-0.12/NetSend.pm<br "This module implements a client interface to the Windows Messenger Service" , what is to happen if the person sending the cgi request is not on windows. What should be on the page of html sent back after the server finishes the cgi reqeust? And that service can be turned off. see http://www.techrepublic.com/article/disable-microsoft-messenger-service-in-windows-xp/]. for more about the service see https://en.wikipedia.org/wiki/Windows_Messenger_service.	[reply]
Re^5: MySQL access denied by tultalk (Monk) on Mar 13, 2017 at 20:27 UTC
Sorry Never mind. The required messaging systems are not provided in "modern" windows OS. Oops. looking into Tk if I can figure it out.	[reply]
Re^6: MySQL access denied by tultalk (Monk) on Mar 13, 2017 at 20:39 UTC
Tk not for me. I will brew up my own. Best regards	[reply]