Set objconn= createobject("ADODB.Connection")
Set objrecord=createobject("ADODB.recordset")
strcommand="select comand...."
objconn.open "DSN"
If objconn.state= 1 Then
msgbox "connection successful"
End If
objRecord.open strcommand,objconn
While not objRecord.EOF
v_count =objrecord("column")
objrecord.movenext
Wend
First get the values in array or in dictionary and then pass the array value
or dictionary values in Webedit to search
or pass the value in the while clause itself.
Regards,
Prasad
On Thu, Dec 31, 2009 at 10:04 AM, Dara Khatana <[email protected]> wrote:
> from DB table column
> thanks,
> dara
>
>
> On Wed, Dec 30, 2009 at 10:39 AM, ERP Solutions
> <[email protected]>wrote:
>
>> you mean from DB table column?
>>
>> Or from QTP data table?
>>
>>
>> On Tue, Dec 29, 2009 at 5:09 PM, Dara Khatana <[email protected]>
>> wrote:
>> > hi,
>> > i want to retrieve column value one by one and use that value into
>> search
>> > webedit field. how it possible.?
>> >
>> > connection with database (mysql) properly established.
>> >
>> >
>> >
>> > --
>> > Regards,
>> > Dara
>> >
>> > --
>> > 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%[email protected]>
>> > 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%[email protected]>
>> For more options, visit this group at
>> http://groups.google.com/group/MercuryQTP?hl=en
>>
>
>
>
> --
> Regards,
> Dara Gurjar
> Software Engineer
> Net4Nuts Limited (CMM level 3 Company)
> Mob. No. +91-9714042928
> www.net4nuts.com,www.meongo.com
>
> --
> 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%[email protected]>
> 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]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
