Solved

ASP error 0X800A0005

Posted on 2001-06-13
26
972 Views
Last Modified: 2012-05-04
I have an SQL database containing 2 procedures
each procedure takes 1 parameter
both procedures are owned by dbo
all users have exec permission on each procedure

I am using InterDev to create an ASP page.
I have added a connection and 2 DTC recordsets

the problem is when the page loads I get an error
Microsoft JScript runtine 0x800A0005
Invalid procedure call or argument
xxx.asp line 116

When I take out recordset 2 the page loads fine.
The problem only occurs when I add recordset2.

what could be wrong?
Both procedures are just simple queries on 1 or 2
tables where a specific column has a user entered value.

The columns have the same type and name in both procedures. they just retreive data from a different table.

Nancy
0
Comment
Question by:NancyCope
  • 11
  • 8
  • 3
  • +3
26 Comments
 
LVL 7

Expert Comment

by:John844
ID: 6188421
will the page work with just recordset 2?
0
 
LVL 7

Expert Comment

by:John844
ID: 6188426
make sure that you are using distinct names for both of the recordset controls.
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6188486
"Invalid procedure call or argument"
Comes when you use a function with zero values , Make sure functions you are using has values and not nulls. Code would be useful
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6188548
THe page does not work with just recordset2.
I am naming the controls recordset1 and recordset2

jitqanquly - I am not sure what you mean. What function?
The error appears when I add a DTC recordset.

first procedure
CREATE PROCEDURE GetRegNo
  (@regno Int)
AS

SELECT CO.RegistrationNumber, CO.Lat_deg, CO.Lat_min, CO.Lat_sec, CO.Lon_deg, CO.Lon_min, CO.Lon_sec,
              RA.StructureStreetAddress, RA.StructureCity, RA.StructureStateCode, RA.HeightOfStructure,
              RA.GroundElevation, RA.OverallHeightAboveGround, RA.OverallHeightAMSL,
              RA.StructureType, RA.FAAStudyNumber
FROM CO INNER JOIN RA ON
            (CO.RegistrationNumber = RA.RegistrationNumber)
          AND
           (CO.UniqueSystemIdentifier = RA.UniqueSystemIndicator)
WHERE
        CO.RegistrationNumber = @regno

return
GO

second procedure:

CREATE Procedure GetEntity
(@regno Int)

As

     SELECT RegistrationNumber, entityname, firstname, lastname, phone,
            streetaddress, city, state, zipcode, attention
     FROM EN
     
     WHERE
          RegistrationNumber = @regno
     
return
GO

I have added commands to the connection.  each command is
named differently and references a different stored procedure.
Both of these procedures run fine from SQL Analyzer.

Nancy
0
 
LVL 2

Expert Comment

by:Fenatu
ID: 6189133
You're running this in JScript? I've never done server side JScript, but I'm guessing it's as finicky as Javascript. Does the AS have to be capitalized? Only thing I see different between the two, unless you're trying to select a field that doesn't exist in the EN table.
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6191104
I dont think the problem is with the procedure itself
because I can run the procedure from query analyzer
without any problems.

I am using Design Time Controls for the recordsets
so whatever is the default is being used for both
recordsets.

Nancy
0
 
LVL 11

Expert Comment

by:jekl2000
ID: 6191465
Maybe this will give you some ideas.



Invalid procedure call or argument
You passed an invalid parameter in your procedure call. This could be because the parameter was out of range, or contained invalid data. Alternately, you may have invoked a procedure at an unexpected time.

To correct this error

Verify that the parameters being passed to the procedure are valid.
Verify that you are calling the function at an appropriate time.
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6191612
Nancy,
Could you post the whole code please. I don't think its a hard issue
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192074
OK, below is the entire code in the ASP file.
The previous code was the SQL procedures.

To me its a hard issue because I am new to ASP and
InterDev programming.

<%@ Language=VBScript %>
<SCRIPT id=DebugDirectives runat=server language=javascript>
// Set these to true to enable debugging or tracing
@set @debug=false
@set @trace=false
</SCRIPT>
<% ' VI 6.0 Scripting Object Model Enabled %>
<!--#include file="../_ScriptLibrary/pm.asp"-->
<% if StartPageProcessing() Then Response.End() %>
<FORM name=thisForm METHOD=post>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">


