of hey admin take care of server. We saw it on one internal dev server
How did The World get access to your internal systems ?
--
Helping to evangelistically orchestrate granular edge-of-your-seat
architectures as part of the IT team of the year, '09 and '08
Tom Chiverton
Developer
Tel:
HI everybody,,
Am stucked... I have a query with 9 rows. I need to store every row into a
different distinct variable. my query is listed below
cfquery name=getcs datasource=#datasource#
SELECT COUNT(s.id) AS cscount
FROMSociety s
WHERE s.gr='cs'
group by s.asst
/cfquery
cfoutput
I need to store every row
into a different distinct variable.
You probably don't, and should instead be using an array.
MyValues = ListToArray( ValueList( MyQuery.ColumnName ) )
Then you can do MyValues[1] to MyValues[9] to get at the variables.
If you *really* need to create individual
Thanks will do that then
I need to store every row
into a different distinct variable.
You probably don't, and should instead be using an array.
MyValues = ListToArray( ValueList( MyQuery.ColumnName ) )
Then you can do MyValues[1] to MyValues[9] to get at the variables.
If you
Hello,
I have read just about everything I can (searched just about all forums, adobe,
etc) and can't find an answer.
We are running CF 8 Standard and FusionReactor 3 and have a heavy load
application running but we are starting to get SQL deadlocks.
Error Executing Database Query.
Hello,
I have read just about everything I can (searched just about all
forums, adobe, etc) and can't find an answer.
We are running CF 8 Standard and FusionReactor 3 and have a heavy load
application running but we are starting to get SQL deadlocks.
Error Executing Database Query.
Just to throw out another solution, you can get the same result you
initailly tried by doing the following:
cfloop query=getcs
cfset variables[rowgetcs.currentRow] = getcs.cscount /
/cfloop
On Thu, May 28, 2009 at 7:58 AM, Peter Boughton bought...@gmail.com wrote:
I need to store every
Thanks, Will!
I don't remember using the group function as part of a query like that.
I had always just looped one query around another. When did the group
function show up as a query output function in CF? CF5? (Well, I guess
that's
what I get for going from CF 4.5 straight to CF 8...or was
I have a request from a client to integrate a CF application with
InfusionSoft's API. Any CF programmers done any work with InfusionSoft API and
CF?
Thanks,
Dave
~|
Want to reach the ColdFusion community with something they
Umm .. no .. it's in there ..
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
map.addOverlay(marker);
missing ;
maybe
On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear
Hey gang -
Having some issues with cfflush not... flushing. :P
Same page, same code, running on two different servers - flush works on
one, not the other.
Both servers are sporting CF8, but the underlying platform is different
- Windows 2k server (working) vs. Windows 2003 server (not
And finally, you could simpy reference the original query using array
notation (e.g. getcs[cscount][1], getcs[cscount][2] etc) and avoid
the extra work.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/5/28 Scott Stroz boyz...@gmail.com:
Just to throw out
Thanks Alan ...
Here is the rendered code ...
script
src=http://maps.google.com/maps?file=apiamp;v=2amp;key=ABQIiM57Lca47g
ZUZAGU9VAgzxSgDYqnW_JCrkwCqigUjd1zUJsCbRRgKmt_eNGlKyP-RjRNHj7jzDkmgA
type=text/javascript/script
script type=text/javascript
//![CDATA[
function
Thanks Paul, but I put the ; in and no change
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
map.addOverlay(marker);
missing ;
maybe
On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear
I assume you are not getting any javascript errors?
--
Ryan
On Thu, May 28, 2009 at 7:54 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
Umm .. no .. it's in there ..
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
I have a cfreport that needs to have images in the footer. The images
are working fine if I output the report in PDF or Flashpaper, but
don't show up in RTF or Excel (RTF is the needed output). Things I've
tried:
-using URLs, file paths, and blobs from the db...same result with each
-using
Is it possible to use the W3C validator tool at: http://validator.w3.org/ to
check cfm files?
Terry Troxel
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
Is it possible to use the W3C validator tool at: http://validator.w3.org/ to
check cfm files?
Yes, just put in the URL to your file. You can't upload a file to it,
because CFML is not valid HTML or XHTML. The validator will have to
receive the output of your .cfm file. You could, I guess, save
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am wondering
if I can create my own searchable list from query results and replace the list
below with my new list.
Thanks for any suggestions.
How difficult was your ftp user/password?
--
Ryan
On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote:
It's a demo server we use to show clients works in progress, its behind our
firewall but is open on 80 for this purpose.
-Original Message-
From: Tom
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all')
]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by
It's a demo server we use to show clients works in progress, its behind our
firewall but is open on 80 for this purpose.
-Original Message-
From: Tom Chiverton [mailto:tom.chiver...@halliwells.com]
Sent: Thursday, May 28, 2009 4:24 AM
To: cf-talk
Subject: Re: (ot) Hacked by Fatal Error
OK, I answered part of my own question. The RTF output has a empty
box placed over the image for some reason (I mistakenly thought that
was its attempt to show the image). Now to figure out how to have it
not show that box.
On Thu, May 28, 2009 at 9:08 AM, Jim Wright wright...@gmail.com wrote:
Nice Stephane.
I did one like this: (Way too much code obviously but it works)
cfparam name=city_list default=
cfloop query=getCities
cfif getcities.recordcount NEQ getcities.currentrow
cfset city_list = city_list '' getcities.city ','
cfelse
cfset city_list = city_list ''
Rick,
If it looks unclear, you can also do the following:
cfoutput query=getStuff group=theTitleFieldHere
h1#someTitleField#/h1
cfoutput group=theDetailField
p#theDetailField#/p
/cfoutput
/cfoutput
Note that the inner CFOUTPUT has 'group' attribute, but no 'query' attribute.
The plain
I know how to use cfobject type=webservice and AddSOAPRequestHeader() to
generate a SOAP request like this:
s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/;
s:Header
h:UserName xmlns:h=[namespace]username/h:UserName
h:Password xmlns:h=[namespace]password/h:Password
Thanks
The list creation does exactly what I need it to but the cfoutput... does
work.
It's not giving an error but the autocomplete does nothing.
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [
I would have considered it strong - 9 chars, letters/numbers/other chars
mixed case.
The ftp logs don't show anything though. I looked into turning off webDav
on it since its IIS 5.0. I just wish I felt better about knowing how they
got in.
-Original Message-
From: Ryan Letulle
Final answer, if anyone ever has this issue: There is a Transparency
attribute that defaults to Opaque on the image object. In Flashpaper
and PDF, the image shows up with that set...in RTF, it puts a box over
top of it.
~|
How does your source look?
--
Ryan
On Thu, May 28, 2009 at 9:25 AM, Torrent Girl torrentg...@gmail.com wrote:
Thanks
The list creation does exactly what I need it to but the cfoutput... does
work.
It's not giving an error but the autocomplete does nothing.
I would suggest doing
Any chance they were an old employee etc that knew the password?
--
Ryan
On Thu, May 28, 2009 at 9:34 AM, Scott Mulholland smulholl...@aimg.comwrote:
I would have considered it strong - 9 chars, letters/numbers/other chars
mixed case.
The ftp logs don't show anything though. I looked
Have you tried to dump the value of the list to see if it matches the format of
the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput;
Yes I dump it and the list is correct. I'll try your other sugg...
Have you tried to dump the value of the list to see if it matches the
format of the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var
Would it look like this?
cfoutput
script type=text/javascript
var scriptList = '#myList#';
$(document).ready(function() {
$(##country).autocomplete(
data/country.cfm,
Yes, i guess... if still not working try displaying an alert of the var in the
script, to see what's wrong with it
Would it look like this?
cfoutput
script type=text/javascript
var scriptList = '#myList#';
On Thursday 28 May 2009, Scott Mulholland wrote:
I would have considered it strong - 9 chars, letters/numbers/other chars
mixed case.
The ftp logs don't show anything though.
If they brute forced it, they could alter the logs after the fact.
You can not trust anything on that box, remember
So everything works until you change the list? Something must be wrong with
the list format. Extra or missing comma.
--
Ryan
On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote:
Would it look like this?
cfoutput
script type=text/javascript
Yes, this is how I am formatting the list
cfset myList = [
ListQualify(ValueList(myQuery.NameofField),'',',','all') ]
So everything works until you change the list? Something must be wrong with
the list format. Extra or missing comma.
--
Ryan
On Thu, May 28, 2009 at 9:39 AM, Torrent
Thanks for the explanation, Jason.
It just seems so counter-intuitive to have cfoutput's within
cfoutput's...that's
always been a no-no.
So, was the cfoutput group... function created to address the very problem
of having to loop a query within a query? And when did CF first get this
function?
After you open the page in your browser look at the source for the list.
Make sure it doesn't say something like #mylist# :). There must be
something off there.
--
Ryan
On Thu, May 28, 2009 at 10:01 AM, Torrent Girl torrentg...@gmail.comwrote:
Yes, this is how I am formatting the list
Just asking how other folks would go about this, in general...
Getting ready to start on a new site. To get everything to work like the
client wants, almost every single site URL is going to have to go
through a IIS rewrite rule so everything looks like:
www.mysite.com/contact
Did that and the list is showing correctly
After you open the page in your browser look at the source for the list.
Make sure it doesn't say something like #mylist# :). There must be
something off there.
--
Ryan
On Thu, May 28, 2009 at 10:01 AM, Torrent Girl torrentg...@gmail.comwrote:
It's actually been there since 4.0, I believe. I know they added the
groupCaseSensitive attribute in 4.5, so the group option was in place by
that point. Essentially it's a way to get your output to follow your SQL
groupings, when that sort of thing is necessary. So like doing a blotter
Scott Mulholland wrote:
The ftp logs don't show anything though. I looked into turning off webDav
on it since its IIS 5.0. I just wish I felt better about knowing how they
got in.
WebDav is a high candidate. It was enabled by default in IIS5. It uses
port 80 and their where known
Just asking how other folks would go about this, in general...
Getting ready to start on a new site. To get everything to work like the
client wants, almost every single site URL is going to have to go
through a IIS rewrite rule so everything looks like:
www.mysite.com/contact
The ftp logs don't show anything though. I looked into turning off webDav
on it since its IIS 5.0. I just wish I felt better about knowing how they
got in.
Have you looked at the IIS server logs? Most simple defacements aren't
really anything more, and the logs are probably intact. Of
Wow! That is a great function that I didn't even know existed! And how
many
times have a simply resorted to looping one query over another
unnecessarily!
And to be able to nest this multiple levels deep is great!
Finally crawling out from under my rock and into the light of day!
Doh!
On
why dont you try the same ajax method that is used with the city local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select
why dont you try the same ajax method that is used with the city local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select
Don't feel bad. I never used it either. So at least there's 2 of us.
--
Ryan
On Thu, May 28, 2009 at 10:51 AM, Rick Faircloth
r...@whitestonemedia.comwrote:
Wow! That is a great function that I didn't even know existed! And how
many
times have a simply resorted to looping one query
Interesting problem.
CFPDFFORM works wonderfully for the most part, except when it does what it's
supposed to do: insert data into pdf forms.
I'm finding that often times, letters like q, y, or other letters that hang a
bit, get cut off.
Additionally, alignment seems screwy. Many times a
I agree with Dave. I've used URL rewriting on two projects now (including my
own blog: www.andymatthews.net) and it's best to put the rules in place
right away. Remember that without the rules your links would have to point
to the .cfm versions rather than the clean version so it's really going
Hi everybody..
Have a problem when i modify a date on a cfinput
cfinput
NAME=DateEnd
TYPE=TEXT
Value=#DateFormat(Getall.DateEnd, dd/mm/)#
validate=eurodate
width=150
I have a validate eurodate.. example I have a date that i should modify
On Thu, May 28, 2009 at 12:23 PM, alex poyaoan ap.cli...@tiscali.it wrote:
cfinput
NAME=DateEnd
TYPE=TEXT
Value=#DateFormat(Getall.DateEnd, dd/mm/)#
validate=eurodate
width=150
always insert dates in the following format...
-mm-dd
I tried it and it works fine but is it possible to type only the mmdd
without dashes?
On Thu, May 28, 2009 at 12:23 PM, alex poyaoan ap.cli...@tiscali.it wrote:
cfinput
NAME=DateEnd
TYPE=TEXT
Value=#DateFormat(Getall.DateEnd, dd/mm/)#
validate=eurodate
LOL, don't you just love finding something new that makes life (or at least
coding) easier?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
On Thu, May 28, 2009 at 12:41 PM, alex poyaoan ap.cli...@tiscali.it wrote:
I tried it and it works fine but is it possible to type only the mmdd
without dashes?
how about if it works with dashes you just use dashes?
Always lookin to save keystrokes. :)
--
Ryan
On Thu, May 28, 2009 at 11:50 AM, Jason Fisher ja...@wanax.com wrote:
LOL, don't you just love finding something new that makes life (or at least
coding) easier?
~|
Want
Maybe we should start a club... :o)
On Thu, May 28, 2009 at 12:02 PM, Ryan Letulle bayous...@gmail.com wrote:
Don't feel bad. I never used it either. So at least there's 2 of us.
--
Ryan
On Thu, May 28, 2009 at 10:51 AM, Rick Faircloth
r...@whitestonemedia.comwrote:
Wow! That
why dont you try the same ajax method that is used with the city
local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select
Thanks
Tried your code.
I am closer but still not working correctly
My 'searching' image shows up and turns but I get no results.
why dont you try the same ajax method that is used with the city
local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug =
Hi all,
I am stuck. I have never had this happen before and I cannot figure it out.
Hopefully there is enough info below to see what I am not seeing
Any help would be greatly appreciated.
First of all when I connect to this directly through the cfc
, i.e. not through a webservice
everything
Hi all,
I am stuck. I have never had this happen before and I cannot figure it out.
Hopefully there is enough info below to see what I am not seeing
Any help would be greatly appreciated.
First of all when I connect to this directly through the cfc
, i.e. not through a webservice
everything
coded like spaghetti with meatballs.
That is a good one.
The discussion with my colleagues is that some want to refactor the whole
project in a framework. I think it's to much work, and you can better start
from scratch. My other colleagues disagrees.
I just got done doing something very
Hello,
What cfsqltype in a cfqueryparam should I use to insert now() into a mySql
database (datetime data type) so it keeps the date and time?
cf_sql_timestamp and cf_sql_date only seem to hold the date, not the time when
I insert.
What cfsqltype in a cfqueryparam should I use to insert now() into a
mySql database (datetime data type) so it keeps the date and time?
cf_sql_timestamp. You might double check your syntax and the data type. It
works fine for me.
INSERT INTO Table (DateTimeColumn)
VALUES ( cfqueryparam
What cfsqltype in a cfqueryparam should I use to insert now() into a mySql
database
(datetime data type) so it keeps the date and time?
cf_sql_timestamp and cf_sql_date only seem to hold the date, not the time
when I insert.
You should use CF_SQL_TIMESTAMP, but you'll need to make sure
Andy Matthews wrote:
I agree with Dave. I've used URL rewriting on two projects now (including my
own blog: www.andymatthews.net) and it's best to put the rules in place
right away. Remember that without the rules your links would have to point
to the .cfm versions rather than the clean
I'm currently attempting to concatenate several wave files into a single wave
file using java with ColdFusion. I am using the java code here -
http://stackoverflow.com/questions/653861/join-two-wav-files-from-java - as a
basis for my ColdFusion cfscript code below (apologies for formatting in
Dumping the available methods on AudioFileFormat and putting around
the javadocs seems to imply that Type.WAVE is a static property,
which I understand CF can have problems accessing??
Type is an inner class. You can use $ to reference it:
cfset AudioFileFormatType = createObject(java,
Type is an inner class. You can use $ to reference it:
Awesome - works like a charm. Thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Hi,
I'm moving my CF applications to a new dedicated server, and I need to
both send messages and receive,
for several users under several domains.
Any suggestion ?
~|
Want to reach the ColdFusion community with something
Google Apps
Hi,
I'm moving my CF applications to a new dedicated server, and I need to
both send messages and receive,
for several users under several domains.
Any suggestion ?
~|
Want to reach the ColdFusion community with
On Thu, May 28, 2009 at 7:18 PM, Claude Schneegans
schneeg...@internetique.com wrote:
Hi,
I'm moving my CF applications to a new dedicated server, and I need to
both send messages and receive,
for several users under several domains.
Any suggestion ?
Or SmarterMail
Trying to get Ionic IsapRewrite working locally so I can develop locally
without having to put every freaking thing out to the server...
Running:
XP Pro
IIS 5.1
Stuff is set up thusly:
1. Since IIS 5.1 only allows one site, I've got my default site as the
main wwwroot directory with
I second Google Apps. You don't want the spam traffic headache. I am
slowly moving everyone off of a mail server that I manage because of spam.
--
Ryan
On Thu, May 28, 2009 at 7:20 PM, Casey Dougall
ca...@uberwebsitesolutions.com wrote:
On Thu, May 28, 2009 at 7:18 PM, Claude Schneegans
On Thu, May 28, 2009 at 8:28 PM, Ryan Letulle bayous...@gmail.com wrote:
I second Google Apps. You don't want the spam traffic headache. I am
slowly moving everyone off of a mail server that I manage because of spam.
--
Ryan
Also note, coldfusion 8 can send mail out through google
So what's the actual problem?
Don't know if this is it, but it looks like you're missing a slash
after the caret in your RewriteRule. Should be ^/att... not ^att...
On Thu, May 28, 2009 at 5:24 PM, Les Mizzell lesm...@bellsouth.net wrote:
Trying to get Ionic IsapRewrite working locally so I
I am using cfmail to send out emails. For some users it goes to the junk mail
folder. The email content has a link. When I remove the link it goes to the
Inbox. From address is a valid address.
Thanks,
~|
Want to reach the
Can you get the email users to put your from address in their contact list?
--
Ryan
On Thu, May 28, 2009 at 7:56 PM, Vineetha Varghese vvargh...@pace.eduwrote:
I am using cfmail to send out emails. For some users it goes to the junk
mail folder. The email content has a link. When I remove
I can request, but not all user will do so. The emails are part of a workflow
and I need to make sure that they all do go to the Inbox.
V
Can you get the email users to put your from address in their contact list?
--
Ryan
On Thu, May 28, 2009 at 7:56 PM, Vineetha Varghese
Do you have an SPF (http://www.openspf.org/) record in your DNS? If
not, you should add one. Hard to say whether it'll help or not in
this particular case, but it's a good thing to have set up if you're
going to be sending out email.
cheers,
barneyb
On Thu, May 28, 2009 at 5:56 PM, Vineetha
I've run into this curious problem recently, since switching to Windows 7
RC, concerning deleting
or renaming uploaded files.
I was trying to sort out this problem through a development site when I
decided to delete all the files
that I had uploaded to my local system and couldn't delete through
Someone reported the exact same problem either here or on the Railo Group
yesterday. Apparently it's a new window's feature. :)
--
Ryan
On Thu, May 28, 2009 at 9:36 PM, Rick Faircloth r...@whitestonemedia.comwrote:
I've run into this curious problem recently, since switching to Windows 7
I wonder if the new feature is going to be a problem with Windows 2008
Server?
On Thu, May 28, 2009 at 10:50 PM, Ryan Letulle bayous...@gmail.com wrote:
Someone reported the exact same problem either here or on the Railo Group
yesterday. Apparently it's a new window's feature. :)
--
Ryan
You could use Apache locally to get the rules in place for your dev
site and then put in place equivalent rules on the prod IIS server.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/5/29 Les Mizzell lesm...@bellsouth.net:
Andy Matthews wrote:
I agree
On Fri, May 29, 2009 at 1:18 AM, Claude Schneegans wrote:
I'm moving my CF applications to a new dedicated server, and I need to
both send messages and receive,
for several users under several domains.
Postfix. If you want to offer IMAP as well and total mail volume goes
over 50 GB I would
87 matches
Mail list logo
