Answered this on 5/9 your argument "manfitem" needs to be evaluated as an array in your TAF file.
To see an HTML submittal example, look at http://www.raisethebar.com/collaborations.taf In this case, you can select purposes and/or deliverables. I want to find all engagements that had the selected purposes or deliverables. Consider the purposes case: We have a purposes table that has a row containing the purpose_id and the engagement id. The search criteria tab has: purposes_db.purposes_id Is In <@POSTARG purposes TYPE=ARRAY> This returns a list of matching engagement IDs. I do the same for deliverables. Then use <@DISTINCT> to eliminate duplicate engagement IDs (a single engagement can have multiple purposes and deliverables), then query the engagements database for the matching engagement IDs. >Hi > > <select name="manfitem" size=4 MULTIPLE><option value="" >*Items*</option> ><option value="ABRASIVE JET CUTTING EQUIP" >ABRASIVE JET CUTTING >EQUIP</option> ><option value="AIR COMPRESSORS" >AIR COMPRESSORS</option> ><option value="AUTOMATICS" >AUTOMATICS</option> ><option value="BALERS" >BALERS</option> ><option value="BANDERS" >BANDERS</option> ><option value="BEARINGS" >BEARINGS</option> ><option value="BENDERS-PIPE-TUBE-BAR" >BENDERS, PIPE, TUBE, BAR</option> ><option value="BEVELERS" >BEVELERS</option> ><option value="BORING MACHINES" >BORING MACHINES</option> ><option value="BORING MILLS" >BORING MILLS</option> ><option value="BRAKES" >BRAKES</option> ></select> > >When I select multiple items I am getting only the first item selected to be >inserted into the database. >I was expecting a comma delimited list. > >What am I doing wrong? > >Thanks > >venu > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
