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: MOD Implementation
 adding more character in frontpage_news MOD		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pokemon
Junior Member

151 Posts
Posted - 21 October 2003 :  11:05:23  Show Profile
Hello,

i download frontpage news mod. Everything is working very well. But i have one little concern of how to increase more character in the fields.

i look in dbs_frontnews.asp

Front Page News V1.5

[DROP]
NEWS
[END]
[DROP]
NEWS_CONFIG
[END]

[CREATE]
NEWS_CONFIG

show_news#int#NULL#
num_items#int#NULL#
[END]

[CREATE]
NEWS

MEMBER_ID#int#NULL#
N_DATE#varchar(20)#NULL#
N_TEXT#varchar(225)#NULL#
[END]


How do i change to textarea or text = 1000 characters. I currently have only 225

by changing this link

N_TEXT#varchar(225)#NULL# to varchar(500) and i'm ending with an error

CREATE TABLE FORUM_NEWS( MEMBER_ID int NULL , N_DATE varchar(20) NULL , N_TEXT varchar(500) NULL )
CREATE TABLE FORUM_NEWS( MEMBER_ID int NULL , N_DATE varchar(20) NULL , N_TEXT varchar(500) NULL )
-2147217887 | Size of field 'N_TEXT' is too long.

--------------------------------------------------------------------------------
Unable to remove dbs file
Permission denied

anyone would please help me. I'd appreciate it

DavidRhodes
Senior Member

United Kingdom
1222 Posts
Posted - 21 October 2003 :  11:10:37  Show Profile
try replacing 'varchar(225)' with 'memo'
The UK MkIVs Forum
Edited by - DavidRhodes on 21 October 2003 11:10:57
Go to Top of Page

pokemon
Junior Member

151 Posts
Posted - 21 October 2003 :  11:21:02  Show Profile
thanks, it works great
Go to Top of Page

Cailean
New Member

Canada
75 Posts
Posted - 31 October 2003 :  21:18:16  Show Profile
maybe a silly question... do I have to re-run the dbs file in Admin Options-->Mod Setup? If so, will I lose anything in the DB?
Never mind, just went ahead and did it, anyway...

Also, I edited admin_newspost.asp so the the input box was a textarea so that it
fit on the page better:
at line 192, find:
"    <input type=""text"" name=""strNewsPost"" size=""120"" value="""">" & vbNewLine & _

and replace it with:
"    <textarea name=""strNewsPost"" cols=""25"" rows=""4""></textarea>" & vbNewLine & _
Edited by - Cailean on 01 November 2003 17:53:21
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.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07