Re: CFDIRECTORY question
You can trim the extension via #ListFirst(qDirectory.Name,".")# (assuming there's only one period per file name). What's wrong with a simple CFQUERYinsert/CFQUERY? -David On Tue, 5 Sep 2000 Jacob McKee [EMAIL PROTECTED] writes: Please help! I need to know how to read all the files in a directory, trim the .gif or .jpg or what ever extension off and create a database record based on that file name. With the CFDIRECTORY, I can read a list of the files, but I can't get the INSERT to work. I also don't have any idea how to trim the extension off the file name. 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: CF Docs in PDF Format
Thanks a lot! I also prefer a PDF version for searching and, most important, printing. I already downloaded everything. All the best Massimo Foti [EMAIL PROTECTED] My own Corner of the web http://www.massimocorner.com Dreamweaver, Ultradev and Fireworks goodies It should be this hole in the ozone layer But I am not the coder I use to be... 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 -- 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 Server and MS Exchange 2000
How big is your server and how many users ? -Original Message- From: Luke Kearney [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 04:14 To: '[EMAIL PROTECTED]' Subject: CF Server and MS Exchange 2000 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_01C017B0.7ACC82C0 Content-Type: text/plain; charset="shift_jis" Content-Transfer-Encoding: quoted-printable Hi CF'ers, I realise why that Exchange 2000 is not oficially released yet but my = boss is thinking about running the Intranet on the same server as Exchange. Probably looking to work with CF 4.51. Can anybody see any immediate problems with that ?? =20 Any opinions,hints etc appreciated =20 thank you =20 =20 Luke Kearney =83=8B=81[=83N =83J=81[=83j=81[ East West Technology Service Inc. Tel (03) 3222 7459 Fax (03) 3222 5591 =20 --_=_NextPart_001_01C017B0.7ACC82C0 Content-Type: text/html; charset="shift_jis" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dshift_jis" META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD BODY DIVFONT face=3D"MS Gothic"SPAN class=3D309571403-06092000Hi=20 CF'ers,/SPAN/FONT/DIV DIVFONT face=3D"MS Gothic"SPAN class=3D309571403-06092000I = realise why that=20 Exchange 2000 is not oficially released yet but my boss is thinking = about=20 running the Intranet on the same server as Exchange. Probably looking = to work=20 with CF 4.51. Can anybody see any immediate problems with thatnbsp;=20 ??/SPAN/FONT/DIV DIVFONT face=3D"MS Gothic"SPAN=20 class=3D309571403-06092000/SPAN/FONTnbsp;/DIV DIVFONT face=3D"MS Gothic"SPAN class=3D309571403-06092000Any = opinions,hints=20 etc appreciated/SPAN/FONT/DIV DIVFONT face=3D"MS Gothic"SPAN=20 class=3D309571403-06092000/SPAN/FONTnbsp;/DIV DIVFONT face=3D"MS Gothic"SPAN class=3D309571403-06092000thank=20 you/SPAN/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Luke Kearney/FONT/DIV DIVFONT face=3DArial size=3D2=83=8B=81[=83N = =83J=81[=83j=81[/FONT/DIV DIVFONT face=3DArial size=3D2East West Technology Service = Inc./FONT/DIV DIVFONT face=3DArial size=3D2Telnbsp; (03) 3222 7459/FONT/DIV DIVFONT face=3DArial size=3D2Fax (03) 3222 5591/FONT/DIV DIVnbsp;/DIV/BODY/HTML --_=_NextPart_001_01C017B0.7ACC82C0-- -- 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
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). On top of the DaysInMonth error - your SQL won't work properly, unless you can guarantee that Event_Date is a date only, and doesn't include time The way I'd do it is to use make EndDay as the first of the month higher, and use "" Or you could use BETWEEN, as this handles what you're doing faster in SQL than using = and = 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.
ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems
We are still using CF 4.0.1 due to an inability to get 4.5.1 to consistently run on our SPARC Solaris 2.6 systems. While we are impatiently waiting for help from support, we have been seeing a two part problem in CF 4.0.1. First, we see the CF Scheduler after running a few days stop running. Within another day or two (of doing things like stopping and restarting ColdFusion, etc.) suddently ColdFusion no longer will run at all, reporting a corrupt Registry. If at that point in time we recover the Registry from a backup previous to when ColdFusion Scheduler quit working, the Scheduler starts up again. We are in need of tips, pointers, tools to analyze the Registry problem, etc. Any information you might be able provide to enable us to work out this problem would be appreciated. -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- 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.
Counting logged in users?
Hi all, Back on the list after a well needed vacation and guess what...I have more questions. I've been trying to find out how a simple way to get the number of user logged into my site that uses Advanced Security. Does anyone know how to do it? Regards Tage Widsell Webmaster Propellerhead Software -- 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.
Query Not working
This is a multi-part message in MIME format. --=_NextPart_000_000F_01C017DD.96038C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can someone tell me why this Query wouldn't work? Update TableC Set Fieldname =3D (Select * From TableB,TableC Where Somefield =3D AnotherField) for some reason Access says it needs to be an updatable query. Thanks for any help Ben Densmore --=_NextPart_000_000F_01C017DD.96038C00 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=3D2Can someone tell me why this Query = wouldn't=20 work?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Update TableC/FONT/DIV DIVFONT face=3DArial size=3D2Set Fieldname =3D (Select * = From/FONT/DIV DIVFONT face=3DArial size=3D2TableB,TableC/FONT/DIV DIVFONT face=3DArial size=3D2Where/FONT/DIV DIVFONT face=3DArial size=3D2Somefield =3D = AnotherField)/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2for some reason Access says it needs to = be an=20 updatable query./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks for any help/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Ben Densmore/FONT/DIV/BODY/HTML --=_NextPart_000_000F_01C017DD.96038C00-- -- 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: Query Not working
Update TableC Set Fieldname =3D (Select * From TableB,TableC Where Somefield =3D AnotherField) You're trying to update *one* column ("Fieldname") in TableC. The nested Select is selecting *all* the columns out of TableB and TableC. - Does not compute %) 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: cf error question...
I assume you mean the error messages with the diagnostic information in a box (syntax error, ODBC error, etc.)? The way you can set a default alternative for these admittedly ugly errors is to use the CFERROR tag in your application.cfm. If that's too limiting for what you wanted to do, you could use CFTRY/CFCATCH to trap individual errors per page and manipulate them. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Chris Terrebonne [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, September 05, 2000 6:15 PM Subject: cf error question... This has probably been covered already but... Is there any way to replace or customize CF's internal error messages ("canceled or ignored by server...", etc)? Thanks, Chris _ 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.
RE: CFFTP Question
yes, but is the CF service running as someone that has administrative rights or rights to that directory? Chris Olive, DOEHRS Website Administrator -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 5:26 PM To: [EMAIL PROTECTED] Subject: CFFTP Question This is a multi-part message in MIME format. --=_NextPart_000_000D_01C01756.0459E380 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to remove a directory with CFFTP and am getting a 550 Access = Denied error. I am trying to remove the directory from outside of it. = I am 100% sure that I have the permission to remove it as I am logged in = as Administrator on WIN2K. Any ideas??? Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_000D_01C01756.0459E380 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 am trying to remove a directory with = CFFTP and am=20 getting a 550 Access Denied error.nbsp; I am trying to remove the = directory=20 from outside of it.nbsp; I am 100% sure that I have the permission to = remove it=20 as I am logged in as Administrator on WIN2K.nbsp; Any = ideas???/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_000D_01C01756.0459E380-- -- 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 error question...
Thanks for the response. I understand how to use CFTRY/CFCATCH and CFERROR. The messages that I am trying to replace are the CF server errors messages like: "Request canceled or igorned by server", etc.. Those types of messages are not affected by try/catch or cferror. Any ideas? Thanks, Chris -- Original Message From: "Jamie Keane"[EMAIL PROTECTED] Subject: Re: cf error question... Date: Wed, 6 Sep 2000 08:57:14 -0400 I assume you mean the error messages with the diagnostic information in a box (syntax error, ODBC error, etc.)? The way you can set a default alternative for these admittedly ugly errors is to use the CFERROR tag in your application.cfm. If that's too limiting for what you wanted to do, you could use CFTRY/CFCATCH to trap individual errors per page and manipulate them. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Chris Terrebonne [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, September 05, 2000 6:15 PM Subject: cf error question... This has probably been covered already but... Is there any way to replace or customize CF's internal error messages ("canceled or ignored by server...", etc)? Thanks, Chris _ 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.
Re: URL varibles with same name
Yep I thought that was the only way to do it too, It worked but it's so clumsy.. Thx for the help. .Magnus At 13:16 2000-09-04 -0400, you wrote: On 9/4/00, Magnus Wallin penned: Hey folks. Was doing an implementation between two sites and I ran into a little problem. In their code they are using GET instead of POST in the FORMs And when I submit I get a querystring with variblenames that are duplicate (Yes all INPUT-fieldnames are named the same). If it would have been a POST all the data would have ended up in a List. But how do I do the same with the GET function? This will work. Once you set the values you can do what you want with them. Append them to your own list or whatever. cfloop index="var" list="#cgi.query_string#" delimiters="" cfset myvalue = right(var, len(var) - find("=", var)) cfset myvariable = left(var, find("=", var) - 1) #myvariable#br #myvalue#p /cfloop As usual, wait a couple hours and someone will come up with something better. -- 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.
Access 2000 to SQL Server 7.0
Say you define table relationships with cascacading updates or cascading deletes in Access 2000. With the upsizing wizard do the cascading updates and cascading deletes also get transferred to SQL Server 7.0 or do you have to create triggers? Sebastian -- 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 with WDDX
Hey all, I need a jump start with a WDDX solution I have to come up with. I need to query a table, take the results and change a few of the variable names, serialize it using wddx, and then send that packet in an email. Problem is, I have never done WDDX before... any pointers? Marcus -- 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
Tom, Sorry I missed the first part of your question. The only other suggestion I have is that I have had problems calling a method and passing a parameter to it. I tried it several times on an application I was writing and couldn't get it to work so I gave up. What I do instead is have properties on the object for every parameter. I then set these properties and call the method without parameters. You just need to make sure that your methods understand that if they don't have parameters to look at the property on the object to get the value to use. This seems to work very well. To take the code I see below and change it I would do the following: cfset oASIWeb.PathParm = "E:\InetPub\wwwroot\SolidData\Data" cfset rs = oASIWeb.SetDataPath cfset oASIWeb.DBParm = "sdweb" cfset rs = oASIWeb.SetDatabase cfset oASIWeb.IDParm = "USERS" cfset RetVal = oASIWeb.NewID Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] -- Date: Sun, 3 Sep 2000 19:57:22 -0700 From: "Tom Kim" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Using COM with CF Message-ID: [EMAIL PROTECTED] 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=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: CFOBJECT and com components
Jason, I would try 2 things. First I have not had great success using () when calling methods. You should be able to call it without the parenthesis. Secondly, you need to set a variable to the return value of your object. Your CFOBJECT statement is fine but it only creates an object with the name recordset. When you call your GetOrders method you need to capture the actual recordset returned. This would make your method call the following: cfset resultset = recordset.getorders Now when you loop your collection reference resultset instead, it actually contains your recordset. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] -- Date: Tue, 5 Sep 2000 16:42:06 +0100 From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: CFOBJECT and com components Message-ID: [EMAIL PROTECTED] 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??? -- 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: Help with WDDX
I need to query a table, take the results and change a few of the variable names, It is best to change var names in the SQL so, if you want to change column col_1 - MyVarName1 cfquery name="q" SELECT col_1 as MyVarName1, col_2 as MyVarName2 FROM myTable /cfquery serialize it using wddx, and then send that packet in an email. cfwddx action="WDDX2CFML" input="#q#" output="MyWddx" cfmail #MyWddx# /cfmail HTH ~Justin MacCarthy -- 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.
Verity: Allaire's Disowned Step Child?
Is there anyone here with experience setting Verity up? Someone willing to answer a couple questions? 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.
Server Error Codes
What error code does CF Server return if it cannot find a page? It isn't 404 which means .cfm pages are not having a 404 page displayed. Adam ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- 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: Access 2000 to SQL Server 7.0
Say you define table relationships with cascacading updates or cascading deletes in Access 2000. With the upsizing wizard do the cascading updates and cascading deletes also get transferred to SQL Server 7.0 or do you have to create triggers? Sebastian SQL Server doesn't have the concept of cascading updates deletes built in the way Access does. But as you say, you can achieve the same effect with triggers. The Upsizing Wizard does supposedly create the required triggers automatically if you choose to Upsize Table Relationships with Triggers rather than DRI (Declarative Referential Integrity). DRI doesn't do cascading updates deletes. I haven't tried it myself though! (Never trusted them in Access in the first place...) 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: Server Error Codes
ColdFusion returns a 200 (it really should return a 404). Regards, Howie - Original Message - From: "Reynolds, Adam" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 9:45 AM Subject: Server Error Codes What error code does CF Server return if it cannot find a page? It isn't 404 which means .cfm pages are not having a 404 page displayed. Adam -- 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.
URGENT! - Help With OLEDB
Hi, With some playing around, I have found that OLEDB seems to be much more stable that ODBC. For awhile, we were recieving random disappearances of ODBC datasources, which required a reboot. Anyway, the problem I'm having is that the results from OLEDB aren't consistant with those in ODBC. Example: I have one query that returns a series of results, and the query is dynamically generated. This works *perfectly* under ODBC. Under OLEDB, it returns zero records. I've tried even moving the query to a stored procedure and generating it dynamically from there. No good. Regardless of what I've tried, simply changing from ODBC to an OLEDB datasource effects the results returned. Any ideas, thoughts, help?!? Thanks, Geoff B -- 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 error question...
I understand how to use CFTRY/CFCATCH and CFERROR. The messages that I am trying to replace are the CF server errors messages like: "Request canceled or igorned by server", etc.. Those types of messages are not affected by try/catch or cferror. As these are provided by the API plug-in portion of CF, you won't be able to change these, to the best of my knowledge. You might actually be able to change it if you're running Apache on Solaris or Linux, since I think Allaire provides the source code for the plugin so that it can be compiled statically within Apache itself. On IIS, you might be able to trap this by writing an ISAPI extension to examine the content after CF runs, but frankly I don't know enough about ISAPI to say for sure. 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: Access 2000 to SQL Server 7.0
OK. cascading deletes = bad :-) But what about cascading updates when you do the upsizing from Access 2000 to SQL Server 7.0? Does that relationship get automatically maintained also? Sebastian on 9/6/00 9:01 AM, Andy Ewings at [EMAIL PROTECTED] wrote: Damn right NickCascading deltes can be a very dangerous thing! -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 14:50 To: '[EMAIL PROTECTED]' Subject: RE: Access 2000 to SQL Server 7.0 Say you define table relationships with cascacading updates or cascading deletes in Access 2000. With the upsizing wizard do the cascading updates and cascading deletes also get transferred to SQL Server 7.0 or do you have to create triggers? Sebastian SQL Server doesn't have the concept of cascading updates deletes built in the way Access does. But as you say, you can achieve the same effect with triggers. The Upsizing Wizard does supposedly create the required triggers automatically if you choose to Upsize Table Relationships with Triggers rather than DRI (Declarative Referential Integrity). DRI doesn't do cascading updates deletes. I haven't tried it myself though! (Never trusted them in Access in the first place...) 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. -- 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: Access 2000 to SQL Server 7.0
I've never tried thisbut from what Nick is saying it looks as though if you choose to Upsize Table Relationships with Triggers rather than DRI it will automatically create the required triggers for you. Try it and let us know what happens!!! -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 15:14 To: [EMAIL PROTECTED] Subject: Re: Access 2000 to SQL Server 7.0 OK. cascading deletes = bad :-) But what about cascading updates when you do the upsizing from Access 2000 to SQL Server 7.0? Does that relationship get automatically maintained also? Sebastian on 9/6/00 9:01 AM, Andy Ewings at [EMAIL PROTECTED] wrote: Damn right NickCascading deltes can be a very dangerous thing! -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 14:50 To: '[EMAIL PROTECTED]' Subject: RE: Access 2000 to SQL Server 7.0 Say you define table relationships with cascacading updates or cascading deletes in Access 2000. With the upsizing wizard do the cascading updates and cascading deletes also get transferred to SQL Server 7.0 or do you have to create triggers? Sebastian SQL Server doesn't have the concept of cascading updates deletes built in the way Access does. But as you say, you can achieve the same effect with triggers. The Upsizing Wizard does supposedly create the required triggers automatically if you choose to Upsize Table Relationships with Triggers rather than DRI (Declarative Referential Integrity). DRI doesn't do cascading updates deletes. I haven't tried it myself though! (Never trusted them in Access in the first place...) 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. -- 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: Help with WDDX
I need to query a table, take the results and change a few of the variable names, It is best to change var names in the SQL so, if you want to change column col_1 - MyVarName1 cfquery name="q" SELECT col_1 as MyVarName1, col_2 as MyVarName2 FROM myTable /cfquery serialize it using wddx, and then send that packet in an email. cfwddx action="WDDX2CFML" input="#q#" output="MyWddx" cfmail #MyWddx# /cfmail Thanks more then you can imagine... Marcus -- 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: CF4.5.1, Win2K and CFMAIL
Installed CF 4.5.0 on a server almost 2 weeks ago and had problems with CFMAIL from day 1. Found out about the SMTP.dll patch through CF-TALK - anyone know where to get it? I've tried the Allaire site but can't find it - even the search engine on there doesn't know what it is! Help, anyone? Thanks. Sponsors of the 1st Northern Information Security Conference http://www.nisc.org.uk Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From: David E. Crawford [SMTP:[EMAIL PROTECTED]] Sent: 06 September 2000 14:06 To: CF-Talk Subject: CF4.5.1, Win2K and CFMAIL Just installed CF4.5.1 Pro on Win2K. CFMAIL no longer functions, even with the SMTP.dll patch from Allaire. The CF service is running as a user account in the administrators group, with "full control" of the \cfusion\mail directory structure. Temp files of 0 bytes are being written to the \cfusion\mail\spool directory and any template that calls CFMAIL fails with this error: TagCFMail::sendMessage I have tried all the steps in KB 15821 with no success. Has anyone else encountered this problem, and come up with a solution/workaround? 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. --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net -- 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: site i'm working on
this is baffeling me... can anyone help me out and tell my why my web site sometimes looses an image. This is what i mean: http://www.lightrodsoft.com/new/index.cfm if you hit refresh a few times you'll start to notice that maybe a button, or background will dissapear, you can go to it, right click and say show picture, and it will show... if you hit refresh again another thing dissapears... or sometimes nothing disapears. I have this error on IE 5, on NN 3.0 I don't get that problem, but the backgrounds don't show up (i can fix that though) any help (or other noticed bugs) would be appreciated Thanks! Gavin -- 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 Server and MS Exchange 2000
I realise why that Exchange 2000 is not oficially released yet but my boss is thinking about running the Intranet on the same server as Exchange. Probably looking to work with CF 4.51. Can anybody see any immediate problems with that? If you can afford a separate server, I'd strongly recommend that instead. Exchange is designed to be the primary service on a machine, as is CF. They'll fight for resources, and if one crashes, it'll take out the other (and if the other is Exchange, and your Information Store gets corrupted, you'll be extremely unhappy). Web/application servers, like it or not, crash a lot more than other services. This is true for all the web application servers I've worked with, not just CF. 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...
Hello Matthew, to stop Apache properly open another DOS console... This is from the manual: http://www.apache.org/docs/windows.html -- snip Controlling Apache in a Console Window You can tell a running Apache to stop by opening another console window and running: apache -k shutdown Note: This option is only available with Apache 1.3.3 and later. - end quote - I do it in two batch files with shortcuts on the desktop. Works like a charm, except that open dos window, but you get used to it. Birgit Tuesday, September 05, 2000, 12:23:28 PM, you wrote: 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".) -- 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 help making an event calendar of sorts
Try eWebCalendar from Ektron. I don't know if they are still actively marketing the package, but it works quite well so far, you can purchase a source code license and support has been excellent. R. Colman UC Irvine -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 6:59 AM To: [EMAIL PROTECTED] Subject: Need help making an event calendar of sorts I need to display a monthly calendar that will show the travel packages that will be featured each week. The packages will run for one week and there can not be more than 3 features a week. If there are less than 3, I need to have links to click to be able to fill the empty slots. How can this be done? I don't have any idea on how to make a calendar but any help on that part alone would be a BIG help. Art _ 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.
newbie:Structure problem
cfset stcTempSS1 = StructNew() cfset stcSS1 = StructNew() cfset stcActiveListSS1 = StructNew() CFQUERY NAME="Select" DATASOURCE="ProdCenter" USERNAME="sa" PASSWORD="" SELECT * FROM Service_Scope /CFQUERY cfloop query="select" cfset stcTempSS1["Service_Scope_ID"] = "#Service_Scope_ID#" /cfloop cfloop index="key" list="#StructKeyList(stcTempSS1)#" cfoutput#stcTempSS1["#key#"]#/cfoutput /cfloop *** I want to dynamically create a structure, but this only writes the last CurrentRow value into my structure. How do I fill a structure up with many custom key names and values? Thank you. /mdeane -- 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
talentsoft Web+Shop is pretty good and is open source. It uses Web+ instead of coldfusion, but they are similar enough that if you know cf, web+ is easy to learn and is multi-platform. Regards. :GeckoX 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 -- 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: newbie:Structure problem
you need to assign the struct key name to the id, and the value you wish to assign to it as its value. the way you have it now, you're assigning each id to the key "Service_Scope_ID", which just overwrites the valuse iteratively. your code snippet is a bit cryptic, but this is what i THINK you're trying to do replace cfloop query="select" cfset stcTempSS1["Service_Scope_ID"] = "#Service_Scope_ID#" /cfloop with cfloop query="select" cfset stcTempSS1["#Service_Scope_ID#"] = "#whatever the field name is that's associated with ID#" /cfloop Chris Olive, DOEHRS Website Administrator -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 11:06 AM To: '[EMAIL PROTECTED]' Subject: newbie:Structure problem cfset stcTempSS1 = StructNew() cfset stcSS1 = StructNew() cfset stcActiveListSS1 = StructNew() CFQUERY NAME="Select" DATASOURCE="ProdCenter" USERNAME="sa" PASSWORD="" SELECT * FROM Service_Scope /CFQUERY cfloop query="select" cfset stcTempSS1["Service_Scope_ID"] = "#Service_Scope_ID#" /cfloop cfloop index="key" list="#StructKeyList(stcTempSS1)#" cfoutput#stcTempSS1["#key#"]#/cfoutput /cfloop *** I want to dynamically create a structure, but this only writes the last CurrentRow value into my structure. How do I fill a structure up with many custom key names and values? Thank you. /mdeane -- 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.
Baffled by Exception Code Runtime error
Hi all, I've just got back from a baffling client visit. The problem they were having was the Exception runtime error as commonly seen when the server requires the latest MDAC installed. The client decided to carry out a complete server reinstall (inlcuding reformat and reinstall NT4.0) for reasons unknown. The site (intranet) was working 100% perfectly before carrying out the reinstall. It was running on NT4.0, SP6a, IIS4.0, CF4.5Ent, MDAC 2.5 using Access datasources. Also residing on the same machine was Lotus Domino and SQL 7.0 and several other services, which I think may have had something to do with their decision to reformat etc. They reinstalled everything to exactly same configuration as above and are now receiving the Exception Runtime error. I've checked through the following: Latest MDAC installed - yes Query in question runs fine in Access - yes Templates in question run fine on another server - yes Is Service Pack 6a causing problem? - Can't be as this was present in previous install Are correct url variables being passed to the template - yes Can anyone else suggest any other things i should have looked into as I'm totally stumped by this one. The client needs this running asap as the query "aparently" causing the error drives the entire intranet's navigation menu system. I didn't build this site so intimate knowledge of the code base is not available either, however, the query in question is shown below: SELECT (main_area.main_area_name + ' \ ' + sub_area.sub_area_name) as Location FROM main_area INNER JOIN sub_area ON main_area.main_area_id = sub_area.main_area_id WHERE (((sub_area.sub_area_id)=#url.id#)) Any help appreciated, Dave 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] -- 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.
Uploading and Emailing a File
Travel Insurance Company wishes their clients to be able to upload small text files to then be emailed to the Company when processing claims. File is list of names, beneficiaries, birth datesblah, blah So, following action is working great. File is saved to server properly from the client input form: CFFILE ACTION="UPLOAD" DESTINATION="e:\inetpub\hostroot\myclient.com\MailFiles\" NAMECONFLICT="Overwrite" FILEFIELD="ClientFile" Same processing page needs to send email to the Insurance Company, which is working properly as well. However, I can't seem to get the syntax correct for it to include the above file as an attachment to the email CFMAILPARAM FILE="e:\inetpub\hostroot\myclient.com\MailFiles\#ClientFile#" I'm probably and idiot! Advise please?? Thanks Les Mizzell *** Who needs Intel? Athlon Inside!!! -- 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: Uploading and Emailing a File
This is a multi-part message in MIME format. --=_NextPart_000_00E6_01C01817.6D46BA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Uploading and Emailing a FileYou need to get the file name from the FILE object. Use File.ServerFile in the MAILPARAM. DC -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 15:19 To: [EMAIL PROTECTED] Subject: Uploading and Emailing a File Travel Insurance Company wishes their clients to be able to upload small text files to then be emailed to the Company when processing claims. File is list of names, beneficiaries, birth datesblah, blah So, following action is working great. File is saved to server properly from the client input form: CFFILE ACTION="UPLOAD" DESTINATION="e:\inetpub\hostroot\myclient.com\MailFiles\" NAMECONFLICT="Overwrite" FILEFIELD="ClientFile" Same processing page needs to send email to the Insurance Company, which is working properly as well. However, I can't seem to get the syntax correct for it to include the above file as an attachment to the email CFMAILPARAM FILE="e:\inetpub\hostroot\myclient.com\MailFiles\#ClientFile#" I'm probably and idiot! Advise please?? Thanks Les Mizzell *** Who needs Intel? Athlon Inside!!! -- 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_00E6_01C01817.6D46BA00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEUploading and Emailing a File/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=3D251023015-06092000You=20 need to get the file name from the FILE object.nbsp; Use = File.ServerFile in the=20 MAILPARAM./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/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 Les Mizzell=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, September = 06, 2000=20 15:19BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B = Uploading and=20 Emailing a FileBRBR/DIV/FONTBR PFONT size=3D2Travel Insurance Company wishes their clients to be = able to=20 upload small/FONT BRFONT size=3D2text files to then be emailed = to the=20 Company when processing claims.nbsp; File/FONT BRFONT = size=3D2is list of=20 names, beneficiaries, birth datesblah, blah/FONT /P PFONT size=3D2So, following action is working great.nbsp; File is = saved to=20 server properly/FONT BRFONT size=3D2from the client input = form:/FONT=20 /P PFONT size=3D2lt;CFFILE ACTION=3D"UPLOAD"/FONT=20 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT=20 = size=3D2DESTINATION=3D"e:\inetpub\hostroot\myclient.com\MailFiles\"/FON= T=20 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT=20 size=3D2NAMECONFLICT=3D"Overwrite"/FONT=20 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT=20 size=3D2FILEFIELD=3D"ClientFile"gt;/FONT /PBR PFONT size=3D2Same processing page needs to send email to the = Insurance=20 Company, which is/FONT BRFONT size=3D2working properly as = well.nbsp;=20 However, I can't seem to get the syntax correct/FONT BRFONT = size=3D2for it=20 to include the above file as an attachment to the email/FONT = /P PFONT size=3D2lt;CFMAILPARAM=20 = FILE=3D"e:\inetpub\hostroot\myclient.com\MailFiles\#ClientFile#"gt;/FON= T /P PFONT size=3D2I'm probably and idiot!nbsp; Advise please??/FONT = /P PFONT size=3D2Thanks/FONT /P PFONT size=3D2Les Mizzell/FONT BRFONT = size=3D2***/FONT=20 BRFONT size=3D2Who needs Intel?/FONT BRFONT size=3D2Athlon=20 Inside!!!/FONT /P PFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 = target=3D_blankhttp://www.mail-archive.com/cf-talk@houseoffusion.com//A= /FONT=20 BRFONT size=3D2To Unsubscribe visit A=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"=20 = target=3D_blankhttp://www.houseoffusion.com/index.cfm?sidebar=3Dlistsam=
Re: Shopping Cart
And is most probably a total ripoff of the original CF code. In the beginning, web+ used .cfm as an extension, used CFX tags and more. Even to this day the code is almost the same as CF, but with a web prefix. There's a whole lot more to the story here than I can actually tell, but the good point is that if you know CF, you can use web+. Additionally, you can take any of the web+ code and 'port' it to CF with few problems. (related to that, any CF 3 or earlier code should have not problem. CF 4 or higher code will have conversion issues. Additionally, they wrote some of the comparison logic differently. They still misuse pound signs though.) Michael Dinowitz Publisher - The Fusion Authority (www.fusionauthority.com/alert) ListManager - CF-Talk, CF-Jobs, Spectra-Talk, JRun-Talk, etc. (www.houseoffusion.com) talentsoft Web+Shop is pretty good and is open source. It uses Web+ instead of coldfusion, but they are similar enough that if you know cf, web+ is easy to learn and is multi-platform. Regards. :GeckoX 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 -- 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.
CFQUERY Question
This is a multi-part message in MIME format. --=_NextPart_000_0177_01C017F7.6A6D41C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a list that contains the ID of several items in a database. I = want to run one query that will select them all from the database. =20 The number of items in the list is dynamic so I never know exactly how = many I am pulling??? CFQUERY DATASOURCE=3D"#dns#" SELECT *=20 FROM Homes WHERE ID =3D #listitem1# AND #listitem2# ETC. /CFQUERY Any thoughts?? Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_0177_01C017F7.6A6D41C0 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 have a list that contains the ID of = several items=20 in a database.nbsp; I want to run one query that will select them = allnbsp;from=20 the database.nbsp; /FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2The number of items in the list is = dynamic so I=20 never know exactly how many I am pulling???/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2lt;CFQUERY = DATASOURCE=3D"#dns#"gt;/FONT/DIV DIVFONT face=3DArial size=3D2SELECT * /FONT/DIV DIVFONT face=3DArial size=3D2FROM Homes/FONT/DIV DIVFONT face=3DArial size=3D2WHERE ID =3D #listitem1# AND = #listitem2#=20 ETC./FONT/DIV DIVFONT face=3DArial size=3D2lt;/CFQUERYgt;/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Any thoughts??/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/DIV/FONT/BODY/HTML --=_NextPart_000_0177_01C017F7.6A6D41C0-- -- 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.
Sort Search/Query
I'm struggling with the sorting of my Verity search results . . . which I have massaged a little in order to pull other info from a database. I am able to successfully: perform the search, set up an array which matches the SCORE from the search with the NUMBER field from my db, run a query pulling all fields from the db for records matching search results, display results of query - including the score array, sort the query results based on user input from the form. What I'm not able to do right now is sort the query based on the score array. Any suggestions? Please respond to the group and to my email at [EMAIL PROTECTED] Thank you for any advice you may have . . . BJS !--- perform search based on criteria passed from form --- CFSEARCH Collection="cwt" name="search1" criteria = "#criteria#" type = "explicit" !--- Set array to match the score from the search results with the number field from the db (custom2) --- cfset scr=arraynew(1) cfloop query="search1" cfset scr[custom2]="#score#" /cfloop !--- no files found for specified criteria? --- CFIF search1.RecordCount is 0 BNo files found for specified criteria/B !--- ... else at least one file found --- CFELSE cfoutput P Records found: #search1.recordcount# Records Searched: #search1.recordssearched# /cfoutput !--- table header --- table cellspacing=2 cellpadding=2 tr bgcolor="cc" td align="Left" valign="bottom"bScore/b/td td align="left" valign="bottom"bFilename/b/td td align="left" valign="bottom"bDescription/b/td td align="left" valign="bottom"bAuthor/b/td td align="left" valign="bottom"bDate Uploaded/b/td td align="left" valign="bottom"bDept/b/td /tr !--- run query to pull in all fields from db relating to records that matched search results --- CFQuery name="results" datasource="files" SELECT * FROM Files WHERE number IN (#ValueList(Search1.custom2)#) /cfquery CFOUTPUT Query="RESULTS" !--- use Nate's QuerySort to sort query based on user input from form --- CF_QuerySort QUERY="results" SORTCOLUMN="#form.SORTBY#" SORTORDER="asc" SORTTYPE="textnocase" SORTEDQUERY="results" tr bgcolor="#IIf(CurrentRow Mod 2, DE('ff'), DE('cf'))#" td align="center" valign="top"#scr[number]# /td td valign="top" width="10"a HREF=files/#department#/#GetFileFromPath(file_name)##GetFileFromPath(file_n ame)# /A/td td valign="top"#Summary# /td td valign="top"#name#/td td valign="top"#dateformat(date,"mm/dd/yy")#/td td valign="top"#department#/td /tr/cfoutput/table /cfif Barbara J Smith Consulting http://www.bjsconsulting.com [EMAIL PROTECTED] 651.365.0822 -- 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: Baffled by Exception Code Runtime error
wouldn't have thought so Nick. What is your DBMS? Try changing it and see what happens. What is the error message you are getting? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:00 To: '[EMAIL PROTECTED]' Subject: RE: Baffled by Exception Code Runtime error SELECT (main_area.main_area_name + ' \ ' + sub_area.sub_area_name) as Location Is something in there suddenly having a problem with the word "Location"??? ** 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.
count() or recordcount
Which is faster? I'm presuming count() or what else would it be good for? -- 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: MS Access CFUPDATE question
Anyone have an idea why the following error occurs when I use two tables in MS Access that have one-to-many relationship with referencial integrity applied. I am trying to update a record in Categories table which has one column called GroupID. The GroupID comes from Table called Group. I have established one-to-many relationship between Group -to- Categories. I have turned off the lookup column (combo box) option and changed it to text box. I still get this error. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Group'. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:2) to (6:124). Any suggestions are very welcome Thanks, Nehal -- 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.
Strange Warning in Application.Log
Hi Folks, I am getting a strange error in my Application.Log file that I am wondering if anyone could decode. The error itself is cryptic to me, but weirder still is that the problem is with a shopping cart that I am fairly certain isn't being used by anyone at all...so why is this tag being looked at: "Warning","TID=238","09/06/00","10:58:08","In a CF_TagName construct custom tag file 'C:\CFUSION\CustomTags\Ship\intershipper.cfm' will occlude custom tag file 'C:\inetpub\wwwroot\shopping_cart\constructors\intershipper.cfm'." Thanks, Eron -- 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: count() or recordcount
If you do a select * and then do a record count you have to perform 2 operations. Select count(*) is only one so I think you are right - count(*) will be faster but it'll be negligible unless you have a huge amount of records -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:12 To: [EMAIL PROTECTED] Subject: count() or recordcount Which is faster? I'm presuming count() or what else would it be good for? -- 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: count() or recordcount
Two totally different beasts. If you want to pull data back from the database and then determine how many rows were returned, use query.recordcount rather than going back to the database for a row count. If you only want to find out how many rows but don't need the data, then count() is your best bet rather than pulling the data across the wire and using CF's recordcount. SQL vs. CF . . . two separate beasts, or was that two separate mutants? Or was that thread on fusebox? I'm confused now! ;) Dan -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:12 AM To: [EMAIL PROTECTED] Subject: count() or recordcount Which is faster? I'm presuming count() or what else would it be good for? -- 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: MS Access CFUPDATE question
Not quite sure exactly how you are updating the record but what that error message implies is that you are updating a record in the Categories table whih changes the Group ID so that no other record in that table has that group ID. Therefore there is a record in Group which has no corresponding record in Categories -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:20 To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question Anyone have an idea why the following error occurs when I use two tables in MS Access that have one-to-many relationship with referencial integrity applied. I am trying to update a record in Categories table which has one column called GroupID. The GroupID comes from Table called Group. I have established one-to-many relationship between Group -to- Categories. I have turned off the lookup column (combo box) option and changed it to text box. I still get this error. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Group'. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:2) to (6:124). Any suggestions are very welcome Thanks, Nehal -- 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: Strange Warning in Application.Log
its basically saying its going to use the template file (intershipper.cfm) you have in C:\CFUSION\CustomTags\Ship INSTEAD of the one you have in C:\inetpub\wwwroot\shopping_cart\constructors\ You obviously have intershipper.cfm located in BOTH places. Stay current with what's happening on AirportNet. Subscribe to our Announcement list today: http://www.airportnet.org/email.htm --- Kelly Matthews Internet Development Coordinator AAAE 703.578.2509 [EMAIL PROTECTED] http://www.airportnet.org --- -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:11 PM To: Cf-Talk Subject: Strange Warning in Application.Log Hi Folks, I am getting a strange error in my Application.Log file that I am wondering if anyone could decode. The error itself is cryptic to me, but weirder still is that the problem is with a shopping cart that I am fairly certain isn't being used by anyone at all...so why is this tag being looked at: "Warning","TID=238","09/06/00","10:58:08","In a CF_TagName construct custom tag file 'C:\CFUSION\CustomTags\Ship\intershipper.cfm' will occlude custom tag file 'C:\inetpub\wwwroot\shopping_cart\constructors\intershipper.cfm'." Thanks, Eron -- 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: count() or recordcount
Just ran a test using my CGLOBAL table that holds client variables in an ODBC database. Over 1000 loops of a query grabbing cfid and using recordcount, it took 20031 ms of time. To get the recordcount using the count(*) method, over 1000 loops of the same table, it only took 3406 ms. So, if you are only interested in the amount of rows, count(*) from SQL is much better, but in most cases, you want data and a recordcount, there I would use CF's RecordCount variable. Justin Kidman -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:12 AM To: [EMAIL PROTECTED] Subject: count() or recordcount Which is faster? I'm presuming count() or what else would it be good for? -- 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: count() or recordcount
In a direct comparison, I would think count() would be since it's run on the SQL server. Todd Ashworth - Original Message - From: "Bud" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 12:11 PM Subject: count() or recordcount | Which is faster? I'm presuming count() or what else would it be good for? | -- | | 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: Verity: Allaire's Disowned Step Child?
Hi Lon, You wrote: Is there anyone here with experience setting Verity up? Someone willing to answer a couple questions? I wrote: We have used Verity extensively here at WOW! What help do you need? Also I like the term "CyberEntomologist", interesting... Regards, Anthony Geoghegan Lead Developer Ireland Film and Television Net 26 South Frederick Street Dublin 2 Ireland Tel: +353 1 671 3664 Fax: +353 1 671 0763 Web: http://www.wow.ie mailto:[EMAIL PROTECTED] NOTICE: This communication is confidential. The copyright in this communication belongs to Ireland Film Television Net (IFTN) or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of IFTN. Any views expressed in this communication are those of the individual sender except where the sender specifically states those are of view of IFTN. Except as required by law IFTN does not represent, warrant, and/guarantee that the integrity of this communication has been maintained or that the communication is free of virus, interception or interference. -- 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: count() or recordcount
Even on small tables the difference is pretty big percentage wise . . . a quick test (10 iterations) on a table with 140 rows shows an average of 50 ms doing select * and recordcount, 11 ms using select count(*). If you have a lot of traffic on that page 40 ms could mean a lot. Dan -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:17 AM To: '[EMAIL PROTECTED]' Subject: RE: count() or recordcount If you do a select * and then do a record count you have to perform 2 operations. Select count(*) is only one so I think you are right - count(*) will be faster but it'll be negligible unless you have a huge amount of records -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:12 To: [EMAIL PROTECTED] Subject: count() or recordcount Which is faster? I'm presuming count() or what else would it be good for? -- 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: MS Access CFUPDATE question
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_01C01820.3D0E0070 Content-Type: text/plain; charset="iso-8859-1" You have a relationship with that table, that requires you to have a record in it that is related with the table your updating. Shawn Regan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:20 AM To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question Anyone have an idea why the following error occurs when I use two tables in MS Access that have one-to-many relationship with referencial integrity applied. I am trying to update a record in Categories table which has one column called GroupID. The GroupID comes from Table called Group. I have established one-to-many relationship between Group -to- Categories. I have turned off the lookup column (combo box) option and changed it to text box. I still get this error. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Group'. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:2) to (6:124). Any suggestions are very welcome Thanks, Nehal -- 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. --_=_NextPart_001_01C01820.3D0E0070 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" TITLERE: MS Access CFUPDATE question/TITLE /HEAD BODY PFONT SIZE=3D2You have a relationship with that table, that = requires you to have a record in it that is related with the table your = updating./FONT/P PFONT SIZE=3D2Shawn Regan/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: [EMAIL PROTECTED] [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:fleming@forteinterac= tive.com/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, September 06, 2000 9:20 AM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: RE: MS Access CFUPDATE question/FONT /P BR PFONT SIZE=3D2Anyone have an idea why the following error occurs = when I use two tables in/FONT BRFONT SIZE=3D2MS Access that have one-to-many relationship with = referencial integrity/FONT BRFONT SIZE=3D2applied. I am trying to update a record in = Categories table which has one/FONT BRFONT SIZE=3D2column called GroupID.nbsp; The GroupID comes from = Table called Group. I have/FONT BRFONT SIZE=3D2established one-to-many relationship between Group = -to- Categories. I have/FONT BRFONT SIZE=3D2turned off the lookup column (combo box) option and = changed it to text box./FONT BRFONT SIZE=3D2I still get this error./FONT /P BR BR PFONT SIZE=3D2Error Diagnostic Information/FONT BRFONT SIZE=3D2ODBC Error Code =3D 23000 (Integrity constraint = violation)/FONT /P BR PFONT SIZE=3D2[Microsoft][ODBC Microsoft Access Driver] You cannot = add or change a record/FONT BRFONT SIZE=3D2because a related record is required in table = 'Group'./FONT /P BR BR PFONT SIZE=3D2The error occurred while processing an element with a = general identifier of/FONT BRFONT SIZE=3D2(CFUPDATE), occupying document position (6:2) to = (6:124)./FONT /P PFONT SIZE=3D2Any suggestions are very welcome/FONT /P PFONT SIZE=3D2Thanks,/FONT /P PFONT SIZE=3D2Nehal/FONT /P BR PFONT = SIZE=3D2---= -/FONT BRFONT SIZE=3D2--/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2To Unsubscribe visit/FONT BRFONT SIZE=3D2A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli=
RE: count() or recordcount
I tested this using CF 4.01 using a 9000+ record Access database. Using Query.RecordCount was actually about 10-20% faster. Kevin [EMAIL PROTECTED] 09/06/00 09:16AM If you do a select * and then do a record count you have to perform 2 operations. Select count(*) is only one so I think you are right - count(*) will be faster but it'll be negligible unless you have a huge amount of records -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:12 To: [EMAIL PROTECTED] Subject: count() or recordcount Which is faster? I'm presuming count() or what else would it be good for? -- 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: Baffled by Exception Code Runtime error
I've just got back from a baffling client visit. The problem they were having was the Exception runtime error as commonly seen when the server requires the latest MDAC installed. The client decided to carry out a complete server reinstall (inlcuding reformat and reinstall NT4.0) for reasons unknown. Did they reinstall everything in the proper order? I'd reinstall MDAC 2.5 again anyway. 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.
MULTIPLE COLUMN output problem!
Hi all, I am experiencing a certain problem, and will try to explain it as well as I can. I have a list of links that I am trying to output in a 2 column format, very similar to Yahoo! main menu design. As you know there are main Categories listed with sub categories right underneath them. kind of like: NewsComputers - World, US..-Software, WWW... BusinessReference - B2B, Companies..- Encyclopedias, Lists.. Now, I have in my database 2 tables - categories, and sub-categories, which are linked together thru a category id. The idea is to ouput the categories with their subcategories with them in a 2 column format. I can output 2 columns correctly if I only ouput the categories. or if I just output the subcategory. However it gets all very hairy if join the tables and output using the GROUP parameter of CFOUTPUT. The problem arises when there are a dissimilar number of subcategories for each category. In my code it looks for cfif currentrow MOD columncount eq 0 to determine if the current row's MOD 2 is 0 to know if 2 columns have already been output, but when there are different no. of subcategories, this logic statement gets evaluated at the wrong point than the one I want it to. Right now it is printing 3 columns for one row and only one column for another, while the rest of the rows are alright with 2 columns. What I mean is that if a certain category has 1 sub-cat. and the other has 2 sub-cats, the output counts them as 3 rows total and instead of starting a new row after the category and its sub-cats have been output, it tries to start a new one as soon as 2 columns have been evaluated. So even though the 3rd row is still part of the main category, for the logic statement, it's a NEW row. Sample output: [ numbers are rowcount ] 1-Administration2-Daily Reports 1- Areas | 2- Divisions | 3-Data Entry 4-Help 3- Products | 4- About | 5-MDS6-MSDS 5- Areas | 6- Facilities | 7-Process Control9-Production10-Reports ***problem 7- Business | 8- Divisional | 9- Reports | 10-Data | *** 3 columns 11-SSOP 12-Safety 11- Tasks | 12- Data | 13-Sales* problem 13- Facilities | just 1 column*** To stop confusing you further, I am including the code snippet to accomplish this: !--- the query to gather the info --- cfquery name="mainpage" SELECT mnu_categories.category_id, mnu_categories.category_name, mnu_categories.category_url, mnu_sub_categories.sub_cat_id, mnu_sub_categories.sub_cat_name FROM mnu_categories, mnu_sub_categories WHERE mnu_categories.category_id = mnu_sub_categories.category_id ORDER BY mnu_categories.category_name, mnu_sub_categories.sub_cat_name /cfquery !--- end query--- !--- set vars --- cfset columncount = 2 cfset MaxRows = mainpage.recordcount !---/ set vars --- !--- output--- table tr cfoutput query="mainpage" startrow="1" maxrows=#MaxRows# group="category_id" td a href="index-orig.cfm?action=cat.cfmc=#category_id#" #currentrow#-b#category_name#/b/a !--- current row output for debugging--- br cfoutput font face="Arial" size="-2"#currentrow#- a href="index-orig.cfm?action=subcat.cfmc=#category_id#s=#sub_cat_id#" #sub_cat_name#/a | /font /cfoutput /td cfif currentrow MOD columncount EQ 0 /tr cfif currentrow NEQ MaxRows tr bgcolor="FF" /cfif cfelseif currentrow EQ MaxRows cfloop FROM="#Evaluate(columncount-(currentrow MOD columncount))#" TO="1" STEP="-1" INDEX="i" td/td /cfloop /tr /cfif /cfoutput /table I would really appreciate if anyone can help me with this. The code should be able to take on any no. of subcategories and out put them nicely without breaking. Hassan Khawaja --- -- 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 Server Database Size
Is it possible to query SQL Server to find out the size of a database? I'd like to be able to track its growth from a CF application without having to go to the Enterprise Manager to find out. Regards, Karl Simanonok -- 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: count() or recordcount
Ok, Justin MacCarthy pointed out something for me to try. He suggested using count(cfid) instead of count(*) which would yield the same results. This table has like 944 records btw, here are the results of time in ms taken to run 1000 queries of each over 5 tries: Using count(cfid): 3313 Using count(*): 3422 Using count(cfid): 3297 Using count(*): 3140 Using count(cfid): 3281 Using count(*): 3141 Using count(cfid): 3281 Using count(*): 3187 Using count(cfid): 3281 Using count(*): 3141 Hmm, the first try came out how I expected, but the other four leaned towards count(*). But really, 100 ms difference over 1000 runs is truly insignificant, that is 0.1ms per query on the difference. So, count(*) and count(column) is handled the same at least in SQL Server. If anyone has an Oracle or other DB server running, I can pass the code along for running this test over again. Justin Kidman -Original Message- From: Justin Kidman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:24 AM To: '[EMAIL PROTECTED]' Subject: RE: count() or recordcount Just ran a test using my CGLOBAL table that holds client variables in an ODBC database. Over 1000 loops of a query grabbing cfid and using recordcount, it took 20031 ms of time. To get the recordcount using the count(*) method, over 1000 loops of the same table, it only took 3406 ms. So, if you are only interested in the amount of rows, count(*) from SQL is much better, but in most cases, you want data and a recordcount, there I would use CF's RecordCount variable. Justin Kidman -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:12 AM To: [EMAIL PROTECTED] Subject: count() or recordcount Which is faster? I'm presuming count() or what else would it be good for? -- 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: SQL Server Database Size
yepjust run the system stored procedure sp_databases. This will tell the name and size of all the databases that reside on the SQL server or are accessible through a database gateway. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:39 To: [EMAIL PROTECTED] Subject: SQL Server Database Size Is it possible to query SQL Server to find out the size of a database? I'd like to be able to track its growth from a CF application without having to go to the Enterprise Manager to find out. Regards, Karl Simanonok -- 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: MS Access CFUPDATE question
What are you updating in the Categories table? are you altering the GroupID field of a record(s). If so after the update are there still at least one record in the categories table for each of the three entries in Group? The error message suggests that there isn't. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:54 To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question The Group table has only 3 entities. Each one is represented in the categories table once atleast. I am not creating a new GroupID. I simply need to insert that. I think one can't use CFUPDATE with tables that have referencial integrity relationships with other tables...am I right? Nehal -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:19 PM To: '[EMAIL PROTECTED]' Subject: RE: MS Access CFUPDATE question Not quite sure exactly how you are updating the record but what that error message implies is that you are updating a record in the Categories table whih changes the Group ID so that no other record in that table has that group ID. Therefore there is a record in Group which has no corresponding record in Categories -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 September 2000 17:20 To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question Anyone have an idea why the following error occurs when I use two tables in MS Access that have one-to-many relationship with referencial integrity applied. I am trying to update a record in Categories table which has one column called GroupID. The GroupID comes from Table called Group. I have established one-to-many relationship between Group -to- Categories. I have turned off the lookup column (combo box) option and changed it to text box. I still get this error. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Group'. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:2) to (6:124). Any suggestions are very welcome Thanks, Nehal -- 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. -- 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: SQL Server Database Size
Is it possible to query SQL Server to find out the size of a database? I'd like to be able to track its growth from a CF application without having to go to the Enterprise Manager to find out. Each database in SQL Server has a sysfiles table, and if you sum the column size, that will tell you how much space is allocated to your data and log files. To access the sysfiles, you may have to set up a new SQL Server account that has access to objects owned by system. I've never attempted to do this, so I don't know for sure if SQL Server allows these tables to be accessed by the outside world (it's something of a security hole). Dana Larose ColdFusion Monkey Canadian Web Design Consulting Inc. A: 701-281 McDermot Avenue (McDermot King) P: 204.946.5155 C: 204.228.0477 F: 204.946.5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Canadian Web Design Consulting Inc. client engagement contract. -- 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: MS Access CFUPDATE question
I am not quite clear what you are recommending. Do you mean that I can't insert data in a column Categories.GroupID of table Categories if that Column is tied to Group.GroupID in table Group by using CFUPDATE. Sorry if I come across stupid... Thanks, Nehal -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:34 PM To: '[EMAIL PROTECTED]' Subject: RE: MS Access CFUPDATE question 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_01C01820.3D0E0070 Content-Type: text/plain; charset="iso-8859-1" You have a relationship with that table, that requires you to have a record in it that is related with the table your updating. Shawn Regan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:20 AM To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question Anyone have an idea why the following error occurs when I use two tables in MS Access that have one-to-many relationship with referencial integrity applied. I am trying to update a record in Categories table which has one column called GroupID. The GroupID comes from Table called Group. I have established one-to-many relationship between Group -to- Categories. I have turned off the lookup column (combo box) option and changed it to text box. I still get this error. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Group'. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:2) to (6:124). Any suggestions are very welcome Thanks, Nehal -- 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. --_=_NextPart_001_01C01820.3D0E0070 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" TITLERE: MS Access CFUPDATE question/TITLE /HEAD BODY PFONT SIZE=3D2You have a relationship with that table, that = requires you to have a record in it that is related with the table your = updating./FONT/P PFONT SIZE=3D2Shawn Regan/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: [EMAIL PROTECTED] [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:fleming@forteinterac= tive.com/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, September 06, 2000 9:20 AM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: RE: MS Access CFUPDATE question/FONT /P BR PFONT SIZE=3D2Anyone have an idea why the following error occurs = when I use two tables in/FONT BRFONT SIZE=3D2MS Access that have one-to-many relationship with = referencial integrity/FONT BRFONT SIZE=3D2applied. I am trying to update a record in = Categories table which has one/FONT BRFONT SIZE=3D2column called GroupID.nbsp; The GroupID comes from = Table called Group. I have/FONT BRFONT SIZE=3D2established one-to-many relationship between Group = -to- Categories. I have/FONT BRFONT SIZE=3D2turned off the lookup column (combo box) option and = changed it to text box./FONT BRFONT SIZE=3D2I still get this error./FONT /P BR BR PFONT SIZE=3D2Error Diagnostic Information/FONT BRFONT SIZE=3D2ODBC Error Code =3D 23000 (Integrity constraint = violation)/FONT /P BR PFONT SIZE=3D2[Microsoft][ODBC Microsoft Access Driver] You cannot = add or change a record/FONT BRFONT SIZE=3D2because a related record is required in table = 'Group'./FONT /P BR BR PFONT SIZE=3D2The error occurred while processing an element with a = general identifier of/FONT BRFONT SIZE=3D2(CFUPDATE), occupying document position (6:2) to = (6:124)./FONT /P PFONT SIZE=3D2Any suggestions are very welcome/FONT /P PFONT SIZE=3D2Thanks,/FONT /P PFONT
Re: count() or recordcount
Furthermore, count() is just that, a tally of the rows as a query column in and of itself. The RecordCount variable is an attribute of the query object. Returning a query object assumes that you wish to do something with it, other than count how many rows are returned. If you're just wishing to count the items with x criteria, your intent is closer to count() anyway. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, September 06, 2000 12:31 PM Subject: Re: count() or recordcount In a direct comparison, I would think count() would be since it's run on the SQL server. Todd Ashworth - Original Message - From: "Bud" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 12:11 PM Subject: count() or recordcount | Which is faster? I'm presuming count() or what else would it be good for? | -- | | 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: SQL Server Database Size
How about this.. Call the stored procedure sp_dbhelp With the recordset it returns you may figure out the size with the variable db_size.. Thats it :) SQL Server only. Jeremy -Original Message- From: Dana Larose [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:58 PM To: [EMAIL PROTECTED] Subject: RE: SQL Server Database Size Is it possible to query SQL Server to find out the size of a database? I'd like to be able to track its growth from a CF application without having to go to the Enterprise Manager to find out. Each database in SQL Server has a sysfiles table, and if you sum the column size, that will tell you how much space is allocated to your data and log files. To access the sysfiles, you may have to set up a new SQL Server account that has access to objects owned by system. I've never attempted to do this, so I don't know for sure if SQL Server allows these tables to be accessed by the outside world (it's something of a security hole). Dana Larose ColdFusion Monkey Canadian Web Design Consulting Inc. A: 701-281 McDermot Avenue (McDermot King) P: 204.946.5155 C: 204.228.0477 F: 204.946.5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the applicable Canadian Web Design Consulting Inc. client engagement contract. -- 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: SQL Server Database Size
For MS SQL Server you can use the stored procedure "sp_helpdb" -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:39 PM To: [EMAIL PROTECTED] Subject: SQL Server Database Size Is it possible to query SQL Server to find out the size of a database? I'd like to be able to track its growth from a CF application without having to go to the Enterprise Manager to find out. Regards, Karl Simanonok -- 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.
CF Groupware
I am looking for a groupware solution written in CF, preferably open source. Anyone have any recommendations? Primarily I need calendar, task management, discussion functionality. TIA. - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http://www.mergernetwork.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: count() or recordcount
Also count() is really useful since its an aggregate. When you were doing SubSelects which only needed to count rows that matched certain criteria (like say ranking criteria to rank most searched for items) it becomes an invaluable tool :) Jeremy Allen [EMAIL PROTECTED] Insert Quarter Here ---[ ]--- -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 1:08 PM To: [EMAIL PROTECTED] Subject: Re: count() or recordcount Furthermore, count() is just that, a tally of the rows as a query column in and of itself. The RecordCount variable is an attribute of the query object. Returning a query object assumes that you wish to do something with it, other than count how many rows are returned. If you're just wishing to count the items with x criteria, your intent is closer to count() anyway. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, September 06, 2000 12:31 PM Subject: Re: count() or recordcount In a direct comparison, I would think count() would be since it's run on the SQL server. Todd Ashworth - Original Message - From: "Bud" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 12:11 PM Subject: count() or recordcount | Which is faster? I'm presuming count() or what else would it be good for? | -- | | 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. -- 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.
CFLOCK and client variables....
We are converting our site to client variables and in all the documentation CFLOCK talks about session variables. Is it nessecary to lock client variables? Wouldn't the Database handle the locking? 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.
OUTER JOIN w/more than 2 tables
Hello All! "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting errors. If I set up a query with 3 or more tables everything works fine until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up just 2 tables with an "OUTER JOIN" everything works great but if I add another table it errors again. A! The queries are below. What am I missing? Any help is appreciated. Mark :o) !-This one works fine- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } !-But I need data from 3rd table so I add this and it errors out- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } WHERE Customers.CustomerID = Calendar.CustomerID -- 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: MS Access CFUPDATE question
No you can't insert data into categories.groupid UNLESS that value that you are inserting is in group.groupid. For example: +Group table ++Groupid ++group 1 fruits 2 veges 3 meats 4 breads +categories table ++groupid ++categoryid++category 1 1 berries 1 2 all others 5 3 cooking oils 5 4 butter Those last two entries into the categories table are invalid because there is no group with an id of 5. The fats/sugars group was never added to the group table so you can't start adding categories yet. HTH, --K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:11 AM To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question I am not quite clear what you are recommending. Do you mean that I can't insert data in a column Categories.GroupID of table Categories if that Column is tied to Group.GroupID in table Group by using CFUPDATE. Sorry if I come across stupid... Thanks, Nehal -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:34 PM To: '[EMAIL PROTECTED]' Subject: RE: MS Access CFUPDATE question 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_01C01820.3D0E0070 Content-Type: text/plain; charset="iso-8859-1" You have a relationship with that table, that requires you to have a record in it that is related with the table your updating. Shawn Regan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:20 AM To: [EMAIL PROTECTED] Subject: RE: MS Access CFUPDATE question Anyone have an idea why the following error occurs when I use two tables in MS Access that have one-to-many relationship with referencial integrity applied. I am trying to update a record in Categories table which has one column called GroupID. The GroupID comes from Table called Group. I have established one-to-many relationship between Group -to- Categories. I have turned off the lookup column (combo box) option and changed it to text box. I still get this error. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Group'. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (6:2) to (6:124). Any suggestions are very welcome Thanks, Nehal -- 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. --_=_NextPart_001_01C01820.3D0E0070 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" TITLERE: MS Access CFUPDATE question/TITLE /HEAD BODY PFONT SIZE=3D2You have a relationship with that table, that = requires you to have a record in it that is related with the table your = updating./FONT/P PFONT SIZE=3D2Shawn Regan/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: [EMAIL PROTECTED] [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:fleming@forteinterac= tive.com/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, September 06, 2000 9:20 AM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: RE: MS Access CFUPDATE question/FONT /P BR PFONT SIZE=3D2Anyone have an idea why the following error occurs = when I use two tables in/FONT BRFONT SIZE=3D2MS Access that have one-to-many relationship with = referencial integrity/FONT BRFONT SIZE=3D2applied. I am trying to update a record in = Categories table which has one/FONT BRFONT SIZE=3D2column
RE: OUTER JOIN w/more than 2 tables
Do this all the time, n-table joins, just need to use () well. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON Customers.CustomerID = Calendar.CustomerID Use the () to left if you are using a LEFT OUTER JOIN. Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: OUTER JOIN w/more than 2 tables Hello All! "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting errors. If I set up a query with 3 or more tables everything works fine until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up just 2 tables with an "OUTER JOIN" everything works great but if I add another table it errors again. A! The queries are below. What am I missing? Any help is appreciated. Mark :o) !-This one works fine- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } !-But I need data from 3rd table so I add this and it errors out- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } WHERE Customers.CustomerID = Calendar.CustomerID -- 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: Baffled by Exception Code Runtime error
Dave Watts wrote: The client decided to carry out a complete server reinstall (inlcuding reformat and reinstall NT4.0) for reasons unknown. Did they reinstall everything in the proper order? I'd reinstall MDAC 2.5 again anyway. Already tried that - no luck. Another note. The client had reinstalled everything before the problem became aparent. I then proceeded to reinstall CF4.5ent and MDAC2.5. I had to reinstall CF twice as my first attempt didn't install properly - the iscf.dll file wasn't installed to the server - the second attempt worked just fine, but the problem is still there. I'm wondering if the problem might be totally unrelated to CF?I remember coming up with something quite similar a while back only with a SQL7.0 datasource. Turned out, in that case that the table in question just so happened to have been sitting on a faulty drive sector. This is not the case in this situation as the same code is used in several locations for several similar sub-sites on the same server and consequently using separate access datasources for each sub site, each of which are stored in different areas. I even tried moving a datasource just to rule this situation out. One more thing which springs to mind is the "maintain datasource connection" setting. I'm aware that if this setting is checked and someone attempts to overwrite the access database with another of the same name, say from a CD backup, it can cause some problems, simply due to sharing violations. Now, I'm wondering if this would have had any effect in the reverse order i.e. The client made a copy of all databases, as well as source code to CD before reformatting the drive. They don't, however remember if connection maintain setting was checked or not at that point. Any more ideas? 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] -- 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: count() or recordcount
If you do a select * and then do a record count you have to perform 2 operations. Select count(*) is only one so I think you are right - count(*) will be faster but it'll be negligible unless you have a huge amount of records Actually, the difference can be pretty significant even with average working recordsets. One reason for this is that when you use COUNT(), you're generally only returning one single record from the database. When you use CF to count records, you actually have to retrieve them all, which can be time-consuming. 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.
Web servers
I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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: count() or recordcount
On 9/6/00, Dan Haley penned: Two totally different beasts. If you want to pull data back from the database and then determine how many rows were returned, use query.recordcount rather than going back to the database for a row count. If you only want to find out how many rows but don't need the data, then count() is your best bet rather than pulling the data across the wire and using CF's recordcount. I only need the number of records. No data. The customer is charged based on the number of sessions used. So, I guess you answered my question. :) Thanks. CFQUERY DATASOURCE="#attributes.DSN#" NAME="getsessions" SELECT count(sessiondate) as sessionsused FROM sessions_used WHERE sessiondate = #createodbcdatetime(getfirst)# and sessiondate = #createodbcdatetime(getlast)# and customerid = '#customerid#' /CFQUERY -- 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.
Oracle connection lock . . .
Intermittently on our development machine we are starting to get the following error - Oracle error code = 0 - Timeout while obtaining an Oracle connection lock. Once these appear we have to stop and start CF. Right before these start occurring there is another error - Oracle error code = 0 - Unknown connection error for the data source. I know this is happening on other sites because of a thread on the forums (unresolved) and if you put the phrase "oracle connection lock" into AltaVista or Google it shows up on error pages the search engines retrieved. Anyone run into this and successfully solve it? We are on CF4.5 Ent on NT4 SP4 with Oracle 8.0.5 using a combination of native drivers and ODBC (moving to the native drivers). Thanks, Dan -- 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: CFLOCK and client variables....
Is it necessary to lock client variables? No. Wouldn't the Database handle the locking? Yes, if you're storing client variables in your database (as you should!) 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: Web servers
We run O'Reilly's WebSite Pro here and I love it. website.oreilly.com is where you can find info on it. Justin Kidman -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:30 AM To: [EMAIL PROTECTED] Subject: Web servers I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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: OUTER JOIN w/more than 2 tables
You do not have to use the OUTER keyword either you can just do RIGHT JOIN or LEFT JOIN or FULL JOIN :) Jeremy -Original Message- From: Justin Kidman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 1:27 PM To: '[EMAIL PROTECTED]' Subject: RE: OUTER JOIN w/more than 2 tables Do this all the time, n-table joins, just need to use () well. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON Customers.CustomerID = Calendar.CustomerID Use the () to left if you are using a LEFT OUTER JOIN. Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: OUTER JOIN w/more than 2 tables Hello All! "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting errors. If I set up a query with 3 or more tables everything works fine until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up just 2 tables with an "OUTER JOIN" everything works great but if I add another table it errors again. A! The queries are below. What am I missing? Any help is appreciated. Mark :o) !-This one works fine- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } !-But I need data from 3rd table so I add this and it errors out- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } WHERE Customers.CustomerID = Calendar.CustomerID -- 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: Baffled by Exception Code Runtime error
The client decided to carry out a complete server reinstall (inlcuding reformat and reinstall NT4.0) for reasons unknown. Did they reinstall everything in the proper order? I'd reinstall MDAC 2.5 again anyway. Already tried that - no luck. Another note. The client had reinstalled everything before the problem became apparent. I then proceeded to reinstall CF4.5ent and MDAC2.5. I had to reinstall CF twice as my first attempt didn't install properly - the iscf.dll file wasn't installed to the server - the second attempt worked just fine, but the problem is still there. I'm wondering if the problem might be totally unrelated to CF? That's my bet. You might be able to find out by running the query through another ODBC interface, such as the MS Query ODBC interface. If it fails there, then you know you have a problem. You might also run the MDAC Component Checker, which will show you any problems with MDAC files or registry settings. It's available from the same section of the MS site as MDAC itself. 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: Web servers
I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Although you can certainly use Apache on Win2K, IIS 5, which comes with Win2K, works very well with CF. It's part of the default Win2K Server install, and you can install it from "Add/Remove Windows Components" part of the "Add/Remove Software" Control Panel applet. 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: MULTIPLE COLUMN output problem!
Ok, try this. Didn't have the tables set up to test this against but it should point you in the right direction. !--- Get number of top-level categories for TD delimitting later --- cfquery name="GetNumCategories" ... SELECT DISTINCT(CategoryName) FROM [your table] /cfquery cfset numcategories = GetNumCategories.recordcount !--- Your query here --- cfquery name="GetAllCategories" ... . . . /cfquery !--- Since you can't use currentrow (because you're grouping), maintain your own category (top-level) counter --- cfset count = 0 !--- You're only gonna have 2 TDs in your table - one on the left, one on the right. --- table tr td valign="top" cfoutput query="GetAllCategories" group="CategoryName" cfset count = count + 1 !--- TD delimit check --- cfif count EQ ceiling(numcategories / 2) /tdtd valign="top" /cfif #CategoryName#br cfoutput #SubCategoryName# | /cfoutput brbr /cfoutput /td /tr /table Again, haven't tested this or anything... hope it helps. Courtney E. Payne, Developer Figleaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Hassan Khawaja [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:45 PM To: [EMAIL PROTECTED] Subject: MULTIPLE COLUMN output problem! Hi all, I am experiencing a certain problem, and will try to explain it as well as I can. I have a list of links that I am trying to output in a 2 column format, very similar to Yahoo! main menu design. As you know there are main Categories listed with sub categories right underneath them. kind of like: NewsComputers - World, US..-Software, WWW... BusinessReference - B2B, Companies..- Encyclopedias, Lists.. Now, I have in my database 2 tables - categories, and sub-categories, which are linked together thru a category id. The idea is to ouput the categories with their subcategories with them in a 2 column format. I can output 2 columns correctly if I only ouput the categories. or if I just output the subcategory. However it gets all very hairy if join the tables and output using the GROUP parameter of CFOUTPUT. The problem arises when there are a dissimilar number of subcategories for each category. In my code it looks for cfif currentrow MOD columncount eq 0 to determine if the current row's MOD 2 is 0 to know if 2 columns have already been output, but when there are different no. of subcategories, this logic statement gets evaluated at the wrong point than the one I want it to. Right now it is printing 3 columns for one row and only one column for another, while the rest of the rows are alright with 2 columns. What I mean is that if a certain category has 1 sub-cat. and the other has 2 sub-cats, the output counts them as 3 rows total and instead of starting a new row after the category and its sub-cats have been output, it tries to start a new one as soon as 2 columns have been evaluated. So even though the 3rd row is still part of the main category, for the logic statement, it's a NEW row. Sample output: [ numbers are rowcount ] 1-Administration2-Daily Reports 1- Areas | 2- Divisions | 3-Data Entry 4-Help 3- Products | 4- About | 5-MDS6-MSDS 5- Areas | 6- Facilities | 7-Process Control9-Production10-Reports ***problem 7- Business | 8- Divisional | 9- Reports | 10-Data | *** 3 columns 11-SSOP 12-Safety 11- Tasks | 12- Data | 13-Sales* problem 13- Facilities | just 1 column*** To stop confusing you further, I am including the code snippet to accomplish this: !--- the query to gather the info --- cfquery name="mainpage" SELECT mnu_categories.category_id, mnu_categories.category_name, mnu_categories.category_url, mnu_sub_categories.sub_cat_id, mnu_sub_categories.sub_cat_name FROM mnu_categories,
Re: CF Groupware
Here is a Open source Scheduler it seems to work fine. http://www.epicmedia.com/ -Mark - Original Message - From: Sean Daniels [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 10:21 AM Subject: CF Groupware I am looking for a groupware solution written in CF, preferably open source. Anyone have any recommendations? Primarily I need calendar, task management, discussion functionality. TIA. - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http://www.mergernetwork.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: Web servers
This is a multi-part message in MIME format. --=_NextPart_000_0175_01C0182B.7A9D8DA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Web serversIIS 5 I believe comes with Win2K server. Apache is not a bad webserver, depending on what you want to do it with. DC -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 17:30 To: [EMAIL PROTECTED] Subject: Web servers I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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_0175_01C0182B.7A9D8DA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEWeb servers/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=3D856435317-06092000IIS 5=20 I believe comes with Win2K server.nbsp; Apache is not a bad webserver,=20 depending on what you want to do it with./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D856435317-06092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D856435317-06092000DCBR/SPAN/FONT/DIV BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px" DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT = face=3DTahoma=20 size=3D2-Original Message-BRBFrom:/B Les Irvin=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, September 06, 2000=20 17:30BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B Web=20 serversBRBR/DIV/FONT PFONT size=3D2I've recently upgraded to Windows 2000 and am having = a hard=20 time finding a /FONTBRFONT size=3D2web server to run Cold = Fusion.nbsp;=20 Microsoft's IIS won't install over /FONTBRFONT = size=3D2Win2000.nbsp; Any=20 suggestions on a web server that will work?nbsp; Am I destined to=20 /FONTBRFONT size=3D2configure Apache for the job?/FONT = BRFONT=20 size=3D2Thanks,/FONT BRFONT size=3D2Les/FONT /P PFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 = target=3D_blankhttp://www.mail-archive.com/cf-talk@houseoffusion.com//A= /FONT=20 BRFONT size=3D2To Unsubscribe visit A=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"=20 = target=3D_blankhttp://www.houseoffusion.com/index.cfm?sidebar=3Dlistsam= p;body=3Dlists/cf_talk/A=20 or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in=20 the body./FONT/P/BLOCKQUOTE/BODY/HTML --=_NextPart_000_0175_01C0182B.7A9D8DA0-- -- 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: count() or recordcount
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_01C0182B.FDF468CC Content-Type: text/plain; charset="iso-8859-1" Hello! OT: Does anyone know how I can turn off MIME formatting when I send these messages? Every preference I check says "plain text", but my messages always get converted to MIME/HTML when they're sent out to the list. WinNT4/Outlook2K. Reply OTL, THX. From: "Bud" [EMAIL PROTECTED] Which is faster? I'm presuming count() or what else would it be good for? I thought I'd take a stab at this comparison and see what happened for me. All I need to do with this query is to output the number of records returned. My original query looked like this and took 72ms on average. The number of records was output as #DBCodes.RecordCount#. cfquery name="DBCodes" datasource="#datasource#" SELECT CODE FROMREFERRAL_CODE ORDER BYCODE ASC /cfquery The new query looks like this and takes 8ms on average. The number of records is output as #DBCodes.TotalRecords#. cfquery name="DBCodes" datasource="#datasource#" SELECT Count(*) AS TotalRecords FROMREFERRAL_CODE /cfquery So, in my case, using the tips and techniques I've picked up from this list, I've reduced the time this particular page takes to load by about 64ms, and since the *entire page* takes 320ms to execute on average, that's a pretty big savings! I love this place. :-) Thanks all, and keep 'em coming! Matthew --_=_NextPart_001_01C0182B.FDF468CC 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" TITLERE: count() or recordcount/TITLE /HEAD BODY PFONT SIZE=3D2Hello!/FONT /P PFONT SIZE=3D2OT: Does anyone know how I can turn off MIME = formatting when I send these messages? Every preference I check says = quot;plain textquot;, but my messages always get converted to = MIME/HTML when they're sent out to the list. WinNT4/Outlook2K. Reply = OTL, THX./FONT/P PFONT SIZE=3D2gt;From: quot;Budquot; = lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2gt;Which is faster? I'm presuming count() or what = else would it be good for?/FONT /P PFONT SIZE=3D2I thought I'd take a stab at this comparison and see = what happened for me./FONT BRFONT SIZE=3D2All I need to do with this query is to output the = number of records returned./FONT /P PFONT SIZE=3D2My original query looked like this and took 72ms on = average./FONT BRFONT SIZE=3D2The number of records was output as = #DBCodes.RecordCount#./FONT /P PFONT SIZE=3D2lt;cfquery name=3Dquot;DBCodesquot; = datasource=3Dquot;#datasource#quot;gt;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2SELECTnbsp; CODE/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2FROMnbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; REFERRAL_CODE/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT SIZE=3D2ORDER BY = nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; CODE ASC/FONT BRFONT SIZE=3D2lt;/cfquerygt;/FONT /P PFONT SIZE=3D2The new query looks like this and takes 8ms on = average./FONT BRFONT SIZE=3D2The number of records is output as = #DBCodes.TotalRecords#./FONT /P PFONT SIZE=3D2lt;cfquery name=3Dquot;DBCodesquot; = datasource=3Dquot;#datasource#quot;gt;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2SELECTnbsp; Count(*) AS TotalRecords/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2FROMnbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; REFERRAL_CODE/FONT BRFONT SIZE=3D2lt;/cfquerygt;/FONT /P PFONT SIZE=3D2So, in my case, using the tips and techniques I've = picked up from this list, I've reduced the time this particular page = takes to load by about 64ms, and since the *entire page* takes 320ms to = execute on average, that's a pretty big savings! I love this place. = :-)/FONT/P PFONT SIZE=3D2Thanks all, and keep 'em coming!/FONT BRFONT SIZE=3D2Matthew/FONT /P /BODY /HTML --_=_NextPart_001_01C0182B.FDF468CC-- -- 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: cffile - Unable to delete the file
It's an IIS bug http://support.microsoft.com/support/kb/articles/q184/9/56.asp there solution is: "You can delete the file 60 seconds after closing the Internet browser. This may cause some loss of performance depending on server load, and so on. " Problem is people are constantly hitting the page so it's never freed up. -John On Tue, 5 Sep 2000 18:42:50 -0400, you wrote: On 9/5/00, John Elder penned: 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? Where's your code? I've never had this happen. -- 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: OUTER JOIN w/more than 2 tables
Hehe, well, my SQL statements usually are a chain of LEFT JOINs when I do something like this. I was just trying to stick to his SQL statement. Justin Kidman -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:42 AM To: [EMAIL PROTECTED] Subject: RE: OUTER JOIN w/more than 2 tables You do not have to use the OUTER keyword either you can just do RIGHT JOIN or LEFT JOIN or FULL JOIN :) Jeremy -Original Message- From: Justin Kidman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 1:27 PM To: '[EMAIL PROTECTED]' Subject: RE: OUTER JOIN w/more than 2 tables Do this all the time, n-table joins, just need to use () well. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON Customers.CustomerID = Calendar.CustomerID Use the () to left if you are using a LEFT OUTER JOIN. Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: OUTER JOIN w/more than 2 tables Hello All! "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting errors. If I set up a query with 3 or more tables everything works fine until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up just 2 tables with an "OUTER JOIN" everything works great but if I add another table it errors again. A! The queries are below. What am I missing? Any help is appreciated. Mark :o) !-This one works fine- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } !-But I need data from 3rd table so I add this and it errors out- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } WHERE Customers.CustomerID = Calendar.CustomerID -- 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: Uploading and Emailing a File - Continued!
Thanks for the reply... Still a little confused as to how to accomplish this. This, as a test, works fine: cfmail to="[EMAIL PROTECTED]" from=#name# subject="file test" type="HTML" mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\MyFile.txt" However, the problem I'm now having, is when I try to replace "MyFile.txt" with the name of the file from the form field #MyFile#, it's pulling the ENTIRE entry in the form field... In other words...if I choose "D:\MyDocs\Text Files\MyFile.txt" to upload to the server - that entire path gets appended to the path in the mimeattach statement in the CFMAIL tag: mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\D:\MyDocs\Text Files\MyFile.txt" So, somehow I've got to eliminate the path part that's coming from the form and just get the file name by itself. Further ideas? Les Mizzell *** Who needs Intel? Athlon Inside!!! -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 11:31 AM To: [EMAIL PROTECTED] Subject: RE: Uploading and Emailing a File This is a multi-part message in MIME format. --=_NextPart_000_00E6_01C01817.6D46BA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Uploading and Emailing a FileYou need to get the file name from the FILE object. Use File.ServerFile in the MAILPARAM. DC -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 15:19 To: [EMAIL PROTECTED] Subject: Uploading and Emailing a File Travel Insurance Company wishes their clients to be able to upload small text files to then be emailed to the Company when processing claims. File is list of names, beneficiaries, birth datesblah, blah So, following action is working great. File is saved to server properly from the client input form: CFFILE ACTION="UPLOAD" DESTINATION="e:\inetpub\hostroot\myclient.com\MailFiles\" NAMECONFLICT="Overwrite" FILEFIELD="ClientFile" Same processing page needs to send email to the Insurance Company, which is working properly as well. However, I can't seem to get the syntax correct for it to include the above file as an attachment to the email CFMAILPARAM FILE="e:\inetpub\hostroot\myclient.com\MailFiles\#ClientFile#" I'm probably and idiot! Advise please?? Thanks Les Mizzell *** Who needs Intel? Athlon Inside!!! -- 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_00E6_01C01817.6D46BA00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEUploading and Emailing a File/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=3D251023015-06092000You=20 need to get the file name from the FILE object.nbsp; Use = File.ServerFile in the=20 MAILPARAM./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/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 Les Mizzell=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, September = 06, 2000=20 15:19BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B = Uploading and=20 Emailing a FileBRBR/DIV/FONTBR PFONT size=3D2Travel Insurance Company wishes their clients to be = able to=20 upload small/FONT BRFONT size=3D2text files to then be emailed = to the=20 Company when processing claims.nbsp; File/FONT BRFONT = size=3D2is list of=20 names, beneficiaries, birth datesblah, blah/FONT /P PFONT size=3D2So, following action is working great.nbsp; File is = saved to=20 server properly/FONT BRFONT size=3D2from the client input = form:/FONT=20 /P PFONT size=3D2lt;CFFILE ACTION=3D"UPLOAD"/FONT=20 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT=20 = size=3D2DESTINATION=3D"e:\inetpub\hostroot\myclient.com\MailFiles\"/FON= T=20 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT=20 size=3D2NAMECONFLICT=3D"Overwrite"/FONT=20 BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT=20 size=3D2FILEFIELD=3D"ClientFile"gt;/FONT /PBR PFONT size=3D2Same
Re: Web servers
IIS version 5 comes with WIN2K Server. We have ColdFusion running successfully on WIN2K with both IIS5 and O'Reilly WebSite Pro version 2.5. Regards, Howie - Original Message - From: "Les Irvin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 1:30 PM Subject: Web servers I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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: Web servers
you have to install iis 5 from the win2000 disk it is an addon go to add/remove programs and install it that way -joeyb On Wed, 06 September 2000, Les Irvin wrote: I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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. Joey Boswell Information Technology Ext. 308 -- 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: Web servers
Just as a side note Do not use Apache on a Windows* machine for any type of production work. It is/was designed first and foremost to work the best on *nix machines and there are a whole lot more bugs/security holes in Apache for windows. Jeremy -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 1:54 PM To: [EMAIL PROTECTED] Subject: RE: Web servers This is a multi-part message in MIME format. --=_NextPart_000_0175_01C0182B.7A9D8DA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Web serversIIS 5 I believe comes with Win2K server. Apache is not a bad webserver, depending on what you want to do it with. DC -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 17:30 To: [EMAIL PROTECTED] Subject: Web servers I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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_0175_01C0182B.7A9D8DA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEWeb servers/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=3D856435317-06092000IIS 5=20 I believe comes with Win2K server.nbsp; Apache is not a bad webserver,=20 depending on what you want to do it with./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D856435317-06092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D856435317-06092000DCBR/SPAN/FONT/DIV BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px" DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT = face=3DTahoma=20 size=3D2-Original Message-BRBFrom:/B Les Irvin=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, September 06, 2000=20 17:30BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B Web=20 serversBRBR/DIV/FONT PFONT size=3D2I've recently upgraded to Windows 2000 and am having = a hard=20 time finding a /FONTBRFONT size=3D2web server to run Cold = Fusion.nbsp;=20 Microsoft's IIS won't install over /FONTBRFONT = size=3D2Win2000.nbsp; Any=20 suggestions on a web server that will work?nbsp; Am I destined to=20 /FONTBRFONT size=3D2configure Apache for the job?/FONT = BRFONT=20 size=3D2Thanks,/FONT BRFONT size=3D2Les/FONT /P PFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 = target=3D_blankhttp://www.mail-archive.com/cf-talk@houseoffusion.com//A= /FONT=20 BRFONT size=3D2To Unsubscribe visit A=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"=20 = target=3D_blankhttp://www.houseoffusion.com/index.cfm?sidebar=3Dlistsam= p;body=3Dlists/cf_talk/A=20 or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in=20 the body./FONT/P/BLOCKQUOTE/BODY/HTML --=_NextPart_000_0175_01C0182B.7A9D8DA0-- -- 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: Uploading and Emailing a File - Continued!
This is a multi-part message in MIME format. --=_NextPart_000_018B_01C0182E.E3EA76D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: Uploading and Emailing a File - Continued!You need to use the value of the variable returned by CFFILE. This will be found in FILE.SERVERFILE, which will be the name of the file as it was saved on the server. This is the filename only and does not include the path. Try the code below. CFFILE ACTION="UPLOAD" DESTINATION="e:\inetpub\hostroot\myclient.com\MailFiles\" NAMECONFLICT="Overwrite" FILEFIELD="ClientFile" cfmail to="[EMAIL PROTECTED]" from=#name# subject="file test" type="HTML" mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\#file.serverfile#" -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 18:03 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Uploading and Emailing a File - Continued! Thanks for the reply... Still a little confused as to how to accomplish this. This, as a test, works fine: cfmail to="[EMAIL PROTECTED]" from=#name# subject="file test" type="HTML" mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\MyFile.txt" However, the problem I'm now having, is when I try to replace "MyFile.txt" with the name of the file from the form field #MyFile#, it's pulling the ENTIRE entry in the form field... In other words...if I choose "D:\MyDocs\Text Files\MyFile.txt" to upload to the server - that entire path gets appended to the path in the mimeattach statement in the CFMAIL tag: mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\D:\MyDocs\Text Files\MyFile.txt" So, somehow I've got to eliminate the path part that's coming from the form and just get the file name by itself. Further ideas? Les Mizzell *** Who needs Intel? Athlon Inside!!! -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 11:31 AM To: [EMAIL PROTECTED] Subject: RE: Uploading and Emailing a File This is a multi-part message in MIME format. --=_NextPart_000_00E6_01C01817.6D46BA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Uploading and Emailing a FileYou need to get the file name from the FILE object. Use File.ServerFile in the MAILPARAM. DC -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 15:19 To: [EMAIL PROTECTED] Subject: Uploading and Emailing a File Travel Insurance Company wishes their clients to be able to upload small text files to then be emailed to the Company when processing claims. File is list of names, beneficiaries, birth datesblah, blah So, following action is working great. File is saved to server properly from the client input form: CFFILE ACTION="UPLOAD" DESTINATION="e:\inetpub\hostroot\myclient.com\MailFiles\" NAMECONFLICT="Overwrite" FILEFIELD="ClientFile" Same processing page needs to send email to the Insurance Company, which is working properly as well. However, I can't seem to get the syntax correct for it to include the above file as an attachment to the email CFMAILPARAM FILE="e:\inetpub\hostroot\myclient.com\MailFiles\#ClientFile#" I'm probably and idiot! Advise please?? Thanks Les Mizzell *** Who needs Intel? Athlon Inside!!! -- 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_00E6_01C01817.6D46BA00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEUploading and Emailing a File/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=3D251023015-06092000You=20 need to get the file name from the FILE object.nbsp; Use = File.ServerFile in the=20 MAILPARAM./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/SPAN/FONTnbsp;/DIV
Re: Uploading and Emailing a File - Continued!
Les, You could always use file.serverfile attribute to populate the mimeattach attribute and have your path either hardcoded or set as an application variable e.g. cfmail to="[EMAIL PROTECTED]" from=#name# subject="file test" type="HTML" mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\#file.serverfile#" This works nicely, especially if you have nameconflict=unique in your cffile action. HTH 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: "Les Mizzell" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 7:02 PM Subject: RE: Uploading and Emailing a File - Continued! Thanks for the reply... Still a little confused as to how to accomplish this. This, as a test, works fine: cfmail to="[EMAIL PROTECTED]" from=#name# subject="file test" type="HTML" mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\MyFile.txt" However, the problem I'm now having, is when I try to replace "MyFile.txt" with the name of the file from the form field #MyFile#, it's pulling the ENTIRE entry in the form field... In other words...if I choose "D:\MyDocs\Text Files\MyFile.txt" to upload to the server - that entire path gets appended to the path in the mimeattach statement in the CFMAIL tag: mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\D:\MyDocs\Text Files\MyFile.txt" So, somehow I've got to eliminate the path part that's coming from the form and just get the file name by itself. Further ideas? Les Mizzell *** Who needs Intel? Athlon Inside!!! -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 11:31 AM To: [EMAIL PROTECTED] Subject: RE: Uploading and Emailing a File This is a multi-part message in MIME format. --=_NextPart_000_00E6_01C01817.6D46BA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Uploading and Emailing a FileYou need to get the file name from the FILE object. Use File.ServerFile in the MAILPARAM. DC -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 15:19 To: [EMAIL PROTECTED] Subject: Uploading and Emailing a File Travel Insurance Company wishes their clients to be able to upload small text files to then be emailed to the Company when processing claims. File is list of names, beneficiaries, birth datesblah, blah So, following action is working great. File is saved to server properly from the client input form: CFFILE ACTION="UPLOAD" DESTINATION="e:\inetpub\hostroot\myclient.com\MailFiles\" NAMECONFLICT="Overwrite" FILEFIELD="ClientFile" Same processing page needs to send email to the Insurance Company, which is working properly as well. However, I can't seem to get the syntax correct for it to include the above file as an attachment to the email CFMAILPARAM FILE="e:\inetpub\hostroot\myclient.com\MailFiles\#ClientFile#" I'm probably and idiot! Advise please?? Thanks Les Mizzell *** Who needs Intel? Athlon Inside!!! -- 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_00E6_01C01817.6D46BA00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEUploading and Emailing a File/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=3D251023015-06092000You=20 need to get the file name from the FILE object.nbsp; Use = File.ServerFile in the=20 MAILPARAM./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D251023015-06092000/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 Les Mizzell=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, September = 06,
Re: OUTER JOIN w/more than 2 tables
I tried it and I keep getting this error. Its the same error I was getting before. I must be missing something. :o( !-Error Message- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation. -Mark - Original Message - From: Justin Kidman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 10:27 AM Subject: RE: OUTER JOIN w/more than 2 tables Do this all the time, n-table joins, just need to use () well. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON Customers.CustomerID = Calendar.CustomerID Use the () to left if you are using a LEFT OUTER JOIN. Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: OUTER JOIN w/more than 2 tables Hello All! "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting errors. If I set up a query with 3 or more tables everything works fine until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up just 2 tables with an "OUTER JOIN" everything works great but if I add another table it errors again. A! The queries are below. What am I missing? Any help is appreciated. Mark :o) !-This one works fine- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } !-But I need data from 3rd table so I add this and it errors out- SELECT FixedTeeTimes.Fixed TeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } WHERE Customers.CustomerID = Calendar.CustomerID -- -- -- 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: count() or recordcount
This is a multi-part message in MIME format. --=_NextPart_000_0195_01C01830.46584260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: count() or recordcountI would love to have the answer to the same question. DC -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 17:58 To: '[EMAIL PROTECTED]' Subject: RE: count() or recordcount 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_01C0182B.FDF468CC Content-Type: text/plain; charset="iso-8859-1" Hello! OT: Does anyone know how I can turn off MIME formatting when I send these messages? Every preference I check says "plain text", but my messages always get converted to MIME/HTML when they're sent out to the list. WinNT4/Outlook2K. Reply OTL, THX. From: "Bud" [EMAIL PROTECTED] Which is faster? I'm presuming count() or what else would it be good for? I thought I'd take a stab at this comparison and see what happened for me. All I need to do with this query is to output the number of records returned. My original query looked like this and took 72ms on average. The number of records was output as #DBCodes.RecordCount#. cfquery name="DBCodes" datasource="#datasource#" SELECT CODE FROMREFERRAL_CODE ORDER BYCODE ASC /cfquery The new query looks like this and takes 8ms on average. The number of records is output as #DBCodes.TotalRecords#. cfquery name="DBCodes" datasource="#datasource#" SELECT Count(*) AS TotalRecords FROMREFERRAL_CODE /cfquery So, in my case, using the tips and techniques I've picked up from this list, I've reduced the time this particular page takes to load by about 64ms, and since the *entire page* takes 320ms to execute on average, that's a pretty big savings! I love this place. :-) Thanks all, and keep 'em coming! Matthew --_=_NextPart_001_01C0182B.FDF468CC 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" TITLERE: count() or recordcount/TITLE /HEAD BODY PFONT SIZE=3D2Hello!/FONT /P PFONT SIZE=3D2OT: Does anyone know how I can turn off MIME = formatting when I send these messages? Every preference I check says = quot;plain textquot;, but my messages always get converted to = MIME/HTML when they're sent out to the list. WinNT4/Outlook2K. Reply = OTL, THX./FONT/P PFONT SIZE=3D2gt;From: quot;Budquot; = lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=3D2gt;Which is faster? I'm presuming count() or what = else would it be good for?/FONT /P PFONT SIZE=3D2I thought I'd take a stab at this comparison and see = what happened for me./FONT BRFONT SIZE=3D2All I need to do with this query is to output the = number of records returned./FONT /P PFONT SIZE=3D2My original query looked like this and took 72ms on = average./FONT BRFONT SIZE=3D2The number of records was output as = #DBCodes.RecordCount#./FONT /P PFONT SIZE=3D2lt;cfquery name=3Dquot;DBCodesquot; = datasource=3Dquot;#datasource#quot;gt;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2SELECTnbsp; CODE/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2FROMnbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; REFERRAL_CODE/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT SIZE=3D2ORDER BY = nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; CODE ASC/FONT BRFONT SIZE=3D2lt;/cfquerygt;/FONT /P PFONT SIZE=3D2The new query looks like this and takes 8ms on = average./FONT BRFONT SIZE=3D2The number of records is output as = #DBCodes.TotalRecords#./FONT /P PFONT SIZE=3D2lt;cfquery name=3Dquot;DBCodesquot; = datasource=3Dquot;#datasource#quot;gt;/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2SELECTnbsp; Count(*) AS TotalRecords/FONT BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT = SIZE=3D2FROMnbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; REFERRAL_CODE/FONT BRFONT SIZE=3D2lt;/cfquerygt;/FONT /P PFONT SIZE=3D2So, in my case, using the tips and techniques I've = picked up from this list, I've reduced the time this particular page = takes to load by about 64ms, and since the *entire page* takes 320ms to = execute on average, that's a pretty big savings! I love this place. = :-)/FONT/P PFONT SIZE=3D2Thanks all, and keep 'em coming!/FONT BRFONT SIZE=3D2Matthew/FONT /P /BODY /HTML --_=_NextPart_001_01C0182B.FDF468CC-- -- Archives:
Re: Web servers
Website by O'Reilly works on Win2k without a problem. Additionally, I've run the IIS that comes with the CD and it's ok. You might need to use that one specifically rather than the 'old' IIS 4. Michael Dinowitz Publisher - The Fusion Authority (www.fusionauthority.com/alert) ListManager - CF-Talk, CF-Jobs, Spectra-Talk, JRun-Talk, etc. (www.houseoffusion.com) I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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: Uploading and Emailing a File - Continued!
Still a little confused as to how to accomplish this. This, as a test, works fine: cfmail to="[EMAIL PROTECTED]" from=#name# subject="file test" type="HTML" mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\MyFile.txt" However, the problem I'm now having, is when I try to replace "MyFile.txt" with the name of the file from the form field #MyFile#, it's pulling the ENTIRE entry in the form field... In other words...if I choose "D:\MyDocs\TextFiles\MyFile.txt" to upload to the server - that entire path gets appended to the path in the mimeattach statement in the CFMAIL tag: mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\D:\MyDocs\Text Files\MyFile.txt" So, somehow I've got to eliminate the path part that's coming from the form and just get the file name by itself. That's right. As Mr. Crawford indicated, you'll want to use the name of the actual file on the server, not the name of the file that was uploaded. These will be different, since you specified "overwrite" in your CFFILE's NAMECONFLICT attribute. So, you may upload "MyFile.txt", but it will be saved on the server as "AC3.tmp" or something like that. You can reference this value by using the variable File.ServerFile in your MIMEATTACH attribute: cfmail ... mimeattach="e:\inetpub\hostroot\aaintl.com\MailFiles\#File.ServerFile#" 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: CFLOCK and client variables....
Yes database handles the locking. AS loing as you are using a RDBMS. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 2:17 PM To: [EMAIL PROTECTED] Subject: CFLOCK and client variables We are converting our site to client variables and in all the documentation CFLOCK talks about session variables. Is it nessecary to lock client variables? Wouldn't the Database handle the locking? 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. -- 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: OUTER JOIN w/more than 2 tables
Doh, I messed up the ()... /bonk Justin. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM (oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID) RIGHT OUTER JOIN Customers ON Customers.CustomerID = Calendar.CustomerID That is the () setup I would use on LEFT JOINs, I don't use RIGHT JOINs much because they feel backwards to me. Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 11:17 AM To: [EMAIL PROTECTED] Subject: Re: OUTER JOIN w/more than 2 tables I tried it and I keep getting this error. Its the same error I was getting before. I must be missing something. :o( !-Error Message- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation. -Mark - Original Message - From: Justin Kidman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 10:27 AM Subject: RE: OUTER JOIN w/more than 2 tables Do this all the time, n-table joins, just need to use () well. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON Customers.CustomerID = Calendar.CustomerID Use the () to left if you are using a LEFT OUTER JOIN. Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: OUTER JOIN w/more than 2 tables Hello All! "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting errors. If I set up a query with 3 or more tables everything works fine until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up just 2 tables with an "OUTER JOIN" everything works great but if I add another table it errors again. A! The queries are below. What am I missing? Any help is appreciated. Mark :o) !-This one works fine- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } !-But I need data from 3rd table so I add this and it errors out- SELECT FixedTeeTimes.Fixed TeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID } WHERE Customers.CustomerID = Calendar.CustomerID -- -- -- 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: Web servers
I've got a few Windows 2000 machines, and all of them have IIS on them. It's on the install CD, so you should be able to add it. I've got CF 4.5.1, Spectra 1.0.1, and Tardis running on Windows 2000 Pro, so it should work. Jason Aden webworld studios, Inc. [EMAIL PROTECTED] -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 1:30 PM To: [EMAIL PROTECTED] Subject: Web servers I've recently upgraded to Windows 2000 and am having a hard time finding a web server to run Cold Fusion. Microsoft's IIS won't install over Win2000. Any suggestions on a web server that will work? Am I destined to configure Apache for the job? Thanks, Les -- 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.