Hi MZR Please check your query by running aginst DB directly and see if you see the records you are expecting.
Once you are sure that your query works, then you can ask for more help. Please read Mrinal's comment. Savy On Dec 5, 9:48 am, Mrinal <[email protected]> wrote: > hi mzr, > > Instead of giving rownum could u plz give something other in where clause of > the query and let us know the result. > > > > > > On Sat, Dec 5, 2009 at 10:00 PM, <[email protected]> wrote: > > I am giving query in one line and I don't see and records when I run the > > query. > > Note that if I run only strQuery = "Select * FROM > > loanmdtst1.clpac...@gtas08pcs, my script works fine. > > > On Fri, Dec 4, 2009 at 11:15 PM, savy <[email protected]> wrote: > > >> Hi MZR > > >> Are you giving the following query in one line or two lines? > > >> ' strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs WHERE rownum > >> < > >> 11" > > >> Also, what is the error message that you are getting? (Check whether > >> your query is correct first) > > >> Let me know. > > >> If you are giving it in two lines, then you have to give continuation > >> character. > > >> A vague answer is: > > >> ' strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs "&vbcrlf&_ > > >> "WHERE rownum <11" > > >> Savy. > > >> On Dec 4, 8:12 am, [email protected] wrote: > >> > Hi, > >> > One more issue I am facing right now. > >> > I am trying to read a certain # or rows from DB but the script does not > >> > work. If I try to read everything, script works fine. > >> > Am I missing something? > >> > See script below. Any suggestion will be appreciated. > >> > Thank you. > >> > MZR > > >> > Set objDB = CreateObject("ADODB.Connection") > >> > objDB.ConnectionString = "DSN" > >> > objDB.Open "DRIVER={Microsoft ODBC for > >> > Oracle};UID=XXXXXX;PWD=######;SERVER=tday1.world;" > >> > ' strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs WHERE rownum > >> < > >> > 11" ' // This query does not execute > >> > strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs" ' // This > >> works > >> > fine > >> > Set objResults = objDB.Execute(strQuery) > > >> -- > >> You received this message because you are subscribed to the Google > >> "QTP - HP Quick Test Professional - Automated Software Testing" > >> group. > >> To post to this group, send email to [email protected] > >> To unsubscribe from this group, send email to > >> [email protected]<mercuryqtp%2bunsubscr...@googlegroups.com> > >> For more options, visit this group at > >>http://groups.google.com/group/MercuryQTP?hl=en > > > -- > > You received this message because you are subscribed to the Google > > "QTP - HP Quick Test Professional - Automated Software Testing" > > group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected]<mercuryqtp%2bunsubscr...@googlegroups.com> > > For more options, visit this group at > >http://groups.google.com/group/MercuryQTP?hl=en > > -- > regd, > mrinal- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