<SCRIPT ID=serverEventHandlersVBS LANGUAGE=vbscript RUNAT=Server>

Sub btnGO_onclick()
 
  Recordset1.setParameter 1, Textbox1.value
  Recordset1.open
 
  If Recordset1.EOF then
    'no records found
    'display message
    If Label1.isVisible() = False then
        Label1.Show()
    End If
    'clear feet textboxes
        Textbox18.value = ""
        Textbox19.value = ""
        Textbox20.value = ""
        Textbox21.value = ""
   
  else
    'label should be invisible
    If Label1.isVisible() = True Then
      Label1.Hide()
    End If
      'update feet text boxes
      Textbox18.value = Textbox12.value * 3.28
      Textbox19.value = Textbox13.value * 3.28
      Textbox20.value = Textbox14.value * 3.28
      Textbox21.value = Textbox15.value * 3.28  
  End If
 
 
  Recordset1.close
 
 
End Sub


Sub Textbox1_onchange()
  'simulate click GO
  btnGO_onclick()
 
End Sub

</SCRIPT>
</HEAD>
<BODY>
<P>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:9CF5D7C2-EC10-11D0-9862-0000F8027CA0" id=Recordset1 style="LEFT: 0px; TOP: 0px">
      <PARAM NAME="ExtentX" VALUE="12197">
      <PARAM NAME="ExtentY" VALUE="2090">
      <PARAM NAME="State" VALUE="(TCConn=\qcnnTowAir\q,TCDBObject=\qDE\sCommands\q,TCDBObjectName=\qcmdRegNo\q,TCControlID_Unmatched=\qRecordset1\q,TCPPConn=\qcnnTowAir\q,RCDBObject=\qRCDBObject\q,TCPPDBObject=\qDE\sCommands\q,TCPPDBObjectName=\qcmdRegNo\q,TCCursorType=\q3\s-\sStatic\q,TCCursorLocation=\q3\s-\sUse\sclient-side\scursors\q,TCLockType=\q3\s-\sOptimistic\q,TCCacheSize_Unmatched=\q100\q,TCCommTimeout_Unmatched=\q30\q,CCPrepared=0,CCAllRecords=1,TCNRecords_Unmatched=\q10\q,TCODBCSyntax_Unmatched=\q{?\s=\sCALL\sdbo.GetRegNo(\s?)\s}\q,TCHTargetPlatform=\q\q,TCHTargetBrowser_Unmatched=\qServer\s(ASP)\q,TCTargetPlatform=\qInherit\sfrom\spage\q,RCCache=\qRCBookPage\q,CCOpen=0,GCParameters=(Rows=1,Row1=(CType_Unmatched=\qIn\q,CParName_Unmatched=\qregno\q,CDataType_Unmatched=\qInteger\q,CSize_Unmatched=\q0\q,CReq=1)))">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<!--#INCLUDE FILE="../_ScriptLibrary/Recordset.ASP"-->
