SQL query Issue

[kamaljaiswal]

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 .

[skumar_rao]

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

[kamaljaiswal]

Not getting any error ..but not getting the proper result ..Size..
no problem in TBuf size ..ie query buffer size

[skumar_rao]

looks like your 2nd SQL statement it wrong .

[laa-laa]

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

Lauri