Answer Posted / gayatri

I have coded this, can anyone plz rectify and send


Dim con, rs, username1
Set con=Createobject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
con.connectionString="Drivers={SQLServer};
DSN=<dsn_name>; OPTION=0; PWD=konnects; PORT=<port name>;
SERVER=<server name>; UID=konnects"
con.open
rs.open SQL ,conn
SQL= "select user_name from t_member"
Set rs=con.Execute(SQL)
DbTable("DbTable").Check CheckPoint("DbTable")
on error resume next
while rs.EOF
Do Until username1=user_name
username1=rtrim(rs.fields("user_name"))
msgbox username1
If username1=username Then
Msgbox " User name already exist try another"
Username=inputbox("Username")
msgbox User_name
else
rs.MoveNext
end if
loop
wend
rs.close
con.close
Set rs = Nothing
Set con = Nothing

Browser("").Page("page name").WebEdit("UserName").Set
UserName

What are the special sub-types in vbscript?

1037

---

By default in vbscript the arguments passed to functions and subroutines are by reference or by value?

1070

---

Mention what is select case statement?

937

---

Can any one provide code for Mid(string,start[,length]). I have been asked to write code for Mid(). i.e We need to define our own function say MyMid() which should behave same like built-in Mid function

2423

---

What is the difference between vbscript and vba?

1109

---

what is the use of QCUtil? explain with one example?

7036

---

Differentiate javascript and vbscript?

1013

---

Hello Friends , I am the new joinner of this website. I am working with Sapient ,Gurgoan I would like to ask few qurries regarding the QTP Tool of (Testing) Currently working on QTP Tool . I would like to no learn VB Script can u name some Books which i get in market. And a small issue in QTP I had 2 users right i have to login and send the document from this user to second user right. when i am send this doc some contendId number generates right. now i am loging into second user and i have to search for that contentId right i found it now i dont want to accept the document so i had an opption of check out ok i have to click on check out my QTP Code is like this Browser(" ").Page(" ").WebTable(" ").ChildItem (3,5,"Image",0).click Browser(" ").Page(" ").Link("ChecK Out").Click i new this code is perfectly right but when i am run the script i have to click on that particular contentId and click on check out but now the Problem is started the error is the document has been already checked out remeber every time my content id changes means it is the new contentId which is not been used atleast once Please help me out in this issue i am in big trouble

2445

---

A folder is there inside no of textfiles are avilable. How do count the textfiles. Normally folder means we are using subfolder methods but textfiles is not working for subfolder methods and how do get file name also.

1921

---

how to write codings in QTP using vb script. please help me. i am new to QTP. it is easy or very much tough. please tell me

14156

---

Which data type/types are supported by vbscript language and what are their specialties?

1019

---

Which command is used for writing text on a page?

985

---

Which operator can be used to check if two numbers are equal or not in vbscript?

1147

---

Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?

949

---

Write a vbscript procedure that converts feet to inches. Hint: there are 12 inches in a foot?

1018

---