<SCRIPT LANGUAGE="JavaScript" RUNAT="server">
function _setParametersRecordset1()
{
}
function _initRecordset1()
{
      Recordset1.advise(RS_ONBEFOREOPEN, _setParametersRecordset1);
      thisPage.createDE();
      var rsTmp = DE.Recordsets('cmdRegNo');
      Recordset1.setRecordSource(rsTmp);
      if (thisPage.getState('pb_Recordset1') != null)
            Recordset1.setBookmark(thisPage.getState('pb_Recordset1'));
}
function _Recordset1_ctor()
{
      CreateRecordset('Recordset1', _initRecordset1, null);
}
function _Recordset1_dtor()
{
      Recordset1._preserveState();
      thisPage.setState('pb_Recordset1', Recordset1.getBookmark());
}
</SCRIPT>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:9CF5D7C2-EC10-11D0-9862-0000F8027CA0" id=Recordset2 style="LEFT: 0px; TOP: 0px">
      <PARAM NAME="ExtentX" VALUE="12197">
      <PARAM NAME="ExtentY" VALUE="2090">
      <PARAM NAME="State" VALUE="(TCConn=\qcnnTowAir\q,TCDBObject=\qDE\sCommands\q,TCDBObjectName=\qcmdEntity\q,TCControlID_Unmatched=\qRecordset2\q,TCPPConn=\qcnnTowAir\q,RCDBObject=\qRCDBObject\q,TCPPDBObject=\qDE\sCommands\q,TCPPDBObjectName=\qcmdEntity\q,TCCursorType=\q3\s-\sStatic\q,TCCursorLocation=\q3\s-\sUse\sclient-side\scursors\q,TCLockType=\q3\s-\sOptimistic\q,TCCacheSize_Unmatched=\q100\q,TCCommTimeout_Unmatched=\q0\q,CCPrepared=0,CCAllRecords=1,TCNRecords_Unmatched=\q10\q,TCODBCSyntax_Unmatched=\q{?\s=\sCALL\sdbo.GetEntity(\s?)\s}\q,TCHTargetPlatform=\q\q,TCHTargetBrowser_Unmatched=\qServer\s(ASP)\q,TCTargetPlatform=\qInherit\sfrom\spage\q,RCCache=\qRCBookPage\q,CCOpen=0,GCParameters=(Rows=1,Row1=(CType_Unmatched=\qIn\q,CParName_Unmatched=\q@regno\q,CDataType_Unmatched=\qInteger\q,CSize_Unmatched=\q0\q,CReq=1)))">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE="JavaScript" RUNAT="server">
function _setParametersRecordset2()
{
}
function _initRecordset2()
{
      Recordset2.advise(RS_ONBEFOREOPEN, _setParametersRecordset2);
      thisPage.createDE();
      var rsTmp = DE.Recordsets('cmdEntity');
      Recordset2.setRecordSource(rsTmp);
      if (thisPage.getState('pb_Recordset2') != null)
            Recordset2.setBookmark(thisPage.getState('pb_Recordset2'));
}
function _Recordset2_ctor()
{
      CreateRecordset('Recordset2', _initRecordset2, null);
}
function _Recordset2_dtor()
{
      Recordset2._preserveState();
      thisPage.setState('pb_Recordset2', Recordset2.getBookmark());
}
</SCRIPT>

<!--METADATA TYPE="DesignerControl" endspan-->
<P>Enter Registration Number:&nbsp;</P>
<P>&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" id=Textbox1 style="LEFT: 0px; TOP: 0px">
      <PARAM NAME="_ExtentX" VALUE="3175">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox1">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="RegistrationNumber">
      <PARAM NAME="Enabled" VALUE="-1">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="20">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<!--#INCLUDE FILE="../_ScriptLibrary/TextBox.ASP"-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox1()
{
      Textbox1.setStyle(TXT_TEXTBOX);
      Textbox1.setDataSource(Recordset1);
      Textbox1.setDataField('RegistrationNumber');
      Textbox1.setMaxLength(20);
      Textbox1.setColumnCount(20);
}
function _Textbox1_ctor()
{
      CreateTextbox('Textbox1', _initTextbox1, null);
}
</script>
<% Textbox1.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B6FC3A14-F837-11D0-9CC8-006008058731" height=27 id=btnGO style="HEIGHT: 27px; LEFT: 0px; TOP: 0px; WIDTH: 38px"
      width=38>
      <PARAM NAME="_ExtentX" VALUE="1005">
      <PARAM NAME="_ExtentY" VALUE="714">
      <PARAM NAME="id" VALUE="btnGO">
      <PARAM NAME="Caption" VALUE="GO">
      <PARAM NAME="Image" VALUE="">
      <PARAM NAME="AltText" VALUE="">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="Platform" VALUE="256">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<!--#INCLUDE FILE="../_ScriptLibrary/Button.ASP"-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initbtnGO()
{
      btnGO.value = 'GO';
      btnGO.setStyle(0);
}
function _btnGO_ctor()
{
      CreateButton('btnGO', _initbtnGO, null);
}
</script>
<% btnGO.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>
<P>
<HR>
Search Results
<P></P>
<P>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E460-DC5F-11D0-9846-0000F8027CA0" height=17 id=Label1 style="HEIGHT: 17px; LEFT: 0px; TOP: 0px; WIDTH: 116px"
      width=116>
      <PARAM NAME="_ExtentX" VALUE="3069">
      <PARAM NAME="_ExtentY" VALUE="450">
      <PARAM NAME="id" VALUE="Label1">
      <PARAM NAME="DataSource" VALUE="">
      <PARAM NAME="DataField" VALUE="Sorry No records found">
      <PARAM NAME="FontFace" VALUE="">
      <PARAM NAME="FontSize" VALUE="">
      <PARAM NAME="FontColor" VALUE="Red">
      <PARAM NAME="FontBold" VALUE="0">
      <PARAM NAME="FontItalic" VALUE="0">
      <PARAM NAME="Visible" VALUE="0">
      <PARAM NAME="FormatAsHTML" VALUE="0">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<!--#INCLUDE FILE="../_ScriptLibrary/Label.ASP"-->
