Re: OT STORED PROCEDURES

2001-01-10 Thread moonerent
I had thought of using Dynamic SQL in SQL Server stored procedures, but hadn't gotten around with playing with it much yet. I just got done researching using Dynamic SQL and stored procedures. Bottom line from the SQL guru community, it should be avoided. Main reason, dyn sql forces the db to

RE: Using MSXML DOM with CF

2001-01-10 Thread DeVoil, Nick
Jim, XMLDoc isn't defined, you have created the object with the name "Parser" BTW it may be a good idea to give the full pathname of the file anyway Nick -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 5:49 PM To: CF-Talk Subject: Using

Questions for Certification

2001-01-10 Thread Rajesh Kumar
Hi All, Though I have cleared the exam of BrainBench and eCertifications.com but I am confused about the answers to the following questions. Could you people help me out! 1. When creating a CFX tag using Java, what does the \cfusion\java\class\cfx.jar file contain? A. Transaction Object, CF

RE: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread Neil Clark
Joshua, hopefully this will fill you in...1st of, dont confuse DW and UD as the same product they are not. They may have the same functionality to a certain degree butw where DW stops, UD takes over in the Database sections. 1. Notepad has all the features of the Dreamweaver/UD code editor

1 user login at a time

2001-01-10 Thread han peng
hi... anyone know how can i restrict only 1 user login at a time? eg. USER1 w/ login_id--admin1 USER2 w/ login_id---admin2 once admin1 log into the system... admin2 cant log in.. qs.. : can i use global session to capture the id? and is using global session safe? i oso think of

RE: CFMail Time Stamp

2001-01-10 Thread JustinMacCarthy
Is this the second error of this type I've seen on the list? 2001 bug ? ~ Justin -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 6:20 PM To: CF-Talk Subject: CFMail Time Stamp I have a problem with the time stamp on messages sent through

RE: OT STORED PROCEDURES

2001-01-10 Thread Bob Silverberg
In response to the first post, you can do _anything_ you want with Exec(@sSQL). If @sSQL contains multiple select statements, then your sp will return multiple result sets. In response to the most recent comment - although you do lose the advantage of guaranteed pre-compilation, I have found

DELPHI - where does it fi - folllow up

2001-01-10 Thread Mike Kear
Thanks for your help everyone. Based partly on your views of where Delphi fits in the scheme of things, I decided I didn't want to have to manage pages built with ASP AND ColdFusion AND Delphi, and so I figured I was going to squash the notion of using Delphi as a web application. Build com

RE: 1 user login at a time

2001-01-10 Thread Aidan Whitehall
hi... anyone know how can i restrict only 1 user login at a time? When someone logs in, set an application variable to 1. Set the default to 0. Set the application timeout to a short period, say 5 minutes. Allow the user to log out manually, resetting the application variable. If they just

RE: 1 user login at a time

2001-01-10 Thread Aidan Whitehall
BTW, you'll need to make the Admin section an application in it's own right. Thinking about it, what I suggested might not be the best way to do it... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744)

RE: SESSION Timing out WAY before it's supposed to.

2001-01-10 Thread Bud
On 1/10/01, Joshua Miller penned: Thought I figured it out when I discovered that when one user logged out it killed ALL sessions for that application, but I was using cfset tmp=StructClear(SESSION) and that was killing the whole session. That problem's been removed, I just terminate the

RE: SESSION Timing out WAY before it's supposed to.

2001-01-10 Thread Mary_Baotic
Did you restart the cold fusion server after you changed the session variable timeout? I have gotten burned by this for other settings more than once. Mary

Java Applet Not Working

2001-01-10 Thread Larry Juncker
Good Morning List I have a Java Applet that has been running on a site for quite some time and now all of a sudden when you mouse over it, it says it can find my class file. The trouble is on the following site. http://www.machinerypile.com If you click on one of the Auction items on the Home

RE: OT STORED PROCEDURES

2001-01-10 Thread Eric Barr
I've gotten one result set back from exec before ...never tired multiple, but I don't see why not ...its Executing SQL. BUT, be careful with EXEC ...you can incur some pretty significant performance hits . it messes up the SP plan caching, i.e. loosing one of the major benefits of SP's

RE: Distributed Processing regarding CF and a separate Web Server

