TonikCapGajah2013 175 Report post Posted February 23, 2005 (edited) Salam.Kepada sesiapa yang berminat, sila sediakan PC anda dengan perisian yang diperlukan. Keterangan Lanjut DisiniInstall IIS WinXP ProInstall PWS - Win98Ok...TQ. Edited February 23, 2005 by OngBok Quote Share this post Link to post Share on other sites
izwan 1 Report post Posted February 23, 2005 (edited) kena mula iklan dah la ni OngBok.. http://k.1asphost.com/aspnet300/mmxurl tu.. erm.. last sekali kalo rajin buat la satu .pdf ke, ebook ke eh? pastu jangan lupa daftarkan bawah KPDN&HEP sekali. penting tau! Edited February 23, 2005 by izwan Quote Share this post Link to post Share on other sites
share4ur 0 Report post Posted February 23, 2005 bagus ni...aku xleh bukak le url ni.. Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted February 23, 2005 Izwan.Tak yah iklan sangat. Aku cuba nak buat simple jer.. supaya mudah faham dan boleh guna database dalam 1asphost.Tak yah daftar, kalau ade sapa-sapa nak copy silakan. Cuma link akan diberi melalui PM.Share4urApasal tak leh buka... dah test pc lain ok jer.Cuba lagi.Ok...TQ Quote Share this post Link to post Share on other sites
share4ur 0 Report post Posted February 23, 2005 Izwan.Tak yah iklan sangat. Aku cuba nak buat simple jer.. supaya mudah faham dan boleh guna database dalam 1asphost.Tak yah daftar, kalau ade sapa-sapa nak copy silakan. Cuma link akan diberi melalui PM.Share4urApasal tak leh buka... dah test pc lain ok jer.Cuba lagi.Ok...TQ←tq. tqms access 2003 boleh x? Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted February 23, 2005 Boleh... no hal Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted February 27, 2005 (edited) Kepada ahli yang berminat sahaja.Tutorial DW MX termasuk XARA WebStyle4.Contoh DiSiniSetup PC anda dengan perisian yang dikehendaki secepat mungkin.Harap maklum. Edited February 27, 2005 by OngBok Quote Share this post Link to post Share on other sites
necrome 0 Report post Posted March 4, 2005 Bila nak start belajar ni tak sabar nak belajar ni..... Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 4, 2005 Aku dah upload semua bahan. cuma korang kena sedia beberapa software:1. WinXP CDROM untuk install IIS dalam Sistem Windows XP Pro. 2. Dreamweaver MX (V6)3. MS Access (XP)Sehari dua lagi aku beritau.. ok.TQ. Quote Share this post Link to post Share on other sites
kred 0 Report post Posted March 7, 2005 menungu...... Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 7, 2005 (edited) OK...OK dah beres.saya nak mulakan tutorial malam nie.Saya anggap sapa-sapa yang berminat dan nak ikut tutorial nie;1. Telah install IIS dalam Windows XP2. Telah install DreamWeaver MX 2004Ok. TQSESI 1Install IIS (v5)Install MX 2004 Edited March 7, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 7, 2005 (edited) SESI 2:Setting Site Dalam DWMX 2004Selepas nie buat connection ke database.Setting Data Source Edited March 7, 2005 by OngBok Quote Share this post Link to post Share on other sites
al-siput 2 Report post Posted March 7, 2005 ongbok..kalo apache buleh tak?nanti clash port pulak nih.. Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 7, 2005 (edited) Saya belum pernah try install 2 jenis program server dalam 1 OSKo cuba install IIS. Test dua2. Apache dan IISKalau konflik uninstall IIS.Apa kata ko buat 2 OS.===================================================Ringkasan Tugasan:SESI 1Install IIS (v5)Install MX 2004SESI 2:Setting Site Dalam DWMX 2004 INFOSetting Data Source INFOSESI 3:Setting Connection + View Record INFO Edited March 7, 2005 by OngBok Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 29, 2005 Saya belum pernah try install 2 jenis program server dalam 1 OSKo cuba install IIS. Test dua2. Apache dan IISKalau konflik uninstall IIS.Apa kata ko buat 2 OS.===================================================Ringkasan Tugasan:SESI 1Install IIS (v5)Install MX 2004SESI 2:Setting Site Dalam DWMX 2004 INFOSetting Data Source INFOSESI 3:Setting Connection + View Record INFO← Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 29, 2005 OngBok, bila nak ajar insert record? saya dah tak sabar nak ikut ni sbb lesson sebelum ni saya dah dapat. tkasih. Quote Share this post Link to post Share on other sites
C-Fu 0 Report post Posted March 29, 2005 pergh semangat ko ek. well good luck mate.dulu ako pon ade buat tut dreamweaver gak. cuma just ajar orang pasal html je. taktau la ade orang nak lagi ke idak. Quote Share this post Link to post Share on other sites
mohdfadly 24 Report post Posted March 29, 2005 C-FU ada simpan lagi ke tutorial dreamweaver tu? boleh la post kat sini sebab ada ramai newbie dreamweaver kat sini. Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 30, 2005 ongbok,maaf. boleh tolong saya, saya cuba buat sendiri utk insert record, tapi data tak leh msuk table. saya dah set connection ke database dan successful. boleh tak cek kod dibawah sbb saya rasa ada silap di dlm coding ni..Ini error yg saya dpt dr Internet Explorer:There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following:• Click the Refresh button, or try again later.• Open the localhost home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP errorInternet Information Services Technical Information (for support personnel)• Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use./cubalagi/cubaform.asp, line 113• Browser Type:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) • Page:POST 47 bytes to /cubalagi/cubaform.asp • POST Data:nama=rrr&umur=123&Submit=Submit&MM_insert=form1 • Time:Tuesday, March 29, 2005, 7:08:08 PM • More information:Microsoft Support Dan ini kod yg terhasil dlm dreamweaver:<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!--#include file="Connections/cubaconn.asp" --><%' *** Edit Operations: declare variablesDim MM_editActionDim MM_abortEditDim MM_editQueryDim MM_editCmdDim MM_editConnectionDim MM_editTableDim MM_editRedirectUrlDim MM_editColumnDim MM_recordIdDim MM_fieldsStrDim MM_columnsStrDim MM_fieldsDim MM_columnsDim MM_typeArrayDim MM_formValDim MM_delimDim MM_altValDim MM_emptyValDim MM_iMM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)End If' boolean to abort record editMM_abortEdit = false' query string to executeMM_editQuery = ""%><%' *** Insert Record: set variablesIf (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_cubaconn_STRING MM_editTable = "Tablecubalagi" MM_editRedirectUrl = "berjaya.asp" MM_fieldsStr = "nama|value|umur|value" MM_columnsStr = "nama|',none,''|umur|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End IfEnd If%><%' *** Insert Record: construct a sql insert statement and execute itDim MM_tableValuesDim MM_dbValuesIf (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection (line 113) MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End IfEnd If%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><title>Untitled Document</title></head><body><form name="form1" method="POST" action="<%=MM_editAction%>"> <div align="center"> <p>cubalagi form</p> <p align="left"> nama : <input name="nama" type="text" id="nama" size="10"></p> <p align="left">umur : <input name="umur" type="text" id="umur" size="3"></p> <p align="left"> <input type="submit" name="Submit" value="Submit"></p> </div> <input type="hidden" name="MM_insert" value="form1"></form></body></html> Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 30, 2005 pergh semangat ko ek. well good luck mate.dulu ako pon ade buat tut dreamweaver gak. cuma just ajar orang pasal html je. taktau la ade orang nak lagi ke idak.←C-Fu, awak boleh tolong saya ker? Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 30, 2005 (edited) Ni link untuk add recordhttp://k.1asphost.com/aspnet300/mmx/tutaddrec.htmlTUTORIAL Ver 2.0Lepas nie saya cadang nak buat tutorial menggunakan site Brinkster.comTutorial nie agak terperinci berkenaan dengan;1. Pendaftaran dan setup akaun di Brinkster.com ( http://www.brinkster.com )2. Penggunaan Dreamweaver MX + ASP + Database3. DSN-Less ConnectionJadi korang boleh run application terus di site brinkster.comKalau boleh dapatkan satu akaun di http://www.brinkster.com free Educational PackageOK. TQ Edited March 30, 2005 by OngBok Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 31, 2005 t.q ongbok. saya akan cuba sekejap lagi.... Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 31, 2005 OngBok, puas dah saya cube tapi msih x dpt. error messages sama spt yg saye pastekan sebelum ni.... kenapa? saye paste lagi skali:HTTP 500.100 - Internal Server Error - ASP errorInternet Information Services--------------------------------------------------------------------------------Technical Information (for support personnel)Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use./website/addrecord.asp, line 113Browser Type:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Page:POST 100 bytes to /website/addrecord.aspPOST Data:ISBN=fsd&TAJUK=sdfsd&KATEGORI=fds&PENGARANG=sdf&KODORDER=dsf&MUKASURAT=df&HARGA=12.9&MM_insert=form1 Time:Thursday, March 31, 2005, 4:55:15 AM .........................................................sebenarnya seblum nie(tutorial utk view record) saye dpt error yg sama tapi setelah hampir 5 atau lebih x cube baru betul... tak tahulah ape yg saya buat tiba dpt view. di kolej tadipun saya cuba steps yg sama tapi tak dpt dan yg peliknya... error sama iaitu line 113(active connection). sbenarnya saya dah confuse nie.. sekejap boleh, sekejap tak.adakah sebab connection tak betul? tapi... dah ada pop up "connection succesful". harap2 ongbok boleh clarify. tq........... Quote Share this post Link to post Share on other sites
sris 0 Report post Posted March 31, 2005 a'kum.OngBok, saya dpti kena tutup semua files dan refresh desktop dahulu baru boleh buat view records otherwise akn dpt error mcm yg saya paste tadi. Tapi utk add record, saya cuba cara yg sama(tutup semua files dan refresh desktop) masih x dpt dan ini error yg saya dpt:Technical Information (for support personnel)Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query./website/addrecord.asp, line 115saya x faham apa yg dimaksudkan dengan sttmt nie "Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query"tq...... harap u bleh tolong saya. Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 31, 2005 (edited) Ko guna XP SP2 ker?MS Access XP/2002 ?Cuba buka fail database dalam ms accessklik Tools > Database Utility > Compact & Repair... Edited March 31, 2005 by OngBok Quote Share this post Link to post Share on other sites