Dawn Hilderbrand/is/kcmo is out of the office.
I will be out of the office starting 08/26/2002 and will not return until 09/03/2002. I will respond to your message when I return. 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: CF vs. ASP
Rizal Firmansyah wrote: WOW! Jochem, this is weird. First i thought the first time cfmail being executed within .cfm script, it creates an email-msg file containing all data, including attachments if any. No, just a reference to the attachment. But apparently it doesn't :( Do you know if this particular behaviour occur in CF 5? or just CFMX? This is a change in the behaviour from CF 5 to CF MX. In CF 5 it stored everything in the spooled file, including headers and attachments. Not anymore. Jochem __ 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: CF vs. ASP
Matt Liotta wrote: The problem here is that cfmail doesn't block while the file is in the spool. You are either going to need to adapt your code to support some sort of asynchronous events or use a mail library you can serialize e.g. javax.mail. Hence my comment about first figuring out how CF worked and then deciding I needed something else and figuring out how that worked. Jochem __ 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
sql problem
Greetings,
I'm always having problems with dates,
this is what I'm doing,
I'm wrapping CREATEODBCDATETIME around my date time variable,
so the date scope defaults to 1899-12-30,
CFSET
FILTERTimeFrom=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.hour,ATTRIBUTES.minu
te,00))
CFSET
FILTERTimeTo=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.hourTo,ATTRIBUTES.minu
teTo,00))
which looks like this,
{ts '1899-12-30 11:30:00'} {ts '1899-12-30 18:30:00'},
Inside proc I gave Datetime Datatype,
TimeFrom DATETIME
TimeTo DATETIME
on calling the stored proc,
CFSTOREDPROC
PROCEDURE=p_build_from_historyIDAndFilterTime
DATASOURCE=#REQUEST.dsn#
USERNAME=#REQUEST.user#
PASSWORD=#REQUEST.key#
CFPROCRESULT NAME=q_getTop1 RESULTSET=1
CFPROCPARAM DBVARNAME=customerID VALUE=#SESSION.CUSTOMERID#
CFSQLTYPE=CF_SQL_INTEGER TYPE=IN
CFPROCPARAM DBVARNAME=VehicleID VALUE=#ATTRIBUTES.CALLSIGN#
CFSQLTYPE=CF_SQL_INTEGER TYPE=IN
CFPROCPARAM DBVARNAME=Date VALUE=#ATTRIBUTES.reportDate#
CFSQLTYPE=CF_SQL_INTEGER TYPE=IN
CFPROCPARAM DBVARNAME=TimeFrom VALUE=#FILTERTimeFrom#
CFSQLTYPE=CF_SQL_DATE TYPE=IN
CFPROCPARAM DBVARNAME=TimeTo VALUE=#FILTERTimeTo#
CFSQLTYPE=CF_SQL_DATE TYPE=IN
/CFSTOREDPROC,
I get this error,
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented,
so then I tried the TIMESTAMP datatype changing from CF_SQL_DATE to
CF_SQL_TIMESTAMP,
CFPROCPARAM DBVARNAME=TimeFrom VALUE=#FILTERTimeFrom#
CFSQLTYPE=CF_SQL_TIMESTAMP TYPE=IN
CFPROCPARAM DBVARNAME=TimeTo VALUE=#FILTERTimeTo#
CFSQLTYPE=CF_SQL_TIMESTAMP TYPE=IN
and inside the proc to,
TimeFrom TIMESTAMP
TimeTo TIMESTAMP
BUT ALSO GOT [Microsoft][ODBC SQL Server Driver]Optional feature not
implemented
any ideas
__
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
CFFTP: getting 0 byte files delivered.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Windows 2000 Server, CF4.5Pro. Creating some HTML files from templates, throwing them into a temp directory, zipping them into an archive (that is in a final directory) then trying to ftp them to the current record's ftp info. I keep ending up with 0 bite files having been transferred. The final zips are fine, I've tried different files, on 3 different ftp servers. I've tried 'sleeping' before the ftp to allow for the minute possibility that it's trying to send before the zip is done. I've tried it with stop on error, and without. I've tried with passive on and without. Nothing. And of course, this is one of those, 'It was working just fine last week.', things... =) Anyone? Geo -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9a2Yf6lWSWPFnGFARAgFrAJ9Lj8p17tAMxIH1O9aKGO/ZFpDAlgCfWk8n 9J9pdYuNGgeQDPwXKjU7t3g= =Wqt4 -END PGP SIGNATURE- __ 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
Cold Fusion and Data Warehousing
I am beginning a data mart/data warehouse project where I will extract data from an Oracle database to form fact and dimension tables and then use CF to query against those tables. Before I begin, I thought I'd ask this list if anyone has ever used CF to develop a data mart or data warehouse, or if you know of a resource that I can consult to talk about possible issues in using CF versus a business intelligence tool, such as Cognos or Brio, to perform the queries and reporting. I am just getting up to speed on data mart/data warehouse terminology and processes, so I am a novice. TIA __ 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: CFPOP error
It works fine for most users but on one account I get this (useless) error massage: unknown exception condition unknown error while executing a tag. We had terrible problems with that same error not long ago, and never found a fix. I got a few suggestions from the list which didn't end up solving the problem. I got NO responses whatsoever from the Macromedia forum. None at all. Others have confirmed that they've seen the error too. Some have suggested (and it makes sense) that it has to do with the content of one or more messages on the server--that CFPOP can't handle mail sent by a particular mail program, or something like that. I've never heard any specifics, but I guess knowing the cause doesn't really help solve the problem anyhow. Our only recourse was to switch to a CFX tag, cfx_pop3, which has worked wonderfully for us. -- Owen __ 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: CFPOP error
CFPOPping into an Exchange Mailbox usually requires a special format for the username - did you know that already? Infact this applies to accessing an exchange mailbox in general via POP3. It was a MS tech article that solved the problem for me. The Username takes the form domain\NTUseraccount\ExchangeMailboxAlias The ExchangeMailboxAlias can be determined from the Exchange console. It's on the right hand side in the General tab when you view a user's properties. If you want to check if Exchange 5.5 is accepting POP requests telnet into port 110 on the exchange server and you should see a ready prompt, although individual users can be denied access via a certain protocol. You have to check the PROTOCOLS tab on the individual mailbox to check if POP is enabled for them. HTH, John. -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: 26 August 2002 21:57 To: CF-Talk Subject: CFPOP error I'm using CFPOP (CF5 on Win2K) to retrieve mail from an MS Exchange 5.5 (SP2) running on NT 4. It works fine for most users but on one account I get this (useless) error massage: unknown exception condition unknown error while executing a tag. The account is valid and the user is getting mail fine using his Outlook client, but I cannot get past this error when trying to get his mail using CFPOP. Here's the tag that throws the error: CFPOP ACTION=GETHEADERONLY NAME=Temp SERVER=mail.foo.com TIMEOUT=30 USERNAME=HisUserID PASSWORD=HisPassword This is just a plain vanilla request for mail headers and it works for all other mail accounts. I'm no Exchange admin so I don't know if there is some option somewhere that locks out POP requests or something. Any ideas? Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.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: HTML to Image
Does anyone know of a custom tag (or anything else) that can create an image based on HTML input (like CF_HTML2PDF2 but to an image)? To everyone who was asking about getting website screenshots this week, Mike took it up as a challenge today and wrote a simple cfx_url2bmp. You can download it from http://efflare.com/download/ It's completely free, and includes a readme file with instructions on use. ImageXY, another free tag I saw mentioned recently, should be out soon too. any chance of configuring the screen size or color depth? the thing is it uses the current screen config.. it would be great to make this work in 8bit for example, the resulting image and also memory usage/speed would really improve __ 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: Memo type with CFMX
Neil, Go into CFMX Administrator and edit your datasource. Check the box next to labeled -- Enable long text retrieval (CLOB). Other Neil Neil H. wrote:Are people seeing anything wrong with Memo type on CFMX? I have a customer who claimed it worked and suddenly it stopped working. The fields are just blank. Any Ideas? Thanks, Neil __ 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: CFMX CurrentRow?
None of your examples used the syntax: cfoutput query=getEmloyee #currentrow# /cfoutput That one does work, which is I believe what Sean and Watts were saying. CFLOOP is a completely different animal. - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 22, 2002 12:15 PM Subject: RE: CFMX CurrentRow? Sean, My reply was orientated more at the original post. The reason I post the question is I was wondering if maybe an unscoped currentRow variable was available to pre-CFMX versions that contained the last value of currentRow in a loop. However, I just tested this in CF4.51, CF5 and CFMX and an unscoped currentRow variable does not exist. For that matter, the all the different behaviors I tested acted the same: !-- example 1 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset currentRow = getEmployee.currentRow /cfloop cfoutput#currentRow# :: #getEmployee.currentRow#/cfoutput !-- example 2 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #getEmployee.currentRow#/cfoutput !-- example 3 (causes an error) -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #currentRow#/cfoutput In all cases the first variable contained the total number of records and the second value either was undefined or 1. -Dan -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 10:53 AM To: CF-Talk Subject: Re: CFMX CurrentRow? On Thursday, August 22, 2002, at 07:27 , Dan G. Switzer, II wrote: Out of curiosity, which syntax are you using: #currentRow# or #queryName.currentRow# I know that #queryName.currentRow# works. The latter. I wouldn't have expected the former to work - does it work in pre-MX releases? The reason I think like that is that, to me, currentRow is a pseudo-column so you shouldn't expect it to be available 'unadorned', only as part of a query-qualified reference. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: Memo type with CFMX
What exactly does 'Enable long text retrieval (CLOB)' actually do? Dave -Original Message- From: Neil Ross [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 8:05 AM To: CF-Talk Subject: Re: Memo type with CFMX Neil, Go into CFMX Administrator and edit your datasource. Check the box next to labeled -- Enable long text retrieval (CLOB). Other Neil Neil H. wrote:Are people seeing anything wrong with Memo type on CFMX? I have a customer who claimed it worked and suddenly it stopped working. The fields are just blank. Any Ideas? Thanks, Neil __ 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: CF vs. ASP
-Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Attempting to show that CF is a more rabid development platform than ASP... Petco* has low-cost clinics every two weeks. You seem to be frothing at the mouth. cf_tongueInCheek * Large pet supply chain in the U.S. __ 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: application.cfm?
Don't forget that CF will walk the directory tree upwards looking for an Application.cfm if it doesn't find one in the current directory. I don't think I've ever created a site without them, except for the very first one I did when I didn't know anything about CF. What a nightmare. -Original Message- From: Benoit Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 7:54 PM To: CF-Talk Subject: RE: application.cfm? I don't see the need for an Application.cfm file as being related to the size of the site I don't think either that there is a norm. However, I almost always find the use for an Application.cfm file (e.g. for variables that need to be defined for every or almost every page like the datasource for queries). Having global variables in the Application.cfm page will come in handy when you need ot change their value... you don't have to go through the entire site and modify all the pages one by one... this is only one example but it justifies the use of Application.cfm pages for almost any site Ben -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 1:40 PM To: CF-Talk Subject: application.cfm? Hi, When is it worth it to make an application.cfm file? Do you judge it on the size of the site or do you just build one everytime? I personally haven't seen a need for it, but I built a fairly large site in CF about 3 years ago that I might bring back which almost completely relies on CF (4.5). I'm just curious to see what the norm is. Thanks Phil __ 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: application.cfm?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] The short answer is that it's the same thing as application.cfm with one exception... application.cfm runs BEFORE all other templates but onRequestEnd.cfm runs AFTER all other templates. And, prior to CFMX, there needed to be an Application.cfm in the directory for OnRequestEnd.cfm to run. Apparently not so any longer. __ 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: application.cfm?
I generally use it for debugging information, but have in the past put cfinclude template=#footer# (the companion to cfinclude template=#header# which is in Application.cfm). Also, if you're doing stuff like moving data in and out of persistent variable scopes, that's the perfect place to put your final processing. -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 8:13 PM To: CF-Talk Subject: RE: application.cfm? Could you provide an example of why something like that would be used? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 8:06 PM To: CF-Talk Subject: Re: application.cfm? The short answer is that it's the same thing as application.cfm with one exception... application.cfm runs BEFORE all other templates but onRequestEnd.cfm runs AFTER all other templates. -Novak - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 26, 2002 4:57 PM Subject: RE: application.cfm? pardon the dumb question, but since i have never had any formal cf training, whats an onRequestEnd.cfm file do? tw -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 7:50 PM To: CF-Talk Subject: Re: application.cfm? I build one all the time, at least in the root folder of my app. Subfolders may not have their own application.cfm. Also always put in OnRequestEnd.cfm, too. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Phillip Perry [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 26 Aug 2002 19:40:26 -0400 Hi, When is it worth it to make an application.cfm file? Do you judge it on the size of the site or do you just build one everytime? I personally haven't seen a need for it, but I built a fairly large site in CF about 3 years ago that I might bring back which almost completely relies on CF (4.5). I'm just curious to see what the norm is. Thanks Phil __ 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: Recordsets for the whole site
You could put the query result in a Session or Application variable. If it's a query that needs to actually run on every page request, put it in Application.cfm. -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 8:37 PM To: CF-Talk Subject: Recordsets for the whole site I am creating my first CF-enabled online database. I am starting to find it limiting that I have to define the same recordset over and over in different pages. Is there a way of keeping the results of a recordset for use by more than a single webpage? Thanks in advance, Mitko Gerensky-Greene Make no search for water. But find thirst, And water from the very ground will burst. (A Persian mystic poet, quoted in Delight of Hearts, p. 77) The world is but one country and mankind its citizens Baha'i Faith http://www.us.bahai.org * __ 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
How to access java inner class with CFMX?
Hi, A question for java gurus. How to access java inner class with CFMX? javax.mail.internet.MimeMessage has an inner class MimeMessage.RecipientType with public static fields (TO, CC, BCC and NEWSGROUP). I would like to use MimeMessage.RecipientType.TO as a parameter for MimeMessage.addRecipient() method. I can't find a way to reference it with CFMX. This works : .. cfobject type=java name=MimeMessage class=javax.mail.internet.MimeMessage action=create .. But this don't : .. NewMimeMessage.addRecipient(MimeMessage.RecipientType.TO,ToInternetAddress); .. Error message says : coldfusion.runtime.UndefinedElementException: Element RECIPIENTTYPE.TO is undefined in MIMEMESSAGE. at coldfusion.runtime.DotResolver.resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source) Is it a limitation of CFMX? Or am I doing something wrong? Benoit PS : cfobject type=java name=MimeMessageRecipientType class=javax.mail.internet.MimeMessage.RecipientType action=create, doesn't work either because the constructor is 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: application.cfm?
-- Original Message -- from: Phillip Perry [EMAIL PROTECTED] When is it worth it to make an application.cfm file? Always. CF will search for it, all the way up the directory structure to system root. Yes, system root. It's best to put in an application.cfm (Application.cfm on 'nix systems) even if it has just a blank line. Put in an onrequestend.cfm (OnRequestEnd.cfm on 'nix systems) too, because CF will look for it in the directory it finds Application.cfm. Chris Norloff __ 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: sql problem
The optional feature not implemented message iirc occurs when sql server
receives a string instead of a datetime value ... also, afaik, a timestamp
is supposed to be a uniquely identifying variable, so you shouldn't use them
unless the plan is to use it as the or a unique id for the table... I
remember getting error messages ( maybe from Access ) that said I couldn't
have more than one timestamp column in a given table and then reading the
other info about timestamps to figure out why...
In any event, this was one of the big reasons I stopped using cfstoredproc
at the time, however, I'd be willing to bet that it will work, if you change
your input variables for the procedure to varchar(20) and then use
CONVERT(datetime,timefrom) to insert or update the date column in the
table. You should still use CreateODBCDateTime in your CF, but the
cfprocparam tag will use cf_sql_varchar instead of cf_sql_datetime ...
hth
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
Greetings,
I'm always having problems with dates,
this is what I'm doing,
I'm wrapping CREATEODBCDATETIME around my date time
variable,
so the date scope defaults to 1899-12-30,
CFSET
FILTERTimeFrom=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.ho
ur,ATTRIBUTES.minu
te,00))
CFSET
FILTERTimeTo=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.hour
To,ATTRIBUTES.minu
teTo,00))
which looks like this,
{ts '1899-12-30 11:30:00'} {ts '1899-12-30 18:30:00'},
Inside proc I gave Datetime Datatype,
TimeFrom DATETIME
TimeTo DATETIME
on calling the stored proc,
CFSTOREDPROC
PROCEDURE=p_build_from_historyIDAndFilterTime
DATASOURCE=#REQUEST.dsn#
USERNAME=#REQUEST.user#
PASSWORD=#REQUEST.key#
CFPROCRESULT NAME=q_getTop1 RESULTSET=1
CFPROCPARAM DBVARNAME=customerID
VALUE=#SESSION.CUSTOMERID#
CFSQLTYPE=CF_SQL_INTEGER TYPE=IN
CFPROCPARAM DBVARNAME=VehicleID
VALUE=#ATTRIBUTES.CALLSIGN#
CFSQLTYPE=CF_SQL_INTEGER TYPE=IN
CFPROCPARAM DBVARNAME=Date
VALUE=#ATTRIBUTES.reportDate#
CFSQLTYPE=CF_SQL_INTEGER TYPE=IN
CFPROCPARAM DBVARNAME=TimeFrom
VALUE=#FILTERTimeFrom#
CFSQLTYPE=CF_SQL_DATE TYPE=IN
CFPROCPARAM DBVARNAME=TimeTo VALUE=#FILTERTimeTo#
CFSQLTYPE=CF_SQL_DATE TYPE=IN
/CFSTOREDPROC,
I get this error,
[Microsoft][ODBC SQL Server Driver]Optional feature not
implemented,
so then I tried the TIMESTAMP datatype changing from
CF_SQL_DATE to
CF_SQL_TIMESTAMP,
CFPROCPARAM DBVARNAME=TimeFrom
VALUE=#FILTERTimeFrom#
CFSQLTYPE=CF_SQL_TIMESTAMP TYPE=IN
CFPROCPARAM DBVARNAME=TimeTo VALUE=#FILTERTimeTo#
CFSQLTYPE=CF_SQL_TIMESTAMP TYPE=IN
and inside the proc to,
TimeFrom TIMESTAMP
TimeTo TIMESTAMP
BUT ALSO GOT [Microsoft][ODBC SQL Server Driver]Optional
feature not
implemented
any ideas
__
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
__
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
cf_supercache question
I'm implementing cf_supercache on a Spectra site, but I'm finding that for my test page, pages that invoke cf_supercache tag actually take LONGER to process (50ms or so, but it's still longer) than on the same page without cf_supercache. I'm calling it thusly on my page (not in the application.cfm, since I want to have page-by-page control over it): cf_supercache StripWhitespace=true Page code here /cf_supercache On a dynamic page (just calling #now()# to get a new timestamp), it really doesn't seem to be caching the page, since the timestamp changes with each refresh of the page. It does a great job of stripping whitespace, which will be nice whenever cfa_contentobjectgetmultiple gets called. Am I missing something? Do any of you who have used cf_supercache have any tips or implementation methodologies that you could pass on? Thanks Pete __ 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: CF vs. ASP
Ok, I think it's time for me to toss in my 2 cents (.75 cents Canadian). I am replying now, because most of this discussion took place after I went home yesterday. Truth is, I am an ASP developer. I have been for quite some time. I have been developing ASP since version 1.0 and have written some Big, Bad A** apps out there being used by some Fortune 500 firms (Not UPS mind you). I first learned CF in College (part of an internet development class covering CF, Java and other things). I thought it was a shame we didn't learn any ASP, so I approached my professor about it. I explained to him that I knew I was a proficient programmer (he knew as well from previous classes) and asked if I could do our database project in ASP instead of Cold Fusion. When each class got up to explain their code, it was pretty my the same, cfloop here, cfquery there... I got up and showed the ASP code off and the quicker response time (this was in the days of ASP 2.0 vs. CF 2.0, the book we used was BF's Web application Construction Kit 2nd Ed.) I was sold on ASP from that day forward and vowed never to use CF again. I started my own business and things went well for a while. Then I had a major collapse in the market I was trying to sell in and needed to find a steady job while still doing after hours work. UPS offered me a job as a Systems Management Engineer. When I started I wondered, Why did they hire me? I'm an MCSE, MCT and a lot of other TLA's and FLA's. But I had no experience in Tivoli and very little in Cold Fusion. Now, 7 months later, I consider myself very good in Cold Fusion and still learning Tivoli (my project is in web interfaces to Tivoli). In fact, I just finished a major component using CF. Having some perspective on the matter, I still think I like ASP a little better, but that's my opinion. I consider myself almost a VB expert (working on some articles for various M$ programming Mags.), so I like the granularity of ASP. If I had the tools of ASP and CF at my disposal (ASP is banned at UPS), I'd have to look at my situation. If I need something quick and easy and not a lot of fine control, I'd do it in CF easily. If I have more time and need finer control of details, I'd do it in ASP. I have found that most, if not everything that I can do in ASP, I can do in CF. In fact, I'm pushing my team to buy CF 5 or MX and get me out from the heel of CF 4.0. I think I misjudged CF some years ago, but that was when CF didn't look that good to me. (In fact, I'm working on some ideas of Fusebox for ASP.Net myself) One last thing to add to my rant. I think the code on sending e-mail was very skewed. To someone that doesn't know CF very well, it looks like it takes 25+ lines to do what CF does in 1. The code should have been more a comparison as follows: Set MyMail = CreateObject(CDONTS.NewMail) MyMail.From = [EMAIL PROTECTED] MyMail.To = [EMAIL PROTECTED] MyMail.Subject = Information Request MyMail.BodyFormat = 1 'plain text MyMail.MailFormat = 1 'plain text MyMail.Body = MsgText MyMail.Send Set MyMail = Nothing cfmail to= from= server= subject=some stuff here./cfmail That some stuff here encompasses a lot of code to make the body of the e-mail when comparing the two. (*Any opinions expressed are mine and mine alone, they do not reflect those of my employers) Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 11:28 PM To: CF-Talk Subject: Re: CF vs. ASP Matt I think the problem is that the alternative being discussed is from MSoft and the natural reaction is to barf if something is being shoved down your throat -- common sense and merits adide! Dick On Monday, August 26, 2002, at 06:20 PM, Matt Liotta wrote: People on this list are amazing. I haven't pointed out anything that is wrong with CF in this thread. I have simply pointed out that sometimes other solutions are better, which is far from hating CF. __ 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: CFMX CurrentRow?
Patti, My point was the same as Sean's and that the currentRow is only available while iterating over some type of CF query object (via cfoutput or cfloop.) You can't expect currentRow to equal the last row accessed after looping through a collection, unless you're actually declaring a variable called currentRow in the variables scope. -Dan -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 8:08 AM To: CF-Talk Subject: Re: CFMX CurrentRow? None of your examples used the syntax: cfoutput query=getEmloyee #currentrow# /cfoutput That one does work, which is I believe what Sean and Watts were saying. CFLOOP is a completely different animal. - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 22, 2002 12:15 PM Subject: RE: CFMX CurrentRow? Sean, My reply was orientated more at the original post. The reason I post the question is I was wondering if maybe an unscoped currentRow variable was available to pre-CFMX versions that contained the last value of currentRow in a loop. However, I just tested this in CF4.51, CF5 and CFMX and an unscoped currentRow variable does not exist. For that matter, the all the different behaviors I tested acted the same: !-- example 1 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset currentRow = getEmployee.currentRow /cfloop cfoutput#currentRow# :: #getEmployee.currentRow#/cfoutput !-- example 2 -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #getEmployee.currentRow#/cfoutput !-- example 3 (causes an error) -- cfquery name=getEmployee datasource=cfsnippets SELECT * FROM Employees /cfquery cfloop query=getEmployee cfset iTmp = currentRow /cfloop cfoutput#iTmp# :: #currentRow#/cfoutput In all cases the first variable contained the total number of records and the second value either was undefined or 1. -Dan -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 10:53 AM To: CF-Talk Subject: Re: CFMX CurrentRow? On Thursday, August 22, 2002, at 07:27 , Dan G. Switzer, II wrote: Out of curiosity, which syntax are you using: #currentRow# or #queryName.currentRow# I know that #queryName.currentRow# works. The latter. I wouldn't have expected the former to work - does it work in pre-MX releases? The reason I think like that is that, to me, currentRow is a pseudo-column so you shouldn't expect it to be available 'unadorned', only as part of a query-qualified reference. If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: CF vs. ASP
I know the whole CF and why people are using it issue has been hashed out quite a bit but I would like to add my two cents coming from a different background than most web developers. I started my programmer career with C. In C you have absolute control over everything going on in your program. You have a veritable dictatorship over what your program is doing. Yes the code takes longer to write and it is more prone to errors due to some of that very control you have. Most programmers have a hard time with some of the concepts in C (Pointers, Memory Allocation). Next I found C++ and ColdFusion practically at the same time. From day one I knew ColdFusion was a good tool. After working for about a year building web applications I knew ColdFusion was a *great* tool for building most web applications. This is in the 2.0 days, so keep that in mind. I already wanted to do things CF simply could not do, or did not do the way a project needed them to. When I had to I fell back on my C programming skills to create a CFX tag to give me the control I needed over my environment to accomplish my job. It is not CFs fault, it was just not equipped with the appropriate tools built-in, that is all. I did not curse CF. By then I understood very well what CF could and could not do. I did not expect it to do more than it should. For as long as I can remember there have been behaviors and functionalities in CF that did not do everything the way I needed for a particular task. Trying to *GET* CF to emulate the behavior or functionality would take more time and be less appropriate than just using the right language. (Usually C since there were not a ton of options in the 2.0 days). I have been doing CF since the 2.0 days and there are *STILL* things in CF that you simply need to have more control over. CF might do 99% of your job and it is the natural pick for a moderately complex web app or as a presentation layer for practically any web app. There might be this one piece of functionality that is not working right, and with the proper skill set and toolset you can make it work right in less time than you can use the wrong tool (CF) to finish up that one last bit of functionality. This is all Matt has been saying, there are times when you *NEED* the control. Saying that anything can be done given the time and money seems a little asinine to me. How much time? What about deadlines? Give me a unlimited resources and 2 or 3 years and I can assemble a team to build almost any web app too. The point is most of us don't have unlimited time, or money, so we all want to be as efficient is possible. The right tools in the right situation make that possible. When CF *IS* the only tool considered Jeremy __ 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: Way Off Topic - Need help sending email with ASP
So is there any hope in an Other Technologies for CFer's? list Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 5:15 PM To: CF-Talk Subject: RE: Way Off Topic - Need help sending email with ASP How about just an Other Technologies for CFers mailing list. Maybe CF-I don't wanna, but I have ta? I use CF at the day job, but my side jobs so far have been in ASP, PHP and ActionScript. Programming skills take you 80% of the way, an ability to RTFM takes you about 15% of the way farther, but sometimes the idiosyncrasies of the language are a pain to figure out. Would be nice to ask questions of the CF group with all of its expertise, without being too far OT. Dan -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 1:50 PM To: CF-Talk Subject: RE: Way Off Topic - Need help sending email with ASP What about also a PHP list, I am looking to maybe get into that, unless someone can point to groups that are already out there that are better. It may be good to have these lists on this site though since just about all of us come from a CF background looking to get into another language. The people on the lists here may be more forgiving than ones that are on experienced lists. Just a thought though. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:38 PM To: CF-Talk Subject: RE: Way Off Topic - Need help sending email with ASP Sorry I can't answer your question, but I was just wishing for the same thing: a House of Fusion ASP mailing list. I've spent the entire day trying to figure out how to get a simply query to work, and I come from a Computer Science background. I understand OOP just fine, it's just that there are SO MANY CLASSES. I've joined a number of ASP-specific mailing lists, it's just that none seem to be as active or well-run as this one. Michael Dinowitz, do you think it's possible to start up an ASP-for-CFer's? I would be on it SO quick. Anybody else want to comment on this? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: James Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:23 PM To: CF-Talk Subject: Way Off Topic - Need help sending email with ASP Hi, I know this is way off topic, but really need some help quickly. I can do this easily with CF, but ASP is a way different beast. Has anyone had any experience sending email via ASP/VBScript? I can format the mail headers, to, from, subject, and, can send the mail, but can't get a variable containing a string of other info to show up in the subject. I know the CDONTS mailer is working, or else no mail would be sent or received. I can't debug this in Dreamweaver, as there's no JavaScript. I can't easily figure out how to debug HTML/ASP code in Visual Studio .NET. Here's the code: Dim MyMail Dim MsgText Set MsgText = Request.Form(FirstName) + + Request.Form(LastName) + has requested more information. Set MsgText = MsgText + Please contact them at + Request.Form(Phone) Set MsgText = MsgText + VBCrLf Set MsgText = MsgText + Request.Form(FirstName) + VBCrLf Set MsgText = MsgText + Request.Form(LastName) + VBCrLf Set MsgText = MsgText + Request.Form(Addr1) + VBCrLf Set MsgText = MsgText + Request.Form(Addr2) + VBCrLf Set MsgText = MsgText + Request.Form(City) + VBCrLf Set MsgText = MsgText + Request.Form(State) + VBCrLf Set MsgText = MsgText + Request.Form(ZIP) + VBCrLf Set MsgText = MsgText + Request.Form(Email) + VBCrLf Set MsgText = MsgText + Request.Form(Phone) + VBCrLf Set MsgText = MsgText + Request.Form(Comments) + VBCrLf Set MsgText = MsgText + Request.Form(NoMkt) + VBCrLf Set MyMail = CreateObject(CDONTS.NewMail) MyMail.From = [EMAIL PROTECTED] MyMail.To = [EMAIL PROTECTED] MyMail.Subject = Information Request MyMail.BodyFormat = 1 'plain text MyMail.MailFormat = 1 'plain text MyMail.Body = MsgText MyMail.Send Set MyMail = Nothing Again, sorry for the off topic, but if there was a House of ASP mailing list :) Thanks, *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [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:
RE: Problem with CFMX ADV Sec and Browse Server applets
Hi, Browse Server seems to work with sandbox security turned on, in my instance of CFMX. Can you be more specific as to which folder you secured and your sandbox settings? Thanks Kumaran -Original Message- From: Brian Mitter [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 5:38 PM To: CF-Talk Subject: Problem with CFMX ADV Sec and Browse Server applets Hi, I'm having a problem with CFMX Ent, Advanced Security and the Browse Server applets. I have turned on Advanced Security and successfully configured a sandbox which works fine, however when I use the Browse Server button and the subsequent applet that allows me to select folders, it hangs with a retrieving initial directories... message. The normal list of drives does not appear. However, I have discovered that if I turn OFF the Advanced Security it will allow me to use the Browse Server applet as normal. Does anyone know why this is happening and if there's any kind of fix for it? Turning Advanced Security OFF every time I want to add a new sandbox isn't really a solution surely? Cheers Brian --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 21/08/2002 __ 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
Issue: HTML to PDF to CFMAIL
To All CF People: Issue: HTML to PDF to CFMAIL It's a long shot but I'm going to ask anyway. I'm using a tag I found on the macromedia website CF_HTML2PDF3. It takes my HTML page and converts it to a PDF file on the local server. I wanted to know if anyone knows a way that after the file is generated a pop up window using a CFMAIL form with the attached PDF that was just created can happen and then allow the user to email it to whomever they want. Then once they click send it will delete the PDF off my server. Any Help, Any Help would be greatly appreciated! Regards, James Blaha 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
Verity Performance
Hi, I went over the install and INI files over and over but I still find K2 to be as slow as VDK. It's taking 5 seconds to return results from 1 collection. We have 72 collections running. The k2 Service is using about 149M. The box is a dual PIII 1G with 1G RAM. 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
RE: Other Technologies for CFers (was: Way Off Topic - Need help sending email with ASP)
I think that would be a great idea. No way I'll get exposed to [insert alternative web technology here] in my current day job but I do want to start expanding my horizons. From: Matthew R. Small [mailto:[EMAIL PROTECTED]] So is there any hope in an Other Technologies for CFer's? list __ 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: CF vs. ASP
- Original Message - From: Matt Liotta [EMAIL PROTECTED] People on this list are amazing. I haven't pointed out anything that is wrong with CF in this thread. I have simply pointed out that sometimes other solutions are better, which is far from hating CF. --- Not got through all this thread yet, but I just have to point out: People on this list? Excuse me! A little ironic that you're trying to respond to someone who's distorting your views with sweeping generalisations. It'd help the argument if you were a little less sweeping with the comeback! ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Macromedia and CGI
Thanks, Sean. Just curious :) -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 7:01 PM To: CF-Talk Subject: Re: Macromedia and CGI On Monday, August 26, 2002, at 08:33 , Matt Liotta wrote: Macromedia has their current web site in operation before the purchase of Allaire, which is why most of it is done in BroadVision. The entire site is being redone with CFMX as we speak. Depends what you mean by most... We have about 20,000 static pages (HTML) , some applications built with BroadVision (online store, membership, exchanges - other than CF/JRun, showcase...) and then we have the former-Allaire systems (basic CF-driven content, devex, webforums, partners extranet, training registration system). We went through a big integration back in January to merge all of these into one domain and (mostly) one look and feel. And, yes, there's some legacy CGI code in amongst all of that. Since the site merge, we've launched a new user groups application in CF and a tip submission application (in CF). And, as Matt says, we're currently rewriting the entire site on the MX platform. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: Recordsets for the whole site
Or store the recordset in an application scope variable. If you're using CF5 then you could use query or queries to save on DB hits. John. -Original Message- From: Pablo Varando [mailto:[EMAIL PROTECTED]] Sent: 27 August 2002 01:52 To: CF-Talk Subject: Re: Recordsets for the whole site Try including a single page? Or maybe creating a custom tag that will do the required tasks and spit out the required recordsets to use in the application. That's probably the best way to do it. Not to mention that when you need to modify things, it's just one page :) Just in idea :) Pablo Varando http://www.cfpablo.com http://www.easycfm.com - Original Message - From: Mitko Gerensky-Greene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 26, 2002 5:37 PM Subject: Recordsets for the whole site I am creating my first CF-enabled online database. I am starting to find it limiting that I have to define the same recordset over and over in different pages. Is there a way of keeping the results of a recordset for use by more than a single webpage? Thanks in advance, Mitko Gerensky-Greene Make no search for water. But find thirst, And water from the very ground will burst. (A Persian mystic poet, quoted in Delight of Hearts, p. 77) The world is but one country and mankind its citizens Baha'i Faith http://www.us.bahai.org * __ 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 help
Can someone lend a hand off-list with a problem I'm having? Regular Expressions are not my strong suit and I could use a little hand-holding. Don't want to clutter the list, though. Thanks in advance -- Al Everett __ 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
strange error
Hello, all. I have a page that is hanging the CFAS. It is a rather simple file. It includes a template that does some playing with text, but nothing too fancy. The only fancy stuff (database interaction, session variable manipulation, cookie checking) that the page does is in the Application.cfm. Twice in the past day, this file has caused the CFAS to hang. In the server logs before the hang, we find this message repeatedly, where the listed file (not actually myfilename, of course) is the template I'm blaming for this: Warning,21,08/27/02,06:15:37,,Template: /mypath/myfilename.cfm, Ran: 66 seconds. There are also versions showing 20 and 21 as the second parameter listed. The file is large (250K), but I don't understand why that would cause such an error. Could it be that the database-interactions at the top of the page (through the included Application.cfm), start, hold up the database connection, and then stay holding it up while the rest of the page loads, causing a general system hang? Sorry if that's idiotic blather: I'm grasping at straws. Any help at all would be tremendously appreciated. Thanks, Matthieu __ 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: Verity Performance
I went over the install and INI files over and over but I still find K2 to be as slow as VDK. It's taking 5 seconds to return results from 1 collection. We have 72 collections running. The k2 Service is using about 149M. The box is a dual PIII 1G with 1G RAM. Any Ideas? What's the performance like if you only have the one collection on the server instead of 72?? It may be that you're over stressing the cut down version of verity too much with that number of collections and the number of records in each of those collections. If you find that you get a rapid response when you only have one collection, then it looks like you could do with a stand-alone server, probably with a full version of verity installed on it, to handle that quantity of collections and records. Stephen __ 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: Recordsets for the whole site
Or store the recordset in an application scope variable. If you're using CF5 then you could use query or queries to save on DB hits. Sick puppy.. ;o) Don't be using Query of Query unless the data is coming from seperate datasources! Right your queries efficiently and properly in the first place and cache them appropriately! Picking up a cached query is no slower than picking up a query from an application variable. Stephen __ 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: CF vs. ASP
Which also proves my point. Thank you. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 3:07 AM To: CF-Talk Subject: Re: CF vs. ASP Matt Liotta wrote: The problem here is that cfmail doesn't block while the file is in the spool. You are either going to need to adapt your code to support some sort of asynchronous events or use a mail library you can serialize e.g. javax.mail. Hence my comment about first figuring out how CF worked and then deciding I needed something else and figuring out how that worked. Jochem __ 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: Problem with CFMX ADV Sec and Browse Server applets
Kumaran Nallore wrote: Hi, Browse Server seems to work with sandbox security turned on, in my instance of CFMX. Can you be more specific as to which folder you secured and your sandbox settings? Did you by accident remove the sandbox for the administrator? The administartor directory should have a sandbox that enables ALL options. I did this myself once, and I can tell you, it isn't nice trying to restore it :) Jesse __ 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: CF vs. ASP
Sorry, I seem to generate a good deal of offlist email that I factor into my responses. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 6:54 AM To: CF-Talk Subject: Re: CF vs. ASP - Original Message - From: Matt Liotta [EMAIL PROTECTED] People on this list are amazing. I haven't pointed out anything that is wrong with CF in this thread. I have simply pointed out that sometimes other solutions are better, which is far from hating CF. --- Not got through all this thread yet, but I just have to point out: People on this list? Excuse me! A little ironic that you're trying to respond to someone who's distorting your views with sweeping generalisations. It'd help the argument if you were a little less sweeping with the comeback! ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Recordsets for the whole site
Message received and understood ;) -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 27 August 2002 15:17 To: CF-Talk Subject: Re: Recordsets for the whole site Or store the recordset in an application scope variable. If you're using CF5 then you could use query or queries to save on DB hits. Sick puppy.. ;o) Don't be using Query of Query unless the data is coming from seperate datasources! Right your queries efficiently and properly in the first place and cache them appropriately! Picking up a cached query is no slower than picking up a query from an application variable. Stephen __ 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: CF vs. ASP
Knew this was going to be a big thread... __ 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
application.cfm in templates directory?
Let's say that I accidentally put an Application.cfm file in my /Templates directory. Would that Application.cfm be included at the top of every template CFINCLUDEd from that directory? Thanks, Matthieu Pfizer Information Center __ 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: isDefined question
And multiple select lists / listboxes with nothing selected ... and submit buttons that have not been pressed. - Original Message - isDefined(variableName) and Len(variableName) are used in different contexts. All form values are defined except checkboxes without any data. And radio buttons, don't forget those. :) Isaac Certified Advanced ColdFusion 5 Developer __ 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: application.cfm in templates directory?
oi Matthieu!! don't believe so.only if they were called from that dir as a normal page... could be wrong.who knows. - Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Tuesday, August 27, 2002, 10:29:49 AM, you wrote: CM Let's say that I accidentally put an Application.cfm file in my /Templates CM directory. Would that Application.cfm be included at the top of every CM template CFINCLUDEd from that directory? CM Thanks, CM Matthieu CM Pfizer Information Center CM __ 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: application.cfm in templates directory?
directory. Would that Application.cfm be included at the top of every template CFINCLUDEd from that directory? Yep. -Craig __ 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: CF vs. ASP
- Original Message - From: Jacob [EMAIL PROTECTED] Knew this was going to be a big thread... --- How about CFvsASP-Talk !! ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: strange error
Actually, I'd love to get an idea of what would even cause the CFAS to hang. Even if it doesn't seem related: what would be so serious an error as to cause it to hang, rather than referring to the site's error template? Thanks, Matthieu -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 10:12 AM To: CF-Talk Subject: strange error Hello, all. I have a page that is hanging the CFAS. It is a rather simple file. It includes a template that does some playing with text, but nothing too fancy. The only fancy stuff (database interaction, session variable manipulation, cookie checking) that the page does is in the Application.cfm. Twice in the past day, this file has caused the CFAS to hang. In the server logs before the hang, we find this message repeatedly, where the listed file (not actually myfilename, of course) is the template I'm blaming for this: Warning,21,08/27/02,06:15:37,,Template: /mypath/myfilename.cfm, Ran: 66 seconds. There are also versions showing 20 and 21 as the second parameter listed. The file is large (250K), but I don't understand why that would cause such an error. Could it be that the database-interactions at the top of the page (through the included Application.cfm), start, hold up the database connection, and then stay holding it up while the rest of the page loads, causing a general system hang? Sorry if that's idiotic blather: I'm grasping at straws. Any help at all would be tremendously appreciated. Thanks, Matthieu __ 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
HTMLDoc on CFMX
Anyone else having problems with CFHTML2PDF tag which uses HTMLDOC.EXE on MX? I'm getting a timeout from ghtmldoc.exe. Thanks __ 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: application.cfm in templates directory?
No. An Application.cfm template won't be executed against an include if the include is called into a different directory. Because (you might say) an include is actually written into the cf script at the point it is included. It's not executed in the directory it resided. Dave Tuesday, August 27, 2002, 10:29:49 AM, you wrote: CM Let's say that I accidentally put an Application.cfm file in my /Templates CM directory. Would that Application.cfm be included at the top of every CM template CFINCLUDEd from that directory? CM Thanks, CM Matthieu CM Pfizer Information Center CM __ 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: application.cfm in templates directory?
Wrong. Try it yourself /Application.cfm /test.cfm -- include test_folder/test.cfm /test_folder/Application.cfm -- Output something here /test_folder/test.cfm -- output something here The only Application.cfm running in this case is the /Application.cfm -- This way, if you had a bunch of pages you wanted to protect from public browsing under /test_folder/ you could. ~Todd directory. Would that Application.cfm be included at the top of every template CFINCLUDEd from that directory? Yep. -Craig -- 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
Microsoft Binary File Format
Does anyone know where to get the Microsoft binary file format converter for Word? I sent an email to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] and in typical Microsoft fashion, they are slow. I am converting pieces of word documents for storage into a SQL database. The text has to preserver formatting and tables, otherwise I would store it as regular text. Ronald Winn Application Development Manager Cingular Wireless 678.418.4402.Voice 404.216.5205.Cell [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] When you follow your faith... doors will open where you would not have thought there would be doors; and where there wouldn't be a door for anyone else. __ 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: RE help
http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=21 The subscribe works from there. there is a new HOF list cf-regex not sure the address to send totry that? mikey? can u chime in with the address to send tolets get that list rolling, I know, there are a lot of people, me included who are clueless when it comes to those. and that list hasn't seen any traffic ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 10:16 AM To: CF-Talk Subject: RE help Can someone lend a hand off-list with a problem I'm having? Regular Expressions are not my strong suit and I could use a little hand-holding. Don't want to clutter the list, though. Thanks in advance -- Al Everett __ 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: Microsoft Binary File Format
The only thing I could do was install Office on the server and use com object to convert it to html. It makes it into Microsoft safe HTML, so don't even think of letting other browsers see it. It will change all the pictures to png, comes out pretty functional, looks pretty much like the old text. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Winn, Ron [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 10:52 AM To: CF-Talk Subject: Microsoft Binary File Format Does anyone know where to get the Microsoft binary file format converter for Word? I sent an email to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] and in typical Microsoft fashion, they are slow. I am converting pieces of word documents for storage into a SQL database. The text has to preserver formatting and tables, otherwise I would store it as regular text. Ronald Winn Application Development Manager Cingular Wireless 678.418.4402.Voice 404.216.5205.Cell [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] When you follow your faith... doors will open where you would not have thought there would be doors; and where there wouldn't be a door for anyone else. __ 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: CF vs. ASP
Very well said... use appropriate tool for the situation... you can develop a web application in C++/Javathey are great tools but aimed to broad spectrum programming not RAD/Web... as in the case what the industry demands. CF was developed as web application tool and does a great job for most things that are related to web application development. ASP was just an extention of IIS to start with and has progressed to .NET/aspx.. good... but not strictly targetted to Web RAD and not portable. Joe - Original Message - From: Jeremy Allen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 9:31 AM Subject: RE: CF vs. ASP I know the whole CF and why people are using it issue has been hashed out quite a bit but I would like to add my two cents coming from a different background than most web developers. I started my programmer career with C. In C you have absolute control over everything going on in your program. You have a veritable dictatorship over what your program is doing. Yes the code takes longer to write and it is more prone to errors due to some of that very control you have. Most programmers have a hard time with some of the concepts in C (Pointers, Memory Allocation). Next I found C++ and ColdFusion practically at the same time. From day one I knew ColdFusion was a good tool. After working for about a year building web applications I knew ColdFusion was a *great* tool for building most web applications. This is in the 2.0 days, so keep that in mind. I already wanted to do things CF simply could not do, or did not do the way a project needed them to. When I had to I fell back on my C programming skills to create a CFX tag to give me the control I needed over my environment to accomplish my job. It is not CFs fault, it was just not equipped with the appropriate tools built-in, that is all. I did not curse CF. By then I understood very well what CF could and could not do. I did not expect it to do more than it should. For as long as I can remember there have been behaviors and functionalities in CF that did not do everything the way I needed for a particular task. Trying to *GET* CF to emulate the behavior or functionality would take more time and be less appropriate than just using the right language. (Usually C since there were not a ton of options in the 2.0 days). I have been doing CF since the 2.0 days and there are *STILL* things in CF that you simply need to have more control over. CF might do 99% of your job and it is the natural pick for a moderately complex web app or as a presentation layer for practically any web app. There might be this one piece of functionality that is not working right, and with the proper skill set and toolset you can make it work right in less time than you can use the wrong tool (CF) to finish up that one last bit of functionality. This is all Matt has been saying, there are times when you *NEED* the control. Saying that anything can be done given the time and money seems a little asinine to me. How much time? What about deadlines? Give me a unlimited resources and 2 or 3 years and I can assemble a team to build almost any web app too. The point is most of us don't have unlimited time, or money, so we all want to be as efficient is possible. The right tools in the right situation make that possible. When CF *IS* the only tool considered Jeremy __ 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: Verity Performance
I tried it with one collection and it's very fast. I wondering if doubling the RAM would help? - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 10:14 AM Subject: Re: Verity Performance I went over the install and INI files over and over but I still find K2 to be as slow as VDK. It's taking 5 seconds to return results from 1 collection. We have 72 collections running. The k2 Service is using about 149M. The box is a dual PIII 1G with 1G RAM. Any Ideas? What's the performance like if you only have the one collection on the server instead of 72?? It may be that you're over stressing the cut down version of verity too much with that number of collections and the number of records in each of those collections. If you find that you get a rapid response when you only have one collection, then it looks like you could do with a stand-alone server, probably with a full version of verity installed on it, to handle that quantity of collections and records. Stephen __ 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
cfhttp server config help...
I have a page that uses the cfhttp tag. It works fine on our production server when performing a basic get function and then outputting the cfhttp.filecontent var. I can't get the same page to work on our development server. What kind of settings should I be looking at and where are they located? I keep getting Connection Failure. TIA, - Gary __ 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: Verity Performance
I tried it with one collection and it's very fast. I wondering if doubling the RAM would help? ~shrug~ What's the memory usage like?? If you're running low then maybe it would be worth a try. Otherwise, you've already got a gig in there, so if memory usage is fine then adding more won't make any difference My only other thoughts are : If you're running a large number of web sites each with multiple collections, then maybe its time you thought about investing in multiple boxes. If you've only got a couple of sites on that box, then you need to look at how you're using the collections to index your data/information and see if you can rationalise the collections to reduce the number down from 72. Other than that - I think you're looking at additional boxes and possibly full versions of Verity, if you're really doing that much data/document indexing with it. Sorry that's not a great deal of help. Regards Stephen __ 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
Copying an Access memo field from one table to another.
I'm using this CFQUERY: CFQUERY datasource=#Datasource# name=AddCategories INSERT INTO Categories(SurveyID, Title, Text, TriggerPoint) VALUES (#GetSurveyID.LastID#, '#Title#', #Triggerpoint#) /CFQUERY To copy data from a default table to a live table. The Text field is a memo, and CF throws an error. If I take Text out, it works fine. Is it a reserved word, or is there a trick to copying memo fields? T __ 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: cfhttp server config help...
Have you tried typing the url from the cfhttp in a browser (on your dev machine) to see what happens? -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: dinsdag 27 augustus 2002 17:28 To: CF-Talk Subject: cfhttp server config help... I have a page that uses the cfhttp tag. It works fine on our production server when performing a basic get function and then outputting the cfhttp.filecontent var. I can't get the same page to work on our development server. What kind of settings should I be looking at and where are they located? I keep getting Connection Failure. TIA, - Gary __ 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: Copying an Access memo field from one table to another.
Try using cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: dinsdag 27 augustus 2002 17:30 To: CF-Talk Subject: Copying an Access memo field from one table to another. I'm using this CFQUERY: CFQUERY datasource=#Datasource# name=AddCategories INSERT INTO Categories(SurveyID, Title, Text, TriggerPoint) VALUES (#GetSurveyID.LastID#, '#Title#', #Triggerpoint#) /CFQUERY To copy data from a default table to a live table. The Text field is a memo, and CF throws an error. If I take Text out, it works fine. Is it a reserved word, or is there a trick to copying memo fields? T __ 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
web mail
You guys know of a free or inexpensive, basic (or with a few features) CF web mail package? j __ 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: Copying an Access memo field from one table to another.
It's because you have four fields listed and only three insert values. That's why you can take out Text and it will work. :-) Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:30 AM To: CF-Talk Subject: Copying an Access memo field from one table to another. I'm using this CFQUERY: CFQUERY datasource=#Datasource# name=AddCategories INSERT INTO Categories(SurveyID, Title, Text, TriggerPoint) VALUES (#GetSurveyID.LastID#, '#Title#', #Triggerpoint#) /CFQUERY To copy data from a default table to a live table. The Text field is a memo, and CF throws an error. If I take Text out, it works fine. Is it a reserved word, or is there a trick to copying memo fields? T __ 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: web mail
I use one from ArgoSoft (http://www.argosoft.com/applications/mailserver/). Pretty inexpensive, supports multiple domains, pop3 clients as well as a web based interface. The web templages are customizable as well, and their support is excellent. -- Original Message -- From: JLH All Turbo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 27 Aug 2002 11:30:08 -0400 You guys know of a free or inexpensive, basic (or with a few features) CF web mail package? j __ 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: Copying an Access memo field from one table to another.
CFQUERY datasource=#Datasource# name=AddCategories INSERT INTO Categories(SurveyID, Title, Text, TriggerPoint) VALUES (#GetSurveyID.LastID#, '#Title#', #Triggerpoint#) /CFQUERY To copy data from a default table to a live table. The Text field is a memo, and CF throws an error. If I take Text out, it works fine. Is it a reserved word, or is there a trick to copying memo fields? Text is a reserved. Stephen PS. When you create a new thread can you send a new email to the list rather than replaying to an existing thread please __ 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: Verity Performance
Actually it's only one site-- our Intranet. K2 uses about 150M but there's plenty more available. Is the full version of Verity or does it just allow you to index more documents? Are you saying that having less but bigger collections would help? - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 11:30 AM Subject: Re: Verity Performance I tried it with one collection and it's very fast. I wondering if doubling the RAM would help? ~shrug~ What's the memory usage like?? If you're running low then maybe it would be worth a try. Otherwise, you've already got a gig in there, so if memory usage is fine then adding more won't make any difference My only other thoughts are : If you're running a large number of web sites each with multiple collections, then maybe its time you thought about investing in multiple boxes. If you've only got a couple of sites on that box, then you need to look at how you're using the collections to index your data/information and see if you can rationalise the collections to reduce the number down from 72. Other than that - I think you're looking at additional boxes and possibly full versions of Verity, if you're really doing that much data/document indexing with it. Sorry that's not a great deal of help. Regards Stephen __ 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: cfhttp server config help...
Yes I did...it goes to the url just fine. I just can't get cfhttp to work. - Gary -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:34 AM To: CF-Talk Subject: RE: cfhttp server config help... Have you tried typing the url from the cfhttp in a browser (on your dev machine) to see what happens? -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: dinsdag 27 augustus 2002 17:28 To: CF-Talk Subject: cfhttp server config help... I have a page that uses the cfhttp tag. It works fine on our production server when performing a basic get function and then outputting the cfhttp.filecontent var. I can't get the same page to work on our development server. What kind of settings should I be looking at and where are they located? I keep getting Connection Failure. TIA, - Gary __ 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: Copying an Access memo field from one table to another.
its got to be that name of the field Text have you triedtitle_Text or something else? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:30 AM To: CF-Talk Subject: Copying an Access memo field from one table to another. I'm using this CFQUERY: CFQUERY datasource=#Datasource# name=AddCategories INSERT INTO Categories(SurveyID, Title, Text, TriggerPoint) VALUES (#GetSurveyID.LastID#, '#Title#', #Triggerpoint#) /CFQUERY To copy data from a default table to a live table. The Text field is a memo, and CF throws an error. If I take Text out, it works fine. Is it a reserved word, or is there a trick to copying memo fields? T __ 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: Creating and Downloading an Excel File
What version of Excel? With Excel 2000 I can format an Excel spreadsheet the way that I want it, then do a save as web page and use the output for a template. Leave in all the stylesheet information, etc., then use CF to generate the table structure. Similar to your last item. I always add tags for no caching ... cfheader name=pragma value=no-cache cfheader name=expires value=-1 And then the only content tag I use is ... cfcontent type=application/vnd.ms-excel Comes right up in Excel with all the formatting. Dan __ 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: Copying an Access memo field from one table to another.
It's a reserved word in the sense that Access will throw an error. I ran into the same problem, which sailed past mySQL, SQL Server and Oracle, if I remember correctly. Try PageText or somesuch. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 8:30 AM To: CF-Talk Subject: Copying an Access memo field from one table to another. I'm using this CFQUERY: CFQUERY datasource=#Datasource# name=AddCategories INSERT INTO Categories(SurveyID, Title, Text, TriggerPoint) VALUES (#GetSurveyID.LastID#, '#Title#', #Triggerpoint#) /CFQUERY To copy data from a default table to a live table. The Text field is a memo, and CF throws an error. If I take Text out, it works fine. Is it a reserved word, or is there a trick to copying memo fields? T __ 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: Verity Performance
Did you try messing with the maxFiles option in the ini file? How about the online mode for each collection (which I expect would only affect start-up time)? Are you timing the first search of a collection, or are you doing a few searches to warm it up? Also, is k2 under load, or are you the only person doing searches (and are doing them one at a time)? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:30 AM To: CF-Talk Subject: Re: Verity Performance I tried it with one collection and it's very fast. I wondering if doubling the RAM would help? ~shrug~ What's the memory usage like?? If you're running low then maybe it would be worth a try. Otherwise, you've already got a gig in there, so if memory usage is fine then adding more won't make any difference My only other thoughts are : If you're running a large number of web sites each with multiple collections, then maybe its time you thought about investing in multiple boxes. If you've only got a couple of sites on that box, then you need to look at how you're using the collections to index your data/information and see if you can rationalise the collections to reduce the number down from 72. Other than that - I think you're looking at additional boxes and possibly full versions of Verity, if you're really doing that much data/document indexing with it. Sorry that's not a great deal of help. Regards Stephen __ 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: Copying an Access memo field from one table to another.
It's because you have four fields listed and only three insert values. That's why you can take out Text and it will work. Ha! Well, *one* of those four db platforms will choke on the word 'text' as a db field. I remember having to change a fieldname on that issue for code that had to work on all of them. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.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: Copying an Access memo field from one table to another.
It's because you have four fields listed and only three insert values. That's why you can take out Text and it will work. Of course that won't help either... ;o) Stephen __ 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: CF vs. ASP
Matt I think we all agree that we should use the best tool for the job. The point everyone is trying to convey to you is that CF is the best tool for the job more often than ASP (or PHP etc.). This is because it does dang near everything we want and when it doesn't more than likely someone has already written a custom tag or UDF to handle it. We're all rightlets go for a beer (Canadian beer that is) ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 26, 2002 6:22 PM Subject: RE: CF vs. ASP Sure... but the same could be said about ANY programming language. But this isn't ANY-Talk. This is CF-Talk and we are discussing CF vs. ASP, which makes it relevant. I certainly don't believe ColdFusion is the ultimate solution for EVERY job, just like I don't use a pipe wrench when I really need a hammer. UNLESS the pipe wrench will fix my problem faster than it would take me to get up, go to the garage, and get the hammer. :-) That is a great attitude! Now if only the rest of the list would feel the same way. -Matt __ 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
Have a question about a cfselect....Was(RE: Need help with update on two different tables)
Turns out that there was nothing wrong with this cfselect, but something else was wrong with the data that was being saved to the multiple tables I was inserting into. All is well, however I have a question. How can I emulate the blank line before a cfselect in a drop down box? Here's a sample cfselect I have: tr tdDivision:/td tdcfselect name=Division query=GetDivision value=Division display=Division/cfselect/td /tr Currently this defaults to the 1st value that the query returns. I tried to insert a blank line in the DB, but that is not working. Thanks, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, August 23, 2002 7:37 PM To: CF-Talk Subject: RE: Need help with update on two different tables Here's the code for the cfselect. tr tdGender:/td tdcfselect name=Gender message=Gender query=GetPersonnelInfo value=Gender selected=Gender option value=MM option value=FF/cfselect/td /tr My first instinct is to close the option tags... so option value=MM/option ... If that doesn't work, I'd start to think it's a bug because I don't see any other problems with the cfselect tag syntax... I'm not sure why there's a query attribute tho, since your only options are both provided manually and not by the query ( as is normal for cfselect ), so you might want to remove that also... and if you want to make sure the people entering the data don't make some women men, you might also want to add option value=/option above the M option... hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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: Verity Performance
Actually it's only one site-- our Intranet. K2 uses about 150M but there's plenty more available. Is the full version of Verity or does it just allow you to index more documents? ??? The full version of Verity is much more powerful than the version that is supplied with ColdFusion. http://www.verity.com/ Are you saying that having less but bigger collections would help? Yes I don't know how true that is, but its worth a try. In my experience people seem to over use collections where one would suffice with judicious use of the custom fields. This may or may not be true in your case, but probably worth looking at. Regards Stephen __ 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: Microsoft Binary File Format
I think there is a filter for 'tidy' to clean up the MS Word HTML-hell to standards-compliant (XHTML?). __ 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: cfhttp server config help...CFMX
ok, I'm getting further but now I've discovered it's a cfmx issue... The following code: cfhttp url=http://www.mytesturl.com; method=GET resolveurl=true proxyserver=proxy.company.com proxyport=80 works fine on the production server AND the development server (port 80 on development). I'm trying to get it to work using cfmx on port 8500 on the development server. Here is the code that I'm using: cfhttp url=http://www.mytesturl.com; method=GET port=8500 resolveurl=true proxyserver=proxy.company.com proxyport=80 /cfhttp I'm getting connection failure. Any ideas? - Gary -Original Message- From: Houk, Gary Sent: Tuesday, August 27, 2002 11:43 AM To: CF-Talk Subject: RE: cfhttp server config help... Yes I did...it goes to the url just fine. I just can't get cfhttp to work. - Gary -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:34 AM To: CF-Talk Subject: RE: cfhttp server config help... Have you tried typing the url from the cfhttp in a browser (on your dev machine) to see what happens? -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: dinsdag 27 augustus 2002 17:28 To: CF-Talk Subject: cfhttp server config help... I have a page that uses the cfhttp tag. It works fine on our production server when performing a basic get function and then outputting the cfhttp.filecontent var. I can't get the same page to work on our development server. What kind of settings should I be looking at and where are they located? I keep getting Connection Failure. TIA, - Gary __ 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: CF vs. ASP
I'm not necessarily agreeing with everything that Matt Liotta says but, gosh, is wouldn't go so far as to say that CF is the best tool for the job more often than not. It's a good tool for small-medium sized websites, and it's nice and fast dev time, but there are many instances that CF is not necessarily the best tool for the job, although it can be used. Intranets are one thing I can think of. I have an intranet here that I wrote last year using CF - because I am most experienced at CF. However, I believe that had I written it in ASP, I would have not encountered the numerous problems and trials that using COM through CF gives us. I have actually written one page in CF that calls an ASP page because ASP does the job quicker and easier. I love CF, I used to work for Allaire, but let's not kid ourselves and think that CF is the hammer that can strike all the nails. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:49 AM To: CF-Talk Subject: Re: CF vs. ASP Matt I think we all agree that we should use the best tool for the job. The point everyone is trying to convey to you is that CF is the best tool for the job more often than ASP (or PHP etc.). This is because it does dang near everything we want and when it doesn't more than likely someone has already written a custom tag or UDF to handle it. We're all rightlets go for a beer (Canadian beer that is) ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 26, 2002 6:22 PM Subject: RE: CF vs. ASP Sure... but the same could be said about ANY programming language. But this isn't ANY-Talk. This is CF-Talk and we are discussing CF vs. ASP, which makes it relevant. I certainly don't believe ColdFusion is the ultimate solution for EVERY job, just like I don't use a pipe wrench when I really need a hammer. UNLESS the pipe wrench will fix my problem faster than it would take me to get up, go to the garage, and get the hammer. :-) That is a great attitude! Now if only the rest of the list would feel the same way. -Matt __ 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: isDefined question
And multiple select lists / listboxes with nothing selected ... and submit buttons that have not been pressed. Doh! I forgot. :) - Original Message - isDefined(variableName) and Len(variableName) are used in different contexts. All form values are defined except checkboxes without any data. And radio buttons, don't forget those. :) Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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: application.cfm in templates directory?
Let's say that I accidentally put an Application.cfm file in my /Templates directory. Would that Application.cfm be included at the top of every template CFINCLUDEd from that directory? No, the application.cfm file only gets prepended to base templates, so you woul have to actually type /templates/mytemplate.cfm into the browser for that application.cfm to affect that module... Which actually I use for security purposes to prevent some files from being accessed directly ( as opposed to cfmodule or cfinclude ) by using an application.cfm file which contains only cfabort Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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
OT: Nutscrape document.form.action
Hi,
I've got a form with two submit buttons, and running onclick on them,
pointing at two different functions, one of which is here...
function transfer(){
document.entrant.action=blah.cfm;
document.entrant.submit();
}
works fine in IE, Nutscrape seems to just read the form action= bit...
Anyone any ideas?
Cheers,
Ian
__
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
Good CFUG
Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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: cfhttp server config help...CFMX
FYIthe port setting in cfhttp is for the port on server you are requesting info from, not your cf server port. Defaults to 80. -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:11 AM To: CF-Talk Subject: RE: cfhttp server config help...CFMX ok, I'm getting further but now I've discovered it's a cfmx issue... The following code: cfhttp url=http://www.mytesturl.com; method=GET resolveurl=true proxyserver=proxy.company.com proxyport=80 works fine on the production server AND the development server (port 80 on development). I'm trying to get it to work using cfmx on port 8500 on the development server. Here is the code that I'm using: cfhttp url=http://www.mytesturl.com; method=GET port=8500 resolveurl=true proxyserver=proxy.company.com proxyport=80 /cfhttp I'm getting connection failure. Any ideas? - Gary -Original Message- From: Houk, Gary Sent: Tuesday, August 27, 2002 11:43 AM To: CF-Talk Subject: RE: cfhttp server config help... Yes I did...it goes to the url just fine. I just can't get cfhttp to work. - Gary -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:34 AM To: CF-Talk Subject: RE: cfhttp server config help... Have you tried typing the url from the cfhttp in a browser (on your dev machine) to see what happens? -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: dinsdag 27 augustus 2002 17:28 To: CF-Talk Subject: cfhttp server config help... I have a page that uses the cfhttp tag. It works fine on our production server when performing a basic get function and then outputting the cfhttp.filecontent var. I can't get the same page to work on our development server. What kind of settings should I be looking at and where are they located? I keep getting Connection Failure. TIA, - Gary __ 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: Copying an Access memo field from one table to another.
At 04:43 PM 8/27/02 +0100, Stephen Moretti wrote: Text is a reserved. Ok, thanks. PS. When you create a new thread can you send a new email to the list rather than replaying to an existing thread please Does that make a difference? T __ 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: Copying an Access memo field from one table to another.
At 11:38 AM 8/27/02 -0400, Matthew R. Small wrote: It's because you have four fields listed and only three insert values. That's why you can take out Text and it will work. Actually, that's because I'm taking code that has been modified to work and putting it in the e-mail and changing it back in the e-mail. The original code that didn't work had Text in both places. T __ 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: Nutscrape document.form.action
Ian -
Try using input type=button instead of input type=submit. I think
your problem may be in the fact that using input type=submit has a
built-in document.form.submit action...which may be interfering with your
function running correctly.
worth a shot :)
charlie
Ian Tait writes:
Hi,
I've got a form with two submit buttons, and running onclick on them,
pointing at two different functions, one of which is here...
function transfer(){
document.entrant.action=blah.cfm;
document.entrant.submit();
}
works fine in IE, Nutscrape seems to just read the form action= bit...
Anyone any ideas?
Cheers,
Ian
__
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: Good CFUG
In this case, I do not think that size matters nearly as much as the subject matter being presented. The one here in the DFW area (Dallas/Fort Worth for outsiders) is pretty good, and the subject matter tends to focus on intermediate-advanced levels of expertise. What I have found to be very helpful is to subscribe to a couple of lists. For instance, I am a member of the Maryland CFUG and the DFWCFUG. Between these two, and CF-TALK, I find that most any question that I may have has either been answered or is easily answered by posting the question to all of these resources. -- Original Message -- From: Bryan F. Hogan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 27 Aug 2002 12:19:00 -0400 Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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: Have a question about a cfselect....Was(RE: Need help with update on two different tables)
This will add a blank row at the beginning of the query. You can also use QuerySetCell to give the row specific values. cfset temp = queryaddrow(GetDivision,1) - j -Original Message- From: Clark, Aimee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:00 PM To: CF-Talk Subject: Have a question about a cfselectWas(RE: Need help with update on two different tables) Turns out that there was nothing wrong with this cfselect, but something else was wrong with the data that was being saved to the multiple tables I was inserting into. All is well, however I have a question. How can I emulate the blank line before a cfselect in a drop down box? Here's a sample cfselect I have: tr tdDivision:/td tdcfselect name=Division query=GetDivision value=Division display=Division/cfselect/td /tr Currently this defaults to the 1st value that the query returns. I tried to insert a blank line in the DB, but that is not working. Thanks, Aimee' Clark -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, August 23, 2002 7:37 PM To: CF-Talk Subject: RE: Need help with update on two different tables Here's the code for the cfselect. tr tdGender:/td tdcfselect name=Gender message=Gender query=GetPersonnelInfo value=Gender selected=Gender option value=MM option value=FF/cfselect/td /tr My first instinct is to close the option tags... so option value=MM/option ... If that doesn't work, I'd start to think it's a bug because I don't see any other problems with the cfselect tag syntax... I'm not sure why there's a query attribute tho, since your only options are both provided manually and not by the query ( as is normal for cfselect ), so you might want to remove that also... and if you want to make sure the people entering the data don't make some women men, you might also want to add option value=/option above the M option... hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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
CFAS crash
Hello, everyone. Sorry to re-post this, but it's a rather serious issue, and I fear my initial, long-winded message may have made people fall asleep and hit the delete key. :) So here's the short version. The CFAS is hanging such that all CFM pages fail (they mention something about a UNIX error in the very bried failure message). HTML pages still work. Any idea what would cause a CFAS to hang? I know about endless loops and have checked against those. I can't think of any other reasons, though. Any ideas at all? Thanks, Matthieu __ 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: Good CFUG
Well, the whole purpose is to attend the meetings and be a part of their community. So, I'd look at the MM site for groups in your area. http://www.macromedia.com/v1/usergroups/ Dave - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 12:19 PM Subject: Good CFUG Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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: Good CFUG
Just a thought, but shouldn't you join a UG in your area? I think Ed ([EMAIL PROTECTED]), Amy ([EMAIL PROTECTED]), or Gabriela ([EMAIL PROTECTED]) should be able to answer your question. They are the Macromedia user group community managers. HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 9:19 AM Subject: Good CFUG Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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: OT: Nutscrape document.form.action
Hi,
I'm actually using an 'image' submit button (but have tried with the others
too...)
Cheers,
Ian
-Original Message-
From: charlie griefer [mailto:[EMAIL PROTECTED]]
Sent: 27 August 2002 17:38
To: CF-Talk
Subject: Re: OT: Nutscrape document.form.action
Ian -
Try using input type=button instead of input type=submit. I think
your problem may be in the fact that using input type=submit has a
built-in document.form.submit action...which may be interfering with your
function running correctly.
worth a shot :)
charlie
Ian Tait writes:
Hi,
I've got a form with two submit buttons, and running onclick on them,
pointing at two different functions, one of which is here...
function transfer(){
document.entrant.action=blah.cfm;
document.entrant.submit();
}
works fine in IE, Nutscrape seems to just read the form action= bit...
Anyone any ideas?
Cheers,
Ian
__
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: Good CFUG
Thanks, No size does not matter, I did state I was just curious about the largest. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:39 PM To: CF-Talk Subject: Re: Good CFUG In this case, I do not think that size matters nearly as much as the subject matter being presented. The one here in the DFW area (Dallas/Fort Worth for outsiders) is pretty good, and the subject matter tends to focus on intermediate-advanced levels of expertise. What I have found to be very helpful is to subscribe to a couple of lists. For instance, I am a member of the Maryland CFUG and the DFWCFUG. Between these two, and CF-TALK, I find that most any question that I may have has either been answered or is easily answered by posting the question to all of these resources. -- Original Message -- From: Bryan F. Hogan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 27 Aug 2002 12:19:00 -0400 Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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: Problem with CFMX ADV Sec and Browse Server applets
Well I've discovered with the help of Webby Erika that what is happening is when you click on the browse server button with Adv Sec enabled it is popping up a dialog asking you to put a disk into drive a: (?!) When I was having this problem the server was remote (through Term Services) and so I couldn't see this dialog. Webby though was doing it on a local server and could see the dialog. The java applet in question hangs until this dialog is clicked or a floppy is inserted into the drive. With Adv Sec turned OFF however this dialog doesn't appear. So for some reason it is trying to read what folders are on the a: drive. The mentioned Admin sandbox is still intact, the 2 entries it creates are still there untouched. - Original Message - From: Jesse Houwing [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 3:30 PM Subject: Re: Problem with CFMX ADV Sec and Browse Server applets Kumaran Nallore wrote: Hi, Browse Server seems to work with sandbox security turned on, in my instance of CFMX. Can you be more specific as to which folder you secured and your sandbox settings? Did you by accident remove the sandbox for the administrator? The administartor directory should have a sandbox that enables ALL options. I did this myself once, and I can tell you, it isn't nice trying to restore it :) Jesse __ 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: Good CFUG
Yes, I have looked into these, I have not been impressed with what I have seen yet. Alot of UGs that I have found seem not to be for the Intermediate to the Advanced. That is what I'm looking for. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:38 PM To: CF-Talk Subject: Re: Good CFUG Just a thought, but shouldn't you join a UG in your area? I think Ed ([EMAIL PROTECTED]), Amy ([EMAIL PROTECTED]), or Gabriela ([EMAIL PROTECTED]) should be able to answer your question. They are the Macromedia user group community managers. HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 9:19 AM Subject: Good CFUG Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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
iscollection?
Has anyone seen a way of checking to see of a collection exists? What I am looking for could be a function called iscollection(collection name)if it existed. Is there a better way than evoking a search of a collection and catching any error. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 __ 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: Good CFUG
Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. The DC CFUG is probably the largest, in terms of registered members, and it's the oldest, being the first CFUG to my knowledge, and I think it's a really good CFUG - free food, free code, fun for the whole family! Of course, being one of its founders, I'm a bit biased. However, if you're not in the DC area, it doesn't matter how good it is, I suppose; you'd be better off finding one in Florida if that's where you are. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CFAS crash
What version of CF? What is the Unix error message? If you're using CF 5 or earlier, variables' locking is the most important thing related to system stability, in my experience. The most common Unix error message we get is when the CFserver used to hang, and it's the server not serving message. Chris Norloff -- Original Message -- from: Cornillon, Matthieu [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 27 Aug 2002 12:37:30 -0400 Hello, everyone. Sorry to re-post this, but it's a rather serious issue, and I fear my initial, long-winded message may have made people fall asleep and hit the delete key. :) So here's the short version. The CFAS is hanging such that all CFM pages fail (they mention something about a UNIX error in the very bried failure message). HTML pages still work. Any idea what would cause a CFAS to hang? I know about endless loops and have checked against those. I can't think of any other reasons, though. Any ideas at all? Thanks, Matthieu __ 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: What does this mean?
I'm guessing that the problem is in the stored proc and that you're doing something not supported by the Merant JDBC drivers. If you can post the actual stored procedure, maybe someone will see the problem for you. On 8/3/02 8:48 AM, Bruce Sorge [EMAIL PROTECTED] wrote: I searched the on-line docs and the MM site and I cannot find out why I am receiving this error. MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented The Error Occurred in C:\Web\WME\voucher\step_2_Insert.cfm: line 51 49 : cfprocparam cfsqltype=cf_sql_varchar dbvarname=@VoucherCode type=in value=#Session.VoucherCode# 50 : cfprocparam cfsqltype=cf_sql_date dbvarname=@Date_Registered type=in value=#Today# 51 :/cfstoredproc 52 : /cftransaction 53 : Anyone else encounters this and can you tell me what the resolution is? I am using CFMX. Thanks, Bruce __ 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: Good CFUG
Find the one closest to you. If you are in California, it probably doesn't make sense to attempt to join the New York City CFUG, for example. At 12:19 PM 8/27/2002 -0400, you wrote: Does anyone know of a really good CFUG, or the largest CFUG. I'm not emplying the largest UG is the best, I am just curious about the largest. I want to join an UG, just want to know which one(s) are the cream of the crop. __ 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
