Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #11 (permalink)  
Old February 2nd, 2010, 08:57 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,652
Thanks: 3
Thanked 141 Times in 140 Posts
Default

This page is *EXPECTING* that when the user arrives at it there will be a company id in the querystring.

That is, it is expecting that the URL will look like
Code:
      somePageName.asp?ClientCompanyID=37
(or maybe a string instead of a number there, depending on what the field CompanyID is in your Company table)

If you get to this page WITHOUT that in the querystring, then indeed it will *always* give you the first company in the Company db table.

Which of course is 100% utterly useless. And oh so typical of DW code.

Instead, the page should have *REJECTED* the request and told you to go back and choose a company from the preceding page. Or maybe it should have allowed you to create a new company record right here (that would have been the most reasonable, but this is DW after all).

SO....

The big question here: Is the Company you are looking up here always tied one-to-one with the Client? Or is it possible for a Client to be associated with many Company records??? [That is, is the Company info actually the info for that Client, of is the Company info that of one of the debtors???]

If it's always one-to-one with the clients, then the big problem here may be that you shouldn't even have two tables. But we *may* be okay. *IF* your Clients table has a field in it that has the CompanyID, then we can easily pick it up out of the recordset from the Clients query and use it to get the Company info. Big IF. Well, two big IFs.

On the other hand, if the Company table really *is* the debtors table--if each Client might have multiple records associated with it in the Company table--then you are missing a vital step. You need a page where the client is given a dropdown of existing Company matches and allowed to pick one. And *that* gets passed in the querystring (or Post) to this page.
Reply With Quote
  #12 (permalink)  
Old February 2nd, 2010, 11:36 PM
Authorized User
 
Join Date: Jan 2010
Location: Whitsundays Australia
Posts: 36
Thanks: 1
Thanked 0 Times in 0 Posts
Default MS Access SQL Problem

Hi,

Did you get the post about the login page working? Turns out my commercial hosting company set up my dsn that I asked to be collectoz to a different name.

Ok on with the sql thing.

Your quote-
The big question here: Is the Company you are looking up here always tied one-to-one with the Client? (Yes)

Your quote-

But we *may* be okay. *IF* your Clients table has a field in it that has the CompanyID

