Re: too many fields
Thanks for replying....
There are about 160 fields, all of which are needed.
They will hold the data for test results.
-----------
<%
if(Request("CertNo") <> "") then Update1__ins1 = Request("CertNo")
if((RSinstrument.Fields.Item("InstrumentID").Value ) <> "") then
Update1__MMColParam1 = (RSinstrument.Fields.Item("InstrumentID").Value)
if(Request.QueryString("HistID") <> "") then Update1__MMColParam2 =
Request.QueryString("HistID")
if(Request("checkboxUsed") <> "") then Update1__ins2 =
Request("checkboxUsed")
if(Request("Cont_App1") <> "") then Update1__ins4 = Request("Cont_App1")
if(Request("Cont_App2") <> "") then Update1__ins5 = Request("Cont_App2")
if(Request("Cont_App3") <> "") then Update1__ins6 = Request("Cont_App3")
if(Request("Cont_PF1") <> "") then Update1__ins7 = Request("Cont_PF1")
if(Request("Cont_PF2") <> "") then Update1__ins8 = Request("Cont_PF2")
if(Request("Cont_PF3") <> "") then Update1__ins9 = Request("Cont_PF3")
if(Request("Cont_Read1") <> "") then Update1__ins10 = Request("Cont_Read1")
if(Request("Cont_Read2") <> "") then Update1__ins11 = Request("Cont_Read2")
if(Request("Cont_Read3") <> "") then Update1__ins12 = Request("Cont_Read3")
if(Request("Cont_TN1") <> "") then Update1__ins13 = Request("Cont_TN1")
if(Request("Cont_TN2") <> "") then Update1__ins14 = Request("Cont_TN2")
if(Request("Cont_TN3") <> "") then Update1__ins15 = Request("Cont_TN3")
if(Request("Cont_Tol1") <> "") then Update1__ins16 = Request("Cont_Tol1")
if(Request("Cont_Tol2") <> "") then Update1__ins17 = Request("Cont_Tol2")
if(Request("Cont_Tol3") <> "") then Update1__ins18 = Request("Cont_Tol3")
if(Request("cross_checked") <> "") then Update1__ins19 =
Request("cross_checked")
if(Request("CurrentAC_App1") <> "") then Update1__ins21 =
Request("CurrentAC_App1")
if(Request("CurrentAC_App2") <> "") then Update1__ins22 =
Request("CurrentAC_App2")
if(Request("CurrentAC_App3") <> "") then Update1__ins23 =
Request("CurrentAC_App3")
if(Request("CurrentAC_TN1") <> "") then Update1__ins24 =
Request("CurrentAC_TN1")
if(Request("CurrentAC_TN2") <> "") then Update1__ins25 =
Request("CurrentAC_TN2")
if(Request("CurrentAC_TN3") <> "") then Update1__ins26 =
Request("CurrentAC_TN3")
if(Request("CurrentAC_PF1") <> "") then Update1__ins27 =
Request("CurrentAC_PF1")
if(Request("CurrentAC_PF2") <> "") then Update1__ins28 =
Request("CurrentAC_PF2")
if(Request("CurrentAC_PF3") <> "") then Update1__ins29 =
Request("CurrentAC_PF3")
if(Request("CurrentAC_Read1") <> "") then Update1__ins30 =
Request("CurrentAC_Read1")
if(Request("CurrentAC_Read2") <> "") then Update1__ins31 =
Request("CurrentAC_Read2")
if(Request("CurrentAC_Read3") <> "") then Update1__ins32 =
Request("CurrentAC_Read3")
if(Request("CurrentAC_Tol1") <> "") then Update1__ins33 =
Request("CurrentAC_Tol1")
if(Request("CurrentAC_Tol2") <> "") then Update1__ins34 =
Request("CurrentAC_Tol2")
if(Request("CurrentAC_Tol3") <> "") then Update1__ins35 =
Request("CurrentAC_Tol3")
if(Request("CurrentDC_App1") <> "") then Update1__ins36 =
Request("CurrentDC_App1")
if(Request("CurrentDC_App2") <> "") then Update1__ins37 =
Request("CurrentDC_App2")
if(Request("CurrentDC_App3") <> "") then Update1__ins38 =
Request("CurrentDC_App3")
if(Request("CurrentDC_TN1") <> "") then Update1__ins39 =
Request("CurrentDC_TN1")
if(Request("CurrentDC_TN2") <> "") then Update1__ins40 =
Request("CurrentDC_TN2")
if(Request("CurrentDC_TN3") <> "") then Update1__ins41 =
Request("CurrentDC_TN3")
if(Request("CurrentDC_PF1") <> "") then Update1__ins42 =
Request("CurrentDC_PF1")
if(Request("CurrentDC_PF2") <> "") then Update1__ins43 =
Request("CurrentDC_PF2")
if(Request("CurrentDC_PF3") <> "") then Update1__ins44 =
Request("CurrentDC_PF3")
if(Request("CurrentDC_Read1") <> "") then Update1__ins45 =
Request("CurrentDC_Read1")
if(Request("CurrentDC_Read2") <> "") then Update1__ins46 =
Request("CurrentDC_Read2")
if(Request("CurrentDC_Read3") <> "") then Update1__ins47 =
Request("CurrentDC_Read3")
if(Request("CurrentDC_Tol1") <> "") then Update1__ins48 =
Request("CurrentDC_Tol1")
if(Request("CurrentDC_Tol2") <> "") then Update1__ins49 =
Request("CurrentDC_Tol2")
if(Request("CurrentDC_Tol3") <> "") then Update1__ins50 =
Request("CurrentDC_Tol3")
if(Request("TargetDate") <> "") then Update1__ins51 = Request("TargetDate")
if(Request("EarthBO_App1") <> "") then Update1__ins52 =
Request("EarthBO_App1")
if(Request("EarthBO_App2") <> "") then Update1__ins53 =
Request("EarthBO_App2")
if(Request("EarthBO_App3") <> "") then Update1__ins54 =
Request("EarthBO_App3")
if(Request("EarthBO_TN1") <> "") then Update1__ins55 =
Request("EarthBO_TN1")
if(Request("EarthBO_TN2") <> "") then Update1__ins56 =
Request("EarthBO_TN2")
if(Request("EarthBO_TN3") <> "") then Update1__ins57 =
Request("EarthBO_TN3")
if(Request("EarthBO_PF1") <> "") then Update1__ins58 =
Request("EarthBO_PF1")
if(Request("EarthBO_PF2") <> "") then Update1__ins59 =
Request("EarthBO_PF2")
if(Request("EarthBO_PF3") <> "") then Update1__ins60 =
Request("EarthBO_PF3")
if(Request("EarthBO_Read1") <> "") then Update1__ins61 =
Request("EarthBO_Read1")
if(Request("EarthBO_Read2") <> "") then Update1__ins62 =
Request("EarthBO_Read2")
if(Request("EarthBO_Read3") <> "") then Update1__ins63 =
Request("EarthBO_Read3")
if(Request("EarthBO_Tol1") <> "") then Update1__ins64 =
Request("EarthBO_Tol1")
if(Request("EarthBO_Tol2") <> "") then Update1__ins65 =
Request("EarthBO_Tol2")
if(Request("EarthBO_Tol3") <> "") then Update1__ins66 =
Request("EarthBO_Tol3")
if(Request("EarthOh_App1") <> "") then Update1__ins67 =
Request("EarthOh_App1")
if(Request("EarthOh_App2") <> "") then Update1__ins68 =
Request("EarthOh_App2")
if(Request("EarthOh_App3") <> "") then Update1__ins69 =
Request("EarthOh_App3")
if(Request("EarthOh_TN1") <> "") then Update1__ins70 =
Request("EarthOh_TN1")
if(Request("EarthOh_TN2") <> "") then Update1__ins71 =
Request("EarthOh_TN2")
if(Request("EarthOh_TN3") <> "") then Update1__ins72 =
Request("EarthOh_TN3")
if(Request("EarthOh_PF1") <> "") then Update1__ins73 =
Request("EarthOh_PF1")
if(Request("EarthOh_PF2") <> "") then Update1__ins74 =
Request("EarthOh_PF2")
if(Request("EarthOh_PF3") <> "") then Update1__ins75 =
Request("EarthOh_PF3")
if(Request("EarthOH_Read1") <> "") then Update1__ins76 =
Request("EarthOH_Read1")
if(Request("EarthOH_Read2") <> "") then Update1__ins77 =
Request("EarthOH_Read2")
if(Request("EarthOH_Read3") <> "") then Update1__ins78 =
Request("EarthOH_Read3")
if(Request("EarthOh_Tol1") <> "") then Update1__ins79 =
Request("EarthOh_Tol1")
if(Request("EarthOh_Tol2") <> "") then Update1__ins80 =
Request("EarthOh_Tol2")
if(Request("EarthOh_Tol3") <> "") then Update1__ins81 =
Request("EarthOh_Tol3")
if(Request("FlashT_App1") <> "") then Update1__ins82 =
Request("FlashT_App1")
if(Request("FlashT_App2") <> "") then Update1__ins83 =
Request("FlashT_App2")
if(Request("FlashT_App3") <> "") then Update1__ins84 =
Request("FlashT_App3")
if(Request("FlashT_TN1") <> "") then Update1__ins85 = Request("FlashT_TN1")
if(Request("FlashT_TN2") <> "") then Update1__ins86 = Request("FlashT_TN2")
if(Request("FlashT_TN3") <> "") then Update1__ins87 = Request("FlashT_TN3")
if(Request("FlashT_PF1") <> "") then Update1__ins88 = Request("FlashT_PF1")
if(Request("FlashT_PF2") <> "") then Update1__ins89 = Request("FlashT_PF2")
if(Request("FlashT_PF3") <> "") then Update1__ins90 = Request("FlashT_PF3")
if(Request("FlashT_Read1") <> "") then Update1__ins91 =
Request("FlashT_Read1")
if(Request("FlashT_Read2") <> "") then Update1__ins92 =
Request("FlashT_Read2")
if(Request("FlashT_Read3") <> "") then Update1__ins93 =
Request("FlashT_Read3")
if(Request("FlashT_Tol1") <> "") then Update1__ins94 =
Request("FlashT_Tol1")
if(Request("FlashT_Tol2") <> "") then Update1__ins95 =
Request("FlashT_Tol2")
if(Request("FlashT_Tol3") <> "") then Update1__ins96 =
Request("FlashT_Tol3")
%>
"Philo" <meansyou@nospam.net> wrote in message
news:g23f2g$4ea$1@forums.macromedia.com...
>
> Just how many fields do you have?
|