How do I check to see if a string includes (or does not contain) an integer or
number. I am trying to check the Address form field to see if it 'Does Not
Contain' a number as in 316 Spring Creek Dr. I want to see if they left out the
316. Thanks in advance for any help.
Is there a way to check the whole string and not just the first part in case it
is a P.O. Box 316?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Well, you are doing a great job. I guess I am not communicating well. I was
using the 316 as an example. I want to check an address field passed from a
form where the value is unknown. I just want to be able to check using Does Not
Contain or IsNumeric or other Cold Fusion test in a cfif
For education reasons, what does the '/d' reference? How does that tell the
statement to look for a number?
~|
Order the Adobe Coldfusion Anthology now!
Very Helpful. I had not seen this before. Great stuff. And thanks to everyone
for there expertise. CF-Talk has always come through for me. Blessed Easter
everyone!
~|
Order the Adobe Coldfusion Anthology now!
It still sounds like an excuse. If they are going to allow this mixing, they
should either not provide the feature or make it work. Both are provided
features within ColdFusion. They are both cf tags, cflayout and cftextarea
rich? If Adobe is going to include them within ColdFusion they should
I am using CF 9.1 on a Windows 2008 Web Server and have noticed another issue
with cflayout(area). This (of course) only occurs in IE9. It works fine in
Firefox.
Let's say I build a cflayout page with 3 cflayoutareas (tabs). If I place a
rich cftextarea (CKEditor) within tab 2 or 3 it does
Is it a page execution timeout or some database query execution timeout?
Sorry I haven't gotten back, been out sick. All I know is that the code works
fine if the image being uploaded is 72dpi. If the dpi is larger, I get an error
message that the cfquery which follows the upload times out?
I have an app that uploads and converts images to the appropriate sizes for
website display. If the image being uploaded is 72dpi, it works fine. If the
image is 97 dpi or up, the image is processed appropriately and saved as 72
dpi. Yet, whole the process works, it throws an error. The error
Russ,
Did you ever figure out what was going on because I am having the exact same
issue.
David Moore
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag
I just upgraded from CF8.1 to CF9.1 and am experiencing a major problem with
cflayout. The layout area no longer dynamically fits the content area. The
height is minimal and the width seems to be like 400% wide? From what I have
read, this is a know bug that has not been fixed.
Does anyone
I allow clients to convert MS office files to PDF documents within my content
management system. I was using easyPDF, but since upgrading to CF9, I am
attempting to use cfdocument and openoffice. In testing I am finding it works
sometimes and sometimes not. When it does not, I get a PDF
I just upgraded from CF8 to CF9 and am experiencing the same problem with
cflayout no longer providing dynamic height and width values. I also applied
9.1 hot fix in hopes it would help and it did not. Anyone have a solution?
Thank you,
David G. Moore, Jr.
UpstateWeb, LLC
I recently added an cferror to my websites and it has helped me discover a
lot of issues I needed to fix. At the same time, I have some very odd code
showing up and didn't know if it is something I should address or is it someone
trying to hack into my websites. Here is an example:
I've found that a lot of these issues are caused by either bots, or someone
linking to a webpage and made a typo. Most likely bots.
I am checking to see if it is a bot or not. In this case, it was not. I guess
that's why I was more curious. If it is a bot, like Google or Slurp, I mark it
up to
What is the best way to write the following update loop using cfqueryparam?
cfset loopcount=0
cfloop index=UpdateRecord list=#FORM.RecordsToUpdate#
cfset loopcount = loopcount+1
cfset NewOrder=#ListGetAt(FORM.DisplayOrder, loopcount)#
cfquery name=updDisplayOrder datasource=#DSN#
Pages
SET Pages.DisplayOrder = cfqueryparam cfsqltype=cf_sql_integer
value=#ListGetAt(FORM.DisplayOrder, loopcount)#
WHERE Pages.PageID = #UpdateRecord#
/cfquery
/cfloop
David Moore
UpstateWeb
~|
Order the Adobe
I have seen where others have posted this question, but no resolution. CF keeps
restarting and sometimes will lock up so badly that i have to restart the
server? Here is the error message:
The description for Event ID 0 from source ColdFusion 8 ODBC Server cannot be
found. Either the
I am using MS Access and assigning the Datasource using CF Administrator as
MS Access with Unicode. Does that help?
~|
Order the Adobe Coldfusion Anthology now!
The MS Access with Unicode driver doesn't use ODBC. So, you can
disable the ODBC services and see if that fixes your problem.
I am using 2 websites with SQL Server Express. If I stop this, will it
affect those.
And what is the ODBC Services for if not to manage database connections? In
what
Thank you Dan and Russ. You have been a tremendous help.
I have turned the ODBC Service off and will report back if this resolves the
issue so others may benefit from this post.
~|
Order the Adobe Coldfusion Anthology now!
for all websites and turning off
ODBC Server?
David Moore
UpstateWeb, LLC
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
They must have been ODBC data sources then, a JDBC Data source uses JDBC
and
not ODBC.
I guess then, what you are telling me, is I should be using a JDBC Data
source.
Any place to get directions on how to do this?
David
~|
sequelink or something along
those lines.
Does this help Dan? I am pretty sure I am using ODBC. I set up all my
Datasources using the drop down list in CF Admin.
I am guessing I should do this another way? I have just never figured out
how to do it.
David Moore
UpstateWeb, LLC
working.
Any suggestions from this, other than the obvious as Mark Kruger has told me
many times stop using Access.
David Moore
UpstateWeb, LLC
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion
.
Sorry about repeating some information, I just want to make sure I am being
clear.
David Moore
UpstateWeb, LLC
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag
Mathew,
Did uninstalling and reinstalling the ODBC Drivers fix the issue? I am having
the same problem.
~|
Order the Adobe Coldfusion Anthology now!
Meghna,
I am getting the same error message and CF is locking up so badly all I can do
is reboot my server. What did you find, if any, is the solution?
~|
Order the Adobe Coldfusion Anthology now!
Meghna,
I am getting the same error message and CF is locking up so badly all I can do
is reboot my server. What did you find, if any, is the solution?
~|
Order the Adobe Coldfusion Anthology now!
null=#Trim(FORM.Contributed) EQ ''#
I like this.
I find this easier to read:
null=#yesNoFormat(len(trim(form.contributed)))#
just because the nested quotes can be confusing.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a
Dave,
I find this easier to read:
null=#yesNoFormat(len(trim(form.contributed)))#
I really like this in that is seems to be truer to the actual use of the
variable as CF intended it to be used.
To confirm what you are proposing, if form.contributed is NULL it will produce
the following:
I really appreciate everyone's input. This kind of documentation is very
helpful for a lot of people. I have found CF-Talk to be the best CF resource
available. Maybe some of the experts on this list can provide other examples of
cfqueryparam uses that have been helpful, but not mentioned
Roger,
What about using null=#isDate(form.contributed)# ?
Would you want to add the yesNoFormat before the isDate as in Dave's suggestion?
As to the second part, I am checking using ColdFusion's cfform methods within
cfinput prior to submitting the information. Would your suggestion be a good
Seems to me that there is a lot more to cfqueryparam than I have been
utilizing. I built the following query using as many elements of cfqueryparam
as I could find based on examples from CF-Talk and other resources. I would
love to get expert opinion from those on this forum in an effort to
I guess the question would be, are there better or more proficient ways to
write these cfqueryparams? I haven't been able to find a lot of complete
documentation on the use of cfqueryparam. Just bits and pieces here and there.
So I tried to build in as many instances and different uses as I
I say we start a new party and make him our Candidate. Although he is
everything no one would expect to find in a presidential candidate. He is
intelligent, unselfish, and is accessible to anyone. Yep, nothing you would
expect...
Now, what about a name for our party.
Programlicans,
I hope no one Evaluates() this thread or I'll get a CF- ;).~David
_
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
Ray wrote:
As someone who used to always pounce on folks for using evaluate, I believe
I remember reading recently a blog entry from an Adobian that points out
that evaluate is not nearly as slow as it used to be. Now when I recommend
against Evaluate I do so on readability terms rather
Adrian Wrote:
SELECT * FROM Contacts WHERE Contacts.ContactType = 'Physician' AND
Contacts.#FORM.Field# = '#FORM[FORM.Field]#' ORDER BY Contacts.LastName
What is the [] for. How would they be used. I have never used them at all. What
is the protocal. Is that CF or SQL or... And then throw
You people are just scary smart. At least I have my good looks to fall back on
:) (I wish)...
~David
_
See how Windows connects the people, information, and fun that are part of your
life.
Well, if you'll were trying to make it clearer - it's darker than pitch now.
Smart - but confusing. Seriously. I'm, lost again.
Let's just do this one:
cfoutput query=getPhysicianSubTypes startrow=#Evaluate(start)#
maxrows=#Evaluate(end)#
and this one, which is from a tag I got of Adobe 2
Judah wrote: Untested but should work: cfquery name=getPhysicianRecords
datasource=#DSN# SELECT * FROM Contacts WHERE Contacts.ContactType =
'Physician' cfif Len(form.field) AND StructKeyExists(form,form.field) AND
Contacts.#FORM.Field# = '#Trim(form[form.field])#' cfelse 1 = 0 /cfelse
ORDER
Now I am having one of those v8Aha!/v8 moments.
Thank you...
~David
Judah wrote: Ah, sorry, didn't explain fully. I did a StructKeyExists and a
Len to make sure that the field you are going to evaluate really exists in the
form. If it doesn't, you don't want your cfquery to throw a
Would something like this work?
cfset Evaluate(application.#appconfig.code_name#) = '#appconfig.code_value#'
~ David Moore
_
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
http://windowslive.com/connect/post
I just love giving you guys something to laugh at ... Rag the newbie... It's
OK. At least I am learning, and trying. :) hehe :) Ouch! Evaluate
_
See how Windows Mobile brings your life togetherat home, work, or on the go.
Pat wrote: It's sometimes the best and fastest way to learn :-). Evaluate
works, it's just not really recommended Ouch. ;-)
Yes. It's just painful to the character of ones soul.
I didn't know that about Evaluate. Glad I do know that...now.
I wish there was an asterisks next to code
Charlie wrote: hey i was laughing at patrick laughing at you, not laughing at
you directly, so it's ok :)
Oh, I'm cool. I worked in Radio for 15 years as a DJ, so I don't expect a whole
lot out of myself. I thought it was funny too. :)
~David
the To's. Don't put them all in the To field.
cfloop index=ToEmails list=#ListofEmails#
cfmail to=#ToEmails# from=[EMAIL PROTECTED] subject=email
content
/cfmail
You may also want to do some email validation.
~David Moore
_
Get more
is from the
URL.PageID to make the link color different, like with CSS. I hope this makes
since...
Any suggestions...
~David Moore
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free
of a database dynamically and it must be a non-universal
font, is there any other solution other than Text to Image or sIFR?
Thanks,
~David Moore
_
Talk to your Yahoo! Friends via Windows Live Messenger. Find out how.
http
I think I have everything correct, but the background of my dynamically created
image is black. Nothing I do will change that. Can someone tell me what I am
doing wrong. See the test site at:
http://www.wawalker.com/index.cfm?PageID=32ParentPageID=44NavLink=7
table width=100% border=0
?
~ David Moore
_
Talk to your Yahoo! Friends via Windows Live Messenger. Find out how.
http://www.windowslive.com/explore/messenger?ocid=TXT_TAGLM_WL_messenger_yahoo_082008
K. Wrote
Have a look at sIFR - http://wiki.novemberborn.net/sifr
Uses JavaScript and Flash to dynamically replace text headings with
the desired font. It degrades gracefully so that user agents with no
flash or no javascript will just get the text. Search engine friendly
and no additional markup
Have you tried:
AND Works.ThisInventory not in
(#listQualify(valueList(getActiveWorks.ThisReference),')#)
Dave
I went in and applied the solution to all my other queries where I was having a
problem and it works great. You were right. None better. Thanks!
Already I am learning a lot from
I have a client who must use Scala Sans for their Titles and still wants
everything dynamic. As I explained over and over again that Scala Sans is not
universally available on every computer and that every time they want to have a
header it would have to be an image, I am trying to find a
Are you doing this dynamically using cfimage or Photoshop or just how?
~David Subject: Centering text written on an image From: [EMAIL PROTECTED]
To: cf-talk@houseoffusion.com Date: Fri, 22 Aug 2008 11:09:37 -0400 Hi,
I want to add some text to an image but have it centered rather than left
Kevin Wrote
I am using ColdFusion to write some text on an image and I don't know in
advance what the string is going to be so I can't guess where to start
writing it. Is there a way to say write this text around a particular
point? I can check from the image how wide it is and work
Is there any CF solution to apply some kind of text to image conversion
~David G. Moore, Jr.
And then a thread comes along that gives me an answer without answering my
question at all:
cfset ImageDrawText(myImage,Congratulations!,10,50,attr)
One day I will learn ColdFusion?
~David
I am still getting around 50 to 75 attacks a day on about 20 of my websites. I
applied the solution from JOCHEM that aborts the attach in the application.cfm
file and then sends me an email.
They just keep coming from different IP addresses so it is useless to do
anything other than wait for
I know I am setting myself up for another Query too complex issue, so before
I start I thought I would ask for suggestions. I run into this when I have to
reference two different Access databases that are Client imposed (don't ask).
Basically, I have to use one for active data and one to show
: David Moore [mailto:[EMAIL PROTECTED] Sent:
Wednesday, August 20, 2008 1:18 PM To: CF-Talk Subject: Query Too Complex for
Access? I know I am setting myself up for another Query too complex issue,
so before I start I thought I would ask for suggestions. I run into this when
I have
I am currently using the SQLprev.cfm from Jochem to stop the onslaught of
superfluous bandwidth suckage from my server, but was wondering what the
difference would be with this one. I am not looking to start a my SQL
Injection blocker is better than yours, yet trying to educate myself on just
'some' of the records
in getActiveWorks? If so, send your CFIF statement as we'll have to modify
what I sent you earlier. Dave -Original Message- From: David
Moore, Jr. [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 1:37
PM To: CF-Talk Subject: RE: Query Too Complex
When you say Update Your Code, are you saying using cfqueryparam? But even
so, the SQL injection still will use up countless resources instead of cutting
it off early. So, go back and fix 1,000's of lines of code I have developed
over the last 'upteen' years or stop it before it starts? Is this
And this is where I am. I have been using CF since 4.5. Very Scary. Glad I have
found this list. I am sure to learn a lot. I will try to read and not bother.
Thanks for the SMACK DOWN. I will start to write it in and become more learned.
I can say, just in the last weeks since joining I have
Justin,
I certainly don't feel picked on. I feel blessed to have a place where I can
learn from people who do know so much. And you are right. I (we) only seem to
learn under fire. I am a one man business owner in a small town with limited
resources and time. 10 hour days, work weekends, what
The only way I found the SQL Injection Attack was my server kept crawling to a
dead hault. I looked in SeeFusion (some softwear I purchased that lets me see
what is going on live with the websites) and I noticed that the sites Total
Time just kept going up and never resolving, basically every
Well, it is my goal :) not there yet... Subject: Re: SQL injection attack on
House of Fusion From: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date:
Wed, 20 Aug 2008 16:59:26 -0500 is cfqueryparam something a lot of
programmers really use? Only the good ones. ;) Thanks, Eric
David
a lot of programmers really use?
Only the good ones. ;) Thanks, Eric David Moore, Jr. wrote: When
you say Update Your Code, are you saying using cfqueryparam? But even so,
the SQL injection still will use up countless resources instead of cutting it
off early. So, go back and fix 1,000's
Consider me connected. At the same time, I will try not to just suck the life
out of the list and provide substance where I can. I was a morning radio
announcer for 20 years before becoming a web programmer, so if you can't
remember the name of that song or artist - just ask. :)
As for the
Mary Jo,
Sorry. Didn't see all that. First time using this kind of post. Here's
another smack down for youit would be nice if you could remove all the
extra quoted stuff on your poststake a look at the online web archives, it
really makes a mess of the thread! Will do better in the
Actually I am a pacifist at heart and always try to not lose my temper (serves
me well with customers, particularly the endlessly annoying ones!)
LOLOL. I am actually a moderately conservative liberal. I believe in loosing my
temper only when I know I can't find it.
As for not knowing what
OK. I thought it was from you. I was sent an email with the link to SQLprev.cfm
in an email and they referenced I use your suggestion in the email as well. I
stuck the two together. David Moore, Jr. wrote: I am currently using the
SQLprev.cfm from Jochem
Jochem Wrote? The what from whom
Melissa,
I am not sure, but it sounds like you may be new to ColdFusion. If so, you have
chosen a great language for programming dynamic websites quickly and easily. If
I am wrong, please forgive me. Otherwise, I would recommend you get a book by
Ben Forta on Adobe ColdFusion. You will
Melissa,
This would be in your Query statement.
Insert INTO STATES
Where State = '#URL.State#'
David G. Moore, Jr.
UpstateWeb LLC Subject: Re: Creating a database with repeated information
From: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Mon, 18 Aug 2008
11:05:02 -0400 Thanks
Ooopss. Subject: Re: Creating a database with repeated information From:
[EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Mon, 18 Aug 2008
22:19:03 +0700 hmmm... INSERT with a WHERE cause? Didn't you mean UPDATE?
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/David Moore, Jr
hmmm... INSERT with a WHERE cause? Didn't you mean UPDATE?
OK. SO I am a litle nervous. All these big dogs of CF and I am trying to pitch
in.
Anyway. Shouldn't this be handled in the Query statement? I will let someone
else handle the specifics now that I have completely screwed it up
Sorry for the problems with the House of Fusion site. We've been under
massive attack by sql injection bots and I've just been able to get a handle
on it. A fast solution to the problem is this:
cfif findnocase(';DECLARE, cgi.query_string)cfabort/cfif
It works unless you have a few hundred attacks
I am new to the post, but I have been programming in CF for over 10 years and
know some of you from the CF Forums.
I am getting slammed with this crud as well on over 30 of my websites. Any
suggestions as how to handle this for multuple sites on 1 server? I just
discovered the issue as it
I haven't mentioned this before because I do believe that filtering
request URLs is the wrong approach
Care to elaborate on this?
Denstar, dig out your neo-security.xml file. In my Windows CF8 standalong
install it is located in C:\ColdFusion8\lib\neo-security.xml
Look at the following
80 matches
Mail list logo