Escaping DataTable select queries/filters

1/15/2008 3:49:55 PM #

Thanks for this tip which also works in VBS..

Was trying to get :

SELECT samAccountName, givenName, sn, AdsPath FROM 'LDAP:// DC=xx,DC=x,DC=com' WHERE samAccountName = 'xyz'

and if the samAccountName had an apostrophe in, it was failing with mismatched apostrophes.

Adding in

if instr(ac,"'")<>0 Then
  ac=replace(ac,"'","''")
end if

Has fixed it.

Stuart Bennett |

1/15/2009 3:49:07 PM #

Great tip, was pulling my hair out but you've just saved me several hours manual work

Thanks
Dave

Dave |