Snitz Forums 2000 - How to set the same value to a whole column in DB?

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

How to set the same value to a whole column in DB?

New Topic

Topic Locked

Printer Friendly

Author

Topic

gorman
Starting Member

Italy
47 Posts

Posted - 09 May 2002 : 13:51:41

Is there a quick way to set to 1 the value for R_STATUS of all replies in the A_REPLY table?

A simple script, something... pardon my ignorance if it's a stupid question.

Thanks in advance to anybody that will help.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 May 2002 : 16:51:49

I'll write you a script for it. Just wait a couple minutes...

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 May 2002 : 17:05:48

Ok, here you have a text version of the script. Just copy the content and save it as an ASP file upload it to your forum folder and execute it.

It will set both FORUM_A_REPLY.R_STATUS and FORUM_A_TOPICS.T_STATUS to 1.

Any doubts let me know.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 2.19 seconds.