Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Form to Post to Private Forum.
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

JJenson
Advanced Member

USA
2121 Posts

Posted - 27 July 2007 :  17:03:54  Show Profile  Visit JJenson's Homepage  Reply with Quote
Ok suprise suprise I ran into an error this is what it was


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.1.20-max-log]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 '10, CAT_ID, T_SUBJECT, T_MESSAGE, CustomScript, T_LAST_POST, CustomScript, T_LAS' at line 1

/forum/bug_reporter_send.asp, line 99


This is what is the section it is getting angry about.

<%
Response.End
end if

title = "[Custom Script Form " & strDBNTUserName & "]"

bugDesc = "<b>User Name:</b> " & strDBNTUserName & "<br> "
bugDesc = bugDesc & "<b>OS Info:</b> " & ChkString(Request.Form("userIp"),"hidden") &"<br> "
bugDesc = bugDesc & "<b>IP Address:</b> " & ChkString(Request.Form("OSinfo"),"hidden") &"<br> "
bugDesc = bugDesc & "<b>Your Name:</b> " & ChkString(Request.Form("Subject"),"hidden") &"<br> "
bugDesc = bugDesc & "<b>Custom Script Wanted:</b><br>" & ChkString(Request.Form("Message"),"message")

strSql = "INSERT INTO " & strTablePrefix & "TOPICS (10"
strSql = strSql & ", CAT_ID"
strSql = strSql & ", T_SUBJECT"
strSql = strSql & ", T_MESSAGE"
strSql = strSql & ", CustomScript"
strSql = strSql & ", T_LAST_POST"
strSql = strSql & ", CustomScript"
strSql = strSql & ", T_LAST_POST_REPLY_ID"
strSql = strSql & ", T_DATE"
strSql = strSql & ", T_STATUS"
strSql = strSql & ") VALUES ("
strSql = strSql & " '" & title & "'"
strSql = strSql & ", '" & bugDesc & "'"
strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", " & "0"
strSql = strSql & ", " & "0"
strSql = strSql & ", '" & 1 & "')"


my_Conn.Execute (strSql)%>


I am sure I messed up the SQL statement somehow in modifying it to my needs.<
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts

Posted - 27 July 2007 :  17:06:12  Show Profile  Visit JJenson's Homepage  Reply with Quote
OK got it all working

My next step would be how do I get a field for them to insert their personal email?<

Edited by - JJenson on 27 July 2007 17:24:14
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 27 July 2007 :  19:20:10  Show Profile  Visit MaD2ko0l's Homepage  Reply with Quote
add an email field to the bug_reporter.asp (the form where they neter details)

and then add the following to bug_reporter_send.asp page where it you want it to be displayed in the message.

bugDesc = bugDesc & "<b>E-Mail:</b><br>" & ChkString(Request.Form("Email"),"message")


so it coudl look liek this

bugDesc = bugDesc & "<b>Your Name:</b> " & ChkString(Request.Form("Subject"),"hidden") &"<br> "
bugDesc = bugDesc & "<b>Custom Script Wanted:</b><br>" & ChkString(Request.Form("Message"),"message") &"<br> "
bugDesc = bugDesc & "<b>E-Mail:</b><br>" & ChkString(Request.Form("Email"),"message")
strSql = "INSERT INTO " & strTablePrefix & "TOPICS (10"
<

© 1999-2010 MaD2ko0l
Go to Top of Page

JJenson
Advanced Member

USA
2121 Posts

Posted - 28 July 2007 :  01:44:54  Show Profile  Visit JJenson's Homepage  Reply with Quote
Thanks so much Mad2kool This script works perfectly for what I needed. It was fairly easy to get it to say what I needed it to. Thanks again. <
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 28 July 2007 :  09:02:31  Show Profile  Visit MaD2ko0l's Homepage  Reply with Quote
no problems mate<

© 1999-2010 MaD2ko0l
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.07