Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Insert new concatenated field to link records across table for easy user recall in vbscript

While I'm inserting a new record I would like to capture the userID, transID and Date() to establish the value of transStamp. Then I will set transStamp as a session variable to be used across the multiple tables I'm using to capture financial data from user. I'm doing this to give users opportunity to save and come back where they left off. Any suggestions how to go about this.
0
GMMC_man
Asked:
GMMC_man
  • 8
  • 5
1 Solution
 
chapmandewCommented:
where are you wanting to get the userid and transid from?  
0
 
GMMC_manAuthor Commented:
I've created a register module for new users that sets the MM_userID (integer) session variable when adding new user. transID is a incremented field (integer) automatically generated when a new record is created in my finAnalyses tables. Since I have at least two tables collecting data from this user, and each table potentially contains different transID values, I'm using the transStamp to tie the table transactions together for future recall.
0
 
chapmandewCommented:
so, just so I am clear....you have a couple different tables that have an IDENTITY column named transID, OR you have several users inserting into the table and producing a trans_ID value?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
GMMC_manAuthor Commented:
yes - my tables are finAnalysisBudget finAnalysisFixedExpenses finAnalysisFlexibleExpenses finAnalysisIncome and finAnalysisNetworth. Each of these tables has an incremental transID field. When a user registers he then enters financial data as one transaction in these tables. Because transID could be different in each table I want transStamp to be the same in each table. There may be a better way to solve this problem but that is what I came up with.
0
 
chapmandewCommented:
So,I assume you have one table that you ALWAYS insert into first, right?
0
 
GMMC_manAuthor Commented:
yes - finAnalysisNetworth
0
 
chapmandewCommented:
So, if you want to tie all of the transIDs together, I would get the identity value from finAnalysisNetworth and save it.  From there, you'll want a ParentTransID value in each of the other tables.  Insert the Identity value you got from the insert into finAnalysisNetworth, and add that value into the ParentTransID column in the other tables.  That way, you can always tie them together.  Make sense?
0
 
GMMC_manAuthor Commented:
yes
0
 
GMMC_manAuthor Commented:
so simple - thanks. Give me a minute to try it.
0
 
