Web Wiz Support and Community Forums : Case senstive column names https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 12:03:35 +0000 Fri, 15 Jul 2005 22:56:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15852 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Case senstive column names : First of all if you edit a php...]]> https://forums.webwiz.net/case-senstive-column-names_topic15852_post87036.html#87036 Author: michael
Subject: 15852
Posted: 15 July 2005 at 10:56pm

First of all if you edit a php file you are posting at the wrong forum Wink. If your columns are case sensitive, you sql server database most likely has been installed with the wrong collation. Have your host setup a database with the collation of Lating case-insensitive.]]> Fri, 15 Jul 2005 22:56:54 +0000 https://forums.webwiz.net/case-senstive-column-names_topic15852_post87036.html#87036 <![CDATA[Case senstive column names : Hi, Ive been trying out this...]]> https://forums.webwiz.net/case-senstive-column-names_topic15852_post87025.html#87025 Author: BobGandalf
Subject: 15852
Posted: 15 July 2005 at 2:47pm

Hi,
   Ive been trying out this software, and have installed the SQL server version, ive done the set-up, and most things appear to work, but whenever i try and change Forum Permissions, or do things like Edit the administrator password, the .asp pages return an error. New posts and registrations happen fine, so the connection to the Database must be ok..
 
The Error i get is i.e on forum_group_permissions.asp, line 117, Invalid Column name Cat_ORDER ... Looking in the database, the field is Cat_Order , with lowercases. If i edit the PHP file, it works fine, so i assume this is the nature of the error.
 
I would go through and manually change all the instances to be in the right case, but theres a lot of errors, not only regarding this column, but ones in other tables as well,,,
 
Could there be something wrong with the setup of my DB or Table on the SQL server?
 
 
Thanks,
 
David
]]> Fri, 15 Jul 2005 14:47:57 +0000 https://forums.webwiz.net/case-senstive-column-names_topic15852_post87025.html#87025