Preferred method of doing an update within Asp using Access

[Terry Murray]

I was wondering what is the best method of accomplishing an update within
Asp using Access? I was going to going to use the update method of an ado
recordset, but I thought I would ask in case there is a more efficient way
to do it.

Thanks
Terry

[Ray at]

I'd go with that. Just don't ever fall into the nonsense of creating a
recordset object when doing an update like so many people do for some
unexplained reason!

Ray at work

"Terry Murray" <tgmurray@rogers.com> wrote in message
news:F5vwb.21923$X2W1.10824@news04.bloor.is.net.ca ble.rogers.com...

> I was wondering what is the best method of accomplishing an update within
> Asp using Access? I was going to going to use the update method of an ado
> recordset, but I thought I would ask in case there is a more efficient way
> to do it.
>
> Thanks
> Terry
>
>

[Bob Barrows]

Terry Murray wrote:

> I was wondering what is the best method of accomplishing an update
> within Asp using Access? I was going to going to use the update
> method of an ado recordset, but I thought I would ask in case there
> is a more efficient way to do it.
>
> Thanks
> Terry

With VB, using the recordset's update method is fine. In ASP however, you
should use SQL DML (data modification language) instead, since it gets you
in and out of the database so much faster than a cursor.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Terry Murray]

Hi Ray. So if I understand you correctly. I should not have to use the
following statement:

Set rst = Server.CreateObject("ADODB.Recordset")

If its not too much trouble can you provide a little a snippet on how you
would perform an update. Remember I am using access withing Asp.

Thanks
Terry

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:erJQuYtsDHA.3196@TK2MSFTNGP11.phx.gbl...

> I'd go with that. Just don't ever fall into the nonsense of creating a
> recordset object when doing an update like so many people do for some
> unexplained reason!
>
> Ray at work
>
> "Terry Murray" <tgmurray@rogers.com> wrote in message
> news:F5vwb.21923$X2W1.10824@news04.bloor.is.net.ca ble.rogers.com...

> > I was wondering what is the best method of accomplishing an update

within

> > Asp using Access? I was going to going to use the update method of an

ado

> > recordset, but I thought I would ask in case there is a more efficient

way

> > to do it.
> >
> > Thanks
> > Terry
> >
> >

>
>

[Ray at]

Yeah, you shouldn't have to use that statement too often.

sSQL = "UDATE YourTable SET Something='something' WHERE Something='some
value'"
Set oADO = Server.CreateObject("ADODB.Connection")
oADO.Open YourConnectionString
oADO.Execute sSQL
oADO.Close
Set oADO = Nothing

The basic idea is to connect, execute, close, and destroy as fast as
possible. Even the building of your SQL string should be done before
creating, connectiong, etc., for that extra .000000001 seconds. :]

Ray at work


"Terry Murray" <tgmurray@rogers.com> wrote in message
news:gxvwb.22298$X2W1.17474@news04.bloor.is.net.ca ble.rogers.com...

> Hi Ray. So if I understand you correctly. I should not have to use the
> following statement:
>
> Set rst = Server.CreateObject("ADODB.Recordset")
>
> If its not too much trouble can you provide a little a snippet on how you
> would perform an update. Remember I am using access withing Asp.
>
> Thanks
> Terry
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:erJQuYtsDHA.3196@TK2MSFTNGP11.phx.gbl...

> > I'd go with that. Just don't ever fall into the nonsense of creating a
> > recordset object when doing an update like so many people do for some
> > unexplained reason!
> >
> > Ray at work
> >
> > "Terry Murray" <tgmurray@rogers.com> wrote in message
> > news:F5vwb.21923$X2W1.10824@news04.bloor.is.net.ca ble.rogers.com...

> > > I was wondering what is the best method of accomplishing an update

> within

> > > Asp using Access? I was going to going to use the update method of an

> ado

> > > recordset, but I thought I would ask in case there is a more efficient

> way

> > > to do it.
> > >
> > > Thanks
> > > Terry
> > >
> > >

> >
> >

>
>

[Terry Murray]

Hi Bob. You have definitely got me interested. Does this SQL DML work with
Access? And if so, where can I learn how to use it?

Thanks
Terry

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%237AntltsDHA.3496@TK2MSFTNGP11.phx.gbl...

> Terry Murray wrote:

