Re: FN-FORUM ASP & Access Query

date posted 1st September 2001 16:23

cheers,

will look into this too.

Jon
----- Original Message -----
From: "David Eckersall" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Saturday, September 01, 2001 1:50 PM
Subject: Re: FN-FORUM ASP & Access Query


> if your using access 2000 then you can use the @@IDENTITY variable, more
> commonly used in sql server.
> i've not done this for a while but if i remember correctly it goes like
> this:
>
> 'objConn is connection object *USING OLE DB LAYER*
> sql="INSERT INTO tablename (yada1, yada2) VALUES ('"&var1&"',
> '"&var2&"');SELECT @@IDENTITY"
>
> objConn.execute (sql).nextrecordset
> insertID=objConn(0).value
>
> there are actually a few methods for doing this, but this way seems to
> support the best performance and unlike others guarantees the recordset
isnt
> updated in between.
>
> hth
>
> dave ecky
> ----- Original Message -----
> From: "Jonathan Irvine" [EMAIL REMOVED]
> To: "FREELANCERS" [EMAIL REMOVED]
> Sent: Friday, August 31, 2001 7:08 PM
> Subject: FN-FORUM ASP & Access Query
>
>
> > Hi all,
> >
> > I'm mr query man today.....lol
> >
> > I have a site www.yorkpubguide.com where people can add pub reviews.
It's
> > not finished but
> > a few people have entered stuff. I've found a problem with it though and
> was
> > wondering if anyone
> > could help.
> >
> > When the pub isn't listed user can add them. However they aren't taken
to
> > the actual review form
> > afterwards. Is there anyway of after submitting knowing the Primary Id
of
> > the pub they've entered
> > and redirecting them to a review form which will know which pub to add
it
> > too?
> >
> > Thank everyone. Feel free to test it and see... make sure the pub name
is
> > obvious.
> >
> > Jon
> >
> >
> > *********************** Tight Briefs ***********************
> >
> > Tight Briefs is a new, soon to be launched, remote working
> > projects service from Freelancers.net
> >
> > Clients post their tightly defined briefs, choose a price
> > and freelancers are invited to apply.
> >
> > All client to freelancer contact is handled by us.
> >
> > More details: http://www.freelancers.net/tightbriefs.html
> >
> > ============================================================
> >
> > * Free listing for freelancers
> > * Free to advertise jobs
> > * Free jobs distribution service
> > * Free database of 1000 freelancers
> >
> > Freelancers and Freelance Jobs
> > http://www.freelancers.net
> >
> > To post to the Forum:
> > [EMAIL REMOVED]
> >
> > To unsubscribe please email:
> > [EMAIL REMOVED]
> >
> > To unsubscribe from the digest please email:
> >
> > [EMAIL REMOVED]
> >
> > If you have difficulties unsubscribing please email:
> > [EMAIL REMOVED]
> >
> > To subscribe to the digest for this list or for further information
please
> visit:
> > http://www.freelancers.net/forum.html
>
>
> *********************** Tight Briefs ***********************
>
> Tight Briefs is a new, soon to be launched, remote working
> projects service from Freelancers.net
>
> Clients post their tightly defined briefs, choose a price
> and freelancers are invited to apply.
>
> All client to freelancer contact is handled by us.
>
> More details: http://www.freelancers.net/tightbriefs.html
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> To unsubscribe from the digest please email:
>
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html