<FONT COLOR="Red">
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initLabel1()
{
      Label1.hide();
      Label1.setCaption('Sorry No records found');
}
function _Label1_ctor()
{
      CreateLabel('Label1', _initLabel1, null);
}
</script>
<% Label1.display %>
</FONT>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
 
<P></P>
<P>Registration Number:&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" id=Textbox2 style="LEFT: 0px; TOP: 0px">
      <PARAM NAME="_ExtentX" VALUE="3175">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox2">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="RegistrationNumber">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="20">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox2()
{
      Textbox2.setStyle(TXT_TEXTBOX);
      Textbox2.setDataSource(Recordset1);
      Textbox2.setDataField('RegistrationNumber');
      Textbox2.disabled = true;
      Textbox2.setMaxLength(20);
      Textbox2.setColumnCount(20);
}
function _Textbox2_ctor()
{
      CreateTextbox('Textbox2', _initTextbox2, null);
}
</script>
<% Textbox2.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>Latitude:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox3
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 18px" width=18>
      <PARAM NAME="_ExtentX" VALUE="476">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox3">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="Lat_deg">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="4">
      <PARAM NAME="DisplayWidth" VALUE="3">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox3()
{
      Textbox3.setStyle(TXT_TEXTBOX);
      Textbox3.setDataSource(Recordset1);
      Textbox3.setDataField('Lat_deg');
      Textbox3.disabled = true;
      Textbox3.setMaxLength(4);
      Textbox3.setColumnCount(3);
}
function _Textbox3_ctor()
{
      CreateTextbox('Textbox3', _initTextbox3, null);
}
</script>
<% Textbox3.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox4
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 18px" width=18>
      <PARAM NAME="_ExtentX" VALUE="476">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox4">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="Lat_min">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="4">
      <PARAM NAME="DisplayWidth" VALUE="3">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox4()
{
      Textbox4.setStyle(TXT_TEXTBOX);
      Textbox4.setDataSource(Recordset1);
      Textbox4.setDataField('Lat_min');
      Textbox4.disabled = true;
      Textbox4.setMaxLength(4);
      Textbox4.setColumnCount(3);
}
function _Textbox4_ctor()
{
      CreateTextbox('Textbox4', _initTextbox4, null);
}
</script>
<% Textbox4.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp; &nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox5
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 30px" width=30>
      <PARAM NAME="_ExtentX" VALUE="794">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox5">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="Lat_sec">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="21">
      <PARAM NAME="DisplayWidth" VALUE="5">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox5()
{
      Textbox5.setStyle(TXT_TEXTBOX);
      Textbox5.setDataSource(Recordset1);
      Textbox5.setDataField('Lat_sec');
      Textbox5.disabled = true;
      Textbox5.setMaxLength(21);
      Textbox5.setColumnCount(5);
}
function _Textbox5_ctor()
{
      CreateTextbox('Textbox5', _initTextbox5, null);
}
</script>
<% Textbox5.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>Longitude:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox6
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 18px" width=18>
      <PARAM NAME="_ExtentX" VALUE="476">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox6">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="Lon_deg">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="3">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox6()
{
      Textbox6.setStyle(TXT_TEXTBOX);
      Textbox6.setDataSource(Recordset1);
      Textbox6.setDataField('Lon_deg');
      Textbox6.disabled = true;
      Textbox6.setMaxLength(20);
      Textbox6.setColumnCount(3);
}
function _Textbox6_ctor()
{
      CreateTextbox('Textbox6', _initTextbox6, null);
}
</script>
<% Textbox6.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox7
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 18px" width=18>
      <PARAM NAME="_ExtentX" VALUE="476">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox7">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="Lon_min">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="3">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox7()
{
      Textbox7.setStyle(TXT_TEXTBOX);
      Textbox7.setDataSource(Recordset1);
      Textbox7.setDataField('Lon_min');
      Textbox7.disabled = true;
      Textbox7.setMaxLength(20);
      Textbox7.setColumnCount(3);
}
function _Textbox7_ctor()
{
      CreateTextbox('Textbox7', _initTextbox7, null);
}
</script>
<% Textbox7.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox8
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 30px" width=30>
      <PARAM NAME="_ExtentX" VALUE="794">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox8">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="Lon_sec">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="5">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox8()
{
      Textbox8.setStyle(TXT_TEXTBOX);
      Textbox8.setDataSource(Recordset1);
      Textbox8.setDataField('Lon_sec');
      Textbox8.disabled = true;
      Textbox8.setMaxLength(20);
      Textbox8.setColumnCount(5);
}
function _Textbox8_ctor()
{
      CreateTextbox('Textbox8', _initTextbox8, null);
}
</script>
<% Textbox8.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>Structure Address:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox9
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 258px" width=258>
      <PARAM NAME="_ExtentX" VALUE="6826">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox9">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="StructureStreetAddress">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="50">
      <PARAM NAME="DisplayWidth" VALUE="43">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox9()
{
      Textbox9.setStyle(TXT_TEXTBOX);
      Textbox9.setDataSource(Recordset1);
      Textbox9.setDataField('StructureStreetAddress');
      Textbox9.disabled = true;
      Textbox9.setMaxLength(50);
      Textbox9.setColumnCount(43);
}
function _Textbox9_ctor()
{
      CreateTextbox('Textbox9', _initTextbox9, null);
}
</script>
<% Textbox9.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>City:&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox10
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 150px" width=150>
      <PARAM NAME="_ExtentX" VALUE="3969">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox10">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="StructureCity">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="25">
      <PARAM NAME="DisplayWidth" VALUE="25">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox10()
{
      Textbox10.setStyle(TXT_TEXTBOX);
      Textbox10.setDataSource(Recordset1);
      Textbox10.setDataField('StructureCity');
      Textbox10.disabled = true;
      Textbox10.setMaxLength(25);
      Textbox10.setColumnCount(25);
}
function _Textbox10_ctor()
{
      CreateTextbox('Textbox10', _initTextbox10, null);
}
</script>
<% Textbox10.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>State:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox11
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 30px" width=30>
      <PARAM NAME="_ExtentX" VALUE="794">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox11">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="StructureStateCode">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="5">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox11()
{
      Textbox11.setStyle(TXT_TEXTBOX);
      Textbox11.setDataSource(Recordset1);
      Textbox11.setDataField('StructureStateCode');
      Textbox11.disabled = true;
      Textbox11.setMaxLength(20);
      Textbox11.setColumnCount(5);
}
function _Textbox11_ctor()
{
      CreateTextbox('Textbox11', _initTextbox11, null);
}
</script>
<% Textbox11.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp; </P>
<P>Structure Height:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox12
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 48px" width=48>
      <PARAM NAME="_ExtentX" VALUE="1270">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox12">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="HeightOfStructure">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="8">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox12()
{
      Textbox12.setStyle(TXT_TEXTBOX);
      Textbox12.setDataSource(Recordset1);
      Textbox12.setDataField('HeightOfStructure');
      Textbox12.disabled = true;
      Textbox12.setMaxLength(20);
      Textbox12.setColumnCount(8);
}
function _Textbox12_ctor()
{
      CreateTextbox('Textbox12', _initTextbox12, null);
}
</script>
<% Textbox12.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;meters&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox18
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 48px" width=48>
      <PARAM NAME="_ExtentX" VALUE="1270">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox18">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="">
      <PARAM NAME="DataField" VALUE="">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="8">
      <PARAM NAME="Platform" VALUE="256">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox18()
{
      Textbox18.setStyle(TXT_TEXTBOX);
      Textbox18.disabled = true;
      Textbox18.setMaxLength(20);
      Textbox18.setColumnCount(8);
}
function _Textbox18_ctor()
{
      CreateTextbox('Textbox18', _initTextbox18, null);
}
</script>
<% Textbox18.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;feet</P>
<P>Ground Elevation:&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox13
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 48px" width=48>
      <PARAM NAME="_ExtentX" VALUE="1270">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox13">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="GroundElevation">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="8">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox13()
{
      Textbox13.setStyle(TXT_TEXTBOX);
      Textbox13.setDataSource(Recordset1);
      Textbox13.setDataField('GroundElevation');
      Textbox13.disabled = true;
      Textbox13.setMaxLength(20);
      Textbox13.setColumnCount(8);
}
function _Textbox13_ctor()
{
      CreateTextbox('Textbox13', _initTextbox13, null);
}
</script>
<% Textbox13.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
meters&nbsp;&nbsp;&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox19
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 48px" width=48>
      <PARAM NAME="_ExtentX" VALUE="1270">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox19">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="">
      <PARAM NAME="DataField" VALUE="">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="8">
      <PARAM NAME="Platform" VALUE="256">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox19()
{
      Textbox19.setStyle(TXT_TEXTBOX);
      Textbox19.disabled = true;
      Textbox19.setMaxLength(20);
      Textbox19.setColumnCount(8);
}
function _Textbox19_ctor()
{
      CreateTextbox('Textbox19', _initTextbox19, null);
}
</script>
<% Textbox19.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;feet</P>
<P>Overall Hgt Above Ground:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox14
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 48px" width=48>
      <PARAM NAME="_ExtentX" VALUE="1270">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox14">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="OverallHeightAboveGround">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="8">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox14()
{
      Textbox14.setStyle(TXT_TEXTBOX);
      Textbox14.setDataSource(Recordset1);
      Textbox14.setDataField('OverallHeightAboveGround');
      Textbox14.disabled = true;
      Textbox14.setMaxLength(20);
      Textbox14.setColumnCount(8);
}
function _Textbox14_ctor()
{
      CreateTextbox('Textbox14', _initTextbox14, null);
}
</script>
<% Textbox14.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
meters&nbsp;&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox20
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 60px" width=60>
      <PARAM NAME="_ExtentX" VALUE="1588">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox20">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="">
      <PARAM NAME="DataField" VALUE="">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="10">
      <PARAM NAME="Platform" VALUE="256">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox20()
{
      Textbox20.setStyle(TXT_TEXTBOX);
      Textbox20.disabled = true;
      Textbox20.setMaxLength(20);
      Textbox20.setColumnCount(10);
}
function _Textbox20_ctor()
{
      CreateTextbox('Textbox20', _initTextbox20, null);
}
</script>
<% Textbox20.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;feet</P>
<P>Overall Height AMSL:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox15
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 48px" width=48>
      <PARAM NAME="_ExtentX" VALUE="1270">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox15">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="OverallHeightAMSL">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="8">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox15()
{
      Textbox15.setStyle(TXT_TEXTBOX);
      Textbox15.setDataSource(Recordset1);
      Textbox15.setDataField('OverallHeightAMSL');
      Textbox15.disabled = true;
      Textbox15.setMaxLength(20);
      Textbox15.setColumnCount(8);
}
function _Textbox15_ctor()
{
      CreateTextbox('Textbox15', _initTextbox15, null);
}
</script>
<% Textbox15.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;meters&nbsp;&nbsp;
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" height=19 id=Textbox21
      style="HEIGHT: 19px; LEFT: 0px; TOP: 0px; WIDTH: 60px" width=60>
      <PARAM NAME="_ExtentX" VALUE="1588">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox21">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="">
      <PARAM NAME="DataField" VALUE="">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="10">
      <PARAM NAME="Platform" VALUE="256">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox21()
{
      Textbox21.setStyle(TXT_TEXTBOX);
      Textbox21.disabled = true;
      Textbox21.setMaxLength(20);
      Textbox21.setColumnCount(10);
}
function _Textbox21_ctor()
{
      CreateTextbox('Textbox21', _initTextbox21, null);
}
</script>
<% Textbox21.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
&nbsp;feet</P>
<P>Structure Type:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" id=Textbox16 style="LEFT: 0px; TOP: 0px">
      <PARAM NAME="_ExtentX" VALUE="3175">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox16">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="StructureType">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="20">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox16()
{
      Textbox16.setStyle(TXT_TEXTBOX);
      Textbox16.setDataSource(Recordset1);
      Textbox16.setDataField('StructureType');
      Textbox16.disabled = true;
      Textbox16.setMaxLength(20);
      Textbox16.setColumnCount(20);
}
function _Textbox16_ctor()
{
      CreateTextbox('Textbox16', _initTextbox16, null);
}
</script>
<% Textbox16.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>FAA Study Number:
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT classid="clsid:B5F0E469-DC5F-11D0-9846-0000F8027CA0" id=Textbox17 style="LEFT: 0px; TOP: 0px">
      <PARAM NAME="_ExtentX" VALUE="3175">
      <PARAM NAME="_ExtentY" VALUE="503">
      <PARAM NAME="id" VALUE="Textbox17">
      <PARAM NAME="ControlType" VALUE="0">
      <PARAM NAME="Lines" VALUE="3">
      <PARAM NAME="DataSource" VALUE="Recordset1">
      <PARAM NAME="DataField" VALUE="FAAStudyNumber">
      <PARAM NAME="Enabled" VALUE="0">
      <PARAM NAME="Visible" VALUE="-1">
      <PARAM NAME="MaxChars" VALUE="20">
      <PARAM NAME="DisplayWidth" VALUE="20">
      <PARAM NAME="Platform" VALUE="0">
      <PARAM NAME="LocalPath" VALUE="../"></OBJECT>
