Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Proper syntax for find method in Asp ???

Status
Not open for further replies.
1712

1712

Technical User
Nov 8, 2000
66
NL
Does anybody know the right syntax for the find method of ado recordset and sql 2000.

mine is
rs.find "emailaddress = " & request.form("select1")

note: the request.form("select1") is the option value from a listbox.

 
Sort by date Sort by votes

1712,

strSQL = "SELECT * FROM yourtable WHERE columname = '" & emailaddress & "'"

fengshui1998
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Alexvb6
  • Locked
  • Question
Deprecation of VBScript + Classic ASP: How to Ask Microsoft to cancel their planned craziness
Replies
0
Views
357
Alexvb6
Alexvb6
bdwilcox
  • Locked
  • Question
HTA fails with Syntax Error when working VBScript inserted
Replies
2
Views
345
bdwilcox
bdwilcox
EdScripts
  • Locked
  • Question
Using a Variable in the Run Method - I would sure like to be able to do this !
Replies
0
Views
176
EdScripts
EdScripts
bdwilcox
  • Locked
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
995
SoftwareRT
SoftwareRT
lunter
  • Locked
  • Question
How to create vbArray+vbByte (8209) in *.vbs stript
Replies
0
Views
225
lunter
lunter

Part and Inventory Search

Sponsor

Back
Top