RE: perl / MySql application overview question

2003-08-14 Thread Hughes, Andrew
, Andrew -Original Message- From: Wiggins d'Anconia [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 7:46 PM To: Hughes, Andrew Cc: '[EMAIL PROTECTED]' Subject: Re: perl / MySql application overview question Hughes, Andrew wrote: I have a multi-table MySQL database that holds different

perl / MySql application overview question

2003-08-14 Thread Hughes, Andrew
I have a multi-table MySQL database that holds different pieces of information that will all be displayed on a web page template. The general principle is that non web people will be able to populate web pages through an admin panel. The data in all of the MqSQL tables will be entered by the

RE: Problems getting a simple form to work.

2003-04-04 Thread Hughes, Andrew
I think you meant, Thanks, Rob. Andrew -Original Message- From: Mike Butler [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 4:45 PM To: Rob Benton Cc: Hughes, Andrew; [EMAIL PROTECTED] Subject: RE: Problems getting a simple form to work. Thanks, Andrew. That did it. It's working

RE: form user interface issue

2003-04-02 Thread Hughes, Andrew
appreciate your input. Thanks, Andrew -Original Message- From: Octavian Rasnita [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:01 AM To: Hughes, Andrew; [EMAIL PROTECTED] Subject: Re: form user interface issue That form probably has a submit button that has a parameter name

form user interface issue

2003-04-01 Thread Hughes, Andrew
I have a form that I am using to add data to a mysql database table. I am using a .pl scrtipt to generate the html. I am using cgi.pm and param() to insert the form data. And, I am using to the printHTML; function to display my forms within the .pl script. The problem is that when the user

RE: CPAN/Matt's???

2003-03-31 Thread Hughes, Andrew
I just got it as well. If you click on the MSA logo, it takes you to this page http://www.cpan.org/index2.html What's going on? Andrew -Original Message- From: Scot Robnett [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 7:44 PM To: [EMAIL PROTECTED] Subject: CPAN/Matt's??? Is

RE: downloading data as text file

2003-03-26 Thread Hughes, Andrew
I wrote this script to back up a table in my mySQL database. It also names the file with the exact time from the server that the backup occurred. It might not be the best approach, but it worked for me as the only user. Just adjust the column names to fit your needs. When I posted a similar

RE: Problem with regular expressions!!!

2003-03-18 Thread Hughes, Andrew
This is a newbie observation, but aren't you not supposed to name one of your own variables with a number as the first value after a $, @, or % as in the case of $2? Could this be part of the problem? Andrew -Original Message- From: Marcelo Taube [mailto:[EMAIL PROTECTED] Sent: Tuesday,

delete pattern from text file

2003-03-17 Thread Hughes, Andrew
I am trying to use the following piece of code for subscribers to unsubscribe from my mailing list. The problem is that when the user clicks submit the file gets read into memory. If I open the file as open (DELETEFILE, . etc., the list gets overwritten entirely with nothing. It appears that

RE: question about uninitialized variable

2003-03-07 Thread Hughes, Andrew
As a relative newbie myself, it appears that you have in essence applied a variable to a variable. I typically use the format my $name=param(name); when I have a form that has a field called name. This form field value (andrew for example) would be stored in param(name) which is then stored in

cgi.pm printing 1, not print statement

2003-03-04 Thread Hughes, Andrew
I have a basic script using cgi.pm that is supposed to take one form filed and pass it to a subroutine where I will validate the input. However, when it gets passed, all that prints to the browser is a 1. Can anyone offer any suggestions before I pull the rest of my hair out? Here is the

RE: cgi.pm generate html vs. print EndOfHTML;

2003-01-17 Thread Hughes, Andrew
, Andrew Cc: '[EMAIL PROTECTED]' Subject: RE: cgi.pm generate html vs. print EndOfHTML; On Thu, 16 Jan 2003 at 16:32, Hughes, Andrew opined: HA:I am pointing to the results.tmpl file which is in the same folder as the HA:the .pl script. I found another test script on the web on another website

RE: cgi.pm generate html vs. print EndOfHTML;

2003-01-17 Thread Hughes, Andrew
SECRET_MESSAGE. Thanks, Andrew -Original Message- From: Derrick Spell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 1:53 PM To: Hughes, Andrew Cc: [EMAIL PROTECTED] Subject: Re: cgi.pm generate html vs. print EndOfHTML; I'm new to the HTML::Template module as well, but from what I can

RE: cgi.pm generate html vs. print EndOfHTML;

2003-01-16 Thread Hughes, Andrew
- From: fliptop [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 7:07 AM To: Hughes, Andrew Cc: '[EMAIL PROTECTED]' Subject: Re: cgi.pm generate html vs. print EndOfHTML; On Wed, 15 Jan 2003 at 21:11, Hughes, Andrew opined: HA:does anyone have any strong feelings (know of tutorials

RE: cgi.pm generate html vs. print EndOfHTML;

2003-01-16 Thread Hughes, Andrew
with the information in the script. Could it be a permission issues on the .tmpl file or the .pl file? -Original Message- From: fliptop [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 12:59 PM To: Hughes, Andrew Cc: '[EMAIL PROTECTED]' Subject: RE: cgi.pm generate html vs. print EndOfHTML

cgi.pm generate html vs. print EndOfHTML;

2003-01-15 Thread Hughes, Andrew
I have to say that as a relative beginner, I have really noticed that using cgi.pm to generate forms and entire web pages is a more than a little time consuming. In the interest of time, I have been using print EndOfHTML; to print the html code (esp. forms) in my programs. There are limitations

Apache::Session

2003-01-13 Thread Hughes, Andrew
Hello all, I am trying to use the Apache::Session module to create and store session information. This is my first attempt at using a session to store user info, so please stick with me. The book that I have been using for direction is Paul Dubois' MySQL and Perl for the Web. In it (pg. 329),

how to print mysql table to text file backup with perl

2003-01-06 Thread Hughes, Andrew
I have a mysql table with about 3000 rows of data on which that I need to perform a daily backup. Because I am on a shared hosting account I do not have administrative rights to the database. To back it up currently I have a script that prints each line of data to the browser delimited with

RE: how to print mysql table to text file backup with perl

2003-01-06 Thread Hughes, Andrew
-Original Message- From: LRMK [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 2:16 PM To: Hughes, Andrew; [EMAIL PROTECTED] Subject: Re: how to print mysql table to text file backup with perl where do you want to save your file on your PC or on the server Sign L Rakhitha Malinda

RE: how to print mysql table to text file backup with perl

2003-01-06 Thread Hughes, Andrew
, Andrew Cc: [EMAIL PROTECTED] Sent: 1/6/2003 6:21 PM Subject: RE: how to print mysql table to text file backup with perl On Mon, 6 Jan 2003 at 15:11, Hughes, Andrew opined: HA:my $filename = out.txt; HA:open(OUTFILE,$filename); HA: $stmt = qq { select * from 2002brochurecontest }; HA: $sth = $dbh

replacing numbers around a decimal

2002-10-18 Thread Hughes, Andrew
I am creating a little calculator that is going to need to take a user entered number that will always have 2 decimal places (using sprintf). It could be 89562321.29 or it could be 101.00) and take the last 4 digits (with the period included, so five places) and do two things: 1)Store the

RE: replacing numbers around a decimal

2002-10-18 Thread Hughes, Andrew
Thanks Felix. I actually used $start_discounted_gift_cert = ($total_start) * ($start_discounted_gift_cert_of_total); $start_discounted_gift_cert = sprintf(%8.2f,$start_discounted_gift_cert); $giftcert_remainder_first = substr($start_discounted_gift_cert, -5); $giftcert_remainder_first =

FW: replacing numbers around a decimal

2002-10-16 Thread Hughes, Andrew
Never mind. I figured it out using substr(). Thanks, Andrew -Original Message- From: Hughes, Andrew Sent: Wednesday, October 16, 2002 4:04 PM To: [EMAIL PROTECTED] Subject: replacing numbers around a decimal I am creating a little calculator that is going to need to take a user

RE: Running CGIs offline

2002-07-22 Thread Hughes, Andrew
I am running windows 2000 professional on my laptop and I am using Indigoperl (http://www.indigostar.com/indigoperl.htm). It was extremely easy to download, install and use. Andrew -Original Message- From: Scot Robnett [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:19 PM To:

printf not printing correctly

2002-07-22 Thread Hughes, Andrew
I am having a problem making printf work correctly. The following line of code: printf(\$%4.2\n, $subtotal); prints outputs: $%4.2 to my browser. Subtotal is defined and if it equals 21 and I type: print qq($subtotal); it outputs 21. Does anyone have any suggestions? Thanks, Andrew --

RE: printf not printing correctly

2002-07-22 Thread Hughes, Andrew
Thanks! It works now. -Original Message- From: Bob Showalter [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 2:57 PM To: 'Hughes, Andrew'; '[EMAIL PROTECTED]' Subject: RE: printf not printing correctly -Original Message- From: Hughes, Andrew [mailto:[EMAIL PROTECTED

multi-page form and cgi.pm

2002-07-17 Thread Hughes, Andrew
I have been given the task of creating a multi-page form that will consist of 4 parts. The final page will the list out everything that the users have entered and ask if they would like to go back to any of the 4 sections to update the information. Once the users are satisfied with the final

more redirect script problems

2002-06-18 Thread Hughes, Andrew
I am still trying to create this redirect script that is called when the referring page refreshes after 0 seconds (with a meta tag) to the redirect.pl. I am having a couple of problems. The first is that when it refreshes the scripted does not recognize the page as the referring page. Each time

redirect script problems

2002-06-16 Thread Hughes, Andrew
I am trying to write a script that will send a user to a certain webpage based on the refering url. I am embedding it in a .shtml page as an include. There are 3 urls that I will redirect to based on the refering url. The way it is now, if I type in the url

real beginner help needed

2002-05-23 Thread Hughes, Andrew
I need help. I inherited this script that adds people to a text file for our mailing list. It works in Explorer. However, it does not work in Netscape. Valid email addresses are blocked and the subroutine dienice is called in Netscape. It is pretty short and simple. I do not have time to

RE: Mail script not working for Netscape (was real beginner help needed)

2002-05-23 Thread Hughes, Andrew
a valid email address); } Thanks for your patience with my beginner faux pas. I will be a better member of this list from here on out. Andrew -Original Message- From: John Brooking [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 1:24 PM To: Hughes, Andrew; [EMAIL PROTECTED] Subject

permissions question

2002-02-25 Thread Hughes, Andrew
I have a pipe delimited text file in which I am collecting form submissions. I have the permissions currently set to 666. The problem is that if someone can figure out the path the .txt file, they can view it from their browser. I do not want this to happen. After a period of time, I am

RE: permissions question

2002-02-25 Thread Hughes, Andrew
Message- From: Lisa Nyman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 8:58 AM To: Hughes, Andrew Subject: Re: permissions question Hi, Any sort of data file should be maintained outside of web server space with permissions that allow the web demon to access it in the manner

Limiting form field submission length with perl

2002-02-21 Thread Hughes, Andrew
I have a form that people are going to be filling out online. I am using JavaScript on the front-end to validate the form. However, for security sake and for my own knowledge, I would like to know how to limit the length of form submissions on my server validation sequence. I don't want to cut