cftransaction and Access autonumber

2001-02-17 Thread Bud
Hi. I've got a client that every now and again finds her sequence of order IDs skips a number. I do the thing where I put cftransaction around the order being entered, get the max(order_id) as lastorder, then use that ID for the line items. If there is an error or a timeout between the ID

Session time out error

2001-02-17 Thread Veena Sarda
I am getting a session time out error even if I am using that session. any help? Thanks Veena ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: Page Counter

2001-02-17 Thread Phim
Hi Brendan Thank you very much :))) its working good :) um.. but i wonder why have these 3 lines below; 1. cfif attributes.result is not "" 2. cfset "caller.#attributes.result#"=#currentvalue# 3. /cfif Thank you very much regards, phim -Original Message- From: brendan avery

Re: Java CFX Tags

2001-02-17 Thread Jeff Sarsoun
Nick, Connecting to a ssl server is possible through JAVA ala JSSE and JDK1.2. http://java.sun.com/products/jsse/ You should be able to modify your existing cfx tag to implement https support. Although I haven't had an occasion to use cfhttp with a https url I believe that it was possible.

RE: CFMail -- Good Substitute???

2001-02-17 Thread JustinMacCarthy
CHeck out iMS mail from coolfusion.com Justin -Original Message- From: Melissa Fraher [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 7:40 PM To: CF-Talk Subject: CFMail -- Good Substitute??? Hello. Does anyone know of a good custom tag to use instead of CFMAIL? Any

Re: ParseDog

2001-02-17 Thread Jeffry Houser
There is a difference between solicitation, and a comment in a sig. ;) Theoretically I only post on relevant topics. (this thread aside, of course). Mr Bean wrote: Yea SLAM DUNK, talk talk, bitch and moan and your GUILTY Have a great weekend "Billy Cravens" [EMAIL PROTECTED] wrote

Re: advanced list

2001-02-17 Thread Mr Bean
You cant say it any better than that. "Jon Hall" [EMAIL PROTECTED] wrote in message 001d01c09869$0b37d3d0$a41f88d8@ns2">news:001d01c09869$0b37d3d0$a41f88d8@ns2... Ask your question and it shall be answered. I have never seen a question no matter how advanced that has not been addressed in

RE: Studio losing DW path

