feti

Great..!...successfully for me too.....

Thanx in reply,I cannot remove WHERE statement cause i need that,I need in querying where only the specific data will display whenever user login into this page they will be directed or viewing certain records to be seen, depends on theirs selection, so within this quiry form contain of Enclosures Table, it shoud contained more than 1 title to be displayed out, sometimes 1 records = i Identifier (ID), will have more than 1 enclosures, so I need to display those data. Please help me on this...

I hope anyone can help me on this...i'm newbies in ASP...last 2 weeks just learn how ASP work with form accessing databaseI want to display certain fields of data in database for viewing, I created the code but its only display the first data in database, the rest I can't see it, I want to display out the rest of related data, anyone please help me to explain my coding problem....:)The code:If sGQDidentifier <> " " then sSQLEnc = sSQLEnc & "SELECT * FROM cfts_admin.ddts_enclosures_readonly WHERE identifier = '" & sGQDidentifier & "'" set rsEnc = Server.CreateObject("ADODB.Recordset") rsEnc.Open sSQLEnc,ddtsConnect if not rsEnc.EOF then Do While Not rsEnc.EOF sGQDEncName = rsEnc.Fields("name") rsEnc.movenext loop else response.write "end of file" end if fnCLDestroyObject(rsEnc) sGHTTemp = sGHTTemp & " <tr>" & vbCrLf & _ " <td colspan=2 width=100%_>" & vbCrLf & _ " <span class='issue-field-label'>Enclosure Records</span>" & vbCrLf & _ " <span class='issue-field-content'>: " & sGQDEncName & "</a>" & vbCrLf & _ " </span>" & vbCrLf & _ " </td>" & vbCrLf & _ " </tr>" & vbCrLf & _ "</table>" & vbCrLf end ifThe unsuccessfully display result:Enclosure Records : BINARY:EMEA_Summary.msg *It should display more than this...

Thank you for supportting, i'll try, i'm really appreciate your reply

Hi Anyone,Plzzzz Help me in thisHow can I create multiple selection in Combo Box??, rit now i created the combo box (only one selection for each list), my problem is, i need the list in the combo box can be selected multiple value, then from the multiple selection in the combo box by users, then it will query out the data from the database based on list selected by users. Code: Dim conn - 'Success in connceting into database sIFTemp = sIFTemp & "<TD> : <SELECT NAME='SelectState'>" & vbCrLf sIFTemp = sIFTemp & "<OPTION VALUE='"& sGQDStat&"' selected>" & sGQDStat sIFTemp = sIFTemp & "<OPTION VALUE=''>" & vbCrLf sIFTemp = sIFTemp & fnStateOption() sIFTemp = sIFTemp & "</SELECT></TD></TR><tr>" & vbCrLf******************************************************************sGQDTmpStat= rsDR.Fields("status")sDRMsg = sDRMsg & "<td>" & sGQDTmpStat & " </td>"********************************************************************Function fnStateOption() sGSTTemp = "" sGSTOption = "" sGSTOption = sGSTOption & "<option value='N'>New" sGSTOption = sGSTOption & "<option value='A'>Assigned" sGSTOption = sGSTOption & "<option value='Y'>Analyzed" sGSTOption = sGSTOption & "<option value='I'>Implemented" sGSTOption = sGSTOption & "<option value='V'>Verified" sGSTOption = sGSTOption & "<option value='L'>Validated" sGSTOption = sGSTOption & "<option value='R'>Resolved" sGSTOption = sGSTOption & "<option value='C'>Closed" sGSTOption = sGSTOption & "<option value='R'>Rejected" sGSTOption = sGSTOption & "<option value='D'>Duplicate" sGSTOption = sGSTOption & "<option value='P'>Postponed" sGSTTemp = sGSTTemp & sGSTOption fnStateOption = sGSTTempEnd Function*************************************************************************