Re: cfform format=flash won't render

2006-10-24 Thread Dirk De Bock - Lists
start with upgrading to cf 702, that will solve the active-x warning


- Original Message - 
From: [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, October 24, 2006 9:12 PM
Subject: cfform format=flash won't render


 We recently installed CF 7.  I created a simple page to test Flash Forms. 
 Here is the code, pretty much right out of Ben Forta's book:
 I get a page with a box around it an a tool-tip-like box saying to click 
 to Press SPACE BAR or ENTER to activate and use this control. 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257907
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Recommendations for a mail server...

2006-10-19 Thread Dirk De Bock - Lists
get iMSLite (free)

http://www.coolfusion.com/Commerce/index.cfm?category=7

the relay server will allow you to get your mail off your box


- Original Message - 
From: Russ [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, October 19, 2006 9:44 PM
Subject: RE: Recommendations for a mail server...



 
 My scenario is that I don't provide POP accounts and am trying
 to using SMTP to move mail generated by CF through the mail
 server.
 
 I guess I'm trying to act like an open relay without actually being
 one...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257485
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Database of phone countrycodes?

2006-10-10 Thread Dirk De Bock - Lists
http://www.lincmad.com/countrycodes.html

- Original Message - 
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, October 10, 2006 1:45 PM
Subject: Database of phone countrycodes?


 I'm sorry if this is a duplicate post, but I posted it about 20 hours
 ago now and it still hasn't appeared on the list so I figured
 something must have gone astray somewhere along the way 


 Does anyone know if there's a ready-made, freely downloadable database
 of the countries and the telephone dialing codes for them?   Free
 would be good but could pay a moderate amount if necessary.

 I have an app where i need to match phone numbers to countries of
 residence and one of the things I need to do is check the phone number
 includes the correct country dialing code.



 -- 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256087
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF IIS -- any way to treat .html files as .cfm?

2006-09-02 Thread Dirk De Bock - Lists
you also need to make changes in the coldfusion xml config file to get 
coldfusion to actually process the html files as if they were cfml files

towards the end of the file you find at C:\CFusionMX\wwwroot\WEB-INF\web.xml 
, I added

  servlet-mapping id=macromedia_mapping_14
 servlet-nameCfmServlet/servlet-name
 url-pattern*.html/url-pattern
  /servlet-mapping
  servlet-mapping id=macromedia_mapping_15
 servlet-nameCfmServlet/servlet-name
 url-pattern*.html/*/url-pattern
  /servlet-mapping



- Original Message - 
From: Matt Williams [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, September 02, 2006 6:00 AM
Subject: Re: CF  IIS -- any way to treat .html files as .cfm?


 I'm thinking you can have .html, .htm or even .asp handled by the CF
 server. I could be way off, but go to IIS, WebSite, Properties,
 HomeDirectory, Configuration.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251836
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF IIS -- any way to treat .html files as .cfm?

2006-09-02 Thread Dirk De Bock - Lists
http://www.talkingtree.com/blog/index.cfm/2006/2/17/CF-Custom-File-Extensions

- Original Message - 
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, September 02, 2006 8:34 AM
Subject: Re: CF  IIS -- any way to treat .html files as .cfm?


 No sure you even have to do this, will have to check. All you should need 
 to
 do is add\modify IIS to throw htm files to the jrun.dll. 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251840
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Declaring SQL variables

2006-06-23 Thread Dirk De Bock - Lists
without testing:

I think the into only takes the name of the (new) table

If you need to change the column names you could try it like this:

SELECT SiteAreaName as DeletedAreaName, Lft as DeletedLft , Rgt as 
DeletedRgt
INTO   DeletedArea
FROM   directoryLinks
WHERE  SiteAreaName = '#ARGUMENTS.SiteAreaName#'



- Original Message - 
From: Richard Cooper [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, June 23, 2006 12:39 PM
Subject: CF  Declaring SQL variables


 Hi all,

 I've a section of query I'm trying to run, I've tried lots of different 
 ways to write it but have had no success yet

 Does anyone know how this query should be written:

 [code]

 cfquery name=breadcrumb datasource=#REQUEST.theDatabase#
 !---SELECT the values for the Deleted level into variables---
 DECLARE DeletedAreaName VARCHAR(50);
 DECLARE DeletedLft INTEGER;
 DECLARE DeletedRgt INTEGER;

 SELECT SiteAreaName, Lft, Rgt
 INTO   DeletedAreaName, DeletedLft, DeletedRgt
 FROM   directoryLinks
 WHERE  SiteAreaName = '#ARGUMENTS.SiteAreaName#'
 /cfquery

 [/code]

 Thanks,

 Richard

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244616
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Only update DB if data has changed?

2006-05-26 Thread Dirk De Bock - Lists
one way would be to build a string of all elements of 1 field, get the hash 
of this string and include that as a hidden field, then you do the same for 
the posted info and compare both hash strings

- Original Message - 
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, May 26, 2006 11:14 AM
Subject: RE: Only update DB if data has changed?


 Should be easy enough and no doubt several way s to achieve thisboth 
 in
 CF Code and in SQL.  One way would be to load the records at page load 
 into
 a structure and then on submit comparing both the pre-edited and post 
 edited
 form struct to see what has changed etc...



 -Original Message-
 From: Andy Mcshane [mailto:[EMAIL PROTECTED]
 Sent: 26 May 2006 10:25
 To: CF-Talk
 Subject: Only update DB if data has changed?

 Hi all, does anybody have any ideas how I could best implement the
 following;

 I have a page that loads anything up to about 30 individual records at a
 time. Each record consists of 17 fields of data. All the records are
 displayed on the page to give the user the option of editing any 
 individual
 field. When the user then submits the page I need to be able to work out
 which records have had data changed and only do database updates for those
 specific records. Having an individual submit for each record is not an
 option, the whole page must be submitted as one but only records that have
 changed should be updated. Can anybody suggest a method for doing this?



 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241548
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: determine SQL Server Version via Ent Mngr

2005-12-20 Thread Dirk De Bock - Lists
SELECT SERVERPROPERTY('ProductVersion');





- Original Message - 
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, December 20, 2005 8:26 PM
Subject: OT: determine SQL Server Version via Ent Mngr


 Can anyone point me to a way that I can determine the version of a remote 
 SQL Server database via Enterprise Manager?

 TIA

 Cheers

 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 phone: 250.480.0642
 fax: 250.480.1264
 cell: 250.920.8830
 e-mail: [EMAIL PROTECTED]
 web: www.electricedgesystems.com

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227360
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL Server 2005 and CF?

2005-11-27 Thread Dirk De Bock - Lists
I think the driver class name should be

com.microsoft.sqlserver.jdbc.SQLServerDriver

if you drop the jar in the cf lib dir you do not need to change the 
classpath

- Original Message - 
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, November 27, 2005 1:36 PM
Subject: SQL Server 2005 and CF?


 OS: WinXP Professional (SP2)
 CF: CFMX 6.1 Professional
 DB: SQL Server 2005 Express

 Having issues getting a DSN set up (without resorting to ODBC via the
 OS).  Anybody successfully gotten this working?

 I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
 http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.

 Installed to C:\Program Files (the default install).

 In the CF Administrator, under datasources, I entered the datasource
 name ('comix'), and selected 'Other' for Driver.

 Here are the settings that I've tried on the screen that followed:

 JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
 Driver Class: com.microsoft.sqlserver.jdbc
 Driver Name: com.microsoft.sqlserver.jdbc

 Error message is:
 Connection verification failed for data source: comix
 []java.sql.SQLException: No suitable driver available for comix,
 please check the driver setting in resources file, error:
 com.microsoft.sqlserver.jdbc
 The root cause was that: java.sql.SQLException: No suitable driver
 available for comix, please check the driver setting in resources
 file, error: com.microsoft.sqlserver.jdbc

 I've found bits and pieces of information that are almost relevant,
 but none that are 100%. For example:

 Kola Oyedeji has a blog posting that discusses  JDBC logging with
 P6spy and CFMX.  Not relevant to SQL Server 2005 (or any version of
 SQL Server), but had some good info about JDBC drivers.
 (http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/+meaning+of+bloghl=en)

 MM themselves have a tech note, but it's regarding SQL Server 2000, not 
 2005.
 (http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)

 I also looked at the documentation that came with the driver.  The
 settings that I've posted above are kind of an amalgam of what I was
 able to glean from the 3 sources combined.

 Oh...the other variable in the equation is the classpath.

 I've tried:
 C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
 C:\Program Files\Microsoft SQL Server 2005 JDBC
 Driver\sqljdbc_1.0\enu\sqljdbc.jar
 F:\CFusionMX\lib\sqljdbc.jar

 the first two were the location of the jar file by the default driver
 installation (tried both with and without the filename itself).  The
 last was due to a suggestion that Kola had made regarding placing the
 jar file in the CFusion\lib directory (I copied the file over
 over...wasn't sure if that would require a classpath variable, but
 figured it wouldn't hurt to try).  CFMX service was cycled after each
 time I modified the classpath var.

 Been at this for a while, and really ready to give up and take a nap
 (it's 7:30 am Sunday morning).  Anybody have any info they can share?

 Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)

 Thanks

 --
 Charlie Griefer

 
 ...All the world shall be your enemy, Prince with a Thousand Enemies,
 and whenever they catch you, they will kill you. But first they must catch
 you, digger, listener, runner, prince with a swift warning.
 Be cunning and full of tricks and your people shall never be destroyed.

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225326
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfchart not working on new server

2005-06-10 Thread Dirk De Bock - Listclient
Regarding the video drivers mentioned before, it used to be you needed to 
have an driver installed capable of at least 256 colors. I guess that still 
stands for CF7. 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Pollster 2.0

2005-05-10 Thread Dirk De Bock - Listclient
It would seem that the Flash Remoting gateway is not enabled, did you 
verify this?

- Original Message - 
From: Dan Thatcher [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, May 10, 2005 7:36 PM
Subject: Pollster 2.0


 Hello,

 Anyone in here been successful at getting pollster 2.0 to work? 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206233
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Pollster 2.0

2005-05-10 Thread Dirk De Bock - Listclient
that would indeed be a good indication
now you would have to check the application.cfm file of pollster to make 
sure that the path(s) are set up correctly so that the remoting can actually 
find the cfc

- Original Message - 
From: Dan Thatcher [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, May 10, 2005 8:26 PM
Subject: RE: Pollster 2.0


 Yeah I tried looking into the Flash remoting gateway by going to:
 www.yourserver.com/flashservices/gateway.  I read that if it is running
 - I should receive a blank page.  I received a blank page.  So I believe
 that flash remoting is enabled. 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206243
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Save web page

2005-04-25 Thread Dirk De Bock - Listclient
you need to use cfhttp ... rather than cflocation for this to work

you don't need the cfsavecontent when using cfhttp

the exact syntax depends on the version of CF so please check you manual

- Original Message - 
From: Robert Orlini [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, April 25, 2005 6:01 PM
Subject: Save web page


 IS there a way to save the content of a web page using cfsavecontent?

 Here's my script:

 cfsavecontent variable=intro

 CFLocation url=http://www.mypage.com;

 /cfsavecontent

 cfoutput#intro#/cfoutput

 Would I be able to search #intro# for certain text? Or is there a better 
 way? Sorry but this is new to me.

 Robert O.

 -- 
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204281
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Server recommendations

2005-03-16 Thread Dirk De Bock - Listclient
no

- Original Message - 
From: Eric Creese [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, March 16, 2005 9:50 PM
Subject: RE: Server recommendations


I am running Win2k IIS 5. I really do not want to change OS right now but 
would like to Upgrade from IIS5 to IIS6. Is this possible? 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199024
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


GIS solution UK

2005-02-08 Thread Dirk De Bock - Listclient
I'm looking for pointers to GIS mapping for the UK to interface with cold 
Fusion.

Any recommendation anyone?

Thanks


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193666
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Finding On Bits in a Number

2005-02-07 Thread Dirk De Bock - Listclient
cfif bitand(session.key,4) it is set/cfif

someting like that should work



- Original Message - 
From: Dawson, Michael [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, February 07, 2005 5:37 PM
Subject: Finding On Bits in a Number


 There is not much out there on bitwise operators in ColdFusion.

 Let's say I have an integer that stores certain authorization
 information such as:

 1 = Read-Only User
 2 = Security Administrator
 4 = Report Creator
 8 = Report Administrator

 All these items add up to 15.  I want to know if the bit for Report
 Creator is set so I can grant access to that section of a web site.

 How can I tell if the 4 (third) bit is on?

 Thanks
 MAD


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193400
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: DevNet Version of CFMX adds rubbish to the start of my HTML.

2004-11-17 Thread Dirk De Bock - Listclient
maybe just a cfcontent reset=true will do the trick

- Original Message - 
 META NAME=ColdFusionMXEdition CONTENT=ColdFusion DevNet
 Edition - Not for
 Production Use.

 The MM site says use cfcontent to make the file text/xml but then it does
 not
 work in a browser and I need to have both.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184668
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: MX sql driver issues

2004-11-15 Thread Dirk De Bock - Listclient
apart from reviewing the cf code you may want to look into the jTDS drivers 
available from
http://jtds.sourceforge.net/
they are regarded as considerably more stable and also more performant than 
microsoft's own offering


- Original Message - 
From: Lawrence Ng [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, November 15, 2004 8:37 PM
Subject: MX sql driver issues


 hello there,

 I came across this over the weekend with a fellow developer over the
 weekend...

 Have any of you experienced any issues simliar to this with the JDBC
 driver with SQL 2000 server?

 1. Two weeks ago, they switched over to MX and it bombed under load -
 it was producing constant sql deadlocks.  They believe they were able to
 track down the problem with some stored procedures - why would this
 issue cropped up in MX and not in CF5. Is it because MX is not as
 forgiving as CF5?

 2.   Then another major error occurred:

 Operation failed on the data source named whatever5sql. Reason of
 failure

 [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not
 be prepared.


 This has happened twice and it required the services to be restarted.
 It has been frustrating for the developer and the users.  Management
 that MX was faster and more stable to justify buying it.  They had to
 rollback to CF5 once and the developer doesn't want switch back at this
 time, otherwise the company just wasted $1500 (CDN).

 thoughts?

 thank you.





 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184309
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: MX not working on win2003

2004-11-08 Thread Dirk De Bock - Listclient
You should check the web service extensions and make sure the macromedia 
server extensions are enabled


- Original Message - 
From: Phill B [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, November 08, 2004 6:20 PM
Subject: Re: MX not working on win2003


 The files are there but I'm getting a 404. I read some where that IIS
 6 will give a 404 for unknown mime types. Does that sound right? 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183638
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Dreamweaver coding font

2004-11-07 Thread Dirk De Bock - Listclient
Andale Mono is quite nice, it used to be available for free in the TrueType 
core font library from Microsoft
http://www.eu.microsoft.com/truetype/fontpack/win.htm
but if you look around you should be able to find it 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183589
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Switching domains with IIS

2004-10-18 Thread Dirk De Bock - Listclient
Redirect Variables
You can use redirect variables to pass portions of the original URL with the destination URL. To use these variables, open a directory's properties in IIS Manager, select the Home Directory, Virtual Directory, or Directory tab, click the A redirection to a URL option, and enter a URL in the Redirect to text box, using any of the variables below.

$V Passes the requested URL, without the server name. For example, if the original URL is //Myserver/Scripts/Myscript.asp, the string /Scripts/Myscript.asp is mapped to the destination URL. 

That should let you do what you want, it's all explained in the iis6 help and administrator guides

- Original Message - 
From: Rick Root 
To: CF-Talk 
Sent: Monday, October 18, 2004 9:04 PM
Subject: Re: OT: Switching domains with IIS

Stephen Moretti (cfmaster) wrote:
 Rick Root wrote:
 
 Hi folks.. We are going to be changing our fully qualified domain name
 from www.ads.duke.edu to www.it.dev.duke.edu ... Right now, you can use
 both domains but the url doesn't change... I'd like for *ALL* requests
 to www.ads.duke.edu to be re-written to www.it.dev.duke.edu so that
 we are consistent in our use of the new domain.. but we don't want to
 screw up people's bookmarks...

 We're using IIS 6.0
 
 Just create a new site for the old domain that redirects to the new
 domain.This can all be done in IIS - the redirect is under the home
 directory settings.

No, that doesn't work, just tried it.

It doesn't redirect requests for specific pages... to test, I set up a 
hosts entry to point www.foo.ads.duke.edu to 152.3.224.202

Then,

http://www.foo.ads.duke.edu/ successfully redirects to the new domain.
But accessing specific pages doesn't ie there is no domain rewrite 
if I go to http://www.foo.ads.duke.edu/_main/reports_intro.cfm

 - Rick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: BARCODES in CF

2004-10-05 Thread Dirk De Bock - Listclient
http://www.webcaterers.com/barcodes/

- Original Message - 
From: Ciliotta, Mario 
To: CF-Talk 
Does anyone know of any good barcode generators that work with CFMX.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Regex help

2004-09-14 Thread Dirk De Bock - Listclient
This is working ok in CF5 but apparently not in CFMX

Malformed regular _expression_ \[[^\]*\]. 
Reason: Unmatched [] in _expression_.. 

REReplace(ThisTag.GeneratedContent, \[[^\]*\], , All)

it's supposed to strip all [] with everyting inbetween the brackets
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Now I'm in a fix. Which DB?

2004-09-13 Thread Dirk De Bock - Listclient
Get this one:
http://www.microsoft.com/sql/msde/downloads/download.asp

Basicly mssql without the licensing cost (and without some management tools)
You can use access as the frontend with this one and upgrading your access db to sql is mostly painless

- Original Message - 
From: Richard Meredith-Hardy 
To: CF-Talk 
Sent: Monday, September 13, 2004 10:16 AM
Subject: Now I'm in a fix. Which DB?

Dear all

I should have asked this question before I got to this stage:

Intranet; Win2k / CF5

Which DB should I use?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfchart, flash, and https

2004-09-11 Thread Dirk De Bock - Listclient
workaround (not tested)

capture the cfchart output between cfsavecontent tags and do a replace on http:
- Original Message - 
From: Douglas Knudsen 
To: CF-Talk 
Sent: Friday, September 10, 2004 10:33 PM
Subject: cfchart, flash, and https

Ok, read some stuff on this alread.When cfchart is used with
format=flash the follwing code is auto generated

OBJECT classid="">
codebase="">
ID=Images_14_SWF name=Images_14_SWF WIDTH=320 HEIGHT=240
PARAM NAME=movie VALUE=/CFIDE/GraphData.cfm?graphID=Images/14.SWF
PARAM NAME=quality VALUE=high
PARAM NAME=bgcolor VALUE=#FF
EMBED src="">
quality=high bgcolor=#FF WIDTH=320 HEIGHT=240
TYPE=application/x-shockwave-flash
PLUGINSPAGE=http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash
/EMBED
/OBJECT

Now we run HTTPS on our site.The above causes IE to do teh security
warning and all.Anyone found a way to mod the output above to use
HTTPS instead?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Updater Installation error

2004-09-11 Thread Dirk De Bock - Listclient
It seems one of the files is locked by some user process, take note of what directory the installer complains about and try to rename that directory, that may very well clear it up

- Original Message - 
From: Dave Watts 
To: CF-Talk 
Sent: Saturday, September 11, 2004 4:08 PM
Subject: RE: Updater Installation error

 I do stop all 3 services when instructed to do so.Once I even
 stopped them before I started any part of the installation.Is that
 what you mean?

Yes, that's what I meant, but since that didn't solve your problem I'd
recommend that you set the CF service not to automatically start, reboot
your computer, and try again.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: (Admin) Support drive

2004-06-16 Thread Dirk De Bock - Listclient
I am happy to contribute (a small amount)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: DSN Connection issue

2004-05-31 Thread Dirk De Bock - Listclient
you must set the MS SQL security to mixed mode, use the sql enterprise manager to verify/change this.
- Original Message - 
From: Eric Creese 
To: CF-Talk 
Sent: Sunday, May 30, 2004 10:31 PM
Subject: Re: DSN Connection issue

ok I did this but got the same results as a user connection.I I use SQL username/password it has an error with a trusted connection if I use WindowsNt default then it works. However in the CF Admin it wants a username/password o I try a SQL username password for that db and it fails.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Form button

2004-05-04 Thread Dirk De Bock - Listclient
the form element will indeed be form.C1.X (and also form.C1.Y)
the value passed will be the x and y coordinates (ie where exactly the user clicked on the button) so you will never see 'update' as the value of that form element

- Original Message - 
From: Semrau Steven Ctr SAF/IE 
To: CF-Talk 
Sent: Tuesday, May 04, 2004 9:44 PM
Subject: RE: Form button

Well, let's see IsDefined(form.C1.X) and form.C1 EQ update

First off I'd say just try adding .X 

to form.C1 EQ update--form.C1.X EQ update.

Steven Semrau
SRA International
http://www.sra.com

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 3:24 PM
To: CF-Talk
Subject: Form button

I have an image as a form button as: 
input type=image src="" name=C1 value=update

In my CF code pressing this button should execute an update, however the following code generates an error:

CFIF IsDefined(form.C1.X) and form.C1 EQ update

Cold Fusion Server logged the following error information:
An error occurred while evaluating the _expression_: 
IsDefined(form.C1.X) and form.C1 EQ update
Error near line 1, column 29. 
Error resolving parameter FORM.C1 
The specified form field cannot be found. 

Am I missing something here?

Thanks.

Robert O.
HWW 
 _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Yet another OT Mail Relay move question

2004-02-06 Thread Dirk De Bock - Lists
What pending mail? Incoming or outgoing? You should be able to run the two mailservers simultaneously if you make sure to use different ports. 
That way you can have the postoffice server available on nonstandard ports so that people can still retrieve their old mail.
- Original Message - 
From: Alan Rafael Bleiweiss 
To: CF-Talk 
Sent: Friday, February 06, 2004 7:11 AM
Subject: Yet another OT Mail Relay move questionDoes anyone have any experience in how to move pending email
to the new server?(I've got fifty virtual domains...)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Looking for work around for an error

2004-01-26 Thread Dirk De Bock - Lists
I would set up an extra access database that has linked tables to the original database, use the one with the linked tables as your datasource. The other one will not be locked and you can muck with it as you wish. Performance in my experience is not impacted.
- Original Message - 
From: Mickael 
To: CF-Talk 
Sent: Monday, January 26, 2004 3:35 PM
Subject: Looking for work around for an error

Hello All,

I have an issue with one of my apps using Access.The database that we are using is created on a machine in our network then sent via FTP to the webserver in a Zipped file.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Need help with Batch file

2004-01-08 Thread Dirk De Bock - Lists
I think you can issue the 'prompt' command before the mget, this enables or disables prompting for an mget download

so something like

username
password
cd Custom extracts\ ourfolder 
lcd \inetpub\wwwroot\project\files
prompt
mget p_mth_choice*.zip y
quit

good luck
- Original Message - 
From: Mike Kear 
To: CF-Talk 
Sent: Thursday, January 08, 2004 8:39 AM
Subject: OT: Need help with Batch file

Here's one for some of you older fellas, who still remember DOS: 

I needsome help with a batch file for using FTP.(I can't use CFFTP,
because it fails at the change to directory - the directory we want includes
a space in the name and no matter how I try it won't include the space as
part of the name) 

The commands I'm having trouble with is the get or mget.I don't know the
exact file name I need to retrieve because it contains the date.The
filename will always be in the form: p_mth_choice_mag_ddmmm_nn.zip
where dd is the date, mmm is the month,  is the year, and nn is a
serial number of some sort.So I was hoping to have the ftp file use get or
mget to retrieve p_mth=choice*.zip.

When I do this using manual commands,get doesn't work because it doesn't
support wildcards, but mget does.However mget wants a y confirmation for
each file.How to I put in the batch file to answer Y?

Here's the batch file I've written so far:

ftp -d -s:C:\Inetpub\wwwroot\project\ftpconfig.txt ftp.comain.com.au 

And the ftpconfig.txt file contains the following:

username

password

cd Custom extracts\ ourfolder 

lcd \inetpub\wwwroot\project\files

mget p_mth_choice*.zip y

quit

But this fails because it hasn't got any Y response to the prompt.I know
there's a way to have the batch file submit the Y to the script but I'm at
a block.Can't remember how to do it, and my old DOS manuals went in the
recycle bin years ago.

Can anyone help?

Cheers

Mike Kear

Windsor, NSW, Australia

AFP Webworks

http://afpwebworks.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: HTTP Response codes

2004-01-05 Thread Dirk De Bock - Lists
cfheader statuscode=606
would probably do what you want?

- Original Message - 
From: Howie Hamlin 
To: CF-Talk 
Sent: Monday, January 05, 2004 5:57 PM
Subject: HTTP Response codes

Can ColdFusion be forced to send a particular HTTP response code?For an application that I have I need to send a 606 response when an error occurs.

Thanks,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
 Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
 Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: If Image Exist...

2003-11-25 Thread Dirk De Bock - Lists
One way is to use your webserver functionality:

asiign a default image to the 404 error for that particular directory, if the webserver is asked for a noexistant image it will serve up the default image.
- Original Message - 
From: Bailey, Neal 
To: CF-Talk 
Sent: Wednesday, November 26, 2003 12:21 AM
Subject: If Image Exist...
Is there a way to check if image exist in CF? I have some image names in
the database that are pointing to an image that does not exist. Therefore I
get the little red X in IE. I would like to instead display and alternate
image. 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Eolas patent suit

2003-10-27 Thread Dirk De Bock - Lists
On the other hand, it seems that automatically downloading images, and I guess by extension other 'rich' content is disabled by default in outlook 2003, which will be a major headeache for everyone sending out newsletters.
- Original Message - 
From: Christian Cantrell 
To: CF-Talk 
Sent: Saturday, October 25, 2003 9:12 PM
Subject: Re: Eolas patent suit

On Friday, October 24, 2003, at 12:03 PM, Jeff Beer wrote:

 My livelihood comes
 from developing and delivering flash-based newsletters and promotions 
 in
 e-mail.When this change goes into effect, we're either out of 
 business
 or facing the loss of our primary product.

You don't have anything to worry about, Jeff.Users who have enabled 
ActiveX controls in Outlook will not be prompted before the Flash 
player and other ActiveX controls are loaded.Microsoft confirmed that 
since Outlook is not considered a browser, the upcoming changes to 
Internet Explorer will not affect it.

Christian


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: DataDirect JDBC drivers (shipped with CFMX)..

2003-10-27 Thread Dirk De Bock - Lists
Yes, copy the jar files to the cfmx lib directory, that's the simplest (restart CFMX in order to load the drivers)

Then, when setting up your datasource, use the type 'other'
and use the values you find here:

JDBC URL:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yourDatabaseName

Driver Class:
com.microsoft.jdbc.sqlserver.SQLServerDriver

Driver Name: any name but I use
SQLServerDriverJDBC

- Original Message - 
From: Nathan Strutz 
To: CF-Talk 
Sent: Friday, October 24, 2003 8:48 PM
Subject: RE: DataDirect JDBC drivers (shipped with CFMX)..

Joe, Robert, anyone...

I've decided to give the MS JDBC drivers a go. What's the procedure for
installing them to make CF use the Microsoft drivers over the DataDirect
ones? I would imagine copying the jar files to the cfmx\lib folder would be
a start...?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Add or Multiply as a Variable - Question Repharased

2003-10-23 Thread Dirk De Bock - Lists
You could maybe provide two fields in the database, one for multiply/divide (default to 1) and one for add/substract (default to 0), and just perform both operations, if the values are at default the result is unchanged

- Original Message - 
From: Les Mizzell 
To: CF-Talk 
Sent: Thursday, October 23, 2003 6:02 AM
Subject: Re: Add or Multiply as a Variable - Question Repharased

Michael T. Tangorre wrote:

 why would you want to do this?

 For:
 
 #DollarFormat(ST_100.DIST_COST * ADJUST.ADJUST100)#
 
 How would I make the Arithmetic _expression_ *a variable from the
 database..

I know I can do this with a switch of if structure, but I'm really 
curious if there *is* a way to do it with just the one line of code...

-- 
Les Mizzell
-
Mihi placent, O Pincerna!
 Virent ova! Viret perna!
 Dapem posthac non arcebo.
 Gratum tibi me praebebo.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SQL Assistance

2003-10-23 Thread Dirk De Bock - Lists
Join twice on the user table and differentiate by an alias

select newsID, 
c.firstName creatorFirstName, c.lastName creatorLastName,
u.firstName updaterFirstName, u.lastName updaterLastName
from tbl_news n 
join tbl_user c on n.creatorID = c.userID
join tbl_user u on n.updaterID = u.userID

- Original Message - 
From: Tangorre, Michael 
To: CF-Talk 
Sent: Thursday, October 23, 2003 2:31 PM
Subject: OT: SQL Assistance

I have two tables: tbl_user and tbl_news

In the tbl_user table I have 3 columns (among others): userId, firstName,
lastName

In tbl_news I have two columns (among others): creatorId, updaterId both of
which relate back to the tbl_user table.

In a query, how would I get the first name and last name of both the creator
and updater?

I can JOIN and get one, but how to you differentiate between the creator and
updater names when joining?

Thanks!

Mike

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Grouped cfoutput

2003-10-20 Thread Dirk De Bock - Lists
cfoutput query=yourqueryname group=phaseName
br#phasename#br
cfoutput
- #milestoneName#br
/cfoutput
/cfoutput

should be close enough
- Original Message - 
From: Tangorre, Michael 
To: CF-Talk 
Sent: Monday, October 20, 2003 3:25 PM
Subject: Grouped cfoutput

I have a query whose result set looks like this:

phaseId | phaseName | milestoneId | milestoneName
--
1phase11 name1
1phase12 name2
1phase13 name3
2phase24 name4
2phase25 name5
2phase26 name6
3phase37 name7
3phase38 name8
3phase39 name9

I am trying to output the query so that in a table I can get the output to
look like:

Phase1
---name1
---name2
---name3

Phase2
---name4
---name5
---name6

Phase3
---name7
---name8
---name9

The query I am using is as follows:

SELECT
P.phaseId,
P.phaseName,
M.milestoneId,
M.nilestoneName
FROM
milestone M
INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId)
ORDER BY
P.phaseName

How do I setup the cfoutput tags with the query and group attributes set to
obtain the output I described above..

Thanks!

Mike

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: default.ida?

2001-08-03 Thread Dirk De Bock

To find that entry in your logs does not mean that you're infected
obviously.

- Original Message -
From: Edward Chanter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 3:13 PM
Subject: RE: default.ida?


  -Original Message-
   I keep seeing on the log files some default.ida request.
   are those hacking attempts? what is this file do?


 YOU ARE INFECTED WITH CODE RED

 Please shut down your IIS, patch it and then restart!


 best wishes,

   -= Ed


 If you want others to be happy, practice compassion.
 If you want to be happy, practice compassion.
 ~The 14th Dalai Lama

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Unicode

2001-02-06 Thread Dirk De Bock

No unicode support in CF5, that is what Ben told us today.

- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
  see if Cold Fusion has support for Localization, I'm sure it will
 It's something that they're "aiming for" in CF5, but it might be in CF6...



~~
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



select and flag records

2000-12-15 Thread Dirk De Bock

I have a table with a big number of email addresses. I want to send out mail
in batches of 1000. For this I need to select the top 1000 records where a
flag is false, and then set this flag to true so I won't select them for the
next batch.

Can this be done in one query, maybe with a stored procedure, or do I have
to do this with two queries wrapped in a cftransaction?


~~
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 SP2 + Win2k/Memory Leaks

2000-12-04 Thread Dirk De Bock

Asking if they're using ODBC or OLE/DB is not entirely moot since the ODBC
interface does perform a translation of the query most notably in the date
formats and similar things. There are definitely queries that work in ODBC
and not in OLEDB.


- Original Message -
From: "Zachary Bedell" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, December 04, 2000 5:05 PM
Subject: RE: CF SP2 + Win2k/Memory Leaks


 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Could I just add one niggling little detail to this thread?  I know
 it's a small thing, but...

 If ever someone's having a problem with Microsoft SQL Server 7.0 (and
 I presume 2000 is the same), asking if they're using ODBC or OLE/DB
 is rather moot.

 SQL Server's internal API *is* OLE/DB.  Even if you're using ODBC to
 access it, the ODBC driver just translates your calls to OLE/DB and
 passes them on to the SQL Server.


~~
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: Netscape 6 out UGH!!!!

2000-11-15 Thread Dirk De Bock

there is a 25 meg file at

ftp://ftp.netscape.com//pub/netscape6/english/6.0/windows/win32/sea/N6Setup.
exe

that should be the full install as far as I can tell


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



radius server

2000-11-03 Thread Dirk De Bock

Is anyone interfacing CF with a radius server for authentication? I am aware
of the cfx_radauth tag by [EMAIL PROTECTED] but I could not get it to work
properly with RadiusNT.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: Storing passwords in database as one way hash

2000-10-18 Thread Dirk De Bock

Show us the code! :-)

Or more politely, I'd love to have a look a that. Is this javascript code
publicly available?

Of course the effect is that the hash is sent across the wire instead of the
clear text password, so it could still be sniffed I guess.

- Original Message -
From: "BORKMAN Lee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, October 18, 2000 1:57 AM
Subject: RE: Storing passwords in database as one way hash


 Hi all,

 You can do better than hashing on the server side.  I use a JavaScript MD5
 hash on the client-side.  This prevents the password being sent over the
 network in clear, and alleviates the need for SSL in some circumstances.

 Works like a dream.

 Lee (Bjork) Borkman
 http://bjork.net ColdFusion Tags by Bjork





 IMPORTANT NOTICE:
 This e-mail and any attachment to it is intended only to be read or used
by
 the named addressee.  It is confidential and may contain legally
privileged
 information.  No confidentiality or privilege is waived or lost by any
 mistaken transmission to you.  If you receive this e-mail in error, please
 immediately delete it from your system and notify the sender.  You must
not
 disclose, copy or use any part of this e-mail if you are not the intended
 recipient.  The RTA is not responsible for any unauthorised alterations to
 this e-mail or attachment to it.
 --
--
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: File replication packages

2000-10-17 Thread Dirk De Bock

WebAgain seems to behave quite nicely at a few sites I manage. It can
replicate both through netbios shares and ftp which gives it the flexibility
to also replicate to remote sites.

- Original Message -
From: "Mark Johnson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 12:15 PM
Subject: OT: File replication packages


 Those of you using server farms and or loadbalancing.  How do you publish
 your CF files to all your servers?  What software are you using to
acomplish
 this?  What should we aviod in implementing a file replication package.

 Mark Johnson
 ---
 Senior Cold Fusion Developer
 Cardinal Communications

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe 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: File replication packages

2000-10-17 Thread Dirk De Bock

did you try http://www.webagain.com/

also google gives 8 valid links in the first 10 links it returns :-)

the company website is at www.lockstep.com

but sorry for not providing a direct link in the first mail

- Original Message - 
From: "Paul's Mail" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 11:33 PM
Subject: RE: File replication packages


 Where can I find the WebAgain web site? My search turned up nothing.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe 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: Netscape? Code Included

2000-10-05 Thread Dirk De Bock

where's the /table ?

- Original Message -
From: "HappyToad.com" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, October 05, 2000 6:55 PM
Subject: RE: Netscape? Code Included


 OK This form works fine in IE 5.5 but gets cut off right below h3 in
 Netscape:

   HTML
  HEAD
  cfquery name="get_states" datasource="ibtoad"
  SELECT state_ab FROM states
  /cfquery
  cfquery name="get_countries" datasource="ibtoad"
  SELECT country_name FROM countries
  ORDER by country_name
  /cfquery
   TITLEStore Registration/TITLE
   /HEAD
   BODY
 H1 align="center"Store Registration/H1
 !---Registration Form---
  p align="center"bTo start shopping please register below:/b
 CFFORM ACTION="registration_action.cfm?#client.urltoken#" METHOD="post"
 table align="center"
 tr
 tdbUser ID:/b/td
 tdCFINPUT TYPE="text" NAME="user_id" Required="yes"/td
 /tr
 tr
 tdbPassword:/b/td
 tdCFINPUT TYPE="password" NAME="password" Required="yes"/td
 /tr
 tr
 tdbEmail Address:/b/td
 tdCFINPUT TYPE="text" NAME="email_address" Required="yes"/td
 /tr
 tr
 tdbFirst Name:/b/td
 tdCFINPUT TYPE="text" NAME="first_name" Required="yes"/td
 /tr
 tr
 tdbLast Name:/b/td
 tdCFINPUT TYPE="text" NAME="last_name" Required="yes"/td
 /tr
 tr
 td bAddress:/b/td
 tdCFINPUT TYPE="text" NAME="street_address" Required="yes"/td
 /tr
 td bCity:/b/td
 tdCFINPUT TYPE="text" NAME="city" Required="yes"/td
 /tr
 tr
 td bState:/b/td
 tdselect name="state"
 cfoutput query="get_states"
 option
value="#state_ab#"#state_ab#/option/cfoutput/selectbr/td
 /tr
 tr
 tdbZip Code:/b/td
 tdCFINPUT TYPE="text" NAME="zip" size="5" Validate="zipcode"
 Message="Please enter a valid Zip Code."/td
 /tr
 tr
 tdbCountry:/b/td
 tdselect name="country"
 cfoutput query="get_countries"
 option
 value="#country_name#"#country_name#/option/cfoutput/select/td
 /tr
 tr
 td INPUT TYPE="submit" Value="Register"/td
 /tr
 /CFFORM

 /BODY
 /HTML

 -Original Message-
 From: Gavin Myers [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 05, 2000 12:02 PM
 To: CF-Talk
 Subject: RE: Netscape?


 can you copy/paste the source? that may make it easier to find a problem

 -Original Message-
 From: HappyToad.com [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 05, 2000 9:21 AM
 To: CF-Talk
 Subject: RE: Netscape?


 OK explain this. The form works when I use it as a CFINCLUDE but not on
its
 own.  I can't figure it out.
 Rich

 -Original Message-
 From: James Taavon [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 05, 2000 10:08 AM
 To: CF-Talk
 Subject: Re: Netscape?


 This is a multi-part message in MIME format.
 --9F438ACC8159EB2C0B77E0AA
 Content-Type: text/plain; charset=us-ascii
 Content-Transfer-Encoding: 7bit

 It must be your code.

 I got cfform running using both IE and Netscape.

 "HappyToad.com" wrote:
 
  Is there something wrong with my code or does Netscape not recognise
  CFFORM?
 
  Rich
 --9F438ACC8159EB2C0B77E0AA
 Content-Type: text/x-vcard; charset=us-ascii;
  name="jtaavon.vcf"
 Content-Transfer-Encoding: 7bit
 Content-Description: Card for James Taavon
 Content-Disposition: attachment;
  filename="jtaavon.vcf"

 begin:vcard
 n:Taavon;James
 tel;cell:(443) 506-2117
 tel;fax:(410) 333-5203
 tel;work:(410) 767-3415
 x-mozilla-html:FALSE
 org:Department of Labor, Licensing and Regulation;Office of Information
and
 Technology
 version:2.1
 email;internet:[EMAIL PROTECTED]
 title:Senior Web Developer
 adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom
 203;Baltimore;MD;21201;
 fn:James Taavon
 end:vcard

 --9F438ACC8159EB2C0B77E0AA--

 --
--
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --
--
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --
--
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: 

Re: Need a good dynamic bar pie chart app...

2000-09-05 Thread Dirk De Bock

The slickest looking charts I've seen came from
http://chronoweb.chartsoft.com/
but I can't say I have any experience using them in a CF environment.

- Original Message -
From: "Roberts, Jesse D" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 05, 2000 10:20 PM
Subject: RE: Need a good dynamic bar  pie chart app...


 The pricing is pretty good.  You can view it all on their site
 http://www.corda.com/pricing.cfm. The standard server costs about 2k and
the
 pro version about 5k.  The builder/development software is $250


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe 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: Webcams . . .

2000-07-08 Thread Dirk De Bock

Get an Axis cam, it's a stand-alone device with a mini linux kernel on
board, it has an ethernet interface, comes with it's own webserver built in
and an ftp client that can upload pics every couple of seconds to any ftp
server you tell it to.


- Original Message -
From: "Dan Haley" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 07, 2000 10:09 PM
Subject: OT: Webcams . . .


 Anyone have recommendations for webcams?  Low-end, middle of the road, or
 high-end.  Our CEO wants to put a webcam on the top of the building
pointing
 at the new construction the company is doing and have the pictures put on
 the web.  I'm assuming the webcam could be hooked into a workstation which
 would then upload the pictures to the web server?  Do webcams come with
the
 software to do the upload?

 Thanks for any input.

 Dan

 --

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: OT: Nutscrape Problem

2000-06-22 Thread Dirk De Bock

so does anyone know the magic code to make the player start loading the
media clip at a specific point somewhere in the file rather then at the very
beginning ?


- Original Message -
From: "Deanna L. Schneider" [EMAIL PROTECTED]


 Duane,
 I did something similar - writing ram files as people entered clips to a
 database of audio and video files. Code goes something like this:

--
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: Streaming audio

2000-06-21 Thread Dirk De Bock

Is there any way of controlling access to the realmedia server, like writing
in a table what users do or do not have access ? Also can you control from
CF what point in a file the player should jump to. That is : create a link
in CF that will instruct the realuadio player to open a specific file and to
start playing from 1 minute 43 seconds in that file for instance.


- Original Message -
From: "Nick Call" [EMAIL PROTECTED]
 Todd:  I am buried up to my eyeballs in streaming A/V content right now,
 with access controlled by CF Long story shortened, go with Real Networks.


--
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: .WAV-.RA via command line?

2000-06-20 Thread Dirk De Bock

This used to come for free with the older realaudio encoders

I believe now you have to buy the plus version to get the command line tools

- Original Message -
From: "JF" [EMAIL PROTECTED]

 I'm using the RealAudio server that came with CF Enterprise 4.0, and need
 to convert WAV files to RA format "on-the-fly"


--
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: Upsizing Wizard from Access to MS SQL?

2000-05-24 Thread Dirk De Bock

often it is usefull to use smallint in stead of bit fields, it will avoid
this sort of problems and you can GROUP BY on smallint, not on bit, and
there are other reasons that I forget about right now

just a thought


- Original Message -
From: "Andrew Scott" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 24, 2000 1:23 PM
Subject: Upsizing Wizard from Access to MS SQL?



 I have this small problem where I had a YES/NO field in a MS Access
 database, I then used the wizard to upsize this to MS SQL. THe problem is
 that the wizard made this a bit field which is fair enough, now under
 solaris  mySQL I don't recall having this problem but under MS SQL it
 appears to have a problem.

 Ok this simple insert query has problems from CF

 cfquery name="name" datasource="datasource"
  insert into test (test) values (1)
 /cfquery

 The error I get is as follows from the ODBC:-

 Disallowed implicit conversion from datatype 'varchar' to datatype 'bit'
 Table

 This I have no idea how to get around, my limited knowledge of MS SQL has
me
 stumped yet it works under mySQL so what am I doing wrong here:-)

 --

 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.



where to buy

2000-05-16 Thread Dirk De Bock

I need to buy 2 CF 4.5 pro, what's the quickest way ?


[EMAIL PROTECTED]

--
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: Anyone know about firewall software?

2000-05-13 Thread Dirk De Bock

I should think most firewalls will allow you to 'publish' the real
addresses. This will allow every pc on the inside to be known by it's real
ip number from the outside. At least Axent Raptor 6.0 has this feature.
However to my knowledge there are very few valid reasons to use it.

- Original Message -
From: "Richard Ramos" [EMAIL PROTECTED]
Sent: Saturday, May 13, 2000 12:32 AM
Subject: OT: Anyone know about firewall software?


 Hi, sorry to be OT, but I've been searching for firewall software that
will
 allow each computer in our LAN to have an individual IP and not do
 connection sharing.  Ever hear of any thing like this?


--
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: how do you have a static picture in the background

2000-05-10 Thread Dirk De Bock

Untested but worth trying

In your style sheet :

body

font-family: Verdana, Geneva;
font-size: 11px;
font-style: normal;
font-weight: normal;
background: url(yourpicturehere.jpg) fixed no-repeat;
background-color: #33;
}

adjust to your taste.


- Original Message -
From: "Computer Simplistics Suppoer" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 10, 2000 8:26 PM
Subject: Re: how do you have a static picture in the background


 body bgproperties"fixed"

 I believe.

 Scott Berry
 --
 Computer Simplistics Support
 "Simple Solutions for a Complex World"
 http://www.c-s.net
 661-296-4315

 - Original Message -
 From: "aslam bajaria" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, May 10, 2000 7:45 AM
 Subject: how do you have a static picture in the background


  I was wondering if there is a way to have a static
  picture on the background. Like say the picture of the
  building of your company. As the user scrolls down the
  page, the picture should still be static and only the
  text should scroll.
 
  Can someone help me with this.
  Appreciate.
  A.B.
 
  __
  Do You Yahoo!?
  Send instant messages  get email alerts with Yahoo! Messenger.
  http://im.yahoo.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.


--
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: Add single quotes to each element on a list

2000-04-28 Thread Dirk De Bock

use
cfselect display="rstate_name"
value="'rstate_code'"

or something along these lines, ie add the '' in the option elements

 Subject: Add single quotes to each element on a list
 I have a multiple selection list of states in the US
 When the user selects several out of the list and submit, the selected
state
 Code are passed as  selState = 'AL,AK,AS,AZ,AR,CA,CO,CT,DC,DE,FL,GA'
 I wonder if there is a way to make the list like
 selState = 'AL','AK','AS','AZ','AR','CA','CO','CT','DC','DE','FL','GA'


--
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: Parent/Child query

2000-04-19 Thread Dirk De Bock

I think a lot of people could use something like this so do please consider
setting up a web page with explanations and source code or some such.

- Original Message -
From: "Dan G. Switzer, II" [EMAIL PROTECTED]
 I have a working model of the "nested set tree" in a working Access
 database. Let me know if you want a copy of it. It works a little
different
 then the standard adjacent list (aka, the parent/child relation) but it
 seems to work really will. The concept is based off of something in the
book
 "SQL for Smarties"-which is a great book.


--
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: Parent/Child query

2000-04-19 Thread Dirk De Bock

Thank you, I have something working here for a threaded message forum but it
does it's dirty work in cf and not in the database


- Original Message -
From: "Dan G. Switzer, II" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 19, 2000 3:54 PM
Subject: RE: Parent/Child query


 PS - Make sure to get the 2nd Edition version of Joe Celko's SQL for
 Smarties. According to the liner notes, there are big differences between
 the two versions. Apparently 1st Edition doesn't cover hierarchical trees
to
 the depth that 2nd Edition does.

 -Dan

 -Original Message-
 From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 19, 2000 9:35 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Parent/Child query

 Dirk,

 I'll try to write an article up describing the basic concept next week.
I'll
 post in on the OACFUG site (http://www.oacfug.org/.) I'd recommend for
 anyone looking to do parent/child relationships in a database, to buy the
 SQL for Smarties book by Joe Celko. It's not a beginners book by any
means,
 but has some really great useful tips for organize your data.

 -Dan
 ++---+
 |   name | Dan G. Switzer, II|
 |company | PengoWorks.com|
 |www | http://www.pengoworks.com |
 | mailto | [EMAIL PROTECTED]   |
 ++---+


 -Original Message-----
 From: Dirk De Bock [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 19, 2000 9:21 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Parent/Child query

 I think a lot of people could use something like this so do please
consider
 setting up a web page with explanations and source code or some such.

 - Original Message -
 From: "Dan G. Switzer, II" [EMAIL PROTECTED]
  I have a working model of the "nested set tree" in a working Access
  database. Let me know if you want a copy of it. It works a little
 different
  then the standard adjacent list (aka, the parent/child relation) but it
  seems to work really will. The concept is based off of something in the
 book
  "SQL for Smarties"-which is a great book.


 --
--
 --
 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.

 --

 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.



Re: OT JavaScript Question

2000-04-18 Thread Dirk De Bock

Since you're using dynamic pages I would just add
the current template to the href as in location.href =
"index_test.cfm?page=pageyoureon
and then use that param to decide what pages to include in your frame

you could probably even use the cgi_referer in the index.cfm if you don't
like the idea of appending params to your href

 This is the script to jump to the home frames page
 script language="Javascript"
 !--
  if (location.href == top.location.href) {
location.href = "index_test.cfm"
}
  // --
 /script


--
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: Speed of CFMAIL

2000-04-07 Thread Dirk De Bock

To the disk. I missed the bit about getting the message to the client.

So first the messages are queued locally, then I deliver them to a smart
host at my provider, this will be typically at 150 to 300 msg per minute,
obviously depending on numerous factors such as local server load, remote
server load, bandwidth.

To actually get them delivered to the client is not my concern at this
point, not until my ISP starts complaining. I guess this will takes a couple
of hours to get the last one out.

- Original Message -
From: "Len Conrad" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 05, 2000 8:52 PM
Subject: Re: Speed of CFMAIL



 On a good day I can have my box spit out 2.000 mails per minute,

 That's just queued to disk?  or delivered from queue to smtp destination?

 Howie needs to how many mails / hour delivered OUT OF THE CF BOX (to his
 next hop MTA).

 30 ms/msg is pretty darn good, anyway.

 3,000,000 / day ... queued to disk!  LOL

 "dans queue" for that info, Dirk.

 Len  on a queued day, you can wait forever! 

 --

 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.



Re: Speed of CFMAIL

2000-04-05 Thread Dirk De Bock

On a good day I can have my box spit out 2.000 mails per minute, I should
think it mostly depends on your i/o subsystem and file system since you're
creating 2.000 files per minute. A FAT sytem would slow to a crawl after the
first couple of hundred messages.

Other ways to go would be to use cffile to write out the mails (maybe more
efficient), or to use a CFX ro COM object in a compiled language to write te
mail files.

- Original Message -
From: "Chris Evans" [EMAIL PROTECTED]
Subject: RE: Speed of CFMAIL



--
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.