<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?action=history&amp;feed=atom&amp;title=Rlegaspi_Week_6</id>
		<title>Rlegaspi Week 6 - Revision history</title>
		<link rel="self" type="application/atom+xml" href="https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?action=history&amp;feed=atom&amp;title=Rlegaspi_Week_6"/>
		<link rel="alternate" type="text/html" href="https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Rlegaspi_Week_6&amp;action=history"/>
		<updated>2026-06-07T18:13:58Z</updated>
		<subtitle>Revision history for this page on the wiki</subtitle>
		<generator>MediaWiki 1.25.1</generator>

	<entry>
		<id>https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Rlegaspi_Week_6&amp;diff=2491&amp;oldid=prev</id>
		<title>Rlegaspi: Finished questions to answer question, just need to proofread and finish electronic lab notebook.</title>
		<link rel="alternate" type="text/html" href="https://xmlpipedb.lmucs.io/biodb/fall2015/index.php?title=Rlegaspi_Week_6&amp;diff=2491&amp;oldid=prev"/>
				<updated>2015-10-15T03:22:16Z</updated>
		
		<summary type="html">&lt;p&gt;Finished questions to answer question, just need to proofread and finish electronic lab notebook.&lt;/p&gt;
&lt;table class=&#039;diff diff-contentalign-left&#039;&gt;
				&lt;col class=&#039;diff-marker&#039; /&gt;
				&lt;col class=&#039;diff-content&#039; /&gt;
				&lt;col class=&#039;diff-marker&#039; /&gt;
				&lt;col class=&#039;diff-content&#039; /&gt;
				&lt;tr style=&#039;vertical-align: top;&#039;&gt;
				&lt;td colspan=&#039;2&#039; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&#039;2&#039; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Revision as of 03:22, 15 October 2015&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;L87&quot; &gt;Line 87:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 87:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* b)&amp;lt;code&amp;gt;select drugname from drugproduct where drugname like &amp;#039;%ESTROL&amp;#039;;&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* b)&amp;lt;code&amp;gt;select drugname from drugproduct where drugname like &amp;#039;%ESTROL&amp;#039;;&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Produce a table listing all of the known values for the &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; column in the &amp;#039;&amp;#039;application&amp;#039;&amp;#039; table and how many &amp;#039;&amp;#039;application&amp;#039;&amp;#039; records there are of each. (&amp;#039;&amp;#039;Side note:&amp;#039;&amp;#039; The &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; codes are explained in the &amp;#039;&amp;#039;ReviewClass_Lookup.txt&amp;#039;&amp;#039; file, in case you’re interested.)&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Produce a table listing all of the known values for the &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; column in the &amp;#039;&amp;#039;application&amp;#039;&amp;#039; table and how many &amp;#039;&amp;#039;application&amp;#039;&amp;#039; records there are of each. (&amp;#039;&amp;#039;Side note:&amp;#039;&amp;#039; The &amp;#039;&amp;#039;therapeutic_potential&amp;#039;&amp;#039; codes are explained in the &amp;#039;&amp;#039;ReviewClass_Lookup.txt&amp;#039;&amp;#039; file, in case you’re interested.)&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;−&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#*&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;a) [[Image:Therapeutic Potential.png]]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;#* b)&amp;lt;code&amp;gt;select ther_potential, count(*) from drugapplication group by ther_potential order by count desc&amp;lt;/code&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Produce a table listing all of the known values for the &amp;#039;&amp;#039;chemical_type&amp;#039;&amp;#039; column in the &amp;#039;&amp;#039;application&amp;#039;&amp;#039; table and how many &amp;#039;&amp;#039;application&amp;#039;&amp;#039; records there are of each. (&amp;#039;&amp;#039;Side note:&amp;#039;&amp;#039; The &amp;#039;&amp;#039;chemical_type&amp;#039;&amp;#039; codes are explained in the &amp;#039;&amp;#039;ChemTypeLookup.txt&amp;#039;&amp;#039; file, in case you’re interested.)&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Produce a table listing all of the known values for the &amp;#039;&amp;#039;chemical_type&amp;#039;&amp;#039; column in the &amp;#039;&amp;#039;application&amp;#039;&amp;#039; table and how many &amp;#039;&amp;#039;application&amp;#039;&amp;#039; records there are of each. (&amp;#039;&amp;#039;Side note:&amp;#039;&amp;#039; The &amp;#039;&amp;#039;chemical_type&amp;#039;&amp;#039; codes are explained in the &amp;#039;&amp;#039;ChemTypeLookup.txt&amp;#039;&amp;#039; file, in case you’re interested.)&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;−&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#*&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;a) [[Image: Chemical Type.png]]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;#* b)&amp;lt;code&amp;gt;select chemical_type, count(*) from drugapplication group by chemical_type order by count desc&amp;lt;/code&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# What are the names of the drug products that are sponsored (&amp;#039;&amp;#039;sponsor applicant&amp;#039;&amp;#039; column) by &amp;lt;code&amp;gt;MERCK&amp;lt;/code&amp;gt;?&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# What are the names of the drug products that are sponsored (&amp;#039;&amp;#039;sponsor applicant&amp;#039;&amp;#039; column) by &amp;lt;code&amp;gt;MERCK&amp;lt;/code&amp;gt;?&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;−&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#*&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;a) &amp;#039;&amp;#039;&amp;#039;DECADRON, HUMORSOL, NEO-HYDELTRASOL, PRINIVIL, MAXALT-MLT, HYDROCORTONE, PERIACTIN, PROPECIA, PROSCAR, CLINORIL, PRINZIDE, ELSPAR, ALDOMET, ALDORIL D30, EMEND, DIUPRES-500, NEODECADRON, ALDOCLOR-250, MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER, ARAMINE, TIAMATE, BLOCADREN, CANCIDAS, CHIBROXIN, CORTONE, PEPCID, TRUSOPT, REDISOL, VIOXX, FLOROPRYL, ALPHAREDISOL, DECADRON-LA, MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER, PEPCID RPD, NOROXIN, ZOCOR, LERITINE, DECADERM, DOLOBID, MANNITOL 25%, DECADRON W/ XYLOCAINE, ALDORIL D50, TIMOLIDE 10-25, CYCLAINE, HYDROPRES 25, AMINOHIPPURATE SODIUM, MEVACOR, MODURETIC 5-50, ALDORIL 25, SINGULAIR, COLBENEMID, DIUPRES-250, HYDELTRA-TBA, PRIMAXIN, BENEMID, MAXALT, FOSAMAX PLUS D, HYDRODIURIL, HYDELTRASOL, HYDROPRES 50, ZOLINZA, ALDORIL 15, FOSAMAX, DECASPRAY, COGENTIN, ALDOCLOR-150, PEPCID PRESERVATIVE FREE&amp;#039;&amp;#039;&amp;#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;#* b) &amp;lt;code&amp;gt;select drugname from product inner join application on (product.applno = application.applno) where sponsorapplicant = &amp;#039;MERCK&amp;#039; group by drugname&amp;lt;/code&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Which &amp;#039;&amp;#039;sponsor applicant&amp;#039;&amp;#039; companies have the text &amp;lt;code&amp;gt;LABS&amp;lt;/code&amp;gt; in their names and have products whose active ingredients (&amp;#039;&amp;#039;activeingred&amp;#039;&amp;#039;) include &amp;#039;&amp;#039;both&amp;#039;&amp;#039; &amp;lt;code&amp;gt;ASPIRIN&amp;lt;/code&amp;gt; and &amp;lt;code&amp;gt;CAFFEINE&amp;lt;/code&amp;gt;?&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;# Which &amp;#039;&amp;#039;sponsor applicant&amp;#039;&amp;#039; companies have the text &amp;lt;code&amp;gt;LABS&amp;lt;/code&amp;gt; in their names and have products whose active ingredients (&amp;#039;&amp;#039;activeingred&amp;#039;&amp;#039;) include &amp;#039;&amp;#039;both&amp;#039;&amp;#039; &amp;lt;code&amp;gt;ASPIRIN&amp;lt;/code&amp;gt; and &amp;lt;code&amp;gt;CAFFEINE&amp;lt;/code&amp;gt;?&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;−&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#*&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;#* &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;a) &amp;#039;&amp;#039;&amp;#039;ACTAVIS LABS UT INC&amp;#039;&amp;#039;&amp;#039; and &amp;#039;&amp;#039;&amp;#039;WATSON LABS&amp;#039;&amp;#039;&amp;#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;#* b) &amp;lt;code&amp;gt;select sponsorapplicant from application inner join product on (application.applno = product.applno) where sponsorapplicant like &amp;#039;%LABS%&amp;#039; and activeingred like &amp;#039;%ASPIRIN%&amp;#039; and activeingred like &amp;#039;%CAFFEINE%&amp;#039; group by sponsorapplicant;&amp;lt;/code&amp;gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;= Links to User Page and Journal Pages =&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;= Links to User Page and Journal Pages =&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;{{Template:Rlegaspi}}&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;{{Template:Rlegaspi}}&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#039;&amp;#039;&amp;#039;Homework Partner:&amp;#039;&amp;#039;&amp;#039; [[User:Jwoodlee | Jake Woodlee]]&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;#039;&amp;#039;&amp;#039;Homework Partner:&amp;#039;&amp;#039;&amp;#039; [[User:Jwoodlee | Jake Woodlee]]&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Rlegaspi</name></author>	</entry>

