Hi All,
Opening and closing connection for each database
Request Or keeping a coonection open in the beginning
of the page and closing it at the end, Which is better?
and why?
TIA
Roji
----- Original Message -----
From: "Bostrup, Tore" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 9:41 PM
Subject: RE: Unknow SQL Update error
> TEXT is a reserved word in MS Access. Use [text] instead.
>
> HTH,
> Tore.
>
> -----Original Message-----
> From: Tim [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 11:11 AM
> To: ActiveServerPages
> Subject: Unknow SQL Update error
>
>
> Hopefully this post will not appear 2x, it keeps being rejected from the
> ListSeerv.
>
>
> I'm not a newbie, but damned if i can find my booboo here. I get this
> error.. "Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error in UPDATE statement.
> /Admin/news.asp, line 201"
>
> here's a Response.Write of my SQL "UPDATE News SET entry_date = #8/8/2002
> 10:56:02 AM#, title = 'Mens B National Champions
> Blyth Storm, Blyth, O', text = 'Congratulations to Blyth Storm, Blyth
> Ontario - 2002 Champs!!' WHERE (Entry_id = 2)"
>
>
> here's my actual String...
> strSQL = "UPDATE News SET " _
> & "entry_date = #" & sEntry_Date & "#, " _
> & "title = '" & sTitle & "', " _
> & "text = '" & stext & "' " _
> & "WHERE (Entry_id = " & iRecordId & ")"
>
> Set cnnDBEdit =
> Server.CreateObject("ADODB.Connection")
> cnnDBEdit.Open CONN_STRING
>
> cnnDBEdit.Execute strSQL, adAffectAll, adCmdText Or
> adExecuteNoRecords
>
> ---
> You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> %%email.unsub%%
>
> ---
> You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
>
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
