|    
			
				01/10/2010, 11:00
			
			
			  | 
  |   |  |  |  Fecha de Ingreso: julio-2010 
						Mensajes: 35
					 Antigüedad: 15 años, 3 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
     |