|
lovduv -> *solved* Syntax error (missing operator) in query expression (11/9/2005 4:47:28)
|
I am using the white paper from Microsoft that Spooky suggests for image upload:
How to Send Form Results
to a Database and
an E-mail Address and
Use the File Upload Component
Simultaneously
I am trying to set up the database to accept uploaded images. I have set up the pages according to the white paper and everything works except for the actual writing of the record to the database. The image is saved in a folder on my site and an e-mail is sent when I hit submit and go to the page Process2.asp I get this DRW error:
Database Results Error
Description: Syntax error (missing operator) in query expression 'any@anyemail.com'.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
Where any@anyemail.com is the e-mail field.
This is the form http://www.missyandross.com/form.htm
This is the code from the Process2.asp page:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="INSERT INTO Results (Name, Email, Comments, File) VALUES (::Name::, ::Email::, ::Comments::, ::File::)"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="form"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&name=202&email=202&Comments=203&File=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<p>
<%=FP_FieldVal(fp_rs,"ID")%></p>
<p>
<%=FP_FieldVal(fp_rs,"name")%></p>
<p>
<%=FP_FieldVal(fp_rs,"email")%></p>
<p>
<%=FP_FieldVal(fp_rs,"Comments")%></p>
<p>
<%=FP_FieldVal(fp_rs,"File")%></p>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</body></html>
|
|
|
|
