Need help with this please
Need help with this please
Ambient
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?
```
ALTER PROCEDURE "WEBDBA"."StockCheck"(
@param_Location varchar(15)= '0001',
@param_Code varchar(255)= null )
/* RESULT( column_name column_type, ... ) /
as
begin
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
LIST(
'<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;
--Endif;
--SET @bodydata = ''/
execute sa_set_http_header 'Content-Type','text/html'
--call sa_set_http_header('Content-Type','text/html');
set @tablebody
= (select
LIST(
'<tr>'
|| '<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" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<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="https://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"/>
<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="https://cdn.jsdelivr.net/datatables.mark.js/2.0.0/datatables.mark.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/plug-ins/1.10.13/features/mark.js/datatables.mark.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.13/css/dataTables.jqueryui.min.css"/>
</head>
<body>
<
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>
<BR/>
<
table id="example1" class="display" cellspacing="0" width="100%">
| Product Code | Product Barcode | Product Description | Safdar Warehouse Stock | Last Sold Date |
|---|---|---|---|---|
| Product Code | Product Barcode | Product Description | Stock At Safdar | Last Sold Date |
'
end ```