Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:06:36
|
| Ashraf writes "I used to use Oracle and Java but now I am switching to SQL server 2000 and Visual basic, I made a login form in Visual basic and what to submit the query : recordset.open "select * from Login where username=text1.Text and password=text2.Text", connection The problem I found is that it is not allowed to compare the username (which is a feild in the database) to a value from a textbox in that way.I just want you to write me a sample of a select statement which can solve me this problem.Thanks alot, Regards, Ashraf" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-02 : 01:20:29
|
| If you are looking for comparying your form values with your databaseThis should help yourecordset.open "select * from Login where username='" & text1.Text & "' and password='"& text2.Text& "'", connection ----------------------------Anything which Doesn't Kills you Makes you Stronger |
 |
|
|
|
|
|
Visual basic connection