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

Server Issues...

Thread Tools
 
Search this Thread
 
Old Jun 11, 2008 | 07:20 AM
  #1  
woo545's Avatar
Thread Starter
|
Senior Member
Joined: Jun 2007
Posts: 2,680
Likes: 1
From: PA
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.
 
Reply
Old Jun 11, 2008 | 08:02 AM
  #2  
Hayden06F4i's Avatar
Senior Member
Joined: Jun 2007
Posts: 2,503
Likes: 0
From: Maine
Default RE: Server Issues...

ahhhhhh. i see
 
Reply
Old Jun 11, 2008 | 10:39 AM
  #3  
woot's Avatar
Senior Member
Joined: Jul 2006
Posts: 1,127
Likes: 1
From: NS, Canada
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...
 
Reply
Old Jun 11, 2008 | 10:48 AM
  #4  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

SELECT
 
Reply
Old Jun 11, 2008 | 10:49 AM
  #5  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

*
 
Reply
Old Jun 11, 2008 | 10:49 AM
  #6  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

FROM
 
Reply
Old Jun 11, 2008 | 10:49 AM
  #7  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

unknown.unknown
 
Reply
Old Jun 11, 2008 | 10:50 AM
  #8  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

WHERE
 
Reply
Old Jun 11, 2008 | 10:50 AM
  #9  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

asp = 'pos'
 
Reply
Old Jun 11, 2008 | 10:50 AM
  #10  
rrasco's Avatar
Senior Member
Joined: Mar 2006
Posts: 5,844
Likes: 1
From: South Texas
Default RE: Server Issues...

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



All times are GMT -5. The time now is 01:54 PM.