Off Topic A place for you CBR junkies to boldly go off topic. Almost anything goes.

Server Issues...

  #1  
Old 06-11-2008, 07:20 AM
woo545's Avatar
Senior Member
Thread Starter
Join Date: Jun 2007
Location: PA
Posts: 2,680
Likes: 0
Received 1 Like on 1 Post
Default Server Issues...

Many of you might have noticed that there are a few issues making posts. The problem is that some shoddy programming was applied that passes on our text incorrectly to the SQL Server backend.

Until it is fixed, the only way to allow you to make posts, is to avoid words that are reserved by SQL queries. Of course this is impossible for those not familiar with the language...so see the links below.

S elect
F rom
W here
W ith

This is cumbersome, but as you see, I added additional spacing to prevent the words from causing a problem.

You can try lookup other words here: http://developer.mimer.com/validator...rved-words.tml
or test them here: http://www.petefreitag.com/tools/sql...words_checker/

another alternative would be utilizing a "highlighter" programming that highlights SQLs reserved words, when editing posts. "ConText" is one such program. Keep in mind, apostrophes will throw things off too. http://www.contexteditor.org/

Guess this is a gud reeson to mispell words. Go ahead and try making posts wit those words lists above. You can't do it.
 
  #2  
Old 06-11-2008, 08:02 AM
Hayden06F4i's Avatar
Senior Member
Join Date: Jun 2007
Location: Maine
Posts: 2,503
Likes: 0
Received 0 Likes on 0 Posts
Default RE: Server Issues...

ahhhhhh. i see
 
  #3  
Old 06-11-2008, 10:39 AM
woot's Avatar
Senior Member
Join Date: Jul 2006
Location: NS, Canada
Posts: 1,127
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

that makes sense as it's also turning single quotes into double quotes...

if you need db help that is part of what I do...
 
  #4  
Old 06-11-2008, 10:48 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

SELECT
 
  #5  
Old 06-11-2008, 10:49 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

*
 
  #6  
Old 06-11-2008, 10:49 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

FROM
 
  #7  
Old 06-11-2008, 10:49 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

unknown.unknown
 
  #8  
Old 06-11-2008, 10:50 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

WHERE
 
  #9  
Old 06-11-2008, 10:50 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

asp = 'pos'
 
  #10  
Old 06-11-2008, 10:50 AM
rrasco's Avatar
Senior Member
Join Date: Mar 2006
Location: South Texas
Posts: 5,844
Likes: 0
Received 1 Like on 1 Post
Default RE: Server Issues...

interesting, they work in parts, but not as a whole
 

Thread Tools
Search this Thread
Quick Reply: Server Issues...



All times are GMT -5. The time now is 06:51 PM.