Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: Select Fields

Quote Reply
Re: Select Fields In reply to
Hi Jai,
Well this is the first time Ive ever been able to help anyone out, hope this works it did for me.

First in you cfg file add
$db_table_reqfield (call it whatever you want really)

Then in the the db.cgi copy and paste this sub
sub build_select_field_from_db

and rename it build_select_field_from_reqfield (or once again what ever you want to call it)

then in the new sub replace this line
SELECT DISTINCT $column FROM $db_table

with
SELECT DISTINCT $column FROM $db_table_reqfield (the same as you called it in the cfg file)

The last thing to do is add the info into the html file where you want to use it.

e.g
print &build_select_field_from_reqfield("reqfield",$rec{'reqfield'})

(call it the same as you did in the db.cgi file)
Hope that works for you.

Cheers
Zero73
Sydney, Australia



Subject Author Views Date
Thread Select Fields jai 2885 Aug 28, 2000, 6:15 PM
Thread Re: Select Fields
zero73 2777 Sep 6, 2000, 12:14 AM
Post Re: Select Fields
jai 2755 Sep 6, 2000, 6:36 PM