RE: Help! - Dynamically Generate Forms from SQL DB - Bad Idea?

2004-07-29 Thread Micha Schopman
I created some screenshots, the languagepack used is dutch. http://www.formmanager.nl/fm1.jpg http://www.formmanager.nl/fm2.jpg http://www.formmanager.nl/fm3.jpg http://www.formmanager.nl/fm4.jpg Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel

RE: DHTML recursion problem

2004-07-29 Thread Micha Schopman
Just a word of advice, place the entire business logic of recursion in a stored procedure. What you do know, is make numerous calls to the database server, which is by far, more slower and cpu intensive than putting the job at SQL Server. tSQL gives you enough functions and possibilities to get

RE: HELP - having trouble with a insert query.

2004-07-29 Thread Pascal Peters
Or even better: USE CFQUERYPARAM cfparam name=form.size1qty value= ... cfquery ... cfqueryparam cfsqltype=cf_sql_numeric value=#form.size1qty# null=#YesNoFormat(NOT Len(form.size1qty))# ... Pascal -Original Message- From: Robert Munn [mailto:[EMAIL

Re: HELP - having trouble with a insert query.

2004-07-29 Thread Robert Munn
Or even better: USE CFQUERYPARAM cfparam ... cfparam name=form.size1qty value= But make sure to NULL your default values ... cfparam name=form.size1qty value=NULL [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

Component Paths in Distributed Applications

2004-07-29 Thread Greg Landers
Here is a multi-part question regarding components that I have been pondering for some time now. What is the best method for handling component paths in a distributed application? I have found that CFC component files can be referenced using a period or a forward slash ... example:

RE: HELP - having trouble with a insert query.

2004-07-29 Thread Pascal Peters
NO, CFQUERYPARAM The cfparam is there because cfqueryparam can't handle the value attribute if the variable doesn't exist (read my first post entirely)! I want to insert null if the string is empty. The point is you should always use cfqueryparam in your queries (as discussed in about a hundred

The search is killing the server. Please help!

2004-07-29 Thread cf coder
Hello everybody, I'm working on a logging system. The site search as you can imagine is very complicated and a lot depends on it. I have written a stored procedure for the search to make the search quicker with a lot of inner and outer joins (the usual). The seach is very quick most of the times,

RE: The search is killing the server. Please help!

2004-07-29 Thread Hugo Ahlenius
I think you can do it in sql, but I'm no wizard there -- I am sure there is one of the SQL Aces that can answer you there. But what you can do -- store the result query in the session scope, then you can QoQ it to get the results that you want, without having to go to the database. By the way --

RE: The search is killing the server. Please help!

2004-07-29 Thread Hugo Ahlenius
Your message is a reply to anothers post and is more than 100 lines of text. Unless you are a major writer, your probably adding a lot of the previous replies. Please trim your posts when replying. Thank you. I think you can do it in sql, but I'm no wizard there -- I am sure there is one of

RE: The search is killing the server. Please help!

2004-07-29 Thread Micha Schopman
Try using full text search, which gives far more superior speeds, and superior search results. Why do you need 5000 results btw, do you really think someone is going to browse them all? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax

RE: Mapping .html in CFMX 6.1 JRun version...

2004-07-29 Thread Wes
Some of this may seem obvious, but sometimes it's the obvious things we miss.So, with that being said, try this check list and see if it helps. 1. Make sure the Mappings change you made to ISS is on the site you are testing.You can make this change Master Properties area but doing this will not

RE: The search is killing the server. Please help!

2004-07-29 Thread Micha Schopman
And try using cached queries, for 1 minute or some.. :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: The search is killing the server. Please help!

2004-07-29 Thread Jim Voris
You can use cfquery in lieu of cfstored proc and cache the results. That should solve the speed for records 101-200, etc. - Original Message - From: Micha Schopman [EMAIL PROTECTED] Date: Thu, 29 Jul 2004 13:33:48 +0200 Subject: RE: The search is killing the server. Please help! To:

Re: Best Practice - Forms

2004-07-29 Thread Adam Haskell
For most of my forms I used something like this for my SQL: IF EXISTS(Select Username From USERS where username= '#form.username#') Update Stuff ELSE Insert stuff This way if the user does go back to correct something (so long as it isn't the username). The form will update upon resubmit. Adam

Re: The search is killing the server. Please help!

2004-07-29 Thread Adam Haskell
I like Hugo's idea of putting the query result in a session variable. But you shouldn't have to do a QofQ you should jsut be able to use your current code. If you want to change your SQL as far as I know the only way to do this is something like this: SELECT Top 100 Partnumber From Products WHERE

Re: The search is killing the server. Please help!

2004-07-29 Thread Aaron DC
Have a look at the help for CFQUERY and CFOUTPUT. In particular: CFOUTPUT - StartRow and Maxrows attribues. CFQUERY - CachedWithin attribute I would either cache the query or store it in a scope. Then output the records you require using startrow (= (page num -1) * 100) and maxrows (= 100).

RE: The search is killing the server. Please help!

2004-07-29 Thread Micha Schopman
Caching queries in application scope is a gray area, sometimes it can be implemented very soon, and sometimes it is very hard to implement. It all depends on the sql code being executed. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax

Strange server issue

2004-07-29 Thread Matthew Fusfield
Last weekend, we installed CFMX 6.1 on a server running CF5 on Windows 2000. We are running MX on its standalone web server as well as 1 IIS server, while the remaining IIS servers are running CF5. Since that time, every evening the server loses network connectivity and requires a reboot to get

RE: Strange server issue

2004-07-29 Thread Mark A. Kruger - CFG
Matt, I'd say your guess that your install has something to do with it is a red herring.Something has changed the way it handles idle time suspension or power or somehting.Also, when you say cannot access the network from the server - what do you mean? Do you mean you can't ping an IP address...

RE: Mapping .html in CFMX 6.1 JRun version...

2004-07-29 Thread Wes
I did this as a test and along each step of the way I tested the page with the same result you are having.It took a full WWW service restart after all settings where added to make it work. Hope this helps. Wes -Original Message- From: Wes [mailto:[EMAIL PROTECTED] Sent: Thursday, July

Re: Strange server issue

2004-07-29 Thread Matthew Fusfield
Mark - No network access at all, can't ping either via DNS or IP, and cannot ping the default gateway. I've checked the other servers on the same network and none have had any network issues. I've even tried swapping switch ports to see if there was an issue there and nothing changed. I've done

SOT: @@RowCount equivalent in Oracle

2004-07-29 Thread Rick Root
I'm having a problem with an update query in a web service in which the update doesn't seem to be performed I've output the SQL (by returning it) and the SQL is correct and works when run within SQL*Plus. I'm 100% positive that it's RUNNING the code and I can't figure out why it's not

Re: Need recommendations for charting engines

2004-07-29 Thread Deanna Schneider
A little late to the conversation - but we're using the bline components to generate flash charts. Works slick and the support is top-notch (thanks, Sam). - Original Message - From: Dave Wilson Hi all, I've been caught short once again by cfchart's inability to handle dates and

RE: Need recommendations for charting engines

2004-07-29 Thread Micha Schopman
I am very happy with swiff chart, www.globfx.com http://www.globfx.com/:-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription]

Re: Mapping .html in CFMX 6.1 JRun version...

2004-07-29 Thread Rey Bango
Thanks alot, Wes. The one thing I didn't do was restart IIS so I will definitely give that a shot. I truly appreciate your efforts. Rey... - Original Message - From: Wes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 29, 2004 9:06 AM Subject: RE: Mapping .html in

Re: SOT: @@RowCount equivalent in Oracle

2004-07-29 Thread Janet Schmitt
Immediately after doing the update, you can use sql%rowcount to determine the number of records processed. Here is an example of using sql%rowcount and the variable i would contain the rows processed: begin update customers set email = email || '2' where email like 'test%'; i:=sql%rowcount; i

CFMX / JRUN / Apache virtual servers

2004-07-29 Thread Doug Hughes
Hello All, I'm trying to figure out some of the technical details behind setting up multiple instances of CFMX via JRUN and hooking those into Apache virtual servers. I've already installed Apache and setup a few virtual servers.I've also installed CFMX on JRUN and hooked JRUN into Apache€¦ or

Re: The search is killing the server. Please help!

2004-07-29 Thread cf coder
a lot of people have suggested that I cache the results. To do this I must use the cfquery tag, but I'm using the cfstoredproc tag. Is there any cachedwithin equivalent? someone else suggested that I store the results in session variables. Won't there be a performance hit by storing for ex 5000

RE: The search is killing the server. Please help!

2004-07-29 Thread Micha Schopman
You have 2 options, Use cfquery to execute the stored procedure (I prefer this method, much better readable instead of that ugly cfstoredproc tags) and then cache it. Or define a sql code based variablename based on the parameters in the sql to store the data into an application variable. Micha

Re: The search is killing the server. Please help!

2004-07-29 Thread G
I've always used CFQUERY as well when executing stored procedures.but you've got me wondering, is there a performance hit that occurs here? Or are there other distinct advantages to using CFSTOREDPROC tag? Brian - Original Message - From: Micha Schopman To: CF-Talk Sent: Thursday,

RE: The search is killing the server. Please help!

2004-07-29 Thread Micha Schopman
I always have used cfquery, according to Macromedia document cfstoredproc should be faster, but I've only seen the opposite being true. Like it is important though if one function is 0.1 ms faster than the other function ;) I prefer cfquery because it makes my code more readable, and I see

Re: The search is killing the server. Please help!

2004-07-29 Thread G
Same here. CFQUERY is such a flexible tag, i abuse the heck out of it. - Original Message - From: Micha Schopman To: CF-Talk Sent: Thursday, July 29, 2004 9:21 AM Subject: RE: The search is killing the server. Please help! I always have used cfquery, according to Macromedia document

Problems with CFQUERYPARAM

2004-07-29 Thread Rick Root
Rick Root wrote: I'm having a problem with an update query in a web service in which the update doesn't seem to be performed I've output the SQL (by returning it) and the SQL is correct and works when run within SQL*Plus. I'm 100% positive that it's RUNNING the code and I can't figure

RE: The search is killing the server. Please help!

2004-07-29 Thread Hugo Ahlenius
Micha, Why are you talking about application variables? Are you suggesting a struct of different keywords? Since the queries will be different for each user (using different keywords), and the refinement/paging would be per user, the session scope would make sense, right? No need for caching

cfmx tailspin.......death follows

2004-07-29 Thread Tony Weeg
ok. in the past two days, and with no conceivable pattern, my cfmx server has basically tailspun down to a sloww death.it appears that a query or two, some long ones, that are tuned to the nth degree, but still require being time intensive, are being used, then slowly the server dies.no

RE: Problems with CFQUERYPARAM

2004-07-29 Thread Pascal Peters
Have you tried cf_sql_numeric ? Pascal -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 16:33 To: CF-Talk Subject: Problems with CFQUERYPARAM Rick Root wrote: I'm having a problem with an update query in a web service in which the update

Re: Best Practice - Forms

2004-07-29 Thread Jason Lemahieu
You could also generate the ID for the record on the page where they enter data, and pass it to the page that processes it.This way, you can first see if the record exists (yes = update, no = create).You may end up with IDs that get selected and not used, but such is life. [Todays Threads]

Re: The search is killing the server. Please help!

2004-07-29 Thread cf coder
I don't know how to user cfquery to execute the stored procedure. I thought they are tags that compliemnt each other (either or). I might be wrong but are you suggesting to wrap the cfstoredproc code inside a cfquery tag? Sorry if this a silly question to ask [Todays Threads] [This Message]

Re: The search is killing the server. Please help!

2004-07-29 Thread Adam Haskell
Yes cfstoredproc is supposed to be faster...I beleive I read/heard somewhere that cfstoredproc only takes 3 steps to exectute everything and cfquery requires something like 10 steps(might have been a dream)...I have not seen a difference generally. Adam H On Thu, 29 Jul 2004 16:21:16 +0200,

RE: The search is killing the server. Please help!

2004-07-29 Thread Micha Schopman
The situation is a bit more complicated, with cachedwithin you have the power of caching + defining the expiration. The negative effect of cachedwithin is that it uses a first in first out system, because ColdFusion has only has a maximum amount of cached queries it can hold (defined in the cf

RE: The search is killing the server. Please help!

2004-07-29 Thread Andrew Tyrone
On my last project I had to present a large amount of items to the user using a next/prev style interface.Since there were a lot of filters to narrow down the returned data, I just ended up presenting the top 20 items to the user and basically forced them to use the filter to narrow their search.

CFCACHE produces blank page on the first load.

2004-07-29 Thread Wes
When I use the cfcache tag to cache a page on the server, on any pages fist load, the server returns a blank white page.A view source of that page shows a generic HTML page that includes the HTML, HEAD, and BODY tags that contain no data.This HTML that is produced is not anywhere in my code.On

RE: The search is killing the server. Please help!

2004-07-29 Thread Andrew Tyrone
I don't agree with this.You can cache pretty much any query as long as the server has the resources, but that doesn't mean you should cache everything. In my experience caching in general takes a bit of forethought to implement in the most efficient way.As long as you return a query, you can cache

Re: The search is killing the server. Please help!

2004-07-29 Thread G
You simply put the procedure call inside the cfquery tag, where you would normally write your SQL. cfquery EXECUTE procedureName /cfquery - Original Message - From: cf coder To: CF-Talk Sent: Thursday, July 29, 2004 9:52 AM Subject: Re: The search is killing the server. Please

Incorrect ORDER in query of query

2004-07-29 Thread Claude Schneegans
Hi, Is there some known problem with queries of queries in CF 5? I have this query: CFQUERY NAME=getSchemas DBTYPE=query SELECT schema, tableType, count (*) AS nbTables FROM getTables GROUP BY schema, tableType ORDER BY schema /CFQUERY It is supposed to count tables by table type and

SOLVED: Problems with CFQUERYPARAM

2004-07-29 Thread Rick Root
Pascal Peters wrote: Have you tried cf_sql_numeric ? Actually it was on the string, which is a CHAR(8) I changed it to CF_SQL_CHAR, and it still didn't work... then I used LJustify() to pad the value to 8 characters (it was only 6)... so now THIS works: WHERE prfid = CFQUERYPARAM

RE: Best Practice - Forms

2004-07-29 Thread fbx-lists
I have done it before storing the entire form contents into a session variable, but storing the record ID might be simpler.I will have to think about this one some more. Thanks for all of the feedback. -- Jeff Quoting Tangorre, Michael [EMAIL PROTECTED]: Right after your initial insert set a

Link to current thread in cf-talk emails

2004-07-29 Thread Rick Root
For a few hours last month or so, the email messages included a link to the entire thread on the house of fusion web site.I thought they were a little obnoxious placed at the top of the message, but I'd REALLY love to see that link added to the bottom of each message.That was a really nice

Re: CFMX / JRUN / Apache virtual servers

2004-07-29 Thread Greg Stewart
Hi Doug, You'll need to modify your httpd.conf file to look something like this: VirtualHost * ServerAdmin [EMAIL PROTECTED] DocumentRoot /your/document/root ServerName your.domain.com ErrorLog logs/yourErrorLog-error_log CustomLog logs/yourAcesslog-access_log common JRunConfig Serverstore

Question about cfqueryparam

2004-07-29 Thread Joshua OConnor-Rose
Sorry if this question has been answered already. I searched the list but putting that particular tagname returns plenty and most of it is advice to use it. For search pages I started to put the where statement together into a variable request.filter this worked fine but we just upgraded the

RE: Question about cfqueryparam

2004-07-29 Thread Pascal Peters
You can't use cfqueryparam like this, it won't get evaluated. It has to be in the cfquery. cfquery datasource=media name=get_office select office_id from office #request.filter# where 0=0 cfif len(attributes.office_num) and office_num in (cfqueryparam list='Yes'

Re: Question about cfqueryparam

2004-07-29 Thread Joe Rinehart
Hi Josh, cfqueryparam is meant for use inside of your cfquery tags becuase it does more than string parsing. Try this out: cfquery datasource=media name=get_office select office_id from office where office_num in (cfqueryparam list='Yes' value='#attributes.office_num#'

Re: Link to current thread in cf-talk emails

2004-07-29 Thread Michael Dinowitz
They are on the bottom of each message. There's a link to this message, todays threads, subscription information, etc. - Original Message - From: Rick Root [EMAIL PROTECTED] Date: Thu, 29 Jul 2004 11:09:01 -0400 Subject: Link to current thread in cf-talk emails To: CF-Talk [EMAIL

RE: Question about cfqueryparam

2004-07-29 Thread Joshua OConnor-Rose
thanks. gee I thought I had something good going on. ah well. -Joshua O'Connor-Rose -All is Good --- Pascal Peters [EMAIL PROTECTED] wrote: You can't use cfqueryparam like this, it won't get evaluated. It has to be in the cfquery. cfquery datasource=media name=get_office select

Re: Problems with CFQUERYPARAM

2004-07-29 Thread Dave Carabetta
On Thu, 29 Jul 2004 10:33:13 -0400, Rick Root [EMAIL PROTECTED] wrote: Rick Root wrote: I'm having a problem with an update query in a web service in which the update doesn't seem to be performed I've output the SQL (by returning it) and the SQL is correct and works when run within

RE: Question about cfqueryparam

2004-07-29 Thread Pascal Peters
I forgot to delete #request.filter# in the query below -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 17:23 To: CF-Talk Subject: RE: Question about cfqueryparam You can't use cfqueryparam like this, it won't get evaluated. It has to be in the

Re: CFMX / JRUN / Apache virtual servers

2004-07-29 Thread Doug Hughes
Thanks!I'll take a look though those resources.I appreciate the help. Doug On Thu, 29 Jul 2004 16:13:31 +0100, Greg Stewart [EMAIL PROTECTED] wrote: Hi Doug, You'll need to modify your httpd.conf file to look something like this: VirtualHost * ServerAdmin [EMAIL PROTECTED] DocumentRoot

RE: The search is killing the server. Please help!

2004-07-29 Thread Dave Watts
The negative effect of cachedwithin is that it uses a first in first out system, because ColdFusion has only has a maximum amount of cached queries it can hold (defined in the cf administrator). This means if you have cached queries in a website not related to a search, those cached

RE: The search is killing the server. Please help!

2004-07-29 Thread Dave Watts
Yes cfstoredproc is supposed to be faster...I beleive I read/heard somewhere that cfstoredproc only takes 3 steps to exectute everything and cfquery requires something like 10 steps(might have been a dream)...I have not seen a difference generally. Unfortunately, things are just not that

Re: HELP - having trouble with a insert query.

2004-07-29 Thread Robert Munn
The point is you should always use cfqueryparam in your queries (as discussed in about a hundred other threads on this list). Whoops, I see the rest of the post- ;-) On an insert query like this, unless it will be used in very high volume, I actually prefer to leave the insert values inline and

Re: The search is killing the server. Please help!

2004-07-29 Thread cf coder
I don't quite understand the code you posted. cfset tmp = structNew() cfset tmp [expiration] = CreateTimeSpan(0,0,5,0) cfset tmp [variableName] = variableName cfset ArrayAppend(application.cachedQueries, tmp) I keep getting an error when I try to dump application.cachedQueries that its not

Re: Link to current thread in cf-talk emails

2004-07-29 Thread Rick Root
Deerr. *sigh*I even LOOKED at those links.Apparently, I looked without seeing. Michael Dinowitz wrote: They are on the bottom of each message. There's a link to this message, todays threads, subscription information, etc. - Original Message - From: Rick Root [EMAIL PROTECTED]

RE: The search is killing the server. Please help!

2004-07-29 Thread Dave Watts
I don't know how to user cfquery to execute the stored procedure. I thought they are tags that compliemnt each other (either or). You can invoke stored procedures using CFQUERY with some database servers, such as SQL Server. Typically, you can do this by invoking a stored procedure using

RE: The search is killing the server. Please help!

2004-07-29 Thread Tangorre, Michael
The advantages of doing this instead of using the CFSTOREDPROC tag are that you can cache recordsets using CACHEDWITHIN/CACHEDAFTER, and that you can write it a little more easily in some cases. Is there anyway to reference more than one recordset? We have a lot of stored procs that return

RE: The search is killing the server. Please help!

2004-07-29 Thread Dave Watts
I always have used cfquery, according to Macromedia document cfstoredproc should be faster, but I've only seen the opposite being true. Like it is important though if one function is 0.1 ms faster than the other function ;) If you're just calling stored procedures from CFQUERY, I doubt

Re: Link to current thread in cf-talk emails

2004-07-29 Thread Michael Dinowitz
Which is why I moved them to the top, to everyones dislike. Deerr. *sigh*I even LOOKED at those links.Apparently, I looked without seeing. Michael Dinowitz wrote: They are on the bottom of each message. There's a link to this message, todays threads, subscription information, etc.

RE: The search is killing the server. Please help!

2004-07-29 Thread Tangorre, Michael
Mik is me, Mike, my e key has some burrito in it.:-) The advantages of doing this instead of using the CFSTOREDPROC tag are that you can cache recordsets using CACHEDWITHIN/CACHEDAFTER, and that you can write it a little more easily in some cases. Is there anyway to reference more

RE: The search is killing the server. Please help!

2004-07-29 Thread Andrew Tyrone
Yeah, it's a documented tag that is nested inside the cfstoredproc tag. It's called cfprocresult and it allows you to return multiple recordsets. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 12:33 PM To: CF-Talk Subject: RE: The search

An interesting rounding oddity

2004-07-29 Thread Rob
I am not sure if this is a bug or not, nor if it has been discussed, but I just ran into it so I'd thought I'd share cfset nfactor = 2.000 cfoutputbooga#nfactor#W/cfoutput equals booga2.000W cfoutputbooga#nfactor+1#W/cfoutput equals booga3W Kind of odd that it looses it's precision - but

RE: HELP - having trouble with a insert query.

2004-07-29 Thread Dave Watts
On an insert query like this, unless it will be used in very high volume, I actually prefer to leave the insert values inline and have less code to deal with. If you are taking the pains to use cfqueryparam, you might as well push the whole query into a stored procedure. If you're

RE: The search is killing the server. Please help!

2004-07-29 Thread Tangorre, Michael
Yeah, I know about that.. I was referring to the ability to reference multiple record sets from a stored procedure when you call the procedure within cfquery tags. Mike Yeah, it's a documented tag that is nested inside the cfstoredproc tag. It's called cfprocresult and it allows you to

RE: The search is killing the server. Please help!

2004-07-29 Thread Dave Watts
Is there anyway to reference more than one recordset? We have a lot of stored procs that return 2 or 3 so we find ourselves using cfstoredproc in those instances and cfquery with EXEC PRON_NAME in other instances.. Mainly select queries where we want to cache the results. To the best of

Monitor CFMX threads

2004-07-29 Thread Mark W. Breneman
Is there any way to get a list of the current running threads for CFMX and what .cfm is being run? What I am really after is to check and see what website on our shared server (we host about 70 very low traffic sites on one box) is maxing out the CPU. Or more specifically what .cfm is causing

cfmx server crashing

2004-07-29 Thread Tony Weeg
ok. in the past two days, and with no conceivable pattern, my cfmx server has basically tailspun down to a sloww death.it appears that a query or two, some long ones, that are tuned to the nth degree, but still require being time intensive, are being used, then slowly the server dies.no

Re: Mapping .html in CFMX 6.1 JRun version...

2004-07-29 Thread Rey Bango
Damn it, Wes, I love you man!! It's like they say, 2 eyes are better than one. The only thing that I didn't restart was IIS so when I rebooted my server and sure enough, the .html files are being read correctly. Thanks again man! Rey... - Original Message - From: Wes [EMAIL PROTECTED]

RE: Question about cfqueryparam

2004-07-29 Thread Joshua OConnor-Rose
I'm back to this now Anybody seen this before? [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ 'active = 1 and adcompany = 4 where office_num in (Pa_RaM000,Pa_RaM001,Pa_RaM002)'. it says my sql

Re: DHTML recursion problem

2004-07-29 Thread Metzy Martinez
It's extremely fustrating. I'm trying to convert JAVA code into coldFusion and i tried to go with CFTREE but there is a problem with it ColdFusion 5 server. I tried to implement the recursive tree function found in the o'reilly ColdFusion 5 book. that of course is using CFtree. ughhh. thanks for

CF on Linux

2004-07-29 Thread Robert Orlini
Sorry I'm not too Linux savvy But does Cold Fusion work on Linux Enterprise server edition? No workaround for MS SQL either I guess(?) Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: CF on Linux

2004-07-29 Thread Bryan Stevenson
Sorry I'm not too Linux savvy no worriesme too ;-) But does Cold Fusion work on Linux Enterprise server edition? We run it on Red Hat 9.2 with no issues...not sure about the above edition...would guess it's fine No workaround for MS SQL either I guess(?) Yep...seperate Windows based

Re: CF on Linux

2004-07-29 Thread Barney Boisvert
Linux Enterprise Server Edition is a false name.Perhaps you mean RedHat Linux Enterprise Server?I've never tried it, but it should work fine.We've been running CF on RedHat for about 4 years now, starting with CF4.5, and now CFMX 6.1.In general CF should run on most recent Linux distributions,

Opinions on an idea for updating multiple instances of CFMX6.1

2004-07-29 Thread DURETTE, STEVEN J (AIT)
Hi all, I have just really started maintaining multiple instances of CFMX on one server and I had an idea for how to do updates easier (hot fixes and security updates).I'd like to know what your opinions are. I started out with a master copy of the cfusion\cfusion-ear directory that I use to

Re: CF on Linux

2004-07-29 Thread Doug James
We are running CFMX 6.1 on a RedHat 2.1 AS server connected to a separate Win2003 Server with SQL Server and the setup works great. And Verity works on our version regardless of the official MM system requirements stating differently. Doug Robert Orlini wrote: Sorry I'm not too Linux savvy

RE: CF on Linux

2004-07-29 Thread Steven Erat
CFMX 6.1 supports Red Hat Enterprise Linux 2.1 and 3.0, and it comes with a MS SQL JDBC driver.For those versions of Linux which have been previously qualified as not supported for Verity functionality, there is a hotfix to enable Verity for ColdFusion on all Linux OS's listed in the system

RE: Monitor CFMX threads

2004-07-29 Thread Steven Erat
Generate a Full Thread Dump to see which threads and cfm templates are running at that instant. http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm -Steve _ From: Mark W. Breneman [mailto:[EMAIL

hosting blogs

2004-07-29 Thread Doug James
We are thinking about hosting blogs on our server. Does anyone know of a multiple user blog application in ColdFusion? Thanks! Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: CF on Linux

2004-07-29 Thread Robert Orlini
Thanks Doug, I presume you are using IIS on the Win2003 and modifying pages how?...with FrontPage? I'm thinking of Linux Server with CFMX and connecting to a Win2000 Advanced Server running FP. Sounds OK folks or am I missing something? Robert O. -Original Message- From: Doug

log files not being written

2004-07-29 Thread Plunkett, Matt
We are setting up a new Windows 2000 server with CFMX 6.1 and IIS.The server has gone through the SANS lockdown, and IIS was fairly aggressively locked down also.We have other boxes like this that work fine with MX, but this one for some reason is not able to write the application.log and

Re: cfmx server crashing

2004-07-29 Thread Brook Davies
So, what does happen? Does the running thread count grow and then start to queue additional requests? Ram usage? CPU Usage? Or are you seeing what I was seeing (or still am for that matter), where CF just stops answering requests and the requests seem to get stuck in limbo between IIS and CFMX

RE: Question about cfqueryparam

2004-07-29 Thread Joshua OConnor-Rose
nevermind sorry to be so hasty -joshua o'connor-rose -all is good --- Joshua OConnor-Rose [EMAIL PROTECTED] wrote: I'm back to this now Anybody seen this before? [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)

cfm template gone, i have class file

2004-07-29 Thread Tony Weeg
can i get my cfm back from the class file? is this possible? homesite wont let me ctrl+z to go back in the file editing, i accidentally ctrl + a, and deleted the contents, then saved, and now its blank, can i recreate from the class file? thanks if you can help. -- tony Tony Weeg human.

Re: Question about cfqueryparam

2004-07-29 Thread Joe Rinehart
Hey Josh, You're missing your AND operator and doubling up on the WHERE.Try this: from office inner join state on office.state=state.state_id where active = 1 and adcompany = 4 AND office_num in (cfquery... -joe - Original Message - From: Joshua OConnor-Rose [EMAIL PROTECTED] Date: Thu,

Re: CF on Linux

2004-07-29 Thread Doug James
No sir. We run apache on the linux box. We use a combination of CF-Studio, Homesite+ and eclipse to work with pages. If you have more specific questions regarding our set up you can e-mail me off list. Doug Robert Orlini wrote: Thanks Doug, I presume you are using IIS on the Win2003 and

Re: log files not being written

2004-07-29 Thread Adam Haskell
you you have anyhting set up for Site-wide Error Handler in the cf admin area? If so CF will nto make an application log I believe. Adam H On Thu, 29 Jul 2004 14:38:48 -0400, Plunkett, Matt [EMAIL PROTECTED] wrote: We are setting up a new Windows 2000 server with CFMX 6.1 and IIS.The server

Re: cfm template gone, i have class file

2004-07-29 Thread Barney Boisvert
Nope, you can't go from CLASS to CFM.You can get back the Java, but that's it, and it won't be very helpful.Couple suggestions: 1) enable undo across saves in the HomeSite prefs (CF Studio had this, I assume HS does) 2) start using version control 3) can you download it from a production server,

Re: CF on Linux

2004-07-29 Thread Doug James
Steve, Does the hotfix happen to include getting verity spider to work? Doug Steven Erat wrote: CFMX 6.1 supports Red Hat Enterprise Linux 2.1 and 3.0, and it comes with a MS SQL JDBC driver.For those versions of Linux which have been previously qualified as not supported for Verity

Re: cfm template gone, i have class file

2004-07-29 Thread Tony Weeg
it was a dev server, thats where we ran it.(dumb, VERY dumb) i dont use version control, i know i know i know this is a lesson, i guess. I AM ABOUT TO SHOOT MYSELF! there has to be a reversal tool...if it can go from cfml to .class, why not .class to cfm? tony On Thu, 29 Jul 2004

Formatting output for printing question

2004-07-29 Thread Kevin
Hey group, I have a question that has got me stuck. I want to be able to format my reports for printing and can not seem to get the html page to fit right on the different printers we use in our offices. Once I get it working on one printer it prints wrong on the others (cuts off the right edge).

RE: CF on Linux

2004-07-29 Thread Steven Erat
Support for Verity is inclusive of the Verity commandline tools. Do you have a specific example of a vspider problem on Linux? -Steve _ From: Doug James [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 3:09 PM To: CF-Talk Subject: Re: CF on Linux Steve, Does the hotfix happen

Re: Monitor CFMX threads

2004-07-29 Thread Pete Freitag
You can find out some info by accessing the currentRunning thread, and then getting its thread group, and then enumerating the threads in that group. I tried writing this in pure CFML but since you can't cast to specific object types I couldn't do it, but I wrote it in JSP, so if your running

Re: cfm template gone, i have class file

2004-07-29 Thread Tony Weeg
strange, in homestite i can go to other files, and ctrlz them now, but not on this one?wtf? is this a bug in homesite that you can ctrlz some files but not others, depending on what you do? this is nuts. tw On Thu, 29 Jul 2004 15:24:14 -0400, Tony Weeg [EMAIL PROTECTED] wrote: it was a dev

  1   2   >