| Author |
 Topic  |
|
RichardE
Starting Member
United Kingdom
20 Posts |
 Posted - 30 November 2003 : 14:23:27
|
Mike
Thanks for the fix - it all works fine now.
Really good MOD.
Richard |
 |
|
|
JMT
Starting Member
17 Posts |
Posted - 09 December 2003 : 10:40:11
|
| Yes, only after I installed the signup mod. Not sure why still, so I gave up until I saw some more folks using it with a mySQL back end. Do you use mySQL on IIS/Win2K? |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 09 December 2003 : 20:22:23
|
JMT - The signup mod does not modify the cal_post_info2.asp. I would need to see the lines before Line 66. If you want to send me the file i'll take a look at it (If you still have it). My email is in the readme file or send a email through my profile here.
I am running Access currently on Win2K/IIS but others have installed this mod on mySQL. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 28 December 2003 : 00:31:37
|
I made a modification to how the signup link appears in topic.asp. See pic below:
The buttons open both pages in the same window. To do this find this section in topic.asp @line 1250:
'##### Signup Mod ######
if is_event = "1" and strList = "1" then
Response.Write " <tr>" & vbNewLine & _
" <td valign=""bottom""><hr noshade size=""" & strFooterFontSize & """><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><span class=""spnMessageText"">To sign up for this event or to see who it attending click below:<br><a href=""" & strForumURL & "eventlist.asp?Event=" & TopicID & "&B1=Submit"">" & strForumURL & "eventlist.asp?Event=" & TopicID & "&B1=Submit</a> </span></font></td>" & vbNewLine & _
" </tr>" & vbNewLine
end if
if CanShowSignature = 1 and Topic_Sig = 1 and Topic_MemberSig <> "" then
Response.Write " <tr>" & vbNewLine & _
" <td valign=""bottom""><hr noshade size=""" & strFooterFontSize & """><font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><span class=""spnMessageText"">" & formatStr(Topic_MemberSig) & "</span></font></td>" & vbNewLine & _
" </tr>" & vbNewLine
end if
Replace the code in red with the following:
if is_event = "1" and strList = "1" then
Response.Write " <tr>" & vbNewLine & _
" <td valign=""bottom""><hr noshade size=""" & """>" & vbNewLine & _
"<input type=""button"" value=""View Attendees"" onClick=""eventattendees(this)"">" & vbNewLine & _
" " & vbNewline & _
"<input type=""button"" value=""Signup Now!"" onClick=""eventsignup(this)"">" & vbNewLine & _
" </td></tr>" & vbNewLine
end if
In inc_header.asp, add the following javascript functions:
"function eventsignup(url,w,h) { var MainWindow = window.open('eventlist.asp?SignUp=" & Topic_ID & "&B1=Submit""','_self','width='+w+',height='+h+',scrollbars=yes');" & vbNewLine & _
"}" & vbNewLine & _
"function eventattendees(url,w,h) { var MainWindow = window.open('eventlist.asp?Event=" & Topic_ID & "&B1=Submit""','_self','width='+w+',height='+h+',scrollbars=yes');" & vbNewLine & _
"}" & vbNewLine & _
That should be it. |
Edited by - StephenD on 03 March 2004 20:19:01 |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 30 December 2003 : 21:32:23
|
| Thanks StephenD, I may add that to the next release if you do not mind. However not sure when the next release will be. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
Gargoyle
Junior Member
USA
280 Posts |
|
|
JMT
Starting Member
17 Posts |
Posted - 08 February 2004 : 01:17:52
|
MySQL errors:
Trying to get this going again (I'd REALLY like to use this). and I get these errors:
Clicking on the To sign up for this event or to see who it attending click below: link gets me this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'E.EVENT_DATE >= '20040207000000' GROUP BY T.TOPIC_ID, T.FORUM_I
/EMSR/Interviews/eventlist.asp, line 163
Clicking on Event List Maintenance in the Admin panel gets me:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]Invalid use of group function
/EMSR/Interviews/admin_signup.asp, line 52
What can I do to get this to work?
Thanks,
Joe |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 08 February 2004 : 10:18:45
|
| My first thought is that it has something to do with MySql. I have tried this with Access and MS SQl but not mySQL. I will have to investigate a little to see what is different in MySQL. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
JMT
Starting Member
17 Posts |
Posted - 12 February 2004 : 08:01:55
|
| Thanks. I wonder if there is a mySQL guru we could ask from here somewhere. Do you know what the procedure / feelings would be about maybe putting some of this thread on the mySQL support forum to see if anyone in there could help? |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
|
|
JMT
Starting Member
17 Posts |
Posted - 13 February 2004 : 16:58:49
|
| Thanks. I'll give it a try tonight. I'll let you know if it works too. |
|
|
|
JMT
Starting Member
17 Posts |
Posted - 13 February 2004 : 23:12:07
|
No deal on the fix. Here are the latest errors after modifying the code as instructed in the post you found:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'E.EVENT_DATE >= '20040213000000' ORDER BY min(E2.EVENT_DATE) As
Can't make the error in that area go away...
|
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 14 February 2004 : 10:11:35
|
| The latest information from that post claim it is the min statement in MySQL. If you remove it the code should work but it will give you the wrong results. However it might be worth trying just to see if the Min() is the problem. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 14 February 2004 : 10:20:38
|
In the admin_signup.asp page you might try this code to replace Line 31 - 44:
StrSQL = "SELECT T.FORUM_ID, Min(E.EVENT_DATE), T.T_SUBJECT, T.TOPIC_ID " & _
"FROM (" & _
strTablePrefix & "TOPICS AS T " & _
"INNER JOIN " & _
strTablePrefix & "CAL_EVENTS AS E ON T.TOPIC_ID = E.TOPIC_ID) " & _
"INNER JOIN " & _
strTablePrefix & "CAL_EVENTS AS E2 ON E.TOPIC_ID = E2.TOPIC_ID " & _
"WHERE T.T_ISEVENT = 1 AND T_LIST_INCLUDE = 1 " & _
"AND E.EVENT_DATE < '" & datetostr(DateValue(strForumTimeAdjust)) & "' "
strSql = strSql & _
" GROUP BY T.TOPIC_ID, T.FORUM_ID, T.T_SUBJECT, T.TOPIC_ID, " & _
"E.EVENT_DATE " & _
"ORDER BY E2.EVENT_DATE Asc, T.TOPIC_ID Asc, E.EVENT_DATE Asc "
I have no way of testing it - If it works for the admin screen then we can move to the signup.asp one. |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
JMT
Starting Member
17 Posts |
Posted - 20 February 2004 : 16:05:53
|
Thanks n8pbm. I'll try it tonight. Sure wish they had subscriptions turned on for these forums...
I'll let you know how it turns out. |
|
|
|
Topic |
|
Topic Locked