2001-01-10 Thread Eric Barr
I remember asking about this at the Allaire DEV conference 2 years ago I'm by no means an authority ...but I think I can answer some of these, if anyone know better speak up. 1) I'm entirely sure, I remember the developer saying RPC, but Allaire seems to be saying "standard TCP/IP sockets"

RE: OT STORED PROCEDURES

2001-01-10 Thread Andy Ewings
It's only the statement within the EXEC that does not get precompiled, the sp that contains the EXEC will still be compiled. I do agree that performance will be affected but how much it will be affected all depends on what the statement does and what proportion of the SP it is.

RE: OT STORED PROCEDURES

2001-01-10 Thread Peter Stolz
Use sp_executesql instead of EXEC() to run your dynamic SQL. It caches the query plans. P. -Original Message- From: Eric Barr [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 7:59 AM To: CF-Talk Subject: RE: OT STORED PROCEDURES I've gotten one result set back from exec

RE: Questions for Certification

2001-01-10 Thread Jeff Sarsoun
The answer is b. When you create a cfx tag in java you have the three available to you for development. Jeff Sarsoun -Original Message- From: Rajesh Kumar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 3:19 PM To: CF-Talk Subject: Questions for Certification Hi All,

RE: Distributed Processing regarding CF and a separate Web Server

2001-01-10 Thread JustinMacCarthy
I agree with all that Eric said regarding this. Just to add I heard that proformance is dreadful using this method There is a stub called(?) cfdist.exe to allow you do this. ~ Justin ~~ Structure your ColdFusion code with Fusebox. Get the

customtags complaining that required parameters are not set, but they are.

2001-01-10 Thread Mary_Baotic
Occasionally I have a problem where a customtag will complain that a required parameter isn't set. I have double checked and the parameter is spelled right and is being passed to the customtag. Is there any other reason CF would throw this error even though it's there? Perhaps a umatched

Re: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread mark_wimer
Jon, I found your review very helpful! I'll get UD4 when I upgrade instead of DW4. It actually includes CFINCLUDEs? Great! Does it read application.cfm? This would be very useful. For instance, I put my style sheets into a header file that is included in application.cfm. That means when I open

Re: customtags complaining that required parameters are not set, but they are.

2001-01-10 Thread Brendan Avery
I believe that error is thrown whenever a CFPARAM tag doesn't have a default and the variable has not yet been created. You may want to check the custom tag for the relevant CFPARAM -brendan avery / [EMAIL PROTECTED] At 08:36 AM 1/10/2001 -0500, you wrote: Occasionally I have a problem where

RE: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread Joshua Miller
As far as my opinions on the XML methodologies, your answer that some things have to be learned is kind of a slippery-slope argument ... if you argue that some things just have to be done by hand in regards to XML, what happens if someone argues the same defense for tables or links? At what point

Re: customtags complaining that required parameters are not set, but they are.

2001-01-10 Thread Mary_Baotic
I answered my own question. It helps not to look at the same code for extended periods of time, you miss that you are forgetting the word "attributes."! Mary

RE: Searching

2001-01-10 Thread Eric Barr
If I had to take a shot in the dark you probably don't want one big text / char field for this. If you do have a NEED for a single column that appears like this you might want to check out computed columns (in SQL, I'm sure other RDBMS'es have similar features). It will allow you to have

(little OT) MS Word 2000 convert to HTML

2001-01-10 Thread Eric Dawson
Remember when Word just handled the files the way they were. sigh. Trying to do something that used to be simple, as the easy way to get something started, has turned into the proverbial pain in the ass. I have a word perfect document that I want to quickly convert with formatting to a few

Re: CFFORM Problem

2001-01-10 Thread David E. Crawford
Take out the CFOUTPUT and it should work. CFFORM behaves as if it is an implicit CFOUTPUT in many cases. Dave - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 02:13 Subject: CFFORM Problem This throws an

RE: (little OT) MS Word 2000 convert to HTML

2001-01-10 Thread Martin Sutton
Dreamweaver (gulp) has a clean up Word HTML feature which kind of works. Get the trial version and give it a try. Martin. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: 10 January 2001 14:27 To: CF-Talk Subject: (little OT) MS Word 2000 convert to HTML Remember

RE: (little OT) MS Word 2000 convert to HTML

2001-01-10 Thread James Maltby
We've written a word 2000 buster cftag - which converts files specifically from word - converts lists, paras, most formatting, etc. but is bespoke for job - our job required that the first line of the word document was bold for example. James -Original Message- From: Eric Dawson

cfFtp general questions

2001-01-10 Thread cf kaizen
Hi, I'm trying to upload files to my ISP using CFFTP. I keep getting the following error message: "Cold Fusion error code 1, FTP error code 2): Cannot put local file c:\imageFile.gif to remote file imageFile.gif: The system cannot find the file specified." Failing to figure out how to upload,

Re: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread Greg Wolfinger
By the way, what happened to UltraDev 2.0 and 3.0? Can you really just jump from 1.0 to 4.0 in one version? Sounds a little Netscape-ish to me :) They did this so that Dreamweaver and Dreamweaver UltraDEV would be at the same version number, since UD came out when DW was in version 3.0 --greg