GMMC_manAuthor Commented:
What is the best way to pass that value (transID) to the next page? Passing it as a querystring or session variable or cookie? And where would be the place in code to capture and pass it? I've included the code below from analysis2.asp which accepts users asset info. It redirects to analysis2a.asp (this page gives user chance to review and change what they entered) if 1) the user submits the form or 2) the user is returning and has a record already saved. 2a then sends user to analysis3.asp which accepts users liability info. This goes to my second table where user enters flexible expenses and so forth and so until a report is displayed. You can see how this works now by going to www.lovingthenet.com/GrowMyMoneyClub/public/registration.asp and signing up yourself.
<%@LANGUAGE="VBSCRIPT"%>
<%Dim myDateString
myDateString = Date()%>
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers="visitor,member,admin,super"
MM_authFailedURL="tryLoginAgain.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
  If (false Or CStr(Session("MM_UserAuthorization"))="") Or _
         (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
    MM_grantAccess = true
  End If
End If
If Not MM_grantAccess Then
  MM_qsChar = "?"
  If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
  MM_referrer = Request.ServerVariables("URL")
  if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
  MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
  Response.Redirect(MM_authFailedURL)
End If
%>
<!--#include file="../Connections/connGMMCdata.asp" -->
<%
Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If
 
' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
%>
 
<%
' IIf implementation
Function MM_IIf(condition, ifTrue, ifFalse)
  If condition = "" Then
    MM_IIf = ifFalse
  Else
    MM_IIf = ifTrue
  End If
End Function
%>
<%
If (CStr(Request("MM_insert")) = "frmAssets") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd
 
    Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_connGMMCdata_STRING
    MM_editCmd.CommandText = "INSERT INTO dbo.finAnalysisNetWorth (Home, Vehicles, Appliances, Jewelry, Artwork, Furniture, Electronics, Antiques, Collections, Business1Equity, Business2Equity, Business3Equity, Land, Rentals, otherRealEstate, CashonHand, CheckingCash, SavingsCash, CDs, MoneyMarket, Bonds, InsurancePolicies, Pensions, ProfitSharingPlans, Annuities, KeoghPlan, IRA, RetirementSavingsPlan, MutualFunds, InvestmentTrusts, TaxRefundsDue, LoansOwedYou, IndStockShares, OtherAssets, MortgageDebts, CarDebts, FurnitureDebts, ApplianceDebts, OtherInstallmentDebts, PersonalLoanDebts, CurrentBillsOutstanding, TaxesDue, OthersDebts, userID, transDate, transStamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 5, 1, -1, MM_IIF(Request.Form("Home"), Request.Form("Home"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 5, 1, -1, MM_IIF(Request.Form("Vehicles"), Request.Form("Vehicles"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 5, 1, -1, MM_IIF(Request.Form("Appliances"), Request.Form("Appliances"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 5, 1, -1, MM_IIF(Request.Form("Jewelry"), Request.Form("Jewelry"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 5, 1, -1, MM_IIF(Request.Form("Artwork"), Request.Form("Artwork"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 5, 1, -1, MM_IIF(Request.Form("Furniture"), Request.Form("Furniture"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 5, 1, -1, MM_IIF(Request.Form("Electronics"), Request.Form("Electronics"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 5, 1, -1, MM_IIF(Request.Form("Antiques"), Request.Form("Antiques"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 5, 1, -1, MM_IIF(Request.Form("Collections"), Request.Form("Collections"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 5, 1, -1, MM_IIF(Request.Form("Business1Equity"), Request.Form("Business1Equity"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 5, 1, -1, MM_IIF(Request.Form("Business2Equity"), Request.Form("Business2Equity"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 5, 1, -1, MM_IIF(Request.Form("Business3Equity"), Request.Form("Business3Equity"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 5, 1, -1, MM_IIF(Request.Form("Land"), Request.Form("Land"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 5, 1, -1, MM_IIF(Request.Form("Rentals"), Request.Form("Rentals"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 5, 1, -1, MM_IIF(Request.Form("otherRealEstate"), Request.Form("otherRealEstate"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 5, 1, -1, MM_IIF(Request.Form("CashonHand"), Request.Form("CashonHand"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param17", 5, 1, -1, MM_IIF(Request.Form("CheckingCash"), Request.Form("CheckingCash"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param18", 5, 1, -1, MM_IIF(Request.Form("SavingsCash"), Request.Form("SavingsCash"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param19", 5, 1, -1, MM_IIF(Request.Form("CDs"), Request.Form("CDs"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param20", 5, 1, -1, MM_IIF(Request.Form("MoneyMarket"), Request.Form("MoneyMarket"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param21", 5, 1, -1, MM_IIF(Request.Form("Bonds"), Request.Form("Bonds"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param22", 5, 1, -1, MM_IIF(Request.Form("InsurancePolicies"), Request.Form("InsurancePolicies"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param23", 5, 1, -1, MM_IIF(Request.Form("Pensions"), Request.Form("Pensions"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param24", 5, 1, -1, MM_IIF(Request.Form("ProfitSharingPlans"), Request.Form("ProfitSharingPlans"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param25", 5, 1, -1, MM_IIF(Request.Form("Annuities"), Request.Form("Annuities"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param26", 5, 1, -1, MM_IIF(Request.Form("KeoghPlan"), Request.Form("KeoghPlan"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param27", 5, 1, -1, MM_IIF(Request.Form("IRA"), Request.Form("IRA"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param28", 5, 1, -1, MM_IIF(Request.Form("RetirementSavingsPlan"), Request.Form("RetirementSavingsPlan"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param29", 5, 1, -1, MM_IIF(Request.Form("MutualFunds"), Request.Form("MutualFunds"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param30", 5, 1, -1, MM_IIF(Request.Form("InvestmentTrusts"), Request.Form("InvestmentTrusts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param31", 5, 1, -1, MM_IIF(Request.Form("TaxRefundsDue"), Request.Form("TaxRefundsDue"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param32", 5, 1, -1, MM_IIF(Request.Form("LoansOwedYou"), Request.Form("LoansOwedYou"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param33", 5, 1, -1, MM_IIF(Request.Form("IndStockShares"), Request.Form("IndStockShares"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param34", 5, 1, -1, MM_IIF(Request.Form("OtherAssets"), Request.Form("OtherAssets"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param35", 5, 1, -1, MM_IIF(Request.Form("MortgageDebts"), Request.Form("MortgageDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param36", 5, 1, -1, MM_IIF(Request.Form("CarDebts"), Request.Form("CarDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param37", 5, 1, -1, MM_IIF(Request.Form("FurnitureDebts"), Request.Form("FurnitureDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param38", 5, 1, -1, MM_IIF(Request.Form("ApplianceDebts"), Request.Form("ApplianceDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param39", 5, 1, -1, MM_IIF(Request.Form("OtherInstallmentDebts"), Request.Form("OtherInstallmentDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param40", 5, 1, -1, MM_IIF(Request.Form("PersonalLoanDebts"), Request.Form("PersonalLoanDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param41", 5, 1, -1, MM_IIF(Request.Form("CurrentBillsOutstanding"), Request.Form("CurrentBillsOutstanding"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param42", 5, 1, -1, MM_IIF(Request.Form("TaxesDue"), Request.Form("TaxesDue"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param43", 5, 1, -1, MM_IIF(Request.Form("OthersDebts"), Request.Form("OthersDebts"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param44", 5, 1, -1, MM_IIF(Request.Form("userID"), Request.Form("userID"), null)) ' adDouble
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param45", 135, 1, -1, MM_IIF(Request.Form("transDate"), Request.Form("transDate"), null)) ' adDBTimeStamp
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close
 
    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "analysis2a.asp"
    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
    Response.Redirect(MM_editRedirectUrl)
  End If
End If
%>
<%
Dim rs_Assets
Dim rs_Assets_cmd
Dim rs_Assets_numRows
 
Set rs_Assets_cmd = Server.CreateObject ("ADODB.Command")
rs_Assets_cmd.ActiveConnection = MM_connGMMCdata_STRING
rs_Assets_cmd.CommandText = "SELECT transID, userID, transDate, Home, Vehicles, Appliances, Jewelry, Artwork, Furniture, Electronics, Antiques, Collections, Business1Equity, Business2Equity, Business3Equity, Land, Rentals, otherRealEstate, CashonHand, CheckingCash, SavingsCash, CDs, MoneyMarket, Bonds, InsurancePolicies, Pensions, ProfitSharingPlans, Annuities, KeoghPlan, IRA, RetirementSavingsPlan, MutualFunds, InvestmentTrusts, TaxRefundsDue, LoansOwedYou, IndStockShares, OtherAssets, transStamp FROM dbo.finAnalysisNetWorth" 
rs_Assets_cmd.Prepared = true
 
Set rs_Assets = rs_Assets_cmd.Execute
rs_Assets_numRows = 0
%>
<%
Dim rs_CheckExistingTrans__MMColParam
rs_CheckExistingTrans__MMColParam = "1"
If (Session("MM_userID") <> "") Then 
  rs_CheckExistingTrans__MMColParam = Session("MM_userID")
	MM_abortEdit = true
	response.redirect("analysis2a.asp?transID=" & Session("MM_transID"))
End If
%>
<%
Dim rs_CheckExistingTrans
Dim rs_CheckExistingTrans_cmd
Dim rs_CheckExistingTrans_numRows
 
Set rs_CheckExistingTrans_cmd = Server.CreateObject ("ADODB.Command")
rs_CheckExistingTrans_cmd.ActiveConnection = MM_connGMMCdata_STRING
rs_CheckExistingTrans_cmd.CommandText = "SELECT transID, userID FROM dbo.finAnalysisNetWorth WHERE userID = ?" 
rs_CheckExistingTrans_cmd.Prepared = true
rs_CheckExistingTrans_cmd.Parameters.Append rs_CheckExistingTrans_cmd.CreateParameter("param1", 5, 1, -1, rs_CheckExistingTrans__MMColParam) ' adDouble
 
Set rs_CheckExistingTrans = rs_CheckExistingTrans_cmd.Execute
Session("MM_transID") = rs_CheckExistingTrans("transID")
rs_CheckExistingTrans_numRows = 0
%>
<%
Dim rs_user__MMColParam
rs_user__MMColParam = "1"
If (Session("MM_Username") <> "") Then 
  rs_user__MMColParam = Session("MM_Username")
End If
%>
<%
Dim rs_user
Dim rs_user_cmd
Dim rs_user_numRows
 
Set rs_user_cmd = Server.CreateObject ("ADODB.Command")
rs_user_cmd.ActiveConnection = MM_connGMMCdata_STRING
rs_user_cmd.CommandText = "SELECT userID, mentorID, firstName, lastName, email, userGroup FROM dbo.Members WHERE email = ?" 
rs_user_cmd.Prepared = true
rs_user_cmd.Parameters.Append rs_user_cmd.CreateParameter("param1", 200, 1, 50, rs_user__MMColParam) ' adVarChar
Set rs_user = rs_user_cmd.Execute
rs_user_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/analysis_template.dwt.asp" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 
<title>Financial Analysis - What Do You Own?</title>
 
<link href="file:///C|/inetpub/wwwroot/gmmcPub/public/css/main.css" rel="stylesheet" type="text/css" />
<!--[if IE 5]>
<style type="text/css"> 
/* place css box model fixes for IE 5* in this conditional comment */
.thrColFixHdr #sidebar1 { width: 180px; }
.thrColFixHdr #sidebar2 { width: 280px; }
</style>
<![endif]--><!--[if IE]>
<style type="text/css"> 
/* place css fixes for all versions of IE in this conditional comment */
.thrColFixHdr #sidebar2, .thrColFixHdr #sidebar1 { padding-top: 30px; }
.thrColFixHdr #mainContent { zoom: 0.9; padding-top: 15px; }
/* the above proprietary zoom property gives IE the hasLayout it needs to avoid several bugs */
</style>
<![endif]-->
<link href="../css/main2.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.fltrt {	float: right;
	margin-left: 8px;
}
-->
</style>
 
<script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<link href="../css/main.css" rel="stylesheet" type="text/css" />
</head>
 
<body class="thrColFixHdr">
 
<div id="container">
  <div id="header"><!-- InstanceBeginEditable name="Head" -->
    <table width="100%" border="0" cellspacing="0" cellpadding="3">
      <tr>
        <td><img src="../images/gmmc_text_blue.gif" alt="Grow My Money Club Logo" width="348" height="28" /></td>
        <td valign="top"><div class="topHeader" id="topMenu"></div></td>
      </tr>
      <tr>
        <td colspan="2"><hr /></td>
      </tr>
      <tr>
        <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2"><hr /></td>
      </tr>
    </table>
  <!-- InstanceEndEditable -->
  <!-- end #header --></div>
  
    <!-- InstanceBeginEditable name="sidebar" -->
    <div id="sidebar1">
      <p align="center" class="navhead">ADD $11,000 TO $22,000 TO YOUR<br />
        BOTTOME LINE<br />
        THIS YEAR!</p>
      <p align="center" class="caption"><img src="../images/photos/GasingCar.png" alt="Putting gas in car" width="156" height="96" /> </p>
      <p align="center" class="caption">Fuel Your Future!</p>
      <p align="center" class="caption">&nbsp;</p>
      <p align="center" class="caption">&nbsp;</p>
      <p align="center" class="caption"><span class="error">&quot;The poor and the middle class work for money.&quot; &quot;The rich have money work for them.&quot;</span><span class="author"><br />
        </span><br />
        <span class="author">Robert T. Kiyosaki</span></p>
      <!-- end #sidebar1 -->
      <p></p>
    </div>
    <!-- InstanceEndEditable -->
    <div id="Article"><!-- InstanceBeginEditable name="content" -->
    <table width="75%" border="0" cellspacing="0" cellpadding="3">
 
      <tr>
        <td><h2>Free Financial Analysis - <%= Session("MM_firstName") %>,&nbsp;Where Are You Now?</h2>
        <p>The first step in getting where you want to go is clearly locating where you are. These questions help you get an accurate picture of your current financial situation. The first thing we will do is discover your Net Worth. A Net Worth Statement adds up what you own - assets (personal items, cash, investments) and subtracts what you owe -  liabilities (loans and debts). Gather all the documents you may need to complete this as accurately as possible. The more accurate you are the more clearly we will be able to help you.</p>        </td>
      </tr>
      
      <tr>
        <td><p>&nbsp;</p>
          <form action="<%=MM_editAction%>" method="POST" name="frmAssets" id="frmAssets">
            <table align="center">
              <tr valign="baseline">
                <td colspan="2" align="right" nowrap="nowrap"><div align="center" class="rowHover">Assets</div></td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowselect"><div align="center">Items</div></td>
                <td class="rowselect"><div align="center">Your Answers</div></td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Home:</td>
                <td><input type="text" name="Home" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Vehicles:</td>
                <td><input type="text" name="Vehicles" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Appliances:</td>
                <td><input type="text" name="Appliances" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Jewelry:</td>
                <td><input type="text" name="Jewelry" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Artwork:</td>
                <td><input type="text" name="Artwork" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Furniture:</td>
                <td><input type="text" name="Furniture" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Electronics:</td>
                <td><input type="text" name="Electronics" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Antiques:</td>
                <td><input type="text" name="Antiques" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Collections:</td>
                <td><input type="text" name="Collections" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Business 1 Equity:</td>
                <td><input type="text" name="Business1Equity" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Business 2 Equity:</td>
                <td><input type="text" name="Business2Equity" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Business 3 Equity:</td>
                <td><input type="text" name="Business3Equity" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Land:</td>
                <td><input type="text" name="Land" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Rentals:</td>
                <td><input type="text" name="Rentals" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Other Real Estate:</td>
                <td><input type="text" name="otherRealEstate" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Cash on Hand:</td>
                <td><input type="text" name="CashonHand" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Checking Cash:</td>
                <td><input type="text" name="CheckingCash" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Savings Cash:</td>
                <td><input type="text" name="SavingsCash" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">CDs:</td>
                <td><input type="text" name="CDs" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Money Market:</td>
                <td><input type="text" name="MoneyMarket" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Bonds:</td>
                <td><input type="text" name="Bonds" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Insurance Policies:</td>
                <td><input type="text" name="InsurancePolicies" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Pensions:</td>
                <td><input type="text" name="Pensions" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Profit Sharing Plans:</td>
                <td><input type="text" name="ProfitSharingPlans" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Annuities:</td>
                <td><input type="text" name="Annuities" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Keogh Plan:</td>
                <td><input type="text" name="KeoghPlan" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">IRA:</td>
                <td><input type="text" name="IRA" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Retirement Savings Plan:</td>
                <td><input type="text" name="RetirementSavingsPlan" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Mutual Funds:</td>
                <td><input type="text" name="MutualFunds" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Investment Trusts:</td>
                <td><input type="text" name="InvestmentTrusts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Tax Refunds Due:</td>
                <td><input type="text" name="TaxRefundsDue" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Loans Owed You:</td>
                <td><input type="text" name="LoansOwedYou" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Ind Stock Shares:</td>
                <td><input type="text" name="IndStockShares" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Other Assets:</td>
                <td><input type="text" name="OtherAssets" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Mortgage Debts:</td>
                <td><input type="text" name="MortgageDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Car Debts:</td>
                <td><input type="text" name="CarDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Furniture Debts:</td>
                <td><input type="text" name="FurnitureDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Appliance Debts:</td>
                <td><input type="text" name="ApplianceDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Other Installment Debts:</td>
                <td><input type="text" name="OtherInstallmentDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Personal Loan Debts:</td>
                <td><input type="text" name="PersonalLoanDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Current Bills Outstanding:</td>
                <td><input type="text" name="CurrentBillsOutstanding" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Taxes Due:</td>
                <td><input type="text" name="TaxesDue" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">Others Debts:</td>
                <td><input type="text" name="OthersDebts" value="" size="16" />                </td>
              </tr>
              <tr valign="baseline">
                <td align="right" nowrap="nowrap" class="rowHover">&nbsp;</td>
                <td><input type="submit" value="Next" />                </td>
              </tr>
            </table>
            <input type="hidden" name="userID" value="<%= Session("MM_userID") %>" />
            <input type="hidden" name="transDate" value="<%Date()%>" />
            <input type="hidden" name="MM_insert" value="frmAssets" />
          </form>
        <p>&nbsp;</p></td>
      </tr>
    </table>
<p>&nbsp;</p>
  <!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats --><br class="clearfloat" />
<div id="footer">
    <p>&copy; 2009 Grow My Money Club</p>
<!-- end #footer --></div>
<!-- end #container -->
</body>
</html>
<%
rs_Assets.Close()
Set rs_Assets = Nothing
%>
<%
rs_CheckExistingTrans.Close()
Set rs_CheckExistingTrans = Nothing
%>
<%
rs_user.Close()
Set rs_user = Nothing
%>

Open in new window

0
 
chapmandewCommented:
I would use a session variable...but I am just a database guy.  :)

If you want advice for how to pass, etc, I would post another question for the ASP guys to answer.
0
 
GMMC_manAuthor Commented:
Thanks
0
 
GMMC_manAuthor Commented:
Thanks for your expert help.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now