Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

A way of printing field value when posted to atext

Jun 22, 2000, 6:06 AM
hass
Novice (17 posts)
Jun 22, 2000, 6:06 AM
Post #1 of 4
Views: 1627
Shortcut
Quote Reply
A way of printing field value when posted to atext
Is there a way to have the db.cgi file print a specified field value to a text file and overwrite and update whenever someone enters data to the DB?

thanks in advance!

Jun 22, 2000, 2:23 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 22, 2000, 2:23 PM
Post #2 of 4
Views: 1565
Shortcut
Quote Reply
Re: A way of printing field value when posted to atext In reply to
Probably, but I would need more detail about what you want to do.

JPD
http://www.jpdeni.com/dbman/
Jun 22, 2000, 11:36 PM
hass
Novice (17 posts)
Jun 22, 2000, 11:36 PM
Post #3 of 4
Views: 1566
Shortcut
Quote Reply
Re: A way of printing field value when posted to atext In reply to
okay
say we have database named sample
in sample there is 4 fields, field1,field2,field3,field4

now, somewhere else, there is a field.txt file
and whenever someone adds a record to the db lets say field2 is printed to field.txt ( over whatever exists there)

get it?


Jun 22, 2000, 11:43 PM
JPDeni
Veteran / Moderator (8669 posts)
Jun 22, 2000, 11:43 PM
Post #4 of 4
Views: 1563
Shortcut
Quote Reply
Re: A way of printing field value when posted to atext In reply to
Okay.

In your .cfg file define a variable

$field_text = $db_script_path . "/field.txt";

Be sure that you upload a file by that name to your DBMan directory and set the permission to 666.

In db.cgi, sub add_record, after

close DB; # automatically removes file lock

add

Code:

open (TEXT, ">$field_text") or &cgierr("error in add_record. unable to open text file: $field_text.\nReason: $!");
if ($db_use_flock) {
flock(TEXT, 2) or &cgierr("unable to get exclusive lock on $field_text.\nReason: $!");
}
print TEXT $in{'field2'};
close TEXT;

JPD
http://www.jpdeni.com/dbman/