Need help with this please

Need help with this please

AmbientAmbient Posts: 23Questions: 9Answers: 0

Okay, I am not a programmer but know a little. I have written quite complex scripts in autoit etc and have programmed in the past. I have been tasked with creating reports using data tables. We use Sybase and stored procedures. We then call the webservice. My boss has this working in a previous report for different data but for some reason, I just can't get this to show the search box. This displays the table nicely and is by no means complete but I am getting frustrated at this stage. I have tried different combinations of .js and .css files. I have also tried using base script call and various other combinations. What am I missing?

@param_Location varchar(15)= '0001',
@param_Code varchar(255)= null )
/* RESULT( column_name column_type, ... ) /
declare @location_no varchar(5),
@prod_code varchar(40),
@prod_desc varchar(40),
@ShopStock numeric(18,4),
@html_body TEXT,
@results TEXT,
@tablebody long varchar,
@stk_qty varchar(25),
@shoplist long varchar,
@shopname long varchar,
@shopnumber varchar(10)
message 'Location ['+@param_Location+']' to log
--message 'Code ['+param_Code+']' to log;
--set @results = '';
--set @tablebody = '';
set @shoplist = (select
'<option value="' || ClientNumber || '">' || ClientName || '</option>')
from DBA.Locations)
-- set @shopnumber = (select ClientNumber from DBA.Client where ClientName = shopname and ClientType = 'L');
--if(param_Code is not null) then
-- SET location_no = COALESCE(param_Location, '0006' );
-- set location_no = param_Location;
-- MESSAGE 'Location [' + param_Location + ']' TO LOG;
--SET @bodydata = ''
execute sa_set_http_header 'Content-Type','text/html'
--call sa_set_http_header('Content-Type','text/html');

set @tablebody
= (select
|| '<td>' || Productcode || '</td>'
|| '<td><B>' || Barcode || '</B></td>'
|| '<td><i>' || ProductDescription || '</i></td>'
|| '<td><B>' || Totalshelfstockquantity || '</B></td>'
-- '<td>'||sa.updatetimestamp||'</td>'||
|| '</tr>','') from DBA.StockListView)
select '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Available Stock Warehouse</title>

<link rel="stylesheet" type="text/css" href="/css/foundation.css"/>
<link rel="stylesheet" type="text/css" href="/css/foundation.min.css"/>
<link rel="stylesheet" type="text/css" href="/css/app.css"/>
<link rel="stylesheet" type="text/css" href=""/>
<link rel="stylesheet" href="DataTables/jquery.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="jquery.dataTables_themeroller.css"/>
<link rel="stylesheet" type="text/css" href="/css/reset.css"/>
<link rel="stylesheet" type="text/css" href="/css/opera.css"/>
<link rel="stylesheet" type="text/css" href=""/>
<link rel="stylesheet" type="text/css" href=""/>
<link rel="stylesheet" type="text/css" href=""/>


div class="container">

$(document).ready(function() { $("#example").dataTable( { "paging": false, "ordering": false, "info": false } ); } );

<Table id="image"><td valign="top" align="right"><a href="/"><img src="/images/Store_logo.png" width="358" height="105" border="0"></a></td></table>


table id="example1" class="display" cellspacing="0" width="100%">

' || @tablebody || '
Product Code Product Barcode Product DescriptionSafdar Warehouse StockLast Sold Date
Product Code Product Barcode Product Description Stock At Safdar Last Sold Date

Designed and created by ############### © 2007-2017.

end ```

This discussion has been closed.