Passing info to IIS or Apache

At a Show-and-Tell session of our Macromedia User Group last night, one of the members showed a site he was working on that would gather a large amount of information about the craft of blacksmithing, categorized in various ways, with the content ultimately being served out in the form of a URL tha

RE: Massive RegEx

It is quite handy to be able to post links in comments though.   _   From: Rick Mason [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 4:40 p.m. To: CF-Talk Subject: Re: Massive RegEx Jake, Wouldn't it make more sense to do a lookup on the MX record of their email?  I would have to gu

RE: connecting to SQL 2000 directly WAS: EXTREMELY slow site, trying to troubleshoot

It's on the hosting company's server. Everybody that goes to the site (client, client employees, myself) finds themselves waiting 4.5-9 seconds for each and every page to display. Gil Midonnet   -Original Message-   From: Matthew Walker [mailto:[EMAIL PROTECTED]   Sent: Thursday, August 0

Re: Massive RegEx

Jake, Wouldn't it make more sense to do a lookup on the MX record of their email?  I would have to guess that the spam bots wouldn't use a valid email. I've also noticed some blogs won't let you post a valid clickable link.  Seems like that would remove the very reason for the bots posting.  Not

RE: connecting to SQL 2000 directly WAS: EXTREMELY slow site, trying to troubleshoot

No, this isn't normal. I've dealt with the hosting company before and have been satisfied with them. I've never seen anything like this. At first I thought I had too many includes (4) and too many database calls with too many joins. Finally I pared a test page down to one database call SELECT * FR

Re: (OT?) White space and search engines

Yes and no. The tag does not change the source code, only how it's expressed to the browser (i.e. the end result html, not the original cfm page). It's a module that wraps a page and compresses it. Normal, well formatted html in and tight one line html out for the browser (or search agent) to read.

RE: connecting to SQL 2000 directly WAS: EXTREMELY slow site, trying to troubleshoot

Is it slow when you query it from your local server or when you query it from the hosting company's cf server? If it's slow from your development server, it could simply be a network issue you don't need to worry about too much.   _   From: mayo [mailto:[EMAIL PROTECTED] Sent: Friday, 6 Aug

linux image manip tags

what are the options (free or otherwise) for a simple image maniuplation tag (mostly just size) tags or programs that run on linux? thanks ia now can i go back on vacation? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Why won't SP commit?

I have a form that submits to itself and displays the results to the user. If the user clicks "submit", the form submits to itself again with a hidden parameter that launches this: <  --  lots of querying and stuff here --   > UPDATE RequestGroup SET  Status=#newStatus#

Re: (OT?) White space and search engines

DEATH TO CODE READABILITY?!!!   - Original Message -   From: Michael Dinowitz   To: CF-Talk   Sent: Thursday, August 05, 2004 11:10 PM   Subject: (OT?) White space and search engines   I'm giving a presentation on RegEx this Wed. and one of the things   I'll be showing is a tight little

Re: connecting to SQL 2000 directly WAS: EXTREMELY slow site, trying to troubleshoot

No you shouldn't be doing anything different to connect to your database, in fact, you could use Java objects to connect to your database, however, because the resultsets returned would need to be converted to ColdFusion query variables before being used by other ColdFusion code this would be slowe

(OT?) White space and search engines

I'm giving a presentation on RegEx this Wed. and one of the things I'll be showing is a tight little piece of code that will compress a webpage by removing all 'extra' spaces (and tabs, new lines, etc.) from all places other than script and pre tags. I'm under the impression that if this is done, i

Re: [mysql] alter column command...

Now that you mention it, I think I've heard/read that before.  Kinda makes sense, because the space savings are pretty minimal at that point (VARCHAR uses an extra byte beyond string length).  Good to know though; thanks for pointing it out. cheers, barneyb On Thu, 5 Aug 2004 16:32:43 -0700, Matt

CF Enterprise MX and NotesSQL 3.0.2

Hello, Installed on the server (Windows 2003): * ColdFusion Enterprise Server MX * NotesSQL v3.0.2c * Lotus Notes 6.5.2 client The ODBC System DSN connection has been setup without any problem. On ColdFusion administrator, using driver "ODBC Socket", the connection name is found no problem, but w

connecting to SQL 2000 directly WAS: EXTREMELY slow site, trying to troubleshoot

My site is extremely slow. I've narrowed it down to my database calls. This site is being hosted remotely. I am being told by tech support that to speed things up I ought to be connecting to SQL 2000 directly. Huh?! Is there something I ought to be doing aside from :         I set up a Acces

Re: Massive RegEx

Jake You are trying to test for members (pardon the pun) of an open-ended system. You would prolly be better off: 1) manually reviewing posts prior to making them visible on the site. 2) only allow posts by registered/logged in users 3) use one of the bad-words tags available but they are easy

