OT: Server logging tools [Was server monitoring tools]
Hello CFlers, thank you all for your contributions on this issue. Indeed all the software you guys mentioned didn't really focus on what we need. O.K. Mutek's Appsight is a monitoring tool as well, but what is more interesting in this tool is the fact that it is logging every activity on the computer. Every thread, every handle every *.exe-activity on NT/2000 machines. I look for such a tool rather than tools like Ipswitch's What's UP. Forgive my unclear decriptions of our needs on the first question. AppSight itself is as I said far too expensive. Thanks for further ideas. Uwe - Original Message - From: Conrad Classen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 9:53 AM Subject: RE: Server monitoring tools Have you had a look at WhatsUp Gold by Ipswitch.com Quiet a comprehensive solution, and monitors remote systems as well. Has Alerts which can be sent via SMTP or a pager. It can also monitor DNS, SMTP, Telnet, HTTP, etc. Conrad -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 9:44 PM To: CF-Talk Subject: OT: Server monitoring tools Hi, does s.o. know any good server monitoring tools like Mutek's AppSight ( www.mutek.com ) ? This tool is far too expensive (but indeed very nice) for me. We have some freezing-problems with our Win-NT-CF-server and nothing is showing in the logs. Thanks ! Uwe ~~ 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
Studio 4.5.1 and Windows 2000 Professional
Does anyone know why I can only view the Studio program folder when logged in as the Administrator on a Windows 2000 Professional machine, and not when logged in as a User or a Power User? I read that Power Users are allowed to run legacy applications (I assumed that was the reason why it wasn't visible under the User account), but the Studio program folder still wasn't visible after that account had been added to the Power User group. BTW, 2000 Pro newbie here, so be kind... Thanks Aidan -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick format question
How is it done in the sql statement. I'm thinking that would be the best way to go since the data needs to be kicked out to a pdf. Thanks, j -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 6:08 PM To: CF-Talk Subject: 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 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick format question
How is it done in the sql statement. As always with anything to do with string functions or date functions, the answer is, it depends what DBMS you're using. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Displaying an image with CFcontent
I'm trying to pull an image out on a database and display it without writing a file to the disk. I tried this... cfcontent type=image/jpeg cfoutput#toBinary(Base64imageFromDatabase)#/cfoutput And, of course, cfoutput won't let me do this because it wants a string, not a binary value. I could write the file to the disk, then display and delete it (using cffile then cfcontent for the last 2 steps). I'd like to cut those steps out, though. All those disk writes effect the performance of this application. Is there any way I can go from the database to CFContent? Thanks, EC ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mulit-User Concurrency
Another old approach that might work better in the who-knows-how-long-the-user-will-take-or-even-if-they're-still-logged-in world of the web is 1) when selecting include a magic field (explained below) 2) let user make edits with the UIl; when ready to save 3) within a db transaction check to see that the magic field has not changed; if unchanged, do the update, but if changed, re-select data, notify user, display their data and the just-retrieved data so they can decide to overwrite or back off SQL Server (Sybase Microsoft) had/have a specific datatype for this magic field called TIMESTAMP (a name that was a recurrent source of confusion) but it could be implemented in any modern RDBMS; you just need a field that, through triggers or something, is _guaranteed_ to increment any time the record is updated. -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 6:39 PM To: CF-Talk Subject: 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.
RE: Problem with Java
Are u using CF5? If so, have you tried rebooting the server?? I found that I could not get the server to recognise my changes to the Java settings in administrator until I rebboted the server... HTH Dan -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 06:23 To: CF-Talk Subject: Re: Problem with Java Have you added the CFX to the CFX Tags section in the CF Administrator? If you have... Where is your class? For development purposes, and to ensure it's configured properly, I put them in the \cfusion\java\classes folder, then when they are ready to go to live use, I'll put them in the correct folders. on 4/9/01 2:58 PM, David Lawrence at [EMAIL PROTECTED] wrote: Hi All I am trying to use a CFX Java tag and am having problems... I have installed 'Java 2 SDK Standard Edition 1.3.1' and have configured the CF Administrator (within the Java area and the CFX area). Everytime I try to run the page calling the tag I get the following error: java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I imagine this means the application cannot find the relevant Class, but I am not sure where I am going wrong. When installing the SDK I simply used the standard install without any further modifications. Any ideas out there? Thanks David Lawrence Red 5 Interactive Media FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
source safe integration
Did we lose this in the admin web page of CF 5 Server? Tom ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: New Discussion List
Excuse the intrusion, but I thought this might be relevant to all of us IT-Talk is a new discussion list formed by the people who brought you JS-Jive (http://groups.yahoo.com/group/JS-Jive) and the RIMZOO Developer's Forum (http://groups.yahoo.com/group/RIMZOO)! IT-Talk is a group for the open discussion of all things Internet Technology related. From web server software, programming languages, internet related issues, wireless web, web statistics, browser wars, etc. If it pertains to the web, then it's fair game. This group serves as an overflow buffer to other programming and internet discussions that may be off topic for your other discussion groups. SPAM is not permitted. If you would like to join, send a blank email to mailto:[EMAIL PROTECTED] or visit the home page at http://groups.yahoo.com/group/IT-Talk. We are eagerly looking forward to your participation and contributions! Thanks, Steve Reich Moderator, IT-Talk ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server monitoring tools
Well, there is the one that comes as a part of IIS. I'm not sure, however, whether or not you can install it on Windows 2000 Professional. If not, you might check out Mercury (http://www.pmail.com/) by the folks who make the Pegasus E-mail client. I've never used it myself but it is free. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 5:46 PM To: CF-Talk Subject: Re: Server monitoring tools Looks good. I'm looking for something like this so I can get rid of my $30/month hosting acct that runs my own monitor. Need to spend a little time on that project. Since I use Apache at home I have to find a dirt-basic smtp that runs on win2k pro. Anyone have any ideas on that? Its sole purpose would be to send monitor emails if something goes down. - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Mike Brunt [EMAIL PROTECTED] Pretty basic, reasonable price ($70.00 for single user) but we like it http://servermonitoringsoftware.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Application.cfm Error
In the CF-Admin, do you have the registry set up as the container for client variables? If so, are ColdFusion services running under an account that has access to the registry? You may want to use a database to store client variables. -Original Message- From: John Patterson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 9:30 AM To: CF-Talk Subject: Application.cfm Error Hello, I received a cf error using my application which is being hosted. The hosting service didn't know what the problem could be. The error I was receiving was: Error attempting to get the client(ClientID='207026') A Problem was encountered trying to access the system registry. Error number 1450 occurred. The error occurred while processing an element with a general identifier of (CFAPPLICATION). Here is what I have for my cfapplication: cfapplication name=SFS sessionmanagement=Yes clientmanagement=Yes setclientcookies=Yes SESSIONTIMEOUT=#CreateTimeSpan(0,0,20,0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0,0,30,0)# Does someone know what may have happened or how I can prevent it from happening? Thanks. John ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
help with moving from access to sql server
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit
column.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (21:1) to (21:53).
I realise that this is caused by trying to group according to the bit
datatype.
However when I remove the grouping for this it gives an error saying
that I need to group.
This is the query I am using. Can anybody suggest a way of getting
around this.
cfquery name=gethdrs datasource=#Variables.DSN#
SELECT DISTINCT Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Quarter_ID,
Programme_Details.Locked, Programme_details.Prog_Status,
Programme_Details.ILX, Programme_Details.Executive,
Programme_Details.BSS, Programme_Details.Prog_result
FROM Programme_Hdr, Programme_Details, Business_Units2
WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID
cfif form.Programme_Name NEQ ALL
AND Programme_Name = '#Form.Programme_Name#'
/cfif
cfif form.year NEQ ALL
AND Programme_Details.Year = '#Form.Year#'
/cfif
cfif form.quarter NEQ ALL
AND Programme_Details.Quarter = '#Form.Quarter#'
/cfif
cfif form.Business_unit NEQ ALL
AND Programme_Hdr.Business_Unit = '#form.Business_Unit#'
/CFIF
cfif listcontains(session.access,'5') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND Programme_Details.Executive = 1
OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED'))
/cfif
cfif listcontains(session.access,'3') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND
Programme_Details.BSS = 0))
/cfif
cfif listcontains(session.access,'2') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND
Programme_Details.ILX = 0))
/cfif
cfif NOT listcontains(session.access, '1') AND NOT
listcontains(session.access, '2') AND NOT listcontains(session.access,
'5')
AND Business_Units2.bss_Name = '#session.bss#'
AND Programme_Hdr.Business_Unit = Business_Units2.bu_name
/cfif
cfif listcontains(session.access, '4') AND NOT
listcontains(session.access, '5')
AND Programme_Hdr.Business_Unit = '#session.b_unit#'
/cfif
AND Programme_Details.archived = 0
Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Locked,
Programme_Details.Prog_Status, Programme_Details.ILX,
Programme_Details.BSS, Programme_Details.Executive,
Programme_Details.Prog_result
cfif not parameterexists(url.orderby)
ORDER by Programme_Hdr.Business_Unit, Programme_Details.Quarter
Cfelse
cfif parameterexists(url.Orderby) and url.orderby eq BU
Order by Programme_Hdr.Business_Unit
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq PN
Order by PROGRAMME_hdr.Programme_Name
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq YR
Order by PROGRAMME_DETAILS.YEAR
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq QR
Order by PROGRAMME_DETAILS.Quarter
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq RN
Order by PROGRAMME_HDR.Region
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
/cfif
/cfif
/cfquery
thanks,
Regards,
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need to be? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
Is it possible you are pointing to a SQL view - and the error is in the SQL view - I too cannot see anything obviously wrong with the SQL (with regards to the CF - parameterexists() function has been deprecated and has been replaced by isdefined() ) Cheers Dan -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 15:48 To: CF-Talk Subject: RE: help with moving from access to sql server Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need to be? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Any forums software based on CF-Express?
SMB (simplemessageboard.com) requires just a few modificiations (removing some cftransactions, etc.) to run on CF-Express. Someone has already done it - I have a zip of it somewhere. ;p So, any available? If not, I'm writing one :) ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MIME Type email and CF
Can you send MIME email using CF, either with cfmail in CF 4.01? Thanks! Clint ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:weird behaviour using yes/no field in Access
Hi I wonder if anyone has come across this before. To set a yes no field in Access to yes I usually insert a 1, this seems to work. Also when searching for checked fields, searching for the value 1 for yes/no fields usually works as well. Of recent I have noticed that this no longer works. I now need to check for yes with no quotes quotes or minus 1, checking for 1 will not match checked fields. As I've never had this problem before I'm wondering if this could possibly have anything to do with CF5 and the drivers it ships with as this is the only change which has been made to the site. Thanks in advance Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MIME Type email and CF
CFMAIL allows you to send html mail and MIME-encoded attachments. Is that what you need? 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: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:14 AM Subject: MIME Type email and CF Can you send MIME email using CF, either with cfmail in CF 4.01? Thanks! Clint ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: help with moving from access to sql server
use cast() or convert() to change the datatype in your qry
On Tue, 4 Sep 2001, Declan Maher wrote:
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit
column.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (21:1) to (21:53).
I realise that this is caused by trying to group according to the bit
datatype.
However when I remove the grouping for this it gives an error saying
that I need to group.
This is the query I am using. Can anybody suggest a way of getting
around this.
cfquery name=gethdrs datasource=#Variables.DSN#
SELECT DISTINCT Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Quarter_ID,
Programme_Details.Locked, Programme_details.Prog_Status,
Programme_Details.ILX, Programme_Details.Executive,
Programme_Details.BSS, Programme_Details.Prog_result
FROM Programme_Hdr, Programme_Details, Business_Units2
WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID
cfif form.Programme_Name NEQ ALL
AND Programme_Name = '#Form.Programme_Name#'
/cfif
cfif form.year NEQ ALL
AND Programme_Details.Year = '#Form.Year#'
/cfif
cfif form.quarter NEQ ALL
AND Programme_Details.Quarter = '#Form.Quarter#'
/cfif
cfif form.Business_unit NEQ ALL
AND Programme_Hdr.Business_Unit = '#form.Business_Unit#'
/CFIF
cfif listcontains(session.access,'5') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND Programme_Details.Executive = 1
OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED'))
/cfif
cfif listcontains(session.access,'3') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND
Programme_Details.BSS = 0))
/cfif
cfif listcontains(session.access,'2') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND
Programme_Details.ILX = 0))
/cfif
cfif NOT listcontains(session.access, '1') AND NOT
listcontains(session.access, '2') AND NOT listcontains(session.access,
'5')
AND Business_Units2.bss_Name = '#session.bss#'
AND Programme_Hdr.Business_Unit = Business_Units2.bu_name
/cfif
cfif listcontains(session.access, '4') AND NOT
listcontains(session.access, '5')
AND Programme_Hdr.Business_Unit = '#session.b_unit#'
/cfif
AND Programme_Details.archived = 0
Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Locked,
Programme_Details.Prog_Status, Programme_Details.ILX,
Programme_Details.BSS, Programme_Details.Executive,
Programme_Details.Prog_result
cfif not parameterexists(url.orderby)
ORDER by Programme_Hdr.Business_Unit, Programme_Details.Quarter
Cfelse
cfif parameterexists(url.Orderby) and url.orderby eq BU
Order by Programme_Hdr.Business_Unit
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq PN
Order by PROGRAMME_hdr.Programme_Name
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq YR
Order by PROGRAMME_DETAILS.YEAR
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq QR
Order by PROGRAMME_DETAILS.Quarter
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq RN
Order by PROGRAMME_HDR.Region
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
/cfif
/cfif
/cfquery
thanks,
Regards,
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange CFMail Error
A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing. cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Missing File Encountered cfoutput query=q404 group=adSite #repeatstring(=,50)# #adSite# #repeatstring(=,50)# cfoutput #repeatstring(-,50)# Date: #dateformat(adDateTime,mm/dd/)# #timeformat(adDateTime,hh:mm:ss tt)# File: #adFile# Referring Page: #adReferer# /cfoutput /cfoutput #repeatstring(=,50)# To be removed: a href=mailto:[EMAIL PROTECTED]?SUBJECT=Remove%20From%20404%20Digest;dev@eagl etgi.com/a #repeatstring(=,50)# /cfmail Any reason why this error would occur??? My CFMAIL doesn't have a query specified at all... I have 2 nested outputs running inside the CFMAIL and that's it. Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX_HTTP
Does anyone have the documentation for this tag? Thanks in advance. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion license agreement
So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Retraction: Strange CFMail Error
Not strange, guess you just can't do a CFOUTPUT inside a CFMAIL ... oops Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:03 PM To: [EMAIL PROTECTED] Subject: Strange CFMail Error A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing. cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Missing File Encountered cfoutput query=q404 group=adSite #repeatstring(=,50)# #adSite# #repeatstring(=,50)# cfoutput #repeatstring(-,50)# Date: #dateformat(adDateTime,mm/dd/)# #timeformat(adDateTime,hh:mm:ss tt)# File: #adFile# Referring Page: #adReferer# /cfoutput /cfoutput #repeatstring(=,50)# To be removed: a href=mailto:[EMAIL PROTECTED]?SUBJECT=Remove%20From%20404%20Digest;dev@eagl etgi.com/a #repeatstring(=,50)# /cfmail Any reason why this error would occur??? My CFMAIL doesn't have a query specified at all... I have 2 nested outputs running inside the CFMAIL and that's it. Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: weird behaviour using yes/no field in Access
Ah... question: In which version of MDAC does this become broken? I've been using 1/0, both in setting and in testing boolean (yes/no) fields in Access for years, thinking that this was the most portable (that is, compatible with SQL Server) coding technique. Jim -Original Message- From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, September 04, 2001 9:44 AM Subject: RE: weird behaviour using yes/no field in Access Just a guess. Have you recently installed a newer version of MDAC? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 11:16 AM To: CF-Talk Subject: OT:weird behaviour using yes/no field in Access Hi I wonder if anyone has come across this before. To set a yes no field in Access to yes I usually insert a 1, this seems to work. Also when searching for checked fields, searching for the value 1 for yes/no fields usually works as well. Of recent I have noticed that this no longer works. I now need to check for yes with no quotes quotes or minus 1, checking for 1 will not match checked fields. As I've never had this problem before I'm wondering if this could possibly have anything to do with CF5 and the drivers it ships with as this is the only change which has been made to the site. Thanks in advance Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: weird behaviour using yes/no field in Access
With the Yes/No fields, zero represents a No/False value, any non-zero value represents a Yes/True value. Therefore, a value of 1 or -1 mean the same thing. When dealing with the Yes/No field (or any boolean field), you should be checking for True/False. Leave the details of the values to the system (like it was designed to do). (there are exceptions of course, such as if you use a char(1) field to hold a Y or N value for boolean purposes). My two cents worth. Shawn Grover -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 9:22 AM To: CF-Talk Subject: RE: weird behaviour using yes/no field in Access Just a guess. Have you recently installed a newer version of MDAC? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 11:16 AM To: CF-Talk Subject: OT:weird behaviour using yes/no field in Access Hi I wonder if anyone has come across this before. To set a yes no field in Access to yes I usually insert a 1, this seems to work. Also when searching for checked fields, searching for the value 1 for yes/no fields usually works as well. Of recent I have noticed that this no longer works. I now need to check for yes with no quotes quotes or minus 1, checking for 1 will not match checked fields. As I've never had this problem before I'm wondering if this could possibly have anything to do with CF5 and the drivers it ships with as this is the only change which has been made to the site. Thanks in advance Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Formatting Text for Email/Text Files
Here's a function for CF 5:
call it like cfset mybody = makeNiceEmail(mybody,70)
cfscript
function makeNiceEmail(string, theLength) {
CRLF=chr(13);
for (i=theLength-1;i LTE Len(string);i=i+theLength){
string = Insert(CRLF,string,i);
}
return string;
}
/cfscript
tom
www.basic-ultradev.com
Dennis Powers [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
It has been a long working weekend and my brain is suitably befuddled at
the
moment. I am attempting to format text for use in an email or a RAW text
file and wish to insert a carriage return/line feed at the closest space,
with out breaking the words, to the 60-70 characters point for each line.
I am pulling text data out of a database that only has CR/LF breaks at the
paragraph level. The paragraphs can run several hundreds words (don't
ask -
it's PhD speak stuff) I need to create text files from the data with CR/LF
breaks inserted within the paragraphs to break at a space within the
60-70-character point.
I am sure someone has done this before and am hoping that you might be
willing to take pity on one of your fellow CF'ers and share some code.
Best regards,
Dennis Powers
UXB Internet
(203)879-2844
http://www.uxbinfo.com/
~~
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
SandBox Security Problems
Hi @all, i'm trying to set up a SandBox Security on our server, but it does not work. After I set the rules and created the policies, I start the SandBox. But now, absolutely no webpage can be found on the server! I get the error-information, that there is an SandBox-Error because of an invalid user or bad password! Where can i set this password? And what password do I have to choose for anonymous visitor's of the sites??? greez cybergnom ~~ 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: weird behaviour using yes/no field in Access
Not sure, i didnt do the installation. Stranegly it now works again? Bit of a mystery. Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 16:22 To: CF-Talk Subject: RE: weird behaviour using yes/no field in Access Just a guess. Have you recently installed a newer version of MDAC? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 11:16 AM To: CF-Talk Subject: OT:weird behaviour using yes/no field in Access Hi I wonder if anyone has come across this before. To set a yes no field in Access to yes I usually insert a 1, this seems to work. Also when searching for checked fields, searching for the value 1 for yes/no fields usually works as well. Of recent I have noticed that this no longer works. I now need to check for yes with no quotes quotes or minus 1, checking for 1 will not match checked fields. As I've never had this problem before I'm wondering if this could possibly have anything to do with CF5 and the drivers it ships with as this is the only change which has been made to the site. Thanks in advance Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ 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: ColdFusion license agreement
CF Studio includes a single-user version of CF Server Enterprise that should solve your problem. Ken -Original Message- From: P Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:07 PM To: CF-Talk Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
No, you can't install the one you are using in production, but if you are using a licensed version of CF Studio, that comes with a single IP version of CF for use by developers. If you are not using CF Studio, perhaps you should be! :P Marwan Saidi Webmaster CED - Concord IS [EMAIL PROTECTED] 407.741.8645 -Original Message- From: P Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:07 PM To: CF-Talk Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion license agreement
ColdFusion Studio comes with a single user verison of CF that is exactly for this purpose. 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: P Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 12:07 PM Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
If not, how do I get around the problem with out having to buy a copy? If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX_HTTP
Kwang, Here is the text from the archive, which I have sent you off-list: [ cut here ] ColdFusion custom tag for performing HTTP reads Copyright 1999 Follett Software Company The CFHTTP tag that comes as part of ColdFusion is a fine and useful thing, except that it doesn't allow the user to see response codes or headers. For anything more than cursory page retrieval (such as building a spider), this is inadequate. So we wrote CFX_HTTP, using Visual C++ 5.0. Parameters URL Required. Fully qualified URL to retrieve. It must be an HTTP URL. UserAgent Optional. Specifies the User-Agent: HTTP header to be passed to the server. This header is the name that shows up in the target site's log. This helps the site know who is visiting their site. For our internal link-checking spider that we call the WebChimp, the UserAgent parm is WebChimp/1.0. Verb Optional. Specifies the HTTP verb to use (either GET or HEAD). GET is assumed if this is omitted. Timeout Optional. Specifies the number of seconds to run before timing out on non-responsive sites. Note: This parm does not work. See Known Issues below. Accept Optional. Specifies the MIME type to accept, such as text/*. ProxyName Optional. Specifies the address of the proxy server to use. ProxyBypass Optional. Space-separated list of server addresses that should not go through the proxy. This parm is ignored if ProxyName isn't specified. UserName Optional. Username to supply for the connection. Password Optional. Password to supply for the connection. Referer Optional. Specifies the HTTP_REFERER header, which theoretically tells where the link to the page came from. AddlHeaders Optional. Any additional HTTP headers to pass along. Example of calling CFX_HTTP CFSET URL = http://www.cnn.com/; CFX_HTTP URL=#URL# USERAGENT=WebChimp/1.0 PROXYNAME=http://proxy.mycompany.com:8080/; PROXYBYPASS=intranet.mycompany.com private-machine.mycompany.com CFOUTPUT CFIF CFX_HTTP.ResponseCode EQ 200 #CFX_HTTP.FileContent# CFELSE Oops, you got a #CFX_HTTP.ResponseCode# error! The error message is: #CFX_HTTP.FileContent# /CFIF /CFOUTPUT Here's an example using POST. Note that you must URLEncode the form data and concatenate it with the ampersands yourself. CFX_HTTP assumes that it's in a valid format. CFSET URL = http://www.amazon.com/exec/obidos/generic-quicksearch-query/; CFSET FormData = keyword-query=cold+fusionmode=books CFX_HTTP URL=#URL# USERAGENT=#Agent# VERB=POST TIMEOUT=10 FORMDATA=#FormData# Using CFX_HTTP's returns CFX_HTTP creates a one-row query in the caller's namespace called CFX_HTTP. It's a true query, so you can use something like CFX_DumpQuery to view all your results. However, you can still refer to the first (only) row in the query with .Field syntax. Please note that if CFX_HTTP.ResponseCode is -1, because of a non-HTTP error, only the CFX_HTTP.FileContent field will have a valid value in it. All other fields will be undefined, and accessing them through CF tags will make CF throw an exception. CFX_DumpQuery handles these undefined fields, so may be a better choice for viewing your responses. CFX_HTTP.ResponseCode The 3-digit response code (i.e. 200, 404, 500, etc). If you want a textual description, you'll have to bust up CFX_HTTP.Headers. If the response code is -1, then there was some non-HTTP error. For instance, if the server can't resolve the DNS name for the URL, the response will be a -1. If so, the textual description of the error will be in CFX_HTTP.FileContent. CFX_HTTP.FileContent This is analogous to CFHTTP.FileContent if the call succeeds, or the error message in the case of something failing. This field will be blank for a HEAD call. CFX_HTTP.URL Returns the URL that was fetched. CFX_HTTP.Title This is the contents of the TITLE tag in the returned page. This is to save you the hassle of parsing the whole page when you only want the title, as in a web spider. This field will be blank for a HEAD call. CFX_HTTP.Headers This is a CRLF-delimited list of all the HTTP headers passed back to your server. CFX_HTTP.LastModified The content of the Last-Modified: header CFX_HTTP.Date The content of the Date: header Known issues The TIMEOUT= parm does NOT work. For some reason, CFX_HTTP's overriding of Wininet's default of 45 seconds for timeouts is ignored. All timeouts will happen after 45 seconds. If anyone's an expert with WinInet and can help, please contact me at [EMAIL PROTECTED] Differences from CFHTTP No RESOLVEURL parm This functionality is in the sister tag CFX_ParseHTML. CFHTTP's RESOLVEURL is slightly buggy as it is. (It prepends servers to javascript: and mailto: URLs.) No authentication support I'm sorry if these shortcomings make CFX_HTTP unsuitable for your purposes. We wrote it for our needs, and have published it to share. Some of these features may be made in the future, but it's a low priority. Revision History v1.45 Added Referer parm v1.42 Added
RE: weird behaviour using yes/no field in Access
Didn't mean to imply that MDAC was the cause of the change in behavior. Seemed like a logical subject to investigate regarding this problem. EC -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:07 PM To: CF-Talk Subject: Re: weird behaviour using yes/no field in Access Ah... question: In which version of MDAC does this become broken? I've been using 1/0, both in setting and in testing boolean (yes/no) fields in Access for years, thinking that this was the most portable (that is, compatible with SQL Server) coding technique. Jim -Original Message- From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, September 04, 2001 9:44 AM Subject: RE: weird behaviour using yes/no field in Access Just a guess. Have you recently installed a newer version of MDAC? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 11:16 AM To: CF-Talk Subject: OT:weird behaviour using yes/no field in Access Hi I wonder if anyone has come across this before. To set a yes no field in Access to yes I usually insert a 1, this seems to work. Also when searching for checked fields, searching for the value 1 for yes/no fields usually works as well. Of recent I have noticed that this no longer works. I now need to check for yes with no quotes quotes or minus 1, checking for 1 will not match checked fields. As I've never had this problem before I'm wondering if this could possibly have anything to do with CF5 and the drivers it ships with as this is the only change which has been made to the site. Thanks in advance Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Java
You probably don't need to reboot the server, just restart CF. When you make changes to the classpath or add a CFX tag you need to restart CF. But also make sure that you have specified everything correctly in the class path. Also remember that if your using .class files then you just need to specify the directory that the class files are in, in the class path, but if you have a .jar file, you need to specify the path to the .jar file. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 9:01 AM To: CF-Talk Subject: RE: Problem with Java Are u using CF5? If so, have you tried rebooting the server?? I found that I could not get the server to recognise my changes to the Java settings in administrator until I rebboted the server... HTH Dan -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 06:23 To: CF-Talk Subject: Re: Problem with Java Have you added the CFX to the CFX Tags section in the CF Administrator? If you have... Where is your class? For development purposes, and to ensure it's configured properly, I put them in the \cfusion\java\classes folder, then when they are ready to go to live use, I'll put them in the correct folders. on 4/9/01 2:58 PM, David Lawrence at [EMAIL PROTECTED] wrote: Hi All I am trying to use a CFX Java tag and am having problems... I have installed 'Java 2 SDK Standard Edition 1.3.1' and have configured the CF Administrator (within the Java area and the CFX area). Everytime I try to run the page calling the tag I get the following error: java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I imagine this means the application cannot find the relevant Class, but I am not sure where I am going wrong. When installing the SDK I simply used the standard install without any further modifications. Any ideas out there? Thanks David Lawrence Red 5 Interactive Media FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT? Macromedia Spectra
In reply to Tyson Vanek's question about Macromedia Spectra last Friday -- yes, we're still selling Spectra, and you can contact your Macromedia Spectra sales rep or partner contact for details. This Spring we announced that the current version of Spectra, release 1.5, would be the last feature-added release. We're re-architecting Spectra's core technology, the Content Object API (COAPI) for inclusion in the next major release of ColdFusion, code-named Neo. We will continue to support Spectra for two years from the date of the announcement, until May 31st, 2001. Spectra has always shipped with a community source license -- meaning once you've bought a Spectra license, you can inspect and modify the source code and submit bug fixes and modfications to the company. We'll continue this program and will release code fixes and modifications through the Macromedia Spectra Community Source site, available to all existing Spectra customers, at SpectraSource.Macromedia.com. -Margaret Waters Product Manager Macromedia, Inc. [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: MIME Type email and CF
I am trying to send out a multi-part email that is both text and html with headers and a boundary so that I can just send one email and let the users client be able to read it. Clint -- Original Message -- from: Howie Hamlin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 04 Sep 2001 11:25:59 -0400 CFMAIL allows you to send html mail and MIME-encoded attachments. Is that what you need? 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: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:14 AM Subject: MIME Type email and CF Can you send MIME email using CF, either with cfmail in CF 4.01? Thanks! Clint ~~ 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
2nd request: RE: CFGRAPH Formatting
Any help please ... Trying to use CFGraph for the first time ... pretty cool, but I'm struggling with figuring out how to format things the way I want. Specifically, in my bar graph, all of my lables are overlapping. The bars are too close together. How do I get some separation there. What is the attribute? I've tried everything I can think of and nothing seems to change the spacing (in typography, we'd say leading). H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
Actually, last I checked, the CF5 eval can be used as a development server similar to Jrun, where it only works from one IP address. For the first 30 days it works as a full version, then afterwards it's a developer version. Of course, your client couldn't view it remotely, unless they want to shell out the $$. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: P Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 11:07 AM To: CF-Talk Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Formatting Text for Email/Text Files
call it like cfset mybody = makeNiceEmail(mybody,70)
cfscript
function makeNiceEmail(string, theLength) {
CRLF=chr(13);
for (i=theLength-1;i LTE Len(string);i=i+theLength){
string = Insert(CRLF,string,i);
}
return string;
}
/cfscript
CRLF chould be chr(13) chr(10) shouldn't it?
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Formatting Text for Email/Text Files
Tom,
Thanks for the idea, but I am stuck with CF 4.0.1 at the moment. However
won't your function just insert at the 70th character regardless of whether
is falls within a word? What I am trying to do is a friendly line break.
Never breaking into a word unless the word is over 60-70 characters long,
which is not likely.
Best regards,
Dennis Powers
UXB Internet
(203)879-2844
http://www.uxbinfo.com/
-Original Message-
From: tom muck [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 12:15 PM
To: CF-Talk
Subject: Re: Formatting Text for Email/Text Files
Here's a function for CF 5:
call it like cfset mybody = makeNiceEmail(mybody,70)
cfscript
function makeNiceEmail(string, theLength) {
CRLF=chr(13);
for (i=theLength-1;i LTE Len(string);i=i+theLength){
string = Insert(CRLF,string,i);
}
return string;
}
/cfscript
tom
www.basic-ultradev.com
Dennis Powers [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
It has been a long working weekend and my brain is suitably befuddled at
the
moment. I am attempting to format text for use in an email or a RAW text
file and wish to insert a carriage return/line feed at the closest space,
with out breaking the words, to the 60-70 characters point for each line.
I am pulling text data out of a database that only has CR/LF breaks at the
paragraph level. The paragraphs can run several hundreds words (don't
ask -
it's PhD speak stuff) I need to create text files from the data with CR/LF
breaks inserted within the paragraphs to break at a space within the
60-70-character point.
I am sure someone has done this before and am hoping that you might be
willing to take pity on one of your fellow CF'ers and share some code.
Best regards,
Dennis Powers
UXB Internet
(203)879-2844
http://www.uxbinfo.com/
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
Reinstalling an Eval version will not do anything, after the time out it remains timed out. In CF5.0 (not sure about 4.5.2) it reverts to single IP mode for development only:-) Regards, Andrew Scott -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 5 September 2001 2:16 AM To: CF-Talk Subject: Re: ColdFusion license agreement As far as I know, a CF license is only for one machine. I believe that your company will need to purchase a copy of the license so that you are legal. The only other way is to install an eval version and re-install every 30 days. - Original Message - From: P Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:07 AM Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ 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: ColdFusion license agreement
The CF5 eval will default to single ip mode after 30 days. It will still work, but only from one IP address. It's a great way to develop on a non-production machine. EC -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:16 PM To: CF-Talk Subject: Re: ColdFusion license agreement As far as I know, a CF license is only for one machine. I believe that your company will need to purchase a copy of the license so that you are legal. The only other way is to install an eval version and re-install every 30 days. - Original Message - From: P Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:07 AM Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ 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
CFMAIL inserting e-mail addresses, CFIF isdefined ...
I'm trying to pass e-mail addresses into my cfmail tag if a variable is defined. Here's a dummy sample, that I can't get to work. CFSET email = fun CFmail to=CFIF ISDEFINED (email)[EMAIL PROTECTED]/CFIF from= sullivan mailto:[EMAIL PROTECTED] @hittite.com subject=Test test /CFMAIL ~~ 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
Print Landscape
I am using a style to hide part of the web page when someone prints it. I would like to know how to make the page print in landscape. Joshua Tipton ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
I think... If you need CF5, then after the demo timesout, it turns into the single user version - maybe someone else can verify??? http://www.macromedia.com/software/coldfusion/trial/ -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 17:22 To: CF-Talk Subject: RE: ColdFusion license agreement If not, how do I get around the problem with out having to buy a copy? If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MySQL and Null Dates
First im wondering if this is a valid CF statement with a MySQL datefield record? CFIF CLOCKOUT IS null do this /CFIF Does CF know what null is? Because the only way i can get CF to understand that the datefield is Null is to use: CFIF CLOCKOUT IS '-00-00 00:00:00' ~~ 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: ColdFusion license agreement
If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. For the 5.0 tags, I just looked at the Macromedia site. There is something there called the ColdFusion Studio Tag Update that might help you out. I am not sure, but you should take a look. Go to the Macromedia site, click the Downloads tab, click More Downloads next to ColdFusion Studio, then click ColdFusion Studio Tag Infusion Pack/Studio Update under Updates. Hope this helps, Matthieu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
On Server 5, I found the that when the Eval copy expires it becomes the single user version. At 05:22 PM 9/4/2001 +0100, you wrote: If not, how do I get around the problem with out having to buy a copy? If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT? Macromedia Spectra
When is Neo to be released? Rich -Original Message- From: Margaret Waters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:30 PM To: CF-Talk Subject: OT? Macromedia Spectra In reply to Tyson Vanek's question about Macromedia Spectra last Friday -- yes, we're still selling Spectra, and you can contact your Macromedia Spectra sales rep or partner contact for details. This Spring we announced that the current version of Spectra, release 1.5, would be the last feature-added release. We're re-architecting Spectra's core technology, the Content Object API (COAPI) for inclusion in the next major release of ColdFusion, code-named Neo. We will continue to support Spectra for two years from the date of the announcement, until May 31st, 2001. Spectra has always shipped with a community source license -- meaning once you've bought a Spectra license, you can inspect and modify the source code and submit bug fixes and modfications to the company. We'll continue this program and will release code fixes and modifications through the Macromedia Spectra Community Source site, available to all existing Spectra customers, at SpectraSource.Macromedia.com. -Margaret Waters Product Manager Macromedia, Inc. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion license agreement
you can download the CF5 eval version. It becomes single user after the trial period is over. On Tue, 4 Sep 2001, P Broussard wrote: So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2nd request: RE: CFGRAPH Formatting
To separate the bars, you would want to use the BarSpacing attribute. Once you set the spacing, the labels should follow. Bruce - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:29 AM Subject: 2nd request: RE: CFGRAPH Formatting Any help please ... Trying to use CFGraph for the first time ... pretty cool, but I'm struggling with figuring out how to format things the way I want. Specifically, in my bar graph, all of my lables are overlapping. The bars are too close together. How do I get some separation there. What is the attribute? I've tried everything I can think of and nothing seems to change the spacing (in typography, we'd say leading). H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ 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: Studio 4.5.1 and Windows 2000 Professional
Does anyone know why I can only view the Studio program folder when logged in as the Administrator on a Windows 2000 Professional machine, and not when logged in as a User or a Power User? My guess is that it doesn't have anything to do with user rights, but rather with user profiles. CF Studio, when installed, creates a shortcut in the user profile of whoever installs it. You can make the Studio shortcut available to all users by simply moving it to the All Users profile folder. To do this, right-click on the Start button, select Explore All Users, and move the CF Studio folder from the Start Menu folder of the Administrator to the All Users Start Menu folder. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Variables Collection???
I know there's a FORM collection, but does a VARIABLES collection exist? If so, where can I find documentation? Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
BIT is the correct type to use for a boolean value, but you must think about
it first since BIT typed columns cannot be included in a GROUP BY clauses.
TINYINT is the one to use for boolean values if you need to group by a
column.
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 7:41 AM
To: CF-Talk
Subject: help with moving from access to sql server
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit
column.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (21:1) to (21:53).
I realise that this is caused by trying to group according to the bit
datatype.
However when I remove the grouping for this it gives an error saying
that I need to group.
This is the query I am using. Can anybody suggest a way of getting
around this.
cfquery name=gethdrs datasource=#Variables.DSN#
SELECT DISTINCT Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Quarter_ID,
Programme_Details.Locked, Programme_details.Prog_Status,
Programme_Details.ILX, Programme_Details.Executive,
Programme_Details.BSS, Programme_Details.Prog_result
FROM Programme_Hdr, Programme_Details, Business_Units2
WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID
cfif form.Programme_Name NEQ ALL
AND Programme_Name = '#Form.Programme_Name#'
/cfif
cfif form.year NEQ ALL
AND Programme_Details.Year = '#Form.Year#'
/cfif
cfif form.quarter NEQ ALL
AND Programme_Details.Quarter = '#Form.Quarter#'
/cfif
cfif form.Business_unit NEQ ALL
AND Programme_Hdr.Business_Unit = '#form.Business_Unit#'
/CFIF
cfif listcontains(session.access,'5') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND Programme_Details.Executive = 1
OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED'))
/cfif
cfif listcontains(session.access,'3') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit
'#session.b_unit#' AND Programme_Details.BSS = 0))
/cfif
cfif listcontains(session.access,'2') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit
'#session.b_unit#' AND Programme_Details.ILX = 0))
/cfif
cfif NOT listcontains(session.access, '1') AND NOT
listcontains(session.access, '2') AND NOT listcontains(session.access,
'5')
AND Business_Units2.bss_Name = '#session.bss#'
AND Programme_Hdr.Business_Unit = Business_Units2.bu_name
/cfif
cfif listcontains(session.access, '4') AND NOT
listcontains(session.access, '5')
AND Programme_Hdr.Business_Unit = '#session.b_unit#'
/cfif
AND Programme_Details.archived = 0
Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Locked,
Programme_Details.Prog_Status, Programme_Details.ILX,
Programme_Details.BSS, Programme_Details.Executive,
Programme_Details.Prog_result
cfif not parameterexists(url.orderby)
ORDER by Programme_Hdr.Business_Unit, Programme_Details.Quarter
Cfelse
cfif parameterexists(url.Orderby) and url.orderby eq BU
Order by Programme_Hdr.Business_Unit
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq PN
Order by PROGRAMME_hdr.Programme_Name
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq YR
Order by PROGRAMME_DETAILS.YEAR
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq QR
Order by PROGRAMME_DETAILS.Quarter
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq RN
Order by PROGRAMME_HDR.Region
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
/cfif
/cfif
/cfquery
thanks,
Regards,
Declan Maher
Web Applications Developer
Head Office
133-137
Re: Formatting Text for Email/Text Files
CFX_ODSMail (freeware) does wordwrap. However, we haven't updated the tag since 1999 (you are free to give it a try). You can download it from: ftp://ftp.hoot.com/pub/ods/cfx_odsmail/cfx_odsmail.zip Besides that, iMS (with cfx_iMSMail) also can do this but it's not free. 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: Dennis Powers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 12:42 PM Subject: RE: Formatting Text for Email/Text Files Tom, Thanks for the idea, but I am stuck with CF 4.0.1 at the moment. However won't your function just insert at the 70th character regardless of whether is falls within a word? What I am trying to do is a friendly line break. Never breaking into a word unless the word is over 60-70 characters long, which is not likely. Best regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion license agreement
I responded under the presumption that this individual was doing development work from home and would need to show his work from his home machine, such as what I do for my clients. I do not load any code to their (Client) servers until I know that it works, and that they have had a chance to look at it while it is on my server, which means that the single version license does not work for me. - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:41 AM Subject: RE: ColdFusion license agreement The CF5 eval will default to single ip mode after 30 days. It will still work, but only from one IP address. It's a great way to develop on a non-production machine. EC -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:16 PM To: CF-Talk Subject: Re: ColdFusion license agreement As far as I know, a CF license is only for one machine. I believe that your company will need to purchase a copy of the license so that you are legal. The only other way is to install an eval version and re-install every 30 days. - Original Message - From: P Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:07 AM Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying an image with CFcontent
I've done this before... I eventually figured out that the server's file system is much, much, much better suited for managing image files than the database. I suggest you use CFFILE to copy your images to the server and simply store the path to them in the DB. Once that is done you can use CFCONTENT type= file= to display. Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 5:48 AM To: CF-Talk Subject: Displaying an image with CFcontent I'm trying to pull an image out on a database and display it without writing a file to the disk. I tried this... cfcontent type=image/jpeg cfoutput#toBinary(Base64imageFromDatabase)#/cfoutput And, of course, cfoutput won't let me do this because it wants a string, not a binary value. I could write the file to the disk, then display and delete it (using cffile then cfcontent for the last 2 steps). I'd like to cut those steps out, though. All those disk writes effect the performance of this application. Is there any way I can go from the database to CFContent? Thanks, EC ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Server monitoring tools
Wow. I wound up using a CF monitor I wrote (too much text being pumped thru to my cell phone on the other systems' email alerts), and an open relay from my ISP (I can't use the Win smtp service as I'm running Apache here at home) But this definitely bears looking into. I don't like having to rely on an open relay server. Thanks, --Matt-- - Original Message - From: Benjamin S. Rogers [EMAIL PROTECTED] Well, there is the one that comes as a part of IIS. I'm not sure, however, whether or not you can install it on Windows 2000 Professional. If not, you might check out Mercury (http://www.pmail.com/) by the folks who make the Pegasus E-mail client. I've never used it myself but it is free. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MIME Type email and CF
You can code the headers and boundaries manually. There are quite a few posts giving the full code for a multi-part email -- check the archives. tom Clint Tredway [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am trying to send out a multi-part email that is both text and html with headers and a boundary so that I can just send one email and let the users client be able to read it. Clint ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DNS Question
A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, Christian ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL inserting e-mail addresses, CFIF isdefined ...
Well, first of all, if email isn't defined, your CFMAIL tag will blow up. Also, your from attribute is messy. You need to put some quotes around all that, or it'll never work. The angle brackets are probably causing a problem as well. The tag thinks you're ending the tag at the at the end of your email address. Kevin Langevin Web Guy in Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] -Original Message- From: Dan Sullivan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:53 PM To: CF-Talk Subject: CFMAIL inserting e-mail addresses, CFIF isdefined ... I'm trying to pass e-mail addresses into my cfmail tag if a variable is defined. Here's a dummy sample, that I can't get to work. CFSET email = fun CFmail to=CFIF ISDEFINED (email)[EMAIL PROTECTED]/CFIF from= sullivan mailto:[EMAIL PROTECTED] @hittite.com subject=Test test /CFMAIL ~~ 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: Formatting Text for Email/Text Files
True, I didn't read your post clearly. I'm using this for email attachments. To do what you need to do is a little or a lot more difficult. You can use list functions to separate the words at the space, adding words until you are up to 70 characters, or choose an arbitrary length less than seventy and add characters until you reach a space or punctuation mark. You could also use the CDONTS object to send the mail for you instead of CFMAIL if you are on a Windows server. tom Dennis Powers [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Tom, Thanks for the idea, but I am stuck with CF 4.0.1 at the moment. However won't your function just insert at the 70th character regardless of whether is falls within a word? What I am trying to do is a friendly line break. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
But did MM ever respond to the discussion where it was pointed out that using it for Dev work was not legal according to the current license? Ken -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:41 PM To: CF-Talk Subject: RE: ColdFusion license agreement The CF5 eval will default to single ip mode after 30 days. It will still work, but only from one IP address. It's a great way to develop on a non-production machine. EC -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:16 PM To: CF-Talk Subject: Re: ColdFusion license agreement As far as I know, a CF license is only for one machine. I believe that your company will need to purchase a copy of the license so that you are legal. The only other way is to install an eval version and re-install every 30 days. - Original Message - From: P Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:07 AM Subject: ColdFusion license agreement So I got a job that allows me to work from home. I set up Apache and ColdFusion Express to do my development work and then just upload the files to the live server and be done with it. Well, the current code uses a lot of tags that are not available in the Express version. What I want to know is, can I install a copy of ColdFusion server that we are using on the live server and not be braking any licenses agreements? If not, how do I get around the problem with out having to buy a copy? TIA, Phillip ~~ 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 inserting e-mail addresses, CFIF isdefined ...
Try setting it up outside the mail tag. Ex: CFIF IsDefined(Email) CFSET Email = [EMAIL PROTECTED] /CFIF CFmail to=#Email# from=sullivan mailto:[EMAIL PROTECTED] @hittite.com subject=Test Note: This will fail if Email is not defined. Are you taking this into account? -Original Message- From: Dan Sullivan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 11:53 AM To: CF-Talk Subject: CFMAIL inserting e-mail addresses, CFIF isdefined ... I'm trying to pass e-mail addresses into my cfmail tag if a variable is defined. Here's a dummy sample, that I can't get to work. CFSET email = fun CFmail to=CFIF ISDEFINED (email)[EMAIL PROTECTED]/CFIF from= sullivan mailto:[EMAIL PROTECTED] @hittite.com subject=Test test /CFMAIL ~~ 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: MySQL and Null Dates
ACK! i figured out part of my problem. I used DBTools to convert an Access DB to MySQL. Well the import turned Access's Nulls to -00-00 00:00:00. I will have to go in and replace all -00-00 00:00:00 with a MySQL Null. Im still wondering what CF's null is? is it just plain old CFIF CLOCKOUT IS At 01:09 PM 9/4/2001 -0400, you wrote: First im wondering if this is a valid CF statement with a MySQL datefield record? CFIF CLOCKOUT IS null do this /CFIF Does CF know what null is? Because the only way i can get CF to understand that the datefield is Null is to use: CFIF CLOCKOUT IS '-00-00 00:00:00' ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MySQL and Null Dates
Does CF know what null is? No, it doesn't. When a recordset contains NULLs, CF converts them to empty strings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL inserting e-mail addresses, CFIF isdefined ...
try the if logic outside of the cfmail tag and always pass #email# On Tue, 4 Sep 2001, Dan Sullivan wrote: I'm trying to pass e-mail addresses into my cfmail tag if a variable is defined. Here's a dummy sample, that I can't get to work. CFSET email = fun CFmail to=CFIF ISDEFINED (email)[EMAIL PROTECTED]/CFIF from= sullivan mailto:[EMAIL PROTECTED] @hittite.com subject=Test test /CFMAIL ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MySQL and Null Dates
My mySQL db does the same thing, although on the test I ran, I was able to use an empty string as the field I tested allows 'null' values. Just for laughs I tried ''LT 1'' and that worked, too. - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 10:09 AM Subject: MySQL and Null Dates First im wondering if this is a valid CF statement with a MySQL datefield record? CFIF CLOCKOUT IS null do this /CFIF Does CF know what null is? Because the only way i can get CF to understand that the datefield is Null is to use: CFIF CLOCKOUT IS '-00-00 00:00:00' ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MIME Type email and CF
I will be trying to do this soon as well. Here is someone's post that I thought may be useful when I try to do this task. Let me know how it goes ;) HTH, Jeff One more experienced than I posted this once: I believe his name is Seth Bienek Here's the commented code -- !--- Create a unique ID for the message boundary. --- cfset boundary = CreateUUID() !--- Standard CFMAIL.. Note that the TYPE attribute is not set. --- cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test !--- This message is going to be a multipart message. Since an email is really just a really long string of text, we need a unique substring to use as a seperator between the parts. Just to make sure that a seperator doesn't accidentally get typed in, I like to use a UUID - the odds of this exact string accidentally coming through in an email would be extremely rare. The mailparam tag will insert the value of the seperator into the mail header, as well as telling the email client that this message is composed of more than one part. --- cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# !--- Boundaries are always preceded by --. Each part of a multi-part message is preceded by a boundary. The boundary value MUST match the value set in the header. --- --#boundary# !--- Each section of the email gets it's own mini-header. This header tells the mail client what kind of data follows (plain text, 8 bit, in this case), and is always seperated from the content that follows by one empty line. --- Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is the plain text message for the email. !--- Every section gets a header, and every header begins with the same exact Boundary value. --- --#boundary# !--- Modern mail clients that support HTML email will ignore a plain text section of an email if there is also an HTML section. Note the empty line between the secion header and the content that follows it. --- Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !--- HTML formatted emails should generally be treated the same as html pages. Javascript is not allowed, however. The title tags are not supported in most mail readers, but should be used anyway. --- html head titleHTML Message/title /head body This is the HTML text message for the email. /body /html !--- the final boundary is always followed by two hyphens. This is how the email client knows that the message is complete, and not to expect another section. --- --#boundary#-- /cfmail -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 9:33 AM To: CF-Talk Subject: Re: MIME Type email and CF I am trying to send out a multi-part email that is both text and html with headers and a boundary so that I can just send one email and let the users client be able to read it. Clint ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
Can't you just use a Convert statement in your SELECT and GROUP BY clause
for the Bit fields?
For example
SELECT sum(line.total) as OrderTotal, Convert(Char(1), order.Sent) as
Shipped, order.ShipDate, order.ordernum
from line, order
where line.order_id = order.order_id
AND order.sent = 1 AND order.customer_id = #customerid#
group by Convert(Char(1), order.Sent), order.ShipDate, order.ordernum
I've done this several times on SQL Server platforms and it works with no
problem.
Hatton Humphrey
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 1:36 PM
To: CF-Talk
Subject: RE: help with moving from access to sql server
BIT is the correct type to use for a boolean value, but you must
think about
it first since BIT typed columns cannot be included in a GROUP BY clauses.
TINYINT is the one to use for boolean values if you need to group by a
column.
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 7:41 AM
To: CF-Talk
Subject: help with moving from access to sql server
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit
column.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (21:1) to (21:53).
I realise that this is caused by trying to group according to the bit
datatype.
However when I remove the grouping for this it gives an error saying
that I need to group.
This is the query I am using. Can anybody suggest a way of getting
around this.
cfquery name=gethdrs datasource=#Variables.DSN#
SELECT DISTINCT Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Quarter_ID,
Programme_Details.Locked, Programme_details.Prog_Status,
Programme_Details.ILX, Programme_Details.Executive,
Programme_Details.BSS, Programme_Details.Prog_result
FROM Programme_Hdr, Programme_Details, Business_Units2
WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID
cfif form.Programme_Name NEQ ALL
AND Programme_Name = '#Form.Programme_Name#'
/cfif
cfif form.year NEQ ALL
AND Programme_Details.Year = '#Form.Year#'
/cfif
cfif form.quarter NEQ ALL
AND Programme_Details.Quarter = '#Form.Quarter#'
/cfif
cfif form.Business_unit NEQ ALL
AND Programme_Hdr.Business_Unit = '#form.Business_Unit#'
/CFIF
cfif listcontains(session.access,'5') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND Programme_Details.Executive = 1
OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED'))
/cfif
cfif listcontains(session.access,'3') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit
'#session.b_unit#' AND Programme_Details.BSS = 0))
/cfif
cfif listcontains(session.access,'2') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit
'#session.b_unit#' AND Programme_Details.ILX = 0))
/cfif
cfif NOT listcontains(session.access, '1') AND NOT
listcontains(session.access, '2') AND NOT listcontains(session.access,
'5')
AND Business_Units2.bss_Name = '#session.bss#'
AND Programme_Hdr.Business_Unit = Business_Units2.bu_name
/cfif
cfif listcontains(session.access, '4') AND NOT
listcontains(session.access, '5')
AND Programme_Hdr.Business_Unit = '#session.b_unit#'
/cfif
AND Programme_Details.archived = 0
Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Locked,
Programme_Details.Prog_Status, Programme_Details.ILX,
Programme_Details.BSS, Programme_Details.Executive,
Programme_Details.Prog_result
cfif not parameterexists(url.orderby)
ORDER by Programme_Hdr.Business_Unit, Programme_Details.Quarter
Cfelse
cfif parameterexists(url.Orderby) and url.orderby eq BU
Order by Programme_Hdr.Business_Unit
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq PN
Order by PROGRAMME_hdr.Programme_Name
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq YR
Re: Variables Collection???
According to MM/Allaire, no - there is not a collection of VARIABLES-scoped variables. Using ColdFusion Variables http://www.allaire.com/handlers/index.cfm?ID=21727 - see the end of the document, which is actually at http://www.allaire.com/handlers/index.cfm?ID=21726 Chris Norloff -- Original Message -- from: Joshua Miller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 04 Sep 2001 13:28:36 -0400 I know there's a FORM collection, but does a VARIABLES collection exist? If so, where can I find documentation? Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [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: Variables Collection???
While Variables looks like a struct, ie, you can do Variables.YoWhasup, it is not a true struct that you can enumerate. === 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: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:29 PM To: CF-Talk Subject: Variables Collection??? I know there's a FORM collection, but does a VARIABLES collection exist? If so, where can I find documentation? Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [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: ColdFusion license agreement
Ok I think I am going to try the CF server 5 and see how that works. I never got a copy of Studio because I have Homesite which is good enough for me. At least for now. hehee Anything I should be aware of when installing CF Server 5 on NT with Apache?? Phillip ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DNS Question
What server are you using? It's a combo of DNS and Webserver settings. -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: DNS Question A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, 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: DNS Question
Generally your record should be set up at your DNS to handle this. If you're handling the DNS yourself then make sure the record includes: *.domain.name. IN CNAME domain.name.; GLOBALOK HTH Hatton Humphrey -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: DNS Question A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, 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: DNS Question
hmmm... point your A record to the IP... define another A record that is *.domain.extension Set you web server up to handle all incoming requests for *.domain.extension... in IIS this occurs where you have no location where the ASTERICK is... so in IIS tell it to answer all requests on domain.extension... hope that helped... and if DNS is driving you up a wall check out SIMPLE DNS PLUS server... excellent product... about $100 for it... -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: Tue, 04 Sep 2001 12:52:08 -0500 Subject: DNS Question A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, Christian ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: CFMAIL inserting e-mail addresses, CFIF isdefined ...
Try this instead: cfif isDefined(email) cfmail from=mailto:[EMAIL PROTECTED]; to=mailto:[EMAIL PROTECTED]; subject=test test /cfmail /cfif CF does not allow you to embed tags like what you have there. Also, the from attribute is required, so even you could embed tags, your code would still blow up if email wasn't defined. -Original Message- From: Dan Sullivan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:53 PM To: CF-Talk Subject: CFMAIL inserting e-mail addresses, CFIF isdefined ... I'm trying to pass e-mail addresses into my cfmail tag if a variable is defined. Here's a dummy sample, that I can't get to work. CFSET email = fun CFmail to=CFIF ISDEFINED (email)[EMAIL PROTECTED]/CFIF from= sullivan mailto:[EMAIL PROTECTED] @hittite.com subject=Test test /CFMAIL ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MIME Type email and CF
thanks I will do that. -- Original Message -- from: tom muck [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 04 Sep 2001 13:40:01 -0400 You can code the headers and boundaries manually. There are quite a few posts giving the full code for a multi-part email -- check the archives. tom Clint Tredway [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am trying to send out a multi-part email that is both text and html with headers and a boundary so that I can just send one email and let the users client be able to read it. Clint ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2nd request: RE: CFGRAPH Formatting
Bruce, Thanks, but tried that. All that does is make the bars wider, even to the point where they overlap. The labels stay as crunched up as ever. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Bruce Sorge [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 10:19 AM To: CF-Talk Subject: Re: 2nd request: RE: CFGRAPH Formatting To separate the bars, you would want to use the BarSpacing attribute. Once you set the spacing, the labels should follow. Bruce - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:29 AM Subject: 2nd request: RE: CFGRAPH Formatting Any help please ... Trying to use CFGraph for the first time ... pretty cool, but I'm struggling with figuring out how to format things the way I want. Specifically, in my bar graph, all of my lables are overlapping. The bars are too close together. How do I get some separation there. What is the attribute? I've tried everything I can think of and nothing seems to change the spacing (in typography, we'd say leading). ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DNS Question
skillpath.com. IN AYour IP address www IN AYour IP address note the . at the end of the first that is not at the end of the second. Also need to make sure the web server will respond to both. Justin -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: DNS Question A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, Christian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IIS Session information
Hello all. Is it possible to access the session ID that is created by IIS? I would like to create a unique identifier for every visit for every user. This will be used to report on site and usage and reporting within the for the dynamic pages and sections of the site. Please respond with other ideas or tools if you know of any thing good. (I am using url vars for section and page IDs.) Signed, Bill King ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX_HTTP
FYI, you _can_ get the headers from CFHTTP now. I know the original msg is old, but I wanted to make sure people didn't get confused. === 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: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:23 PM To: CF-Talk Subject: RE: CFX_HTTP Kwang, Here is the text from the archive, which I have sent you off-list: [ cut here ] ColdFusion custom tag for performing HTTP reads Copyright 1999 Follett Software Company The CFHTTP tag that comes as part of ColdFusion is a fine and useful thing, except that it doesn't allow the user to see response codes or headers. For anything more than cursory page retrieval (such as building a spider), this is inadequate. ~~ 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: ColdFusion license agreement
Ken Wilson [EMAIL PROTECTED] wrote in message But did MM ever respond to the discussion where it was pointed out that using it for Dev work was not legal according to the current license? No, we are still waiting... Massimo ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Setting Java Classpath in CFAdmin
This is a multi-part message in MIME format. --=_NextPart_000_0010_01C1348D.D4D13CC0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I am having trouble getting the CFAdmin console to recognize the = directories I am setting in my classpath. I should only have to = designate the directories and not necessarily the specific jar files = containing those class files, correct? Or do I need to specifically = reference each and every jar file being used.=20 This is the exact error I get when I tried to load my page which = instantiates an object I've created Unhandled System exception !=20 java.lang.NoClassDefFoundError: com/sun/net/ssl/HttpsURLConnection. Java = exception occurred in attempt to locate class 'HttpsServerCom' (you = should verify that the class is in the CLASSPATH). Any help would be greatly appreciated. Paul J. Summers, Jr. Developer Advanced Media Productions (508)647-5151 ext. 19 --=_NextPart_000_0010_01C1348D.D4D13CC0 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3DMSHTML 5.00.2919.6307 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2 DIVI am having trouble getting the CFAdmin console to recognize the=20 directories I am setting in my classpath. I should only have to = designate the=20 directories and not necessarily the specific jar files containing those = class=20 files, correct? Or do I need to specifically reference each and every = jar file=20 being used. /DIV DIVnbsp;/DIV DIVThis is the exact error I get when I tried to load my page which=20 instantiates an object I've created/DIV DIVnbsp;/DIV DIVUnhandled System exception ! /DIV DIVnbsp;/DIV DIVjava.lang.NoClassDefFoundError: com/sun/net/ssl/HttpsURLConnection. = Java=20 exception occurred in attempt to locate class 'HttpsServerCom' (you = should=20 verify that the class is in the CLASSPATH)./DIV DIVnbsp;/DIV DIVAny help would be greatly appreciated./DIV DIVnbsp;/DIV/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Paul J. Summers, = Jr.BRDeveloperBRAdvanced Media=20 ProductionsBR(508)647-5151 ext. 19/FONT/DIV/BODY/HTML --=_NextPart_000_0010_01C1348D.D4D13CC0-- FAQ: http://www.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: DNS Question
I figured it out. All you have to do is leave the A record blank. Didn't think that was possible and tried everything but that. See what I get for thinking. Christian -Original Message- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: RE: DNS Question What server are you using? It's a combo of DNS and Webserver settings. -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: DNS Question A little off topic, but can anyone please tell me how in the world you set up DNS so that the user does not have to enter WWW. Instead of www.skillpath.com they can just enter skillpath.com and the name is resolved. Thank You, Christian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Javascript for SSL Certificate
I am wondering if anyone knows if there is there a possibility to view a site's certificate directly by clicking a link (instead of right clicking/properties/certificate)? I expect it would be some kind of javascript, but I haven't been able to figure out just what the object would be. Thanks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting Java Classpath in CFAdmin
You need to specifically reference each Jar file you add to your classpath. A jar file is a collection of files, kind of like a directory its self. Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Paul John Summers, Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 3:34 PM To: CF-Talk Subject: Setting Java Classpath in CFAdmin This is a multi-part message in MIME format. --=_NextPart_000_0010_01C1348D.D4D13CC0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I am having trouble getting the CFAdmin console to recognize the = directories I am setting in my classpath. I should only have to = designate the directories and not necessarily the specific jar files = containing those class files, correct? Or do I need to specifically = reference each and every jar file being used.=20 This is the exact error I get when I tried to load my page which = instantiates an object I've created Unhandled System exception !=20 java.lang.NoClassDefFoundError: com/sun/net/ssl/HttpsURLConnection. Java = exception occurred in attempt to locate class 'HttpsServerCom' (you = should verify that the class is in the CLASSPATH). Any help would be greatly appreciated. Paul J. Summers, Jr. Developer Advanced Media Productions (508)647-5151 ext. 19 --=_NextPart_000_0010_01C1348D.D4D13CC0 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3DMSHTML 5.00.2919.6307 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2 DIVI am having trouble getting the CFAdmin console to recognize the=20 directories I am setting in my classpath. I should only have to = designate the=20 directories and not necessarily the specific jar files containing those = class=20 files, correct? Or do I need to specifically reference each and every = jar file=20 being used. /DIV DIVnbsp;/DIV DIVThis is the exact error I get when I tried to load my page which=20 instantiates an object I've created/DIV DIVnbsp;/DIV DIVUnhandled System exception ! /DIV DIVnbsp;/DIV DIVjava.lang.NoClassDefFoundError: com/sun/net/ssl/HttpsURLConnection. = Java=20 exception occurred in attempt to locate class 'HttpsServerCom' (you = should=20 verify that the class is in the CLASSPATH)./DIV DIVnbsp;/DIV DIVAny help would be greatly appreciated./DIV DIVnbsp;/DIV/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Paul J. Summers, = Jr.BRDeveloperBRAdvanced Media=20 ProductionsBR(508)647-5151 ext. 19/FONT/DIV/BODY/HTML --=_NextPart_000_0010_01C1348D.D4D13CC0-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2nd request: RE: CFGRAPH Formatting
That is interesting because I just created a graph and added the BarSpacing attribute, and it worked fine. Mind shooting over your code? I have quite a lot of experience with CFGRAPH and PopCharts, so I may be able to assist. Also, if you can param some query attributes for the DB you are hitting, that would help to see what is going on. You can do this off list if you like. No sense in cluttering up the list. Bruce - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 2:00 PM Subject: RE: 2nd request: RE: CFGRAPH Formatting Bruce, Thanks, but tried that. All that does is make the bars wider, even to the point where they overlap. The labels stay as crunched up as ever. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Bruce Sorge [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 10:19 AM To: CF-Talk Subject: Re: 2nd request: RE: CFGRAPH Formatting To separate the bars, you would want to use the BarSpacing attribute. Once you set the spacing, the labels should follow. Bruce - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:29 AM Subject: 2nd request: RE: CFGRAPH Formatting Any help please ... Trying to use CFGraph for the first time ... pretty cool, but I'm struggling with figuring out how to format things the way I want. Specifically, in my bar graph, all of my lables are overlapping. The bars are too close together. How do I get some separation there. What is the attribute? I've tried everything I can think of and nothing seems to change the spacing (in typography, we'd say leading). ~~ 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: Setting Java Classpath in CFAdmin
you have to specifically set each jarfile on the path On Mon, 3 Sep 2001, Paul John Summers, Jr. wrote: I am having trouble getting the CFAdmin console to recognize the = directories I am setting in my classpath. I should only have to = designate the directories and not necessarily the specific jar files = containing those class files, correct? Or do I need to specifically = reference each and every jar file being used.=20 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPARAM vs. CFSET
Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPARAM vs. CFSET
You can use cfparam to make sure a variable is defined (such as form, url, or session variables). Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 3:49 PM To: CF-Talk Subject: CFPARAM vs. CFSET Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Session information
Why aren't you using ColdFusion's Session? To answer your original question, I swear that I saw IIS Session info once in the list of CGI variables available to ColdFusion.. I think it was in cgi.http_cookie - but I'll be darned if I can remember how to duplicate it. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Bill King [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:20 PM To: CF-Talk Subject: IIS Session information Hello all. Is it possible to access the session ID that is created by IIS? I would like to create a unique identifier for every visit for every user. This will be used to report on site and usage and reporting within the for the dynamic pages and sections of the site. Please respond with other ideas or tools if you know of any thing good. (I am using url vars for section and page IDs.) Signed, Bill King ~~ 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: CFPARAM vs. CFSET
CFparm only writes to the variable if the variable does not exist, where as CFSet overwrites the variable with a new value regardless of if it exists. EX: cfparam name=form.checkbox default=0 is the same in principle as: cfif NOT isDefined() cfset form.checkbox = 0 /cfif HTH, Duane -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 4:49 PM To: CF-Talk Subject: CFPARAM vs. CFSET Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) ~~ 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: CFPARAM vs. CFSET
CFSET assigns a value to a variable. CFPARAM makes sure a variable exists (with a given default value if specified). The two ideas are a little different. If I have passed a URL variable to my page (call it URL.MyVar), then I can do processing on my page using that variable. However, if I do not pass that URL parameter, yet still have processing using URL.MyVar, then my page will crash complaining that URL.MyVar doesn't exist. That's where CFPARAM comes in. It makes sure the variable exists, and allows you to specify a default value. So, by adding a CFPARAM for URL.MyVar, my page will process without error (assuming I've done a good job of everything else). The results may be unexpected if you don't handle a default value, but the page doesn't crash, which is rather important. hm not sure if that's clear enough. But here's hoping. Shawn Grover -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 2:49 PM To: CF-Talk Subject: CFPARAM vs. CFSET Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPARAM vs. CFSET
Well for starters. CFSET sets a defined valuable for a variable, while CFPARAM allows you to set a DEFAULT value for a variable that only gets used if the variable does not exist at that stage of the form being processed Terry - Original Message - From: Fuon See Tu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 1:48 PM Subject: CFPARAM vs. CFSET Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
from web media to print?
I wanted to get feedback on how you all handle print versions of your data. I've had a number of clients that after I've built this great site with administrable content, they call up and say Why don't the products print out on my printer like they show up on the website?. For some reason they think a product catalog on a website should transfer automatically transfer over to a print catalog. Have any of you found good ways to deal with this. I'm looking for suggestions/direction because this comes up all the time and I have yet to provide my clients with a good flexible solution. Thanks, Rick ~~ 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: CFPARAM vs. CFSET
Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) This: cfparam name=Form.myfield default=someval is the same as this: cfif not IsDefined(Form.myfield) cfset Form.myfield = someval /cfif Also, CFPARAM allows you to do some other things. You can force an error if a variable doesn't already exist: cftry cfparam name=Form.myfield cfcatch You must submit the form! cfabort /cfcatch /cftry And, you can use CFPARAM as a simple type-checker, using the relatively little-known TYPE attribute: cfparam name=Form.somenumericfield type=numeric Finally, it's worth noting that CFPARAM may be considerably slower than using CFSET within an IsDefined test; this is according to a poster on the Spectra-Talk list. I haven't verified this myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPARAM vs. CFSET
Here's a common use for CFParam ... at least for me ... Let's say I have a form that can be used either for updating existing data OR for inserting new data. If the form will function as update, I'll want to display the existing data, such as: cfinput type=text name=fname value=#finddata.fname# That's fine so long as I have a query running called finddata But when the from is called for a new insert, chances are, I haven't run the query. So, in that case, #findata.fname# will throw and error. But if I start my template with: cfparam name=finddata.fname default= Now my value in the cfinput tag will show blank and not throw an error. That's a rather simplified version of how I might use CFParam. Basically, it's a way of making sure a default variable exists in cases where a dynamic variable might not otherwise exist. Many times, you need to make sure a variable exists, but you are not ready to populate that variable with a meaningful variable. Or sometimes, you want a meaningful variable to be the default and only be changed as a result of some database or user interaction. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Fuon See Tu [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:49 PM To: CF-Talk Subject: CFPARAM vs. CFSET Hey guys i still don't understand the difference between CFPARAM and CFSET. anyone got a working concept? i see no use for CFPARAM :) ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: from web media to print?
I've never tried this, but have you thought about making it possible for the client to download RTF versions of said content? If you search Google, I think you'll come up with some templates for RTF documents. I was researching this once, but the project never went through so I didn't actually get a chance to try it. If you control your own server, I believe there are also components you can install/call that allow you to write directly to Word or Excel and create fully formatted documents. I believe somebody else on the list can pop up with information on how to do a dynamic PDF document. The other thing I would suggest is try to educate your clients when you first sign them. Try to access their expectations and then educate them on what realistic expectations they should have. I've found this works best. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:05 PM To: CF-Talk Subject: from web media to print? I wanted to get feedback on how you all handle print versions of your data. I've had a number of clients that after I've built this great site with administrable content, they call up and say Why don't the products print out on my printer like they show up on the website?. For some reason they think a product catalog on a website should transfer automatically transfer over to a print catalog. Have any of you found good ways to deal with this. I'm looking for suggestions/direction because this comes up all the time and I have yet to provide my clients with a good flexible solution. Thanks, Rick ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
