I am trying to add a select box function to my forms.
I have added the following code to my .cfg file
%db_select_fields = (
Products => 'Bearings,Cable Tray Systems,Expansion Joints,Fiberglass,Flow/Metering,PTFE Products,Phenolic Material,Pipe/Fittings Valves,Pipe,Valve Pumps Filter,Pipe/Fittings,Plastic Materials,Plastic Fabrication,Roofing/Siding,Thermoplastic Material,Thermoplastic Material Valves,Tubing/Hose,Tubing/Hose,Valves',
Products2 => 'ADHESIVES,CEMENT,CHEM-FLOW,CONTROL,CPVC,CPVC DUCT,DIGI-FLOW,DOOR FRAME,ELASTOMERIC BEARINGS,FABRICATION & MACHINING,FIBERGLASS,FIBERGLASS DOOR,FIRE DOOR,FLOORING,FLOW METER GASKETS,FLOWMETER,GASKETS,GRATING,HDPE UHMW FIBERGLASS,INSULATORS,KYNAR,LADDER,LEAK REPAIR,MATERIAL-GRATING,MATERIAL-PIPE,MATERIAL-RINGS,MATERIAL-ROD,MATERIAL-SHEET,MATERIAL-STRUCTURAL,MATERIAL-TUBE,PE,PENETRATION COLLARS,PLASTIC,POLY PR,POLY PRO,PRESSURE REGULATING,PRIMER,PULTRUDED,PVC,PVC DUCT,RAIL,ROOFING,RUBBER,RUBBER,SAFETY GATES,SCH 40 PVC,SCH 80 CPVC,SCH 40 CPVC,SCH 80 PVC,SEALANTS,SISEMIC BEARINGS,SOLVENT,SWING GATES,TANKS,TEFLON,TEFLON BEARINGS,TEFLON LINED,THERMOPLASTIC ACTUATION CONTROL,TYGON,WINDOWS LOUVERS',
Manufacturer => 'ACE TANKS,ASAHI,ATLAS FIBER,BLUE WHITE,CORRIM COMPANY,CREATIVE PULTRUSION,Fluorocarbon Company,GEORGE FISHER,Harvel Plastic,Hayward Industrial,INTERPLAST,IPEX,IPS CEMENT,InduMar Products Inc.,Intrepid Safety Gates & GPC's,New Age Industries,NIBCO,PLASTINETICS,PLAST-O-MATIC VALVES,PRECISIONEERING,PROCO EXPANSION JOINTS,AICKINSTRUT,RESOLITE,SIMONA AMERICA INC,Seismic Energy Products,Spears Manufacturing,St. Gobain Tubing,Thermoplastic Processes,Thermoplastic Valves Inc'
);
When I do my script breaks as follows;
CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Bad name after Inc' at \\nawinfs03\home\users\web\b1213\rh.greggeisen\cgi-bin\products_search/products.cfg line 96.
Compilation failed in require at \\nawinfs03\home\users\web\b1213\rh.greggeisen\cgi-bin\products_search\db.cgi line 52.
Script Location : \\nawinfs03\home\users\web\b1213\rh.greggeisen\cgi-bin\products_search\db.cgi
Perl Version : 5.008006
Setup File : products.cfg
Session ID : default
Form Variables
-------------------------------------------
Record_ID : *
db : products
uid : default
view_records : 1
When I remove the db_select_fields stuff everything works.
Any ideas why this happens?
links to the various files;
http://www.plantmaintenanceservices.com/dbman/
Ed 8-)
I have added the following code to my .cfg file
Code:
%db_select_fields = (
Products => 'Bearings,Cable Tray Systems,Expansion Joints,Fiberglass,Flow/Metering,PTFE Products,Phenolic Material,Pipe/Fittings Valves,Pipe,Valve Pumps Filter,Pipe/Fittings,Plastic Materials,Plastic Fabrication,Roofing/Siding,Thermoplastic Material,Thermoplastic Material Valves,Tubing/Hose,Tubing/Hose,Valves',
Products2 => 'ADHESIVES,CEMENT,CHEM-FLOW,CONTROL,CPVC,CPVC DUCT,DIGI-FLOW,DOOR FRAME,ELASTOMERIC BEARINGS,FABRICATION & MACHINING,FIBERGLASS,FIBERGLASS DOOR,FIRE DOOR,FLOORING,FLOW METER GASKETS,FLOWMETER,GASKETS,GRATING,HDPE UHMW FIBERGLASS,INSULATORS,KYNAR,LADDER,LEAK REPAIR,MATERIAL-GRATING,MATERIAL-PIPE,MATERIAL-RINGS,MATERIAL-ROD,MATERIAL-SHEET,MATERIAL-STRUCTURAL,MATERIAL-TUBE,PE,PENETRATION COLLARS,PLASTIC,POLY PR,POLY PRO,PRESSURE REGULATING,PRIMER,PULTRUDED,PVC,PVC DUCT,RAIL,ROOFING,RUBBER,RUBBER,SAFETY GATES,SCH 40 PVC,SCH 80 CPVC,SCH 40 CPVC,SCH 80 PVC,SEALANTS,SISEMIC BEARINGS,SOLVENT,SWING GATES,TANKS,TEFLON,TEFLON BEARINGS,TEFLON LINED,THERMOPLASTIC ACTUATION CONTROL,TYGON,WINDOWS LOUVERS',
Manufacturer => 'ACE TANKS,ASAHI,ATLAS FIBER,BLUE WHITE,CORRIM COMPANY,CREATIVE PULTRUSION,Fluorocarbon Company,GEORGE FISHER,Harvel Plastic,Hayward Industrial,INTERPLAST,IPEX,IPS CEMENT,InduMar Products Inc.,Intrepid Safety Gates & GPC's,New Age Industries,NIBCO,PLASTINETICS,PLAST-O-MATIC VALVES,PRECISIONEERING,PROCO EXPANSION JOINTS,AICKINSTRUT,RESOLITE,SIMONA AMERICA INC,Seismic Energy Products,Spears Manufacturing,St. Gobain Tubing,Thermoplastic Processes,Thermoplastic Valves Inc'
);
When I do my script breaks as follows;
CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Bad name after Inc' at \\nawinfs03\home\users\web\b1213\rh.greggeisen\cgi-bin\products_search/products.cfg line 96.
Compilation failed in require at \\nawinfs03\home\users\web\b1213\rh.greggeisen\cgi-bin\products_search\db.cgi line 52.
Script Location : \\nawinfs03\home\users\web\b1213\rh.greggeisen\cgi-bin\products_search\db.cgi
Perl Version : 5.008006
Setup File : products.cfg
Session ID : default
Form Variables
-------------------------------------------
Record_ID : *
db : products
uid : default
view_records : 1
When I remove the db_select_fields stuff everything works.
Any ideas why this happens?
links to the various files;
http://www.plantmaintenanceservices.com/dbman/
Ed 8-)