BIBLIOGRAPHY
>List all the bibliography
ERROR: eseguiqueryAdvancedZoom.002 [Microsoft][Driver ODBC Microsoft Access] Uso di Null non valido ERROR NUMBER: -2147217913
Query: Select distinct [Title], img as [img£££], [Authors], [Year] as [_Year], [Pubblication type], [Abstract], [Reference],
[WEB Reference],
iif(len([WEB Reference2])>0,
iif(instr([WEB Reference2],'researchgate')>0, chr(60)+'img src='+chr(39)+'/spring2/images/sn2_ResearchGate.png'+chr(39)+' border=0'+chr(62)+' '+[WEB Reference2], [WEB Reference2])
) as [WEB Reference 2],
iif(val([Bibliografia-vista-eng].[PDF Reading permission])<=0 and (not(val([Bibliografia-vista-eng].[Reading permission])<=0)),[Internal reference]+' (pdf)'+'#/repository_2010/repository_show_document.asp?xmlsrcrepository=/repository_2010/repository.xml&lingua=en¶metro=pdon&p_query=p0&Protocollo_Documento='+[Internal reference]+'#','') as [Repository reference PDF],
iif(val([Bibliografia-vista-eng].[Reading permission])<=0,[Internal reference]+'#/repository_2010/repository_show_document.asp?xmlsrcrepository=/repository_2010/repository.xml&lingua=en¶metro=veryshort&p_query=p0&Protocollo_Documento='+[Internal reference]+'#','') as [Repository reference],
iif(len([Slides internal reference]),[Slides internal reference]+'#/repository_2010/repository_show_document.asp?xmlsrcrepository=/repository_2010/repository.xml&lingua=en¶metro=veryshort&p_query=p0&Protocollo_Documento='+[Slides internal reference]+'#','') as [Related Slides],
iif(val([Bibliografia-vista-eng].[PDF Reading permission])<=0,[Downloadable PDF file],'') as [PDF Directly downloadable file],
iif(val([Bibliografia-vista-eng].[Reading permission])<=0,[Downloadable file],'') as [Directly downloadable file],
[ResearchUnitName]+'#/tecnopolo/imple/listezoom.asp?lingua=en&xmlsrclista=/tecnopolo/imple/unitadiricerca-lista.xml&rtdr=/tecnopolo/&k='+cstr([ResearchUnitName])+'#' as [Research unit],
[Keywords], [Bibliografia-vista-eng].[LastUpdate], [id££], ResearchUnitName as [ResearchUnitName££]
,[Bibliografia-vista-eng].[id££] as [IDCAMPO],
[impact factor], ReferenzaUnivoca
FROM [Bibliografia-vista-eng]
WHERE ((val([Bibliografia-vista-eng].[PDF Reading permission]) <= 0) or (val( [Bibliografia-vista-eng].[Reading permission]) <= 0)) AND ( ([id££] = 513) );
|