Re: The biggest cfmail message?
At 8:11 AM -0500 8/31/01, Bruce Sorge wrote: What do you mean by biggest? Are you referring to the size in KB of the document, or are you talking about volume? Size in K of the document. Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The biggest cfmail message?
At 2:32 PM +0100 8/31/01, Will Swain wrote: I think the question should be What is the biggest email that my clients will want to download without getting really hacked off?? Will Normally I would agree, but this is a subscription (paid for) newsletter... many would want to receive it in email rather than go to the site and link through web pages. Thanks, though, ot is a good point! Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT? Macromedia Spectra
So I'm wondering now what the official situation with Spectra is? My company is currently talking about designing a content management tool to use for our clients. The more and more we talk about it, the more and more I'm reminded of Spectra. I'd hate to re-invent the wheel at this point. I noticed the Spectra Community site that launched, which is great. But, is it still possible now for companies to purchase Spectra? Is it now available as a free download instead? If I did have to purchase it, is that even an option and is it at the same cost it was previously sold at? I'm still not quite clear what the scenario is here. Any MACR reps care to comment on this? Thanks in advance, Tyson ~~ 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: DateFormat
Use DateAdd(m, 2, Now()) -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:14 AM To: CF-Talk Subject: DateFormat I need get thedate 2 months in advance from now? ~~ 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: DateFormat
Check out the DateAdd function... Howie - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 10:14 AM Subject: DateFormat I need get thedate 2 months in advance from now? ~~ 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: Question about retrieving Oracle CLOBs into a CF variable
We had the same issue with getting gibberish. What we found was that if you insert a record into a table with a clob, you need to set the value of the clob on insert, even if its an empty string. If you insert a record without including a value for the clob, your select against that row will seem to draw data from the fourth dimension. We're using clobs with native drivers all the time. -Original Message- From: Rosa, Issac [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:16 AM To: CF-Talk Subject: RE: Question about retrieving Oracle CLOBs into a CF variable You should be able to just do select clob_column from table [where]. We had a problems using clob and retrieving erroneous data or gibberish. Not sure if it was related to Native drivers or what the issue was exactly. So we changed to Long datatype and everything works great. Good luck. LOL Issac Rosa IT - National Sales Marketing Web Developer Ofc: 407-658-3111 Cell: 407-342-0644 Fax: 407-971-2374 [EMAIL PROTECTED] -Original Message- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 11:02 PM To: CF-Talk Subject: Question about retrieving Oracle CLOBs into a CF variable Folks, In one CF template I insert a very long string (e.g. 1 bytes) into a CLOB column of a new row in an Oracle table. (Actually the CLOB is the string resulting from a CFWDDX tage that converts a CF structure of structures to a string.). I do this insert by using the CFQUERYPARAM tag to force CF to generate a bind variable like Oracle wants for CLOBs. Now, in another CF template I need to retrieve it. My question is, how Can I simply say select clob_column from table wherecondition is true? Can I then refer to QueryName.clob_column and get the whole humoungous string? Or do I need to force CF to use bind variables again? If so how do I do that in a select statement? Can I say select clob_column into cfqueryparam value=#local_cf_variable# from table where condition is true Does that work? Can anyone advise? I will be most appreciative of any help. Thanks, -- Tim Dempsey ~~ 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: Mailing List Manager
FYI - this list is now running on iMS... Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Tom Forbes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 9:31 AM Subject: Mailing List Manager I need to move to an opt in / opt out mailing list to accommodate about 5,000 addresses. Can someone recommend a good Mailing List Manager that is CF based? Thank you, Tom Forbes ** Shop MedSearch - Over 500 Web sites under one roof! http://www.medsearch.medmatrix.com TEL: 407-772-3427 FAX: 407-772-3428 Tom Forbes, Forbes Web Consulting, Inc. ** ~~ 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 and Messager
Oohhh. You've got my attention. I don't know flash, but this might be a good opportunity for me to push to have them get me trained on it (or at least give me time and the tools to do it). Can you share more details (of how flash works without opening a browser). See, many times students are using the word processor, spreadsheet, power point or something else, and are not on the web. Dave - Original Message - From: Bill Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 10:14 AM Subject: Re: CF and Messager You could probably write it in Flash and make a projector and you'd have a client app that does what you need. I wrote a time tracking system for our developers and other employees and plan to do something like this with Flash or Director to make it so they don't have to open a browser to punch in/out. -Bill brainbox - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 9:21 AM Subject: CF and Messager Hello, I'm developing an application were our computer labs can track usage and statistics on the machines that are used in there. What I'm looking for is this. Students check in with their ID cards and are asigned a machine. The application then tracks who's on what machine and tracks the time, etc. I'd like to place an agent on each machine that talks back to the application, and when flagged, say, if the student's time is up, I can have pop up a message telling them time's up. Kinda along the lines of the old Novel network messaging system where you could send a message in a popup box to any other machine on the network. Is anybody doing anything like this? If so, what are you using for the agent on the client machines? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: adding counts
I'm using sql2000. Thanks for getting me started-looks like I can go from here. j -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:26 AM To: CF-Talk Subject: Re: adding counts If you're using oracle, you could so something like this: SELECTSUM(DECODE(abstype, 'E', 1, 'U', 1, 0)) AS totalabsences In plain english, this says: If abstype = 'E' then add 1 to totalabsences, elseif abstype = 'U' then add 1 to totalabsences, else add zero to totalabsences You can add additional lines to it like this one: SUM(DECODE(abstype, 'T', 1, 0)) AS totaltardies, SUM(DECODE(abstype, 'E', 1, 0)) AS totalexcused, SUM(DECODE(abstype, 'U', 1, 0)) AS totalunexcused FROMyourtable WHEREyourconditions If you're using ACCESS, you do this with iif. I can look up the syntax if you need it. If you're using mssql, I can't help ya. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: adding counts
I think you just need to add something to your WHERE clause. For example, if you just want to count U+E, use WHERE ((T_ABS.ABSDATE = T_Quarter.BegQuarter) AND (T_ABS.ABSDATE = T_Quarter.EndQuarter)) AND ( (T_ABS.ABSType = 'U') OR (T_ABS.ABSType = 'E') ) --- Janine Jakim [EMAIL PROTECTED] wrote: ABSType is the column being counted. In it there are several different codes that are used depending on what is appropriate for the student. They include: T=Tardy U=Unexcused Absence E=Excused Absence So my query does fine in the sense that it counts how many T/E/U each student has. The next step is to add E+U= Total Absences I assume it needs to happen outside the query? -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 4:31 PM To: CF-Talk Subject: Re: adding counts Can you show your table structure? I need to know how do you distinguish absent from tardy from excused from unexcused? Where in the table is it located and how is the information represented? --- Janine Jakim [EMAIL PROTECTED] wrote: I've got a query that counts how many times a student is absent/tardy. It outputs fine BUT i need it to do things slightly differently- I need to combine a couple of the codes to make a total (For example 3 Excused +2 Unexcused= 5 absences). What is the best way to do this? CFQUERY NAME=MissedDays DATASOURCE=dsn SELECT T_ABS.QUARTER, T_ABS.ID, Count(T_ABS.ABSType) AS CountOfABSType, T_ABS.DAYTITLE FROM T_ABS, T_Quarter WHERE ((T_ABS.ABSDATE = T_Quarter.BegQuarter) AND (T_ABS.ABSDATE = T_Quarter.EndQuarter)) GROUP BY T_Quarter.QUARTER, T_ABS.ID, T_ABS.DAYTITLE /CFQUERY So how do I get my CountOfABSType to do this? Thanks in advance. j = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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: DateFormat
Use DateAdd() cfset Date2MontsFromToday=DateAdd(m,2,Now()) Ok??? Is that what you are looking for? Trishan Singh ACP/CCFD [EMAIL PROTECTED] 316-204-1097 Paracom Technologies Wichita KS - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 9:14 AM Subject: DateFormat I need get thedate 2 months in advance from now? ~~ 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: Speak Up...
Matt, I had another conversation with MM yesterday with Dave Emmon (sic?) and I pointed out that the EAPI for apache was not supported in CF 5 either and was told that MM considers Win32 apache to be beta software [snip] beta status and that when 2.0 is out of beta it will be supported. I take the lack of support for beta software and the small user base as positioning statement and an attempt to set expectation. I would like to point out (and maybe you can be in the meeting) that the manual does contains installation instructions for apache and does not say anything about it being beta and unsupported. I will not be in the meeting, but I know from a couple of people that this is an issue. I will bring up your points to the PM now and see what can be done. We are doing our best here and I thank you for bearing with us for the time being. _ Matt Brown Community Manager Macromedia (650) 481-4525 [EMAIL PROTECTED] Register now for Macromedia DevCon 2001! Visit for more information and to register http://www.macromedia.com/go/devcon. 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? Macromedia Spectra
You can still purchase it, but 1.5.1 will be the last major release in its current format (all fixed and updates etc.. will be got thru the SCSS). I think the current app is supported for another 2 years; as for cost I think its the same - can't be sure though. The future, well the major components of the COAPI are being integrated at the Java level into Neo - CF6; so we will have to wait and see, but the future does look good. I was very disappointed when I heard they were dropping it but as it turns out it is a blessing IMHO N ~~ 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: case sensitive sql query
SQL Queries ARE NOT case sensitive when doing a WHERE
that involves a varchar.
They should be unless there's been a nonstandard
implementation of SQL. I'm not familiar with SQL
Server, so I don't know about that, but on Oracle it
doesn't matter whether the underlying column type is
CHAR or VARCHAR -- it's always case sensitive.
--- Alex Santantonio [EMAIL PROTECTED] wrote:
SQL Queries ARE NOT case sensitive when doing a
WHERE that involves a
varchar. The way to do a Case sensitive WHERE
clause depends largely on the
database that you are using. If you are using SQL
Server 7/2000 then it is
quite simple. It is even more simple if you are
using Stored Procedures to
perform this task. Just use CAST to force your
value to binary data and
then compare based on the returned binary data.
CAST(ColumnName AS
VARBINARY(ColumnLength)) = CAST('Test Query' AS
VARBINARY(ColumnLength)) in
your WHERE within your Stored Procedure. Once you
have that set, just make
the 'Test Query' string in your Stored Procedure
into a @sp_variable and
pass in the value you are searching on. CAST is
preferred over CONVERT.
Alex Santantonio,
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED]
www.doceus.com
-Original Message-
From: cf refactoring
[mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 9:11 AM
To: CF-Talk
Subject: Re: case sensitive sql query
SQL SELECT queries ARE case sensitive.
The problem is in your data -- you're using
columnames
from your tables as data. Depending on the database,
this information is stored in auxiliary tables (in
Oracle, it would be in a table like
all_tab_columns), and may be in a case-insensitive
form. For example, in Oracle, if I run
select column_name, table_name from all_tab_columns
then I see that all the column_names and table_names
are all uppercase even though when I created the
tables, I had mixed case for the table and column
names
--- Bernd VanSkiver [EMAIL PROTECTED] wrote:
Is there a way to do a case sensitive SELECT
query?
Don't want to make a
server wide change, just want to specify a single
query to do a case
sensitive search.
SELECT ColumnName
FROM tableName
WHERE ColumnName = 'Test Query'
Want this to do a case sensitive search on the
WHERE
clause.
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
~~
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: Plain text view in outlook?
Eudora Light is a limited HTML reader. It will pick up the HTML version before the text version. You can see the text version in Outlook by viewing the message Properties Details message source. You'll see both versions with all headers. tom www.basic-ultradev.com [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Probably most effective to get yourself a plain-text email client to experiment with, assuming you have something that looks like a POP server. An older version of Eudora (free light version at ftp://ftp.eudora.com/eudora/eudoralight/windows/english/306/) should work. ~~ 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
fieldnames structure
Hi Folks, I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: adding counts
The access version would be
SELECT SUM(IIF(abstype IN ('U','E'), 1, 0)) as totalabsences
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The biggest cfmail message?
Is this content already displayed online? If so, rather than sending an email with all the images etc attached, you could link to all the image's online locations (absolute href's) and thus reduce your bandwidth requirements substantially (depending on the nature of the content...) HTH Dan -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 15:42 To: CF-Talk Subject: RE: The biggest cfmail message? At 2:32 PM +0100 8/31/01, Will Swain wrote: I think the question should be What is the biggest email that my clients will want to download without getting really hacked off?? Will Normally I would agree, but this is a subscription (paid for) newsletter... many would want to receive it in email rather than go to the site and link through web pages. Thanks, though, ot is a good point! Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: fieldnames structure
Form.Fieldnames is a list of all the form fields. You want just Form. Also, you can't place a structure in a form field like that, it's not a simple string. You can, however, convert the form structure to a wddx packet and put _that_ in a form field. CFSET Form.Foo = 1 CFWDDX ACTION=CFML2WDDX INPUT=#Form# OUTPUT=Formpacket FORM CFOUTPUT INPUT TYPE=hidden NAME=OldData VALUE=#FormPacket# /CFOUTPUT /FORM You may want to URL encode FormPacket to ensure no line breaks are in. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:38 AM To: CF-Talk Subject: fieldnames structure Hi Folks, I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: fieldnames structure
Hello Deanna, whynot just cfset 1stPage = structcopy(form) then access that structure on the second page? -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Friday, August 31, 2001, 11:38:20 AM, you wrote: DS Hi Folks, DS I'm trying to figure out this structure thing, and I have a project where I DS have to grab all the fieldname/value pairs from one form, hold them while DS the user fills out a second page, then send them along in a hidden field to DS the action page. DS What's the best way to do this? I thought I could just do something like: DS input type=hidden name=page1struct DS value=#structcopy(form.fieldnames)# But that throws an error. DS -d DS Deanna Schneider DS Interactive Media Developer DS [EMAIL PROTECTED] DS ~~ 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: fieldnames structure
Loop through the list of field names, CFOUTPUT CFLOOP LIST=#FORM.Fieldnames# INDEX=field INPUT TYPE=Hidden NAME=#field# VALUE=#Evaluate(FORM. Field)# /CFLOOP /CFOUTPUT -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:38 AM To: CF-Talk Subject: fieldnames structure Hi Folks, I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: fieldnames structure
I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. That's not going to work, because a structure can't be simply written to a string, as you're trying to do. If you want to pass data from one page, to the next, it'll have to be string data of some type. You could use WDDX to convert complex objects (arrays, structures, queries) to strings, then write the WDDX strings to your form fields, then convert them back to complex objects using CFWDDX in the action page. Or, you could use the Session scope to store the data persistently. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: The biggest cfmail message?
At 4:22 PM +0100 8/31/01, Daniel Lancelot wrote: Is this content already displayed online? If so, rather than sending an email with all the images etc attached, you could link to all the image's online locations (absolute href's) and thus reduce your bandwidth requirements substantially (depending on the nature of the content...) HTH Dan Yes, the content is online! The email will have the hrefs as you mention. But, I don't see how this helps the receiver, the email client has to go fetch the images from the live site, as opposed to receiving them as attachments... seems that this would take a little longer. Am I missing something here? Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: fieldnames structure
Deana, You're close. The FORM scope itself is actually just one big structure, which means you can copy it and pass it along. You'll likely, however, need to convert it to something that can be passed in the form hidden field - I'd recommend WDDX. Try something like this. !--- copy the form scope from the previous page submission --- cfset stcPage1 = structCopy(form) !--- encode it as a WDDX packet --- cfwddx action=cfml2wddx input=#stcPage1# output=wstcPage1 !--- embed it in the form on page 2 --- cfoutput input type=hidden name=stcPage1 value=#wstcPage2# /cfoutput This will pass the struct as a WDDX packet named wstPage1. In order to access the values of the struct on the next page, you'll need to de-serialize it first, like this (this would be in the submit logic on page 2): cfwddx action=wddx2cfml input=#form.wstcPage1# output=stcPage1 Then you should be able to reference fields from page one in the following manner: cfoutput #stcPage1.strFormField1#br #stcPage1.strFormField2#br /cfoutput Hope this helps, Tyson -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:38 AM To: CF-Talk Subject: fieldnames structure Hi Folks, I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Prepared statements
I have two questions. When you set up a dsn in the CF there is a check box that says Create stored procedures for prepared statements. Do I need to check that box to get cfquery's to work that include cfqueryparam's? No. Second question, if it does create a stored proc for my query would I just continue to run the query with the cfqueryparam or would I need to run it as a stored procedure? You'd continue to run your query as before. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: fieldnames structure
First off all, if you could do this then why not just reference the form field directly. Secondly I think it was asked when a new page is displayed, after the first was submitted so this will not work! Regards, Andrew Scott -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: Saturday, 1 September 2001 1:56 AM To: CF-Talk Subject: Re: fieldnames structure Hello Deanna, whynot just cfset 1stPage = structcopy(form) then access that structure on the second page? -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Friday, August 31, 2001, 11:38:20 AM, you wrote: DS Hi Folks, DS I'm trying to figure out this structure thing, and I have a project where I DS have to grab all the fieldname/value pairs from one form, hold them while DS the user fills out a second page, then send them along in a hidden field to DS the action page. DS What's the best way to do this? I thought I could just do something like: DS input type=hidden name=page1struct DS value=#structcopy(form.fieldnames)# But that throws an error. DS -d DS Deanna Schneider DS Interactive Media Developer DS [EMAIL PROTECTED] DS ~~ 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
FW: fieldnames structure
Deanna The custom tag CF_EmbedFields does this job for you. Check it out at http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34704C-2830-11D4-AA 9700508B94F380method=Full Cheers Rob -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 16:38 To: CF-Talk Subject: fieldnames structure Hi Folks, I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The biggest cfmail message?
Most HTML messages that are sent out are done this way. It's much easier on the mail server and the email reader if the images aren't included in the body. If you must include them, I posted some code here a couple months back that you may be able to use. As far as limits, there are no known limits. A lot of users have limited space in their inbox, though, especially people with free email accounts. tom Dick Applebaum [EMAIL PROTECTED] wrote in message news:v04220808b7b56406fd83@[63.15.99.55]... At 4:22 PM +0100 8/31/01, Daniel Lancelot wrote: Is this content already displayed online? If so, rather than sending an email with all the images etc attached, you could link to all the image's online locations (absolute href's) and thus reduce your bandwidth requirements substantially (depending on the nature of the content...) ~~ 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[2]: fieldnames structure
Hello Andrew, I don't follow you. why could you not post from pagea to pageb on pageb copy the form structure to another structure post pageb to pagec and access a newly populated form structure AND the structure you created?? -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Friday, August 31, 2001, 12:08:26 PM, you wrote: AS First off all, if you could do this then why not just reference the form AS field directly. Secondly I think it was asked when a new page is AS displayed, after the first was submitted so this will not work! AS Regards, AS Andrew Scott AS -Original Message- AS From: Critter [mailto:[EMAIL PROTECTED]] AS Sent: Saturday, 1 September 2001 1:56 AM AS To: CF-Talk AS Subject: Re: fieldnames structure AS Hello Deanna, AS whynot just AS cfset 1stPage = structcopy(form) AS then access that structure on the second page? ~~ 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: Re[2]: fieldnames structure
--- Critter [EMAIL PROTECTED] wrote: Hello Andrew, I don't follow you. why could you not post from pagea to pageb on pageb copy the form structure to another structure post pageb to pagec and access a newly populated form structure AND the structure you created?? -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Friday, August 31, 2001, 12:08:26 PM, you wrote: AS First off all, if you could do this then why not just reference the form AS field directly. Secondly I think it was asked when a new page is AS displayed, after the first was submitted so this will not work! AS Regards, AS Andrew Scott AS -Original Message- AS From: Critter [mailto:[EMAIL PROTECTED]] AS Sent: Saturday, 1 September 2001 1:56 AM AS To: CF-Talk AS Subject: Re: fieldnames structure AS Hello Deanna, AS whynot just AS cfset 1stPage = structcopy(form) AS then access that structure on the second page? ~~ 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: case sensitive sql query
If I remember correctly, when MS SQL Server is installed one determines
whether the DBs will be case sensitive or case insentitive. If the former
is selected, you have to cast or convert everything to upper or lower case
when doing compares as 'a' != 'A'. This of course forces table scans as
placing any sort of evaluation on the left side of the = prevent the use of
an index and you cannot force an index to be case insensitive (I think you
can do this in Oracle). I suspect that the reverse is true in the below
example. If you are casting your varchar as case sensitive, it may not be
able to use the indexes properly. I am not positive, but it is worth
looking into if the tables are large as it will cause a performance hit.
Justin
-Original Message-
From: Alex Santantonio [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 9:59 AM
To: CF-Talk
Subject: RE: case sensitive sql query
SQL Queries ARE NOT case sensitive when doing a WHERE that involves a
varchar. The way to do a Case sensitive WHERE clause depends largely on the
database that you are using. If you are using SQL Server 7/2000 then it is
quite simple. It is even more simple if you are using Stored Procedures to
perform this task. Just use CAST to force your value to binary data and
then compare based on the returned binary data. CAST(ColumnName AS
VARBINARY(ColumnLength)) = CAST('Test Query' AS VARBINARY(ColumnLength)) in
your WHERE within your Stored Procedure. Once you have that set, just make
the 'Test Query' string in your Stored Procedure into a @sp_variable and
pass in the value you are searching on. CAST is preferred over CONVERT.
Alex Santantonio,
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED]
www.doceus.com
-Original Message-
From: cf refactoring [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 9:11 AM
To: CF-Talk
Subject: Re: case sensitive sql query
SQL SELECT queries ARE case sensitive.
The problem is in your data -- you're using columnames
from your tables as data. Depending on the database,
this information is stored in auxiliary tables (in
Oracle, it would be in a table like
all_tab_columns), and may be in a case-insensitive
form. For example, in Oracle, if I run
select column_name, table_name from all_tab_columns
then I see that all the column_names and table_names
are all uppercase even though when I created the
tables, I had mixed case for the table and column
names
--- Bernd VanSkiver [EMAIL PROTECTED] wrote:
Is there a way to do a case sensitive SELECT query?
Don't want to make a
server wide change, just want to specify a single
query to do a case
sensitive search.
SELECT ColumnName
FROM tableName
WHERE ColumnName = 'Test Query'
Want this to do a case sensitive search on the WHERE
clause.
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
~~
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: Re[2]: fieldnames structure
And your Signature says Certified Coldfusion Developer!!! In a sense you can, but then thing is that the web is stateless is it not. So as others have mentioned, you need to place this into the form. Or you could create a wddx packet stick it into a session variable (Not preferred by me) or into a client variable maybe. Then you de-serialize this later on the next page, many ways to do it. But just copying it into a new structure and outputting the new page, without encoding these values into the new page is not going to be able to reference this copied value. And my point is that either way why copy the structure, its one line of code too many!! Regards, Andrew Scott -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: Saturday, 1 September 2001 2:27 AM To: CF-Talk Subject: Re[2]: fieldnames structure Hello Andrew, I don't follow you. why could you not post from pagea to pageb on pageb copy the form structure to another structure post pageb to pagec and access a newly populated form structure AND the structure you created?? -- Critter, MMCP Certified ColdFusion Developer ~~ 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[4]: fieldnames structure
Hello Andrew, And your Signature says Certified Coldfusion Developer!!! yes, but it doesn't say all knowing that's why i'm on the list. thanks for your reply -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Friday, August 31, 2001, 12:56:10 PM, you wrote: AS And your Signature says Certified Coldfusion Developer!!! AS In a sense you can, but then thing is that the web is stateless is it AS not. AS So as others have mentioned, you need to place this into the form. Or AS you could create a wddx packet stick it into a session variable (Not AS preferred by me) or into a client variable maybe. Then you de-serialize AS this later on the next page, many ways to do it. But just copying it AS into a new structure and outputting the new page, without encoding these AS values into the new page is not going to be able to reference this AS copied value. And my point is that either way why copy the structure, AS its one line of code too many!! AS Regards, AS Andrew Scott AS -Original Message- AS From: Critter [mailto:[EMAIL PROTECTED]] AS Sent: Saturday, 1 September 2001 2:27 AM AS To: CF-Talk AS Subject: Re[2]: fieldnames structure AS Hello Andrew, AS I don't follow you. AS why could you not AS post from pagea to pageb AS on pageb copy the form structure to another structure AS post pageb to pagec and access a newly populated form structure AND the AS structure you AS created?? ~~ 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: The biggest cfmail message?
few reasons 1: Bandwidth on your mailserver Depending on the number of recipients your webserver is probably far better optimized for serving images, than your mail server is of sending large numbers of large emails - and the load would be far more distributed as people read their mail, rather than all in one batch when they get sent. (also with any bounced messages - the original email is often attached - and could put additional unneccessary strain on your mailserver) 2: Initial Time to display email Although in absolute terms you're right - it probably take longer to go fetch the images from the live site, the email would appear readable to the recipient as soon as all the mail is recieved - and the images could download in the background as the mail is being read. 3: User Impatience Depending on the file size, and the users bandwidth, they may not be prepared to wait for ages for some unknown massive email to download - whereas when they have it in their inbox they know what it is... 4: Cheapo ISP's restricted mailbox sizes... Some ISP's have really low size limits on their mailbox size - and will bounce messages that won't fit - My old uni only gave 300kb - though I think most commercial ISP's are better... HTH Dan -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 17:00 To: CF-Talk Subject: RE: The biggest cfmail message? At 4:22 PM +0100 8/31/01, Daniel Lancelot wrote: Is this content already displayed online? If so, rather than sending an email with all the images etc attached, you could link to all the image's online locations (absolute href's) and thus reduce your bandwidth requirements substantially (depending on the nature of the content...) HTH Dan Yes, the content is online! The email will have the hrefs as you mention. But, I don't see how this helps the receiver, the email client has to go fetch the images from the live site, as opposed to receiving them as attachments... seems that this would take a little longer. Am I missing something here? Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Efficient Query Manipulation?
I am rather new at CF and am trying to decide how to go about manipulating sets of records in a database. 1)Use cached queries -- OR -- 2)Build an array. My dilemma goes like this... - A user Queries the database and gets a set of say 50 to 100 records in a list. On of the fields retrieved is the SEQUENCE of the record in the list. - Next the user both inserts new items into and deletes current items from this list until they are satisfied with the contents of the list. I can update the database on each insert or deletion, modifying many records to update the SEQUENCE value of the records. (An obvious Downside is lots of database activity) -- OR -- My most current thinking is that stuffing the Query into an Array would be a good idea... Then I could manipulate the Array, inserting and deleting rows until a time where the user would commit the Array. (An obvious Downside is loss of all work done in the session if the App/OrSomethingElse crashes.) Is this an acceptable practice? Are there techniques? What's the view from the Brainiacs on this list? ~~ 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
Help with cfpop
Can anyone suggest where I could start with debugging this error :- Error,TID=630,08/31/01,07:41:14,Unexpected exception while processing a tag with a general identifier of (CFPOP), occupying document position (21:1) to (21:171), while executing template file Thanks In Advance Richard ~~ 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: The biggest cfmail message?
One additional not regarding imaged served by mail server as opposed to web servers - web servers send images in raw format (8-bit) so a 30k images will be delivered in 30k bytes. A mail server sends mail in 7 bit format so the image needs to be MIME-encode in the email. MIME encoding typically adds 50-100% to the size of the image so you would be delivering 45-60k of data for the 30k image. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Daniel Lancelot [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 1:10 PM Subject: RE: The biggest cfmail message? few reasons 1: Bandwidth on your mailserver Depending on the number of recipients your webserver is probably far better optimized for serving images, than your mail server is of sending large numbers of large emails - and the load would be far more distributed as people read their mail, rather than all in one batch when they get sent. (also with any bounced messages - the original email is often attached - and could put additional unneccessary strain on your mailserver) 2: Initial Time to display email Although in absolute terms you're right - it probably take longer to go fetch the images from the live site, the email would appear readable to the recipient as soon as all the mail is recieved - and the images could download in the background as the mail is being read. 3: User Impatience Depending on the file size, and the users bandwidth, they may not be prepared to wait for ages for some unknown massive email to download - whereas when they have it in their inbox they know what it is... 4: Cheapo ISP's restricted mailbox sizes... Some ISP's have really low size limits on their mailbox size - and will bounce messages that won't fit - My old uni only gave 300kb - though I think most commercial ISP's are better... HTH Dan ~~ 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
CFHTTP - help!
Does anyone now how to authenticate with a proxy server using the cfhttp tag. trying to submit a page to an external site then return info to internal. Some people may not have external access so I have to do it at this level. Any help would be great! Christian ~~ 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: CFHTTP - help!
Try specifying an absolute path for the contents of the CFHTTP Get request to be stored in. Thank you, Dan Phillips Express Technologies, Inc. dba CFXhosting.com -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:41 PM To: CF-Talk Subject: CFHTTP - help! Does anyone now how to authenticate with a proxy server using the cfhttp tag. trying to submit a page to an external site then return info to internal. Some people may not have external access so I have to do it at this level. Any help would be great! Christian ~~ 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: The biggest cfmail message?
OMG - I need typing lessons...that should have read: One additional note regarding images served by mail servers as opposed to web servers - web servers send images in raw format (8-bit) so a 30k image will be delivered in 30k bytes. A mail server sends mail in 7 bit format so the image needs to be MIME-encoded in the email. MIME encoding typically adds 50-100% to the size of the image so you would be delivering 45-60k of data for the 30k image. Sorry, Howie - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 1:27 PM Subject: Re: The biggest cfmail message? One additional not regarding imaged served by mail server as opposed to web servers - web servers send images in raw format (8-bit) so a 30k images will be delivered in 30k bytes. A mail server sends mail in 7 bit format so the image needs to be MIME-encode in the email. MIME encoding typically adds 50-100% to the size of the image so you would be delivering 45-60k of data for the 30k image. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon ~~ 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: CFHTTP - help!
That will save the data, but I need to get data first. The proxy server is not authentication my http so I am not ever hitting the site to get any info back. How can I put the username and password in the cfhttp call so that the proxy will allow the request to go through. The username and password in the cfhttp call does not do the trick. Christian -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 12:36 PM To: CF-Talk Subject: RE: CFHTTP - help! Try specifying an absolute path for the contents of the CFHTTP Get request to be stored in. Thank you, Dan Phillips Express Technologies, Inc. dba CFXhosting.com -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:41 PM To: CF-Talk Subject: CFHTTP - help! Does anyone now how to authenticate with a proxy server using the cfhttp tag. trying to submit a page to an external site then return info to internal. Some people may not have external access so I have to do it at this level. Any help would be great! Christian ~~ 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: CFHTTP - help!
Does the proxy server use NT authentication? Is CF on NT? If so it should be possible to change the account CF uses to one with access through the proxy (possibly need a new account creating...) HTH Dan -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 18:54 To: CF-Talk Subject: RE: CFHTTP - help! That will save the data, but I need to get data first. The proxy server is not authentication my http so I am not ever hitting the site to get any info back. How can I put the username and password in the cfhttp call so that the proxy will allow the request to go through. The username and password in the cfhttp call does not do the trick. Christian -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 12:36 PM To: CF-Talk Subject: RE: CFHTTP - help! Try specifying an absolute path for the contents of the CFHTTP Get request to be stored in. Thank you, Dan Phillips Express Technologies, Inc. dba CFXhosting.com -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:41 PM To: CF-Talk Subject: CFHTTP - help! Does anyone now how to authenticate with a proxy server using the cfhttp tag. trying to submit a page to an external site then return info to internal. Some people may not have external access so I have to do it at this level. Any help would be great! Christian ~~ 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: Re[2]: fieldnames structure
- Original Message - And your Signature says Certified Coldfusion Developer!!! And your reply reminds us that your the same old Andrew!!! Why dude? totally un-neccessary Do you practice being an arse - or does that just come natural? no reply needed. Have a happy day. Steve ~~ 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: fieldnames structure
as an addendum to the idea that I sent along, you will need to do some additional work if you are including any checkboxes in your initial form. Use CFPARAM NAME=FORM.checkboxname DEFAULT=defaultvalue at the top of the resulting page to set the checkbox value if the user didn't check it, and then you will need to do a LISTAPPEND(FORM.fieldnames,checkboxname) to include that form name in the field names since CF will not see the checkbox if it isn't selected, and will not automatically insert the name into the fieldnames list when you use the CFPARAM. Just FYI. -Original Message- From: Alex Santantonio [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:57 AM To: CF-Talk Subject: RE: fieldnames structure Loop through the list of field names, CFOUTPUT CFLOOP LIST=#FORM.Fieldnames# INDEX=field INPUT TYPE=Hidden NAME=#field# VALUE=#Evaluate(FORM. Field)# /CFLOOP /CFOUTPUT -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:38 AM To: CF-Talk Subject: fieldnames structure Hi Folks, I'm trying to figure out this structure thing, and I have a project where I have to grab all the fieldname/value pairs from one form, hold them while the user fills out a second page, then send them along in a hidden field to the action page. What's the best way to do this? I thought I could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Messager
If you are using Windows 2000 and the client machines use Windows 2000 you can use the console messaging feature. Not sure what the command line tools are, but you could use cfexecute to process them. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 8:21 AM Subject: CF and Messager Hello, I'm developing an application were our computer labs can track usage and statistics on the machines that are used in there. What I'm looking for is this. Students check in with their ID cards and are asigned a machine. The application then tracks who's on what machine and tracks the time, etc. I'd like to place an agent on each machine that talks back to the application, and when flagged, say, if the student's time is up, I can have pop up a message telling them time's up. Kinda along the lines of the old Novel network messaging system where you could send a message in a popup box to any other machine on the network. Is anybody doing anything like this? If so, what are you using for the agent on the client machines? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP - help!
Good idea, but no dice...the CF service is already running on an nt account that has proxy access. but yes, it does use NT authentication! Christian -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 12:47 PM To: CF-Talk Subject: RE: CFHTTP - help! Does the proxy server use NT authentication? Is CF on NT? If so it should be possible to change the account CF uses to one with access through the proxy (possibly need a new account creating...) HTH Dan -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 18:54 To: CF-Talk Subject: RE: CFHTTP - help! That will save the data, but I need to get data first. The proxy server is not authentication my http so I am not ever hitting the site to get any info back. How can I put the username and password in the cfhttp call so that the proxy will allow the request to go through. The username and password in the cfhttp call does not do the trick. Christian -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 12:36 PM To: CF-Talk Subject: RE: CFHTTP - help! Try specifying an absolute path for the contents of the CFHTTP Get request to be stored in. Thank you, Dan Phillips Express Technologies, Inc. dba CFXhosting.com -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:41 PM To: CF-Talk Subject: CFHTTP - help! Does anyone now how to authenticate with a proxy server using the cfhttp tag. trying to submit a page to an external site then return info to internal. Some people may not have external access so I have to do it at this level. Any help would be great! Christian ~~ 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
IIS login and Cf
Is it possible to grab the login info from an IIS password prompt with ColdFusion? If so how? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Attributes Scope Variable List
All, Is it possible to find out all the variables that are declared in a certain scope? I'm trying to loop over all the variables in the Attributes Scope and insert their contents in hidden form fields. I was wondering if anyone has accomplished something like this. Leon Oosterwijk ISDN-NET Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS login and Cf
CGI.AUTH_PASSWORD CGI.AUTH_TYPE CGI.AUTH_USER -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 2:09 PM To: CF-Talk Subject: IIS login and Cf Is it possible to grab the login info from an IIS password prompt with ColdFusion? If so how? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL Performance...
Sorry about the delay...been gone a couple of days. it depends on the time. If you look in the IMAIL book, the is a registery setting to increase the number of smtp32.exe connections, which is how many messages it can process at one time. I have that set at 100. When you first start the send, Imail will open just about all of them, but after CF stops dumping mail into the spool, Imail slows down to about 15 - 25 every time. I overcome this by manually sending additional messages with the queue viewer in Imail which will start another smtp32.exe instance. I usually pump those up to 75-80 at a time, that way the best I can figure is you send around 100 messages a minute, depending on the size of the message and how long it takes to find the domain. As for delayed responses, I have seen mail servers send back undevs up to a week, and sometimes longer, after all of the messages are emptied out of my mail spool. So that you something you have no control over. Thank you, Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:04 PM To: CF-Talk Subject: RE: CFMAIL Performance... Chritian, How long is it takiing from the point where you start running the query until the final mass of them is delivered in your scenario... We found tuning things and breaking it into blocks allows us to do it, but the turn around on things getting to the users might not happen for a day or two :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: ChristianWatt [EMAIL PROTECTED] Date: Wed, 29 Aug 2001 12:24:25 -0500 Subject: RE: CFMAIL Performance... No problem at all...I send about 790,000 month. Doesn't sound like this is an issue with you, but don't ever send more then 65,000 at one time. CF doesn't have enough names to give the messages in it's mail spool. Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:45 AM To: CF-Talk Subject: CFMAIL Performance... Hi all, I have a list of about 10,000 email addresses - a client wants to do a one-shot email to them (they're all opt-in addresses collected from their web site). It's not an ongoing thing, so Lyris or other systems probably aren't worth it. Can CFMAIL handle it? The client's on a dedicated dual-Pentium machine with 512 meg of RAM... Ian Portent Interactive http://www.portentinteractive.com Combining process, design, content to create great web sites since 1995 ~~ 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
OLE-DB Client Storage Problem
Can anyone explain why I'm getting an error when trying to set up my OLE-DB data store for client variable storage? The data source provider is Microsoft.Jet.OLEDB.4.0. Verify status is OK. I checked off Create Client database tables which generated: Error: Invalid Selection Unknown database type - Unable to create client tables Please uncheck Create Client Tables. So I unchecked it and moved on. The data store is now listed in Client Variables as a Native Data Source type; the Registry shows the type as ODBC. But I have this data store set up as OLE-DB. ??? I really wanted to use my OLE-DB data store for client variable storage. But, as a workaround, I had to set up a separate ODBC data store to do that. It works fine...but seems inefficient. What am I doing wrong? Your help would be greatly appreciated. Thanks, Dina ~~ 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
Using CFMAIL
Hello all I hope I can present this question correctly and that I am looking at the situation from the right angle. I am trying to use CFMAIL to sent emails from the web site. The page itself runs fine. The part I need help in is, how does CF log on to he web server? I have entered the web server in CF admin. Get no errors when web page that generates the mail is run. So unless I am off base, I think that the CF server needs an account on the web server. This itself is not a problem, but how do you get CF to log into the email account? Even users have to long on separately to their email accounts (after logging onto the LAN). Unlike I think most company LANs, when the user signs on, they get access to their email. Or am I going about this all wrong. Thanks for any help Rodney ~~ 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
Detecting Variables names
hey guys, part of my application allows users to create their own forms via a coldfusion template, and they can make it required and set different attributes and what not. Now, on the page where all of their forms are rendered, I have a problem... first of all, is there a way for coldfusion to retrieve all of the form names (or variable names) for me after the page is submitted? and also, i have a problem naming the forms. should I name them dynamically with incrememnts? ~~ 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: Using CFMAIL
CF needs to be configured to use a separate mail server. You set this up in the administrator under miscellaneous/mail option. In there you need to enter the mail server (cname or ip address can be used although ip address is suggested). You also need to set up the server port (this is 25 by standard). After entering this information you click on the verify button to verify that the connection to the mail server can be made by cf. Once you set this up you should be able to use cfmail. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 2:34 PM Subject: Using CFMAIL Hello all I hope I can present this question correctly and that I am looking at the situation from the right angle. I am trying to use CFMAIL to sent emails from the web site. The page itself runs fine. The part I need help in is, how does CF log on to he web server? I have entered the web server in CF admin. Get no errors when web page that generates the mail is run. So unless I am off base, I think that the CF server needs an account on the web server. This itself is not a problem, but how do you get CF to log into the email account? Even users have to long on separately to their email accounts (after logging onto the LAN). Unlike I think most company LANs, when the user signs on, they get access to their email. Or am I going about this all wrong. Thanks for any help Rodney ~~ 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: Detecting Variables names
Hello Fuon, you can use form.fieldnames to retrieve a list of the elements. (is that Ok with you Andrew?) -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Friday, August 31, 2001, 2:57:48 PM, you wrote: FST hey guys, part of my application allows users to create their own forms via FST a coldfusion template, and they can make it required and set different FST attributes and what not. Now, on the page where all of their forms are FST rendered, I have a problem... FST first of all, is there a way for coldfusion to retrieve all of the form FST names (or variable names) for me after the page is submitted? FST and also, i have a problem naming the forms. should I name them dynamically FST with incrememnts? FST ~~ 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: Efficient Query Manipulation?
It is not very efficient to convert query results to an array. The overhead involved is completely avoidable. More often than not the database machine will be more powerful (and reliable) than the CF server. When you are faced with a decision between loading up the DB machine or the CF machine I would choose the DB machine every time. You may also want to modify the interface... Place a checkbox next to each row containing that row's ID and have multiple submit buttons at the bottom such as Delete All Checked Rows, and Move Checked Rows Up, and Move Checked Rows Down. This way you can modify many rows with one query and you don't have to reload the page more than once. You would need to put a little thought into the process in order to maintain an un-broken sequence (i.e. how to avoid a gap between 5 and 7 when deleting 6) and so on... Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:23 AM To: CF-Talk Subject: Efficient Query Manipulation? I am rather new at CF and am trying to decide how to go about manipulating sets of records in a database. 1)Use cached queries -- OR -- 2)Build an array. My dilemma goes like this... - A user Queries the database and gets a set of say 50 to 100 records in a list. On of the fields retrieved is the SEQUENCE of the record in the list. - Next the user both inserts new items into and deletes current items from this list until they are satisfied with the contents of the list. I can update the database on each insert or deletion, modifying many records to update the SEQUENCE value of the records. (An obvious Downside is lots of database activity) -- OR -- My most current thinking is that stuffing the Query into an Array would be a good idea... Then I could manipulate the Array, inserting and deleting rows until a time where the user would commit the Array. (An obvious Downside is loss of all work done in the session if the App/OrSomethingElse crashes.) Is this an acceptable practice? Are there techniques? What's the view from the Brainiacs on this list? ~~ 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: Using CFMAIL
I have done this: I have entered the other mail server's name and port in the admin. When I click to verify I get the error that it can not connect. I have tried both the mail server's name and IP, neither work at this point. The CF server is WINNT 4.0, the Mail server is some flavor of Unix, using SunMail. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:46 AM To: CF-Talk Subject: Re: Using CFMAIL CF needs to be configured to use a separate mail server. You set this up in the administrator under miscellaneous/mail option. In there you need to enter the mail server (cname or ip address can be used although ip address is suggested). You also need to set up the server port (this is 25 by standard). After entering this information you click on the verify button to verify that the connection to the mail server can be made by cf. Once you set this up you should be able to use cfmail. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 2:34 PM Subject: Using CFMAIL Hello all I hope I can present this question correctly and that I am looking at the situation from the right angle. I am trying to use CFMAIL to sent emails from the web site. The page itself runs fine. The part I need help in is, how does CF log on to he web server? I have entered the web server in CF admin. Get no errors when web page that generates the mail is run. So unless I am off base, I think that the CF server needs an account on the web server. This itself is not a problem, but how do you get CF to log into the email account? Even users have to long on separately to their email accounts (after logging onto the LAN). Unlike I think most company LANs, when the user signs on, they get access to their email. Or am I going about this all wrong. Thanks for any help Rodney ~~ 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: Efficient Query Manipulation?
Bryan... Love that you responded... I was beginning to feel invisible on this list ;-) Umm... Ok You say the DBServer should absorb the load, not the CFServer. So Refinding 100 indexed database records is faster/easier/MoreResource Efficient than CFServer manipulating 100 records stored in an Array. Very Interesting point. RE the interface: Thanks for the ideas... not sure what I'll be doing... Currently I have three submit buttons for each Row now... insert above this row, delete this row, edit this row. Just want to work out the best way to do this before going on because it will be central and used heavily in the rest of this application. again, thanks for making me not feel so invisible ;) Gonzo At 12:17 PM 8/31/01 -0700, you wrote: It is not very efficient to convert query results to an array. The overhead involved is completely avoidable. More often than not the database machine will be more powerful (and reliable) than the CF server. When you are faced with a decision between loading up the DB machine or the CF machine I would choose the DB machine every time. You may also want to modify the interface... Place a checkbox next to each row containing that row's ID and have multiple submit buttons at the bottom such as Delete All Checked Rows, and Move Checked Rows Up, and Move Checked Rows Down. This way you can modify many rows with one query and you don't have to reload the page more than once. You would need to put a little thought into the process in order to maintain an un-broken sequence (i.e. how to avoid a gap between 5 and 7 when deleting 6) and so on... Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:23 AM To: CF-Talk Subject: Efficient Query Manipulation? I am rather new at CF and am trying to decide how to go about manipulating sets of records in a database. 1)Use cached queries -- OR -- 2)Build an array. My dilemma goes like this... - A user Queries the database and gets a set of say 50 to 100 records in a list. On of the fields retrieved is the SEQUENCE of the record in the list. - Next the user both inserts new items into and deletes current items from this list until they are satisfied with the contents of the list. I can update the database on each insert or deletion, modifying many records to update the SEQUENCE value of the records. (An obvious Downside is lots of database activity) -- OR -- My most current thinking is that stuffing the Query into an Array would be a good idea... Then I could manipulate the Array, inserting and deleting rows until a time where the user would commit the Array. (An obvious Downside is loss of all work done in the session if the App/OrSomethingElse crashes.) Is this an acceptable practice? Are there techniques? What's the view from the Brainiacs on this list? ~~ 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: Using CFMAIL
All the verify does is connect to the mail server, issue an SMTP HELO and QUIT. I would assume that CF cannot connect to the mail server at all in that case. Try this: Open telnet connect to port 25 of your mail server. Wait for the preamble (some text returned from the server). Type in HELO (without the quotes) Type in QUIT when you are ready to disconnect. Let me know what happens. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 3:21 PM Subject: RE: Using CFMAIL I have done this: I have entered the other mail server's name and port in the admin. When I click to verify I get the error that it can not connect. I have tried both the mail server's name and IP, neither work at this point. The CF server is WINNT 4.0, the Mail server is some flavor of Unix, using SunMail. ~~ 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: Attributes Scope Variable List
The URL and FORM scopes are structures. I think this applies to all scopes
but can't be sure.
You can use the StructKeyArray(Structure) to return an array of the key
elements in a structure. So, if you feed the function the name of the
scope, you get an array of the variable names.
then doing an loop based on the length of the array, you can find the
values.
Here's a sample for the URL scope that I've come up with:
cfscript
if (len(CGI.Query_String) gt 0)
{
URLArray = StructKeyArray(URL);
for (x = 1; x lt arraylen(URLArray); x = x +1)
{
URL[URLArray[x]] = REReplaceNoCase(URL[URLArray[x]], ['],
chr(96), ALL);
URL[URLArray[x]] = REReplaceNoCase(URL[URLArray[x]],
[^]*, , ALL);
}
}
/cfscript
HTH
Shawn Grover
-Original Message-
From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 12:15 PM
To: CF-Talk
Subject: Attributes Scope Variable List
All,
Is it possible to find out all the variables that are declared in a certain
scope? I'm trying to loop over all the variables in the Attributes Scope and
insert their contents in hidden form fields. I was wondering if anyone has
accomplished something like this.
Leon Oosterwijk
ISDN-NET Inc.
~~
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: Efficient Query Manipulation?
Gonzo, There are cases where building a cached array is more efficient. Mainly when you want indexed Access to records (basically your not going to output all your data at once). So consider the following situation lets say you had a table called documents that you accessed the following way... /getDocument.cfm?DocumentID=12 and it would pull the document from the db with that ID out and display it. If you had a cached query your going to have to loop through it and find the correct document (or do a query of a query). It's much faster to access an array element here than perform this comparison. Here's how you might build such an array, for this general document example: put this in application.cfm ... cflock scope=application type=exclusive timeout=20 cfif NOT IsDefined(application.document) cfquery datasource=dsn name=doc SELECT DocumentID, Name, Description, Content FROM documents /cfquery cfset application.document = ArrayNew(1) cfoutput query=doc cfscript application.document[DocumentID] = StructNew(); application.document[DocumentID].Name = doc.Name; application.document[DocumentID].Description = doc.Description; application.document[DocumentID].Content = doc.Content; /cfscript /cfoutput /cfif /cflock Now to access an element, something like this... cflock scope=application type=readonly timeout=20 cfoutput#application.document[url.DocmentID].content#/cfoutput /cflock Note that if someone types in a DocumentID into the url that is not in the array an error will be thrown, you need to catch that error. Also do not use this technique to store large amounts of data, because your server could run out of RAM. ++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 3:36 PM To: CF-Talk Subject: RE: Efficient Query Manipulation? Bryan... Love that you responded... I was beginning to feel invisible on this list ;-) Umm... Ok You say the DBServer should absorb the load, not the CFServer. So Refinding 100 indexed database records is faster/easier/MoreResource Efficient than CFServer manipulating 100 records stored in an Array. Very Interesting point. RE the interface: Thanks for the ideas... not sure what I'll be doing... Currently I have three submit buttons for each Row now... insert above this row, delete this row, edit this row. Just want to work out the best way to do this before going on because it will be central and used heavily in the rest of this application. again, thanks for making me not feel so invisible ;) Gonzo At 12:17 PM 8/31/01 -0700, you wrote: It is not very efficient to convert query results to an array. The overhead involved is completely avoidable. More often than not the database machine will be more powerful (and reliable) than the CF server. When you are faced with a decision between loading up the DB machine or the CF machine I would choose the DB machine every time. You may also want to modify the interface... Place a checkbox next to each row containing that row's ID and have multiple submit buttons at the bottom such as Delete All Checked Rows, and Move Checked Rows Up, and Move Checked Rows Down. This way you can modify many rows with one query and you don't have to reload the page more than once. You would need to put a little thought into the process in order to maintain an un-broken sequence (i.e. how to avoid a gap between 5 and 7 when deleting 6) and so on... Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:23 AM To: CF-Talk Subject: Efficient Query Manipulation? I am rather new at CF and am trying to decide how to go about manipulating sets of records in a database. 1)Use cached queries -- OR -- 2)Build an array. My dilemma goes like this... - A user Queries the database and gets a set of say 50 to 100 records in a list. On of the fields retrieved is the SEQUENCE of the record in the list. - Next the user both inserts new items into and deletes current items from this list until they are satisfied with the contents of the list. I can update the database on each insert or deletion, modifying many records to update the SEQUENCE value of the records. (An obvious Downside is lots of database activity) -- OR -- My most current thinking is that stuffing the Query into an Array would be a good idea... Then I could manipulate the Array, inserting and deleting rows until a time where the user would commit the Array. (An obvious Downside is loss of all work done in the session if the
Quick format question
How do format for phone numbers I want it to print out like: (===) ===- I didn't see it in the CF books. thanks, j ~~ 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
ColdFusion Variable length
Hi All, Does anybody know how big a coldfusion variable could be? Does it truncate at 65k characters? Any help will be greatly appreciated! Sima ~~ 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: Quick format question
CFSET formatPhoneNumber='#Mid(PhoneNumber,1,3)#-#Mid(PhoneNumber,4,3)#-#Mid(PhoneN umber,7,4)#' -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:04 PM To: CF-Talk Subject: Quick format question How do format for phone numbers I want it to print out like: (===) ===- I didn't see it in the CF books. thanks, j ~~ 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
Configuring CF Server to use Java
I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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:Configuring CF Server to use Java (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. = ~~ 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:Configuring CF Server to use Java (I have received youre-mail but will be out of the office) (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ~~ 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:Configuring CF Server to use Java (I have receivedyoure-mail but will be out of the office) (I have received your e-mailbut will be out of the office) (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. === ~~ 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:Configuring CF Server to use Java (I have receivedyoure-mailbut will be out of the office) (I have received your e-mailbut will beout of the office) (I have received your e-mail but will be out of theoffice) (I have received your e-mail but will be out
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. == ~~ 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:Configuring CF Server to use Java (I havereceivedyoure-mailbut will be out of the office) (I have received youre-mailbut will beout of the office) (I have received your e-mail butwill be out of theoffice) (I have received your e-mail but will be out (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. = ~~ 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: Configuring CF Server to use Java (I have receivedyoure-mail but will be out of the office) (I have received your e-mailbut will be out of the office) (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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:Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) (I have receivedyoure-mailbut will beout of the office) (I have received your e-mailbutwill be out of theoffice) (I have received your e-mail but will beout (I (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:46 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ~~ 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:Configuring CF Server to use Java (I havereceivedyoure-mailbut will be out of the office) (I have received youre-mailbut will beout of the office) (I have received your e-mail butwill be out of theoffice) (I have received your e-mail but will be out (I
Uggh Loop! [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Darren Houle [EMAIL PROTECTED] Date: Fri, 31 Aug 2001 17:46:38 -0400 Subject: Re:Configuring CF Server to use Java (I havereceivedyoure- mailbut will be out of the office) (I have received youre-mailbut will beout of the office) (I have received your e-mail butwill be out of theoffice) (I have received your e-mail but will be out (I I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 - - This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. = ~~ 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: Configuring CF Server to use Java (I havereceivedyoure-mail but will be out of the office) (I have received youre-mailbut will be out of the office) (I have received your e-mail butwill be out of the office) (I have received your e-mail but will be ou
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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: Configuring CF Server to use Java
Your JRE path needs to be pointing to the JVM library... So on windows its usually jvm.dll and on unix libjvm.so search for these files on your server and put the path to one of them. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Paul John Summers, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 5:32 PM To: CF-Talk Subject: Configuring CF Server to use Java I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 ~~ 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: Configuring CF Server to use Java (I have receivedyoure-mail but will be out of the office) (I have received your e-mailbut will be out of the office) (I have received your e-mail but will be out of the office)
as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? Nah, I think we should call Dan Tesenair... John (Feeling evil late on a Friday) ~~ 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:Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) (I havereceivedyoure-mailbut will beout of the office) (I have received youre-mailbutwill be out of theoffice) (I have received your e-mail butwill beout (I (I (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:49 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:46 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. === ~~ 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:Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) (I have receivedyoure-mailbut will beout of the office) (I have received your e-mailbutwill be out of theoffice) (I have received your e-mail but will beout (I (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 Uggh Loop! [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Darren Houle [EMAIL PROTECTED] Date: Fri, 31 Aug 2001 17:46:38 -0400 Subject: Re:Configuring CF Server to use Java (I havereceivedyoure- mailbut will be out of the office) (I have received youre-mailbut will beout of the office) (I have received your e-mail butwill be out of theoffice) (I have received your e-mail but will be out (I I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 - - This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. === ~~ 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: Configuring CF Server to use Java (I havereceivedyoure-mailbut will be out of the office) (I have received youre-mailbut will beout of the office) (I have received your e-mail butwill be out of theoffice) (I have received your e-mail but will be ou (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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
negative numbers
I want to check to see if this value is a 0 or a negative number. How would I do this? ~~ 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: Configuring CF Server to use Java (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:59 Your JRE path needs to be pointing to the JVM library... So on windows its usually jvm.dll and on unix libjvm.so search for these files on your server and put the path to one of them. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Paul John Summers, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 5:32 PM To: CF-Talk Subject: Configuring CF Server to use Java I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 ~~ 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: Quick format question
a number of ways: it is probably best to do it in the SQL statement if you have a lot of records, If you can't do it that way and you still have a lot of records then try this: cfoutputcfset foo = insert() ,1234567890,3) (#insert(-,foo,8)#/cfoutput The above method is fast, but this one is easier to understand: (#left(phone,3)#) #mid(phone,4,3)#-#right(phone,4)# Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:04 PM To: CF-Talk Subject: Quick format question How do format for phone numbers I want it to print out like: (===) ===- I didn't see it in the CF books. thanks, j ~~ 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: Attributes Scope Variable List
cfloop collection=#attributes# item=i #i# = #evaluate(attributes. i)#br /cfloop Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:15 AM To: CF-Talk Subject: Attributes Scope Variable List All, Is it possible to find out all the variables that are declared in a certain scope? I'm trying to loop over all the variables in the Attributes Scope and insert their contents in hidden form fields. I was wondering if anyone has accomplished something like this. Leon Oosterwijk ISDN-NET Inc. ~~ 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:Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) ( Ihavereceivedyoure-mailbut will beout of the office) (I have receivedyoure-mailbutwill be out of theoffice) (I have received your e-mailbutwill beout (I (I (I (
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:55 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:49 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:46 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. == ~~ 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: Slightly OT: CF + Generator
Simon, Yes, you absolutley can. Here is a website that we recently did using ColdFusion and Generator: http://www.miriellografico.com/ Generator templates can produce dynamic media from datasources. These datasources can be either a JDBC/ODBC connection or a text file. We used ColdFusion extensivley in this application to format the data we pull from SQL Server and produce dynamic text files.. In this case, CF is just acting as a middle man between the database and Generator. While you can connect directly to databases with Generator, using a middle-ware scripting language like CF allows you much more flexibility. There are two methods of using Generator, online and offline (CF can assist both methods). When using online Generation, your media is generated at each request (However, you do have the ability to do some server side caching of this media). This method works fine for smaller, lower traffic Generator sites, or components that change very often (stock tickers, etc). When using offline generation, you produce static copies of the media in batch. Some larger content management tools do similar operations, producing static HTML files from the output of CF templates. Offline Generation is vital for larger sites. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] http://www.ninthlink.com 619.222.7082 - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 12:52 AM Subject: Slightly OT: CF + Generator I am under the impression that you can use CF pages to create dynamic flash pages with Generator. Does anyone know more details about this or have examples that I could look through? Cheers Simon ~~ 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
(I havereceivedyoure-mail but will be out of the office)
So - are we all really looking at 10 days of this while he is out of the office? Please say it isn't so. Tony -Original Message- From: Darren Houle [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 2:53 PM To: CF-Talk Subject: RE: Configuring CF Server to use Java (I havereceivedyoure-mail but will be out of the office) (I have received youre-mailbut will be out of the office) (I have received your e-mail butwill be out of the office) (I have received your e-mail but will be ou I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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: Configuring CF Server to use Java (I have receivedyoure-mail but will be out of the office) (I have received your e-mailbut will be out of the office) (I have received your e-mail but will be out of the office)
hmm we could always sequentially loop it by sending him mail then having our end respond with the response... and it will get bigger and bigger til one side loses :) great server stress testing too :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: John Paitel [EMAIL PROTECTED] Date: Fri, 31 Aug 2001 14:56:03 -0700 Subject: RE: Configuring CF Server to use Java (I have receivedyoure- mail but will be out of the office) (I have received your e-mailbut will be out of the office) (I have received your e-mail but will be out of the office) as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? Nah, I think we should call Dan Tesenair... John (Feeling evil late on a Friday) ~~ 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:Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) (I havereceivedyoure-mailbut will beout of the office) (I have received youre-mailbutwill be out of theoffice) (I have received your e-mail butwill beout (I (I (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:59 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 Uggh Loop! [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Darren Houle [EMAIL PROTECTED] Date: Fri, 31 Aug 2001 17:46:38 -0400 Subject: Re:Configuring CF Server to use Java (I havereceivedyoure- mailbut will be out of the office) (I have received youre-mailbut will beout of the office) (I have received your e-mail butwill be out of theoffice) (I have received your e-mail but will be out (I I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 - - This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. === ~~ 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: Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) (I have receivedyoure-mailbut will beout of the office) (I have received your e-mailbutwill be out of theoffice) (I have received your e-mail but will beou (I (I
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:02 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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:negative numbers (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:07 I want to check to see if this value is a 0 or a negative number. How would I do this? ~~ 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: Configuring CF Server to use Java (I have received youre-mail but will be out of the office) (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:05 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:59 Your JRE path needs to be pointing to the JVM library... So on windows its usually jvm.dll and on unix libjvm.so search for these files on your server and put the path to one of them. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Paul John Summers, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 5:32 PM To: CF-Talk Subject: Configuring CF Server to use Java I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 ~~ 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: Quick format question (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:07 a number of ways: it is probably best to do it in the SQL statement if you have a lot of records, If you can't do it that way and you still have a lot of records then try this: cfoutputcfset foo = insert() ,1234567890,3) (#insert(-,foo,8)#/cfoutput The above method is fast, but this one is easier to understand: (#left(phone,3)#) #mid(phone,4,3)#-#right(phone,4)# Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:04 PM To: CF-Talk Subject: Quick format question How do format for phone numbers I want it to print out like: (===) ===- I didn't see it in the CF books. thanks, j ~~ 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: Attributes Scope Variable List (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:09 cfloop collection=#attributes# item=i #i# = #evaluate(attributes. i)#br /cfloop Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 11:15 AM To: CF-Talk Subject: Attributes Scope Variable List All, Is it possible to find out all the variables that are declared in a certain scope? I'm trying to loop over all the variables in the Attributes Scope and insert their contents in hidden form fields. I was wondering if anyone has accomplished something like this. Leon Oosterwijk ISDN-NET Inc. ~~ 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: negative numbers
cfset intFoo = -3 cfif isNumeric(intFoo) and intFoo lte 0 the value is 0 or a negative number /cfif -Tyson -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 5:07 PM To: CF-Talk Subject: negative numbers I want to check to see if this value is a 0 or a negative number. How would I do this? ~~ 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:Configuring CF Server to use Java ( Ihavereceivedyoure-mailbut will be out of the office) ( Ihavereceivedyoure-mailbut will beout of the office) (I havereceivedyoure-mailbutwill be out of theoffice) (I have received youre-mailbutwill beout (I (I (I ( (
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:10 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:55 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:49 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:46 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:43 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:40 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:37 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:34 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/30/01 17:31 I am trying to configure my CF Server to use Java objects and it doesn't recognize my JVM path. Can anyone make any recommendations? The exact error message I get when I try to instantiate a Java object is: The JVM library could not be found. Please check if the file specified in the ColdFusion Administrator actually exists. However, I am pointing my CF Server to the the JAVA_ROOT/jre/bin directory and my classpath to the only place in which I have created or to which I have downloaded class files. Any help would be greatly appreciated. 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 MMS health-first.org made the following annotations on 08/31/01 17:41:09 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. = ~~ 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: negative numbers
u can do a CFIF number GT 0 or number LT 0 or, do a multiplication with a number like 5. if the result is 0, then that number is a zero. if the result is a negative number, then that number is negative. there's lots of ways :) From: Joshua Tipton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: negative numbers Date: Fri, 31 Aug 2001 18:07:29 -0400 I want to check to see if this value is a 0 or a negative number. How would I do this? ~~ 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: Slightly OT: CF + Generator (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:28 Simon, Yes, you absolutley can. Here is a website that we recently did using ColdFusion and Generator: http://www.miriellografico.com/ Generator templates can produce dynamic media from datasources. These datasources can be either a JDBC/ODBC connection or a text file. We used ColdFusion extensivley in this application to format the data we pull from SQL Server and produce dynamic text files.. In this case, CF is just acting as a middle man between the database and Generator. While you can connect directly to databases with Generator, using a middle-ware scripting language like CF allows you much more flexibility. There are two methods of using Generator, online and offline (CF can assist both methods). When using online Generation, your media is generated at each request (However, you do have the ability to do some server side caching of this media). This method works fine for smaller, lower traffic Generator sites, or components that change very often (stock tickers, etc). When using offline generation, you produce static copies of the media in batch. Some larger content management tools do similar operations, producing static HTML files from the output of CF templates. Offline Generation is vital for larger sites. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] http://www.ninthlink.com 619.222.7082 - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 31, 2001 12:52 AM Subject: Slightly OT: CF + Generator I am under the impression that you can use CF pages to create dynamic flash pages with Generator. Does anyone know more details about this or have examples that I could look through? Cheers Simon ~~ 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: (I havereceivedyoure-mail but will be out of the office)
bahehehehe :) From: Tony Gruen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: (I havereceivedyoure-mail but will be out of the office) Date: Fri, 31 Aug 2001 15:14:43 -0700 So - are we all really looking at 10 days of this while he is out of the office? Please say it isn't so. Tony -Original Message- From: Darren Houle [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 2:53 PM To: CF-Talk Subject: RE: Configuring CF Server to use Java (I havereceivedyoure-mail but will be out of the office) (I have received youre-mailbut will be out of the office) (I have received your e-mail butwill be out of the office) (I have received your e-mail but will be ou I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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:(I havereceivedyoure-mail but will be out of the office) (I have received your e-mail but will be out of the office)
I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 18:14 So - are we all really looking at 10 days of this while he is out of the office? Please say it isn't so. Tony -Original Message- From: Darren Houle [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 2:53 PM To: CF-Talk Subject: RE: Configuring CF Server to use Java (I havereceivedyoure-mail but will be out of the office) (I have received youre-mailbut will be out of the office) (I have received your e-mail butwill be out of the office) (I have received your e-mail but will be ou I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Thank you, Darren Houle Sr. Web Developer cf-talk 08/31/01 17:52 I have received your e-mail but will be out of the office 9/9/01. I will be checking messages while away and will get back to you as soon as possible. If this is an urgent request please contact Dan Tesenair. Can we automatically unsub people who do this? ~~ 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
Mulit-User Concurrency
Sure... I see, Thanks Pete. A Cached Array for persistent data which is index pointers so to speak... yep makes sense. Ok... NOW, Thinking deeper... How are people handling Multi-User concurrency issues? How to not overwrite someone elses changes to a record while pondering how to make your own changes to the record IE: User A reads Record #1. User B reads record #1. User B changes fields[3,4,5] in Record #1 and rewrites the entire record. User A changes fields[7,8,9] in Record #1 and overwrites [3,4,5] with old data just changed by User B. In the past I have used the Classic Lock/ReReadRecord/ModifyMyChangedFieldsOnly/WriteRecord/UnLock scenario to avoid this via built in tools... What does CF have built in or in the way of custom tags to help with this? At 04:01 PM 8/31/01 -0400, you wrote: Gonzo, There are cases where building a cached array is more efficient. Mainly when you want indexed Access to records (basically your not going to output all your data at once). So consider the following situation lets say you had a table called documents that you accessed the following way... /getDocument.cfm?DocumentID=12 and it would pull the document from the db with that ID out and display it. If you had a cached query your going to have to loop through it and find the correct document (or do a query of a query). It's much faster to access an array element here than perform this comparison. Here's how you might build such an array, for this general document example: put this in application.cfm ... cflock scope=application type=exclusive timeout=20 cfif NOT IsDefined(application.document) cfquery datasource=dsn name=doc SELECT DocumentID, Name, Description, Content FROM documents /cfquery cfset application.document = ArrayNew(1) cfoutput query=doc cfscript application.document[DocumentID] = StructNew(); application.document[DocumentID].Name = doc.Name; application.document[DocumentID].Description = doc.Description; application.document[DocumentID].Content = doc.Content; /cfscript /cfoutput /cfif /cflock Now to access an element, something like this... cflock scope=application type=readonly timeout=20 cfoutput#application.document[url.DocmentID].content#/cfoutput /cflock Note that if someone types in a DocumentID into the url that is not in the array an error will be thrown, you need to catch that error. Also do not use this technique to store large amounts of data, because your server could run out of RAM. ++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 3:36 PM To: CF-Talk Subject: RE: Efficient Query Manipulation? Bryan... Love that you responded... I was beginning to feel invisible on this list ;-) Umm... Ok You say the DBServer should absorb the load, not the CFServer. So Refinding 100 indexed database records is faster/easier/MoreResource Efficient than CFServer manipulating 100 records stored in an Array. Very Interesting point. RE the interface: Thanks for the ideas... not sure what I'll be doing... Currently I have three submit buttons for each Row now... insert above this row, delete this row, edit this row. Just want to work out the best way to do this before going on because it will be central and used heavily in the rest of this application. again, thanks for making me not feel so invisible ;) Gonzo At 12:17 PM 8/31/01 -0700, you wrote: It is not very efficient to convert query results to an array. The overhead involved is completely avoidable. More often than not the database machine will be more powerful (and reliable) than the CF server. When you are faced with a decision between loading up the DB machine or the CF machine I would choose the DB machine every time. You may also want to modify the interface... Place a checkbox next to each row containing that row's ID and have multiple submit buttons at the bottom such as Delete All Checked Rows, and Move Checked Rows Up, and Move Checked Rows Down. This way you can modify many rows with one query and you don't have to reload the page more than once. You would need to put a little thought into the process in order to maintain an un-broken sequence (i.e. how to avoid a gap between 5 and 7 when deleting 6) and so on... Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:23 AM To: CF-Talk Subject: Efficient Query Manipulation? I am rather new at CF and am trying to decide how to go about manipulating sets of records in a database. 1)Use cached
