Re: (ot) Hacked by Fatal Error
of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.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:322854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
creating variables from a query problem
HI everybody,, Am stucked... I have a query with 9 rows. I need to store every row into a different distinct variable. my query is listed below cfquery name=getcs datasource=#datasource# SELECT COUNT(s.id) AS cscount FROMSociety s WHERE s.gr='cs' group by s.asst /cfquery cfoutput query=getcs startrow=1 maxrows=1 cfset row1=cscount /cfoutput cfoutput query=getcs startrow=2 maxrows=2 cfset row2=cscpimt /cfquery etc row9 I have to repeat the above code 9 times which is equivalent to the rows of my query...Is there a way of not doing this?.. thanks ~| 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:322855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating variables from a query problem
I need to store every row into a different distinct variable. You probably don't, and should instead be using an array. MyValues = ListToArray( ValueList( MyQuery.ColumnName ) ) Then you can do MyValues[1] to MyValues[9] to get at the variables. If you *really* need to create individual variables, you can then do: cfloop index=i from=1 to=#ArrayLen(MyValues)# cfset Variables['MyVariable#i#'] = MyValues[i] / /cfloop But don't do that - use the array. ~| 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:322856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating variables from a query problem
Thanks will do that then I need to store every row into a different distinct variable. You probably don't, and should instead be using an array. MyValues = ListToArray( ValueList( MyQuery.ColumnName ) ) Then you can do MyValues[1] to MyValues[9] to get at the variables. If you *really* need to create individual variables, you can then do: cfloop index=i from=1 to=#ArrayLen(MyValues)# cfset Variables['MyVariable#i#'] = MyValues[i] / /cfloop But don't do that - use the array. ~| 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:322857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 SQL Deadlock
Hello, I have read just about everything I can (searched just about all forums, adobe, etc) and can't find an answer. We are running CF 8 Standard and FusionReactor 3 and have a heavy load application running but we are starting to get SQL deadlocks. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 87) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. brThe error occurred on line 115. This isn't happening on a particular cfm page but random. While looking in the FusionReactor logs, I am noticing that this seems to be only happening when the Finished Request Count in FR is above CF's Maximum number of simultaneous Template requests (which is set to 60). I am guessing (that is what I need clarification on) that this is what is giving us the deadlocks? Should we be using CF Enterprise? Any help would be greatly appreciated. Thank you Andy ~| 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:322858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 SQL Deadlock
Hello, I have read just about everything I can (searched just about all forums, adobe, etc) and can't find an answer. We are running CF 8 Standard and FusionReactor 3 and have a heavy load application running but we are starting to get SQL deadlocks. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 87) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. brThe error occurred on line 115. This isn't happening on a particular cfm page but random. While looking in the FusionReactor logs, I am noticing that this seems to be only happening when the Finished Request Count in FR is above CF's Maximum number of simultaneous Template requests (which is set to 60). I am guessing (that is what I need clarification on) that this is what is giving us the deadlocks? Should we be using CF Enterprise? Any help would be greatly appreciated. Thank you Andy Forgot to mention, we are not using CFLOCK anywhere. Thanks ~| 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:322859 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 variables from a query problem
Just to throw out another solution, you can get the same result you initailly tried by doing the following: cfloop query=getcs cfset variables[rowgetcs.currentRow] = getcs.cscount / /cfloop On Thu, May 28, 2009 at 7:58 AM, Peter Boughton bought...@gmail.com wrote: I need to store every row into a different distinct variable. You probably don't, and should instead be using an array. MyValues = ListToArray( ValueList( MyQuery.ColumnName ) ) Then you can do MyValues[1] to MyValues[9] to get at the variables. If you *really* need to create individual variables, you can then do: cfloop index=i from=1 to=#ArrayLen(MyValues)# cfset Variables['MyVariable#i#'] = MyValues[i] / /cfloop But don't do that - use the array. ~| 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:322860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Thanks, Will! I don't remember using the group function as part of a query like that. I had always just looped one query around another. When did the group function show up as a query output function in CF? CF5? (Well, I guess that's what I get for going from CF 4.5 straight to CF 8...or was the group function in CF 4.5, too?) Another thing that confused me was using cfoutput/cfoutput inside the cfoutput query = At first I left them out thinking you had made a coding error! (!!! :o) But when I took them out, the looping didn't work correctly...put them back in and it worked fine...strange...(at least to me) The help is much appreciated! Rick On Wed, May 27, 2009 at 11:58 PM, Will Tomlinson w...@wtomlinson.comwrote: 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. Remove that group by n the SQL. 3. Your query output should look something like this: cfoutput query=getStuff group=theTitleFieldHere h1#someTitleField#/h1 cfoutput p#theDetailField#/p /cfoutput /cfoutput See if that works. Will ~| 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:322861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(ot) InfusionSoft API using CF
I have a request from a client to integrate a CF application with InfusionSoft's API. Any CF programmers done any work with InfusionSoft API and CF? Thanks, Dave ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IUM Re: Google Map API
Umm .. no .. it's in there ..
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
map.addOverlay(marker);
missing ;
maybe
On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
(message bumped with corrected subject ... help !!!)
hi all .. trying to get a marker to show on the google map api ... extract
of code below ..
anyone have any ideas as to why my marker isn't visible, please?
tia, jenny
cfoutput
script
src=http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey
#
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14);
map.addControl(new GSmallMapControl());
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#),
3);
var point = new GPoint(#dLatitude#, #dLongitude#);
var marker = new GMarker(point);
map.addOverlay(marker)
}
}
//]]
/script
/cfoutput
~|
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:322863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfflush issues
Hey gang - Having some issues with cfflush not... flushing. :P Same page, same code, running on two different servers - flush works on one, not the other. Both servers are sporting CF8, but the underlying platform is different - Windows 2k server (working) vs. Windows 2003 server (not working). I've googled around and found some posts in the past regarding cfflush and IE, and needing to push out some extra content for IE to go oh, time to update - but this is a different issue. I've tested using both IE and FF, same results. Now, due to other display issues, I'm having to rethink how this page works - but I'd still like to resolve this issue... any thoughts? Is it an IIS version issue (which is my initial thought)? The two boxes are also in different locations - first box that works is my dev box, which is on our server guy's home network (decent bandwidth, considering) and the second box is a production box in a co-loc. So I wonder if perhaps a difference in the routers in use may be a cause (highly doubtful, I know)...? ~| 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:322864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating variables from a query problem
And finally, you could simpy reference the original query using array notation (e.g. getcs[cscount][1], getcs[cscount][2] etc) and avoid the extra work. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/28 Scott Stroz boyz...@gmail.com: Just to throw out another solution, you can get the same result you initailly tried by doing the following: cfloop query=getcs cfset variables[rowgetcs.currentRow] = getcs.cscount / /cfloop On Thu, May 28, 2009 at 7:58 AM, Peter Boughton bought...@gmail.com wrote: I need to store every row into a different distinct variable. You probably don't, and should instead be using an array. MyValues = ListToArray( ValueList( MyQuery.ColumnName ) ) Then you can do MyValues[1] to MyValues[9] to get at the variables. If you *really* need to create individual variables, you can then do: cfloop index=i from=1 to=#ArrayLen(MyValues)# cfset Variables['MyVariable#i#'] = MyValues[i] / /cfloop But don't do that - use the array. ~| 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:322865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
IUM Re: Google Map API
Thanks Alan ...
Here is the rendered code ...
script
src=http://maps.google.com/maps?file=apiamp;v=2amp;key=ABQIiM57Lca47g
ZUZAGU9VAgzxSgDYqnW_JCrkwCqigUjd1zUJsCbRRgKmt_eNGlKyP-RjRNHj7jzDkmgA
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(51.5398228, -0.1926350), 13);
map.addControl(new GLargeMapControl());
map.centerAndZoom(new GPoint(51.5398228, -0.1926350), 3);
var point = new GPoint(51.5398228, -0.1926350);
var marker = new GMarker(point);
map.addOverlay(marker);
}
}
//]]
/script
-Original Message-
From: Alan Rother [mailto:alan.rot...@gmail.com]
Sent: 15 May 2009 19:37
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
Can we see what the rendered JS code looks like? There is the possibility
that the marker you are creating has an invalid geocode.
=]
--
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org
~|
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:322866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
IUM Re: Google Map API
Thanks Paul, but I put the ; in and no change
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
map.addOverlay(marker);
missing ;
maybe
On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
(message bumped with corrected subject ... help !!!)
hi all .. trying to get a marker to show on the google map api ... extract
of code below ..
anyone have any ideas as to why my marker isn't visible, please?
tia, jenny
cfoutput
script
src=http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey
#
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14);
map.addControl(new GSmallMapControl());
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#),
3);
var point = new GPoint(#dLatitude#, #dLongitude#);
var marker = new GMarker(point);
map.addOverlay(marker)
}
}
//]]
/script
/cfoutput
~|
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:322867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IUM Re: Google Map API
I assume you are not getting any javascript errors?
--
Ryan
On Thu, May 28, 2009 at 7:54 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
Umm .. no .. it's in there ..
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
map.addOverlay(marker);
missing ;
maybe
On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
(message bumped with corrected subject ... help !!!)
hi all .. trying to get a marker to show on the google map api ...
extract
of code below ..
anyone have any ideas as to why my marker isn't visible, please?
tia, jenny
cfoutput
script
src=
http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey
#
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14);
map.addControl(new GSmallMapControl());
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#),
3);
var point = new GPoint(#dLatitude#, #dLongitude#);
var marker = new GMarker(point);
map.addOverlay(marker)
}
}
//]]
/script
/cfoutput
~|
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:322868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfreport rtf images
I have a cfreport that needs to have images in the footer. The images are working fine if I output the report in PDF or Flashpaper, but don't show up in RTF or Excel (RTF is the needed output). Things I've tried: -using URLs, file paths, and blobs from the db...same result with each -using jpeg and gif as the source image...same result This is on a Win2003 CF8 Ent box. Any ideas? Anybody use cfreport? ~| 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:322869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
w3c validator and *.cfm files
Is it possible to use the W3C validator tool at: http://validator.w3.org/ to check cfm files? Terry Troxel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: w3c validator and *.cfm files
Is it possible to use the W3C validator tool at: http://validator.w3.org/ to check cfm files? Yes, just put in the URL to your file. You can't upload a file to it, because CFML is not valid HTML or XHTML. The validator will have to receive the output of your .cfm file. You could, I guess, save the output and upload that. 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:322871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
question on jquery..need answer pretty quickly if possible
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am wondering
if I can create my own searchable list from query results and replace the list
below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322873
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) Hacked by Fatal Error
How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.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:322874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all')
]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by cfoutput#myList#/cfoutput
in the script
Theer are other ways of doing this I'm sure, but that's the one I would use to
go faster
Stéphane
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am
wondering if I can create my own searchable list from query results
and replace the list below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,
Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,
Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322875
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Hacked by Fatal Error
It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.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:322872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfreport rtf images
OK, I answered part of my own question. The RTF output has a empty box placed over the image for some reason (I mistakenly thought that was its attempt to show the image). Now to figure out how to have it not show that box. On Thu, May 28, 2009 at 9:08 AM, Jim Wright wright...@gmail.com wrote: I have a cfreport that needs to have images in the footer. The images are working fine if I output the report in PDF or Flashpaper, but don't show up in RTF or Excel (RTF is the needed output). Things I've tried: -using URLs, file paths, and blobs from the db...same result with each -using jpeg and gif as the source image...same result This is on a Win2003 CF8 Ent box. Any ideas? Anybody use cfreport? ~| 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:322876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
Nice Stephane.
I did one like this: (Way too much code obviously but it works)
cfparam name=city_list default=
cfloop query=getCities
cfif getcities.recordcount NEQ getcities.currentrow
cfset city_list = city_list '' getcities.city ','
cfelse
cfset city_list = city_list '' getcities.city ''
/cfif
/cfloop
$(document).ready(function(){
// City dropdowns
$(#city).autocompleteArray([cfoutput#city_list#/cfoutput]);
});
/script
--
Ryan
On Thu, May 28, 2009 at 9:08 AM, Stephane Vantroyen s...@emakina.com wrote:
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [
ListQualify(ValueList(myQuery.NameofField),'',',','all') ]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by
cfoutput#myList#/cfoutput in the script
Theer are other ways of doing this I'm sure, but that's the one I would use
to go faster
Stéphane
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am
wondering if I can create my own searchable list from query results
and replace the list below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,
Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,
Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Rick, If it looks unclear, you can also do the following: cfoutput query=getStuff group=theTitleFieldHere h1#someTitleField#/h1 cfoutput group=theDetailField p#theDetailField#/p /cfoutput /cfoutput Note that the inner CFOUTPUT has 'group' attribute, but no 'query' attribute. The plain CFOUTPUT inside an existing query-CFOUTPUT is the equivalent. ~| 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:322878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOAP Request
I know how to use cfobject type=webservice and AddSOAPRequestHeader() to generate a SOAP request like this: s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/; s:Header h:UserName xmlns:h=[namespace]username/h:UserName h:Password xmlns:h=[namespace]password/h:Password /s:Header s:Body ThisFunction xmlns=[namespace] /ThisFunction /s:Body /s:Envelope ...this is equivalent to calling ThisWebservice.ThisFunction(). But, when ThisFunction requires: ThisFunction xmlns=[namespace] ThisArg i:type=ThisType xmlns:i= http://www.w3.org/2001/XMLSchema-instance; ThisFieldsomething/ThisField ThisFieldsomething/ThisField ...etc... /ThisArg /ThisFunction ...equivalent to calling ThisWebservice.ThisFunction(ThisArg), how do I first build the ThisArg struct(?) in order to get i:type and ThisFields in there? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| 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:322879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Thanks
The list creation does exactly what I need it to but the cfoutput... does
work.
It's not giving an error but the autocomplete does nothing.
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',
','all') ]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by
cfoutput#myList#/cfoutput in the script
Theer are other ways of doing this I'm sure, but that's the one I
would use to go faster
Stéphane
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am
wondering if I can create my own searchable list from query results
and replace the list below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,
Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,
Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,
Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,
Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,
Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322880
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Hacked by Fatal Error
I would have considered it strong - 9 chars, letters/numbers/other chars mixed case. The ftp logs don't show anything though. I looked into turning off webDav on it since its IIS 5.0. I just wish I felt better about knowing how they got in. -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Thursday, May 28, 2009 10:12 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.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:322881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfreport rtf images
Final answer, if anyone ever has this issue: There is a Transparency attribute that defaults to Opaque on the image object. In Flashpaper and PDF, the image shows up with that set...in RTF, it puts a box over top of it. ~| 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:322882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
How does your source look?
--
Ryan
On Thu, May 28, 2009 at 9:25 AM, Torrent Girl torrentg...@gmail.com wrote:
Thanks
The list creation does exactly what I need it to but the cfoutput... does
work.
It's not giving an error but the autocomplete does nothing.
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',
','all') ]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by
cfoutput#myList#/cfoutput in the script
Theer are other ways of doing this I'm sure, but that's the one I
would use to go faster
Stéphane
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am
wondering if I can create my own searchable list from query results
and replace the list below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,
Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,
Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,
Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,
Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,
Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322883
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) Hacked by Fatal Error
Any chance they were an old employee etc that knew the password? -- Ryan On Thu, May 28, 2009 at 9:34 AM, Scott Mulholland smulholl...@aimg.comwrote: I would have considered it strong - 9 chars, letters/numbers/other chars mixed case. The ftp logs don't show anything though. I looked into turning off webDav on it since its IIS 5.0. I just wish I felt better about knowing how they got in. -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Thursday, May 28, 2009 10:12 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.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:322884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Have you tried to dump the value of the list to see if it matches the format of
the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput;
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(scriptList),
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
Thanks
The list creation does exactly what I need it to but the cfoutput... does
work.
It's not giving an error but the autocomplete does nothing.
~|
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:322885
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
Yes I dump it and the list is correct. I'll try your other sugg...
Have you tried to dump the value of the list to see if it matches the
format of the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput;
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(scriptList),
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
Thanks
The list creation does exactly what I need it to but the cfoutput...
does work.
It's not giving an error but the autocomplete does nothing.
~|
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:322886
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
Would it look like this?
cfoutput
script type=text/javascript
var scriptList = '#myList#';
$(document).ready(function() {
$(##country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(##city).autocompleteArray(
scriptList,
{
minChars:1,
delay:10,
autoFill:false,
matchSubset:10,
matchContains:10,
selectOnly:10
}
);
});
/script
/cfoutput
Have you tried to dump the value of the list to see if it matches the
format of the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput;
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(scriptList),
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
Thanks
The list creation does exactly what I need it to but the cfoutput...
does work.
It's not giving an error but the autocomplete does nothing.
~|
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:322887
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Yes, i guess... if still not working try displaying an alert of the var in the
script, to see what's wrong with it
Would it look like this?
cfoutput
script type=text/javascript
var scriptList = '#myList#';
$(document).ready(function() {
$(##country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(##city).autocompleteArray(
scriptList,
{
minChars:1,
delay:10,
autoFill:false,
matchSubset:10,
matchContains:10,
selectOnly:10
}
);
});
/script
/cfoutput
~|
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:322888
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Hacked by Fatal Error
On Thursday 28 May 2009, Scott Mulholland wrote: I would have considered it strong - 9 chars, letters/numbers/other chars mixed case. The ftp logs don't show anything though. If they brute forced it, they could alter the logs after the fact. You can not trust anything on that box, remember :-) -- Helping to challengingly participate bricks-and-clicks wireless granular channels as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.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:322889 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
So everything works until you change the list? Something must be wrong with
the list format. Extra or missing comma.
--
Ryan
On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote:
Would it look like this?
cfoutput
script type=text/javascript
var scriptList = '#myList#';
$(document).ready(function() {
$(##country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(##city).autocompleteArray(
scriptList,
{
minChars:1,
delay:10,
autoFill:false,
matchSubset:10,
matchContains:10,
selectOnly:10
}
);
});
/script
/cfoutput
Have you tried to dump the value of the list to see if it matches the
format of the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput;
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(scriptList),
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
Thanks
The list creation does exactly what I need it to but the cfoutput...
does work.
It's not giving an error but the autocomplete does nothing.
~|
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:322890
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Yes, this is how I am formatting the list cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all') ] So everything works until you change the list? Something must be wrong with the list format. Extra or missing comma. -- Ryan On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote: ~| 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:322891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the best way to handle returning two queries from a component for looping?
Thanks for the explanation, Jason. It just seems so counter-intuitive to have cfoutput's within cfoutput's...that's always been a no-no. So, was the cfoutput group... function created to address the very problem of having to loop a query within a query? And when did CF first get this function? Recently? Or have I just completely missed that function for 10+ years? I'm just running into this as an issue now since I'm using components. Except for the use of components, I could always run two queries and then loop one within the other, so a good solution was always available. Rick On Thu, May 28, 2009 at 10:16 AM, Jason Fisher ja...@wanax.com wrote: Rick, If it looks unclear, you can also do the following: cfoutput query=getStuff group=theTitleFieldHere h1#someTitleField#/h1 cfoutput group=theDetailField p#theDetailField#/p /cfoutput /cfoutput Note that the inner CFOUTPUT has 'group' attribute, but no 'query' attribute. The plain CFOUTPUT inside an existing query-CFOUTPUT is the equivalent. ~| 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:322892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
After you open the page in your browser look at the source for the list. Make sure it doesn't say something like #mylist# :). There must be something off there. -- Ryan On Thu, May 28, 2009 at 10:01 AM, Torrent Girl torrentg...@gmail.comwrote: Yes, this is how I am formatting the list cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all') ] So everything works until you change the list? Something must be wrong with the list format. Extra or missing comma. -- Ryan On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote: ~| 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:322893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
In theory - new site development and IIS rewrite rules
Just asking how other folks would go about this, in general... Getting ready to start on a new site. To get everything to work like the client wants, almost every single site URL is going to have to go through a IIS rewrite rule so everything looks like: www.mysite.com/contact www.mysite.com/about-my-company www.mysite.com/something/red www.mysite.com/something/blue www.mysite.com/newsletters/11/23/2008/some-important-newsletter They never want to see a file extension. For me, it gets pretty difficult trying to figure out what's running what once the rewrite rules go into place since it's a fairly large site. Would most of you develop the site without the rules first, then apply the rules to get everything like the client wishes, or just go ahead and work with the rules from day one? I've got the stand alone version of CF8 installed locally. I don't have IIS installed. That's one point in favour of developing without the rewrite rules and adding them afterwards. Looks like it would be a painful process to install IIS locally and then change my CF installation to run under that. Thoughts? ~| 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:322894 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Did that and the list is showing correctly After you open the page in your browser look at the source for the list. Make sure it doesn't say something like #mylist# :). There must be something off there. -- Ryan On Thu, May 28, 2009 at 10:01 AM, Torrent Girl torrentg...@gmail.comwrote: ~| 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:322895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
It's actually been there since 4.0, I believe. I know they added the groupCaseSensitive attribute in 4.5, so the group option was in place by that point. Essentially it's a way to get your output to follow your SQL groupings, when that sort of thing is necessary. So like doing a blotter style calendar, if you ORDER or GROUP the query by eventDate, you can then cfoutput group=eventDate to get your day-by-day headings, for example, and then cfoutput group=eventStartTime or whatever to do a little block for each event on the blotter ... etc. They can also be nested deeper: Company, Department, Individual Employee, for example. Jason ~| 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:322896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Hacked by Fatal Error
Scott Mulholland wrote: The ftp logs don't show anything though. I looked into turning off webDav on it since its IIS 5.0. I just wish I felt better about knowing how they got in. WebDav is a high candidate. It was enabled by default in IIS5. It uses port 80 and their where known exploits allowing hackers to modify web content within 24 hours of the publishing of the bug. The idea is that IIS will improperly translate URLS received via webDav that include unicode \ characters which allows the request to escape the defined webDav directory and access any directory on the site. ~| 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:322897 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - new site development and IIS rewrite rules
Just asking how other folks would go about this, in general... Getting ready to start on a new site. To get everything to work like the client wants, almost every single site URL is going to have to go through a IIS rewrite rule so everything looks like: www.mysite.com/contact www.mysite.com/about-my-company www.mysite.com/something/red www.mysite.com/something/blue www.mysite.com/newsletters/11/23/2008/some-important-newsletter They never want to see a file extension. For me, it gets pretty difficult trying to figure out what's running what once the rewrite rules go into place since it's a fairly large site. Would most of you develop the site without the rules first, then apply the rules to get everything like the client wishes, or just go ahead and work with the rules from day one? I would probably develop the rules right away, just because I'd need to match the spec and to discuss spec items, other users (who wouldn't know the underlying URLs) would need to see the right URLs. But I don't think it would matter that much either way, except that if I tacked them on at the end, I wouldn't know if they worked properly without retesting everything. I've got the stand alone version of CF8 installed locally. I don't have IIS installed. That's one point in favour of developing without the rewrite rules and adding them afterwards. Looks like it would be a painful process to install IIS locally and then change my CF installation to run under that. It shouldn't be painful, really. IIS is available as a system component in any recent version of Windows, so you can install it very easily. Then, you can easily hook CF up to it using the web server configuration utility. If you're using Vista, there are a few (now well-documented) specific steps you'll need to follow, but we're talking about maybe half an hour or so, I think. You don't have to disable the JRun web server or really change anything about your CF installation. 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:322898 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) Hacked by Fatal Error
The ftp logs don't show anything though. I looked into turning off webDav on it since its IIS 5.0. I just wish I felt better about knowing how they got in. Have you looked at the IIS server logs? Most simple defacements aren't really anything more, and the logs are probably intact. Of course, after even a simple defacement, you can't be sure if the server was further compromised, so you really should wipe it, etc. 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 informatio ~| 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:322899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Wow! That is a great function that I didn't even know existed! And how many times have a simply resorted to looping one query over another unnecessarily! And to be able to nest this multiple levels deep is great! Finally crawling out from under my rock and into the light of day! Doh! On Thu, May 28, 2009 at 11:21 AM, Jason Fisher ja...@wanax.com wrote: It's actually been there since 4.0, I believe. I know they added the groupCaseSensitive attribute in 4.5, so the group option was in place by that point. Essentially it's a way to get your output to follow your SQL groupings, when that sort of thing is necessary. So like doing a blotter style calendar, if you ORDER or GROUP the query by eventDate, you can then cfoutput group=eventDate to get your day-by-day headings, for example, and then cfoutput group=eventStartTime or whatever to do a little block for each event on the blotter ... etc. They can also be nested deeper: Company, Department, Individual Employee, for example. Jason ~| 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:322900 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
why dont you try the same ajax method that is used with the city local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select firstname,LASTNAME from employee where lower(firstname)
like '#lCase(url.q)#%'
/cfquery
/cfsilentcfoutput
query=getMatches#getMatches.firstname##getMatches.LASTNAME#
/cfoutput
#2 apply the input to autocomplete and specify the ajax page. see complete code
below
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /
titleUntitled Document/title
script src=.jquery-1.3.2.min.js type=text/javascript/script
script src=jquery.autocomplete.js type=text/javascript/script
link rel=stylesheet href=jquery.autocomplete.css/
script
function findValue(li) {
if( li == null ) return alert(No match!);
// if coming from an AJAX call, let's use the CityId as the value
if( !!li.extra ) var sValue = li.extra[0];
// otherwise, let's just display the value in the text box
else var sValue = li.selectValue;
//alert(The value you selected was: + sValue);
}
function selectItem(li) {
findValue(li);
}
function formatItem(row) {
return row[0] + (id: + row[1] + );
}
function lookupAjax(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
function lookupLocal(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
$(document).ready(function(){
$(#suggest).autocomplete(
names.cfm,
{
delay:10,
minChars:2,
matchSubset:1,
matchContains:1,
cacheLength:10,
onItemSelect:selectItem,
onFindValue:findValue,
formatItem:formatItem,
autoFill:true
}
);
})
/script
/head
body
labelAuto suggest Sample/label
input name=suggest id=suggest /
/body
/html
~|
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:322901
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
why dont you try the same ajax method that is used with the city local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select firstname,LASTNAME from employee where lower(firstname)
like '#lCase(url.q)#%'
/cfquery
/cfsilentcfoutput
query=getMatches#getMatches.firstname##getMatches.LASTNAME#
/cfoutput
#2 apply the input to autocomplete and specify the ajax page. see complete code
below
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /
titleUntitled Document/title
script src=.jquery-1.3.2.min.js type=text/javascript/script
script src=jquery.autocomplete.js type=text/javascript/script
link rel=stylesheet href=jquery.autocomplete.css/
script
function findValue(li) {
if( li == null ) return alert(No match!);
// if coming from an AJAX call, let's use the CityId as the value
if( !!li.extra ) var sValue = li.extra[0];
// otherwise, let's just display the value in the text box
else var sValue = li.selectValue;
//alert(The value you selected was: + sValue);
}
function selectItem(li) {
findValue(li);
}
function formatItem(row) {
return row[0] + (id: + row[1] + );
}
function lookupAjax(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
function lookupLocal(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
$(document).ready(function(){
$(#suggest).autocomplete(
names.cfm,
{
delay:10,
minChars:2,
matchSubset:1,
matchContains:1,
cacheLength:10,
onItemSelect:selectItem,
onFindValue:findValue,
formatItem:formatItem,
autoFill:true
}
);
})
/script
/head
body
labelAuto suggest Sample/label
input name=suggest id=suggest /
/body
/html
~|
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:322902
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Don't feel bad. I never used it either. So at least there's 2 of us. -- Ryan On Thu, May 28, 2009 at 10:51 AM, Rick Faircloth r...@whitestonemedia.comwrote: Wow! That is a great function that I didn't even know existed! And how many times have a simply resorted to looping one query over another unnecessarily! And to be able to nest this multiple levels deep is great! Finally crawling out from under my rock and into the light of day! Doh! On Thu, May 28, 2009 at 11:21 AM, Jason Fisher ja...@wanax.com wrote: It's actually been there since 4.0, I believe. I know they added the groupCaseSensitive attribute in 4.5, so the group option was in place by that point. Essentially it's a way to get your output to follow your SQL groupings, when that sort of thing is necessary. So like doing a blotter style calendar, if you ORDER or GROUP the query by eventDate, you can then cfoutput group=eventDate to get your day-by-day headings, for example, and then cfoutput group=eventStartTime or whatever to do a little block for each event on the blotter ... etc. They can also be nested deeper: Company, Department, Individual Employee, for example. Jason ~| 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:322903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using CFPDFFORM, Data going into PDF Form Fields is mis-aligned or cut off...
Interesting problem. CFPDFFORM works wonderfully for the most part, except when it does what it's supposed to do: insert data into pdf forms. I'm finding that often times, letters like q, y, or other letters that hang a bit, get cut off. Additionally, alignment seems screwy. Many times a form is perfect in PDF form, but then when CFPDFFORM inserts data into that form, the data is mis-aligned and has a different placement than it did in the actual PDF. On that second issue, if you tab through those form fields when in the browser, they jump all over the place as you tab in and out of the fields. I see no way to adjust this behavior in the tag's docs. Is this a known issue? The PDFs are created with Adobe Professional 7, but displayed in Adobe Reader 8 via the browser. Very curious if anyone else is having this problem. We have a dozen or more forms automated and all sorts of hacks are in place like stretching form fields or purposely mis-aligning them so that CFPDFFORM's mis-alignment looks closer to how it should look, etc. Thanks! ~| 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:322904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: In theory - new site development and IIS rewrite rules
I agree with Dave. I've used URL rewriting on two projects now (including my own blog: www.andymatthews.net) and it's best to put the rules in place right away. Remember that without the rules your links would have to point to the .cfm versions rather than the clean version so it's really going to affect your entire site. I'd be happy to share my rules with you if you like. There's only a few, but they're very similar to yours. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, May 28, 2009 10:30 AM To: cf-talk Subject: Re: In theory - new site development and IIS rewrite rules Just asking how other folks would go about this, in general... Getting ready to start on a new site. To get everything to work like the client wants, almost every single site URL is going to have to go through a IIS rewrite rule so everything looks like: www.mysite.com/contact www.mysite.com/about-my-company www.mysite.com/something/red www.mysite.com/something/blue www.mysite.com/newsletters/11/23/2008/some-important-newsletter They never want to see a file extension. For me, it gets pretty difficult trying to figure out what's running what once the rewrite rules go into place since it's a fairly large site. Would most of you develop the site without the rules first, then apply the rules to get everything like the client wishes, or just go ahead and work with the rules from day one? I would probably develop the rules right away, just because I'd need to match the spec and to discuss spec items, other users (who wouldn't know the underlying URLs) would need to see the right URLs. But I don't think it would matter that much either way, except that if I tacked them on at the end, I wouldn't know if they worked properly without retesting everything. I've got the stand alone version of CF8 installed locally. I don't have IIS installed. That's one point in favour of developing without the rewrite rules and adding them afterwards. Looks like it would be a painful process to install IIS locally and then change my CF installation to run under that. It shouldn't be painful, really. IIS is available as a system component in any recent version of Windows, so you can install it very easily. Then, you can easily hook CF up to it using the web server configuration utility. If you're using Vista, there are a few (now well-documented) specific steps you'll need to follow, but we're talking about maybe half an hour or so, I think. You don't have to disable the JRun web server or really change anything about your CF installation. 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:322905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem when modifying dates
Hi everybody.. Have a problem when i modify a date on a cfinput cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 I have a validate eurodate.. example I have a date that i should modify 20/01/2009 to 10/01/2009 (january 10, 2009) when i input it in the database and if the day is 12 and below it flips the day and month so it becomes 01/10/2009 (October 1, 2009) is there a way that it would stay as a eurodate? thanks ~| 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:322906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem when modifying dates
On Thu, May 28, 2009 at 12:23 PM, alex poyaoan ap.cli...@tiscali.it wrote: cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 always insert dates in the following format... -mm-dd ~| 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:322907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem when modifying dates
I tried it and it works fine but is it possible to type only the mmdd without dashes? On Thu, May 28, 2009 at 12:23 PM, alex poyaoan ap.cli...@tiscali.it wrote: cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 always insert dates in the following format... -mm-dd ~| 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:322908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
LOL, don't you just love finding something new that makes life (or at least coding) easier? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem when modifying dates
On Thu, May 28, 2009 at 12:41 PM, alex poyaoan ap.cli...@tiscali.it wrote: I tried it and it works fine but is it possible to type only the mmdd without dashes? how about if it works with dashes you just use dashes? ~| 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:322910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the best way to handle returning two queries from a component for looping?
Always lookin to save keystrokes. :) -- Ryan On Thu, May 28, 2009 at 11:50 AM, Jason Fisher ja...@wanax.com wrote: LOL, don't you just love finding something new that makes life (or at least coding) easier? ~| Want 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:322911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Maybe we should start a club... :o) On Thu, May 28, 2009 at 12:02 PM, Ryan Letulle bayous...@gmail.com wrote: Don't feel bad. I never used it either. So at least there's 2 of us. -- Ryan On Thu, May 28, 2009 at 10:51 AM, Rick Faircloth r...@whitestonemedia.comwrote: Wow! That is a great function that I didn't even know existed! And how many times have a simply resorted to looping one query over another unnecessarily! And to be able to nest this multiple levels deep is great! Finally crawling out from under my rock and into the light of day! Doh! On Thu, May 28, 2009 at 11:21 AM, Jason Fisher ja...@wanax.com wrote: It's actually been there since 4.0, I believe. I know they added the groupCaseSensitive attribute in 4.5, so the group option was in place by that point. Essentially it's a way to get your output to follow your SQL groupings, when that sort of thing is necessary. So like doing a blotter style calendar, if you ORDER or GROUP the query by eventDate, you can then cfoutput group=eventDate to get your day-by-day headings, for example, and then cfoutput group=eventStartTime or whatever to do a little block for each event on the blotter ... etc. They can also be nested deeper: Company, Department, Individual Employee, for example. Jason ~| 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:322912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
why dont you try the same ajax method that is used with the city
local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select firstname,LASTNAME from employee where lower(firstname)
like
'#lCase(url.q)#%'
/cfquery
/cfsilentcfoutput query=getMatches#getMatches.
firstname##getMatches.LASTNAME#
/cfoutput
#2 apply the input to autocomplete and specify the ajax page. see
complete code below
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html;
charset=iso-8859-1 /
titleUntitled Document/title
script src=.jquery-1.3.2.min.js type=text/javascript/script
script src=jquery.autocomplete.js type=text/javascript/script
link rel=stylesheet href=jquery.autocomplete.css/
script
function findValue(li) {
if( li == null ) return alert(No match!);
// if coming from an AJAX call, let's use the CityId as the value
if( !!li.extra ) var sValue = li.extra[0];
// otherwise, let's just display the value in the text box
else var sValue = li.selectValue;
//alert(The value you selected was: + sValue);
}
function selectItem(li) {
findValue(li);
}
function formatItem(row) {
return row[0] + (id: + row[1] + );
}
function lookupAjax(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
function lookupLocal(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
$(document).ready(function(){
$(#suggest).autocomplete(
names.cfm,
{
delay:10,
minChars:2,
matchSubset:1,
matchContains:1,
cacheLength:10,
onItemSelect:selectItem,
onFindValue:findValue,
formatItem:formatItem,
autoFill:true
}
);
})
/script
/head
body
labelAuto suggest Sample/label
input name=suggest id=suggest /
/body
/html
~|
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:322913
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
Thanks
Tried your code.
I am closer but still not working correctly
My 'searching' image shows up and turns but I get no results.
why dont you try the same ajax method that is used with the city
local
#1. create a page like names.cfm
add the below code
cfsilent
cfset debug = false /
cfparam name=url.q type=string /
cfquery name=getMatches datasource=cfdocexamples
select firstname,LASTNAME from employee where lower(firstname)
like
'#lCase(url.q)#%'
/cfquery
/cfsilentcfoutput query=getMatches#getMatches.
firstname##getMatches.LASTNAME#
/cfoutput
#2 apply the input to autocomplete and specify the ajax page. see
complete code below
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html;
charset=iso-8859-1 /
titleUntitled Document/title
script src=.jquery-1.3.2.min.js type=text/javascript/script
script src=jquery.autocomplete.js type=text/javascript/script
link rel=stylesheet href=jquery.autocomplete.css/
script
function findValue(li) {
if( li == null ) return alert(No match!);
// if coming from an AJAX call, let's use the CityId as the value
if( !!li.extra ) var sValue = li.extra[0];
// otherwise, let's just display the value in the text box
else var sValue = li.selectValue;
//alert(The value you selected was: + sValue);
}
function selectItem(li) {
findValue(li);
}
function formatItem(row) {
return row[0] + (id: + row[1] + );
}
function lookupAjax(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
function lookupLocal(){
var oSuggest = $(#suggest)[0].autocompleter;
oSuggest.findValue();
return false;
}
$(document).ready(function(){
$(#suggest).autocomplete(
names.cfm,
{
delay:10,
minChars:2,
matchSubset:1,
matchContains:1,
cacheLength:10,
onItemSelect:selectItem,
onFindValue:findValue,
formatItem:formatItem,
autoFill:true
}
);
})
/script
/head
body
labelAuto suggest Sample/label
input name=suggest id=suggest /
/body
/html
~|
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:322914
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Entity has incorrect type for being called as a function
Hi all, I am stuck. I have never had this happen before and I cannot figure it out. Hopefully there is enough info below to see what I am not seeing Any help would be greatly appreciated. First of all when I connect to this directly through the cfc , i.e. not through a webservice everything works fine. However, once I try to get it through a webservice it breaks. I am creating a webservice object. cfset emswebservice=http://ckm-dev.osumc.edu/webservices/edu/osu/twomdtools/ems/ems.cfc?wsdl; cfset emsserviceerror = cfobject name = wsobject refreshWSDL = yes webservice = #emswebservice# cfdump var=#wsobject# I can create the object by connecting to the webservice Upon creation I dump the object and see everything in it including the method getBookingWithDetail that I am looking for in the struct on the Methods line. object of webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub Class Name webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub MethodsMethod Return Type getBookingWithDetail(java.lang.String, double, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String) coldfusion.xml.rpc.QueryBean Upon dumping the methods I get this error cfdump var=#wsobject.methods# Element METHODS is undefined in WSOBJECT. When I call the method in the invoke cfinvoke object=#wsobject# BookingIDList= ReservationID=0 Groupname= Start=#StartDate# End=#StartDate# StatusIDList=#StatusIDList# method=getBookingWithDetail returnvariable=getwsobject I get the following error Entity has incorrect type for being called as a function. The symbol you provided getBookingWithDetail is not the name of a function. This is the function !--- --- --- !--- *** getBookingWithDetail this function returns rows from the dbo.tblBooking table *** --- !--- --- --- cffunction name=getBookingWithDetail access=remote output=false returntype=query hint=this function returns rows from the dbo.tblBooking table cfargument name=BookingIDList required=False type=string hint= cfargument name=ReservationID required=False type=numeric hint= cfargument name=GroupName required=False type=string hint= cfargument name=Room required=False type=string hint= cfargument name=Start required=False type=string hint= cfargument name=End required=False type=string hint= cfargument name=StatusIDList required=False type=string hint= !--- init local scope --- cfset var local = StructNew() cfquery name='local.BookingWithDetail' datasource='#this.dsnPub#' SELECT TOP 100 PERCENT so.ID AS ServiceOrderID, bk.ID as BookingID, bk.ReservationID, bk.TimeBookingStart, bk.TimeBookingEnd, bk.EventName, bk.RoomID, bk.StatusID, st.Description AS StatusDescription, rsv.TempContact, rsv.Phone AS TempContactPhone, rsv.AltTempContact, bk.TimeEventStart, bk.TimeEventEnd, rsv.AltPhone AS AltTempContactPhone, rm.Room, bld.Description AS BuildingDescription, sod.ResourceID, sod.Quantity, sod.Notes, rsc.ResourceDescription, g.groupName FROM dbo.tblBooking AS bk INNER JOIN dbo.tblStatus AS st ON bk.StatusID = st.ID INNER JOIN dbo.tblReservation AS rsv ON bk.ReservationID = rsv.ID LEFT OUTER JOIN dbo.tblServiceOrder AS so ON bk.ID = so.BookingID LEFT OUTER JOIN dbo.tblRoom AS rm ON bk.RoomID = rm.ID LEFT OUTER JOIN dbo.tblBuilding AS bld ON rm.BuildingID = bld.ID LEFT OUTER JOIN dbo.tblServiceOrderDetail AS sod ON so.ID = sod.ServiceOrderID LEFT OUTER JOIN dbo.tblResource AS rsc ON sod.ResourceID = rsc.ID LEFT OUTER JOIN dbo.tblGroup g on rsv.groupID = g.ID where 0=0 cfif structKeyExists(arguments,'BookingIDList') and arguments.BookingIDList neq '' AND bk.ID IN (cfqueryparam cfsqltype=CF_SQL_Integer
Entity has incorrect type for being called as a function
Hi all, I am stuck. I have never had this happen before and I cannot figure it out. Hopefully there is enough info below to see what I am not seeing Any help would be greatly appreciated. First of all when I connect to this directly through the cfc , i.e. not through a webservice everything works fine. However, once I try to get it through a webservice it breaks. I am creating a webservice object. cfset emswebservice=http://ckm-dev.osumc.edu/webservices/edu/osu/twomdtools/ems/ems.cfc?wsdl; cfset emsserviceerror = cfobject name = wsobject refreshWSDL = yes webservice = #emswebservice# cfdump var=#wsobject# I can create the object by connecting to the webservice Upon creation I dump the object and see everything in it including the method getBookingWithDetail that I am looking for in the struct on the Methods line. object of webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub Class Name webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub MethodsMethod Return Type getBookingWithDetail(java.lang.String, double, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String) coldfusion.xml.rpc.QueryBean Upon dumping the methods I get this error cfdump var=#wsobject.methods# Element METHODS is undefined in WSOBJECT. When I call the method in the invoke cfinvoke object=#wsobject# BookingIDList= ReservationID=0 Groupname= Start=#StartDate# End=#StartDate# StatusIDList=#StatusIDList# method=getBookingWithDetail returnvariable=getwsobject I get the following error Entity has incorrect type for being called as a function. The symbol you provided getBookingWithDetail is not the name of a function. This is the function !--- --- --- !--- *** getBookingWithDetail this function returns rows from the dbo.tblBooking table *** --- !--- --- --- cffunction name=getBookingWithDetail access=remote output=false returntype=query hint=this function returns rows from the dbo.tblBooking table cfargument name=BookingIDList required=False type=string hint= cfargument name=ReservationID required=False type=numeric hint= cfargument name=GroupName required=False type=string hint= cfargument name=Room required=False type=string hint= cfargument name=Start required=False type=string hint= cfargument name=End required=False type=string hint= cfargument name=StatusIDList required=False type=string hint= !--- init local scope --- cfset var local = StructNew() cfquery name='local.BookingWithDetail' datasource='#this.dsnPub#' SELECT TOP 100 PERCENT so.ID AS ServiceOrderID, bk.ID as BookingID, bk.ReservationID, bk.TimeBookingStart, bk.TimeBookingEnd, bk.EventName, bk.RoomID, bk.StatusID, st.Description AS StatusDescription, rsv.TempContact, rsv.Phone AS TempContactPhone, rsv.AltTempContact, bk.TimeEventStart, bk.TimeEventEnd, rsv.AltPhone AS AltTempContactPhone, rm.Room, bld.Description AS BuildingDescription, sod.ResourceID, sod.Quantity, sod.Notes, rsc.ResourceDescription, g.groupName FROM dbo.tblBooking AS bk INNER JOIN dbo.tblStatus AS st ON bk.StatusID = st.ID INNER JOIN dbo.tblReservation AS rsv ON bk.ReservationID = rsv.ID LEFT OUTER JOIN dbo.tblServiceOrder AS so ON bk.ID = so.BookingID LEFT OUTER JOIN dbo.tblRoom AS rm ON bk.RoomID = rm.ID LEFT OUTER JOIN dbo.tblBuilding AS bld ON rm.BuildingID = bld.ID LEFT OUTER JOIN dbo.tblServiceOrderDetail AS sod ON so.ID = sod.ServiceOrderID LEFT OUTER JOIN dbo.tblResource AS rsc ON sod.ResourceID = rsc.ID LEFT OUTER JOIN dbo.tblGroup g on rsv.groupID = g.ID where 0=0 cfif structKeyExists(arguments,'BookingIDList') and arguments.BookingIDList neq '' AND bk.ID IN (cfqueryparam cfsqltype=CF_SQL_Integer
Re: Old CF project (1000 .cfm and .cfc), refactor into framework
coded like spaghetti with meatballs. That is a good one. The discussion with my colleagues is that some want to refactor the whole project in a framework. I think it's to much work, and you can better start from scratch. My other colleagues disagrees. I just got done doing something very similar. Not a 1000 items but is was non trivial. And this is what I found. I don't think it is all or nothing. You can probably harvest at least the forms and display pages from the existing app (striping out all the stuff that should be in your model) and then use a code generator like Illudium PU-36 or the one that Dominic Watson just released to abstract your data layer. http://code.google.com/p/cfcgenerator/ http://fusion.dominicwatson.co.uk/2009/05/next-generator -illudium-pu-36-based-app.html Or use Transfer (with Transfer Config), Data Faucet or Reactor to do the same. That will give you a jump start on the grunt work. After that you will have your views (from the existing site) , most of your model (at least for CRUD functions) and then you can harvest/Refactor the existing CFC's and plug them into your model. Then, as Nathan suggested: -- If nothing else, get your entire model into well encapsulated CFCs and your app into a generic MVC structure, then you can port it pretty freely to any MVC compatible framework. Trust me, you will thank yourself repetedly every time you need to update it, and programmers down the line will bless you instead of curse you. -- Once you get your model encapsulated into CFCs and have all your views it is just a matter of plugging them into the controler/Framework of your choice. Of course it is not as easy as I make it, and as Ike suggested it can be a lot of work, but there are plenty of ways to reduce the amount of work. HTH G! -- Gerald Guido http://www.myinternetisbroken.com http://www.cfsimple.org/ To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:322917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfsqltype for date and time
Hello, What cfsqltype in a cfqueryparam should I use to insert now() into a mySql database (datetime data type) so it keeps the date and time? cf_sql_timestamp and cf_sql_date only seem to hold the date, not the time when I insert. ~| 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:322918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfsqltype for date and time
What cfsqltype in a cfqueryparam should I use to insert now() into a mySql database (datetime data type) so it keeps the date and time? cf_sql_timestamp. You might double check your syntax and the data type. It works fine for me. INSERT INTO Table (DateTimeColumn) VALUES ( cfqueryparam value=#now()# cfsqltype=cf_sql_timestamp ) ~| 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:322919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfsqltype for date and time
What cfsqltype in a cfqueryparam should I use to insert now() into a mySql database (datetime data type) so it keeps the date and time? cf_sql_timestamp and cf_sql_date only seem to hold the date, not the time when I insert. You should use CF_SQL_TIMESTAMP, but you'll need to make sure you have a new-enough version of the JDBC driver for MySQL. 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:322920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - new site development and IIS rewrite rules
Andy Matthews wrote: I agree with Dave. I've used URL rewriting on two projects now (including my own blog: www.andymatthews.net) and it's best to put the rules in place right away. Remember that without the rules your links would have to point to the .cfm versions rather than the clean version so it's really going to affect your entire site. Looks like this is going to be a PITA developing locally though. XP Pro only runs IIS 5.1 - which only allows one site - and I've not figured out how to get any rewrite rules to actually work locally on that so far. No problem out on the actual server... Back to Google. Ack! ~| 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:322921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Concat Wav Files - Prob w CF accessing Java Static Props?
I'm currently attempting to concatenate several wave files into a single wave
file using java with ColdFusion. I am using the java code here -
http://stackoverflow.com/questions/653861/join-two-wav-files-from-java - as a
basis for my ColdFusion cfscript code below (apologies for formatting in
advance):
cfscript
strLocation = #getDirectoryFromPath(getCurrentTemplatePath())# 'wavs\';
aWav = [#strLocation# test1.wav,#strLocation# test2.wav];
aAudioObj = ArrayNew(1);
SequenceInputStream = createObject(java,java.io.SequenceInputStream);
AudioFileFormat = createObject(java,javax.sound.sampled.AudioFileFormat);
AudioInputStream = createObject(java,javax.sound.sampled.AudioInputStream);
AudioSystem = createObject(java,javax.sound.sampled.AudioSystem);
//loop through and create java file objects for each item in the array
for(i=1; i lte ArrayLen(aWav); i = i + 1) {
aAudioObj[i] =
AudioSystem.getAudioInputStream(createObject(java,java.io.File).init(aWav[i]));
}
fileNew = createObject(java,javax.sound.sampled.AudioInputStream).init(
createObject(java,java.io.SequenceInputStream).init(aAudioObj[1],aAudioObj[2]),
aAudioObj[1].getFormat(),
aAudioObj[1].getFrameLength() + aAudioObj[2].getFrameLength()
);
AudioSystem.write(
fileNew,
AudioFileFormat.Type.WAVE,
createObject(java,java.io.File).init(#strLocation#concat1.wav)
);
/cfscript
Stepping through the code things are going swimmingly until I attempt to write
the newly created wave file back to the file system. Specifically, the
AudioFileFormat.Type.WAVE line throws the error:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
Dumping the available methods on AudioFileFormat and putting around the
javadocs seems to imply that Type.WAVE is a static property, which I
understand CF can have problems accessing??
How do I define an AudioFileFormat of type WAVE?
* Thanks in Advance -
Matthew Reinbold
~|
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:322922
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Concat Wav Files - Prob w CF accessing Java Static Props?
Dumping the available methods on AudioFileFormat and putting around the javadocs seems to imply that Type.WAVE is a static property, which I understand CF can have problems accessing?? Type is an inner class. You can use $ to reference it: cfset AudioFileFormatType = createObject(java, javax.sound.sampled.AudioFileFormat$Type) cfoutput #AudioFileFormatType.WAVE# cfoutput ~| 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:322923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Concat Wav Files - Prob w CF accessing Java Static Props?
Type is an inner class. You can use $ to reference it: Awesome - works like a charm. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT, looking for an affordable SMTP/POP3 solution
Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT, looking for an affordable SMTP/POP3 solution
Google Apps Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT, looking for an affordable SMTP/POP3 solution
On Thu, May 28, 2009 at 7:18 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? Or SmarterMail http://www.smartertools.com/ SmarterMail Professional Edition 5.x - 50 Domains - 250 Users $299.00 ~| 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:322927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Little help with Ionic IsapiRewrite
Trying to get Ionic IsapRewrite working locally so I can develop locally without having to put every freaking thing out to the server... Running: XP Pro IIS 5.1 Stuff is set up thusly: 1. Since IIS 5.1 only allows one site, I've got my default site as the main wwwroot directory with everything under it 2. The IonicReWrite is listed in the IIS Admin ISAPI Filters section My Isapi ini file (for now): -- # IsapiRewrite4.ini # ini file for the ISAPI rewriter. RewriteLogLevel 3 RewriteRule ^attorney/([_0-9a-z-]+)/([_.0-9a-z-]+)$ /attorney/nelson-mullins-attorney-bio.cfm?city=$1lawyer=$2 --- Ideas on what I might have wrong? ~| 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:322928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT, looking for an affordable SMTP/POP3 solution
I second Google Apps. You don't want the spam traffic headache. I am slowly moving everyone off of a mail server that I manage because of spam. -- Ryan On Thu, May 28, 2009 at 7:20 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, May 28, 2009 at 7:18 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? Or SmarterMail http://www.smartertools.com/ SmarterMail Professional Edition 5.x - 50 Domains - 250 Users $299.00 ~| 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:322929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT, looking for an affordable SMTP/POP3 solution
On Thu, May 28, 2009 at 8:28 PM, Ryan Letulle bayous...@gmail.com wrote: I second Google Apps. You don't want the spam traffic headache. I am slowly moving everyone off of a mail server that I manage because of spam. -- Ryan Also note, coldfusion 8 can send mail out through google servers, so you could totally do away with all mail locally. ~| 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:322930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Little help with Ionic IsapiRewrite
So what's the actual problem? Don't know if this is it, but it looks like you're missing a slash after the caret in your RewriteRule. Should be ^/att... not ^att... On Thu, May 28, 2009 at 5:24 PM, Les Mizzell lesm...@bellsouth.net wrote: Trying to get Ionic IsapRewrite working locally so I can develop locally without having to put every freaking thing out to the server... Running: XP Pro IIS 5.1 Stuff is set up thusly: 1. Since IIS 5.1 only allows one site, I've got my default site as the main wwwroot directory with everything under it 2. The IonicReWrite is listed in the IIS Admin ISAPI Filters section My Isapi ini file (for now): -- # IsapiRewrite4.ini # ini file for the ISAPI rewriter. RewriteLogLevel 3 RewriteRule ^attorney/([_0-9a-z-]+)/([_.0-9a-z-]+)$ /attorney/nelson-mullins-attorney-bio.cfm?city=$1lawyer=$2 --- Ideas on what I might have wrong? ~| 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:322931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Email via cfmail tag goes to junk folder
I am using cfmail to send out emails. For some users it goes to the junk mail folder. The email content has a link. When I remove the link it goes to the Inbox. From address is a valid address. Thanks, ~| Want to reach the 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:322932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email via cfmail tag goes to junk folder
Can you get the email users to put your from address in their contact list? -- Ryan On Thu, May 28, 2009 at 7:56 PM, Vineetha Varghese vvargh...@pace.eduwrote: I am using cfmail to send out emails. For some users it goes to the junk mail folder. The email content has a link. When I remove the link it goes to the Inbox. From address is a valid address. Thanks, ~| 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:322933 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 via cfmail tag goes to junk folder
I can request, but not all user will do so. The emails are part of a workflow and I need to make sure that they all do go to the Inbox. V Can you get the email users to put your from address in their contact list? -- Ryan On Thu, May 28, 2009 at 7:56 PM, Vineetha Varghese vvargh...@pace.eduwrote: I am using cfmail to send out emails. For some users it goes to the junk mail folder. The email content has a link. When I remove the link it goes to the Inbox. From address is a valid address. Thanks, ~| 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:322934 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 via cfmail tag goes to junk folder
Do you have an SPF (http://www.openspf.org/) record in your DNS? If not, you should add one. Hard to say whether it'll help or not in this particular case, but it's a good thing to have set up if you're going to be sending out email. cheers, barneyb On Thu, May 28, 2009 at 5:56 PM, Vineetha Varghese vvargh...@pace.edu wrote: I am using cfmail to send out emails. For some users it goes to the junk mail folder. The email content has a link. When I remove the link it goes to the Inbox. From address is a valid address. Thanks, ~| Want to reach the 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:322935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Could this be related to the fact that I can't delete or rename files that have been uploaded?
I've run into this curious problem recently, since switching to Windows 7 RC, concerning deleting or renaming uploaded files. I was trying to sort out this problem through a development site when I decided to delete all the files that I had uploaded to my local system and couldn't delete through the browser. Various errors during deleting or renaming keep occuring, such as e:\images\blah.jpg can't be deleted for some unknown reason...and yes, CF says, for some unknown reason. However, after an error was thrown in the browser, I did decide to just delete all the files building up through Windows Explorer. I deleted all but one successfully, and that one I couldn't delete was the last one I uploaded. Windows Explorer threw an error stating, The action can't be completed because the file is open in jrun.exe ??? What does that mean? Is CF ( meaning jrun.exe?) hanging onto the file somehow, which would explain why I can't delete it or rename it as I normally can with CF? Is there a way to force jrun.exe to not keep the file open? Incidentally, after waiting a couple of minutes, I can delete the file normally. Anyone have any ideas or suggestions? If I can't solve this, I've got to rewrite a ton of code and develop workarounds. Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could this be related to the fact that I can't delete or rename files that have been uploaded?
Someone reported the exact same problem either here or on the Railo Group yesterday. Apparently it's a new window's feature. :) -- Ryan On Thu, May 28, 2009 at 9:36 PM, Rick Faircloth r...@whitestonemedia.comwrote: I've run into this curious problem recently, since switching to Windows 7 RC, concerning deleting or renaming uploaded files. I was trying to sort out this problem through a development site when I decided to delete all the files that I had uploaded to my local system and couldn't delete through the browser. Various errors during deleting or renaming keep occuring, such as e:\images\blah.jpg can't be deleted for some unknown reason...and yes, CF says, for some unknown reason. However, after an error was thrown in the browser, I did decide to just delete all the files building up through Windows Explorer. I deleted all but one successfully, and that one I couldn't delete was the last one I uploaded. Windows Explorer threw an error stating, The action can't be completed because the file is open in jrun.exe ??? What does that mean? Is CF ( meaning jrun.exe?) hanging onto the file somehow, which would explain why I can't delete it or rename it as I normally can with CF? Is there a way to force jrun.exe to not keep the file open? Incidentally, after waiting a couple of minutes, I can delete the file normally. Anyone have any ideas or suggestions? If I can't solve this, I've got to rewrite a ton of code and develop workarounds. Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could this be related to the fact that I can't delete or rename files that have been uploaded?
I wonder if the new feature is going to be a problem with Windows 2008 Server? On Thu, May 28, 2009 at 10:50 PM, Ryan Letulle bayous...@gmail.com wrote: Someone reported the exact same problem either here or on the Railo Group yesterday. Apparently it's a new window's feature. :) -- Ryan On Thu, May 28, 2009 at 9:36 PM, Rick Faircloth r...@whitestonemedia.com wrote: I've run into this curious problem recently, since switching to Windows 7 RC, concerning deleting or renaming uploaded files. I was trying to sort out this problem through a development site when I decided to delete all the files that I had uploaded to my local system and couldn't delete through the browser. Various errors during deleting or renaming keep occuring, such as e:\images\blah.jpg can't be deleted for some unknown reason...and yes, CF says, for some unknown reason. However, after an error was thrown in the browser, I did decide to just delete all the files building up through Windows Explorer. I deleted all but one successfully, and that one I couldn't delete was the last one I uploaded. Windows Explorer threw an error stating, The action can't be completed because the file is open in jrun.exe ??? What does that mean? Is CF ( meaning jrun.exe?) hanging onto the file somehow, which would explain why I can't delete it or rename it as I normally can with CF? Is there a way to force jrun.exe to not keep the file open? Incidentally, after waiting a couple of minutes, I can delete the file normally. Anyone have any ideas or suggestions? If I can't solve this, I've got to rewrite a ton of code and develop workarounds. Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - new site development and IIS rewrite rules
You could use Apache locally to get the rules in place for your dev site and then put in place equivalent rules on the prod IIS server. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/29 Les Mizzell lesm...@bellsouth.net: Andy Matthews wrote: I agree with Dave. I've used URL rewriting on two projects now (including my own blog: www.andymatthews.net) and it's best to put the rules in place right away. Remember that without the rules your links would have to point to the .cfm versions rather than the clean version so it's really going to affect your entire site. Looks like this is going to be a PITA developing locally though. XP Pro only runs IIS 5.1 - which only allows one site - and I've not figured out how to get any rewrite rules to actually work locally on that so far. No problem out on the actual server... Back to Google. Ack! ~| 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:322939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT, looking for an affordable SMTP/POP3 solution
On Fri, May 29, 2009 at 1:18 AM, Claude Schneegans wrote: I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Postfix. If you want to offer IMAP as well and total mail volume goes over 50 GB I would add Dovecot it. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:322940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
