Lista de Resultados - :
Lista de Resultados - :

%res_cmt1a% %res_cmt2a% ") hits_here = decode(pseudo_hit, true, hits_here, IntArith(hits_here, "+", 1)) ti_isbn = SingleStringSQL(format("SELECT isn FROM titleisns WHERE titleno = %titleno% AND repeat_seq = 1")) syndetics_url1 = decode(SingleStringSQL("SELECT isntp FROM titleisns WHERE titleno = :titleno AND repeat_seq = 1", titleno), "ISSN", fandr(syndetics_url1, "isbn", "issn"), syndetics_url1) el1 = format("%syndetics_url1%%ti_isbn%%syndetics_url2%") el2 = format("%syndetics_url1%%ti_isbn%%syndetics_url3%") enrichlnk_link = decode(ti_isbn, "", " ", format("%syndetics_alt%")) format("") title = SingleStringSQL( concat("select ", hitlist_title_display, " from titles t where t.titleno = ", titleno )) title2 = SingleStringSQL( concat("select ", hitlist_title_display2, " from titles t where t.titleno = ", titleno )) Exec(display_alertme) format(" ") mediaicon = SingleStringSQL(format("select nvl(me.webview_icon, m.webview_icon) from titles t, media me, mediatps m where titleno = %titleno% and upper(t.medium) = me.medium(+) da" >

Hay Resultados.

%respage%") item_selection = GetCol("wrsi_selected") odd = decode(odd, "odd", "even", "odd") item_checked = decode(item_selection, "1", "checked", "") format("%hitno%.%cit_cmt1a%%cit_cmt2a%%enrichlnk_link%%title%%title2%%alertme_text%
< Ant.
Saltar página:
Sig. >
< Ant.
Saltar página:
Sig. >
and upper(t.mediatp) = m.mediatp")) media = SingleStringSQL(format("select %t_hitlist_media% from titles t, media me, mediatps m where titleno = %titleno% and upper(t.medium) = me.medium(+) and upper(t.mediatp) = m.mediatp")) mediaicon = decode(mediaicon, "none", "", "NONE", "", mediaicon) media = decode(mediaicon, "", media, format("%media%")) format("%media%") "" oid=titleno format("") run "check_basket_icon.glu" "" "" hl_end " "
/ARG 2/ select i.wrsi_number1 titleno, i.wrsi_itemno itemno, i.wrsi_selected wrsi_selected from web_result_set_item i where i.wrsi_wrsh_id = and i.wrsi_itemno between decode(1, 1, 0, (1 -1) * 20 + 1) and 1 * 20 order by i.wrsi_itemno
Call stack:
xif(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: falta una expresión "
CGI error (version=Header: glue.c 3.0.9): (in file
run from text<\n run "multi_hitl...>run from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecRecs()
/ARG 1/ first_page = IntArith(page, "-", 10) last_page = IntArith(page, "+", 10) show_page = decode(IntArith(GetCol(1), "<", first_page), "true", "N", "Y") show_page = decode(show_page, "N", "N", decode(IntArith(GetCol(1), ">", last_page), "true", "N", "Y")) decode(show_page, "N", "", " ") decode(show_page, "N", "", decode(page, GetCol(1), GetCol(1), concat("", GetCol(1), "")))
/ARG 2/ select (wrsi_itemno-1) / 20 +1 from web_result_set_item where mod(wrsi_itemno, 20) = 1 and wrsi_wrsh_id = order by wrsi_itemno
Call stack:
xif(...)
xif(...)
xif(...)
Failed to run query: "ORA-00936: falta una expresión "
CGI error (version=Header: glue.c 3.0.9): (in filerun from file
run from text<\n run "multi_hitl...>run from file
run from text<\n""\n...>
run from text<\n cnt = Singl...>run from file)
Last GLUE procedure call was ExecPLSQL1()
/ARG 1/begin update web_result_set_header set wrsh_info = 'search_label=['||':'||'] '|| 'style=['||''||'] '|| 'entry=['||''||'] '|| 'nh=decode(nh, [], ['||'20'||'], nh) '|| 'filtered=['||'FALSE'||'] '|| 'save_page=['||'1'||'] '|| 'force_domain=['||'title'||'] '|| 'tnh=['||''||']' where wrsh_id = ; commit; end;
Call stack:
xif(...)
xif(...)
xif(...)
Failed to call PLSQL : "ORA-06550: línea 12, columna 35: PL/SQL: ORA-00936: falta una expresión ORA-065"