CFWebstore ICVerify
If anyone is experienced with CFWebstore, I'm having trouble configuring the IC Share Directory in the Payment Mgr. I've entered "I:\icdata" but doesn't work. Can you please provide an example of the appropriate syntax for this field. I've installed the CFX_MICV tag. Thank you! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Filemaker on a MAC
I'm very interested in finding out if anyone has used a MAC Filemaker database to drive a site and if there are any compatibility issues with our hosting platform (We have NT4 SP5 servers running MIIS4 and CF4.5 Ent). Or if it just can't be done? It can be done, but FileMaker is quite different to most databases. Its ODBC implementation is pretty fragile. Most Mac people who use filemaker as their web DB platform use BlueWorld Lasso as the application server (it runs on Mac OS and Windows NT). And, is working with a filemake file the same as working sith Access (i.e. just upload the file, make the connection and way you go?). You have to have the Filemaker application running on the server to host filemaker files. The ODBC driver connects to the app, not the file itself. It can be a bit of a resource hog and is not suitable for sites that need any kind of scalability at all. If you have not had much FileMaker experience I'd steer clear if I were you. Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFWebstore ICVerify
Hey there LH, Check out the IC Verify list at: The ICVerify E-mail List is hosted by Humankind Systems, Inc. E-mail all commands to [EMAIL PROTECTED] Put commands in the message body To Subscribe: Subscribe icverify your_name To Un-Subscribe: Unsubscribe icverify More questions? mailto:[EMAIL PROTECTED] Aaron -Original Message- From: LH Rothman [mailto:[EMAIL PROTECTED]] Sent: Monday, September 04, 2000 11:12 PM To: CF Talk Subject: CFWebstore ICVerify If anyone is experienced with CFWebstore, I'm having trouble configuring the IC Share Directory in the Payment Mgr. I've entered "I:\icdata" but doesn't work. Can you please provide an example of the appropriate syntax for this field. I've installed the CFX_MICV tag. Thank you! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Java Custom Tags and File access
Cheers for the advice but I don't think this can be a classpath problem as I can quite happily call other classes in the same package. Any other ideas anyone? Cheers, Simon -- Sounds like a classpath issue with the server. What version of CF are you running and what are your classpath settings ? Chris Christopher Conrad Victoria's Secret Catalogue Limited Technology Services - New Media Senior.Programmer.Analyst http://www.VictoriasSecret.com 614.337.5653 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
This is a multi-part message in MIME format. --=_NextPart_000_0009_01C01718.DBE16690 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable unsubscribe This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp --=_NextPart_000_0009_01C01718.DBE16690 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=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2unsubscribe/FONT/DIV/BODY/HTML HTMLBODYBR BR This message has been checked for all known viruses, by Star Internet, BR delivered through the MessageLabs Virus Control Centre. BR For further information visit:BR A =20 href=3Dhttp://www.star.net.uk/stats.asp http://www.star.net.uk/stats.asp/ABR BR /BODY/HTML --=_NextPart_000_0009_01C01718.DBE16690-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 All, I have inherited the support/debug/function enhancement work on an application a previous developer built (yippee!). There are a number of queries on various pages (.cfm) of the app that use what looks to be valid SQL (although my SQL is adequate at best). Problem is, on my setup (Win2K Pro, CF Server 4.5.1, CF Studio 4.5.1) the SQL craps out and kills CF Server every time it encounters the code in the form shown below. The code works fine on another couple of machines (WinNT4, CF Server 4.5, CF Studio 4.0.1 and Win2K Adv Server, CF Server 4.5). The problem appears to be with the concatenation of several fields into an alias. For example: cfquery name="type_query" datasource="CVCOOOS" SELECT type_id, type_id ' (' description ')' AS temp FROM CallTypes WHERE new ORDER BY sequence /cfquery Like I said, the code kills CF Server on my setup, and works on others. Even running it within the Studio Query Builder, the query returns no result... I'm baffled. Any and all advice, even that pointing out how dopey I am for missing something obvious, will be happily received. Steve | Stephen Collins| | Consultant - Australian Corporate Information Solutions| |GPO Box 2962 CANBERRA ACT 2601 Australia| | Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722| | [EMAIL PROTECTED] [EMAIL PROTECTED] | | http://www.acis.com.au | |~~~oOo~~| | Before I got into triathlon, I was a normal person. | || -BEGIN PGP SIGNATURE- Version: PGP Personal Privacy 6.5.3 iQA/AwUBObQ6rdBcRJfAaSYUEQL2cwCfRFWgfP4ZdqoS/GqTcqmELb9ceK8AoNnW 5SbnTA+oJmyiBnEnJoESMLQ5 =7lgQ -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL problem - QUESTION ANSWERED BY SELF
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As usual, I managed to answer the question myself by looking around properly. This thread (http://forums.allaire.com/devconf/Thread.cfm?Message_ID=556006_#Me ssage556006) at the forums tells all. Sorry for bandwidth-wasting. Steve -BEGIN PGP SIGNATURE- Version: PGP Personal Privacy 6.5.3 iQA/AwUBObRB0tBcRJfAaSYUEQKvKgCgx43qX0ArRNhf5jQJ/l7ez1Tg5igAoMdA HJ5z8h/kf7cqhkB+gFkKkvX0 =jfbI -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help needed configuring a native datasource
Hi. I hope someone can advise me I just installed Oracle 8.1.5 (8i) on my system where I was previously running Oracle 7.3.4 and migrated my database to it using Oracle's migration tool. In Cold Fusion 4.5 Administrator, I removed my old datasource that pointed to Oracle73 and added a new one that pointed to Oracle80. Cold Fusion couldn't verify the new datasource. So I deleted it and reverted to Oracle73. Cold Fusion verified that one correctly. How come? If my database is Oracle 8.1.5, how come it verifies in Cold Fusion as Oracle73 but not as Oracle80? Thanks for any enlightenment anyone can shed -- Tim Dempsey P.S. In case it matters, the Oracle server and the Cold Fusion Server are both on the same NT box. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
It takes CF 1 minute to close DSN
I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table that is in DSN2. If I wait a minute then CF seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
TwoSelectsRelated Hack
Has anyone hacked CF_TWOSELECTSRELATED to allow more than one instance of the tag to be used on the same form? Dave --- David E. Crawford Director, Internet Development Yale Security Group, Inc. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL ORDER BY Problem
I have a query that selects dates from a datasource, and I would like to order by the number of days to the next occurrence, but the following doesn't work. SELECT Date FROM Dates ORDER BY #DateDiff(date, now())# The only way I can think of doing it would be to query the dates, do the CF calculations, then insert the results into a new column and order by that. ie... SELECT Date FROM Dates insert into dates (datediff) values (#datediff(date, now())#) SELECT Date, DateDiff FROM Dates ORDER BY DateDiff Can anyone come up with a solution that doesn't require 3 queries? (and yes I know I have missed the WHERE clause etc this is just an example of the code to keep the mail short. -- James Smith [EMAIL PROTECTED] When God created France he found it so perfect that to comfort those who couldn't live there, he created the French. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL problem
Steve SELECT type_id, type_id ' (' description ')' AS temp FROM CallTypes WHERE new ORDER BY sequence Is this a literal excerpt? "WHERE new" doesn't make sense to me. It should be WHERE something = something else. "ORDER BY sequence" doesn't either - "sequence" isn't in the SELECT clause. Also, if type_id is a numeric field, it would be better to cast it to a character type before using it in a concatenation. 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: TwoSelectsRelated Hack
I just did this! Put this in the HEAD of your page: SCRIPT LANGUAGE="JavaScript1.1" var maxlength = 10; OneA = new Array; var trueLength = OneA.length; var lst = OneA.length; function FormXChangeMenu(j) { OneA.length = 0; strclient = "document.FormX.ClientID" + j + ".selectedIndex" menuNum = eval(strclient); if (menuNum == null) return; CFINCLUDE TEMPLATE="app_Globals.cfm" CFQUERY NAME="GetClients" DATASOURCE="#DSN#" DBTYPE="ODBC" USERNAME="#DBUSER#" PASSWORD="#DBPASS#" SELECT ClientID, ClientName FROM Clients /CFQUERY CFLOOP INDEX="icount" FROM="1" TO="#GetClients.RecordCount#" CFSET jcount=icount+1 CFOUTPUT if (menuNum == #icount#){ NewOpt = new Array; NewVal = new Array; CFQUERY NAME="GetClientsAndTasks" DATASOURCE="#DSN#" DBTYPE="ODBC" USERNAME="#DBUSER#" PASSWORD="#DBPASS#" SELECT Clients.ClientID AS Clients_ClientID, Clients.ClientName, Tasks.TaskID, Tasks.ClientID AS Tasks_ClientID, Tasks.TaskName FROM Clients INNER JOIN Tasks ON Clients.ClientID = Tasks.ClientID WHERE Clients.ClientID=#icount# ORDER BY Clients.ClientName /CFQUERY CFSET thiscount=#GetClientsAndTasks.RecordCount#-1 CFLOOP INDEX="tcount" FROM="0" TO="#thiscount#" NewOpt[0] = new Option("Select a task"); NewOpt[0].value = ''; /CFLOOP /CFOUTPUT CFSET taskcount=0 CFOUTPUT QUERY="GetClientsAndTasks" CFSET taskcount=#taskcount#+1 NewOpt[#taskcount#] = new Option("#GetClientsAndTasks.TaskName#"); NewOpt[#taskcount#].value = '#GetClientsAndTasks.TaskID#'; /CFOUTPUT } /CFLOOP tot = NewOpt.length; str1st = "document.FormX.TaskID" + j + ".options.length"; lst = eval(str1st); for (i = lst; i 0; i--) { strtemp1 = "document.FormX.TaskID" + j + ".options[i]= null"; eval(strtemp1); } for (i = 0; i tot; i++) { strtemp1 = "document.FormX.TaskID" + j + ".options[i] = NewOpt[i]"; eval(strtemp1); } strtemp1 = "document.FormX.TaskID" + j + ".options[0].selected = true"; eval(strtemp1); } /SCRIPT And this is what I put in the body: CFLOOP INDEX="icount" FROM="1" TO="5" TR TD CFOUTPUT SELECT NAME="ClientID#icount#" onChange="FormXChangeMenu(#icount#)" SIZE="1" /CFOUTPUT OPTION VALUE=""Select a client CFOUTPUT QUERY="GetClients" OPTION VALUE="#ClientID#"#ClientName# /CFOUTPUT /SELECT CFOUTPUTSELECT NAME="TaskID#icount#" SIZE="1" OPTION VALUE=""Select a task /SELECT/CFOUTPUT BR /TD TD CFOUTPUT SELECT NAME="SunHours#icount#" /CFOUTPUT OPTION VALUE="0"Hrs CFOUTPUT QUERY="GetHours" OPTION VALUE="#Hours#"#Hours# /CFOUTPUT /SELECT /TD TD CFOUTPUT SELECT NAME="MonHours#icount#" /CFOUTPUT OPTION VALUE="0"Hrs CFOUTPUT QUERY="GetHours" OPTION VALUE="#Hours#"#Hours# /CFOUTPUT /SELECT /TD TD CFOUTPUT SELECT NAME="TueHours#icount#" /CFOUTPUT OPTION VALUE="0"Hrs CFOUTPUT QUERY="GetHours" OPTION VALUE="#Hours#"#Hours# /CFOUTPUT /SELECT /TD TD CFOUTPUT SELECT NAME="WedHours#icount#" /CFOUTPUT OPTION VALUE="0"Hrs CFOUTPUT QUERY="GetHours" OPTION
Inserting (or updating) more than one record at a time
I have more than one set of fields to insert or update in a table. See below for the fields and sample data... can someone tell me the best way to insert or update multiple rows? Form Fields: FIELDNAMES=CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOUR S1,FRIHOURS1,SATHOURS1,CLIENTID2,TASKID2,SUNHOURS2,MONHOURS2,TUEHOURS2,WEDHO URS2,THUHOURS2,FRIHOURS2,SATHOURS2,CLIENTID3,TASKID3,SUNHOURS3,MONHOURS3,TUE HOURS3,WEDHOURS3,THUHOURS3,FRIHOURS3,SATHOURS3,CLIENTID4,TASKID4,SUNHOURS4,M ONHOURS4,TUEHOURS4,WEDHOURS4,THUHOURS4,FRIHOURS4,SATHOURS4,CLIENTID5,TASKID5 ,SUNHOURS5,MONHOURS5,TUEHOURS5,WEDHOURS5,THUHOURS5,FRIHOURS5,SATHOURS5,SUBMI T CLIENTID1=3 CLIENTID2=1 CLIENTID3=1 CLIENTID4=4 CLIENTID5=2 FRIHOURS1=0 FRIHOURS2=0 FRIHOURS3=0 FRIHOURS4=0 FRIHOURS5=0 MONHOURS1=0 MONHOURS2=1.50 MONHOURS3=2.00 MONHOURS4=2.00 MONHOURS5=0 SATHOURS1=0 SATHOURS2=0 SATHOURS3=1.50 SATHOURS4=0 SATHOURS5=1.25 SUBMIT=Preview Timesheet SUNHOURS1=1.75 SUNHOURS2=0 SUNHOURS3=0 SUNHOURS4=0 SUNHOURS5=0 TASKID1=5 TASKID2=1 TASKID3=1 TASKID4=8 TASKID5=6 THUHOURS1=2.25 THUHOURS2=0 THUHOURS3=0 THUHOURS4=2.50 THUHOURS5=1.25 TUEHOURS1=1.50 TUEHOURS2=0 TUEHOURS3=0 TUEHOURS4=2.25 TUEHOURS5=2.50 WEDHOURS1=0 WEDHOURS2=2.00 WEDHOURS3=0 WEDHOURS4=0 WEDHOURS5=0 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL ORDER BY Problem
Let's hope this one gets there a bit quicker.. James What's wrong with SELECT Date FROM Dates ORDER BY Date? (You're not really using the name Date I guess) 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL ORDER BY Problem
ORDER BY Date will include the year, so 01/JAN/1940 will always appear before 02/DEC/1999 even though on 01/DEC/2000 it is only one day to the second date but 31 days to the first. That is why I need the datecompare function (although it is slightly more complicated than just datecompare(date, now()) it is actually #abs(datediff("D", createdate(year(now()), month(date), day(date)), now()))# but that isn't the point. - Original Message - From: "DeVoil, Nick" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: "'James Smith'" [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 2:23 PM Subject: RE: SQL ORDER BY Problem Let's hope this one gets there a bit quicker.. James What's wrong with SELECT Date FROM Dates ORDER BY Date? (You're not really using the name Date I guess) 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using COM with CF
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually... COM works just *FINE* in CFScript blocks. All you're doing w/ COM (as far as CF is concerned) is setting variables (properties) calling functions (invoking methods). Both of those functions work quite nicely in CFSCRIPT blocks. And in 4.5.1, you've even got a CreateObject function so you can create your ojects in CFSCRIPT blocks without needing to use CFOBJECT. I've never had any COM problems w/ CFSCRIPT. Best regards, Zac Bedell Hi Dave, Unfortunately CFSET does not work either. I can get at the object's public properties, but running the method does not work. I've tried using MSWord as a COM object and that did work. I'm at a loss. Thanks for the suggestion though. --Tom Unfortunately, using COM objects can be problematic with CF occasionally. Instead of doing what you're doing within a CFSCRIPT, you might have better luck doing it within CFSET tags: cfset rs = oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data") cfset rs = oASIWeb.SetDatabase("sdweb") cfset RetVal = oASIWeb.NewID("USERS") That usually works for me. To be honest, I've never used COM objects within CFSCRIPT, but I wouldn't be surprised if they're not supported within CFSCRIPT as well as they should be. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBObT4KgraVoMWBwRBEQKaXgCfaBSuSXXtHlUYt2yJ/auOljpYkqQAn1Vj ow3wFJgJB6b2bQ4pQwSMSlvO =3pHR -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL ORDER BY Problem
OK James, I understand what you're trying to do now. You can do it all in one SQL statement using database functions rather than going back to CF to do the work, it should be a lot faster. What DBMS are you 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL ORDER BY Problem
ODBC connection to Access. - Original Message - From: "DeVoil, Nick" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 2:43 PM Subject: RE: SQL ORDER BY Problem OK James, I understand what you're trying to do now. You can do it all in one SQL statement using database functions rather than going back to CF to do the work, it should be a lot faster. What DBMS are you 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. ASP (was: What I want in CF (was: Learning ASP))
But you have to admit Superman would kick the Hulk's butt :-) Sorry, but couldn't resist this... Which color Hulk, and which version of Superman? Which era of Hulk, which era of Superman... etc. etc. Sorry, but now I'm getting REALLY geeky g Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL ORDER BY Problem
Wouldn't your results be the same if you just ordered by Date? You're merely (trying to) subtract a constant from each Date. -David On Tue, 5 Sep 2000 "James Smith" [EMAIL PROTECTED] writes: I have a query that selects dates from a datasource, and I would like to order by the number of days to the next occurrence, but the following doesn't work. SELECT Date FROM Dates ORDER BY #DateDiff(date, now())# YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL ORDER BY Problem
ODBC connection to Access. Then you should be able to replicate the functionality of your CF statement with the Access functions DatePart(), DateDiff() and Now(). HTH 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSELECT, selected= doesnt work?! Am I going crazy?
Doesn't help me because I am not using a query as my option list is not in the database. At 09:18 PM 9/2/00 -0400, Bud wrote: On 9/2/00, Peter Theobald penned: [cfform action="#CGI.SCRIPT_NAME#" method="post" [cfselect name="letter" selected="B" [option value="A"Apple [option value="B"Bear [option value="C"Car [/cfselect [input type=submit [/cfform The options you put in there will not be selected. They will only be in addition to the options output by the query, which is noticeably absent from your cfselect tag. So, you run a query to get all the states "GetStates" that returns an ID for the state and the state's name. Then you run a query on a user "GetUser" to get his state ID on an update page. cfselect name="state_id" query="GetStates" selected="#GetUser.state_id#" value="state_id" display="state" If the users state if Florida and the state ID is FL, this will return all the states, with the users looking like: [select name="state_id" [option value="FL" selectedFlorida You would want to add an option manually maybe on the signup page where you could put: [option value=""Select A State -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFSELECT, selected= doesnt work?! Am I going crazy?
This is a multi-part message in MIME format. --=_NextPart_000_0219_01C01743.51708470 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Re: CFSELECT, selected= doesnt work?! Am I going crazy?Then, you will have to manually determine which item should be selected. The "selected" attribute of cfselect only works when combined with a query. DC -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 14:01 To: [EMAIL PROTECTED] Subject: Re: CFSELECT, selected= doesnt work?! Am I going crazy? Doesn't help me because I am not using a query as my option list is not in the database. At 09:18 PM 9/2/00 -0400, Bud wrote: On 9/2/00, Peter Theobald penned: [cfform action="#CGI.SCRIPT_NAME#" method="post" [cfselect name="letter" selected="B" [option value="A"Apple [option value="B"Bear [option value="C"Car [/cfselect [input type=submit [/cfform The options you put in there will not be selected. They will only be in addition to the options output by the query, which is noticeably absent from your cfselect tag. So, you run a query to get all the states "GetStates" that returns an ID for the state and the state's name. Then you run a query on a user "GetUser" to get his state ID on an update page. cfselect name="state_id" query="GetStates" selected="#GetUser.state_id#" value="state_id" display="state" If the users state if Florida and the state ID is FL, this will return all the states, with the users looking like: [select name="state_id" [option value="FL" selectedFlorida You would want to add an option manually maybe on the signup page where you could put: [option value=""Select A State -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_0219_01C01743.51708470 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLERe: CFSELECT, selected=3D doesnt work?! Am I going = crazy?/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD BODY DIVFONT color=3D#ff face=3DArial size=3D2SPAN = class=3D719471114-05092000Then,=20 you will have to manually determine which item should be selected. The=20 "selected" attribute of cfselect only works when combined with a=20 query./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D719471114-05092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D719471114-05092000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D719471114-05092000/SPAN/FONTnbsp;/DIV BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px" DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT = face=3DTahoma=20 size=3D2-Original Message-BRBFrom:/B Peter Theobald=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Tuesday, September = 05, 2000=20 14:01BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B Re: = CFSELECT,=20 selected=3D doesnt work?! Am I going crazy?BRBR/DIV/FONT PFONT size=3D2Doesn't help me because I am not using a query as my = option=20 list is not in the database./FONT /P PFONT size=3D2At 09:18 PM 9/2/00 -0400, Bud wrote:/FONT = BRFONT=20 size=3D2gt;On 9/2/00, Peter Theobald penned:/FONT BRFONT=20 size=3D2gt;gt;[cfform action=3D"#CGI.SCRIPT_NAME#" = method=3D"post"gt;/FONT=20 BRFONT size=3D2gt;gt;nbsp;nbsp; [cfselect name=3D"letter"=20 selected=3D"B"gt;/FONT BRFONT = size=3D2gt;gt;nbsp;nbsp;nbsp;nbsp;=20 [option value=3D"A"gt;Apple/FONT BRFONT=20 size=3D2gt;gt;nbsp;nbsp;nbsp;nbsp; [option = value=3D"B"gt;Bear/FONT=20 BRFONT size=3D2gt;gt;nbsp;nbsp;nbsp;nbsp; [option=20 value=3D"C"gt;Car/FONT BRFONT size=3D2gt;gt;nbsp;nbsp;=20 [/cfselectgt;/FONT BRFONT
Re: SQL ORDER BY Problem
Then you should be able to replicate the functionality of your CF statement with the Access functions DatePart(), DateDiff() and Now(). I had considered this, but the actual code requires an if statement cfif datecompare(createdate(year(now()), month(date), day(date)), now()) LTE 0 #abs(datediff("D", createdate(year(now()) +1, month(date), day(date)), now()))# cfelse #abs(datediff("D", createdate(year(now()), month(date), day(date)), now()))# /cfif to take into account the date having already occurred in this year and therefore needing to compare with next years date and my access coding isn't up to the task. If you could point me in the correct direction... :-) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Is it to be expected that a server may be down for 24 hours once in a while?
It all depends on what you are paying for. If you are getting Cold Fusion hosting and a SQL server database on a shared server for $10/mo then you take what you can get. If your site is "mission critical" then this is completely unacceptable, but you may have to pay more for more reliability. You will have to decide how much your budget will allow. Because of the nature of Cold Fusion and Database servers for reliability you really can't be on a shared server. You've been reading all these messages about how to use CFLOCK so you never 'crash' the server? What if you are sharing a server with someone who never heard of CFLOCK? A dedicated server will put you in control of your own server and take a lot of the unpredictability out of it, but it will cost more. If your site is *really* mission-critical for a client who has a real budget then you can do alot more for reliability like having a web farm (multiple Cold Fusion/Web servers with failover between them), a database cluster, etc. Make sure your hosting provider has redundant paths from your server out to the Internet including redundant routers, switches, etc. Actually go on a tour of the facility if possible. You'd be surprised how many ISPs promise alot but in person your server is sitting on someone's desk with a cat sleeping on top of it :-) At 08:48 AM 9/3/00 -0400, Hubert Earl wrote: Hi, Is it to be expected that a server may be down for 24 hours? The server I use has been down since yesterday, and I'm trying to decide whether to should shift to a different server. It is true that this is the first time it has been down so long, but as I need to use it to do business on the Net, it is rather unsettling. However, I don't want to move if it is a situation that may normally happen on most servers from time to time. Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Online Sale: http://cfwarrior.homeip.net/hubert/onlinesales/ebay_links_page.htm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
instant redirection based on reffering url
Is it possible in a non cf environment to let a page refresh to a specified paged based on the referring url. in other words detect the url the browser is coming from as in the referring url and then depending on the url the page refreshes to a specified page that way it www.website1.com and www.website2.com are both hosted on the one website virtual server the index page has the code to redirect the browser instantly to www.website1.com/website1.htm if the referring url is www.website1.com and if the referring url is www.website2.com then the index page on the server will auto refresh to www.website2.com/website2.htm that way you can have two totally separate website running off the one virtual server space have you seen this before and can you direct me to where I could find the code that will achieve this ??? can this be achieved using cf and can it also be achieved without being in a cf environment using standard java script for example Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL ORDER BY Problem
look at iif 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL ORDER BY Problem
Don't databases store 'date' types such that they CAN be compared exactly as you want? -David On Tue, 5 Sep 2000 14:30:57 +0100 "James Smith" [EMAIL PROTECTED] writes: ORDER BY Date will include the year, so 01/JAN/1940 will always appear before 02/DEC/1999 even though on 01/DEC/2000 it is only one day to the second date but 31 days to the first. That is why I need the datecompare function (although it is slightly more complicated than just datecompare(date, now()) it is actually #abs(datediff("D", createdate(year(now()), month(date), day(date)), now()))# YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: It takes CF 1 minute to close DSN
Have you spoken to the Admin of the server about this yet? I routinely do what you describe without fail which leads me to think it must be something other than CF that is causing the problem. Or perhaps posting a bit of your code would help us to identify if there is a CF code problem. Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: CF Forum [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 8:44 AM Subject: It takes CF 1 minute to close DSN I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table that is in DSN2. If I wait a minute then CF seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Kind of Transfer-Manager back to MS-Access
You should be able to do this by creating a DTS package in SQL Server and scheduling it to run at an appropriate time. Of course all of my experience is w/SQL Server 7.0, but I would think it would be similar in 6.5 if its possible at all. Philip -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Monday, September 04, 2000 4:27 PM To: [EMAIL PROTECTED] Subject: Kind of Transfer-Manager back to MS-Access I want to transfer data from an MS-SQL-Server (6.5) back to MS-Access for storage and offline reading reasons. Is there an CF-Application / Custom Tag which can do that automatically with the help of the CF-scheduler ? Or do I have to write my own app. here ? Thanks. Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problem setting up Verity.
Any help with this would be greatly appreciated. I'm following Forta's book for this. I set up the collection in the administrator. I then go to studio and use the wizard. I'm trying to set it up for a directory and sub-directories that contain nothing but html. The created templates load ok. I don't get an error when I do the initial indexing. But my results come back empty. And I don't have a clue. Is there a trick to verity? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
OK, I'm not sure what code you want to see, but here is the code for the page that has a link to anothere page. If this is not what you wanted plese let me know. Thanks for your help. html head titleCommon Support Eqiuipment/title /head cfset designator=1 body bgcolor="White" cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetProgram" datasource="#Application.settings.dsn#" dbtype="ODBC" SELECT Distinct Program FROM Equipment /cfquery /cflock table width="100%" border="0" cellspacing="0" cellpadding="0" tr bgcolor="Navy" td width="25%"bfont face="Arial" color="White"PROGRAM/font/b/td td width="75%"bfont face="Arial" color="White" img src="Images/blank.gif" width=35 height=12 border=0 alt="" img src="Images/blank.gif" width=35 height=12 border=0 alt="" img src="Images/blank.gif" width=35 height=12 border=0 img src="Images/blank.gif" width=35 height=12 border=0 EQUIPMENT/font/b /td /tr cfloop query="qryGetProgram" cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetProjects" datasource="#Application.settings.dsn#" dbtype="ODBC" SELECT * FROM Equipment WHERE program='#qrygetprogram.program#' ORDER BY Nomenclature asc /cfquery /cflock cfif designator Mod 2 cfset color="FF" cfelse cfset color="FF" /cfif tr bgcolor="cfoutput#color#/cfoutput" td width="25%" valign="TOP"cfoutputfont face="Verdana" size="1"#qryGetProgram.Program#/font/cfoutput/td td width="75%" valign="TOP" cfloop query="qryGetProjects" cfset strCLPTS="../clpts/CopyofClpts/Detail1.cfm?Niin=" #Niin# font face="Verdana" size="1" cfif #clpts# is not "" cfoutputa href="#strclpts#" target="_top"img src="Images/clpts.gif" width=35 height=12 border=0/a/cfoutput cfelse img src="Images/blank.gif" width=35 height=12 border=0 /cfif /cfoutput br /font /cfloop cfset designator=designator + 1 /td /cfloop /tr /table /body /html -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: Re: It takes CF 1 minute to close DSN Have you spoken to the Admin of the server about this yet? I routinely do what you describe without fail which leads me to think it must be something other than CF that is causing the problem. Or perhaps posting a bit of your code would help us to identify if there is a CF code problem. Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: CF Forum [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 8:44 AM Subject: It takes CF 1 minute to close DSN I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table that is in DSN2. If I wait a minute then CF seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives:
ReReplace and New Line
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01748.A11912F0 Content-Type: text/plain; charset="iso-8859-1" I'm new to CF and am having trouble using regular expressions using the ReReplace fuction. Can't seem to match a new line (normally "\n") Tried to use ascii code 10 as in :10:, but that does not seem to work. Anyone know where I can find some documentation for using regular expressions in CF? Sean Driscoll mailto:[EMAIL PROTECTED] IniNet, Inc. 16 Church Street Keene, NH 03431 http://www.ininet.com --_=_NextPart_001_01C01748.A11912F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEReReplace and New Line/TITLE /HEAD BODY PFONT SIZE=3D2 FACE=3D"Arial"I'm new to CF and am having trouble = using regular expressions using the ReReplace fuction./FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Can't seem to match a new line = (normally quot;\nquot;)/FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Tried to use ascii code 10 as in :10:, = but that does not seem to work./FONT /P PFONT SIZE=3D2 FACE=3D"Arial"Anyone know where I can find some = documentation for using regular expressions in CF?/FONT /P PFONT SIZE=3D2 FACE=3D"Verdana"Sean Driscoll/FONTBR U/UU/UUFONT COLOR=3D"#FF" SIZE=3D2 = FACE=3D"Verdana"lt;A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/Agt;= /FONT/UFONT FACE=3D"Arial" /FONT /P PFONT SIZE=3D2 FACE=3D"Verdana"IniNet, Inc./FONTFONT = FACE=3D"Arial"BR /FONTFONT SIZE=3D2 FACE=3D"Verdana"16 Church Street/FONTFONT = FACE=3D"Arial"BR /FONTFONT SIZE=3D2 FACE=3D"Verdana"Keene, NH 03431/FONTFONT = FACE=3D"Arial"BR /FONTU/UUFONT COLOR=3D"#FF" SIZE=3D2 = FACE=3D"Verdana"lt;A HREF=3D"http://www.ininet.com" = TARGET=3D"_blank"http://www.ininet.com/Agt;/FONT/UFONT = FACE=3D"Arial"BR /FONT /P /BODY /HTML --_=_NextPart_001_01C01748.A11912F0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Docs in PDF Format
As I found the online CF docs a hassle to use (that is, not indexed or searchable), I've turned them into Acrobat PDF files which are quickly searchable. It's simply wonderful to be able to search for any number of examples using a certain keyword. I hope you enjoy them as well. http://www.chesco.com/~randzman/CFDOCS/ Randy Zeitman -- Signature.. "In the best relationships sex is the booby prize." "I'm gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: It takes CF 1 minute to close DSN
On 9/5/00, Miriam Hirschman penned: I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table that is in DSN2. If I wait a minute then CF seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any help would be appreciated. Hi Miriam. I'll ask again. We can't possibly guess without seeing the code on the pages in question and maybe the URL to the site. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. ASP (was: What I want in CF (was: Learning ASP))
Hmmn I think the ASP vs CF thread is one of the longest running I have seen... anywhere :-P Heremy -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 9:17 AM To: [EMAIL PROTECTED] Subject: RE: CF vs. ASP (was: What I want in CF (was: Learning ASP)) But you have to admit Superman would kick the Hulk's butt :-) Sorry, but couldn't resist this... Which color Hulk, and which version of Superman? Which era of Hulk, which era of Superman... etc. etc. Sorry, but now I'm getting REALLY geeky g Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. ASP (was: What I want in CF (was: Learning ASP))
How about we let Microsoft's MSDN site settle this once and for all g: http://msdn.microsoft.com/library/default.asp?URL=/library/periodic/period00 /coldfusion.htm "Is ColdFusion the ideal Web development environment for everyone? Not necessarily. If your company already uses Visual Basic (VB) and is expanding into Web applications, then the ASP environment might make more sense for you, particularly if you work in an exclusively NT or Win2K environment. However, developing Web applications using ASP requires developers who are proficient in VB and VBScript. In contrast, I've observed programmers with little or no ColdFusion experience create dynamic pages within one week after seeing ColdFusion for the first time. Within a few months, they were creating extensive, complex Web applications. Because of its ease of use and its flexibility, ColdFusion might be the right choice for your Web development environment." -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 10:56 AM To: [EMAIL PROTECTED] Subject: RE: CF vs. ASP (was: What I want in CF (was: Learning ASP)) Hmmn I think the ASP vs CF thread is one of the longest running I have seen... anywhere :-P Heremy -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 9:17 AM To: [EMAIL PROTECTED] Subject: RE: CF vs. ASP (was: What I want in CF (was: Learning ASP)) But you have to admit Superman would kick the Hulk's butt :-) Sorry, but couldn't resist this... Which color Hulk, and which version of Superman? Which era of Hulk, which era of Superman... etc. etc. Sorry, but now I'm getting REALLY geeky g Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Java CFX tag developement question.....
In a java servlet you can get a Output stream by doing out = response.getOutputStream(); Is it possible to do the same with the com.allaire.cfx.Response? The response class doesn't seem to have any such methods? thank you Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Rereplace and newline
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0174B.947995E0 Content-Type: text/plain; charset="iso-8859-1" I'm new to CF and am having trouble using regular expressions using the ReReplace fuction. Can't seem to match a new line (normally "\n") Tried to use ascii code 10 as in :10:, but that does not seem to work. Anyone know where I can find some documentation for using regular expressions in CF? Sean Driscoll mailto:[EMAIL PROTECTED] IniNet, Inc. 16 Church Street Keene, NH 03431 http://www.ininet.com --_=_NextPart_001_01C0174B.947995E0 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLERereplace and newline/TITLE /HEAD BODY PFONT SIZE=2I'm new to CF and am having trouble using regular expressions using the ReReplace fuction./FONT /P PFONT SIZE=2Can't seem to match a new line (normally quot;\nquot;)/FONT /P PFONT SIZE=2Tried to use ascii code 10 as in :10:, but that does not seem to work./FONT /P PFONT SIZE=2Anyone know where I can find some documentation for using regular expressions in CF?/FONT /P PFONT SIZE=2Sean Driscoll/FONT BRFONT SIZE=2lt;A HREF="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/Agt; /FONT /P PFONT SIZE=2IniNet, Inc. /FONT BRFONT SIZE=216 Church Street /FONT BRFONT SIZE=2Keene, NH 03431 /FONT BRFONT SIZE=2lt;A HREF="http://www.ininet.com" TARGET="_blank"http://www.ininet.com/Agt; /FONT /P /BODY /HTML --_=_NextPart_001_01C0174B.947995E0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
This is the other page (the one that the first page links to.) html head meta name="GENERATOR" content="Microsoft FrontPage 3.0" titleCLPTS/title /head body bgcolor="#FF" cfset Count=0 cfset Symbol="" cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetDetail" datasource="#application.settings.dsn#" dbtype="ODBC" Select Niin, CurrentPri, PreviousPri, Nomenclature, PrContractNo, Poc, PartNo, Cage, Description, Rate, PicWebAddress, DetailLink From NewestMain Where niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetSchedule" datasource="#application.settings.dsn#" dbtype="ODBC" Select Buyyear, Qty, EAD, EDD From Schedule Where Niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetTotalSeca" datasource="#application.settings.dsn#" dbtype="ODBC" SELECT Seca, SumofQuantity From qryTotalSecas Where Niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetNotes" datasource="#application.settings.dsn#" dbtype="ODBC" Select myDate, Details From Notes Where Niin='#url.niin#' /cfquery /cflock table width="100%" border="0" cellspacing="0" cellpadding="0" tr td align="CENTER" strongfont face="Verdana" color="#80"bigCLOSED LOOP PROCUREMENT TRACKING SYSTEM/big/fontsmallsmallfont face="Arial" color="#408080" /font/small/small/strong /td td align="CENTER" a href="javascript:this.history.go(-1);" IMG src="BackArrowBlue.gif" border=0 width=27 height=25 alt=""/a brfont face="Verdana" size="-2"bBACK/b/font /td /tr /table table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#00" bordercolor="#00" style="border-bottom: medium none" tr td width="100%"font face="Verdana"strongsmallDATA/small/strong/font/td /tr /table table border="1" cellspacing="0" width="100%" bordercolor="#00" style="border-top: medium none; border-bottom: medium none" tr td width="13%" align="center" valign="middle" font face="Arial" color="#80"strongsmallCURR PRI/small/strong/font /td td width="13%" align="center" valign="middle" font face="Arial" color="#80"strongsmallPREV PRI/small/strong/font /td td width="36%" align="center" valign="middle" font face="Arial" color="#80"strongsmallNOMENCLATURE/small/strong/font /td td width="15%" align="center" valign="middle" font face="Arial" color="#80"strongsmallNIIN/small/strong/font /td /tr cfoutput query="qryGetDetail" tr td width="13%" align="center" valign="middle" smallfont face="Verdana"nbsp;#CurrentPri# /font/small /td td width="13%" align="center" valign="middle"small font face="Verdana"nbsp;#PreviousPri#/font/small /td td width="36%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Nomenclature#/font/small /td td width="15%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Niin#/font/small /td /tr /table table border="1" cellspacing="0" width="100%" bordercolor="00" style="border-top: medium none; border-bottom: medium none" tr td width="17%" align="center" valign="middle" font face="Arial" color="80"strongsmallPOINT OF CONTACT/small/strong/font /td td width="17%" align="center" valign="middle" font face="Arial" color="80"strongsmallPART NUMBER/small/strong/font/td td width="4%" align="center" valign="middle" font face="Arial" color="80"strongsmallCAGE/small/strong/font /td td width="22%" align="center" valign="middle" font face="Arial" color="80"strongsmallPR/CONTRACT NUMBER/small/strong/font /td /tr tr td width="17%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Poc#/font/small /td td width="17%" align="center" valign="middle" smallfont face="Verdana"nbsp;#PartNo#/font/small /td td width="4%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Cage#/font/small /td
Multiple Records
Hi All, I want to insert multiple records at the same time, by pressing one submit button. All the data will then "hopefully" be inserted into the table. All the data is new. I want to create a form with many rows(which form the records), where the columns are the fields I want to insert. I have tried to write a CFLOOP so that all the rows have different names, i.e. Field_One_1, Field_Two_1 and then the next row would be Field_One_2, Field_Two_2 and so on. I would really appreciate any help you could give.I have enclosed my CF code to give you an idea of the form which I am generating. Regards, Gaurav P.S The field #number# comes from the previous page where according to the user I create the appropriate number of rows for him\her to enter the data. cfoutput input type="text" name="number" value="#form.number#" body table tr tdfont face="Arial" size="2"ISRC Code/td tdfont face="Arial" size="2"Track/td tdfont face="Arial" size="2"Writer/td tdfont face="Arial" size="2"Artist/td tdfont face="Arial" size="2"Category/font/td/tr CFLOOP INDEX="fieldnumber" FROM="1" TO="#number#" trtdfont face="Arial" size="1"input type="text" name="ISRC#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name="Track#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name="Writer#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name="Artist#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name = "category" value="#category#"/td/tr /CFLOOP /cfoutput /table input type="submit" value="Continue " /form --- Demech International www.demech.net 15 Courtfield Rd, London,SW7 4DA Tel : +44 207 370 4906 Fax: +44 207 835 1068 --- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person(s). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
This is a multi-part message in MIME format. --=_NextPart_000_0257_01C0174C.9993FDA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: It takes CF 1 minute to close DSNWell, to my eye, it looks like you are using "#application.settings.dsn#" in both pages, so unless the tables in question are in the that datasource you are going to have some issues. Have you tried testing with hard coded datasource names instead of looking in the application scope to see if there is a difference in behavior? DC -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 15:13 To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is the other page (the one that the first page links to.) html head meta name="GENERATOR" content="Microsoft FrontPage 3.0" titleCLPTS/title /head body bgcolor="#FF" cfset Count=0 cfset Symbol="" cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetDetail" datasource="#application.settings.dsn#" dbtype="ODBC" Select Niin, CurrentPri, PreviousPri, Nomenclature, PrContractNo, Poc, PartNo, Cage, Description, Rate, PicWebAddress, DetailLink From NewestMain Where niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetSchedule" datasource="#application.settings.dsn#" dbtype="ODBC" Select Buyyear, Qty, EAD, EDD From Schedule Where Niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetTotalSeca" datasource="#application.settings.dsn#" dbtype="ODBC" SELECT Seca, SumofQuantity From qryTotalSecas Where Niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetNotes" datasource="#application.settings.dsn#" dbtype="ODBC" Select myDate, Details From Notes Where Niin='#url.niin#' /cfquery /cflock table width="100%" border="0" cellspacing="0" cellpadding="0" tr td align="CENTER" strongfont face="Verdana" color="#80"bigCLOSED LOOP PROCUREMENT TRACKING SYSTEM/big/fontsmallsmallfont face="Arial" color="#408080" /font/small/small/strong /td td align="CENTER" a href="javascript:this.history.go(-1);" IMG src="BackArrowBlue.gif" border=0 width=27 height=25 alt=""/a brfont face="Verdana" size="-2"bBACK/b/font /td /tr /table table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#00" bordercolor="#00" style="border-bottom: medium none" tr td width="100%"font face="Verdana"strongsmallDATA/small/strong/font/td /tr /table table border="1" cellspacing="0" width="100%" bordercolor="#00" style="border-top: medium none; border-bottom: medium none" tr td width="13%" align="center" valign="middle" font face="Arial" color="#80"strongsmallCURR PRI/small/strong/font /td td width="13%" align="center" valign="middle" font face="Arial" color="#80"strongsmallPREV PRI/small/strong/font /td td width="36%" align="center" valign="middle" font face="Arial" color="#80"strongsmallNOMENCLATURE/small/strong/font /td td width="15%" align="center" valign="middle" font face="Arial" color="#80"strongsmallNIIN/small/strong/font /td /tr cfoutput query="qryGetDetail" tr td width="13%" align="center" valign="middle" smallfont face="Verdana"nbsp;#CurrentPri# /font/small /td td width="13%" align="center" valign="middle"small font face="Verdana"nbsp;#PreviousPri#/font/small /td td width="36%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Nomenclature#/font/small /td td width="15%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Niin#/font/small /td /tr /table table border="1" cellspacing="0" width="100%" bordercolor="00" style="border-top: medium none; border-bottom: medium none" tr td width="17%" align="center" valign="middle" font face="Arial" color="80"strongsmallPOINT OF
Dates from #Week(Date)#
Is there a way to get the range of dates if all you have is a week number? For example, if you have a Week field in a table, can you get the days of the week and corresponding dates using only the Week number? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Rereplace and newline
I think you need to use something along the lines of chr(13) chr(10) RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Multiple Records
See http://forums.allaire.com/devconf/Index.cfm?Message_ID=180096 -Original Message- From: Gaurav Malik [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 11:08 AM To: [EMAIL PROTECTED] Subject: Multiple Records Hi All, I want to insert multiple records at the same time, by pressing one submit button. All the data will then "hopefully" be inserted into the table. All the data is new. I want to create a form with many rows(which form the records), where the columns are the fields I want to insert. I have tried to write a CFLOOP so that all the rows have different names, i.e. Field_One_1, Field_Two_1 and then the next row would be Field_One_2, Field_Two_2 and so on. I would really appreciate any help you could give.I have enclosed my CF code to give you an idea of the form which I am generating. Regards, Gaurav P.S The field #number# comes from the previous page where according to the user I create the appropriate number of rows for him\her to enter the data. cfoutput input type="text" name="number" value="#form.number#" body table tr tdfont face="Arial" size="2"ISRC Code/td tdfont face="Arial" size="2"Track/td tdfont face="Arial" size="2"Writer/td tdfont face="Arial" size="2"Artist/td tdfont face="Arial" size="2"Category/font/td/tr CFLOOP INDEX="fieldnumber" FROM="1" TO="#number#" trtdfont face="Arial" size="1"input type="text" name="ISRC#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name="Track#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name="Writer#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name="Artist#fieldnumber#"/tdtdfont face="Arial" size="1"input type="text" name = "category" value="#category#"/td/tr /CFLOOP /cfoutput /table input type="submit" value="Continue " /form --- Demech International www.demech.net 15 Courtfield Rd, London,SW7 4DA Tel : +44 207 370 4906 Fax: +44 207 835 1068 --- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person(s). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Boolean values in WDDX
Is there a simple way to make cfwddx tag a CF variable as Boolean? If the value of a variable is simply "TRUE" or "FALSE", cfwddx just creates a string value out of it. However, if you use an isSomething() function, the XML in the WDDX packet will show that the value is Boolean. No, unfortunately, you'll have to do this "casting" yourself. This isn't just true for Boolean variables, but also for any non-string simple data. For example, if you have an integer, you'll have to wrap it in Var() to get CFWDDX to write it out as an integer instead of a string. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF-Talk V1 #184
Is there a way to get the last value of an autoincrementing field, immediately after an insert statement, without another select over the table? I know this is now possible in ADO, is there a way in Cold Fusion? Kwasi Date-Bah System Developer iMediapoint.com 1-7 Fulham High Street London SW6 3JH Tel: 020 75983060 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
Each page is part of an application. There are two application, which are it two separate folders. They each have their own application.cfm page which refers to their own DSN. -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:19 AM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is a multi-part message in MIME format. --=_NextPart_000_0257_01C0174C.9993FDA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: It takes CF 1 minute to close DSNWell, to my eye, it looks like you are using "#application.settings.dsn#" in both pages, so unless the tables in question are in the that datasource you are going to have some issues. Have you tried testing with hard coded datasource names instead of looking in the application scope to see if there is a difference in behavior? DC -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 15:13 To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is the other page (the one that the first page links to.) html head meta name="GENERATOR" content="Microsoft FrontPage 3.0" titleCLPTS/title /head body bgcolor="#FF" cfset Count=0 cfset Symbol="" cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetDetail" datasource="#application.settings.dsn#" dbtype="ODBC" Select Niin, CurrentPri, PreviousPri, Nomenclature, PrContractNo, Poc, PartNo, Cage, Description, Rate, PicWebAddress, DetailLink From NewestMain Where niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetSchedule" datasource="#application.settings.dsn#" dbtype="ODBC" Select Buyyear, Qty, EAD, EDD From Schedule Where Niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetTotalSeca" datasource="#application.settings.dsn#" dbtype="ODBC" SELECT Seca, SumofQuantity From qryTotalSecas Where Niin='#url.niin#' /cfquery /cflock cflock timeout="30" throwontimeout="No" name="#session.urltoken#" cfquery name="qryGetNotes" datasource="#application.settings.dsn#" dbtype="ODBC" Select myDate, Details From Notes Where Niin='#url.niin#' /cfquery /cflock table width="100%" border="0" cellspacing="0" cellpadding="0" tr td align="CENTER" strongfont face="Verdana" color="#80"bigCLOSED LOOP PROCUREMENT TRACKING SYSTEM/big/fontsmallsmallfont face="Arial" color="#408080" /font/small/small/strong /td td align="CENTER" a href="javascript:this.history.go(-1);" IMG src="BackArrowBlue.gif" border=0 width=27 height=25 alt=""/a brfont face="Verdana" size="-2"bBACK/b/font /td /tr /table table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#00" bordercolor="#00" style="border-bottom: medium none" tr td width="100%"font face="Verdana"strongsmallDATA/small/strong/font/td /tr /table table border="1" cellspacing="0" width="100%" bordercolor="#00" style="border-top: medium none; border-bottom: medium none" tr td width="13%" align="center" valign="middle" font face="Arial" color="#80"strongsmallCURR PRI/small/strong/font /td td width="13%" align="center" valign="middle" font face="Arial" color="#80"strongsmallPREV PRI/small/strong/font /td td width="36%" align="center" valign="middle" font face="Arial" color="#80"strongsmallNOMENCLATURE/small/strong/font /td td width="15%" align="center" valign="middle" font face="Arial" color="#80"strongsmallNIIN/small/strong/font /td /tr cfoutput query="qryGetDetail" tr td width="13%" align="center" valign="middle" smallfont face="Verdana"nbsp;#CurrentPri# /font/small /td td width="13%" align="center" valign="middle"small font face="Verdana"nbsp;#PreviousPri#/font/small /td td width="36%" align="center" valign="middle" smallfont face="Verdana"nbsp;#Nomenclature#/font/small /td td width="15%" align="center" valign="middle" smallfont
RE: CF-Talk V1 #184
At 16:40 9/5/00 +0100, you wrote: Is there a way to get the last value of an autoincrementing field, immediately after an insert statement, without another select over the table? I know this is now possible in ADO, is there a way in Cold Fusion? I think you could do it with a trigger, if your database supports it. Something like this (syntax is not correct): begin trigger on TABLE for INSERT: select ID_column from inserted as your_last_inserted_id; end trigger -Ryan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFOBJECT and com components
This is a multi-part message in MIME format. --=_NextPart_000_001B_01C01758.3A50AB20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Ok I have built a com component in VB and registered it on the server = with regserver32. I am now trying to use it in cf but I cant seem to? Here is how I call the object, and it is supposed to simply return a = recordset. cfobject=20 type=3D"com" name=3D"Recordset" class=3D"macoOrder.cOrders" action=3D"create" This bit works fine but when I want to use a method of the object = (GetOrders) it seems to fall over. cfset Recordset.getOrders() This doesn't work cfloop collection =3D #Recordset# item =3D whatever cfoutput #whatever# /cfoutput =20 /cfloop doesn't work either? any suggestions??? --=_NextPart_000_001B_01C01758.3A50AB20 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 http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Ok I have built a com component in VB = and=20 registered it on the server with regserver32.nbsp;nbsp; I am now = trying to use=20 it in cf but I cant seem to?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Here is how I call the object, and it = is supposed=20 to simply return a recordset./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; lt;cfobject = /FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; type=3D"com"/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; name=3D"Recordset"/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; class=3D"macoOrder.cOrders"/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; action=3D"create"gt;/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; This bit works fine = but when I=20 want to use a method of the object (GetOrders)nbsp;it seems to fall=20 over./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2lt;cfset = Recordset.getOrders()gt;/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2This doesn't work/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2lt;cfloop collection =3D = #Recordset#nbsp; item =3D=20 whatevergt;/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; = lt;cfoutputgt;/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 #whatever#/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp;=20 lt;/cfoutputgt;nbsp;nbsp;nbsp; /FONT/DIV DIVFONT face=3DArial size=3D2lt;/cfloopgt;/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2doesn't work either?nbsp;nbsp; = any=20 suggestions???/FONT/DIV/BODY/HTML --=_NextPart_000_001B_01C01758.3A50AB20-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
On 9/5/00, Miriam Hirschman penned: cfquery name="qryGetProgram" datasource="#Application.settings.dsn#" dbtype="ODBC" Where are you setting application.settings.dsn? What are you using for the datasource name on the second page? If you are using application.settings.dsn as the datasource name for both queries, and if that is supposed to change dynamically, depending on which page you are accessing (which by the way, would probably be a bad use of application variables) and it's not changing until AFTER you access the second query, then that would explain why it doesn't access the correct datasource until you click the 2nd time, AFTER the application variable is updated. Try entering the datasource names manually in both queries and see what happens. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using COM with CF
Actually... COM works just *FINE* in CFScript blocks. All you're doing w/ COM (as far as CF is concerned) is setting variables (properties) calling functions (invoking methods). Both of those functions work quite nicely in CFSCRIPT blocks. And in 4.5.1, you've even got a CreateObject function so you can create your ojects in CFSCRIPT blocks without needing to use CFOBJECT. I've never had any COM problems w/ CFSCRIPT. I had problems doing this with one of the 4.5.1 betas. I'm glad it works well now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Inserting (or updating) more than one record at a time
Gina, I don't have a specific response to your question, only a suggestion. If your form fields correspond to columns in a table, you might find everything much easier to deal with if you modify the structure of your database. You have, essentially, these types of information: CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOURS1, FRIHOURS1,SATHOURS1. To get different ClientIDs, you change the "1" to a different number and add new columns to the table. What you might consider is breaking this up into at least two tables, one for the ClientID, and the second one for the tasks and hours associated with that ID. All of the fields in the second table can have the ending number dropped, then be combined into a single table with only 9 columns. The ClientID field would be the link back to your Client table. Doing this will shrink the size and complexity of your database, make it easier to add new ClientIDs, if needed, and make inserts, updates, and deletes, not to mention select queries, a snap to write. HTH, --John Gina Shillitani gshillitani@GeckoTo: "'[EMAIL PROTECTED]'" Media.com[EMAIL PROTECTED] cc: 09/05/2000 08:10 Subject: Inserting (or updating) more than one record AMat a time Please respond to cf-talk I have more than one set of fields to insert or update in a table. See below for the fields and sample data... can someone tell me the best way to insert or update multiple rows? Form Fields: FIELDNAMES=CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOUR S1,FRIHOURS1,SATHOURS1,CLIENTID2,TASKID2,SUNHOURS2,MONHOURS2,TUEHOURS2,WEDHO URS2,THUHOURS2,FRIHOURS2,SATHOURS2,CLIENTID3,TASKID3,SUNHOURS3,MONHOURS3,TUE HOURS3,WEDHOURS3,THUHOURS3,FRIHOURS3,SATHOURS3,CLIENTID4,TASKID4,SUNHOURS4,M ONHOURS4,TUEHOURS4,WEDHOURS4,THUHOURS4,FRIHOURS4,SATHOURS4,CLIENTID5,TASKID5 ,SUNHOURS5,MONHOURS5,TUEHOURS5,WEDHOURS5,THUHOURS5,FRIHOURS5,SATHOURS5,SUBMI T -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
I thought that the application.cfm page is called before each page in that directory. So why doesn't the variable get updated before the page loads. Also, I've used this code before in other applications without a problem. I'm not sure I understand why this method is giving me an error now. In a CF article I read, it said that it is better not to hard code the DSN name, because it makes your code hard to maintain. Please explain. Thanks so much for your time. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:01 PM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN On 9/5/00, Miriam Hirschman penned: cfquery name="qryGetProgram" datasource="#Application.settings.dsn#" dbtype="ODBC" Where are you setting application.settings.dsn? What are you using for the datasource name on the second page? If you are using application.settings.dsn as the datasource name for both queries, and if that is supposed to change dynamically, depending on which page you are accessing (which by the way, would probably be a bad use of application variables) and it's not changing until AFTER you access the second query, then that would explain why it doesn't access the correct datasource until you click the 2nd time, AFTER the application variable is updated. Try entering the datasource names manually in both queries and see what happens. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. ASP (was: What I want in CF (was: Learning ASP))
Sorry, but couldn't resist this... Which color Hulk, and which version of Superman? The purple one? Allaire should get a cross-licensing ageement with Marvel/DC. Be _interesting_to see superheroes pitching the benefits of CF over ASP. The Beast giving a monologue on CFWDDX. Deathlok talking about integrating wireless devices with the web... ;-) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
TagCFMail::sendMessage error on Solaris
This is a multi-part message in MIME format. --=_NextPart_000_00A8_01C01719.8C6B7E10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, It appears this problem - TagCFMail::sendMessage - also occurs on = Solaris. I know there is a patch for NT. Is there a patch or is = Allaire working on a patch for Solaris? Robert Chang Web Developer Check Point Software Technologies, Inc. --=_NextPart_000_00A8_01C01719.8C6B7E10 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=3D"MSHTML 5.00.3015.1600" name=3DGENERATOR/HEAD BODY bgColor=3D#ff DIVHi all,/DIV DIVnbsp;/DIV DIVIt appears this problem - TagCFMail::sendMessage - also occurs on=20 Solaris.nbsp; I know there is a patch for NT.nbsp; Is there a patch or = is=20 Allaire working on a patch for Solaris?/DIV DIVnbsp;/DIV DIVRobert ChangBRWeb DeveloperBRCheck Point Software Technologies, = Inc./DIV/BODY/HTML --=_NextPart_000_00A8_01C01719.8C6B7E10-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Scheduled Task
Does anyone know how to run a "CFM" file, periodically, without the use of ColdFusion's scheduled task functions? For example, every 24-hours at a specified time. My web site is hosted on a shared server and the hosting company won't allow the use of the CF Administrator's scheduled tasks, nor will they allow the use of CFSCHEDULE. They say that both modify the registry and modification of the registry has been disabled for security reasons. Any ideas would be greatly appreciated. You can use the operating system scheduler, if you have access to that. However, I suspect that if you can't use the CF scheduler, you won't be able to access the OS scheduler. You could try, though. You'd need to build a batch file that would set the environment variables you need, which would probably require CFFILE. You might then be able to use CFEXECUTE to call the "at" command (assuming you're on NT) to schedule your batch file. Unfortunately for you, if your host doesn't let you use the CF scheduler, they probably don't let you use CFFILE or CFEXECUTE. As a workaround, you could have every page request within the application run a "schedule check". Use a database table and/or a complex memory variable to list what events you want, and when you want them to occur. Have your application's application.cfm file check to see whether the time for any unexecuted events has passed. If so, have the event execute, and mark it as executed in your table. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
More of an HTML question.....
I know I really shouldn't be asking this sort of question here but can anyone tell me how you avoid underlining hyperlinks in your HTML code without using Style Sheets? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. ASP (was: What I want in CF (was: Learning ASP))
Oh.. thats bad *throws fruit at Lewis* Magneto discussing how hes turning everyone into CF developers for the years of pain and frustration ASP caused him. Jeremy -Original Message- From: lsellers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:12 PM To: [EMAIL PROTECTED] Subject: RE: CF vs. ASP (was: What I want in CF (was: Learning ASP)) Sorry, but couldn't resist this... Which color Hulk, and which version of Superman? The purple one? Allaire should get a cross-licensing ageement with Marvel/DC. Be _interesting_to see superheroes pitching the benefits of CF over ASP. The Beast giving a monologue on CFWDDX. Deathlok talking about integrating wireless devices with the web... ;-) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More of an HTML question.....
a href="#linktome#"span style="text-decoration:none"Link Text/span/a -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:20 AM To: Jones, Matt Subject: More of an HTML question. I know I really shouldn't be asking this sort of question here but can anyone tell me how you avoid underlining hyperlinks in your HTML code without using Style Sheets? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: transferring SQL server DB to an ISP
I'm having to transfer an SQL server to a client's ISP - this is the first time I have had to do this. I have a book on SQL server which doesn't cover this exactly, but it seems I should be using DTS Transfer Manager? You could use Transfer Manager, which would require you to be able to connect via SQL Enterprise Manager to both the source and target databases. In my experience, the ISP will generally open a hole in their firewall to allow this as needed, and give you the TCP/IP connection information you'll need (and in some cases, they'll be able to walk you through the process if needed). Alternatively, you could just send the database as a file. There are a couple of ways you can do this. You can back it up to file on the source machine, then send that file off to the target machine, where the administrator of that machine could then restore it from the file. This obviously doesn't require that you have access to the target machine. In this vein, you could send the actual database files themselves - without even doing a backup - and they could be attached on the target server using sp_attach_db (which I believe is new to SQL Server 7). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs. ASP (was: What I want in CF (was: Learning ASP))
Gives "X-Men" a whole new meaning. Steve -Original Message- From: lsellers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:12 PM To: [EMAIL PROTECTED] Subject: RE: CF vs. ASP (was: What I want in CF (was: Learning ASP)) Sorry, but couldn't resist this... Which color Hulk, and which version of Superman? The purple one? Allaire should get a cross-licensing ageement with Marvel/DC. Be _interesting_to see superheroes pitching the benefits of CF over ASP. The Beast giving a monologue on CFWDDX. Deathlok talking about integrating wireless devices with the web... ;-) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Apache Isn't Playing Nice with ColdFusion...
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these particular problems, I'd really appreciate it. Reply OTL if you feel it is appropriate. Thanks again, Matthew --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEApache Isn't Playing Nice with ColdFusion.../TITLE /HEAD BODY PFONT SIZE=3D2Hello!/FONT /P PFONT SIZE=3D2I installed Apache 1.3.12 on my machine last night, = and I got it running with the following problems. Any help on any of = these points would be greatly appreciated. Win98/C533/64MB/CF4.5 = config. TIA!/FONT/P PFONT SIZE=3D21) I can't get Apache to run automatically or as a = service in the background/FONT BRFONT SIZE=3D2nbsp;nbsp; like PWS used to./FONT /P PFONT SIZE=3D2Right now, I've got a shortcut to apache.exe in my = startup group with ColdFusion server. Yes, it seems like a huge hack to = me, too. So, at startup, I get a DOS-looking window that says something = like quot;Apache running...quot;, and indeed it is. But, the DOS = window can't be closed without killing Apache, and even when I try to = shut down, I have to Alt-F4 the window and say yes to the quot;are you = surequot; dialog. Then, next time I start Apache, I get a little = message in the DOS window about Apache being started after it was = closed inappropriately last time. Using Start gt; Programs gt; Apache = gt; Stop Apache gives me an error if the Apache DOS window is still = open. Trying to install Apache as a service gives me some error in a = DOS window that closes too quickly for me to read what it says. I just = want Apache to run in the background with no help from me after I get = it set up the first time. In other words, I want it to run = quot;hiddenquot; like PWS did. (Although it does seem to run faster, = which was the reason for the quot;upgradequot;.)/FONT/P PFONT SIZE=3D22) The /images
Re: SQL ORDER BY Problem
SELECT Date, #DateDiff(date, now())# AS "DateSpan" FROM Dates ORDER BY DateSpan chris -- Original Message From: "David Shadovitz"[EMAIL PROTECTED] Subject: Re: SQL ORDER BY Problem Date: Tue, 5 Sep 2000 06:18:33 -0700 Wouldn't your results be the same if you just ordered by Date? You're merely (trying to) subtract a constant from each Date. -David On Tue, 5 Sep 2000 "James Smith" [EMAIL PROTECTED] writes: I have a query that selects dates from a datasource, and I would like to order by the number of days to the next occurrence, but the following doesn't work. SELECT Date FROM Dates ORDER BY #DateDiff(date, now())# YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Apache Isn't Playing Nice with ColdFusion...
Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these particular problems, I'd really appreciate it. Reply OTL if you feel it is appropriate. Thanks again, Matthew --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEApache Isn't Playing Nice with ColdFusion.../TITLE /HEAD BODY PFONT SIZE=3D2Hello!/FONT /P PFONT SIZE=3D2I installed Apache 1.3.12 on my machine last night, = and I got it running with the following problems. Any help on any of = these points would be greatly appreciated. Win98/C533/64MB/CF4.5 = config. TIA!/FONT/P PFONT SIZE=3D21) I can't get Apache to run automatically or as a = service in the background/FONT BRFONT SIZE=3D2nbsp;nbsp; like PWS used to./FONT /P PFONT SIZE=3D2Right now, I've got a shortcut to apache.exe in my = startup group with ColdFusion server. Yes, it seems like a huge hack to = me, too. So, at startup, I get a DOS-looking window that says something = like quot;Apache running...quot;, and indeed it is. But, the DOS = window can't be closed without killing Apache, and even when I try to = shut down, I have to Alt-F4 the window and say yes to the quot;are you = surequot;
RE: Apache Isn't Playing Nice with ColdFusion...
I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. PWS didn't run as a service, but rather as an application which showed its visual interface through the system tray. Apache can, in fact, be set to run as a service, but this requires Windows NT or Windows 2000. If you're using Windows 98, get used to having the DOS window open when Apache runs. There are nifty little "window hiding" utilities available to get it out of your face. 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? Right after all the other LoadModule lines. Make sure that you actually put the DLL in your modules directory, though. The DLL is in C:\CFUSION\BIN by default. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Apache Isn't Playing Nice with ColdFusion...
This is a multi-part message in MIME format. --=_NextPart_000_0295_01C01758.545BFF10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Apache Isn't Playing Nice with ColdFusion...Apache is a console application, and since Win95/98 don't really support services, you are stuck with what you have. The "dirty startup" problem is not a real problem. Just put it in your start menu and go. I put the LoadModule command for CF, right after the last LoadModule command in the httpd.conf file. If your images and style sheet directories are not below your htdocs root, you will need to establish a directoryalias for them in order for Apache to know where to serve them from. Apache is perfectly suited for development/testing on Win95/98. I have used it in production on WinNT 4.0 with no problems. You just have to realize that its heritage is Unix, so it has some characteristics that may appear to be a bit quirky to a Windoze user. DC -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 16:23 To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these particular problems, I'd really appreciate it. Reply OTL if you feel it is appropriate. Thanks again, Matthew --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEApache Isn't Playing Nice with ColdFusion.../TITLE /HEAD BODY PFONT SIZE=3D2Hello!/FONT /P PFONT SIZE=3D2I installed Apache 1.3.12 on my machine last night, = and I got it running with the following problems. Any help on any of = these points would be greatly appreciated.
RE: Apache Isn't Playing Nice with ColdFusion...
Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. CF works fine with Apache 1.3.12 (which is a higher version than 1.3.2; it's actually the latest version). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Shopping Cart
This is a multi-part message in MIME format. --=_NextPart_000_1803_01C0173D.82C757C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this question has been asked before. Is there a good open source = shooping cart besides the quickstore app?? Thanks, Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_1803_01C0173D.82C757C0 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=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I know this question has been asked = before.nbsp;=20 Is there a good open source shooping cart besides the quickstore=20 app??/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/FONT/DIV/BODY/HTML --=_NextPart_000_1803_01C0173D.82C757C0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Shopping Cart
CF comes with an example shopping cart app. Usually located in C:\Inetpub\wwwroot\CFDOCS\exampleapp\store At 01:30 PM 9/5/00 -0500, you wrote: This is a multi-part message in MIME format. --=_NextPart_000_1803_01C0173D.82C757C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this question has been asked before. Is there a good open source = shooping cart besides the quickstore app?? Thanks, Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_1803_01C0173D.82C757C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" I know this question has been asked = before. =20 Is there a good open source shooping cart besides the quickstore=20 app?? Thanks, Kevin Schmidt Internet Services=20 Manager Peterson, WIlliams Bizer Office: = 734.995.5000 Mobile:=20 734.649.4843 --=_NextPart_000_1803_01C0173D.82C757C0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Shopping Cart
www.cfwebstore.com Regards, Howie - Original Message - From: "Kevin Schmidt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 2:30 PM Subject: Shopping Cart This is a multi-part message in MIME format. --=_NextPart_000_1803_01C0173D.82C757C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this question has been asked before. Is there a good open source = shooping cart besides the quickstore app?? Thanks, Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_1803_01C0173D.82C757C0 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=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I know this question has been asked = before.nbsp;=20 Is there a good open source shooping cart besides the quickstore=20 app??/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/FONT/DIV/BODY/HTML --=_NextPart_000_1803_01C0173D.82C757C0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ODBC Date errors
List, I have a template that creates a query to get information for the month selected. I am doing this by constructing a query like this : CFSET Today = #CreateODBCDate(CreateDate(#ByYear#, #ByMonth#, 1))# CFSET EndDay = #CreateODBCDate(CreateDate(#ByYear#, #ByMonth#, DaysInMonth(#ByMonth#)))# CFQUERY name="Events" datasource="XXX" SELECT Location, Name, Time, Event_Date, Event_Number, Location FROM Tbl_Events WHERE Event_Date = #Today# AND Event_Date = #EndDay# /cfquery ByYear is passed as the year selected from a form. ByMonth is the numerical month passed from a form. Now the issue is that when I pass September as "9" then the above cfset for EndDay returns 2000- 9-31 (obviously wrong) and November as "11" returns 2000-11-31 (also wrong). What is the problem with these two months?? TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Shopping Cart
Able Commerce has a good OpenSource shopping cart if you are looking for one to purchase. -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 1:31 PM To: [EMAIL PROTECTED] Subject: Shopping Cart This is a multi-part message in MIME format. --=_NextPart_000_1803_01C0173D.82C757C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this question has been asked before. Is there a good open source = shooping cart besides the quickstore app?? Thanks, Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_1803_01C0173D.82C757C0 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=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I know this question has been asked = before.nbsp;=20 Is there a good open source shooping cart besides the quickstore=20 app??/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/FONT/DIV/BODY/HTML --=_NextPart_000_1803_01C0173D.82C757C0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Inserting (or updating) more than one record at a time
I have three tables, Tasks, Clients, and Timesheet. I have to enter the timesheets by week rather than by date. What I'm having a hard time with is inserting the individual records. There are multiple records, and they are named CLIENTID1, TASKID1, etc. with a loop on the page that submits the records for insertion. I can't figure out how to enter multiple records. The Timesheet table insert for a single record looks like this: INSERT INTO Timesheet(Week, UserID, ClientID, TaskID, Sun, Mon, Tue, Wed, Thu, Fri, Sat) VALUES(#Week(Now())#, #UserID#, #ClientID#, #TaskID#, '#SunTime#', '#MonTime#', '#TueTime#', '#WedTime#', '#ThuTime#', '#FriTime#', '#SatTime#') I need to be able to run this insert query on multiple records to be inserted. -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:02 AM To: [EMAIL PROTECTED] Subject: Re: Inserting (or updating) more than one record at a time Gina, I don't have a specific response to your question, only a suggestion. If your form fields correspond to columns in a table, you might find everything much easier to deal with if you modify the structure of your database. You have, essentially, these types of information: CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOURS1, FRIHOURS1,SATHOURS1. To get different ClientIDs, you change the "1" to a different number and add new columns to the table. What you might consider is breaking this up into at least two tables, one for the ClientID, and the second one for the tasks and hours associated with that ID. All of the fields in the second table can have the ending number dropped, then be combined into a single table with only 9 columns. The ClientID field would be the link back to your Client table. Doing this will shrink the size and complexity of your database, make it easier to add new ClientIDs, if needed, and make inserts, updates, and deletes, not to mention select queries, a snap to write. HTH, --John Gina Shillitani gshillitani@GeckoTo: "'[EMAIL PROTECTED]'" Media.com[EMAIL PROTECTED] cc: 09/05/2000 08:10 Subject: Inserting (or updating) more than one record AMat a time Please respond to cf-talk I have more than one set of fields to insert or update in a table. See below for the fields and sample data... can someone tell me the best way to insert or update multiple rows? Form Fields: FIELDNAMES=CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOUR S1,FRIHOURS1,SATHOURS1,CLIENTID2,TASKID2,SUNHOURS2,MONHOURS2,TUEHOURS2,WEDHO URS2,THUHOURS2,FRIHOURS2,SATHOURS2,CLIENTID3,TASKID3,SUNHOURS3,MONHOURS3,TUE HOURS3,WEDHOURS3,THUHOURS3,FRIHOURS3,SATHOURS3,CLIENTID4,TASKID4,SUNHOURS4,M ONHOURS4,TUEHOURS4,WEDHOURS4,THUHOURS4,FRIHOURS4,SATHOURS4,CLIENTID5,TASKID5 ,SUNHOURS5,MONHOURS5,TUEHOURS5,WEDHOURS5,THUHOURS5,FRIHOURS5,SATHOURS5,SUBMI T -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cffile - Unable to delete the file
I'm using cffile to delete files but occasionally get this error: Unable to delete the file The process cannot access the file because it is being used by another process. (error 32) Is there a way to let cf wait for the file or just overide the server and delete the file? TIA, John Elder www.Webtunes.com www.bla-bla.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC Date errors
You didn't read the documentation for the DaysInMonth() function, did ya? :) You can't just pass in a month number, you have to pass in a full date. Think about February. Wouldn't work in leap years, right? Instead, try using: DaysInMonth(Today) That should clear things right up. -Rick -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 1:35 PM To: Cold Fusion Subject: ODBC Date errors List, I have a template that creates a query to get information for the month selected. I am doing this by constructing a query like this : CFSET Today = #CreateODBCDate(CreateDate(#ByYear#, #ByMonth#, 1))# CFSET EndDay = #CreateODBCDate(CreateDate(#ByYear#, #ByMonth#, DaysInMonth(#ByMonth#)))# CFQUERY name="Events" datasource="XXX" SELECT Location, Name, Time, Event_Date, Event_Number, Location FROM Tbl_Events WHERE Event_Date = #Today# AND Event_Date = #EndDay# /cfquery ByYear is passed as the year selected from a form. ByMonth is the numerical month passed from a form. Now the issue is that when I pass September as "9" then the above cfset for EndDay returns 2000- 9-31 (obviously wrong) and November as "11" returns 2000-11-31 (also wrong). What is the problem with these two months?? TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Inserting (or updating) more than one record at a time
See http://forums.allaire.com/devconf/Index.cfm?Message_ID=180096 -Original Message- From: Gina Shillitani [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 1:42 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: Inserting (or updating) more than one record at a time I have three tables, Tasks, Clients, and Timesheet. I have to enter the timesheets by week rather than by date. What I'm having a hard time with is inserting the individual records. There are multiple records, and they are named CLIENTID1, TASKID1, etc. with a loop on the page that submits the records for insertion. I can't figure out how to enter multiple records. The Timesheet table insert for a single record looks like this: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC Date errors
The DaysInMonth function needs a date not just the month number but also the year. Try this. Good!! cfloop from=1 to="12" index="ii" cfoutputcfset byyear = "2000" cfset bymonth = ii CFSET Today = CreateODBCDate(CreateDate(ByYear, ByMonth, 1)) CFSET EndDay = CreateODBCDate(CreateDate(ByYear, ByMonth, DaysInMonth("#ByMonth#/#byyear#"))) #today# - #endday#br /cfoutput /cfloop Bad!! cfloop from=1 to="12" index="ii" cfoutputcfset byyear = "2000" cfset bymonth = ii CFSET Today = CreateODBCDate(CreateDate(ByYear, ByMonth, 1)) CFSET EndDay = CreateODBCDate(CreateDate(ByYear, ByMonth, DaysInMonth(ByMonth))) #today# - #endday#br /cfoutput /cfloop The second loop will bomb out on the second pass through because the DaysInMonth function isn't working properly. --K -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 10:35 AM To: Cold Fusion Subject: ODBC Date errors List, I have a template that creates a query to get information for the month selected. I am doing this by constructing a query like this : CFSET Today = #CreateODBCDate(CreateDate(#ByYear#, #ByMonth#, 1))# CFSET EndDay = #CreateODBCDate(CreateDate(#ByYear#, #ByMonth#, DaysInMonth(#ByMonth#)))# CFQUERY name="Events" datasource="XXX" SELECT Location, Name, Time, Event_Date, Event_Number, Location FROM Tbl_Events WHERE Event_Date = #Today# AND Event_Date = #EndDay# /cfquery ByYear is passed as the year selected from a form. ByMonth is the numerical month passed from a form. Now the issue is that when I pass September as "9" then the above cfset for EndDay returns 2000- 9-31 (obviously wrong) and November as "11" returns 2000-11-31 (also wrong). What is the problem with these two months?? TIA, Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ODBC Date Errors
Doh Sound of head hitting wall Thanks, I guess I need to read the Notes in the CFWACK closer, Thanks all Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Inserting (or updating) more than one record at a time
Gina, Try this for inserting: cfloop index="i" FROM="1" TO= "6" (change "to" to however many variables sets you have) cfset Thisweek = Evaluate("week" i) cfset Thisclientid= Evaluate("Form.clientid" i) cfset Thisuserid = Evaluate("Form.clientid" i) cfset Thistaskid= Evaluate("form.taskid" i) (do this for all your form variables) cfquery name="addrows" datasource="#dbname#" INSERT INTO Timesheet (week, clientid, userid, taskid, ..) VALUES ('#thisweek#', #thisclientied#, #thisuserid#, #thistaskid#, .) /cfquery /cfloop As for updating... use the same idea for an UPDATE statement, using your primary key data for the WHERE clause. HTH, Erika - Original Message - From: "Gina Shillitani" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 11:42 AM Subject: RE: Inserting (or updating) more than one record at a time : I have three tables, Tasks, Clients, and Timesheet. I have to enter the : timesheets by week rather than by date. What I'm having a hard time with is : inserting the individual records. There are multiple records, and they are : named CLIENTID1, TASKID1, etc. with a loop on the page that submits the : records for insertion. I can't figure out how to enter multiple records. The : Timesheet table insert for a single record looks like this: : : INSERT INTO : Timesheet(Week, : UserID, : ClientID, : TaskID, : Sun, : Mon, : Tue, : Wed, : Thu, : Fri, : Sat) : VALUES(#Week(Now())#, : #UserID#, : #ClientID#, : #TaskID#, : '#SunTime#', : '#MonTime#', : '#TueTime#', : '#WedTime#', : '#ThuTime#', : '#FriTime#', : '#SatTime#') : : I need to be able to run this insert query on multiple records to be : inserted. : : -Original Message- : From: John Allred [mailto:[EMAIL PROTECTED]] : Sent: Tuesday, September 05, 2000 11:02 AM : To: [EMAIL PROTECTED] : Subject: Re: Inserting (or updating) more than one record at a time : : : Gina, : : I don't have a specific response to your question, only a suggestion. If : your form fields correspond to columns in a table, you might find : everything much easier to deal with if you modify the structure of your : database. You have, essentially, these types of information: : CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOURS1, : FRIHOURS1,SATHOURS1. To get different ClientIDs, you change the "1" to a : different number and add new columns to the table. : : What you might consider is breaking this up into at least two tables, one : for the ClientID, and the second one for the tasks and hours associated : with that ID. All of the fields in the second table can have the ending : number dropped, then be combined into a single table with only 9 columns. : The ClientID field would be the link back to your Client table. Doing this : will shrink the size and complexity of your database, make it easier to add : new ClientIDs, if needed, and make inserts, updates, and deletes, not to : mention select queries, a snap to write. : : HTH, : --John : : : : : : Gina Shillitani : : gshillitani@GeckoTo: : "'[EMAIL PROTECTED]'" : Media.com[EMAIL PROTECTED] : : cc: : : 09/05/2000 08:10 Subject: Inserting (or : updating) more than one record : AMat a time : : Please respond to : : cf-talk : : : : : : : : : I have more than one set of fields to insert or update in a table. See : below : for the fields and sample data... can someone tell me the best way to : insert : or update multiple rows? : : Form Fields: : : FIELDNAMES=CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOUR : : S1,FRIHOURS1,SATHOURS1,CLIENTID2,TASKID2,SUNHOURS2,MONHOURS2,TUEHOURS2,WEDHO : : URS2,THUHOURS2,FRIHOURS2,SATHOURS2,CLIENTID3,TASKID3,SUNHOURS3,MONHOURS3,TUE : : HOURS3,WEDHOURS3,THUHOURS3,FRIHOURS3,SATHOURS3,CLIENTID4,TASKID4,SUNHOURS4,M : : ONHOURS4,TUEHOURS4,WEDHOURS4,THUHOURS4,FRIHOURS4,SATHOURS4,CLIENTID5,TASKID5 : : ,SUNHOURS5,MONHOURS5,TUEHOURS5,WEDHOURS5,THUHOURS5,FRIHOURS5,SATHOURS5,SUBMI : : T : : : : : : -- -- : -- : Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ : To Unsubscribe visit : http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or : send a message to [EMAIL PROTECTED] with 'unsubscribe' in : the body. : -- : Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ : To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives:
Shopping Cart (2)
This is a multi-part message in MIME format. --=_NextPart_000_1832_01C01742.ECD55C20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable What is the best way to store shopping cart items. I have noticed a = client variable with a list in one of the programs I downloaded. Is = this a good way to go or are there better ways out there. Let me know = what you think?? Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_1832_01C01742.ECD55C20 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=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2What is the best way to store shopping = cart=20 items.nbsp; I have noticed a client variable with a listnbsp;in one of = the=20 programs I downloaded.nbsp; Is this a good way to go or are there = better ways=20 out there.nbsp; Let me know what you think??/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/FONT/DIV/BODY/HTML --=_NextPart_000_1832_01C01742.ECD55C20-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL ORDER BY Problem
I meant to include the SQL DateDiff() function. Oopps, sorry... Here's the correct way: SELECT Date, DateDiff(DAY,Date, GetDate()) AS "DateSpan" FROM Dates ORDER BY DateSpan Chris -- Original Message From: "Dan Haley"[EMAIL PROTECTED] Subject: RE: SQL ORDER BY Problem Date: Tue, 5 Sep 2000 09:58:08 -0700 This one, just like James' original won't work because you are mixing CF and SQL statements. CF will try to evaluate the '#datediff(date, now())#' one time when it is preparing the SQL to send to the database. It will not be evaluated for each row of the query. Build your query with CF. Use SQL statements and functions for manipulating each row of the query. Dan -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 9:45 AM To: [EMAIL PROTECTED] Subject: Re: SQL ORDER BY Problem SELECT Date, #DateDiff(date, now())# AS "DateSpan" FROM Dates ORDER BY DateSpan chris -- Original Message From: "David Shadovitz"[EMAIL PROTECTED] Subject: Re: SQL ORDER BY Problem Date: Tue, 5 Sep 2000 06:18:33 -0700 Wouldn't your results be the same if you just ordered by Date? You're merely (trying to) subtract a constant from each Date. -David On Tue, 5 Sep 2000 "James Smith" [EMAIL PROTECTED] writes: I have a query that selects dates from a datasource, and I would like to order by the number of days to the next occurrence, but the following doesn't work. SELECT Date FROM Dates ORDER BY #DateDiff(date, now())# YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Need a good dynamic bar pie chart app...
Anyone have a tag/app that plays nicely with ColdFusion to create dynamic bar and pie chartsin a web page? I'm specifically looking for something that will display multiple recommended/actual vertical bars next to each other, in differing colors. Any help would be greatly appreciated. Thanks, all... CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: RE: Apache Isn't Playing Nice with ColdFusion... Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these particular problems, I'd really appreciate it. Reply OTL if you feel it is appropriate. Thanks again, Matthew --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEApache Isn't Playing Nice with ColdFusion.../TITLE /HEAD BODY PFONT SIZE=3D2Hello!/FONT /P PFONT SIZE=3D2I installed Apache 1.3.12 on my machine last night, = and I got it running with the following problems. Any help on any of = these points would be greatly appreciated.
RE: Need a good dynamic bar pie chart app...
Have you tried popchart from www.popchart.com? Very good product. Helge -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: 5. september 2000 20:32 To: [EMAIL PROTECTED] Subject: Need a good dynamic bar pie chart app... Anyone have a tag/app that plays nicely with ColdFusion to create dynamic bar and pie chartsin a web page? I'm specifically looking for something that will display multiple recommended/actual vertical bars next to each other, in differing colors. Any help would be greatly appreciated. Thanks, all... CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: RE: Apache Isn't Playing Nice with ColdFusion... Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these particular problems, I'd really appreciate it. Reply OTL if you feel it is appropriate. Thanks again, Matthew --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEApache Isn't Playing Nice
Re: (OT) Javascript Question
Not precisely, they CAN click again, but it won't do anything... John Andrichak IV Web Programmer Dannemiller Memorial Educational Foundation - Original Message - From: "Robert Everland III" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 11:25 PM Subject: RE: (OT) Javascript Question Now will this make it so they can't click the sumit image again? Bob Everland -Original Message- From: John Andrichak IV [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: (OT) Javascript Question Why don't you check to see if the image has already changed? If it has... then don't change the image and cancel the form submission. Try something like: form input name="whatever" type="image" src="my.img" onClick="return doChangeSubmit();" /form with this JavaScript: script language="JavaScript" var submitted = false; function doChangeSubmit() { if(!submitted) { submitted = true; --- insert image change stuff... } else return false; } /script - Original Message - From: "Robert Everland" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 8:58 AM Subject: OT: Javascript Question I can't remember where or the name of the javascript forum off of cf-talk but I figured I may as well as my question and then have someone tell me where to do. I have a form button that is an image. I put some javascript in there so that when I click on it, it changes the image. What I want to do now is make it so that image is not clickable that way no one can keep clicking on submit. Anyone know how to do this, it can't be a href tag becuase I have to pass form variables. Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: instant redirection based on reffering url
You can access the reffering URL through javascript via the call "document.referrer" Hope this helps. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
next row in cfloop
Hey all, I am looping through a query and need to get data from the next row. Make sense? While my loop in handling row 5, I need to grab some data from row 6 and do a TimeFormat. I just can't seem to get to that next row. I have tried a number of different ways to do this but have had no luck. It seems that this screams for an embedded loop but I just can't seem to get what I want. If this makes any sense I anyone out there, I would be grateful for any assistance. Thanks, Tim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need a good dynamic bar pie chart app...
I was happy with an applet called tChart which allows you to pass parameters to various types of charts. At http://www.javaside.com/us/tchart.shtml you will find a demo and download. The download comes with several files depending on your circumstances. To pass parameters you'll want to use the example in tChart5.html source code. You do have to tinker with the html source code to get the number of columns, labels, colors, etc. that you want, but once you get the hang of it, it's a great tool at very low cost ($55 w/o Java source code). Marianne Daye -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 2:32 PM To: [EMAIL PROTECTED] Subject: Need a good dynamic bar pie chart app... Anyone have a tag/app that plays nicely with ColdFusion to create dynamic bar and pie chartsin a web page? I'm specifically looking for something that will display multiple recommended/actual vertical bars next to each other, in differing colors. Any help would be greatly appreciated. Thanks, all... CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: RE: Apache Isn't Playing Nice with ColdFusion... Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these
RE: next row in cfloop
#myquery.myfield[myquery.currentrow + 1]# And don't forget to check for when you are in the last row. ;) Dan -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:53 AM To: [EMAIL PROTECTED] Subject: next row in cfloop Hey all, I am looping through a query and need to get data from the next row. Make sense? While my loop in handling row 5, I need to grab some data from row 6 and do a TimeFormat. I just can't seem to get to that next row. I have tried a number of different ways to do this but have had no luck. It seems that this screams for an embedded loop but I just can't seem to get what I want. If this makes any sense I anyone out there, I would be grateful for any assistance. Thanks, Tim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: music cd file management in ColdFusion
I actually used Min's tag to create a basic MP3 cataloging app with a playlist generator. The app also creates CD burn config files so you can create mixes online and then burn a CD of that mix just by loading the saved config file :) Cool. That's what she's for. :) The tool works great, thanks for the great work Min. np. Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Unix File Permissions
Can someone tell me what the minium file permissions need to be for a cold fusion template and its directory in unix. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: next row in cfloop
Instead of using CFLOOP QUERY="x" use CFLOOP FROM="1" TO="#x.RecordCount#" INDEX="i". Then just make sure that you reference all your vars as #x.FieldName[i]#. Or, you should be able to use the CurrentRow variable from that first loop. EIther way will work, it just depends on which you think you like better. CFQUERY DATASOURCE="#Application.DataSource#" NAME="x" SELECT bug_id BugID, created_dt Created FROM bugs_bugs ORDER BY created_dt /CFQUERY !--- Method One --- CFLOOP QUERY="x" CFIF CurrentRow IS NOT RecordCount CFSET NextID=CurrentRow+1 CFOUTPUTDiff: #DateDiff("d",Created,x.Created[NextID])#BR/CFOUTPUT /CFIF /CFLOOP CFOUTPUTHR/CFOUTPUT !--- Method Two --- CFSET NextToLast=x.RecordCount - 1 CFLOOP FROM="1" TO="#NextToLast#" INDEX="ThisID" CFSET NextID=ThisID+1 CFOUTPUTDiff: #DateDiff("d",x.Created[ThisID],x.Created[NextID])#BR/CFOUTPUT /CFLOOP -Rick -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 2:53 PM To: [EMAIL PROTECTED] Subject: next row in cfloop Hey all, I am looping through a query and need to get data from the next row. Make sense? While my loop in handling row 5, I need to grab some data from row 6 and do a TimeFormat. I just can't seem to get to that next row. I have tried a number of different ways to do this but have had no luck. It seems that this screams for an embedded loop but I just can't seem to get what I want. If this makes any sense I anyone out there, I would be grateful for any assistance. Thanks, Tim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need a good dynamic bar pie chart app...
Thanks, Helge...I'm downloading the eval right now. Can you give me any info on the usefulness of Popchart Live vs. Image Server or Image Server Pro? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Helge Hetland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 2:25 PM To: '[EMAIL PROTECTED]' Subject: RE: Need a good dynamic bar pie chart app... Have you tried popchart from www.popchart.com? Very good product. Helge -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: 5. september 2000 20:32 To: [EMAIL PROTECTED] Subject: Need a good dynamic bar pie chart app... Anyone have a tag/app that plays nicely with ColdFusion to create dynamic bar and pie chartsin a web page? I'm specifically looking for something that will display multiple recommended/actual vertical bars next to each other, in differing colors. Any help would be greatly appreciated. Thanks, all... CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: RE: Apache Isn't Playing Nice with ColdFusion... Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources
CFGRAPH
Is there anywhere I can go to see CFGRAPH examples? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need a good dynamic bar pie chart app...
No, sorry. I just started looking into it myself. I've tested ImageServer and relatively quickly managed to make Flash drill downs from CF queries. I guess this text from their web site tells you that ImageServer is the tool to use (Pro adds caching, loadbalancing and performance enhancements): "PopChart Image Server is a server-side tool written in 100% Java that generates high-quality dynamic charts and graphs and integrates easily with Allaire ColdFusion. PopChart Image Server can generate either GIF, or FLASH images from dynamic ColdFusion Queries. FLASH Images are smaller, quicker to generate, and allow interaction such as drill-down, roll-over, and popup text." Helge -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: 5. september 2000 21:15 To: [EMAIL PROTECTED] Subject: RE: Need a good dynamic bar pie chart app... Thanks, Helge...I'm downloading the eval right now. Can you give me any info on the usefulness of Popchart Live vs. Image Server or Image Server Pro? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Helge Hetland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 2:25 PM To: '[EMAIL PROTECTED]' Subject: RE: Need a good dynamic bar pie chart app... Have you tried popchart from www.popchart.com? Very good product. Helge -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: 5. september 2000 20:32 To: [EMAIL PROTECTED] Subject: Need a good dynamic bar pie chart app... Anyone have a tag/app that plays nicely with ColdFusion to create dynamic bar and pie chartsin a web page? I'm specifically looking for something that will display multiple recommended/actual vertical bars next to each other, in differing colors. Any help would be greatly appreciated. Thanks, all... CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: RE: Apache Isn't Playing Nice with ColdFusion... Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the
Re: next row in cfloop
cfloop query="myQuery" this loop: #field# cfif currentRow IS NOT myQuery.recordcount next loop: #query.field[currentRow+1]# /cfif /cfloop HTH Sharon At 02:53 PM 9/5/2000 -0400, Tim Bahlke wrote: Hey all, I am looping through a query and need to get data from the next row. Make sense? While my loop in handling row 5, I need to grab some data from row 6 and do a TimeFormat. I just can't seem to get to that next row. I have tried a number of different ways to do this but have had no luck. It seems that this screams for an embedded loop but I just can't seem to get what I want. If this makes any sense I anyone out there, I would be grateful for any assistance. Thanks, Tim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT SQL 7 FULL-TEXT more than one column?
I know you can assign more than one column in setting up a fulltext index on a table -- but it seems like you can't include more than one column in the where CONTAINS statement...if this is indeed true how do you create a query to search thru all of the columns you have included in the fulltext indexing of a given table? An example would be highly appreciated! TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: It takes CF 1 minute to close DSN
Miriam, Have you ensured that "maintain database connections" options is UNchecked in your odbc settings for both datasources on the server? Dave Wilson Internet Technology Manager, BizNet Solutions Allaire Premier Partner Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast BT9 6GE Tel: 02890 225 776 Fax: 02890 223 223 web: http://www.biznet-solutions.com email: [EMAIL PROTECTED] - Original Message - From: "Miriam Hirschman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 5:12 PM Subject: RE: It takes CF 1 minute to close DSN I thought that the application.cfm page is called before each page in that directory. So why doesn't the variable get updated before the page loads. Also, I've used this code before in other applications without a problem. I'm not sure I understand why this method is giving me an error now. In a CF article I read, it said that it is better not to hard code the DSN name, because it makes your code hard to maintain. Please explain. Thanks so much for your time. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:01 PM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN On 9/5/00, Miriam Hirschman penned: cfquery name="qryGetProgram" datasource="#Application.settings.dsn#" dbtype="ODBC" Where are you setting application.settings.dsn? What are you using for the datasource name on the second page? If you are using application.settings.dsn as the datasource name for both queries, and if that is supposed to change dynamically, depending on which page you are accessing (which by the way, would probably be a bad use of application variables) and it's not changing until AFTER you access the second query, then that would explain why it doesn't access the correct datasource until you click the 2nd time, AFTER the application variable is updated. Try entering the datasource names manually in both queries and see what happens. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need a good dynamic bar pie chart app...
Hmmm...I can't seem to get anyone from Corda on the phone...just keep getting voicemail. Any idea what pricing is like? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Helge Hetland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 2:25 PM To: '[EMAIL PROTECTED]' Subject: RE: Need a good dynamic bar pie chart app... Have you tried popchart from www.popchart.com? Very good product. Helge -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: 5. september 2000 20:32 To: [EMAIL PROTECTED] Subject: Need a good dynamic bar pie chart app... Anyone have a tag/app that plays nicely with ColdFusion to create dynamic bar and pie chartsin a web page? I'm specifically looking for something that will display multiple recommended/actual vertical bars next to each other, in differing colors. Any help would be greatly appreciated. Thanks, all... CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: RE: Apache Isn't Playing Nice with ColdFusion... Allaire only supports 1.3.2 and better :) From the allaire site.. "ColdFusion supports only Apache version 1.3.2 and above" For Version 4.01 And for.. 4.5 in my CFDOCS it says "To configure the Apache Web Server v1.3.6" which kind of implies that you have to use that. And apache will not run in the background in Win98 try reading the release notes for Win32 apache ... Here http://www.apache.org/docs/windows.html Apache + CF + NT is real easy with the right versions etc. Jeremy -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:23 PM To: '[EMAIL PROTECTED]' Subject: Apache Isn't Playing Nice with ColdFusion... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01755.9FA441D8 Content-Type: text/plain; charset="iso-8859-1" Hello! I installed Apache 1.3.12 on my machine last night, and I got it running with the following problems. Any help on any of these points would be greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA! 1) I can't get Apache to run automatically or as a service in the background like PWS used to. Right now, I've got a shortcut to apache.exe in my startup group with ColdFusion server. Yes, it seems like a huge hack to me, too. So, at startup, I get a DOS-looking window that says something like "Apache running...", and indeed it is. But, the DOS window can't be closed without killing Apache, and even when I try to shut down, I have to Alt-F4 the window and say yes to the "are you sure" dialog. Then, next time I start Apache, I get a little message in the DOS window about Apache being started after it was closed inappropriately last time. Using Start Programs Apache Stop Apache gives me an error if the Apache DOS window is still open. Trying to install Apache as a service gives me some error in a DOS window that closes too quickly for me to read what it says. I just want Apache to run in the background with no help from me after I get it set up the first time. In other words, I want it to run "hidden" like PWS did. (Although it does seem to run faster, which was the reason for the "upgrade".) 2) The /images and /stylesheets directories aren't working, unless... If I open up IE and hit my site, no images appear, and the page is rendered without stylesheets, but is otherwise completely functional (queries run, CFML is parsed, etc.). So, I can go through and use the site without images or stylesheets, which is very annoying. But, if I hit Back or use history.back();, *the page appears like it is supposed to, complete with images and stylesheets*! Consecutive visits to the same page exhibit the problems above, but again, using Back or history.back(); will "fix" it. That's pretty strange. Yes, the directories are properly mapped in CF Admin. All of the other dir mappings work correctly. Perhaps I need to add the .jpg/.gif/.css file types to httpd.conf? Code, anyone? 3) Where in httpd.conf is the LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll line supposed to go? At home last night, I stuck it on a new line at the very end of section 1, after "#ExtendedStatus On" because I didn't see that it was already there, but commented out. Could this be causing the problem listed above? I'll fix that straightaway when I get home and see, although I'm sure I'll have the answer from you guys before then. :-) 4) Any other Apache/Win32/ColdFusion tips? If you have any tips or can point me to some on-line resources for these particular