RE: Massive RegEx

I think each line is a separate regex so it's really a lot of small ones. Nevertheless, this strikes me as a poor way to filter comments - as futile as filtering spam email using boolean _expression_ matching. Aside from needing constant updates, it won't filter the occasional abusive comment from

RE: Rounding number format to 0 decimal places

hi Joe, I've had a quick read  on numberformat(), so hopefully that will help. But yes, it's part of a resulting query, and the output for the query already has the following:        #team_name#     #results["wins_round_#round_number_results#"][currentRow]#     #results["margin_round_#round_num

Massive RegEx

All, I have an idea to implement the Movable Type plugin Blacklist (http://www.jayallen.org/projects/mt-blacklist/) into my blogging app. At its core, this plugin seems to be based on a pretty massive RegEx that is run on all comments that are posted to the blog in order to help to eliminate c

Re: [mysql] alter column command...solved

Thanks Barney that did it.   - Original Message -   From: Barney Boisvert   To: CF-Talk   Sent: Thursday, August 05, 2004 6:53 PM   Subject: Re: [mysql] alter column command...   If you want a numeric column, use a numeric type.  TINYINT UNSIGNED   would probably do (0-255), but you mig

Re: Rounding number format to 0 decimal places

If you need it at the query level, you can do: SELECT CAST(columnToBeInt AS INT) Otherwise, the numberFormat() can do wonders when it comes to, well, formatting numbers. -joe - Original Message - From: Mark Henderson <[EMAIL PROTECTED]> Date: Fri, 6 Aug 2004 10:42:29 +1200 Subject: RE:

Re: CFFILE Mystery

:) I hit cntrl+enter and it sent before i was done like i said, if that works then you are missing the directory they are trying to put the file in. Possibly because of session timeouts? or it just doesnt exist?   - Original Message -   From: Ewok   To: CF-Talk   Sent: Thursday, August

Re: trim numbers

any of these should do the trick NumberFormat(number, "999,999") -or- ListFirst(number, ".") -or- Left(number, Len(number) - 3) -or if it is always .00- Replace(number, ".00", "")   - Original Message -   From: Duane Boudreau   To: CF-Talk   Sent: Thursday, August 05, 2004 12:24 PM   S

Re: CFFILE Mystery

this cant be all that is in the form.cfm file... it seems that i have gotten that same error at one time or another. I want to say that it happened when someone tried to upload a 0 byte file? I'm not betting any body parts on that though : ) if thats not it, try letting everyone upload to the sa

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

I am sure somewhere down the line that the date 8-5-2004 is being treated as a math problem 8 minus 5 minus 2004 giving you -2001 which when formatted as you are doing returns the date 07-08-1894   - Original Message -   From: hammerin hankster   To: CF-Talk   Sent: Thursday, August

Re: CFMX and PostgreSQL 7.X

Thanks Jochem i'll be read that docs carefully... very carefully... ;-) On Thu, 05 Aug 2004 22:44:09 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Marco Antonio C. Santos wrote: > > > Thanx all... but our Dev Server runs in Win2K3... > > For 7.4.3: > http://techdocs.postgresql.org/

Re: tip of the day

Ah, that seems like a great idea.  I'll be back to that on Monday and give it a try.  Thanks! > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/appfra29.htm > > it will cache it for everyone, its a server side cache    > - Original Message -    > From: daniel kessler    > To: CF-

Re: [mysql] alter column command...

Barney wrote: > MySQL will never use CHAR columns if the table uses any > variable-length columns (such as VARCHAR or TEXT).   Huh?  Sure it will: http://foohbar.com/tempshot.gif >From what I've seen, any varchar column whose length is specified as being shorter than 6 chars gets automatically c

