

<!-- 

Public Function Exec_SQL_sel_Marca(ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT * FROM Marca WHERE Id=" & intId
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	Set Exec_SQL_sel_Marca = objRs
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function


Public Function Exec_SQL_sel_MarcaPorAsociado(ByVal intIdAsociado, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT * FROM Asociado_Marca AM, Marca M WHERE M.Id=AM.Marca AND AM.Asociado=" & intIdAsociado & " ORDER BY M.Descripcion "
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	Set Exec_SQL_sel_MarcaPorAsociado = objRs
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_upd_Marca(ByVal intId, ByVal strTitulo, ByVal strDescripcion, ByVal intValoracion, ByVal intCategoria, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	'strSQL = " UPDATE Marca SET " 
	'strSQL = strSQL & " 	Titulo = '" & strTitulo &"',"
	'strSQL = strSQL & " 	Descripcion = '" & strDescripcion & "', "
	'strSQL = strSQL & " 	Valoracion = " & intValoracion &", "	
	'strSQL = strSQL & " 	CategoriaATE = " & intCategoria &" "	
	'strSQL = strSQL & " Where Id = " & intId
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_ins_Marca(ByVal strTitulo, ByVal strDescripcion, ByVal intValoracion, ByVal intCategoria, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	'strSQL = " INSERT INTO Marca (Titulo, Descripcion, Valoracion, CategoriaATE)  " 
	'strSQL = strSQL & " 	VALUES "	
	'strSQL = strSQL & " ('" & strTitulo & "','" & strDescripcion & "'," & intValoracion & "," & intCategoria & ")"	

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_ins_MarcaAsociado(ByVal intAsociado, ByVal intMarca, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " INSERT INTO Asociado_Marca (Asociado, Marca)  " 
	strSQL = strSQL & " 	VALUES "	
	strSQL = strSQL & " (" & intAsociado & "," & intMarca & ")"	

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_ins_OtraMarcaAsociado(ByVal intAsociado, ByVal intMarca, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " INSERT INTO Asociado_OtraMarca (Asociado, Marca)  " 
	strSQL = strSQL & " 	VALUES "	
	strSQL = strSQL & " (" & intAsociado & "," & intMarca & ")"	

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_del_Marca (ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Marca WHERE Id = " & intId 
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function


Public Function Exec_SQL_del_MarcaPorAsociadoMarca (ByVal intId, ByVal intIdMarca, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Asociado_Marca WHERE Asociado = " & intId & " AND Marca = " & intIdMarca 

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_del_MarcaPorAsociado (ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Asociado_Marca WHERE Asociado = " & intId 

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_del_MarcasOficialNoSeleccionadas (ByVal intId, ByVal strMarcas, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Asociado_Marca WHERE Asociado = " & intId & " AND Marca not in (" & strMarcas & ")"

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function



Public Function Exec_SQL_del_OtraMarcaPorAsociado (ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Asociado_OtraMarca WHERE Asociado = " & intId 
							
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_sel_ExisteMarcaOficial(ByVal intAsociado, ByVal intMarca, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT count(*) FROM Asociado_Marca WHERE Asociado=" & intAsociado & " AND Marca=" & intMarca
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	if objRs(0)>0 then
		Exec_SQL_sel_ExisteMarcaOficial = true
	else
		Exec_SQL_sel_ExisteMarcaOficial = false
	end if
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_sel_ExisteOtraMarca(ByVal intAsociado, ByVal intMarca, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT count(*) FROM Asociado_OtraMarca WHERE Asociado=" & intAsociado & " AND Marca=" & intMarca
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	if objRs(0)>0 then
		Exec_SQL_sel_ExisteOtraMarca = true
	else
		Exec_SQL_sel_ExisteOtraMarca = false
	end if
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

 -->



<!-- 

Public Function Exec_SQL_sel_Producto(ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT * FROM Producto WHERE Id=" & intId
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	Set Exec_SQL_sel_Producto = objRs
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_sel_ProductoPorAsociado(ByVal intIdAsociado, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT * FROM Producto WHERE Asociado=" & intIdAsociado & " ORDER BY Descripcion "
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	Set Exec_SQL_sel_ProductoPorAsociado = objRs
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_ins_ProductoAsociado(ByVal intAsociado, ByVal intProducto, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " INSERT INTO Asociado_Producto (Asociado, Producto)  " 
	strSQL = strSQL & " 	VALUES "	
	strSQL = strSQL & " (" & intAsociado & "," & intProducto & ")"	

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_del_Producto (ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Producto WHERE Id = " & intId 
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_del_ProductoPorAsociado (ByVal intId, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")

	strSQL = " DELETE FROM Asociado_Producto WHERE Asociado = " & intId 

	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
		.Execute()
	End With

	Set objCmd = Nothing
	
	If Err <> 0 and Err <> "0" Then

		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function

Public Function Exec_SQL_sel_ExisteProducto(ByVal intAsociado, ByVal intProducto, ByRef lngRetVal, ByRef strErrDesc, ByVal objCn)
	Dim strSQL 
	Dim objRs 

	On Error Resume Next
	Set objCmd  = Server.CreateObject("ADODB.Command")
	Set objRs  = Server.CreateObject("ADODB.Recordset")
	strSQL = " SELECT count(*) FROM Asociado_Producto WHERE Asociado=" & intAsociado & " AND Producto=" & intProducto
	
	With objCmd
		.Commandtext = strSQL
		Set .ActiveConnection = objCn
	End With
	With objRs
		.CursorLocation = adUseClient
		.Open objCmd, , adOpenStatic, adLockReadOnly
		Set .ActiveConnection = Nothing
	End With
	if objRs(0)>0 then
		Exec_SQL_sel_ExisteProducto = true
	else
		Exec_SQL_sel_ExisteProducto = false
	end if
	Set objCmd = Nothing

	If Err <> 0 and Err <> "0" Then
		
		lngRetVal = Err.Number
		strErrDesc = Err.Description
		'response.redirect "../Admin/Error.asp?pmId="&wkInserta
	End If
End Function


 -->


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
	<title>ACEMA - Página Principal</title>
	<link href="css/default.css" rel="stylesheet" type="text/css">
	<script language="JavaScript" src="rutinas/images.js"></script>
	<SCRIPT LANGUAGE="JavaScript">
		function buscar() {
			
			document.formulario.pmBuscar.value='1';
			document.formulario.submit();
		}
	</script>
</head>

<body leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0">

		
	<table width="760"  height="7" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#4EBBE4">
		<tr><td></td></tr>
	</table>
	
	<!-- ********** LOGOS Y PATROCINIO ********** -->
	
	<table width="760" border="0" align="center" cellpadding="0" cellspacing="4">
		
		<tr>
			<td width="350"><a href="default.asp"><img src="imagenes/logo.gif" alt="ACEMA" width="80" height="67" hspace="20" vspace="2" border="0"></a></td>
			<td align="right" valign="bottom">
				&nbsp;<script src="rutinas/flash_carrusel.js"></script>&nbsp;
				<br>
				
					desconectado <img src="imagenes/boton_rojo_2.gif" alt="" width="9" height="9" border="0" align="absmiddle">
				
			</td>
			<!-- 
			<td valign="middle">Proyecto patrocinado por:</td>
			<td valign="bottom" width="132"><img src="imagenes/cab_CAM.gif" alt="" width="132" height="67" hspace="5" vspace="5" border="0"></td>
			<td valign="bottom" width="80"><img src="imagenes/cab_madrid_innova.gif" alt="" width="80" height="67" hspace="5" vspace="5" border="0"></td>
			 -->
			<!-- 
			<form action="privada/confirmacion.asp" name="formulario" id="formulario" target="_blank">
			<td align="right" width="200">
				<table width="200" border="0" cellspacing="2" cellpadding="2" align="right">
					<tr><td>&nbsp;</td><td><img src="imagenes/tit_area_asociados.gif" alt="" width="88" height="14" border="0"></td></tr>
					<tr>
						<td>Usuario:</td>
						<td><input type="text" name="pmUsuario" size="13" maxlength="16"></td><td></td>
						
					</tr>
					<tr>
						<td>Contraseña:</td>
						<td><input type="Password" name="pmPassword" size="13" maxlength="16"></td><td> <a href="javascript:document.formulario.submit();">aceptar</a></td>
					</tr>
				
				</table>
			</td> 
			</form> -->
		</tr>
		
	</table>
	
	
	
	<!-- ********** MENU ********** -->
	<table width="760" border="0" align="center" cellpadding="0" cellspacing="0"><!-- </table> background="imagenes/menu_lateral_izq.gif"> -->
		<tr align="center">
			
			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="80" align="center"><a href="" class="enlacemenu">Inicio</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>

			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="80" align="center"><a href="tienda_buscador.asp" class="enlacemenu">Buscador</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>
			
			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="180" align="center"><a href="quees.asp" class="enlacemenu">La Asociación (ACEMA)</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>
			
			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="90" align="center"><a href="contacta.asp" class="enlacemenu">Contactar</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>
			
			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="90" align="center"><a href="asociados.asp" class="enlacemenu">Asociados</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>
			
			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="70" align="center"><a href="http://www.satelectrodomesticos.com" target="_blank" class="enlacemenu">SAT</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>
			
			<td width="5"><img src="imagenes/menu_lateral_izq.gif" alt="" width="5" height="26" border="0"></td>
			<td background="imagenes/px_menu.gif" width="100" align="center"><a href="links.asp" class="enlacemenu">Enlaces</a></td>
			<td><img src="imagenes/menu_lateral_der.gif" alt="" width="5" height="26" border="0"></td>

		</tr>
	</table>

	
	
	<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
		<tr><td height="5"></td></tr>
		<tr bgcolor="#F56F18"><td valign="middle" align="center">
		<img src="imagenes/bannerInterno.jpg" alt="" width="760" height="96" border="0">
		</td></tr>
	</table>
	<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
		<tr><td height="5"></td></tr>
	</table>
	
	<table width="760" border="1" style="border-collapse:collapse" bordercolor="#ff6600" cellspacing="0" cellpadding="2" align="center">
		<tr>
			<!-- ********** ASOCIADOS ********** -->
			<td width="30%" valign="top">
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr><td><div class="cabecera_bienvenida">Servicios</div></td></tr>
				</table>
								<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr><td style="padding-left: 5px; font-weight: bold;"><a href="documentos/ORGANIGRAMA.pdf" target="_blank"><strong style="font-size:12px">Organigrama</strong></a></td></tr>
					<tr><td style="padding-left: 5px; font-weight: bold; font-size:12px">Asesorías</td></tr>
					<tr><td style="padding-left: 15px">
						<table width="100%" border="0" cellspacing="2" cellpadding="0" align="center">
							<tr><td><a href="servicios_asesoria_fiscal.asp">Fiscal</a></td></tr>
							<tr><td><a href="servicios_asesoria_juridica.asp">Jurídica</a></td></tr>
							<tr><td><a href="servicios_asesoria_laboral.asp">Laboral</a></td></tr>
							<tr><td><a href="servicios_asesoria_medio_ambiente.asp">Medio Ambiente</a></td></tr>
							<tr><td><a href="servicios_asesoria_prevencion_riesgos.asp">Prevención de Riesgos</a></td></tr>
							<tr><td><a href="servicios_asesoria_busqueda_profesionales.asp">Búsqueda de profesionales</a></td></tr>
						</table>
					</td></tr>
					
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=1"><strong style="font-size:12px">Noticias</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=2"><strong style="font-size:12px">Ayudas y Subvenciones</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=3"><strong style="font-size:12px">Convenios</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=4"><strong style="font-size:12px">Actas de Acema</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=5"><strong style="font-size:12px">Formación</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=6"><strong style="font-size:12px">Legislación</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=7"><strong style="font-size:12px">Estudios</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=8"><strong style="font-size:12px">Calendario</strong></a></td></tr>
						
						<tr><td style="padding-left: 5px; font-weight: bold;"><a href="contenido_listado.asp?pmtipo=9"><strong style="font-size:12px">Reciclado</strong></a></td></tr>
						
					
				</table>
				

			</td>
			<!-- ********** NOTICIAS ********** -->
			

			<td width="50%" valign="top" bgcolor="#EAEAEA">
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr><td><div class="cabecera_bienvenida">Noticias</div></td></tr>
				</table>
				<table width="100%" border="0" cellspacing="2" cellpadding="0" align="center">
					<tr><td height="5"></td></tr>
					
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>16 de Enero 2012</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=159">ACEMA CONVOCA EL II PREMIO BENITO HERRERAS</a><br>
							Acema abre el plazo para recibir propuestas de los grupos y asociaciones que quieran presentar candidatos a dicho premio.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>22 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=158">APERTURA DOMINGOS Y FESTIVOS 2012 EN CASTILLA Y LEÓN</a><br>
							Calendario de los domingos y festivos con apertura autorizada en Castilla y León para 2012.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>19 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=157">EMPIEZA EL PLAN RENOVE DE ELECTRODOMESTICOS EN CASTILLA LA MANCHA</a><br>
							Hoy día 19 de diciembre de 2011, se inicia el Plan Renove de Electrodomésticos en Castilla- La Mancha.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>19 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=148">CALENDARIO DE FIESTAS LABORALES 2012</a><br>
							Según publican los Boletines Oficiales de Madrid, Galicia, Castilla-La Mancha y Castilla y Léon.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>15 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=156">ENTREGA DEL PREMIO BENITO HERRERAS</a><br>
							El Excmo. Sr. D. Percival Manglano, Consejero de Economía y Hacienda de la Comunidad de Madrid, ha hecho entrega del premio a título póstumo a D. Benito Herreras Sevillano.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>2 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=155">INICIO PLAN RENOVE DE ELECTRODOMÉSTICOS CASTILLA LA MANCHA 2011.</a><br>
							El Diario Oficial de Castilla La Mancha , publica el inicio del Plan Renove de electrodomésticos en Castilla La Mancha por la que se convocan ayudas.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>1 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=154">FIRMA CONVENIO ECOLEC</a><br>
							ACEMA y  la  Fundación ECOLEC han suscrito un nuevo convenio de colaboración para la gestión de los residuos de grandes electrodomésticos que se generan en el desarrollo de nuestra actividad. 
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>1 de Diciembre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=153">NUEVO ETIQUETADO ENERGÉTICO DE ELECTRODOMÉSTICOS</a><br>
							Con carácter obligatorio desde el pasado 30 de Noviembre.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>24 de Octubre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=151">REGLAMENTO DE INSTALACIONES TÉRMICAS EN LOS EDIFICIOS</a><br>
							Documentación sobre el Reglamento de Instalaciones Térmicas en los Edificios.

		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>19 de Octubre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=150">FIRMA CONVENIO AVALMADRID</a><br>
							Avalmadrid y Acema han firmado hoy un convenio que facilitará la financiación a todos los socios de esta asociación.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
						<tr>
							<td valign="top" width="10"><img src="imagenes/separador_noticias.gif" alt="" width="7" height="7" hspace="4" vspace="4" border="0"></td>
							<td>
							
								<strong>17 de Octubre 2011</strong>
														
							<br>
							<a href="contenido_detalle.asp?pmid=149">ENTREGA PREMIO BENITO HERRERAS</a><br>
							La Junta Directiva de Acema decidió por unanimidad, conceder el “Premio Benito Herreras” en su 1ª Edición y a título póstumo a D. Benito Herreras Sevillano.
		
						</td></tr>
						<tr><td height="5"></td></tr>
						
				</table>
			</td>
			
			<!-- ********** BUSCADOR DE TIENDAS ********** -->
			<td valign="top">
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr><td><div class="cabecera_bienvenida">Plan Renove</div></td></tr>
				</table>
				
				<table width="100%" border="0" cellspacing="2" cellpadding="2" align="center">
					<tr valign="top">
						<td><img src="imagenes/bnd_cm.gif" alt="Comunidad de Madrid" width="23" height="16" border="0"></td>
						<td><a href="http://www.acemaelec.org/renove2011" target="_blank">Plan Renove <strong>2011</strong><br>Comunidad de Madrid</a></td>
					</tr>
					<tr><td height="5"></td></tr>
					<tr valign="top">
						<td><img src="imagenes/bnd_ga.gif" alt="Galicia" width="23" height="16" border="0"></td>
						<td><a href="documentos/BASES_REGULADORAS_GALICIA.pdf" target="_blank">Plan Renove <strong>2011</strong><br>Galicia</a></td>
					</tr>
					<tr><td height="5"></td></tr>
					<tr valign="top">
						<td><img src="imagenes/bnd_clm.gif" alt="Comunidad de Castilla-La Mancha" width="23" height="16" border="0"></td>
						<td><a href="documentos/ORDEN_30_11_2011.pdf" target="_blank">Plan Renove <strong>2011</strong><br>Comunidad de Castilla-La Mancha</a></td>
					</tr>
					<tr valign="top">
						<td><img src="imagenes/bnd_cl.gif" alt="Comunidad de Castilla y León" width="23" height="16" border="0"></td>
						<td><a href="http://www.acemaelec.org/privada/Multimedia/20102011_cl.pdf" target="_blank">Plan Renove 2010<br>Comunidad de Castilla y León</a></td>
					</tr>
					<!-- <tr valign="top">
						<td><img src="imagenes/bnd_ex.gif" alt="Extremadura" width="23" height="16" border="0"></td>
						<td><a href="http://www.industriaextremadura.com/index.php?id=38" target="_blank">Plan Renove 2008<br>Extremadura</a></td>
					</tr> -->
				</table>	
				<br>			
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr><td><div class="cabecera_bienvenida">SAT Oficiales</div></td></tr>
				</table>			
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr>
						<td><img src="imagenes/logo_ate.gif" alt="sat electrodomésticos" border="0"></td>
						<td>Servicios de Asistencia Técnica Oficiales.</td>
					</tr>
					<tr><td align="center" colspan="2"><a href="http://www.satelectrodomesticos.com" target="_blank">Web SAT electrodomésticos</a></td></tr>
					<tr><td align="center" colspan="2"><a href="http://www.satelectrodomesticos.com" target="_blank"><img src="imagenes/web_sat_150.gif" alt="sat electrodomésticos" width="150" height="83" vspace="0" border="0" style="border: 1 solid #F96302;"></a></td></tr>
				</table>
				<br>
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<tr><td><div class="cabecera_bienvenida">Tiendas virtuales</div></td></tr>
				</table>
				<table width="100%" border="0" cellspacing="5" cellpadding="0" align="center">
					<form name="formulario" action="tienda_buscador.asp" method="post" onSubmit="return false">
					
					<tr><td valign="top">
						<table cellspacing="2" cellpadding="2" align="center">
							<tr><td colspan="2">
								<select name="pmProducto" class="combo">
									<option value="">--- Todos los productos ---</option>
									
										<option value="8">Aire Acondicionado</option>
										
										<option value="7">Calefaccion Indu./Domés.</option>
										
										<option value="4">Cámaras</option>
										
										<option value="14">Cocinas/Hornos</option>
										
										<option value="12">Frigoríficos/Congeladores</option>
										
										<option value="9">Informática</option>
										
										<option value="2">Lavadoras y Secadoras</option>
										
										<option value="15">Lavavajillas</option>
										
										<option value="13">Microondas</option>
										
										<option value="1">Pequeños Electrodomést.</option>
										
										<option value="6">Sonido</option>
										
										<option value="10">Telecomunicaciones</option>
										
										<option value="3">Televisión</option>
										
										<option value="5">Video/DVD</option>
										
									
								</select>
							</td></tr>				
							<tr><td colspan="2">
								<select name="pmMarca" class="combo">
									<option value="">--- Todas las marcas ---</option>
									
										<option value="1">ADMIRAL</option>
										
										<option value="105">AEG</option>
										
										<option value="2">AIWA</option>
										
										<option value="3">AKAI</option>
										
										<option value="5">AMANA</option>
										
										<option value="132">ANSONIC</option>
										
										<option value="9">AR SYSTEM</option>
										
										<option value="143">ARDEM</option>
										
										<option value="106">ARISTON</option>
										
										<option value="167">ASKO</option>
										
										<option value="7">ASPES</option>
										
										<option value="10">BALAY</option>
										
										<option value="130">BASIC LINE</option>
										
										<option value="111">BAUKNECHT</option>
										
										<option value="141">BEKO</option>
										
										<option value="11">BLACK&DECKER</option>
										
										<option value="12">BLAUPUNKT </option>
										
										<option value="168">BLOMBERG</option>
										
										<option value="13">BLUESKY</option>
										
										<option value="102">BOSCH</option>
										
										<option value="151">BOSE</option>
										
										<option value="14">BRAUN</option>
										
										<option value="142">BRU</option>
										
										<option value="137">CAMPINGAS</option>
										
										<option value="124">CANAL PLUS</option>
										
										<option value="125">CANAL SATÉL. DIGITAL</option>
										
										<option value="15">CANDY</option>
										
										<option value="16">CANON</option>
										
										<option value="17">CARRIER</option>
										
										<option value="101">CATA</option>
										
										<option value="20">CLARIVOX</option>
										
										<option value="112">COINTRA</option>
										
										<option value="138">COLEMAN</option>
										
										<option value="120">COOK-LINE</option>
										
										<option value="107">CORBERO</option>
										
										<option value="169">CROLLS</option>
										
										<option value="22">DAEWOO</option>
										
										<option value="126">DAIKIN</option>
										
										<option value="155">DE DIETRICH</option>
										
										<option value="170">DEKSIA</option>
										
										<option value="150">DELONGUI</option>
										
										<option value="162">DEMOKA</option>
										
										<option value="152">DENON</option>
										
										<option value="139">Di 4</option>
										
										<option value="25">EDESA</option>
										
										<option value="26">ELBE</option>
										
										<option value="27">ELECTROLUX</option>
										
										<option value="164">EUROTECH</option>
										
										<option value="28">FAGOR</option>
										
										<option value="29">FERROLI</option>
										
										<option value="30">FIRSTLINE</option>
										
										<option value="119">FULGOR</option>
										
										<option value="171">GAGGENAU</option>
										
										<option value="31">GENERAL ELECTRIC</option>
										
										<option value="32">GOLDSTART</option>
										
										<option value="144">GORENJE</option>
										
										<option value="156">GRANDIN</option>
										
										<option value="34">GRUNDIG</option>
										
										<option value="36">GRUPO CANDY</option>
										
										<option value="145">HAIER</option>
										
										<option value="37">HITACHI</option>
										
										<option value="38">HOOVER</option>
										
										<option value="39">IBERNA</option>
										
										<option value="103">IGNIS</option>
										
										<option value="108">INDESIT</option>
										
										<option value="178">INTER</option>
										
										<option value="40">ITT</option>
										
										<option value="41">JATA</option>
										
										<option value="158">JUNKERS</option>
										
										<option value="42">JVC</option>
										
										<option value="157">KELVINATOR</option>
										
										<option value="46">KENMORE</option>
										
										<option value="48">KENWOOD</option>
										
										<option value="154">KRUPS</option>
										
										<option value="172">KUPPERSBUSCH</option>
										
										<option value="49">LG ELECTRONICS</option>
										
										<option value="50">LIEBHERR</option>
										
										<option value="52">LOEWE</option>
										
										<option value="115">LYNX</option>
										
										<option value="161">MAGEFESA</option>
										
										<option value="109">MAYTAG</option>
										
										<option value="53">MELVOX</option>
										
										<option value="149">MENEGHETTI</option>
										
										<option value="99">MEPAMSA</option>
										
										<option value="54">MIELE</option>
										
										<option value="55">MITSUBISHI</option>
										
										<option value="56">MOULINEX</option>
										
										<option value="173">NEFF</option>
										
										<option value="110">NEWPOL</option>
										
										<option value="159">NODOR</option>
										
										<option value="59">NOKIA</option>
										
										<option value="61">ORION</option>
										
										<option value="62">OTSEIN</option>
										
										<option value="64">PANASONIC</option>
										
										<option value="128">PANDO</option>
										
										<option value="65">PHILCO</option>
										
										<option value="66">PHILIPS</option>
										
										<option value="67">PIONEER</option>
										
										<option value="140">POLTI</option>
										
										<option value="121">RADIOTONE</option>
										
										<option value="70">ROCA</option>
										
										<option value="163">ROMMER</option>
										
										<option value="71">ROSIERE</option>
										
										<option value="72">ROWENTA</option>
										
										<option value="100">S&P</option>
										
										<option value="131">SAIVOD</option>
										
										<option value="73">SAMSUNG</option>
										
										<option value="74">SANYO</option>
										
										<option value="75">SAUNIER DUVAL</option>
										
										<option value="98">SCHNEIDER</option>
										
										<option value="177">SCHOLTES</option>
										
										<option value="134">SEG</option>
										
										<option value="76">SEGA</option>
										
										<option value="78">SHARP</option>
										
										<option value="79">SIEMENS</option>
										
										<option value="174">SMEG</option>
										
										<option value="81">SOLAC</option>
										
										<option value="82">SONITRON</option>
										
										<option value="83">SONY</option>
										
										<option value="175">SUPERSER</option>
										
										<option value="85">TAURUS</option>
										
										<option value="148">TEBA</option>
										
										<option value="87">TECHNICS </option>
										
										<option value="165">TECNOGAS</option>
										
										<option value="88">TEFAL</option>
										
										<option value="84">TEKA</option>
										
										<option value="123">TELETECH</option>
										
										<option value="146">TERMOZETA</option>
										
										<option value="89">THOMSON</option>
										
										<option value="127">THOR</option>
										
										<option value="117">TORNADO</option>
										
										<option value="90">TOSHIBA</option>
										
										<option value="91">UFESA</option>
										
										<option value="160">VAILLANT</option>
										
										<option value="166">VANGUARD</option>
										
										<option value="94">VESTEL</option>
										
										<option value="122">WELTSTAR</option>
										
										<option value="95">WESTINGHOUSE</option>
										
										<option value="96">WHIRLPOOL</option>
										
										<option value="176">WOSSLER</option>
										
										<option value="153">YAMAHA</option>
										
										<option value="116">ZANUSSI</option>
										
								</select>
							</td></tr>
							<tr><td colspan="2"><input type="text" name="pmCP" value=" --- CP ---" size="10" maxlength="10" onFocus="pmCP.value=''"><A HREF="Javascript:buscar();"><img src="imagenes/buscar.gif" alt="" align="absmiddle" hspace="25" vspace="0" width="64" height="16" border="0"></A></td></tr>
						<input type="hidden" name="pmBuscar" value="0">
						</table>
						<br><br>
					</td></tr>
					</form>
				</table>

						</td>
		</tr>
	</table>
	
	<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
		<tr><td height="5"></td></tr>
	</table>
	<table width="760" style="border: 1 solid #ff6600;" height="20" border="0" align="center" cellpadding="5" cellspacing="0">
		<tr bgcolor="#4EBBE4">
			<td align="left" valign="middle" class="pie">
				&nbsp;<strong>ACEMA</strong> - Asociación de Comerciantes de Electrodomésticos, Muebles de Cocina y Autónomos<!--  - C/ Abtao nº 11-1º c. 28007 Madrid - Tlfno. 91 551 32 06 - Fax. 91 501 22 40  -->
			</td>
			<td valign="middle" class="pie" align="right">Web creada por <a href="http://www.tatum.es" target="_blank" class="enlacepie">Tatum</a>&nbsp;</td>
		</tr>
	</table>

	<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
		<tr>
			<td valign="middle" align="right">Proyecto patrocinado por:&nbsp;</td>
			<td valign="top" width="132"><img src="imagenes/cab_CAM.gif" alt="Consejería de Economía e Innovación Tecnológica de la Comunidad de Madrid" width="132" height="67" hspace="5" vspace="5" border="0"></td>
			<td valign="top" width="80"><img src="imagenes/cab_madrid_innova.gif" alt="Madrid Innova" width="80" height="67" hspace="5" vspace="5" border="0"></td>
		</tr>
	</table>	

</body>
</html>