Makasih mas-mas atas penjelasannya akan saya coba.
--- togi <[EMAIL PROTECTED]> wrote:
>
>
> kalo dari script yang pertama, kayanya yang baru
> dideklarasiin cuma nama
> variable, nilai dari msg2 variable blom
> dideklarasiin. idem kayak yang
> ditanyain om udhien, anda dapat nilai2 variable dari
> mana? kalo dari form,
> lihat dulu form methodnya (GET/POST). kalo methodnya
> POST, caranya kayak om
> Udhien (strday = request.form("nama field
> textbox")), sedangkan untuk yang
> methodnya GET, ganti aja sintaks "request.form" jadi
> "request.querystring".
> kalo nilai variable2 tsb sudah dideklarasiin di page
> lain, anda harus
> menginclude page tersebut di page anda.
>
> salam,
>
> Togi Pangihutan
> http://www.abd250979day.com
>
> ----- Original Message -----
> From: "cae kit" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 29, 2004 2:10 PM
> Subject: [MasterWeb] tanya error asp
>
>
> >
> >
> >
> > Hiiiii,
> > Aku bingung nich, databaseku belum bisa jalan. Aku
> udah coba 2 cara tapi
> kok sama aja .Komentarnya gini:
> >
> > [Microsoft][ODBC Microsoft Access Driver] Syntax
> error in INSERT INTO
> statement.
> > /coba/coba.asp, line 27
> > Script koneksinya gini:
> >
> > <%
> > response.buffer=true
> > response.expires=0
> > dim
> strday,strdate,strmonth,stryear,strstart,strfinish
> > dim oconn,strconn,strsql
> > strconn="dsn=catat"
> > set oconn=server.createobject("ADODB.Connection")
> > oConn.Open strConn
> > strsql="INSERT INTO catat("
> > strsql=strsql & "day,"
> > strsql=strsql & "date,"
> > strsql=strsql & "month,"
> > strsql=strsql & "year,"
> > strsql=strsql & "start,"
> > strsql=strsql & "finish"
> > strsql=strsql & ")"
> > strsql=strsql & "VALUES ("
> > strSQL=strSQL & "'& strday &',"
> > strSQL=strSQL & "'& strdate &',"
> > strSQL=strSQL & "'& strmonth &',"
> > strSQL=strSQL & "'& stryear &',"
> > strSQL=strSQL & "'& strstart &',"
> > strSQL=strSQL & "'& strfinish &'"
> > strSQL=strSQL & ")"
> > 'response.write strsql
> > 'response.end
> > oconn.execute strsql
> >
> > oconn.close
> > set oconn=nothing
> >
> > %>
> > Dan script yang satunya:
> >
> > <% Response.Buffer = True
> > Response.Expires = 0
> > Dim strday, strdate, strmonth, stryear, strstart,
> strfinish
> > Dim oConn, strConn, strSQL,oRs
> > strConn = "DSN=catat1"
> > Set oConn =
> Server.CreateObject("ADODB.Connection")
> > oConn.Open strConn
> > strSQL="INSERT INTO catat1
> (day,date,month,year,start,finish) values
>
('"&strday&"','&strdate&','"&strmonth&"','&stryear&','"&strstart&"','"&finis
> h&"')"
> >
> > 'response.write strSQL
> > 'response.end
> > oConn.Execute strSQL
> >
> > oConn.Close
> > Set oConn = Nothing
> > %>
> > Komentarnya sama:
> > Syntax error in INSERT INTO statement.
> > Tolong dong salahnya di mana?
> >
> >
> > Yahoo! Mobile
> > - Download the latest ringtones, games, and more!
> >
> > [Non-text portions of this message have been
> removed]
> >
> >
> >
> >
> >
> >
> >
> >
>
----------------------------------------------------------
> > Komunitas MasterWeb Indonesia
> http://www.master.web.id
> >
>
----------------------------------------------------------
> > MWN, Masternya WEBHOSTING di Indonesia, Indo/USA
> Servers,
> > Customer Support 24 jam
> http://www.masterwebnet.com
> >
>
----------------------------------------------------------
> > Sekolah Digital Design Terlengkap
> http://www.mwschool.com
> >
>
----------------------------------------------------------
> > WebDevelopment,Designing/Programming
> http://www.dlanet.com
> >
>
----------------------------------------------------------
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion
> Toolbar.
> Now with Pop-Up Blocker. Get it for free!
>
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/IHFolB/TM
>
--------------------------------------------------------------------~->
>
>
>
----------------------------------------------------------
> Komunitas MasterWeb Indonesia
> http://www.master.web.id
>
----------------------------------------------------------
> MWN, Masternya WEBHOSTING di Indonesia, Indo/USA
> Servers,
> Customer Support 24 jam http://www.masterwebnet.com
>
----------------------------------------------------------
> Sekolah Digital Design Terlengkap
> http://www.mwschool.com
>
----------------------------------------------------------
> WebDevelopment,Designing/Programming
> http://www.dlanet.com
>
----------------------------------------------------------
>
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Download the latest ringtones, games, and more!
http://sg.mobile.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/IHFolB/TM
--------------------------------------------------------------------~->
----------------------------------------------------------
Komunitas MasterWeb Indonesia http://www.master.web.id
----------------------------------------------------------
MWN, Masternya WEBHOSTING di Indonesia, Indo/USA Servers,
Customer Support 24 jam http://www.masterwebnet.com
----------------------------------------------------------
Sekolah Digital Design Terlengkap http://www.mwschool.com
----------------------------------------------------------
WebDevelopment,Designing/Programming http://www.dlanet.com
----------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/milis-masterweb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
