Hi there,
I hope that someone can help me starting to integrate my .cgi I used with links 2.0 for links sql. I need to access some data from the links database and had it stored in an array before. The code was like:
open(PRODUCTS, $PRODUCT_INFO)
| | &ws_error('open->product_info', $PRODUCT_INFO);
while ($record= <PRODUCTS> ) {
local($ref_name, $name, $weight, $datum, $filename, $note, $price, $euro) = split(/\Q|\E/o, $record);
$PRODUCT_WEIGHT{$ref_name} = $weight;
$CONFIG{'PRODUCT_WEIGHT_' . $ref_name} = $weight;
$PRODUCT_NAME{$ref_name} = $name;
$CONFIG{'PRODUCT_NAME_' . $ref_name} = $name;
$PRODUCT_COST{$ref_name} = $price;
$CONFIG{'PRODUCT_PRICE_' . $ref_name} = $price;
$PRODUCT_NR{$ref_name} = $ref_name;
$CONFIG{'PRODUCT_NR_' . $ref_name} = $ref_name;
push(@products, $ref_name);
}
close(PRODUCTS);
I know that I have to add:
use CGI ();
use CGI::Carp qw/fatalsToBrowser/;
use Links;
use Links: BSQL;
use Links: B_Utils;
use Links::HTML_Templates;
use strict;
use vars qw($USE_HTML $LINKDB $CATDB $EMAIL $HIERARCH $GRAND_TOTAL);
$|++;
but I don´t know how I can access the data then. Thanks for your help
Niko
I hope that someone can help me starting to integrate my .cgi I used with links 2.0 for links sql. I need to access some data from the links database and had it stored in an array before. The code was like:
open(PRODUCTS, $PRODUCT_INFO)
| | &ws_error('open->product_info', $PRODUCT_INFO);
while ($record= <PRODUCTS> ) {
local($ref_name, $name, $weight, $datum, $filename, $note, $price, $euro) = split(/\Q|\E/o, $record);
$PRODUCT_WEIGHT{$ref_name} = $weight;
$CONFIG{'PRODUCT_WEIGHT_' . $ref_name} = $weight;
$PRODUCT_NAME{$ref_name} = $name;
$CONFIG{'PRODUCT_NAME_' . $ref_name} = $name;
$PRODUCT_COST{$ref_name} = $price;
$CONFIG{'PRODUCT_PRICE_' . $ref_name} = $price;
$PRODUCT_NR{$ref_name} = $ref_name;
$CONFIG{'PRODUCT_NR_' . $ref_name} = $ref_name;
push(@products, $ref_name);
}
close(PRODUCTS);
I know that I have to add:
use CGI ();
use CGI::Carp qw/fatalsToBrowser/;
use Links;
use Links: BSQL;
use Links: B_Utils;
use Links::HTML_Templates;
use strict;
use vars qw($USE_HTML $LINKDB $CATDB $EMAIL $HIERARCH $GRAND_TOTAL);
$|++;
but I don´t know how I can access the data then. Thanks for your help
Niko