Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    76

    Question Unanswered: what does this mean

    Hi
    I am unable to understand what this means.

    where ID = '"& request.querystring("oID") & "'

    * manifestexp is a view.
    * ID is a column in the veiw.

    select count(distinct hazmatclass) as hzcount
    from manifestexp
    where orderkey in
    (
    select orderkey
    from manifestexp
    where ID = '"& request.querystring("oID") & "'
    )
    group by hazmatclass;


    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    71

    Re: what does this mean

    Originally posted by Naweed
    Hi
    I am unable to understand what this means.

    where ID = '"& request.querystring("oID") & "'

    * manifestexp is a view.
    * ID is a column in the veiw.

    select count(distinct hazmatclass) as hzcount
    from manifestexp
    where orderkey in
    (
    select orderkey
    from manifestexp
    where ID = '"& request.querystring("oID") & "'
    )
    group by hazmatclass;



    Thanks

    It it a user input asking for the value of ID. Once you supply it with a valid value for the ID, it would return the output of teh query, try running in sql plus.

  3. #3
    Join Date
    Oct 2003
    Posts
    706

    Re: what does this mean

    Originally posted by reemagupta
    It is a user input asking for the value of ID. Once you supply it with a valid value for the ID, it would return the output of teh query, try running in sql plus.
    Also note... I rather don't-like this kind of approach because if the user types in a non-existent or invalid input, he often winds up looking at a blank report or a blank screen. (Plus the input-prompt he's had to respond to is often pretty cryptic.) This technique might be fine for a "data center internal-use-only" query but it's extremely obtuse when used in an end-user application.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  4. #4
    Join Date
    Nov 2003
    Posts
    76

    Lightbulb

    Thank you. I am greatful for your responce.
    Well, this query is going to be used internally within an asp page. The values which will be invoked are going to be generated and stored in a view and the the feild for this particular value will not be empty.
    What could be a better way to do this. I am a beginner and would appreciate hints from you.
    Thanks

Posting Permissions

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