Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

simple query question

I know this is wrong but could you help please?


("select description from parts where PCID like form.id.text")

Craig
0
csindorf
Asked:
csindorf
1 Solution
 
wsh2Commented:
strSQL = _
   "SELECT [Description] " & _
   "  FROM Parts " & _
   " WHERE [PCID] LIKE '" & form.id.text & "'"

Enclose from.id.text in single quotes.. <smile>.
0
 
PaulHewsCommented:
Concatinate to make a string
"Select description from parts where PCID like " & form.id.text
0
 
csindorfAuthor Commented:
Bingo
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now