FlyerTalk Forums - View Single Post - Swiss TravelClub website is on........
View Single Post
Old Jan 2, 2003, 12:31 pm
  #11  
digisup
 
Join Date: Oct 2000
Location: Annandale
Posts: 164
they are still working on it I guess:

I got this on the SNBA site. The priority for which the system was build shows a little: '...AIRLINE = 3...')

Would 'CI_STATUS >= 40' mean: gold and above ?

SELECT C.CI_ID, C.CI_CURL_ID, C.CI_LOGIN, C.CI_AUTHOR, C.AIRLINE, C.CI_TYPE_ID, C.BORDER, C.DISPLAY_TEMPLATE, C.SMALL_PIC, C.HORIZONTAL_LINE, C.FULL_WIDTH, C.LARGE_PIC, C.THUMBNAIL_PIC, C.CI_NAV_LINK_INTERNAL, C.CI_NAV_LINK_EXTERNAL, C.CI_NAV_LINK_EXTERNAL_TARGET, C.DYNAMIC_DISPLAY_TEMPLATE, L.LANG_ID, L.CI_TITLE, L.CI_BODY, L.CI_LEAD, L.CI_INDEX_TITLE, L.CI_BROWSER_TITLE FROM FF_CI C, FF_CI_LANG_DATA L WHERE C.CI_CURL_ID = 262 AND C.AIRLINE = 3 AND C.CI_STATUS >= 40 AND C.CI_TL1 = 1 AND L.CI_ID = C.CI_ID AND L.LANG_ID = 1
digisup is offline