Hi JPD,
I was looking for your mod 'validate records', but I only found the one, whitch is for the 'user friendly'. I looked it over, but it seems that I came to stand for some surprises, if I modify it for the regular 'html.pl'. Is there somewhere a version of that mod for me availeble, I mean for the regular 'html.pl'???

mart,

If you want I can send my html.pl and db.cgi
files with the Validate mod in them for you to look at. I am not using the friendly html.pl file.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

Thank you very, very much, but I'm almost finished with modifying the new mod. Only 'one' syntax error. When I will not come out, I'll let you know.

Thanks again.
--------
Mart.

Finished and good working

Thanks
-------
Mart.

Great! One suggestion given by another DBMAN user, which I am in the process of doing (waiting for a down time when users won't be accessing the database so much) is to change the field to something obscure and also the values of "yes/no" to numeric values to ensure that people will not find a way to slip through the cracks and add records on their own.

Also, you might want to consider adding check_url sub routine in your script and refer to them in the add, modify, delete sub-routines in your db.cgi. While the Validation mod is very nice, it is not 100% gaurantee that people will either access non-validated records or bypass the Validation process.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited September 23, 1999).]

I'm not sure which version of the validation routine you're referring to, Eliot.

In the most recent version that I have, when a record is added the script automatically sets the value of the Validated field to "No" within the script. Even if the user changes it on the form, it is reset before the record is added.

The same thing is available as an option when a record is modified.

As for searches, unless the user has admin permission, the value of the Validated field is set to "Yes" -- again, within db.cgi so that it doesn't matter what the user enters by URL on on a form.

If your script doesn't have this, I would be glad to give you the code.


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

I am using the original version that you helped me with a month or so ago. I would greatly appreciate the new codes since currently I am using hidden fields for the Validation field in the search form.

Thanks.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

I do have it on my webspace, although I haven't made it "pretty" yet, so I don't have a link to it. You can pick it up at http://www.jpdeni.com/...n/Mods/validate1.txt .

This version can send a "canned" email to those whose records are validated or deleted. Also, the html subroutines are not the user-friendly type.


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

Thanks, Carol! I do have the validation mod working just fine...just want to tighten security a little more. I have a sub url_check routine (similar to the one found in the FormMail by Matt) in the add, modify, and delete sub-routines. But it would be nice to have the Validate taken out of the query string and also delete the hidden field.

Thanks.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us