I am converting the snitz forum into a classmates.com type of site for http://www.tafthighalumni.com (a site I built in TCL)
So I had to add a graduation lastname field for people who's lastname has changed. I went through register.asp and inc_profile.asp and copied that lastname stuff I could find and renamed it to gradlastname... and I went into the database and found the forum_members and made the correct column in there... but when I try to register a NEW user I get this error
Microsoft OLE DB Provider for SQL Server error '80040e14'
Invalid column name 'M_GRADLASTNAME'.
/forum/register.asp, line 573
and if I am updating a current user I don't get any error but it doesn't store it in the database either!
Are there any other places besides register.asp and inc_profile.asp that I need to edit code?
ok... now GRADLASTNAME is making it to the pending activation table but when I activate the account via the email that gets sent out the GRADLASTNAME field is lost and doesn't make it to the FORUM_MEMBERS table. There is not an error either.
anybody have any idea what is going on or where to look?
it's in the register.asp file. there is a section in there that moves the data over from the PENDING_MEMBERS table to the MEMBERS table when an account is activated/verified.
I noticed this... chkString(rsKey("M_GRADLASTNAME"),"SQLString") & "'" is the chkString(rsKey comparing something in the cookie... cause if so, that could be a problem cause I don't thing my change is referenced in the cookie at all...
I woke up the next day looked at the code and a friend looked at it with me... realized I was looking at the wrong page the night before... everything works fine now!
so far here are the changes that have been made... made a index page that shows info that ties into snitz
changed age to Graduation Year and made it a select box
added a field for graduation last name
installed a photo gallery mod and made it to show grad year, first name and grad last name instead of username since username will not mean much to high school alumni people
added a tell a friend about the site form
added a feedback form
also working on adding a trigger so that when someone new signs up and validates there info a email is sent off to people from the same grad year and two years before and afte letting them know who signed up
working on making it so that the photo gallery searches a few other fields and so that you have the option to make one of the photos you are uploading your default pic in your profile.
also working on making it so the profile search can return only profiles with default pics...
and I need to work on making my headers on the snitz pages and my custom pages look the same.
sheesh, probably a few other things to do too... oh yeah... I am looking for a snitz calendar mod too.
Topic Locked
Posted - 13 March 2003 : 00:54:59
