chargill -

my apologies - i knew that it wasn't enough for you to really see what's going on, but what i'm working on is private information, and i didn't want to create a dummy db to demonstrate.

what i have come up with as a workaround is to add ", -value=>'', -override=>1" to each field, as follows:

print table(
Tr({-valign=>"TOP"},
    td(["First Name", textfield(-name=>'firstname', -size=>80, -value=
+>'', -override=>1)]),
    td(["Last Name", textfield(-name=>'lastname', -size=>80, -value=>'
+', -override=>1)]),
    td(["Address", textfield(-name=>'address1', -size=>80, -value=>'',
+ -override=>1)]),
[download]

setting each value to '' doesn't do it without including the -override=>1

so, this works, but it seems like there must be an easier, more efficient way!

in answer to your inquiries about the rest of my code:

1. #!/usr/bin/perl, 2. use CGI qw/:standard/;,

the top of my script is:

#!/usr/bin/perl
use strict;
use warnings;
use CGI qw(:standard);
use CGI::Pretty;
use CGI::Carp qw(fatalsToBrowser);
use DBI;

my $q = new CGI;
[download]

i've tried putting -nosticky into the use CGI statement: use CGI qw(:standard, -nosticky); which didn't clear the fields. and i also put '-nosticky' into each of the fields, again, without success (the previous field values remain). i've tried adding the line $q->delete_all(); above the code creating the form when "submit = 'New Entry'", which also doesn't work to clear the field values.

3. the bit of CGI code that displays the button called 'New Entry',

print submit(-name=>'submit',-value=>'New Entry'); the main conditionals that are run look like:

%in = map { $_ => $q->param($_) } $q->param;
    
if ($in{'submit'} ne 'New Entry')
{
.
.
$requestID = $in{'requestID'};
$sql = "SELECT title, firstname, lastname, address1, address2, city, s
+tate, zipcode, zipextra, phonehome, phonework, phonecell, email, user
+name, role, approved FROM members WHERE UID = $requestID";
....code to generate table with the values from the db inserted into t
+he fields...
}
else
{
....code to generate table with empty fields...
}
[download]

4. enough data stuffed into perhaps __DATA__ to recreate the problem.

the source of the DATA is from a sql statement, as shown above....not sure how to show you this, since it's confidential.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.