Re: FN-FORUM ASP & Access Query

date posted 1st September 2001 13:58

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