Professional Web Applications Themes

problems width select line - ASP

Hi! I am having some problems width a little script i downloaded... I'm not able to figure out what he SELECT line does! What does the identity mean? Is this maby a javascript? :) function GetLastIdentity(ADOConnection) { var rstIdentity = Server.CreateObject("ADODB.Recordset"); rstIdentity.Open("SELECT identity AS IdentityId", ADOConnection); var iIdentity = rstIdentity.EOF == false ? rstIdentity("IdentityId").value : -1; rstIdentity.Close(); return iIdentity; }...

  1. #1

    Default problems width select line

    Hi!

    I am having some problems width a little script i downloaded...

    I'm not able to figure out what he SELECT line does!
    What does the identity mean?
    Is this maby a javascript? :)



    function GetLastIdentity(ADOConnection)
    {
    var rstIdentity = Server.CreateObject("ADODB.Recordset");
    rstIdentity.Open("SELECT identity AS IdentityId", ADOConnection);
    var iIdentity = rstIdentity.EOF == false ? rstIdentity("IdentityId").value : -1;
    rstIdentity.Close();
    return iIdentity;
    }

    Christopher Brandsdal Guest

  2. #2

    Default Re: problems width select line

    An explanation of what IDENTITY is can be found here.
    [url]http://www.aspfaq.com/show.asp?id=2174[/url]

    Ray at work

    "Christopher Brandsdal" <christopherwbc2i.net> wrote in AN HTML message
    news:%23iSrsE7TDHA.3188tk2msftngp13.phx.gbl...
    Hi!

    I am having some problems width a little script i downloaded...

    I'm not able to figure out what he SELECT line does!
    What does the identity mean?
    Is this maby a javascript? :)



    function GetLastIdentity(ADOConnection)
    {
    var rstIdentity = Server.CreateObject("ADODB.Recordset");
    rstIdentity.Open("SELECT identity AS IdentityId", ADOConnection);
    var iIdentity = rstIdentity.EOF == false ? rstIdentity("IdentityId").value
    : -1;
    rstIdentity.Close();
    return iIdentity;
    }


    Ray at Guest

  3. #3

    Default Re: problems width select line

    You guy's are amazing!!!
    Is there anything you DON'T know?

    Best thank's from Norway!;)
    Christopher Brandsdal


    "Aaron Bertrand - MVP" <aaronTRASHaspfaq.com> skrev i melding
    news:uRQQ#I7TDHA.2128TK2MSFTNGP12.phx.gbl...
    > IDENTITY is a SQL Server variable representing the last inserted
    IDENTITY
    > value for this connection's session (that's a SQL Server session, not an
    ASP
    > session).
    >
    > In this case, the GetLastIdentity() function would be of very little use
    > unless it is called directly after a barebones INSERT statement.
    >
    > If you're using SQL Server 2000, SCOPE_IDENTITY() is safer than
    IDENTITY,
    > since the latter is vulnerable to chained inserts (e.g. a trigger on the
    > object table that, in turn, inserts into another table with an IDENTITY
    > column).
    >
    > [url]http://www.aspfaq.com/2174[/url]
    >
    >
    >
    >
    > "Christopher Brandsdal" <christopherwbc2i.net> wrote in message
    > news:#iSrsE7TDHA.3188tk2msftngp13.phx.gbl...
    > Hi!
    >
    > I am having some problems width a little script i downloaded...
    >
    > I'm not able to figure out what he SELECT line does!
    > What does the identity mean?
    > Is this maby a javascript? :)
    >
    >
    >
    > function GetLastIdentity(ADOConnection)
    > {
    > var rstIdentity = Server.CreateObject("ADODB.Recordset");
    > rstIdentity.Open("SELECT identity AS IdentityId", ADOConnection);
    > var iIdentity = rstIdentity.EOF == false ?
    rstIdentity("IdentityId").value
    > : -1;
    > rstIdentity.Close();
    > return iIdentity;
    > }
    >
    >

    Christopher Brandsdal Guest

  4. #4

    Default Re: problems width select line

    There are lots of things I don't know. There is only one thing that Aaron
    doesn't know though - euphemismic conversation. :P

    Ray at work

    "Christopher Brandsdal" <christopherwbc2i.net> wrote in message
    news:OvTe5U7TDHA.2308TK2MSFTNGP12.phx.gbl...
    > You guy's are amazing!!!
    > Is there anything you DON'T know?
    >
    > Best thank's from Norway!;)
    > Christopher Brandsdal
    >
    >
    > "Aaron Bertrand - MVP" <aaronTRASHaspfaq.com> skrev i melding
    > news:uRQQ#I7TDHA.2128TK2MSFTNGP12.phx.gbl...
    > > IDENTITY is a SQL Server variable representing the last inserted
    > IDENTITY
    > > value for this

    Ray at Guest

Similar Threads

  1. variable width line
    By Michael_Vestel@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 5
    Last Post: July 24th, 07:03 AM
  2. IE window width problems
    By Jim Shepherd in forum Web Design
    Replies: 1
    Last Post: February 28th, 10:01 PM
  3. DRKv5 3D Line Chart line width, rendering problems
    By dbarker webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 26th, 04:48 PM
  4. How to draw lines with different line width?
    By Yi Chu in forum PERL Beginners
    Replies: 3
    Last Post: October 3rd, 06:44 PM
  5. Problems width IF....
    By Christopher Brandsdal in forum ASP
    Replies: 6
    Last Post: July 18th, 02:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139