-->
<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initTextbox17()
{
      Textbox17.setStyle(TXT_TEXTBOX);
      Textbox17.setDataSource(Recordset1);
      Textbox17.setDataField('FAAStudyNumber');
      Textbox17.disabled = true;
      Textbox17.setMaxLength(20);
      Textbox17.setColumnCount(20);
}
function _Textbox17_ctor()
{
      CreateTextbox('Textbox17', _initTextbox17, null);
}
</script>
<% Textbox17.display %>

<!--METADATA TYPE="DesignerControl" endspan-->
</P>
<P>&nbsp;</P>
<P>&nbsp;</P>

</BODY>
<% ' VI 6.0 Scripting Object Model Enabled %>
<% EndPageProcessing() %>
</FORM>
</HTML>
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6192196
and what is line 116 ?
0
 
LVL 11

Expert Comment

by:jekl2000
ID: 6192482
If you change this to Recordset2 will recordset2 work and RS 1 not?


Sub btnGO_onclick()
 
 Recordset1.setParameter 1, Textbox1.value
 Recordset1.open
 
 If Recordset1.EOF then
   

0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192511
I am not sure which lines count.  Line 116 just has }
If you don't count the recordset controls then line
116 is Recordset2_preserveState();

This code is automatically generated when the DTC is
added and cannot be edited.

