Akasha

ok thnx it workedbut now i have the following problemI want to upload to another server (network connection)not to my own serveris there a possible way

Dim uploadsDirVaruploadsDirVar = "\\Presentations\"

then i get the error path doesn't exist

I have found the problemMy first and second dropdown menu had the same nameso when he does the request form he will take the result from dropdown menu 1 and 2.

This is the outputrename=Rename itemhcat=testhoofdcategorie=Group, hoofdcategorieen=

forgot something

</tr><tr>  <td><div align="left"></div></td>  <td colspan="2"><div align="left"></div></td></tr><tr>  <td class="p-content"><input name=rename type="submit" value="Rename item"></td>  <td class="p-content"><div align="right"><input type='button' onclick="window.location.href='../main.asp'" name=submit value='Cancel'></div>  </td></tr></form>

this is the code after the submit

If Request.Form("rename") = "Rename item" Then   if Request.Form("hcat") <> "" then     if Request.Form("hoofdcategorie") <> "" then        sql ="UPDATE Hoofdcategorieen SET hoofdcat_name = '" &Request.Form("hcat")& "' WHERE (hoofdcat_name = '"&Request.Form("hoofdcategorie")&"')"        Response.Write(Sql)    end if   conn2.Execute(sql)end if

and this is my form

<form name='form' method='post' action='change_menu.asp'>  <tr>     <td>         <select name="hoofdcategorie" onchange="changeHoofdcat()">         <option value=''>--- Select a category ---         <%   	             'Recordset            set rs2 = Server.CreateObject("ADODB.recordset")            rs2.Open "SELECT * FROM Hoofdcategorieen WHERE hoofdcat_id > 1 ORDER BY hoofdcat_name ASC", conn2            'Fill variables with values            Do until rs2.EOF	if Request("HoofdCat") = rs2.fields("hoofdcat_name") then    Response.Write("<OPTION SELECTED value='" & rs2.fields("hoofdcat_name") & "'>" & rs2.fields("hoofdcat_name") & "</option>")	else    Response.Write("<OPTION value='" & rs2.fields("hoofdcat_name") & "'>" & rs2.fields("hoofdcat_name") & "</option>")	end if	rs2.movenext            Loop            rs2.close         %>         </select>      </td>     <%	       if Request("HoofdCat") <> "" then         'Recordset         set rs2 = Server.CreateObject("ADODB.recordset")         rs2.Open "SELECT c.*, h.hoofdcat_id FROM hoofdcategorieen h, categorieen c WHERE h.hoofdcat_name='"&Request("HoofdCat")&"' AND h.hoofdcat_id= c.hoofdcat_id ORDER BY c.cat_name ASC", conn2,1,1        'Fill variables with values         Hoofdcat = Request("HoofdCat")         if rs2.RecordCount = 0 then            Response.Write("<td><INPUT TYPE=""text"" NAME=""hcat"" SIZE=""20"" MAXLENGTH=""30""></td></tr>")         else           if request("Cat") = "" then              Response.Write("<td><INPUT TYPE=""text"" NAME=""hcat"" SIZE=""20"" MAXLENGTH=""30""></td></tr>")          end if          Response.Write("</tr><tr><td><select name=""hoofdcategorie"" onchange=""changeCat()""><option value=''>--- Select a category ---")          Do until rs2.EOF             if request("Cat") = rs2.fields("cat_name") then       Response.Write("<OPTION SELECTED value='" & rs2.fields("cat_name") & "'>" & rs2.fields("cat_name") & "</option>")             else      Response.Write("<OPTION value='" & rs2.fields("cat_name") & "'>" & rs2.fields("cat_name") & "</option>")             end if             rs2.movenext         Loop         rs2.close        Response.Write("</select></td>")      end if   end if %><%	   if Request("Cat") <> "" then     'Recordset      set rs2 = Server.CreateObject("ADODB.recordset")      rs2.Open "SELECT s.*, c.cat_id FROM categorieen c, subcategorieen s WHERE c.cat_name='"&Request("Cat")&"' AND c.cat_id= s.cat_id ORDER BY s.subcat_name ASC", conn2,1,1     'Fill variables with values     if rs2.RecordCount = 0 then       Response.Write("<td><INPUT TYPE=""text"" NAME=""categorie"" SIZE=""20"" MAXLENGTH=""30""></td></tr>")    else      if request("SubCat") = "" then        Response.Write("<td><INPUT TYPE=""text"" NAME=""categorie"" SIZE=""20"" MAXLENGTH=""30""></td></tr>")     end if     Response.Write("</tr><tr><td><select name=""subcategorie"" onchange=""changeSubCat()""><option value=''>--- Select a category ---")     Do until rs2.EOF        if request("SubCat") = rs2.fields("subcat_name") then         Response.Write("<OPTION SELECTED value='" & rs2.fields("subcat_name") & "'>" & rs2.fields("subcat_name") & "</option>")       else         Response.Write("<OPTION value='" & rs2.fields("subcat_name") & "'>" & rs2.fields("subcat_name") & "</option>")       end if       rs2.movenext    Loop    rs2.close    Response.Write("</select></td>")    if request("SubCat") <> "" then       Response.Write("<td><INPUT TYPE=""text"" NAME=""scat"" SIZE=""20"" MAXLENGTH=""30""></td>")   end ifend ifend if%>

