...

View Full Version : help meee....



claypot
09-16-2005, 04:53 AM
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.. :(

glenngv
09-16-2005, 06:12 AM
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 (http://www.google.com/search?q=ASP+File+Upload).

claypot
09-16-2005, 09:47 AM
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="clsid:D27CDB6E-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="clsid:D27CDB6E-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="clsid:D27CDB6E-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="clsid:D27CDB6E-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.... :( :( :(

glenngv
09-16-2005, 09:57 AM
Comment out first on error resume next to see the actual and detailed error message.

claypot
09-16-2005, 10:06 AM
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..

glenngv
09-16-2005, 10:29 AM
'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.

NancyJ
09-16-2005, 10:30 AM
remove this line:


<%
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.

claypot
09-19-2005, 04:06 AM
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?

glenngv
09-19-2005, 08:59 AM
That's exactly what we want to see, the actual error.
Now, try this:

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
'...

claypot
09-19-2005, 10:21 AM
That's exactly what we want to see, the actual error.
Now, try this:

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...?

NancyJ
09-19-2005, 10:43 AM
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/server_permissions.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)

glenngv
09-19-2005, 11:59 AM
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.


'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.

NancyJ
09-19-2005, 12:13 PM
Temporarily remove the on error resume next statement so that we can see the actual error.


'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:

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.

glenngv
09-19-2005, 12:29 PM
If that indeed is the actual error message, then read this ASP FAQ (http://www.aspfaq.com/show.asp?id=2062) about "Operation must use an updateable query" errors.

NancyJ
09-19-2005, 01:14 PM
This is almost always a permissions issue.

...which is what I said 3 hours ago :p

This link will give you additional information on how to set the permissions (with pictures ;) ) http://www.webwizguide.info/asp/faq/server_permissions.asp



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum