String problem. simple 4 u but

**Radhesham** · Sep 6th, 2003, 12:18 PM

Dear all

strSQL = "associate_name = '" & Text2.Text & "'"
rst.find strSQL

gives an error bcoz Text2.text contain

JOHN'S CLINIC

It contains an apostrophy.
How to deal with this.
urgent pls
thanx

**Merri** · Sep 6th, 2003, 02:00 PM

I guess you can add \ before ' so you don't get that error. I'm not sure if it's that character though... I'm no expert with SQL, but this is a little thing I remember from somewhere...

The string would be then JOHN\'S CLINIC

**MartinLiss** · Sep 6th, 2003, 02:03 PM

I don't know if this works but try

strSQL = "associate_name = '[" & Text2.Text & "]'"

**Radhesham** · Sep 6th, 2003, 02:14 PM

Martin / Merri
both does not work.
some one urgent pls.

**Radhesham** · Sep 6th, 2003, 02:16 PM

And the value in Text2.text is from the Table.
So do not know how many times apostrophy is there and which place.
Though this can be found out, it will be troublsome.
Any simpler solution for this?

**Merri** · Sep 6th, 2003, 02:18 PM

Ok, try to convert it with %27 (which is the character code for ' - I don't know if SQL supports quoted printable coding though... (this is used in the HTML-urls)

**MartinLiss** · Sep 6th, 2003, 02:23 PM

Dim strName As String

strName = Replace(Text2.Text, "'", "''")
strSQL = "associate_name = '" & strName & "'"

**Radhesham** · Sep 6th, 2003, 02:25 PM

Its resolved

strFind= Replace(Text2.text, " ' ", " ' ' " )
strSQL = "associate_name = '" & strFind & "'"
rst.find strSQL

**Radhesham** · Sep 6th, 2003, 02:26 PM

ok ok marty
Thankx

Thread: String problem. simple 4 u but

Thread Tools

Display

String problem. simple 4 u but

Posting Permissions