HelloI have a button and when i push it, it must execute an sql update querythe query gets his information from a dropdown menu and a textfieldThat works all finebut somehow the &Request.Form("hoofdcategorie") functiongives back a strange result like

<option>,

for example i have choosen in my dropdown menu the item Groupthe query must be

UPDATE Hoofdcategorieen SET hoofdcat_name = 'test' WHERE (hoofdcat_name = 'Publications')

but instead he writes

UPDATE Hoofdcategorieen SET hoofdcat_name = 'test' WHERE (hoofdcat_name = 'Publications, ')

'Publications, 'the red part in the queryIs there sometime wrong with my Request.Form???thnxgreetzakasha

Already found a solution for that

Hmz.. ok now he fills my second dropdownbut loses the inserted value in dropdown menu 1is there a way to keep thos values ?

Hello peeps,i have this problem i can't figure out.I use ASP and have a formwith 2 dropdown menusthe first one gets filled with a querywhen someone makes a choice in the first dropdown menuthe second must contain the choices related to the first choice in dropdown menu 1Dropdown menu als needs to be filled with a query.what code needs in the function??or do you have another solution??

function changeHoofdcat(){	?????}........<form name='form' method='post' action='links.asp'><select name="hoofdcategorie" onchange="go()"><option value=''>--- Select a category ---<%   	    set rs2 = Server.CreateObject("ADODB.recordset")   rs2.Open "SELECT * FROM Hoofdcategorieen WHERE hoofdcat_id > 1 ORDER BY hoofdcat_name ASC", conn2   'Fill variables with values   Do until rs2.EOF      Response.Write("<OPTION value='" & rs2.fields("hoofdcat_name") & "'>" & rs2.fields("hoofdcat_name") & "</option>")     rs2.movenext   Loop   rs2.close%></select><br/><select name="categorie" onchange="go()"><option value=''>--- Select a category ---<%   	   set rs2 = Server.CreateObject("ADODB.recordset")  rs2.Open "SELECT c.*, h.hoofdcat_id FROM hoofdcategorieen h, categorieen c WHERE h.hoofdcat_name='"&SelValue&"' AND h.hoofdcat_id= c.hoofdcat_id ORDER BY c.cat_name ASC", conn2  'Fill variables with values  Do until rs2.EOF     Response.Write("<OPTION value='" & rs2.fields("hoofdcat_name") & "'>" & rs2.fields("hoofdcat_name") & "</option>")    rs2.movenext  Loop  rs2.close%></select>

GreetzLeandra

HelloI want to upload files from a pc to a server using ASPI am working on a website and on this website it must be possible for the users to upload files to the server like ppt or doc filesdoes anyone know if this is possible and where i can find the scriptthnx alotgreets Leandra

Already found the problem. :)Recordcount is not supported with the default forward-only cursor.so i opened it in a different waysolution is found at this link:http://www.aspfaq.com/show.asp?id=2193greets leandra

Helloi am new with asp and i have a problemI want to check the number of records in a recordsetif there aren't any in it it must give back an error that there was nothing returnedif rs2.RecordCount > 0 thenthat all works fine except for one thing and that is dat rs2.RecordCount keeps giving back -1 even when the query didn't or did return something from the database?why do I get -1 :)I look at the explanation of recordcount but didn't get any wisergreets Leandraps. excuses for my english