(My Client tables first column has a clientId second column has a ClientCompanyID their ID both started in row 1 and both ID was 1 untill I deleted the first row to see if that was the problem. The first row is now 2 and both ID are 2 also. My Company tables first column starts out with a +
on each row but it is not labled at the top like all the other columns, the column if you could call it one is only the width of the + very thin, is that the connection to the Client table? The second normal width column is the Company ID the first row is 2 and the next column is the Compname.

Both the Client and the Company table are my clients not debtors.

Cheers

Len
Reply With Quote
  #13 (permalink)  
Old February 3rd, 2010, 02:31 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,652
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Okay, so you really should never have had separate Clients and Company tables in the first place.

As to what the *appearance* of the table is in some tool (you don't even say *which* tool...DW or in Access itself??), you should be able to easily change that by just dragging the vertical bar left or right to narrow/widen the space used by the column (the little + sign surely just means "there is more here but the column you chose is too narrow to display it"). The appearance, in any case, is 100% IRRELEVANT to your problems.

ANYWAY...

Okay, let's rewrite the crappy DW code.
Code:
<%
' *** Restrict Access To Page: Grant or deny access to this page
userName = Trim(Session("MM_Username"))
If userName = "" Then
  MM_referrer = Request.ServerVariables("URL") & "?" & Request.QueryString()
  Response.Redirect "../content/online.htm?accessdenied=" & Server.URLEncode(MM_referrer)
End If
%>
<!--#include file="../Connections/collectoz.asp" -->
<%
Set oConn = Server.CreateObject("ADODB.Collection")
oConn.Open MM_collectoz_STRING
SQL = "Select *  from clients  where UsrName = '" & Replace(userName,"'","''") & "'"
Set rsclient = oConn.Execute(SQL)
If rsclient.EOF Then
    Response.Write "FATAL ERROR: Invalid UsrName of " & userName
    Response.End
End If
CompanyID = rsClient("ClientCompanyID")
SQL = "select *  from Company  where CompanyID = '" & Replace(CompanyID, "'", "''") & "'"
Set Recordset1 = oConn.Execute(SQL)
If Recordset1.EOF Then
    Response.Write "FATAL ERROR: Invalid CompanyID of " & CompanyID
    Response.End
End If
%>
<html><!-- #BeginTemplate "/Templates/Subpage.dwt" -->
... rest is the same ...
See why I call it "DumbWaster"??

Mind you, the rest of the page is so horribly inefficient and ugly that "DumbWaster" might be me just being overly nice.

But I *think* the rest of the page will at least run.

Oh...and by the by...you really should *NOT* be using a DSN. You really and truly should be using a DSN-less connection. But that's yet another story.
Reply With Quote
  #14 (permalink)  
Old February 4th, 2010, 02:51 AM
Authorized User
 
Join Date: Jan 2010
Location: Whitsundays Australia
Posts: 36
Thanks: 1
Thanked 0 Times in 0 Posts
Default MS Access SQL Problem

Hi,

Tried to put in this code today, this was what it looked like after I cut and pasted it in. I have put a note in showing were the rest of the DW code greyed out from the last of your code finished and DW code starts, maybe I have not inserted it correctly.

After I pasted it in DW chimed in and told me I had to undo the edit and - out server behaviors. Looked like this-

! Dynamic text (Recordset1.CompTrdAdl1)
! Dynamic text (Recordset1.CompTrdAdl2)
! Dynamic text (Recordset1.CompTrdAdl3)
! Dynamic text (Recordset1.CompTrdCrty)

The document does not open after uploading to my host computer.

Code:
<%@LANGUAGE="VBSCRIPT"%> 
<%
' *** Restrict Access To Page: Grant or deny access to this page
userName = Trim(Session("MM_Username"))
If userName = "" Then
  MM_referrer = Request.ServerVariables("URL") & "?" & Request.QueryString()
  Response.Redirect "../content/online.htm?accessdenied=" & Server.URLEncode(MM_referrer)
End If
%>
<!--#include file="../Connections/collectoz.asp" -->
<%
Set oConn = Server.CreateObject("ADODB.Collection")
oConn.Open MM_collectoz_STRING
SQL = "Select *  from clients  where UsrName = '" & Replace(userName,"'","''") & "'"
Set rsclient = oConn.Execute(SQL)
If rsclient.EOF Then
    Response.Write "FATAL ERROR: Invalid UsrName of " & userName
    Response.End
End If
CompanyID = rsClient("ClientCompanyID")
SQL = "select *  from Company  where CompanyID = '" & Replace(CompanyID, "'", "''") & "'"
Set Recordset1 = oConn.Execute(SQL)
If Recordset1.EOF Then
    Response.Write "FATAL ERROR: Invalid CompanyID of " & CompanyID
    Response.End
End If
%>
<html><!-- #BeginTemplate "/Templates/Subpage.dwt" -->
<head>  (EVERY THING FROM HERE DOWN IS GREYED OUT NO COLOUR)?
<title>debtorstocash.com Online Services</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--


<!--

<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>
<body bgcolor="336699" leftmargin="30" topmargin="0" marginwidth="30" marginheight="0" text="#FFFFFF" link="#FFFFFF" vlink="#CCCCCC" alink="#FFFFFF">
<table bgcolor="#336699" border="0" cellpadding="0" cellspacing="0" width="689" height="8" align="center">
  <tr> 
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="146" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="141" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="16" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="135" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="17" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="101" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="17" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="77" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="64" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td colspan="9"><img name="slice01" src="images/slice01.jpg" width="714" height="120" border="0" usemap="#m_slice01" alt="">
      <map name="m_slice01">
<area shape="rect" coords="8,7,697,106" href="../default.asp" alt="" >
</map></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="106" border="0"></td>
  </tr>
  <tr> 
    <td colspan="5"><img name="Site20trafic" src="images/Site%20trafic.gif" width="714" height="25" border="0" usemap="#m_Site20trafic" alt=""><map name="m_Site20trafic">
<area shape="rect" coords="663,4,694,20" href="../content/Jobs.htm" alt="" >
<area shape="rect" coords="569,6,647,21" href="../content/contactus.htm" alt="" >
<area shape="rect" coords="442,5,549,19" href="../online.asp" alt="" >
<area shape="rect" coords="284,5,426,21" href="../products.asp" alt="" >
<area shape="rect" coords="77,6,264,20" href="../content/aboutus.htm" alt="" >
<area shape="rect" coords="13,3,63,19" href="../default.asp" alt="" >
</map></td>
    <td rowspan="5">&nbsp;</td>
    <td rowspan="2" colspan="3">&nbsp;</td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td rowspan="3">&nbsp;</td>
    <td rowspan="4">&nbsp;</td>
    <td rowspan="3">&nbsp;</td>
    <td rowspan="4">&nbsp;</td>
    <td rowspan="3">&nbsp;</td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td rowspan="2">&nbsp;</td>
    <td height="9">&nbsp;</td>
    <td rowspan="2">&nbsp;</td>
    <td height="9"><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="11" border="0"></td>
  </tr>
  <tr> 
    <td><img name="slice13" src="http://www.collectoz.com/images/slice53.gif" width="77" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td rowspan="2" bgcolor="#336699">&nbsp;</td>
    <td rowspan="2" bgcolor="#336699">&nbsp;</td>
    <td rowspan="2" bgcolor="#336699">&nbsp;</td>
    <td rowspan="2" colspan="3" bgcolor="#336699">&nbsp;</td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="2" border="0"></td>
  </tr>
  <td height="13">&nbsp; 
</table>
<table width="715" border="0" cellspacing="0" cellpadding="0" height="143" align="center">
  <tr> 
    <td height="121" valign="top">      <p><FONT size="+1"><B><FONT face="Arial, Helvetica, sans-serif">Upload Debtors 
        <BR>
        </FONT></B><FONT size="-1" face="Arial, Helvetica, sans-serif"><A href="logout.asp">Click 
        here to log out</A></FONT></FONT></p>      
      <p><font face="Arial, Helvetica, sans-serif" size="-1">To begin the process
           of collecting your debt, we need to find out the neccessary information
          
        about your debtor. Please gather the required information and enter it
           into the fields below. When completed simply left-click on the &quot;Upload
        Debtor to debtorstocash.com&quot; button located at the bottom 
        of the page. Lets get started.</font></p>      <form name="Upload Debtors" method="post" action="http://mailgate.server-mail.com/cgi-bin/mailgate">
        <table width="600" border="0" cellspacing="0" cellpadding="3" align="center" height="337">
          <tr> 
            <td colspan="2"><b><font face="Arial, Helvetica, sans-serif" size="-1"> 
              Your Contact Information</font></b></td>
          </tr>
          <tr> 
            <td width="269"><font face="Arial, Helvetica, sans-serif" size="-1">Company 
              Name or Name of Partners:</font></td>
            <td width="331"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input name="Client Company Name/Partners" type="text" value="<%=(Recordset1.Fields.Item("CompName").Value)%>" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="269"><font face="Arial, Helvetica, sans-serif" size="-1">ABN 
              / ACN:</font></td>
            <td width="331"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input name="Cleint ABN/ACN" type="text" value="<%=(Recordset1.Fields.Item("CompABN_ACN").Value)%>" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="269"><font face="Arial, Helvetica, sans-serif" size="-1">Trading 
              Name/s:</font></td>
            <td width="331"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input name="Client Trading As" type="text" value="<%=(Recordset1.Fields.Item("CompTradAs").Value)%>" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="269" valign="top"><font face="Arial, Helvetica, sans-serif" size="-1">Trading 
              Address:<br>
              <font size="-4">Please enter full address including State, Post 
              code, and Country.</font> </font></td>
            <td width="331"><font face="Arial, Helvetica, sans-serif" size="-1">&nbsp; 
              </font> 
              <table width="75%" border="0">
                <tr> 
                  <td><font color="#000000"><%=(Recordset1.Fields.Item("CompTrdAdL1").Value)%></font></td>
                </tr>
                <tr> 
                  <td><font color="#000000"><%=(Recordset1.Fields.Item("CompTrdAdL2").Value)%></font></td>
                </tr>
                <tr> 
                  <td><font color="#000000"><%=(Recordset1.Fields.Item("CompTrdAdL3").Value)%></font></td>
                </tr>
                <tr>
                  <td><font color="#000000"><%=(Recordset1.Fields.Item("CompTrdCrty").Value)%></font></td>
                </tr>
              </table>
              <font face="Arial, Helvetica, sans-serif" size="-1">&nbsp; </font></td>
          </tr>
          <tr> 
            <td colspan="2" valign="top"> 
              <table width="600" border="0" cellspacing="0" cellpadding="3" align="center">
                <tr> 
                  <td width="269"><font face="Arial, Helvetica, sans-serif" size="-1">Contact 
                    Name/s:</font></td>
                  <td width="331"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
                    <input name="Client Contact Name" type="text" value="<%=(rsclient.Fields.Item("UsrName").Value)%>" size="40" maxlength="1000">
                    </font></td>
                </tr>
                <tr> 
                  <td width="269" height="26"><font face="Arial, Helvetica, sans-serif" size="-1">E-mail 
                    Address:</font></td>
                  <td width="331" height="26"> 
                    <input name="Client Email" type="text" value="<%=(rsclient.Fields.Item("Email").Value)%>" size="40" maxlength="1000">
                  </td>
                </tr>
                <tr> 
                  <td width="269" height="26"><font face="Arial, Helvetica, sans-serif" size="-1">Telephone 
                    #:</font></td>
                  <td width="331" height="26"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
                    <input name="Client Telephone#" type="text" value="<%=(rsclient.Fields.Item("Phone").Value)%>" size="30" maxlength="30">
                    </font></td>
                </tr>
                <tr> 
                  <td width="269"><font face="Arial, Helvetica, sans-serif" size="-1">Faxmail 
                    #:</font></td>
                  <td width="331"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
                    <input name="Client Fax#" type="text" value="<%=(rsclient.Fields.Item("Fax").Value)%>" size="30" maxlength="1000">
                    </font></td>
                </tr>
              </table>
              <font face="Arial, Helvetica, sans-serif" size="-1">&nbsp; </font></td>
          </tr>
        </table>
        <input type=hidden name="recipient" value="debtors@collectoz.com">
        <input type=hidden name="subject" value="Debtor Uploaded">
        <input type=hidden name="redirect" value="http://www.collectoz.com/ssl/confirm.asp">
        <input type=hidden name="realname" value="Online Services">
        <table width="601" border="0" cellspacing="0" cellpadding="3" align="center">
          <tr> 
            <td colspan="2"><b><font face="Arial, Helvetica, sans-serif" size="-1">Your 
              Debtor</font></b></td>
          </tr>
          <tr> 
            <td width="263"><font face="Arial, Helvetica, sans-serif" size="-1">Company 
              Name:</font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="Company Name" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="263"><font face="Arial, Helvetica, sans-serif" size="-1">ABN 
              / ACN: </font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="ACN/ABN" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="263"><font face="Arial, Helvetica, sans-serif" size="-1">Trading 
              Name/s:</font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="Trading as" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="263" height="63" valign="top"><font face="Arial, Helvetica, sans-serif" size="-1">Company 
              Director/s:</font><font face="Arial, Helvetica, sans-serif"><br>
              <font size="-3">If there are multiple directors, please list them 
              by placing a<br>
              semi-colon after each director.</font></font><br>
            </td>
            <td width="326" height="63" valign="top"> 
              <input type="text" name="Company Directors" value="" size="50">
            </td>
          </tr>
          <tr> 
            <td width="263" valign="top"> 
              <p><font face="Arial, Helvetica, sans-serif" size="-1">Trading Address:<br>
                <font size="-3">Please enter full address including State, Post 
                code, and<br>
                </font></font><font face="Arial, Helvetica, sans-serif" size="-3">Country.<br>
                </font></p>
            </td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <textarea name="Trading Address" wrap="VIRTUAL" cols="30" rows="3"></textarea>
              </font></td>
          </tr>
          <tr> 
            <td width="263" valign="top"><font face="Arial, Helvetica, sans-serif" size="-1">Postal 
              Address:<br>
              <font size="-3">Please enter full address including State, Post 
              code, and Country. </font> </font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <textarea name="Postal Address" wrap="VIRTUAL" cols="30" rows="3"></textarea>
              </font></td>
          </tr>
        </table>
        <br>
        <table width="601" border="0" cellspacing="0" cellpadding="3" align="center">
          <tr> 
            <td colspan="2"><b><font face="Arial, Helvetica, sans-serif" size="-1">Debtor 
              Contact Information</font></b></td>
          </tr>
          <tr> 
            <td width="263"><font face="Arial, Helvetica, sans-serif" size="-1">Contact 
              Name/s:</font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="Contact Name" size="40" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="263" height="26"><font face="Arial, Helvetica, sans-serif" size="-1">E-mail 
              Address:</font></td>
            <td width="326" height="26"> 
              <input type="text" name="Email" size="40" maxlength="1000">
            </td>
          </tr>
          <tr> 
            <td width="263" height="26"><font face="Arial, Helvetica, sans-serif" size="-1">Telephone 
              #:</font></td>
            <td width="326" height="26"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="Telephone#" size="30" maxlength="30">
              </font></td>
          </tr>
          <tr> 
            <td width="263"><font face="Arial, Helvetica, sans-serif" size="-1">Faxmail 
              #:</font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="Fax#" size="30" maxlength="1000">
              </font></td>
          </tr>
          <tr> 
            <td width="263"><font face="Arial, Helvetica, sans-serif" size="-1">Mobile 
              Telephone #:</font></td>
            <td width="326"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <input type="text" name="Mobile#" size="30" maxlength="1000">
              </font></td>
          </tr>
        </table>
        <br>
        <table width="602" border="0" cellpadding="0" cellspacing="0" height="240" align="center">
          <tr> 
            <td colspan="2" height="34"><font face="Arial, Helvetica, sans-serif" size="-1"><b>Information 
              of incurred debt</b></font></td>
          </tr>
          <tr valign="top"> 
            <td width="269" height="54"><font face="Arial, Helvetica, sans-serif" size="-1">The 
              Invoice Number:</font><br>
              <font face="Arial, Helvetica, sans-serif" size="-3">If you have 
              a number of invoices include only the first and<br>
              last issued.</font></td>
            <td height="54" width="330"> <p><font face="Arial, Helvetica, sans-serif" size="-1">First 
                Invoice# 
                <input type="text" name="Invoice#1" size="10">
                </font></p>
              <p><font face="Arial, Helvetica, sans-serif" size="-1">Last Invoice#
                <input type="text" name="Invoice#2" size="10">
              </font> </p></td>
          </tr>
          <tr valign="top"> 
            <td height="41" width="269"><font face="Arial, Helvetica, sans-serif" size="-1">Date 
              of Debt:</font><br>
              <font face="Arial, Helvetica, sans-serif" size="-3">The date which 
              the first invoice was issued. (DD/MM/YYYY)</font></td>
            <td height="41" width="330"> 
              <input type="text" name="Date of 1st Invoice" size="30">
            </td>
          </tr>
          <tr valign="top"> 
            <td height="40" width="269"><font face="Arial, Helvetica, sans-serif" size="-1">Date 
              of Last Invoice:</font><font face="Arial, Helvetica, sans-serif"><br>
              <font size="-3">The date when the last invoice was issued. </font><font face="Arial, Helvetica, sans-serif" size="-3">(DD/MM/YYYY)</font></font></td>
            <td height="40" width="330"> 
              <input type="text" name="Date of last invoice" size="30">
            </td>
          </tr>
          <tr> 
            <td height="48" width="269"><font size="-1" face="Arial, Helvetica, sans-serif">The 
              amount of debt:</font></td>
            <td height="48" width="330"> 
              <input type="text" name="Amount ($)" size="30" value="$0.00">
            </td>
          </tr>
          <tr valign="top"> 
            <td height="26" width="269"><font face="Arial, Helvetica, sans-serif" size="-1">The 
              debt was the result from:</font></td>
            <td height="26" width="330"> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <select name="Debt incurred by">
                <option>Please Select</option>
                <option value="goods sold">Goods sold</option>
                <option value="services rended">Services rended</option>
                <option value="dishonoured check">Dishonoured check</option>
                <option value="services rended and goods sold">Services rended
                and goods sold</option>
                            </select>
            </font></td>
          </tr>
        </table>
        <br>
        <table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
          <tr> 
            <td colspan="2" height="29"><b><font face="Arial, Helvetica, sans-serif" size="-1">Important 
              Information</font></b></td>
          </tr>
          <tr> 
            <td height="26"><font face="Arial, Helvetica, sans-serif" size="-1">Do 
              you have a signed Credit Application:</font></td>
            <td> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <select name="Credit App. Signed">
              <option selected>Please Select
              <option value="Yes">Yes
              <option value="No">No              
              </select>
              </font></td>
          </tr>
          <tr> 
            <td height="26"><font face="Arial, Helvetica, sans-serif" size="-1">Do 
              you have a Directors Guarantee:</font></td>
            <td> <font face="Arial, Helvetica, sans-serif" size="-1"> 
              <select name="Directors Guarantee">
              <option selected>Please Select
              <option value="Yes">Yes
              <option value="No">No              
              </select>
              </font></td>
          </tr>
        </table>
        <br>
        <table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
          <tr> 
            <td colspan="2" height="26"><b><font face="Arial, Helvetica, sans-serif" size="-1">What 
              to do next?</font></b></td>
          </tr>
          <tr> 
            <td width="375" height="26"><font face="Arial, Helvetica, sans-serif" size="-1">Would 
              you like us to make a debtor assessment call:</font></td>
            <td width="225" height="26"><font face="Arial, Helvetica, sans-serif" size="-1"> 
              <select name="Make Debt Assess Call">
                <option selected>Please Select</option>
                <option value="Yes">Yes</option>
                <option value="No">No</option>
              </select>
              </font></td>
          </tr>
          <tr> 
            <td width="375" height="38"><font face="Arial, Helvetica, sans-serif" size="-1">Would
                 you like us to issue a letter of demand from our
                 Solicitors:</font></td>
            <td width="225" height="38"><font face="Arial, Helvetica, sans-serif" size="-1"> 
              <select name="Issue Letter of Demand">
              <option selected>Please Select
              <option value="Yes">Yes
              <option value="No">No
              </select>
              </font></td>
          </tr>
          <tr> 
            <td width="375" height="26"><font face="Arial, Helvetica, sans-serif" size="-1">Take 
              immediate legal action to recover debt:</font></td>
            <td width="225" height="26"><font face="Arial, Helvetica, sans-serif" size="-1"> 
              <select name="Take Immediate Action">
                <option selected>Please Select</option>
                <option value="Not at this stage">Not at this stage</option>
                <option value="Yes - Magistrates Court">Yes - Magistrates Court</option>
                <option value="Yes - Minor Debt Court">Yes - Minor Debt Court</option>
              </select>
              </font></td>
          </tr>
        </table>
        <br>
        <table width="600" border="0" cellspacing="0" cellpadding="3" align="center">
          <tr> 
            <td align="center"> 
              <input type="reset" name="clear" value="      Cancel      " onClick="MM_goToURL('parent','https://bne070u.server-securmainmenu.asp');return document.MM_returnValue">
              <input type="submit" name="Send" value="        Upload Debtor to debtorstocash.com        ">
            </td>
          </tr>
        </table>
        <br>
        <br>
        <br>
        </form>      <p>&nbsp;</p></td>
  </tr>
</table>
<table width="714" border="0" cellpadding="0" cellspacing="0" align="center">
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif" size="-1">| <a href="../default.asp">Home</a> 
      | <a href="../content/aboutus.htm">About Us</a> | <a href="../products.asp">Products 
      &amp; Services</a> | <a href="../online.asp">Online Services</a> 
      | <a href="../content/contactus.htm">Contact Us</a> | <a href="../content/Jobs.htm">Jobs</a> 
      |<br>
      Site Designed by Leonard P.O'Grady<br>
      <font size="-2">&copy; Content Copyright 2002 Leonard P.O'Grady ABN
    80 340 504 889. </font></font></td>
  </tr>
</table>
</body>
</html>

<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<%
rsclient.Close()
Set rsclient = Nothing
%>
Cheers

Len
Reply With Quote
  #15 (permalink)  
Old February 4th, 2010, 01:26 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,652
Thanks: 3
Thanked 141 Times in 140 Posts
Default

I know you can override DW. But if you choose not to do so, you'll have to figure out how to get along with DW's mistaken assumptions about your pages and project. As I said, DW thinks that you are getting the CompanyID from the querystring, and you'll have to reconfigure it somehow (no, I don't know how) to convince it otherwiser. The problem surely stems from the fact that you have two tables where there should be only one, but I think trying to fix that, at this point in time, is even more difficult than convincing DW of the errors of its ways.

I'm sorry, but I honestly don't know what more I can do to help you. Were it my project, I would of course stop using DastardlyWeasel.

Maybe Imar will revisit and have some ideas.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
convert a SQL Statement from MS Access to a SQL Corey Access 6 March 28th, 2007 12:33 PM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
MS access in My SQL anukagni MySQL 2 March 10th, 2006 04:38 AM
Problem with SQL (MS-Access) and ASP DaPrince Access ASP 4 August 14th, 2004 08:11 AM



All times are GMT -4. The time now is 11:24 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.