Jump to content
TonikCapGajah2013

Tutorial Dreamweaver Mx Online

Recommended Posts

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.

Share4ur

Apasal tak leh buka... dah test pc lain ok jer.

Cuba lagi.

Ok...TQ

Share this post


Link to post
Share on other sites

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.

Share4ur

Apasal tak leh buka... dah test pc lain ok jer.

Cuba lagi.

Ok...TQ

tq. tq

ms access 2003 boleh x?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 XP

2. Telah install DreamWeaver MX 2004

Ok. TQ

SESI 1

Install IIS (v5)

Install MX 2004

Edited by OngBok

Share this post


Link to post
Share on other sites

Saya belum pernah try install 2 jenis program server dalam 1 OS

Ko cuba install IIS. Test dua2. Apache dan IIS

Kalau konflik uninstall IIS.

Apa kata ko buat 2 OS.

===================================================

Ringkasan Tugasan:

SESI 1

Install IIS (v5)

Install MX 2004

SESI 2:

Setting Site Dalam DWMX 2004 INFO

Setting Data Source INFO

SESI 3:

Setting Connection + View Record INFO

Edited by OngBok

Share this post


Link to post
Share on other sites

Saya belum pernah try install 2 jenis program server dalam 1 OS

Ko cuba install IIS. Test dua2. Apache dan IIS

Kalau konflik uninstall IIS.

Apa kata ko buat 2 OS.

===================================================

Ringkasan Tugasan:

SESI 1

Install IIS (v5)

Install MX 2004

SESI 2:

Setting Site Dalam DWMX 2004 INFO

Setting Data Source INFO

SESI 3:

Setting Connection + View Record INFO

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 error

Internet 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 variables

Dim MM_editAction

Dim MM_abortEdit

Dim MM_editQuery

Dim MM_editCmd

Dim MM_editConnection

Dim MM_editTable

Dim MM_editRedirectUrl

Dim MM_editColumn

Dim MM_recordId

Dim MM_fieldsStr

Dim MM_columnsStr

Dim MM_fields

Dim MM_columns

Dim MM_typeArray

Dim MM_formVal

Dim MM_delim

Dim MM_altVal

Dim MM_emptyVal

Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))

If (Request.QueryString <> "") Then

MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)

End If

' boolean to abort record edit

MM_abortEdit = false

' query string to execute

MM_editQuery = ""

%>

<%

' *** Insert Record: set variables

If (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 If

End If

%>

<%

' *** Insert Record: construct a sql insert statement and execute it

Dim MM_tableValues

Dim MM_dbValues

If (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 If

End 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>

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Ni link untuk add record

http://k.1asphost.com/aspnet300/mmx/tutaddrec.html

TUTORIAL Ver 2.0

Lepas nie saya cadang nak buat tutorial menggunakan site Brinkster.com

Tutorial nie agak terperinci berkenaan dengan;

1. Pendaftaran dan setup akaun di Brinkster.com ( http://www.brinkster.com )

2. Penggunaan Dreamweaver MX + ASP + Database

3. DSN-Less Connection

Jadi korang boleh run application terus di site brinkster.com

Kalau boleh dapatkan satu akaun di http://www.brinkster.com free Educational Package

OK. TQ

Edited by OngBok

Share this post


Link to post
Share on other sites

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 error

Internet 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 113

Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

Page:

POST 100 bytes to /website/addrecord.asp

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

Share this post


Link to post
Share on other sites

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 115

saya 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. wacko.gifwacko.gifwacko.gif

Share this post


Link to post
Share on other sites

Ko guna XP SP2 ker?

MS Access XP/2002 ?

Cuba buka fail database dalam ms access

klik Tools > Database Utility > Compact & Repair...

Edited by OngBok

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...