2001-02-17 Thread Deb Dickerson
I think if you create a custom button within Studio that points to the correct executable, it straightens out the path issue. Debbie -Original Message- From: Joe Sheble (Wizaerd) [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 2:32 AM To: CF-Talk Subject: OT: Studio

Admin .htaccess files

2001-02-17 Thread David Hannum
Hello, Is it possible to build an interface to administer .htaccess files from the browser? I've never tried, but can't think of a reason why it would not work. Any thoughts? Dave ~~ Structure your ColdFusion code with Fusebox. Get the

Re: Admin .htaccess files

2001-02-17 Thread William J Wheatley
well you could build an interface to run it from the web, but anytime you put a security function on the web you give yourself one more vunerablity. So unless its important you might as well just do it the old fashined way. Now i may be in the minority where i feel you should not expose yourself

RE: Admin .htaccess files

2001-02-17 Thread JustinMacCarthy
YEah , there are 1000's of perl scripts to just that. http://www.google.com/search?q=perl+htaccess+cgibtnG=Google+Search Justin -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 2:51 PM To: CF-Talk Subject: Admin .htaccess files

SQL error

2001-02-17 Thread Jeff Davis
Help? I'm sure this is a silly insert error but I just don't see the problem. The answer filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the field? Running CF 4.5 and SQL7. ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL Server

Re: SQL error

2001-02-17 Thread Bryan LaPlante
Is that # hash mark in the color value causing you trouble? - Original Message - From: "Jeff Davis" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 10:16 AM Subject: SQL error Help? I'm sure this is a silly insert error but I just don't see the

Re: SQL error

2001-02-17 Thread Jeffry Houser
You may want to use a text field, not a char field. I imagine the quotes in the insert may be cause of the problems. There are a handful of statements that have an effect on the quotes. Look into htmleditformat() first. I don't see any single quotes in your insert, so

Re: SQL error

2001-02-17 Thread Jeff Davis
I have a backend page set up to insert new FAQ's to the site so teh CEO can add them as they come up. This is really the only one that has this much HTML for the table layout of requirements. It was teh # sign causing the problem, I removed all the Font tags and it inserted just fine. Thanks

ParseDog and Mr Bean?

2001-02-17 Thread Gordon Burns
I have no idea who Mr Bean is or where he has come from, nor do I recall any previous contributions being posted to this list from Mr Bean. I am deeply suspicious of anyone who uses the name Mr Bean (For those who are not aware, the character of Mr Bean is played to great effect by Rowan

Re: Admin .htaccess files

2001-02-17 Thread David Hannum
It would be just as secure as .htaccess itself, because the tool would be in a directory protected by both CF and .htaccess Dave - Original Message - From: William J Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 10:40 AM Subject: Re:

Custom 404 in CF.

2001-02-17 Thread Neil H.
IN a virtual hosting environment how would you use a custom 404 that is CF based? Actually even if it a .cfm and the file is not found IIS wouldn't return the 404 page but there is something else displayed. Thanks, Neil p.s. It can not be the server wide error handler since there are several

Re: SQL 7 vs SQL2k...

2001-02-17 Thread Cary Gordon
You can manage SQL 7 (and 6.5) databases using the SQL 2k Enterprise Manager. You cannot manage SQL 2k databases using the SQL 7 Enterprise Manager. Cary At 06:54 PM 2/16/2001 -0500, you wrote: On 2/16/01, Cary Gordon penned: One possible negative is that, if you have a mixed environment,

Re: cftransaction and Access autonumber

2001-02-17 Thread Jon Hall
Yup, that is exactly what is happening. Once you insert a new record the autonumber index gets incremented. If you delete that record as happens in case of an error with cftransaction. The next time a new record is inserted it just continues on to the next highest number. jon - Original

RE: Custom 404 in CF.

2001-02-17 Thread Lee Fuller
The only way to do this is with iEP's redirection (error) handler. It allows for the use of CFM's for error handling/custom 404's.. etc. Lee Fuller Chief Technical Officer PrimeDNA Corporation -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17,

RE: Custom 404 in CF.

2001-02-17 Thread Tony Gruen
Neil, If you have enabled session variables, this is easy. In your application.cfm page insert this code below your cfapplication... CFERROR TYPE="Request" TEMPLATE="error.html" MAILTO="[EMAIL PROTECTED]" Then be sure to have a custom error.html page within that directory scope. It is

Re: cftransaction and Access autonumber

2001-02-17 Thread Bud
On 2/17/01, Jon Hall penned: Yup, that is exactly what is happening. Once you insert a new record the autonumber index gets incremented. If you delete that record as happens in case of an error with cftransaction. The next time a new record is inserted it just continues on to the next highest

Re: cftransaction and Access autonumber

2001-02-17 Thread Terry - it-werks.com
I think there is more to what you stated then Jon Hall mentioned. Why not lose the autonumber field and do autonumber yourself by incrementing MAX(id) + 1 and using that as your unique id. This way your related link from the line items to the order header is something YOU created and can RECREATE

Locking question

2001-02-17 Thread Jon Hall
I have seen all of the warnings to make sure to use cflock around any of the in memory variable types in a CF application. I hear that every access of a session, or application variable should have cflock around it, or I could enable automatic locking on the server which will exact a performance

RE: Custom 404 in CF.

2001-02-17 Thread Max Paperno
Hi, I've found CFERROR does not trap the CF 404 errors even when used in the global application.cfm. Also a couple of statements in Tony's mail aren't correct in regards to CFERROR: At 2/17/2001 12:09 PM -0800, Tony Gruen wrote: If you have enabled session variables, this is easy. You

A question on queries

2001-02-17 Thread Bud
Hi all. This may be a little long, but I really need some advice from the gurus out there. I'm updating an application I built for a client awhile back and am looking to try and pick up some speed if possible. The way it works now is, the items being sold can only be sold one to an area.

Re: Locking question

2001-02-17 Thread Jeffry Houser
Jon Hall wrote: I have seen all of the warnings to make sure to use cflock around any of the in memory variable types in a CF application. I hear that every access of a session, or application variable should have cflock around it, or I could enable automatic locking on the server which

Re: A question on queries

2001-02-17 Thread Dick Applebaum
Bud Have you considered making a separate ProductArea table which is a child of the Product table: ProductID Int, AreaID Int, PRIMARY KEY (ProductID, AreaID) Both as the PK You could just do the insert bookended with CFTry... If no error, it was the first of that

Re: advanced list

2001-02-17 Thread Michael Dinowitz
OK, I've heard the call for an advanced list and I I'll see what I can do over the next 2 days. Why 2 days? Because I'm taking down post.office and putting up the iMS listserver (which I'm writing from scratch now). Once its up, I'll set up a CF mailing list that's moderated only, but of a

RE: advanced list

2001-02-17 Thread Lee Fuller
Strongly support you on this Michael. Sounds like a great idea. I'll be waiting to hear more about it. Lee Fuller Chief Technical Officer PrimeDNA Corporation -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 5:28 PM To:

Re: advanced list

2001-02-17 Thread Michael Dinowitz
Current specs: 1. A person has to sign up for a list online. This will change in the future, but for now that's the fastest and easiest signup we have. 2. A subscription allows a person to enter the following information: a. username b. password c. primary email address (address used to receive

Re: advanced list

2001-02-17 Thread pan
Quite a project, Micahel. Looks good. A couple of comments interspersed below . OK, I've heard the call for an advanced list and I I'll see what I can do over the next 2 days. Why 2 days? Because I'm taking down post.office and putting up the iMS listserver (which I'm writing from scratch

RE: Locking question

2001-02-17 Thread Patricia Lee
In short 1) You need to have locks around even the Cfif Isdefined() statements. In order for CF to check if a function is defined it has to attempt a read of said function. 2) When accessing a shared variable to read its value the cflock type="" attribute should be Readonly. 3) When

