×

Discussion Board

Results 1 to 5 of 5

Thread: SQL query Issue

  1. #1
    Registered User
    Join Date
    Mar 2006
    Location
    India
    Posts
    503

    SQL query Issue

    Query 1:
    query.Format(_L("Select Image , Sequence,Impressions, Tags,Default, Action, NoShown from %S where FromDateTime <= %ld and ToDateTime >= %ld "), &KTableDynamic,time.Int64(),time.Int64());
    Result:This works


    Query 2:
    query.Format(_L("Select Image , Sequence,Impressions, Tags,Default, Action, NoShown from %S where Order By Sequence"), &KTableDynamic);
    Result:This works


    Query3: = Query 1 + Query 2
    query.Format(_L("Select Image , Sequence,Impressions, Tags,Default, Action, NoShown from %S where FromDateTime <= %ld and ToDateTime >= %ld Order By Sequence"), &KTableDynamic,time.Int64(),time.Int64());
    Result:It does not work .
    Last edited by kamaljaiswal; 2008-06-25 at 09:32.
    Regards
    Kamal :)
    ------------------
    You never expect what expects you.

  2. #2
    Super Contributor
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    9,968

    Re: SQL query Issue

    What is the error you are getting ...
    What is the size of "query"

  3. #3
    Registered User
    Join Date
    Mar 2006
    Location
    India
    Posts
    503

    Re: SQL query Issue

    Not getting any error ..but not getting the proper result ..Size..
    no problem in TBuf size ..ie query buffer size
    Regards
    Kamal :)
    ------------------
    You never expect what expects you.

  4. #4
    Super Contributor
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    9,968

    Re: SQL query Issue

    looks like your 2nd SQL statement it wrong .

  5. #5
    Registered User
    Join Date
    Aug 2003
    Location
    Oulu, Finland
    Posts
    1,122

    Re: SQL query Issue

    Note that for formatting TInt64s, you need %Ld, not %ld.

    Lauri

Similar Threads

  1. Sql Query Doubt
    By lpradeepa in forum Symbian
    Replies: 7
    Last Post: 2010-07-31, 09:34
  2. How to compare date Sql Query in Symbian
    By kamaljaiswal in forum Symbian
    Replies: 2
    Last Post: 2009-08-31, 00:57
  3. Problem with SQL query
    By dsiorpaes in forum Symbian
    Replies: 3
    Last Post: 2006-12-08, 12:00
  4. performace for SQL query..
    By promethus.tw in forum Symbian
    Replies: 0
    Last Post: 2005-07-08, 07:24
  5. some descritor trick is required in sql query?
    By siemensc55 in forum Symbian
    Replies: 2
    Last Post: 2004-08-16, 10: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
  •  
×