Irina’s Weblog

Ðàçãëåæäàõ èíôîðìàöèÿ çà êíèãà íà ñàéòà íà çàïàäíî èçäàòåëñòâî. Çà äà ïîëó÷à ïîâå÷å èíôîðìàöèÿ çà êíèãàòà òðÿáâàøå äà ïðîñëåäÿ âðúçêàòà “To order this title, and for more information, click here“. Ïîïàäíàõ íà ñòðàíèöà çà èçáîð íà ðåãèîí. È ñëó÷àéíî çàáåëÿçàõ ñèòíèÿ øðèôò â ãîðíèÿ ëÿâ úãúë íà åêðàíà :

‘sup’ and i.code is not null) and s.imprint is not null order by i.priority –>

Õì, SQL êîä, wft?! Âåäíàãà äàäîõ “View source” è íà êàêâî ìèñëèòå ïîïàäíàõ :

<!–connection timeout:60–><– strSourceCode : –><–NEW SHOP.ASP Provider=SQLOLEDB.1; Initial Catalog=*Commerce; Data Source=195.***.***.***; Extended Properties=”UID=bhcom_user; PWD=******”; Use Procedure for Prepare=1; Auto Translate=True; Packet Size=4096; Workstation ID=GB02VW2020ELR27; set Encryption for Data=False; Tag with column collation when possible=False –><–0:–><-select distinct i.imprint as bookimprint, s.imprint,/*s.code,*/ subsitename, folder, subsitecode, s.subsitedescription, mainimprint, i.priority, fulfillmentuk, (select siteprefix from smart_fulfillment sf where sf.fulfillmentsystem = s.fulfillmentuk and sf.country = ‘United Kingdom’) as UKsiteprefix, fulfillmentus, (select siteprefix from smart_fulfillment sf where sf.fulfillmentsystem = s.fulfillmentus and sf.country = ‘United States’) as Ussiteprefix from vw_subsite s full outer join vw_isbnclassification i on i.code = s.code where 0 = 0 and (isbn = ‘024080****’ and ((i.imprint = s.imprint) or (i.imprint like ‘********%’) or (s.imprint like ‘******%’) or (i.imprint like ‘******* *****’)) and s.fordisplay = 1 and s.subsitetypecode <> ‘sup’ and i.code is not null) and s.imprint is not null order by i.priority –>< br />

Åñòåñòâåíî çâåçäè÷êèòå ñà îò ìåí 😉

Äðàñíàõ èì åäèí “feedback” ñ òàçè èíôîðìàöèÿ, äà âèäèì êîãà ùå ðåàãèðàò!

Ï.Ñ. Ñóòðèíòà êàòî ïîãëåäíàõ, âå÷å íå ìîæåøå äà ñå ñòèãíå äî òàçè ñòðàíèöà. Ðåøåíèåòî : Ïðè êëèêàíå íà âðúçêàòà çà ïîâå÷å èíôîðìàöèÿ è ïîðú÷êà îòèâàø äèðåêòíî íà ñòðàíèöà, êîÿòî èìà â URL-òî ñëåäíèÿ ïàðàìåòúð : “country=United+Kingdom” …