Hi!

On the modify/delete/validate success screens with short&long, I notice that the confirmation message passed from db.pl is
This is a bit meaningless to my visitors! Is there a way (read as 'how can ...') I can change this to the titles rather than the DB Keys?

It seems to be calling it from db.pl so I'm not really very confident about fiddling!!




------------------
Ben

-------------------------
http:/www.t-e.co.uk

The modify success screen should show the record after it was modified. And your users won't be using the validate function, so they won't see that screen.

In order to change what is displayed on the delete success screen, you'll have to pull the data from the record before it is deleted.

In db.cgi, there are the following lines:


You'll need to change these lines to


You'll also need to change


to


I'm pretty sure this will work.


------------------
JPD

 
As ever, I type in awe!

Works a treat!

------------------
Ben

-------------------------
http:/www.t-e.co.uk

Whew! I'm never as sure of myself as I seem to be when I'm typing here. I sorta hold my breath until I know how it turned out. Glad this one worked.


------------------
JPD

I made the changes to show the Title (field 11) but I still got a 500 error, but I also have the multiple-upload-mod.

I looked it over and over again but cannot find the error (a typo? 1 } to much?)

This piece of code I have now;

Anyone did the same with the same error?

It looks as though you may have added the lines in the wrong place with the extra coding for the upload mod. Try using this and see if it helps:

($output .= "$line\n" and next LINE) if ($restricted and ($db_userid ne $data[$auth_user_field]));

if ($delete_list{$data[$db_key_pos]}) {
$delete_list{$data[$db_key_pos]} = 0;
# $succstr .= "$data[11],";
# }
if ($db_upload) {
if (-e "$SAVE_DIRECTORY/$data[$db_key_pos]") {
opendir (GRAPHIC, "$SAVE_DIRECTORY/$data[$db_key_pos]") or &cgierr("unable to open directory in delete records: $SAVE_DIRECTORY/$data[$db_key_pos]. Reason: $!");
@files = readdir(GRAPHIC);
closedir (GRAPHIC);
foreach $file (@files) {
unlink ("$SAVE_DIRECTORY/$data[$db_key_pos]/$file");
}
rmdir "$SAVE_DIRECTORY/$data[$db_key_pos]";
}
}
}
# else { $output .= $line . "\n"; }
$succstr .= "$data[the number of the field you want to return],";
}
else {
$output .= $line . "\n";
}
}

foreach $key (keys %delete_list) {
if ($delete_list{$key}) {
$errstr .= "$key,";
}
}
chop($succstr); # Remove trailing delimeter

If not, it's most likey just a matter of matching up the brackets correctly.

Let us know if it works

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi LoisC,



As usual, you were right....
I had a hard time finding the 1 to much '}', it was the one just beneath:

rmdir "$SAVE_DIRECTORY/$data[$db_key_pos]";


Finally after deleting one of the } there was no 500 error anymore and the scripts shows the deleted titles beautifully. I added an extra linebreak in the successtring so the titles would show in a list;
$succstr .= "$data[11]<br>";

Thank you for your everlasting suipport.
You are a wonderful person...