Suppose i have a productDescription column in my products table, and i want to search
for a string.
Witch one do you advise?
1) Query of query
- do a master query (select * from products) and cache it.
- do a query of query (select * from masterquery where productDescription like
Hi. I'm using query of query to query a master query (lol, to many query)
!--- query of query ---
cfquery name=qGetProductCatListing dbtype=query
SELECT
Very nice comments
- Original Message -
From: Benoit Hediard
To: CF-Talk
Sent: Thursday, February 27, 2003 7:43 AM
Subject: RE: OT - Fusebox for Flash?
Good question...
Many people are struggling with that right now...
I don't think that there isn't any structured
I'm doing a report page, with all the sales grouped by month.
Select SUM(OrderTotal) as Total, MONTH(OrderDate) as M
from orders
GROUP BY Month(OrderDate)
That returns the month and the total as follow:
01(january) 15
02(feb) 40
03(mar) 50
05(may) 20
and so.
Suppose in
--
From: Leonardo Crespo - Cftop.COM [EMAIL PROTECTED]
Suppose in april, i didnt had sales, i would like the query list it too, but with 0
as total. Since i got no April in the MONTH(OrderDate), cos i have no sales in april,
this month is not listed.
I
Hi, i used to have a COM object (Tarifa.dll) that connects to a .MDB database to
calculate shipping charges for my e-commerce. Both files were provided by the a the
govern shipping company (i have no idea how to say that in english).
Everything works fine with cf5, but when i migrate to cfmx,
THE / 1000)
/cfcase
/cfswitch
You gotta love Macromedia.
BTW, am i the only brazilian in this list? =)
Cheers
- Original Message -
From: Leonardo Crespo - Cftop.COM
To: CF-Talk
Sent: Wednesday, February 26, 2003 12:22 PM
Subject: Urgent problem with COM
, Leonardo Crespo - Cftop.COM
wrote:
I'm just complaining here, but i think it is a bug, since if your
using CFMX FOR J2EE and map you context root as /, you CAN'T make
cfform work.
I will let them know about it.
I was able to get it to work with the above configuration
What is the equivalent of the CDBL() function (asp) in coldfusion?
I have a COM object that takes a weight as a parameter. In one computer, it interprets
6.65 30 and 6,65 30 and on the other occurs the exact oposite.
Thxx
What is the equivalent of the CDBL() function (asp) in coldfusion?
I have a COM object that takes a weight as a parameter. In one computer, it interprets
6.65 30 and 6,65 30 and on the other occurs the exact oposite.
Thx
Leonardo
Macromedia®
What the web can be.(tm)
Announcing Macromedia DevNet Subscriptions
Maximize your power with our new premium software subscription for Macromedia
developers
Find out more: http://www.macromedia.com/go/devnetsubs/
-Original Message-
From: Leonardo Crespo - Cftop.COM
to do with the fact
that it is a PRO version and not an Enterprise version.
Martin.
Leonardo Crespo - Cftop.COM [EMAIL PROTECTED] wrote:
Man i couldn't possibly imagine that migrating my websites to
cfmx would require those minor changes. This is about
.
Leonardo Crespo - Cftop.COM [EMAIL PROTECTED] wrote:
Man i couldn't possibly imagine that migrating my websites to
cfmx would require those minor changes. This is about the 10 th
time i need help =/
The problem is now with cfform. I'm
way round. We
have
been working on a fix for this one with my hosting co. for months, I am
not
sure that it has anything to do with the fact that it is a PRO version
and
not an Enterprise version.
Martin.
Leonardo Crespo - Cftop.COM
: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, February 25, 2003 6:45 AM
Subject: Re: Take a look at the BUG
Leonardo Crespo - Cftop.COM wrote:
http://webforums.macromedia.com/coldfusion/mm_login.cfm?FTVAR_REDIRECTURLFRM=messagepost%2Ecfm%3Fpostaction%3Dpost%26catid%3D274postaction=Yes
Is anyone using MySQL Connector/J instead of the drivers shipped with CFMX? Any
performance gains?
Leonardo Crespo
ICQ: 198810
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Leonardo Crespo - Cftop.COM [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 10:37 PM
Subject: Take a look at the BUG
http://webforums.macromedia.com/coldfusion
I'm evaluating cfmx on j2ee. I use mysql as database and all my date are stored in
mysql default format, witch is -mm-dd hh:mm:ss. I'm using the
Portugues(Brazilian) locale.
As you know, MYSQL stores DateTime objects in the format -MM-DD HH:MM:SS.
When i try to run the code:
cfquery
...
#LsDateFormat(DateVar, 'dd/mm/')#
Instead of
#LsDateFormat(DateVar, 'dd/mm/')#
HTH
Mikey
=
http://www.phonebin.com
From Phone to Web in minutes
-Original Message-
From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED
!
Drop the quotes...
#LsDateFormat(DateVar, 'dd/mm/')#
Instead of
#LsDateFormat(DateVar, 'dd/mm/')#
HTH
Mikey
=
http://www.phonebin.com
From Phone to Web in minutes
-Original Message-
From: Leonardo Crespo
...
#LsDateFormat(DateVar, 'dd/mm/')#
Instead of
#LsDateFormat(DateVar, 'dd/mm/')#
HTH
Mikey
=
http://www.phonebin.com
From Phone to Web in minutes
-Original Message-
From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED
and definitly not nice =/. Maybe i should
post a bug @ MM page.
- Original Message -
From: Leonardo Crespo - Cftop.COM
To: CF-Talk
Sent: Monday, February 24, 2003 3:31 PM
Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!
I got it working
:59 )
- Original Message -
From: Leonardo Crespo - Cftop.COM [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:41 PM
Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
INVALID!
The mega wierd part is that if i run
Yeah, you're right =/
- Original Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Monday, February 24, 2003 4:14 PM
Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!
Leonardo Crespo - Cftop.COM wrote:
That's wierd and definitly
That's a quick question, What is the JDBC type of MYSQL driver included in CFMX to
j2ee?
I'm asking that because i'm wondering if i should use the MYSQL Connector/J witch is a
TYPE 4 JDBC driver instead if the one included with CFMX to J2EE.
MYSQL says that it is 50-100% faster than previous
If you have NULL or values for CourseName in your DB for your Employees that hasnt
build the course you can use that in your where clause (where CourseName IS NULL OR
CourseName = .
But i think you have a Employees table, with all the Employees. You can make a query
to select all employees
Makes no diference for me , using mysql and cfmx on win2k.
- Original Message -
From: Everett, Al
To: CF-Talk
Sent: Monday, February 24, 2003 5:12 PM
Subject: RE: SQL: How do I a get list of everybody that doesn't meet a cer tain
criteria
Shouldn't those be single quotes
Man i couldn't possibly imagine that migrating my websites to cfmx would require those
minor changes. This is about the 10 th time i need help =/
The problem is now with cfform. I'm running cfmx on j2ee and win2k. I've mapped my
cfmx context root to /, so i can acess my pages as
in there.
-Original Message-
From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 February 2003 11:15 a.m.
To: CF-Talk
Subject: BIG CFFORM problem :-(
Man i couldn't possibly imagine that migrating my websites to
cfmx would require those
-
From: Leonardo Crespo - Cftop.COM
To: CF-Talk
Sent: Monday, February 24, 2003 7:14 PM
Subject: BIG CFFORM problem :-(
Man i couldn't possibly imagine that migrating my websites to cfmx would require
those minor changes. This is about the 10 th time i need help =/
The problem is now
Mm says in the Jrun sp1a release notes:
Delete jrun_root/servers/lib/jrun_axis.jar or move it to a location outside of JRun.
This JAR file addressed issues that are fixed in JRun 4 SP1 and will cause server
startup problems if allowed to remain in servers/lib.
But i cant delete it, it is
: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 11:07 PM
To: CF-Talk
Subject: deleting jrun_axis.jar
Mm says in the Jrun sp1a release notes:
Delete jrun_root/servers/lib/jrun_axis.jar or move it to a location outside
of JRun. This JAR file
I haven't found a solution for the cfform problem but i found the cause. The CFMX RDS
Application context root is set to /CFIDE, with means any thing like
http://localhost/CFIDE. will be redirected to the RDS context root, that's why the
scripts (cfform validation) dont work.
that's why,
How can MM build such a program and forget to look at the basic things miss
allaire...
I give up on CFMX j2ee just because of that cfform problem (witch DOES NOT have a
solution, if you want to keep your context root as /). Let's try CFMX Std...
. How can they
dont notice that bug??
I'm very disapointed... :'-(
Leonardo Crespo
ICQ: 198810
[EMAIL PROTECTED]
- Original Message -
From: Leonardo Crespo - Cftop.COM
To: CF-Talk
Sent: Tuesday, February 25, 2003 3:27 AM
Subject: Solution to CFFORM problem? RDS Context root
35 matches
Mail list logo