Hello,
I've looked this over and over and over until it's now 2:50 in the mornin, and Im just not seeing what's causing this problem.
Basically, I enter a test record, click on Build All, and it replaces the record id number in the database with either No or Yes.
Heres my links.def file, perhaps someone will spot something right away or try it on their test links systems to see if it happens to them as well, and help me to find out why.
# Links
# -------------
# Links Manager
#
# File: links.def
# Description: Contains the database definition for links.
# Author: Alex Krohn
# Email: alex@gossamer-threads.com
# Web: http://www.gossamer-threads.com/
# Version: 2.0
#
# (c) 1998 Gossamer Threads Inc.
#
# This script is not freeware! Please read the README for full details
# on registration and terms of use.
# =====================================================================
# Database Definition: LINKS
# --------------------------------------------------------
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
'Product ident' => [1, 'alpha', 15, 75, 1, '', ''],
Description => [2, 'alpha', '40x3', 900, 1, '', ''],
Qty => [3, 'numer', 10, 75, 1, '', ''],
'Qty On Hand' => [4, 'numer', 10, 75, 0, '', ''],
Date => [5, 'date', 15, 15, 0, \&get_date, ''],
'Exp Date' => [6, 'date', 15, 15, 0, \&get_date, ''],
Size => [7, 'alpha', 15, 50, 0, '0', ''],
'Brand Name' => [8, 'alpha', 35, 75, 0, '', ''],
Price => [9, 'numer', 10, 10, 1, 0, ''],
'Pallet Price' => [10, 'numer', 10, 10, 0, 0, ''],
'Sale Price' => [11, 'numer', 10, 10, 0, '', ''],
Master => [12, 'alpha', 25, 500, 0, '', ''],
'Case Pack' => [13, 'alpha', 25, 100, 0, '', ''],
Type => [14, 'alpha', 10, 15, 0, 'New', ''],
Category => [15, 'alpha', 0, 150, 1, '', ''],
Misc => [16, 'alpha', '40x3', 900, 0, '', '']
);
# Database file to use -- defined in links.cfg.
$db_file_name = $db_links_name;
# Counter file to use -- defined in links.cfg.
$db_id_file_name = $db_links_id_file_name;
# The column name for the database key.
$db_key = 'ID';
# Database delimeter.
$db_delim = '|';
# Title used in admin output.
$html_title = 'Product Database';
$html_object = 'Product';
# Field Number of some important fields. The number is from %db_def above
# where the first field equals 0.
$db_product_ident = 1; $db_date = 5; $db_exp_date = 6; $db_category = 15; $db_id = 0;
$db_description = 2; $db_id = 0;
$db_qty = 3;
$db_qty_on_hand = 4;
# Field number to sort links by:
$db_sort_links = 1;
# Field names you want to allow visitors to search on:
@search_fields = (5,10);
# System defaults. When adding new links or modifying links, these fields
# can not be overwritten by a user.
%add_system_fields = (
# isNew => 'No',
# isPopular => 'No',
# Hits => '0',
# Rating => 0,
# Votes => 0,
# ReceiveMail => 'Yes'
);
# Hash of column names to possible options. If you want to use a select form
# field, you can use &build_select_field in your HTML page. This routine will
# make a <SELECT> input tag using the following values:
%db_select_fields = (
# isNew => 'Yes,No',
# isPopular => 'Yes,No',
# ReceiveMail => 'Yes,No',
Type => 'New,Refurbished,Short Date'
);
# Hash of column names to radio values. If you use &build_radio_field, it will
# make a <INPUT TYPE="RADIO"> tag for you using the options specified in the hash.
%db_radio_fields = ( );
# Maximum number of hits returned in a search. Can be overridden in the search
# options.
$db_max_hits = 10;
# Use the built in key tracker.
$db_key_track = 1;
# ===========================================================================
# Build up some variables from your definitions. Internal use only.
@db_cols = ();
foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {
push (@db_cols, $_);
$db_sort{$_} = $db_def{$_}[1];
$db_form_len{$_} = $db_def{$_}[2];
$db_lengths{$_} = $db_def{$_}[3];
$db_not_null{$_} = $db_def{$_}[4];
$db_defaults{$_} = $db_def{$_}[5];
$db_valid_types{$_} = $db_def{$_}[6];
($_ eq $db_key) and $db_key_pos = $db_def{$_}[0];
}
1;
[\code]
Thanks
Vis
[This message has been edited by Visionary (edited December 16, 1999).]
I've looked this over and over and over until it's now 2:50 in the mornin, and Im just not seeing what's causing this problem.
Basically, I enter a test record, click on Build All, and it replaces the record id number in the database with either No or Yes.
Heres my links.def file, perhaps someone will spot something right away or try it on their test links systems to see if it happens to them as well, and help me to find out why.
Code:
# ------------- # Links
# -------------
# Links Manager
#
# File: links.def
# Description: Contains the database definition for links.
# Author: Alex Krohn
# Email: alex@gossamer-threads.com
# Web: http://www.gossamer-threads.com/
# Version: 2.0
#
# (c) 1998 Gossamer Threads Inc.
#
# This script is not freeware! Please read the README for full details
# on registration and terms of use.
# =====================================================================
# Database Definition: LINKS
# --------------------------------------------------------
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
'Product ident' => [1, 'alpha', 15, 75, 1, '', ''],
Description => [2, 'alpha', '40x3', 900, 1, '', ''],
Qty => [3, 'numer', 10, 75, 1, '', ''],
'Qty On Hand' => [4, 'numer', 10, 75, 0, '', ''],
Date => [5, 'date', 15, 15, 0, \&get_date, ''],
'Exp Date' => [6, 'date', 15, 15, 0, \&get_date, ''],
Size => [7, 'alpha', 15, 50, 0, '0', ''],
'Brand Name' => [8, 'alpha', 35, 75, 0, '', ''],
Price => [9, 'numer', 10, 10, 1, 0, ''],
'Pallet Price' => [10, 'numer', 10, 10, 0, 0, ''],
'Sale Price' => [11, 'numer', 10, 10, 0, '', ''],
Master => [12, 'alpha', 25, 500, 0, '', ''],
'Case Pack' => [13, 'alpha', 25, 100, 0, '', ''],
Type => [14, 'alpha', 10, 15, 0, 'New', ''],
Category => [15, 'alpha', 0, 150, 1, '', ''],
Misc => [16, 'alpha', '40x3', 900, 0, '', '']
);
# Database file to use -- defined in links.cfg.
$db_file_name = $db_links_name;
# Counter file to use -- defined in links.cfg.
$db_id_file_name = $db_links_id_file_name;
# The column name for the database key.
$db_key = 'ID';
# Database delimeter.
$db_delim = '|';
# Title used in admin output.
$html_title = 'Product Database';
$html_object = 'Product';
# Field Number of some important fields. The number is from %db_def above
# where the first field equals 0.
$db_product_ident = 1; $db_date = 5; $db_exp_date = 6; $db_category = 15; $db_id = 0;
$db_description = 2; $db_id = 0;
$db_qty = 3;
$db_qty_on_hand = 4;
# Field number to sort links by:
$db_sort_links = 1;
# Field names you want to allow visitors to search on:
@search_fields = (5,10);
# System defaults. When adding new links or modifying links, these fields
# can not be overwritten by a user.
%add_system_fields = (
# isNew => 'No',
# isPopular => 'No',
# Hits => '0',
# Rating => 0,
# Votes => 0,
# ReceiveMail => 'Yes'
);
# Hash of column names to possible options. If you want to use a select form
# field, you can use &build_select_field in your HTML page. This routine will
# make a <SELECT> input tag using the following values:
%db_select_fields = (
# isNew => 'Yes,No',
# isPopular => 'Yes,No',
# ReceiveMail => 'Yes,No',
Type => 'New,Refurbished,Short Date'
);
# Hash of column names to radio values. If you use &build_radio_field, it will
# make a <INPUT TYPE="RADIO"> tag for you using the options specified in the hash.
%db_radio_fields = ( );
# Maximum number of hits returned in a search. Can be overridden in the search
# options.
$db_max_hits = 10;
# Use the built in key tracker.
$db_key_track = 1;
# ===========================================================================
# Build up some variables from your definitions. Internal use only.
@db_cols = ();
foreach (sort { $db_def{$a}[0] <=> $db_def{$b}[0] } keys %db_def) {
push (@db_cols, $_);
$db_sort{$_} = $db_def{$_}[1];
$db_form_len{$_} = $db_def{$_}[2];
$db_lengths{$_} = $db_def{$_}[3];
$db_not_null{$_} = $db_def{$_}[4];
$db_defaults{$_} = $db_def{$_}[5];
$db_valid_types{$_} = $db_def{$_}[6];
($_ eq $db_key) and $db_key_pos = $db_def{$_}[0];
}
1;
[\code]
Thanks
Vis
[This message has been edited by Visionary (edited December 16, 1999).]