Hello

I have installed the DBMAN succesfully.

I have installed also the modification from http://www.jpdeni.com/dbman/Mods/

http://www.jpdeni.com/.../email_after_add.txt

to have a message (mail notification) after new record.



Unfortunally, the e-mail-notification which I receiving after every new record it is this...

-----Original message-----

From: master@cool.fm [mailto: master@cool.fm]

ÁðïóôïëÞ: ÔåôÜñôç, 13 Öåâñïõáñßïõ 2002 1:09 ðì

To: master@cool.fm

Subject: New Record



The following new record has been added to the database:.

--

Where are the data entries?????



Could you hel me ?



Thanks

Try changing:

foreach $col ($db_cols) {
print MAIL "$col -- $rec{$col}\n";

to:

foreach $col($db_cols) {
print MAIL "$col -- $rec{$col}\n";

I think the problem with the original may be the space between $col and ($db_cols).

or try:

foreach $column(@db_cols) {
print MAIL "$column: $in{$column}\n";

Check the FAQ noted below under the section "Email" for other variations which include only sending specific fields.

Unoffical DBMan FAQ

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

>>
I think the problem with the original may be the space between $col and ($db_cols).
<<

Perl ignores spaces so it isn't an issue most of the time. The problem is with trying to loop using a scalar. You need to use @db_cols.

Re: [LoisC] send mail to admin after new record - NEW [In reply to] Quote | Reply

---

>>
I think the problem with the original may be the space between $col and ($db_cols).
<<

Perl ignores spaces so it isn't an issue most of the time. The problem is with trying to loop using a scalar. You need to use @db_cols.


Could you write the full code for this?

Try changing:


....to......

Ok. That's it!!!!

It's working!!!



Thanks