Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 15 of 15

Thread: help meee....

  1. #1
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    help meee....

    hai there...
    i wanna ask for your help...
    can you help me to find coding asp for upload button...
    there's been a week i try to find that coding but i's never work..pleaseee..

  • #2
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    Welcome to CF Forums. Please put a more descriptive subject next time. Subject like yours is against posting guidelines.

    To help you with your problem, you can find many file upload scripts/components if you google ASP File Upload.
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #3
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hai...
    i'm back with another problem..mmm.asp

    <html>
    <body>

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "C:\Inetpub\wwwroot\lib\ppap\maklumat.mdb"
    sql="INSERT INTO maklumat(artikel_id,hari,bulan,tahun,sumber,subjek)"
    sql=sql & " VALUES "
    sql=sql & "('" & Request.Form("artikel_id") & "',"
    sql=sql & "'" & Request.Form("hari") & "',"
    sql=sql & "'" & Request.Form("bulan") & "',"
    sql=sql & "'" & Request.Form("tahun") & "',"
    sql=sql & "'" & Request.Form("sumber") & "',"
    sql=sql & "'" & Request.Form("subjek") & "')"
    on error resume next
    conn.Execute sql,recaffected
    if err<>0 then
    Response.Write("No update permissions!")
    else
    Response.Write("<h3>" & recaffected & " record added</h3>")

    end if
    conn.close
    %>

    </body>
    </html>


    the question is..why that's coding did'n work...when i'm run im localhost it always display..."No permission Update"...why? what's wrong with that?

    this is html source code for that asp file..

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title>Untitled Document</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <style type="text/css">
    i.jenis1 {color:red;}
    </style>

    </head>
    <body>
    <table width="35%" align="left">
    <tr>
    <td align="center"><div align="left"><font color="black" size="3">
    <script type="text/javascript">
    var d=new Date()
    var weekday=new Array("Ahad","Isnin","Selasa","Rabu","Khamis","Jumaat","Sabtu")
    var monthname=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
    document.write(weekday[d.getDay()] + " , ")
    document.write(d.getDate() + " ")
    document.write(monthname[d.getMonth()] + " ")
    document.write(d.getFullYear())
    </script>
    </font></div></td>
    </tr>
    </table>
    <!-----------------------------------------start insert data------------------------------->
    <form method="post" action="mmm.asp">
    <p>&nbsp;</p><table width="75%" border="0" align="center">
    <tr>
    <td height="156"><p align="center"><img src="Banner/Banner/logo.gif" width="113" height="106"></p>
    <div align="left">
    <div align="right">
    <div align="center">
    <pre><strong>ARKIB AKHBAR </strong><strong>
    PERBADANAN PERPUSTAKAAN AWAM PAHANG</strong></pre>
    <hr>
    </div>
    </div>
    </div></td>
    </tr>
    <tr>
    <td height="250"> <div align="center"></div>
    <table width="70%" height="85%" border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#000000">
    <tr>
    <td height="244" valign="top" bgcolor="#CCCCCC"><p align="center"><strong><font size="+1"><u>BORANG
    KEMASUKAN ARTIKEL / AKHBAR</u></font></strong></p>
    <div align="center">
    <table width="83%" height="116" border="0" align="center">
    <tr bgcolor="#666666">
    <td width="19%" height="25"><div align="right"><font color="#FFFFFF">Artikel
    ID </font>: </div></td>
    <td width="81%"> <input type="text" name="artikel_id">
    &nbsp;&nbsp; <a href="carian.htm">
    <input name="imageField" type="image" src="Banner/Banner/search.jpg" width="15" height="15" border="0">
    <u><font color="#0000FF" size="2">
    <object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="19">
    <param name="BGCOLOR" value="#666666">
    <param name="movie" value="carian.swf">
    <param name="quality" value="high">
    <param name="base" value=".">
    <embed src="carian.swf" width="100" height="19" base="." quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" bgcolor="#666666" ></embed>
    </object>
    </font></u> </a></td>
    </tr>
    <tr bgcolor="#666666">
    <td height="26"><div align="right"><font color="#FFFFFF">Tarikh</font>
    :</div></td>
    <td>
    <font color="#FFFFFF" size="-1">Hari
    <select name="hari">
    <option> </option>
    <option>01</option>
    <option>02</option>
    <option>03</option>
    <option>04</option>
    <option>05</option>
    <option>06</option>
    <option>07</option>
    <option>08</option>
    <option>09</option>
    <option>10</option>
    <option>11</option>
    <option>12</option>
    <option>13</option>
    <option>14</option>
    <option>15</option>
    <option>16</option>
    <option>17</option>
    <option>18</option>
    <option>19</option>
    <option>20</option>
    <option>21</option>
    <option>22</option>
    <option>23</option>
    <option>24</option>
    <option>25</option>
    <option>26</option>
    <option>27</option>
    <option>28</option>
    <option>29</option>
    <option>30</option>
    <option>31</option>
    </select>
    <font color="#FFFFFF" size="-1">Bulan</font>
    <select name="bulan">
    <option> </option>
    <option>Januari</option>
    <option>Februari</option>
    <option>Mac</option>
    <option>April</option>
    <option>Mei</option>
    <option>Jun</option>
    <option>Julai</option>
    <option>Ogos</option>
    <option>September</option>
    <option>Oktober</option>
    <option>November</option>
    <option>Disember</option>
    </select>

    Tahun <input name="tahun" type="text" size="6">
    </font></td>
    </tr>
    <tr bgcolor="#666666">
    <td height="26"><div align="right"><font color="#FFFFFF">Sumber</font>
    :</div></td>
    <td> <select name="sumber">
    <option> </option>
    <option>Berita Harian</option>
    <option>Utusan Malaysia</option>
    </select> </td>
    </tr>
    <tr bgcolor="#666666">
    <td height="26"><div align="right"><font color="#FFFFFF">Subjek
    </font>:</div></td>
    <td> <select name="subjek">
    <option> </option>
    <option>Agensi Kerajaan</option>
    <option>Am</option>
    <option>Bahasa</option>
    <option>Belia</option>
    <option>Bencana Alam</option>
    <option>Ekonomi</option>
    <option>Felda &amp; Peneroka</option>
    <option>Gejala Sosial</option>
    <option>Islam</option>
    <option>Kebajikan Sosial</option>
    <option>Kebudayaan</option>
    <option>Kepenggunaan</option>
    <option>Kesihatan</option>
    <option>Majlis Perbandaran</option>
    <option>Pelabuhan</option>
    <option>Perlancongan &amp; Perhotelan</option>
    <option>Pembangunan Wilayah</option>
    <option>Pembangunan &amp; Pentadbiran</option>
    <option>Pendidikan</option>
    <option>Penduduk &amp; Suku Kaum</option>
    <option>Pengairan &amp; Saliran</option>
    <option>Penternakan</option>
    <option>Perancangan &amp; Pembangunan</option>
    <option>Perhilitan</option>
    <option>Perhubungan &amp; Pengangkutan</option>
    <option>Perhutanan &amp; Pembalakan</option>
    <option>Perikanan</option>
    <option>Perindustrian</option>
    <option>Perkhidmatan &amp; Pentadbiran</option>
    <option>Perlombongan Galian</option>
    <option>Perniagaan &amp; Keusahawanan</option>
    <option>Perpustakaan &amp; Sumber Maklumat</option>
    <option>Pertahanan &amp; Keselamatan</option>
    <option>Pertanian</option>
    <option>Pertumbuhan Desa</option>
    <option>Perumahan &amp; Petempatan</option>
    <option>Perundangan &amp; Perlembagaan</option>
    <option>Politik</option>
    <option>Saham &amp; Pelaburan</option>
    <option>Sains &amp; Teknologi Maklumat</option>
    <option>Sastera &amp; Budaya</option>
    <option>Sejarah &amp; Arkeologi</option>
    <option>Sukan &amp; Rekreasi</option>
    <option>Tokoh &amp; Biografi</option>
    <option>Wanita</option>
    </select> </td>
    </tr>
    <tr bgcolor="#666666">
    <td width="19%" height="25"><div align="right"><font color="#FFFFFF">Artikel: </font>: </div></td>
    <td width="81%"> <input name="artikel" type="file" id="artikel">
    </table>
    </div>
    <div align="center">
    <table width="99%">
    <tr>
    <td height="26"><div align="center">
    <input name="reset" type="reset" id="reset" value=" KOSONGKAN">
    &nbsp;
    <input type="submit" name="simpan" value=" SIMPAN ">
    </div></td>
    </tr>
    </table>
    </div></td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td height="21">&nbsp;</td>
    </tr>
    <tr>
    <td height="30">
    <table width="77%" border="0" align="center">
    <tr>
    <td width="70%" height="24" valign="top"> <div align="right">
    <object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
    <param name="BGCOLOR" value="">
    <param name="movie" value="kembali1.swf">
    <param name="quality" value="high">
    <param name="base" value=".">
    <param name="SCALE" value="exactfit">
    <embed src="kembali1.swf" width="100" height="22" base="." quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" scale="exactfit" ></embed>
    </object>
    </div></td>
    <td width="10%"><div align="right">
    <object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
    <param name="BGCOLOR" value="">
    <param name="movie" value="laporan.swf">
    <param name="quality" value="high">
    <param name="base" value=".">
    <embed src="laporan.swf" base="." quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="22" ></embed>
    </object>
    </div></td>
    <td width="20%"> <div align="right">
    <object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
    <param name="BGCOLOR" value="">
    <param name="movie" value="keluar.swf">
    <param name="quality" value="high">
    <param name="SCALE" value="exactfit">
    <embed src="keluar.swf" width="100" height="22" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" scale="exactfit" ></embed>
    </object>
    </div></td>
    </tr>
    </table>
    <div align="right"></div></td>
    </tr>
    </table>
    </form></body>
    </html>



    please help me to find the error....

  • #4
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    Comment out first on error resume next to see the actual and detailed error message.
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #5
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by glenngv
    Comment out first on error resume next to see the actual and detailed error message.

    mmm i can't get u..what do you mean? sorry...actually i'm new with this server script..

  • #6
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    Code:
    'on error resume next
    conn.Execute sql,recaffected
    "on error resume next" causes the error to be suppressed. If you comment it out and then run the page again, you can see the actual error. And from there, you can debug the problem.
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #7
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,174
    Thanks
    19
    Thanked 66 Times in 65 Posts
    remove this line:

    Code:
    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "C:\Inetpub\wwwroot\lib\ppap\maklumat.mdb"
    sql="INSERT INTO maklumat(artikel_id,hari,bulan,tahun,sumber,subjek)"
    sql=sql & " VALUES "
    sql=sql & "('" & Request.Form("artikel_id") & "',"
    sql=sql & "'" & Request.Form("hari") & "',"
    sql=sql & "'" & Request.Form("bulan") & "',"
    sql=sql & "'" & Request.Form("tahun") & "',"
    sql=sql & "'" & Request.Form("sumber") & "',"
    sql=sql & "'" & Request.Form("subjek") & "')"
    on error resume next
    conn.Execute sql,recaffected
    if err<>0 then
    Response.Write("No update permissions!")
    else
    Response.Write("<h3>" & recaffected & " record added</h3>")
    
    end if
    conn.close
    %>
    This will give you a real error message and it will tell you what the problme is.

  • #8
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hai...
    so last time u told me that i must remove "on error resume next"... so i try to remove it and when i run it's still doesn't work. still show "no update permission".

    but when i'll try more and more it's show this error...

    Error Type:
    Microsoft JET Database Engine (0x80004005)
    Operation must use an updateable query.
    /lib/ppap/mmm.asp, line 17


    *line 17 is "conn.Execute sql,recaffected"

    why?

  • #9
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    That's exactly what we want to see, the actual error.
    Now, try this:
    Code:
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\lib\ppap\maklumat.mdb;"
    sql="INSERT INTO maklumat(artikel_id,hari,bulan,tahun,sumber,subjek)"
    sql=sql & " VALUES "
    '...and so on
    conn.Execute sql,recaffected
    '...
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #10
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by glenngv
    That's exactly what we want to see, the actual error.
    Now, try this:
    Code:
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\lib\ppap\maklumat.mdb;"
    sql="INSERT INTO maklumat(artikel_id,hari,bulan,tahun,sumber,subjek)"
    sql=sql & " VALUES "
    '...and so on
    conn.Execute sql,recaffected
    '...
    it's didn't work too...still disply " no update permission". it's show like this:

    INSERT INTO maklumat(artikel_id,hari,bulan,tahun,sumber,subjek,artikel) VALUES ('bh08/zuera','27','September','2001','Berita Harian','Perindustrian','C:\Documents and Settings\libraryusr\My Documents\azura\artikel akhbar\Penternakan\13.pdf')No update permissions!

    why...?

  • #11
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,174
    Thanks
    19
    Thanked 66 Times in 65 Posts
    Looking at your code I'm guessing you're using the tutorial from w3schools. The no Update permissions is written out because its told to do so if there are errors, but the real error message indicates the same thing - you dont have permission to update the database. If you are running your own webserver on IIS, read this: http://www.webwizguide.info/asp/faq/...ermissions.asp it will show you how to set up the correct permissions.
    If you're not running your own host then you need to contact them and find out a) if you're allowed to use access dbs and b) the correct method for doing so on their servers.
    Some hosts have a _private folder outside the public_html folder for accessing databases - most likely that is where you want it to be (if you're using an external host)

  • #12
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    Quote Originally Posted by claypot
    it's didn't work too...still disply " no update permission". it's show like this:

    INSERT INTO maklumat(artikel_id,hari,bulan,tahun,sumber,subjek,artikel) VALUES ('bh08/zuera','27','September','2001','Berita Harian','Perindustrian','C:\Documents and Settings\libraryusr\My Documents\azura\artikel akhbar\Penternakan\13.pdf')No update permissions!

    why...?
    Temporarily remove the on error resume next statement so that we can see the actual error.
    Code:
    'on error resume next
    conn.Execute sql,recaffected
    'if err<>0 then
    '  Response.Write("No update permissions!")
    'else
      Response.Write("<h3>" & recaffected & " record added</h3>")
    'end if
    The "No update permissions!" error is your own generic error message that may or may not be related to database or IIS permission settings.
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #13
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,174
    Thanks
    19
    Thanked 66 Times in 65 Posts
    Quote Originally Posted by glenngv
    Temporarily remove the on error resume next statement so that we can see the actual error.
    Code:
    'on error resume next
    conn.Execute sql,recaffected
    'if err<>0 then
    '  Response.Write("No update permissions!")
    'else
      Response.Write("<h3>" & recaffected & " record added</h3>")
    'end if
    The "No update permissions!" error is your own generic error message that may or may not be related to database or IIS permission settings.
    That is true but the most likely cause of this error:
    Quote Originally Posted by claypot
    Error Type:
    Microsoft JET Database Engine (0x80004005)
    Operation must use an updateable query.
    /lib/ppap/mmm.asp, line 17


    *line 17 is "conn.Execute sql,recaffected"
    is database permissions.

  • #14
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    If that indeed is the actual error message, then read this ASP FAQ about "Operation must use an updateable query" errors.
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #15
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,174
    Thanks
    19
    Thanked 66 Times in 65 Posts
    Quote Originally Posted by ASP FAQ
    This is almost always a permissions issue.
    ...which is what I said 3 hours ago

    This link will give you additional information on how to set the permissions (with pictures ) http://www.webwizguide.info/asp/faq/...ermissions.asp
    Last edited by NancyJ; 09-19-2005 at 12:16 PM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •