<%
String id_rec = request.getParameter("id_rec");
String chk_la="I.TAG='" + lang + "' ";
if(id_rec!=null){
chk_la = chk_la + " AND R.ID_RECETA=" + id_rec;
}
%>
SELECT R.ID_RECETA,R.ID_IDIOMA,R.NOMBRE ,R.DESCRIPCION ,R.INGREDIENTES,R.PREPARACION ,R.FOTO1 ,R.FOTO2,R.ESTADO
FROM RECETA R, IDIOMA I WHERE I.ID_IDIOMA=R.ID_IDIOMA AND R.ESTADO='ES001' AND <%=chk_la%>
ORDER BY ID_RECETA DESC
 |
| |
|
|
|
| |
|
|
|
| |
|
 "> |
|
|
|
|
<%
if(lang.compareTo("ES")==0){
out.println("Ingredientes");
}
if(lang.compareTo("EN")==0){
out.println("Measures");
}
if(lang.compareTo("FR")==0){
out.println("Measures");
}
%>
|
|
| |
|
|
| |
|
<%
if(lang.compareTo("ES")==0){
out.println("Preparación");
}
if(lang.compareTo("EN")==0){
out.println("Method");
}
if(lang.compareTo("FR")==0){
out.println("Method");
}
%>
|
|
| |
|
|
| |
| |
<%
if(lang.compareTo("FR")==0){
%>
|
Appréciez cette idée
délicieuse...
|
|
<%
}
if(lang.compareTo("ES")==0){
%>
|
Disfrute de esta deliciosa idea...
|
|
<%
}
if(lang.compareTo("EN")==0){
%>
|
Enjoy this delicious idea...
|
|
<%
}
%>
| |
|
|
| |
<%
if(lang.compareTo("FR")==0){
%>
|
Choisissez une recette |
<%
}
if(lang.compareTo("ES")==0){
%>
|
Escoja una receta |
<%
}
if(lang.compareTo("EN")==0){
%>
|
Choose a recipe |
<%
}
%>
<%
chk_la="I.TAG='" + lang + "' ";
int rango = 4;
String q_recetas = "SELECT R.ID_RECETA,R.ID_IDIOMA,R.NOMBRE,R.DESCRIPCION,R.INGREDIENTES,R.PREPARACION,R.FOTO1,R.FOTO2,R.ESTADO FROM RECETA R, IDIOMA I WHERE I.ID_IDIOMA=R.ID_IDIOMA AND R.ESTADO='ES001' AND " + chk_la + "ORDER BY ID_RECETA";
%>
<%=q_recetas%>
|
"
class="texto_recetas">
|
| |
|
| |
<%
int n=0;
if(DSRecDis.getRowSet().isFetchComplete()==false){
Integer nx = new Integer (DSRecDis.getRowSet().next().getAttribute("ID_RECETA").toString());
n = nx.intValue();
}
%>
|
<%
if(n>0){
%>
<%
}
%>
|
select R.FOTO2 FROM RECETA R, IDIOMA I WHERE I.ID_IDIOMA=R.ID_IDIOMA
AND R.ESTADO='ES001' AND R.FOTO2 IS NOT NULL AND <%=chk_la%> order
by dbms_random.value
 ">
|
|
|
