Welcome to Geeklog, Anonymous Wednesday, June 19 2024 @ 11:03 am EDT

Geeklog Forums


Status: offline


Forum User
Regular Poster
Registered: 12/08/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!

Status: offline


Forum User
Regular Poster
Registered: 08/13/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:

Text Formatted Code
"objets d'art"



Status: offline


Forum User
Registered: 02/13/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:
Text 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.

All times are EDT. The time is now 11:03 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