File Permissions

2003-09-07 Thread Greenhalgh David
Hi All, I have a script which, amazingly, is doing exactly what it is supposed to do. It is taking user input, processing it and, over several iterations of the script, building a text file on the server. The text file itself is used as the input to a Java applet. All works fine on my local

Re: File Permissions

2003-09-07 Thread Greenhalgh David
You have left out some details, but from what I read above, this is not a perl issue. To clarify, you have a perl script that creates a text file. You then open a browser that downloads a Java applet from a remote server. You want this applet to read the local file. Correct? If so, then

Re: File Permissions

2003-09-07 Thread Greenhalgh David
On Sunday, September 7, 2003, at 08:31 AM, Octavian Rasnita wrote: Read: perldoc -f chmod It isn't working. $cnt=chmod 0644 'textfile.txt'; after running, textfile.txt is still -rw-rw-rw- Is this command possible as the WWW user when running the CGI? Dave -- To unsubscribe, e-mail: [EMAIL

Installing/Uninstalling CPAN modules

2003-08-26 Thread Greenhalgh David
This may be the wrong forum to ask this... How do I uninstall a module downloaded from CPAN? Specifically, I cannot get the DBD::MySQL driver to install under OS X. It refuses to find the mysql_config file, and when I run Makefile again with the -L and -I switches it won't work after install.

Re: Installing/Uninstalling CPAN modules

2003-08-26 Thread Greenhalgh David
You may have better luck in the [EMAIL PROTECTED] list since OS X likes to do all kinds of weird things with its Perl, and with regards to DBI/DBD in [EMAIL PROTECTED] Typically removing a Perl module is not as easy as installing them, removing the associated files is only one step... Sorry

Re: Secure Form Submission

2003-08-22 Thread Greenhalgh David
It seems like it should be secure. I am assuming the session cookie would store the server's public key? or some such? My question would be how do you implement an RC4 encryption (or any encryption other than the built-in SSL) on the client side? Possibly a Java applet with the encryption

Secure Form Submission

2003-08-21 Thread Greenhalgh David
Hi All, I need to implement a form that is submitted securely. My client does not have access to SSL on his host. I was thinking in terms of a session cookie with a client side RC4 encrypt and a decrypt in the Perl script. Do peoople here consider that to be a secure scenario, or is there

Re: Urgent Question (Deployed code gone wrong!)

2003-08-14 Thread Greenhalgh David
eBay, Thanks. I learnt something there. Equally, thanks to Bob, nice solution which I also didn't know. Dave -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Urgent Question (Deployed code gone wrong!)

