help - running a cf query opens homesite
I have a drop down list, when you pick an option and click proceed your selection should come up in the browser. I upgraded from access 97 to access xp. Now when I click on proceed homesite opens. Any ideas? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Statistics gatherers
Hi all, I'm currently investigating statistics gathering packages, such as ActiveTracker, to be used to probide usage statistics for fusebox-like sites. The hosting providor's stats package (which probably parses log files) only sees index.cfm (yea, they should get a better package) when I say index.cfm/Foo/Bar. Anyway, ActiveTracker seems quite nice, however it stores the data in the form of 1 record per hit, which while I can appreciate is the fastes t way of logging, on a high traffic site that's going to be creating a LOT of records, I have visions of a huge wasteful table of hit records . Does anybody know of a similar package (doesn't necessarily need to be in CF, if it was open source I could possibly convert it), that stores the data in a slightly less gratuitous method ? It would need to provide the usual stats functions, session counts, referrers, exit pages, top pages, paths through site etc etc. --- James Sleeman __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE6 and CFLocation
Or CFHTMLHEAD ? Or basically anything where CF programatically adds code to the head section of a page? No, it's just plain forms, and a cfloction tag. No code after the cflocation at all. Tom C __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email validation
Very nice piece of work! REFindNocase(^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+ )*\.(([a-z ]{2,3})|(aero|coop|info|museum|name))$,email_address) I'd add a '=' to the first two cases, as in http://www.regxlib.com/REDetails.aspx?regexp_id=39, which allow through some of the more infrequent but legal email address. Tom C __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Two tables same column name?
hi john try aliasing the value you want to pull out, there is a way which will negate the need to name all the columns you want to select, but I can't remember it off the top of my head. The code below should work, let me kow if you have any problems Mark cfquery name=getRep datasource=#session.datasource# dbserver=#session.dbserver# SELECT b.total, d.total AS second_total FROM trip_flow_breakdown b, trip_flow_data d WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = #attributes.id# AND d.wid = #attributes.wid# AND d.fid = #attributes.fid# /cfquery cfoutput#getRep.second_total#/cfoutput -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 01:21 To: CF-Talk Subject: Two tables same column name? I have a query where i join two tables. and both tables have a field which are titled the same but each table has a different value. is there a way for pulling the two different values out in cold fusion or do i have to use multiple selects?? cfquery name=getRep datasource=#session.datasource# dbserver=#session.dbserver# SELECT * FROM trip_flow_breakdown b, trip_flow_data d WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = #attributes.id# AND d.wid = #attributes.wid# AND d.fid = #attributes.fid# /cfquery the field i want to get is total but if i use cfoutput query=getRep#total#/cfoutput i only get the value of the first table in the from clause. any one have a solution? Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Omitting certain directories using cfdirectory
Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
NSLookup
Hi all. Here is a problem I have been pulling my hair out over. I want to do an NSLookup directly (ie: no custom tags if it can be avoided) and have tried both w3sockets and TCPClient to open the socket but not for love nor money can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. Can anyone point me in the correct direction? -- Jay __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NSLookup
both w3sockets and TCPClient to open the socket but not for love nor money ^^^ can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. DNS uses UDP doesn't it ? http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q173161; for instance. The RFC may be of help too. Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
James Smith wrote: Hi all. Here is a problem I have been pulling my hair out over. I want to do an NSLookup directly (ie: no custom tags if it can be avoided) and have tried both w3sockets and TCPClient to open the socket but not for love nor money can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. Can anyone point me in the correct direction? honestly the best advice here is don't re-invent the wheel.. use cfexecute and dig from sendmail/bind or maybe a java class this code using dig will give u really detailed info about dns cfsavecontent variable=dig_outcfexecute name=#server.dig_exe# arguments=#attributes.domain# +nssearch timeOut=5/cfexecute /cfsavecontent cfscript soa_pos=FindNoCase(SOA,dig_out,1); if (soa_pos gt 0){ soa_server=ListGetAt(dig_out,2, ); request.mod.dnsdig.status=1; } else { // name server soa not found! soa_server=; request.mod.dnsdig.status=-1; } /cfscript cfif len(soa_server) gt 0 cfsavecontent variable=request.mod.dnsdig.infopre cfexecute name=#server.dig_exe# arguments=#soa_server# #attributes.domain# axfr +multiline timeOut=5/cfexecute/pre/cfsavecontent the short explanation is SOA is the master server for a domain, u can only get the detailed info from the master server, you first get the SOA server, then u query the SOA server for the domain info is there a reason why you don't want to use custom tags??? what are u wanting to do? z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HTML2excel
Hi there, I have been using Peter Stolz's CF_HTML2EXCEL tag on CF 4.5 with great success - however on an upgrade on one of our dev boxes I am getting an error like the following: Error occured while connected to the Excel object! Error Details: An exception occurred when executing a Com method. The Error Occurred in PATH\CustomTags\HTML2Excel.cfm: line 168 Called from PATH\excelreport.cfm: line 374 Called from PATH\excelreport.cfm: line 2164 166 : objExcel.Quit(); 167 : /CFSCRIPT 168 : CFABORT SHOWERROR=FONT COLOR='RED'Error occured while connected to the Excel object!/FONTBRError Details: #CFCATCH.MESSAGE# 169 : /CFCATCH 170 :/CFTRY !--And at the bottom of the page --- Exceptions 12:31:36.036 - Object Exception - in PATH\CustomTags\HTML2Excel.cfm : line 147 An exception occurred when executing a Com method. 12:31:36.036 - Expression Exception - in PATH\CustomTags\HTML2Excel.cfm : line 168 Error occured while connected to the Excel object!Error Details: An exception occurred when executing a Com method. I understand that there are some COM problems in MX but would appreciate any ideas about this. I have tried to contact Mr Stolz directly but have not been able to get through to his email address. Cheers Simon __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML2excel
sorry - should have said upgrade to CFMX DOH!!! Simon - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:34 PM Subject: HTML2excel Hi there, I have been using Peter Stolz's CF_HTML2EXCEL tag on CF 4.5 with great success - however on an upgrade on one of our dev boxes I am getting an error like the following: Error occured while connected to the Excel object! Error Details: An exception occurred when executing a Com method. The Error Occurred in PATH\CustomTags\HTML2Excel.cfm: line 168 Called from PATH\excelreport.cfm: line 374 Called from PATH\excelreport.cfm: line 2164 166 : objExcel.Quit(); 167 : /CFSCRIPT 168 : CFABORT SHOWERROR=FONT COLOR='RED'Error occured while connected to the Excel object!/FONTBRError Details: #CFCATCH.MESSAGE# 169 : /CFCATCH 170 :/CFTRY !--And at the bottom of the page --- Exceptions 12:31:36.036 - Object Exception - in PATH\CustomTags\HTML2Excel.cfm : line 147 An exception occurred when executing a Com method. 12:31:36.036 - Expression Exception - in PATH\CustomTags\HTML2Excel.cfm : line 168 Error occured while connected to the Excel object!Error Details: An exception occurred when executing a Com method. I understand that there are some COM problems in MX but would appreciate any ideas about this. I have tried to contact Mr Stolz directly but have not been able to get through to his email address. Cheers Simon __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML2excel
Have you upgraded your CFMX install? -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 12:35 To: CF-Talk Subject: HTML2excel Hi there, I have been using Peter Stolz's CF_HTML2EXCEL tag on CF 4.5 with great success - however on an upgrade on one of our dev boxes I am getting an error like the following: Error occured while connected to the Excel object! Error Details: An exception occurred when executing a Com method. The Error Occurred in PATH\CustomTags\HTML2Excel.cfm: line 168 Called from PATH\excelreport.cfm: line 374 Called from PATH\excelreport.cfm: line 2164 166 : objExcel.Quit(); 167 : /CFSCRIPT 168 : CFABORT SHOWERROR=FONT COLOR='RED'Error occured while connected to the Excel object!/FONTBRError Details: #CFCATCH.MESSAGE# 169 : /CFCATCH 170 :/CFTRY !--And at the bottom of the page --- Exceptions 12:31:36.036 - Object Exception - in PATH\CustomTags\HTML2Excel.cfm : line 147 An exception occurred when executing a Com method. 12:31:36.036 - Expression Exception - in PATH\CustomTags\HTML2Excel.cfm : line 168 Error occured while connected to the Excel object!Error Details: An exception occurred when executing a Com method. I understand that there are some COM problems in MX but would appreciate any ideas about this. I have tried to contact Mr Stolz directly but have not been able to get through to his email address. Cheers Simon __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
I was under the impression that it used UDP by preference but will fall back to TCP if UDP is not available. -- Jay - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:23 PM Subject: RE: NSLookup both w3sockets and TCPClient to open the socket but not for love nor money ^^^ can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. DNS uses UDP doesn't it ? http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q173161; for instance. The RFC may be of help too. Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
The reason for attempting direct interaction is that the page I have here has about 200+ domains on it and it is growing every day and every custom tag I have tried can't cope with the volume. -- Jay - Original Message - From: Zac Spitzer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:34 PM Subject: Re: NSLookup James Smith wrote: Hi all. Here is a problem I have been pulling my hair out over. I want to do an NSLookup directly (ie: no custom tags if it can be avoided) and have tried both w3sockets and TCPClient to open the socket but not for love nor money can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. Can anyone point me in the correct direction? honestly the best advice here is don't re-invent the wheel.. use cfexecute and dig from sendmail/bind or maybe a java class this code using dig will give u really detailed info about dns cfsavecontent variable=dig_outcfexecute name=#server.dig_exe# arguments=#attributes.domain# +nssearch timeOut=5/cfexecute /cfsavecontent cfscript soa_pos=FindNoCase(SOA,dig_out,1); if (soa_pos gt 0){ soa_server=ListGetAt(dig_out,2, ); request.mod.dnsdig.status=1; } else { // name server soa not found! soa_server=; request.mod.dnsdig.status=-1; } /cfscript cfif len(soa_server) gt 0 cfsavecontent variable=request.mod.dnsdig.infopre cfexecute name=#server.dig_exe# arguments=@#soa_server# #attributes.domain# axfr +multiline timeOut=5/cfexecute/pre/cfsavecontent the short explanation is SOA is the master server for a domain, u can only get the detailed info from the master server, you first get the SOA server, then u query the SOA server for the domain info is there a reason why you don't want to use custom tags??? what are u wanting to do? z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NSLookup
I was under the impression that it used UDP by preference but will fall back to TCP if UDP is not available. That sounds more like it, actually :-) Either way, it's not something you want to implement yourself. Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
James Smith wrote: The reason for attempting direct interaction is that the page I have here has about 200+ domains on it and it is growing every day and every custom tag I have tried can't cope with the volume. like always, cache your results, if it's possible, most likely the results your are getting are cached in the dns server anyway.. cache to application vars or write out txt files z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
I was under the impression that it used UDP by preference UDP is used to query as long as the response packets do not have the TC = TrunCated bit set. If TC, then the DNS client queries with TCP. but will fall back to TCP if UDP is not available. afaik, TCP is not tried as fallback if UDP queries are not responding. see: http://www.networksorcery.com/enp/protocol/dns.htm you can get dig for win32 here, in the tools package: ftp://ftp.isc.org/isc/bind/contrib/ntbind-8.3.3 I'm not sure dig for win32 has the full man page, so here it is for bind8. When rolling out to dig from CF, you can limit the verbosity of the response with dig arguments: DIG(1) FreeBSD General Commands Manual DIG(1) NAME dig - send domain name query packets to name servers SYNOPSIS dig [@server] domain [query-type] [query-class] [+query-option] [-dig-option] [%comment] DESCRIPTION Dig (domain information groper) is a flexible command line tool which can be used to gather information from the Domain Name System servers. Dig has two modes: simple interactive mode for a single query, and batch mode which executes a query for each in a list of several query lines. All query options are accessible from the command line. The usual simple use of dig will take the form: dig @server domain query-type query-class where: server may be either a domain name or a raw (IPv4 / IPv6) Internet address. If this optional field is omitted, dig will attempt to use the default name server for your machine. Note: If a domain name is specified, this will be resolved using the domain name system resolver (i.e., BIND). If your system does not support DNS, you may have to specify a dot- notation address. Alternatively, if there is a server at your disposal somewhere, all that is required is that /etc/resolv.conf be present and indicate where the default name servers reside, so that server itself can be resolved. See resolver(5) for information on /etc/resolv.conf. WARNING: Changing /etc/resolv.conf will affect both the stan- dard resolver library and (potentially) several programs which use it. As an option, the user may set the environment variable LOCALRES to name a file which is to be used instead of /etc/resolv.conf (LOCALRES is specific to the dig resolver and is not referenced by the standard resolver). If the LOCALRES variable is not set or the specified file is not readable, then /etc/resolv.conf will be used. domain is the domain name for which you are requesting information. See the -x option (documented in the OTHER OPTIONS subsection of this section) for convenient way to specify reverse address query. query-type is the type of information (DNS query type) that you are requesting. If omitted, the default is ``a'' (T_A = address). The following types are recognized: a T_Anetwork address any T_ANY all/any information about specified domain mx T_MX mail exchanger for the domain ns T_NS name servers soa T_SOA zone of authority record hinfo T_HINFOhost information axfrT_AXFR zone transfer (must ask an authoritative server) txt T_TXT arbitrary number of strings (See RFC 1035 for the complete list.) query-class is the network class requested in the query. If omitted, the default is ``in'' (C_IN = Internet). The following classes are recognized: in C_IN Internet class domain any C_ANY all/any class information (See RFC 1035 for the complete list.) Note: ``Any'' can be used to specify a class and/or a type of query. Dig will parse the first occurrence of ``any'' to mean query-type = T_ANY. To specify query-class = C_ANY, you must either specify ``any'' twice, or set query-class using the -c option (see below). OTHER OPTIONS %ignored-comment ``%'' is used to included an argument that is simply not parsed. This may be useful if running dig in batch mode. Instead of resolving every @server-domain-name in a list of
JRE 1.4.1 ?
Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. CFSET SetLocale(Portuguese (Brazilian)) cfoutput#lsCurrencyFormat(977,9)#/cfoutput The output should be R$ 977,90 (note the two digits in the cents). But its bug in the JVM, not in the CFMX. People are using a UDF to solve this situation till Sun solve the bug. []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:14 AM To: CF-Talk Subject: JRE 1.4.1 ? Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
That's good news...but I've been having problems with the CFC explorer...it throws an error when attempting to introspect a CFC... That happen to you? -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:38 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. CFSET SetLocale(Portuguese (Brazilian)) cfoutput#lsCurrencyFormat(977,9)#/cfoutput The output should be R$ 977,90 (note the two digits in the cents). But its bug in the JVM, not in the CFMX. People are using a UDF to solve this situation till Sun solve the bug. []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:14 AM To: CF-Talk Subject: JRE 1.4.1 ? Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
Good question, I didn't test it yet. | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:41 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? That's good news...but I've been having problems with the CFC explorer...it throws an error when attempting to introspect a CFC... That happen to you? -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:38 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. CFSET SetLocale(Portuguese (Brazilian)) cfoutput#lsCurrencyFormat(977,9)#/cfoutput The output should be R$ 977,90 (note the two digits in the cents). But its bug in the JVM, not in the CFMX. People are using a UDF to solve this situation till Sun solve the bug. []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:14 AM To: CF-Talk Subject: JRE 1.4.1 ? Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
Hold up I just tried viewing the same CFC thru the internal web server (as opposed to Apache 2 and it works fine...HHhmmm... I've got CFIDE mapped in my conf file for Apache 2...and the administrator works fine...wondering why the explorer doesn't... Any ideas? -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:41 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? That's good news...but I've been having problems with the CFC explorer...it throws an error when attempting to introspect a CFC... That happen to you? -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:38 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. CFSET SetLocale(Portuguese (Brazilian)) cfoutput#lsCurrencyFormat(977,9)#/cfoutput The output should be R$ 977,90 (note the two digits in the cents). But its bug in the JVM, not in the CFMX. People are using a UDF to solve this situation till Sun solve the bug. []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:14 AM To: CF-Talk Subject: JRE 1.4.1 ? Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
This is the error I get when invoking the explorer from the external Apache server: -- Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. -- Here are my mappings in the conf: Alias /cfide/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory Alias /CFIDE/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:48 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? Hold up I just tried viewing the same CFC thru the internal web server (as opposed to Apache 2 and it works fine...HHhmmm... I've got CFIDE mapped in my conf file for Apache 2...and the administrator works fine...wondering why the explorer doesn't... Any ideas? -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:41 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? That's good news...but I've been having problems with the CFC explorer...it throws an error when attempting to introspect a CFC... That happen to you? -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:38 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. CFSET SetLocale(Portuguese (Brazilian)) cfoutput#lsCurrencyFormat(977,9)#/cfoutput The output should be R$ 977,90 (note the two digits in the cents). But its bug in the JVM, not in the CFMX. People are using a UDF to solve this situation till Sun solve the bug. []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:14 AM To: CF-Talk Subject: JRE 1.4.1 ? Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
Just asking the obvious here, when you made that alias, you cycled the Apache server, yes? ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: This is the error I get when invoking the explorer from the external Apache server: -- Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. -- Here are my mappings in the conf: Alias /cfide/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory Alias /CFIDE/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
I think I've seen this mentioned somewhere before...just not sure where...doing some digging... With 1.3.1 the CFC explorer works, but only on the internal web server. With 1.4.1 it doesn't work on either... Not a show stopper I guess considering it's really only used in development...just wondering if there are other side effects... Either that or I've got a config amuck somewhere... Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:04 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? This is the error I get when invoking the explorer from the external Apache server: -- Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. -- Here are my mappings in the conf: Alias /cfide/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory Alias /CFIDE/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:48 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? Hold up I just tried viewing the same CFC thru the internal web server (as opposed to Apache 2 and it works fine...HHhmmm... I've got CFIDE mapped in my conf file for Apache 2...and the administrator works fine...wondering why the explorer doesn't... Any ideas? -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:41 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? That's good news...but I've been having problems with the CFC explorer...it throws an error when attempting to introspect a CFC... That happen to you? -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:38 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. CFSET SetLocale(Portuguese (Brazilian)) cfoutput#lsCurrencyFormat(977,9)#/cfoutput The output should be R$ 977,90 (note the two digits in the cents). But its bug in the JVM, not in the CFMX. People are using a UDF to solve this situation till Sun solve the bug. []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:14 AM To: CF-Talk Subject: JRE 1.4.1 ? Has anyone been using this JRE for CFMX? Wondering if you've run into any incompatibility problems... Stace 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. 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. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ?
yep -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:13 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? Just asking the obvious here, when you made that alias, you cycled the Apache server, yes? ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: This is the error I get when invoking the explorer from the external Apache server: -- Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. -- Here are my mappings in the conf: Alias /cfide/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory Alias /CFIDE/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Attn: Stacy re: Apache aliasing
Btw, Stacy, one more thing... if you've made an alias for the CFIDE in the main part of the httpd.conf and you have multiple sub-websites (read: Mulitple NamedVirtualHosts) ... don't forget to also map CFIDE to those as well. They cannot and will not see it unless you add the alias cfdirectory to the VirtualHost directive. That being said, I'm going to put my CFIDE in the CFMX wwwroot folder and see if I can duplicate your error. ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QueryNew() Filtering Problems
I have created a query using the QueryNew and QueryAddColumn functions. My data is output correctly until I start trying to interrogate it using query of query. For Example, if I have a column called cost with the values 6000, 5, 4, 3000, 2000 and want to pull out only the records where the data is greater than 30 *THOUSAND*, I would write the following: cfquery name=qCost dbType=Query SELECT cost FROM request.MyQuery WHERE cost 3 /cfquery The recordset returned is 6000, 5, 4. It seems that the column is being treated as text rather than Numeric. The strange thing is, if I order the query by cost descending, I get 5, 4, 6000 - the correct numeric order. I know there are a few known bugs with Query of Query and was wondering if this is one of them? I have thought about taking the data and creating a temporary table in SQL Server and dumping the data in there to interrogate it properly. Does anyone know of a better solution, or even better, a fix for my code? This is an integral part of my application. Many thanks, Ryan Edgar Web Applications Developer BizNet biznet-solutions.com __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (fwd)
Stace, I just confirmed the same issue. I moved the CFIDE to the directory you have mapped below and made my aliases in Apache. I can get to the CFAdmin just fine, but I can't invoke the cfcexplorer. I was also using the jdk.1.4.1 SF (?) and I moved it back to the built in CFMX jre, same error. I moved my directory back to the Apache htdocs folder and removed the mapping and found that I can't invoke the cfcexplorer there either. Looks like that the CFMX updater broke something? ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | On Tue, 24 Sep 2002, Stacy Young wrote: This is the error I get when invoking the explorer from the external Apache server: -- Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. -- Here are my mappings in the conf: Alias /cfide/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory Alias /CFIDE/ C:/CFusionMX/wwwroot/CFIDE/ Directory C:/CFusionMX/wwwroot/CFIDE Options Indexes FollowSymlinks MultiViews AllowOverride None Order allow,deny Allow from all /Directory -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Attn: Stacy re: Apache aliasing
Hi Todd, nope not using multiple. Ok I tested with the original JRE (IBM) and it works on the Internal web server but not Apache 2. (Same result as Suns JRE 1.3.1) The CF admin works fine on all JRE's when accessing via the external Apache 2 web server. Hhmmm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:18 AM To: CF-Talk Subject: Attn: Stacy re: Apache aliasing Btw, Stacy, one more thing... if you've made an alias for the CFIDE in the main part of the httpd.conf and you have multiple sub-websites (read: Mulitple NamedVirtualHosts) ... don't forget to also map CFIDE to those as well. They cannot and will not see it unless you add the alias cfdirectory to the VirtualHost directive. That being said, I'm going to put my CFIDE in the CFMX wwwroot folder and see if I can duplicate your error. ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QueryNew() Filtering Problems
Can we see your code? I had no issues with this on either CF5 or MX. Here is the code I used: cf_querysim name=foo price name 6000foo 1 goo 2 moo /cf_querysim cfdump var=#foo# cfquery name=test dbtype=query select price fromfoo where price 7000 /cfquery cfdump var=#test# === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ryan Edgar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:18 AM To: CF-Talk Subject: QueryNew() Filtering Problems I have created a query using the QueryNew and QueryAddColumn functions. My data is output correctly until I start trying to interrogate it using query of query. For Example, if I have a column called cost with the values 6000, 5, 4, 3000, 2000 and want to pull out only the records where the data is greater than 30 *THOUSAND*, I would write the following: cfquery name=qCost dbType=Query SELECT cost FROM request.MyQuery WHERE cost 3 /cfquery The recordset returned is 6000, 5, 4. It seems that the column is being treated as text rather than Numeric. The strange thing is, if I order the query by cost descending, I get 5, 4, 6000 - the correct numeric order. I know there are a few known bugs with Query of Query and was wondering if this is one of them? I have thought about taking the data and creating a temporary table in SQL Server and dumping the data in there to interrogate it properly. Does anyone know of a better solution, or even better, a fix for my code? This is an integral part of my application. Many thanks, Ryan Edgar Web Applications Developer BizNet biznet-solutions.com __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (fwd)
Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WHYYYYY!!!!!!
What I do know is that if you don't lock memory variables in CF 5 or earlier, your server will typically crash under load, and if you consistently lock memory variables with the SCOPE attribute, your server won't crash under load. I agree that empirical testing is the way to go, but I disagree with your must lock memory variables rule. There are many applications that can avoid the use of cflock even in pre-MX days. IMHO, adding additional overhead when none is needed is foolish. Some foolishness is less foolish than other foolishness. In my defense, I'd like to point out the use of the word typically in the first paragraph above. Sure, there are exceptional cases, but I would argue that they are, in fact, exceptional cases. I've had to fix a lot of broken applications, in which the cause of the problem was the failure to lock memory variables. Given that, I'd prefer to see everyone incur a little unnecessary overhead rather than risk total system failure. Sure, if you really know what you're doing, you might be able to avoid locking in some situations, but I really think that figuring out whether you've got such a situation is more trouble than it's worth, when the overhead is pretty minimal and the cost of failure is so high. If you really know what you're doing, and you're willing to do the above-mentioned empirical testing to make sure (before letting your users do that testing for you), then whatever works for you is the right way to go. Many people using CF don't fall into both of those categories, though, and in that case, safe is better than sorry. As you've pointed out more than once, true scalability isn't a matter of code optimization, right? By the way, welcome to Atlanta! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 : dream :: design :: develop : MXDC 02 :: Join us at this all day conference for designers developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :: __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
Thanks for the help so far, I now have it working with the folowing code. cfset Address = www.microsoft.com cfset DigPath = expandpath(./BIND8.3.3Tools/dig.exe) cfset DigArgs = @192.168.2.3Address +pfmin cfsavecontent variable=Results cfexecute name=#DigPath# arguments=#DigArgs# timeout=1/cfexecute /cfsavecontent The problem is that it will take the value of the timeout to complete (give or take). With a timeout value of 1 it takes 1022 ms to complete and with a value of 10 it requires 10014 for example. This has the obvious problem that on a page of 200 domains it takes about 200 seconds to complete the page. Any idea why it isn't returning control as soon as it is finished and waiting for the timeout? -- Jay - Original Message - From: Len Conrad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:09 PM Subject: Re: NSLookup I was under the impression that it used UDP by preference UDP is used to query as long as the response packets do not have the TC = TrunCated bit set. If TC, then the DNS client queries with TCP. but will fall back to TCP if UDP is not available. afaik, TCP is not tried as fallback if UDP queries are not responding. see: http://www.networksorcery.com/enp/protocol/dns.htm you can get dig for win32 here, in the tools package: ftp://ftp.isc.org/isc/bind/contrib/ntbind-8.3.3 I'm not sure dig for win32 has the full man page, so here it is for bind8. When rolling out to dig from CF, you can limit the verbosity of the response with dig arguments: DIG(1) FreeBSD General Commands Manual DIG(1) NAME dig - send domain name query packets to name servers SYNOPSIS dig [@server] domain [query-type] [query-class] [+query-option] [-dig-option] [%comment] DESCRIPTION Dig (domain information groper) is a flexible command line tool which can be used to gather information from the Domain Name System servers. Dig has two modes: simple interactive mode for a single query, and batch mode which executes a query for each in a list of several query lines. All query options are accessible from the command line. The usual simple use of dig will take the form: dig @server domain query-type query-class where: server may be either a domain name or a raw (IPv4 / IPv6) Internet address. If this optional field is omitted, dig will attempt to use the default name server for your machine. Note: If a domain name is specified, this will be resolved using the domain name system resolver (i.e., BIND). If your system does not support DNS, you may have to specify a dot- notation address. Alternatively, if there is a server at your disposal somewhere, all that is required is that /etc/resolv.conf be present and indicate where the default name servers reside, so that server itself can be resolved. See resolver(5) for information on /etc/resolv.conf. WARNING: Changing /etc/resolv.conf will affect both the stan- dard resolver library and (potentially) several programs which use it. As an option, the user may set the environment variable LOCALRES to name a file which is to be used instead of /etc/resolv.conf (LOCALRES is specific to the dig resolver and is not referenced by the standard resolver). If the LOCALRES variable is not set or the specified file is not readable, then /etc/resolv.conf will be used. domain is the domain name for which you are requesting information. See the -x option (documented in the OTHER OPTIONS subsection of this section) for convenient way to specify reverse address query. query-type is the type of information (DNS query type) that you are requesting. If omitted, the default is ``a'' (T_A = address). The following types are recognized: a T_Anetwork address any T_ANY all/any information about specified domain mx T_MX mail exchanger for the domain ns T_NS name servers soa T_SOA zone of authority record hinfo T_HINFOhost information axfrT_AXFR zone transfer (must ask an authoritative server) txt T_TXT arbitrary number of strings (See RFC 1035 for the complete list.) query-class is the network class requested in the query. If
RE: JRE 1.4.1 ? (fwd)
I just redid my connector, no go. ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WHYYYYY!!!!!!
dave, is that, welcome to atlanta where the playa's play? :) I had to! ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:40 AM To: CF-Talk Subject: RE: WHY!! What I do know is that if you don't lock memory variables in CF 5 or earlier, your server will typically crash under load, and if you consistently lock memory variables with the SCOPE attribute, your server won't crash under load. I agree that empirical testing is the way to go, but I disagree with your must lock memory variables rule. There are many applications that can avoid the use of cflock even in pre-MX days. IMHO, adding additional overhead when none is needed is foolish. Some foolishness is less foolish than other foolishness. In my defense, I'd like to point out the use of the word typically in the first paragraph above. Sure, there are exceptional cases, but I would argue that they are, in fact, exceptional cases. I've had to fix a lot of broken applications, in which the cause of the problem was the failure to lock memory variables. Given that, I'd prefer to see everyone incur a little unnecessary overhead rather than risk total system failure. Sure, if you really know what you're doing, you might be able to avoid locking in some situations, but I really think that figuring out whether you've got such a situation is more trouble than it's worth, when the overhead is pretty minimal and the cost of failure is so high. If you really know what you're doing, and you're willing to do the above-mentioned empirical testing to make sure (before letting your users do that testing for you), then whatever works for you is the right way to go. Many people using CF don't fall into both of those categories, though, and in that case, safe is better than sorry. As you've pointed out more than once, true scalability isn't a matter of code optimization, right? By the way, welcome to Atlanta! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 : dream :: design :: develop : MXDC 02 :: Join us at this all day conference for designers developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :: __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
The reason for attempting direct interaction is that the page I have here has about 200+ domains on it and it is growing every day and every custom tag I have tried can't cope with the volume. -- Jay - Original Message - From: Zac Spitzer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:34 PM Subject: Re: NSLookup James Smith wrote: Hi all. Here is a problem I have been pulling my hair out over. I want to do an NSLookup directly (ie: no custom tags if it can be avoided) and have tried both w3sockets and TCPClient to open the socket but not for love nor money can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. Can anyone point me in the correct direction? honestly the best advice here is don't re-invent the wheel.. use cfexecute and dig from sendmail/bind or maybe a java class this code using dig will give u really detailed info about dns cfsavecontent variable=dig_outcfexecute name=#server.dig_exe# arguments=#attributes.domain# +nssearch timeOut=5/cfexecute /cfsavecontent cfscript soa_pos=FindNoCase(SOA,dig_out,1); if (soa_pos gt 0){ soa_server=ListGetAt(dig_out,2, ); request.mod.dnsdig.status=1; } else { // name server soa not found! soa_server=; request.mod.dnsdig.status=-1; } /cfscript cfif len(soa_server) gt 0 cfsavecontent variable=request.mod.dnsdig.infopre cfexecute name=#server.dig_exe# arguments=@#soa_server# #attributes.domain# axfr +multiline timeOut=5/cfexecute/pre/cfsavecontent the short explanation is SOA is the master server for a domain, u can only get the detailed info from the master server, you first get the SOA server, then u query the SOA server for the domain info is there a reason why you don't want to use custom tags??? what are u wanting to do? z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Rounding numbers in coldfusion
I am using a float datatype in the database and calculating some numbers on the page. The calculation seems to round up the numbers to the nearest integer, even when I use numberformat or decimal format. How can I prevent it doing this? Example below cfif isdefined(P90) and P90 gt 0 cfif FindNoCase(gas,#Type#) cfset P90x= #Evaluate(P90/6)# cfset totalP90=totalP90 + P90x cfelse cfset totalP90=totalP90 + P90 /cfif /cfif __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rounding numbers in coldfusion
Figured it out. Thanks anyway!! -Original Message- From: Declan Maher Sent: 24 September 2002 14:40 To: CF-Talk Subject: Rounding numbers in coldfusion I am using a float datatype in the database and calculating some numbers on the page. The calculation seems to round up the numbers to the nearest integer, even when I use numberformat or decimal format. How can I prevent it doing this? Example below cfif isdefined(P90) and P90 gt 0 cfif FindNoCase(gas,#Type#) cfset P90x= #Evaluate(P90/6)# cfset totalP90=totalP90 + P90x cfelse cfset totalP90=totalP90 + P90 /cfif /cfif __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (fwd)
If I'm not mistaken that last error I got is from Apache so it may be connector related...but to add to the puzzle the CFC explorer doesn't even work on the Internal web server running JRE 1.4.1. I'm going to reconfirm that now... Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:43 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) I just redid my connector, no go. ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (fwd)
My mistake...Internal web server works fine with 1.4.1 leading me to believe it's solely a connector issue. Stace -Original Message- From: Stacy Young Sent: Tuesday, September 24, 2002 9:47 AM To: '[EMAIL PROTECTED]' Subject: RE: JRE 1.4.1 ? (fwd) If I'm not mistaken that last error I got is from Apache so it may be connector related...but to add to the puzzle the CFC explorer doesn't even work on the Internal web server running JRE 1.4.1. I'm going to reconfirm that now... Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:43 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) I just redid my connector, no go. ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (fwd)
Reported the bug to MM. Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:50 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) My mistake...Internal web server works fine with 1.4.1 leading me to believe it's solely a connector issue. Stace -Original Message- From: Stacy Young Sent: Tuesday, September 24, 2002 9:47 AM To: '[EMAIL PROTECTED]' Subject: RE: JRE 1.4.1 ? (fwd) If I'm not mistaken that last error I got is from Apache so it may be connector related...but to add to the puzzle the CFC explorer doesn't even work on the Internal web server running JRE 1.4.1. I'm going to reconfirm that now... Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:43 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) I just redid my connector, no go. ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IIS Security
What is the disadvantage of using the native IIS directory security functionality over using a cf-based login? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Filemaker faults to win a bid for using CF
I need some strong points on the shortcomings of filemaker to win a bid to use CF. Any bright ideas? Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)7748 79 1038 Office Location: http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error sending an attachment using CFMAIL
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange threading issue, cflock?
cfloop condition=(#datediff('S', tick, now())# LT 5)/cfloop Loops like that spike to 100% cpu utilization, not a good method. You can use a tag like cfx_sleep, or the deadlock timeout, which is great on hosts that charge for cfx component installation/use. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 3:21 PM To: CF-Talk Subject: Re: Strange threading issue, cflock? On 9/23/02, jon hall penned: Using CF5, I have a database insert that I need to pause a few seconds, then select a value back out that is updated from withing the db. My code looks something like this: cfquery .../ // Insert Query cfset name = Hash(CreateUUID())/ cflock name=#name# type=readonly timeout=1 cflock name=#name# type=exclusive timeout=5 throwontimeout=No/cflock /cflock cfquery .../ // Select Query What is strange is that the second query is not executing after the cflock times out. It seems that it must be executing _before_ the cflock starts! The database usually takes about 1 second to update the field, and even if I set the timeout to 20 seconds the recordset returned always contains data that would indicate that the query didn't wait until the cflock timed out, but executed before the cflock... I'm not exactly sure if I'm reading your post correctly, but if you simply want some code to delay executing for a set amount of time, you can use a conditional loop. CFLOCK doesn't actually lock the code at that point for the timeout value. The timeout value is how long CF will wait until either throwing an error or moving on to the next section of code. In the same below, the Select query will run 5 seconds after the Code to activate database Update. cftry cflock name=mylockname timeout=10 type=exclusive throwontimeout=yes cfset tick = now() Code to activate database Update begins at CFOUTPUT#TimeFormat(tick, h:mm:ss)#/CFOUTPUTp cfloop condition=(#datediff('S', tick, now())# LT 5)/cfloop Select query runs at CFOUTPUT#TimeFormat(now(), h:mm:ss)#/CFOUTPUT /cflock cfcatch type=lock The process timed out. Try again. /cfcatch /cftry -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Security
I am pretty sure that there are Netscape issues with IIS/NT security based systems. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 14:54 To: CF-Talk Subject: IIS Security What is the disadvantage of using the native IIS directory security functionality over using a cf-based login? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error sending an attachment using CFMAIL
Can you copy and paste the error for us? :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:00:23 AM ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error sending an attachment using CFMAIL
What's the error? -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Adams, Stephen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 10:00 AM Subject: Error sending an attachment using CFMAIL ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL message resent, completed this time.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype=multipart/form-data, I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Security
the only thing I can think of is the amount of users that windows servers are allowed to have depending on your server license. (ie, 5 user license etc.) I have ran into the problem of too many users logged in when using windows security model. however, if you use cf and a database, then you can get around that :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:54 AM To: CF-Talk Subject: IIS Security What is the disadvantage of using the native IIS directory security functionality over using a cf-based login? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Security
Candace Cottrell wrote: What is the disadvantage of using the native IIS directory security functionality over using a cf-based login? you don't have so much control over the interface ( ie browser login dialogs ) and it generally more flexible via cf logins with error handling.. ie you control the flow and not with IIS HTTP status codes and then u need to configure IIS error pages etc etc z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error sending an attachment using CFMAIL
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Sorry, my clumbsy fingers sent the email before it was finished. I have sent another email with the complete error. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:04 To: CF-Talk Subject: Re: Error sending an attachment using CFMAIL What's the error? -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Adams, Stephen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 10:00 AM Subject: Error sending an attachment using CFMAIL ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Security
Robertson-Ravo, Neil (REC) wrote: I am pretty sure that there are Netscape issues with IIS/NT security based systems. only with NTLM/kerbos auth, use basic security... NTLM is not secure anyway coz it's flawed (crackable) ... if you are worried about passwords in clear text then use ssl z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Omitting certain directories using cfdirectory
I'm not sure if I am understanding you correctly. Do you mean based on the info in strSelect, when using the cfdirectory action=list, you only want to show c:\Inetpub c:\Temp c:\Windows Just clarifying :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QueryNew() Filtering Problems
Raymond Camden wrote: Can we see your code? I had no issues with this on either CF5 or MX. Here is the code I used: cf_querysim name=foo price name 6000 foo 1 goo 2 moo /cf_querysim cfdump var=#foo# cfquery name=test dbtype=query select price fromfoo where price 7000 /cfquery cfdump var=#test# order by in CF 5.0 doesn't work with QoQ's when the query is built or modified using QuerySetCell, and I found no work arounds, querying the query and then trying to query and order by with that recordset still doesn't work z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Omitting certain directories using cfdirectory
Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
Use #CFFILE.ServerFile# to get the name of the file. -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:06 AM To: CF-Talk Subject: CFMAIL message resent, completed this time. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype=multipart/form-data, I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
Try using CFFile to Upload the file to a temp directory, then attach the file to the email, send the email then delete the file... HTH -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 15:06 To: CF-Talk Subject: CFMAIL message resent, completed this time. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype=multipart/form-data, I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL message resent, completed this time.
Are you uploading the file? cfif form.file IS NOT cffile action=UPLOAD destination=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\ filefield=form.file nameconflict=OVERWRITE cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] mimeattach=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# Subject=Cheers! Type=HTML Blah blah Message goes here /cfmail cfif #form.file# IS NOT cffile action=DELETE file=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# /cfif Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Security
I'm thinking I should just try to figure out this LDAP thing. That way I dont have to give all these folks 50-11 usernames and passwords. We are on Novell, and this is an intranet setting :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:09:56 AM Robertson-Ravo, Neil (REC) wrote: I am pretty sure that there are Netscape issues with IIS/NT security based systems. only with NTLM/kerbos auth, use basic security... NTLM is not secure anyway coz it's flawed (crackable) ... if you are worried about passwords in clear text then use ssl z __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL message resent, completed this time.
How are you referencing the uploaded file? I think you have to refer to it as #cffile.serveFile# Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Adams, Stephen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 10:06 AM Subject: CFMAIL message resent, completed this time. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype=multipart/form-data, I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (OK I GIVE UP!)
I'm back on JRE 1.4.1 and now the CFC explorer is not working at all with the Internal Web Server. I've tried everything...emptying cfclasses, restarting services etc...No configuration changes have been made to the web server... I get this error for any explorer functions: Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. (that's when accessing the explorer directly) -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:58 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) Reported the bug to MM. Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:50 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) My mistake...Internal web server works fine with 1.4.1 leading me to believe it's solely a connector issue. Stace -Original Message- From: Stacy Young Sent: Tuesday, September 24, 2002 9:47 AM To: '[EMAIL PROTECTED]' Subject: RE: JRE 1.4.1 ? (fwd) If I'm not mistaken that last error I got is from Apache so it may be connector related...but to add to the puzzle the CFC explorer doesn't even work on the Internal web server running JRE 1.4.1. I'm going to reconfirm that now... Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:43 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) I just redid my connector, no go. ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QueryNew() Filtering Problems
Now that's funny. The original poster said he no issue with ordering. I have no problems ordering either, in both CF5 or CFMX. Here is a modified form of my code: FYI, querysim is using querySetCell to set data. cf_querysim name=foo price name 6000foo 1 goo 2 moo 1 zoo 999 poo /cf_querysim cfdump var=#foo# cfquery name=test dbtype=query select price fromfoo where price 7000 /cfquery cfdump var=#test# cfquery name=test2 dbtype=query select * fromfoo order by price desc /cfquery cfdump var=#test2# === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:13 AM To: CF-Talk Subject: Re: QueryNew() Filtering Problems Raymond Camden wrote: Can we see your code? I had no issues with this on either CF5 or MX. Here is the code I used: cf_querysim name=foo price name 6000foo 1 goo 2 moo /cf_querysim cfdump var=#foo# cfquery name=test dbtype=query select price fromfoo where price 7000 /cfquery cfdump var=#test# order by in CF 5.0 doesn't work with QoQ's when the query is built or modified using QuerySetCell, and I found no work arounds, querying the query and then trying to query and order by with that recordset still doesn't work z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Omitting certain directories using cfdirectory
Hi Candace, Was there a reply to my question? I don't see anything. On Tue, 24 Sep 2002 10:10:16 -0400, Candace Cottrell wrote: Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QueryNew() Filtering Problems
Ryan, It's sorting in Alpha order rather than numeric order. Querysetcell( ) will treat your col. data as a string not a number. I awlays had this issue with wddx'ing a manually created query. When I wanted it to say number6000/number it would say string6000/string Querysetcell(myquery,'cost',6000); To get around this, I've always used a Math function inside the querysetCell as in: Querysetcell(myquery,'cost',(6000 * 1)); // the Val( ) function might also work This cause the output to be correctly identified as a number rather than a string. I suspect it will do the same for you in your Q of a Q - but I don't know for certain. It's a klude - and perhaps someone knows how to set the type correctly to begin with (even though there ain't no type in cf g). -mk -Original Message- From: Ryan Edgar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:18 AM To: CF-Talk Subject: QueryNew() Filtering Problems I have created a query using the QueryNew and QueryAddColumn functions. My data is output correctly until I start trying to interrogate it using query of query. For Example, if I have a column called cost with the values 6000, 5, 4, 3000, 2000 and want to pull out only the records where the data is greater than 30 *THOUSAND*, I would write the following: cfquery name=qCost dbType=Query SELECT cost FROM request.MyQuery WHERE cost 3 /cfquery The recordset returned is 6000, 5, 4. It seems that the column is being treated as text rather than Numeric. The strange thing is, if I order the query by cost descending, I get 5, 4, 6000 - the correct numeric order. I know there are a few known bugs with Query of Query and was wondering if this is one of them? I have thought about taking the data and creating a temporary table in SQL Server and dumping the data in there to interrogate it properly. Does anyone know of a better solution, or even better, a fix for my code? This is an integral part of my application. Many thanks, Ryan Edgar Web Applications Developer BizNet biznet-solutions.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** No, I am sending the file as an attachment to a series of recipients. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:14 To: CF-Talk Subject: Re: CFMAIL message resent, completed this time. Are you uploading the file? cfif form.file IS NOT cffile action=UPLOAD destination=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\ filefield=form.file nameconflict=OVERWRITE cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] mimeattach=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# Subject=Cheers! Type=HTML Blah blah Message goes here /cfmail cfif #form.file# IS NOT cffile action=DELETE file=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# /cfif Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Omitting certain directories using cfdirectory
cfset strSelect = Inetpub,temp,WINDOWS cfdirectory action=LIST directory=c:\ name=directories/ cfoutput query=directories cfif type is dir and listfindnocase(strselect,name)#name#/cfif /cfoutput Hope this helps -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:27 AM To: CF-Talk Subject: Re: Omitting certain directories using cfdirectory Hi Candace, Was there a reply to my question? I don't see anything. On Tue, 24 Sep 2002 10:10:16 -0400, Candace Cottrell wrote: Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Omitting certain directories using cfdirectory
Just this.. I dont know how that other messge appeared. weird ! I'm not sure if I am understanding you correctly. Do you mean based on the info in strSelect, when using the cfdirectory action=list, you only want to show c:\Inetpub c:\Temp c:\Windows Just clarifying :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:27:10 AM Hi Candace, Was there a reply to my question? I don't see anything. On Tue, 24 Sep 2002 10:10:16 -0400, Candace Cottrell wrote: Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
In the future, some code would make it easier to troubleshoot the specific problem. That said, I'm not sure what you're doing wrong, but the general order of your code should be something to the effect of: 1) Use CFFILE to accept the uploaded file, as in: CFFILE ACTION=Upload FILEFIELD=File DESTINATION=C:\WinNT\Temp\ NAMECONFLICT=MakeUnique 2) Use CFMAIL to send the email, attaching the newly uploaded file, as in: CFMAIL TO=#FORM.To# FROM=[EMAIL PROTECTED] SUBJECT=#FORM.Subject# CFMAILPARAM FILE=C:\WinNT\Temp\#FILE.ServerFile# Hello. Here's the file. /CFMAIL HTH. If not, send some code along. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:06 AM To: CF-Talk Subject: CFMAIL message resent, completed this time. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype=multipart/form-data, I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Forging a web page
Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form Builder
Anyone got or know of a decent form builder for use via a browser? I want to put more power into the hands of the client :-) evil laugh/ Neil __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JRE 1.4.1 ? (OK I GIVE UP!)
Ok my bad. I had changed the root mapping in CFMX to the Apache 2 folder. Switched it back to the cfmx web root and it works fine on the Internal server. :) The original bug is still valid though. Explorer doesnot work through Apache 2. Cheers Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:25 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (OK I GIVE UP!) I'm back on JRE 1.4.1 and now the CFC explorer is not working at all with the Internal Web Server. I've tried everything...emptying cfclasses, restarting services etc...No configuration changes have been made to the web server... I get this error for any explorer functions: Component not found The component definition file for component 'CFIDE.componentutils.cfcexplorer' cannot be found on this server. (that's when accessing the explorer directly) -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:58 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) Reported the bug to MM. Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:50 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) My mistake...Internal web server works fine with 1.4.1 leading me to believe it's solely a connector issue. Stace -Original Message- From: Stacy Young Sent: Tuesday, September 24, 2002 9:47 AM To: '[EMAIL PROTECTED]' Subject: RE: JRE 1.4.1 ? (fwd) If I'm not mistaken that last error I got is from Apache so it may be connector related...but to add to the puzzle the CFC explorer doesn't even work on the Internal web server running JRE 1.4.1. I'm going to reconfirm that now... Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:43 AM To: CF-Talk Subject: RE: JRE 1.4.1 ? (fwd) I just redid my connector, no go. ~Todd On Tue, 24 Sep 2002, Stacy Young wrote: Could be. Maybe connector related? I still have my CFIDE in the original spot under the CFusionMX/wwwroot folder...but my Apache 2 root is in another location. Ok I just tried moving the Apache 2 root to C:/CFusionMX/wwwroot and still no go. - Server Error The server encountered an internal error and was unable to complete your request. Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Omitting certain directories using cfdirectory
You could draw the directory list and loop over it while checking to see if a given directory is in your list... cfoutput index=mydirectorylist cfif ListFindNoCase(mylist,mydirectorylist.name) #mydirectorylist.name# /cfif /cfoutput Or you could use #ValueList(MyDirectoryList.Name)# in combination with a UDF from www.cflib.org to remove any items which don't exist in both lists... Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Omitting certain directories using cfdirectory
Correct. On Tue, 24 Sep 2002 10:38:17 -0400, Candace Cottrell wrote: Just this.. I dont know how that other messge appeared. weird ! I'm not sure if I am understanding you correctly. Do you mean based on the info in strSelect, when using the cfdirectory action=list, you only want to show c:\Inetpub c:\Temp c:\Windows Just clarifying :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:27:10 AM Hi Candace, Was there a reply to my question? I don't see anything. On Tue, 24 Sep 2002 10:10:16 -0400, Candace Cottrell wrote: Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 6:57:51 AM Yo All, I'm not sure how to go about this. I'm using cfdirectory and cfloop to list a directory structure. This is all working great. I also have a access database where I enter in some of the directories that I'm listing. For example the directory structure for C:\ might read... Documents and Settings Inetpub My Music Program Files temp updates WINDOWS In my database I have a field called strSelect were a few or all of the above directories could be entered in. Like... strSelect = Inetpub,temp,WINDOWS I would like to read this string in from the database and based on the results display only those directories in the above list. Can this be done? If so, how. I'm not sure of the correct procedure or syntax. Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IDE for the Mac...?
I will heartily second the jEdit recommendation. Because it's Java-based, it works on many platforms. I use the same IDE at work (Windows 2k) as I do at home (TiPB). Plus, it has more source code editing features than CF Studio or any other text editor I've seen. I never got into BBEdit, but everyone I've ever known that uses it absolutely swears by it. Bill : -Original Message- : From: ColdFusion MX : Sent: 9/23/02 6:00 PM : Subject: Re: IDE for the Mac...? : : All depends on what you are used to -- : : Probably the most popular (developer) editor on the Mac is BBEdit, from Bare Bones (software : that doesn't suck): : : http://www.barebones.com/ : : Although, JEdit has got some nice features (open source) : : http://www.jedit.org : : Have I missed anything? : : HTH : : Dick __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
Right, but you still have to upload it and then delete it. See my example below :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:38:22 AM ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** No, I am sending the file as an attachment to a series of recipients. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:14 To: CF-Talk Subject: Re: CFMAIL message resent, completed this time. Are you uploading the file? cfif form.file IS NOT cffile action=UPLOAD destination=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\ filefield=form.file nameconflict=OVERWRITE cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] mimeattach=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# Subject=Cheers! Type=HTML Blah blah Message goes here /cfmail cfif #form.file# IS NOT cffile action=DELETE file=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# /cfif Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Forging a web page
In Netscape 6, click on the File menu, then click on the Edit Page option. The just edit/type any changes you want to see in the editor window. Then hit print. It couldn't be much easier. Jerry Johnson [EMAIL PROTECTED] 09/24/02 10:47AM Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Builder
I've got one that generates an add/edit/delete/search form based on a SQL Server database. The tool uses SQL Server META data to display form labels, field types, etc. If you're interested I can show you a demo. Email me off-list if you're interested. Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:44 AM To: CF-Talk Subject: Form Builder Anyone got or know of a decent form builder for use via a browser? I want to put more power into the hands of the client :-) evil laugh/ Neil __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forging a web page
Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Netscape's composer ? The 'save as complete web page' feature in most browsers and copy of Dream Weaver ? . . . etc. Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forging a web page
If you're talking about the date that is commonly displayed in the header or footer when you print a web page, it's usually as simple as changing the date/time on your computer. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:48 AM To: CF-Talk Subject: OT: Forging a web page Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WDDX Error in CFMX
I am testing on CFMX Pro box, that has code that currently works in CF 5. I am getting this error: WDDX packet parse error at line 1, column -1. Document root element is missing.. From this line: cfwddx input=#ThisTag.GeneratedContent# output=tempVar action=wddx2cfml validate=no (Note: The WDDX packet is rendered from a servlet, ie: our own wddx packet). The packet is about 40940 bytes in length. 1.) Is there a wddx length restriction? (as possible seen from CF Forums?) 2.) Or any other wddx oddities or change in definition in wddx from CFMX? Here are the top and bottom headers: wddxPacket version=1.0 header/header data struct ... /struct /data /wddxPacket Tkx, James M. Reilly GlobalSpec 350 Jordan Road Troy, NY 12180 Tel: 518.880.0200 x318 Fax: 518.880.0250 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, you're example works fine. Cheers. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:57 To: CF-Talk Subject: RE: CFMAIL message resent, completed this time. Right, but you still have to upload it and then delete it. See my example below :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:38:22 AM ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** No, I am sending the file as an attachment to a series of recipients. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:14 To: CF-Talk Subject: Re: CFMAIL message resent, completed this time. Are you uploading the file? cfif form.file IS NOT cffile action=UPLOAD destination=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\ filefield=form.file nameconflict=OVERWRITE cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] mimeattach=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# Subject=Cheers! Type=HTML Blah blah Message goes here /cfmail cfif #form.file# IS NOT cffile action=DELETE file=D:\Webserver\InetPub\wwwRoot\TEMPDOCS\#file.serverfile# /cfif Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Security
Why not give them an interface to assign their own Unique CF run UserID/PW, with a master admin function that allows one person to add, modify and delete them if needed? In one scenario we set this up for a client and because it was an Intranet, each individual had to sign up themselves cross-referencing their employeeID. At 10:15 AM 09/24/2002 -0400, you wrote: I'm thinking I should just try to figure out this LDAP thing. That way I dont have to give all these folks 50-11 usernames and passwords. We are on Novell, and this is an intranet setting :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/24/2002 10:09:56 AM Robertson-Ravo, Neil (REC) wrote: I am pretty sure that there are Netscape issues with IIS/NT security based systems. only with NTLM/kerbos auth, use basic security... NTLM is not secure anyway coz it's flawed (crackable) ... if you are worried about passwords in clear text then use ssl z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Forging a web page
In IE 6, you can just save_as HTML, it will copy everything down to your local machine (images included) and open that up in an editor. ~Todd On Tue, 24 Sep 2002, Jerry Johnson wrote: In Netscape 6, click on the File menu, then click on the Edit Page option. The just edit/type any changes you want to see in the editor window. Then hit print. It couldn't be much easier. Jerry Johnson [EMAIL PROTECTED] 09/24/02 10:47AM Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IDE for the Mac...?
I agree, BBEdit has some nice features but JEdit is infinitely more extensible, it's built in JAVA, runs anywhere and it's free. Joshua Miller [EMAIL PROTECTED] -Original Message- From: Bill Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:59 AM To: CF-Talk Subject: RE: IDE for the Mac...? I will heartily second the jEdit recommendation. Because it's Java-based, it works on many platforms. I use the same IDE at work (Windows 2k) as I do at home (TiPB). Plus, it has more source code editing features than CF Studio or any other text editor I've seen. I never got into BBEdit, but everyone I've ever known that uses it absolutely swears by it. Bill : -Original Message- : From: ColdFusion MX : Sent: 9/23/02 6:00 PM : Subject: Re: IDE for the Mac...? : : All depends on what you are used to -- : : Probably the most popular (developer) editor on the Mac is BBEdit, from Bare Bones (software : that doesn't suck): : : http://www.barebones.com/ : : Although, JEdit has got some nice features (open source) : : http://www.jedit.org : : Have I missed anything? : : HTH : : Dick __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Builder
I built one for a client but cannot share the app. I built it using Flash MX. It has drag and drop form elements and allows the user to create forms, and customize just about everything about them, on the fly...it is pretty darn cool. Wish I could share it! --Josh -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:44 AM To: CF-Talk Subject: Form Builder Anyone got or know of a decent form builder for use via a browser? I want to put more power into the hands of the client :-) evil laugh/ Neil __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Two tables same column name?
I guess that is the only way to do that. I was hoping not to have to list all the columns I needed but to use the *. Thanks any way guys :) At 09:49 AM 9/24/2002 +0100, you wrote: hi john try aliasing the value you want to pull out, there is a way which will negate the need to name all the columns you want to select, but I can't remember it off the top of my head. The code below should work, let me kow if you have any problems Mark cfquery name=getRep datasource=#session.datasource# dbserver=#session.dbserver# SELECT b.total, d.total AS second_total FROM trip_flow_breakdown b, trip_flow_data d WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = #attributes.id# AND d.wid = #attributes.wid# AND d.fid = #attributes.fid# /cfquery cfoutput#getRep.second_total#/cfoutput -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 01:21 To: CF-Talk Subject: Two tables same column name? I have a query where i join two tables. and both tables have a field which are titled the same but each table has a different value. is there a way for pulling the two different values out in cold fusion or do i have to use multiple selects?? cfquery name=getRep datasource=#session.datasource# dbserver=#session.dbserver# SELECT * FROM trip_flow_breakdown b, trip_flow_data d WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = #attributes.id# AND d.wid = #attributes.wid# AND d.fid = #attributes.fid# /cfquery the field i want to get is total but if i use cfoutput query=getRep#total#/cfoutput i only get the value of the first table in the from clause. any one have a solution? Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IDE for the Mac...?
Take a long look at BBedit. One of the programmers in the office uses it. WOW is all I can say. I wish CFstudio had 1/2 of the features. One that I find very impressive is how the Snippets work. The snippets can have vars in them like :date/time: and :selected text:. Oh, and a very cool undo find and replace feature. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Bill Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:59 AM To: CF-Talk Subject: RE: IDE for the Mac...? I will heartily second the jEdit recommendation. Because it's Java-based, it works on many platforms. I use the same IDE at work (Windows 2k) as I do at home (TiPB). Plus, it has more source code editing features than CF Studio or any other text editor I've seen. I never got into BBEdit, but everyone I've ever known that uses it absolutely swears by it. Bill : -Original Message- : From: ColdFusion MX : Sent: 9/23/02 6:00 PM : Subject: Re: IDE for the Mac...? : : All depends on what you are used to -- : : Probably the most popular (developer) editor on the Mac is BBEdit, from Bare Bones (software : that doesn't suck): : : http://www.barebones.com/ : : Although, JEdit has got some nice features (open source) : : http://www.jedit.org : : Have I missed anything? : : HTH : : Dick __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Forging a web page
Yeah, look at the source, if there's a META creator that's different than the original then you've caught him. Netscape and IE usually put some meta information about the browser/editor in the source code near the top. Look for something like: meta name=Generator ... Joshua Miller [EMAIL PROTECTED] -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 11:09 AM To: CF-Talk Subject: Re: OT: Forging a web page In Netscape 6, click on the File menu, then click on the Edit Page option. The just edit/type any changes you want to see in the editor window. Then hit print. It couldn't be much easier. Jerry Johnson [EMAIL PROTECTED] 09/24/02 10:47AM Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX Error in CFMX
there is a packet length in CF5, but you say it works in that. wierd?.. -Original Message- From: Reilly, Jim [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 16:12 To: CF-Talk Subject: WDDX Error in CFMX I am testing on CFMX Pro box, that has code that currently works in CF 5. I am getting this error: WDDX packet parse error at line 1, column -1. Document root element is missing.. From this line: cfwddx input=#ThisTag.GeneratedContent# output=tempVar action=wddx2cfml validate=no (Note: The WDDX packet is rendered from a servlet, ie: our own wddx packet). The packet is about 40940 bytes in length. 1.) Is there a wddx length restriction? (as possible seen from CF Forums?) 2.) Or any other wddx oddities or change in definition in wddx from CFMX? Here are the top and bottom headers: wddxPacket version=1.0 header/header data struct ... /struct /data /wddxPacket Tkx, James M. Reilly GlobalSpec 350 Jordan Road Troy, NY 12180 Tel: 518.880.0200 x318 Fax: 518.880.0250 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Forging a web page
Internet Explorer 5ish has a Save as, which saves the whole lot. Then there are various programs that will spider a site and grab all the files for you to have a local copy too If you're using fusebox and the date on the page is supplied via a variable in the attributes scope, then you could probably change the date by submitting a form which has a field that is the same as the variable for the date to the page. If the date is set up using cfparam and isn't checked then potentially this could provide a route to forge the display. Obviously this would require a little insider knowledge or some luck at guessing the name of the date variable, but always possible if you've named the variable sensibly! Regards Stephen - Original Message - From: Brian Fox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 3:47 PM Subject: OT: Forging a web page Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX Error in CFMX
There are two confirmed WDDX bugs that may be affecting you: 1) Does your packet contain any date time info? Any large packet with datetime info will not be deserialized. You must do a regex and replace any datetime.../datetime with string.../string This will have zero impact on your ability to use the data. 2) Does your data contain a structure with a key containing a single quote? Ie, cfset foo[ray's world]. This will not be deserializable. Also - try adding a trim around the ThisTag.generatedcontent. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Reilly, Jim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 11:12 AM To: CF-Talk Subject: WDDX Error in CFMX I am testing on CFMX Pro box, that has code that currently works in CF 5. I am getting this error: WDDX packet parse error at line 1, column -1. Document root element is missing.. From this line: cfwddx input=#ThisTag.GeneratedContent# output=tempVar action=wddx2cfml validate=no (Note: The WDDX packet is rendered from a servlet, ie: our own wddx packet). The packet is about 40940 bytes in length. 1.) Is there a wddx length restriction? (as possible seen from CF Forums?) 2.) Or any other wddx oddities or change in definition in wddx from CFMX? Here are the top and bottom headers: wddxPacket version=1.0 header/header data struct ... /struct /data /wddxPacket Tkx, James M. Reilly GlobalSpec 350 Jordan Road Troy, NY 12180 Tel: 518.880.0200 x318 Fax: 518.880.0250 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Setting cookies...followup on previous email regarding cfdirectory
Yo all, I'm setting a cookie for the users session that holds information which I query to display the directory structure based on the cookie contents. Cookie = Program Files,temp,windows In the middle of the session there is a possiblity that the user changes this by a preferences interface. I have a button selection (list of directories) that they can click on to select what they want displayed. The database is updated based on their selections. I need to clear the previous cookie and set a new cookie to the updated contents. Can I clear and reset a cookie? Is there a better way --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rounding numbers in coldfusion
can you share with the rest of us who may be interested in your soliution? -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:42 AM To: CF-Talk Subject: RE: Rounding numbers in coldfusion Figured it out. Thanks anyway!! -Original Message- From: Declan Maher Sent: 24 September 2002 14:40 To: CF-Talk Subject: Rounding numbers in coldfusion I am using a float datatype in the database and calculating some numbers on the page. The calculation seems to round up the numbers to the nearest integer, even when I use numberformat or decimal format. How can I prevent it doing this? Example below cfif isdefined(P90) and P90 gt 0 cfif FindNoCase(gas,#Type#) cfset P90x= #Evaluate(P90/6)# cfset totalP90=totalP90 + P90x cfelse cfset totalP90=totalP90 + P90 /cfif /cfif __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Forging a web page
I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. I've never found this tedious actually... If you know what you're looking for, you open the html doc ( there's only one ), hit search, type in the date you see on the page ( or some bit of text near to it ) and go straight to it. It takes less than a minute to have a forged copy. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QueryNew() Filtering Problems
Mark, Thanks for your help. I used the Val() function and this works perfectly. I wouldn't have identified that in a million years. What is strange is that the query I am using is quite large, but when I threw together a small dummy version to post to the list, it worked perfectly without Val() ! The wonders of CF5! Cheers, Ryan -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:33 To: CF-Talk Subject: RE: QueryNew() Filtering Problems Ryan, It's sorting in Alpha order rather than numeric order. Querysetcell( ) will treat your col. data as a string not a number. I awlays had this issue with wddx'ing a manually created query. When I wanted it to say number6000/number it would say string6000/string Querysetcell(myquery,'cost',6000); To get around this, I've always used a Math function inside the querysetCell as in: Querysetcell(myquery,'cost',(6000 * 1)); // the Val( ) function might also work This cause the output to be correctly identified as a number rather than a string. I suspect it will do the same for you in your Q of a Q - but I don't know for certain. It's a klude - and perhaps someone knows how to set the type correctly to begin with (even though there ain't no type in cf g). -mk -Original Message- From: Ryan Edgar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:18 AM To: CF-Talk Subject: QueryNew() Filtering Problems I have created a query using the QueryNew and QueryAddColumn functions. My data is output correctly until I start trying to interrogate it using query of query. For Example, if I have a column called cost with the values 6000, 5, 4, 3000, 2000 and want to pull out only the records where the data is greater than 30 *THOUSAND*, I would write the following: cfquery name=qCost dbType=Query SELECT cost FROM request.MyQuery WHERE cost 3 /cfquery The recordset returned is 6000, 5, 4. It seems that the column is being treated as text rather than Numeric. The strange thing is, if I order the query by cost descending, I get 5, 4, 6000 - the correct numeric order. I know there are a few known bugs with Query of Query and was wondering if this is one of them? I have thought about taking the data and creating a temporary table in SQL Server and dumping the data in there to interrogate it properly. Does anyone know of a better solution, or even better, a fix for my code? This is an integral part of my application. Many thanks, Ryan Edgar Web Applications Developer BizNet biznet-solutions.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JRE 1.4.1 ?
No problems at all. People here in Brazil are just facing a bug (it happens also in 1.3) regarding Locales. i haven't really looked yet. anything else in 1.4.1 as far as i18n? i say one item about thai numbers locale variant. ah, this is all so cool ;-) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.385 / Virus Database: 217 - Release Date: 4/9/2545 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX Error in CFMX
Raymond, 1) There is no datetime tags. 2) There are no quotes as keys, just in the values. 3) I added the Trim. Still no luck! I appreciate the help!!! You or anyone else have a thought...? Tkx, Jim Tkx, James M. Reilly GlobalSpec 350 Jordan Road Troy, NY 12180 Tel: 518.880.0200 x318 Fax: 518.880.0250 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 11:28 AM To: CF-Talk Subject: RE: WDDX Error in CFMX Importance: Low There are two confirmed WDDX bugs that may be affecting you: 1) Does your packet contain any date time info? Any large packet with datetime info will not be deserialized. You must do a regex and replace any datetime.../datetime with string.../string This will have zero impact on your ability to use the data. 2) Does your data contain a structure with a key containing a single quote? Ie, cfset foo[ray's world]. This will not be deserializable. Also - try adding a trim around the ThisTag.generatedcontent. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Reilly, Jim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 11:12 AM To: CF-Talk Subject: WDDX Error in CFMX I am testing on CFMX Pro box, that has code that currently works in CF 5. I am getting this error: WDDX packet parse error at line 1, column -1. Document root element is missing.. From this line: cfwddx input=#ThisTag.GeneratedContent# output=tempVar action=wddx2cfml validate=no (Note: The WDDX packet is rendered from a servlet, ie: our own wddx packet). The packet is about 40940 bytes in length. 1.) Is there a wddx length restriction? (as possible seen from CF Forums?) 2.) Or any other wddx oddities or change in definition in wddx from CFMX? Here are the top and bottom headers: wddxPacket version=1.0 header/header data struct ... /struct /data /wddxPacket Tkx, James M. Reilly GlobalSpec 350 Jordan Road Troy, NY 12180 Tel: 518.880.0200 x318 Fax: 518.880.0250 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Forging a web page
Well, as you said.. saving the HTML and editing it. I believe the save as function of Internet Explorer automatically copies all the images locally. I bet this is what was done. Taking a screenshot of the page and changing it in a photo editor such as Photoshop is also possible, although not necessarily the easiest thing in the world, I have seen it done. it is not much different than me scanning a Snapple cap, removing all the related Snapple logos, wiping out the text inside the cap, and adding my own text. ( I did that and I have very little Photoshop skill ). What is in the header / footer when they printed it out? Anything? Sometimes the URL is displayed. At 07:47 AM 9/24/2002 -0700, you wrote: Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists