Alexis,
Did you ever get an answer to this problem? Also, do you have any experience
with minisoft on 4.5 - or with troubleshooting minisoft drivers to CF Server?
-Mark
([EMAIL PROTECTED])
ok here is my problem..
I had an application that worked perfectly on CF 5.0 using the Minisoft
ODBC
Jim,
Do you have any CF code using that java4less vision jar?
-mark
-Original Message-
From: Jim Rising [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 6:54 AM
To: CF-Talk
Subject: Re: OCR Solutions
one quick note here... if you're using fax... efaxdeveloper.com has the
that the agreements are setup
with the contract i'm on, i can't give out any of the efaxdeveloper code i'm
working on... but i could possibly work on the java4less stuff for you and
build a CFC wrapper for it that you could use it to generate barcodes and
read them. shouldn't be too hard.
-jim
On 12/6/07, Mark
These aren't really part of CF 5 per se. Rather they are a part of the ODBC
settings in windows. You can cause DSN's to show up in the datasources by
using the ODBC control panel - and visa versa.
Look in the registry for ODBC under local machine (not sure of the exact
location).
Doh! Beat me to it ... Dang it.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 4:22 PM
To: CF-Talk
Subject: RE: Stupid CF 5 Question
Okay, I've combed the Internet and the Macromedia site, and my
Google-Fu has failed me.
All I want
Jake... And I appreciate it :)
-Original Message-
From: Jake Churchill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 5:46 PM
To: CF-Talk
Subject: RE: OT: Eclipse speed issue
I wouldn't mind making that switch but we are predominantly Windows here so
I try not to be the odd
Rob,
I have a couple of tips on my blog about PDFs and optimization. Recall that
CF is doing HTTP get type requests for the resources it needs - so when
you include images it has to create HTTP request to retrieve each of them.
One work around is to use the file:// type syntax to map to the
Very wrong :)
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Friday, December 14, 2007 9:23 AM
To: CF-Talk
Subject: RE: To AIR or not to AIR?
From what I understand, AIR really doesn't work with ColdFusion yet..
Am I wrong?
sas
--
Scott Stewart
ColdFusion
Scott,
Air has it's own language for development - scripting very like
actionscript. It doesn't parse CF tags. It doesn parse JSP tags or PHP tags
either. It's not designed as a many language-single runtime engine (ala
..NET). However, just like Flex, CF is a great back end for AIR to use in
I too loved the rice.. Not many hosts give you rice.
-Original Message-
From: Eric Roberts [mailto:[EMAIL PROTECTED]
Sent: Friday, December 14, 2007 2:59 PM
To: CF-Talk
Subject: Re: VPS hosting, anyone?
I have been using AHP for about 6 months or o when my host's server bit it
and
Beware of doing it this way... You will need cftransaction or some other
way of ensuring that the ID is unique. Consider the situation where 2
inserts from 2 different people are happening nearly simultaneously. The
second request for the max(ID) could occur before the first is inserted
-mark
Rick,
Autonumber doesn't re-number existing ids (does it??) ... Although it does
mean that the numbers are not tightly sequential (there will be gaps).
-mark
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 20, 2007 8:47 AM
To: CF-Talk
Subject:
Dominic,
Not really... Databases do a lot of things concurrently. The statement below
should be safe, but locking, and other issues on a very busy database
could cause deadlocks if 2 simultaneous processes are trying to update the
same row.
Having said that, I suspect that the identity or
Lori,
So they are trying to solve customer service problems through automation...
I get that. However, I think going to far down the road of the on site
custom printing will generate just as many customer service issues (if not
more). I think I agree with most of the folks here that you should
I can't find this in the docs and my recollection is YES that it does require a
restart - but can anyone out there confirm that moving from registry to
database for clients vars requires a cf restart?
~|
Message:
I'm moving FROM the registry... sorry if I mistyped. I'm inside a clients
network, rdped into a server so I can send mail through my own crappy web mail
interface.
Original Message ---
I have to ask the question, why would you want to move to using the
registry?
My
Rob,
Frankly I think you must using some other product than we are... We love
Farcry. We have almost 30 sites using it so far and more on the way.
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
There is a username and password attribute for scheduled tasks. It requires
that you allow the plain text option I believe.
Barring that you can set up a site that mirrors your web site but does allow
anon access and have it respond only to 127.0.0.1. That would allow your
tasks to run but not
it prevents passwords from being passed cleartext.
Steve
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, December 31, 2007 2:25 PM
To: CF-Talk
Subject: RE: Keeping Anon access off turning on Scheduled Tasks
There is a username and password attribute
Ben,
Search House of fusion for a recent thread on query optimization as well...
There was an interesting issue with a stored proc taking too long and it
turned out to be permissions on the database (made me go hm.)
-mark
-Original Message-
From: Ben Mueller [mailto:[EMAIL
If what you are trying to do is eliminate trailing spaces why not just do:
Update contacts set contact = rtrim(ltrim(contact))
-Original Message-
From: morchella [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 9:03 AM
To: CF-Talk
Subject: sql question: contains space' '
Claude,
Hmmm Ok this is interesting to me. The argument below seems semantic
So I think I am missing something. I'd like to get my head around this.
Visually DPI represents dots per inch - it's a measure of density in
printing. The higher the DPI the better the quality of printing -
inch), or linescreen. That's usually a better measure of print quality
than is DPI.
Bit depth simply refers to the total number of colors available to an image.
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 11:06 AM
To: CF-Talk
Subject: RE
Claude,
Thanks for an enlightening foray into the world of graphics. I especially
like the part about a virtual object having no size..fascinating. It made me
think to myself... If a virtual tree falls in the woods... (ha).
In any case, excellent stuff. I feel edicated enough to be able to say
Chad,
Well you could do something like this:
!--- get list of coloumns ---
cfquery name=blankquery datasource=myDsn
SELECT * FROM mytable
WHERE id = -99
/cfquery
cfquery name=update datasource=myDSN
update myTable
cfloop list=#blankquery.columnlist#
I agree with Dave... Perhaps you need a different sort of join (a left join
perhaps) ... That would return blank column values if no row existed for the
join.
-Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, January 04, 2008 10:48 AM
To: CF-Talk
Don,
Go into the security center - click on the windows firewall and turn it
off (as a test). If your connects work after that you will need to work at
unblocking them before you get the FW turned back on again.
-Mark
-Original Message-
From: Don L [mailto:[EMAIL PROTECTED]
Sent:
Try
Get_leadsTotal[totalLeads][currentrow]
-Mark
-Original Message-
From: Dr. Who [mailto:[EMAIL PROTECTED]
Sent: Friday, January 04, 2008 1:13 PM
To: CF-Talk
Subject: Re: stuck with a loop count
i tried
cfloop query=get_leads
cfloop query=get_leadsTotal
Just having a backup generator helps if the power outage is quite local...
But if the power outage is a large grid it doesn't necessarily do the trick.
Every downstream device must also be protected. If you are using a tier one
provider that is usually the case (cross your fingers). Alos power
I have a feeling you will have trouble solving this problem off the
shelf. Why not modify Ray's application to use client vars and a database?
-Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 07, 2008 8:58 AM
To: CF-Talk
Subject: Advice
Claude,
I'm with you there I use homesite about 50% of the time... Can't seem to
get away from it. Especially since I have all my custom help files and edits
and vtms brought forward for the last 7 or 8 years :)
-mark
-Original Message-
From: Claude Schneegans [mailto:[EMAIL
Now that is a useful list... Nice going jerry.
-Original Message-
From: Jerry Guido [mailto:[EMAIL PROTECTED]
Sent: Monday, January 07, 2008 12:43 PM
To: CF-Talk
Subject: RE: Adobe ColdFusion IDE survey
My wish list for a CF IDE.
Everything that CFEclipse and the Adobe's plug-ins has
I'm afraid I'd have to say that is not the case I would say that it is a
significant majority.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Monday, January 07, 2008 1:48 PM
To: CF-Talk
Subject: Re: Adobe ColdFusion IDE survey
On Jan 7, 2008 11:42 AM,
have co-workers or usergroup
members or others who can weigh in with their views, views we might not hear
as often, that would be invaluable.
--- Ben
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, January 07, 2008 3:24 PM
To: CF-Talk
Subject: RE: Adobe
Thanks Charlie...
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Monday, January 07, 2008 3:46 PM
To: CF-Talk
Subject: Re: Adobe ColdFusion IDE survey
On Jan 7, 2008 1:36 PM, Mark Kruger [EMAIL PROTECTED] wrote:
Ben,
Sorry... Can you post the link
Claude,
Very succinct... I agree with that.
-mark
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 10:38 AM
To: CF-Talk
Subject: Re: Adobe ColdFusion IDE survey
View (HTML) code should be separate to Control and Model code (CFML).
CF-Talkers,
Rather than bore the list with a long email I have written a blog post with
some of my thoughts on this topic. Remember that I am old and set in my ways
so take it for what it's worth :)
http://www.coldfusionmuse.com/index.cfm/2008/1/9/Coldfusion.IDE.Debate
-Mark
Mark A. Kruger,
Jochem,
So... If I ran the DBCC operation on the SQL server to flush the execution
plan cache immediatley after a shema change - I would not have to fiddle
with the queries or restarts or other techniques to draw it over to CF? If
so - that's a great tip.
-Mark
-Original Message-
From:
I'm not sure if this will work for you but I'll mention it. We recently did
a project that handled faxes with 2D bar codes. We used a java library from
Java4Less to create a 2D data matrix code on a fax cover sheet. The idea
was that user would fax documents into our fax number (on an Asteisk
Jochem,
I tried the DBCC FREEPROCCACHE routine after making a schema change - but it
does not prevent the 'invalid data type error that sometimes occurs. Any
other useful routines you can think of?
-mark
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday
The COUNT( ) function will never return NULL. So isNull(count(*)) will
never trigger. Count(*) will always return an int - so using isNULL and
count together is not possible - plus you are mixing data types if you are
trying to return a 0.1 to a function call designed to return an int.
I tested both DBCC DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS as well and
it does not solve the cached schema problem.
Here's my approach:
I created a table called tmpTable with the columns username, and email
address, date added and a tmp_id (int). I then ran the following query
Dana,
Not pretty...and often not possible. Consider the many many sites on shared
hosts. How do they handle this situation?
-mark
-Original Message-
From: Dana Kowalski [mailto:[EMAIL PROTECTED]
Sent: Friday, January 18, 2008 8:24 AM
To: CF-Talk
Subject: Re: cfqueryparam, cached
Robert,
You mean something like:
td style='mso-number-format:\@;' .../td
That's an excellent tip.
-Original Message-
From: FROEHLING, ROBERT (ATTSI) [mailto:[EMAIL PROTECTED]
Sent: Friday, January 18, 2008 4:39 PM
To: CF-Talk
Subject: RE: Output to Excel Problem
Les,
If you're
readers still have the possibility of it breaking. Especially if
you're forwarding the article to someone that reads email in only
plain-text.
On Jan 18, 2008 1:49 PM, Mark Kruger [EMAIL PROTECTED] wrote:
One thing would be to use multi-part emails and encode the links in
the HTML... This would
One thing would be to use multi-part emails and encode the links in the
HTML... This would accommodate those with html email readers - but you will
still have the problem with those using plain text.
-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]
Sent: Friday,
FYI: I have a blog on this topic...
http://www.coldfusionmuse.com/index.cfm/2005/12/1/ca
I tell clients with public web sites that they probably need a cert from a
popular reputable provider in order to avoid the browser warning. But the
thing to remember is that (in most cases) the warning is
If you are sure that no one has the file open (like through a mapped drive etc)
then I would run the repair utility on the file.
Mark A. Kruger - CFG
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
From: [EMAIL PROTECTED]
Sent: Friday,
Use a different delimiter if you suspect that the comma might appear.
cfset example=something 1|something2|something,3|something4
cfsdump var=#listToArray(example,'|')#/
-Original Message-
From: Leitch, Oblio [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 7:52 AM
To: CF-Talk
Nate,
FC released version 4 last summer and version 5 is in progress. It has a
vibrant development community. Where were you looking?
-mark
-Original Message-
From: Nate Willard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 11:39 AM
To: CF-Talk
Subject: CMS Solution
Scott,
The pro is that it's well supported by a reputable company and it's full
featured. The con Expensive.
-mark
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2008 9:03 AM
To: CF-Talk
Subject: Paperthin's Commonspot
Does anyone
Brian,
Dave's right but I'm curious. What is it that you are trying to do here?
Run mame on the web server? How would that work exactly? A guy goes to your
web site and then clicks on a link that launches mame on the web server
Ok ... Now what? How does he interact with it? If you are
Are you sure that bigInt is what you think it is? I thought it was just a
signed integer (2billion+ to -2billion+).
Meanwhile, the code below will throw a syntax error on the ampersand...
BigIntCol CAST(...) ... The ampersand is not the concatenation operator
in T-SQL. You have to use a plus
Dennis... Learn something new everyday. I guess I did not know there was
bit operator in CF :)
-Original Message-
From: Dennis Powers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 1:11 PM
To: CF-Talk
Subject: RE: Transact SQL question has me stumped
Mark,
I knew I would
I meant... I didn't know there was a bit operator in MSSQL ... In my
defense I'm not feeling well today and I've had a variety of pills of
dubious quality and nature.
-mk
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 06, 2008 8:47 AM
To: CF
Steven,
I would say that it is still quite important - especially if you wish to
leverage more memory on a larger server.
-mark
-Original Message-
From: Steven Wood [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 06, 2008 11:12 AM
To: CF-Talk
Subject: Is the need for multiple CF
Whoa What about the ability to run your instances with different JVM
args and allocate memory and resources specifically? And what about
leveraging more than 1.6 gigs of memory using multi-instances? It seems to
me there are resource issues that multi instance addresses as well.
-Mark
Ben,
Your syntax has commas in it that are not syntactically correct The
error is telling you this - incorrect syntax near ,
Note this line in your insert code:
njuice', '', 1903, 189, 123.45, , , 'clamprack
See the three commas in a row? There should be something there... An empty
I thought this question was worth a blog post
http://www.coldfusionmuse.com/index.cfm/2008/2/21/cfargument.sql.injection#m
ore
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get
Daniel,
I've installed on a dual proc dual core many times and never seen this
message. It must have something to do with the quad core...
-mark
-Original Message-
From: Daniel Roberts [mailto:[EMAIL PROTECTED]
Sent: Friday, February 22, 2008 10:03 AM
To: CF-Talk
Subject: Re:
I just put a post on my blog with some CF examples of SQL injection using
character fields. Perhaps some of you could add additional cases.
http://www.coldfusionmuse.com
-mk
-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]
Sent: Friday, February 22, 2008 2:35 PM
To:
Richard,
Here's a rundown of somt things we did for a problem like that one.
http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm
-mark
-Original Message-
From: Richard Steele [mailto:[EMAIL PROTECTED]
Sent: Monday, February 25, 2008 7:23 AM
To: CF-Talk
Subject: Memory
Che,
TOP is T-SQL specific I believe. You would need to use it in your SQL query
(to the Db) then use Q of Q of to join 1 or more queries together.
If what you are trying to do is combine 2 queries on the DB - consider
UNION
-Mark
-Original Message-
From: Che Vilnonis
Robert,
We have a web service used for the state of California that wraps image
files up as base64 - exactly as you suggest below. The image files are
obviously much smaller than media files (mostly less than half a meg), but I
can tell you that you are on the right track thinking that it is a
Daves right... Although cfcontent won't be as bad as opening the file as
binary, encoding as base64 and then creating a vary large XML packet.
I have never used the symlink idea - although I've heard him mention it
before. I'd be interested in a code snippet on how to do this on the fly
in
Dave,
What's your take on heavy use of cfexecute and the shell - at least in
Windows we have found it to be a little dicey. Sometimes command shells are
left in the process space without terminating.
-Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Pete,
I have a number of blog posts on JVM memory and links to other CF related
tuning of the JVM.
My latest post on it is a good start...
http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
It is quite surprising how many CF Servers go into production having just
the default JVM settings (0 to 512 heap).
I think that Adobe should have some choices during install... Maybe profiles
based on load and resources or whatever. I don't think that many people
understand that throwing CF on
be allocated to the JVM?
Mark Kruger wrote:
... there is a limit to how large the heap can be (on 32bit anyway).
-mark
Well there is a limit on a 64 bit system to. It is just a much bigger
limit.
~|
Adobe® ColdFusion® 8 software
well with 1024. Is there a smaller limit for
1.4 JVM?
Russ
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Friday, February 29, 2008 9:39 AM
To: CF-Talk
Subject: RE: How much memory should be allocated to the JVM?
It is quite surprising how many CF Servers go
Russ,
Not so fast... If you are using 7 gigs already then the issue is not how
much memory you have free total.. The issue is are there enough blocks of
contiguous memory available to equal the heap size you are targeting. On a
server running JUST an operating system (say Win2000 or 03) and 2
Dave,
Whoa Do you know which patch? Was it one of the auto-update ones? We
should write that down. That would be one of those things that would take
forever to figure out.
-mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, February 29, 2008 1:05 PM
Dom,
Great example
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 2:24 PM
To: CF-Talk
Subject: Re: CF functions question
No, you absolutely should var that variable, persistant component or UDF or
whatever and I always var my
I have a recent one one to add to this list:
http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm
Good luck..
-Mark
-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2008 12:14 PM
To: CF-Talk
Subject: Re: Slow machine - JRun?
Professional
Advanced Macromedia ColdFusion MX 7 Developer _
http://blog.cutterscrossing.com
Mark Kruger wrote:
I have a recent one one to add to this list:
http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm
Good luck..
-Mark
Mashup gurus,
I'm looking for some simple examples of using google maps version 2 with CF
and Ajax Anyone? Also - any tips you have on performance when using a
lot of markers. Thanks!
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
ColdFusion MX 7 Developer _
http://blog.cutterscrossing.com
Mark Kruger wrote:
Mashup gurus,
I'm looking for some simple examples of using google maps version 2
with CF and Ajax Anyone? Also - any tips you have on performance
when using a lot of markers. Thanks
Advanced Macromedia ColdFusion MX 7 Developer _
http://blog.cutterscrossing.com
Mark Kruger wrote:
Cool... I didn't think to look there. Thanks Steve.
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
Don,
I'm with Sonny on the virus thing... But I do like the idea of better file
upload... Like some of the java applets that are out there.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Sonny
Right on..
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2008 7:03 PM
To: CF-Talk
Subject: Re: Help Adobe plan the future of ColdFusion (along that line)
Sure, but not Java. Flex does this really well and fits better with CF as an
adobe
Don,
I was responding to your suggestion and I got carried away and wrote about 5
paragraphs So instead of cluttering up the list I put it in a blog post:
http://www.coldfusionmuse.com/index.cfm/2008/3/13/cf8.catch.22
As a practical note specifically for you, I would mention that you are
Subject: RE: Google Maps, CF and Ajax
I so hope everyone knows that's in reference to Red Dwarf! :O.
http://en.wikipedia.org/wiki/Red_Dwarf_characters#Ace_Rimmer
:OD
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: 12 March 2008 22:25
To: CF-Talk
Subject: RE: Google Maps
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2008 3:23 PM
To: CF-Talk
Subject: RE: Google Maps, CF and Ajax
Cool... I didn't think to look there. Thanks Steve.
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
Yes... I thought the response was good as well. Thanks for Jamie.
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Adam Churvis [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2008 4:05 AM
To: CF-Talk
That is amazing I have no idea how they could afford to offer CF for 10
bucks a month... I would be afraid of paying so little What is their
incentive to help when things go wrong?
I'm all in favor of low prices but sometimes I think it would be better if
there were not so many
Jamie,
In a recent project I used the new server monitor on a Linux CF8 ent
server... There were some things from SeeFusion has that I missed - but over
all the server monitor provided some excellent tools and was an acceptable
replacement.
One item that was particularly useful was the alert
.
They also allow you to have multiple domains under one account which was one
of the primary reasons I first looked at them. I've been with them ever
since.
andy
-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2008 8:49 AM
To: CF-Talk
Subject: RE
Sonny,
These constants are not constants to the SQL server. To the SQL server
these are still unbound variables... So yes, you need to use cfqueryparam if
you want to hit the cache pool and execution plan cache. Otherewise the
driver hands off the prepare operation to the SQL server - meaning no
variables used when the value is actually variable.
On Fri, Mar 14, 2008 at 10:43 AM, Mark Kruger [EMAIL PROTECTED]
wrote:
Sonny,
These constants are not constants to the SQL server. To the SQL
server these are still unbound variables... So yes, you need to use
cfqueryparam if you want to hit
Jamie,
Ah Well it's likely you will run into the same issue with the server
monitor. I know it's important to be able to do that in a shared
environment. On one of my seeFusion (windows) box I have a hard time killing
them as well... Usually takes a couple tries per thread - and even then
Jamie,
There are a couple of new features of 8 that will help. One is the ability
to set timeout values on threads in the queue (nice to have on a very busy
server) and another is the ability to configure the automated killing of
long running threads in the alerts area. I have not yet configured
Ian,
I posted an example of this recently on my blog.
http://www.coldfusionmuse.com/index.cfm/2008/2/22/sql-injection-on-a-charact
er-field
The long and short is that different platforms allow you to escape single
quotes differently and this technique can be used to get the right number of
Patrick
Excellent excellent information pat - thanks! Do you have any articles or
other information on just exactly what is this OS Native Socket code of
which you speak? I'd love to learn more about it.
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
You did not mention the JVM settings... I assume that you have changed the
JVM args for memory to conform to the production environment - yes? What
version of cf? What are the settings etc. You definitely should see a boost
not a decline in performance.
Mark A. Kruger, CFG, MCSE
(402) 408-3733
2 follow up.. What are the actual JVM settings (the arguments in the
jvm.config file). What is your setting for simultaneous requests.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Annie x
Pat,
Put me on the I think it's a high priority list. If they are going to
tout CF8 as a huge performance gain and certifiy it for 1.6 then I would
think this would be an issue for them.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
Dave,
Of course the other side of the coin is writing an application that can work
with multiple databases... That can sometimes require a generic approach
that resides in the application logic. Many shopping carts are like that.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
I'm not sure I would get hung up on what windows task manager reports vs.
the server monitor or Jprofiler.
Looking at this log it appears that the number of simultaneous requests is
set at 25. When 25 is reached all other threads begin to queue. It goes
from 0/5 (0 running requests out of 5
Mike,
Are you making sure that either product_id or cat_id is required? If not
then this query has the potential to select all the records from your DB.
You also need to specify actual columns rather than the asterisk.
As for complexity - I've seen far worse :)
I would use aliases instead
Mike,
You would only need to validate it if you were accepting it as user input.
In that case you would need to compare it to a list or array of valid
values... Or perhaps pass in something that you compare to derive this value
as in.
cfif form.orderby IS 'order_key'
Cfset
1 - 100 of 365 matches
Mail list logo
