SQL DB Results Wizard Error

J

Jeff

HELP! What does '::name::' mean? the :: is unfamiliar to me!

Error:

Database Results Wizard Error
Unable to find operator in query string. Query string currently is
INSERT INTO Results (Name, Email, Comments, File) VALUES
('::Name::', '::Email::', '::Comments::', '::File::')

Code:
<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;Comments=&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="7327"
--><!--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>
 
S

Stefan B Rusynko

The DBR uses :: as delimiters for field names

--




| HELP! What does '::name::' mean? the :: is unfamiliar to me!
|
| Error:
|
| Database Results Wizard Error
| Unable to find operator in query string. Query string currently is
| INSERT INTO Results (Name, Email, Comments, File) VALUES
| ('::Name::', '::Email::', '::Comments::', '::File::')
|
| Code:
| <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;Comments=&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="7327"
| --><!--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>
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to understand this code... 3
any ideas why I can update one table in my database but not the other? 2
@ my wits end 1
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
SELECT DISTINCT Query not working 4
DataBase results Error continued 1
Database Results Error 1
FP Database help needed... 6

Top