Need Help with CFLOOP and CFINPUT

2001-01-10 Thread Kollodge, Lynn M.
Dear List, I was recently moved from an Access Database Developer to a Web Developer. CF classes don't start until Feb. 14, and have already been given projects using CF and sure could use your expertise. I am to create an internal order sheet for our Food Services Dept. This sheet will

Re: CFFORM Problem

2001-01-10 Thread paul smith
Yep! That was it. Thanks! best, paul At 09:33 AM 1/10/01 -0500, you wrote: Take out the CFOUTPUT and it should work. CFFORM behaves as if it is an implicit CFOUTPUT in many cases. Dave This throws an error if I change it to CFFORM: FORM

WDDX for Cobol

2001-01-10 Thread David E. Crawford
I know this sounds like a completely lame question, but has anyone attempted to create a WDDX component for COBOL? I have a legacy system integration project that would be greatly simplified with the ability to have WDDX or other XML component to deal with some data transfer. This is on an

RE: WDDX for Cobol

2001-01-10 Thread Robert Everland
Well if you have Client access to connect to the AS/400 and it's using an offshoot of DB2 somewhere which AS/400 usually uses, you should be able to query the database with an odbc connection. We do this now with AS/400 and RPG. Robert Everland III Web Developer Dixon Ticonderoga -Original

RE: WDDX for Cobol

2001-01-10 Thread Simon Horwith
I've not heard of this, but one thing you might want to do is either write or search for a java class to do this. If your OS400 version is less than 5 years old, then it should have a local JVM that you could interface with. Java has excellent XML parsing capabilities, and would be the ideal

RE: (little OT) MS Word 2000 convert to HTML

2001-01-10 Thread Christopher Olive, CIO
there's a perl script on CPAN that claims to do this. i haven't used it, so i can't speak for its effecitveness, but you might want to give it a try. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Eric Dawson [mailto:[EMAIL

Re: WDDX for Cobol

2001-01-10 Thread David E. Crawford
In production we will not have ODBC connectivity to the database, but will only be calling a stored procedure which executes a COBOL routine. Right now I am getting a huge string back, delimited by the | character. The downside is that the client side of this is in JSP. My parsing skills in

LDAP

2001-01-10 Thread Stefan
Hello, does anyone know of alternatives to the CFLDAP tag. We are having problems with CFLDAP tag and LDAP3 functions that are not suported by CFLDAP like "newsuperior" or "deleteoldrdn". Thanks for any help Stefan ~~ Structure your ColdFusion

RE: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread Adam Reynolds
Not sure if this is useful bt... I only briefly dived into UD and reverted straight back to the Dreamweaver/Firweorks/CFStudio combination and to be honest nowadays I really only use Cfstudio with Fireworks. Dreamweaver is only ever lightly touched. The reasons are primarily to do with the

Re: Questions for Certification

2001-01-10 Thread Alex Puritche
Rajesh, Go here http://www.allaire.com/CFDOCS/dochome.htm Click on the "Search" icon and you'll find answers on most of your questions. Brainbench test is based on the Allaire documentation. Tuesday, January 09, 2001, 10:19:14 PM, you wrote: Rajesh Hi All,

RE: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread Brendan Avery
btw: if you want to experiment with XML, there is a really great free beta tool by Architag.com called XRay http://www.architag.com/xray/ I suggest you download it while it's still free. Really neat. --brendan avery / [EMAIL PROTECTED] At 09:01 AM 1/11/2001 -0500, you wrote: As far as my

