| Author |
 Topic  |
|
need300z
Starting Member
14 Posts |
 Posted - 10 January 2001 : 23:43:58
|
This is the error I get when I run the setup from the mod screen.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
it reffers to:
strSql = strSql & "ADD COLUMN C_INTUSERFIELDS smallint NULL" in memeber_profile_setup.asp anybody have any clues at to what could be wrong here.
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 11 January 2001 : 05:06:43
|
quote:
This is the error I get when I run the setup from the mod screen.
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.
it reffers to:
strSql = strSql & "ADD COLUMN C_INTUSERFIELDS smallint NULL" in memeber_profile_setup.asp anybody have any clues at to what could be wrong here.
A couple of questions first,
which version of the forumcode are you using?
Did you download this as part of Myforum code, or from the link in this Topic?
I will post you a file when you have answered
'Resistance is futile' |
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 11 January 2001 : 06:07:15
|
Thanks HuwR,
i send u email to the addy in your profile on this board
I did redo the mod, this time i got it show up on profile but it does not update or record the field value when post.
I am lost:( thanks for help
Edited by - evehawk on 11 January 2001 06:08:51 |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 11 January 2001 : 06:43:27
|
quote:
Thanks HuwR,
i send u email to the addy in your profile on this board
I did redo the mod, this time i got it show up on profile but it does not update or record the field value when post.
I am lost:( thanks for help
Edited by - evehawk on 11 January 2001 06:08:51
I have been trying to respond, but your mail program does not give the correct return address. I have now sent it to the address listed here in your profile
'Resistance is futile' |
|
|
|
need300z
Starting Member
14 Posts |
Posted - 11 January 2001 : 09:38:34
|
HuwR, i'm using 3.1sr4 and Yes I download your code from above. I'm using sql 7 and the mod commader to run it and running into those problems
|
|
|
|
need300z
Starting Member
14 Posts |
Posted - 11 January 2001 : 11:35:21
|
Ok i added the colum in forum_config that was missing: C_INTUSERFIELDS smallint NULL but now when i go to the mod commmander and and try and run go. I get:
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/board/mods/admin_user_fields.asp, line 59
know what do I do
|
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 11 January 2001 : 11:44:15
|
quote:
Ok i added the colum in forum_config that was missing: C_INTUSERFIELDS smallint NULL but now when i go to the mod commmander and and try and run go. I get:
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/board/mods/admin_user_fields.asp, line 59
know what do I do
look in admin_userfields for
rs2.AbsolutePage = iPage
change it to
if not rs2.BOF or not rs2.EOF then
rs2.AbsolutePage = iPage
end if
'Resistance is futile' |
|
|
|
need300z
Starting Member
14 Posts |
Posted - 11 January 2001 : 11:47:23
|
ok here is what I had to do:
I have added a small fix to this, modify line 59 to this
'############################################
if rs2.AbsolutePage > 0 then
rs2.AbsolutePage = iPage
end if
'############################################
I had also changed the [Page:1/0] so it would display correctly [Page:1/1] by changing line 80 to this:
'############################################
response.write " [Page:" & iPage & "/"
if iPageCount = 0 then
iPageCount = 1
end if
response.write iPageCount & "]"
'############################################
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 17 January 2001 : 17:23:32
|
HuwR... I'm having trouble with User Fields.. Here is the files. Let me know if you see what's wrong
www.eastpasco.com/files/userf.zip
The setup file will not work either... I'm on 3.1 SR4
Thanks
Rick
My Demo Site
www.eastpasco.com
Edited by - rick7165 on 17 January 2001 17:37:18 |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 17 January 2001 : 18:05:42
|
firstly, you need to edit the include directives in
admin_user_fields remove the ../
'Resistance is futile' |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 22 January 2001 : 20:54:06
|
Fields are showing up, but no data :( here is the line of code:
<%'Rem User Field Code #######################################
if (intUserFields > 0) then
%> <tr>
<td align=center bgcolor="<% =strCategoryCellColor %>" colspan="2"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Extra Info..</font></b></td>
</tr>
<tr><td></td></tr>
<%
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strConnString
set rs2 = Conn.Execute("SELECT * FROM " & strMemberTablePrefix & "USERFIELDS ORDER BY USR_FIELD_ID")
do until rs2.EOF
fieldValue = getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID"))
Response.Write ("<tr><td valign=""top"" align=""right"" bgColor=" &strPopUpTableColor & " > <b><font face=""" & strDefaultFontFace & """ size=" & strDefaultFontSize & ">" & rs2("USR_LABEL") & ":</font></b></td>")
if rs2("USR_FIELDTYPE") = "T" then %>
<td valign="top" bgColor="<% =strPopUpTableColor %>"><textarea maxLength="255" name=<%=rs2("USR_SHORTNAME")%> cols="20" rows=3><%= getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID")) %></textarea></td>
<% Else
if rs2("USR_FIELDTYPE") = "S" then %>
<td valign="top" bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name=<%=rs2("USR_SHORTNAME")%> size="20" value="<%= getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID")) %>"></font></td>
<% Else %>
<td valign="top" bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name=<%=rs2("USR_SHORTNAME")%> type="checkbox" value="1" <% If fieldValue = "1" then %>checked<% End If %>></font></td>
<% End If %>
<% End If %>
<% rs2.MoveNext
loop
rs2.Close
Conn.close
set Conn = Nothing
end if
'Rem User Field Code #######################################
My Demo Site
www.eastpasco.com |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 23 January 2001 : 22:58:46
|
Not sure if it's me.. Most likely... LOL
But The user fields work when a new member joins.. they can enter into that field and it shows up, But if a current member trys to go and enter info in the extra field.. It will not show up.
Any Suggestions?
Rick
My Demo Site
www.eastpasco.com |
|
|
|
CrAzY
New Member
USA
50 Posts |
Posted - 24 January 2001 : 15:32:34
|
Does anyone have this mod working on their site? I'd like to see an example of what this does.
I'm Beyond Help |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 24 January 2001 : 15:46:32
|
You can try it here
Test Forum
You can log in as Admin/admin to test the admin stuff.
'Resistance is futile' |
|
|
|
CrAzY
New Member
USA
50 Posts |
Posted - 24 January 2001 : 16:25:27
|
Thanks HuwR ...
Now I've got an idea of how i might implement this.
I'm Beyond Help |
|
|
|
Topic |
|
Topic Locked
