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());
}