RE: [mysql] alter column command...

ALTER TABLE slideshow MODIFY orderby char(5) Gilbert Midonnet   I have the following column   orderby   varchar(5)   I want to change it to...   orderby char(5)   I've tried this sql but no luck   "ALTER TABLE   slideshow   ALTER COLUMN   orderby char(5)   " [Todays Threads] [This Mes

Re: If "x" is in a list problem - What worked..

This did it: checked="checked" Thanks for the pointers... -- Les Mizzell -- Certe, toto, sentio nos in kansate non iam adesse -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscrib

Re: [mysql] alter column command...

I haven't had much experience with MySQL, but I'm guessing VarChar and Char are similar, character based fields, and even if you could change it to Char, it would make no difference to your output order. What I am suggesting is you change the field to an Int:     > "ALTER TABLE     > slideshow    

Re: [mysql] alter column command...

If you want a numeric column, use a numeric type.  TINYINT UNSIGNED would probably do (0-255), but you might need a larger size if you're going to have numbers outside that range. alter table slideshow modify column orderby tinyint unsigned not null; cheers, barneyb On Thu, 5 Aug 2004 18:36:38 -

Re: [mysql] alter column command...

that's what I was trying to do in changing the varchar to char ( see early on in this thread ) but it's not taking the command   - Original Message -   From: Aaron DC   To: CF-Talk   Sent: Thursday, August 05, 2004 6:19 PM   Subject: Re: [mysql] alter column command...   Orderby

RE: Rounding number format to 0 decimal places

hi Charlie, int() might work. But then I thought round would too. I'm just not sure how to build it into the resulting output query. regards Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: cfmx - request timeout setting

:) thanks! for all your help. also, kudos to mike t.  who helped as well! later. tw On Thu, 5 Aug 2004 18:18:58 -0400, DURETTE, STEVEN J (AIT) <[EMAIL PROTECTED]> wrote: > Tony, > > The only thing I can say to that is run it one way , then run it the other > way and see which is faster. > > Th

Re: Rounding number format to 0 decimal places

int() ? Mark Henderson wrote: >Moving on from where I left off the other day, I would now like to be able to round the following output to zero decimal places. > >Here's my query >= > >    SELECT * >    FROM results >    WHERE team_name IS NOT NULL >    ORDER

RE: cfmx - request timeout setting

Tony, The only thing I can say to that is run it one way , then run it the other way and see which is faster. There is an article about Query performance here: http://www.databasejournal.com/features/mssql/article.php/3298411 Steve -Original Message- From: Tony Weeg [mailto:[EMA

Rounding number format to 0 decimal places

Moving on from where I left off the other day, I would now like to be able to round the following output to zero decimal places. Here's my query =     SELECT *     FROM results     WHERE team_name IS NOT NULL     ORDER BY total_score DESC And the resulting

Re: [mysql] alter column command...

Orderby would indicate a number/integer? Why not alter the table and make it a numeric field type instead? Aaron - Original Message - From: Daniel Farmer To: CF-Talk Sent: Friday, August 06, 2004 8:05 AM Subject: Re: [mysql] alter column command... The problem I was having is in order

Re: [mysql] alter column command...

The problem I was having is in ordering the orderby column. since it places the order like this...eg... "Order By orderby asc" 10 11 12 2 21 22 When I want it to be like so... 2 10 11 12 21 22   - Original Message -   From: Barney Boisvert   To: CF-Talk   Sent: Thursday, August 05, 20

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

>Are all the columns of data type string? If not, why are you quoting >all the values? Save for the prepareddate field, they're all either text or memo fields.   BTW, I changed the prepareddate field to: prepareddate =  #DateFormat(Form.prepareddate, "mm-dd-")# But now, it's entering 07/03/

Re: JRun Process Hangs on Queries with Large Number of Columns