Re: advanced list

2001-02-17 Thread Dick Applebaum
At 8:27 PM -0500 2/17/01, Michael Dinowitz wrote: OK, I've heard the call for an advanced list and I I'll see what I can do Michael I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. Sometimes, something appears on the cf-talk

Re: advanced list

2001-02-17 Thread Chad Gray
I have to agree. I like the list the way it is. We all have delete keys. Let the list live as is. At 08:36 PM 2/17/01 -0700, you wrote: At 8:27 PM -0500 2/17/01, Michael Dinowitz wrote: OK, I've heard the call for an advanced list and I I'll see what I can do Michael I like the cf-talk

Re: advanced list

2001-02-17 Thread Nick Texidor
I second that too. I have no problems using the delete key. And it's been the source of some great help, suggestions and ideas in the past. I'd prefer to see it continue as is. From: Chad Gray [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sat, 17 Feb 2001 11:16:15 -0500 To:

SMB feature idea

2001-02-17 Thread Tony Schreiber
Since I run (and moderate) several forums (is300.net the most active right now), I'm always trying to think of ways to make Simple Message Board the best and easiest to use (that's where the Brownie Point idea came from) and the other day I had a thought (watch out!): I'm going to add a "This

Re: how to launch a windows app from a web page?

2001-02-17 Thread David Shadovitz
Kirk and all, This may be insufficient for your needs, but it is easy and useful: You can add an "Add this meeting to your calendar" hyperlink to your web pages. The link is to a simple text file in the vCalendar format. When the user clicks on the link, the browser invokes the user's

Re: Custom 404 in CF.

2001-02-17 Thread Jim McAtee
Lee, Do you have a link to more information? Jim - Original Message - From: "Lee Fuller" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 1:01 PM Subject: RE: Custom 404 in CF. The only way to do this is with iEP's redirection (error) handler. It

Re: advanced list

2001-02-17 Thread Al Musella, DPM
I don't like the idea of a new list. Face it. 90% of us are going to join both lists anyway. Where is the savings? I run about 10 mailing list, and have run into this problem of too much off topic stuff a few times. I think I found a way to stop it Just assign a few volunteers to be the

Re: advanced list

2001-02-17 Thread paul smith
I agree. While my delete button gets overheated from time to time, that's a small penalty for the usefulness of the list. I think Al's suggestions below are more practical than setting up a new list. The new rules, whichever list, should identify whether messages like this one are off

Re: advanced list

2001-02-17 Thread Michael Dinowitz
Only a few people can post. Posters are set by recommendation from a current poster. Can you compile a 'grandfathered' list of historically productive cf-talk members in order to streamline the start up of the posting privileged list? Already done. We've got a number of people who are

Re: advanced list

2001-02-17 Thread Michael Dinowitz
Michael I like the cf-talk list the way it is. I am a member of several moderated lists and they leave a lot to be desire. CF-Talk will not be changing. I'm defining a new, extended list that'll be both more limited than CF-Talk and more restrictive. Also, due to its nature it'll be slower.

Re: advanced list

2001-02-17 Thread Michael Dinowitz
I have to agree. I like the list the way it is. We all have delete keys. Let the list live as is. The lists are staying as is, I was talking about a new experimental list. ~~ Structure your ColdFusion code with Fusebox. Get the official book

RE: SMB feature idea

2001-02-17 Thread Angel Stewart
Let it be a Administrator defined maintenance task. So in the Admin menu somewhere there will be a "Run Maintenance Profiles" button or something that will execute this and other features. Yeah..this is manual, but it's either that or do a check everytime the board is accessed to see what needs

RE: SMB feature idea

2001-02-17 Thread Tony Schreiber
Let it be a Administrator defined maintenance task. So in the Admin menu somewhere there will be a "Run Maintenance Profiles" button or something that will execute this and other features. Yeah..this is manual, but it's either that or do a check everytime the board is accessed to see what

RE: advanced list

2001-02-17 Thread Hal Helms
I don't know if the will work out or not, but kudos for trying something new. I'm sure it was a huge amount of work, too. Hal Helms == See ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training == -Original Message- From: Michael Dinowitz [mailto:[EMAIL