lol what? what do you mean hijacking...oh i'm sorry, i did the reply from my email.
On Tue, Nov 18, 2008 at 7:27 AM, KeidrickP <[EMAIL PROTECTED]> wrote: > > are you hijacking someone else's post? > > On Tue, Nov 18, 2008 at 9:22 AM, Jon Liu <[EMAIL PROTECTED]> wrote: > > > > Right, primary key values are unique. So what I am saying is I want to > auto > > generate the Id like a counter. Example, when I insert an entry, I'd > like > > it to generate EntryId=1, then on the next insertion, EntryId=2, then > > EntryId=3 so on and so forth... > > > > > > On Tue, Nov 18, 2008 at 7:19 AM, KeidrickP <[EMAIL PROTECTED]> wrote: > >> > >> I don't understand your question. > >> A primary key should be a unique identifier for a record in your table. > >> What info is your weblog app tracking? > >> > >> On Tue, Nov 18, 2008 at 9:12 AM, Jon Liu <[EMAIL PROTECTED]> wrote: > >> > i want to generate an alphnumeric value for the primary key "EntryId" > >> > for a > >> > webblog app I'm building. If not "BigJ1", how would you go about just > >> > generating an incremental numeric Id for EntryId? > >> > > >> > On Tue, Nov 18, 2008 at 7:00 AM, KeidrickP <[EMAIL PROTECTED]> > wrote: > >> >> > >> >> I agree with Stephen. What exactly are you trying to accomplish? > >> >> > >> >> On Tue, Nov 18, 2008 at 7:18 AM, Stephen Russell < > [EMAIL PROTECTED]> > >> >> wrote: > >> >> > > >> >> > Please don't do this. An ID should be not only unique, but have NO > >> >> > VALUE. > >> >> > You are imparting value as "BigJ" and that is very wrong. > Appending > >> >> > the > >> >> > # > >> >> > 1,2,3 does not make it correct. > >> >> > > >> >> > > >> >> > ......................... > >> >> > Stephen Russell - > >> >> > Senior Visual Studio Developer, DBA > >> >> > > >> >> > Memphis, TN > >> >> > 901.246-0159 > >> >> > > >> >> > > >> >> > > >> >> > -----Original Message----- > >> >> > From: [email protected] > >> >> > [mailto:[EMAIL PROTECTED] On Behalf Of BigJ > >> >> > Sent: Monday, November 17, 2008 10:51 PM > >> >> > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > >> >> > Web > >> >> > Services,.NET Remoting > >> >> > Subject: [DotNetDevelopment] Auto-generating a primary key > >> >> > > >> >> > > >> >> > I see a formula section, but not sure how to go about it. I > >> >> > basically > >> >> > have an primary key called "EntryId" and I want to consist of > UserId > >> >> > +unique counter, so if UserId="BigJ", and it's my first entry, then > >> >> > EntryId="BigJ1" and the next entry would be BigJ2 etc....any > insight > >> >> > as to how to accomplish this? I know there is a formula field and I > >> >> > am > >> >> > looking into it, but any insight or simple examples are apreciated, > >> >> > as > >> >> > I left my SQL book at home lol...Thanks... > >> >> > > >> >> > No virus found in this incoming message. > >> >> > Checked by AVG - http://www.avg.com > >> >> > Version: 8.0.175 / Virus Database: 270.9.4/1790 - Release Date: > >> >> > 11/17/2008 > >> >> > 8:48 AM > >> >> > > >> >> > > >> >> > > >> > > >> > > > > > >
