Re: OT: Javascript ?
Deanna -
Just use an onclick or use an [a href=javascript: unCheckAll()] [img][/a]
to handle that.
Mike Wokasch
UW-Extension
At 12:47 PM 10/23/2002 -0500, you wrote:
Hi Folks,
With the following code, I can check or uncheck all the checkboxes on a page
IF I use an input type of button. If I use an input type of image, the page
submits. What gives? (Two different style of looping because of messing
around with it only.)
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
These submit the form:
input type=image src=images/check.gif onClick=checkAll(); alt=Check
All input type=image src=images/uncheck.gif onClick=unCheckAll();
alt=UnCheck All
These don't
input type=button value=Check All onClick=checkAll(); input
type=button value=UnCheck All onClick=unCheckAll();
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: OT: Javascript ?
Thanks everyone for your replies. I obviously had a momentary lapse of sanity there. *sigh* -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFMX and JRE 1.4.1 - Problems
For those of you using the locale functions in CFMX beware of significant
issues when using SUN JRE 1.4.1
From our testing of CFMX on JRE 1.4.1 we found that all of the following
functions returned unexpected results.
LSIsDate()
- Set Locale to English (UK)
- Pass LSIsDate() value of 13/12/02 which is Dec. 13 2002 a valid date.
- Returns error of 13/12/02 is an invalid date format.
LSDateFormat()
- Set Locale to English (UK)
- Pass LSIsDate() value of 13/12/02 which is Dec. 13 2002 a valid date.
- Returns error of 13/12/02 is an invalid date format.
LSParseDateTime()
- Set Locale to English (UK)
- Pass LSIsDate() value of 13/12/02 which is Dec. 13 2002 a valid date.
- Returns error of 13/12/02 is an invalid date format.
Note: Appears almost as though the setlocale() even though when you run
function getlocale() it returns the correct label. If you do enter in the
English (US) formatted date as 12/13/02 the functions work but the
LSDate functions do not show any of the localiezed values. ie. Deciembre
instead of December if Spanish etc.
LSCurrencyFormat(n,none)
- Set Locale to English (UK)
- Pass LSCurrencyFormat() value of 123456.78
- Returns 123,456.78 (proper except that in locales with different
separators the separators do not change)
LSCurrencyFormat(n,local)
- Set Locale to English (UK)
- Pass LSCurrencyFormat() value of 123456.78
- Returns GBP123,456.78 (Localized currency specifier does not work)
Note: Should return local currency specifier but does not.
LSCurrencyFormat(n,international)
- Set Locale to English (UK)
- Pass LSCurrencyFormat() value of 123456.78
- Returns GBP123,456.78 (proper for some locales but shows EURO for many
locales that used to be specific to that locale).
Note: For all currencies the thousands separator and other separators do not
change regardless of the locale that has been set.
We have downgraded to JRE 1.4.0_02 as this seems to have fixed the problems
mentioned above. However, I point all this out as many on this list have
suggested that moving to JRE 1.4.1 has fixed your JDBC problems. This may
not be a good solution if you are using LS functions. If someone at
Macromedia would like to see this error in action please contact me offline
and we can make it available. What is the recommended JRE for CFMX?CFMX
ships with 1.3.0_03 but in the documentation Migrating ColdFusion 5
Applications page 9 it states the following for the CFHTTP tag. The
timeout attribute requires the Java Development Kit (JDK) 1.4; otherwise,
ColdFusion MX ignores this attribute. Is JRE 1.4 the reccomended JRE?
Secondly, through this testing we have also noticed a difference in the way
CF 5.0 processes localized dates and the way that CFMX processes localized
dates. To be honest I think the way that CFMX processes the locale makes
more sense than previously, but it is still a difference you should be aware
of.
In CF 5 locale set to English (UK):
#LsDateFormat('12/13/02', ' dd ')# - Cold Fusion returns no errors
and formats the date as December 13 2002
In CFMX locale set to English (UK):
#LsDateFormat('12/13/02', ' dd ')# - Cold Fusion returns an error
of 12/13/02 is an invalid date format.
If you add the LSParseDateTime() to the equation in MX:
#LsDateFormat(LSParseDateTime('12/13/02'), ' dd ')# - Cold Fusion
returns no errors and formats the date as December 13 2002
Enjoy! We have :(
Mark Johnson
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: Javascript ?
Make them regular images.
Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]
WARNING:
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above. If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited.
If you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.
AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee. Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.
-Original Message-
From: Deanna Schneider [mailto:deanna.schneider;ces.uwex.edu]
Sent: 23 October 2002 18:47
To: CF-Talk
Subject: OT: Javascript ?
Hi Folks,
With the following code, I can check or uncheck all the checkboxes on a page
IF I use an input type of button. If I use an input type of image, the page
submits. What gives? (Two different style of looping because of messing
around with it only.)
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
These submit the form:
input type=image src=images/check.gif onClick=checkAll(); alt=Check
All input type=image src=images/uncheck.gif onClick=unCheckAll();
alt=UnCheck All
These don't
input type=button value=Check All onClick=checkAll(); input
type=button value=UnCheck All onClick=unCheckAll();
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: UDF and Null Errors?
Take off eh! Are you Canadian? ;) The code is pretty simple, here it is: (FYI, this code tackles the SoEditor problem I mentioned a few posts back...) Also, interestingly enough, if I take out the entire body of the UDF, I get the same error... cfif IsSoEditorEmpty(attributes.htmlbody) cfset attributes.htmlbody= /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFMX and FreeBSD
Costas Mac OS X is essentially Free BSD, so the os port should work for that as well. The port was from CFMX Linux (Others have used Solaris or Unix to port from). The steps to OS X are itemized at: http://www.oreillynet.com/pub/a/javascript/2002/08/08/ coldfusion_three.html This assumes the lowest-common-denominator: availability of only emulated Linux and no special network ability, so it uses a rather cumbersome drop box procedure to exchange files between Linux and Mac OS X. IF you have access to a network and/or a CFMX supported Linux/Unix platform, the port should be much easier. HTH Dick On Wednesday, October 23, 2002, at 09:05 AM, Costas Piliotis wrote: Has anyone successfully gotten CFMX working on FreeBSD by chance? I haven't really taken a stab at it quite yet, but I'd love to be able to put it on FreeBSD... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
SOT: Dreamweaver and Opening Access Files?
DWMX recognizes that a file is an Access database.. But will not use Access to open the file. Just keeps popping up saying that it can't find an editor for this type of file. I read the info on changing the Extensions.txt file. But that won't allow for pointing a particular file to another app within DWMX Any clues? TTAIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFMX and FreeBSD
| Mac OS X is essentially Free BSD, Huh? MAC OS X is a *nix OS with some sort of GUI top-end? That's quite interesting. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Dreamweaver and Opening Access Files?
preferences file types/editors click + above extensions type .mdb click + above editors browse to access Matthew Walker http://www.matthewwalker.net.nz/ -Original Message- From: Lee Fuller [mailto:leelistnew;primedna.net] Sent: Thursday, 24 October 2002 10:07 a.m. To: CF-Talk Subject: SOT: Dreamweaver and Opening Access Files? DWMX recognizes that a file is an Access database.. But will not use Access to open the file. Just keeps popping up saying that it can't find an editor for this type of file. I read the info on changing the Extensions.txt file. But that won't allow for pointing a particular file to another app within DWMX Any clues? TTAIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: UDF and Null Errors?
Sometimes my code does not post, here is the actual function: cffunction name=IsSoEditorEmpty hint=Checks the SoEditor Field for User Inserted Content cfargument name=str required=true hint=The String to Check cfif ReFindNoCase([^]*,str,1) !--- check for image tags. NOTE: add any other tags to check for here --- cfif ReFindNoCase(img,str,1) cfreturn FALSE cfelse cfset TempStr=ReReplaceNoCase(str, [^]*|nbsp;, , ALL) cfif not len(trim(TempStr)) cfreturn TRUE /cfif /cfif /cfif /cffunction At 01:58 PM 23/10/02 -0700, you wrote: Take off eh! Are you Canadian? ;) The code is pretty simple, here it is: (FYI, this code tackles the SoEditor problem I mentioned a few posts back...) Also, interestingly enough, if I take out the entire body of the UDF, I get the same error... cfif IsSoEditorEmpty(attributes.htmlbody) cfset attributes.htmlbody= /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
cfobject
Can multiple connects to the same object within a single template cause any problems? I use try/catch to determine if the object is already created, then connect as needed, but in a particular template I may be connecting more than once to the same object depending on a few variables. Should I test for this and only connect a single time or is multiple connects within a single template ok? Im trying to isolate a problem that I believe is related to this COM process... Thanks,Adrian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX and FreeBSD
Yup. That's why I bought a Powerbook :) Five weeks of use and zero crashes. On 10/23/02 2:07 PM, Lee Fuller [EMAIL PROTECTED] wrote: | Mac OS X is essentially Free BSD, Huh? MAC OS X is a *nix OS with some sort of GUI top-end? That's quite interesting. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Dreamweaver and Opening Access Files?
Bingo! Thanks Matthew. | -Original Message- | From: Matthew Walker [mailto:Matthew;cabbagetree.co.nz] | Sent: Wednesday, October 23, 2002 2:11 PM | To: CF-Talk | Subject: RE: Dreamweaver and Opening Access Files? | | | preferences file types/editors | click + above extensions | type .mdb | click + above editors | browse to access | | Matthew Walker | http://www.matthewwalker.net.nz/ | | | | -Original Message- | From: Lee Fuller [mailto:leelistnew;primedna.net] | Sent: Thursday, 24 October 2002 10:07 a.m. | To: CF-Talk | Subject: SOT: Dreamweaver and Opening Access Files? | | | DWMX recognizes that a file is an Access database.. But | will not use | Access to open the file. Just keeps popping up saying that | it can't | find an editor for this type of file. | | I read the info on changing the Extensions.txt file. But | that won't | allow for pointing a particular file to another app within DWMX | | Any clues? | | TTAIA | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFMX and FreeBSD
No WONDER MAC has all this money to spend on advertising! :) | -Original Message- | From: Ian Lurie [mailto:ian;portentinteractive.com] | Sent: Wednesday, October 23, 2002 2:16 PM | To: CF-Talk | Subject: Re: CFMX and FreeBSD | | | Yup. That's why I bought a Powerbook :) | | Five weeks of use and zero crashes. | | | | On 10/23/02 2:07 PM, Lee Fuller [EMAIL PROTECTED] wrote: | | | Mac OS X is essentially Free BSD, | | Huh? MAC OS X is a *nix OS with some sort of GUI top-end? | | That's quite interesting. | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CF_DHTMLMenu
I trying to use the CF_DHTMLMenu created by Ben Forta. The menu works fine but the rest of the page goes berserk. Only some of content loads. No errors. For the life of me I can not seem to fiqure this out. Prof. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: UDF and Null Errors?
Your code doesn't always return a value. If you fail the first cfif, you don't return anything. You also fail to return anything in this block: cfelse cfset TempStr=ReReplaceNoCase(str, [^]*|nbsp;, , ALL) cfif not len(trim(TempStr)) cfreturn TRUE /cfif Notice this cfif - what if it is false? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Wednesday, October 23, 2002 5:15 PM To: CF-Talk Subject: RE: UDF and Null Errors? Sometimes my code does not post, here is the actual function: cffunction name=IsSoEditorEmpty hint=Checks the SoEditor Field for User Inserted Content cfargument name=str required=true hint=The String to Check cfif ReFindNoCase([^]*,str,1) !--- check for image tags. NOTE: add any other tags to check for here --- cfif ReFindNoCase(img,str,1) cfreturn FALSE cfelse cfset TempStr=ReReplaceNoCase(str, [^]*|nbsp;, , ALL) cfif not len(trim(TempStr)) cfreturn TRUE /cfif /cfif /cfif /cffunction At 01:58 PM 23/10/02 -0700, you wrote: Take off eh! Are you Canadian? ;) The code is pretty simple, here it is: (FYI, this code tackles the SoEditor problem I mentioned a few posts back...) Also, interestingly enough, if I take out the entire body of the UDF, I get the same error... cfif IsSoEditorEmpty(attributes.htmlbody) cfset attributes.htmlbody= /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
HELP! CFStudio customization
I am trying to edit the color coding in Studio 4.5 and am having a problem. Specifically, I want the background to be black instead of white. That is no problem. However, I use studio for editing both .cfm and .java files. The problem is that in the elements for .java files the curly braces, semi-colons, etc. are not included in any element for that scheme. So they default to black which renders them invisible. The html scheme has something an element called punctuation which deals with these characters. And of course, I can't use the html scheme since it does not contain the java elements. Anyone know how to add elements to a color scheme? Any help would be greatly appreciated. --Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Remote SQl Server
Is it practical to run a webserver on one side of town/country and connect to a remote SQL Server on the other side of town? We have a box that sends out mail and handles open rate tracking / bounce processing / unsubscribes etc. We need to host this mail/web server in a remote location (300 km away). Ideally, this box would be able to speak with an SQL server at our location here. Is this practical? What kind of network issues should I be concerned about? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX and JRE 1.4.1 - Problems
For those of you using the locale functions in CFMX beware of significant issues when using SUN JRE 1.4.1 i haven't used ls functions in a dogs age (well since mx was released). you get more bang for your buck with the underlying java or ibm's locale functions with very little effort. there is at least one locale bug, brazilian currency formatting, thats crept up. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2545 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: UDF and Null Errors?
Doh - thanks Raymond, my mistake. So thats what happens when nothing gets returned At 05:21 PM 23/10/02 -0400, you wrote: Your code doesn't always return a value. If you fail the first cfif, you don't return anything. You also fail to return anything in this block: cfelse cfset TempStr=ReReplaceNoCase(str, [^]*|nbsp;, , ALL) cfif not len(trim(TempStr)) cfreturn TRUE /cfif Notice this cfif - what if it is false? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Wednesday, October 23, 2002 5:15 PM To: CF-Talk Subject: RE: UDF and Null Errors? Sometimes my code does not post, here is the actual function: cffunction name=IsSoEditorEmpty hint=Checks the SoEditor Field for User Inserted Content cfargument name=str required=true hint=The String to Check cfif ReFindNoCase([^]*,str,1) !--- check for image tags. NOTE: add any other tags to check for here --- cfif ReFindNoCase(img,str,1) cfreturn FALSE cfelse cfset TempStr=ReReplaceNoCase(str, [^]*|nbsp;, , ALL) cfif not len(trim(TempStr)) cfreturn TRUE /cfif /cfif /cfif /cffunction At 01:58 PM 23/10/02 -0700, you wrote: Take off eh! Are you Canadian? ;) The code is pretty simple, here it is: (FYI, this code tackles the SoEditor problem I mentioned a few posts back...) Also, interestingly enough, if I take out the entire body of the UDF, I get the same error... cfif IsSoEditorEmpty(attributes.htmlbody) cfset attributes.htmlbody= /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CFMX and FreeBSD
Yes! And you can use the GUI or CLI or both here's an interesting article: http://www.macdevcenter.com/pub/a/mac/2002/10/03/keynotes.html Dick On Wednesday, October 23, 2002, at 02:07 PM, Lee Fuller wrote: | Mac OS X is essentially Free BSD, Huh? MAC OS X is a *nix OS with some sort of GUI top-end? That's quite interesting. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX and FreeBSD
.. and developing insanely great products! On Wednesday, October 23, 2002, at 02:18 PM, Lee Fuller wrote: No WONDER MAC has all this money to spend on advertising! :) | -Original Message- | From: Ian Lurie [mailto:ian;portentinteractive.com] | Sent: Wednesday, October 23, 2002 2:16 PM | To: CF-Talk | Subject: Re: CFMX and FreeBSD | | | Yup. That's why I bought a Powerbook :) | | Five weeks of use and zero crashes. | | | | On 10/23/02 2:07 PM, Lee Fuller [EMAIL PROTECTED] wrote: | | | Mac OS X is essentially Free BSD, | | Huh? MAC OS X is a *nix OS with some sort of GUI top-end? | | That's quite interesting. | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: MM - the story
Hi All, Does anyone know if there is a tutorial or an article on the making of this fantastic piece of Flash. Thanks Mario -Original Message- From: Lee Fuller [mailto:leelistnew;primedna.net] Sent: Saturday, October 19, 2002 1:25 PM To: CF-Talk Subject: RE: OT: MM - the story Yeah.. I'd like to know about the opening text effects.. Where'd they come from? | -Original Message- | From: Sean A Corfield [mailto:sean;corfield.org] | Sent: Saturday, October 19, 2002 9:59 AM | To: CF-Talk | Subject: Re: OT: MM - the story | | | On Saturday, Oct 19, 2002, at 05:16 US/Pacific, cf-talk wrote: | Hi list, anybody who knows how they did: | http://www.macromedia.com/macromedia/story/ | | Well, it's 'just' a Flash movie. What would you like to know about it? | | We may have used FlashCom for the video, I'm not sure. I can | certainly | find out. | | I can smell your brains! | -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT: MM - the story
here you go: http://www.macromedia.com/desdev/mx/flashcom/articles/odopod.html mike chambers [EMAIL PROTECTED] -Original Message- From: Ciliotta, Mario [mailto:mario.ciliotta;csfb.com] Sent: Wednesday, October 23, 2002 5:50 PM To: CF-Talk Subject: RE: OT: MM - the story Importance: High Hi All, Does anyone know if there is a tutorial or an article on the making of this fantastic piece of Flash. Thanks Mario ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX and FreeBSD
Just hoping for the nice aqua interface on x86 platforms... Just a matter of time now... Thanks Dick by the way for your help... I'll let you know if it actually works out... -Original Message- From: Dick Applebaum [mailto:dicklacara;mac.com] Sent: Wednesday, October 23, 2002 2:49 PM To: CF-Talk Subject: Re: CFMX and FreeBSD . and developing insanely great products! On Wednesday, October 23, 2002, at 02:18 PM, Lee Fuller wrote: No WONDER MAC has all this money to spend on advertising! :) | -Original Message- | From: Ian Lurie [mailto:ian;portentinteractive.com] | Sent: Wednesday, October 23, 2002 2:16 PM | To: CF-Talk | Subject: Re: CFMX and FreeBSD | | | Yup. That's why I bought a Powerbook :) | | Five weeks of use and zero crashes. | | | | On 10/23/02 2:07 PM, Lee Fuller [EMAIL PROTECTED] wrote: | | | Mac OS X is essentially Free BSD, | | Huh? MAC OS X is a *nix OS with some sort of GUI top-end? | | That's quite interesting. | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Remote SQl Server
Yes, consider using an IPSec vpn connection. Something that supports L2TP. Do not use a PPTP vpn connection to connect sql servers. Make sure you have a fast connection though. What kind of speaking do they have to do? -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Wednesday, October 23, 2002 2:29 PM To: CF-Talk Subject: Remote SQl Server Is it practical to run a webserver on one side of town/country and connect to a remote SQL Server on the other side of town? We have a box that sends out mail and handles open rate tracking / bounce processing / unsubscribes etc. We need to host this mail/web server in a remote location (300 km away). Ideally, this box would be able to speak with an SQL server at our location here. Is this practical? What kind of network issues should I be concerned about? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
sorta Strange CFGRAPH thing
We've got a site we are getting ready to deploy. If you go to interrev1.fares (our internet dev site/the new app) the graph works. If you go to faresrev (a virtual folder to the above folder) graph no worky. Anyone seen or heard of anything likes this? Something I am over looking? THanks J. John WilkerBR Web Applications Consultant/WriterBR Macromedia Certified ColdFusion DeveloperBR A HREF=http://www.red-omega.com;www.red-omega.com/A ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: sorta Strange CFGRAPH thing
If you go to interrev1.fares (our internet dev site/the new app) the graph works. If you go to faresrev (a virtual folder to the above folder) graph no worky. Anyone seen or heard of anything likes this? Something I am over looking? Within each directory, the URL /CFIDE/GraphData.cfm... has to work, so you may have a mapping issue. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Oracle Error no descriptor for this position
Translate()? I don't even know what that does. ;p I'm pretty sure it's not in use in this application. I've been trying to trudge through my memory about this one, since I used to get it and don't anymore. I think it was this issue: There was one app where I was using translate() in a query. I updated all the data to do what the translate was doing, and haven't had a problem since. You wouldn't happen to be using that function, would you? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Java?
I just came across this site today: http://www.joegrip.com/ Uses flash movies to teach you Java. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Chris Alvarado [mailto:chris.alvarado;4guys.com] Sent: Wednesday, October 23, 2002 10:40 AM To: CF-Talk Subject: SOT:Java? Hello all, Sorry for the somewhat off topic post, but as I have noticed many people on this list have gotten into J2EE (Java) stuff. Does anyone have any good book reccomendations to get me started down that path? I have some basic OOP experience, but none with Java, so any help would be awesome. Also, any preferred Development Environments / Editors? Thanks all for any help you might provide, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com We create websites that make you a hero. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Remote SQl Server
Is the IPSec vpn a part of Win2k? No additional costs? Mostly just simple, small writes and some reads. No queries that return anything more than one record and no writes that insert more the one record. Its basically just for incrementing counters for bounces and unsubscribes and the like... Brook At 03:20 PM 23/10/02 -0700, you wrote: Yes, consider using an IPSec vpn connection. Something that supports L2TP. Do not use a PPTP vpn connection to connect sql servers. Make sure you have a fast connection though. What kind of speaking do they have to do? -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Wednesday, October 23, 2002 2:29 PM To: CF-Talk Subject: Remote SQl Server Is it practical to run a webserver on one side of town/country and connect to a remote SQL Server on the other side of town? We have a box that sends out mail and handles open rate tracking / bounce processing / unsubscribes etc. We need to host this mail/web server in a remote location (300 km away). Ideally, this box would be able to speak with an SQL server at our location here. Is this practical? What kind of network issues should I be concerned about? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Remote SQl Server
Can't do an L2TP vpn connection with standard win2k stuff... You can set up a PPTP vpn connection easily enough. For a L2TP connection, you'd need to use Symantec Firewall or an appliance like Cisco's or something... PPTP is kinda insecure... Depends how bad someone wants to break in... You can always restrict IP access to your PPTP host... -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Wednesday, October 23, 2002 3:47 PM To: CF-Talk Subject: RE: Remote SQl Server Is the IPSec vpn a part of Win2k? No additional costs? Mostly just simple, small writes and some reads. No queries that return anything more than one record and no writes that insert more the one record. Its basically just for incrementing counters for bounces and unsubscribes and the like... Brook At 03:20 PM 23/10/02 -0700, you wrote: Yes, consider using an IPSec vpn connection. Something that supports L2TP. Do not use a PPTP vpn connection to connect sql servers. Make sure you have a fast connection though. What kind of speaking do they have to do? -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Wednesday, October 23, 2002 2:29 PM To: CF-Talk Subject: Remote SQl Server Is it practical to run a webserver on one side of town/country and connect to a remote SQL Server on the other side of town? We have a box that sends out mail and handles open rate tracking / bounce processing / unsubscribes etc. We need to host this mail/web server in a remote location (300 km away). Ideally, this box would be able to speak with an SQL server at our location here. Is this practical? What kind of network issues should I be concerned about? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: M$Access DB and ColdFusionMX for Solaris
Troy You probably can't do exactly what you want -- run MS-Access native on a non-windows platform, but you can get close enough. As far as I have been able to determine, the Jet engine (MS-Access RDBMS) is implemented within the microsoft ODBC driver -- the driver is the database. Because of this, there are no implementations except on windows platforms. But, if you can interface a windows box on a network, or run emulated windows on Solaris (VMWare?), you can set up CFMX to interface the MS-Access system (ODBC driver) through TCP/IP. Now, MS-Access doesn't provide TCP/IP access, so you need some 3rd-party software. OpenLink Software provides a package that will do the job. It consists of a JDBC driver for CFMX Server software that runs on windows and interfaces the JDBC driver (above) A MS-Access agent, that runs on windows and connects the server with the MS-Access ODBC driver. I have successfully done this with Mac OS X, running MS-Access97/2000 under VirtualPC emulated WindowsNT/XP MS-Access can be running, or not. I used CFMX programs to read the a large MS-Access mdb, validate the data, normalize, create and populate tables using Sybase_ASE (could be any CFMX supported db). In my case, this was all running on a single box -- everything but the emulated MS-Access ODBC driver, an OpenLink server/agent were run in Native OS X. I haven't tried Solaris, but the same setup should be possible. The Openlink software is $500 -- which seems a little pricey. Except you could easily recover this cost with a single conversion (as described above). Further, OpenLink Software has a free trial, so you can play before you pay. Dick On Wednesday, October 23, 2002, at 10:22 AM, Troy Simpson wrote: I'm sitting here trying to figure a way to use ColdFusionMX on Solaris8 to get data out of an Microsoft Access Database. I heard a rumor that there was an ODBC driver or some other driver that would allow this to happen. Does anyone know if this is true? Can I store an Access DB File on a Solaris File system and use ColdFusionMX to select data from it which is also running on the same Solaris system? I have a feeling that the answer would be NO, but just wanted to post this to see if I am correct. I searched the CF-TALK list for this and did not find anything, but I could have used the wrong search criteria. If this is indeed not possible, I thought of another idea to accomplish this that might work. Use ColdFusionMX in distributed mode. Install ColdFusionMX and the Access DB file on a Windows2000/XP server and use ODBC to connect to Access. Configure the web server, maybe Apache2, on Sun Solaris8 with the ColdFusionMX distributed client (wsconfig.jar). I wonder if this would work like I expect it to? Anyone already done this? I can already see the benefits. I can segregate my small Access Applications from the rest. ;-) I strongly invite any and all comments. Thanks, Troy -- - Troy Simpson Applications Analyst/Programmer, MCSE, OCPDBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Search functionality: Verity, LIKE operator, or what?
Hi all: I haven't posted to this list for awhile. I used to post all the time, and used to write the TipWorld ColdFusion tips many of you received. Good to be back in the mix. My question: I built a document management system of sorts. I have all the files in a directory. there's a database record for every file with fields such as: title, filename, description, keywords, and more. The filename field references the actual physical file and it's all very simple. So now I want to provide the ability to search the files. with a twist. I have a box where the user can type in keywords. I could then write a query which uses the LIKE operator many times and searches the various relevant fields for that keyword. But is that really the most efficient way? I know I could create a collection. But doesn't a collection only search the actual content of the physical files indexed in the collection? Meaning my title, description, and keywords fields (etc.) wouldn't be relevant. What do I do? That's question one. but then let's take it a step further: I have a securitytype associated with each file record, which denotes whether the logged in user has access to the file. When a user searches for files, I DO NOT want to display files he does not have access to. I can easily accomplish this using my own query (LIKE operator and a WHERE clause that only pulls records they have access to), but if I do it the verity way, is this possible? Just trying to decide the best way to go about this. I am using ColdFusion Pro MX, SQLServer 2000. --D ### David Notik Digital202, LLC Imagination gone digital. Web: http://www.digital202.com/ www.digital202.com E-mail: mailto:dave;digital202.com [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
It WAS working I tell you...
I'm getting this wierd error under CFMX (with updater applied) with the following query: cfquery name=LookupCategories datasource=#DataSourceName# SELECT CategoryID, CategoryName, CategoryDescription, CategoryAdded, CategoryCreator FROM Categories ORDER BY CategoryName ASC /cfquery The error I am getting is: Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The Error Occurred in C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 Called from C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 6 : ORDER BY 7 : CategoryName ASC 8 : /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX Problem... RESOLVED
I blogged this yesterday in the hope that it will save other folks the same pain: http://www.corfield.org/blog/2002_10_01_archive.html#83378585 On Wednesday, Oct 23, 2002, at 10:29 US/Pacific, Gary W. Sullivan II wrote: Ok... I figured out the answer to my problem. It wasn't CF related at all. It was that damn McAfee NetShield. It renamed the Java compiler to jikesew.exe.vlr because it quarantined it (???), so I just unquarantined it (even though I still had to MANUALLY take out the .vlr extension because McAfee hates my guts, apparently. If anyone comes across this problem, don't sweat, it's an easy fix. Thanks to everyone for your help which directly led to my success :-) - Gary Sullivan -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Tuesday, October 22, 2002 3:17 PM To: CF-Talk Subject: RE: CFMX Problem... Yes... I am running Netshield. I am on my way down to the server room to disble it. Any other .cfm files run fine... It's just a few subdirectories that get all cheesy on me. You may have to do more than that - it's possible that Netshield has quarantined your Java compiler. You may need to unquarantine it, or reinstall it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CFMX question for Ben and Debbie
On Wednesday, Oct 23, 2002, at 02:18 US/Pacific, Adrian Lynch wrote: Here's an idea, CFMX turns into a single IP server after the trial is up, why not make DWMX turn into a one page at a time product after 30 days? Sounds like a great suggestion for the DWMX team via the wishlist form :) I can smell your brains! -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Using CFEXECUTE from a Web Browser???
Has anyone ever tried to use CFEXECUTE to execute a command? CFEXECUTE NAME=C:\WINDOWS\system32\cmd.exe ARGUMENTS=copy zebra.txt LPT1 TIMEOUT=5/CFEXECUTE We're trying to print barcodes from a Web browser and have been having lots of problems. All it does is times out. I can go to a command prompt and type in copy zebra.txt LPT1 and it works fine. How can I do this using CFEXECUTE? Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Using CFEXECUTE from a Web Browser???
It's probably a permission problem. Make sure that that the CF server service account has permissions to use the printer. Kevin -Original Message- From: Dave Cordes [mailto:davecordes;charter.net] Sent: Wednesday, October 23, 2002 5:00 PM To: CF-Talk Subject: Using CFEXECUTE from a Web Browser??? Has anyone ever tried to use CFEXECUTE to execute a command? CFEXECUTE NAME=C:\WINDOWS\system32\cmd.exe ARGUMENTS=copy zebra.txt LPT1 TIMEOUT=5/CFEXECUTE We're trying to print barcodes from a Web browser and have been having lots of problems. All it does is times out. I can go to a command prompt and type in copy zebra.txt LPT1 and it works fine. How can I do this using CFEXECUTE? Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Search functionality: Verity, LIKE operator, or what?
David, email me off-list for help on this. Cheers! Peter Tilbrook ([EMAIL PROTECTED]) Project Officer Strategic Development Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2600 Telephone: (02) 6213 6731 Facsimile: (02) 6213 7287 -Original Message- From: David Notik [mailto:dave;digital202.com] Sent: Thursday, 24 October 2002 9:03 AM To: CF-Talk Subject: Search functionality: Verity, LIKE operator, or what? Hi all: I haven't posted to this list for awhile. I used to post all the time, and used to write the TipWorld ColdFusion tips many of you received. Good to be back in the mix. My question: I built a document management system of sorts. I have all the files in a directory. there's a database record for every file with fields such as: title, filename, description, keywords, and more. The filename field references the actual physical file and it's all very simple. So now I want to provide the ability to search the files. with a twist. I have a box where the user can type in keywords. I could then write a query which uses the LIKE operator many times and searches the various relevant fields for that keyword. But is that really the most efficient way? I know I could create a collection. But doesn't a collection only search the actual content of the physical files indexed in the collection? Meaning my title, description, and keywords fields (etc.) wouldn't be relevant. What do I do? That's question one. but then let's take it a step further: I have a securitytype associated with each file record, which denotes whether the logged in user has access to the file. When a user searches for files, I DO NOT want to display files he does not have access to. I can easily accomplish this using my own query (LIKE operator and a WHERE clause that only pulls records they have access to), but if I do it the verity way, is this possible? Just trying to decide the best way to go about this. I am using ColdFusion Pro MX, SQLServer 2000. --D ### David Notik Digital202, LLC Imagination gone digital. Web: http://www.digital202.com/ www.digital202.com E-mail: mailto:dave;digital202.com [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Using CFEXECUTE from a Web Browser???
Has anyone ever tried to use CFEXECUTE to execute a command? CFEXECUTE NAME=C:\WINDOWS\system32\cmd.exe ARGUMENTS=copy zebra.txt LPT1 TIMEOUT=5/CFEXECUTE We're trying to print barcodes from a Web browser and have been having lots of problems. All it does is times out. I can go to a command prompt and type in copy zebra.txt LPT1 and it works fine. How can I do this using CFEXECUTE? try cfexecute name=copy c:\path\to\zebra.txt lpt1 timeout=5/cfexecute cfexecute accesses the operating system in much the same way cmd.exe does, so at that point, cmd.exe is superfluous in your name attribute. You do need to bear in mind, however, that any DOS commands you execute this way will be relative iirc from the root of the operating system drive, i.e. from c:\ ... so any batch files you need access to, etc. will need to be in that root or will require full paths to files or will require entries in the path in your autoexec.bat hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: It WAS working I tell you...
Access sometimes returns this error message if you make reference to an object (table, column, etc.) that does not exist or is not identified in the query. Is it possible that you misspelled one of the column names? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tilbrook, Peter [mailto:Peter.Tilbrook;abcb.gov.au] Sent: Wednesday, October 23, 2002 7:06 PM To: CF-Talk Subject: It WAS working I tell you... I'm getting this wierd error under CFMX (with updater applied) with the following query: cfquery name=LookupCategories datasource=#DataSourceName# SELECT CategoryID, CategoryName, CategoryDescription, CategoryAdded, CategoryCreator FROM Categories ORDER BY CategoryName ASC /cfquery The error I am getting is: Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The Error Occurred in C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 Called from C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 6 : ORDER BY 7 : CategoryName ASC 8 : /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CFMX Installation Help Needed
Tried to install CFMX on our Unix box and ran into problems. Installing over CF5 seemed to mangle it badly including no bin directory! Started over with a clean install and got it at least running this time but it: * Runs MUCH slower than CF5 - have others seen this? * The server admin throws Java errors trying to configure the server. Are these known issues? What's the workaround? Is there documentation of what to do/not do in installing CFMX successfully on Unix? -- Bruce Holm Web Developer Lattice Semiconductor [EMAIL PROTECTED] -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Using CFEXECUTE from a Web Browser???
Thanks for the suggestion but I got an error. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Slightly OT - Powered by MX logo's ?
Can someone point me to where I can get Powered by ColdFusion MX logo's? Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: It WAS working I tell you...
Nope. All correct. Was working fine and then stopped. Is working under SQL Server 2000 just fine. -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelbaum;evoch.com] Sent: Thursday, 24 October 2002 10:21 AM To: CF-Talk Subject: RE: It WAS working I tell you... Access sometimes returns this error message if you make reference to an object (table, column, etc.) that does not exist or is not identified in the query. Is it possible that you misspelled one of the column names? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tilbrook, Peter [mailto:Peter.Tilbrook;abcb.gov.au] Sent: Wednesday, October 23, 2002 7:06 PM To: CF-Talk Subject: It WAS working I tell you... I'm getting this wierd error under CFMX (with updater applied) with the following query: cfquery name=LookupCategories datasource=#DataSourceName# SELECT CategoryID, CategoryName, CategoryDescription, CategoryAdded, CategoryCreator FROM Categories ORDER BY CategoryName ASC /cfquery The error I am getting is: Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The Error Occurred in C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 Called from C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 6 : ORDER BY 7 : CategoryName ASC 8 : /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Anybody using manual 304 not modified response?
Susan Rayburn wrote:
I'm wondering if anyone is using a manual 304 not modified response with
ColdFusion dynamic pages on IIS. I'd like to pull the last modified date
from SQL and pass it to the browser. If anyone has had luck setting that
up
(or knows of an article explaining how-to) I'd love to see more.
I'm interested in using the 304 responses as described in the below
discussion.
http://www.webmasterworld.com/forum3/6005.htm
Susan:
I've not done this, but your question got me a bit curious and so I looked
into it a bit more. First, not all web clients send the If-Modified-Since
header, so before anything you'd have to check for it's existence. Cold
Fusion allows you to access this header via the CGI.HTTP_IF_MODIFIED_SINCE
variable. If it exists, its value should be in the format specified by RFC
1123, for example:
Sun, 06 Nov 1994 08:49:37 GMT
So, you can parse this date value, and compare it to the last modified
date/time of your current page/data. Depending on the result of the
comparison, you either let the page execute as normal, or you return the 304
response. So you might use something like the following:
CFIF IsDefined(CGI.HTTP_IF_MODIFIED_SINCE)
CFSET comparisonDate = [convert date to CF timestamp and to local
time]
CFSET lastModDate = [get last mod date from file sys or DB]
CFIF DateCompare(lastModDate, comparisonDate) EQ 1
CFHEADER STATUSCODE=304 STATUSTEXT=Not Modified
CFABORT
/CFIF
/CFIF
This doesn't take into account the If-None-Match header, also discussed in
RFC 2616, but this is about as far as I've had time to get. Also, to
facilitate the logic needed for the first step, convert date to CF
timestamp and to local time, I wrote the following UDF (queued at
cflib.org):
CFSCRIPT
/**
* Function that converts HTTPTimeString format to ColdFusion TimeStamp
format and
* optionally converts the time from UTC/GMT to local time.
*
* @param httpTimeStringA datetime in the format: ddd, dd mmm hh:mm:ss
GMT. (Required)
* @param convertToLocalA boolean specifying whether httpTimeString should
be converted to local time. Defaults to false. (Optional)
* @return Returns a string in Cold Fusion Time Stamp format.
* @author Mosh Teitelbaum ([EMAIL PROTECTED])
* @version 1, October 23, 2002
*/
function getTimeStamp(httpTimeString) {
// Build Time Stamp
var tsParts = ListToArray(httpTimeString, );
var timeStamp = {ts ' tsParts[4] -
DateFormat(#tsParts[3]#/1/1970, mm) - tsParts[2]
tsParts[5] '};
// Convert to local time
if ((ArrayLen(Arguments) EQ 2) AND (CompareNoCase(Arguments[2], TRUE) EQ
0)) {
timeStamp = DateConvert(utc2Local, timeStamp);
}
// Return timeStamp
return timeStamp;
}
/CFSCRIPT
After writing and submitting it, I noticed that there is a similar (too
similar for my tastes, but whatever) UDF that handles the conversion from
HTTPTimeString to CF TimeStamp but does not handle the conversion from
UTC/GMT to localtime. Anyway, your first line of code would now change
from:
CFSET comparisonDate = [convert date to CF timestamp and to local time]
to:
CFSET comparisonDate = getTimeStamp(CGI.HTTP_IF_MODIFIED_SINCE, True)
How you get the last modified date is up to you. You'd have to check, I
believe, both the file timestamp and the data timestamp.
Good luck and let me know if you take this any further.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Using CFEXECUTE from a Web Browser???
Oops. Here is the error. An exception occurred when invoking an external process. The cause of this exception was that: java.io.IOException: CreateProcess: copy C:\Inetpub\wwwroot\CFDEV\barcode\zebra.txt LPT1 error=2. Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) -Original Message- From: Dave Cordes [mailto:davecordes;charter.net] Sent: Wednesday, October 23, 2002 7:31 PM To: CF-Talk Subject: RE: Using CFEXECUTE from a Web Browser??? Thanks for the suggestion but I got an error. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Anybody using manual 304 not modified response?
Oops, left something out.
This won't do much good unless you also send back the Last-Modified header
with every page that doesn't return a 304.
So change the code a bit so it reads like:
CFIF DateCompare(lastModDate, comparisonDate) EQ 1
CFHEADER STATUSCODE=304 STATUSTEXT=Not Modified
CFABORT
CFELSE
CFHEADER NAME=Last-Modified VALUE=#GetHttpTimeString(Now())#
/CFIF
Again, I haven't really tested much of this, so just make sure the code
works as expected before dropping into production 8^).
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Mosh Teitelbaum [mailto:mosh.teitelbaum;evoch.com]
Sent: Wednesday, October 23, 2002 9:10 PM
To: CF-Talk
Subject: RE: Anybody using manual 304 not modified response?
Susan Rayburn wrote:
I'm wondering if anyone is using a manual 304 not modified response with
ColdFusion dynamic pages on IIS. I'd like to pull the last modified date
from SQL and pass it to the browser. If anyone has had luck setting that
up
(or knows of an article explaining how-to) I'd love to see more.
I'm interested in using the 304 responses as described in the below
discussion.
http://www.webmasterworld.com/forum3/6005.htm
Susan:
I've not done this, but your question got me a bit curious and so I looked
into it a bit more. First, not all web clients send the If-Modified-Since
header, so before anything you'd have to check for it's existence. Cold
Fusion allows you to access this header via the CGI.HTTP_IF_MODIFIED_SINCE
variable. If it exists, its value should be in the format
specified by RFC
1123, for example:
Sun, 06 Nov 1994 08:49:37 GMT
So, you can parse this date value, and compare it to the last modified
date/time of your current page/data. Depending on the result of the
comparison, you either let the page execute as normal, or you
return the 304
response. So you might use something like the following:
CFIF IsDefined(CGI.HTTP_IF_MODIFIED_SINCE)
CFSET comparisonDate = [convert date to CF timestamp and to local
time]
CFSET lastModDate = [get last mod date from file sys or DB]
CFIF DateCompare(lastModDate, comparisonDate) EQ 1
CFHEADER STATUSCODE=304 STATUSTEXT=Not Modified
CFABORT
/CFIF
/CFIF
This doesn't take into account the If-None-Match header, also
discussed in
RFC 2616, but this is about as far as I've had time to get. Also, to
facilitate the logic needed for the first step, convert date to CF
timestamp and to local time, I wrote the following UDF (queued at
cflib.org):
CFSCRIPT
/**
* Function that converts HTTPTimeString format to ColdFusion TimeStamp
format and
* optionally converts the time from UTC/GMT to local time.
*
* @param httpTimeString A datetime in the format: ddd, dd
mmm hh:mm:ss
GMT. (Required)
* @param convertToLocal A boolean specifying whether
httpTimeString should
be converted to local time. Defaults to false. (Optional)
* @return Returns a string in Cold Fusion Time Stamp format.
* @author Mosh Teitelbaum ([EMAIL PROTECTED])
* @version 1, October 23, 2002
*/
function getTimeStamp(httpTimeString) {
// Build Time Stamp
var tsParts = ListToArray(httpTimeString, );
var timeStamp = {ts ' tsParts[4] -
DateFormat(#tsParts[3]#/1/1970, mm) - tsParts[2]
tsParts[5] '};
// Convert to local time
if ((ArrayLen(Arguments) EQ 2) AND
(CompareNoCase(Arguments[2], TRUE) EQ
0)) {
timeStamp = DateConvert(utc2Local, timeStamp);
}
// Return timeStamp
return timeStamp;
}
/CFSCRIPT
After writing and submitting it, I noticed that there is a similar (too
similar for my tastes, but whatever) UDF that handles the conversion from
HTTPTimeString to CF TimeStamp but does not handle the conversion from
UTC/GMT to localtime. Anyway, your first line of code would now change
from:
CFSET comparisonDate = [convert date to CF timestamp and
to local time]
to:
CFSET comparisonDate =
getTimeStamp(CGI.HTTP_IF_MODIFIED_SINCE, True)
How you get the last modified date is up to you. You'd have to check, I
believe, both the file timestamp and the data timestamp.
Good luck and let me know if you take this any further.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Re: Using CFEXECUTE from a Web Browser???
It's quite likely a permissions problem. But another thing you can try is to put the commands in a .BAT file and then execute the .BAT file. Also note... I've experienced some weirdness with the CFEXECUTE command in CFMX. I wish I could explain it better than that but the main problem I was having was that some programs (which worked in CF5) would not execute in CFMX. I also noticed that the timeout attribute was causing the program to take that long to execute rather than executing and then returning back to the calling template. I'm not sure if this was addressed in the updater patch or not. I haven't tested it since. -Novak - Original Message - From: Dave Cordes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 5:00 PM Subject: Using CFEXECUTE from a Web Browser??? Has anyone ever tried to use CFEXECUTE to execute a command? CFEXECUTE NAME=C:\WINDOWS\system32\cmd.exe ARGUMENTS=copy zebra.txt LPT1 TIMEOUT=5/CFEXECUTE We're trying to print barcodes from a Web browser and have been having lots of problems. All it does is times out. I can go to a command prompt and type in copy zebra.txt LPT1 and it works fine. How can I do this using CFEXECUTE? Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: sorta Strange CFGRAPH thing
Huh. Ok cool. I'll take a look tomorrow. Thanks Dave! J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Wednesday, October 23, 2002 3:33 PM To: CF-Talk Subject: RE: sorta Strange CFGRAPH thing If you go to interrev1.fares (our internet dev site/the new app) the graph works. If you go to faresrev (a virtual folder to the above folder) graph no worky. Anyone seen or heard of anything likes this? Something I am over looking? Within each directory, the URL /CFIDE/GraphData.cfm... has to work, so you may have a mapping issue. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Create table
What would be the SQL Server equivalent of the following code (particularly the COUNTER attribute)?: cfquery datasource=#DataSourceName# CREATE TABLE #Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName# ( BookmarkID COUNTER NOT NULL PRIMARY KEY, BookmarkName TEXT(255), BookmarkCategory TEXT(255), BookmarkURL TEXT(255), BookmarkDescription MEMO, BookmarkAdded DATETIME, BookmarkVisits NUMBER, BookmarkRating TEXT(50), BookmarkLastVisit DATETIME ); /cfquery Cheers! Peter Tilbrook Project Officer Strategic Development Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2600 Telephone: (02) 6213 6731 Facsimile: (02) 6213 7287 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Create table
If I'm not mistaken it would be: cfquery datasource=#DataSourceName# CREATE TABLE #Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName# ( BookmarkID IDENTITY NOT NULL PRIMARY KEY, BookmarkName VARCHAR(255), BookmarkCategory VARCHAR(255), BookmarkURL VARCHAR(255), BookmarkDescription TEXT, BookmarkAdded DATETIME, BookmarkVisits INT, BookmarkRating VARCHAR(50), BookmarkLastVisit DATETIME ); /cfquery At 11:56 AM 10/24/2002 +1000, you wrote: What would be the SQL Server equivalent of the following code (particularly the COUNTER attribute)?: cfquery datasource=#DataSourceName# CREATE TABLE #Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName# ( BookmarkID COUNTER NOT NULL PRIMARY KEY, BookmarkName TEXT(255), BookmarkCategory TEXT(255), BookmarkURL TEXT(255), BookmarkDescription MEMO, BookmarkAdded DATETIME, BookmarkVisits NUMBER, BookmarkRating TEXT(50), BookmarkLastVisit DATETIME ); /cfquery Cheers! Peter Tilbrook Project Officer Strategic Development Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2600 Telephone: (02) 6213 6731 Facsimile: (02) 6213 7287 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Good Database Practices
How important is it to build auditing into your database? For example, in an invoicing system where you have an invoice table and an invoice item table, does anyone recommend keeping totals such as number of items or total invoice amount in the invoice record? Not for reporting, but for data integrity checks. If so, how often would you validate the tables and what do you do if errors are found? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Create table
BookmarkID IDENTITY NOT NULL PRIMARY KEY, I think: BookmarkID INT IDENTITY NOT NULL PRIMARY KEY, Matthew Walker http://www.matthewwalker.net.nz/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Good Database Practices
Andy, That's a good question. Here's my $0.02. I do not think it is necessary or even helpful to store aggregate information as a checkpoint to validate data. What is often done, however, is to keep an entire audit trail for the database. Basically what this means is you always keep a copy of every record. There are a few ways to do this. One way is to add modified date and active fields to every table, and then instead of modifying any record you always insert a new record and update the modified date. To delete a record, insert a new date with latest modified date and set active equal to false. The major drawback of this method is that all joins have to filter out on only the latest record and you end up with very slow queries. However, this is a very common practice in accounting systems (PeopleSoft comes to mind since I deal with this regularly and curse it almost every day). Another method is to have a Audit or History version of every table. Use triggers so any time a record is change a new record is added to the Audit table so you have a complete history of the record. The advantage here is much greater query performance, but of course updates/inserts/deletes are slower. Does this tradeoff sound familiar? Same considerations as with indexes.. Speed up reads, slow down writes. Which method is best will vary by app and circumstances. HTH, Sam Date: Wed, 23 Oct 2002 21:07:11 -0500 From: Andy Ousterhout [EMAIL PROTECTED] Subject: Good Database Practices Message-ID: [EMAIL PROTECTED] How important is it to build auditing into your database? For example, in an invoicing system where you have an invoice table and an invoice item table, does anyone recommend keeping totals such as number of items or total invoice amount in the invoice record? Not for reporting, but for data integrity checks. If so, how often would you validate the tables and what do you do if errors are found? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Using CFEXECUTE from a Web Browser???
I checked and ColdFusion is logged in as the Local System Account so I don't think it could be a permissions problem. I found some other posts on the ColdFusion Support Forums that would lead me to believe that your second point about timing out is the cause. Here is the link that talks about it. I read somewhere that Macromedia has no current plans to fix it so that's not a good sign. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid= 310075 Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) -Original Message- From: [EMAIL PROTECTED] [mailto:cf-talk;linenoize.com] Sent: Wednesday, October 23, 2002 8:37 PM To: CF-Talk Subject: Re: Using CFEXECUTE from a Web Browser??? It's quite likely a permissions problem. But another thing you can try is to put the commands in a .BAT file and then execute the .BAT file. Also note... I've experienced some weirdness with the CFEXECUTE command in CFMX. I wish I could explain it better than that but the main problem I was having was that some programs (which worked in CF5) would not execute in CFMX. I also noticed that the timeout attribute was causing the program to take that long to execute rather than executing and then returning back to the calling template. I'm not sure if this was addressed in the updater patch or not. I haven't tested it since. -Novak - Original Message - From: Dave Cordes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 5:00 PM Subject: Using CFEXECUTE from a Web Browser??? Has anyone ever tried to use CFEXECUTE to execute a command? CFEXECUTE NAME=C:\WINDOWS\system32\cmd.exe ARGUMENTS=copy zebra.txt LPT1 TIMEOUT=5/CFEXECUTE We're trying to print barcodes from a Web browser and have been having lots of problems. All it does is times out. I can go to a command prompt and type in copy zebra.txt LPT1 and it works fine. How can I do this using CFEXECUTE? Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: It WAS working I tell you...
Try eliminating the ASC in the order by clause. Access orders ascending by default. Use: ORDER BY CategoryName Instead of ORDER BY CategoryName ASC Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Tilbrook, Peter [mailto:Peter.Tilbrook;abcb.gov.au] Sent: Wednesday, October 23, 2002 7:06 PM To: CF-Talk Subject: It WAS working I tell you... I'm getting this wierd error under CFMX (with updater applied) with the following query: cfquery name=LookupCategories datasource=#DataSourceName# SELECT CategoryID, CategoryName, CategoryDescription, CategoryAdded, CategoryCreator FROM Categories ORDER BY CategoryName ASC /cfquery The error I am getting is: Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The Error Occurred in C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 Called from C:\CFusionMX\wwwroot\coldbookmarks\qry_categorylist.cfm: line 8 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 140 Called from C:\CFusionMX\wwwroot\coldbookmarks\index.cfm: line 176 6 : ORDER BY 7 : CategoryName ASC 8 : /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Using CFEXECUTE from a Web Browser???
Local System Account probably DOES NOT have the proper permissions. Try (temporarily) setting ColdFusion to run as Administrator and see if that solves your problem. If it does, then you'll want to create a ColdFusion (or similar) account and set it up that way. I do NOT recommend running the ColdFusion server as Administrator for obvious reasons... just as a test to see if it's a permissions issue or not. -Novak - Original Message - From: Dave Cordes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 8:28 PM Subject: RE: Using CFEXECUTE from a Web Browser??? I checked and ColdFusion is logged in as the Local System Account so I don't think it could be a permissions problem. I found some other posts on the ColdFusion Support Forums that would lead me to believe that your second point about timing out is the cause. Here is the link that talks about it. I read somewhere that Macromedia has no current plans to fix it so that's not a good sign. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid= 310075 Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) -Original Message- From: [EMAIL PROTECTED] [mailto:cf-talk;linenoize.com] Sent: Wednesday, October 23, 2002 8:37 PM To: CF-Talk Subject: Re: Using CFEXECUTE from a Web Browser??? It's quite likely a permissions problem. But another thing you can try is to put the commands in a .BAT file and then execute the .BAT file. Also note... I've experienced some weirdness with the CFEXECUTE command in CFMX. I wish I could explain it better than that but the main problem I was having was that some programs (which worked in CF5) would not execute in CFMX. I also noticed that the timeout attribute was causing the program to take that long to execute rather than executing and then returning back to the calling template. I'm not sure if this was addressed in the updater patch or not. I haven't tested it since. -Novak - Original Message - From: Dave Cordes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 5:00 PM Subject: Using CFEXECUTE from a Web Browser??? Has anyone ever tried to use CFEXECUTE to execute a command? CFEXECUTE NAME=C:\WINDOWS\system32\cmd.exe ARGUMENTS=copy zebra.txt LPT1 TIMEOUT=5/CFEXECUTE We're trying to print barcodes from a Web browser and have been having lots of problems. All it does is times out. I can go to a command prompt and type in copy zebra.txt LPT1 and it works fine. How can I do this using CFEXECUTE? Dave Cordes Senior ColdFusion Developer 636-939-1081 (H) 636-578-4235 (M) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Good Database Practices
Sam, Would it be more effective given the hopefully minimal usage of the audit trail to a flat file and save XML version of the record (in case database structure changes). I would think that this would add less overhead then a db Insert/Add. Andy -Original Message- From: Samuel Neff [mailto:sam;serndesign.com] Sent: Wednesday, October 23, 2002 10:04 PM To: CF-Talk Subject: Re: Good Database Practices Andy, That's a good question. Here's my $0.02. I do not think it is necessary or even helpful to store aggregate information as a checkpoint to validate data. What is often done, however, is to keep an entire audit trail for the database. Basically what this means is you always keep a copy of every record. There are a few ways to do this. One way is to add modified date and active fields to every table, and then instead of modifying any record you always insert a new record and update the modified date. To delete a record, insert a new date with latest modified date and set active equal to false. The major drawback of this method is that all joins have to filter out on only the latest record and you end up with very slow queries. However, this is a very common practice in accounting systems (PeopleSoft comes to mind since I deal with this regularly and curse it almost every day). Another method is to have a Audit or History version of every table. Use triggers so any time a record is change a new record is added to the Audit table so you have a complete history of the record. The advantage here is much greater query performance, but of course updates/inserts/deletes are slower. Does this tradeoff sound familiar? Same considerations as with indexes.. Speed up reads, slow down writes. Which method is best will vary by app and circumstances. HTH, Sam Date: Wed, 23 Oct 2002 21:07:11 -0500 From: Andy Ousterhout [EMAIL PROTECTED] Subject: Good Database Practices Message-ID: [EMAIL PROTECTED] How important is it to build auditing into your database? For example, in an invoicing system where you have an invoice table and an invoice item table, does anyone recommend keeping totals such as number of items or total invoice amount in the invoice record? Not for reporting, but for data integrity checks. If so, how often would you validate the tables and what do you do if errors are found? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: SOT:Java?
Howdy Chris, Wednesday, October 23, 2002, 9:39:52 AM, Chris Alvarado wrote: CA Does anyone have any good book reccomendations to get me started down CA that path? I have some basic OOP experience, but none with Java, so any CA help would be awesome. Are you talking about just starting out with Java? If so, I recently purchased these two (Amazon.com has a package deal on them right now): Beginning Java 2 SDK 1.4 Edition (Ivor Horton) http://www.amazon.com/exec/obidos/tg/detail/-/1861005695/ Beginning Java Objects: From Concepts to Code (Jacquie Barker) http://www.amazon.com/exec/obidos/tg/detail/-/1861004176/ I haven't had a chance to look at the Barker's book yet, but Horton's is a pretty good intro to Java. Hal Helms recommended Barker's book as a good starting point to learn about OOP in one of his recent newsletters. CA Also, any preferred Development Environments / Editors? Based on a recommendation in Horton's book, I've started messing around with JCreator ( http://www.jcreator.com/ ). It's a nice Java IDE and pretty easy for beginners to pick up. The light edition is free, too. Also, UltraEdit works pretty good and has a tool you can configure to compile java files. Chris Montgomerymonty airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Create table
Matt, you're a legend! Thank you! I'll let you know what I needed the code for shortly. Cheers! Peter Tilbrook Project Officer Strategic Development Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2600 Telephone: (02) 6213 6731 Facsimile: (02) 6213 7287 -Original Message- From: Matthew Walker [mailto:Matthew;cabbagetree.co.nz] Sent: Thursday, 24 October 2002 12:15 PM To: CF-Talk Subject: RE: Create table BookmarkID IDENTITY NOT NULL PRIMARY KEY, I think: BookmarkID INT IDENTITY NOT NULL PRIMARY KEY, Matthew Walker http://www.matthewwalker.net.nz/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Create table
Matt, that worked! I left my SQL book at home but at least you helped me get this app running today! Thanks! -Original Message- From: Matthew Walker [mailto:Matthew;cabbagetree.co.nz] Sent: Thursday, 24 October 2002 12:15 PM To: CF-Talk Subject: RE: Create table BookmarkID IDENTITY NOT NULL PRIMARY KEY, I think: BookmarkID INT IDENTITY NOT NULL PRIMARY KEY, Matthew Walker http://www.matthewwalker.net.nz/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Java?
Wednesday, October 23, 2002, 5:39:06 PM, Pete Freitag wrote: PF I just came across this site today: PF http://www.joegrip.com/ PF Uses flash movies to teach you Java. Very interesting site. When I first looked at one of the free tutorials, I thought it was done in Qarbon Viewlets (missed your comment about it using flash movies - duh). The price is not bad and for someone just starting out learning Java, looks like a good investment. Thanks for the tip. Chris Montgomerymonty airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Apache 2.0.4x connector
Vern Does this mean that we will be able to use Apache with the Mac OS X port of CFMX? Some time ago, Jesse Noller said that you could not use Apache with CFMX OS X because the connector was compiled code to protect the intellectual property of CFMX Has this changed? Is there anything else that would prevent Apache from interfacing CFMX on Mac OS X? TIA Dick On Tuesday, October 22, 2002, at 09:10 AM, Vernon Viehe wrote: We will be releasing the source code to the connector so that one can recompile when needed for Apache 2.0.4x releases. The schedule is not finalized, but it will be in via a future release of the Updater. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Multiple Records Update Issue
There are several problems I can see here: 1. nulls. I would suggest you do not use NULLS to mean false. A logical field should be 0 (false) or 1 (true). Set up the DB so the field has a default value of either of them as you prefer. 2. Your checkboxes have no value even if they are passed as true, should be eg input type=checkbox name=Onboard value=1 3. You do not need to use the # hashes around variables inside the cfif block: cfif Onboard EQ )unchecked/cfif 4. I think the default state of a checkbox is unchecked, thus you should positively check them (not uncheck them) thus: input type=checkbox name=Onboard value=1 cfif Onboard EQ 1CHECKED/cfif 5. You are providing no differentiation between different records, ie you are returning lots of form.vars named onboard, or probably a single one as a comma delimited list. Either way there is no connection between the var and the record it belongs to. I expect there are a number of ways to deal with this, but I do it by concantenating the input field name thus: input type=checkbox name=Onboard_#EmpID_Muster# value=1 cfif Onboard EQ 1CHECKED/cfif. I then provide a list of the keys we are referring to in a hidden field at the end of the form, thus: CFSET tmpkeylist = cfoutput query=Recordset1 CFSET tmpkeylist = listappend(tmpkeylist,EmpID_Muster) input type=checkbox name=Onboard_#EmpID_Muster# value=1 cfif Onboard EQ 1CHECKED/cfif other query output /cfoutput CFOUTPUTINPUT TYPE=hidden NAME=EmpID_Muster_list VALUE=#tmpkeylist#/CFOUTPUT /FORM 6. Unchecked checkboxes return nothing, not even the variable name, so you must be prepared to create them and give them a false value if they don't exist. This is what CFPARAM is for. Your update script, looping thru each EmpID_Muster would thus look something like this: CFLOOP LIST=#form.EmpID_Muster_list# INDEX = idx CFPARAM NAME = Onboard_#idx# DEFAULT = 0 cfquery datasource=Muster_Test UPDATE dbo.muster SET Onboard= #evalute(Onboard_#idx#)# WHERE EmpID_Muster = #idx# /cfquery /CFLOOP note the evaluate() which gets the value of the variable HTH Hawkes, Keith A CIV wrote: Date: Tue, 22 Oct 2002 11:31:57 +0100 From: Adrian Lynch [EMAIL PROTECTED] Subject: RE: Newbie Question on Looping Message-ID: [EMAIL PROTECTED] Your code, we nd ya code My apologies, I thought that might have been presumptuous - there I go thinking again! Here it is: cfset CurrentPage=GetFileFromPath(GetTemplatePath()) cfif IsDefined(FORM.MM_UpdateRecord) AND FORM.MM_UpdateRecord EQ form2 cfquery datasource=Muster_Test UPDATE dbo.muster SET Onboard= cfif IsDefined(FORM.Onboard) 1 cfelse NULL /cfif , DayOff= cfif IsDefined(FORM.DayOff) 1 cfelse NULL /cfif , Liberty= cfif IsDefined(FORM.Liberty) 1 cfelse NULL /cfif , Leave= cfif IsDefined(FORM.Leave) 1 cfelse NULL /cfif , TAD= cfif IsDefined(FORM.TAD) 1 cfelse NULL /cfif , SIQ= cfif IsDefined(FORM.SIQ) 1 cfelse NULL /cfif WHERE EmpID_Muster=#FORM.EmpID_Muster# /cfquery /cfif cfquery name=Recordset1 datasource=Muster_Test SELECT dbo.muster.EmpID_Muster, dbo.muster.LNAME, dbo.muster.FNAME, dbo.muster.RANK, dbo.muster.Onboard, dbo.muster.DayOff, dbo.muster.Liberty, dbo.muster.Leave, dbo.muster.TAD, dbo.muster.SIQ FROM dbo.muster where date_today getdate()-1 and dept_name like 'a%' /cfquery form name=form1 method=post action= /form form method=post name=form2 action=cfoutput#CurrentPage#/cfoutput table width=852 height=85 border=1 align=center cellpadding=1 cfoutput query=Recordset1 tr valign=baseline td height=20 colspan=2 align=right nowrap div align=rightfont color=##00 size=2#Recordset1.RANK# #Recordset1.FNAME# #Recordset1.LNAME#___ Onboard:_ input type=checkbox name=Onboard value= cfif (#Recordset1.Onboard# EQ )unchecked/cfif DayOff:_ input type=checkbox name=DayOff value= cfif (#Recordset1.DayOff# EQ )unchecked/cfif Liberty:_ input type=checkbox name=Liberty value= cfif (#Recordset1.Liberty# EQ )unchecked/cfif Leave:_ input type=checkbox name=Leave value= cfif (#Recordset1.Leave# EQ )unchecked/cfif TAD:_ input type=checkbox name=TAD value= cfif (#Recordset1.TAD# EQ )unchecked/cfif SIQ:_ input type=checkbox name=SIQ value= cfif (#Recordset1.SIQ# EQ )unchecked/cfif /font /div/td /tr /cfoutput tr valign=baseline td height=20 colspan=2 align=right nowrap div align=center input name=submit type=submit value=Update Record /div/td /tr /table input type=hidden name=MM_UpdateRecord value=form2 input type=hidden name=EmpID_Muster
Re: Known CFMX issues under consideration for upcoming Updater re leas e
Vern Here's hoping that the next updater (and future updaters) will also work on the port to Mac OS X -- so we don't have to reinstall Linux. Damon Cooper and Brent Baker, of the Macromedia CF RD team, put together an updater 1 package that worked great on Mac OS X -- I hope this will carried forward to future updaters. TIA Dick On Tuesday, October 22, 2002, at 11:39 AM, Vernon Viehe wrote: Hey Maurius, Let me highlight some of the text that preceeds the list, and try to elaborate a bit: This TechNote provides a summary of *some* of the known issues with Macromedia ColdFusion MX. Fixes for *these* issues are currently being investigated for *potential* inclusion in an upcoming release of the ColdFusion MX Updater. *Inclusion or exclusion* in this list *does not guarantee inclusion or exclusion from future releases* of the ColdFusion MX Updater. Basically, this (should?) mean that not all issues reported to us are on this list. These are the ones that have been chosen for consideration in an upcoming updater release. There may be issues included in the updater that aren't listed here. Most importantly, there are other known issues, and we know that many of those issues are very important to the community. Hopefully, issues that didn't make it onto this list for consideration for the next updater will end up on a list for a subsequent updater - but we haven't gotten this one out the door yet, so we haven't firmed up anything beyond what's on this technote. If there's an issue you'd like to see addressed as part of an updater, and it's not on this list, you can vote for that issue by turning it in on the feature request form (even if you already have reported it, so do it as a vote. I got this form the horse's mouth, so please do so!) http://www.macromedia.com/support/email/wishform?6213=3 Thanks! Vernon Viehe ColdFusion Community Manager Macromedia, Inc. -- Macromedia Certified Professional CF blog at http://vvmx.blogspot.com -Original Message- From: Marius Milosav [mailto:mmilosav;scorpiosoft.com] Sent: Tuesday, October 22, 2002 11:31 AM To: CF-Talk Subject: Re: Known CFMX issues under consideration for upcoming Updater releas e Is this list the final cut for the next updater? I haven't seen any mention for the null problem throw once in a while by CFMX server, http://webforums.macromedia.com/coldfusion/ messageview.cfm?catid=3threadid= 410762highlight_key=ykeyword1=null Connection reset by peer, error http://webforums.macromedia.com/coldfusion/ messageview.cfm?catid=10threadid =423645highlight_key=ykeyword1=Connection%20reset%20by%20peer cffunctions that should participate in transactions declared outside of the function All of this issues have been reported (for a couple of months now) and quasi acknowledged by MM as bugs Thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Vernon Viehe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 2:09 PM Subject: Known CFMX issues under consideration for upcoming Updater releas e TechNote 23464 provides a summary of some of the known issues with Macromedia ColdFusion MX. Fixes for these issues are currently being investigated for potential inclusion in an upcoming release of the ColdFusion MX Updater. Inclusion or exclusion in this list does not guarantee inclusion or exclusion from future releases of the ColdFusion MX Updater. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23464Method=Full Vernon Viehe ColdFusion Community Manager Macromedia, Inc. -- Macromedia Certified Professional CF blog at http://vvmx.blogspot.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Known CFMX issues under consideration for upcoming Updater re leas e
Hey Dick, Do you think MM are serious on porting over to Mac OS X? even its just in a developer capacity :-) (I dont think Macs will ever be a hit on the server market) Neil -Original Message- From: Dick Applebaum [mailto:dicklacara;mac.com] Sent: 23 October 2002 09:05 To: CF-Talk Subject: Re: Known CFMX issues under consideration for upcoming Updater re leas e Vern Here's hoping that the next updater (and future updaters) will also work on the port to Mac OS X -- so we don't have to reinstall Linux. Damon Cooper and Brent Baker, of the Macromedia CF RD team, put together an updater 1 package that worked great on Mac OS X -- I hope this will carried forward to future updaters. TIA Dick On Tuesday, October 22, 2002, at 11:39 AM, Vernon Viehe wrote: Hey Maurius, Let me highlight some of the text that preceeds the list, and try to elaborate a bit: This TechNote provides a summary of *some* of the known issues with Macromedia ColdFusion MX. Fixes for *these* issues are currently being investigated for *potential* inclusion in an upcoming release of the ColdFusion MX Updater. *Inclusion or exclusion* in this list *does not guarantee inclusion or exclusion from future releases* of the ColdFusion MX Updater. Basically, this (should?) mean that not all issues reported to us are on this list. These are the ones that have been chosen for consideration in an upcoming updater release. There may be issues included in the updater that aren't listed here. Most importantly, there are other known issues, and we know that many of those issues are very important to the community. Hopefully, issues that didn't make it onto this list for consideration for the next updater will end up on a list for a subsequent updater - but we haven't gotten this one out the door yet, so we haven't firmed up anything beyond what's on this technote. If there's an issue you'd like to see addressed as part of an updater, and it's not on this list, you can vote for that issue by turning it in on the feature request form (even if you already have reported it, so do it as a vote. I got this form the horse's mouth, so please do so!) http://www.macromedia.com/support/email/wishform?6213=3 Thanks! Vernon Viehe ColdFusion Community Manager Macromedia, Inc. -- Macromedia Certified Professional CF blog at http://vvmx.blogspot.com -Original Message- From: Marius Milosav [mailto:mmilosav;scorpiosoft.com] Sent: Tuesday, October 22, 2002 11:31 AM To: CF-Talk Subject: Re: Known CFMX issues under consideration for upcoming Updater releas e Is this list the final cut for the next updater? I haven't seen any mention for the null problem throw once in a while by CFMX server, http://webforums.macromedia.com/coldfusion/ messageview.cfm?catid=3threadid= 410762highlight_key=ykeyword1=null Connection reset by peer, error http://webforums.macromedia.com/coldfusion/ messageview.cfm?catid=10threadid =423645highlight_key=ykeyword1=Connection%20reset%20by%20peer cffunctions that should participate in transactions declared outside of the function All of this issues have been reported (for a couple of months now) and quasi acknowledged by MM as bugs Thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Vernon Viehe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 2:09 PM Subject: Known CFMX issues under consideration for upcoming Updater releas e TechNote 23464 provides a summary of some of the known issues with Macromedia ColdFusion MX. Fixes for these issues are currently being investigated for potential inclusion in an upcoming release of the ColdFusion MX Updater. Inclusion or exclusion in this list does not guarantee inclusion or exclusion from future releases of the ColdFusion MX Updater. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23464Method=Full Vernon Viehe ColdFusion Community Manager Macromedia, Inc. -- Macromedia Certified Professional CF blog at http://vvmx.blogspot.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Adding a row..
eh? so you are adding a 'blank' row to your DB?.. FWIW this is bad DB design and should be avoided; I am not sure what you are trying to achieve here . can you elaborate? Neil -Original Message- From: Russ [mailto:russ;unrealisticexpectations.com] Sent: 23 October 2002 06:37 To: CF-Talk Subject: Adding a row.. All, My application has line items that are stored in a database for a project. When you enter the application page, you start with a blank line item. You enter your information, you can perform a calculation and then you have the option to Save the project or you can Add a Row. Saving simply updates the db and then sends you on your merry way. Adding a row, on the other hand, updates all current Line Items and then returns with a new blank line. Additionally, there are fields that calculate certain titles from the line items to give dollar amounts, etc. The issue I'm having is that I cannot figure out the best approach to adding this new line item row to my project. Does anyone have any examples of this type of application or where they've done something similar? Thanks, Russ Unger Managing Partner Blue Chrome Design www.bluechromedesign.com 312.593.4260 :office 877.433.8427 :pager 312.873.4033 :fax ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: encrypt()
Costas, I too would like to see these functions - I gather they are UDF? -Original Message- From: Costas Piliotis [mailto:cpiliotis;voyus.com] Sent: 22 October 2002 22:45 To: CF-Talk Subject: RE: encrypt() Apparantly the ciper is known, and the key can be easily reverse engineered. Best use revolving keys with it if you're concerned about security. However there are some really good encryption ciphers available from the developers exchange. Stuff like RC4, Sha256, MD5, Ripemd160, rot13 are all available as functions. I can send you the cf functions if u like... -Original Message- From: Neil H. [mailto:neil-list;hostmysite.com] Sent: Tuesday, October 22, 2002 2:25 PM To: CF-Talk Subject: encrypt() How insecure is encrypt first of all. Second of all how do I know the length of the string encrypted? Thanks, Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
apache and ColdFusion
I'm running apache 1.3 on RedHat, and have run the CF5 installer (this is the version of CF required by our app), and it all seemed to go without problems, except when accessing the cfide URL, I get a page of junk with Allaire Cold Fusion Template Header Size: New Versionà at the top. Any ideas ? Google and the archives seem to be unhelpful. Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: apache and ColdFusion
Tom, What you are seeing is the source code for the template (which is encrpyted). You have to bind the .cfm extension to the ColdFusion .dll (or whatever it equivelant in RedHat...I am an not a Linux user/fan). Basically your install has failed to bind any and all .cfm pages to the CF server. This is a common install error; I am not sure what causes it though... HTH N -Original Message- From: Thomas Chiverton [mailto:thomas.chiverton;locavista.com] Sent: 23 October 2002 09:55 To: CF-Talk Subject: apache and ColdFusion I'm running apache 1.3 on RedHat, and have run the CF5 installer (this is the version of CF required by our app), and it all seemed to go without problems, except when accessing the cfide URL, I get a page of junk with Allaire Cold Fusion Template Header Size: New Versionà at the top. Any ideas ? Google and the archives seem to be unhelpful. Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX question for Ben and Debbie
Funny you should mention world peace, I've been working on a custom tag! :OD Here's an idea, CFMX turns into a single IP server after the trial is up, why not make DWMX turn into a one page at a time product after 30 days? Ade -Original Message- From: Vernon Viehe [mailto:vviehe;macromedia.com] Sent: 22 October 2002 19:58 To: CF-Talk Subject: RE: CFMX question for Ben and Debbie Download = Free CD = Very cheap (sorry!) Not sure about the change in schedule, but if you could bring about world peace, I'll bet they'd bend over backwards to adjust the publish date just for you. ;) -Vern -Original Message- From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net] Sent: Tuesday, October 22, 2002 10:18 AM To: CF-Talk Subject: RE: CFMX question for Ben and Debbie Nice one Vernon, December is miles away, any chance of getting it out earlier, just for me :OD I was hoping there would be a free trial/developers edition that you guys would be sending out on CD. Ade -Original Message- From: Vernon Viehe [mailto:vviehe;macromedia.com] Sent: 22 October 2002 18:09 To: CF-Talk Subject: RE: CFMX question for Ben and Debbie Hey Adrian, The CF MX Developer Study Guide by Macromedia Press will be available in December 2002. The Evaluation Kit is now available from the online store, for those who want a CD instead of downloading the trials. It contains all of the MX product trials (and the CFMX Trial/Developer's Edition - CFMX Trial reverts to the Developer's Edition at the end of 30 days when the trial expires). http://dynamic.macromedia.com/bin/MM/store/US/product.jsp?category=/BooksVid eos/Misc/TrialCDtype=FULL In addition to the trials CD, there's an additional CD which contains a first-hand look at all the amazing things you can do with the new MX products. I haven't seen this new first-hand look CD, so at the moment, I can't describe it any futher than that. I hope this helps! Vernon Viehe ColdFusion Community Manager Macromedia, Inc. -- Macromedia Certified Professional CF blog at http://vvmx.blogspot.com -Original Message- From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net] Sent: Tuesday, October 22, 2002 9:28 AM To: CF-Talk Subject: CFMX question for Ben and Debbie Any news on the release of the CFMX study guide and the CD version of CFMX Developers Edition? Cheers Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Known CFMX issues under consideration for upcoming Updater re leas e
Neil I hope MM is looking at a Mac OS X version of CFMX -- at least for developers. I have been told that there isn't a large enough population of Mac OS X servers to build a business case for releasing a supported production version. That said, Sybase and Oracle have released their latest db servers to run on Mac OS X, and IBM is conducting a survey to see if there is enough demand to warrant a DB/2 product for Mac OS X. So, Sybase, Oracle, and maybe IBM see an opportunity to make money on the Mac Server Market. If IBM decides to release a Mac product, that will mean that 3 of the top 4 production databases have Mac products. I have Sybase and Oracle (and every other JDBC-compliant db I could find) running on my TiBook. I just converted a client's large SQL-Server db to Sybase to see what is involved. As you may know, Sybase and SQL-Server share a common ancestry, T/SQL, etc. There were a few differences, but everything works fine, even though everything is running on the same box. It performs well, and makes a very nice demo. Later, I will do the same exercise with Oracle -- just 'cause I can. Sybase_ASE, on the Mac, has an interesting feature -- using Rendezvous (Apple's zero configuration networking) it can detect and connect (with appropriate security) to any Sybase servers that exist on the network or wireless. So, conceivably, you could grab your wireless laptop, dance into a client's office, connect to his production db and do a prepared or ad hoc CFMX demo -- no wires, no configuration, no fiddling, no nuthin' between you and the presentation The list of dbs that run on OS X and interface with CFMX include: MySQL PostgreSQL OpenBase PointBase Embedded PointBase Server FrontBase Xindice Sybase_ASE Oracle9i And to convert existing offline databases to a more robust RDBMS suitable for online use, CFMX can interface the following running on Mac OS X. FileMaker MS-Access 97/2000 running under emulation with an interface from OpenLink Software. The Client Sybase db that I created (mention above) was actually built from a MS-Access 97 mdb, with CFMX programs reading the Access db, then creating,validating, normalizing the Sybase db (using the same programs that created the SQL-Server db, several years ago). So, with the exception of SQL-Server and DB/2, you can run (pretty much) everything you need for a complete CFMX developer system in native OS X, on a single box. It's getting there! Dick On Wednesday, October 23, 2002, at 01:26 AM, Robertson-Ravo, Neil (REC) wrote: Hey Dick, Do you think MM are serious on porting over to Mac OS X? even its just in a developer capacity :-) (I dont think Macs will ever be a hit on the server market) Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Known CFMX issues under consideration for upcoming Updater re leas e
Dick Applebaum wrote: That said, Sybase and Oracle have released their latest db servers to run on Mac OS X, and IBM is conducting a survey to see if there is enough demand to warrant a DB/2 product for Mac OS X. So, Sybase, Oracle, and maybe IBM see an opportunity to make money on the Mac Server Market. If IBM decides to release a Mac product, that will mean that 3 of the top 4 production databases have Mac products. And how many of these depend on an up-to-date JRE being available for Mac OS X? Don't they all just depend on POSIX compliance, which is pretty much guaranteed giving the FreeBSD roots? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFMX / Mac OS : was Known issues...
Dick, Yep it is getting there. I still think that a production level version of CFMX will never happen on an Apple as there just isnt enough of them running within ISP's etc... nothing can be done about that, its a legacy thing and it aint gonna happen overnight. What would be good to see is a version which is Mac OS X compatible and is supported - this could be the Linux version. That way you do not have to sell a Mac version per say but get sales via another avenue and if the user decides to buy it and run it on OSX then so be it! As for the DB's, I do see your point, but what also needs to be considered with them is the features they provide - such as Stored Procedures, Triggers etc (which some of them do not support). Is there no way you can install CFMX on a Mac OS and use a Windows based SQL server? (annoying, but its a step in the right direction). Neil -Original Message- From: Dick Applebaum [mailto:dicklacara;mac.com] Sent: 23 October 2002 10:21 To: CF-Talk Subject: Re: Known CFMX issues under consideration for upcoming Updater re leas e Neil I hope MM is looking at a Mac OS X version of CFMX -- at least for developers. I have been told that there isn't a large enough population of Mac OS X servers to build a business case for releasing a supported production version. That said, Sybase and Oracle have released their latest db servers to run on Mac OS X, and IBM is conducting a survey to see if there is enough demand to warrant a DB/2 product for Mac OS X. So, Sybase, Oracle, and maybe IBM see an opportunity to make money on the Mac Server Market. If IBM decides to release a Mac product, that will mean that 3 of the top 4 production databases have Mac products. I have Sybase and Oracle (and every other JDBC-compliant db I could find) running on my TiBook. I just converted a client's large SQL-Server db to Sybase to see what is involved. As you may know, Sybase and SQL-Server share a common ancestry, T/SQL, etc. There were a few differences, but everything works fine, even though everything is running on the same box. It performs well, and makes a very nice demo. Later, I will do the same exercise with Oracle -- just 'cause I can. Sybase_ASE, on the Mac, has an interesting feature -- using Rendezvous (Apple's zero configuration networking) it can detect and connect (with appropriate security) to any Sybase servers that exist on the network or wireless. So, conceivably, you could grab your wireless laptop, dance into a client's office, connect to his production db and do a prepared or ad hoc CFMX demo -- no wires, no configuration, no fiddling, no nuthin' between you and the presentation The list of dbs that run on OS X and interface with CFMX include: MySQL PostgreSQL OpenBase PointBase Embedded PointBase Server FrontBase Xindice Sybase_ASE Oracle9i And to convert existing offline databases to a more robust RDBMS suitable for online use, CFMX can interface the following running on Mac OS X. FileMaker MS-Access 97/2000 running under emulation with an interface from OpenLink Software. The Client Sybase db that I created (mention above) was actually built from a MS-Access 97 mdb, with CFMX programs reading the Access db, then creating,validating, normalizing the Sybase db (using the same programs that created the SQL-Server db, several years ago). So, with the exception of SQL-Server and DB/2, you can run (pretty much) everything you need for a complete CFMX developer system in native OS X, on a single box. It's getting there! Dick On Wednesday, October 23, 2002, at 01:26 AM, Robertson-Ravo, Neil (REC) wrote: Hey Dick, Do you think MM are serious on porting over to Mac OS X? even its just in a developer capacity :-) (I dont think Macs will ever be a hit on the server market) Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Adding a row..
One way to do this is have a set of empty input field(s) after the end of the lineitems output query called something like new_fieldname When you come to submit, you update your existing lineitems, then check if one or more of your new_ fields has a value in it, ie CFIF len(trim(form.new_fieldname)) gt 0 and if the value(s) check out as valid, then do an insert query. Then read the lot with your SELECT query, output it, if insert was good then it will now be a lineitem. Robertson-Ravo, Neil (REC) wrote: eh? so you are adding a 'blank' row to your DB?.. FWIW this is bad DB design and should be avoided; I am not sure what you are trying to achieve here . can you elaborate? Neil -Original Message- From: Russ [mailto:russ;unrealisticexpectations.com] Sent: 23 October 2002 06:37 To: CF-Talk Subject: Adding a row.. All, My application has line items that are stored in a database for a project. When you enter the application page, you start with a blank line item. You enter your information, you can perform a calculation and then you have the option to Save the project or you can Add a Row. Saving simply updates the db and then sends you on your merry way. Adding a row, on the other hand, updates all current Line Items and then returns with a new blank line. Additionally, there are fields that calculate certain titles from the line items to give dollar amounts, etc. The issue I'm having is that I cannot figure out the best approach to adding this new line item row to my project. Does anyone have any examples of this type of application or where they've done something similar? Thanks, Russ Unger Managing Partner Blue Chrome Design www.bluechromedesign.com 312.593.4260 :office 877.433.8427 :pager 312.873.4033 :fax ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
passing variable via JS to popup
Hello All... I have a template I'm using to pass a CF variable to a
pop-up window named directions.cfm that I want to provide detail
directions (text) for an event location. The variable that needs to be
passed is event_no (event number). being a JS novice, can someone tell
me how to change the code below to pass the event_no CF variable
(#event_no#) to directions.cfm.. The code as written is not sending the
event_no
cfoutput query=event_no
form action=directions.cfm method=POST
a href=## OnClick =window.open('directions.cfm');Directions/a
INPUT TYPE=hidden NAME=event_no VALUE=#event_no#
/form
/cfoutput
thanks
Tim Laureska
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
