Ven ustedes algun error de sitaxis en esta expresión:
sSQL = ""
sSQL = sSQL & "INSERT INTO Xe (ItemOwner, cTitle, turism, lifeEstile, surfing, realEstate, "
sSQL = sSQL & " loadging, ecology, cEmail, cPhone, site, link, description, date) "
sSQL = sSQL & " VALUES ( "
sSQL = sSQL & SQLVal(valRS.Fields("ID")) & ", "
sSQL = sSQL & SQLStr(scTitle) & ", "
sSQL = sSQL & request.form("Tourism") & ", "
sSQL = sSQL & request.form("lifeEstile") & ", "
sSQL = sSQL & request.form("Surfing") & ", "
sSQL = sSQL & request.form("RealEstate") & ", "
sSQL = sSQL & request.form("Loadging") & ", "
sSQL = sSQL & request.form("Ecology") & ", "
sSQL = sSQL & SQLStr(scEmail) & ", "
sSQL = sSQL & SQLStr(scPhone) & ", "
sSQL = sSQL & SQLStr(sSite) & ", "
sSQL = sSQL & SQLStr(slink) & ", "
sSQL = sSQL & SQLStr(sDescription) & ", "
sSQL = sSQL & SQLDate(dCloseDate) & " )"
Response.Write "<P>" & sSQL & "<BR>"
GobjConnect.Execute(sSQL)
Al dar el response write me escribe:
INSERT INTO Xe (ItemOwner, cTitle, turism, lifeEstile, surfing, realEstate, loadging, ecology, cEmail, cPhone, site, link, description, date) VALUES ( 12, 'asdfasdfa', true, true, true, true, true, true, 'asfda', 'asdfa', NULL, NULL, 'asdfasdf', #16/12/2002 08:34# )
El campo Item Owner es numerico
Ctitle es texto
Turism , lifeEstile, surfing, realEstate, loadging, ecology son yes/no
cEmail , cPhone, site, link, description , son texto
date es date/time
Pero me da este error:
· Tipo de error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis en la instrucción INSERT INTO.
/asp/postitem2.asp, line 94