Welcome to Geeklog Saturday, May 21 2022 @ 09:37 am EDT

Geeklog Forums

Funny


Status: offline

jackknyc

Forum User
Regular Poster
Registered: 08/12/03
Posts: 88
I cant add anything to my calendar that says "objets d'art"
I get an SQL error unless I take it out. WASUP!
Jack
 Quote

Status: offline

exaurdon

Forum User
Regular Poster
Registered: 13/08/03
Posts: 107
Well, that isn't a terribly lot fo information to go off. Posting the SQL error might be helpful....

Off the top of my head I would say that the problem is that you are trying to put a quote mark in a box that is not being processed properly. This could be a possible bug in Geeklog (Developers? Any comment?)

To test if this is the problem, try putting a backslash in front of the quote mark (apostraphe) as follows:

PHP Formatted Code
"objets d'art"
 


Exaurdon~

 Quote

Status: offline

jkottler

Forum User
Junior
Registered: 13/02/04
Posts: 19
Uh...I had some trouble with that when using an old version of the forum plugin, and managed to escape the apostrophe the old fashioned way--by doubling it, like this:
PHP Formatted Code
a single tic won''t insert
 

As a database developer, I have found it best to write a SQLQuote() method and make sure any varchar2 fields (I work mostly on Oracle) have the values run through that before updating or inserting.
 Quote

All times are EDT. The time is now 09:37 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content