By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,281 Members | 1,933 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,281 IT Pros & Developers. It's quick & easy.

Help with Syntax on Webpage

P: n/a
I am getting

Unable to find operator in query string. Query string currently is
INSERT INTO Results (Name,Email,Comments,File) VALUES
('::Name::','::Email::','::Comments::','::File::')
Here is the ASP Code..From Frontpage.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body>

<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes
s-dataconnection="form" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE"
i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns
s-criteria s-order s-sql="INSERT INTO Results
(Name,Email,Comments,File) VALUES
('::Name::','::Email::','::Comments::','::File::') "
b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Name=&amp;amp;Email=&amp;amp;Commen ts=&amp;amp;File="
s-norecordsfound="Your Profile has been accepted." i-maxrecords="256"
i-groupsize="0" botid="0" u-dblib="../../_fpclass/fpdblib.inc"
u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="BODY" preview="&lt;table
border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. The page must be fetched from a web server with a web browser
to display correctly; the current web is stored on your local disk or
network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE"
--><!--#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="Name=&Email=&Comments=&File="
fp_sNoRecords="Your Profile has been accepted."
fp_sDataConn="form"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="44694"
--><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064"
--></body></html>

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
what happens if you do something like
Response.Write s-sql

do you have something like an apostrophe inside your text? If so, the
database engine will interpret that as a delimiter and will screw up
your insert statement. You probably need to double all the single
quotes inside your text boxes before writing them to the database.

and BTW, it would be a huge help if you would cut out all the pieces of
the code/web page that are irrelevant to the question....

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.