[thelist] Converting VBScript from Access to SQL

Dan Romanchik dan at danromanchik.com
Wed Nov 20 12:11:01 CST 2002


Easy to install and customize, and on all the sites I've installed it, the
users find it easy to use.

Dan Romanchik - Web Developer
dan at danromanchik.com, 734-930-6564

----- Original Message -----
From: "Wade Armstrong" <wade_lists at runstrong.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, November 20, 2002 12:48 PM
Subject: Re: [thelist] Converting VBScript from Access to SQL

> on 11/19/02 8:25 PM, Jeremy Weiss at jweiss03 at comcast.net wrote:
> > I've changed the connection string to an SQL DNS one and now it's adding
> > an id, but it's the wrong id.
> As Eric suggested, make sure that you tables are set up as you expect,
> particularly that your id is, in fact, of a numeric datatype (I've seen
> upsizing change numeric fields into varchars), set to be IDENTITY(1,1) (or
> whatever you want your starting number and steps to be), and set as a
> primary key. IF all those things are true, THEN you should ALWAYS get the
> right result by SELECTing @@IDENTITY.
> Did you get the expected result using the recordset method you'd earlier
> used with Access? If not, try.
> Wade
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list