Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Jul 2002
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select Statement Syntax

    Can this be written into a select statement?


    Conn.Execute("SELECT * FROM products where catalogID="
    &Request.QueryString("intCategory"))
    If you don't do it this year, you will be one year older when you do. "Warren Miller"

  • #2
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts

    Re: Select Statement Syntax

    Code:
    Conn.Execute("SELECT * FROM 'products' WHERE catalogID='" & Request.QueryString("intCategory") & "'" )
    Try that.

  • #3
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,032
    Thanks
    0
    Thanked 248 Times in 245 Posts
    table products should have no quotes...

    Conn.Execute("SELECT * FROM products WHERE catalogID='" & Request.QueryString("intCategory") & "'" )

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Except for the space at the end that looks EXACTLY like my code... cool
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

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