Sure, but at no stage are you looping through getPCtoNCRet. This means
that only one value will be matched as the comparison sees only one
value from the query.
On 1/6/07, Bruce Sorge [EMAIL PROTECTED] wrote:
Actually I do not need the group or maxrows attribute so I took them out,
but that did
Hi there
I am currently developing a business application (business directory) for a
specialized section of the medical profession in Sydney (Australia).
As part of the directory people who wish to advertise and have their details
included on the site they are able to provide us with
On Saturday 06 January 2007 21:20, Jochem van Dieten wrote:
index scales with the natural logarithm of the cardinality so 4000
composite records should only be 1.5 times slower then 900 individual
And, tbh, if your database can't sort 4000 records in reasonable time, you
have other problems
I hope that I am not interpreting wrong here, but whther you get mixed
results or not, do you want a trailing space after the column level?
You could just use the following and whether you receive the extra space or
not, it should return the same result:
cfoutput query=test#trim(level)#123br
I think the schema here needs a little tweaking.
This is a perfect case for a many to many relationship also know as a bridge
table.
You have table 1 which is your for processes and you have table 2 for your
tasks.
You will need a table 3, which will store the primary key from processes and
Teddy,
Yes, we already have all this. The data is highly normalized. This is how we
relate the items to each other already. But the issue is trying to store as
little in the colleciton as possible. If I store the 'relation' records (from
the 3rd table) then I end up with the 4,000+ items
Hi,
Had a very strange occurrence on Friday that mystifies me: while doing some
testing, two of my client's analysts experienced the same error, as follows:
Element user is undefined in a Java object of type class
coldfusion.runtime.MemorySessionScope
The element user is a struct within the
I'm building an app where usage is going to be FAR higher than anything i've
used OOP for before, so I am trying to be careful to build it with the
potential bottlenecks in mind. In this job i might have several hundred
concurrent users accessing the application.(in the past i've used it for
Dave,
I see now what you are trying to achieve. I do not use cfsearch or verity
for such searches and weighted results.
I have done a similar search in the past on two related ideas. I shall put
it in the terms of your example.
The search was one part search and one part drill down. I would
I am working on a server with 8 different web sites, at least 2 of which
are fairly high traffic. Would I be best served having an instance on
each web site (server is dual-Cpu dual-core 3.8 xeon w/ 4 gig Ram,
win2003 IIS), or would you think 2 instances per high traffic site w/
cluster
An organization I work with recently hired a firm to redo their website.
This includes both HTML and CF.
A problem cropped up on a portion of the work. I looked at their code
and found they were using reserved words for field names, e.g. Year.
The query worked when I pulled it out and plugged it
Larry,
I am not trying to criticize the institution or the client or to reiterate
the rhetoric that Access just simply is a troubled solution.
As for the reserved word usage, that just needs to be changed to avoid the
exact issue you are having. It is a reserved word on purpose.
With Access, I
What part of the word RESERVED do they not grasp?RESERVED means it's
RESERVED for a specific use.
When you go to a concert, and sit in a seat marked RESERVED you can expect
that it's odds-on there's gonna be trouble, unless it's reserved for you.
This is no different.
The solution is for
Is there anything out there that will take a number and convert it to
words like you would have on a check? Example 12.45 would become twelve
dollars and forty five cents.
Lee
~|
Create robust enterprise, web RIAs.
Upgrade
Check CFLIB.org I recall something like that before.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 11:53 AM
To: CF-Talk
Subject: Number to currency words
Is there anything out there that will take a number and convert it to
words
I choose [B]. Less objects = a good thing.
On 1/8/07, Mike Kear [EMAIL PROTECTED] wrote:
I'm building an app where usage is going to be FAR higher than anything i've
used OOP for before, so I am trying to be careful to build it with the
potential bottlenecks in mind. In this job i might have
couldnt you create a list of words one - ninety-nine
use the decmial to seperate the currency into 2 values.. dollars and cents.
Then use a switch case to determine the length of the dollars to add
the hundred or thousand, or ten thousand, etc?
use the above list to create the tens and ones
Is there anyway to use the cingular 8125 to capture a signature in a mobil web
form and transfer it into database via coldfusion?
Thanks
Keith
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with
It seems like option [B] would use a lot less memory resources.
A little more detail about how your objects are set up would be helpful to
get a clearer picture. Do you have multiple tables which each store which
user/ when created? It seems like you could have a userID property in each
of
How do I date format a year behind the current year? In other words, I would
like to populate a dropdown with 2006 and 2007.
Tried this, but no dice:
#dateAdd('y',-1,now(), )#
Thanks.
Robert O.
~|
Create robust
Anyone recommend a GUI HTML editor for Eclipse? Kind of like Dreamweaver's
Design view.
I have a friend who is more designer than programmer and needs something free
to edit pages in a graphic kind of way rather then coding HTML.
Thanks!
year(now()) - 1 should work
~Brad
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 11:30 AM
To: CF-Talk
Subject: One year behind
How do I date format a year behind the current year? In other words, I
would like to populate a dropdown
Close But not quite:
#Year(now())# (will give you 2007)
#Year(dateAdd('y',-1,now()))# (will give you 2006)
Or you can do the long way:
#DateFormat(now(), '')# (will give you 2007)
#DateFormat(dateAdd('y',-1,now()), '')# (will give you 2006)
-Original Message-
From: Orlini,
#dateAdd('y',-1,now(), )#
That is not a valid function.
You could do this.
#dateFormat(dateAdd('',-1,now()),)#
OR
Year(now()) - 1
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Soduko
| | |
Robert,
Try
#Year(Dateadd('y',-1,now()))#
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 11:30 AM
To: CF-Talk
Subject: One year behind
How do I date format a year behind the current year? In other words, I would
like to populate a
Also, the dateAdd function uses '' to specify year (where 'y' specifies day
of year).
So #dateAdd('y',-1,now(), )# should be #dateAdd('',-1,now(), )#.
Terry
How do I date format a year behind the current year? In other words, I
would like to populate a dropdown with 2006 and
Try supplying the full date, not just the year portion.
On 1/8/07, Orlini, Robert [EMAIL PROTECTED] wrote:
How do I date format a year behind the current year? In other words, I
would like to populate a dropdown with 2006 and 2007.
Tried this, but no dice:
#dateAdd('y',-1,now(), )#
You've got too many arguments in dateAdd. Get rid of the , part.
Cheers,
Chris
Orlini, Robert wrote:
How do I date format a year behind the current year? In other words, I would
like to populate a dropdown with 2006 and 2007.
Tried this, but no dice:
#dateAdd('y',-1,now(), )#
Terry Sta. Maria wrote:
Also, the dateAdd function uses '' to specify year (where 'y' specifies
day of year).
So #dateAdd('y',-1,now(), )# should be #dateAdd('',-1,now(),
)#.
Terry
Terry:
dateAdd only takes three arguments. Not four.
|*DateAdd*|(/datepart/, /number/,
Hello, we're trying to set up some new servers (W2003/IIS6) with CF7 Enterprise
multi-server. We have a purchasing system on a Weblogic box that we are using
BEA's proxy to forward requests based on extension. My problem is that the JRun
server keeps trying to parse the .jsp files. I found an
Oops. Scratch my reply. I somehow missed the Now() portion of your
example.
On 1/8/07, Crow T. Robot [EMAIL PROTECTED] wrote:
Try supplying the full date, not just the year portion.
On 1/8/07, Orlini, Robert [EMAIL PROTECTED] wrote:
How do I date format a year behind the current year?
I'm looking through old code from my new company and I'm asking questions of
myself. It's a good challenge, but one that I'm not sure about is this.
A query has an incoming value which is the result of a previous query:
WHERE id = #Val(getsite.id)#
Should something like this be using a
ALWAYS use CFQUERYPARAM...it's not just for stopping SQL injection
attacksit
also increases query speed by using BIND variables (at least with Oracle and MS
SQL Server.not Accessnot sure about mySQL).
HTH
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
A query has an incoming value which is the result of a previous query:
WHERE id = #Val(getsite.id)#
Should something like this be using a cfqueryparam or is it okay to leave as
is?
As Bryan said, it probably should use cfqueryparam. One time you may see this
code though would be if it's a
yes as a matter of routine, my tables usually have fields for:
createdby (the userid of the person who created this record)
datecreated (timestamp)
updatedby (The userid of the last person to alter this record)
dateupdated (timestamp)
So the methods in the DAOs that manipulate the records
Bryan...
Could you explain a little please? It would seem to me that using an extra
function or tag would increase processing time.
Andy Matthews
Senior Coldfusion Developer
Office: 877.707.5467 x747
Direct: 615.627.9747
Fax: 615.467.6249
[EMAIL
Are you putting the entire factory into session or the results of the
factory?
It seems like to me that you put your factory into a less transient scope
like your application scope and then your user's session invokes an
instances of the factory as related to the user.
As for credentials, how
Hello,
I've always used MSSQL and quite frankly am quite fond of it - except for
licensing costs. I've read a few posts here and there where people have
talked highly of PostgreSQL, so I'm thinking about giving it a shot on a new
server (windows box). I mentioned this to a buddy of mine who is
john venable wrote:
Hello, we're trying to set up some new servers (W2003/IIS6) with CF7
Enterprise multi-server. We have a purchasing system on a Weblogic box
that we are using BEA's proxy to forward requests based on extension.
My problem is that the JRun server keeps trying to parse the
nVU?
http://www.nvu.com/index.php
On 1/8/07, Chad Gray [EMAIL PROTECTED] wrote:
Anyone recommend a GUI HTML editor for Eclipse? Kind of like Dreamweaver's
Design view.
I have a friend who is more designer than programmer and needs something free
to edit pages in a graphic kind of way
Could you explain a little please? It would seem to me that using an extra
function or tag would increase processing time.
The limiting factor here is not the CF code, it's the database processing time.
Using binding variables will generally speed that up.
--- Mary Jo
Here's a good blog entry from Ben a while back:
http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored
Will
~|
Create robust enterprise, web RIAs.
Upgrade integrate
In my experience, it only slowed things down. Now, YMMV, but I've noticed
that the more cfqueryparams you have in your query, the slower it will run.
Although theoretically the sql engine should have an easier time caching an
execution plan for your query, the only reason I have found to use
I have this code that goes through a db record set (with just one
record) and creates a structure, full of variables for referencing:
cfset db_info = StructNew()
cfloop list=#the_db.columnlist# index=col
cfset db_info[col] = the_db[col][currentRow]
!--- attempting to make
Hi all,
I have to display an alphanumeric field that may contain numbers (e.g., GPA's)
or text (e.g., n/a). I have no control over the input form, or the database,
so I have to work with whatever I'm given access to.
So, to format the display of that field, and hoping that the field will
Does anyone know if this works on SQL server? I was never able to replicate
this.
Russ
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 1:34 PM
To: CF-Talk
Subject: Re: Cfqueryparam on ALL values or just user definable ones?
I was attempting to install SQL Server 2000 SP3 onto my Windows XP
Professional machine, and I was informed that I could only install the
client tools and not the server itself. This sucks since this is a laptop
that I do development on, and my main SQL Server is home on my server. Has
anyone had
Can't you do it like
cfset #varname# = anothervar?
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
You can only install SQL Server Developer edition (not the same as the MSDE)
on an XP machine (not standard etc)
Failing that install MSDE
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Hey gang, I'm having some trouble getting something to work as expected.
I've got a script that generates a form based on data in a DB. I'm
adding a CAPTCHA to it - Ryan Emerle's cfx_captcha to be specific.
In the example page that came with the tag, in the end it spits out:
cfcontent
It should work. I have it installed on my machine. You will need to
install the software from the original cd's and then put on the latest
service pack. (4a I believe). Make sure you have all the prereq's
installed.
Russ
-Original Message-
From: Bruce Sorge [mailto:[EMAIL
For those cases
were the field can contain text, e.g., a n/a string, I tried to use
the following:
cfif isNumeric(GPA)#numberFormat(GPA, '9.
999')#cfelse#GPA#/cfif
Obviously, this always displays the CFELSE portion because the
original field is not numeric.
As I was reading my own
Although theoretically the sql engine should have an easier time caching an
execution plan for your query,
And there's the important part. I don't think you can base it on what you will
see as just one individual hitting the page during development, because yes,
then you will generally see a
Yep, I've only installed SQL Server Developer, and on quite a few XP Pro
machines - no problems.
Will
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
I made this work... let me know if you still need the code (it's ugly
but performs the job)
On 1/8/07, Greg Morphis [EMAIL PROTECTED] wrote:
couldnt you create a list of words one - ninety-nine
use the decmial to seperate the currency into 2 values.. dollars and cents.
Then use a switch case
Oh yea, I am using the developer version.
Russ
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 3:05 PM
To: CF-Talk
Subject: RE: Getting SQL Server onto XP Pro machine
It should work. I have it installed on my machine. You will need to
How about in your list loop:
cfset #col# = the_db[col][currentRow] and
cfset #col# =
-- Josh
- Original Message -
From: Scott Weikert [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, January 08, 2007 12:01 PM
Subject: Re: retrieve db into variables
Can't you
This should do it for you. Returns 1 if anything but numeric, comma or
decimal is in the field:
reFind([^[:digit:].,],yourVariable)
On 1/8/07, Roberto Perez [EMAIL PROTECTED] wrote:
Hi all,
I have to display an alphanumeric field that may contain numbers (e.g.,
GPA's) or text (e.g., n/a). I
OK, I am using SQL Server Standard Edition, so that must be the problem. I
will look for the developer edition in our collection. Thanks.
On 1/8/07, Russ [EMAIL PROTECTED] wrote:
Oh yea, I am using the developer version.
Russ
-Original Message-
From: Russ [mailto:[EMAIL
Come to an intensive class on SQL, Model Glue, Fusebox or ColdFusion.
Classes limited size so that you can be sure
to get your own questions answered! Sign up today to
guarantee a place at http://www.teratech.com/training/
- Michael Smith, TeraTech, Inc
PS If you can't make a class we have
I'd rather it just create a variable with the field name and fill
it with content instead of sticking it in a structure.
It may be helpful to know/recall that all local variables live in a scope
structure called Variables. So you can just use that instead of the structure
you create yourself:
I have several issues i am trying to work out but I will take them one at a
time. My first question is installing iText to CF7. I know CF7 comes with a
older version of iText 1.2.8 or something like that. The newest is 1.4.8(3). If
I drop this into the CF lib/ dir it breaks cfdocument. Can
OK, that was the problem. Wrong version. Thanks all.
On 1/8/07, Bruce Sorge [EMAIL PROTECTED] wrote:
OK, I am using SQL Server Standard Edition, so that must be the problem. I
will look for the developer edition in our collection. Thanks.
On 1/8/07, Russ [EMAIL PROTECTED] wrote:
Oh yea,
john venable wrote:
I have no experience with it, but I can think of 2 probable solutions:
1. Give the ISAPI plugin from BEA a higher priority then the ISAPI plugin from
JRun.
2. Remove the jsp mapping in JRun. I think it is the following in
default-web.xml:
servlet-mapping
I started looking into this matter a little and the protocol is easy to crack.
I only coded 3 functions, but I found many other operations by playing with IIS
logs.
http://www.angryprogramming.com/download_details.cfm/download_id/3
is it developer edition or personal edition? at home i'm always installing
SQL 2000 personal edition on window XP Pro. the personal edition came with
my standard edition and uses the same key.
jonese
On 1/8/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
wrote:
You can only install SQL Server
If you use my JavaLoader, you should find it a relative breeze. It
enables you to load in jars that aren't inside your lib folder.
Have a look:
http://www.compoundtheory.com/?action=javaloader.index
Mark
On 1/9/07, Steven Gekko [EMAIL PROTECTED] wrote:
I have several issues i am trying to
Yeah, that will not install on XP.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It
I also seem to recall someone saying Snake has a way around the CFDOCUMENT
busted by newer iText issue (thoughthat is form mabye a year ago) ;-)
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell:
I am all for reducing attack surfaces. Even if cfqueryparam's sole
purpose in life is to enhance security, its worth it. Never mind the
speed given under load. Use it as a cheap way to bulletproof your
code and minimize your own personal liability in case it turns out the
hacker is smarter than
Scott,
You call the captcha file directly from within the img tag:
img src=randomWord.cfm alt=Captcha Img /
When you post the form, you compare the Captcha input to the session
variable set in the cfm that generates the captcha.
With CFX_Captcha I believe the variable it sets is
MS SQL is a fine database, and will get the job done. However, why pay
for a database like that when you can get essentially the same thing for
free?
I've got nothing but positive things to say about PostgreSQL, and I'd be
very interested to hear what your friend has against it. In my
experience,
Jordan,
Thanks for the reply. I forgot to post his specific gripes about it. Here
is a quick summary:
- non-standard sql
- difficult to backup / migrate
- user authenication is weak
- difficult to setup
- difficult to manage
Your post was most informative, for sure. But there's one thing
Steven Gekko wrote:
I have several issues i am trying to work out but I will take them one at a
time. My first question is installing iText to CF7. I know CF7 comes with a
older version of iText 1.2.8 or something like that. The newest is 1.4.8(3).
If I drop this into the CF lib/ dir it breaks
Hi Matt,
I've responded to your message in-line below:
Matt Quackenbush wrote:
Jordan,
Thanks for the reply. I forgot to post his specific gripes about it. Here
is a quick summary:
- non-standard sql
Indeed. This is true in some rare cases (like case sensitivity) however,
it seems all
- non-standard sql
Indeed. This is true in some rare cases (like case sensitivity) however,
it seems all databases take some liberties in regards to this.
I agree, I think every database has some non-standard SQL. An example in MS
SQL is the isNull() function, which is functionally
Jordan,
One note - MS SQL is not case insensitive. In it's default collation it is
case insensitive - but it can be either case sensitive OR case insensitive
depending on install options and collations.
-mark
-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED]
Sent:
Hi, Bruce.
Of the four versions of SQL Server 2000 that are available, only the
personal version of SQL Server 2000 can be installed on aWinXP machine. All
other versions must be installed on a Windows server system (Win2K, Win2K3,
SBS, etc.) Since you are doing this on your development machine,
Matt,
I'll offer my 2 cents:
I use both Pg and MySQL daily now. I used MSSQL for quite a time,
but being a small company, when I started to think about scaleability
and long-term costs I moved all of my projects over to MySQL.
Most of my external projects, however, run Pg, so I spend quite
Just to keep you in the loop. We were actually using TinyMCE 2.0.6. and
I had a look at the 2.0.8 version of it. This version has been adapted
to IE7 requirements (it's now sniffing for IE7 as well in the JS).
However, it still loses the position when a link is inserted from the
FarCry tree.
80 matches
Mail list logo