Professional Web Applications Themes

Session variable in SELECT statement? - ASP Database

What am I doing wrong here? This works: SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' But when I try to add a session value in the query I get invalid syntax SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID = " & session("Dealer_ID") & "" Ive tried tons of variables but cant seem to get it right. TIA!...

  1. #1

    Default Session variable in SELECT statement?

    What am I doing wrong here?

    This works:
    SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1'

    But when I try to add a session value in the query I get invalid syntax

    SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID = "
    & session("Dealer_ID") & ""

    Ive tried tons of variables but cant seem to get it right.

    TIA!



    targa Guest

  2. #2

    Default Re: Session variable in SELECT statement?

    a) What is the *exact* error?

    b) Number 1 SQL troubleshooting tip:

    <%
    strSQL = _
    "SELECT Count(ID) AS MyCount " & _
    "FROM mytable " & _
    "WHERE Status = '1' " & _
    "AND StatID = " & session("Dealer_ID")

    Response.Write(strSQL)
    Response.End
    %>

    so you can see what you're actually sending to the database.

    Cheers
    Ken



    "targa" <targa1alltel.net> wrote in message
    news:%23I0dkUafDHA.1736TK2MSFTNGP12.phx.gbl...
    : What am I doing wrong here?
    :
    : This works:
    : SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1'
    :
    : But when I try to add a session value in the query I get invalid syntax
    :
    : SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID =
    "
    : & session("Dealer_ID") & ""
    :
    : Ive tried tons of variables but cant seem to get it right.
    :
    : TIA!
    :
    :
    :


    Ken Schaefer Guest

  3. #3

    Default Re: Session variable in SELECT statement?

    Perhaps change this:
    SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID
    = "
    & session("Dealer_ID") & ""

    To be more like this instead:
    SELECT Count(ID) AS MyCount FROM mytable WHERE (Status = '1') AND
    (StatID = '"
    & session("Dealer_ID") & "')"

    Best regards,
    J. Paul Schmidt, Freelance ASP Web Developer
    [url]http://www.Bullschmidt.com[/url]
    ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Bullschmidt Guest

Similar Threads

  1. SP with Select statement
    By Gerald in forum ASP Database
    Replies: 3
    Last Post: November 27th, 03:38 PM
  2. variable select statement
    By Karzy in forum PHP Development
    Replies: 2
    Last Post: October 4th, 01:49 PM
  3. help with SELECT statement
    By Chris Hohmann in forum ASP
    Replies: 2
    Last Post: August 19th, 05:10 PM
  4. SELECT statement
    By Simon in forum Microsoft SQL / MS SQL Server
    Replies: 23
    Last Post: August 18th, 01:12 PM
  5. Getting column name in Select statement
    By Jane in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 8th, 04:17 PM

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