I was able to get it to work by changing the
Database object form the DE Command to a stored procedure.

I found some information in the help files Q235644 that lists this problem but the error would be generated in
pm.asp - not the asp file I am getting the error from.

Could there possibly be a problem with the method I
use to develop.  My development machine is a laptop
using Windows 98, PWS, and InterDev.  The web server
is on another machine using Windows 2000 and the IIS
that comes with 2000.  When I started this project I
created a new project, used the 2000 server and local mode,
Connected to an existing application.
In order to test my pages I need to release the working
copy and go to that web page in IE.  I have tried to view my copy in browser and that doesn't work.

0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192523
the recordsets are both set to not open automatically.
The error occurs immediately upon trying to load the
page - before any recordset is opened.

Nancy
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 20

Expert Comment

by:jitganguly
ID: 6192544
Let me see. Just cut and paste the exact error message for me please
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192617
here is the error page.

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the rccweb home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft JScript runtime (0x800A0005)
Invalid procedure call or argument
/tf/towair/towair2.asp, line 124


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows 98; AT&T WNS5.0 IE5.0.01; AT&T WNS5.0)

Page:
GET /tf/towair/towair2.asp

Time:
Thursday, June 14, 2001, 3:21:45 PM


More information:
Microsoft Support
 
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6192638
Probably it is not finding the SP. Have you given permission GRANT EXECUTE on ... TO ...
How do you connect to db ? As a which user ?
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192684
Yes, everybody has execute permission on all procedures,
The problem seems to be with the Command. WHen I change
the DatabaseObject of the DTC from DECommand to Stored Procedure I don't get the error.

