| Author |
 Topic  |
|
joswell
Starting Member
USA
11 Posts |
|
|
Bookie
Average Member
USA
856 Posts |
 Posted - 17 July 2001 : 16:16:56
|
quote:
simonduz;
You're right on the Access. However, I am not good at Access, but I figured out that the DataTypefor Working is should be in Yes/No in Access 2000. This is what Access calls BIT. When Rob Poretti said set the default valaue is (1), I think he meant set it equal TRUE (CHECKED value)
Correct me if I am wrong.
I still get not get the contendisplay_editor.asp work.
I'm having the same problem. Anyone have a fix for this? (Out of acceptable range.)
Bookie
"May the forces of evil become confused on the way to your home."
- George Carlin |
 |
|
|
Bookie
Average Member
USA
856 Posts |
|
|
Bookie
Average Member
USA
856 Posts |
Posted - 17 July 2001 : 16:38:16
|
The error is occuring at line 110 of the inc_functions page. That line is the execution of the sql statement. You can view my inc_functions page here...
http://www.bookfamily.net/forum/inc_functions.txt
Any help would be appreciated.
Bookie
"May the forces of evil become confused on the way to your home."
- George Carlin |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 17 July 2001 : 16:56:18
|
Do you have the Posting Restrictions MOD installed?
This line is right above it(ok a couple lines up)....
'############### Posting Restrictions ###########################
strSql = strSql & ", F_HIDDEN "
'############### Posting Restrictions ###########################
@tomic
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 July 2001 : 19:00:15
|
'//////////////////////////////// FORM VARIABLES //////////////
if Request.Form("intID") = "" then
intID = 1
else
intID = cint(Request.Form.Item("intID"))
end if
'//////////////////////////////// DISPLAY COLUMN PROPERTIES //////////////
The above statements(at the top of contentdisplay_editor.asp) force the intID to be "1" when you load the contentdisplay_editor.asp. And if you have no record with ID "1" in the table DC_templates, you will get an error of Either Eof or BOF is true or record has been deleted. To overcome this problem these statements need to be added to this file:
Look for the following in contentdisplay_editor.asp
if not (oRSTemplates.EOF and oRSTemplates.BOF) then
DatabaseConnected = True
end if
And add these statements below it
'########### In case there is no record with ID=1 ########
if oRSTemplates.RecordCount > 0 then
if Request.Form("intID") = "" then
intID = oRSTemplates("ID")
'Make sure the working is set to True
oRSTemplates("WORKING") = True
oRSTemplates.Update
end if
end if
'#######################################################
Above will assign ID of first recordset returned by the query to the intID.
gauravbhabu
There is only one miracle...That is LIFE! |
|
|
|
Bookie
Average Member
USA
856 Posts |
Posted - 17 July 2001 : 19:33:19
|
If you're looking at my content display editor page, don't create a template and save it because I'm using Access 2000 database. Every time someone does, I have to download my database and delete the record.
I do not have the posting restrictions mod installed. I didn't know there was one and I didn't know it was required for this mod.
Bookie
"May the forces of evil become confused on the way to your home."
- George Carlin |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 17 July 2001 : 21:07:33
|
Ok. GauravBhabu, Bookie, @tomic
Just got back to town and need to know the last peice of this puzzle. I have this working but apparently don't have my Access settings correct for the 'Working' column. Can somebody post these, as I have not been able to get it to work with 'Yes/No.'
Thanks again,
Simonduz
http://easyromantic.webbhost.net -[test site]-
yada, yada. |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 17 July 2001 : 21:15:44
|
I have not yet attempted to install this MOD as I have been adding all the MODs required to get it to work first. I was set to do it tonight until I saw that the Posting restriction MOD is needed(Doh!). At least the tables/fields need to be there anyway. I am not going so far as adding the rest of it if it's not necessary.
I just can't wait to delve into this 1/2, Yes/No, True/False thing. It's given me grief before 
@tomic
|
|
|
|
Bookie
Average Member
USA
856 Posts |
Posted - 17 July 2001 : 21:33:48
|
Ok. I've nailed it down. I can get it to work under certain circumstances.
On the contentdisplay_editor.asp page, if I have Admin mode ON, everything works.
On my http://www.bookfamily.net/index2.asp page, the only way I can get one of them to work is if I have topicstatus = closed topics.
If neither of the above situations occur, I get an error on the inc_functions.asp page at line 110 (see previous post).
Bookie
"May the forces of evil become confused on the way to your home."
- George Carlin |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 17 July 2001 : 21:43:01
|
quote:
I just can't wait to delve into this 1/2, Yes/No, True/False thing. It's given me grief before
LOL. Yep been there done that. Can't get this one right for some reason. But it does work with the setting I posted earlier so I am not sure what 'Working' really is supposed to do at this point.
simonduz
http://easyromantic.webbhost.net -[test site]-
yada, yada. |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 July 2001 : 21:51:50
|
There are some changes need to be made to the contentdisplay_editor.asp.
For Access DB
The WORKING should be YES/NO and on the General Tab select TRUE/FALSE as Format. On the LOOK UP tab I selected Text BOX.
***************
contentdisplay_editor.asp
***************
Find the below line
strSQL = strSQL & "WHERE WORKING = " 1
(somehow this is not working.)
and change it to
strSQL = strSQL & "WHERE WORKING =True"
There are two instances of it.
***********************
Inc_functions
***********************
I do not have F_USERLIST in FORUM_FORUM so I changed it to:(need posting restrictions mod). If you have this field in your table then you need not make these changes
Find this statement
'strSql = "SELECT " & strTablePrefix & "FORUM.F_USERLIST, " & strTablePrefix & "FORUM.F_PRIVATEFORUMS "
change it to:
strSql = "SELECT " & strTablePrefix & "FORUM.F_TOPIC_AUTH, " & strTablePrefix & "FORUM.F_PRIVATEFORUMS "
Find this code:
'if Instr(rsAccess("F_USERLIST"), ", ") > 0 then
' Users = Split(rsAccess("F_USERLIST"), ", ")
'elseif trim(rsAccess("F_USERLIST")) <> "" then ' Only 1 member assigned to forum
' chkDisplayPrivateForum = (cint(rsAccess("F_USERLIST")) = cint(UserNum))
' exit function
'else ' No members assigned to forum
' chkDisplayPrivateForum = false
' exit function
'end if
change it to
if Instr(rsAccess("F_TOPIC_AUTH"), ", ") > 0 then
Users = Split(rsAccess("F_TOPIC_AUTH"), ", ")
elseif trim(rsAccess("F_TOPIC_AUTH")) <> "" then ' Only 1 member assigned to forum
chkDisplayPrivateForum = (cint(rsAccess("F_TOPIC_AUTH")) = cint(UserNum))
exit function
else ' No members assigned to forum
chkDisplayPrivateForum = false
exit function
end if
There are two instances of it.
Also look for my post earlier for another change. This Mod can be used for displaying content from all the tables with modifications or additional case statements and queries. The logic for the Mod is simple what the thought behind the idea is really great.It is great work. And Works like a CHARM.
gauravbhabu
There is only one miracle...That is LIFE!
Edited by - GauravBhabu on 17 July 2001 22:13:00 |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 July 2001 : 22:05:38
|
quote:
Ok. I've nailed it down. I can get it to work under certain circumstances.
On the contentdisplay_editor.asp page, if I have Admin mode ON, everything works.
On my http://www.bookfamily.net/index2.asp page, the only way I can get one of them to work is if I have topicstatus = closed topics.
If neither of the above situations occur, I get an error on the inc_functions.asp page at line 110 (see previous post).
Bookie
"May the forces of evil become confused on the way to your home."
- George Carlin
What is on line 110.
gauravbhabu
There is only one miracle...That is LIFE! |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 17 July 2001 : 22:18:06
|
103 '############### Posting Restrictions ###########################
104 strSql = strSql & ", F_HIDDEN "
105 '############### Posting Restrictions ###########################
106
107 strSql = strSql & " FROM " & strTablePrefix & "FORUM "
108 strSql = strSql & " WHERE FORUM_ID = " & fForum_ID
109
110 set rsAccess = my_Conn.Execute(strSql)
@tomic
Edited by - @tomic on 17 July 2001 22:19:09 |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 July 2001 : 22:23:25
|
Did you check my post above for the statements which relate to statements before line 103 in your file.
gauravbhabu
There is only one miracle...That is LIFE! |
|
|
|
Topic |
|
Topic Locked
