Beyond this they seem to be a good company although I'm a little
squeemish about there not being telephone tech support available. That's the
impression I get from viewing their Web Site. Any feedback will be very much
appreciated.
Peter Donahue
My experience with them sucked. My hosting
How does one refresh application.cfc application variables without
restarting coldfusion services? Thanks in advance.
And I would recommend using a hard to guess url variable to fire off the app
restart:
?hardToGuessVar=1
Otherwise, hoodlums like Ray Camden will run around restarting your
I unashamedly admit I don't want to pay for a service if I can. Can anyone
recommend anything or alternatively I'm happy to run it off my own box if
someone can recommend some code etc
TIA!
I use aremysitesup.com
Works well.
Will
Hi Folks -
I am feeling dumb and either I am missing something simple or it's way
above me.
In my application.cfc, I was going to have a cfinclude that would pull
in my DB Name, user name, and password.
I would store those variables in application scope in onApplicationStart().
Gerald,
Your comments about CFB being slow bother me, and warrant some exploration.
Can you provide more detail? Do you have projects set up into a shared dev
environment over the network? I can't imagine that would be fast for any
IDE.
I'm not a CFBuilder fan, I've always liked DW. But let's
Curious to see what everybody's favorite coldfusion host is also?
Hostek? CrystalTech? DailyRazor?
+ 1 Viviotech. I feel much better knowing those guys have my back.
I have two VPS's with them. One for my Railo, one for my Database. No, it isn't
discount-cheap-fast food hosting. You
so I've got a site with a few Application.cfc (basically I want to
lock down some folders).
If everyone has to log in to hit the admin/Application.cfc does that
cfc need the onApplicationStart method or even onSessionStat methods?
And it shouldn't need the application variables either correct?
Am
After that I wanted to click the top submit button that submits
all
the other form elements to the action page. This of course
generates
Looks like your CF doesn't have access to createObject()
~|
Order the
Can anyone recommend any good tool that can be used for Coldfusion Code
Reviews?
I tried Sonar but could'nt find coldfusion plugin for the same.
I built one a couple of years back. You'd need to have some knowledge of Regexs
to use it. It uses a MySQL DB.
After that I wanted to click the top submit button that submits all
the other form elements to the action page. This of course generates
an error that says element data undefine.
It looks like you're binding to an id of #submit, but the submit button doesn't
have an id=submit, so the
I ran into a bizarre issue last night where FireFTP wouldn't overwrite my
Application.cfc. The site started erroring with invalid tokens.
When I viewed the code on the live server, I noticed the Application.cfc had
been appended to with as many cfcomponent tags as I had uploaded the files. I
Hello All.
Is there a utility that will allow me to copy the tables and structure from
an MS SQL database to a mySQL one?
Thanks
I use this product - works flawlessly. When moving large amounts of data, just
be sure to go into settings and use NO skin. It bogs it down. Otherwise it
works
Can anyone recommend a decent VPS host with a basic windows server
setup that would allow several developers to login and develop
remotely?
Dan
- 1 kickassvps - aremysitesup.com overloaded my phone txts with server down
notifications. I had other problems with support as well. Don't
transferring data from one app to another
I'd just use Navicat to transfer the data. No CF needed. Quick and easy.
Will
~|
Order the Adobe Coldfusion Anthology now!
Hi,
I am running the following cfquery which inserts a large amount of
rows into a table (approx 2200)
Just out of curiosity, where does your insert data originate from?
~|
Order the Adobe Coldfusion Anthology now!
Thanks, but it is not that simple.
I have plenty of things to check, convert, validate, etc.
Don't forget an Excel file is created and filled by humans ;-)
I would figure out a way to use my RDBMS to handle this. Navicat or SQL Server
tools to do it.
Then clean the data or whatever once it's
Demo: http://www.opensourcecf.com/cffm/demo
Rick, the demo doesn't come up:
HTTP Status 404 - /cffm/demo/
Thanks,
Will
~|
Order the Adobe Coldfusion Anthology now!
Hi list, is there any social network application / social network
framework based on CF you guys are aware of ?
Thanks in advance for your feedback !
Uwe
This one is PHP, but I know folks that seem to love it.
http://www.socialengine.net/
Will
Richard Brain of ProCheckUp commented âThis is a trivial attack which
can be performed easily by a competent engineer; ProCheckUp thanks
Adobe for consciously working with us to produce a patch which fixes
the traversal attack. By performing a simple Google search for
inurl:index.cfm,
The general consensus is that CFCs should be used primarily to encapsulate
logic, and data retrieval. If you want to output something it really should
be in a CFM page, or a custom tag.
Man, consensus scares me. :)
Will
~|
I keep trying to post to this thread but HOF is down. hehehehe!!
Why is no one mentioning the Java argument? Ask your friends if they think Java
sucks and can't handle load.
Then you got'em by the gonads.
Will
~|
Order
Why not just use CFQUERYPARAM bound parameters in your SQL?
In my case, I'm scrubbing the data. cfqueryparam doesn't do that.
~|
Order the Adobe Coldfusion Anthology now!
I'm building a form cleaner utility method that might help thwart some XSS,
clean my fields up, etc. Know I can't stop it all. Didnt see anything on
riaforge exactly like what I'm lookin for here.
Here's what I've got so far. Anyone have anything to add?
cffunction name=cleanFormFields
Hi, Jim...
Check into www.KickAssVPS.com.
I've been with them for two years and haven't had a single
moment of downtime. Seriously...
I was with them for a few months and I had to move to a better host. I have an
account at aremysitesup.com, which sends me txts when one of my sites is down.
Could someone show me an example? I've tried all kinds of stuff with no luck.
Thanks,
Will
~|
Order the Adobe Coldfusion Anthology now!
Use an inner join on the id's that you wish to link across the tables.
I don't get what you mean Andrew. Sorry.
~|
Order the Adobe Coldfusion Anthology now!
MySql 5, I have this product schema. There are other tables involved but this
is the pertinent part.
tblskus
skuid pk
sku_prodid
more fields...
tblskuoptions
skuoptionid pk
skuoptionname
more fields...
tblskuoptions_rel (linking many table)
skuid fk
skuoptionid fk
The user is
Ok, I'm now straying into OT area, but I must be the only who liked the idea
of PRODUCT YEAR as a brand. Ie, Windows 95, Windows 98, Windows 2000. To me it
was a very clear way to know the release of the version you are using.
This sounds perfect for Rick. Where's dave when we need'em??
:)
Seems to work beautifully! Thanks!
As long as you don't have any variables/values with cf in them. hehehe..
cfqueryparam value=anythingcfanything / doesn't match.
~|
Order the Adobe Coldfusion Anthology now!
Anyone know any good, reasonable CF 9 hosting companies w/ mysql.
Thanks!
+ 1000 for viviotech. They rock.
Will
~|
Order the Adobe Coldfusion Anthology now!
Playing with some CFGRID examples on ColdFusion 9, I noticed some
major slowdown without a lot of records being loaded. Being on a
locally hosted server off my workstation that concerned me even more.
I like jqGrid. cfgrid bit me in the butt when I moved to Railo. jqGrid fixes
that
I turned off Syntax Checking:
Preferences ColdFusion Editor Profiles Editor Syntax Checking
Turned off Build Server Settings
Preferences ColdFusion Server Settings Build Server Settings
I downloaded it, installed it, used it for about 20 minutes, and realized it
was the most
2 ?'s
I need to show a difference between to dates
basically how much time is left between the ending date and now. can
cf do this or should I use a java script?
also, how do I use a Now() but add 3 hours to the output?
server is 3 hours behind but I need to be the current time. I don't
actually
I already have it:)
just really sick of reading it at the moment. lots to absorb, short amount
of time
Dave,
CF is a lot to absorb chief!! LOL!!!
~|
Want to reach the ColdFusion community with something they want?
Now that my dev machine is being rebuilt, one of the things i have to
do is work out if the way I've been doing things is still the best way
of doing them.
+1 dbconvert.com. They have an amazing slick application there. I happen to use
it to convert MSSQL MySQL. Works like a charm.
Anything you could do to make jQuery have to do less work will be
beneficial.
Andy,
This works great for form actions. I've played around with doing the exact same
thing for any inputs with onclick attributes. But JQ doesn't seem to select up
the value of the onclick. Do you have any ideas?
It sounds like you're talking about jQuery manipulating jQuery code?
Not in these cases. This is some legacy JS in our onclicks.They must remain,
but they contain mappings that I need to do the exact same thing we did realier
in the form action. The code to be manipulated looks somethin like
It sounds like you're talking about jQuery manipulating jQuery code?
Andy, this seems to do the trick with grabbing my input code string.
var htmlStr = $(':input').append($(':input').clone()).remove().html();
Thanks,
Will
Your problem is twofold.
1) change $(this) to this $('body') (assuming that the text will only appear
within the body tag.
Thanks Andy!
I'm having a problem with the page choking on this line:
$('body').html(replaced);
It literally bogs thr browser down and it just churns away with a blank
Your problem is twofold.
1) change $(this) to this $('body') (assuming that the text will only appear
within the body tag.
Thanks Andy!
I'm having a problem with the page choking on this line:
$('body').html(replaced);
It literally bogs thr browser down and it just churns away with a blank
I didn't get any response on the jquery list, so I'm reposting this here.
Hey,
I need to traverse an entire DOM, find a match for a pattern like this:
someController.somemapping
And I need to replace that text with this:
someController.somemappingsomeURLVar=someValue
This pattern could be
I recently switched to using the latest Microsoft JDBC Driver for
MSSQL 2005
and immediately saw a performance increase (over using the standard
driver
w/ ColdFusion 8.01). However, all our queries that have multiple
statements
are failing so I've had to switch back. e.g.
I know with
Does anyone have any good methods for testing or monitoring SQL
Injection they are willing to share?
Thanks!
Here's a good resource we use to test attacks:
http://ha.ckers.org/xss.html
Will
~|
Want to reach the
Iâm trying to get four related selects to work---basically, you can
change any one of the selects and it will reload the other 3 based on
your selection.
I've used qForms with great success. I had up to 7 related selects - handled
it, no problem.
.
On Mon, Nov 23, 2009 at 10:10 AM, Will Tomlinson w...@wtomlinson.comwrote:
Yeah, mine had hundreds of items. All the data is loaded into JS, so there are
no ajax calls to make, which makes it superfast instantaneous.
Will
~|
Want
Hi All,
Anyone know of a good MySQL list? I have to take on a project that has
a PHP/MySQL backend. Thankfully it's a short term thing as the entire
site is getting migrated. In the mean time I need to find a tool
similar to Enterprise Manager/SQL Studio for MySQL.
I like Navicat for
i'm not very familiar with sql server syntax, but would something like
this work?
SELECT IFNULL(cpn.numCoupons,0) as numCoupons, couponcode,
THEORDERDATE
Hmm. didn't work. SQL server didn't like it. :(
I just simplified it and didn't break it down by the day. I got somethin
that'll
SQL Server
I'm trying to report on the number of orders per day that has coupon code
associated with them. The problem is, we can have multiple coupons running at
the same time. My query just counts the number of coupons used per day. It
doesn't filter by couponcode.
But the minute I
A couple of things that I'd like to do with local deployment of my web
app using an open source cfml engine. FYI, I ran some quick search,
unsatisfactory.
If you're using railo, why not ask on the railo list?
Will
~|
The session logout time is fairly short and everytime you write a long
post you got to copy and paste to save your work and relogin to post,
arg
I would just stop posting if I were you. I'm sure everyone would agree this is
the best solution. :)
Will
I have help with problems to your motivated issue of capable proportions that
might hint to the extinction of the not cf coding issue...
Here's a situation I hope you could provide some thoughtful input.
I've converted a cf8-based app into an open source one. Initially it
seemed all's
I'm trying to match if a pageID list doesn't end with:
,services.wpViewingHistory
And has a siteList with W in it.
Here's my regex:
We're using a cfgrid. Pagesize is 25. If you specify href, and there are less
than 25 results are returned... then remaining rows are empty but still
clickable.This results in CFGRIDKEY=null
Thanks,
Will
~|
Want to reach the
Hey,
CF8 - mySql 5 on both boxes.
I've added allowMultiQueries=true in CF Admin on my live server, and it works
just fine with letting me use multiple selects within one cfquery
So I added it to my development machine, but it doesn't work. My queries still
error due to the semicolon and
Oh, I fixed it! I just deleted the DSN and created a new one with the new
connection setting. Seems to have worked.
Thanks,
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
Hi all,
I have an issue with a stored proc that hopefully someone can help with...
A little background...
I built a CF based message queue system. It is pretty simple; I have a table of
'messages' in the database. I can fire up as many infinite threads as I want
and they process those
Don,
I guess it's time to invite you to the Railo Google group.
THANK YOU GERT! I thought you'd never offer!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
Man, I have no idea what I'm doin.
hehe, i often feel that way, too :)
Ahhh thank you! I will give it a shot tonight. And the JS you posted does
indeed go in product_add.cfm, correct?
Thanks much,
Will
~|
Want to reach
your form processing javascript will then look something like this:
Ahh yes, this works! I just need to stick a .tabs() in there that selects the
next tab after submission.
Thanks!
Will
~|
Want to reach the ColdFusion
Man, I have no idea what I'm doin.
hehe, i often feel that way, too :)
Hot damn! I'm gettin' fancy now. Check this out.
I decided to try and preselect the categories tab after the product is added.
Like a wizard. I'm also passing my ID to each tab so you can use them for
inserting into
go here: http://jqueryui.com/demos/tabs/
click on Methods tab. read about the 'URL' method.
presumably, your product_add.cfm page adds a product using ajax post? if
so, the callback function should receive the id of newly added product
and then call the url() method on the other tabs (and maybe
a safe bet would be to define all your js in the main page (tabs.cfm).
but particulars depend on your code...
how are you submitting your add product form? are you using jquery (i.e.
$.ajax or $.post) or are you using cf8 built-in ajax features
(cfajaxproxy or ColdFusion.Ajax.submitForm())?
I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken it
up a bit. As a product is added, I need the tab .cfm's, and the parent to pass
around the prod ID variable to each other.
The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs
I have a parent page that
go here: http://jqueryui.com/demos/tabs/
click on Methods tab. read about the 'URL' method.
presumably, your product_add.cfm page adds a product using ajax post? if
so, the callback function should receive the id of newly added product
and then call the url() method on the other tabs (and maybe
I started out that way, but couldn't make a join of any type work...
I tried left join, inner join, join, union, etc, but the best I could do
was get one title with one section. There should be one title with
multiple sections.
Rick,
1. I would remove the * and reference your fieldnames.
2.
anyone got any idea , what is going wrong
It's virtually impossible to know what is going wrong unless we see some of
your
code!!
!
Hope this helps,
Will
I think I'm going to use this tool:
http://nstree.riaforge.org/
I've been playing around with it. Seems fairly straightforward and does
everything I need.
I'm just working on what the admin interface would look like to display the
entire tree so you could select multiple categories for a
I built a store application that has a simple product category schema. Right
now, the user can select one or more categories to associate to a given
product. I have a linking table in between those two tables that resolves the
many-to-many.
Now, I need the ability to let the user create
This might be useful:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Cheers,
Dave
Yes, there's a lot of great info there. But it looks like a nightmare if I want
to add a node under the parent.
Products
-baseball
--gloves
--bats
--shin guards
-golf
--gloves
--bags
@willr u ok with setting a maximum number of levels?
--
Ryan
Yep. I could max it out at 4 levels. I had thought about building related
tables, 4 of them.
Thanks,
Will
~|
Want to reach the ColdFusion community with
Thanks to everyone for their help with this!
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:
I have your typical tblorders. I'm trying to query it to get order totals by
month, and I'm outputting them in cfchart
All goes fine, except in 2009. We have no order data for April-December of
course, so the query returns just three rows (Jan, Feb, March).
I need it to return all 12 months,
I need a quick favor from someone who has access to a Vista box.
type
echo %OS%
from DOS prompt
and let me know what you got.
I'm a bad googler.
It crashed on me. Thanks don L.
~|
Adobe® ColdFusion® 8 software 8 is the most
thanks for the tips guys!
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:
I'm planning on using onMissingMethod() to create some pretty URL's for
products, using a new db field (productPrettyTitle) in my products table. I'd
rather not use an ISAPI filter right now.
Everything seems to work OK so far, but I wondered what would happen if I took
it a step further.
I have an uploaded file named: CIY '06 001.jpg (That's
CIYspace'06space001.jpg)
I want to change the name of that file to: CIY06001.jpg
Dunno if this is an option rick, but I usually use bobby h's trick of creating
my own filename for the images. Then you don't need to worry about
I am working on Dropdown List and was just wondering how to make the
dropdown list selected data preserved.
cfform prevervedata=yes works for other Formfields but not the
drowpdown list?
Does your select menu use cfquery data?
Problem is, the order date they are passing is in Greenwich Mean
Time, and looks pretty funky to me:
I used this. Seemed to work fine...
http://www.cflib.org/udf/DateConvertZ
Will
~|
Adobe® ColdFusion® 8 software 8 is
I have a user submitting an image via a form.
I would like to make a function in my cfc to upload the file. What do
I put in the fileField attribute of CFFile?
Arguments.TitleImage or Form.TitleImage?
What type do I set for the cfargument? String? Binary?
Thanks, everyone, for pointing out the goofy errors in the attributes.
I don't know how I got those in there...copy and paste gone wild, or
something.
Maybe just old-age confusion... :o)
Rick, have you thought about just quitting CF altogether? And maybe taking up
PHP or .NET??
:)
Will
Interesting Will. So does your outer-most structure have some sort of
incremental key? Personally an array of structs seems easier to me
because the array implies a series of something. As far as updating
and the code to deal with them it is pretty much 6 or 1/2 dozen I
would think.
I have a
MySQL 5
My client wants to run a report on taxes collected for a given month in a given
year. I have a typical orders table with an âordertaxâ field and
âorderdateâ field. Iâm remote right now so I canât test this, but how
could I spit out order totals for each month. Hereâs
cfif session.allowin neq true
cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm
cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm
cfelse
!--- Not logged in, alert user and redirect ---
script
!---alert(You must login to access this
I find a structure of structures to be better-understood, and easily updated.
I have some example code from my cart if you want it.
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
What version of ISAPI Rewrite are you using?
The tutorial looks as though it's written for v2; whereas in v3 it is
much more like the syntax of Apache's mod_rewrite. Which means that
the querystring is not actually seen as part of the URL in
RewriteRule, but can be accessed via a
And this assumes that the files are at your site's root, and that it's
always an EID value you're matching. (If the key value in the
querystring varies, you could use a regex for that too).
Thanks Seb!
So I could say:
RewriteRule ^calendarDetails\.html/[A-Za-z]+/([0-9]+)$
This should do the trick:
RewriteRule ^calendarDetails\.html/EID/([0-9]+)$ /calendarDetails.cfm?
EID=$1 [NC]
Seb, this works just fine in the ISAPI test utility, but I cannot get the URL
variable to show up in URL scope of the page, which of course, cause an error.
I'm attempting my first SES URL rewriting with the IIS ISAPI filter, and having
a few problems.
I wanted to process .html files as .cfm's. That part seems to work, but I have
another rule that converts /EID/993 to ?EID=993
My URL var doesn't seem to be seen on the action page.
You know you don't have to use a rewrite tool to do that - you can just
map the .html extension to CF in IIS.
Well I'm eventually wanting to create friendly URL's.
/someVolleyballShirt.html.
I think you might need to use the .html extension.
I tried it with and without. No matter what I
I'm getting errors when i attempt to upload images to a site using an
image upload form I've done. But I'm not sure why.
What does your file processing code look like?
Will
~|
Adobe® ColdFusion® 8 software 8 is the most
How do I get the above section to submit the selected voucher to
populate the remainder of the form with the relevant details before I
submit the form for processing? TIA
Sounds like you could use an onchange event in that select to submit the form.
Use that for your cfif to run that query
I don't want to use the new result variable in CF8 here. What's the right
syntax for getting the last inserted ID in mySQL. I'm getting a syntax error
with this:
insert into sometable (fields...)
values (values)
;
select last_insert_id() as lastinsert
Found a beautiful post by ben on this subject. Thanks ben!
http://www.bennadel.com/blog/1209-Turning-On-Multiple-Statements-In-ColdFusion-8-MySQL-4-5-Datasource.htm
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important
MySQL doesn't allow multiple statements in a single query unless you
change a server config option. It's a form of SQL injection
protection. So just run the two statements in two CFQUERY tags.
You'll need to ensure they're on the same connection with no
interleaved queries though, so make sure
I played around with WebLoad and thought it was pretty easy to use.
http://www.webload.org/
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Should I be able to set up my local dev environment mappings,
where I view all http requests through localhost/...,
and my remote server environment mappings, where the server
is a multi-homed webserver, in such a way that the same
logical path will work in both places?
When I used to use the
I'm heartily sick of the tedious way I have to spend half a day or
more EACH WEEK uploading and downloading databases from my
SQLServer2005 web sites.
Not that it helps you any, but this is exactly the reason I've moved most of my
websites to MySQL. Navicat makes this kinda thing completely
cf express + :oP
I think rick uses cf express beta.
~|
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:
i also have to warn you having multiple domains with the same content
can class as duplicated content in Google. If Google decides the
websites are the same it WILL only index one of them or only one
domain will come up per search query i.e. sports. this rule will also
apply to sub
I'm just wondering what will happen with SSL. Never done it like that before.
Thanks,
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
1 - 100 of 1735 matches
Mail list logo