Jump to content
TonikCapGajah2013

Tutorial Dreamweaver Mx Online

Recommended Posts

Ko guna XP SP2 ker?

MS Access XP/2002 ?

Cuba buka fail database dalam ms access

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

saya guna ms access 2002 dan windows xp. dan saya dah cuba klik Tools > Database Utility > Compact & Repair... masih dpt error yg sama... huh.gif

Share this post


Link to post
Share on other sites

1. kat dalam source view dalam dw, ko enable line number so tau line 113 tu ape kod die.

2. ako memang sokong sangat untuk guna connection string / dsn-less connection, problem senang je setel. dan most free asp website memang suruh kita gune connection string pon.

3. mase ko edit kod tu dan run ko bukak ms access ke? cube tutup access dulu. kalo tak jad gak, pi Start>run>odbcad32, pastu ko doubleklik entry database ko tuh. tengok name die. same tak ngan name yang ko boh kat dalam DW? kalo sama, kat dalam odbcad32 tadik tu doubleklik kat dbase ko. klik Advanced. tambah jumlah Threads dari 3 kepada 8 ke 10 ke.

4. dari ape yang ako blaja untuk buat mende ni dalam dw dulu, kalo error tu tetap menjadi tapi ko dah buat ape yang ko rase betul...

ko kene bukak source die, pastu delete SEMUA ASP KOD. semua, kecuali file2 html. pasal sometimes, bile ko klik + untuk add record ke pastu ko klik - untuk buang fungsi dari dw tu nanti certain code die tak buang. so tu pasal error.

cara ako dulu bile buat , kalo contohnye insert record, ako buat very very basic webpage ngan form. teks hitam ngan page putih background. bile dah takde problem untk insert record, baru ako start main2 dengan kaler la image la etc etc.

tutorial tu ako rase ade jumpe. tapi ako nak send/upload ke mane? ade gamba2 skali.

AND, bila ko nak pos kod ke putera ni, make sure yang kod tu dalam tag [.code]kod2[./code].

contoh macam

<% blaaaaaah blahhhh %>

ni site ako bile ako start belajar ASP ngan dreamweaver untuk keje skolah dulu. total time buat: 4 5 hari dari start blaja sampai siap hahahahhaha ako beshhhhhhhhhhhhhhhh

offtopic: dalam dreamweaver, kalo ade flash file yang ko nak background die transparent cam ako buat tu, dalam dw klik kat flash movie tu, pastu under properties ko tambah parameter ni

name wmode

value transparent

Edited by C-Fu

Share this post


Link to post
Share on other sites

Untuk memastikan semua software di install dan konfigur dengan betul, cuba ikut step nie.

1. Buat satu folder tryasp dalam C:\inetpub\wwwroot

2. Buat satu folder db dalam folder tryasp.

3. Path yang akan terjadi;

c:\inetpub\wwwroot\tryasp\db

4. Buat satu fail database access (simpan fail tryasp.mdb dalam folder db) seperti berikut;

fieldname: Username dan IC_No (datatype: text)

5. Simpan table tbl_Username

Semak path database.

c:\inetpub\wwwroot\tryasp\db\tryasp.mdb

Dreamweaver

Setting site.

1. Klik Site > Manage Sites > New > Site

user posted image

Kemudian ikut step by step.

user posted image

Edited by OngBok

Share this post


Link to post
Share on other sites

Buat Connection String

1. klik file > new. Pilih dynamic page > asp.net VB

user posted image

2. Klik Template > Microsoft Jet

user posted image

Edited by OngBok

Share this post


Link to post
Share on other sites

Copy semua text conn. string

user posted image

paste dalam ruang kosong.

taip data source spt dalam gambar.

user id=;

password=;

user posted image

Edited by OngBok

Share this post


Link to post
Share on other sites

Klik Application > Database

Klik + > Custom Conn String

user posted image

Isikan seperti dalam rajah.

Untuk conn string > paste. (string yang telah dicopy sebelum ini)

user posted image

Edited by OngBok

Share this post


Link to post
Share on other sites

user posted image

user posted image

Simpan fail dengan nama try.asp

akhir sekali , tekan F12 untuk test dalam browser

user posted image

try masuk data, dan check database. kalu ok. ok la. biggrin.gif

Edited by OngBok

Share this post


Link to post
Share on other sites

berkenaan error tu, cuba download MDAC latest. kalau tak silap aku, MDAC 2.8.

anyway, good job OngBok. btw, aku pun ada buat jugak site dengan 1stasphost ni. saje saje takde keje. coding bodo jek. testing testing hahahaha. buat connection string pun, manual sampai DMX takleh recognize aku punya coding tu (i must be bad in programming, somehow).

http://k.1asphost.com/daniaherzegovina

ID: testing

password: testing

Share this post


Link to post
Share on other sites

