Apostrophes and Active Record

Apostrophes and Active Record

El Forum
Unregistered

11-19-2007, 11:19 PM

[eluser]Developer13[/eluser]
Sorry - it's not really my birthday... just the first thing that came to mind Smile

Error is 1064. It errors out because it executes the following:

INSERT INTO tablename (fieldname) VALUES ('it's my birthday')

The apostrophe is not being escaped.

Messages In This Thread

Apostrophes and Active Record - by El Forum - 11-19-2007, 10:33 PM

Apostrophes and Active Record - by El Forum - 11-19-2007, 11:05 PM

Apostrophes and Active Record - by El Forum - 11-19-2007, 11:08 PM

Apostrophes and Active Record - by El Forum - 11-19-2007, 11:19 PM

Apostrophes and Active Record - by El Forum - 11-20-2007, 01:47 AM

Apostrophes and Active Record - by El Forum - 11-20-2007, 11:19 AM

Apostrophes and Active Record - by El Forum - 11-20-2007, 12:24 PM

Apostrophes and Active Record - by El Forum - 11-20-2007, 11:56 PM

Apostrophes and Active Record - by El Forum - 02-27-2008, 04:57 PM