Need help creating stored procedures

crystalb24 · Oct 12, 2004

I need to create two new stored procedures for a web based application that I am creating, both triggered by buttons on the screen.

First is to save the users work and close the application.

Second is to save the users work and continue to the next section of the application.

I need the information that is being saved for each user to be saved to there personal log-in for later retrival.

I'm new to programming with SQL Server, so any help at all will be very much appreciated.

~Crystal
Click here (

http://www.freeiPods.com/default.aspx?referer=7003325)

for a free iPod

crystalb24 · Oct 12, 2004

Guess it would help if I included some of the code from one of the pages in question.

Code:

<script language="JavaScript">
function updateTextarea(cb)
{
 var taValue = document.formName.textareaName.value;
 if(cb.checked)
 {
  if(taValue != "")
   taValue += " ";

  taValue += cb.value; //APPENDS checked value to textarea
 }//end if
 else //checkbox is not checked
 {
  if(taValue.indexOf(cb.value) > -1)
  {
   taValue = taValue.replace(cb.value, "");//removes UNchecked value once
  }//end if
 }//end else

 taValue = taValue.replace(/\s+/g, " "); //reduces multiple spaces to single spaces
 if(taValue.indexOf(" ") == 0)
  taValue = taValue.substring(1);
 document.formName.textareaName.value = taValue;
}//end function
</script>


<script language="javascript">
function Start(page) {
OpenWin = this.open(page, "CtrlWindow", "resizable=yes");
}
</script>


<script language="JavaScript">
function showLink(name)
{
 window[name+"Div"].style.visibility = "visible";
}
</script>

<body>

<table width="100%">
	<tr>
		<td>
		<table width="100%" cellpadding="20" >
  <tr valign="top">
    <td><table width="100%">
        <tr valign="top">
                <td><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="[URL unfurl="true"]http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0"[/URL] width="540" height="120" align="middle" VIEWASTEXT>
              <param name="allowScriptAccess" value="sameDomain" />
              <param name="movie" value="flash/flashmenu.swf?section=1" /><!-- <-------section number is added here and in the embed source -->
              <param name="quality" value="high" />
              <param name="bgcolor" value="#ffffff" />
              <embed src="flash/flashmenu.swf?section=1" quality="high" bgcolor="#ffffff" width="540" height="120" align="middle" allowscriptaccess="sameDomain" type="application/x-shockwave-flash" pluginspage="[URL unfurl="true"]http://www.macromedia.com/go/getflashplayer"[/URL] />
          </object></td>
        </tr>
	</table>


<br>

<table width="100%" border="0">
  <tr>
  	<td>
	<p class="style20">A <font color="#cc0000">Mission Statement</font> describes how you define the purpose of your practice. Creating your <font color="#cc0000">Mission Statement</font> will help you to articulate the essence of what you do for clients and can be placed in your practice brochure, on your website, in client presentations and letters and, of course, presented in client discussions.</p>
	</td>
  </tr>
  <tr>
    <td width="75%">
		<table width="100%">
			<tr>
				<td>
					<a name="Sec1OtherFAcomments"></a><table width="100%" border="0" cellspacing="0" cellpadding="0">
						<tr> 
							
                    <td class="style27"><b>What other FAs have 
                      to say</b></font> </td>
						</tr>
					</table>
					<p class="body">
						<table align="center" width="100%">
							<tr>
								<td valign="middle" align="center" width="33%">
									<img src="images/Multimedia_1.jpg" width="120" height="83" border="5">
								</td>
								<td valign="middle" align="center" width="33%">
									<A HREF="javascript:popUp('video1.htm')"><img src="images/Multimedia_2.jpg" width="120" height="91" border="5"></a>
								</td>
								<td valign="middle" align="center" width="33%">
									<img src="images/Multimedia_3.jpg" width="120" height="83" border="5"><p></p>
								</td>
							</tr>
							<tr class="style20">
								<td align="center">Building your Business<br>with PracticeMAX
								</td>
								
                    <td align="center">FAs Discuss DMA<br>
                      Best Practices </td>
								<td align="center">Why Envision?
								</td>
							</tr>
						</table>
				</td>
			</tr>

			<tr>
				<td>&nbsp;
				</td>
			</tr>
			<tr>
				<td>
					<a name="Sec1CreateMyOwn"></a><table width="100%" border="0" cellspacing="0" cellpadding="0">
						<tr> 
							
                        <td class="style27"><b>Show me examples 
                          and let me create my own <font color="#cc0000"><font color="#cc0000">Mission 
                          Statement</font></font></b></font> 
							<a href="javascript:Start('section1help.asp')";>Need help?</a>
						  </td>
						</tr>
					</table>
					
		
					<p class="style20">Review the questions below and write your <font color="#cc0000">Mission Statement</font> or click and edit from the examples below. You may find the right fit for your practice by combining aspects of more than one of the examples.<br>
						<!--first form-->
						<form name="formName" method="post" action="file:///G|/[URL unfurl="true"]wwwroot/PDGApps/AppFiles/ASPFiles/OnlineTraining/PCG/Fa_Rookie/MainMenu/Thanks.asp"[/URL] onsubmit="this.mission.value=this.textareaName.value;alert(this.mission.value);">
							<input type='hidden' name='mission'>
                      <a name="textarea1"></a><a name="test"></a> 
                      <TEXTAREA ROWS="10" COLS="65" name="textareaName"></textarea>
							<p class="style27"><b>Create your <font color="#cc0000">Mission Statement</font></b></p>
							<p class="style20"><i>(insert questions from pyramid materials here)</i></p> 
							<p class="style27"><b>Best Practice Examples from FAs</b></p>
							<table class="style20" width="100%">
								<tr>
									<td width="3%" valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox" value="Our mission is to assist successful individuals and families in achieving their financial objectives. It is only through an understanding of our clients and their goals that we can truly provide them superior service and financial solutions.">
									</td>
									<td>
									Our mission is to assist successful individuals and families in achieving their financial objectives. It is only through an understanding of our clients and their goals that we can truly provide them superior service and financial solutions.
									
                            <div id="checkboxDiv" style="visibility:hidden"><a href="section1.htm#textarea1" target="_self">Click 
                              here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox2" value="Our mission is to provide objective financial advice and guidance with the highest level of professional service in building and perserving wealth for our clients.">
									</td>
									<td>
									Our mission is to provide objective financial advice and guidance with the highest level of professional service in building and perserving wealth for our clients. 
									<div id="checkbox2Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox3" value="Our philosophy is based on the proactive process of capturing opportunity while managing risk. It is our mission to skillfully guide our clients' portfolios to meet their near and long-term objectives by navigating them through changing markets.">
									</td>
									<td>
									Our philosophy is based on the proactive process of capturing opportunity while managing risk. It is our mission to skillfully guide our clients' portfolios to meet their near and long-term objectives by navigating them through changing markets. 
									<div id="checkbox3Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox4" value="Our mission is to help our clients and their families reach their financial goals by providing comprehensive financial planning, creative solutions and sound investment strategies that help provide financial freedom and preserve wealth for future generations.">
									</td>
									<td>
									Our mission is to help our clients and their families reach their financial goals by providing comprehensive financial planning, creative solutions and sound investment strategies that help provide financial freedom and preserve wealth for future generations. 
									<div id="checkbox4Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox5" value="Our mission is to help our clients make smart decisions with their money so they can spend their time doing the things they care about most.">
									</td>
									<td>
									Our mission is to help our clients make smart decisions with their money so they can spend their time doing the things they care about most.
									<div id="checkbox5Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox6" value="Our mission is to help our clients achieve financial peace of mind.">
									</td>
									<td>
									Our mission is to help our clients achieve financial peace of mind.
									<div id="checkbox6Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox7" value="Our mission is to provide comprehensive financial advice and portfolio management, individually designed for each client, and delivered with the highest level of personal service and professional integrity.">
									</td>
									<td>
									Our mission is to provide comprehensive financial advice and portfolio management, individually designed for each client, and delivered with the highest level of personal service and professional integrity.
									<div id="checkbox7Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox8" value="We manage the financial opportunities and risks of our clients throughout their lives. We do so through a close-knit working relationship and prudent, comprehensive investment strategies tailored specifically to the client.">
									</td>
									<td>
									We manage the financial opportunities and risks of our clients throughout their lives. We do so through a close-knit working relationship and prudent, comprehensive investment strategies tailored specifically to the client.
									<div id="checkbox8Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox9" value="To help our clients achieve and maintain their preferred future.">
									</td>
									<td>
									To help our clients achieve and maintain their preferred future.
									<div id="checkbox9Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox10" value="To provide comprehensive wealth management consulting to help our clients realize their lifetime dreams.">
									</td>
									<td>
									To provide comprehensive wealth management consulting to help our clients realize their lifetime dreams.
									<div id="checkbox10Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox11" value="To provide sound investment advice and the highest level of personal service to help our clients achieve their investment and personal goals.">
									</td>
									<td>
									To provide sound investment advice and the highest level of personal service to help our clients achieve their investment and personal goals.
									<div id="checkbox11Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox12" value="Our mission is to build life-long client relationships built on a foundation of trust and client satisfaction. Our value is built on our experience and knowledge of financial and estate planning, investments, and financial markets. We work with our clients to formulate a comprehensive financial plan, implement that plan, and provide ongoing guidance and direction. As we help our clients accomplish their ultimate individual and family goals, our focus never wavers from what is important - you, our client.">
									</td>
									<td>
									Our mission is to build life-long client relationships built on a foundation of trust and client satisfaction. Our value is built on our experience and knowledge of financial and estate planning, investments, and financial markets. We work with our clients to formulate a comprehensive financial plan, implement that plan, and provide ongoing guidance and direction. As we help our clients accomplish their ultimate individual and family goals, our focus never wavers from what is important - you, our client.
									<div id="checkbox12Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox13" value="Our mission is to work together with our clients to help them achieve their financial goals. We will use our extensive resources to offer sound research and financial advice. We take pride in our high level of professionalism and our standard of ethics. At no time do we forget whose money and whose future is in our hands. Your trust and confidence are our guides.">
									</td>
									<td>
									Our mission is to work together with our clients to help them achieve their financial goals. We will use our extensive resources to offer sound research and financial advice. We take pride in our high level of professionalism and our standard of ethics. At no time do we forget whose money and whose future is in our hands. Your trust and confidence are our guides.
									<div id="checkbox13Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox14" value="Our mission: to develop and execute a comprehensive and successful investment program that addresses your short- and long-term goals in coordination with your legal and accounting advisors.">
									</td>
									<td>
									Our mission: to develop and execute a comprehensive and successful investment program that addresses your short- and long-term goals in coordination with your legal and accounting advisors.
									<div id="checkbox14Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox15" value="Our financial advisory practice is designed to help you live the one life you have in the best way you can without undue financial sacrifice or overexposure to risk.">
									</td>
									<td>
									Our financial advisory practice is designed to help you live the one life you have in the best way you can without undue financial sacrifice or overexposure to risk.
									<div id="checkbox15Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox16" value="Our mission is to combine the strength and heritage of our firm with insight, concern and experience of our team to provide clients objective, individualized advice and service that can help them define and achieve their long-term financial goals.">
									</td>
									<td>
									Our mission is to combine the strength and heritage of our firm with insight, concern and experience of our team to provide clients objective, individualized advice and service that can help them define and achieve their long-term financial goals.
									<div id="checkbox16Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox17" value="Our mission - to create exceptional value for our clients through a deep commitment to service, to provide knowledgeable advice, sincere counsel, and ongoing consultative process that exceeds our clients' expectations.">
									</td>
									<td>
									Our mission - to create exceptional value for our clients through a deep commitment to service, to provide knowledgeable advice, sincere counsel, and ongoing consultative process that exceeds our clients' expectations.
									<div id="checkbox17Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox18" value="Our mission - to assist families and family-owned businesses in building, preserving, and transferring wealth through comprehensive financial planning and portfolio management services.">
									</td>
									<td>
									Our mission - to assist families and family-owned businesses in building, preserving, and transferring wealth through comprehensive financial planning and portfolio management services.
									<div id="checkbox18Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td valign="top">
									<input type="checkbox" onclick="updateTextarea(this);if(this.checked)showLink(this.name);" name="checkbox19" value="Our team is dedicated to achieving the financial goals of our clients by understanding their needs, offering quality investment advice, and providing unparalleled service.">
									</td>
									<td>
									Our team is dedicated to achieving the financial goals of our clients by understanding their needs, offering quality investment advice, and providing unparalleled service.
									<div id="checkbox19Div" style="visibility:hidden"><a href="#textarea1">Click here to return to top and edit your mission statement</a></div>
									</td>
								</tr>
							</table>
						</form> 
				</td>
			</tr>
			<tr>
				<td>&nbsp;
				</td>
			</tr>
			<tr>
				<td>
					<a name="Sec1RelatedResources"></a><table width="100%" border="0" cellspacing="0" cellpadding="0">
						<tr> 
							<td class="style27">Related Resources</font>
							</td>
						</tr>
						<tr>
							<td class="style20"><br>While very robust and customizable to suit your individual needs, PracticeMAX should not be your only resource. For further information about mission statements, visit these links.</td>
						</tr>
					</table>
								
					<p class="style27">Articles / White Papers</font></p>
					
					    <p class="style20"> <a href="[URL unfurl="true"]http://www.horsesmouth.com/linkpo/74000_124.htm"[/URL] target="_blank">How 
                          to Write a Mission Statement That Matters</a> - Will 
                          your mission statement really make a difference in your 
                          performance? Yes-but only if you're approaching the 
                          process properly. Here's how to devise a statement that 
                          works for you. (Horsesmouth article)<br>
						<br>
                          <a href="[URL unfurl="true"]http://www.horsesmouth.com/linkpo/71715_124.htm"[/URL] target="_blank">Designing 
                          Your Mission Statement-10 Tips From an Expert</a> - 
                          Horsesmouth expert and business coach Jim Rohrbach answers 
                          questions on crafting a mission statement and clarifies 
                          the difference between outlining your "mission" and 
                          articulating your "vision" or "values." (Horsesmouth 
                          article) 
						<br>
						<br>
                          <a href="[URL unfurl="true"]http://www.horsesmouth.com/linkpo/70733_124.htm"[/URL] target="_blank">Real Value Starts With Your Mission Statement</a> - 
                          Distilling our services, strengths, and beliefs into a clear and concise statement is a daunting task. But when we make a strong case for our unique value, we attract the customers we deserve, and everyone-other advisors, as well as prospects-wins. (Horsesmouth 
                          article) 
					</p>
					
					<p class="style27">Books</b></font></p>
					
					<p class="style20">
						<a href="[URL unfurl="true"]http://www.amazon.com/exec/obidos/tg/detail/-/0967663504/qid=1097266554/sr=1-1/ref=sr_1_1/103-9961491-2523850?v=glance&s=books"[/URL] target="_blank">The Mission Primer: Four Steps to an Effective Mission Statement by Richard O'Hallaron, David O'Hallaron</a> - The book outlines a simple four-step method for developing effective mission statements. Our unique method is structured, quantifiable, and has a distinct beginning and end. We have used it successfully with dozens of corporate, university, and non-profit clients. The method is based on a set of six laws --- what we call Gast's laws --- that describe the culture of a successful organization. The central idea is that a mission statement describes how the organization intends to comply with Gast's laws.
						<br>
						<br>
						<a href="[URL unfurl="true"]http://www.amazon.com/exec/obidos/tg/detail/-/0385476302/qid=1097266554/sr=5-3/ref=cm_lm_asin/103-9961491-2523850?v=glance"[/URL] target="_blank">Say it and Live it by PATRICIA JONES, LARRY KAHANER</a> - Jones and Kahaner present a compendium of 50 corporate "mission statements, values, philosophies, visions, or whatever they call them" from companies that practice what they proclaim. In Peak Performers (LJ 4/1/86), Charles Garfield opines that mission statements exceeding ten words are useless. His reasoning is simple: it is unlikely that either a board member or a frontline employee can recall a verbose and complicated mission. Few mission statements presented here meet this requirement, General Electric's being an exception ("Boundary-less...Speed...Stretch"). The last chapter, "Six Rules for Writing Your Own Mission Statement," is a "by the numbers" approach to the task. Unfortunately, the last thing any enterprise needs is a cookbook mission. Most libraries could do without this book in their collections.?Steven Silkunas, Southeastern Pennsylvania Transit Authority, Philadelphia
						<br>
						<br>
					</p>
					
					<p class="style27">Websites</b></font></p>
					
					<p class="style20">
						<a href="[URL unfurl="true"]http://">website[/URL] link 1</a> 
						<br>
						<a href="[URL unfurl="true"]http://">website[/URL] link 2</a> 
						<br>
						<br>
					</p>
					
					<p class="style27">Quotes</b></font></p>
					
					<p class="style20">
						<a href="[URL unfurl="true"]http://">quote[/URL] link 1</a> 
						<br>
						<a href="[URL unfurl="true"]http://">quote[/URL] link 2</a>
					</p>
				</td>
				</tr>
			</table>
		</td>
        </tr>
		<tr>
			<td>
			<table class="style20" width="100%">
				<tr>
					<td>
					Click the button below to end this session and save your progress 
					<form name="form1" method="post" action="file:///G|/[URL unfurl="true"]wwwroot/PDGApps/AppFiles/ASPFiles/OnlineTraining/PCG/Fa_Rookie/MainMenu/Thanks.asp">[/URL]
						<input name="CourseID" type="hidden" id="CourseID" value="77">
						<input type="submit" name="Submit" value="Save my progress.">
					</form>
					</td>
				</tr>
				<tr>
					<td>
					Click the button below when you have completed this section.
					<form name="form1" method="post" action="file:///G|/[URL unfurl="true"]wwwroot/PDGApps/AppFiles/ASPFiles/OnlineTraining/PCG/Fa_Rookie/MainMenu/Thanks.asp">[/URL]
						<input name="CourseID" type="hidden" id="CourseID" value="77">
						<input type="submit" name="Submit" value="I have completed this section.">
					</form>
					</td>
				</tr>
			</table>
			</td>
		</tr>
        <tr>
          <td height="20"><div align="center" class="style20"><font color="#999999"></font>PracticeMAX - Wachovia 
            Securities &copy;2004</div></td>
        </tr>
    </table>
		</td>
		<td width="162">
        <table width="152" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" hspace="0">
          <tr valign="left">
            <td><img src="images/login_header.gif" width="152" height="20"></td>
          </tr>
          <tr>
            <td bgcolor="#7f97c0" height="100">
				<table>
						<tr> 
							<td align="center" class="style24">
							<br>
							<b>Welcome Back, Crystal!</b>
							</td>
						</tr>
						<tr>
							<td>&nbsp;</td>
						</tr> 
						<tr> 
							<td align="center" class="style24"> 
							Your last log-in was on Sept. 21, 2004
							</td>
						</tr>
						<tr>
							<td>&nbsp;</td>
						</tr>
						<tr> 
							<td align="center" class="style24">
							You are 25% complete your PracticeMAX experience.
							</td>
						</tr>
						<tr>
							<td align="center">
							<img src="images/status bar.gif">
							</td>
						</tr>
						<tr>
							<td>&nbsp;</td>
						</tr>
			  </table>
			</td>
			
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td><img src="images/mm_header.gif" width="152" height="20"></td>
          </tr>
          <tr>
            <td bgcolor="#7f97c0"><table>
								<tr> 
		                          <td align="center">
								  		<p><img src="images/bowlofsoup.gif" width="120" height="78" border="1"><br>
										<font color="#FFFFFF" class="style28">Building Your Business with PracticeMAX</font><br>
										<a href="[URL unfurl="true"]http://"[/URL] class="style28">Click here to View</a>
										<br>                                    
										<br>
										<img src="images/nuts.jpeg" width="120" height="78" border="1"><br> 
										<span class="style28"><font color="#FFFFFF">FAs Discuss DMA<br>
										Best Practices</font></span><span class="style28"><br>
										<a href="[URL unfurl="true"]http://"[/URL] class="style28">Click here to View</a></span>
										<br>		      
										<br>		      
										<img src="images/62Corvette.jpeg" width="120" height="78" border="1"><br>
										<font color="#FFFFFF" class="style28">Why Envision?<br>
										</font><a href="[URL unfurl="true"]http://"[/URL] class="style28">Click here to View</a><br>
										<br>
										</span></p>
	                              </td>
								</tr>

					</table>
			</td>
		  </tr>
	  </table>
	</td>
          </tr>
        </table>

</table>
</body>
</html>

The peices of information that I want to be saved into the database is the contents of the textarea as well as a yes/no value for whether or not the checkboxes are checked

~Crystal
Click here (

http://www.freeiPods.com/default.aspx?referer=7003325)

for a free iPod

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need help creating stored procedures

crystalb24

Programmer

crystalb24

Programmer

Similar threads

Part and Inventory Search

Sponsor