SET Database Connection On Site.

Upload fail database ke dalam folder db di brinkster.com

Upload fail try.asp ke root folder di brinkster.com

Contoh:

try.asp

Edited by OngBok

Share this post


Link to post
Share on other sites

Selepas upload ke brinkster, anda belum boleh running fail asp ini.

Buat sedikit pindaan seperti berikut.

Dalam Classic File Manager, klik file try.asp > klik Edit file.

Kod dibaca dari atas;

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

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<!--#include file="Connections/connTryasp.asp" -->

<%

' *** Edit Operations: declare variables

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

Delete baris <!--#include file="Connections/connTryasp.asp" --> dan gantikan dengan kod ini

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%

Dim myConn, MM_connTryasp_STRING

Set myConn = Server.CreateObject("ADODB.Connection")

MM_connTryasp_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};" & _

"DBQ=" & Server.MapPath("\username\db\namafail.mdb") & ";"

myConn.Open(MM_connTryasp_STRING)

%>

<%

' *** Edit Operations: declare variables

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

Sesuaikan path anda dan nama fail database.

Kenapa gunakan var MM_connTryasp_STRING ?

Kerana var ini digunakan dalam baris berikutnya. cuba check kod dibawah

<%

' *** Insert Record: set variables

If (CStr(Request("MM_insert")) = "form1") Then

MM_editConnection = MM_connTryasp_STRING

MM_editTable = "tbl_Username"

MM_editRedirectUrl = "thank.html"

MM_fieldsStr = "Username|value|IC_No|value"

MM_columnsStr = "Username|',none,''|IC_No|',none,''"

Edited by OngBok

Share this post


Link to post
Share on other sites

tahniah kpada ONG BOK ... mjadi lecturer dkat sini... aku bangga putera.com mmpunyai kjasama yg hebat!!

tapi aku dah tlambat la thread nih...

ulang balik leh x??? [jgn marah... gurau...] tongue.gif

nk blaja nih kene ader pc yg berinternet... ph34r.gif

Share this post


Link to post
Share on other sites

Hai semua,

saya pun baru belajar guna dreamweaver ni.Macam best tapi tu ler lepas try sampai sekarang masih tak leh nak wat connection walaupun dah cuba step by step yang OngBok tunjuk tu...biler test URL dia kata dreamweaver cannot use the prefix you entered to display live data. HTTP Error: 12029) Kalu ada sesiapa yang boleh bagitau salah kat maner...tima kasihhh

Share this post


Link to post
Share on other sites

hihii...memang ler berminat....dah lama nak buat tapi tak kesempatan tapi biler tengok ada tutorial yang OngBok buat tu terus bersemangat nak sambung balik. Dan masalah tadi dah berjaya settlekan...lupa nak startkan IIS....tapi ada masalah lagi .selepas step 1 untuk connection string kan kena g template...tak jumper ler ikon nyer...so tak tau nak g maner....tolonnnn.tq

Share this post


Link to post
Share on other sites

Sekali lagi saya berjaya settlekan masalah saya dan telah sampai ke tahap set database connection on site.

biler saya view dia kuar error nie:

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

A string literal was expected, but no opening quote character was found. Error processing resource 'http://www45.brinkster....

<font face="Arial" size=2>

-------------------------^

Boleh OngBok bagitau kat maner yang perlu dibetulkan.Tima kasiihhh

Ini saya nyer kod

<?xml version="1.0" encoding="iso-8859-1"?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%

Dim myConn,MM_connTryasp_STRING

Set myConn=Server.CreateObject("ADODB.Connection")

MM_connTryasp_STRING="DRIVER={Microsoft Access Driver(*.mdb)};"&_

"DBQ="&Server.MapPath("\tiena77\db\tryasp.mdb")&";"

myConn.Open(MM_connTryap_STRING)

%>

<%

' *** 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 & "?" & 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_connTryasp_STRING

MM_editTable = "tbl_Username"

MM_editRedirectUrl = ""

MM_fieldsStr = "Username|value|IC_No|value|id|value"

MM_columnsStr = "Username|',none,''|IC_No|',none,''|id|none,none,NULL"

' 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

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

%>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

</head>

<body>

<form method="post" action="<%=MM_editAction%>" name="form1">

<table align="center">

<tr valign="baseline">

<td nowrap align="right">Username:</td>

<td> <input type="text" name="Username" value="" size="32"> </td>

</tr>

<tr valign="baseline">

<td nowrap align="right">IC_No:</td>

<td> <input type="text" name="IC_No" value="" size="32"> </td>

</tr>

<tr valign="baseline">

<td nowrap align="right">&nbsp;</td>

<td> <input type="submit" value="Insert Record"> </td>

</tr>

</table>

<input type="hidden" name="MM_insert" value="form1">

</form>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

</body>

</html>

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