solve this problem urgently


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: solve this problem urgently

  1. #1
    manish jaiswal Guest

    solve this problem urgently




    freinds i am tring to execute following query

    can any one tell me how can i correct it?
    as it is not executing .

    i explain it--

    actually i am trying to retrieve information of persons which meet a parameter
    given by the user .
    the information is distributed among differenr tables.

    one thing more the qualification table has multiple records for a person.

    so please help me solve this problem.


    one thing more i have made use of session variables quite extensively.
    is that harmful??

    SQL = "SELECT DISTINCT A.EMAILID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,B.QUALIFICATION
    "
    SQL = SQL & " FROM PERSONAL_INFO A,QUALIFICATION_TABLE B"
    SQL = SQL & " WHERE A.EMAILID = B.EMAILID " 'AND B.EMAILID IN "
    SQL = SQL & " ( SELECT EMAILID FROM CANDIDATE_CURRENT_EMPLOYMENT "
    SQL = SQL & " WHERE CURRENT_LEVEL = " & chr(39) & session("rel") & chr(39)
    & ")"



  2. #2
    js Guest

    Re: solve this problem urgently


    SQL = SQL & " WHERE A.EMAILID = B.EMAILID " 'AND B.EMAILID IN "

    should be

    SQL = SQL & " WHERE A.EMAILID = B.EMAILID " AND B.EMAILID IN "


    If that doesnt work i suggest doing this after your SQL string is complete

    Response.write SQL
    response.end

    view it in the browser, copy the sql and then debug using your databases
    query tools..ex query analyzer for MSSQL

    "manish jaiswal" <m_jaiswal1@yahoo.com> wrote:
    >
    >
    >
    >freinds i am tring to execute following query
    >
    >can any one tell me how can i correct it?
    >as it is not executing .
    >
    >i explain it--
    >
    >actually i am trying to retrieve information of persons which meet a parameter
    >given by the user .
    >the information is distributed among differenr tables.
    >
    >one thing more the qualification table has multiple records for a person.
    >
    >so please help me solve this problem.
    >
    >
    >one thing more i have made use of session variables quite extensively.
    >is that harmful??
    >
    > SQL = "SELECT DISTINCT A.EMAILID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,B.QUALIFICATION
    >"
    > SQL = SQL & " FROM PERSONAL_INFO A,QUALIFICATION_TABLE B"
    > SQL = SQL & " WHERE A.EMAILID = B.EMAILID " 'AND B.EMAILID IN "
    >SQL = SQL & " ( SELECT EMAILID FROM CANDIDATE_CURRENT_EMPLOYMENT "
    > SQL = SQL & " WHERE CURRENT_LEVEL = " & chr(39) & session("rel") & chr(39)
    >& ")"
    >
    >



  3. #3
    Kris Eiben Guest

    Re: solve this problem urgently

    Try response.write SQL to make sure you're executing the statement you
    think you are.

    I've heard that "extensive" use of session variables can cause
    performance degredation. If you start to see performance problems once
    you get multiple concurrent users, you might want to consider minimizing
    session variables to just the ID fields you need to get the rest of the
    data out of the database. Read these for more pitfalls regarding
    session variables:
    http://www.aspfaq.com/show.asp?id=2053
    http://www.aspfaq.com/show.asp?id=2157

    "manish jaiswal" <m_jaiswal1@yahoo.com> wrote in message
    news:3eb8f443$1@tnews.web.devx.com...
    >
    >
    >
    > freinds i am tring to execute following query
    >
    > can any one tell me how can i correct it?
    > as it is not executing .
    >
    > i explain it--
    >
    > actually i am trying to retrieve information of persons which meet a

    parameter
    > given by the user .
    > the information is distributed among differenr tables.
    >
    > one thing more the qualification table has multiple records for a

    person.
    >
    > so please help me solve this problem.
    >
    >
    > one thing more i have made use of session variables quite extensively.
    > is that harmful??
    >
    > SQL = "SELECT DISTINCT

    A.EMAILID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,B.QUALIFICATION
    > "
    > SQL = SQL & " FROM PERSONAL_INFO A,QUALIFICATION_TABLE B"
    > SQL = SQL & " WHERE A.EMAILID = B.EMAILID " 'AND B.EMAILID IN "
    > SQL = SQL & " ( SELECT EMAILID FROM CANDIDATE_CURRENT_EMPLOYMENT "
    > SQL = SQL & " WHERE CURRENT_LEVEL = " & chr(39) & session("rel") &

    chr(39)
    > & ")"
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center