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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Alter default value in table		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 18 February 2005 :  11:39:47  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
I want to alter the default value for M_PMEMAIL in the members table - Is this dbs code going to get me anywhere:

[ALTER]
MEMBERS
ALTER#M_PMEMAIL#int#NULL#1
[END]

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 18 February 2005 :  12:17:40  Show Profile  Send ruirib a Yahoo! Message
You can't alter default values through a dbs file.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 18 February 2005 :  12:40:09  Show Profile
You'll have to go into the database and alter it manually. Alternatively, you can it to the INSERT statement when people register so that it sets M_PMEMAIL to the new value.
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 18 February 2005 :  12:50:02  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
quote:
Originally posted by Shaggy

You'll have to go into the database and alter it manually. Alternatively, you can it to the INSERT statement when people register so that it sets M_PMEMAIL to the new value.
I came up with this:

register.asp
line 140/442:		strSql = strSql & ", M_PMEMAIL"
			strSql = strSql & ", M_PMRECEIVE"
line 185/585:		strSql = strSql & ", 1"
			strSql = strSql & ", 1"

I put the values after M_SHA256, as they appear in that order in the database, is that right
Edited by - Jorrit787 on 18 February 2005 13:03:45
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 18 February 2005 :  12:58:46  Show Profile
Should do it. For future reference, though, they don't have to be in the same order they are in the database, just usually makes things easier on you in the long run.
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 18 February 2005 :  13:04:59  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
Thanks a lot! It would seem I'm actually starting to get the hang of SQL statements
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 18 February 2005 :  13:16:10  Show Profile
You're welcome

Yeah, once the basics click, you're laughing; then it's on to the more fun, advanced stuff!
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
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 0.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07