RE: Calling all IIS Gurus..
Also u have the // the wrong way round it should be \\myotherserver\myotherdicrectory . From Rif Kiamil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 June 2001 13:43 To: CF-Talk Subject:Calling all IIS Gurus.. I seem to have a bit of a problem setting up some CF files for display on a windows2000 server. The files themselves exist on another server so I have set the web server to 'content exists on another server' and entered the correct unc path ie //myOtherServer/myDirectory Sure enough, those directories appear in the iis console and all seems to be there. However, when I try and browse those files, the .htm files are fine but the ...cfm files return the dreaded http error 1.0/404 file not found. So it seems as if the server doesn't recognise the .cfm's in the mapped directory. When I copy those directories to a local drive on the server and change the web server settings to map to the local directory then all the files are displayed OK so CF must be installed ok. So how do I get the web server to recognise .cfm files in a mapped directory ? Any suggestions would be greatly appreciated, Regards, MR ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developers Exchange (Allaire)
They should move the server 2 TeleHouse in the London Docklands (best place for internet connection :)) Rif -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: 19 May 2001 15:01 To: CF-Talk Subject:RE: Developers Exchange (Allaire) hmmm I wonder if this is related to the problems I've been having - my sites in South Carolina have been going down for days at a time, apparently as a result of upheavals at the phone company cheers, MIke Kear Windsor, NSW, Australia AFP Webworks On Sat, 19 May 2001, Angel Stewart wrote: Uhh..remember yesterday the guy from Macromedia mentioned they are switching over sites, so some things won't be available, or may not work right etc. etc. I think we're supposed to give them till Monday to get everything switched over etc. I believe they are doing this to better enable them to cope with the rolling blackout situation. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another clustering question (MS SQL 7.0).
Distributed Partitioned Views are real the only way 2 load balance in MS SQL but u will need MS SQL 2000 Enterprise Edition. From Rif Kiamil -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:32 To: CF-Talk Subject:RE: Another clustering question (MS SQL 7.0). Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB and 2 SQL servers. One of the SQL servers is live and the other is passive, both sharing a disk array containing the databases. If server 1 fails then server 2 takes over. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:29 To: CF-Talk Subject: Another clustering question (MS SQL 7.0). Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Send SMS
Trying 2 find info on this for a long time 2 From Rif -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: 16 February 2001 07:14 To: CF-Talk Subject:Send SMS Hi, Any information on sending SMS or SMS Gateway or Anything relevant. Please contribute to this forum. Thanks - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Notes database connection
If there is a OBDC driver for Notes then you can uses MD SQL DTS to import the data into MS SQL Rif -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 20:00 To: CF-Talk Subject:RE: CF-Notes database connection I haven't delt w/ Domino 5. I would think that ya should be able too... But dammed if I know how, and the general consensus seems to be problematic. At 03:47 PM 05/17/2001 +0100, you wrote: Surely with Domino 5 and it's flashy wizzy web side you must be able to build a web intermediary between Notes an CF. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 17:43 To: CF-Talk Subject: Re: CF-Notes database connection Well, in Notes you can use LotusScript. Out of Notes... I'm not sure. I had a neat little application working that allowed users to register from the web. It created their user accounts in a secondary name address book, and added them into the valid groups to the primary address book. I think that Lotus provided a template similar to that. At 07:43 AM 05/17/2001 -0500, you wrote: I know I came in at the tale end of this thread, but can you tell me if there's any scripting language that will write to NPAB? Note that the same scripting language does not need the capability to read from Any sort of database. Thanks, Tony Hicks - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 7:28 AM Subject: CF-Notes database connection Thanks to everyone who responded. It is disappointing that no one has had any success in doing what we are needing to do, which is exchanging data between Notes and our SQL Server database. We just wanted to get names, addresses, phone numbers, etc. out of our db and into the Notes Personal Address Book for our sales people to download into their Palms. Sounds like a simple thing, but I guess we'll have to wait for Bill to buy and kill Notes before we can get this app written. If anyone has any other ideas, we'd like to hear them. BTW, I did hear about ZMerge and have downloaded an eval. If it works I'll repost and let everyone know about it. Thanks again, Loyd Campbell Bank One International Corp. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
What type of database u using ? Rif -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 16:25 To: CF-Talk Subject:SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Running a MS SQL Server DTS Package from ColdFusion
very easy to run DTS from CF. here is an e.g. cfquery name="DTSImport" datasource="#DSN#" master.dbo.xp_cmdshell 'DTSRun /~S 0x570181FD8A97DA72994BA30CD26A73E4C23626D16140CF0 /~U 0xF8141F8065D98248 /~P 0x23CAD6B1F4C4A4FBA499C068C0851BA3F2B320313D854C83 /~N 0x8633C5F800EA5FB74BA6756A1A7C499E0BECB133550E554589B918A33667AFE11A2A97320E 29F6FC8431DEF154CA67B ' /cfquery U can find the hexadecimal encrypted sting by scheduling the DTS then go in to the Job, under SQL SEM, Management, Jobs, Properties, Steps, Edit the step that runs your DTS it will have the command u need to run (the command will look like this DTSRun /~S 0x5701181D8A97DA72994BA30CD26A73E4C23626D16140CF0 /~N 0x5AEDF53AEB844805D84A0F5C167B98D34FDD2EBBCC75CAF55AFED3C357DA785DD056F835CB 5B36BB365A3B921227B99 /E ). From Rif -Original Message- From: Percy E Perez [mailto:[EMAIL PROTECTED]] Sent: 16 January 2001 18:14 To: CF-Talk Subject: Running a MS SQL Server DTS Package from ColdFusion Anyone has any suggestions on how to run a DTS package from a coldfusion page? I found article# Q252987 on technet on how to do this using ASP, but I would rather implemented in ColdFusion. Thank you for any suggestions. Percy E Perez -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 11:59 AM To: CF-Talk Subject: RE: SQL Manager Yep, this will be taken care of soon. -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 10:44 AM To: CF-Talk Subject: RE: SQL Manager yep, I would NEVER want anyone connecting to the Master DB. I always keep my SQL Servers on the inside of the firewall allowing no access from the outside world - only from the cf server. Neil ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how to retrieve excel data and to put into DB
Do u run MS SQL any where on the network ? -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: 13 January 2001 15:44 To: CF-Talk Subject: Re: how to retrieve excel data and to put into DB I run Cold Fusion on Linux, so I cannot connect to Excel as a datasource or use a CFX tag that uses OLE to remote control Excel. The way I do it (somewhat clumsy) is the user has to "Save As..." in Tab Delimited format. My page has a FILE UPLOAD form input, which uploads the file. Then I clean out the Excel garbage I dont want, such as the leading and trailing " marks, either in Cold Fusion or in Perl (using CFEXECUTE). Then I run a query to loop over the file and insert all the data... or I bulk insert the data. Someone here recently talked about using an Excel Macro that did the saving and uploading for the user, which would make it much more seamless. At 03:23 AM 1/13/01 -0800, ramesh deva wrote: Hi all, How can you retrieve the excel sheet data and to put in to database.. Is there any tag avaialble,, Thanx in advace Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Name are Intranet !!
Dear CF Users, We are looking to name are intranet. Any body got any good ideas? From Rif PS Should be a sexy name ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Name are Intranet !!
Sell Food to End Users. -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: 15 December 2000 18:44 To: CF-Talk Subject:Re: Name are Intranet !! Rif: It should be name OUR intranet, not arewhat exactly does your company do? -Greg - Original Message - From: "Rif Kiamil" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 11:44 AM Subject: Name are Intranet !! Dear CF Users, We are looking to name are intranet. Any body got any good ideas? From Rif PS Should be a sexy name ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Order By Question
U running MS SQL server 7 ? -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: 04 December 2000 15:41 To: CF-Talk Subject:OT: Order By Question I've got a query that works fine except that it seems to be ignoring the order by clause. It seems to be sorting in order of the primary key. Any suggestions? The query is: cfquery datasource="HelpDesk" name="EditRecordqry" Select *, DATENAME(MM, CALLDATE) + ' ' + DATENAME(DD, CALLDATE) + ', ' + DATENAME(, CALLDATE)AS 'DATEOFCALL', DATENAME(MM, LASTUPDATE) + ' ' + DATENAME(DD, LASTUPDATE) + ', ' + DATENAME(, LASTUPDATE)AS 'LU', Ext, EmailAddress from CALLS, USERS WHERE (CALLS.Closed='N' or CALLS.Closed IS NULL) AND (CALLS.Name = USERS.Name) order by Users.Name /cfquery I've also tried sorting by CALLS.Name, same result. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Does not like MSSQL7 @@ROWCOUNT
Dear All I have the flowing CF Code --- START - cfparam name="AddInvoices.RowsAffected" default="NOTSET" cfquery datasource="#DSNOperaDW#" name="AddInvoices" INSERT INTO [Images_Invoice_Index] (Invoice_ID, DirPath) SELECT CSVTemp.Inv_ID, CSVTemp.DIR FROMImages_INVPROJECT_CSVTempTable as CSVTemp WHERE (Doc_Type = 'I') SELECT @@ROWCOUNT as RowsAffected /cfquery cfoutput#AddInvoices.RowsAffected#/cfoutput -- END --- Now my Output should be a number but I just get my default param back NOTSET. If I run this query in MS Query Analyzer I will get the following back - START (8 row(s) affected) RowsAffected 8 -- END --- Any body know why CF does not pick up the 8 and how I can get it to pick up the 8 Thanks for your Time Rif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Does not like MSSQL7 @@ROWCOUNT
But why does CF not pick up the Select @@RowCount as rowsaffected Unless in is at the top of the CFQUERY ? -Original Message- From: Manner Jukka [mailto:[EMAIL PROTECTED]] Sent: 01 December 2000 13:16 To: CF-Talk Subject:RE: CF Does not like MSSQL7 @@ROWCOUNT Use a trigger! Enterprise Manager - your database - tables - right click on top of any table - "Manage Triggers" and create a new trigger: CREATE TRIGGER Insert_Images_Invoice_Index ON [dbo].[Images_Invoice_Index] FOR INSERT AS BEGIN SELECT rowsaffected = @@rowcount END - Jukka -Original Message----- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 2:31 PM To: CF-Talk Subject: CF Does not like MSSQL7 @@ROWCOUNT Dear All I have the flowing CF Code --- START - cfparam name="AddInvoices.RowsAffected" default="NOTSET" cfquery datasource="#DSNOperaDW#" name="AddInvoices" INSERT INTO [Images_Invoice_Index] (Invoice_ID, DirPath) SELECT CSVTemp.Inv_ID, CSVTemp.DIR FROMImages_INVPROJECT_CSVTempTable as CSVTemp WHERE (Doc_Type = 'I') SELECT @@ROWCOUNT as RowsAffected /cfquery cfoutput#AddInvoices.RowsAffected#/cfoutput -- END --- Now my Output should be a number but I just get my default param back NOTSET. If I run this query in MS Query Analyzer I will get the following back - START (8 row(s) affected) RowsAffected 8 -- END --- Any body know why CF does not pick up the 8 and how I can get it to pick up the 8 Thanks for your Time Rif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Does not like MSSQL7 @@ROWCOUNT
I run your Trigger CF still does not pick up RowAffected ? -Original Message- From: Manner Jukka [mailto:[EMAIL PROTECTED]] Sent: 01 December 2000 13:16 To: CF-Talk Subject:RE: CF Does not like MSSQL7 @@ROWCOUNT Use a trigger! Enterprise Manager - your database - tables - right click on top of any table - "Manage Triggers" and create a new trigger: CREATE TRIGGER Insert_Images_Invoice_Index ON [dbo].[Images_Invoice_Index] FOR INSERT AS BEGIN SELECT rowsaffected = @@rowcount END - Jukka -Original Message----- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 2:31 PM To: CF-Talk Subject: CF Does not like MSSQL7 @@ROWCOUNT Dear All I have the flowing CF Code --- START - cfparam name="AddInvoices.RowsAffected" default="NOTSET" cfquery datasource="#DSNOperaDW#" name="AddInvoices" INSERT INTO [Images_Invoice_Index] (Invoice_ID, DirPath) SELECT CSVTemp.Inv_ID, CSVTemp.DIR FROMImages_INVPROJECT_CSVTempTable as CSVTemp WHERE (Doc_Type = 'I') SELECT @@ROWCOUNT as RowsAffected /cfquery cfoutput#AddInvoices.RowsAffected#/cfoutput -- END --- Now my Output should be a number but I just get my default param back NOTSET. If I run this query in MS Query Analyzer I will get the following back - START (8 row(s) affected) RowsAffected 8 -- END --- Any body know why CF does not pick up the 8 and how I can get it to pick up the 8 Thanks for your Time Rif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access 2000
Is it run on the ColdFusion server ? or Is it on any other Server your access database ? -Original Message- From: sknyppy [mailto:[EMAIL PROTECTED]] Sent: 01 December 2000 04:01 To: CF-Talk Subject:access 2000 We have a client designing databases w/ Access 2000. He cannot setup a datasource to the database, everytime I try to verify the connection, it fails. What can I do to correct this? Update drivers? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Does not like MSSQL7 @@ROWCOUNT
But the record count does not count how many Insert the SQL has made only the amount of rows outputted From R -Original Message- From: Eli Shechter [mailto:[EMAIL PROTECTED]] Sent: 01 December 2000 14:42 To: CF-Talk Subject:RE: CF Does not like MSSQL7 @@ROWCOUNT Cold fusion has a problem with writing multiple queries in one CFQUERY, you could just use the variable #AddInvoices.RecordCount# -Eli Shechter- -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 7:31 AM To: CF-Talk Subject: CF Does not like MSSQL7 @@ROWCOUNT Dear All I have the flowing CF Code --- START - cfparam name="AddInvoices.RowsAffected" default="NOTSET" cfquery datasource="#DSNOperaDW#" name="AddInvoices" INSERT INTO [Images_Invoice_Index] (Invoice_ID, DirPath) SELECT CSVTemp.Inv_ID, CSVTemp.DIR FROMImages_INVPROJECT_CSVTempTable as CSVTemp WHERE (Doc_Type = 'I') SELECT @@ROWCOUNT as RowsAffected /cfquery cfoutput#AddInvoices.RowsAffected#/cfoutput -- END --- Now my Output should be a number but I just get my default param back NOTSET. If I run this query in MS Query Analyzer I will get the following back - START (8 row(s) affected) RowsAffected 8 -- END --- Any body know why CF does not pick up the 8 and how I can get it to pick up the 8 Thanks for your Time Rif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What Time Zone
Dear All, I know this is not the place for this type of message but does any body know what Time Zone Allaire's HQ is in ? From R ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RIF Please read concerning Cube
I would never every uses space in your database Naming Convention. But if u
do want to just put [] around The Cube.
E.g
OPENQUERY([My Cube],
From Rif
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 18:40
To: CF-Talk
Subject: Re: RIF Please read concerning Cube
Looks like you're trying to query a table called "The Cube". In most
RDBMS's, this is not a valid table name. Change it to something like
TheCube or The_Cube.
--
Billy Cravens
[EMAIL PROTECTED]
Edward Peloke wrote:
Rif,
I tried your code and seem to be able to get to the linked server but I
now
get an error or incorrect syntax near cube.
**
Error Diagnostic Information
OLEDB Error Code = 170
Line 3: Incorrect syntax near 'Cube'.
The error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (2:1) to (2:48).
*
Here is the mdx statement I want to execute:
SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [The Cube]
'* Here is the code generating the error
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
cfquery datasource="The Cube" Name="My Cube"
set quoted_identifier on
SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROMOPENQUERY(My Cube,
'select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales)
')
as o
set quoted_identifier off
/CFQUERY
html
head
titleUntitled/title
/head
body
table
tr
tdUnit Sales/td
tdMedia Type/td
/tr
cfoutput query="OLAPTEST"
tr
td#OLAPTEST.C#/td
td#OLAPTEST.R#/td
/tr
/cfoutput
/table
/body
/html
Thanks,
Eddie
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom output tag
This is what I do when I want to Query MSOLAP from ColdFusion.
cfquery datasourc="SQLSERVERDATABASE" Name"OLAPTEST"
set quoted_identifier on
SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROMOPENQUERY(OLAP_TEST, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')
as o
set quoted_identifier off
/CFQUERY
table
tr
tdUnit Sales/td
tdMedia Type/td
/tr
cfoutput query="OLAPTEST"
tr
td#OLAPTEST.C#/td
td#OLAPTEST.R#/td
/tr
/cfoutput
/table
Hope this helps
From Rif
PS Where it has OLAP_TEST, that is a link server from my SQL to my OLAP
database
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 14:57
To: CF-Talk
Subject: Custom output tag
Hello,
I was able to query an olap cube through cf but didn't get a result. I was
told me code should work, I just need to play with the output of the query
to put it in a form that cf will understand. I used the querydump tag and
it said returned a spaceany suggestions on how I can see the query
results?
Thanks,
Eddie
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible w/CF???
If u where going to uses a Triggers, how would it know the UserID ? From R -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: 20 November 2000 14:26 To: CF-Talk Subject: RE: Is this possible w/CF??? Just to toss a little more to this suggestion. Assuming this is not an Access database, one way to make things a bit more effecient is to use Stored Procedures to perform all of the actual logging. :-) (Triggers:) Then just use CF to figure out how to reconstruct and assemble the interface to view the log table in a easy to understand/administer fashion Jeremy Allen ElliptIQ Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP
This is what I do when I want to query OLAP from CF.
Make a LinkServer from MS SQL Server to MS OLAP Server. The setting are :
Provider Name : Microsoft OLE DB Provider for OLAP
Product Name: MSOLAP
Datesource : OLAP SERVER NAME
Provider string :
Location: NAME OF OLAP DATABASE
Catalog : NAME OF OLAP DATABASE
Onces that is done you can us the OPENQUERY from a normal SQL query. But you
must turn quted_identifier ON.
e.g.
-- START --
CFQUERY
set quoted_identifier on
SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROMOPENQUERY(OLAP_TEST, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')
as o
set quoted_identifier off
/CFQUERY
-- END --
From Rif
PS I have not test this query!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 16:54
To: CF-Talk
Subject: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP
Hello, I am attempting to query an Olap Cube through using MDX through CF.
I am using a com object and can see the cube but am unable to get any data
from it. I used a custom tag to see what was being returned and all that is
returned is a space. I was told by Ben Forta that I would need to play with
the com object so that CF would understand the output. Any suggestions?!?
The following code runs with no errors, (unless I have made an error in my
expression) but there is only a space in the output.
Thanks,
Eddie
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
html
head
titleCube Test/title
/head
body
cfset adOpenStatic = 3
cfset adLockReadOnly = 1
cfset adCmdText = 1
!--- Grab the component---
cfobject type="COM"
name="cst"
class="ADOMD.Cellset"
action="CREATE"
!---This is where I now write the mdx expression---
cfset sMDX="SELECT TopCount({[Product].[Product Name].Members}, 1,
Measures.[Unit Sales]) ON COLUMNS FROM [Sales]"
!---cfset sMDX="SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS
FROM [The Cube]" ---
cfset cst = cst.open(sMDX,
"Provider=MSOLAP;Datasource=NHCNTMSSQL2000;Catalog=FoodMart;")
!---I have just added this to make sure that the variable is not empty. If
it is the page will stop---
cfif "CST" IS " "
The variable is empty.
cfabort showerror="The Template was aborted because the variable is an
empty string"
/cfif
!---The values should be listed here---
cfform name="mdx"
font face="arial" size=4
Results:brbrbr
/font
font face="arial" size="3"
cf_objectdump object="#cst#"
cfoutput
#cst#br
/cfoutput/font
font face="arial" size=4
Your mdx query is:br/fontbr
font face="arial" size="3"
cfoutput
#smdx#
/cfoutput/font
/cfform
/body
/html
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP
U dont link ColdFusion to a LinkServer, U tell SQL to which link server u
want to uses after the OPENQUERY
e.g.
FROMOPENQUERY(LINK SERVER NAME, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')
as [AS ANYTHING]
you have to uses "AS" for your table name but it can be anything
you have to uses "AS" for your your select stuff becuase when u do the
output it can not uses the standed names e.g.
cfoutput#OlapQuery.Measures.MeasuresLevel.Members#/cfoutput, but if you
us AS then u can do the following cfoutput#OlapQuery.C#/cfoutput. Again
it does not have to be "C", it can be "MembersName".
Hope this helps
From Rif :-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 19:40
To: Rif Kiamil
Subject: RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE
HELP
Rif,
Thanks for your response. I set up my linked server but just have a few
questions. How do I get to the linked server through coldfusion? How do I
set up my datasource in Cf Administrator? Also, why did you use the o.
"" as c in your expressions? Why did you use the o and c? Can I
not just use a query such as:
SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [My Cube]
And then try to diplay the results in an output tag?
Thanks again!
Eddie
-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 1:48 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE
HELP
This is what I do when I want to query OLAP from CF.
Make a LinkServer from MS SQL Server to MS OLAP Server. The setting are :
Provider Name : Microsoft OLE DB Provider for OLAP
Product Name: MSOLAP
Datesource : OLAP SERVER NAME
Provider string :
Location: NAME OF OLAP DATABASE
Catalog : NAME OF OLAP DATABASE
Onces that is done you can us the OPENQUERY from a normal SQL query. But you
must turn quted_identifier ON.
e.g.
-- START --
CFQUERY
set quoted_identifier on
SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROMOPENQUERY(OLAP_TEST, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')
as o
set quoted_identifier off
/CFQUERY
-- END --
From Rif
PS I have not test this query!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 16:54
To: CF-Talk
Subject: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP
Hello, I am attempting to query an Olap Cube through using MDX through CF.
I am using a com object and can see the cube but am unable to get any data
from it. I used a custom tag to see what was being returned and all that is
returned is a space. I was told by Ben Forta that I would need to play with
the com object so that CF would understand the output. Any suggestions?!?
The following code runs with no errors, (unless I have made an error in my
expression) but there is only a space in the output.
Thanks,
Eddie
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
html
head
titleCube Test/title
/head
body
cfset adOpenStatic = 3
cfset adLockReadOnly = 1
cfset adCmdText = 1
!--- Grab the component---
cfobject type="COM"
name="cst"
class="ADOMD.Cellset"
action="CREATE"
!---This is where I now write the mdx expression---
cfset sMDX="SELECT TopCount({[Product].[Product Name].Members}, 1,
Measures.[Unit Sales]) ON COLUMNS FROM [Sales]"
!---cfset sMDX="SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS
FROM [The Cube]" ---
cfset cst = cst.open(sMDX,
"Provider=MSOLAP;Datasource=NHCNTMSSQL2000;Catalog=FoodMart;")
!---I have just added this to make sure that the variable is not empty. If
it is the page will stop---
cfif "CST" IS " "
The variable is empty.
cfabort showerror="The Template was aborted because the variable is an
empty string"
/cfif
!---The values should be listed here---
cfform name="mdx"
font face="arial" size=4
Results:brbrbr
/font
font face="arial" size="3"
cf_objectdump object="#cst#"
cfoutput
#cst#br
/cfoutput/font
font face="arial" size=4
Your mdx query is:br/fontbr
font face="arial" size="3"
cfoutput
#smdx#
/cfoutput/font
/cfform
/body
/html
~~
Structure your ColdFusion code with Fusebox. Get the officia
RE: automatic page copying
You can use ColdFusion to Tell MS SQL server to run a xp_cmdshell with a xcopy command -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: 09 October 2000 13:59 To: CF-Talk Subject: automatic page copying I thought I would ask if this is possible before actually attempting it, but once a day(or week) I'd like to schedual a file copy from my mirror server to the actual content server. A sort for anything new, and copy it over type of application. Possible? Has anyone done this type of thing before? -Pete -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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.
Client Session variables?
Dear All, What is the different between Client Session variables? From Rif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: Getting Outlook information - Success
Its been about a year since I played with MS Digital Dashboard. I think the is a ActiveX component. It only work if 1. Outlook is install on that client computer. 2. Outlook has been configured ActiveX component only show what outlook can show. From Rif -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 15:10 To: CF-Talk Subject: RE: Getting Outlook information - Success Thanks for the help so far. I downloaded digital dashboard, but I am not running NT2K yet, so I can't implement it to the general populace. HOWEVER, there is a page of code in the digital dashboard that will retrieve your Outlook email. I just copied the code onto a ColdFusion page and it worked instantly. I did not change 1 single line of the code. What the code does is query the system for the Outlook mail information, and use that to open the mailbox. Security is my next investigation. If two people share a computer I am not sure what will happen. If anyone wants the code to do this, just email me. It is very short. Tim Tim Claremont Xerox Corporation 800 Phillips Road 111-06J Webster, NY 14580 Phone: 716-265-8573 Pager: 716-239-3514 -Original Message- From: seth ward [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:52 AM To: CF-Talk Subject: RE: Getting Outlook information FWIW, you can do this stuff in ASP - there's something called a Digital Dashboard, with pre-developed applications to access the Inbox, Calendar, COntacts etc. You could combine ASP pages with Coldfusion if that's possible in your case. http://www.microsoft.com/solutions/km/digitaldashboard.htm Seth Ward -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 27 September 2000 18:13 To: CF-Talk Subject: Getting Outlook information My company uses Microsoft Outlook as the mail client. I am wondering if I can grab information from outlook and put it on my customized intranet home page. For instance, can I put a link in my coldfusion page that calls the user's Outlook calendar and shows it on the page? What about the number of new messages, etc? Basically I want to grab the features of the "Outlook Today" tools in outlook. Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarlistsbodylists/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: combining SQL queries
Why do you want to combin then ? -Original Message- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 19:21 To: CF-Talk Subject: OT: combining SQL queries CFQUERY NAME="GetSenderDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# /CFQUERY CFQUERY NAME="GetOrdererDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# /CFQUERY CFQUERY NAME="GetApproverDetails" DATASOURCE="#datasource#" SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# /CFQUERY Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [CF-Talk] Ben Forta's CF_DHTMLMenu
Try this web site. Has very cool Menu Apps, www.coolfocus.com -Original Message- From: Jay Wigginton [mailto:[EMAIL PROTECTED]] Sent: 20 September 2000 01:32 To: [EMAIL PROTECTED] Subject: RE: [CF-Talk] Ben Forta's CF_DHTMLMenu Thanks... I did have it pointing to the correct spot... I have decided not to use the tag after I found out that it supports only IE and not Netscape... -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 3:02 PM To: [EMAIL PROTECTED] Subject: Re: [CF-Talk] Ben Forta's CF_DHTMLMenu Make sure that you specify the correct script directory in the custom tag (it's looking for the .js file that came with the tag) .. the example he gives points to a /js directory (which would be js under web root). Try "./" if it's in the same directory as your application. Otherwise, point it to the correct directory (relative to your web root) -- Billy Cravens [EMAIL PROTECTED] Jay Wigginton wrote: Does anyone have a working example of Ben Forta's custom tag CF_DHTMLMENU? I downloaded this from the tag gallery and used the example from there and I when I attempt to test it I get one javascript error after another??? thanks Jay -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: I GIVE UP!
Try Select T.* from Test AS T where (T.ID 6) -Original Message- From: Geno [mailto:[EMAIL PROTECTED]] Sent: 13 September 2000 06:39 To: [EMAIL PROTECTED] Subject: I GIVE UP! I want to select all records from a table that "do not" contain the number 6. Sheesh! Why is it so difficult to select records this way... the query was Select * From CaseDetail, CaseInfo Where CaseDetail.CaseID=CaseInfo.CaseID And CaseDetail.StatusID ? 6 I've tried NEQ, Does Not Contain, or!=, Just about everything I'm lost! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: How to Auto downloading of file
I think u can only do this if u write an ActiveX program or u can let them download it off the web -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: 07 September 2000 14:33 To: [EMAIL PROTECTED] Subject: How to Auto downloading of file I have create a program that will create a excel file. Cool, this works great, but what I need to do next is not so clear. How do I allow the user to create the file on their local computer? Using this code: CFSET OUTFILE="E:\inetpub\wwwroot\vsts\ExcelExport.txt", creates the file on the server. I need to create this file on the users local HD. Thanks for the help. Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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 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: CFObjects v FuseBox
Any body else, got any thing to add? I would be grateful for any more insight. -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: 03 September 2000 16:56 To: '[EMAIL PROTECTED]' Subject: CFObjects v FuseBox Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: CFObjects v FuseBox
Have u used CFobject ? If u have what do u think of it ? -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: 04 September 2000 12:37 To: [EMAIL PROTECTED] Subject: RE: CFObjects v FuseBox I would agree with what Rif had to say: the fusebox idea is quite useful but I have never used it 100% - I was already doing fusebox- like things before I heard of it. Different projects require different approaches. Graham -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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.
CFObjects v FuseBox
Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: CFObjects v FuseBox
Do u have your own coding policies? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: 03 September 2000 17:23 To: [EMAIL PROTECTED] Subject: RE: CFObjects v FuseBox I think is what do you want to work with. I have looked in to a lot of coding methods for CF and really haven't seen anything that has made me really comfortable to work with. They all have merit and some people find them really helpful. If you're code right now is clean, can be easily distributed, and works fine and error free, why bother yourself with learning a coding specification. It's up to you, both communities have a lot of insight. Bob Everland -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 11:56 AM To: '[EMAIL PROTECTED]' Subject: CFObjects v FuseBox Dear All, Which would u pick Fuse Box or CFObejcts and why? What are the differences between CFObejcts and FuseBox? Can u compare them? Thanks for any info Rif Kiamil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: Escaping Pound Signs in a CF Query....
What about [Cust#] ? -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: 01 September 2000 15:58 To: [EMAIL PROTECTED] Subject: RE: Escaping Pound Signs in a CF Query I gave that a shot last night, to no avail... It just doesnt seem to like the pound sign(#) in the sql query. I'm trying to get the new db guy to change the field name, but it's going to take a while, so i'd like to create a workaround.. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Friday, September 01, 2000 12:04 AM To: '[EMAIL PROTECTED]' Subject: RE: Escaping Pound Signs in a CF Query Yes. Either change it Cust ## or something else like Cust num. This also applies to using the hex colour codes - eg: ##ff intead of the usual #ff - within CFOUTPUT. The double pound signs cancel out the usual CFOUTPUT requirement. Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 September 2000 5:00 To: Cf-Talk Subject: Escaping Pound Signs in a CF Query For some strange and utterly inconvenient reason, our former Access Database guy had created a form field named Cust#. I imagine this stands for CustNumber, but CF doesn't seem to agree. Is there a way to escape a # (pound sign) so i can query the table? I've tried doing a "Cust# As CustNum" as well as Cust##. Nothing seems to work. Anyone know of anything? Thanks In Advance!! Mark Armendariz Righteous Design -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: CF hangs
Which version of MDAC are u using -Original Message- From: Jimmy B. Glass [mailto:[EMAIL PROTECTED]] Sent: 30 August 2000 21:18 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: CF hangs Hey Guys... I am having the exact same problem as you guys have described... I have just taken over on this site, and it seems have been going on for a while. We are using CF 4.0.1 on NT 4 machines. We use SQL server as our DB. Did ya'll ever come up with a solution to the NT Errors 109 232? I tried your fix to tell the ODBC not to maintain a connection, but still am able to produce the "Unable to write reply - Client browser stopped waiting for request" which I feel triggers the NT Error 109, eventually halting CF server. Any suggestions would be greatly appreciated. Jimmy G - Original Message - From: "Nille af Ekenstam" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 6:27 AM Subject: RE: CF hangs Neil Robinson skrev: Hi Nille, I had what sounds like the same problem this week. What database are you using? If it's the same problem (check your server.log file for NT Errors) then it seems to be caused by ODBC drivers keeping database connections open. After the timeout period on the db server, CF tries to use the same connection pipe thinking that it's still open, and an error occurs. I disabled the 'maintain database connection' option on my oracle odbc driver and it's now been running fine for about 24 hours (normally it would hang after 1-2 hours). I'm using MSSQL7.0 as bd. Found a gazillion of these in my server.log: "Error","TID=1448","07/13/00","23:15:58","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109 occurred." Look familiar to you? I've just followed your advice on disabling "maintain db con" - hope it helps. Thanks Neil! file://Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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
Are u going do the admin with SQL EM (GUI) or uses T-SQL ? -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 30 August 2000 18:53 To: [EMAIL PROTECTED] Subject: SQL Im doing a quote for a company that has a current SQL database for their existing web page. We will be adding a section to their web page. Is there a way i can edit this SQL database remotely? I have never worked with a SQL database or server, and im wondering what kind of investment i have to make to edit their existing database? Thanks Chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: UK Moblie Intranet
I know what WAP is. But I want to use a SMS Service. -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: 26 August 2000 21:20 To: [EMAIL PROTECTED] Subject: Re: UK Moblie Intranet do you know about WAP - Original Message - From: "Rif Kiamil" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 26, 2000 11:56 AM Subject: UK Moblie Intranet Dear All, Can any body help. On are Intranet we want to be able to send text message to UK moblie phones. Can somone help ? Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9214 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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.
UK Moblie Intranet
Dear All, Can any body help. On are Intranet we want to be able to send text message to UK moblie phones. Can somone help ? Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9214 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: Big Search Query problem!
If u try running the Drill Down Wizard, From CF Studio and look @ the code it make. Hope this helps -Original Message- From: morris johnston [mailto:[EMAIL PROTECTED]] Sent: 26 August 2000 16:51 To: Cf-Talk Subject: Big Search Query problem! Hi people, I attempting to build a search facility on my site to search a database. At the moment I have a 'search' form consisting of 8 fields (6 select drop down menu choice + 2 text input). The user is allowed to select / input any number of fields for the search criteria. The values are passed to a action template where I have a query to the database with the following format: CFQUERY name="search" datasource="#DB#" SELECT column1,column2,column3,column4,column5column6,column7,column8 FROM table1 !--- 1 WHERE Field1 is filled and ALL other fields empty --- CFIF #field1# IS NOT "" AND #field2# IS "" AND #field3# IS "" AND #field4# IS "" AND #field5# IS "" AND #field6# IS "" AND #field7# IS "" AND #field8# IS "" WHERE field1 = '#column1#' !--- 2 WHERE Field1 AND Field2 are filled and ALL other fields empty --- CFIF #field1# IS NOT "" AND #field2# IS NOT "" AND #field3# IS "" AND #field4# IS "" AND #field5# IS "" AND #field6# IS "" AND #field7# IS "" AND #field8# IS "" WHERE field1 = '#column1#' AND field2 = '#column2#' etc... I have tried to code as many CFELSEIF statements for all the possibilities of field combinations that a user may select and the related fields which they don't select. This is obviously very inefficient coding and I continue to find bugs whenever I choose a combination of fields that I have not taken account of in the above CFESLEIF statements. Are there any suggestions of an alternative to the above CFELSEIF method to deal with the possibility of a search criteria of anything between 1 to 8 fields??? perhaps by putting the field values selected into a List/ Array and looping through it with a SQL statement to look for records where Column name(s) = field name(s) (both have identical names) ignoring columns that have not been selected in the search form? If all this doesn't make sense let me know and I'll try to explain it better :) Regards. Parsman --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.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: excel to SQL
Why use coldfusion, the SQL DTS would be much better -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: 21 August 2000 05:21 To: [EMAIL PROTECTED] Subject: excel to SQL I am interested in getting data from excel format into MSSQL 7 using coldfusion. Anyone already done it? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: server printing
No, not unless you want to write a COM or you can us can COM from MS Access and you can tell that to print any thing from Access. But it you can only use the default printer setup on that system I am writing a Com object in Delphi that will let me print any Access Report from the ColdFusion to any printer on the network. It will also let me send information to Access to fill the report with the data. E.g. You could design a Report in Access with no data in it and then the ColdFusion would send the info to the COM which get the report from access fill the data in the right places in the forum and send it to any print on that computer you want. From Rif -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: 10 August 2000 18:23 To: Cf-Talk Subject: server printing Is there a way with cf (or maybe js) to print from a web app to a printer attached to the cf server or the network it is on? Say, I want to print a document from out of town to the printer on the network for someone to look at or whatever... thanks, je -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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.
Do u us Intranets ?
Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif Kiamil Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: Do u us Intranets ?
But a lot of the application need each other -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:26 To: [EMAIL PROTECTED] Subject: RE: Do u us Intranets ? Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif, Sounds like you need to look in to a design methodology, that allows you to add/remove applications without it affecting other parts of the application as a whole. The method I use (and quite a lot of other CF developers worldwide) is Fusebox. See http://www.fusebox.org/ for more information. Regards Stephen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: Do u us Intranets ?
Yea, but the Intranet is getting to big -Original Message- From: kwasi [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:47 To: '[EMAIL PROTECTED]' Subject: RE: Do u us Intranets ? Do you know how to use the Debugging environment within ColdFusion Studio 4.5. Kwasi Date-Bah System Developer iMediapoint.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: Do u us Intranets ?
We have 100's of forums that are sales people use to do their job. When a form is submitted it is also logged under the Account Log application. But also the Call Sheet application may also log things on the account log. But some of the forums may change setting on the Call Sheets . To u get what I mean -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:46 To: '[EMAIL PROTECTED]' Subject:RE: Do u us Intranets ? Then you should consider using the fusebox method with sub-fuseboxes. By 'need each other' do you mean that there are links to each other or that there is a coding dependency. I would suggest you need to look at what you have designed and remove interdependence if at all possible. Adam Reynolds -- From: Rif Kiamil[SMTP:[EMAIL PROTECTED]] Sent: 07 August 2000 14:19 To: '[EMAIL PROTECTED]' Subject: RE: Do u us Intranets ? But a lot of the application need each other -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 14:26 To: [EMAIL PROTECTED] Subject: RE: Do u us Intranets ? Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif, Sounds like you need to look in to a design methodology, that allows you to add/remove applications without it affecting other parts of the application as a whole. The method I use (and quite a lot of other CF developers worldwide) is Fusebox. See http://www.fusebox.org/ for more information. Regards Stephen -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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. ** 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. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe 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: Do u us Intranets ?
We also add new table to are MSSQL 7 database as well. But we don't change column names and we all most never add new columns to the tables. But the code can change a lot. Does any body run a big intranet? -Original Message- From: Miguel [mailto:[EMAIL PROTECTED]] Sent: 07 August 2000 15:26 To: '[EMAIL PROTECTED]' Subject:RE: Do u us Intranets ? Do you change your databases or your code? Miguel Gonzalez www.ibcmass.com mailto:[EMAIL PROTECTED] -Mensaje original- De: Rif Kiamil [mailto:[EMAIL PROTECTED]] Enviado el: lunes 7 de agosto de 2000 15:01 Para: '[EMAIL PROTECTED]' Asunto: Do u us Intranets ? Importancia: Alta Dear All, We are running an Intranet in Cold Fusion, which is very big and does lots of things. We are looking to update it every 2 - 4 weeks with new applications or make updates of old applications. Basically because of the size of it when you change something or add something it is very hard to check to see if it has affected any other parts of the intranet. Any ideas ? Rif Kiamil Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_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.
NEED HELP Encrypt Url ?
How do I encrypt urls, where do i get info on encrypt urls, just want info on encrypt url Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
uniqueidentifier in SQL and ColdFusion
What problems do people get when using uniqueidentifier as there primey key in MS SQL and Cold Fusion ? Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Encrypt Url
How do I encrypt urls, where do i get info on encrypt urls, just want info on encrypt url Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HTML in MSSQL
Dear All, I have some data in a HTML Table I want to insert this information into MS SQL Server. What is the best way of doing this ? From Rif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFML in a Object Orientated Style
Dear All, Sometime ago, I found a site that show how to write CFML in a Object Orientated Style, but I lost the url. Can body know what I am talking about ? From Rif -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
My Intranet App
Dear All, I am building a intranet, it has 50 apps on it and growing. I have going to let users be a part of groups. I have User 1, Which is in HR Group and Sales Group. The HR Edit Application can only be used by people in the HR Group. Should I program it that Users 1 will have access or will not have access ? From Rif -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe 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: Win2k or NT?
I would wait till SP2 or 3 on Win2K. -Original Message- From: Aaron Powell [mailto:[EMAIL PROTECTED]] Sent: 23 June 2000 17:52 To: [EMAIL PROTECTED] Subject: Win2k or NT? I'm going to be getting a dedicated server for my personal website from Digital Nation very soon (being with Interland is really starting to suck). I'll be buying CF 4.5 and SQL Server 7 and I'm trying to decided if I should go with NT or 2000. I've heard a lot of good things (as well as a lot of bad) about 2k, so I'm curious to hear which people recommend. Thanks. --- Aaron Powell Healthwell.com Web Developer http://www.healthwell.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe 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.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
