wei, typenya mismatch...
ID='" &lngID & "' itu buat string
idnya string ato integer ? kalo integer .. gini
ID= " &lngID & "
;p
nice try
--- T�m� �l-��ghor� <[EMAIL PROTECTED]> wrote:
> Saya punya masalah yang mirip ini juga, pesan
> errornya :
>
> Microsoft OLE DB Provider for ODBC Drivers error
> '80040e07'
>
> [Microsoft][ODBC Microsoft Access Driver] Data type
> mismatch in criteria
> expression.
>
> /deletebreakingnews.asp, line 9
>
> code-nya :
>
> 6 dim lngID
> 7 lngID = Request.QueryString("ID")
> 8 SQL = "DELETE FROM BreakingNews WHERE ID='" &
> lngID & "' "
> 9 set objRS = Koneksi.Execute(SQL)
>
> Apa yang salah ya ? saya udah coba juga ngga pake
> long integer tapi hasilnya
> sama saja. Thank's.
> ----- Original Message -----
> From: Ady Permadi <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, October 09, 2000 2:49 PM
> Subject: Re: [MasterWeb] tolongin ASP dong...
>
>
> Loh.. milis ini kham emang nggak ngebahas flash
> aja.. :)
> Itu linknya sudah bener...
> tinggal dimasukkan ke sintak sqlnya..
> <%
> Usaha = Request.Querystring("usaha)
> sqlquery = "SELECT * FROM TABEL WHERE USAHA =
> '"&usaha&"'"
> %>
>
> btw.. pake database nggak ?
>
> BiG
>
>
>
> Ikutilah lomba banner flash berhadiah :
> http://www.master.web.id/kreasi-banner-berhadiah.htm
>
> -------[ Master Web Indonesia - www.master.web.id ]
> -------
> Moderator : [EMAIL PROTECTED]
> Berlangganan : [EMAIL PROTECTED]
> Stop Berlangganan : [EMAIL PROTECTED]
>
-----------------------------------------------------------
__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
Ikutilah lomba banner flash berhadiah :
http://www.master.web.id/kreasi-banner-berhadiah.htm
-------[ Master Web Indonesia - www.master.web.id ] -------
Moderator : [EMAIL PROTECTED]
Berlangganan : [EMAIL PROTECTED]
Stop Berlangganan : [EMAIL PROTECTED]
-----------------------------------------------------------
