ASP - Syntax Error In Update Statement espero alguien me pueda ayudar... No puedo detectar cual puede ser el error, cuando intento realizar un Update de una pagina .asp me trae el siguiente error:
"Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers"
Les dejo aqui el codigo de la pagina Update.asp
<!--#include File='Login_Check.asp'-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>EducationPM -- Updated information</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF" bgproperties="fixed" background="ibmbackgroundsuave.bmp">
<!--webbot bot="PurpleText" PREVIEW="-Importante- Si modifica esta área de resultados de base de datos con el Asistente para resultados de bases de datos, el editor de bases de datos no funcionará. Si abre accidentalmente este asistente, haga clic en Cancelar sin volver a generar el área de resultados de base de datos." -->
<p style="margin-top: 0; margin-bottom: 0">
<img SRC="ServiceManagement.bmp" width="600" height="95">
<table width="84%" align="left">
<td width="50%" align="right">
<table align="left">
<td align="center">
<p style="margin-top: 0; margin-bottom: 0">
<font color="#000080"> | </font>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br clear=all>
<br clear=all>
<br clear=all>
<!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="ticketsgenerales" 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="UPDATE EducationPM SET EmployeeName = '::EmployeeName::' , ProjectManagementOrientation = '::ProjectManagementOrientation::' , ProjectManagementFoundational = '::ProjectManagementFoundational::' , LeadershipInAProjectTeamEnvironment = '::LeadershipInAProjectTeamEnvironment::' , UnderstandingWWPMM = '::UnderstandingWWPMM::' , CreatingAndTailoringProjectManagementSystem = '::CreatingAndTailoringProjectManagementSystem::' , GettingStartedManagingProjectsInIBM-RPM = '::GettingStartedManagingProjectsInIBM-RPM::' , CreatingAndManagingProjectSchedulesInIBM-RPM = '::CreatingAndManagingProjectSchedulesInIBM-RPM::' , ManagingScopeExceptionsInIBM-RPM = '::ManagingScopeExceptionsInIBM-RPM::' , ContractingForProjectManagers-SelfPaced = '::ContractingForProjectManagers-SelfPaced::' , FinancialManagementForProjectManagers-DistributedLearning = '::FinancialManagementForProjectManagers-DistributedLearning::' , AppliedProjectManagementInaCustomerEnvironment = '::AppliedProjectManagementInaCustomerEnvironment: :' , ProjectManagementBasicEducationStatus = '::ProjectManagementBasicEducationStatus::' , PM-SelfAssessmentExam = '::PM-SelfAssessmentExam::' , Review*****periencedPMs = '::Review*****periencedPMs::' , ExperiencedPM-Equivalency = '::ExperiencedPM-Equivalency::' WHERE (Clave = ::Clave::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="EmployeeName=&ProjectManagementOrie ntation=&ProjectManagementFoundational=&Leadership InAProjectTeamEnvironment=&UnderstandingWWPMM=&Cre atingAndTailoringProjectManagementSystem=&GettingS tartedManagingProjectsInIBM-RPM=&CreatingAndManagingProjectSchedulesInIBM-RPM=&ManagingScopeExceptionsInIBM-RPM=&ContractingForProjectManagers-SelfPaced=&FinancialManagementForProjectManagers-DistributedLearning=&AppliedProjectManagementInaCu stomerEnvironment=&ProjectManagementBasicEducation Status=&PM-SelfAssessmentExam=&Review*****periencedPMs=&Exper iencedPM-Equivalency=&Clave=0" s-NoRecordsFound="Request updated" i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Éste es el principio de una región de resultados de base de datos.</font></td></tr></table>" startspan --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>El componente Resultados de base de datos de esta página no puede mostrar el contenido de la base de datos. La página debe tener un nombre de archivo que termine en '.asp', y el Web debe encontrarse en un servidor que admita páginas Active Server.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE EducationPM SET EmployeeName = '::EmployeeName::' , ProjectManagementOrientation = '::ProjectManagementOrientation::' , ProjectManagementFoundational = '::ProjectManagementFoundational::' , LeadershipInAProjectTeamEnvironment = '::LeadershipInAProjectTeamEnvironment::' , UnderstandingWWPMM = '::UnderstandingWWPMM::' , CreatingAndTailoringProjectManagementSystem = '::CreatingAndTailoringProjectManagementSystem::' , GettingStartedManagingProjectsInIBM-RPM = '::GettingStartedManagingProjectsInIBM-RPM::' , CreatingAndManagingProjectSchedulesInIBM-RPM = '::CreatingAndManagingProjectSchedulesInIBM-RPM::' , ManagingScopeExceptionsInIBM-RPM = '::ManagingScopeExceptionsInIBM-RPM::' , ContractingForProjectManagers-SelfPaced = '::ContractingForProjectManagers-SelfPaced::' , FinancialManagementForProjectManagers-DistributedLearning = '::FinancialManagementForProjectManagers-DistributedLearning::' , AppliedProjectManagementInaCustomerEnvironment = '::AppliedProjectManagementInaCustomerEnvironment: :' , ProjectManagementBasicEducationStatus = '::ProjectManagementBasicEducationStatus::' , PM-SelfAssessmentExam = '::PM-SelfAssessmentExam::' , Review*****periencedPMs = '::Review*****periencedPMs::' , ExperiencedPM-Equivalency = '::ExperiencedPM-Equivalency::' WHERE (Clave = ::Clave::)"
fp_sDefault="EmployeeName=&ProjectManagementOrient ation=&ProjectManagementFoundational=&LeadershipIn AProjectTeamEnvironment=&UnderstandingWWPMM=&Creat ingAndTailoringProjectManagementSystem=&GettingSta rtedManagingProjectsInIBM-RPM=&CreatingAndManagingProjectSchedulesInIBM-RPM=&ManagingScopeExceptionsInIBM-RPM=&ContractingForProjectManagers-SelfPaced=&FinancialManagementForProjectManagers-DistributedLearning=&AppliedProjectManagementInaCu stomerEnvironment=&ProjectManagementBasicEducation Status=&PM-SelfAssessmentExam=&Review*****periencedPMs=&Exper iencedPM-Equivalency=&Clave=0"
fp_sNoRecords="Information updated"
fp_sDataConn="ticketsgenerales"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=17
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<table>
<tr>
<td>
<form>
<input type=button value="Close screen" onClick="javascript:window.close();">
</form>
</td>
<td>
</form>
</td>
</tr>
</table>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-CheckSum="7380" -->
<p><!--webbot bot="PurpleText" PREVIEW="Esta es una consulta UPDATE." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">Éste es el final de una región de resultados de base de datos.</font></td></tr></table>" startspan --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->
</body>
</html>
Lo hice 5 veces, tomando los nombres de la DB de Access por si era un error de tipeo, pero ya no se que puede ser.
Muchas gracias!!!!!!!!
