Search DaniWeb - recipes

Deduct food recipes from the main inventroy? 10 Years Ago by savedlema … my inventory is left) The code is to allow these recipes of Salad to be changed/deleted/some others added into… in code as something that won't change forever.(More recipes can be added in the future) Does anyone has an… Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema … the food/menu, I want the appropriate amount of its recipes to be substracted from the total that is available in… makefile compile gsl and numerical recipes 13 Years Ago by habib_parisa … have a large C code which uses routines from numerical recipes and GNU scientific library. It needs a compilation compilation because… Food Recipes 10 Years Ago by rajuahmed How i can i buy web hosting on my blogsite? My site: [Food Recipes](http://www.foodrecipesall.blogspot.com/) Recipes 11 Years Ago by abdulhamid1 How will i use java in the blog? Re: Recipes 11 Years Ago by JamesCherrill I don't understand your post. Can you explain in more detail what you want to know? Re: Recipes 11 Years Ago by jalpesh_007 which functionality you want to use..? explain all the things Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema What I have so far: My tables are: 1.Inventory (item,amount) 2. Menu (menu_name) 3. Salad (recipe, amount) Other tables will be added for each menu, just like I did for salad. (I may have table for Rice, Soda e.t.c) Now, when I click Salad, since it has two values (recipe for it and amount), how then can I subtract these (recipe & amount)… Re: Deduct food recipes from the main inventroy? 10 Years Ago by Begginnerdev You will have to get the current value, subtract, then update to the newest value. This is assuming your amount colum in as decimal value. For Example: Try Dim da As New OleDbDataAdapter(New OleDbCommand("SELECT * FROM Inventory WHERE Item='" & sItemType & "'", myConnection))… Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Thanks Begginerdev! Something:Please can you explain to me what will be done in line 2 of your solution? Dim da As New OleDbDataAdapter(New OleDbCommand("SELECT * FROM Inventory WHERE Item='" & sItemType & "'", myConnection)) What will this `WHERE Item='" & sItemType & "'", myConnection` do?… Re: Deduct food recipes from the main inventroy? 10 Years Ago by Begginnerdev The select statment retreives the record from your database table. For example: Inventory Item | Amount garlic,10.21 onion,50.13 water,200.23 "SELECT * FROM Inventory WHERE Item='garlic'" 'Would return garlic,10.21 As for the myConnection, you will need a connection to the database to retreive the … Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Thank you. But, I think we are using different connectors? This is how I had to change your code to suite the connector I use: con.Open() Try Dim da As New MySqlDataAdapter(New MySqlCommand("SELECT * FROM Inventory WHERE Item='" & Me.ComboBox1.Text & "'", … Re: Deduct food recipes from the main inventroy? 10 Years Ago by Begginnerdev dblAmountToSubtract will be a variable declared as double that will hold the value to subtract from your total. For Example: Dim dblAmountToSubtract As Double = Cdbl(txtAmountUsed.Text) 'This pulls the amount from a text box on a form. For the command, you can simply replace: da.UpdateCommand = New OleDb.OleDbCommandBuilder(… Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Thank you, now it works; it subtract & update one record in the inventory table. BUT, What I want to do is, consider the inventory table in your solution : Inventory table: Item | Amount garlic, 10.21 onion, 50.13 water, 200.23 Now, let's say to make 1 Salad you will use 5of garlic, 5 of onion and 5 … Re: Deduct food recipes from the main inventroy? 10 Years Ago by GeekPlease You must have settings in your program where you can update the recipe of each food. You can't expect your program to know that thing. Hope this helps Re: Deduct food recipes from the main inventroy? 10 Years Ago by ddanbe I hope these are just example ingredients for a salad. Water in a salad? :-) Another note: The offial symbol for milliliters is not **mil** but **ml** The offial symbol for grams is not **gm** but **g** Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Yes ddanbe, these are just examples, if it works I can substitute that with something useful. No problem with measurements units too for now, I just want it to do the subtraction and I will care about that in the future. Any idea with my case? Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Note: It seems like you guys did not understand my scenario clearly. I will add this note; Now, let's say to make 1 Salad you will use 5of garlic, 5 of onion and 5 of water. So, when I click on "Salad", I want all these (5garlic,5onion,5water) to be deducted from their store in the inventory table. (Not deduct just one) This composition … Re: Deduct food recipes from the main inventroy? 10 Years Ago by Begginnerdev Place the code in a sub procedure and pass in the item type for the action: Private Sub DeductFromTotal(ByVal sItemType As String,ByVal dblAmountToSubtract As Double) Try Dim da As New MySqlDataAdapter(New MySqlCommand("SELECT * FROM Inventory WHERE Item='" & Me.ComboBox1.Text & "'", New … Re: Deduct food recipes from the main inventroy? 10 Years Ago by Begginnerdev You could take that string returned, split and parse it to what you need. For example: Private Function ParseIngredients(ByVal strIngredients As String) As Dictionary(Of String, Double) Try strIngredients = "(Water (20), Salt(30))" 'When passing the value in delete this, this is just for example. Dim… Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Begginerdev, Thank you again for taking your time to help. But I must admit, almost everything in that function is new to me! > Just pass in the ingredients string and accept the output dictionary.> > Iterating through the dictionary can be done as follows: Can you please instruct how to do what you said in the quote? I don't mean to … Re: Deduct food recipes from the main inventroy? 10 Years Ago by tinstaafl Dictionaries are simpler than they sound. Basically a dictionary is a list that instead of accessing individual items by their index number each index is given a name. Thus, just as, a list (MyList(3)) returns the value associated with that index, a dictionary (MyDictionary("vegetable oil")) returns the value associated with that index… Re: Deduct food recipes from the main inventroy? 10 Years Ago by Begginnerdev Not knowing =/= Laziness. It is a good thing that you are willing to learn! Re: Deduct food recipes from the main inventroy? 10 Years Ago by savedlema Solved. I solved it by just few lines of a SELECT statement that has other SELECT in it. Thank you all, you are great! Re: Deduct food recipes from the main inventroy? 10 Years Ago by tinstaafl Please remember to mark this solved thanks Re: makefile compile gsl and numerical recipes 13 Years Ago by griswolf What is the result you want? Is it a library? executable? Something else? Whatever it is, you put that on the left of the colon, a list of the required prerequisite "things" (object files, libraries etc) on the right, and how to put them together to make your result on the next line, tab indented. For instance, lines 25 and 26 correctly … Re: Food Recipes 10 Years Ago by dany12 You have to choose a web hosting company the lowest price with a lot of feature is ipage. The top 3 companies from my point of view are: Hostgator Ipage Dreamhost Hope this helps, if not post a reply and i will get back to you. Selectively Printing only Certain Divs (javascript/css question) 17 Years Ago by Spycat … give the ability for visitors to print out INDIVIDUAL recipes contained upon the page. I thought I had it…xhtml"> <head> <title>Chocolate Recipes : Brownies, Cakes, Candy, Cookies, Pies, and Miscellaneous Categories&…>Chocolate Fudge</h3> <table class="recipes"> <tr> <td> … copy noshow 9 Years Ago by L-D … <?php Welcome!<br /> Interested in recipes, 'eh? There's nothing quite as satisfying as … home and have been grabbing <br /> recipes from newspapers, magazines, etc. since then. The Internet…gt; ?> Welcome!<br /> Interested in recipes, 'eh? There's nothing quite as satisfying as following… My Approach to Automating Grocery Shopping 2 Years Ago by dubadub … # About Cooklang I thought, *what if I store my recipes in Markdown-like text files and tag ingredients with @ symbol…list in the browser. I migrated a bunch of recipes from scattered sources into Cooklang format and stored them on… thinking about creating a mapping between ingredients from my recipes and links to them at my shop's website.…