From: wally g. <wa...@gm...> - 2007-07-31 13:42:47
|
Just a quick note to point out that the Voyager driver has SQL table references specific to Villanova hardcoded in Voyager.php. Around line 53, for example: public function getHolding($id) { $sql = "select ITEM.ON_RESERVE, ITEM.ITEM_SEQUENCE_NUMBER, ITEM_STATUS_DESC as status, LOCATION.LOCATION_DISPLAY_NAME as "from NOVADB.BIB_ITEM, NOVADB.ITEM, NOVADB.ITEM_STATUS_TYPE, NOVADB.ITEM_STATUS, NOVADB.LOCATION, NOVADB.MFHD_ITEM "where BIB_ITEM.BIB_ID = '$id' " . "and BIB_ITEM.ITEM_ID = ITEM.ITEM_ID " . "and ITEM.ITEM_ID = ITEM_STATUS.ITEM_ID " . "and ITEM_STATUS.ITEM_STATUS = ITEM_STATUS_TYPE.ITEM_STATUS_TYPE " . "and LOCATION.LOCATION_ID = ITEM.PERM_LOCATION " . "and CIRC_TRANSACTIONS.ITEM_ID (+)= ITEM.ITEM_ID " . "and MFHD_ITEM.ITEM_ID = ITEM.ITEM_ID " . "and MFHD_MASTER.MFHD_ID = MFHD_ITEM.MFHD_ID"; Where you see NOVADB.xxxxx it will have to be changed for your Voyager institution (e.g., here at Mason it's GMUDB.xxxxx). -- Wally Wally Grotophorst Digital Programs & Systems George Mason University |
From: Andrew N. <and...@vi...> - 2007-07-31 15:02:42
|
Wally, thanks for pointing this out. Your message didn't get posted on the= listserv because you are not registered, or at the time you sent this you = were not registered. I will try to fix this soon. Thanks Andrew > -----Original Message----- > From: wally grotophorst [mailto:wa...@gm...] > Sent: Tuesday, July 31, 2007 9:43 AM > To: vuf...@li... > Subject: SQL values hardcoded in Voyager driver > > Just a quick note to point out that the Voyager driver has SQL table > references specific to Villanova hardcoded in Voyager.php. Around > line 53, > for example: > > public function getHolding($id) > { > $sql =3D "select ITEM.ON_RESERVE, ITEM.ITEM_SEQUENCE_NUMBER, > ITEM_STATUS_DESC as status, LOCATION.LOCATION_DISPLAY_NAME as > "from NOVADB.BIB_ITEM, NOVADB.ITEM, > NOVADB.ITEM_STATUS_TYPE, NOVADB.ITEM_STATUS, NOVADB.LOCATION, > NOVADB.MFHD_ITEM > "where BIB_ITEM.BIB_ID =3D '$id' " . > "and BIB_ITEM.ITEM_ID =3D ITEM.ITEM_ID " . > "and ITEM.ITEM_ID =3D ITEM_STATUS.ITEM_ID " . > "and ITEM_STATUS.ITEM_STATUS =3D > ITEM_STATUS_TYPE.ITEM_STATUS_TYPE " . > "and LOCATION.LOCATION_ID =3D ITEM.PERM_LOCATION " . > "and CIRC_TRANSACTIONS.ITEM_ID (+)=3D ITEM.ITEM_ID " . > "and MFHD_ITEM.ITEM_ID =3D ITEM.ITEM_ID " . > "and MFHD_MASTER.MFHD_ID =3D MFHD_ITEM.MFHD_ID"; > > Where you see NOVADB.xxxxx it will have to be changed for your Voyager > institution (e.g., here at Mason it's GMUDB.xxxxx). > > -- Wally > > Wally Grotophorst > Digital Programs & Systems > George Mason University > > > |