Nancy
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6192713
Thats the way it should be. If have to choose Stored procedure is database object and choose teh name of the SP in the object.
See MSDN help her
Database object

Choose this button, and then select the type of database object you want from the box to the right of the button. You can select any database object from the database specified in the Connection box. For example, you can select a table, view, or stored procedure from a SQL Server database as a source of the Recordset control's data.

You can also select DE Commands and then in the Object name box select any Command object from the data environment that specifies a set of records for this recordset.

This setting and the Connection and Object name settings on this tab are used to create script on your HTML page that connects to the database specified by the data connection and retrieves the specified data.

Note   You can also set this property directly on the Recordset control in Source view on your ASP page.

Object name

Select the name of a database object of the type you selected in the Database object box. For example, if you selected Tables in the Database object box, in the Object name box select the name of a table from the database specified in the Connection box.

You can also select DE Commands in the Database object box and then in the Object name box select any Command object from the data environment that specifies a set of records for this recordset.


Are you still gettign the error ?
0
 
LVL 11

Expert Comment

by:jekl2000
ID: 6192807
If you change this to Recordset2 will recordset2 work and RS 1 not?


Sub btnGO_onclick()
 
 Recordset1.setParameter 1, Textbox1.value
 Recordset1.open
 
 If Recordset1.EOF then
   

