Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wsexton
  • Order by date
  1. wsexton

    Using Programs on External Hard Drive

    If I take an internal hard drive from my old pc and use it as an external drive on my new pc, will I still be able to use all the programs on the external drive. Word, Excel, etc. My old pc died and I'd like to use the drive from it on a new pc. Do I have to reinstall programs, etc on the new...
  2. wsexton

    Convert HTML to CSS

    I have a web page I created using Dreamweaver. It has a table, with table cells, etc. Is there some way I can convert this to CSS without having to rewrite the whole thing? In other words, strip the tags out and put them into an external style sheet without having to go through an entire...
  3. wsexton

    Perl script not getting $ENV{'CONTENT_LENGTH'}

    I have an html form that uses post <form name="formname" method="post" action="cgi-bin/feedback.pl"> Here's the perl script: #!/usr/bin/perl use warnings; use CGI; use CGI::Carp qw(fatalsToBrowser); use Mail::SendEasy; print "Content-type:text/html\n\n"; my $FormData = ""; # Read the...
  4. wsexton

    Form Post Content Length

    Here's my HTML file: <html> <head>Test</head> <body> <form name="feedback" method="post" action="cgi-bin/feedback.pl"> <p><font size="5"> <font size="4">Your Name: <input name="name" type="text" id="name">* </font></font></p> <p> <font size="4"> <input type="submit" name="Submit"...
  5. wsexton

    Form Post Content Length

    When I submit an HTML form I'm not getting a content length environment variable. Here's my HTML: <form name="feedback" method="post" action="cgi-bin/feedback.pl"> The feedback.pl is a perl script that looks at the environment variables. I'm not getting the content length. Any ideas? Thanks.
  6. wsexton

    HTML Form Save and Process

    I have a perl script that process an form created in html. I'd like to email the actual form, with the fields filled in. I've figured out how to email the html form, but the fields aren't filled in. Is there a way to do this? I've tried saving the html file to another html file, but that still...
  7. wsexton

    Sendmail Attachment

    I've tried using ppm to install Mail-SendEasy but I get the message "no suitable installation target found for package Mail-SendEasy." I'm using ActivePerl 5.8.7.813.
  8. wsexton

    Sendmail Attachment

    I'd like to add an attachment to an email I'm sending from a perl script using sendmail. Here's my code: #!/usr/bin/perl use warnings; use CGI; use Mail::Sendmail; $file = "testdoc.txt"; unshift @{$Mail::Sendmail::mailcfg{'smtp'}} , 'AB-MAIL4'; %mail = ( To => 'wsexton@anywhere.net'...
  9. wsexton

    Regular Expression with negative number

    I figured it out. Just a dumb mistake. Thanks anyways.
  10. wsexton

    Regular Expression with negative number

    I'm trying to remove a comma from a negative number: First I use substr to get the number: $number = substr($line, 1, 10); Now $number has -1,125.50 I do this: $number =~ s/\,//g; This works for a positive number, but not negative. Any ideas?
  11. wsexton

    Sending Email from CGI Perl Script to MS Outlook

    I'm trying to send email from a perl script to MS Outlook. Here's my code: use lib qw(lib); use Mail::Outlook; my $mail = new Mail::Outlook(); die "Cannot create mail object\n" unless $mail; my $message = $mail->create(); die "Cannot create message object\n" unless $message...
  12. wsexton

    Getting autonumber from MS Access database

    I'm trying to get the autonumber of a record I just inserted into an Access database. Here's the code I'm using. I don't seem to be getting anything back and it doesn't seem to return an error, either. my $sth1 = $dbh->prepare("select max(REQUESTNUMBER) from request_data"); $sth1->execute...
  13. wsexton

    Insert into Access Table

    Thanks, that works.
  14. wsexton

    Insert into Access Table

    I'm using perl to insert data from a file into an MS Access database. I'd like to use the autonumber feature in Access. I can change the autonumber field to a number field and insert a number I create. How do I insert a record and allow Access to assign an autonumber? Here's my current code...
  15. wsexton

    CGI Environment Variables

    When I run that I get a file download message box. I select open, a command box flashes, then it doesn't do anything. I'm running this on my PC using XP. I have IIS installed and I believe I've correctly set up CGI. I also have perl installed and I've set up IIS to use perl to execute both .cgi...
  16. wsexton

    CGI Environment Variables

    I'm trying to display environment variables in my browser (IE): Here's the html: <head> <title>variable test</title> </head> <body bgcolor=white> <center> <a href=cgi-bin/env.pl>Environment Variables Example</a> </center> </body> Here's the perl: #!/usr/bin/perl print "Content-type...
  17. wsexton

    Syntax error with insert

    I certainly appreciate your help. I'm still getting an error message: DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver] Syntax e rror in INSERT INTO statement. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1) at datarequest.pl line 60. I don't have much experience with...
  18. wsexton

    Syntax error with insert

    Thanks for spotting the missing variable. I corrected that, and I've tried using \' for the single quotes and I still get a syntax error. I just can't see what's causing the problem.
  19. wsexton

    Syntax error with insert

    I keep getting a syntax error message when I try to execute this sql statement. I know it's a long one. Can anyone spot the problem? $sqlstmt = $dbh->prepare("INSERT INTO request_data (requestnumber, date, requestor, duedate, reoccuring, frequency, purposeandscope, question, utilization...
  20. wsexton

    Using Sql in form field

    I'd like to run a sql statement after a user enters info in a form field. This is what I have so far: Private Sub Reporting_Unit_AfterUpdate() Dim sql As String Dim Provider_Code As String Dim Legal_Entity As String sql = "SELECT dbo_PROVIDER_MASTER.CDS_PROVIDER_CODE as PROVIDER_CODE...

Part and Inventory Search

Back
Top