> > I was wondering what is the best method of accomplishing an update
> > within Asp using Access? I was going to going to use the update
> > method of an ado recordset, but I thought I would ask in case there
> > is a more efficient way to do it.
> >
> > Thanks
> > Terry

> With VB, using the recordset's update method is fine. In ASP however, you
> should use SQL DML (data modification language) instead, since it gets you
> in and out of the database so much faster than a cursor.
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

[Bob Barrows]

DML is simply SQL statements using the UPDATE, INSERT and DELETE commands.
Ray has shown you an example.

Check out the JetSQL Reference in Access Online help. You will need to use
the Contents tab to find it.

Bob Barrows

Terry Murray wrote:

> Hi Bob. You have definitely got me interested. Does this SQL DML
> work with Access? And if so, where can I learn how to use it?
>
> Thanks
> Terry
>
> "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:%237AntltsDHA.3496@TK2MSFTNGP11.phx.gbl...

>> Terry Murray wrote:

>>> I was wondering what is the best method of accomplishing an update
>>> within Asp using Access? I was going to going to use the update
>>> method of an ado recordset, but I thought I would ask in case there
>>> is a more efficient way to do it.
>>>
>>> Thanks
>>> Terry

>> With VB, using the recordset's update method is fine. In ASP
>> however, you should use SQL DML (data modification language)
>> instead, since it gets you in and out of the database so much faster
>> than a cursor.
>>
>> Bob Barrows
>> --
>> Microsoft MVP -- ASP/ASP.NET
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get
>> a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Terry Murray]

Thanks again Ray
Terry

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uGr$nqtsDHA.4056@TK2MSFTNGP11.phx.gbl...

> Yeah, you shouldn't have to use that statement too often.
>
> sSQL = "UDATE YourTable SET Something='something' WHERE Something='some
> value'"
> Set oADO = Server.CreateObject("ADODB.Connection")
> oADO.Open YourConnectionString
> oADO.Execute sSQL
> oADO.Close
> Set oADO = Nothing
>
> The basic idea is to connect, execute, close, and destroy as fast as
> possible. Even the building of your SQL string should be done before
> creating, connectiong, etc., for that extra .000000001 seconds. :]
>
> Ray at work
>
>
> "Terry Murray" <tgmurray@rogers.com> wrote in message
> news:gxvwb.22298$X2W1.17474@news04.bloor.is.net.ca ble.rogers.com...

> > Hi Ray. So if I understand you correctly. I should not have to use the
> > following statement:
> >
> > Set rst = Server.CreateObject("ADODB.Recordset")
> >
> > If its not too much trouble can you provide a little a snippet on how

you

> > would perform an update. Remember I am using access withing Asp.
> >
> > Thanks
> > Terry
> >
> > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> > news:erJQuYtsDHA.3196@TK2MSFTNGP11.phx.gbl...

> > > I'd go with that. Just don't ever fall into the nonsense of creating

a

> > > recordset object when doing an update like so many people do for some
> > > unexplained reason!
> > >
> > > Ray at work
> > >
> > > "Terry Murray" <tgmurray@rogers.com> wrote in message
> > > news:F5vwb.21923$X2W1.10824@news04.bloor.is.net.ca ble.rogers.com...
> > > > I was wondering what is the best method of accomplishing an update

> > within

> > > > Asp using Access? I was going to going to use the update method of

an

> > ado

> > > > recordset, but I thought I would ask in case there is a more

efficient

> > way

> > > > to do it.
> > > >
> > > > Thanks
> > > > Terry
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Ray at]

You bet. :]

Ray at home

"Terry Murray" <tgmurray@rogers.com> wrote in message
news:F_vwb.22693$X2W1.6812@news04.bloor.is.net.cab le.rogers.com...

> Thanks again Ray
> Terry

[Jeff Cochran]

On Mon, 24 Nov 2003 16:59:04 -0500, "Ray at <%=sLocation%>"
<myfirstname at lane34 dot com> wrote:

>I'd go with that. Just don't ever fall into the nonsense of creating a
>recordset object when doing an update like so many people do for some
>unexplained reason!

I think it has to do with working in VB, and I've seen a number of
tutorials that use that method. Some of my first ASP code still has
record sets for updates and inserts, simply because I copied tutorials
when creating it and I'm too busy (or lazy) to go back through and
optimize it. Besides, if it works... :)

Yeah, I know. It could work *better*.

Jeff