Well, that would explain it then. Obviously, we have a bug in our CFC
generator code :)
Scott
On Mon, Jan 11, 2010 at 4:21 PM, Leigh wrote:
>
> There is no cfsqltype named "cf_sql_datetime". So CF may be using the default
> instead cf_sql_char. Anyway, you are correct in selecting cf_sql_tim
> Let's be clear here- a DBMS will cache ALL execution
> plans. The real question really is whether or not the cached
> plan will ever be used or
> if it will sit around and gather dust until it is evicted
> from cache.
> (Or worse yet, fill the cache up so other plans are
> evicted)
You are
>
> You could have left it running there using the built in web server, and
> linked
> it into your Apache install via. mod_proxy rather than mod_jrun, not that
> it
> matters now.
Thanks for the tip Tom. If I have to move it I will try that.
On Mon, Jan 11, 2010 at 12:09 PM, wrote:
>
> Tom,
> My understanding is the query plan can be cached when only the VALUES change.
Let's be clear here- a DBMS will cache ALL execution plans. The real
question really is whether or not the cached plan will ever be used or
if it will sit around and gather dust until it is evicted from cache.
(Or
G Allen R Souliere wrote:
>> You should be using PLSQL statements. Use CASE statements and
>> proper PLSQL and see what happens then.
>>
>
> Could you provide an example of how you would go about writing these
> PLSQL statements, then?
>
> Isn't there still a problem when attempting to pass an
> I found the problem (or at least a workaround). I changed
> the cfsqltype to be a timestamp instead of a datetime and that
> did the trick. Seems a little odd, but at this
> point, whatever works.
There is no cfsqltype named "cf_sql_datetime". So CF may be using the default
instead cf_sql_c
>
> You should be using PLSQL statements. Use CASE statements and
> proper PLSQL and see what happens then.
>
Could you provide an example of how you would go about writing these
PLSQL statements, then?
Isn't there still a problem when attempting to pass an empty string
via the tags where t
> On the other hand I think that:
>
> may cache properly.
>
> Does anyone have any insight into whether or not this is
> true?
I cannot speak for Oracle. But I believe that to be true for some other
databases like MS SQL and MySQL. My understanding is the query plan can be
cached when on
I found the problem (or at least a workaround). I changed the
cfsqltype to be a timestamp instead of a datetime and that did the
trick. Seems a little odd, but at this point, whatever works.
Scott
On Mon, Jan 11, 2010 at 3:29 PM, Scott Brady wrote:
> I'm not seeing that in the docs for cfcomp
G Allen R Souliere wrote:
> Oracle cannot cache the query if the insert statement itself changes
> whenever a parameter is avoided due to being null.
>
> On the other hand I think that:
>
>
> INSERT INTO MYTABLE
> (
> MYCOLUMN
> ,MYACOLUMN
> ,MYBCOLUMN
> ,MYCCOLUMN
> ,MYDCOLUMN
> )
> VALUES
>
On this topic, my understanding has been that Oracle cannot cache the
query when the parameters change.
So, when you do
INSERT INTO MYTABLE
(
MYCOLUMN
,MYACOLUMN
,MYBCOLUMN
,MYCCOLUMN
,MYDCOLUMN
)
VALUES
(
,
,
,
,]
)
Oracle cannot cache the query if the insert statement itself changes
wh
I'm not seeing that in the docs for cfcomponent anywhere. I take that
back. It's not in my local cfdocs. Awesome.
But, that didn't solve the problem. I'm still getting the same error.
On Mon, Jan 11, 2010 at 3:19 PM, David Mineer wrote:
>
> You have accessors="true" on your component right?
>
> The performance hit I meant was on the cf-app and then the
> inability of the
> app server (or would it be the db server?) to cache that
> query.
Oh, I see what you mean now. Yes, I that is my understanding as well. ie There
is a better chance of your database caching the query plan when the s
and so it was. Thanks =). Thanks to everyone else that chimed in.
W
On Mon, Jan 11, 2010 at 5:19 PM, Jason Fisher wrote:
>
> Looks like you're missing your comma before the queryparam:
>
>,#form.product_id#
> , cfsqltype="cf_sql_char"
> null="#YesNoFormat(NOT LEN(TRIM(form.p
Looks like you're missing your comma before the queryparam:
,#form.product_id#
,
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
You have accessors="true" on your component right?
On Mon, Jan 11, 2010 at 3:05 PM, Scott Brady wrote:
>
> I'm using the new "bean" type of component in CF9 for the first time
> and I'm running into a frustrating problem when trying to insert into
> the database (SQL Server 2005). The bean is s
The performance hit I meant was on the cf-app and then the inability of the
app server (or would it be the db server?) to cache that query.
also cfqueryparam doesn't seem to be working in this case.
here is my code
insert into case_products
(
case_id
,created
I'm using the new "bean" type of component in CF9 for the first time
and I'm running into a frustrating problem when trying to insert into
the database (SQL Server 2005). The bean is set up with the following
code:
> I can get around this by using a len(trim(form.fieldname)>. Is there
> a better way to handle this? Isn't there a
> performance hit for this sort of
> quasi-dymanic sql statement?
No, because the sql string is all constructed in CF. Then the final string is
sent (all at once) to your databa
Thanks.
On Mon, Jan 11, 2010 at 4:43 PM, Qing Xia wrote:
>
> I didn't test it against an Oracle DB, but the following works against a
> SQL
> Server DB. Be sure to adjust the cfsqltype according to the data type of
> your form field.
>
> null="#YesNoFormat(NOT LEN(TRIM(form.myField)))#">
>
>
I didn't test it against an Oracle DB, but the following works against a SQL
Server DB. Be sure to adjust the cfsqltype according to the data type of
your form field.
Hope this helps!
On Mon, Jan 11, 2010 at 4:21 PM, Won Lee wrote:
>
> I'm not sure what to do a search on this subject so ple
I'm not sure what to do a search on this subject so please excuse me if this
question was already asked.
I have a form. It has an optional field. When I go to insert a new record
into the Oracle DB, the db will throw an error if the formfield is empty.
I can get around this by using a . Is the
Tom, I've always loved your signature-- does it not count now that it is
2010?
:)
~Brad
Original Message
Subject: Re: CF5 download
From: Tom Chiverton
Date: Mon, January 11, 2010 8:31 am
To: cf-talk
--
Helping to synergistically transition cutting-edge exceptional
six-gen
On Thursday 07 Jan 2010, Kevin Pepperman wrote:
> So I did a test install in a Ubuntu VM, only to discover CF5 only runs on
> older versions Apache (LTE Apache 2.0.43-xx ) AFAIK
You could have left it running there using the built in web server, and linked
it into your Apache install via. mod_pr
24 matches
Mail list logo