<tr><td colspan="2" class="diff-lineno" id="L65" ><!--LINE 65--></td>
<td colspan="2" class="diff-lineno"><!--LINE 65--></td></tr>
<tr><td class='diff-marker'>&#160;</td><td class='diff-context'><div>#* DrugProduct: &lt;code&gt;cat Product.txt | sed &quot;s/\*\*Federal Register determination that product was not discontinued or withdrawn for safety or efficacy reasons\*\*//g&quot; | sed &quot;s/\*\*Federal Register determination that product was not discontinued or withdrawn for safety or efficacy\*\*//g&quot; | sed &quot;s/\*\*Federal Register notice determination that product was not discontinued or withdrawn for safety or efficacy reasons\*\*//g&quot; | sed &quot;s/\*\*Federal Registration determination that product was not discontinued or withdrawn for safety or efficacy reason\*\*//g&quot; | sed &quot;s/See current Annual Edition, 1.8 Description of Special Situations, Levothyroxine Sodium//g&quot; | sed &quot;s/&#039;//g&quot; | sed &quot;s/\t/#/g&quot; | sed -r &quot;s/( ){2}//g&quot; | sed &quot;s/ \#/#/g&quot; | sed &quot;s/\# /#/g&quot; | sed &quot;s/\#\#/#null#/g&quot; | sed &quot;s/\#\#/#null#/g&quot; | sed &quot;s/\#/,/1&quot; | sed &quot;s/\#/,&#039;/1&quot; | sed &quot;s/\#/&#039;,&#039;/1&quot; | sed &quot;s/\#/&#039;,/1&quot; | sed &quot;s/\#/,&#039;/1&quot; | sed &quot;s/\#/&#039;,/1&quot; | sed &quot;s/\#/,&#039;/1&quot; | sed &quot;s/\#/&#039;,&#039;/1&quot; | sed &quot;s/\r$/&#039;/g&quot; | sed &quot;s/^/insert into drugproduct (ApplNo,ProductNo,Form,Dosage,ProductMktStatus,TECode,ReferenceDrug,drugname,activeingred) values(/g&quot; | sed &quot;s/$/);/g&quot; | sed 1D &gt; ~/public_html/drugproduct.sql.txt&lt;/code&gt;</div></td><td class='diff-marker'>&#160;</td><td class='diff-context'><div>#* DrugProduct: &lt;code&gt;cat Product.txt | sed &quot;s/\*\*Federal Register determination that product was not discontinued or withdrawn for safety or efficacy reasons\*\*//g&quot; | sed &quot;s/\*\*Federal Register determination that product was not discontinued or withdrawn for safety or efficacy\*\*//g&quot; | sed &quot;s/\*\*Federal Register notice determination that product was not discontinued or withdrawn for safety or efficacy reasons\*\*//g&quot; | sed &quot;s/\*\*Federal Registration determination that product was not discontinued or withdrawn for safety or efficacy reason\*\*//g&quot; | sed &quot;s/See current Annual Edition, 1.8 Description of Special Situations, Levothyroxine Sodium//g&quot; | sed &quot;s/&#039;//g&quot; | sed &quot;s/\t/#/g&quot; | sed -r &quot;s/( ){2}//g&quot; | sed &quot;s/ \#/#/g&quot; | sed &quot;s/\# /#/g&quot; | sed &quot;s/\#\#/#null#/g&quot; | sed &quot;s/\#\#/#null#/g&quot; | sed &quot;s/\#/,/1&quot; | sed &quot;s/\#/,&#039;/1&quot; | sed &quot;s/\#/&#039;,&#039;/1&quot; | sed &quot;s/\#/&#039;,/1&quot; | sed &quot;s/\#/,&#039;/1&quot; | sed &quot;s/\#/&#039;,/1&quot; | sed &quot;s/\#/,&#039;/1&quot; | sed &quot;s/\#/&#039;,&#039;/1&quot; | sed &quot;s/\r$/&#039;/g&quot; | sed &quot;s/^/insert into drugproduct (ApplNo,ProductNo,Form,Dosage,ProductMktStatus,TECode,ReferenceDrug,drugname,activeingred) values(/g&quot; | sed &quot;s/$/);/g&quot; | sed 1D &gt; ~/public_html/drugproduct.sql.txt&lt;/code&gt;</div></td></tr>
<tr><td class='diff-marker'>&#160;</td><td class='diff-context'><div># Using the command line, how can you determine the number of records in each file? Provide the command.</div></td><td class='diff-marker'>&#160;</td><td class='diff-context'><div># Using the command line, how can you determine the number of records in each file? Provide the command.</div></td></tr>
Exception encountered, of type &quot;Error&quot;<br />
[2d86ffd8] /biodb/fall2015/index.php?action=history&amp;feed=atom&amp;title=Rlegaspi_Week_6   Error from line 434 of /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php: Call to undefined function each()<br />
Backtrace:<br />
#0 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(544): DiffEngine-&gt;diag()<br />
#1 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(344): DiffEngine-&gt;compareSeq()<br />
#2 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(227): DiffEngine-&gt;diffLocal()<br />
#3 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(721): DiffEngine-&gt;diff()<br />
#4 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(859): Diff-&gt;__construct()<br />
#5 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(980): MappedDiff-&gt;__construct()<br />
#6 /apps/xmlpipedb/biodb/fall2015/includes/diff/TableDiffFormatter.php(194): WordLevelDiff-&gt;__construct()<br />
#7 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(140): TableDiffFormatter-&gt;changed()<br />
#8 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(82): DiffFormatter-&gt;block()<br />
#9 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(888): DiffFormatter-&gt;format()<br />
#10 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(802): DifferenceEngine-&gt;generateTextDiffBody()<br />
#11 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(733): DifferenceEngine-&gt;generateContentDiffBody()<br />
#12 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(662): DifferenceEngine-&gt;getDiffBody()<br />
#13 /apps/xmlpipedb/biodb/fall2015/includes/FeedUtils.php(155): DifferenceEngine-&gt;getDiff()<br />
#14 /apps/xmlpipedb/biodb/fall2015/includes/actions/HistoryAction.php(325): FeedUtils::formatDiffRow()<br />
#15 /apps/xmlpipedb/biodb/fall2015/includes/actions/HistoryAction.php(290): HistoryAction-&gt;feedItem()<br />
#16 /apps/xmlpipedb/biodb/fall2015/includes/actions/HistoryAction.php(130): HistoryAction-&gt;feed()<br />
#17 /apps/xmlpipedb/biodb/fall2015/includes/actions/FormlessAction.php(43): HistoryAction-&gt;onView()<br />
#18 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(395): FormlessAction-&gt;show()<br />
#19 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(273): MediaWiki-&gt;performAction()<br />
#20 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(566): MediaWiki-&gt;performRequest()<br />
#21 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(414): MediaWiki-&gt;main()<br />
#22 /apps/xmlpipedb/biodb/fall2015/index.php(44): MediaWiki-&gt;run()<br />
#23 {main}<br />

