well I have tree condtions.<BR>1. field Type(ft) = 1 its free input(anotherfield with value)<BR>2. Field Type(ft) = 2 its drop down(anotherfield with value)<BR>3. Field Type(ft) = 3 its date.(anotherfield with choosen dates)<BR><BR>Now when I choose the data related to match all these different values, I need to have the value of ft ids like 1,2 and 3, then the respective datas related to this into an content table.<BR><BR>from the page one I need to get the ft number and the anotherfield related to that.<BR><BR>for all the conditions...<BR><BR>so it will be like<BR><BR>if ft=1 then sql= "....."<BR><BR>if ft=2 then sql = "...."<BR><BR>I am not sure of the loops I am supposed to use, or is that first I have to check the total no of fields and their values.<BR>I am using VBScript.<BR><BR>I am not very sure, what I have jotted is clear for you guys...<BR><BR>But I am struck....<BR><BR>Dig me out....<BR><BR>
you better to write a stored pocedure that will have a parameter, which accepts one of your three types then insert satement as the body of stored procedure. call the Sp using command object of ado. i feel this wiil work out.