hello there i have a problem.......
im using dmx 6.1 and on page 1 im sendig the variable idlink then on page 2 i have command that deletes from the acces database de record, i keep recibing this error and i cant figure out why:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/arquitectonica/admin/paginas/test/2.asp, line 16



this is the command and line 16 is the commandl.Execute()

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../../../Connections/arquitectonica.asp" -->
<%

if(Request.QueryString("idlink" <> "" then Command1__x = Request.QueryString("idlink"

%>
<%

set Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_arquitectonica_STRING
Command1.CommandText = "DELETE FROM links WHERE id = '" + Replace(Command1__x, "'", "''" + "'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>

thanks for your help


Visit my home page
www.cancuncoral.com