Re: New CF8 vulnerability
A hotfix was just released for this: http://www.adobe.com/support/security/bulletins/apsb09-09.html -Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Restricted access to non cf files using cf
Store them outside of the webroot and use cfcontent to serve them to the browse when necessary. -Ryan Anastassios Hadjicrystallis wrote: I have a question that its answer may be interesting and usefull for many CF developers. Here it is. I have a site, and I have a folder where access is restricted and I have a login page asking for user name and password. As usually I chech these access data in my database and I give or give not access to the content of this folder. Nothing special until now. Let's suppose The root folder of my site isC:\MySite The restricted access folder isC:\MySite\MembersFolder In the root folder I have the login page C:\MySite\login.cfm In the restricted access folder and its subfolders I have various CF pages e.g. -- C:\MySite\MembersFolder\page1.cfm , -- C:\MySite\MembersFolder\folder2\page2.cfm etc Whenever someone logs in successfully I keep a session variable with his name, userid etc blah blah. So whenever someone tries to access a restricted access page e.g C:\MySite\MembersFolder\page1.cfm I check if there is or there is not the session variable of his access. If the session variable exists I give access, otherwise I send him to the login page. Again nothing special. Just typical proccess. My question is. All the above can restrict access to any CF page in the folder C:\MySite\MembersFolder BUT what about any other content in this folder e.g PDF, jpg, doc files etc ? Because someone not logged in can just write in his browser: http://www.MySite.com/MembersFolder/MyBook.pdf and can get the PDF file without loggin!!! Any idea how can I restrict access to any kind of content (htm, cfm, pdf, jpg, doc xls etc) using coldfusion ? (Well I know I can store these kind of files in binary fields of the database instead of storing them as files, but I don't think it's realistic. These files pdf, doc, tiff, xls can be many Mb and it's not realistic to read these huge files from the database in middle or high traffic site.) So any other idea? Thanks in advance for your response. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Sport Software
With Railo gaining more momentum now, I think we'll see some cheaper ColdFusion hosting options. And you get your own administrator! Alurium has Railo hosting starting at $6.75/month (200MB storage, 5GB bandwidth). And a 60 day free trial. http://alurium.com -Ryan Paul Alkema wrote: I love ColdFusion, but when people talk shared hosting there's no comparative to between CF shared hosting and php shared hosting. Here is Mike Kear's Offer of CF Hosting According to his website. CF Shared Hosting afpwebworks.com - Advertised Hosting Plan Monthly price - $15/M Disk Space - 20mb Bandwidth - 500mb/mo MySQL Databases - None PHP Shared Hosting alkemadesigns.com/hosting - Advertised Hosting Plan Monthly price - $4.95/M Disk Space - UNLIMITED Bandwidth - UNLIMITED MySQL Databases - UNLIMITED I'm not insulting Mike Kear's offer.. at all, I actually think this is low for coldfusion hosting. The matter of the fact is, is that good CF shared hosting costs more than good PHP hosting. If I can get my clients to get a dedicated CF server I always encourage them to do so, but if they can't afford it there is no comparison between PHP shared hosting and CF shared hosting. Also, I think another downside to CF shared hosting is the lack of control, between Cpanel, php.ini file and your .htaccess file you have so much control of your hosting, but with CF hosting in order to get things changed many times you have to call the hosting company ask them to change IIS setting etc... My recommendation is, if you're looking for shared hosting, use a PHP server and learn PHP. If your company can afford it, go with a dedicated CF server because CF is so much easier to write, easier to read and development time is so much faster. :) Paul Alkema http://www.AlkemaDesigns.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and RSS
XMLFormat() does NOT clean up all invalid XML characters, it still leaves in a lot of bar chars that will mess up XML readers. I think there is a function on cflib that does a better job, I wrote one too a while back: http://www.stillnetstudios.com/2008/09/14/cleaning-up-non-ascii-characters/ -Ryan Dominic Watson wrote: You may like to try: description![CDATA[#post#]]/description However, the xmlformat will definately be cleaning up any invalid xml characters; are you using it in the title, etc? Perhaps it could be an encoding issue. Dominic 2009/6/26 bill turner bill.tur...@selectcomfort.com: description#xmlFormat(post)#/description ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Phillip I haven't followed this whole thread, but can you really not set mappings or do you just not have access to the Administrator? In CF8, Railo and OpenBD you can set mappings in your Application.cfc file. -Ryan Phillip Vector wrote: Ah.. That would explain it. My hosting plan can't set mapping. Though, I wouldn't think it would be a mapping issue, but *shrugs* On Thu, Jun 18, 2009 at 1:49 PM, Dave Wattsdwa...@figleaf.com wrote: Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How would you approach this? Shared Calender? Any volunteers?
How about pushing your data in to Google Calendar. They have a nice API, and you can easily embed the calendar with a snippet of html/js. Additionally end users can embed your events into their own personal Google Calendar to easily keep track of events. If you don't want to go that route, just give them a snippet of html/js or an iframe that pulls the calendar in from your site. Then you have full control over it and will never have an issue of getting all the other sites to update to the latest calendar code or whatever. -Ryan Al Musella, DPM wrote: I created a group of 50 brain tumor organizations and need to create a calender that each member can insert into their own website, but takes the data from my website.. I see a lot of sample code out there for creating the actual calander, but I am thinking about how to actually implement it to make it easy for people to put into their own websites.. what would be best and easiest for the members? Maybe use an iframe with the source being the calander on my website? maybe a flash or flex applet? I could do the iframe with a standard cf page myself.. but I never used flex and just basic stuff with flash. Anyone want to volunteer to help on this? Contact me privately muse...@virtualtrials.com Al ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reducing a query result
You can do something similar with SQL Server 2005 http://www.stillnetstudios.com/2008/11/12/pagination-mssql-2005/ -Ryan Andy Matthews wrote: If you're using mySQL, then look into the LIMIT keyword: SELECT [columns] FROM [tableName] LIMIT [totalRecords], [startingRow] This way you ONLY get the data you want. You could easily tie this into a data grid via Ext (or jQuery) so that new pages call only the data for that page. Here's one of the preeminent jQuery versions: http://www.flexigrid.info/ And a tutorial written by a coworker of mine on Ext data grids: http://blog.cutterscrossing.com/index.cfm/2007/4/24/My-First-ExtJS-DataGrid- Pt-1 andy -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, June 04, 2009 10:07 AM To: cf-talk Subject: reducing a query result Say I have a query returned with 500 records. Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 etc? I talking physically reducing the query object. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating appopriate transaction IDs
I just fired up Tomcat and tried getTickCount() on all 3 CFML engines within a second or two of each other. OpenBD: 276282Railo: 1244157288529cfusion: 1244157287685 Running date +%s on my linux box gives me 1244157286 so it looks like cfusion and Railo do indeed return milliseconds since the epoch. This may not have always been the case, hence the fuzzy documentation. -Ryan From: Peter Boughton bought...@gmail.com Sent: Thursday, June 04, 2009 4:43 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Generating appopriate transaction IDs it resets back to 1 every time the server restarts. Huh? I was under the impression it was number of milliseconds since the unix epoch (1-Jan-1970). Certainly that's what Railo is returning, and no resetting after restart there. I'm 99% certain that CF7 acts in the same way. The CF docs are a bit vague/contradictory on it though: Description - Returns the current value of an internal millisecond timer. Returns - A string representation of the system time, in milliseconds. Usage - The value of the counter has no meaning. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating appopriate transaction IDs
Eh sorry my webmail sucks, lets see if this one comes through formatted better. __ I just fired up Tomcat and tried getTickCount() on all 3 CFML engines within a second or two of each other. OpenBD: 276282 Railo: 1244157288529 cfusion: 1244157287685 Running date +%s on my linux box gives me 1244157286 so it looks like cfusion and Railo do indeed return milliseconds since the epoch. This may not have always been the case, hence the fuzzy documentation. -Ryan From: Peter Boughton Sent: Thursday, June 04, 2009 4:43 PM To: cf-talk Subject: Re: Generating appopriate transaction IDs it resets back to 1 every time the server restarts. Huh? I was under the impression it was number of milliseconds since the unix epoch (1-Jan-1970). Certainly that's what Railo is returning, and no resetting after restart there. I'm 99% certain that CF7 acts in the same way. The CF docs are a bit vague/contradictory on it though: Description - Returns the current value of an internal millisecond timer. Returns - A string representation of the system time, in milliseconds. Usage - The value of the counter has no meaning. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: New Topic: Custom content based on environment.
I think it would easiest to do this within ColdFusion, like body bgcolor=#DetermineCorrectBGColor()# Or something similar with CSS: body id=#DetermineCorrectBodyID()# That function could then look at the hostname, perhaps compare it to a list of ones that should be displayed specially, and return the proper ID value. But it can be done with Apache as well. Look at the mod_ext_filter module. It looks like you could do something similar to this in the virtual hosts you want to appear differently: # this changes the body id from normal to special in this virtual host ExtFilterDefine fixtext mode=output intype=text/html cmd=/bin/sed s/body id=\normal\/body id=\special\/ Location / SetOutputFilter fixtext /Location http://httpd.apache.org/docs/2.0/mod/mod_ext_filter.html -Ryan Ian Skinner wrote: Is it possible, and if so any links to help/hints/tutorials, to have Apache server modify content before it is sent to a browser. We would like to be able to tell some virtual hosts, but not others to change the background color style. The idea being to visually distinguish the staging virtual host form the production host. Some challenges for this is that both hosts actually get there styles from the same source and much of the content is plain HTML files so the usual CF tricks are not available. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New Topic: Custom content based on environment.
Another idea - you could override a stylesheet on the staging sites. Put something like this in the those virtual hosts: Alias /path/to/one-of-my-stylesheets.css /special-cfm-stylesheet.cfm Then in special-cfm-stylesheet.cfm you read in the normal stylesheet, append something to that text that will alter the body tag the way you want, the cfcontent the entire text to the browser. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321894 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Anyone heard of CF_WordCount?
I am working on rebuilding a site for a client whose server crashed. They are missing a tag named CF_wordcount. The only occurrence of this in google is on Adobe's developer exchange: http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetailextid=115 But although that entry is for CF_WordCount, when you try to download it all you get is a DLL. As far as I know a Custom Tag can't use a DLL, that would have to be a CFX tag. There's also no documentation, no examples, and all the links are broken. It also has a date of 1997 on it so I doubt it will run on CF8. It shoudn't be too hard to duplicate (probably using ListLen()? ) but if we could find the missing drop in replacement that would be great. I'm guessing this might have been something custom they did or had done for themselves anyway though. But if anyone has any info on a CF_WordCount custom tag please let me know. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Startup scripts on Linux
I'm not seeing a problem with your script. When I change it to echo out
the start up commands instead of running them, this is what I get:
The ColdFusion 8 server is starting up and will be available shortly.
su cfuser -c nohup /opt/jrun4/bin/jrun -start cfusion -config
jvm.config_dev /opt/jrun4/logs/cfusion-event.log
su cfuser -c nohup /opt/jrun4/bin/jrun -start dev_inter -config
jvm.config_dev
/opt/jrun4/servers/dev_inter/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
su cfuser -c nohup /opt/jrun4/bin/jrun -start dev_www -config
jvm.config_dev
/opt/jrun4/servers/dev_www/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
su cfuser -c nohup /opt/jrun4/bin/jrun -start test_inter -config
jvm.config_test
/opt/jrun4/servers/test_inter/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
su cfuser -c nohup /opt/jrun4/bin/jrun -start test_www -config
jvm.config_test
/opt/jrun4/servers/test_www/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
==
ColdFusion 8 has been started.
ColdFusion 8 will write logs to /opt/jrun4/logs/cfusion-event.log
==
It all looks good. What happens if you just try to run one of those
commands directly, like this:
su cfuser -c nohup /opt/jrun4/bin/jrun -start test_www -config
jvm.config_test
/opt/jrun4/servers/test_www/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
Does that cause two instances to start up?
-Ryan
Phillip Duba wrote:
Hey everyone,
I'm trying to create/modify the coldfusion8multi start startup scripts to
utilize a different jvm.config folder for each instance of ColdFusion 8
that's been created. Essentially, I have dev and test instances on the same
box, each with it's own jvm.config. The script is below, compiled from
documentation from Adobe and various blog posts/other emails (thanks Steve
Erat!). What I see when I use the script to start the services, is that all
the services get started with the -config setting, but then a duplicate set
are spawned without the -config and the first set of services are then
stopped. Here's the abbreviated script:
#!/bin/sh
# MultiServer cfusion instance Init-Script
CF_DIR=/opt/jrun4
RUNTIME_USER=cfuser
devservers=dev_inter dev_www
testservers=test_inter test_www
cfstart() {
echo The ColdFusion 8 server is starting up and will be available shortly.
su $RUNTIME_USER -c nohup $CF_DIR/bin/jrun -start cfusion -config
jvm.config_dev $CF_DIR/logs/cfusion-event.log
#su $RUNTIME_USER -c nohup $CF_DIR/bin/jrun -start admin -config
jvm.config_dev $CF_DIR/logs/admin-event.log
for server in $devservers
do
su $RUNTIME_USER -c nohup $CF_DIR/bin/jrun -start $server -config
jvm.config_dev
$CF_DIR/servers/$server/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
done
for server in $testservers
do
su $RUNTIME_USER -c nohup $CF_DIR/bin/jrun -start $server -config
jvm.config_test
$CF_DIR/servers/$server/cfusion.ear/cfusion.war/WEB-INF/cfusion/logs/cfusion-event.log
done
echo
==
echo ColdFusion 8 has been started.
echo ColdFusion 8 will write logs to $CF_DIR/logs/cfusion-event.log
echo
==
}
...
case $1 in
start)
cfstart
;;
...
esac
exit 0
Any insight/help would be appreciated. This is ColdFusion 8.0.1 Enterprise,
64-bit, on RHEL 5 64-bit. Thanks,
Phil
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321748
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for a CF drag drop tutorial
Maya MacDonald wrote: Hi, I am looking for a CF tutorial on how to create a drag and drop list to reorder entries. Thanks! You may find this useful: http://www.stillnetstudios.com/2006/12/31/drag-and-drop-sort-order-with-scriptaculous/ It shows how to pass the resorted values back into ColdFusion. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: would you consider this a bug, CF8
Look at the DaysInMonth() function.
-Ryan
Tony wrote:
cfset date1 = '11/30/2008' /
cfoutput
cfloop from=1 to=6 index = i
cfset date2 = dateAdd('m', i, date1) /
#dateFormat(date2,'mm/dd/')#br /
/cfloop
/cfoutput
very simple code. however, its behaving like i dont want it to.
id rather see it increment by a MONTH, not same day next month.
the output of that code above is:
12/30/2008
01/30/2009
02/28/2009
03/30/2009
04/30/2009
05/30/2009
and i would rather it be
12/31/2008
1/31/2009
2/28/2009
3/31/2009
4/30/2009
5/31/2009
what should i be using? this is weird... i supply m to get month
increment, but
no dice...
thanks
tw
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321220
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Javascript question
Do you have ID=registerForm in your opening form tag? Don't forget it
is case sensitive, too.
-Ryan
Jenny Gavin-Wear wrote:
I have in the header:
script type=text/javascript
function submitForm()
{
document.getElementById(registerForm).submit()
}
/script
and this as the trigger:
input name=roomID type=radio id=radio value=0 cfif session.roomID
is 0checked /cfif onClick=submitForm()
I am getting the error:
document.registerForm.submit is not a function
Could someone tell me what I am doing wrong, please?
tia, Jenny
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320642
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL and CF LAST_INSERT_ID()
You actually *can* run multiple statements in a cfquery if you change a
setting in the datasource. By default MySQL does not let you, this is a
security precaution to protect against SQL injection. This may help:
http://www.petefreitag.com/item/357.cfm
Also note that you can only use CFTRANSACTION with innodb tables, not
MyISAM tables. I don't know if it will throw an error or not, last time
I tried it did not, but there is no transaction going on when you use
these tags with MyISAM tables.
-Ryan
Barney Boisvert wrote:
It doesn't work because you can't run multiple statements in a single
query. If you use two CFQUERY tags (wrapped in a CFTRANSACTION to
ensure connection affinity) it'll work fine. MySQL Front is splitting
the single query into two distinct queries on the semicolon, sending
each to the server independently, and then giving you back the two
results. I.e. it's a client-side optimization, not server
functionality.
cheers,
barneyb
On Tue, Mar 17, 2009 at 10:42 AM, Chad Gray cg...@careyweb.com wrote:
I am trying to use the MySQL function LAST_INSERT_ID() in a CFquery tag and
get this error.
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '; SELECT
LAST_INSERT_ID() AS UserID' at line 4
INSERT users (Foo, Foo1, Foo2)
VALUES ('test', 'test', 'test');
SELECT LAST_INSERT_ID() AS UserID;
If I run this query in MySQL Front it works fine. It returns the last
UserID. If I run this code inside of CFQuery I get the error.
Any ideas why it is not working in a CFQUery tag?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320589
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic SubDomain Creation / Domain Pointing
The subdomains shouldn't take any time to propagate, they should start working instantly. Its when you setup a brand new 2nd level domain (Foo.com) that it can take a while to propagate. When I did this before we dynamically wrote out zone files for the 2nd level domains, and used a wild card for the subdomains. For Apache we just modified one of two apache include files we setup, one for subdomains and one for full domains. I looked at doing it with a rewrite but it didn't work well for us for some reason. Maybe something to do with the logging or something. -Ryan Robert Rawlins wrote: Hello Chaps, We've been working on some ideas for our new reseller panel and one things which really attracts me at the moment is making the panel they sign-in to brand able. I've started so I'll finish ;-) I had an itchy trigger finger this morning. Now in the most part a brandable panel is very simple, allowing users to change the colour scheme, logo and headings in the site is all no problem at all. One thing I have seen done in other applications is the dynamic creation of a subdomain for each user which registers on the server, they can then access the login for that site from that domain, for instance, someone comes and registers with me, and they then have access to their branded panel through thiername.thinkbluemedia.co.uk and they don't have to come through our site. Not only this but they can also mask that subdomain with their own domain such as control.resellersdomain.com or whatever it might happen to be making things even more seamless for the clients which they are reselling too. Now I would assume that the latter part requires them to add CNAME records to their own DNS records and is out of my control, however, the first part is not. How would you guys go about creating these subdomains? presumably I don't want to actually create records in my own domains DNS settings as these would take 72 hours to propagate so can I perhaps do this with some type of URL rewrite? or perhaps a wildcard subdomain and I then use server side code CGI scope variables to to display the correct branding? I'd appreciate your thoughts on this guys, Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
Spam Assassin has nothing to do with apache. And you wouldn't have to run SA on the local server, either. There is a java implementation of spamc (the SA client), you can use that to run the message through a SA server, wherever it may be. -Ryan Claude Schneegans wrote: Setup a local Spam Assassin server? I don't use Apache... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
We tried this, and it didn't work very well. The scoring doesn't range much. It could be an issue with what's in our auto-learn database, but I think it has more to do with the missing message headers. We even tacked on basic headers (to, from, subject), but its still missing the headers from traversing through various mail servers. -Ryan Shannon Peevey wrote: The easiest is to install spamassassin on your local machine and run your messages through them. The issues are: 1. spamassassin auto-learns, so other sites are not going to have the same results as you will. 2. spamassassin also checks headers, so they will play a role in the remote scoring, but will not in your tests. lycka til, speeves On Mon, Feb 23, 2009 at 1:38 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I have a couple of sites which send some news letters to subscribers. A couple of them are blocked by Spam Assassin. I'm looking for some service I could send messages to and that will return the Spam Assassin report and scoring, so I can make sure my news letters are correct. Any hint ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Uploading Really Large Files w/CF
We had a very tough time with uploading large files using ColdFusion. It is probably better now in CF8. But it used to always choke after 100MB or so. One reason for NOT using CF to do this is that is each upload is going to tie up one of your CF threads for who knows how long, it could be quite a while depending on the client's upstream bandwidth. We wrote a little perl script to accept the uploaded file, which then afterwards did an http call to a .cfm page to tell it to process it. -Ryan Che Vilnonis wrote: I have a client that needs to be able to upload large files via a form on his website. The uploaded files will be used to print large banners graphics. Many files will be 100-200 mb in size. - Is this something that can be done with CF? How much will a 100-200 mb file choke the server? - If CF is not the best option (please tell me why), does anyone know of a third party application/service that can be used in conjunction with CF? My guess is that I don't want to use CF to do this. I figured someone with experience doing this will read this and be able to recommend a proper course of action. Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Controlling the Number of Inputs with a Dropdown
You can do this all with JavaScript, it works really slick. I just did this a few weeks ago and wrote a blog post about it:http://www.stillnetstudios.com/2009/01/05/dynamically-adding-and-removing-form-elements/ Or you can go the route you are heading, where you ask for how many, then submit the form, then in CF loop through 1 to N, writing out form elements and naming them as you describe. (firstName_1, etc.). Also embed the how many number as a hidden element. Regardless of which method you use to setup the form, on the form processing page you look for that hidden how many number and loop 1 to it, processing elements along the way. Look in the comments of that blog post, there is a mention in there about how to do this form processing also. -Ryan From: Les Mizzell lesm...@bellsouth.net Sent: Friday, January 16, 2009 5:48 PM To: cf-talk cf-talk@houseoffusion.com Subject: Controlling the Number of Inputs with a Dropdown Basically, I'm looking how to do the below: In the middle of an existing form, there's a dropdown with 1 to 10 as possibe values. How Many guests do you wish to bring? If I select 5, I then need firstNAME_1, lastNAME_1 through firstNAME_5, lastNAME_5 input boxes to appear in place underneath. There's multiple places on the form where this needs to happen. I'm just getting started with Ajax and CF8, but don't even know exactly what I'm looking for to get this to happen and need a pointer in the right direction to figure this out. Been googling for a couple of hours, but haven't found the right place to start yet. Ideas please? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf and asterisk voip
Chad I would start by looking at how the flash panel (from asternic.org) works, I think it has a Perl backend that talks AGI to asterisk. I think AGI works all through pipes, so that will be hard to do with CF. I think you'll need to reach down into Java to do it. -Ryan Chad Gray wrote: Has anyone tried tapping into Asterisk with CF? I would like to look at building a manager interface or a page that at least displays what phone lines are being used or not used. Any code tips or examples would be appreciated. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftoken lost between servers
You might need to turn off setClientCookies and set them manually with cfcookie tags. I've had a similar issue before where when you jump to another server while passing in your own cfid and cftoken, it works for the first request but then the new server hands back NEW cfid/cftoken values and your old session is lost. -Ryan Paolo Piponi wrote: It's been about 4 years since I've been on one of these lists, so here goes: We've been using client variables quite successfully for some years now in a load-balanced environment with a database client variable storage. This has continued to CF8. Although tests made a few months back proved that client variables were holding up across servers, recently I made another check and found them changing. For the test we forced our load-balancer to point from one single server to another (thus forcing the browser to - unknowingly - swap servers) but their session is lost. In short, the CFTOKEN changed. When we swapped the servers again the CFTOKEN changed again. Although JSessionID persists (with a different value) on each server, CFTOKEN is created from scratch on each server change and never recurs. We did recently turn on session management and I'm suspicious this be the cause but would like to hear some opinions before I have to spend much more time replicating the problem in different environments or risking tests in production. Many thanks, Paolo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: POI HSSF problem with CFLOOP
http://pastebin.com. Its made for sharing code thats being discussed on mail lists and the like. Works great. -Ryan Adrian Lynch wrote: You can't post attachments to CF-Talk, can you post it somewhere? Adrian -Original Message- From: Craigsell [mailto:craigs...@charter.net] Sent: 07 January 2009 15:24 To: cf-talk Subject: SOT: POI HSSF problem with CFLOOP I've been working with JAKARTA POI HSSF to create spreadsheets and have run into a strange issue. Certain HSSF methods become unavailable when the workbook is contained in a query loop. An index loop works fine but the query loop throws an error: coldfusion.runtime.java.MethodSelectionException: The selected method addMergedRegion was not found. I've attahced some sample code to illustrate the problem. I am using POI 2.5.1 and 3.1 in CFMX7 -- it fails consistently in both versions. Does anyone have a clue as to why this is and how to fix it? Thanks! Warren Koch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anybody out there comtemplating or currently building their own blog?
Rick Faircloth wrote: Thanks for the recommendations, Barney. I've thought about hosting Wordpress. I have my own VPS with Win 2003, CF 8, and MySQL 5, so hosting's not an issue. It's more about how I'd like to spend my time...learning PHP :o/ , which I'll probably never use, or more about CF, with which I earn my daily bread. I know a lot of people who use wordpress that have customized it with plugins, themes, etc. and have not had to touch a line of PHP code. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iPhone Development
Bryan Hogan wrote: Can someone point me into the right direction to get started developing iPhone applications with CFML? I would like to develop on Windows if at all possible. You can't develop iPhone applications with CFML. You can build a *web application* thats targeted to mobile (very small screen) browsers, however, using CFML. iPhone applications are developed using Objective-C and the iPhone SDK. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Appending one file to another
Stephens, Larry V wrote: Can I use cffile to append one file to another? cffile action=append output=File2.txt file=File1.txt Doesn't seem to work. (This is assuming File2.txt is too large to store in a variable.) Since you didn't mention a version, I assume you are on the latest? (cf8). If so this might work for you: cffile action=append output=#FileRead(File2.txt)# file=File1.txt -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sharing vars between applications
If the two sites are on the same server, OR they use the same client variables database (and don't use any session variables), you can push the user over to the other site, sending along their cfid cftoken and their session should persist. You will probably need to make a few changes to your code to get it to work. This article may help: http://www.stillnetstudios.com/2008/04/17/maintaining-state-between-servers/ -Ryan Jessica Kennedy wrote: Posted this last week... no response, I am still not any further... any help would be greatly appreciated! OK, I have a member area on my site that is unencrypted. there are a couple of pages that need to be encrypted as they deal with passing credit card info to our cc processor. I'm using crystaltech, so our site has a mirrored site on their shared SSL domain. I thought it would be fairly easy to pass some session vars to the mirrored site and keep the user logged in, but that is clearly not working; i am assuming because the cfid token are the same it is kicking me out of the system on the mirrored site. does anyone have suggestions for how i can accomplish this without moving my entire member area to ssl?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Recheck: File Upload Progress Bar
Robert wrote: Anyone know of a solution for either an upload progress bar (not using flex), or at least to output a message while the file is uploading? You can show an in progress meter using only GIFs and JavaScript. Take a look at this article: http://www.stillnetstudios.com/2007/02/04/animated-in-progress-indicator-for-long-running-pages/ Ian wrote: Well, before Adobe can address this problem, the entire HTTP standard for client-server communications would have to be addressed. The corner stone of HTTP is that it is stateless and each and every request-response is separate and intendant. This is entirely doable right now, just not in ColdFusion I don't think. We would need access to the state of the upload, I don't think there is a way to get that in CF. If we had that you could do some fancy things with application variables and ajax to update a progress meter. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF-based freelancer time/billing system?
I love Freshbooks. They have time tracking, and then you can generate and send bills from that time data. Clients can login as well and review stuff, but its just billing information - this isn't a project management tool. Its free for you to have up to 3 clients in their system, then its still cheap after that. http://www.freshbooks.com -Ryan Jason Durham wrote: I'm looking for an inexpensive tool to keep track of time logs for side work. Specifically, I'd like to be able to setup automated billing and allow the customer to view progress on their project. Google landed me on ProWorkFlow.com which seems to fit the bill, however it might be a little more than I need. 5GB of storage at $200 a month is excessive, IMO. Are there any other less expensive (or open source) projects out there? Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The infamous back button
Yes, it does make sense, I almost posted the same thing. That way when the user does go back, they are just getting the view page again, not the action page. You can't really disable the back button, but this method is a good way to get around problems the back button sometimes causes. -Ryan Andy Matthews wrote: That doesn't make any sense Barney. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2008 2:21 PM To: cf-talk Subject: Re: The infamous back button CFLOCATION. Never render a page when it's an action request; always redirect to somewhere else that just renders (doesn't perform an action). cheers, barneyb On Tue, Dec 9, 2008 at 12:08 PM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, Is there a way to detect the use of the browser back button? I have an issue where I need to prevent a process from running if the browser back button is used.. thanks in advance sas -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Use Wordpress or BlogCFC?
Hostmysite has some very cheap wordpress accounts where they setup the wordpress installation for you, then you get all the features, no limitations. Its also pretty easy to run it yourself. MangoBlog also looks interesting. -Ryan Rick Faircloth wrote: I want to start blogging and have been looking over the options. Blogger...mmm...meh. I looked over Wordpress, but options are limited unless I pay more and more money for features. I downloaded BlogCFC and am considering that, but do I really want to bother with running my own software to get fine-grain control over just my one blog? (Just the notes for installation is 16 pages!) Is BlogCFC more for those wanting to run a blogging service for multiple users? Thoughts? Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache/CF8 problems
It looks like you are binding your vhosts to 127.0.0.1. Are you sure thats the IP you get when you are browsing to this dev site? For example if you ping localhost on a vista box I think by default it resolves to an IPv6 address. I don't think that will match the virtualhost 127.0.0.1 entry. Try using virtualhost * instead. You should probably change NameVirtualHost to use * also. -Ryan Will Tomlinson wrote: I'm helping a friend setup his Vista machine to run Apache/CF8, like my XP Pro machine. The problem we're having is, whenever he hits one of his domains we setup in his windows hosts file, it directs you to the default apache website. It works! But we have virtualhost directives in the httpd.config file to direct to C:\webRoot\somesite Here's the hosts file: 127.0.0.1 localhost 127.0.0.1 local.ApacheTestSite 127.0.0.1 local.ApacheTestSite2 Here's the bottom of his config file: NameVirtualHost 127.0.0.1 VirtualHost 127.0.0.1 DocumentRoot C:\webRoot\testSite2 ServerName local.ApacheTestSite2 /VirtualHost VirtualHost 127.0.0.1 DocumentRoot C:\webRoot\InfoSite ServerName local.infotest /VirtualHost What's strange is, this all works on my XP Pro machine. I can't figure out why you hit one of those domains in the URL, and it will not take you to the right website in the webroot. Any ideas? Thanks! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF7.02: How to restart mail spooler without restarting the service???
You *can* restart the spooler service without restarting CF. This is unsupported but works in CF7 and 8, and possibly 6. cfset sFactory = CreateObject(java,coldfusion.server.ServiceFactory) cfset MailSpoolService = sFactory.mailSpoolService cfset MailSpoolService.stop() cfset MailSpoolService.start() -Ryan Beru wrote: Hi, I had from time to time some difficulties with interaction between CF mail and our mail relay: our mail relay uses a round-robin load balancing method; so behind a unique host name, we have 5-6 mail servers. Problems occurred when one of the mail servers was stopped; it seemed as if java kept the name resolution in cache and did not release it. So I thought I solved the problem by changing the name loookup cache policy as per some tech note I found, so now the cache is expired after 10 sec (in C:\JRun4\jre\lib\security\java.security): # # The Java-level namelookup cache policy for successful lookups: # # any negative value: caching forever # any positive value: the number of seconds to cache an address for # zero: do not cache # # default value is forever (FOREVER). For security reasons, this # caching is made forever when a security manager is set. # # NOTE: setting this to anything other than the default value can have # serious security implications. Do not set it unless # you are sure you are not exposed to DNS spoofing attack. # # Enable DNS resolution updates #networkaddress.cache.ttl=-1 networkaddress.cache.ttl=10 # The Java-level namelookup cache policy for failed lookups: # # any negative value: cache forever # any positive value: the number of seconds to cache negative lookup results # zero: do not cache # # In some Microsoft Windows networking environments that employ # the WINS name service in addition to DNS, name service lookups # that fail may take a noticeably long time to return (approx. 5 seconds). # For this reason the default caching policy is to maintain these # results for 10 seconds. # # networkaddress.cache.negative.ttl=10 Now, not being a java geek (and not willing to), I don't have a clue if this setting is applied as it should be, or if there is a way to check the sta ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: CSV Import - Update with Commas in the Content
I'm not sure I understand. Are you saying they are providing you data that has delimiters within the data, but the data is not quoted? Like: [EMAIL PROTECTED],Joe,Smith,Joe, John Sons Inc. If so there is nothing you can do about that, they need to be properly quoting (with double quotes or some other identifier) data that contains the delimiter, like this: [EMAIL PROTECTED],Joe,Smith,Joe, John Sons Inc. Then you need a data import routine that can correctly handle that. Most of the ColdFusion CSV handling code I come across does not handle this very well. -Ryan From: Michael Grove [EMAIL PROTECTED] Sent: Monday, October 20, 2008 8:27 PM To: cf-talk cf-talk@houseoffusion.com Subject: CSV Import - Update with Commas in the Content I am trying to figure out how to update a sql table using a CSV file that has commas in the data fields. The long and Short of it, is that we have a SEO company rewriting our keywords, meta descriptions and titles for our product database. We were able to build a simple CSV export so that they could add the new info. Now we need a way to import it back into the systm and update all of the records based on the productID, wich is in the csv file. The developer we are using says it can be done, but we cannot have commas in any of the fields. We can wrap the columns in double quotes on an export, cant we do this on the import? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is it possible to trigger a link on a web page and trigger a download?
You could have an .htaccess file in your downloads directory that adds the content type to do this, for files retrieved from that directory. -Ryan [EMAIL PROTECTED] wrote: Ahh, good tip on the cfheader name=Content-Disposition value=Attachment; filename=#clipname# bit. I have never used that before. Of course, that also means you burn a thread to server the download. I wonder if there is an easy way to link directly to the file, but force apache or IIS to provide the same attachment header trick. ~Brad Original Message Subject: Re: Is it possible to trigger a link on a web page and trigger a download? From: Wil Genovese [EMAIL PROTECTED] Date: Thu, October 16, 2008 2:35 pm To: cf-talk cf-talk@houseoffusion.com Actually you can control the way a link opens if your trying to push a file when a user clicks a link. If the link is to a coldfusion page that then grabs the file sets header info and content type. I do this for mp3 files. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Streamlining an insert
This is how you'd do it with MySQL: INSERT INTO tablename (x,y,z) SELECT x,y,z FROM othertable If you are using MSSQL, I'm sure its something similar. -Ryan Eric Roberts wrote: I have been trying to come up with a more streamlined way to update the contents of a table with data that is coming from a different database. Is there a way to use in the values clause a reverence to a record from a cf query instead of actually typing out all of the variables? Something along the lines of: Insert into table(x,y,z) Values(#queryname[currentrow]#) Or is there a way to use cfinsert or some other process where I could essentially pass the query object so that I can insert the data without having to loop and do each insert individually? Thanks! Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Streamlining an insert
Eh, sorry I didn't catch that you are pulling in from a completely different database. I think you can still directly in MySQL, like INSERT INTO tablename (x,y,z) SELECT x,y,z FROM databasename.othertable *if* both databases are on the same MySQL server. But I'm not sure how it works with a ColdFusion datasource, I think the user you are connect the DSN as would need permission to both databases and it should work. -Ryan Ryan Stille wrote: This is how you'd do it with MySQL: INSERT INTO tablename (x,y,z) SELECT x,y,z FROM othertable If you are using MSSQL, I'm sure its something similar. -Ryan Eric Roberts wrote: I have been trying to come up with a more streamlined way to update the contents of a table with data that is coming from a different database. Is there a way to use in the values clause a reverence to a record from a cf query instead of actually typing out all of the variables? Something along the lines of: Insert into table(x,y,z) Values(#queryname[currentrow]#) Or is there a way to use cfinsert or some other process where I could essentially pass the query object so that I can insert the data without having to loop and do each insert individually? Thanks! Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Firefox redirects to machine's IP address?
Greg Morphis wrote: If I type in http://localhost:8300/ into Firefox it goes to the machine's IP address and I get a Network error.. In IE this works fine.. it takes me to my CF root directory.. What gives? Sounds like a webserver redirect issue. I've run into this before, but I don't remember exactly what I did to resolve it. I changed something in the web server config. Perhaps your ServerName value? (assuming Apache here). Take a look at the exact headers that are being sent to FF (may need an extension such as Firebug, webdev or liveHTTPHeaders). -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox redirects to machine's IP address?
I've had it happen where it did *not* affect IE and FF the same. But it doesn't sound like you even talking to Apache, port 8300 is usually talking to JRun's built in http server. What happens in IE, does it redirect you somewhere different or does the page just display properly at the http://localhost:8300/ URL? And what URL exactly is FireFox getting redirected to? -Ryan Greg Morphis wrote: If it were a webserver redirect issue wouldnt it affect both IE and FF? I have Apache on here(Tomcat 5.5 for Flex) however with CF I installed the Jrun option... On Mon, Sep 29, 2008 at 10:39 AM, Ryan Stille [EMAIL PROTECTED] wrote: Greg Morphis wrote: If I type in http://localhost:8300/ into Firefox it goes to the machine's IP address and I get a Network error.. In IE this works fine.. it takes me to my CF root directory.. What gives? Sounds like a webserver redirect issue. I've run into this before, but I don't remember exactly what I did to resolve it. I changed something in the web server config. Perhaps your ServerName value? (assuming Apache here). Take a look at the exact headers that are being sent to FF (may need an extension such as Firebug, webdev or liveHTTPHeaders). -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Chrome: Cfinput text area: fckeditor
Paul Ihrig wrote: the fckeditor in cf8 dosnt seem to render in chrome. any ideas? danke -paul I believe it only works in Safari/Chrome when using the latest version of FCKEditor. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: My first attempt to install 64bit CF did not go well...
Check the paths in the connector script and make sure they are correct. This is often an issue on Linux, and it could be the same on Solaris. This may be helpful: http://www.stillnetstudios.com/2007/04/05/problems-installing-the-coldfusion-connector-on-linuxapache/ -Ryan Ian Skinner wrote: We tried to install ColdFusion 8.01 in 64 bit mode on a new Solaris Unix server yesterday and it did not complete. The installation seems to have ran without any noticeable problems, but the cfmx-connectors.sh does not seem to run properly. We are attempting to install ColdFusion in a Multi-home configuration under a default JRun-4 JVM using Apache as the web server. Can anybody point to any information specific to installing this flavor of ColdFusion? Anybody got any hints on what we should be looking for in any particular logs that may guide us as we start to debug the problem this morning? TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Chrome: Cfinput text area: fckeditor
It can be done, but I don't know the specifics. There are also reasons you may not want to. But you can download FCKeditor and just embed it manually. Its not hard. -Ryan Paul Ihrig wrote: so how do i updated the fckeditor that cf 8 uses in its rich text area for cfinput? On Thu, Sep 25, 2008 at 10:39 AM, Ryan Stille [EMAIL PROTECTED] wrote: Paul Ihrig wrote: the fckeditor in cf8 dosnt seem to render in chrome. any ideas? danke -paul I believe it only works in Safari/Chrome when using the latest version of FCKEditor. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting an image in a PDF?
Aaron C wrote: Is it possible to insert an image (e.g. jpg) into a PDF using ColdFusion 8? Yes, since CF7. cfdocument img src=file:///home/data/whatever/image.jpg /cfdocument Or do you mean into an *existing* PDF? In that case I think you'd do something like above, then use the new cfpdf tag to merge that PDF into your existing one. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf 7.0.2 freezes on install
I have no suggestions for your issue, but you may be able to get around it by doing a silent install: http://kb.adobe.com/selfservice/viewContent.do?externalId=87bd20f4 -Ryan Greg Morphis wrote: I left it trying to install all last night and nada.. after 15 hours, still nothing.. I think it may have to do with the installer.. For fun I ran the CF 8 installer and the install screen looks different.. Buttons! In the CF 7 installer the buttons are labels and there aren't any radio buttons.. So I wonder if it's even registering the button click at the end to initiate the install Here's some screen shots.. http://img140.imageshack.us/my.php?image=ss1od6.jpg http://img140.imageshack.us/my.php?image=ss2dn9.jpg http://img140.imageshack.us/my.php?image=ss3hc5.jpg http://img140.imageshack.us/my.php?image=ss4ri9.jpg So what the hell? Any Adobe guys reading the forums that might have suggestions? CF 8 is installing fine but our dev and prod server is CF 7.0.2. I really need to get 7.0.2 installed. On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote: I tried 3 different versions, they all did the same. I'll get with the LAN people tomorrow and see what's up. On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote: + make sure windows firewall (or any other firewall you may be using) is turned off or at least not blocking ports required by installation (there is a list of those somewhere on abode website... i prefer to just turn firewalls off). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Brad Wood wrote: For starters, can you re-download the installation (make sure you have the correct 32 bit or 64 bit version) and verify the file size to ensure you downloaded the entire file. Also, shut down any other programs during the install and make sure you have installation rights as well as making sure there are no anti-virus programs messing with you. ~Brad - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 15, 2008 5:30 PM Subject: Re: cf 7.0.2 freezes on install I finally cancelled after nearly 3 hours... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Totally Baffling Extra being added in a plain text email. What the heck?
Try adding a server=some non-existent server attribute to the cfmail tag. This will cause the mail spool file to end up in the Udelivr folder (alternatively you can just try to catch the file in the Spool directory before it gets picked up). Now you can look at the raw email, does the problem exist there? If not then your email client or something else is adding it. -Ryan From: Les Mizzell [EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 5:55 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Totally Baffling Extra being added in a plain text email. What the heck? ARRRGGHH This is the kind of thing that makes you tear ALL your hair out! If anybody can figure this one out, I'll treat you at Starbucks in some future life! ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache with coldfusion, using seo urls
Stephen Adams wrote: Hi, I'm trying to set up my laptop with Apache and CF, so far I have everything working the only problem is that the site I'm working on uses SEO url's e.g. mysite/myaccount and this will load the index.cfm page of the my account folder. This also means that all the includes and links to stylesheets are like this: CFINCLUDE TEMPLATE=/includes/modules/myaccount/act_default.cfm or link type=text/css href=/styles/print.css rel=stylesheet media=print / Now at work we are using IIS and these links work fine, but on my laptop I'm using Apache (I couldn't get IIS to work on the laptop), but on Apache url written this way are not working I have to amend them to CFINCLUDE TEMPLATE=../includes/modules/myaccount/act_default.cfm or link type=text/css href=../styles/print.css rel=stylesheet media=print / Is there a way in Apache I can get all url's to work the same as IIS? This doesn't sound like an Apache issue at all, if you are having to change your cfinclude paths. cfinclude works at the ColdFusion server level, not on the web server level. It looks like you may be missing a ColdFusion mapping, and may need to adjust your web server's web root and/or add an alias/virtual dir. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Best FTP Software 4 Windows
Che Vilnonis wrote: Just curious as to what y'all use. In the past I've used Smart FTP, but it has grown into 'bloatware' IMO and I'm looking to find something a bit more lightweight and free to use. Your thoughts? TIA, Che For a client I like the FireFox plugin FireFTP. For a server, I've recently started using FileZilla, and I like it a lot. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open source BLOG which run on GoDaddy.
BlogCFC is released under the Apache 2.0 license, you can pretty much do anything you want with it, including redistributing. http://www.apache.org/licenses/LICENSE-2.0 -Ryan Andy Matthews wrote: BlogCFC is editable, yes. When you download it, you have the source code. I don't think you could redistribute your changes, but you can change it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is it Flex?
Very useful, thanks. The weird thing is, its running the swf, too? I ran pandora.com through it, because I've always wondered about that. Then some music started playing, even though I couldn't see any player. When I closed your site, the music stopped. ??? -Ryan Brad Wood wrote: Ok, have you ever had the burning question when you see a Flash application on a webpage-- Was it made with Flex? James Ward, a Flex and Air evangelist from Adobe has a little page located at http://www.jamesward.com/is_it_flex/ that lets you specify a URL to a SWF. It uses swfdump to parse the SWF files and tell you if it was created with Flex. Well, I created a piggy-back page located at http://www.bradwood.com/is_it_flex/ which lets you type in a page, it downloads the source, parses through it for SWF files, and then runs them one at a time through James Ward's page (with his permission of course) I rewrote it last night (read: introduced some bugs) and thought I would throw it out there for people to mess with. If you have any questions you can hit me off-list at brad at bradwood.com since this is a little OT. Thanks. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Shopping cart with focus on inventory management? Or just inventory management?
Hi. I'm looking for a ColdFusion shopping cart that also has a good feature set for managing inventory. Really looking for an inventory management system that also has a shopping cart. Or actually it might not even *have* to have a shopping cart, if you know of a good CF inventory management system, please post it. Thanks, -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion instances running under other instances?
I'm working on a server with multiple instances of ColdFusion running on a Jrun4 installation. Sometimes this gets weird and I get one of the instances running under another one. This screen shot explains it better: http://tinyurl.com/2l73dy You can see the admin instance is running under the cfusion instance. It should be running under a single jrunsvc process, like br1 and br2 are. When one of the instances gets like this, it is unresponsive. Possibly because it can't grab the memory its supposed to because its limited by what the parent instance is setup for. Has anyone ever seen this? I have to manually kill the process, then start it, usually from the services control panel to get it to come back correctly. It seems to be related to starting/restarting the instance from within the JRun administrator, but it doesn't happen all the time. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SEO company recommendations ?
I'm looking for a good search engine optimization company to recommend to a client. If you've had a good experience with one, please point me to them. Thanks, -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfstat checkbox resetting
Vance Whitehouse wrote: Hello, I've been upgrading our web servers from CF 7 to 8 and I'm not able to enable cfstat on them when they are running CF 8. Every time I check the Enable CFSTAT checkbox in the CF administrator, hit submit, and restart CF then log back in and check the administrator the box is unchecked. The box is even unchecked if I simply refresh the page after submitting it. I have also verified that the Watch configuration files for changes checkbox is not checked. Two of the servers are running Windows 2003 and two are running Red Hat ES 5. Any ideas? Thanks, Vance I just ran into a similar today. I wrote a blog post about it: http://www.stillnetstudios.com/2008/03/04/getting-cfstat-to-work/ But the short of it is - check your neo-metric.xml file. Look for var name='cfstat'number1.0/number/var and change it to var name='cfstat'stringtrue/string/var. If it still doesn't work, look at the cfstatport setting (more details in the blog post). -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300457 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 autosuggest automatically filters again?
I have a CF8 autosuggest setup for selecting a user on a form. The input tag
is:
cfinput type=text name=sendto
autosuggest=cfc:ajax.getAddressBook({cfautosuggestvalue})
And the query inside the getAddressBook() method looks like this:
cfquery name=qryClients datasource=mydsn
SELECT first, last, email FROM clients
WHERE first LIKE cfqueryparam value=#Arguments.autosuggestvalue#%
cfsqltype=CF_SQL_VARCHAR
OR last LIKE cfqueryparam value=#Arguments.autosuggestvalue#%
cfsqltype=CF_SQL_VARCHAR
OR email LIKE cfqueryparam value=#Arguments.autosuggestvalue#%
cfsqltype=CF_SQL_VARCHAR
/cfquery
I then return an array whose entries look like #first# #last# #email#.
This returns users whose first name, last name, or email address starts with
the text the user has entered in the form field. I've called it via URL and its
returning the correct results. If I give it Smi for an autosuggestvalue, it
returns Joe Smith [EMAIL PROTECTED].
But the auto suggest values shown on the form are only the ones with a *first
name* starting with the auto suggest value. Its as if the CF code on the
client is further filtering the results returned from the CFC.
I didn't see anything in the docs about the client side auto filtering, but it
looks it is doing just that???
-Ryan
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300267
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: email encryption
You would have to cfexecute to something like pgp or gpg. But first the end user would need to install software, generate public/private keys and give you the public key. Not a very viable solution. How about instead of generating the password at the time of account creation, leave it NULL, and in the initial email give them a link to access the a page on the over SSL. Once they click on the link, generate the password for them and display it on the SSL-protected page. -Ryan Original Message From: Richard White [EMAIL PROTECTED] Sent: Saturday, March 01, 2008 12:58 PM To: CF-Talk cf-talk@houseoffusion.com Subject: email encryption Hi, we have a page where we add new users to our software. before it adds them to the database it generates a random password for them, then we want it to send them that password via an encrypted email. is this is the best way to do it, and if so then can you tell us how to encrypt an email please. i can send an email fine but encrypting it is a different story. we have to generate them a random password, as we generate the accounts whilst the new users are not with us, and by emailing it to them it ensures that we don't see their password. appreciate your thoughts and advice thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfdocument and load balancing.
Jeremy Rottman wrote: We recently updated our infrastructure to include HW loadbalacing and a linux based firewall. With this new change, came a basket full of issues. One issue that is most pressing, is when attempting to create a pdf via cfdocument that has images with in the pdf, cfdocument times out every time. If the pdf does not contain an image, the pdf generates perfectly fine. Currently our webservers have thier own external ip address (not a 192... address). They are IP load balanced. So our domains point to one ip, and they are loadbalanced between the other servers. What I speculate is that when the document tries to generate it is attempting to pull the images from the balanced ip and not the from the webservers themselves. Has anyone ever run into this situation before? How are you referencing the images in the HTML behind the PDF? For speed reasons you should be pulling them from the disk like img src=file:///C:\tmp\whatever.jpg. In that case there shouldn't be any issues with load balancing. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: accepting/returning cookies with cfinvoke
Do many web services use cookies? I think authentication is usually controlled by having you send your credentials with each request. Or you send your credentials initially, then are given a token you must pass back in with each request. -Ryan Brad Wood wrote: I didn't get any takers with this. Anyone? ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, February 22, 2008 4:07 PM To: CF-Talk Subject: accepting/returning cookies with cfinvoke If I am using cfinvoke to consume a web service, will ColdFusion accept and or return cookies set by the third party for authentication purposes? I'm thinking no, but how then does one do that? ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: A little CFEXECUTE help
Log all the paramters when making your cfexecute call, and whether it successfully created the file or not. Then look at both lists (the ones that worked, and the ones that didn't), and I'll bet a pattern will emerge. Spaces or bad characters in a filename perhaps? Surround the filenames with double quotes. Or perhaps output over a certain size is failing? I haven't seen it done the way you are doing it there (not that its wrong), passing the binary data through coldfusion by using the outputfile attribute. What attributes are you passing to gzip? By default it deletes the file you are compressing, so this should work: cfexecute name=/bin/gzip arguments=#pathtofile# / This should create a new file named #pathtofile#.gz, and the original #pathtofile# will have been deleted. -Ryan Josh Nathanson wrote: Hey all, I'm trying to do a little CFEXECUTE magic on a Linux box, gzipping an xml file on the fly. All is well except that the resulting file is occasionally empty. It seems to work about 50% of the time, then the other 50% I get an empty .gz file. My code looks like this: cfexecute name=#pathtogzip# arguments=#pathtofile# outputfile=#pathtofile#.gz /cfexecute The paths are all correct -- as I mentioned it does work about half the time so there are no path or permission issues. I also tried adding in the arguments -f (force) and -q (quiet), but it doesn't seem to make a difference. Any thoughts? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload - my new posts aren't coming through
I've had problems with occasional messages not coming through for a few weeks now, perhaps months. I always use plain text when posting to this list. -Ryan Bruce Sorge wrote: I use Thunderbird and I make sure to select Text Only when sending to any of your lists 99% of what I originally posts goes through fine. Bruce Michael Dinowitz wrote: The issue is probably due to you posting from a client that has a rich text post set as default. Rich text posts are usually base64 encoded which is rejected by the lists. Some rich text posts are html only with no text only alternate which is also rejected. Replying always works because the reply is in the same format as the original post which will always be sent to you as plain text. What client are you using to post? BTW, posting from the archives always works. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload
I don't know why Bruce needs it, but I would love to be able to do it because it adds usability. When there are multiple file upload boxes, its easy to get confused as to what files you have selected already. The file input box is usually only about 20 characters wide (and not adjustable in most browsers). So I end up seeing C:\Documents and Sett in all 10 boxes. I have used some uploaders where after you select the file, the file name appears next to the file select control. Very helpful. -Ryan James Holmes wrote: Out of curiosity, can you say why you need the filename before the file is uploaded to the server? On Feb 5, 2008 5:47 AM, Rick Sanders [EMAIL PROTECTED] wrote: Hello Bruce, Thanks for your reply. However, I'd like to grab the file name before the file is actually uploaded to the server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using cfinput causes form fields to show through?
I have a form with three text fields lined up vertically on top of each other. The first field was a cfinput, so I could use the autosuggest feature. Worked great. Then I changed the other two fields to be cfinputs, and now they show through the autosuggest popup area. Here's a screen shot of what I'm talking about: http://aycu24.webshots.com/image/43863/2002850445526073769_rs.jpg Happens on IE6 for sure, don't know about other browsers yet. Anyway to fix this? I'm thinking it might have something to do with how cfinput wraps the input tag in a few other tags, including a div. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can you rotate a PDF in CF8?
I was sure cfpdf could do it, but now that I'm ready to do it and am looking through the documentation, I don't see how. Anybody done this already? Seems like rotating would be a pretty simple and common thing, I'd be surprised if they left it out. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Resizing images Godaddy Linux Coldfusion hosting?
In CF8, all the image functions work the same regardless of the host operating system. If you are not on 8 you could use command line tools if they are installed, but if CreateObject is disabled, I doubt they'll let you use cfexecute. -Ryan Casey Dougall wrote: Hello, Without having this turn into a heated debate about hosting companies, the pros and cons of dedicated boxes etc... I would like to know if anyone is resizing images on GoDaddys Linux Coldfusion Shared hosting accounts. I have a client who was already hosting with them and adding coldfusion to their account was easy enough to get the project rolling. I'm running into issues with resizing images though, as I have never tried using any of the underlying Linux image manipulation functions OR if they are even available and things like createobject are not allowed so I cannot use imagecfc on their shared hosting accounts. Thanks gang! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Limit to single user logon with same userid
You can go through all an applications current sessions using the SessionTracker class, but I've found this to be very slow. Instead I switched to keeping a list of logged in users in the application scope. Users get pushed into here when they login, and removed from here when they click LogOut, or when their session times out (via OnSessionEnd). I store the users in a structure, using their username as a key, and their session information as the value. Then when someone logs in, I check the application variable. If a user exists in there, you know they are already logged in from another session. At that point you still have the use the SessionTracker to reach into that other session and invalidate it - but this is much faster since you aren't looping through all the sessions, you are just reaching into one known session. -Ryan Wally Randall wrote: How do people prevent the same user from logging into an application with the same userid from multiple machines? We have users who are sharing their IDs which is causing application failures with the concurrent sessions. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Java help - convert -D command line option to CF?
Hareni that worked great, thank you! -Ryan Hareni Venkatramanan wrote: Perhaps, you can try to instantiate java.lang.System and set the system property in the coldfusion code? Something like, cfset sys = createObject(java, java.lang.System) cfset sys.setProperty(com.java4less.vision.maxarea, 9) Hope that helps. Thanks, Hareni -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: 08 December 2007 04:19 To: CF-Talk Subject: Java help - convert -D command line option to CF? I am converting a little java code into CF8. The sample Java program I am working from is meant to be run with this command line option: -Dcom.java4less.vision.maxarea=90 Without having that set, my results in ColdFusion are not working very well. Anyone know how I can do something like the above in ColdFusion? I have no vision object to work with or anything, I'm only working with 1 instantiated java object and there is no maxarea property or setter in that object. I imagine I could change ColdFusion's JVM start up parameters to include that option, but I don't really like that idea. -Ryan ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Java help - convert -D command line option to CF?
I am converting a little java code into CF8. The sample Java program I am working from is meant to be run with this command line option: -Dcom.java4less.vision.maxarea=90 Without having that set, my results in ColdFusion are not working very well. Anyone know how I can do something like the above in ColdFusion? I have no vision object to work with or anything, I'm only working with 1 instantiated java object and there is no maxarea property or setter in that object. I imagine I could change ColdFusion's JVM start up parameters to include that option, but I don't really like that idea. -Ryan ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OCR Solutions
Has anyone else been having problems with the list missing emails, or coming through 8+ hours after it was originally posted? I don't have the original message for this thread. The web archive shows it was posted around lunch today. Anyway, I am going to need to implement something like this soon. Our images will come in via email, then I need to OCR a customer ID out of it and import appropriately. I was looking at JavaOCR (http://javaocr.com) and Asprise OCR, also written in Java. So they should easily integrate with ColdFusion. Neither are free. There are also several (free) open source OCR packages: GOCR http://jocr.sourceforge.net/ Ocrad http://www.gnu.org/software/ocrad/ocrad.html Tesseract _http://google-code-updates.blogspot.com/2006/08/announcing-tesseract-ocr.html_ But I have not looked into any of them yet. But the barcode stuff Jim Rising mentioned (glad I checked the archive, as I don't have that email either...) looks very interesting, and it looks like its a lot cheaper than OCR. My images are actually coming in via fax, so OCR'ing that quality of an image may be a challenge. I think the barcode may perform better. -Ryan Dave Watts wrote: Does anyone know of any ocr solutions that can be made to work with ColdFusion? What I'd like to do is have documents scanned and emailed to a coldFusion server and then OCR'ed to find a person's name or account number. The number will be used to match the document to a database record so the document can be attached to their account. Since lots of scanners come with OCR solutions, why not do it there? Adobe Acrobat does this quite well, in my opinion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
string concatenation / appending in CF8
Is there a shorter way to append strings in CF8 now? With all the javascript style operators I was hoping there would be something. += or = or .= or whatever. Or do we still need to do: Arguments.myOutputString = Arguments.myOutputString more text all the time? I would love a shorter way to do this. -Ryan ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: string concatenation / appending in CF8
Hmm that one didn't work for me when I tried it (I tried the ways I listed in my first post), but I'll have to go back and try it again, maybe I had something wrong. -Ryan Dale Fraser wrote: cfset string = The Quick / cfset string = Brown Fox / cfoutput#string#/cfoutput Regards Dale Fraser http://learncf.com -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Wednesday, 21 November 2007 11:50 AM To: CF-Talk Subject: string concatenation / appending in CF8 Is there a shorter way to append strings in CF8 now? With all the javascript style operators I was hoping there would be something. += or = or .= or whatever. Or do we still need to do: Arguments.myOutputString = Arguments.myOutputString more text all the time? I would love a shorter way to do this. -Ryan ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sms
If going the email-to-phone route, you can just send to [EMAIL PROTECTED] and it will get there. No need to figure out what carrier the user is on. -Ryan Ryan Heldt wrote: Don't know if this was mentioned before. Might be helpful: http://www.bennadel.com/index.cfm?dax=blog:692.view Ryan -Original Message- From: Graham Pearson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 14, 2007 6:02 AM To: CF-Talk Subject: Re: sms -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If you are handy with Unix and you know all of the Cell Phone Proivers of the users who will be receiving these SMS messages you can create your own SMS Gateway and save a lot of money. All you will need is a Linux Based Computer, a 2400 baud modem and a cheap fax line. If you want to test it out, simple contact me off list and I can configure mine setup to send you sms messages. The way that I perform this is I have to know the Cell Phone Provider so I can send the right message to the Right Provider which delivers the message to the end user. I have been doing this same thing with Coldfusion 5 in the K-12 Education Industry for 5 years however since I am a single man shop I am not Well Known in the community so my knowledge in this is overlooked. To see the Web Interface you can visit http://paging.niesc.k12.in.us select my name from the list and send a message which will be received on my Treo 650 phone through Verizon Wireless. Graham Pearson ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Posted input array problem
I would store your modified sort order in the form. Instead of just moving them up and down the page, also change the value of the radio button or the value of hidden fields(s). Then when the form is submitted, you can loop through that data and examine what the sort order of each item should be. BUT - when I have done what you are talking about, just moving the form elements around - when I then examined the form scope, the elements were in the new order, not the original order. So maybe double check how you are moving the elements around. -Ryan Tarek Jubaer wrote: Hi I am trying to get value from posted input array (input type='hidden' name='inp[]' value='1' input type='hidden' name='inp[]' value='2' input type='hidden' name='inp[]' value='3'). But from the article http://www.christian-web-masters.com/forums/index.php?showtopic=10873 i found that it is not possible with cold fusion. Is there any solution to this problem? what i want to do is: My form will have some input radio button with dynamic different values form database. There is a function in JavaScript to move up/down the radio buttons (i.e. sorting will be done). when the form is posted i want to get the values in sorted order (not in the order they were created. using name='inp' instead of name='inp[]' i can get all the values in the order they were created. but not in sorted order. ) Any help will be really appreciated. Thanks in advance. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sms
Chad Gray wrote: Hello, I would like to make an application that would allow one of our sales reps to use their cell phone to create a new login/password for a CF application. How does the cell phone send the data to the CF Event Gateway for SMS? This must be some kind of service from the phone company that connects to the CF Server? I've heard getting access to an SMS gateway is very expensive. Don't most phones/providers let you send an SMS to an email address? I'm not sure how you'd authenticate the sender though. Maybe they'd have to place a username/password or key in the message. Perhaps having an obscure email address + a special keyword in the message would be enough security, depending on what you are doing. -Ryan ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC to check spam score BEFORE sent...
C. Hatton Humphrey wrote: I would like to install something on our server that will check an emails spam score before we send it out to catch any problems. If you know of one I'd love to hear about it as well. One idea that came to mind - if there were a way to use CFExecute to fire off SpamAssassin and tell it to check a message via the command line you should get something back for a score. Not 100% certain if that's possible with SA though. Still checking. I did find this: http://wiki.apache.org/spamassassin/AvoidingFpsForSenders as a list of tips but that doesn't help much. I also found a program called Mail Avenger that lets you process a message on SMTP receive instead of on POP/IMAP/Exchange delivery. Hatton Yes, you could do this with Spam Assassin. I've generally not had good luck using cfexecute under load though, so it depends on how many messages you need to check. You could also write a Java class to deal with the SA interaction. The SA install does not need to be local either (although it could be, I think it runs ok on Windows), as the SA daemon can bind to a port and work distributed. -Ryan ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cfexecute and restart of apache...
When I needed to do this, I wrote out a restart request file in a certain directory. Then had a job run from crontab every 1 or 5 minutes or whatever, that if it found a restart request file, it would (as root) restart the webserver, and remove the restart request file. I think you may have problems trying to restart apache using the user apache runs as, but I'm not really sure how OSX compares to Linux on that. -Ryan Douglas Hyde wrote: I am new to CFEXECUTE. I am trying to use cfexecute to restart apache2.2 on max OSX (unix file structure) when a new virtual host is added or when the aliases are updated within a host (eg, new directories are added that must be aliased). Apache doesn't recognize these changes until restart. So I have written code to add the new virtual host/alias settings in the vhosts directory of apache - this is working fine. My challenge is getting cfexecute to restart apache in order to pick up the new configurations. Here is what I have tried: !---now set absolute path to a file on the web server to reboot--- cfset script_path = /Library/Apache2/bin/apachectl !---now set arguments--- cfset script_arguments = restart !---now set absolute path to a file on the web server to act as a log; something like--- cfset script_log = /Library/WebServer/Documents/script_log.txt cfexecute name=#script_path# arguments=#script_arguments# outputfile=#script_log#/cfexecute So, it looks like apache is restarting - the problem I am having is that it tries to spit out the file that the cfexecute is contained in, rather than writing to the file in outputfile. I have manually created the script_log.txt in the target directory, and have set permissions to allow the file to be overwritten. But nonetheless, a window pops up asking me to download the file that the cfexecute command is contained in. I have also tried switching from outputfile to variable, and then dumping the variable to a file, but I still have the same problem. To be frank, I really don't need the file, its just a behaviour of cfexecute I need to manage. Any thoughts on why it dumps? I thought of wrapping the cfexecute in cfsavecontent, but don't think I should have to. Cheers, Doug ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java Script Value to CF Value
You'll need two pages or steps to get this value - one for the form itself, then when you submit that form you can have the value. form action=mypage.cfm input type=hidden name=wide /form script language=JavaScript document.forms[0].wide.value = document.images[0].height; document.forms[0].submit(); /script Robert Harrison wrote: I have a value I'm retrieving from Java Script. I need to set it to a CF value. What is the correct syntax. Below does not work, but it makes the point on what I'm trying to do. How do I do this correctly? cfset wide=script language='javascript'document.write(document.images[0].height)/script Thanks, Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Easy-to-develop recurring billing?
This week I uploaded my cfc for dealing with Authorize.Net's recurring billing API. http://AuthorizeNetRecurring.riaforge.org/ -Ryan Josh Nathanson wrote: Authorize.net. There are several tags for it. Are there tags for recurring billing, or just the regular one-time authorization? I know the Authorize.net API for recurring billing just debuted a couple of months ago (they were horribly slow in putting it together), so I'd be surprised if someone's already whipped up a CFC / UDF for it...if there is one, give us a link! -- Josh ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Easy-to-develop recurring billing?
Josh Nathanson wrote: This week I uploaded my cfc for dealing with Authorize.Net's recurring billing API. http://AuthorizeNetRecurring.riaforge.org/ Crap, I just finished my CFC last week but hadn't posted it yet... I had an issue where the Authnet service returns three junk characters at the beginning of the returned XML string, did you happen to run across that? Their tech said ColdFusion has bugs parsing XML. I wrote back saying I think it's the Authnet service that's buggy, most XML parsers would choke on three ascii 65533 characters but I never heard back. I had to remove them manually with a replace. -- Josh Yes I did run into that. Download the cfc and take a look at it if you are interested. I also wrote a blog post about fixing those funny characters a few weeks ago: http://www.stillnetstudios.com/2007/07/09/coldfusion-xml-prolog-error/ -Ryan ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Authorize.net cfc/tag for recurring billing?
Anyone know of a cfc or custom tag to work with Authorize.net's recurring billing API? I know tags/cfcs have been around for their regular payment gateway, but in early 2007 they (finally!) released a recurring billing API. It uses xml, it doesn't look *too* time consuming, but I thought if there was already something out there that would give me a head start, I'd use it. :-) -Ryan ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL question
I wrote a blog post concerning this a while back: http://www.stillnetstudios.com/2007/01/20/comparing-dates-without-times-in-sql-server/ Hope that helps. -Ryan Chad Gray wrote: I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and SSL woes
Have you upgraded the jvm? If so, could you be importing the cert into the wrong keystore? You will need to import it into the keystore under the new JVM installation directory. If you follow any of the cert import instructions on the net, they will probably lead you to install the cert into the old keystore (CFusionMX/runtime/jre/lib/security/cacerts). -Ryan http://www.stillnetstudios.com Will Swain wrote: Yup - this old chestnut. Server running cfmx6.1 trying to use CFHTTP to a url using SSL v3. This worked until recently when they upgraded their cert from v2 to v3, and now I'm getting the infamous Connection Failure error. I've tried applying the fixes such as importing the cert into cfmx's cacerts etc., all to no avail. My question is this - I can run this code fine on my local test server, running cfmx 7.0.2. I get communication with the remote url via CFHTTP no problem. Is this something that was fixed somewhere in between CFMX 7 (I've seen some people having this issue still with 7) and CFMX 7.0.2? I don't want to recommend that the client upgrades from cfmx 6.1 to 7.0.2 unless I'm pretty sure it will work. Thanks all. Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: upgrade java in CF
Andrew Scott wrote: With all this talk about upgrading the java runtime, what is the process in doing so. Is it just a simple matter of backing up the lib directory and dropping the new libs in there? Andrew Scott I wrote up a HowTo a few weeks ago: http://www.stillnetstudios.com/2007/02/24/upgrading-the-coldfusion-jvm-on-linux-and-windows/ -Ryan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating HTML Content Wrapper for Email
By inline style I'm assuming you mean using the style tag in the actual element, i.e. p style=color: blue;mytext/p ? I've had good luck in the the past defining the stylesheet at the top and setting my P, TD, etc. to whatever font color and sizes I want. I haven't tried to use classes though. -Ryan Andy Matthews wrote: You're mostly out of luck when trying to use CSS in emails. It sucks, but you're stuck with using inline styles (in my experience). -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 10:06 AM To: CF-Talk Subject: RE: Creating HTML Content Wrapper for Email Ah, excellent idea Andy, Thanks, Whilst on the topic, does anyone happen to have any good resources or advice on developing XHTML and CSS code for use in Emails? Rob ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: php equivalent of application.cfc
You don't need to have access to the php.ini file. You can set those directives in an .htaccess file. I done this on shared hosting providers. If you did it in .htaccess the syntax would be: php_value auto_prepend_file Application.php php_value auto_append_file onRequestEnd.php -Ryan Christopher Jordan wrote: Probably not, but I didn't read where the original poster said he was using a shared host. And you're probably right, the shared host probably has these turned off. I was just trying to show that it *is* possible to prepend and append files in php. I'm also used to hosting my own. I'm fortunate enough to work for a small company who is in the business of hosting for our clients. Chris Tom Chiverton wrote: On Friday 02 Mar 2007, Christopher Jordan wrote: In fact, here are the two lines I included in my php.ini file (which on my fadoracore4 system is located in /etc) On a typical shared host, you wouldn't be able to set those parameters though, would you ? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cfdocument sizes
You could look at HTMLDoc, but I recently had a few problems with it moving from CF5 to CF7. -Ryan E C list wrote: Unfortunately they do not. It's a dymo label writer. I use it to create address labels for new customers (one at a time.)...I wish I could either figure out what's wrong with the html2pdf or figure out some other workaround. I don't know if there is going to be one though. Thanks for trying to help. -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Friday, March 02, 2007 12:25 PM To: CF-Talk Subject: Re: Cfdocument sizes Do the labels com on sheets of 8.5 x 11? If so, you could create a CSS workaround with multiple classes to align everything where it needs to go. Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 E C list wrote: Does anyone have any ideas? I was happily using CF_html2pdf on ColdFusion 5.0 to make pdfs, but now that particular server has been upgraded to ColdFusion 7 mx and that tag no longer works for me...(it just times out with a java error)...that would be no problem, but I was using the tag to make labels and print them off on a label printer...so the dimentions of the pdf have to be 1.4 inches by 3 inches. Unfortunately, with cfdocument you MUST make the dimentions larger than 2x2, so the small size labels cannot be created. Does anyone have any comments or a workaround? Thanks - Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: php equivalent of application.cfc
Correct! They wouldn't be very useful if you could only set them for the server as a whole. If you set a prepend/append file in your webroot, and want it turned off in a subdirectory, you can put a .htaccess file in there and set the auto_prepend_file value to none (without quotes I believe) and it will turn it off. If you really wanted to emulate the way ColdFusion looks for and executes Application.cfm you could put some code in your auto prepended file that looks for Application.php in the same file as the current script. If its not found, check the parent directory, etc. etc. -Ryan Rob Wilkerson wrote: Cool. I didn't know that. Theoretically, then, you could have a separate auto_append and auto_prepend file for each web root or even directory within a webroot, right? On 3/2/07, Ryan Stille [EMAIL PROTECTED] wrote: You don't need to have access to the php.ini file. You can set those directives in an .htaccess file. I done this on shared hosting providers. If you did it in .htaccess the syntax would be: php_value auto_prepend_file Application.php php_value auto_append_file onRequestEnd.php -Ryan Christopher Jordan wrote: Probably not, but I didn't read where the original poster said he was using a shared host. And you're probably right, the shared host probably has these turned off. I was just trying to show that it *is* possible to prepend and append files in php. I'm also used to hosting my own. I'm fortunate enough to work for a small company who is in the business of hosting for our clients. Chris Tom Chiverton wrote: On Friday 02 Mar 2007, Christopher Jordan wrote: In fact, here are the two lines I included in my php.ini file (which on my fadoracore4 system is located in /etc) On a typical shared host, you wouldn't be able to set those parameters though, would you ? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cfdocument sizes
Wow I just went though this exact same problem. We tried everything, including posting to this list for help. Unfortunately we have not been able to come up with a solution and will probably end up converting to CFDOCUMENT. Are there any images referenced in your html? That seemed to be the cause of most of our hang ups. Without the images in there, htmldoc would produce the PDF *most* of the time, the only other time it would fail was on a very large text only report. If you are using images, are they from cfchart or static images? If you are using cfchart images, make sure you are using the name attribute and then writing the data to disk - don't use cfhttp to grab the graphs. Changing the referenced images from JPGs to PNGs helped a lot. The only thing not working now is our one very large text report. -Ryan E C list wrote: Hey Ryan- The cf_html2pdf works based on htmldoc.exe. And seems to be the root of the problems I am having with making my label pdfs in CF7. If I could figure out that problem, I would be all set. When I submit a page with that tag, I keep getting a timeout error when I try to access the tag, and it points to the htmlDOC.exe file. Timeout period expired without completion of c:\htmldoc\htmldoc.exe ... I have looked around the web for solutions to this but haven't found any. If you have any ideas of how you fixed the problem on your system, I'd really like to hear them. -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Friday, March 02, 2007 12:50 PM To: CF-Talk Subject: Re: Cfdocument sizes You could look at HTMLDoc, but I recently had a few problems with it moving from CF5 to CF7. -Ryan E C list wrote: Unfortunately they do not. It's a dymo label writer. I use it to create address labels for new customers (one at a time.)...I wish I could either figure out what's wrong with the html2pdf or figure out some other workaround. I don't know if there is going to be one though. Thanks for trying to help. -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Friday, March 02, 2007 12:25 PM To: CF-Talk Subject: Re: Cfdocument sizes Do the labels com on sheets of 8.5 x 11? If so, you could create a CSS workaround with multiple classes to align everything where it needs to go. Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 E C list wrote: Does anyone have any ideas? I was happily using CF_html2pdf on ColdFusion 5.0 to make pdfs, but now that particular server has been upgraded to ColdFusion 7 mx and that tag no longer works for me...(it just times out with a java error)...that would be no problem, but I was using the tag to make labels and print them off on a label printer...so the dimentions of the pdf have to be 1.4 inches by 3 inches. Unfortunately, with cfdocument you MUST make the dimentions larger than 2x2, so the small size labels cannot be created. Does anyone have any comments or a workaround? Thanks - Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Something weird?
Sounds like there is an htaccess file (or similar) in the directory
where the image resides.
-Ryan
Doug Brown wrote:
Ok...even weirder. I can switch images and the problem goes away, but if I
put the same image back voila there we go again. This is really starting to
peeese me off.
Doug B.
- Original Message -
From: Doug Brown [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, February 25, 2007 3:37 PM
Subject: Something weird?
I have a page that all it has on it is an image that is being placed via
CSS. When I preview in Firefox or Opera I am getting a request to
authenticate my credentials. If I remove the image (Remove the div) then
that does not happen. Any ideas? This is really irritating.
style type=text/css media=all
#banner{background:url(images/red_banner.jpg);
background-repeat:no-repeat; height: 79px; width:800px; margin:auto;}
/style
body
div id=banner/div
Doug B.
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270648
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is this the best approach?
As an alternative to dynamically creating/managing directories and copying code into them, here is what I have done in the past. Each time a sweepstake is added, modified or deleted, we recreated a .htaccess file in the root directory that sets up redirects for each sweepstake. So /sweepstakeName redirects to /sweepstakes/index.cfm?sweepstakes_ID=45 or /sweepstakes/index.cfm?sweepstakes_Title=SweepstakeName If you want the user to stay at /sweepstakename all the time and not be redirected, you could write out mod_rewrite lines instead. I'm not saying thats a better way of doing it, just another way. I prefer to have as few pieces of code-generated-code as possible. Also you might want to think of having an active flag, so a sweepstake could still exist and be viewed in the admin side, without actually giving users access to it. -Ryan Bruce Sorge wrote: I have been tasked by one of my customers to create an on-line sweepstakes. They want to be able to create a sweepstakes dynamically (title of the sweepstakes, questions, answers and control types). Also, they want to be able to run one or more sweepstakes at a time, but they do not want a link to all of the sweepstakes currently running from the home page. Rather they would want the customer to go to www.sitename.com/sweepstakesname. So here is what I have devised. If anyone has a better idea, I would love to hear it. DB Tables: Sweepstakes sweepstakes_ID int Sweepstakes_Title varchar Questions Question_ID int Question text Sweepstakes_ID Answers Answer_ID int Question_ID int Control_Type varchar Control_Name varchar Answer varchar CustomerAnswers Sweepstakes_ID int Customer_ID int Question_ID int Answer text I have an admin page that flows like this: Admin enters the name of the new sweepstakes. Then they go to the question section. They select the sweepstakes that they want to add questions to, enter in the question, then they go to a page that has them enter answers and control types (radio, checkbox, text, textarea). Once they are done entering the answers for that question, they go back to a new question and then do it all over again. As far as creating a new folder for each .cfm page for the sweepstakes, I thought that when they enter the sweepstakes title, they can enter a name for the directory, then I create a directory with CFDIRECTORY tag, and use CFFILE to copy the .cfm files from a main directory to the new directory. The main sweepstakes page is index.cfm so that should work. Then, when they are done, I can show them a page that has the URL of the sweepstakes they currently created, like www.sitename.com/newcoolsweepstakes. They can then copy and paste it to marketing email to customers. So what do you all think of this? Is this a descent approach or is there a better way to do it? Thanks, ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading CSV files with the ODBC text driver
I'm surprised you would get a file not found error if the file was there but locked? Are you 100% sure the file exists at C:\test\testfile.csv ? -Ryan It's not the same request, but a subsequent request in the same session - do you think it would still be locked by CF? Is there a way I can see for myself if the file is locked and by what process? Thanks Nick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfchart woes - vertical labels like 3.70333333
AJ that was very helpful. It worked great until I changed my gridLines value from 10 to something else. But it led me to discover this formula that seems to always produce whole number labels - scaleTo must be evenly divisible by (gridLines - 1) Thanks! -Ryan AJ Mercer wrote: From memory, when I was messing around with this, the scale needs to be a multiple of 9 So work out what the max value is and then get the next multipe of 9 so if the max val is 88 - set the top scale to 90 Hope this helps. On 2/10/07, Ryan Stille [EMAIL PROTECTED] wrote: I am converting some charts from cf5 (cfgraph) to CFMX7 (cfchart). My simple bar graphs that looked great in CF5 are not looking so good in CF7. My main problem is the y axis grid labels showing up as 3.703, 7.407, etc. Instead of 5,10,15 like they were before. I've been looking through the docs but I must be missing something. Here is what the new chart looks like: http://img408.imageshack.us/my.php?image=chart1wv2.jpg Here is what the old one looked like: http://img408.imageshack.us/my.php?image=chart2fp5.jpg I've played around with the gridLines and scaleTo but that doesn't seem to help. Thanks, -Ryan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick help on a mod rewrite rule
To do this in apache, you don't even need mod_rewrite. RedirectMatch /States/xq/ASP/StateName\.(\w+)/qx/index.htm /States/index.cfm?StateName=$1 Don't know if IIS has something like RedirectMatch or not... -Ryan Russ wrote: Pretty sure it's apache, since he mentioned mod_rewrite... Russ -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:53 AM To: CF-Talk Subject: RE: Quick help on a mod rewrite rule Mark, What web server are you using? Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:48 AM To: CF-Talk Subject: Quick help on a mod rewrite rule I apologize for those of you who may have seen this post on another list this morning... I'm having trouble finding an answer. I really suck at these. I need a rule that will turn this: http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.htm Into this: http://www.wheretobuild.com/States/index.cfm?StateName=Kansas I know that there are some regex and SES experts on this list. Can any of you do in like 10 seconds? My first 3 attempts based on samples failed... -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Issues with cfexecute in cfmx7?
I am converting an app from CF5 to CF7. This application makes use of an external program (htmdoc) to convert html into PDFs. The problem is when I feed it large html documents (200-300kb), it hangs when I cfexecute it. When I run the exact same command at a command prompt, it runs just fine. Any tips or tricks to using cfexecute on cf7? This is on Windows. The process only takes a second or two to execute when I run it at the cmd prompt. Thanks, -Ryan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Issues with cfexecute in cfmx7?
Yes it does work on the smaller files, but when I feed it a larger one it hangs. I've checked the process list and both cmd.exe and the htmldoc process are there. Each time I run the page I'll get another cmd and htmldoc process in the list. They stay there until I restart ColdFusion. They do not consume any CPU or increase their memory allocation. Also should have mentioned that the PDF file *does* get generated, but its a few kb short. If I try to open the PDF, the viewer says the file is corrupt. If I run htmldoc manually at a prompt, the PDF is a few Kb larger and I can open it just fine. -Ryan Gaulin, Mark wrote: Have you ever gotten in to work on cfmx7, or does it fail on every file? If it fails all of time, even on trivial inputs, then I would suspect permissions problems... Maybe temp directories or something like that. One way to test that angle is to login using the same account that cfmx will run as. (Check the service settings.) Can you see if the htmldoc process is actually running (using CPU, etc) when it hangs, or is the process there but not doing anything (0 cpu)? Mark -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 12:37 PM To: CF-Talk Subject: Issues with cfexecute in cfmx7? I am converting an app from CF5 to CF7. This application makes use of an external program (htmdoc) to convert html into PDFs. The problem is when I feed it large html documents (200-300kb), it hangs when I cfexecute it. When I run the exact same command at a command prompt, it runs just fine. Any tips or tricks to using cfexecute on cf7? This is on Windows. The process only takes a second or two to execute when I run it at the cmd prompt. Thanks, -Ryan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfchart woes - vertical labels like 3.70333333
I am converting some charts from cf5 (cfgraph) to CFMX7 (cfchart). My simple bar graphs that looked great in CF5 are not looking so good in CF7. My main problem is the y axis grid labels showing up as 3.703, 7.407, etc. Instead of 5,10,15 like they were before. I've been looking through the docs but I must be missing something. Here is what the new chart looks like: http://img408.imageshack.us/my.php?image=chart1wv2.jpg Here is what the old one looked like: http://img408.imageshack.us/my.php?image=chart2fp5.jpg I've played around with the gridLines and scaleTo but that doesn't seem to help. Thanks, -Ryan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Filenames in CFusionMX7\Mail\Undelivr folder
Andy Matthews wrote: Anyone? Google doesn't tell me whether I can depend on the filenames in the Undelivr folder being 100% unique. Just interested in getting recommendations for how I can be sure I'm checking a file's uniqueness. Andy Matthews Senior Coldfusion Developer Hash the contents of the file? I don't believe the contents change as it gets moved between Spool and Undelvr, so that should uniquely identify the file no matter what the name. -Ryan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cf.Objective conference registration is now open
FYI, I just noticed the registration for the cf.Objective conference finally opened up. http://www.cfobjective.com/conference/index.cfm?event=page.register -Ryan CF WebTools http://ryan.cfwebtools.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268607 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Windows Based Load testing?
I've had good luck with OpenSTA. Its free and runs on Windows. You can get it from opensta.org. -Ryan CF WebTools http://ryan.cfwebtools.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forcing a default directory on file download
Not possible with regular web browser technology. May be possible if you used an ActiveX for the download, or Apollo might be able to do something like this too. -Ryan OÄuz Demirkapı wrote: Hi I have a dummy client request that I wonder if there is a solution. We have a data file that we are exporting from our web based application. I created a download process and I force to download data file with cfcontent and client downloads this file to the local. After that client must put this file into a specific directory by just copying the file. But this process looks complicated for the client and they want to save this file direct into this specific directory. Ok they can select this directory and save file but they want to do this via application because they have different agents who does not know this directory in mind. When I prompt file download they want to see this specific directory as default save location. I said this is technically not possible, but before closing this request, I just want to be sure by asking here. Can we force to save into a specific directory or can we set default save location via application? Any idea? ~~~ Oßuz Demirkapñ TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
