[Microsoft][ODBC Microsoft Access Driver] Syntax e

Results 1 to 2 of 2

Thread: [Microsoft][ODBC Microsoft Access Driver] Syntax e

  1. #1
    Join Date
    Dec 1969

    Default [Microsoft][ODBC Microsoft Access Driver] Syntax e

    I&#039ve had this before and I&#039m sure most other have. Whats the most common reason for this occuring?<BR>The following is my query strong that it dislikes.<BR><BR>query="select * from [Software] where [Details] like = " & "&#039" & Usertext & "&#039"

  2. #2
    Join Date
    Dec 1969

    Default RE: [Microsoft][ODBC Microsoft Access Driver] Synt

    I&#039m assuming here that UserText is a variable that contains some sort of text (UserText = "whatever details you&#039re trying to match here"). Am I correct in that assumption?<BR><BR>The only time I&#039ve run into problems with the query string is when the Data Type on the database not meshing with how you&#039re laying the query out. Am I making sense? An example from my own work is:<BR><BR>"select * from tblName WHERE DataID = &#039" & DataID & "&#039"<BR><BR>where DataID is actually a number and not a text field and I have to correct the query to read:<BR><BR>"selct * from tblName WHERE DataID = " & DataID<BR><BR>I hope this helps more than it confuses!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts