01/10/2010, 11:00
|
| | Fecha de Ingreso: julio-2010
Mensajes: 35
Antigüedad: 14 años, 6 meses Puntos: 0 | |
Respuesta: Busqueda Multiple en .asp <%
poo = Request.Form ("texto")
sta = Request.Form ("nombre")
'opcional
set rs = Server.CreateObject("ADODB.Recordset")
sql = " select * from Plans "
If(poo <>"") then
sql2 = sql2 & " WHERE Pool LIKE '%" & poo & "%' "
end if
If(sta <>"") then
sql2 = sql2 & " WHERE Status LIKE '%" & sta & "%' "
end if
If(poo <>"" and sta <>"") then
sql2 = sql2 & " WHERE Status LIKE '%" & sta & "%' and Pool LIKE '%" & poo & "%' "
end if
'concateno variables
sql = sql & sql2
'espero que tu coneccion sea buena.
dbfile=Server.MapPath("fpdb/ticketsgenerales.mdb")
Set OBJdbConnection=Server.CreateObject("ADODB.Connect ion")
OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbfile
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open Sql, OBJdbConnection, 1, 1%>
Ahora busca de a 1 campo o campos en blancos para traer todo.
Error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driver does not support the requested properties.
/PlanManagementTool/search.asp, line 57 |