Posted 11 December 2003 - 12:58 PM
I want to create a page with a pull down list where I select the program leys say \"quark\" and it would bring me to a detail page listing all the computers that have Quark installed \"Yes\"
I understand how to do this if I was checking one field for yes or no , but because i have numerous fields i cand seem to come up with the code to do this.
Is there anyone out there who can help?
Posted 12 December 2003 - 01:00 PM
Let me explain it again.
I have appx 20 fileds named after programs which may be installed on a computer.
The fiels can contan either yes or no.
I want to creat a page with a puldown list where you select the program you want to use and it will goto a page that will display a list of computers tha t have this program installed.
This would be find if I had only one field to searcd but I have appx 20 fields. it has to first find the program field and see if a yes is in that field. I dont know how to code it to look for that field only to see if it contains a yes.
Please I am at a standstill without this.
I have included the list of fields below.
Field Type Null Default Links to Comments
Device varchar(30) No
Description varchar(120) No 0
Network_Name varchar(30) No
Location varchar(30) No
ip varchar(15) No 0
Can_Ping char(2) No
Drop varchar(4) No
Operating_Sys varchar(40) Yes NULL
quark50 varchar(5) No No
pic varchar(100) No nophoto.gif
quark41 varchar(5) No No
pm65 varchar(5) No
pm70 varchar(5) No No
quark60 varchar(5) No No
ps60 varchar(5) No No
ps70 varchar(5) No No
ps80 varchar(5) No No
ps90 varchar(5) No No
ps10 varchar(5) No No
pscs varchar(5) No No
ill9 varchar(5) No No
ill10 varchar(5) No No
corel10 varchar(5) No No
corel11 varchar(5) No No
wordperfect varchar(5) No No
publisher2000 varchar(5) No No
indesign1 varchar(5) No No
indesign2 varchar(5) No No
Posted 12 December 2003 - 01:46 PM
When I select the value from the pull down list it gets assigned to the variable also.
The search query should look something like this I think..
Where ($Variable) = yes
This is what I think the query should be like but I dont know how to write the real code...CAN you help.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users