2003-08-14 Thread Greenhalgh David
A quick question about a while loop. I have a simple code that searches database for all entries and puts one of the fields into a select box on the output page. However, due to a mistake in my untaint routine (which I've fixed) if a visitor entered their name in Japanese characters, the entry

Re: Reading and comparing files from a directory

2003-07-09 Thread Greenhalgh David
If I am reading this correctly (which I am probably not!) you need another foreach loop in there somewhere. When you compare $file with $lines, you are trying to compare the contents of @temp. I think you need to wrap your comparison with a foreach loop: foreach $file (sort readdir (DH)) {

Re: Working with DBI

2003-07-08 Thread Greenhalgh David
On Tuesday, July 8, 2003, at 01:19 pm, Bob Showalter wrote: Greenhalgh David wrote: ... In other words, my SELECT block is returning the value of available as it was before the UPDATE, even though I have AutoCommit set to 1, the UPDATE is called before the SELECT and manual investigation

Re: Working with DBI

2003-07-08 Thread Greenhalgh David
#!/usr/local/bin/perl -wT use strict; use CGI ':standard'; use DBI; use CGI::Carp qw(fatalsToBrowser); # Simulate a param call in CGI my $player=HarryPotter; # Connect to the database my $dbh = DBI-connect(DBI:mysql:ladderDB, , xx); # Make an update that is representative of the full

Re: disabling the use of browser history

2003-07-06 Thread Greenhalgh David
head META http-equiv=Pragma content=no-cache /head HTH Dave On Saturday, July 5, 2003, at 10:12 pm, Alexander Blüm wrote: hello!!! I'm writing a database frontend based on perl-CGI. Each query is being cached in a file with the current session-ID. The reason for this doing is that

Working with DBI

2003-07-06 Thread Greenhalgh David
Hi All, I have a script that updates a value in a table using $handle=$dbh-do(UPDATE league SET available=DATE_ADD(NOW() INTERVAL $offset DAY); The script then reads the value of available using a prepare/execute/fetchrow statement. The script then needs to e-mail the new value of the

Re: Working with DBI - extra info

2003-07-06 Thread Greenhalgh David
I should have mentioned that the connect call uses AutoCommit like this: my $dbh=DBI-connect(DBD:mysql:databasename, username, userpassword, {AutoCommit =1}); Hi All, I have a script that updates a value in a table using $handle=$dbh-do(UPDATE league SET available=DATE_ADD(NOW() INTERVAL

Re: Working with DBI

2003-07-06 Thread Greenhalgh David
If you are assigning the value of the field available to a variable then you should kill or delete that variable (CGI::delete) before you are able to assign a new value to it. Craig No, I'm not assigning the value of available to a previously used variable. For safety's sake, I am reading

Why should I create an object?

2003-06-26 Thread Greenhalgh David
Bare in mind that I am still a beginner at coding. Why is it good practice to create an object when using CGI, rather than just diving in? For example: use CGI ':standard'; my $q=new CGI; my $input=$q-param('input'); and use CGI ':standard'; my $input=param('input'); both put the contents of

Tainted Input

2003-06-21 Thread Greenhalgh David
Hi all, Quick question. Is data read in from a MySQL table considered tainted? Also do I need to untaint a variable that is included in the body of an email? The email structure is addresses from the mySQL table (untainted when the data is stored) and data which could, if someone really

Re: Subroutine Syntax

2003-06-15 Thread Greenhalgh David
: : DO STUFF Comments in perl begin with #, not Perl probably thinks you're referring to a file handle in angle brackets. Sorry, this is me using my own shorthand, everything is correctly #'d in the code. : sub error { : : Print top half of a HTML page : : if ($_[0]=1) { '=' is

Re: want to verify the data coming from a form with the data in database

2003-06-10 Thread Greenhalgh David
Am I understanding you correctly? Your form only has two fields, lastname and firstname? In that case SELECT * FROM table_name WHERE lastname = '$a2' AND firstname = '$a1' works on the command line. (Wasn't sure if you could use the AND like that, but it seems you can) so all you need to do

Re: Strategies for Internationalizing - Re: Targeting two frames from one CGI - Spoke too Soon!

2003-06-09 Thread Greenhalgh David
[1] For fun, you may wish to get into the LWP::UserAgent and build a small 'browser' to 'fetch web pages' since that may help understand the 'advantages' and disadvantages of page fetching... I see prospects for sleep disappearing into fluffy pink sunsets...must check the difference

Targeting two frames from one CGI

2003-06-08 Thread Greenhalgh David
Hi all, Searched the archives for an answer to this, but nothing seems to answer the right question. My basic page has three frames. The top frame contains global navigation and never changes. The left frame (side.html, name=leftFrame) contains a console for want of a better word. The main

Re: Targeting two frames from one CGI - Spoke too Soon!

2003-06-08 Thread Greenhalgh David
you will still need to deal with 'targets' so you will need to know when you want target=_top since you are repainting all of the window, and when you want target=MainBody so that something clicked in the vertical navigation will show up in the MainBody Section... Yes, happy with those as

Getting my head round hashes

2003-06-06 Thread Greenhalgh David
Hi all, I have a script which mostly works, but when I get to the part with hashes, it stops. I'm obviously doing something very basically wrong, but I can't see what. (been staring at so long it could be anything.) A segment of the code is below: #!/usr/local/perl -wT use strict; use CGI; #

Re: Getting my head round hashes

2003-06-06 Thread Greenhalgh David
::Dumper; print Dumper $response; --- Greenhalgh David [EMAIL PROTECTED] wrote: Hi all, I have a script which mostly works, but when I get to the part with hashes, it stops. I'm obviously doing something very basically wrong, but I can't see what. (been staring at so long

Re: Getting my head round hashes

2003-06-06 Thread Greenhalgh David
Thanks Scott, So %hashref now has the modified list of priorities with the task_ID as the key. I think I'm beginning to get the hang of this... I do have use DBI in the code (clipped it by accident when I extracted the segment) but you are quite right about me missing the the

Re: Difference of $hash, and %hash. (was Getting my head round hashes)

2003-06-06 Thread Greenhalgh David
On Thursday, June 5, 2003, at 09:46 pm, drieux wrote: On Thursday, Jun 5, 2003, at 13:34 US/Pacific, Kristofer Hoch wrote: [..] This is possibly the best answer. I won't give any other. [..] why thank you. there are basically two reasons that one should be playing with 'just perl stuff' -

Re: Difference of $hash, and %hash. (was Getting my head round hashes)

2003-06-06 Thread Greenhalgh David
On Thursday, June 5, 2003, at 11:20 pm, drieux wrote: On Thursday, Jun 5, 2003, at 14:33 US/Pacific, Greenhalgh David wrote: [..] My thanks to both of you. The explanation was clear even to me, much better than the book i am using to learn perl. [..] which book are you trying to learn from

Printing Foreign Language Characters from a CGI

2003-06-05 Thread Greenhalgh David
Hi all, A more CGI question this time. The website I have found myself responsible for needs to be bi-lingual, English and Japanese. My problem is, how do I persuade the CGI to output in Japanese characters? Can I use: print Content-Type: text/html\n\n; print Character-Set: shift-jis\n\n; to

DBI indexing question

2003-06-04 Thread Greenhalgh David
Hi all, I just came across this list's archives getting the answer to a problem. Now I have my own questions to ask! This is more of a MySQL question than a cgi one, with luck someone will know the answer. I am managing a database from a set of cgi's, each entry in the database has an ID

Re: DBI indexing question

2003-06-04 Thread Greenhalgh David
The second one. (Except if you delete the largest number(s); they will be reused.) Second question. If I use the following: my $query=CURDATE(); my $sth-prepare($query); $sth-execute; I understand that $sth now just contains the reference to the result of the query. Where is the value of the