public long getItemID(string item_name) { //Check item name against current entries db.CreateCommand("Select item_id from collar_data_entry where item_name=" + SQLSpecific.QVal(item_name)); db.SetConnection(); return(db.ScalarIntx()); }
public long getItemID(string item_name) { //Check item name against current entries db.SetConnection(); string sSQL = "Select item_id from collar_data_entry where item_name='" + item_name + "'"; return(db.ScalarIntx(sSQL)); }
public int GetCycleCount(long mid) { string sSQL = "SELECT COUNT(id) FROM cycles Where mid=" + mid; db.CreateCommand(sSQL); db.SetConnection(); return(db.ScalarIntx()); }