0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192840
jekl2000 - I looked again at recordset1 and it works
because I am using the stored procedure directly from
the database not the DE Command.

Neither recordset works using the DECommand. THe commands
I created reference these same stored procedures though.

Nancy
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6192863
Nancy,
In Database Object, can you see Stored procedure or something ? Then choose that. Next in hte object name you will have to specify the actual name of the SP.
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6192938
That is what I have done.  I click in DatabaseObject and
select DECommands, then I select the command from the
other dropdown box.  This is when I get the error.

As I said a few hours ago, I can get it to work when
I change the Database Object from DECOmmands to StoredProcedure.  The problem is - what good is creating
a command on the database connection if I cannot use them?

0
 
LVL 1

Author Comment

by:NancyCope
ID: 6196347
I am closing out this question because I have discovered
the answer to my question on my own.

I fixed the problem by clicking on the global.asa file
and selecting release working copy.

Nancy
0
 
LVL 1

Author Comment

by:NancyCope
ID: 6196353
I have discovered the answer to my question on my own

I clicked on the global.asa file and selected release
working copy.

Nancy
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 6196367
OK alright
I missed some points
:-)
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 6945966
This question was still open today, but you stated you found your own solution so I have refunded to you 200 points for this and closed this by moving it to our PAQ at zero points.

When this type of event occurs, please post a zero point question in Community Support with the question link so we can help you with this.

Moondancer - EE Moderator
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now