CFGRID with blinking column
Hi, Is there anyway to make a Particular Row and Particular Column to blink using action scripts. i m using flashing remoting method to fill the grid . Thanks in advance. Johnson ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Ajax and CFCs
On Wednesday 14 September 2005 17:50, Matthew Blatchley wrote: Very cool.. I've taken another look. It is, indeed, very very cool. (Briefly, seemless data binding of javascript to remote (java|.net) classes with Ajax). And it's free (apperently) for commercial use. :forwards widely. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Jrun Update and cflocation
We have just applied JRun 4 updater 6 to an MX 6.1 Enterprise server. We have 2 instances set up in a cluster serving 1 site in IIS6. We have made use of cflocation in the site to redirect users to a new page. After applying Updater 6, this redirect now fails - a blank page appears, but the browser has the new URL in its address bar. However apparently only on Internet Explorer. Firefox appears to still handle this ok. We've also narrowed it down to URLs with variables in it only. The following presents the user a blank page. Hitting refresh loads it fine. cfsilent cfparam name=attributes.sap_realestateagent_cit_id default=/for_property_buyers/agent/90007.cfm /cfsilent cflocation url=#attributes.sap_realestateagent_cit_id# addtoken=no Using just cflocation url=/file.cfm addtoken=no works ok. Any ideas on this? It worked fine before this update but I cannot find any references linking this issue to the update. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Create Excel file
That is the fella yeah. -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 17:31 To: CF-Talk Subject: Re: Create Excel file Is this what you are referring to? http://jakarta.apache.org/poi/ On 9/14/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Yep, I would certainly recommend using POI if you can. -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 16:27 To: CF-Talk Subject: Re: Create Excel file ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf_twoselectsrelated
I have sent you one off list, hope it is what you are looking for. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 20:43 To: CF-Talk Subject: cf_twoselectsrelated Does anyone have a version of cf_twoselectsrelated (or something similar) that accepts a parameter to 'preselect' records in the second select depending upon what is selected in the first? Thanks. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218386 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf_twoselectsrelated
Two and Three are here for anyone who needs them. http://www.cfugspain.org/index.cfm/fuseaction/coldfusion.customtags.cfm Allan -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: 15 September 2005 11:20 To: CF-Talk Subject: RE: cf_twoselectsrelated I have sent you one off list, hope it is what you are looking for. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: 14 September 2005 20:43 To: CF-Talk Subject: cf_twoselectsrelated Does anyone have a version of cf_twoselectsrelated (or something similar) that accepts a parameter to 'preselect' records in the second select depending upon what is selected in the first? Thanks. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your experience of Bluedragon.net?
This is good stuff guy's, thanks. If I understand correctly Bluedragon can be configured on a per site basis so my next question is has anyone had Bluedragon Coldfusion running on the same server or have I completely got the wrong end of the stick? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Create Excel file
Does CFREPORT use POI? -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 September 2005 01:39 To: CF-Talk Subject: Re: Create Excel file You can use CFREPORT to create formatted Excel files very easily, using query data but we don't currently support multi-tabbed Excel spreadsheets. HTH Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Populating Radio Buttons in CFFORM?
Hi Thanks for the help using your expert advice has solved the problem ! One other problem I was getting with the radio buttons was the following error if I do not select a radio button as it is not a required field Element ORIGIN is undefined in FORM. Any ideas on why I am getting this error message when it has been defined in the code below? If for example I selected one of the radio buttons I do not recieve any the above error cfif not isdefined(SESSION.test) !--- If the structure is undefined, create or initialize it --- CFSET SESSION.test = structnew() !--- The code below represents the users progress in the wizard --- cfset SESSION.test.stepNum = 1 !--- We will collect these from the user; start as blank values --- cfset SESSION.test.title = cfset SESSION.test.applicant = cfset SESSION.test.origin = etc... /cfif cfif isDefined(FORM.title) cfset SESSION.test.title = Form.title cfset SESSION.test.applicant = Form.applicant cfset SESSION.test.origin = Form.origin /cfif cfform action=application.cfm?StepNum=#session.test.StepNum# method=POST cfinput name=title size=50 required=Yes message=Please enter your Title value=#SESSION.test.title# validateAt=onsubmit, onserver cfinput name=applicant size=50 required=Yes message=Please complete value=#SESSION.test.applicant# validateAt=onsubmit, onserver cfinput name=origin type=radio value=OriginOrigin1 cfinput name=origin type=radio value=Origin1Origin2 cfinput name=origin type=radio value=Origin2Origin3 /cfform ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Multiple selections on a Flash Form
Hi,
I have just about got to grips with a Flash form, and now have a drop down
list of names which then populates a field with the mobile number of the
selected name.
I am coming unstuck now when trying to select multiple names, and add each
selected mobile to the text field. I currently have the code
bind={staff.selectedItem.data}
in the text field parameters to select a single item, but selectedItems
isn't working as it apparently should be!
Thanks in advance
Paul
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218391
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Jrun Update and cflocation
On Thursday 15 September 2005 09:46, Markus Lindemann wrote: Any ideas on this? It worked fine before this update but I cannot find I assume you have added a log statement to verify that the value of the url attribute is what you expect? -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218392 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Create Excel file
No. Does CFREPORT use POI? -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 September 2005 01:39 To: CF-Talk Subject: Re: Create Excel file You can use CFREPORT to create formatted Excel files very easily, using query data but we don't currently support multi-tabbed Excel spreadsheets. HTH Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple selections on a Flash Form
MrG wrote:
Hi,
I have just about got to grips with a Flash form, and now have a drop down
list of names which then populates a field with the mobile number of the
selected name.
I am coming unstuck now when trying to select multiple names, and add each
selected mobile to the text field. I currently have the code
bind={staff.selectedItem.data}
in the text field parameters to select a single item, but selectedItems
isn't working as it apparently should be!
Did you see my reply yesterday?
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218394
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple selections on a Flash Form
MrG wrote: Did you see my reply yesterday? I did, but I'm sure there must be an easier way of doing things just using the parameters within the Flash form surely? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Formatting text in IM Gateway
Thanx Damon...I tried that already. The message gest passed to CF as plain text. On 9/14/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: You might try sending one to your bot with formatted text and see what it comes across as pretty easily. It might be that each service uses it's own scheme (or something standard such as RTF). Not sure... I am using an IM gateway. I would like some of the responses to have basic formatting in the text (bold, ital). Anyone know how a message sent via gateways should be formatted to achieve this? -- Scott Stroz Boyzoid.com http://Boyzoid.com http://Boyzoid.com ___ Some days you are the dog, Some days you are the tree. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218396 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Formatting text in IM Gateway
in the jabber bots (at least google talk) you surround text with a * for bold and a _ for italics. *this is bold* _this is italics_ Thats the only two I know, but may give you enough info to google it more. On 9/14/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: You might try sending one to your bot with formatted text and see what it comes across as pretty easily. It might be that each service uses it's own scheme (or something standard such as RTF). Not sure... I am using an IM gateway. I would like some of the responses to have basic formatting in the text (bold, ital). Anyone know how a message sent via gateways should be formatted to achieve this? -- Scott Stroz Boyzoid.com http://Boyzoid.com ___ Some days you are the dog, Some days you are the tree. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218397 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Another radio button problem
You have an ID field for every single record. So yes, it's hitting them all in your action query when you loop over that field. Give your delete_noticeboard field a value of the NoticeBoardID inside your loop. On your form, change input name=delete_noticeboard type=checkbox value=Yes To input name=delete_noticeboard type=checkbox value=#NoticeBoardID# At the top of your update query page, add this to ensure no error is thrown when no boxes were checked cfparam name=form.delete_noticeboard default= And in your loop, change list=#form.ID# to list=#form.delete_noticeboard# When you submit the form now, the #Form.delete_noticeboard# will hold a comma delimited list of all of the selected check box values. (A comma delimited list of all the NoticeIDs you want to delete) Good luck. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 12:00 AM To: CF-Talk Subject: Another radio button problem I am having issues with a form that allows multiple deletes (or in this case simply changing the active db field to no) from a database using checkboxes. Hers the deal so far. The query to display all noticeboard items is... cfquery name = qryNoticeboard datasource = #request.dsn# SELECTnoticeboardID, title, description, dateAdded, userInitials, active FROM noticeBoard WHERE active = Yes ORDER BY dateAdded DESC /cfquery In the display, I have.. form method=post action=cfoutput#myself##xfa.processNoticeboardDeletion#/cfoutput id=deleteNoticeboardItem cfoutput query=qryNoticeboard div class=noticeboard span class=title#dateformat(dateAdded, d/mm/)# - #timeformat(dateAdded, hh:mm tt)# :/span strong#title#/strongbr / #description# cfif Len(userInitials)span class=user-initials[#userInitials#]/span/cfif br / div class=genericform input type=hidden name=ID value=#noticeboardID# / input type=hidden name=boardCount value=#qryNoticeboard.recordCount# / input name=delete_noticeboard type=checkbox value=Yes / /div /div /cfoutput input type=submit name=Submit value=delete item class=btn-gray / /form And the processing (which I am pretty sure where my logic is screwed). Ive tried cfloop list=#form.ID# index=listItem cfquery datasource = #request.dsn# name = qryDeleteNoticeboardItem UPDATE noticeBoard SET active = No WHERE noticeboardID = #listItem# /cfquery /cfloop But naturally this turns off ALL records, because it seems all IDs are being passed into form.ID. I need a way to pass only the IDs that are ticked in the display. Any ideas? Please help! All help greatly appreciated. regards Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forms: Populating a text field from a drop down menu
paul gordon wrote:
paul gordon wrote:
I haven't done that, just tried the Flash form.
Hooray! I've actually got the field to display the number of the
person selected.
Is there a way of preserving the number and adding further numbers to
the same field?
Hi Stephen,
I'm trying to implement your way of doing things, but can only get so far.
What would the _root.phonelist refer to in my code?
It is still only adding one mobile number, and I think this would be the reason
- sorry if I sound dumb!
cfsavecontent variable=variables.namechange
var myClickHandler = function (evt){
var thisPhoneList = _root.phonelist;
if (evt.detail == mx.controls.Alert.OK){
if (thisPhoneList.value.length 0) thisPhoneList.value.length =
thisPhoneList.value.length+',';
thisPhoneList.value.length =
thisPhoneList.value.length+fartist.selectedItem.data;
}
}
alert(Are you sure you want to add this mobile number?, Warning,
mx.controls.Alert.OK | mx.controls.Alert.CANCEL, myClickHandler);
/cfsavecontent
cfquery name=getArtists datasource=cfartgallery
SELECT *
FROM ARTISTS
/cfquery
cfform method=get preloader=no format=flash skin=haloblue
cfselect name=fartists query=getArtists display=FIRSTNAME
value=PHONE onchange=#variables.namechange#
/cfselect
cftextarea name=phonelist label=Selected Mobile Numbers
enabled=false height=10 width=30 /
/cfform
Again, typed straight into the email, so there may be errors (make
sure you turn on flash debugging in the CF administrator, while you're
developing your form), but it should be about right.
Stephen
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218399
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple selections on a Flash Form
paul gordon wrote: MrG wrote: Did you see my reply yesterday? I did, but I'm sure there must be an easier way of doing things just using the parameters within the Flash form surely? I'm afraid not. You have to programmatically populate your text box with the mobile numbers. There are only simple one-to-one field binds in cfform. Stephen ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218400 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forms: Populating a text field from a drop down menu
paul gordon wrote:
I'm trying to implement your way of doing things, but can only get so far.
What would the _root.phonelist refer to in my code?
It is still only adding one mobile number, and I think this would be the
reason - sorry if I sound dumb!
Don't worry about it... I spent 3 extremely painful weeks trying to
create a fairly complex order form for a client before I started to get
the hang of cfforms.
thisPhoneList.value.length =
thisPhoneList.value.length+fartist.selectedItem.data;
ahem... typos in my code sorry... I wrote the email while I working
on some stuff of my own and mixed the two up.
if (thisPhoneList.text.length 0) thisPhoneList.text= thisPhoneList.text+',';
thisPhoneList.text = thisPhoneList.text+fartist.selectedItem.data;
_root.phonelist refers to the cfinput/cftextarea in your form where your mobile
numbers are being copied to.
You need to remove the bind from your cfinput/cftextarea, otherwise it will
override the action script that is populating it onchange of your dropdown.
Actionscript variables are case sensitive, so make sure that the field name is
exactly the same in the scripting as it is in the cfinput/cftextarea.
Here's some corrected code.
cfsavecontent variable=variables.namechange
var thisPhoneList = _root.phonelist;
var selectedPhoneNo = _root.fartist.selectedItem.data;
var myClickHandler = function (evt){
if (evt.detail == mx.controls.Alert.OK){
if (thisPhoneList.text.length 0) thisPhoneList.text =
thisPhoneList.text+',';
thisPhoneList.text = thisPhoneList.text+selectedPhoneNo;
}
}
alert(Are you sure you want to add this mobile number?, Warning,
mx.controls.Alert.OK | mx.controls.Alert.CANCEL, myClickHandler);
/cfsavecontent
cfquery name=getArtists datasource=cfartgallery
SELECT *
FROM ARTISTS
/cfquery
cfform method=get preloader=no format=flash skin=haloblue
cfselect name=fartists query=getArtists display=FIRSTNAME
value=PHONE onchange=#variables.namechange# /
cftextarea name=phonelist label=Selected Mobile Numbers
enabled=false height=10 width=30 /
/cfform
Stephen
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218401
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forms: Populating a text field from a drop down menu
Stephen, thanks for your time and patience with me, this now works! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your experience of Bluedragon.net?
i guess you didnt get the invite :) to the ceremony That's kind of silly. Macromedia is a software company; I don't recall seeing a blood oath in the EULA. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ -- tony Tony Weeg tonyweeg [at] gmail [dot] com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF do this?
Claude Schneegans wrote: Most printers prefer 300dpi images for maximum quality... Printers don't give a dam about DPIs... Image do not have DPIs*, they just have pixels, the more pixels there are, the better the image looks on the printer, period. Not to nitpick, but having a degree in printing from the great school of Western Michigan University, let me assure you that printers DO care about DPI. If you have a 6x9 book cover image, the only thing that matters is DPI. If you send a 72 DPI photoshop document to the printer, it's gonna look like crap. I will grant that you can take that 72 DPI image and shrink it down to 3x4.5 and it'll look better but that's not the point. If you want it to look good at 6x9 you have to have a higher resolution than 72 DPI. And any printer you call will say the same thing. Rick Side Note: Western Michigan University also has a paper science and engineering program, and has both a pilot papermaking facility and a printing facility, making it the only university in the world where you can take in a truckload of trees and take out your printed product. Go Broncos! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Create Excel file
Didn't think so, but POI is available in CF7 yeah? So you could do multiple tabbed sheets in CF7 easily via that. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 September 2005 11:59 To: CF-Talk Subject: Re: Create Excel file No. Does CFREPORT use POI? -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 September 2005 01:39 To: CF-Talk Subject: Re: Create Excel file You can use CFREPORT to create formatted Excel files very easily, using query data but we don't currently support multi-tabbed Excel spreadsheets. HTH Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Studio 8 available for download
thanks dave. i got it, did another dl of the files, with IE not FF (like i had tried before) and it was all good. nearly 99% sure that the browser type shouldnt matter, but whatever, its all good however, i think my copy of studio will be here shortly anyway... me On 9/14/05, Dave Watts [EMAIL PROTECTED] wrote: i downloaded dreamweaver trial, and am getting an error trying to install it... I've often downloaded large MM installers, and had to download them again because they've been corrupted. For CF, at least, they list checksums for the files so you can use md5sums or a similar tool to ensure that it's not corrupted. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218407 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
What database? And how did you rename the procedure? I would say make sure you recreate the CFC object if it's stored in a shared scope (like say the application scope) but since the spelling was changed in the db and not in the CFC that shouldn't be relevant. Other than that, I'd say try restarting the CF server service. Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218408 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF do this?
If you send a 72 DPI photoshop document to the printer, it's gonna look like crap. If you send the image directly to the printer, it will take care of the DPI embeded in the image, personally I never send images direcly to the printer, I always use some soft to lay the image the way I want in the page, and I choose myself the DPI of the printer, as well as the printing quality. And when the image is included inside another document, the DPI is simply ignored. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFCHART X-Axis Labelling...
Dan, However, what makes it difficult is how the tag syntax doesn't really match up at all w/the actual WebChart3D syntax. This is what makes it such a pain to map functionality from the WebCharts3D XML syntax to what CF is actually doing. Agreed. I'm not sure what someone was thinking when they decided to expose a limited set of attributes, along with the Designer and the .xml files, and not make terminology match up. I wonder if it would work to give us a cfchartproperty / tag where we could do something like: cfchartproperty name=frameChart.xAxis.labelStyle attributeName=isHideOverlapped value=false / Something like that could allow us to change properties/tag values of a pre-defined stylesheet. If the branch/node doesn't exist in the sheet, CF would generate an error. Actually, that sounds like a terrific idea. That would allow setting of a variable value, then placing it into the value of the properyty. And it avoids having a bunch of new attributes for the cfchart tag itself. What they would need, of course, is documentation, so you don't have to go through the .xml files, or the minimal info in Designer, to try to figure out what you can set. I think you should submit this as a feature request, and perhaps pass the gist of the discussion on to Tim Buntel at Macromedia. He was pretty helpful to me early in the CFMX7 charting work, when I identified what they called a feature and I called a bug. They issued a hotfix for it. I think there a few features people would use in CFCHART if they knew they existed. More than a few, I think. Have you found a way to do that? Unfortunately, I haven't dealt with modifying bar charts yet at all. Most of the stuff I've run into has been with line charts. I just recognized that we were running into similar issues. Good luck. By the way, as long as we're corresponding -- thanks for qForms. It's a great help! -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218410 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: JS and Checkbox Select
Hey guys, I'm having a hard time making this work... it's probably my brain this morning. I have a form with a series of checkboxes for a search. One is 'all documents' and the rest identify certain containers. I need some JavaScript that will deselect 'All Documents' if somebody selects one of the other checkboxes. Can somebody give me a hand? These are my checkboxes: input type=checkbox name=all_documents value=1 checkedAll Documents input type=checkbox name=annual_report value=1Annual Report input type=checkbox name=book value=1Books and Studies input type=checkbox name=briefing_paper value=1Briefing Papers input type=checkbox name=issue_brief value=1Issue Briefs input type=checkbox name=working_paper value=1Working Papers Thank you so much. -- Jillian ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. Thanks, George On 9/15/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: What database? And how did you rename the procedure? I would say make sure you recreate the CFC object if it's stored in a shared scope (like say the application scope) but since the spelling was changed in the db and not in the CFC that shouldn't be relevant. Other than that, I'd say try restarting the CF server service. Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218412 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: JS and Checkbox Select
SCRIPT LANGUAGE=JavaScript
!-- Begin
function checkAll() {
var el = document.forms[0].elements;
for(var i = 0 ; i el.length ; ++i) {
if(el[i].type == checkbox) {
el[i].checked = true;
}
}
}
function unCheckAll() {
var i=0;
for( i=0 ; idocument.forms[0].elements.length; i++) {
document.forms[0].elements[i].checked=0;
}
}
// End --
/script
input type=button value=Check All
onClick=checkAll();nbsp;nbsp;
input type=button value=Un-Check All
onClick=unCheckAll(); return false;
input type=Submit name=submit value=Process
Selected Items
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 10:16 AM
To: CF-Talk
Subject: OT: JS and Checkbox Select
Hey guys,
I'm having a hard time making this work... it's probably my brain this
morning.
I have a form with a series of checkboxes for a search. One is 'all
documents' and the rest identify certain containers.
I need some JavaScript that will deselect 'All Documents' if somebody
selects one of the other checkboxes. Can somebody give me a hand?
These are my checkboxes:
input type=checkbox name=all_documents value=1 checkedAll
Documents
input type=checkbox name=annual_report value=1Annual Report
input type=checkbox name=book value=1Books and Studies
input type=checkbox name=briefing_paper value=1Briefing Papers
input type=checkbox name=issue_brief value=1Issue Briefs
input type=checkbox name=working_paper value=1Working Papers
Thank you so much.
--
Jillian
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218413
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
George, I have a short piece of code at the start of my application that does two things. 1/ Checks for a url variable and if present sets all the cacheds CFCs to a space. 2/ Checks each cached CFC to see that it is defined and not a space. If so it reinitialises it and puts it in the application or server scope. Hope that helps. Kevin Roche -- Original Message -- From: George Abraham [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 15 Sep 2005 10:22:52 -0400 Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. Thanks, George On 9/15/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: What database? And how did you rename the procedure? I would say make sure you recreate the CFC object if it's stored in a shared scope (like say the application scope) but since the spelling was changed in the db and not in the CFC that shouldn't be relevant. Other than that, I'd say try restarting the CF server service. Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
dynamically generated INSERT problem
I am using Oracle and I have an insert where the first few columns
are defined and then the last 9 columns are pulled in through a text
delimited file. I am receiving the error:
[Oracle]ORA-00984: column not allowed here
INSERT INTO grants_contracts ( g_c_id,date_added,status,
account_number,proposal_id, funding_agency,agency_contract_number,
id,title, funding,start_date, end_date ) VALUES (
unique_g_c_num_s.NEXTVAL,SYSDATE,current , (param 1) , (param 2) ,
(param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8)
, (param 9) )
I can't seem to see the error. The code that generates it is pretty
lengthy. Here it is:
CFQUERY NAME=add_item DATASOURCE=dpch
INSERT INTO grants_contracts
(
g_c_id,date_added,
account_number,proposal_id,
funding_agency,agency_contract_number,
id,title,
funding,start_date,
end_date,abstract,
related_file,status
VALUES
(
unique_g_c_num_s.NEXTVAL,SYSDATE !--- SYSDATE comma is
provided by following cfqueryparams ---
cfloop from=1 to=#arrayLen(tmp_ar)# index=gg
cfset error_ar = arrayNew(1)
cfif tmp_ar[gg] EQ 'null'cfset tmp_ar[gg] = ''/cfif
!--- special cases ---
cfswitch expression=#gg#
cfcase value=5,7 delimiters=,
cfif gg EQ 5
!--- FORMAT: Ennis, Catherine D. ---
cfset the_name = listToArray(tmp_ar[gg],,)
cfset lname = the_name[1]
!---
get the second piece of name (fname),
remove the middle initial by grabbing
first name
remove any residual spaces
---
cfset fname = listToArray(the_name[2], )
cfset fname = replace(fname[1], ,,all)
!--- get their id and if there are two,
grab just the top one *not a great query, might return 1* ---
CFQUERY NAME=people DATASOURCE=dpch
maxrows=1
select fname,lname,id
from PEOPLE
where UPPER(fname) = UPPER('#fname#')
AND UPPER(lname) = UPPER('#lname#')
order by id
/CFQUERY
cfif people.recordCount EQ 0
cfset arrayAppend(error_ar,Missing
Person: #fname#,#lname#)
cfelse
,cfqueryparam value=#people.id#
cfsqltype=CF_SQL_NUMERIC
/cfif
!--- cfoutputp#people.id#/p/cfoutput
cfabort ---
/cfif
cfif gg EQ 7
!--- replace . and $ and , with nothing.
didn't use replacelist cause I was replacing a comma and it's comma
delimited ---
cfset tmp_ar[gg] =
replace(replace(replace(tmp_ar[gg],.,,all),$,,all)all)
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=CF_SQL_NUMERIC
/cfif
/cfcase
cfcase value=8,9 delimiters=,
!--- build out dates ---
cfset the_date = listToArray(tmp_ar[gg],/)
cfset the_date =
createDate(the_date[3],the_date[1],the_date[2])
,cfqueryparam value=#the_date#
cfsqltype=CF_SQL_DATE
/cfcase
cfdefaultcase
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=cf_sql_varchar
/cfdefaultcase
/cfswitch
/cfloop
,cfqueryparam value= cfsqltype=cf_sql_varchar,
cfqueryparam value=
cfsqltype=cf_sql_varchar,cfqueryparam value=current
cfsqltype=cf_sql_varchar
)
/CFQUERY
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218415
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
Re: CFC caching?
Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. Yeah, that would do it too... When you store a CFC in a persistent scope, any changes you make to the CFC won't be reflected in your application until you recreate the CFC by calling createObject() or using the cfobject tag again... so, for instance if you have this in your application.cfc cffunction name=onApplicationStart cfset application.myFactory = createObject(component,factory) /cffunction Then if you make any changes to the factory.cfc you would need to re-execute this line: cfset application.myFactory = createObject(component,factory) I believe (don't quote me) that you can do that actually by instantiating the application.cfc within the page and then calling appcfc.onApplicationStart() which might be useful if you happen to be instantiating a lot of application scope CFC's in the onApplicationStart event. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. Nah... I think people may have been confused by your original post and were thinking (like I was) that the name had been changed in the db rather than in the CFC... Once I know the name change occurred in the CFC, then shared-scopes is the first thing that comes to mind for me. :) And once you're done with the development of your shared-scope cfc's, then the thing should run smoothly without needing to recreate them in production. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. I'd have to know more about the specifics of your application to give a really useful opinion on that... What kind of audit is this, where/how is the audit used? If it's just to get a query for a report, then there's a good chance using a CFC is overkill (unless you're building it into a larger object that performs other related tasks). s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218416 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dynamically generated INSERT problem
Don't know Oracle, but in MSSQL, literals use single quote ie. 'current'.
current would be a column name.
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 10:44 AM
To: CF-Talk
Subject: dynamically generated INSERT problem
I am using Oracle and I have an insert where the first few columns
are defined and then the last 9 columns are pulled in through a text
delimited file. I am receiving the error:
[Oracle]ORA-00984: column not allowed here
INSERT INTO grants_contracts ( g_c_id,date_added,status,
account_number,proposal_id, funding_agency,agency_contract_number,
id,title, funding,start_date, end_date ) VALUES (
unique_g_c_num_s.NEXTVAL,SYSDATE,current , (param 1) , (param 2) ,
(param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8)
, (param 9) )
I can't seem to see the error. The code that generates it is pretty
lengthy. Here it is:
CFQUERY NAME=add_item DATASOURCE=dpch
INSERT INTO grants_contracts
(
g_c_id,date_added,
account_number,proposal_id,
funding_agency,agency_contract_number,
id,title,
funding,start_date,
end_date,abstract,
related_file,status
VALUES
(
unique_g_c_num_s.NEXTVAL,SYSDATE !--- SYSDATE comma is
provided by following cfqueryparams ---
cfloop from=1 to=#arrayLen(tmp_ar)# index=gg
cfset error_ar = arrayNew(1)
cfif tmp_ar[gg] EQ 'null'cfset tmp_ar[gg] = ''/cfif
!--- special cases ---
cfswitch expression=#gg#
cfcase value=5,7 delimiters=,
cfif gg EQ 5
!--- FORMAT: Ennis, Catherine D. ---
cfset the_name = listToArray(tmp_ar[gg],,)
cfset lname = the_name[1]
!---
get the second piece of name (fname),
remove the middle initial by grabbing
first name
remove any residual spaces
---
cfset fname = listToArray(the_name[2], )
cfset fname = replace(fname[1], ,,all)
!--- get their id and if there are two,
grab just the top one *not a great query, might return 1* ---
CFQUERY NAME=people DATASOURCE=dpch
maxrows=1
select fname,lname,id
from PEOPLE
where UPPER(fname) = UPPER('#fname#')
AND UPPER(lname) = UPPER('#lname#')
order by id
/CFQUERY
cfif people.recordCount EQ 0
cfset arrayAppend(error_ar,Missing
Person: #fname#,#lname#)
cfelse
,cfqueryparam value=#people.id#
cfsqltype=CF_SQL_NUMERIC
/cfif
!--- cfoutputp#people.id#/p/cfoutput
cfabort ---
/cfif
cfif gg EQ 7
!--- replace . and $ and , with nothing.
didn't use replacelist cause I was replacing a comma and it's comma
delimited ---
cfset tmp_ar[gg] =
replace(replace(replace(tmp_ar[gg],.,,all),$,,all)all)
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=CF_SQL_NUMERIC
/cfif
/cfcase
cfcase value=8,9 delimiters=,
!--- build out dates ---
cfset the_date = listToArray(tmp_ar[gg],/)
cfset the_date =
createDate(the_date[3],the_date[1],the_date[2])
,cfqueryparam value=#the_date#
cfsqltype=CF_SQL_DATE
/cfcase
cfdefaultcase
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=cf_sql_varchar
/cfdefaultcase
/cfswitch
/cfloop
,cfqueryparam value= cfsqltype=cf_sql_varchar,
cfqueryparam value=
cfsqltype=cf_sql_varchar,cfqueryparam value=current
cfsqltype=cf_sql_varchar
)
/CFQUERY
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
Re: dynamically generated INSERT problem
It is the current the double quotes specifically. Offhand I do not see
where in your code it gets put in that way. My guess would be that it is a
variable in need of preserve single quotes function but I did not notice the
need in a very quick look over your code.
On 9/15/05, Daniel Kessler [EMAIL PROTECTED] wrote:
I am using Oracle and I have an insert where the first few columns
are defined and then the last 9 columns are pulled in through a text
delimited file. I am receiving the error:
[Oracle]ORA-00984: column not allowed here
INSERT INTO grants_contracts ( g_c_id,date_added,status,
account_number,proposal_id, funding_agency,agency_contract_number,
id,title, funding,start_date, end_date ) VALUES (
unique_g_c_num_s.NEXTVAL,SYSDATE,current , (param 1) , (param 2) ,
(param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8)
, (param 9) )
I can't seem to see the error. The code that generates it is pretty
lengthy. Here it is:
CFQUERY NAME=add_item DATASOURCE=dpch
INSERT INTO grants_contracts
(
g_c_id,date_added,
account_number,proposal_id,
funding_agency,agency_contract_number,
id,title,
funding,start_date,
end_date,abstract,
related_file,status
VALUES
(
unique_g_c_num_s.NEXTVAL,SYSDATE !--- SYSDATE comma is
provided by following cfqueryparams ---
cfloop from=1 to=#arrayLen(tmp_ar)# index=gg
cfset error_ar = arrayNew(1)
cfif tmp_ar[gg] EQ 'null'cfset tmp_ar[gg] = ''/cfif
!--- special cases ---
cfswitch expression=#gg#
cfcase value=5,7 delimiters=,
cfif gg EQ 5
!--- FORMAT: Ennis, Catherine D. ---
cfset the_name = listToArray(tmp_ar[gg],,)
cfset lname = the_name[1]
!---
get the second piece of name (fname),
remove the middle initial by grabbing
first name
remove any residual spaces
---
cfset fname = listToArray(the_name[2], )
cfset fname = replace(fname[1], ,,all)
!--- get their id and if there are two,
grab just the top one *not a great query, might return 1* ---
CFQUERY NAME=people DATASOURCE=dpch
maxrows=1
select fname,lname,id
from PEOPLE
where UPPER(fname) = UPPER('#fname#')
AND UPPER(lname) = UPPER('#lname#')
order by id
/CFQUERY
cfif people.recordCount EQ 0
cfset arrayAppend(error_ar,Missing
Person: #fname#,#lname#)
cfelse
,cfqueryparam value=#people.id#
cfsqltype=CF_SQL_NUMERIC
/cfif
!--- cfoutputp#people.id#/p/cfoutput
cfabort ---
/cfif
cfif gg EQ 7
!--- replace . and $ and , with nothing.
didn't use replacelist cause I was replacing a comma and it's comma
delimited ---
cfset tmp_ar[gg] =
replace(replace(replace(tmp_ar[gg],.,,all),$,,all)all)
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=CF_SQL_NUMERIC
/cfif
/cfcase
cfcase value=8,9 delimiters=,
!--- build out dates ---
cfset the_date = listToArray(tmp_ar[gg],/)
cfset the_date =
createDate(the_date[3],the_date[1],the_date[2])
,cfqueryparam value=#the_date#
cfsqltype=CF_SQL_DATE
/cfcase
cfdefaultcase
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=cf_sql_varchar
/cfdefaultcase
/cfswitch
/cfloop
,cfqueryparam value= cfsqltype=cf_sql_varchar,
cfqueryparam value=
cfsqltype=cf_sql_varchar,cfqueryparam value=current
cfsqltype=cf_sql_varchar
)
/CFQUERY
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu http://www.phi.umd.edu
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218418
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Populating Radio Buttons in CFFORM? - Fixed
Solved the problem using CFIF isdefined statements Thanks for your help ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
I'll clean that up, thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218420 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
ok, it doesn't seem to be the code, probably, but more likely the data. sorry for not checking that before posting. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218421 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
One thing you can do when debugging things like this is copy the SQL generated and shown in your CFM debugging information and then run it in whatever SQL client you use. You would need to replace the params with their actual values though since they would throw an error as is. In this instance if you can ran that within something like Toad it would have highlighted the current and posted the same error msg you say from CF. On 9/15/05, daniel kessler [EMAIL PROTECTED] wrote: ok, it doesn't seem to be the code, probably, but more likely the data. sorry for not checking that before posting. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218422 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
Simple error (so I didn't even read the code that generates this - there may
be others) - You're using double quotes for current. You need to use
single quotes.
On 9/15/05, Daniel Kessler [EMAIL PROTECTED] wrote:
I am using Oracle and I have an insert where the first few columns
are defined and then the last 9 columns are pulled in through a text
delimited file. I am receiving the error:
[Oracle]ORA-00984: column not allowed here
INSERT INTO grants_contracts ( g_c_id,date_added,status,
account_number,proposal_id, funding_agency,agency_contract_number,
id,title, funding,start_date, end_date ) VALUES (
unique_g_c_num_s.NEXTVAL,SYSDATE,current , (param 1) , (param 2) ,
(param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8)
, (param 9) )
I can't seem to see the error. The code that generates it is pretty
lengthy. Here it is:
CFQUERY NAME=add_item DATASOURCE=dpch
INSERT INTO grants_contracts
(
g_c_id,date_added,
account_number,proposal_id,
funding_agency,agency_contract_number,
id,title,
funding,start_date,
end_date,abstract,
related_file,status
VALUES
(
unique_g_c_num_s.NEXTVAL,SYSDATE !--- SYSDATE comma is
provided by following cfqueryparams ---
cfloop from=1 to=#arrayLen(tmp_ar)# index=gg
cfset error_ar = arrayNew(1)
cfif tmp_ar[gg] EQ 'null'cfset tmp_ar[gg] = ''/cfif
!--- special cases ---
cfswitch expression=#gg#
cfcase value=5,7 delimiters=,
cfif gg EQ 5
!--- FORMAT: Ennis, Catherine D. ---
cfset the_name = listToArray(tmp_ar[gg],,)
cfset lname = the_name[1]
!---
get the second piece of name (fname),
remove the middle initial by grabbing
first name
remove any residual spaces
---
cfset fname = listToArray(the_name[2], )
cfset fname = replace(fname[1], ,,all)
!--- get their id and if there are two,
grab just the top one *not a great query, might return 1* ---
CFQUERY NAME=people DATASOURCE=dpch
maxrows=1
select fname,lname,id
from PEOPLE
where UPPER(fname) = UPPER('#fname#')
AND UPPER(lname) = UPPER('#lname#')
order by id
/CFQUERY
cfif people.recordCount EQ 0
cfset arrayAppend(error_ar,Missing
Person: #fname#,#lname#)
cfelse
,cfqueryparam value=#people.id#
cfsqltype=CF_SQL_NUMERIC
/cfif
!--- cfoutputp#people.id#/p/cfoutput
cfabort ---
/cfif
cfif gg EQ 7
!--- replace . and $ and , with nothing.
didn't use replacelist cause I was replacing a comma and it's comma
delimited ---
cfset tmp_ar[gg] =
replace(replace(replace(tmp_ar[gg],.,,all),$,,all)all)
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=CF_SQL_NUMERIC
/cfif
/cfcase
cfcase value=8,9 delimiters=,
!--- build out dates ---
cfset the_date = listToArray(tmp_ar[gg],/)
cfset the_date =
createDate(the_date[3],the_date[1],the_date[2])
,cfqueryparam value=#the_date#
cfsqltype=CF_SQL_DATE
/cfcase
cfdefaultcase
,cfqueryparam value=#tmp_ar[gg]#
cfsqltype=cf_sql_varchar
/cfdefaultcase
/cfswitch
/cfloop
,cfqueryparam value= cfsqltype=cf_sql_varchar,
cfqueryparam value=
cfsqltype=cf_sql_varchar,cfqueryparam value=current
cfsqltype=cf_sql_varchar
)
/CFQUERY
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu http://www.phi.umd.edu
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218423
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Configuration problem - CFMX7
On 9/14/05, Jacob [EMAIL PROTECTED] wrote: Go to C:\CfusionMX7\bin\connectors Try Upgrade IIS connectors .bat file. Thanks. I've done that. But it didn't help. And it doesn't appear to be the issue, anyway. As I said, I can access the CF Admin well enough, so the connector appears to be working. But when I go to any other .cfm file, The page cannot be displayed. Both file and IIS permissions appear to be correct. Any other thoughts from anyone? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
Isaac, rather than in the CFC... Once I know the name change occurred in the CFC, then shared-scopes is the first thing that comes to mind for me. Ahh, good, finally a phrase I can search on! :-) I'd have to know more about the specifics of your application to give a really useful opinion on that... What kind of audit is this, where/how is the audit used? If it's just to get a query for a report, then there's a good chance using a CFC is overkill (unless you're building it into a larger object that performs other related tasks). Maybe audit is a bad word to choose. Logging is a better word. The CFC would log specific actions that a user took so as to provide a log of the actions to the user when requested. A sort of history, if you will. Thanks, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
The error ended up being that I'm searching for a person, to get there ID and make a relationship. In some cases that I can't fathom, it's not finding a particular person. In that case, I hadn't put in a default entry so it was coming up a column short. ok, checked further and she had an extra space in her name. It must've been before I was doing any trimmin. I'll adjust to that now. thanks for all the help, team. Simple error (so I didn't even read the code that generates this - there may be others) - You're using double quotes for current. You need to use single quotes. On 9/15/05, Daniel Kessler [EMAIL PROTECTED] wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218426 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: jrRecv failed errors under SSL
Again, just bumping up the topic. thx, larry We're getting a lot of errors with pages not showing up in the browser when running a CF app under SSL, on a solaris box, with apache 2.x, CFMX 6.1 Enterprise running on top of Jrun4 with updater 2. Here's a typical log file entry for this error: jrApache[17651: 4336] jrRecv failed[31]: 131 131 Connection reset by peer The pages are there, as they do show up in the browser after a couple of refreshes. I have no idea on what is causing this problem or how to solve it. Any ideas or suggestions would be very appreciated. thx, larry ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218427 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
Can I do a trim in oracle?
I have:
WHERE UPPER(fname) = UPPER(Trim('#fname#')) AND UPPER(lname) =
UPPER(Trim('#lname#'))
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218428
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Jrun Update and cflocation
Yup, the value is correct. The browser's address bar shows the correct URL but displays just a blanks page. Doing a meta refresh does the trick, but we've got the cflocation tags in a lot of places and would prefer to keep this method in place. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218429 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Configuration problem - CFMX7
-Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 11:18 AM To: CF-Talk Subject: Re: Configuration problem - CFMX7 On 9/14/05, Jacob [EMAIL PROTECTED] wrote: Go to C:\CfusionMX7\bin\connectors Try Upgrade IIS connectors .bat file. Thanks. I've done that. But it didn't help. And it doesn't appear to be the issue, anyway. As I said, I can access the CF Admin well enough, so the connector appears to be working. But when I go to any other .cfm file, The page cannot be displayed. Both file and IIS permissions appear to be correct. Any other thoughts from anyone? Is the admin in the same virtual server as the site you're having problems with? If not have you checked the script mappings for the problem site? Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF5 and Application scoped queries
We've got a scoped query called application.q_getcountries on a CF5 box. Today it started throwing the following error: Cannot process query Cannot register the query named application.q_getcountries with ColdFusion. There are two likely causes of this problem: - You are using a CFQUERY tag with a scoped query name. Query names cannot be scoped. For example, *MyProject.MyQuery* is an invalid query name. - The query was set as the default query for a tag like CFOUTPUT, CFLOOP, CFMAIL, etc. However, in the body of the tag this query was modified or removed. Default queries cannot be modified or removed inside the bodies of the tags that use them. If i rename it to application.q_getcountry it works just fine, and all other applicaiton scope variables in the file run a-ok. I've placed locks around thequery etc but still getting the error. The query is being run in the application.cfm file I found a post from Ray back in the day at http://lists.evolt.org/archive/Week-of-Mon-20001218/022071.html but there was no solution here. Any ideas? jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form validation utilizing database field types/sizes/etc
Do you look at the db type and then query it accordingly? Actually not, this is the beauty of ODBC: it is (well almost) DB independant. The only things that are DB dependent are a couple of things (flaws) not supported by some ODBC drivers. This is what I was curious about. I am trying to pull the metadata out of the database but it seems that Oracle and SQL don't support the same methods for querying that metadata. For Oracle, it looks like I will be querying ALL_TAB_COLUMNS and for SQL Server it's a query to INFORMATION_SCHEMA. I guess I could make a config that sets the DB type and do my queries accordingly, but I was curious if anyone knew other ways to query the database systems to get the data out. Thanks, Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218432 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
rather than in the CFC... Once I know the name change occurred in the CFC, then shared-scopes is the first thing that comes to mind for me. Ahh, good, finally a phrase I can search on! :-) Though I think there's usually not a hyphen in it. :) And it's still somewhat ambiguous, but if you combine it with other phrases like say google: coldfusion + cfc + shared scope that might produce a few relevant results. I'd have to know more about the specifics of your application to give a really useful opinion on that... What kind of audit is this, where/how is the audit used? If it's just to get a query for a report, then there's a good chance using a CFC is overkill (unless you're building it into a larger object that performs other related tasks). Maybe audit is a bad word to choose. Logging is a better word. The CFC would log specific actions that a user took so as to provide a log of the actions to the user when requested. A sort of history, if you will. Oh okay... yeah, I would say either session or application ... depends how it functions... if you just use a session variable (like session.userid) to filter queries being executed in the application.cfc then that's fine. If you want to actually store say an array of previous actions in memory for frequent use and/or modification (I have a tool in the Members onTap plugin that handles undo/redo functionality for instance) then you might want to use session storage. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218433 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
Last time I RTFM, it depended on the version you were using. 8i supports
ltrim and rtrim, 10g supports trim, but with a different syntax. I'm not
sure about 9i, as we skipped it.
Let me suggest an execellent reference manual: Oracle [your version here]:
The Completed Reference from Oracle Press.
On 9/15/05, daniel kessler [EMAIL PROTECTED] wrote:
Can I do a trim in oracle?
I have:
WHERE UPPER(fname) = UPPER(Trim('#fname#')) AND UPPER(lname) =
UPPER(Trim('#lname#'))
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218434
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: JS and Checkbox Select
Hey guys,
I'm having a hard time making this work... it's probably my brain this
morning.
I have a form with a series of checkboxes for a search. One is 'all
documents' and the rest identify certain containers.
I need some JavaScript that will deselect 'All Documents' if somebody
selects one of the other checkboxes. Can somebody give me a hand?
These are my checkboxes:
input type=checkbox name=all_documents value=1 checkedAll Documents
input type=checkbox name=annual_report value=1Annual Report
input type=checkbox name=book value=1Books and Studies
input type=checkbox name=briefing_paper value=1Briefing Papers
input type=checkbox name=issue_brief value=1Issue Briefs
input type=checkbox name=working_paper value=1Working Papers
Thank you so much.
--
Here's what I used on a recent project, feel free to modify it:
form
input type=checkbox name=selectAll onClick=toggleSelectList()
input name=view type=checkbox value=animalVirology title=Select
Virology
input name=view type=checkbox value=bacteria title=Select Bacteria
input name=view type=checkbox value=monoclonal title=Select Monoclonal
/form
InvalidTag language=javascript type=text/javascript
var lastState = false;
function SetChecked(val){
dml = document.forms['searchForm'];
len = dml.elements.length;
for( var i = 0; i len; i++){
if (dml.elements[i].name=='view')
{
dml.elements[i].checked=val;
}
}
dml.selectAll.checked = val;
}
function toggleSelectList() {
lastState == false ? SetChecked(true) : SetChecked(false);
lastState = lastState == true ? false: true;
}
/script
This will toggle the checked value of the checkboxes.
enjoy,
larry
--
Larry C. Lyons
Web Analyst
BEI Resources
American Type Culture Collection
email: llyons(at)atcc(dot)org
tel: 703.365.2700.2678
--
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218435
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dynamically generated INSERT problem
9i has a Trim() function, could always just use CF functions when in doubt
for an example like what was given.
On 9/15/05, Deanna Schneider [EMAIL PROTECTED] wrote:
Last time I RTFM, it depended on the version you were using. 8i supports
ltrim and rtrim, 10g supports trim, but with a different syntax. I'm not
sure about 9i, as we skipped it.
Let me suggest an execellent reference manual: Oracle [your version here]:
The Completed Reference from Oracle Press.
On 9/15/05, daniel kessler [EMAIL PROTECTED] wrote:
Can I do a trim in oracle?
I have:
WHERE UPPER(fname) = UPPER(Trim('#fname#')) AND UPPER(lname) =
UPPER(Trim('#lname#'))
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218436
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form validation utilizing database field types/sizes/etc
I am trying to pull the metadata out of the database but it seems that Oracle and SQL don't support the same methods for querying that metadata. Sure. All this is non SQL standard, so every one is doing it HIS way, some are not even doing it. The advantage of doing it through ODBC like CFX_ODBCinfo does is that everything is returned in the same query, no matter the DB type. CFX_ODBCinfo only uses features standard in ODBC and available through the ODBC driver. For Oracle, it looks like I will be querying ALL_TAB_COLUMNS and for SQL Server it's a query to INFORMATION_SCHEMA. CFX_ODBCinfo makes no SQL query to the datasource, it only calls C functions in the ODBC package and creates ColdFusion queries with the information provided by the driver. I guess I could make a config that sets the DB type and do my queries accordingly, but I was curious if anyone knew other ways to query the database systems to get the data out. You could, of course, but for the price, you would be much better with CFX_ODBCinfo ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218437 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form validation utilizing database field types/sizes/etc
Do you look at the db type and then query it accordingly? Actually not, this is the beauty of ODBC: it is (well almost) DB independant. The only things that are DB dependent are a couple of things (flaws) not supported by some ODBC drivers. This is what I was curious about. I am trying to pull the metadata out of the database but it seems that Oracle and SQL don't support the same methods for querying that metadata. For Oracle, it looks like I will be querying ALL_TAB_COLUMNS and for SQL Server it's a query to INFORMATION_SCHEMA. I guess I could make a config that sets the DB type and do my queries accordingly, but I was curious if anyone knew other ways to query the database systems to get the data out. Yep, that's why I use JDBC... Here's the article: http://coldfusion.sys-con.com/read/45569.htm s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218438 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your experience of Bluedragon.net?
On 9/15/05, Andy Mcshane [EMAIL PROTECTED] wrote: This is good stuff guy's, thanks. If I understand correctly Bluedragon can be configured on a per site basis so my next question is has anyone had Bluedragon Coldfusion running on the same server or have I completely got the wrong end of the stick? I have done that, but they have to be running on different ports. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218439 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form validation utilizing database field types/sizes/etc
Yeah, I read through it once already, but I'm not a big on java (just because I don't know it). But let me go read through it again. Mike S. Isaac Dealey wrote: Do you look at the db type and then query it accordingly? Actually not, this is the beauty of ODBC: it is (well almost) DB independant. The only things that are DB dependent are a couple of things (flaws) not supported by some ODBC drivers. This is what I was curious about. I am trying to pull the metadata out of the database but it seems that Oracle and SQL don't support the same methods for querying that metadata. For Oracle, it looks like I will be querying ALL_TAB_COLUMNS and for SQL Server it's a query to INFORMATION_SCHEMA. I guess I could make a config that sets the DB type and do my queries accordingly, but I was curious if anyone knew other ways to query the database systems to get the data out. Yep, that's why I use JDBC... Here's the article: http://coldfusion.sys-con.com/read/45569.htm s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218440 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Configuration problem - CFMX7
Jim On 9/15/05, Jim Davis [EMAIL PROTECTED] wrote: Is the admin in the same virtual server as the site you're having problems with? Yep. That's part of the mystery. Same virtual server, same site. Only one on the machine, in fact. This was a clean, never-before-used machine. I can find nothing that should make the functioning of the admin any different from another file/folder. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218441 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can CF do this?
You're talking about a desktop printer and we're talking about using a Print House... companies that do professional printing. Business cards printed at home are ok, but they never look as good as professionally printed ones. Cheers, Kevin -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: September 15, 2005 7:57 AM To: CF-Talk Subject: Re: Can CF do this? If you send a 72 DPI photoshop document to the printer, it's gonna look like crap. If you send the image directly to the printer, it will take care of the DPI embeded in the image, personally I never send images direcly to the printer, I always use some soft to lay the image the way I want in the page, and I choose myself the DPI of the printer, as well as the printing quality. And when the image is included inside another document, the DPI is simply ignored. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218442 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form validation utilizing database field types/sizes/etc
No worries. I'm always around if you have questions about it. :) I just wasn't sure if you'd seen the last post -- I figured you might have missed it in your inbox if you're like me and have hundreds of messages and end up deleting a lot of them unread. Yeah, I read through it once already, but I'm not a big on java (just because I don't know it). But let me go read through it again. Mike S. Isaac Dealey wrote: Do you look at the db type and then query it accordingly? Actually not, this is the beauty of ODBC: it is (well almost) DB independant. The only things that are DB dependent are a couple of things (flaws) not supported by some ODBC drivers. This is what I was curious about. I am trying to pull the metadata out of the database but it seems that Oracle and SQL don't support the same methods for querying that metadata. For Oracle, it looks like I will be querying ALL_TAB_COLUMNS and for SQL Server it's a query to INFORMATION_SCHEMA. I guess I could make a config that sets the DB type and do my queries accordingly, but I was curious if anyone knew other ways to query the database systems to get the data out. Yep, that's why I use JDBC... Here's the article: http://coldfusion.sys-con.com/read/45569.htm s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218443 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF5 and Application scoped queries
Have you tried: cfquery name=q_getcountries .. ... /cfquery cfset application.q_getcountries = q_getcountries rick jonese wrote: We've got a scoped query called application.q_getcountries on a CF5 box. Today it started throwing the following error: Cannot process query Cannot register the query named application.q_getcountries with ColdFusion. There are two likely causes of this problem: - You are using a CFQUERY tag with a scoped query name. Query names cannot be scoped. For example, *MyProject.MyQuery* is an invalid query name. - The query was set as the default query for a tag like CFOUTPUT, CFLOOP, CFMAIL, etc. However, in the body of the tag this query was modified or removed. Default queries cannot be modified or removed inside the bodies of the tags that use them. If i rename it to application.q_getcountry it works just fine, and all other applicaiton scope variables in the file run a-ok. I've placed locks around thequery etc but still getting the error. The query is being run in the application.cfm file I found a post from Ray back in the day at http://lists.evolt.org/archive/Week-of-Mon-20001218/022071.html but there was no solution here. Any ideas? jonese ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218444 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF do this?
Kevin Aebig wrote: You're talking about a desktop printer and we're talking about using a Print House... companies that do professional printing. Yeah I should've known better than to use the word printer to refer to a print house. Oh well, we all make mistakes ;) Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218445 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfldap and multiple filters
Thanks to both Michael Dawson and Michael Tangorre. I ended up using the following and it worked great. filter = ((sn=#form.name#*)(|(ou=*vet*)(ou=VM*))) Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 14, 2005 8:14 AM To: CF-Talk Subject: RE: cfldap and multiple filters As MT said in another post, you can check that link. Basically, the filter would look something like: FILTER=(|(first=#form.name#)(last=#form.name#)) Place each attribute in parenthesis. Then, wrap all alternate attributes with another set of parenthesis. If your query is an OR, use a pipe | character. If your query is an AND use the ampersand. You can change you OR query to an AND query by changing a single character like this: FILTER=((first=#form.name#)(last=#form.name#)) The filters can get very confusing if there are many of them. M!ke -Original Message- From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 13, 2005 5:18 PM To: CF-Talk Subject: cfldap and multiple filters Is it possible to filter on multiple items in a ldap query using either AND or OR? eg cfldap ... filter=last=#form.name# OR first=#form.name ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218447 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SCM deployment options (was Re: Source Code Control Setup)
On 9/15/05, Barney Boisvert [EMAIL PROTECTED] wrote: That's a surprise -- though it of course depends on what you're doing. I don't have many CF projects that don't have at least *some* java in them (usually the credit card API) so using Ant seems pretty natural. Credit cards? Ick. That stuff sucks. ;) No unhappiness from me that I have touched CC processing in like 4 years. But anyway. We build the Java pieces separately. So Java piece X gets built into a JAR, and then that JAR is included in the CF apps as needed. Keeps the dependancies flowing downward, and isolates the CF apps from any changes to the Java apps until they're ready to deal with them. I'd actually like to hear a little more about how you do that -- if I had to rewrite the JAR for credit card processing for you, it sounds like I'd do that in a branch, approve it, and merge it back into the trunk. Then everyone just pulls down the JAR into their working directory? \yourapp\trunk\java \yourapp\trunk\cfcode or similar in the repository? I'm actually curious :) I do a lot with using filter expansion to properly configure differences between deployments (e.g. changing the fusebox mode parameter from development to production as appropriate on the specific server). We don't use FB4 either. And we maintain our different config stuff in-code, rather than in external ant properties files, so the app itself takes care of pulling the right config stuff out based on where it's at. Most of the reason is so that we can go right from staging to production with a minimum of steps. More steps == more room for error, especially if you're CHANGING THE CODE!!!. ;) If we did use FB4, we'd switch the mode the same way, in-code. cfset application.fusebox.mode = production / is just as effective as changing the XML file, as long as it happens while no request is actively executing the loader. I don't understand how that's fewer steps. If you're developing (in FB for this example) and you have cfset application.fusebox.mode = production / somewhere in your code, you have developers pull that down and change it to development while they're working. Someone inadvertently checks that back in with other changes and it rolls out... Or you have to add a step to verify the setting is correct. What am I missing? I tend to prefer abstracting deployment information (dev/stage/prod settings) into external files (source controlled of course) and relying on the deployment script (aka Ant) to handling everything. Of course then you have to add your deployment script to the testing process. It always comes down to deciding where to spend the time/resources :) I find it pretty interesting to see how folks really *do* their development! Wouldn't you have to start the testing process again after any change in the branch being tested? A change in the staging branch during integration testing *should* restart the unit tests for sure, functional if they are automated and reasonable in length. Yes, expected, and intentionally prevented from interfering. ;) By doing it this way, developer X can merge his private branch into stage, switch his working copy to the stage branch, and then make sure there aren't any issues now that he's back with everyone else. And he can do it during a testing period, without interfering with the test. You can make an argument that that's a stupid way to do it for sure, but having that central point of control sure makes my life easier. Not a stupid way to do it at all -- defintely not the argument I'm making :) I think the key thing you've done is come up with a process that works for your team that involves good practices (SCM, testing, etc). I tend to subscribe strongly to AGILE principles personally, but even there, there are a wide constellation of techniques and practices that are implemented in teams of various sizes and personalities. I'm thrilled we're (the CF community) at the point where more of the discussions are about how to implement the tools to improve process than why it's important to use source control. Amen to that. It's amazing the change that's happened in the past couple years. Not that that question never comes up, but there's so much more behind it now. Agreed. I mean, not only this -- but a *frameworks* conference instead of just Fusebox? And *choices* in the CF framework. Wow! Seems to me it coincides pretty strongly with your activity on this list increasing. :) :) :) cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
Re: Can CF do this?
we're talking about using a Print House... companies that do professional printing. Then a fortiori: what counts is the number of pixels, they will print it at the resolution they need, depending on the printer they have, no matter what's in the image. This was my point. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218448 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SCM deployment options (was Re: Source Code Control Setup)
Responses inline... On 9/15/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 9/15/05, Barney Boisvert [EMAIL PROTECTED] wrote: That's a surprise -- though it of course depends on what you're doing. I don't have many CF projects that don't have at least *some* java in them (usually the credit card API) so using Ant seems pretty natural. Credit cards? Ick. That stuff sucks. ;) No unhappiness from me that I have touched CC processing in like 4 years. But anyway. We build the Java pieces separately. So Java piece X gets built into a JAR, and then that JAR is included in the CF apps as needed. Keeps the dependancies flowing downward, and isolates the CF apps from any changes to the Java apps until they're ready to deal with them. I'd actually like to hear a little more about how you do that -- if I had to rewrite the JAR for credit card processing for you, it sounds like I'd do that in a branch, approve it, and merge it back into the trunk. Then everyone just pulls down the JAR into their working directory? \yourapp\trunk\java \yourapp\trunk\cfcode or similar in the repository? I'm actually curious :) The java is part of the main project, but the app installations don't use the code in the project, then use JARs that are stored in a designated directory. Some are externally created, some are from the in-project java source, but all are treated as the same. In other words, the runtime application has no idea that java exists other than JAR files it has in it's posession. When a JAR is updated (whether from an internal or external source, makes no difference), then every working directory needs to be updated and CF restarted to pull in the new classes. So the internal java pieces are really separate projects that the CF app depends on, rather than part of the same app. And yes, for developing and testing the dependancies, we have ant scripts that'll compile, package, and install a JAR file into the app. But that's part of development, not building the app. At build time, it's the repository that dicates what JARs we have, not the source code. I do a lot with using filter expansion to properly configure differences between deployments (e.g. changing the fusebox mode parameter from development to production as appropriate on the specific server). We don't use FB4 either. And we maintain our different config stuff in-code, rather than in external ant properties files, so the app itself takes care of pulling the right config stuff out based on where it's at. Most of the reason is so that we can go right from staging to production with a minimum of steps. More steps == more room for error, especially if you're CHANGING THE CODE!!!. ;) If we did use FB4, we'd switch the mode the same way, in-code. cfset application.fusebox.mode = production / is just as effective as changing the XML file, as long as it happens while no request is actively executing the loader. I don't understand how that's fewer steps. If you're developing (in FB for this example) and you have cfset application.fusebox.mode = production / somewhere in your code, you have developers pull that down and change it to development while they're working. Someone inadvertently checks that back in with other changes and it rolls out... Or you have to add a step to verify the setting is correct. What am I missing? You missed the we maintain our different config stuff in-code ... the app itself takes care of pulling the right config stuff out based on where it's at part. Probably wasn't too clear, but like how with ant you can specify a specific properties file to read based on where you generate the code from (dev.properties, production.properties, etc.), we do the same thing, but it's all in-code. So the app intelligently switches the config parameters it needs based on where it's installed, rather than having to ensure that the install location matches the build location. In particular, this lets us sync from staging to production, rather than having to use some (potentially troubling) build process, and then upload code into production that has NEVER BEEN TESTED. Theoretically, the only thing that will be different from the staging code is whatever properties, but it's still different code. By making config selection changes (rather than rewriting) I have a lot more confidence that the code is identical. Stupid distinction, and I've never had ant do anything untoward as part of it's filtering process, but you remove the potential problem spots wherever you can. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for
Re: CFC caching?
Hey George... Trust me, you ain't the only one. ;) A CFC is executable CF so when you create an instance in a shared scope, that instance is created with the codebase in existance at the time it was instantiated. When you update the text in the code base, that does not update the contents of the CFC that's in a shared scope. In order to do that you have to use code like below, or restart the server. I assume you have this CFC in the application or session scope, yes? Try this: cfif structKeyExtists(url,reinit) cfset session.myLogger = createObject(component,my.logger.path.to.the ).init() /cfif (be sure to add locking. and be sure to use the right scope left of the equal sign.) ;) Then go to your page and add ?reinit=1 to the URL. Voila... As far as which scope to use... don't feel restricted. There's no reason you couldn't call application.logger.logUserAction(), for one thing. For another, if you have a logger class that's portable, why not use it in the app AND session scopes -- if, that is, they're doing different things. Just be sure that the primary methods in your application scope are thread safe ( i.e. use locking where required and accept parameters, use the var keyword, draw constants from the logger's instance data but don't affect that instance data). In general, anyway. Laterz, J On 9/15/05, George Abraham [EMAIL PROTECTED] wrote: Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. Thanks, George -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218450 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfldap and multiple filters
w00t! The Michaels do it again! M!chael -Original Message- From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 1:22 PM To: CF-Talk Subject: RE: cfldap and multiple filters Thanks to both Michael Dawson and Michael Tangorre. I ended up using the following and it worked great. filter = ((sn=#form.name#*)(|(ou=*vet*)(ou=VM*))) Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218451 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF5 and Application scoped queries
Yep same error... jonese On 9/15/05, Rick Root [EMAIL PROTECTED] wrote: Have you tried: cfquery name=q_getcountries .. ... /cfquery cfset application.q_getcountries = q_getcountries rick jonese wrote: We've got a scoped query called application.q_getcountries on a CF5 box. Today it started throwing the following error: Cannot process query Cannot register the query named application.q_getcountries with ColdFusion. There are two likely causes of this problem: - You are using a CFQUERY tag with a scoped query name. Query names cannot be scoped. For example, *MyProject.MyQuery* is an invalid query name. - The query was set as the default query for a tag like CFOUTPUT, CFLOOP, CFMAIL, etc. However, in the body of the tag this query was modified or removed. Default queries cannot be modified or removed inside the bodies of the tags that use them. If i rename it to application.q_getcountry it works just fine, and all other applicaiton scope variables in the file run a-ok. I've placed locks around thequery etc but still getting the error. The query is being run in the application.cfm file I found a post from Ray back in the day at http://lists.evolt.org/archive/Week-of-Mon-20001218/022071.html but there was no solution here. Any ideas? jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218452 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Dealing with empty fields in lists
In the real world, the following list has 5 items: apple,,banana,,orange Of course, in Coldfusion, it only has 3. What are you all doing to work around this kind of thing? Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218453 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dealing with empty fields in lists
There is a UDF on cflib that handles this. On 9/15/05, Rick Root [EMAIL PROTECTED] wrote: In the real world, the following list has 5 items: apple,,banana,,orange Of course, in Coldfusion, it only has 3. What are you all doing to work around this kind of thing? Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218454 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF do this?
Claude Schneegans wrote: we're talking about using a Print House... companies that do professional printing. Then a fortiori: what counts is the number of pixels, they will print it at the resolution they need, depending on the printer they have, no matter what's in the image. This was my point. But it's not valid. The print house is not going to resize your document for the best quality of printing on their printing press. If you scan your 3x5 photo at 72 dpi for inclusion in a high gloss coffee table book, they're not going to shrink it to 0.75 by 1.25 so it'll print right, as you suggest. They'll call you up and say We need this to be at least 300 DPI And if you want your 3x5 photo to appear in this coffee table book at a print size of 6x10, they're gonna tell you to scan it in at 600 dpi, or 1200 dpi. Why? Because that's accepted terminology. They will NOT tell you to scan it in so it is at least 1800 pixels by 3000 pixels (the equivalent of 3x5 scanned in at 600 dpi) Wow, are we off topic or what? Rick Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218455 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dealing with empty fields in lists
cfset myList = apple,,banana,,orange / cfset myList = replace(myList, ',,', ', ,', 'all') replace consecutive commas with a comma-space-comma. suppose a regex would be better than the above tho so as to handle any number of consecutive commas. On 9/15/05, Aaron Rouse [EMAIL PROTECTED] wrote: There is a UDF on cflib that handles this. On 9/15/05, Rick Root [EMAIL PROTECTED] wrote: In the real world, the following list has 5 items: apple,,banana,,orange Of course, in Coldfusion, it only has 3. What are you all doing to work around this kind of thing? Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218456 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Configuration problem - CFMX7
As I said, I can access the CF Admin well enough, so the connector appears to be working. But when I go to any other .cfm file, The page cannot be displayed. Both file and IIS permissions appear to be correct. Any other thoughts from anyone? Is the CFIDE directory mapped in IIS as a virtual application or a virtual directory? In IIS, it will have a little gear icon if it's a virtual application, or a little yellow folder if it's a virtual directory. If it's a virtual application, compare the application settings to those of the web site itself and see what's different. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218457 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Your experience of Bluedragon.net?
This is good stuff guy's, thanks. If I understand correctly Bluedragon can be configured on a per site basis so my next question is has anyone had Bluedragon Coldfusion running on the same server or have I completely got the wrong end of the stick? Yes, you can have them installed aat the same time. You may wish to hook each to a separate IIS virtual server, or you can have BlueDragon.NET working with IIS and use the built-in JRun web server for CF. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218458 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Configuration problem - CFMX7
Dave, On 9/15/05, Dave Watts [EMAIL PROTECTED] wrote: Is the CFIDE directory mapped in IIS as a virtual application or a virtual directory? Just a plain old virtual directory, I'm afraid. I can find no differences in security, etc. in the properties, compared to other directories. I've even left anonymous access open to the CFAdmin for the moment, since this server is not public yet, in order to keep everything consistent till I can find the problem. Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SCM deployment options (was Re: Source Code Control Setup)
I don't understand how that's fewer steps. If you're developing (in FB for this example) and you have cfset application.fusebox.mode = production / somewhere in your code, you have developers pull that down and change it to development while they're working. Someone inadvertently checks that back in with other changes and it rolls out... Or you have to add a step to verify the setting is correct. What am I missing? You missed the we maintain our different config stuff in-code ... the app itself takes care of pulling the right config stuff out based on where it's at part. Probably wasn't too clear, but like how with ant you can specify a specific properties file to read based on where you generate the code from (dev.properties, production.properties, etc.), we do the same thing, but it's all in-code. So the app intelligently switches the config parameters it needs based on where it's installed, rather than having to ensure that the install location matches the build location. In particular, this lets us sync from staging to production, rather than having to use some (potentially troubling) build process, and then upload code into production that has NEVER BEEN TESTED. Theoretically, the only thing that will be different from the staging code is whatever properties, but it's still different code. By making config selection changes (rather than rewriting) I have a lot more confidence that the code is identical. Stupid distinction, and I've never had ant do anything untoward as part of it's filtering process, but you remove the potential problem spots wherever you can. Potato, potatoe :) You've checked that the code pulls the value from whereever it lives, but you're just trusting that you've got the right configuration where you deploy it since it's never run w/ those value. I agree, pretty minor distinction Testing can make people crazy -- if your code was something like (conceptually) if thisMachine(production) myDb=proddb else myDb=testdb and you test it on your dev machine, you'd have failed to cover one of the two possibilities from a code-coverage perspective. But if you move it to a single piece of code myDb=getDb(thisMachine) you've achieved testing coverage of that line of code. Now it's a configuration issue, not a code issue if something breaks. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
Makes sense! Thanks for all your recommendations, people! George On 9/15/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Hey George... Trust me, you ain't the only one. ;) A CFC is executable CF so when you create an instance in a shared scope, that instance is created with the codebase in existance at the time it was instantiated. When you update the text in the code base, that does not update the contents of the CFC that's in a shared scope. In order to do that you have to use code like below, or restart the server. I assume you have this CFC in the application or session scope, yes? Try this: cfif structKeyExtists(url,reinit) cfset session.myLogger = createObject(component,my.logger.path.to.the ).init() /cfif (be sure to add locking. and be sure to use the right scope left of the equal sign.) ;) Then go to your page and add ?reinit=1 to the URL. Voila... As far as which scope to use... don't feel restricted. There's no reason you couldn't call application.logger.logUserAction(), for one thing. For another, if you have a logger class that's portable, why not use it in the app AND session scopes -- if, that is, they're doing different things. Just be sure that the primary methods in your application scope are thread safe ( i.e. use locking where required and accept parameters, use the var keyword, draw constants from the logger's instance data but don't affect that instance data). In general, anyway. Laterz, J ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF do this?
If you scan your 3x5 photo at 72 dpi ... then you are in trouble, but note that in your example, 72 dpi is the resolution of the SCANNER, not the image. And if you want your 3x5 photo to appear in this coffee table book at a print size of 6x10, they're gonna tell you to scan it in at 600 dpi, or 1200 dpi. again, this is the scanner resolution. As far as the correct number of pixels are in the image, you can store in it the information you want about so called DPIs, it wont make any differenece, the print company will not even look at it. Why? Because an electronic image has no size in inches, then dots per inches is just non sense. And what if your original image was a numeric photo? Where are the inches? Again, the CAMERA has a resolution, an angular resolution in the occurrence, but the image it takes has none, even if the camera stores some weird DPIs in it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
(be sure to add locking. and be sure to use the right scope left of the equal sign.) ;) You mean like this? http://www.fusiontap.com/scope.jpg Or Wintergreen? s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
and this is a real PITA in a cluster, SW base or HW based. HW based is easier. But doing this on a JRun cluster bites. If not in a cluster, no big deal. DK On 9/15/05, Kevin Roche [EMAIL PROTECTED] wrote: George, I have a short piece of code at the start of my application that does two things. 1/ Checks for a url variable and if present sets all the cacheds CFCs to a space. 2/ Checks each cached CFC to see that it is defined and not a space. If so it reinitialises it and puts it in the application or server scope. Hope that helps. Kevin Roche -- Original Message -- From: George Abraham [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 15 Sep 2005 10:22:52 -0400 Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. Thanks, George On 9/15/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: What database? And how did you rename the procedure? I would say make sure you recreate the CFC object if it's stored in a shared scope (like say the application scope) but since the spelling was changed in the db and not in the CFC that shouldn't be relevant. Other than that, I'd say try restarting the CF server service. Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218464 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SCM deployment options (was Re: Source Code Control Setup)
nice discussion folks. danke. planning to use ANT here for sure. Getting my hands durty in it lately. We are going with tagging the trunk with each release, bug fix or major. major releases would get a branch, but get merged back to trunk before release as bug fixes get added to the main trunk eh? Mergin a branch can suck though. I have been reluctant to just check out and run updates to get the changes in a staging area so far, guess I can create a special staging suer in CVS for this, we have two folks managing the code. DK On 9/15/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: I don't understand how that's fewer steps. If you're developing (in FB for this example) and you have cfset application.fusebox.mode = production / somewhere in your code, you have developers pull that down and change it to development while they're working. Someone inadvertently checks that back in with other changes and it rolls out... Or you have to add a step to verify the setting is correct. What am I missing? You missed the we maintain our different config stuff in-code ... the app itself takes care of pulling the right config stuff out based on where it's at part. Probably wasn't too clear, but like how with ant you can specify a specific properties file to read based on where you generate the code from (dev.properties, production.properties, etc.), we do the same thing, but it's all in-code. So the app intelligently switches the config parameters it needs based on where it's installed, rather than having to ensure that the install location matches the build location. In particular, this lets us sync from staging to production, rather than having to use some (potentially troubling) build process, and then upload code into production that has NEVER BEEN TESTED. Theoretically, the only thing that will be different from the staging code is whatever properties, but it's still different code. By making config selection changes (rather than rewriting) I have a lot more confidence that the code is identical. Stupid distinction, and I've never had ant do anything untoward as part of it's filtering process, but you remove the potential problem spots wherever you can. Potato, potatoe :) You've checked that the code pulls the value from whereever it lives, but you're just trusting that you've got the right configuration where you deploy it since it's never run w/ those value. I agree, pretty minor distinction Testing can make people crazy -- if your code was something like (conceptually) if thisMachine(production) myDb=proddb else myDb=testdb and you test it on your dev machine, you'd have failed to cover one of the two possibilities from a code-coverage perspective. But if you move it to a single piece of code myDb=getDb(thisMachine) you've achieved testing coverage of that line of code. Now it's a configuration issue, not a code issue if something breaks. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218465 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can CF do this?
Can cf do this? shhh...relax. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 4:49 PM To: CF-Talk Subject: Re: Can CF do this? If you scan your 3x5 photo at 72 dpi then you are in trouble, but note that in your example, 72 dpi is the resolution of the SCANNER, not the image. And if you want your 3x5 photo to appear in this coffee table book at a print size of 6x10, they're gonna tell you to scan it in at 600 dpi, or 1200 dpi. . again, this is the scanner resolution. As far as the correct number of pixels are in the image, you can store in it the information you want about so called DPIs, it wont make any differenece, the print company will not even look at it. Why? Because an electronic image has no size in inches, then dots per inches is just non sense. And what if your original image was a numeric photo? Where are the inches? Again, the CAMERA has a resolution, an angular resolution in the occurrence, but the image it takes has none, even if the camera stores some weird DPIs in it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Subversion and $Id: $
I see among Subversion's features that SVN won't ever modify my files not even to expand the $Id: $ information. What if I want to see the version number in my files? Am I clinging to an outmoded CVS idea? Thanks. pm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218467 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your experience of Bluedragon.net?
You should also be able to set up a virtual directory in IIS like /BD/ and have it point to wwwroot (or where-ever) and set up cfm cfc pages to run off the BD server (or atleast thats how we're doing it with the free version of DB not sure if that works with .NET) Adam H On 9/15/05, Dave Watts [EMAIL PROTECTED] wrote: This is good stuff guy's, thanks. If I understand correctly Bluedragon can be configured on a per site basis so my next question is has anyone had Bluedragon Coldfusion running on the same server or have I completely got the wrong end of the stick? Yes, you can have them installed aat the same time. You may wish to hook each to a separate IIS virtual server, or you can have BlueDragon.NET working with IIS and use the built-in JRun web server for CF. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218468 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can CF do this?
Can cf do this? A CFX_tag can do it, yes. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Another radio button problem
Thanks Bobby, I actually got it working using a slightly different approach, but your idea is simpler (and I knew there was a simpler way to get this working) Here's what I did. Inside the display cfoutput, I added 2 hidden fields input type=hidden name=deletionID#qryNoticeboard.currentrow# value=#noticeboardID# / input name=deleteNoticeboard#qryNoticeboard.currentrow# type=checkbox value=Yes / Then after the cfoutput is closed but before the form ends, I set another hidden field input type=hidden name=boardCount value=cfoutput#qryNoticeboard.recordCount#/cfoutput / so that I could use this for the query loop And in the query cfloop index=i from=1 to=#boardCount# cfif isDefined(form.deleteNoticeboardi) cfquery datasource = #request.dsn# name = qryDeleteNoticeboardItem UPDATE noticeBoard SET active = No WHERE noticeboardID = #form['deletionID'i]# /cfquery /cfif /cfloop This works but obviously overcomplicates the procedure. The advice is appreciated and I will implement now.. Mark -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 September 2005 11:53 p.m. To: CF-Talk Subject: RE: Another radio button problem You have an ID field for every single record. So yes, it's hitting them all in your action query when you loop over that field. Give your delete_noticeboard field a value of the NoticeBoardID inside your loop. On your form, change input name=delete_noticeboard type=checkbox value=Yes To input name=delete_noticeboard type=checkbox value=#NoticeBoardID# At the top of your update query page, add this to ensure no error is thrown when no boxes were checked cfparam name=form.delete_noticeboard default= And in your loop, change list=#form.ID# to list=#form.delete_noticeboard# When you submit the form now, the #Form.delete_noticeboard# will hold a comma delimited list of all of the selected check box values. (A comma delimited list of all the NoticeIDs you want to delete) Good luck. ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218470 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CSS and Firefox
Inconsistencies between browsers (IE, Firefox, etc.) does present minor
issues on occasion, not just in basic terms (like slight differences to
the DOM style references), but also in broader issues (like how each
browser is affected by the use of a particular DTD). When IE7 is finally
released hopefully some of this will be relieved (if they can convince
everyone to upgrade [yeah, right...]).
All of that being said though, it's worth the tradeoff. I've been slowly
implementing styles in my work for the last few years. I've even totally
rewritten 3rd party code to make it HTML 4/XHTML compliant with styles
(and later stylesheets) so that they were easier to change/maintain.
It's nice to change one line of CSS to change the appearance of an item
across an entire site (like changing the font-type, or the font-size, or
the background color). Sure, sometimes there are issues (especially with
the box model), but generally a little time of tweaking/testing will
work it out, with an occasional trip to Google or the W3CSchool.
I generally start with a layout that works with Firefox (my browser of
choice) and then look at it within IE to see what needs to be
changed/adjusted. I pre-plan my layout prior to coding, which helps me
develop with an eye for encapsulating pods of content and pre-defining
default and block level styles. Since the view layer is usually the last
area of code I work on it typically doesn't take much of my time. Since
code/dev is only about 10% of my current work week then that is time
well spent (I can't wait to get back to core dev. Now, where was that
resume?...)
Minor things will drive you nuts, but typically only you will notice.
It's worth the initial effort.
Cutter
Rick Faircloth wrote:
Thanks for the reply, Cutter...
It does seem an elegant and efficient way to design,
but I've been following discussions on the css-discuss
mailing list, and they sure spend a lot of time figuring out
design issues.
I'm just wondering if I'll be spending too much time trying
to make CSS design behave and not enough time coding CF.
I guess there's probably a common set of functional design
patterns that work well with all (mostly all) browsers and I
could learn what to stay away from...
What's been the key for making CSS work well for you
in dealing with incompatabilities between browsers? Or does
it just seem that there are a lot of issues because the problems
are usually the only hot topics that are discussed on lists...
Rick
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 14, 2005 3:33 PM
To: CF-Talk
Subject: Re: CSS and Firefox
Rick,
Yes, I'm using CSS for all of my design (only using tables for tabular
data). Irie Radio is my first foray into Mach II, and every page
contains some dynamic data (much more to come). I've really had to
rethink some things structurally to leverage CF with a total CSS layout,
but in the end run I'm finding it to be much more flexible from a design
standpoint, especially as I modularize my code. Much easier to change
and maintain.
Cutter
Rick Faircloth wrote:
Hi, Cutter...
Are you using CSS as your primary design approach or tables?
I say primary, because I'm sure you use both, but what do you
use to do your basic page layout?
And if you use CSS, how has it worked with dynamic pages and CF?
Rick
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 14, 2005 9:08 AM
To: CF-Talk
Subject: Re: CSS and Firefox
! Thanks Damien. I had tried adjusting the internal content
block sizes and forgot about my primaryContent container.
The WebDeveloper Toolbar extension for Firefox is great for this as
well. It's got an option in the Outline menu to Outline Block Level
Elements, so I don't have to adjust my stylesheet to see all of these
elements. Overall it's not perfect, but it has been a great tool.
Thanks again Damien (and all those others who posted). Dropping that
width just 5px (460px) was all it needed.
Cutter
Damien McKenna wrote:
Its simply a case of your content being too wide. I made the following
change and it worked fine:
#primaryContent {
width:455px;
}
I suggest adding the following to your main DIVs to see where everything
is *really* positioning:
border: 1px dashed red;
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218471
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS and Firefox
Thanks for the feedback, Cutter...
Rick
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 9:30 PM
To: CF-Talk
Subject: Re: CSS and Firefox
Inconsistencies between browsers (IE, Firefox, etc.) does present minor
issues on occasion, not just in basic terms (like slight differences to
the DOM style references), but also in broader issues (like how each
browser is affected by the use of a particular DTD). When IE7 is finally
released hopefully some of this will be relieved (if they can convince
everyone to upgrade [yeah, right...]).
All of that being said though, it's worth the tradeoff. I've been slowly
implementing styles in my work for the last few years. I've even totally
rewritten 3rd party code to make it HTML 4/XHTML compliant with styles
(and later stylesheets) so that they were easier to change/maintain.
It's nice to change one line of CSS to change the appearance of an item
across an entire site (like changing the font-type, or the font-size, or
the background color). Sure, sometimes there are issues (especially with
the box model), but generally a little time of tweaking/testing will
work it out, with an occasional trip to Google or the W3CSchool.
I generally start with a layout that works with Firefox (my browser of
choice) and then look at it within IE to see what needs to be
changed/adjusted. I pre-plan my layout prior to coding, which helps me
develop with an eye for encapsulating pods of content and pre-defining
default and block level styles. Since the view layer is usually the last
area of code I work on it typically doesn't take much of my time. Since
code/dev is only about 10% of my current work week then that is time
well spent (I can't wait to get back to core dev. Now, where was that
resume?...)
Minor things will drive you nuts, but typically only you will notice.
It's worth the initial effort.
Cutter
Rick Faircloth wrote:
Thanks for the reply, Cutter...
It does seem an elegant and efficient way to design,
but I've been following discussions on the css-discuss
mailing list, and they sure spend a lot of time figuring out
design issues.
I'm just wondering if I'll be spending too much time trying
to make CSS design behave and not enough time coding CF.
I guess there's probably a common set of functional design
patterns that work well with all (mostly all) browsers and I
could learn what to stay away from...
What's been the key for making CSS work well for you
in dealing with incompatabilities between browsers? Or does
it just seem that there are a lot of issues because the problems
are usually the only hot topics that are discussed on lists...
Rick
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 14, 2005 3:33 PM
To: CF-Talk
Subject: Re: CSS and Firefox
Rick,
Yes, I'm using CSS for all of my design (only using tables for tabular
data). Irie Radio is my first foray into Mach II, and every page
contains some dynamic data (much more to come). I've really had to
rethink some things structurally to leverage CF with a total CSS layout,
but in the end run I'm finding it to be much more flexible from a design
standpoint, especially as I modularize my code. Much easier to change
and maintain.
Cutter
Rick Faircloth wrote:
Hi, Cutter...
Are you using CSS as your primary design approach or tables?
I say primary, because I'm sure you use both, but what do you
use to do your basic page layout?
And if you use CSS, how has it worked with dynamic pages and CF?
Rick
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 14, 2005 9:08 AM
To: CF-Talk
Subject: Re: CSS and Firefox
! Thanks Damien. I had tried adjusting the internal content
block sizes and forgot about my primaryContent container.
The WebDeveloper Toolbar extension for Firefox is great for this as
well. It's got an option in the Outline menu to Outline Block Level
Elements, so I don't have to adjust my stylesheet to see all of these
elements. Overall it's not perfect, but it has been a great tool.
Thanks again Damien (and all those others who posted). Dropping that
width just 5px (460px) was all it needed.
Cutter
Damien McKenna wrote:
Its simply a case of your content being too wide. I made the following
change and it worked fine:
#primaryContent {
width:455px;
}
I suggest adding the following to your main DIVs to see where everything
is *really* positioning:
border: 1px dashed red;
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218472
Archives:
Your refill for Vitrx
Hi, your Vitrx natural enhancement product is ready for ordering, as our records indicate that you are due for a refill. Simply press here to order http:///checkout.php?product_id=65c=1207 Please let us know if you have any questions. We are available 24x7. Dan Williams, customer support. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your refill for Vitrx
wow. spam made it through? tony On 9/15/05, Gennie Fridman [EMAIL PROTECTED] wrote: Hi, your Vitrx natural enhancement product is ready for ordering, as our records indicate that you are due for a refill. Simply press here to order http:///checkout.php?product_id=65c=1207 Please let us know if you have any questions. We are available 24x7. Dan Williams, customer support. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218474 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your refill for Vitrx
Gennie has a problem with his wang, so he needs to share his solution with the rest of the world :) - Original Message - From: Tony [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 15, 2005 10:44 PM Subject: Re: Your refill for Vitrx wow. spam made it through? tony On 9/15/05, Gennie Fridman [EMAIL PROTECTED] wrote: Hi, your Vitrx natural enhancement product is ready for ordering, as our records indicate that you are due for a refill. Simply press here to order http:///checkout.php?product_id=65c=1207 Please let us know if you have any questions. We are available 24x7. Dan Williams, customer support. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Your refill for Vitrx
Damn! How'd my order end up here... Kevin - Original Message - From: Gennie Fridman [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 15, 2005 9:13 PM Subject: Your refill for Vitrx Hi, your Vitrx natural enhancement product is ready for ordering, as our records indicate that you are due for a refill. Simply press here to order http:///checkout.php?product_id=65c=1207 Please let us know if you have any questions. We are available 24x7. Dan Williams, customer support. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
