W
William McFarland
Using FrontPage 2003
WIndows XP
Office 2003
Website on a Windows 2003 Server
Receiving the following error when trying to add a record to a database
using INSERT INTO in a custom query.
Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.
Query in Database results file that receives POST is
INSERT INTO Disbursements ( GranteeNum, ContractNum )
VALUES ( = '::GranteeNum::', = '::ContractNum::' )
FP will only accept the code when I replace the "::" with "%%". When I look
at query after saving file, FP re-writes, replacing "%%" with "::" but then
reports errors in the query.
GranteeNum and ContractNum are the textbox names from the form posting. Data
is entered into the textbox as text through a database results wizard form.
Can anyone assist with the correct syntax?
WIndows XP
Office 2003
Website on a Windows 2003 Server
Receiving the following error when trying to add a record to a database
using INSERT INTO in a custom query.
Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.
Query in Database results file that receives POST is
INSERT INTO Disbursements ( GranteeNum, ContractNum )
VALUES ( = '::GranteeNum::', = '::ContractNum::' )
FP will only accept the code when I replace the "::" with "%%". When I look
at query after saving file, FP re-writes, replacing "%%" with "::" but then
reports errors in the query.
GranteeNum and ContractNum are the textbox names from the form posting. Data
is entered into the textbox as text through a database results wizard form.
Can anyone assist with the correct syntax?