anthonybison
New Member
Here is my code:\[code\]Set connFW = Server.CreateObject("ADODB.Connection")connFW.ConnectionTimeout = Application("FW_ConnectionTimeout")connFW.CommandTimeout = Application("FW_CommandTimeout")connFW.Open Application("FW_ConnectionString")\[/code\]From here, I include another file like this:\[code\]<!-- #include file="include\s_menubar2.inc" -->\[/code\]The included file has this code:\[code\]strIsIndependent ="sp_s_checkIndSupplier '" & Session("supplier_id") & "'"set rstIsIndependent = connFW.Execute(strIsIndependent)isIndpendent= rstIsIndependent("independent_supplier")\[/code\]And I'm getting this error:\[code\]Microsoft VBScript runtime error '800a01a8'Object required: ''/include\s_menubar2.inc, line 5\[/code\]NOTE: line 5 in s_menubar2.inc is this line:\[code\]set rstIsIndependent = connFW.Execute(strIsIndependent)\[/code\]It makes me think something is wrong with the SQL statement but here is the stored statement, and it seems fine to me...\[code\]Select independent_supplier, supplier From argus.Supplier Where supplier = @supplier_id\[/code\]