jsking
Posts: 1
|
Posted: 05/26/2006, 4:50 PM |
|
I only just recently installed CCS 3.0 and already have hit a major issue (at least in my book).
Every once in a while I am finding some code calling on a variable or file with a upper case letter in it, but when the variable is set or the file created, it is all lower case. On windows, this does not matter. But Linux/Unix server this is does matter since these OSs consider $Uid and $uid to be two seperate variables or file names. Each file that is generated, I have to go through and proof read for this simple thing and manually make corrections. I am dreading when I add more and CCS regenerates the code all over again and wipes out my earlier corrections.
Would like to see an option for CCS to go through the prepared code and convert all upper case letters to lower case. This would be a big time saver for those of us who host on linux webservers.
|
|
|
peterr
Posts: 5971
|
Posted: 05/26/2006, 4:56 PM |
|
Wehnever you find any such case I'd recommend reporting it to support. Probably most CCS users use Linux, so this should not be happening.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Benjamin Krajmalnik
|
Posted: 05/30/2006, 9:19 AM |
|
Peter,
I think he is tryin to get a utility to address "programer" issues, not
generated code.
In the meantime, there is a free package called "Useful File Utilities"
which has this capability.
|
|
|
WKempees
|
Posted: 05/30/2006, 9:29 AM |
|
jsking,
Without declaring war:
I develop on WinXp Platform, using CCS since way-back-when.
My target platforms are Win IIS, SuSe Linux and FreeBsd Linux.
Your problem sounds totally new to me!
Please let us know if we probably misunderstood your post.
The only issue with CCS that remotely resembles this issue, was the Beta
supplying the Style sheet directory and names wrong.
Walter
|
|
|
Benjamin Krajmalnik
|
Posted: 05/30/2006, 12:05 PM |
|
FreeBSD Linux!!!!??????
Shame on you, Walter :)
Linux is a Unix workalike. FreeBSD is the real enchilada <vbg>.
But, yes, he may be being bit by OS case sensitivity in table names, or
possibly by language case sensitivity.
Let's take MySQL as a database backend for example.
On a Windows MySQL (at least 3.x and 4.x) a table name of "mytable" and of
"MyTable" are the same. MySQL opens the table using fle system calls, and
under Windows it is one and the same. However, under a *nix MySQL,
"mytable" and "MyTable" are two disticnct files.
MS SQL Server is case insensitive on table and field names, and by default
on field level operations.
For example, LIKE, by default, performs a case insensitive evaluation, and
ABC = abc when comparing field values.
PostgreSQL does not. I have modified my base classes to use ILIKE insted of
LIKE when doing a "contains" search, for example, since PostgreSQL is case
sensitive.
The problem which is being described is one of an end user not using proper
coding practices.
I always use lower case definitions in all of my databases, and on languages
which are case sensitive (such as PHP). ASP is case insensitive, so it is
not that critical.
Regards,
Benjamin
|
|
|
WKempees
|
Posted: 05/30/2006, 12:31 PM |
|
The second Linux obviously a copy/paste thing. (<ebg>)
The rest you post, I agree upon.
Table names and all SQL related always lowercase, here.
Hate Camel pagenames so lowercase as well.
The variable naming bit ( $UserID ) mentioned doesn't exist as a real
problem, I think, only in the builders hands.
We have learned from experience and avoid camel and uppers.
Also jsking, have you set the target platform in Project/Settings right?
Walter
"Benjamin Krajmalnik" <kraj@illumen.com> schreef in bericht
news:e5i52k$nhu$1@news.codecharge.com...
> FreeBSD Linux!!!!??????
> Shame on you, Walter :)
>
> Linux is a Unix workalike. FreeBSD is the real enchilada <vbg>.
> But, yes, he may be being bit by OS case sensitivity in table names, or
> possibly by language case sensitivity.
>
> Let's take MySQL as a database backend for example.
> On a Windows MySQL (at least 3.x and 4.x) a table name of "mytable" and
> of "MyTable" are the same. MySQL opens the table using fle system calls,
> and under Windows it is one and the same. However, under a *nix MySQL,
> "mytable" and "MyTable" are two disticnct files.
>
> MS SQL Server is case insensitive on table and field names, and by default
> on field level operations.
> For example, LIKE, by default, performs a case insensitive evaluation, and
> ABC = abc when comparing field values.
>
> PostgreSQL does not. I have modified my base classes to use ILIKE insted
> of LIKE when doing a "contains" search, for example, since PostgreSQL is
> case sensitive.
>
> The problem which is being described is one of an end user not using
> proper coding practices.
> I always use lower case definitions in all of my databases, and on
> languages which are case sensitive (such as PHP). ASP is case
> insensitive, so it is not that critical.
>
> Regards,
>
> Benjamin
>
|
|
|
WKempees
|
Posted: 05/30/2006, 12:34 PM |
|
> Also jsking, have you set the target platform in Project/Settings right?
Project Settings -> Server/Script->Output Format :unix/linux <-> Windows
|
|
|
guest
|
Posted: 05/31/2006, 2:00 AM |
|
Quote Benjamin Krajmalnik:
Let's take MySQL as a database backend for example.
On a Windows MySQL (at least 3.x and 4.x) a table name of "mytable" and of
"MyTable" are the same. MySQL opens the table using fle system calls, and
under Windows it is one and the same. However, under a *nix MySQL,
"mytable" and "MyTable" are two disticnct files.
Don't forget this behaviour depends on the setting of lower_case_table_names system variable.
|
|
|
guest
|
Posted: 05/31/2006, 2:01 AM |
|
Quote guest:
Don't forget this behaviour depends on the setting of lower_case_table_names system variable.
See http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html
|
|
|
|