RE: WDDX for Cobol

2001-01-10 Thread Russel Madere
There is also an ODBC drive for NT To directly pass ODBC commands to a DB2 database by a company called Hit Software (http://www.hit.com). It is easy to set up and then appears to Cold Fusion like any other datasource. We used it over Client Access because of the ease of configuration and

RE: OT STORED PROCEDURES

2001-01-10 Thread William J Wheatley
ok how would you use SP_execute sql with coldfusion then? =) and the reason i'm wanting to use STored Procedures is because this takes about 30 seconds to run via Queries, and joins temp tables, etc so i want to make this into a stored Procedure to speed it up. I've noticed just the start

RE: Faster Join

2001-01-10 Thread Philip Arnold - ASP
What would be faster an inner join, an outer join, or a where something = something join. I am working with huge queries and a little bit of time on a small query could translate to a huge gain on my joins. This really all depends on the data But a Stored Procedure would be faster

Re: Need Help with CFLOOP and CFINPUT

2001-01-10 Thread Deanna L. Schneider
You're almost there - you just need to add the input box within your output, like so. (This assumes here that you're just trying to determine which flavors someone wants, not how many.) cfoutput query = "getFlavor" input type="checkbox" name="muffinorder" value="#flavorid#" #flavordesc# br

Re: Need Help with CFLOOP and CFINPUT

2001-01-10 Thread Deanna L. Schneider
Doh, slow down and read the whole post, Deanna. Let me try that again: table tr tdFlavor/td tdSunday/td tdMonday/td ---etc--- /tr cfoutput query = "getFlavor" tr td#favordesc#/td tdinput type="text" name="sun#flavorid#" size="5"/td tdinput type="text" name="mon#flavorid#" size="5"/td ---etc---

RE: Dreamweaver UltraDev 4.0 and Cold Fusion

2001-01-10 Thread Paul Ihrig
As far as the code UD4 generates, specifically CF Script, i don't care for. i know it is just the first step, but for me at times it is a bit tricky to follow. I enjoy use the ud/fw4 package about 8-10 hours a day. but i still am hitting Ctrl E to hop back into studio to add large chunks of

Re: Java Applet Not Working

2001-01-10 Thread pan
- Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 04:38 Subject: Java Applet Not Working Good Morning List I have a Java Applet that has been running on a site for quite some time and now all of a sudden

RE: WDDX for Cobol

2001-01-10 Thread Russel Madere
I can't really say, our setup was not very optimized and I never did use Client Access myself. I relied on my supervisor's evaluation. However, I remember retrieving a 13,000 personnel record set at peak time on both the AS/400 and Web server in less than 3 minutes. It sounds like a long time,

Joust

2001-01-10 Thread Howie Hamlin
I remember a while back that someone said they were working on a custom tag to integrate CF sith Joust. Did that ever get finished? If so, is it available? Thanks, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server

RE: WDDX for Cobol

2001-01-10 Thread JustinMacCarthy
David , doing WDDX in java isn't too hard.. there are examples in wddx SDK. Otherwise there is Perl wddx? Using | could get ugly.. some sort of encoded is going to be needed... Justin -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001

Re: Joust

2001-01-10 Thread David E. Crawford
I have done some work on it. I took the basis of the code that Nate Weiss wrote for the WDDX SDK (www.wddx.org) and modified it for my own purposes. Nate documents the use of WDDX to populate the Joust Tree. I can give some guidance if needed. Dave - Original Message - From: "Howie

Convert Access Application to Cold Fusion

2001-01-10 Thread Pete Smith
My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking forward to re-writing all of the

Example/Code of Current Users On Site?

2001-01-10 Thread Stephen R. Cassady
Does anyone have a good example / code / method / approach for building a system for displaying the users currently on the site? I don't need the display code, but a few more examples on how to handle the ?Session Variables? for such a practice, unless there is a different way? Thanks -

Re: Convert Access Application to Cold Fusion

2001-01-10 Thread Ryan
At 10:07 1/10/01 -0600, you wrote: My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking

Re: Convert Access Application to Cold Fusion

2001-01-10 Thread Eric Dawson
commerceblocks.com I have a generator I use, but its pretty crappy, and requires considerable effort to finish a site. Eric From: "Pete Smith" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Convert Access Application to Cold Fusion Date: Wed, 10 Jan 2001

