Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 ArticleMentor - adding new fields/tables
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Martha2Mary
Junior Member

New Zealand
250 Posts

Posted - 22 July 2001 :  19:27:51  Show Profile  Visit Martha2Mary's Homepage  Send Martha2Mary an AOL message  Send Martha2Mary an ICQ Message  Send Martha2Mary a Yahoo! Message
I am hoping that someone here is familiar with ArticleMentor (available from aspcode.net) to an extent that they might be able to assist me in customising it for my website.

Using ArticleMentor as-is, there are only two fields that a User has to fill out to submit an Article, those being a Heading and the actual article Content. I am wanting to add two more fields that a User who is submitting an article is required to fill out, those being a Name/Nickname field, and an Email Address field. This info would then need to be written to the database, as well as displayed when someone is viewing the Article. It would be preferable if the Name/Nickname is displayed as a clickable 'mailto' link.

Soooo, can anyone here help me out? I have no idea how to write my own asp code, so am hoping that there is someone who has modified ArticleMentor in the same way that I want it to be, who could send me their modified files.

Thanks in advance!

*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind *

sogoth
New Member

United Kingdom
73 Posts

Posted - 23 July 2001 :  05:01:54  Show Profile  Visit sogoth's Homepage
I havn't modified the code, but it shouldn't be too hard.

First off you'd need to add the extra fields to the database using whatever interface you use.

Next up would be to add boxes for these fields onto the submit form (naming them to match the fields in the DB) and modify the SQL statement "Insert into..." to include these new fields as well

As for creating the email link you'd need a field for the name and one for the email address in the DB. When you come to create the link write it as you would a normal link in HTML, but insert asp statements to drag in the email address for the mailto: part and the name for the description of the link

something like:-

<a href="mailto<%email%>"><%userID%></a>

Paul
still learning myself, but I hope that helps somewhat!

Complete Muppet, Borderline Feeble!
Go to Top of Page

Martha2Mary
Junior Member

New Zealand
250 Posts

Posted - 23 July 2001 :  19:28:08  Show Profile  Visit Martha2Mary's Homepage  Send Martha2Mary an AOL message  Send Martha2Mary an ICQ Message  Send Martha2Mary a Yahoo! Message
Thank you very much for your help, Paul ~ I have actually managed to get it working. The asp code that was used in ArticleMentor didn't use any 'insert into' statements, but with your help, and with studying the code for long enough, it worked - much to my surprise!

Once again, thanks!

*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind *
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.01 seconds. Powered By: Snitz Forums 2000 Version 3.4.07