C
Chris Joyce
I'm sure this is a real simple one ,
whats the best trick when your select conditions have a ' in the value
"WHERE (People.FullName = 'Example O'Toole' )" ?
Chris
Example
strSQLPeople = "SELECT People.FullName "
strSQLPeople = strSQLPeople & "FROM People "
strSQLPeople = strSQLPeople & "WHERE (People.FullName = '" &
Me.ComboFullName.Value & "' ) "
strSQLPeople = strSQLPeople & "GROUP BY People.FullName "
Set rstPeople = New ADODB.Recordset
rstPeople.CursorType = adOpenStatic
rstPeople.CursorLocation = adUseClient
Debug.Print strSQLPeople
' strSQLPeople example
' SELECT People.FullName FROM People WHERE (People.FullName = 'Example
O'Toole' ) GROUP BY People.FullName
rstPeople.Open strSQLPeople , CurrentProject.Connection, adOpenKeyset,
adLockOptimistic, adCmdText
whats the best trick when your select conditions have a ' in the value
"WHERE (People.FullName = 'Example O'Toole' )" ?
Chris
Example
strSQLPeople = "SELECT People.FullName "
strSQLPeople = strSQLPeople & "FROM People "
strSQLPeople = strSQLPeople & "WHERE (People.FullName = '" &
Me.ComboFullName.Value & "' ) "
strSQLPeople = strSQLPeople & "GROUP BY People.FullName "
Set rstPeople = New ADODB.Recordset
rstPeople.CursorType = adOpenStatic
rstPeople.CursorLocation = adUseClient
Debug.Print strSQLPeople
' strSQLPeople example
' SELECT People.FullName FROM People WHERE (People.FullName = 'Example
O'Toole' ) GROUP BY People.FullName
rstPeople.Open strSQLPeople , CurrentProject.Connection, adOpenKeyset,
adLockOptimistic, adCmdText