RE: Calling all IIS Gurus..

2001-06-02 Thread Rif Kiamil
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

RE: Developers Exchange (Allaire)

2001-05-19 Thread Rif Kiamil
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

RE: Another clustering question (MS SQL 7.0).

2001-05-17 Thread Rif Kiamil
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

RE: Send SMS

2001-05-17 Thread Rif Kiamil
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

RE: CF-Notes database connection

2001-05-17 Thread Rif Kiamil
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/

RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.

2001-04-06 Thread Rif Kiamil
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-17 Thread Rif Kiamil
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

RE: how to retrieve excel data and to put into DB

2001-01-13 Thread Rif Kiamil
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

Name are Intranet !!

2000-12-15 Thread Rif Kiamil
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

RE: Name are Intranet !!

2000-12-15 Thread Rif Kiamil
- 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 S

RE: Order By Question

2000-12-04 Thread Rif Kiamil
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

CF Does not like MSSQL7 @@ROWCOUNT

2000-12-01 Thread Rif Kiamil
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

RE: CF Does not like MSSQL7 @@ROWCOUNT

2000-12-01 Thread Rif Kiamil
al 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

RE: CF Does not like MSSQL7 @@ROWCOUNT

2000-12-01 Thread Rif Kiamil
- 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

RE: access 2000

2000-12-01 Thread Rif Kiamil
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

RE: CF Does not like MSSQL7 @@ROWCOUNT

2000-12-01 Thread Rif Kiamil
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

What Time Zone

2000-11-30 Thread Rif Kiamil
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

RE: RIF Please read concerning Cube

2000-11-23 Thread Rif Kiamil
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

RE: Custom output tag

2000-11-22 Thread Rif Kiamil
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

RE: Is this possible w/CF???

2000-11-20 Thread Rif Kiamil
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

RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

2000-11-17 Thread Rif Kiamil
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:

RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

2000-11-17 Thread Rif Kiamil
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 da

RE: automatic page copying

2000-10-09 Thread Rif Kiamil
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

Client Session variables?

2000-09-29 Thread Rif Kiamil
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

RE: Getting Outlook information - Success

2000-09-29 Thread Rif Kiamil
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:

RE: combining SQL queries

2000-09-29 Thread Rif Kiamil
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

RE: [CF-Talk] Ben Forta's CF_DHTMLMenu

2000-09-20 Thread Rif Kiamil
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

RE: I GIVE UP!

2000-09-13 Thread Rif Kiamil
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

RE: How to Auto downloading of file

2000-09-07 Thread Rif Kiamil
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

RE: CF Server and MS Exchange 2000

2000-09-06 Thread Rif Kiamil
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

RE: CFObjects v FuseBox

2000-09-04 Thread Rif Kiamil
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

RE: CFObjects v FuseBox

2000-09-04 Thread Rif Kiamil
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

CFObjects v FuseBox

2000-09-03 Thread Rif Kiamil
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

RE: CFObjects v FuseBox

2000-09-03 Thread Rif Kiamil
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

RE: Escaping Pound Signs in a CF Query....

2000-09-01 Thread Rif Kiamil
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(#)

RE: CF hangs

2000-08-31 Thread Rif Kiamil
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

RE: SQL

2000-08-30 Thread Rif Kiamil
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

RE: UK Moblie Intranet

2000-08-27 Thread Rif Kiamil
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

UK Moblie Intranet

2000-08-26 Thread Rif Kiamil
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

RE: Big Search Query problem!

2000-08-26 Thread Rif Kiamil
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

RE: excel to SQL

2000-08-21 Thread Rif Kiamil
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

RE: server printing

2000-08-11 Thread Rif Kiamil
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

Do u us Intranets ?

2000-08-07 Thread Rif Kiamil
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

RE: Do u us Intranets ?

2000-08-07 Thread Rif Kiamil
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

RE: Do u us Intranets ?

2000-08-07 Thread Rif Kiamil
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

RE: Do u us Intranets ?

2000-08-07 Thread Rif Kiamil
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

RE: Do u us Intranets ?

2000-08-07 Thread Rif Kiamil
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

NEED HELP Encrypt Url ?

2000-07-14 Thread Rif Kiamil
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

uniqueidentifier in SQL and ColdFusion

2000-07-12 Thread Rif Kiamil
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

Encrypt Url

2000-07-12 Thread Rif Kiamil
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

HTML in MSSQL

2000-07-09 Thread Rif Kiamil
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

CFML in a Object Orientated Style

2000-06-27 Thread Rif Kiamil
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

My Intranet App

2000-06-27 Thread Rif Kiamil
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

RE: Win2k or NT?

2000-06-23 Thread Rif Kiamil
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