Hello,
I do need to migrate from Access to MySQL on a Windows and shared server
environment.
All existing queries (approx 2000) are failing because they are not lowercased.
Does anyone know of a script that would look into every files for the CFquery
tag and lowercase its content between?
Do you need all of the query lowercased or is there part that you want
to keep uppercased? If you don't care then this regex will do the job:
(cfquery[^]+.+?/cfquery)
\L\1
The first line grabs all cfquery tags and their content and the second
like converts it to lower case. I'd test the regex
As far as I know there is no requirement in MySQL for queries to be
lowercase. I just ran one in all uppercase and it worked fine. There
has to be something else causing this problem.
On Fri, Feb 26, 2010 at 1:57 AM, phil phil arantxa...@gmail.com wrote:
Hello,
I do need to migrate from
Thanks Michael,
Ideally I would like to keep the comments in Uppercase but can do without it.
You can use just about any regex tool to do the job, including writing
a fast tool in CF to do the job.
I am not sure how to use it but will play with it.
(cfquery[^]+.+?/cfquery)
\L\1
As far as I know there is no requirement in MySQL for queries to be
lowercase. I just ran one in all uppercase and it worked fine. There
has to be something else causing this problem.
Are you on Linux?
It is not the case for Windows with my hosting company which is unable to
change system
It cost me to make the below code to work. Should I use a Rereplace expression?
(cfquery[^]+.+?/cfquery)
\L\1
Thanks in advance for your feedbacks
Do you need all of the query lowercased or is there part that you want
to keep uppercased? If you don't care then this regex will do the job:
If I recall right, you have to switch case sensitivity on, are you saying
that is what your host has done?
-Original Message-
From: phil phil [mailto:arantxa...@gmail.com]
Sent: Friday, 26 February 2010 8:58 PM
To: cf-talk
Subject: Need to convert all CFquery tags to lowercase
Actually, the better solution, in my opinion, is a basic HTML page. Unless
you plan on doing something fancy each time a 404 is encountered, there is
no need to create a CF request.
Just set the custom 404 error template within IIS as you have already done
and also set the Missing Template
It seems that the table name is case sensitive but not the columns.
For e.g if I change the name of the table to 'company' from 'Company' then it
cannot find the table because in MYSQL it is referred as 'Company'.
BTW, we are on Linux which I understand is case sensitive.
If I recall
yes. REReplace.
The pattern your trying to match is the first line. It says that we're
looking to capture something that starts with a cfquery tag, has
content, and then ends with a closing cfquery tag.
The replace has a \L before the content returned from the pattern (the
query tag). \L means
Have you tried talking to your hosting provider, and switch case sensitivity
off for your database?
-Original Message-
From: phil phil [mailto:arantxa...@gmail.com]
Sent: Friday, 26 February 2010 11:40 PM
To: cf-talk
Subject: Re: Need to convert all CFquery tags to lowercase
It seems
Lets say for example I have a component called baseapp.cfc sitting in
the web root. I also have an application.cfc in a directory named
/blog. If I want the application.cfc to extend the baseapp.cfc, I have
to use the following syntax:
extends=/.baseapp
You shouldn't need the slash or
Hello Gang,
This one, I have to say, eludes me. There is probably a very easy way
of doing this that I just don't see, but a little help would be awesome.
I have a list of categories from a query where I have parent-child
relationships going on, where my ID can also be associated within
On Fri, Feb 26, 2010 at 2:01 PM, Andrew Scott wrote:
Have you tried talking to your hosting provider, and switch case sensitivity
off for your database?
That is not a per-database setting. Once you have it set to some
setting and have clients on it, a hosting provider is committed and
can not
Anyone know for sure what versions of Axis are in CF8 and CF9? Or how to get
Cf to expose that info? Am having parsing problems with a third party XML
file, and they're curious as to what version is having the problems. They're
putting a line like this after the first line of the file (ie,
But why not do the conversion on the Access side before migrating to
MySQL? In Access you can simply rename the tables to the case you use
in your queries before you convert them.
IIRC there is a setting in my.cnf that will automatically lower case table
names.
To turn it off you have to
Anyone know for sure what versions of Axis are in CF8 and CF9? Or how to get
Cf to expose that info? Am having parsing
problems with a third party XML file, and they're curious as to what version
is having the problems. They're putting a line like this
after the first line of the file
I would do this in a recursive function that takes a depth parameter that will
indent the presented data in some form (margin,table cells,tabs) and return the
formatted output. I have one that is kind of extensive that builds a
hierarchal output of almost any value given to it, kinda like
Summary
We are looking for tools to help us better troubleshoot this issue and/or a
consultant that can help us track it down.
Details
We are using ColdFusion 8 with Windows Server 2003 in a clustered environment
with 4 web servers. Over the last 2 weeks a random web server has begun
Problem is that in my code over the years the table name can be as 'Company' or
'company' so just changing the table names in mysql to lowercase is not enough
but yes a necessary step (can do it from the GUI: PHPadmin)
Then as you wrote changing all occurrences of the table names (1500 cfquery
Hello. Is there a way to return a datatype list from your query along with the
column list? Example:
cfquery name=qryTest datasource=test
SELECT * FROM tblTest;
/cfquery
cfoutput
#qryTest.columnlist#br
#qryTest.datatypes#
/cfoutput
Thanks!
Hello. Is there a way to return a datatype list from
your query along with the column list? Example:
IIRC, there is no direct method. But you could certainly extract that
information using getMetaData()
cfdump var=#getMetaData(qryTest)#
What does the SeeFusion stack traces show the requests are waiting on?
Also, is SQL running on this same box, or is the CPU spike coming from
JRun?
As far as consulting, you can check out Webapper.com-- they make
SeeFusion and have several consulting plans.
~Brad
Original Message
On 2/26/10, phil phil wrote:
Problem is that in my code over the years the table name can be as 'Company'
or 'company' so just changing the table names in mysql to lowercase is not
enough but yes a necessary step (can do it from the GUI: PHPadmin)
Then as you wrote changing all occurrences of
I tried this but as you can see I am REgex illiterate and more...
REReplaceNoCase(TheFile,(cfquery[^]+.+?/cfquery),(cfquery[^]+.+?/cfquery\L\1),all)
It will return the content of the cfquery but I am cannot find a way to
lowercase it properly.
Thanks
yes. REReplace.
The pattern your trying
Right Dave, I got my wires crossed there. I remember reading something a few
years ago about being to replace the xml parser that comes with CF with one of
a couple of others - do you know which parse is the one the comes with CF9 (or
Cf8, I doubt that it has changed)?
thanks
-reed
We have not been able to catch the SeeFusion stack traces while the problem is
happening, we will do that. SQL is not running on the same box, JRUN is
spiking.
Good suggestion, we will contact the SeeFusion folks to see if they can help.
Lincoln
What does the SeeFusion stack traces show
Set up your Active Monitoring Rules in SeeFusion to E-mail you when
There are long-running requests, or when the number of active requests
reaches a threshold. The E-mails will have a stack trace in them for
you to look at even if you were at lunch when the server started bogging
down.
~Brad
You can usually get that info from the database's system tables, depending
on your RDBMS. (In the following queries, 'typename' will give you the
datatype.)
MSSQL:
SELECT syscolumns.colid,
syscolumns.name,
syscolumns.colorder AS sortorder,
Hi Reed,
I believe ColdFusion uses the JAXP (Java API For XML Parsing) which
uses Apache Xerces on Java 1.5, 1.6 as the default DOM parser. Java
1.4 uses Apache Crimson as the default DOM parser. I have found the
current versions of Java 1.6 use Xerces 2.6.2
You can run this code to find out
I just setup my hosts file to direct me:
1.) C:\Windows\System32\drivers\etc\hosts\ (In Vista. Not sure about win7)
write the following: 127.0.0.1/devprojectA/ [tab] dev.projectA.com
Also, if you are going to push to a windows server with IIS, I suggest you use
the IIS web server instead of
Thanks for all the info Pete. I'm running CF9, so that's Java 1.6, and it uses
Xerces 2.9.1, which seems to be the latest. Interesting that you were able to
parse the xml using java 1.5 - maybe I'll give this a try on a CF8 box. I'll
probably end up doing the stripping of that line, but it's
Yeah, what Charlie said.
It is very easy to set up local sub domains with Apache.
VirtualHost *
ServerName site1.localhost
DocumentRoot C:/xampp/htdocs/site1
/VirtualHost
VirtualHost *
ServerName site2.localhost
DocumentRoot C:/xampp/htdocs/site2
/VirtualHost
I find that it cuts down on a lot
I do something similar but use the host headers in IIS. I think they call it
host name in the latest IIS.
So my Hosts files looks like:
127.0.0.1 foo
127.0.0.1 moo
Then the host header in IIS is foo and moo for each site.
So you type in http://foo/ the hosts file routes it to IIS and IIS
On Thu, Feb 25, 2010 at 6:32 AM, Kevin Pepperman
...
We need it to be raw text, and we have specific filtering for Meta
descriptions, page titles etc..(eg. no in meta description tags so the
XHTML will validate) --so our CMS limits what can be entered with a
combination of jQuery and server
In CF8 there is cfdbinfo This function below will return a query object the
following fields (see below).
http://www.cfquickdocs.com/cf8/?getDoc=cfdbinfo#cfdbinfo
If you don't have CF 8 you will have to query the metadata based on the SQL
dialect for that particular database. You can look at the
I just setup my hosts file to direct me:
1.) C:\Windows\System32\drivers\etc\hosts\ (In Vista. Not sure about win7)
write the following: 127.0.0.1/devprojectA/ [tab] dev.projectA.com
Also, if you are going to push to a windows server with IIS, I suggest you
use the IIS web server instead
On Thu, Feb 25, 2010 at 9:05 PM, Jeff U j...@uspokerdirectory.com wrote:
I'm hoping I can create all links RELATIVE and that way they work
both locally as well as on production with no code changes what-so-ever.
By far, the easiest solution is to make your links relative to the
current
38 matches
Mail list logo