[thelist] ASP - Access

Eric Engelmann eric.engelmann at geonetric.com
Mon Oct 28 15:22:01 CST 2002


Snipped from an evolt message from years ago (8/6/1999) when I asked this
very question. Thanks Matt Warden.

<snip>

I like functions...

I'm not sure if you can do this with straight SQL, but with ASP/ADO
methods...

FUNCTION Add()
SET Data1.......
Data1.AddNew
Data1("myfield") = TrimNulll(myvalue)
Data1.Update
Add = Data1("ID")
END FUNCTION


TempID = Add()
</snip>

Does that help?

Its also a common question, google it, you should find lots and lots of ways
to do this.






More information about the thelist mailing list