| Author |
 Topic  |
|
AnonJr
Moderator
United States
5768 Posts |
 Posted - 31 March 2006 : 10:40:26
|
Not a doctor. Just a computer programmer for the hospital's Training and Development department.
We're trying to drag the staff into the 21st century with computer charting etc. and we're getting a lot of resistance. When you add that we have a little over 4,000 employees and the new training takes me away from my regular work to teach classes, things get interesting.
Because I know I'm going to be pulled from my regular work sometime around July or so I've been killing myself with 12hr days to get my "regular" stuff done. Hopefully I'll be out on time today and can work on it... it is my birthday after all.  < |
 |
|
|
Karel Bata
Junior Member
United Kingdom
122 Posts |
Posted - 31 March 2006 : 19:04:37
|
Happy Birthday!  < |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 31 March 2006 : 19:18:11
|
quote:
Originally posted by Karel Bata
Happy Birthday!
Thanks.  I actually got out of work at 17:00 which has been early for me. Too bad I'm salaried and don't qualify for overtime pay. 
I've made the MySQL changes and I'm trying to fix a couple of other minor bugs. I hope to have some updates up this weekend. Since the birthday party is tomorrow, the updates will go up either tonight or Sunday.  < |
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 01 April 2006 : 05:34:09
|
| Happy birthday, Mark!< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 April 2006 : 09:52:06
|
rabufo, I went to work on your question about hiding the topic/reply counts this morning and noticed that you've solved it. While I'm glad you got it working, I am truly sorry I didn't get to your problem promptly.  < |
|
|
|
Bassman
Junior Member
Netherlands
256 Posts |
Posted - 06 April 2006 : 09:57:56
|
When edit a catagory I get this error:
Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in table 'FORUM_CATEGORY'.
/post_info.asp, line 1516
< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 April 2006 : 10:07:06
|
What are you trying to do with the category? I'd like to try to repeat it on my test forum here at work. Also, do you have any web links in that category or the forums in that category?
<edit>I guess a link to a txt version of post_info.asp would be helpful too... make sure we're looking at the same lines and all. </edit>< |
Edited by - AnonJr on 06 April 2006 10:09:29 |
|
|
|
Bassman
Junior Member
Netherlands
256 Posts |
Posted - 06 April 2006 : 12:01:19
|
You right, a txt is of more help...sry. Found the problemen already, the poll mod code was bugging the sub forums code. I made the post_info from scratch with all the code and it works fine. I gess I made a error somewhere.
Link with subforum running:
http://www.wjforum.nl
Edit: poll mod is giving a error:
quote:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/post_info.asp, line 1001
Txt of post_infohttp://www.wjforum.nl/post_info.txt< |
Edited by - Bassman on 06 April 2006 12:13:42 |
|
|
|
Karel Bata
Junior Member
United Kingdom
122 Posts |
Posted - 06 April 2006 : 16:38:28
|
I thought I'd register to look around and see what you've done (very nice what i can see of it). I selected 'register', got to the 'Registration Rules and Policies Agreement' page (http://www.wjforum.nl/policy.asp) selected 'agree' and was taken straight back to the 'Registration Rules and Policies Agreement' page. A loop...
I use Firefox
Just tried with IE - same prob.< |
Edited by - Karel Bata on 06 April 2006 16:40:00 |
|
|
|
Karel Bata
Junior Member
United Kingdom
122 Posts |
Posted - 06 April 2006 : 16:49:41
|
In the 'Cluster zuid' section, where the sub-forums are I can see the 'Moderator(s)' column. Is that intentional or a bug of the mod?
Ah, I can see it all working in 'World Jamboree [2003]'. You have all the sub forums listed on the main page. Is it possible to switch that facility off in the mod?
< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 April 2006 : 20:54:23
|
Bassman, I hate to say this, but I just can't seem to figure out where the problem is. I'm watching my mother's house while she and my step-father are away, so I don't have much more that trusty ole Notepad... but I just can't see what's missing. Have you tried doing a Response.Write and looking at the actual SQL Statement?
Karel Bata, you wouldn't happen to be using Norton Security would you? I know that's caused that problem in the past.
As to your other question, technically no - there is no "switch" to automatically turn off the listing of sub-forums on the main page. I can show you what to comment out as soon as I get to work tomorrow if you're interested. I may have to think about adding some sort of control panel and make some other options....< |
|
|
|
Bassman
Junior Member
Netherlands
256 Posts |
Posted - 07 April 2006 : 06:30:02
|
@ Karel Bata, registration is fixed.
quote:
In the 'Cluster zuid' section, where the sub-forums are I can see the 'Moderator(s)' column
Correct, I will try to build this in, test and post the code.
quote:
Response.Write and looking at the actual SQL Statement?
Hmmm, I will go and do a check.
Don't worry about the time, I'm not in a hurry and this still is a beta version so I really can't complain  < |
|
|
|
Bassman
Junior Member
Netherlands
256 Posts |
Posted - 07 April 2006 : 07:57:09
|
old
quote:
set rsCatIDCheck = my_Conn.execute(strSql)
bolCatIDChanged = (cSTr(rsCatIDCheck("CAT_ID")) <> ChkString(intSetCategory, "SQLString"))
rsCatIDCheck.Close
set rsCatIDCheck = Nothing
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET CAT_ID = " & cLng("0" & intSetCategory)
'############################ Poll Mod ###########################
if Request.Form("PollAuth") <> "" then
strSql = strSql & ", F_POLLS = " & chkString(Request.Form("PollAuth"),"SQLString") & ""
end if
'#################################################################
to
quote:
set rsCatIDCheck = my_Conn.execute(strSql)
bolCatIDChanged = (cSTr(rsCatIDCheck("CAT_ID")) <> ChkString(Request.Form("Category"), "SQLString"))
rsCatIDCheck.Close
set rsCatIDCheck = Nothing
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET CAT_ID = " & cLng("0" & Request.Form("Category"))
'############################ Poll Mod ###########################
if Request.Form("PollAuth") <> "" then
strSql = strSql & ", F_POLLS = " & chkString(Request.Form("PollAuth"),"SQLString") & ""
end if
'#################################################################
No more error's poll works, still one problem when trying to alow polls in a cat. And whats this? 'End parent mod code -- JUST MAKE SURE YOU CHANGE THAT request.form variable!? Change what where to what.< |
Edited by - Bassman on 07 April 2006 08:42:56 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 April 2006 : 18:24:31
|
quote:
Originally posted by Bassman
And whats this? 'End parent mod code -- JUST MAKE SURE YOU CHANGE THAT request.form variable!? Change what where to what.
That is from the original readme that sr_erick sent. I've added those places in the new readme, I just forgot to remove my reminder.
And I do worry about time... I just wish I had more.  When I started with the public work on this it looked like I was going to have more time than I've had lately.  I'm hoping that will change soon.< |
|
|
|
Karel Bata
Junior Member
United Kingdom
122 Posts |
Posted - 07 April 2006 : 20:03:48
|
quote:
you wouldn't happen to be using Norton Security would you?
Yes I do. But that's not caused probs with other Snitz forums for me so far... Seems that Bassman has fixed it anyhow.
quote:
there is no "switch" to automatically turn off the listing of sub-forums on the main page. I can show you what to comment out as soon as I get to work tomorrow if you're interested.
Not at that stage yet. Just watching what you guys are up to, and trying to be a little helpful. This is a useful mod and I hope to be using it eventually. Keep up the good work. < |
|
|
|
Topic |
|
sr_erick's Sub-forums MOD
