RE: CFFunction Question

2004-01-06 Thread Jochem van Dieten
Bryan F. Hogan said: I know that. I can't remember what I was doing. But there IS a bug somewhere where not using pounds on arguments causes an error. Just can't remember where. Bugs that are not reported don't exist. Jochem [Todays Threads] [This Message] [Subscription] [Fast

Re: Password Logic

2004-01-06 Thread Jesse Houwing
-Original Message- From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Mon, 5 Jan 2004 10:25:27 -0500 Subject: Re: Password Logic but you only need the public key for password verification (eg encrypt th epassword again and verify the encrypted data). Only selected

RE: Password Logic

2004-01-06 Thread Jesse Houwing
You can also generate a random string (or a word from a dictionary file) asking the user to remember this (and write it down if needed). Then ask for that when the user enters his new password. It's easier than coming up with something yourself which will be something close to the person in

RE: Password Logic

2004-01-06 Thread Robertson-Ravo, Neil (RX)
I have an SP for generating a password based on a username and a 'seed' which will generate a random password which is unique for that user. _ From: Jesse Houwing [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 10:01 To: CF-Talk Subject: RE: Password Logic You can also generate a random

Frames

2004-01-06 Thread Shahzad.Butt
Hi My left frame has got a link LOGIN and it opens a Login form on right frame. I want to get rid of the LOGIN link and give my administrator direct access to that login form page. So they jus type in http://www.abc.com/index.htm and they go direct inot login form with having left and top

Re: flash remoting help

2004-01-06 Thread Craig Earls
Yes I am using Flash Remoting in a shared hosting environemnt and have exactly the problem you describe.The unsatisfactory solution has been to put all my cfCFCsin the same directory and only call them from that directory.Otherwise the path gets screwed up since the braindead macromedia service

Re: CFTREE does not work on some machines

2004-01-06 Thread Thomas Chiverton
On Monday 05 Jan 2004 21:46 pm, Debbie McDaniel wrote: I have been successfully using CFTREE in a web application (CF 4.5.2 Windows 2000 SP3) since 2000. One of our execs recently purchased a new laptop (Windows XP IE 6) and now CFTREE no longer works on his machine. It worked on his old

Re: flash remoting help

2004-01-06 Thread Ryan Mitchell
How do you reference that directory then? Could you give me more details, sounds like we have a winner for the problem! On 6/1/04 11:46 am, Craig Earls [EMAIL PROTECTED] wrote: Yes I am using Flash Remoting in a shared hosting environemnt and have exactly the problem you describe.The

RE: CFFunction Question - SOLVED

2004-01-06 Thread Bill Grover
Thanks to Raymond, Bryan and everyone else that responded.I did log a bug as Raymond suggested. There was 2 solutions to the problem.The first solution was to pass the default value in for every argument that I didn't want to change.Very messy, but it does work. The 2nd solution was to use the

RE: CF MX 6.1 and com objects

2004-01-06 Thread Schuster, Steven
You probably do indeed have it working but not natively. .NET is the replacement for COM. COM has a different internal architecture from .NET and thus they are not compatibility natively. That is why you have to use the RCW which translates specific calls from managed clients into COM specific

RE: CF MX 6.1 and com objects

2004-01-06 Thread Schuster, Steven
compatibility natively - That was a good one Compatible natively - Damn MS spell checker http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original Message- From: Schuster,

About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
Hi there: I'm looking for examples and tutorials how to use XML in CFMX. Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: About CFMX and XML

2004-01-06 Thread John Stanley
Developing Cold Fusion MX Applications with CFML page 712 to start with, if you havent already. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:32 AM To: CF-Talk Subject: About CFMX and XML Hi there: I'm looking for examples

Verity Documentation?

2004-01-06 Thread Jamie Jackson
Where can I find Verity (as close to the CF5-bundled version as necessary) documentation beyond the OEM *ColdFusion 5 Advanced Coldfusion Administration* book? That reference helps, but it's not enough. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

RE: About CFMX and XML

2004-01-06 Thread Tony Weeg
http://www.cfdev.com/xml/ try google next time, but the above works. cf xml google :) -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:33 AM To: CF-Talk Subject: RE: About CFMX and XML Developing Cold Fusion MX Applications with CFML

Re: About CFMX and XML

2004-01-06 Thread Bruce Sorge
There is a paper written by Nate Weiss in April of 2002 called Utilizing XML and XSLT in ColdFusion MX. It gave me a basic foundation for an RSS feed that I was working on. You can find it in the Forums of the Devnet site. Bruce - Original Message - From: Hassan Arteaga Rodriguez To:

RE: About CFMX and XML

2004-01-06 Thread Samuel R. Neff
Here's a preso with examples. http://www.rewindlife.com/archives/16.cfm HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message-

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
Thanks Tony __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:36 AM To: CF-Talk Subject: RE: About CFMX and XML http://www.cfdev.com/xml/ try

RE: About CFMX and XML

2004-01-06 Thread Tony Weeg
what kinda details? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:46 AM To: CF-Talk Subject: RE: About CFMX and XML Thanks John. I have it. I started from this. But just looking for more examples and more details __ MSc.

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
OK Samuel. Thanks __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 09:41 AM To: CF-Talk Subject: RE: About CFMX and XML Here's a preso with

CF_MAX_ID - MySQL slowww

2004-01-06 Thread Spectrum WebDesign
Hi all 2 questions: yesterday i need to reinstall CF MX 6.1 after 3 months works fine... Today when run this script: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID cfquery

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
Not exactly more details because theDeveloping Cold Fusion MX Applications.pdf or chm I have is good enough to start but more examples are always welcome Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony

RE: About CFMX and XML

2004-01-06 Thread Tony Weeg
ahhh, well, what parts are you a bit unsure about? writing it? reading from it? extracting info from inside of it? how far have you gotten? tony -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:00 AM To: CF-Talk Subject:

Re: About CFMX and XML

2004-01-06 Thread Massimo, Tiziana e Federica
http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

OT: Mind Mapping Programs

2004-01-06 Thread Daniel O'Keefe
I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a little bit, but want to find one and use it regularly as part of my planning processes. The ones I know of are listed below. Anybody have any experience using any of these or know of other ones I

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
writing it and using it with cfc's. ie: i would like implement one cfc to read and write config settings from one xml file..I know how to write and read..but i'm asking for best practices Do u understand what i mean? Thanks Tony __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
Thanks Massimo __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:10 AM To: CF-Talk Subject: Re: About CFMX and XML

RE: About CFMX and XML

2004-01-06 Thread Tony Weeg
sure do...and I really think that best practices are yet defined in this realm. I could be wrong, but I havent read any or heard about any xml and cfmx best practices yet. now, about cfc's and doing that, check out the cfcdevzone cfc list...there are some real good people on that list, and its

RE: About CFMX and XML

2004-01-06 Thread Hassan Arteaga Rodriguez
Ok. I will start. I will be asking in the way of the development. Thanks __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:14 AM To: CF-Talk

Re: Regex Help

2004-01-06 Thread Ben Doom
With regular expressions, it tends to much, much harder to say do this when a condition is false than do this when a condition is true. One option that would at least fix the problem with the scripts (though not the textareas or the PRE blocks) would be to replace [[:space:]] with a class of

Re: Verity Documentation?

2004-01-06 Thread Jamie Jackson
I may be on to something here: http://www.diramb.gov.pt/search97/ On Tue, 06 Jan 2004 09:33:54 -0500, in cf-talk you wrote: Where can I find Verity (as close to the CF5-bundled version as necessary) documentation beyond the OEM *ColdFusion 5 Advanced Coldfusion Administration* book? That

Changes not being reflected.

2004-01-06 Thread Bryan F. Hogan
Have any of you run across a scenario where changes are not being reflected? What I have is a page that allows uploads. On the action page I'm using CFFILE to upload it. And as I do every time a build an upload page I forgot to add the enctype attribute to the form so I got the error telling me

RE: Changes not being reflected.

2004-01-06 Thread John Stanley
Is the browser tools/internet options/temporary internet files/settings radio set to every visit to the page? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:48 AM To: CF-Talk Subject: Changes not being reflected. Have any of you run

Re: Changes not being reflected.

2004-01-06 Thread Bryan Stevenson
Yep...if you're using CFMX (may be Enterprise only) there is a setting to force CF to always look for changes or never lookthe setting name escapes me at the moment.This setting is set to NOT check once the app is in production because the code should not be changing. HTH Cheers Bryan

RE: Changes not being reflected.

2004-01-06 Thread Bryan F. Hogan
Yep, -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:53 AM To: CF-Talk Subject: RE: Changes not being reflected. Is the browser tools/internet options/temporary internet files/settings radio set to every visit to the page? [Todays

Re: Changes not being reflected.

2004-01-06 Thread Jamie Jackson
After you cleared your class files, did you restart the CF server in the JRun Admin? Jamie On Tue, 6 Jan 2004 10:47:52 -0500, in cf-talk you wrote: Have any of you run across a scenario where changes are not being reflected? What I have is a page that allows uploads. On the action page I'm

RE: Changes not being reflected.

2004-01-06 Thread Bryan F. Hogan
That's the trusted cache option. And it is not checked. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:53 AM To: CF-Talk Subject: Re: Changes not being reflected. Yep...if you're using CFMX (may be Enterprise only) there is a

Re:flash remoting help

2004-01-06 Thread Mauricio Giraldo
Yes I am using Flash Remoting in a shared hosting environemnt Tell me about it. Some sysadmins just dont know how to configure flash remoting. Is it Windows or Linux hosting? Please provide the most information. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

RE: Changes not being reflected.

2004-01-06 Thread Bryan F. Hogan
I don't have JRun installed but I did restart the services in the control panel. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:55 AM To: CF-Talk Subject: Re: Changes not being reflected. After you cleared your class files, did you

Re: flash remoting help

2004-01-06 Thread Clint Tredway
In my experience its not configuring Flash Remoting, its configuring how the webroots are setup. The paths for flash remoting are based on your webroot. I use a shared environment with Crystal Tech, and remoting works just fine. You need to find out what your webroot is. Then, you can figure

Re:flash remoting help

2004-01-06 Thread Mauricio Giraldo
In my experience its not configuring Flash Remoting, its configuring how the webroots are setup. Yes... although I have had quite a few issues with CFC mappings and Remoting since behavior in CFM is different (or has been different in the scenarios I have had) to Flashservices behavior. But that

Re: Changes not being reflected.

2004-01-06 Thread Jamie Jackson
If you're pretty sure that it's a caching issue: Is there any possibility that you're getting problems with crossed sites (maybe there are multiple versions of the same site on the server, or another site with the same template path/name -- i.e. the multi-homed server caching issue)? Jamie On

Re: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Jochem van Dieten
Spectrum WebDesign said: !---get MaxID form DB--- cfloop condition=true cftry cftransaction cf_max_ID datasource=#dsn# tablename=tblNews primarykey=intNewsID It would help if we had the code for cf_max_id and if you placed some timers for the different sections.

RE: Mind Mapping Programs

2004-01-06 Thread Shawn Regan
How about Visio? Shawn -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 7:11 AM To: CF-Talk Subject: OT: Mind Mapping Programs I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a

julian date

2004-01-06 Thread Stephenie Hamilton
What is the best way to work with julian dates in CF? I will need to convert a julian date to a formatted date and vice versa. I have never worked with julian dates before so any info you can send my way would be great. TIA Stephenie Hamilton [Todays Threads] [This Message] [Subscription]

RE: julian date

2004-01-06 Thread Tim Do
Convert to julian:numberformat(dateadd(d,dateToConvert+693592,'1 Jan 1900'),99) Convert from julian:dateformat(dateadd(d,dateToConvert-693596,'1 Jan 1900'), mm-dd-) -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:40 AM

RE: julian date

2004-01-06 Thread Robertson-Ravo, Neil (RX)
There are a few Julian date UDF's at www.cflib.org...head http://www.cflib.org...headover there..:-) _ From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 16:40 To: CF-Talk Subject: julian date What is the best way to work with julian dates in CF? I will need to

CFMX Upgrade Problem

2004-01-06 Thread Bruce Sorge
I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what did you

SOT: SQL question

2004-01-06 Thread Cutter (CF-Talk)
How do I get the ID of the last record in a table (mySQL db)? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: OT-SQL Data file issue

2004-01-06 Thread Eric Creese
I used the tek-tips link below and was able to save the database. Thanks allot for everyone's help. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:17 AM To: CF-Talk Subject: RE: OT-SQL Data file issue

Re: CFSearch Ignoring Document Titles

2004-01-06 Thread Jamie Jackson
Okay, no bites, so let me ask a simpler question. A cfsearch type=simple is *supposed* to search document title and body, no? Thanks, Jamie On Mon, 05 Jan 2004 17:37:54 -0500, in cf-talk you wrote: I've got an index created by K2 spider, but it doesn't seem to be searching on the title field

Re: SOT: SQL question

2004-01-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote: How do I get the ID of the last record in a table (mySQL db)? Define 'last'. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

SOT: BD 6.1 and mySQL

2004-01-06 Thread Cutter (CF-Talk)
I loaded BlueDragon 6.1 on my Win 2003 server this weekend. After a little wrangling I got this to work, but I can't get it to connect to my mySQL db. I did read in a FAQ on thier site about needing an updated driver or something from the mySQL site. I followed all of the necessary

Re: CFMX Upgrade Problem

2004-01-06 Thread Thomas Chiverton
On Tuesday 06 Jan 2004 17:01 pm, Bruce Sorge wrote: I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone

Re: SOT: BD 6.1 and mySQL

2004-01-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote: I loaded BlueDragon 6.1 on my Win 2003 server this weekend. After a little wrangling I got this to work, but I can't get it to connect to my mySQL db. I did read in a FAQ on thier site about needing an updated driver or something from the mySQL site. I followed all

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Barney Boisvert
Last time I checked, CF_MAX_ID simply did a SELECT MAX() on the table, and added one to the result. If you haven't already, make sure that you have an unique index (key) on the intNewsID column.If it's your primary key, then why aren't you using MySQL's AUTO_INCREMENT column type?It will

Re: SOT: SQL question

2004-01-06 Thread Cutter (CF-Talk)
'last' = the last/most recent/highest autonumbered ID in the primary key of the table. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: How do I get the ID of the last record in a table (mySQL db)? Define 'last'. Jochem -- I don't get it immigrants don't work and steal

RE: CFMX Upgrade Problem

2004-01-06 Thread Steven Erat
Maybe this will help: Troubleshooting DataDirect SequeLink ODBC service startup issues http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.htm http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink.ht m _ From: Bruce Sorge [mailto:[EMAIL PROTECTED]

Re: SOT: BD 6.1 and mySQL

2004-01-06 Thread Cutter (CF-Talk)
When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file: http://www.newatlanta.com/biz/c/products/bluedragon/self_help/faq/detail?faqId=216

Re: SOT: SQL question

2004-01-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote: 'last' = the last/most recent/highest autonumbered ID in the primary key of the table. http://www.mysql.com/doc/en/Getting_unique_ID.html Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription]

Re: SOT: BD 6.1 and mySQL

2004-01-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote: When I set up a mySQL datasource and go to verify that connection it returns the following error: verifying (insert db name here)... General SQL Error I followed the instructions from the following BD FAQ file:

Append to File with CFSCHEDULE

2004-01-06 Thread David Adams
I have a requirement to append output to file when using CFSCHEDULE.By nature, when you save output to file with the publish option set in CFSCHEDULE, it overwrites the file if it exists everytime the schedule is run. I don't want to delete the file, I only want to add output data to the existing

Re: Append to File with CFSCHEDULE

2004-01-06 Thread Jamie Jackson
I'd make an intermediate template which uses cfhttp, or whatever is necessary, then uses cffile to append to your file. Then point your cfschedule at that intermediate file. Would that work? Jamie On Tue, 06 Jan 2004 12:59:43 -0400, in cf-talk you wrote: I have a requirement to append output

Re: CFMX Upgrade Problem

2004-01-06 Thread Bruce Sorge
Nothing in the logs, I rebooted, etc... And of course Windows. :) - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, January 06, 2004 11:13 AM Subject: Re: CFMX Upgrade Problem On Tuesday 06 Jan 2004 17:01 pm, Bruce Sorge wrote: I just upgraded our development

RE: RE: Mind Mapping Programs

2004-01-06 Thread Mike Brunt
There is another I have used called TheBrain but it is not a MindMapping tool as such. http://www.thebrain.com/Default.htm Kind Regards - Mike Brunt Original Message --- How about Visio? Shawn -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED]

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Spectrum WebDesign
Jochem this the Max_ID CustomTag code (really simplest): !--- required attributes --- cfparam name=attributes.datasource cfparam name=attributes.tablename cfparam name=attributes.primarykey cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID

Re: SOT: BD 6.1 and mySQL

2004-01-06 Thread Cutter (CF-Talk)
Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the pertinent variables (mySQL server

RE: Changes not being reflected.

2004-01-06 Thread Bryan F. Hogan
No it's a brand new intranet version. The file I'm using is no where else. Thanks for your reply though. By the way it's working now, I wish I could find out why it does that sometimes. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 11:19

Re: SOT: BD 6.1 and mySQL

2004-01-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote: Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and mySQL Control Center on that same machine, as well as mySQL-Front on my personal system. I have double checked what I thought to be the

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Barney Boisvert
Those reasons for using application-side numbering are all valid, though none of them are worth a performance penalty of ANY amount.And if you're using any vendor-specific SQL, then using the built-in autonumbering is the way to go. If you want to do application-side autonumbering, there are

Re: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Jochem van Dieten
Spectrum WebDesign wrote: cfquery name=getmaxID datasource=#attributes.datasource# select max(#attributes.PrimaryKEY#) as Max_ID from #attributes.tablename# /cfquery Use the proper indexes. Why the hell would you want to do this? Because autonumber datatypes are not easily

Re: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Jochem van Dieten
Barney Boisvert wrote: The easiest solution is to use a file on the file system, though that has problems with scalability.A better solution is probably to have a table in your DB like this: Create table keyGenerator ( table char(30), /* fixed width for speed */ currentMaxKey int unsigned

Clearing all Cached Queries at Once?

2004-01-06 Thread Jamie Jackson
It's a pretty simple matter to clear all the queries accessed in a request, say by setting a clearcache url var, and writing the code to set the cache span to a nil duration when url.clearcache exists. Q1. However, what if I'd like to clear *all* cached queries in the entire application in one

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Matt Robertson
Jochem wrote: Bite the bullet and let the database generate the primary key. Absolutely.As an aside, that MaxID tag has some pretty critical try/catch error handling in it (listed only in the readme if I recall correctly).Without it this already debateable technique is quite dangerous indeed.

RE: Clearing all Cached Queries at Once?

2004-01-06 Thread Raymond Camden
Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) cfobjectcache action=""> This clears the entire server's set of cached queries. Q2. Also, say I've got a dynamic query... cfquery ...select * from t

Re: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Spectrum WebDesign
Thanks Jochem but autonumber is secure??? Using Win2K/CFMX 6.1/MySQL 4.0.1 InnoDB Transaction Table we're protected using autonumber fields Inside CFTRANSACTION or only MySQL transaction do the job - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Tue, 06 Jan

Re: SOT: BD 6.1 and mySQL

2004-01-06 Thread Cutter (CF-Talk)
The only logging that is active is error logging and there are no entries here other that system restarts. Cutter Jochem van Dieten wrote: Cutter (CF-Talk) wrote: Now we're outside my realm of experience. My mySQL db is on a seperate server. I can connect to it via the CF dev server and

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Barney Boisvert
But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be far less. The

iMail Web Messaging through IIS

2004-01-06 Thread Heald, Tim
Has anyone ever gotten the iMail web mail app to run through IIS? -- Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated

RE: RE: Mind Mapping Programs

2004-01-06 Thread Daniel O'Keefe
You are right, it is not, but a pretty darn interesting product. -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:38 PM To: CF-Talk Subject: RE: RE: Mind Mapping Programs There is another I have used called TheBrain but it is not a

Re: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Jochem van Dieten
Spectrum WebDesign wrote: but autonumber is secure??? Yes. Inside CFTRANSACTION or only MySQL transaction do the job They are the same. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Jochem van Dieten
Barney Boisvert wrote: But you need Atomicity and/or Isolation (reading the last value and incrementing it are 2 different actions that need to be somehow grouped), so you still need a transaction. But if you go for a HEAP table which you build on application start, the overhead should be

RE: iMail Web Messaging through IIS

2004-01-06 Thread Dan Phillips
You mean the web interface? like http://mail.cfxhosting.com ? We used it in 2000. Where are you getting stuck? Dan Phillips CFXHosting.com [EMAIL PROTECTED] -Original Message- From: Heald, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:53 PM To: CF-Talk Subject:

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Barney Boisvert
Autonumber is secure, regardless of transactions.It uses a centralized store to ensure that the same number is NEVER issued twice for a given table, within the same server instance.For MyISAM table, the same number will never be issued twice.For InnoDB tables, the counter starts at one greater

OT: RE: iMail Web Messaging through IIS

2004-01-06 Thread Heald, Tim
I am running a web server and this mail server on the same box.I run maybe 10 personal sites off the box, nothing major, all on port 80 using virtual servers.I want to be able to check my web mail at work.I can only get the the web server on port 80. I would like to run the CGI app that comes with

RE: RE: iMail Web Messaging through IIS

2004-01-06 Thread Dan Phillips
Someone told me that ipswitch may have set the app up so it can only run through their server. That's possible but I'm not sure. You could run the mail interface on say port 81. Then you would just go to mail.terminal-fusion.com:81 and that should work. As far as sticking with port 80, I

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Barney Boisvert
You're right.I said I'd never actually implemented it.; )You'd have to use a semaphore in the DB to lock it, and that gets nasty fast.Yeah, anyway, back to what I said at the beginning: just use the DB's autonumbering capabilities. barneyb -Original Message- From: Jochem van Dieten

Re: Clearing all Cached Queries at Once?

2004-01-06 Thread Jamie Jackson
Brilliant, thanks. Jamie On Tue, 6 Jan 2004 12:47:04 -0600, in cf-talk you wrote: Q1. However, what if I'd like to clear *all* cached queries in the entire application in one fell swoop? (Without a server restart ;-) cfobjectcache action=""> This clears the entire server's set of cached

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Spectrum WebDesign
...Barney wrote... For InnoDB tables, the counter starts at one greater than the max value when the server starts, so if you delete the last row in a table and cycle the server, you'll get issued that same ID a second time. Do you're right How to skip it??? Transaction for DB level? Or

RE: CF_MAX_ID - MySQL slowww

2004-01-06 Thread Barney Boisvert
You can't skip it without doing an external store like I proposed, and Jochem shot full of holes.That's just part of the way InnoDB functions. Keep in mind that this is only an issue when your server cycles, which hopefully isn't very often.It seems kind of weird, but it's for performance reasons,

RE: CFMX Upgrade Problem

2004-01-06 Thread Dave Watts
I just upgraded our development server from CF5 to CFMX, then to CFMX 6.1. Now the CFMX ODBC Server and Agent will not start. They do not generate any errors. I am only informed that they could not be started on the local machine. Has anyone had this happen to them before, and if so, what

RE: SOT: BD 6.1 and mySQL

2004-01-06 Thread Steven Erat
MySQL has default security restrictions that typically don't allow remote hosts to connect.A quick and dirty test would be to modify the mysql start script and add an argument for --skip-grant-tables such as: $bindir/safe_mysqld --skip-grant-tables --datadir=$datadir . . .Then restart mysqld. If

CF / JavaScript question

2004-01-06 Thread Steve Logan
I was looking around for a code example of this and haven't been able to find one - it's definitely something that's been on my list of must learn - now it's a need to learn item. I have 2 tables in my db - one is partcategory and one is partsubcatetory. I have a CF snippet set to create a form

Re: CF / JavaScript question

2004-01-06 Thread Daniel Farmer
I'm not sure what you're doing here. But why not just put the select fields into a seperate templates and then call them as you need to? ( cfinclude ) - Original Message - From: Steve Logan To: CF-Talk Sent: Tuesday, January 06, 2004 2:49 PM Subject: CF / _javascript_ question I was

Re: CF / JavaScript question

2004-01-06 Thread Charlie Griefer
http://www.webtricks.com/sourcecode/code.cfm?CodeID=18 http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106viewName=Exchange%20Search%20Detailsauthorid=7653985page=0scrollPos=0subcatid=0snid=sn106itemnumber=13extid=1000288catid=0 - Original Message - From: Daniel

Re: CF / JavaScript question

2004-01-06 Thread Joe On The Road
Hi Steve, Take a look at the _javascript_ on this page.It might help. http://www.jascouniform.com/ecom/showdetl.cfm?User_ID=4326092st=4888st2=79755318st3=70838938Product_ID=4240 Select a color and the size changes, select a size and the price changes.Not exactly what you wanted but the concept

Studio MX 2004 with Flash Professional

2004-01-06 Thread Burns, John
Does anyone know where to get Studio MX 2004 w/ Flash Professional for less than on Macromedia's site?I'm looking to purchase it and was curious if anyone had any leads on a cheaper source.Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Calculating Disk Space??

2004-01-06 Thread Troy Montour
Hello writing a web file uploader for a project area and we want to show how much disk space is left so users don't try to upload bigger files. (which of course I will also check on file size). anyone know of any good CF stuff for calculating disk space left? Thank you Troy [Todays Threads]

RE: Calculating Disk Space??

2004-01-06 Thread Raymond Camden
http://www.cflib.org/udf.cfm/freespace [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

  1   2   >