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<font face='Verdana'></font id='Verdana'><font color=blue></font id=blue>

Visit my home page
www.cancuncoral.com

Please, only post your question once.

Thanks,

Martha Graham

who are you

Visit my home page
www.cancuncoral.com