query to struct?

2001-01-10 Thread Mak Wing Lok
does anyone knows how to convert a query result set to a structure? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Cold Fusion and .shtml or Server Side Includes

2001-01-10 Thread net_man
Good Day, I am having a weird problem when my IIS 5.0 server has a .shtml document as a default Document for a website. I am thinking maybe Cold Fusion has done something to cause this as it works fine on a server that has no cold fusion access. The problem is that when I try to view the site

App timeout and caching

2001-01-10 Thread David Shadovitz
Would someone please confirm this? The behavior, that is, not the syntax. Just looking for a second pair of eyes (or whatever your species uses) on this. If you use CFAPPLICATION APPLICATIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#", the app will time out after 1 hour of *non-use*, not after 1 hour.

What should be easy has eluded me...

2001-01-10 Thread James Taavon
I am trying to distinctly count the number occurences of jobs for different agencies in my application. The query spits back all records giving the total in the system being 47 and listing it 47 times against each agency. This obviously is not what I want. How do I get the output to read Agency

RE: CF_Activedit alternatives??

2001-01-10 Thread Philip Arnold - ASP
If you're willing to go with an IE-only solution, it's easy enough to write your own. Go to msdn.microsoft.com and do a search for "DHTMLEdit" (this control is built into IE) ActivEdit is built around the DHTMLEdit functionality, as is ezEdit Philip Arnold Director Certified ColdFusion

OT - encryption for sql 7.0

2001-01-10 Thread Rick Lamb
I've tried to get some help for this from the sql lists but haven't got any response, so I'm going with the trusty CF group on this. Is what I'm looking for is software to encrypt certain table fields in a sql 7.0 database. I would also like to here from any of you on how you handle sensitive

Re: Custom Tag for creating Forms...

2001-01-10 Thread David Cummins
I think a custom tag is going about it the wrong way... extra processing time, limited formatting... Why not write a form generator? Creates the CF code for you, then you just tailor? What would be even better is if its generated code were delimited into sections, and it could detect if you

Re: Example/Code of Current Users On Site?

2001-01-10 Thread Scott Weikert
I saw something like this not long ago... I'm trying to remember how it worked. It was something like... have a table that you write a UID and the current time into, each time a page is viewed. (Something in application.cfm I would imagine, if your session is active at the time). This way, every

Re: Example/Code of Current Users On Site?

2001-01-10 Thread paul smith
Statistics Server does this, as just one feature of its web statistics capability. Great product! www.mediahouse.com best, paul At 02:29 PM 1/10/01 -0700, you wrote: Does anyone have a good example / code / method / approach for building a system for displaying the users currently on the

OT State Sales Tax Tables

2001-01-10 Thread Dan O'Keefe
Does anybody know of a source where I can get the 50 records for the state sales tax percentage? Dan - Dan O'Keefe TriPoint Technologies 954.675.3115 ~~ Structure your ColdFusion code with Fusebox. Get the

request scope revisted

2001-01-10 Thread Won Lee
Anyone out there set a request.dsn instead of an application.dsn? If so is there an advantage? Won ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Semi-OT - Zip code dbs/dist. formulas?

2001-01-10 Thread Scott Weikert
Hey gang, I'm wondering if anyone has, or can point me at, a good (i.e. cheap or free) source for zip code data, along with lat/long values for each, and the mystical formula for calculating the distance between one lat/long and another lat/long. Thanks, --Scott

Re: CFFILE Delete then WRITE issue....

2001-01-10 Thread Wallace Randall
Have you attempted to re-name the file and then delete it. That may prevent the delay in actually deleting the file from interfering with your re-write of the original file name. - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09,

Re: OT STORED PROCEDURES

2001-01-10 Thread moonerent
Great feed back on this, it's adding to my research. Just know I said SQL gurus (often purists) said to avoid. Peter has a great idea here that should make the purists and the rest of us happy enough. Below you'll find the BOL description of sp_executesql... HTH, Rick sp_executesql Executes a

HELP with SP2 upgrade

2001-01-10 Thread Dylan Bromby
hey all - i was running 4.0.1ENT and decided to upgrade to 4.5ENT SP2. first, i used my old 4.5ENT upgrade which went along fine, but now when i try and upgrade using the SP2 download from allaire's site, it tells me i need to have 4.5 or 4.5.1 loaded first! anyone got a suggestion??? thanks!

