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

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 error '80048e07' --it's back again
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

DarkDrift
Junior Member

USA
126 Posts

Posted - 05 January 2005 :  19:50:44  Show Profile  Visit DarkDrift's Homepage  Send DarkDrift an AOL message
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/dev/traderfeedback/post_r_succ.asp, line 70

Line 70 is


rsIU.execute(strSql)


Here is the Form infor


<form action="./post_r_succ.asp" method="post">
			<table width="100%"  border="1">
                                    <tr>
<input type="hidden" name="UNAME" value="0">

                                      <td><div align="center"><strong>Persons Alias:<Br>
                                       <textarea cols="50" rows="4" wrap="virtual" scrolling="false" name="UALIS">Example:
  This person uses the names 4matic, riggyjames, smiley, rougeart on sites such as www.google.com, www.clodtalk.com, www.yahoo.com
									   </textarea>
                                      </strong></div></td>
                                    </tr>
                                    <tr>
                                      <td><div align="center"><strong>Persons Last known Contact:<br>
                                       <textarea cols="50" rows="4" wrap="virtual" scrolling="false" name="UCONTACT">Example:
  The last known address was in Miami, Florida on rigoli street. They're phone number is 410-456-****. Their Name is John Doe
									   </textarea>
                                      </strong></div></td>
                                    </tr>
<input type="hidden" name="UPIP" value="<%=Request.ServerVariables("REMOTE_HOST")%>">
<input type="hidden" name="UDATE" value="<%=now()%>">
<input type="hidden" name="UID" value="<%=intTopicID%>">
                                    <tr>
                                      <td><div align="center"><strong>Details on every aspect of the current situation:<br>
                                        <textarea cols="75" rows="10" wrap="virtual" scrolling="false" name="UINFO">Example:
  This user has stiffed many people out of a product. They have stff blah, blah, blah... etc.
									   </textarea>
                                      </strong></div></td>
                                    </tr>
                                    <tr>
                                      <td><div align="left"><strong>HelpFul Link 1:
                                        <input type="text" name="UPROOF1" size="20">
                                      </strong></div></td>
                                    </tr>
                                    <tr>
                                      <td><div align="left"><strong>HelpFul Link 2:
                                        <input type="text" name="UPROOF2" size="20">
                                      </strong></div></td>
                                    </tr>
                                    <tr>
                                      <td><div align="left"><strong>HelpFul Link 3:
                                        <input type="text" name="UPROOF3" size="20">
                                      </strong></div></td>
                                    </tr>
                                     <tr>
                                      <td><div align="center"><strong>Your Ip-Address has been recorded as: 
<%
Response.Write(U_IP)
%>
                                        </strong></div></td>
                                    </tr>
                                      <td><div align="left"><strong>We have recorded info such as your IP-Address and UserName to 
									  Prevent incorrect claims and to have a security record.</strong></div></td>
                                    </tr>
                                      <td><div align="left"><strong>NOTES:</strong> Please give all information possible without giving out information such as 
									  their exact address... Please give links to forums where this has been stated or to the item it's self as if we believe that 
									  this is not a "TRUE" Comment it will be removed</div></td>
                                    </tr>
              </table>
								  <p align="center">
								    <input type="submit" value="Submit">
								  </p>
		  </form>


The SQL is


set rsIU=Server.Createobject("ADODB.Connection")
		rsIU.open(strConnString)
Function lString(string)
	 if string = "" then string = " "
	 lString = Replace(string, "'", "''")
End Function
			'REGISTER SQL
	strSql = "INSERT INTO SITE_COMP_R ([U_ALIS],[U_NAME],[UP_CONTACT],[UP_IP],[UP_INFO],[DATE],[U_ID],[UP_PROOF1],[UP_PROOF2],[UP_PROOF3]) VALUES(" & _
	 "'" & lString(Request.Form("UALIS")) & "'," & _
	 "'" & lString(Request.Form("UNAME")) & "'," & _
	 "'" & lString(Request.Form("UCONTACT")) & "'," & _
	 "'" & lString(Request.Form("UPIP")) & "'," & _
	 "'" & lString(Request.Form("UINFO")) & "'," & _
	 "'" & lString(Request.Form("UDATE")) & "'," & _
	 "'" & lString(Request.Form("UID")) & "'," & _
	 "'" & lString(Request.Form("UPROOF1")) & "'," & _
	 "'" & lString(Request.Form("UPROOF2")) & "'," & _
	 "'" & lString(Request.Form("UPROOF3")) & "')"
	 rsIU.execute(strSql)
	 
Response.Write("<h1 align=""center"">Congratualtions!</h1>")
Response.Write	"<h3 align=""center"">Thank you for contributing. Your topic is now searchable"	& VbNewLine
	 
	 rsIU.close
	 set rsIU = nothing


The Response.write(strSql) is


INSERT INTO SITE_COMP_R ([U_ALIS],[U_NAME],[UP_CONTACT],[UP_IP],[UP_INFO],[DATE],[U_ID],[UP_PROOF1],[UP_PROOF2],[UP_PROOF3]) VALUES('Example: This person uses the names 4matic, riggyjames, smiley, rougeart on sites such as www.google.com, www.clodtalk.com, www.yahoo.com ',' ','Example: The last known address was in Miami, Florida on rigoli street. They''re phone number is 410-456-****. Their Name is John Doe ','192.168.1.1','Example: This user has stiffed many people out of a product. They have stff blah, blah, blah... etc. ','1/5/2005 7:09:33 PM','16',' ',' ',' ')


I don't get what keeps going wrong. Any Ideas?

http://www.xcalliber.com - The Future of Boards

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 05 January 2005 :  22:10:14  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
Again... Remove the single quotes from around the field values that are numeric in the database.

This applies to all sql strings, number fields, no apostrophe

Check this out

-Stim

Edited by - Da_Stimulator on 05 January 2005 22:24:09
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 06 January 2005 :  01:47:45  Show Profile  Visit Gremlin's Homepage
Please avoid double posting your problems.


Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

DarkDrift
Junior Member

USA
126 Posts

Posted - 06 January 2005 :  10:09:05  Show Profile  Visit DarkDrift's Homepage  Send DarkDrift an AOL message
sry... i thought it would be fine since it was another problem... BTW problem was i needed my_conn.execute(strsql)

http://www.xcalliber.com - The Future of Boards
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07