def getCDTracksXArtist(sessid): artist = ewd.getSessionValue('cdArtist',sessid) if artist == '': return "You must specify an artist" mdb = ewd.mdb_connect('rob','1234567','127.0.0.1') query="SELECT Name FROM itunes where Artist = '" + artist + "'" items=mdb.select('itunes',query) noOfItems = len(items) if noOfItems == 0: return "No matches found" ewd.createiWDMenuFromDictionary(items,"Name","TrackList",sessid) return ""
def getCDTracksXArtist(sessid): artist = ewd.getSessionValue('cdArtist', sessid) if artist == '': return "You must specify an artist" mdb = ewd.mdb_connect('rob', '1234567', '127.0.0.1') query = "SELECT Name FROM itunes where Artist = '" + artist + "'" items = mdb.select('itunes', query) noOfItems = len(items) if noOfItems == 0: return "No matches found" ewd.createiWDMenuFromDictionary(items, "Name", "TrackList", sessid) return ""
def getItemList(sessid): selectedNo = ewd.getRequestValue('menuItemNo',sessid) if selectedNo != "": domainName = ewd.getSelectediWDMenuValue("domainList",sessid) ewd.setSessionValue("domainName",domainName,sessid) else: domainName = ewd.getSessionValue("domainName",sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') query="select itemName() from " + domainName items=mdb.select(domainName,query) ewd.deleteFromSession("itemList",sessid) if items != []: ewd.createiWDMenuFromDictionary(items,"itemName()","itemList",sessid) return ""
def getItemList(sessid): selectedNo = ewd.getRequestValue('menuItemNo', sessid) if selectedNo != "": domainName = ewd.getSelectediWDMenuValue("domainList", sessid) ewd.setSessionValue("domainName", domainName, sessid) else: domainName = ewd.getSessionValue("domainName", sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') query = "select itemName() from " + domainName items = mdb.select(domainName, query) ewd.deleteFromSession("itemList", sessid) if items != []: ewd.createiWDMenuFromDictionary(items, "itemName()", "itemList", sessid) return ""