Different Stored Proc Help

2001-01-10 Thread Joe Sheble aka Wizaerd
I ahve a stored procedure that checks to see if any records exisit, and if not creates a default one. The it polls the database and creates basically an empty query. The problem is if this new default record gets created, my main resultset variable does not contain a valid query. Whereas if

RE: SESSION Timing out WAY before it's supposed to.

2001-01-10 Thread Joshua Miller
For all you out there experiencing SESSION timeouts ... I found the problem cfserver.exe will restart after x unresponsive requests or may be set to restart every so often ... that kills your session and application variables. Our server was set to restart cfserver.exe every 30 minutes so

RE: (little OT) MS Word 2000 convert to HTML

2001-01-10 Thread Robert Everland
If you use word 97 it changes it to very simple html. I chose to use 2000 for an intranet site because the html would look exactly like the word doc, but I could understand wanting only the html. I am sure if you don't have 97 and want to be hasseled you could always parse through the html and

RE: Joust

2001-01-10 Thread ron
I remember a while back that someone said they were working on a custom tag to integrate CF sith Joust. Did that ever get finished? If so, is it available? Haven't done a CF app with Joust (a DHTML hierarchical menu library), but we use Joust in our http://killerwebmail.com product that

RE: Java Applet Not Working

2001-01-10 Thread Larry Juncker
THANK YOU THANK YOU THANK YOU That was exactly the problem. I do not understand why it was working for awhile and then quit, but it is working, that is the important thing. Thanks Again Larry -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001

CFSELECT and Java

2001-01-10 Thread Cami Lawson
Is there a way to check the value of a CFSELECT with a Java script? I have 3 CFSELECTs on one page and I need to compare them against each other before they go to the CFFORM action. TIA ~~ Structure your ColdFusion code with Fusebox. Get the

Re: Convert Access Application to Cold Fusion

2001-01-10 Thread Michael
I'll second that, and would love to know the answer or maybe a utility or something like that. Michael Pete Smith wrote: My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on

ORDER BY question

2001-01-10 Thread Erika Foster
I have a table that has three fields: Paragraph, Title, Content. The Paragraph field is a text field, but is the outline number for the particular paragraph in a document. For example, 7.1.1, 7.1.2, etc. I need to output these paragraphs in outline order as they appear in the printed material.

Re: Convert Access Application to Cold Fusion

2001-01-10 Thread Stephen M Aylor
Doesnt Access2k allow you to publish all this (forms, reports) to HTML? Steve - Original Message - From: "Pete Smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 8:07 AM Subject: Convert Access Application to Cold Fusion My client has a

RE: OT STORED PROCEDURES

2001-01-10 Thread Dave Watts
BUT, be careful with EXEC ...you can incur some pretty significant performance hits . it messes up the SP plan caching, i.e. losing one of the major benefits of SP's ...speed. Use sp_executesql instead of EXEC() to run your dynamic SQL. It caches the query plans. If you're

RE: Faster Join