Do you have the new datadirect jdbc drivers, or the hotfix for the original jdbc drivers?  One of the known problems with the drivers that shipped with 6.1 was 100% CPU uitilization on certain conditions if not, get the fixed drivers off of hte MM site (they're listed with the hotfixes) -jc J

Re: JRun Process Hangs on Queries with Large Number of Columns

If you're running MS SQL Server, this is probably the 100% CPU bug found in CFMX 6.1's original DataDirect 3.2 drivers. The newer version is 3.3, and 3.4 should be coming out any week now in the 6.1 updater. Get and install the hot fix here: http://www.macromedia.com/support/coldfusion/ts/docum

Re: [mysql] alter column command...

MySQL will never use CHAR columns if the table uses any variable-length columns (such as VARCHAR or TEXT).  In general, it's irrelevant.  From the application perspective, there's no difference between VARCHAR and CHAR, so just let the database do it's thing. The reasoning is that if a table has e

Re: [mysql] alter column command...

Daniel Farmer wrote: > I have the following column > > orderby   varchar(5) > > I want to change it to... > > orderby char(5) http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Su

Re: cfmx - request timeout setting

so... does that looping effect buy me anything, or should i just run the whole shebang and not worry about rowcount? i guess my question is...does this help in the deletion process?  help = increased speed/less downtime? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blo

JRun Process Hangs on Queries with Large Number of Columns

In my application a query is executed via cfstoredproc.  This is an "ad hoc" query, where the user may select a number of columns.  It works as designed, except when a large number of columns are selected...say 85 or so. The actual queries which cause the hang, execute just fine in query analyzer.

[mysql] alter column command...

I have the following column orderby   varchar(5) I want to change it to... orderby char(5) I've tried this sql but no luck "ALTER TABLE slideshow ALTER COLUMN orderby char(5) " [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Supp

RE: cfmx - request timeout setting

Tony, You can leave the rowcount in.  Do this: create procedure storedProc_Kill_91stDay AS Begin     set nocount on     set transaction isolation level serializable     set rowcount 3     declare @myDateDiff bigint     declare @myNumDeletes bitint     select @myDateDiff = dateDiff(ss,

Re: JAVA Script Error

>>and where i need to close the popup.
//alert("window is still open");
the_Child.close();
I suppose this script is in the pop up? Then "the_Child" is not defined there, it is its parent's object. Simply try self.close(); and it should close itself. --

Re: If "x" is in a list problem

listFind() and listFindNoCase() look for exact matches, listContains() and listContainsNoCase() look for substrings. A quick way to keep them straight is remember that listContains() works like the contains comparison operator. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsu

Re: If "x" is in a list problem

Or use ListFind()LOL - forgot about that one. At 04:49 PM 8/5/2004, you wrote: >This what you mean? > > > > >  >   >  >   >  > > >Ray > > >At 04:38 PM 8/5/2004, you wrote: > >I'm using this to preselect checkboxes: > > > >checked="chec

Re: If "x" is in a list problem

This what you mean?           Ray At 04:38 PM 8/5/2004, you wrote: >I'm using this to preselect checkboxes: > >checked="checked" > >...but that ain't correct - because it needs to return true ONLY if the >entire string in the list = "3"

Re: If "x" is in a list problem

On Thu, 05 Aug 2004 16:38:28 -0400, Les Mizzell <[EMAIL PROTECTED]> wrote: > I'm using this to preselect checkboxes: > > checked="checked" > > but that ain't correct - because it needs to return true ONLY if the > entire string in the list = "3". > > Currently, "37" or "43" would return true

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

Are all the columns of data type string? If not, why are you quoting all the values? -- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

If "x" is in a list problem

I'm using this to preselect checkboxes: checked="checked" ...but that ain't correct - because it needs to return true ONLY if the entire string in the list = "3". Currently, "37" or "43" would return true as well. So, for a string of "3,33,43,73" how do I get it to return true for ONLY "3"?

Re: CFMX and PostgreSQL 7.X

Marco Antonio C. Santos wrote: > Thanx all... but our Dev Server runs in Win2K3... For 7.4.3: http://techdocs.postgresql.org/guides/Windows http://empoweringminds.mle.ie/openacs/install_postgresql.html For development snapshots: http://pgfoundry.org/project/showfiles.php?group_id=107 For bl

Re: cfmx - request timeout setting

got that...and did that in the mean time, but is there a way to chunk the data, like delete in 3 row blocks, and start again, etc.? someone had suggested that as the way to do that? tw On Thu, 5 Aug 2004 16:26:34 -0400, DURETTE, STEVEN J (AIT) <[EMAIL PROTECTED]> wrote: > Tony, > > Remove

RE: cfmx - request timeout setting

Tony, Remove the "set rowcount 3"  It is limiting the delete to only the first 3 rows it encounters. Also, if you delete that don't forget to delete the "set rowcount 0" at the end. Steve -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, August

Re: JAVA Script Error

still playing with that, no luck yet, If someone have a simple example script please send it to me. What I am trying to do is on the top of page if the form has been submitted, open a popup window with a static html page showing animated gif and when the file is uploaded, at the bottom of the pag

SOT: New Open Source Java DB

Phil Cruz alerted me to the following: One more thing, in terms of an (free) database.  IBM just open sourced cloudscape.  This could be the missing piece for CFAnywhere that needs a db. See this blog post from Charlie http://bluedragon.blog-city.com/read/758030.htm This is a pretty powerful dat

Re: cfmx - request timeout setting

steve. problem. its only deleteing 3 rows, not all of them. how can this work, deleting all, and not stopping @ 3 rows deleted? thanks. tony On Thu, 5 Aug 2004 14:12:39 -0400, Tony Weeg <[EMAIL PROTECTED]> wrote: > well... > > thank you steve. > > ive just got it down to like 5 min t

Re: CFMX and PostgreSQL 7.X

Thanx all... but our Dev Server runs in Win2K3... On Thu, 05 Aug 2004 12:24:31 -0700, Jordan Michaels <[EMAIL PROTECTED]> wrote: > Jochem van Dieten wrote: > > > Marco Antonio C. Santos wrote: > > > > > > i'm looking for examples(tutorials, tips) about how to use CFMX and > > > PostgreSQL 7.X ver

Re: CFMX and PostgreSQL 7.X

Jochem van Dieten wrote: > Marco Antonio C. Santos wrote: > > > > i'm looking for examples(tutorials, tips) about how to use CFMX and > > PostgreSQL 7.X version. It's so difficult to install that DB > > "apt-get install postgresql" isn't really that hard, is it? > > > and I need to integrate it wi

Re: sql question (Quick and easy)

steve, i actually figured that out, but im getting 5/6/2004 01:00:00.000 ??? dst issue? anyway, THANKS MAJORLY FOR YOUR HELP!! i got that shite down to like 5 min, vs. 4 hrs later. tw On Thu, 5 Aug 2004 14:40:00 -0400, DURETTE, STEVEN J (AIT) <[EMAIL PROTECTED]> wrote: > Tony,

Re: CFMX and PostgreSQL 7.X

Marco Antonio C. Santos wrote: > Hi all > > i'm looking for examples(tutorials, tips) about how to use CFMX and > PostgreSQL 7.X version. It's so difficult to install that DB and I > need to integrate it with our CMS. > > Thanx PostgreSQL comes pre-installed (or easily installed via custom packag

CFFILE Mystery

I am having difficulty with a CFFILE upload statement.  It works for me everytime, regardless of which of my 4 machines i use (3 Win2K, 1 WinNT), and whether I access the site from my LAN or via dialup.   Even after resettingthe application and session vars. Yet 3 others using machines running W

Re: CFMX and PostgreSQL 7.X

Marco Antonio C. Santos wrote: > > i'm looking for examples(tutorials, tips) about how to use CFMX and > PostgreSQL 7.X version. It's so difficult to install that DB "apt-get install postgresql" isn't really that hard, is it? > and I need to integrate it with our CMS. http://www1.oli.tudelft.nl

Display a loading message with CFMX and IFRAME tag

I'm trying to determine the best way to display a 'loading' message for an IFRAME that contains a PDF document.  Ideally, I would like to place the IFRAME in a hidden div until the PDF has completely loaded in the Acrobat Plugin, and then display it. Does anyone know how that can be accomplished?

RE: CF Installer Issue (bits are bad? Macro folks?)

Ok I've tried in couple environments...either I've got bad luck or there is something wrong with AIX coldfusion bits coming off Macro's site. :( From: Stacy Young Sent: Thursday, August 05, 2004 2:31 PM To: CF-Talk Subject: CF Installer Issue Hi All, I'm

RE: sql question (Quick and easy)

Tony, If you are just looking for the date, why don't you do: select dateAdd(d, -91, convert(varchar, getdate(), 101)) That returns 5/6/2004 00:00:00.000 Steve -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 2:08 PM To: CF-Talk Subj

CF Installer Issue

Hi All, I'm using the AIX download to create a cross platform cfmx instance. When I run the installer to generate an EAR I get the following error in the log: Install File: C:\opt\cfmx\cfusion.war   Status: ERROR   Additional Notes: ER

Re: Parsing Path

> Good Afternoon everyone, > I have a table that contains a list of files and folders. > Rows may look something like this > doc_id path_namefile_name > 5  test1/test1.1    test.pdf > 4  test1/test1.2    test.pdf > 3  test1folder(place holder if "" then > it's a fo

CF 5.0 Archive Problem

I am trying to build an archive from the administrator of CF 5.0.  When I press "build archive" I get the error "ERROR: The ColdFusion Management service has either not finished or is not running. Verify the service is running by opening the Services tool in the Control Panel, if the service is run

RE: sql question (Quick and easy)

Tony, How about use millisecond in the datepart dateDiff(ms,'01/01/1970 00:00:00.000',DATEADD(Day, 22, '01/01/1970')) however, for milliseconds, the maximum number datediff can produce is 24 days, 20 hours, 31 minutes Hua -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Se

Parsing Path

Good Afternoon everyone, I have a table that contains a list of files and folders. Rows may look something like this doc_id path_namefile_name 5  test1/test1.1    test.pdf 4  test1/test1.2    test.pdf 3  test1folder(place holder if "" then it's a folder) 2  t

Re: JAVA Script Error

thanks for you reply. No this one doesn't work too. There is no error. my script debugger is on, "display error on script" is on as well. popup is opening but its not closing. thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Suppo

RE: JAVA Script Error

Try this.
windowHandle = window.open('anim.htm','waitWin','height=10,width=260');

// alert("windows still open");
    windowHandle.close();
> -Original Message- > From: Asim Manzur [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 05, 2004 11:26 AM > To: CF-T

Re: cfmx - request timeout setting

well... thank you steve. ive just got it down to like 5 min to delete 2million rows. timeID is an int, and yes its indexed. thanks for the ideas... tony On Thu, 5 Aug 2004 14:06:42 -0400, DURETTE, STEVEN J (AIT) <[EMAIL PROTECTED]> wrote: > Tony, > > A few things that might help. > > 1) Use

Re: JAVA Script Error

in addition now I am opening the popup on onSubmit event. ( validate(this) ) {return true} else {return false}"> in function validate the_Child = window.open('popup.htm','waitWinPop','height=10,width=260'); } and where i need to close the popup.
//alert("window is still open");

sql question (Quick and easy)

hi there... this query below returns an epoch time, something like 1083851729 select dateDiff(ss,'01/01/1970 00:00:00.000',DATEADD(Day, -91, GetDate())) which is GREAT, and translates into: 05/06/2004 14:55:29 but i need to get: 05/06/2004 00:00:00.000 i can do it all day long in cfml, b

RE: cfmx - request timeout setting

Tony, A few things that might help. 1) Use set nocount on and off. 2) Calculate the datediff once instead of multiple times. (not too sure on this, I have seen it recalc not at all or on every record whatever the sql server decides). Like this: create procedure storedProc_Kill_91stDay A

Re: CFMX on Mandrake Linux 9.2?

I just followed the RedHat instructions.  You may have to make some changes if your directory structure is different, but it is usually pretty similar between RadHat and Mandrake. -JB Rey Bango wrote: > JB, > > Is there an article that you know of that gives instructions on installing > CFMX o

Re: CFMX on Mandrake Linux 9.2?

JB, Is there an article that you know of that gives instructions on installing CFMX on Mandrake? Rey... - Original Message - From: "JB McMichael" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 05, 2004 12:24 PM Subject: Re: CFMX on Mandrake Linux 9.2? > I

Re: setdomaincookie invalidating session

We're using full domains www.domain.com and secure.domain.com thats good to know though one thought that was floating around but han't been tested is maybe the wrong domain is being used when the cookies are being set. as in gooddomain.com sets gooddomain.com cookies, and baddomain.com is trying

Re: CFMX Errors and Apache

Go disable "send HTTP error codes" on the settings page of the CF administrator, or disable friendly error messages in your browser's settings. cheers, barneyb On Thu, 5 Aug 2004 10:11:28 +0200, Mark Drew <[EMAIL PROTECTED]> wrote: > Currently I am running Apache 2 and CFMX. Instead of getting th

CFMX on IA64 (Itanium)? with JBoss?

I've got Red Hat AS 2.0 installed on an Itanium server. J2SE 1.4.2 (64bit) is installed and working. http://java.sun.com/j2ee/1.4/download.html - j2sdk-1_4_2_04-linux-ia64-rpm.bin (There aren't 64-bit downloads for the other three SDK pieces on that page.) JBoss 3.2.5 with Tomcat is deployed and

RE: EXTREMELY slow site, trying to troubleshoot

Sorry for taking so long to respond, was pulled away. This site is being hosted remotely. I am being told by tech support that to speed things up I ought to be connecting to SQL 2000 directly. Huh?! Is there something I ought to be doing aside from :         I set up a Access db and it takes

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

terminationdesc = '#Form.terminationdesc#' terminationreason = '#Form.terminationreason#', missing a comma after '#Form.terminationdesc#' Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]   - Orig

Re: Is JRun4 included with ColdFusionMX 6.1?

I started up the JRun Management Console and tried to use my CFMX serial number, but it rejected it. But if I start up an instance of ColdFusionMX with the JRun Server, I can set the CFMX serial number within the CF Administrator. Troy Robert Munn wrote: > Sounds like you just talked to a bone

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

>You forgot a  ,  (comma) after this entry terminationdesc = '#Form.terminationdesc#' > >Thanks, >CC >x56927 Yes, I saw that and corrected it.  Still generating the same datatype mismatch error. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations

Re: Accented characters

> I am using MySQL as a datasource and whenever an accented character arises > (é for example) it ends up being stored in the database as ' ' instead. for mx: in your application.cfm add: at the top of your cf pages add: in the advanced option, connection string, for that DSN add: useUnicod

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

>You forgot a  ,  (comma) after this entry terminationdesc = '#Form.terminationdesc#' Yes, I saw that and corrected the problem.  It's still generating the datatype mismatch error. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: trim numbers

Thanks it did... -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:25 PM To: CF-Talk Subject: RE: trim numbers I usually use the following: replace(dollarformat(number), ".00", "", "All") hope this helps Duane   _   From: Robert

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

You forgot a  ,  (comma) after this entry terminationdesc = '#Form.terminationdesc#' Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Is JRun4 included with ColdFusionMX 6.1?

If JRun is Free with CFMX Enterprise Addition, then why am I getting these warning messages from JRun? # ./jrun -start admin Starting Macromedia JRun 4 (Build 63824), admin server 08/05 09:54:36 warning The Trial License evaluation period will expire in 0 days. 08/05 09:54:36 warning The Trial L

CFMX and PostgreSQL 7.X

Hi all i'm looking for examples(tutorials, tips) about how to use CFMX and PostgreSQL 7.X version. It's so difficult to install that DB and I need to integrate it with our CMS. Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support

Re: Is JRun4 included with ColdFusionMX 6.1?

Sounds like you just talked to a bonehead. JRun4 is definitely included in the CFMX Enterprise Edition license, and running in J2EE mode is expressly allowed. You can add your license key to JRun after the fact, I believe, but I'm not sure where you would do that. > I called macromedia and one ans

Can't Update more than 13 records - Datatype Mismatch Error - HELP!

I posted a very similar problem a few days ago, but it's happening on all my tables now. I've got a very bizarre problem.  I'm trying to do an update to my table, but it appears that I can only update 13 fields.  Below is my query: UPDATE tblmasterclients SET acctstatus  = '#For

Re: trim numbers

Depending on how the data is formatted, this will also work: ListFirst(price,'.') - Original Message - From: Gavin Brook <[EMAIL PROTECTED]> Date: Thu, 5 Aug 2004 17:32:14 +0100 Subject: RE: trim numbers To: CF-Talk <[EMAIL PROTECTED]> If you know roughly the maximum price to be displaye

  1   2   >