Re: brain far
Actually I am in the process of converting this site to SP. I am a big fan of them. - Original Message - From: Matthew W Jones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 10:21 AM Subject: RE: brain far use a stored procedure for your insert could probably use cfqueryparam also -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 8:54 AM To: CF-Talk Subject: brain far Question, I am having a brain fart. I am entering information into a database, and one of the fields takes in a comma separated list. The insert query is; cfquery datasource=#WME.DSN# INSERT INTO Coupon (Vendor_ID, C_Title, C_Details, C_Inst, C_Valid, C_Office, Venue_City_ID) Values (#qGetLastID.LastID#, '#Form.C_Title#', '#Form.C_Details#', '#Form.C_Inst#', '#Form.C_Valid#', '#Form.C_Office#', '#Form.Venue#' /cfquery The Venue_City_ID is the comma separated list. The field in the DB is a text field (SQL Server 7). When I view the output, I get something like '3,4,5'. I would think that this would be OK since everything is inside of single quotes. However, I am receiving errors. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '3,4,5'. SQL = INSERT INTO Coupon (Vendor_ID, C_Title, C_Details, C_Inst, C_Valid, C_Office, Venue_City_ID) Values (12, 'Ski Time', 'Test', 'Test', 'Test', 'Test', '3,4,5' I know that there is a simple solution, but it really escapes me. This is what happens when you have 5 projects all going at once. ~~ 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: Checking for NULL
Try this: cfif not len(trim(qQuery.strField)) it's null cfelse it's not null /cfif -Tyson -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:48 AM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ 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: Checking for NULL
I use cfif Len(qQuery.field) EQ 0 This will only work for fields that will not contain blanks since it will generate the same result if it is blank or NULL. I hope there is a better solution. Russel -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:48 AM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ 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: Checking for NULL
Do you mean NULL specifically or just empty? I was taught by one of the learned ones to use this. cfif LEN(somevar) IS 0Do thiscfelseDo this other thing/cfif I remember a big discussion about this on performance, etc., but am now hazy on it. Anyone? -Gary -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:48 AM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ 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: Calling CFCONTENT generates 2 hits?
I've seen this happening with my apps that use cfcontent. I don't know if it's been consistent since I haven't been paying attention to it. I will also say that I've been having nothing but problems with cfcontent using cf5. My browser keeps locking up every now and then - and it's not even consistent. Sometimes I'm able to view 10 or more pdf's before locking up and other times I lock up on 3 or 4. I've reverted back to using cflocation to the pdf. I'm using frames on the particular page, so the path is hidden. -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 11:09 AM To: CF-Talk Subject: Calling CFCONTENT generates 2 hits? Hello, I'm capturing page hits into a database and anytime a page is called that has CFCONTENT in it I get two entries in my database. Is this a known behavior. The CFCONTENT page in question serves up a PDF file. 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
Twoselectrelated preselect
hi everybody, I need help to modify CF_TwoSelectRelated. does anyone has ever modify CF_TwoSelectsRelated so it can take preselected values, like the assigning values to default1/default2 parameters in CF_ThreeSelectsRelated. If anyone has this experience please give me a hand. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.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: ColdFusion license agreement
So downlaod the Enterprise 5 edition as eval? Eric J Hoffman Director of Internet Development Small Dog Design, LLC www.smalldogdesign.com Home of MN Vikings Fans Worldwide! www.purplepride.org -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 12:13 PM To: CF-Talk Subject: 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. ** ~~ 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: sorting within date range
Actually, you can feed CreateODBCDate whatever date you want, i.e: #CreateODBCDate(Form.Start_Date)# Brian - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 10:07 AM Subject: Re: sorting within date range The CreateODBCDate function actually creates a date of now. What you want is something like this: cfquery name=getcount datasource=#Request.App.dsn# SELECT * FROM tbl_downloads WHERE story = '#Form.story#' cfif startdate IS NOT AND datedownloaded = #DateFormat(Form.startdate)# /cfif cfif enddate IS NOT AND datedownloaded = #DateFormat(Form.enddate)# /cfif /cfquery - Original Message - From: Will Swain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 9:35 AM Subject: sorting within date range Hi, I want the user to be able to input a start and end date and then pull relevant records out of an Access db between those dates. The datatype in the db is Date/Time This is the query: cfquery name=getcount datasource=#Request.App.dsn# SELECT * FROM tbl_downloads WHERE story = '#Form.story#' cfif startdate IS NOT AND datedownloaded = #CreateODBCDate(Form.startdate)# /cfif cfif enddate IS NOT AND datedownloaded = #CreateODBCDate(Form.enddate)# /cfif /cfquery However, if I enter dates, they seem to be ignored, and the query just pulls out all instances if I have only entered a start date and none if I enter a start and an end date. Either way it's not working. Any suggestions? Cheers Will Swain ~~ 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: frames and cflocation
how do I do the equivalent of target =main with cflocation? With javascript. ~~ 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: sorting within date range
Look at your query closely. it's asking for everything that's greater than c, AND select everything less than e. so that means it will select a through z. umm I think. instead, use the BETWEEN thingy. dunno =) From: Will Swain [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: sorting within date range Date: Wed, 05 Sep 2001 15:35:36 +0100 Hi, I want the user to be able to input a start and end date and then pull relevant records out of an Access db between those dates. The datatype in the db is Date/Time This is the query: cfquery name=getcount datasource=#Request.App.dsn# SELECT * FROM tbl_downloads WHERE story = '#Form.story#' cfif startdate IS NOT AND datedownloaded = #CreateODBCDate(Form.startdate)# /cfif cfif enddate IS NOT AND datedownloaded = #CreateODBCDate(Form.enddate)# /cfif /cfquery However, if I enter dates, they seem to be ignored, and the query just pulls out all instances if I have only entered a start date and none if I enter a start and an end date. Either way it's not working. Any suggestions? Cheers Will Swain ~~ 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
SQL SERVER Usage Question
I have a client who's new site will have a 20,000 record song catalog. The site is search intensive. Is this a small record set? Should I consider a dedicated SQl Server or can I use a shared SQL server without a huge impact on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual 550 processor with RAID 1. Thanks for the advise, I realize the question is a little vague. ~~ 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: Looping through 5 session vars
Thanks Jeffry - Original Message - From: Jeffry Houser [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Wednesday, September 05, 2001 6:21 PM Subject: RE: Looping through 5 session vars I would do one CFIF: CFIF (not IsDefined(session.myvar)) or (not isDefined(session.myvar2)) or (not IsDefined(session.myvar3)) or (not IsDefined(session.myvar4)) or (not IsDefined(session.myvar5)) CFLOCATION /CFIF Don't forget to do a read-only lock to the above statement. No loop needed. Hi, I need to loop through 5 session variables to check if any one of them hasn't been defined. (and if so, cflocation the user). How can I do this? Thanks Will ~~ 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
Disabling back button
Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ 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: problems querying a query
I know that some syntax is not valid when querying a query and at first glance, the IS NOT NULL might be the culprit. I'm not 100% sure on that though. Mark -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:11 AM To: CF-Talk Subject: problems querying a query I am trying to query the results of a query against SQL server and am getting errors. The first query I am running is: cfquery name=qGetFour datasource=DEU SELECT CertificateID, AuditDate, WasVetTopOfCert FROM dbo.tblDEUCertificates WHERE AuditDate IS NOT NULL /cfquery The second query is: cfquery name=qGetFive dbtype=query SELECT WasVetTopOfCert FROM qGetFour WHERE WasVetTopOfCert IS NOT NULL /cfquery The error I get is: Error Diagnostic Information Query Manipulation Error Code = 0 Invalid Operator WasVetTopOfCert SQL = SELECT WasVetTopOfCert FROM qGetFour WHERE WasVetTopOfCert IS NOT NULL Data Source = Query qgetFour runs ok. WasVetTopOfCert is a bit field set to accept nulls. I have a feeling the problem is in the I check the a bit field for null values. Any ideas? Tim ~~ 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: CF-Community?
I just subscribed to CF-Community, thinking that I would ask a question over there because of the rash of OT postings here lately, and I haven't seen a single message thread come in yet. Is CF-Community up, or does it not have as much traffic as I was led to believe? Thanks! Hatton Humphrey ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Exchange Servers
I don't know your particular situation, but I can say that once I discovered SharePoint and Team Services - http://www.microsoft.com/sharepoint/ - I'll never build another intranet. Don't get me wrong, I love using CF, but when there's something better out there - go with it. I believe someone already mentioned this, but www.cfcomet.com is a great place for help on this topic. Good Luck! Mark -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:32 AM To: CF-Talk Subject: CF and Exchange Servers HI everyone. I am an intermediate CF developer in college. At work (school web team) I was asked to look into setting up an intranet, but the uppers want to pull stuff from an exhcange server (schedules, appointments, calendar info) for use in the intranet. Is there anyway to use CF to pull Data from an exchange server and possibly update it and send it back to the server ... all using CF. I would appreciate any insight anyone could offer. Thanks everyone. Mike Tangorre --Alfred University Student-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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: Calling CFCONTENT generates 2 hits?
Thank you. I had to put in a crude work around by moving my INSERT query to the CFCONTENT page in question and ignoring this page in my main logging module. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'stas ' [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 1:38 PM Subject: RE: Calling CFCONTENT generates 2 hits? I'm capturing page hits into a database and anytime a page is called that has CFCONTENT in it I get two entries in my database. Is this a known behavior. The CFCONTENT page in question serves up a PDF file. I'm pretty sure this is known behavior specifically with PDF files, due to some oddity in the Acrobat Reader. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OLE-DB Client Storage Problem
Hmmm...that's what I suspected, Jay. Thanks for chiming in. - Original Message - From: Jay Sudowski - Handy Networks LLC To: CF-Talk Sent: Wednesday, September 05, 2001 10:19 AM Subject: RE: OLE-DB Client Storage Problem Hi Dina - I don't believe that many folks use OLEDB at all. I tried setting up an OLEDB DSN for my client variables to SQL Server, and that process failed. In some instances I have been forced to develop with Access, and I attempted to use OLEDB, but I had a whole slew of problems and couldn't workaround the issues, so I reverted to ODBC. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:10 AM To: CF-Talk Subject: Re: OLE-DB Client Storage Problem Peter, Thank you for your response. I should probably re-word my question to, Is there anyone on this list who actually uses MS Access (or any other db for that matter) as an OLEDB datasource? I set my database up in CF Admin that way because I thought it would make it more robust (re: Allaire KB article) but OLEDB doesn't seem to be well supported by ColdFusion. By that, I mean there are no OLEDB date functions and, as I've already indicated, CF Admin is unable to make the necessary tables for client variable storage if the datasource is OLEDB. Your suggestion is by far the simplest solution...and I'm ready to bail. :-) Thanks, Dina - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Friday, August 31, 2001 6:39 PM Subject: RE: OLE-DB Client Storage Problem Possibly only supports ODBC connections. Try that first and it should be OK. ~~ 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: frames and cflocation
Here is some javascript that will work for you SCRIPT LANGUAGE=JavaScript TYPE=text/javascript parent.location=index.cfm'; /SCRIPT Replace index.cfm with the file or directory you want to goto Gary cfdev.com http://www.cfdev.com - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 11:15 AM Subject: Re: frames and cflocation Seamus Campbell wrote: I rarely use frames so know nothing about working with them. how do I do the equivalent of target =main with cflocation? Not. cflocation works server side and frames are client side. You will need to write some javascript to do that for you. Jochem ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Training Recommendations
Hi All - I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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: Checking for NULL
Depends on your database - some will accept: cfif qQuery.field eq and others will accept cfif qQuery.field eq null HTH J -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 15:48 To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ 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: sorting within date range
If the date is already in dataFormat you do not need to createODBCdate.Try prefacing the date variables with 'form.'. Also, put 'inverted commas' around form.startdate and form.enddate ie; '#form.startdate#'. Trent shepherd SeaSpray -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 12:36 AM To: CF-Talk Subject: sorting within date range Hi, I want the user to be able to input a start and end date and then pull relevant records out of an Access db between those dates. The datatype in the db is Date/Time This is the query: cfquery name=getcount datasource=#Request.App.dsn# SELECT * FROM tbl_downloads WHERE story = '#Form.story#' cfif startdate IS NOT AND datedownloaded = #CreateODBCDate(Form.startdate)# /cfif cfif enddate IS NOT AND datedownloaded = #CreateODBCDate(Form.enddate)# /cfif /cfquery However, if I enter dates, they seem to be ignored, and the query just pulls out all instances if I have only entered a start date and none if I enter a start and an end date. Either way it's not working. Any suggestions? Cheers Will Swain ~~ 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
Orlando CFUG Meeting
There will be a CFUG meeting tomorrow, Thursday September 6th at 7pm at the Lake Mary meeting facility. Our guest speaker will be Bob Baily from Macromedia to visit us and talk about CF5. We will also be giving out door prizes. Be there or be square. We have room to accomodate a lot of people so we hope you show up. The meeting will be in Lake Mary at Dixon Ticonderoga. The address is: 195 International Parkway Heathrow FL, 32746 http://www.cforlando.com/about/index.cfm/fuseaction/lakemary_map for map . Thanks, and hope to see you all there! -Randy p.s. Don't forget, LAKE MARY... not the Research Park location. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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: brain far
you're missing a closing ) on your values clause. christopher olive, cio cresco technologies, inc http://www.crescotech.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:54 AM To: CF-Talk Subject: brain far Question, I am having a brain fart. I am entering information into a database, and one of the fields takes in a comma separated list. The insert query is; cfquery datasource=#WME.DSN# INSERT INTO Coupon (Vendor_ID, C_Title, C_Details, C_Inst, C_Valid, C_Office, Venue_City_ID) Values (#qGetLastID.LastID#, '#Form.C_Title#', '#Form.C_Details#', '#Form.C_Inst#', '#Form.C_Valid#', '#Form.C_Office#', '#Form.Venue#' /cfquery The Venue_City_ID is the comma separated list. The field in the DB is a text field (SQL Server 7). When I view the output, I get something like '3,4,5'. I would think that this would be OK since everything is inside of single quotes. However, I am receiving errors. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '3,4,5'. SQL = INSERT INTO Coupon (Vendor_ID, C_Title, C_Details, C_Inst, C_Valid, C_Office, Venue_City_ID) Values (12, 'Ski Time', 'Test', 'Test', 'Test', 'Test', '3,4,5' I know that there is a simple solution, but it really escapes me. This is what happens when you have 5 projects all going at once. ~~ 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: Checking for NULL
cfif qQuery.field is Trent Shepherd SeaSpray -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 12:48 AM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ 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
what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. 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: CaNameingAdapter and ntConsoleJava.e
You had mentioned that this could cause problems with CFgraph because of a registry edit? Could you explain, I am doing a little logging and it is using an enormous amount of cpu. Thanks, Neil - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 24, 2001 3:00 PM Subject: RE: CaNameingAdapter and ntConsoleJava.e Neil, This KB article explains the fix: http://www.allaire.com/Handlers/index.cfm?ID=21807Method=Full --- Ben -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 12:31 PM To: CF-Talk Subject: Re: CaNameingAdapter and ntConsoleJava.e I spoke with Ben Forta last night at the Annapolis CFUG. He told me it is a known issue however I can not find any literature about it. He is supposed to email me the registry edit that is required. It has something to do with the JVM I believe. I will post the fix once I get it. I know people were looking for an answer because they were having trouble too... Neil - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 01, 2001 10:30 PM Subject: Re: CaNameingAdapter and ntConsoleJava.e SO what have we found? No one from Allaire has any comments?! Neil - Original Message - From: Dylan Bromby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 24, 2001 11:30 PM Subject: RE: CaNameingAdapter and ntConsoleJava.e IIS5.0 for me. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 7:09 PM To: CF-Talk Subject: Re: CaNameingAdapter and ntConsoleJava.e What webserver? There's a 'feature' in CF 5 that monitors the webserver so that it can be stopped/started/restarted. I'm using website, which is not supported so I got a lot of CPU and a ton of messages in the event log (3 every 10 seconds). I had to turn it off in the registry to stop it. I'm still looking what each piece does and what I can 'kill'. I notice that these programs which are the CF management and something else use a lot of CPU. It will last some amount of time and then stop. Any ideas on why this would be occuring? This oviously is CF 5.0 Thanks, Neil ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Admin) RE: Off topic posts was (OT?) TomCat vs JRun
People people volume volume... OT- kidding. the politics too.. can Michael kill those threads also :) that is what makes this palce a community.. the pleasantries, the frustration, politics and inappropriate behavior... :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: [EMAIL PROTECTED] (Michael Dinowitz) Date: Wed, 05 Sep 2001 10:55:51 -0400 Subject: (Admin) RE: Off topic posts was (OT?) TomCat vs JRun Discussion about if a post is OT or not should be moved to the CF-Community list. Discussion about the differences between JRun and TomCat should be on the JRun list. If you want to talk about the JRun tag pack that simulated CF in some ways then you can mention it here even though its a JRun issue. At 10:42 AM 9/5/01, you wrote: Hahaha. This is gonna be one of those funky threads, where the gripe about OT posts is actually longer than the original OT post! Kinda defeats the purpose, eh? Glad that I was able to contribute :) --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 5:39 PM To: CF-Talk Subject: RE: Off topic posts was (OT?) TomCat vs JRun My thoughts exactly! Sometimes, these OT posts help me out more that posts made to this list about CF (fundamentals, etc.)! - SVV -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 3:23 PM To: CF-Talk Subject: RE: Off topic posts was (OT?) TomCat vs JRun If it's clearly marked as OT, why not? Afterall, where else can one find a collective gathering of experts in related fields such as this list provides??? (not claiming to be one of those experts, but they are out there). I find the topics which are marked OT, are related to some aspect of web development, which may or may not help us all out. Just my thoughts. Shawn Grover -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 4:07 PM To: CF-Talk Subject: Off topic posts was (OT?) TomCat vs JRun (OT?) TomCat vs JRun No question at all. Its totally OT. What do people think about the increasing number of off topic posts on this list? Should they be tolerated as long as they are marked as OT? Or should we be actively trying to ensure that the signal to noise ratio on this list stays low by asking that people not post off topic material? ~~ 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: Calling CFCONTENT generates 2 hits?
I'm capturing page hits into a database and anytime a page is called that has CFCONTENT in it I get two entries in my database. Is this a known behavior. The CFCONTENT page in question serves up a PDF file. I'm pretty sure this is known behavior specifically with PDF files, due to some oddity in the Acrobat Reader. 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: OLE-DB Client Storage Problem
Back when I was messing with Access, I tried and eventually gave up trying to use OLEDB-connected client var storage. Access ODBC is still better than the registry, I think. As for sites, depending on your file spec OLEDB either works fine or not at all. I still have one site running on an Access OLEDB connection. One of these days I'll move it to mySQL/Win, which I think is the best replacement for Access you can get without springing for a real rdbms. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- from: Jay Sudowski - Handy Networks LLC I don't believe that many folks use OLEDB at all. I tried setting up an OLEDB DSN for my client variables to SQL Server, and that process failed. From: Dina Hess [mailto:[EMAIL PROTECTED]] Is there anyone on this list who actually uses MS Access (or any other db for that matter) as an OLEDB datasource? ~~ 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
Message Board Threads confusion
hey guys i wanna build a message board, but am having difficulty with the concept of threads. Let's say there is a message, and 10 people respond to that same message. Are those ten people in the same thread? or not? But let's say that person B replied a message From person A, then person C replied to person B, then D to C, and so on. Is that considered a thread? What if person X Y and J responding individually to person C's message. does that mean A,C,B,X,Y, and J are all in the same thread? confusing!!! ~~ 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: Activedit licensing...
Our intranet uses ActiveEdit to good effect. We are about to upgrade to CF5 so hopefully it will perform even better than it does under 4.5x. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 2:18 To: CF-Talk Subject: RE: Activedit licensing... And let me just chime in ... I looked at a couple similar applications before settling on ActiveEdit. It's well done, easy to use and does what it says it will do. Support has been good, too. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 4:13 AM To: CF-Talk Subject: Re: Activedit licensing... The Activedit License for $99 is for use with 10 domain names on one server. ~~ 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: Browser client for upload files?
Something like this (using a form and then an action page): First page (with form): form name=PDFUpload method=POST enctype=multipart/form-data action=uploadfile.cfm h5Filename:brinput type=file name=PDF size=40/h5 pinput type=submit value=Upload File /form Followed with the action page called uploadfile.cfm: cffile action=upload filefield=PDF destination=c:\uploadedpdffiles\ nameconflict=makeunique accept=image/gif,image/jpeg,image/jpg,image/pjpeg The above accepts only web image formats (Compuserve GIF, JPEG and Progressive JPEG). I'm not sure what the mime type for Acrobat PDF is. Perhaps www.adobe.com has the answer. You should use ACCEPT to prevent executable files being uploaded and then executed on the server (as an extra precaution). Also consider having the files uploaded to a directory out of the web server scope to avoid the chance of a malicious file being executed on the server. Ben Forta's excellent Web Application Construction Kit (http://www.forta.com/books/0789725843/) goes into this and many other CF topics. Highly recommended! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 2:49 To: CF-Talk Subject: Browser client for upload files? Alright, the client needs to upload a PDF file. How do I let the user browse their machine for the file to upload? I'd like to use CFTREE, right? I'm fuddled. Willy ~~ 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: CFLOCK and Session variables
CFLOCK is very important. ColdFusion is a multi-threaded application. Not locking writes to these variables could result in variable (memory) corruption. You should get into the habit of using CFLock even when simply outputting a applicatio, session variable. Ben Forta's excellent CF5WACK book - http://www.forta.com/books/0789725843/ explains locking in fine detail. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 2:45 To: CF-Talk Subject: CFLOCK and Session variables A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ 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
CFHTTP to a new window.
Can you run a CFHTTP that will send the file content to a new window? Thanks, Neil ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: frames and cflocation
That is correct; cflocation works from the server, and doesn't care what is in your browser. So to do things like this the only solution is to use JS to achieve your goal! Regards, Andrew Scott -Original Message- From: Billy Ng [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 2:25 AM To: CF-Talk Subject: RE: frames and cflocation I believe you can't. I've worked on an application which requires frames. And to redirecting, I had to use Javascript. Script Language=Javascript !-- top.main.location.href = http://www.whateveraddress.com;; // -- /Script Billy ~~ 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: Browser client for upload files?
Just use the following input type=file name=UploadFile That simple. Joel -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: September 5, 2001 11:49 AM To: CF-Talk Subject: Browser client for upload files? Alright, the client needs to upload a PDF file. How do I let the user browse their machine for the file to upload? I'd like to use CFTREE, right? I'm fuddled. Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: .biz domains ... what are the issues?
Sorry if this is off-topic, but I'm interested in the views of this group who know a lot about commercial sites I have been asked by a small but international client for my view on the new .biz domain names, and to my shame I hadn't really thought about it much. So I've tried to think through all the issues involved, and would appreciate the views of this list on the matter. What do you think needs to be considered about pre-registering .biz or .shop or whatever domains? Here's what I've listed so far . (1) .biz domains are global, so when you've got a name you've got it worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't. (2) If you don't pre-register your name in the .biz domain, someone else can end up taking your name. This might or might not be a problem depending on how important the .biz domains become. Do you guys think that these new domains will ultimately be as important as the .com domains? (3) If you don't pre-register your name you could find your own domain owned by an opportunist who will hold your name to ransom until you buy it from him at whatever price he wants. (4) If you have high traffic, someone else could use your name in one of these new tlds and use it to drive traffic to their site, parasitically. So you could end up with your customers being directed to a porn site or anything. And all at your cost. (4) Compared to the potential cost of having your name held to ransom or used by a competitor or even a porn site the cost of the new domains are chickenfeed. Is there anything else that needs to be taken into consideration? Cheers Mike Kear, Windsor, NSW, Australia AFP Webworks. www.afpwebworks.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: Disabling back button
is a nightmare! - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 3:51 AM Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ 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: Checking for NULL
I generally use cfif Len(Trim(qQuery.field)) EQ 0 Alistair Davidson Senior Developer Rocom New Media www.rocomx.net There is no spoon -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 15:48 To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ 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
testing
Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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
I've faced the same issue, and have had to setup datasources through the Win2K control panel. Sounds like a bug. Anyone else confirm? Thanks, Peter Janett New Media One Web Services WEB HOSTING FOR WEB DEVELOPERS Sun, IRIX, Windows 2000, Linux; PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 - Original Message - From: Freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 5:20 PM Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. 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. ** ~~ 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: Studio 4.5.1 and Windows 2000 Professional
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. K thanks I'll check that out. 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
thanks Re: frames and cflocation
Thanks gary and to everyone else that replied Seamus At 07:17 am 6/09/01 , you wrote: Here is some javascript that will work for you SCRIPT LANGUAGE=JavaScript TYPE=text/javascript parent.location=index.cfm'; /SCRIPT Replace index.cfm with the file or directory you want to goto Gary cfdev.com http://www.cfdev.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: Excel as a datasource .... ?
I should perhaps tell you more about the application ... it's a data table that's looked up by CF. It's for the Australian Consumers Association. When we do a test on a product, we want the results to be available. So you can put your preferences, dimensions etc and your priorities for ease of use, colours etc and the resulting table will give you the best buy for you. Some of these interactive apps are very small, quite short-lived and low traffic. They never involve the user inputting data. (I'd always use SQLServer for capturing any data from the user, e.g. polls, feedback, forms etc). The problem is the time taken to get the data from the test labs into SQLServer from the spreadsheets they use to collate their results. If we can use the spreadsheets, we can eliminate probably 80% of the cost of these interactive things and reduce the development time greatly. The usage of some of these is very high, and we'd continue to use SQL for those. The ones I'm thinking about are where we might get 300-1500 accesses a month. Does that change any of your opinions about using Excel spreadsheets as datasource? Incidentally I like the idea of using an Access database and linking to the spreadsheets, so I won't have problems swapping out the spreadsheets. I hadn't thought of that aspect yet. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Robert Crooks [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 1:28 AM To: CF-Talk Subject: RE: Excel as a datasource ? I have to agree with this -- my experience is that going low-end on the data store always proves to be a bad decision in the long run. One note on Excel that I haven't seen posted in this thread: I have seen spreadsheets start to develop serious data corruption problems as they grow beyond a certain size -- this may be dependent on system virtual memory availability. Robert Crooks Technical Lead Macromedia Educational Services http://www.allaire.com/conference/index.cfm -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:04 AM To: CF-Talk Subject: Re: Excel as a datasource ? excel as a datasource would make maintainability, scalability, and enhancements alot harder and in the long run cost more. Actually, at one place I worked at we charged more if the client wanted to use Access over SQLServer (I assume excel as a datasource would cost even more). On Wed, 5 Sep 2001, Mike Kear wrote: I have a client who's complaining that the time spent generating a small app using SQL is costing too much and wants to use excel spreadsheets instead. What's your experience using excel as a datasource? Just to clarify what the projects do, they don't write to the datasource, just look up and filter the data customising tables for the user's needs. The volumes aren't great - between a few hundred page views a month to 5000 or so. IS there likely to be implications for the usage of RAM and resources on the server? The System Admin is already complaining that he has to restart the server too often and when the processor usage gets to 100% he panics and complains. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Java
We had a problem on CF5 getting java stuff to work after changing settings in CFIDE - restarting CF made no difference - we couldnt see what was wrong... We rebooted the server and it all worked fine... this has happenned on more than one occasion... once we hadnt even changed any settings - just installed a java CFX... -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 17:35 To: CF-Talk Subject: 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