2001-01-10 Thread Dave Watts
But a Stored Procedure would be faster still than just running the SQL via a query (although you couldn't cache it) You can't use CACHEDWITHIN/CACHEDAFTER to cache a recordset returned with a CFSTOREDPROC tag, but you can call stored procedures from CFQUERY on some platforms (such as SQL

Can you cache CFSoredProc?

2001-01-10 Thread cf kaizen
Hi, I'm using CFStoredProc for Access queries. Is there any way to cache them? Thanks in Advance, Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Re: Joust

2001-01-10 Thread Howie Hamlin
Anything that you could share would be most appreciated. Regards, Howie - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 11:23 AM Subject: Re: Joust I have done some work on it. I took the basis of

Re: (little OT) MS Word 2000 convert to HTML

2001-01-10 Thread Keith C. Ivey
Eric Dawson wrote: What are you guys using to convert word to simple html. Dave Raggett's HTML Tidy has an option for cleaning up MS Word 2000 junk, and it can do lots of other things as well. It's free: http://www.w3.org/People/Raggett/tidy/ Keith C. Ivey [EMAIL PROTECTED] Webmaster,

RE: SESSION Timing out WAY before it's supposed to.

2001-01-10 Thread Jann VanOver
Beware! Mastering Cold Fusion 4 has MANY MANY misprints in it. -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 3:34 PM To: CF-Talk Subject: RE: SESSION Timing out WAY before it's supposed to. If removing those double quotes is the

Problem with long string

2001-01-10 Thread Lon Lentz
I have a string within a cfloop(query). The string itself is kinda long. Inside the loop, certain query variables are placed, and the string is appended to a master string. The problem I am having is that there are roughly 10 character chunks missing from the final product. And it seems

RE: date funcions in netscape

2001-01-10 Thread Jann VanOver
Um ... Netscape doesn't perform these functions, your server does. If you were doing it in Javascript, it would be up to the client (Netscape or IE), but this looks like CF code which executes on the server. As someone else hinted -- Netscape is slow to render tables so if your app has a lot of

RE: Convert Access Application to Cold Fusion

2001-01-10 Thread mherbene
I don't think you'll find an easy way. From bitter experience, let me recommend that you not lightly accept "make a web application that works just like this" as the requirements. Even though it will be frustrating for the user, you need to get them to specify what each screen and report is

Forums

2001-01-10 Thread Al Musella, DPM
I just downloaded the latest version of forums from forumspot.org and can't get it working.. my problem is the change in the database. I tried to restore the sample database that comes with the new version, (into sql server 7), and I get an error that says the header of the sample

Re: Convert Access Application to Cold Fusion

2001-01-10 Thread johnpatterson
Hi there, I am in the process of converting an Access application to SQL Server and Cold Fusion. I haven't found an easy way to convert. The only possible way I could think of is by porting the application into Access 2000 an exporting forms, etc. into HTML formats. John On Wed, 10 January

Cold Fusion and .shtml

2001-01-10 Thread net_man
Good Day, I am having a weird problem when my IIS server has a .shtml document as a default Document for a website. I am thinking maybe Cold Fusion has done something to cause this as it works fine on a server that has no cold fusion access. The problem is that when I try to view the site I

RE: Searching Multiple Data Ranges

2001-01-10 Thread johnpatterson
Thanks Bryan, You were right-on with the quotes. John On Tue, 09 January 2001, Bryan Batchelder wrote: throw some single quotes around the office IDs AND tblReferrals.strRefOfficeIDFK BETWEEN '#StartSort#' AND '#EndSort#' --b

CFX_POP

2001-01-10 Thread David Cummins
Hi fellow CFers, I've heard a lot about a CFX_POP tag that will fix all your mail fetching woes... does anybody know where it is? I can't find it in the Allaire tag gallery or through Google, only mentions of it being used. Help! David Cummins

RE: Escaping quotes in Replace function for SQL Server 7

2001-01-10 Thread Jann VanOver
Escape single quotes to SQL with \' -Original Message- From: Dixon, Aidan [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 7:08 AM To: CF-Talk Subject: Escaping quotes in Replace function for SQL Server 7 We have a classified ads section on our intranet currently running on

SQL subquery question

2001-01-10 Thread Mary Fowler
Greetings, I have two tables. One (SECTIONS_DATA)is the main line item table of a budget. The second (ADJUSTMENTS)lists adjustments made to various line items of items in SECTIONS_DATA. The result set I am trying to get is one that can display the line items from SECTIONS_DATA with an

RE: nested cfoutput with cfmai /error says to use group methodl

2001-01-10 Thread Jann VanOver
It may not be clear from the documentation, but CFMAIL ACTS like a CFOUTPUT tag (with no query name). You do NOT have to use CFOUTPUT to access CF variables inside the CFMAIL tag. Try just taking the CFOUTPUT tags out. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: padding a variable

2001-01-10 Thread Jann VanOver
Some of Katrina's code could be even shorter. Check out the functions "LJustify", "Rjustify", "CJustify" and "RepeatString" - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, November 03, 2000 12:53 PM Subject: RE: padding a

RE: high profile CF sites...

2001-01-10 Thread Philip Arnold - ASP
Just had a look at the mbe siteanyone have a clue as to why they would set up their ALT tags like thisit looks weird in the browser and seems a little silly to me? IMG alt='MBE#13;#10;#13;#10;#13;#10;#13;#10; Online, Connect#13;#10;#13;#10;#13;#10;#13;#10; for

  1   2   >