ColdFusion MX / Studio MX now available!

Macromedia has just announced the availability of ColdFusion MX / Studio MX! :-) Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] S

RE: Repost: CFFTP 500 Invalid PORT Command.

> My setting are very basic. > The Web server is IIS on Win2k > The FTP server is the built-in FTP Server of IIS. > I keep all the default settings. (didn't change anything). > > I was able to connect to the server but when trying to list all > files/directories, I got that error. > > any advice?

Re: ORDER BY question

Jochem van Dieten wrote: > > Actually, there is if your database can do a little bit of maths and > subqueries in the ORDER BY clause. But it is a bit tricky and get's out > of hand when the number of elements in the list get's too long because > you need to develop a power series to sort on :

RE: Forums software

We recenty wrote a forum pzckage for our own use, for very similar reason to you Jon, It has yet to be tested in a high use enviroment, but if you want to try it, mail me off list and I'll let you have a copy. We have 2 versions, an access version designed for low use, high features, very similar

CFQUERY Question to populate a drop down for search

CFQUERY Question to populate a drop down for search I'm looking for a way to query a database table and display the results with out any diplicates. The "WHERE city is unique" does not work. SELECT city FROM profiles WHERE city is unique #getcity.city# ___

RE: CFQUERY Question to populate a drop down for search

You could use: SELECT DISTINCT city FROM profiles Alex > -Original Message- > From: Brian Simpson [mailto:[EMAIL PROTECTED]] > Sent: 29 May 2002 10:32 > To: CF-Talk > Subject: CFQUERY Question to populate a drop down for search > > > CFQUERY Question to populate a drop down for searc

RE: CFQUERY Question to populate a drop down for search

> You could use: > > SELECT DISTINCT city FROM profiles Not forgetting to ORDER BY the query, otherwise it can appear pseudo-random Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk

combining two verity recordsets: double post

HI all, Another Verity question. Is it possible to combine the results from 2 or more CFSearch's? I have a search page that is searching a number of different collections, but I want the results displayed together. Any ideas? Will Swain Hot Horse Ltd __

RE: combining two verity recordsets: double post

> Another Verity question. Is it possible to combine the > results from 2 or more CFSearch's? > > I have a search page that is searching a number of different > collections, but I want the results displayed together. > > Any ideas? >From the docs on CFSEARCH; Multiple ColdFusion collections can b

RE: combining two verity recordsets: double post

super.cheers Philip. will -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 29 May 2002 11:26 To: CF-Talk Subject: RE: combining two verity recordsets: double post > Another Verity question. Is it possible to combine the > results from 2 or more CFSearch

Running program using

I'm looking at the documentation and it looks like I might be able to use cfhttp to run my program on the server from a client PC. I'm not having very much success using cfexecute. Some programs work...others don't. I even tried creating a .bat file without any success. This would be the synta

Transaction

Hi, If I run one query Q1(say update) in tb_Parent and it is successfully executed. Now another object(in my Coldfusion Page) is trying to run another query Q2(say insert) in tb_Child, but on failure of this second query - insert one, I want to ROLLBACK the transaction which has already happened

RE: ORDER BY question

Man! you guys went way over my head hear! : ] for this purpose since there are only 4 separate groupings i may just do 4 separate queries. not sure. thought i could do it like Order By tblJobTitle.TitleID=25, tblJobTitle.TitleID=26, tblJobTitle.TitleID=28, tblJobTitle.TitleID=4; -paul ___

RE: ORDER BY question

ok tried brians Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]'instr' is not a recognized function name. with SELECT LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as Fullname, tblEmpl

RE: ORDER BY question

> Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]'instr' is not > a recognized function name. INSTR is the Access function - CHARINDEX is the SQL Server one The parameters are also the other way around P

RE: ORDER BY question

nope, didn't do it thanks Jochem -paul -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:25 PM To: CF-Talk Subject: Re: ORDER BY question Randell B Adkins wrote: > Create a new field called Sequence or something. > Based on the data a

Distinct Query help

Hello, I am having a little trouble constructing this query because I need a count of a " distinct composite column combo - Date and CMid"..for example..here is the table and the columns in it: DateCMid value rate - -- -- -- 02/021 3 6 02/021

Re: ORDER BY question

One of your goals should be to have as few queries as possible. If you want to do it as one query you might do something like: select tblJobTitle.Title, 1 as SortCol from tblJobTitle where tblJobTitle.Table_ID = 25 UNION select tblJobTitle.Title, 2 as SortCol from tblJobTitle where tblJobTitle

RE: Running program using

> I'm looking at the documentation and it looks like I might be > able to use cfhttp to run my program on the server from a client > PC. > > I'm not having very much success using cfexecute. Some programs > work...others don't. I even tried creating a .bat file without > any success. > > This woul

RE: Transaction

> If I run one query Q1(say update) in tb_Parent and it is successfully > executed. Now another object(in my Coldfusion Page) is trying to run > another query Q2(say insert) in tb_Child, but on failure of > this second query - insert one, I want to ROLLBACK the transaction > which has already happ

RE: Running program using

At 02:04 PM 5/29/2002 +0100, you wrote: > > I'm looking at the documentation and it looks like I might be > > able to use cfhttp to run my program on the server from a client > > PC. > > > > I'm not having very much success using cfexecute. Some programs > > work...others don't. I even tried creat

RE: ORDER BY question

ok...Philip. how should the parameters go? i cant find any info on CHARINDEX in my books. SELECT LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.StatusID, tblEmployee.TitleID, tblSt

RE: CFQUERY Question to populate a drop down for search

If you want the results sorted on the DISTINCT column(s) there's no need to include an order by. The SQL engine must sort the results on those fields to determine uniqueness. It's probably a good practice to include an order by anyway, just for clarity. -Original Message- From: Philip A

RE: ORDER BY question

CHARINDEX(subString, String, StartPoint) So, CHARINDEX(',' + tblJobTitle.TitleID + ',' , '#newOrderList#') As long as NewOrderList begins and ends with commas, this will find the position of tblJobTitle.TitleID within NewOrderList Philip Arnold Technical Director Certified ColdFusion Developer

Re: Running program using

On Wed, 29 May 2002 09:20:09 -0400, in cf-talk you wrote: >I've done this with another program that works OK. I have another program >that just doesn't seem to work properly using CFEXECUTE so I was wondering >if there was a way with CFHTTP? No. (Not unless it was designed to run that way.)

Running program using

I was successful getting my program to run using http://localhost/test.cfm Template (test.cfm) code: http://localhost/programs/runme.exe"; username="test" password="test" resolveurl="yes:> #CFHTTP.MimeType# Length: #len(cfhttp.filecontent)# Content: #htmlcodeforma

Partially OT: Returning POP3 x- headers

I'm not even sure how to ask this question. I have embedded custom headers in e-mail messages. When an address bounces I need to pull the value of those x- headers from the mail. Basically, I'm embedding a message_ID and a mailing_ID. I'd like to be able to flag e-mail addresses in my databas

RE: ORDER BY question

Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]The data type int is invalid for the charindex function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. SELECT LEFT(RTrim(tblEmployee.Lastname),10)

Re: Partially OT: Returning POP3 x- headers

The only sure-fire way to track bounces is to use a unique return path for each mail. For example: Return-path: [EMAIL PROTECTED] The "12345" in the above example is a unique ID that you use to look up the original recipient of the mail (possibly a unique ID in a database). This would requir

OT: CF - PHP - ASP Equivalents

Anyone know of a reference that has all of the CF tags/functions with a PHP, and/or ASP equivalent? I've been using CF for about 3 years now and would like to pick up a second skill. I think something like this might be a good starter. I'm tired of getting a project and finding out the client w

RE: ORDER BY question

this is odd if i do this ORDER BY CHARINDEX(',' + Title + ',' , '#newOrderList#'), Fullname; it basically doesnt even put in the Title as a Order By Item... so my group by in the outputs dont work.. oh well. i can fake this one.. look like a good time to use QaQ -paul ___

Tab order

Anyone know of any good references on setting tab order within some of my complex forms??? I'm sure it's a javascript tutorial I need but I can't find one anywhere. Thanks... I'd also love a PHP to Coldfusion tag conversion chart. Thanks KP ___

Re: Running program using

At 09:50 AM 5/29/2002 -0400, you wrote: >On Wed, 29 May 2002 09:20:09 -0400, in cf-talk you wrote: > > >I've done this with another program that works OK. I have another program > >that just doesn't seem to work properly using CFEXECUTE so I was wondering > >if there was a way with CFHTTP? > >No.

OT - CFUN02 Dinner

For those of you coming out to CFUN02, I'm trying to arrange a dinner get together for Friday around 8pm. Restaurant: GreenFields Brazilian Barbeque (yes the place where they come out with skewers) http://eg.washingtonpost.com/profile/1026892/?&flavor_id=2 I want to get a count of who is intere

Re: OT: CF - PHP - ASP Equivalents

The best thing to do is go to the websites that have tutorials and code snippets. For php - www.phpbuilder.com For asp - www.asp101.com There are many, many more sites but these will get you started. HTH -- Clint Tredway -- Through Him, anything is possible.

Re: Tab order

You can add a parameter to your form elements called "tabindex." For example: HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Sta

Re: Tab order

You can use simple html "Tabindex" but it doesnt always work with netscape. Joe - Original Message - From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 10:30 AM Subject: Tab order > Anyone know of any good references on setting tab

Re: OT - CFUN02 Dinner

oi Sandy!! h well I would love to play with the skewars (just ask some ppl) :) .don't spose there is anything going on..say round midnite for whenst I arrive? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - Wednesday, May 2

RE: Unstructured info

Judging from what I've read thus far, I don't think your problem is one of technology, but more one of organization. From the sounds of things, the site IS organized, but not in an efficent manner for the web. You can try looking at it that way, ignore the underlying language (ASP/CF), and see i

RE: CFGRID - Good alternatives?

We have used CFGrid on one of our sites which is running CF 4.5.2. I like it, but it does have a few issues. It takes longer to load the pages with the grid (and tree) than other pages. We've also had reports of the grid and tree applets never appearing at all. Also, we were considering upgrad

RE: ORDER BY question

> this is odd if i do this > > > ORDER BY CHARINDEX(',' + Title + ',' , '#newOrderList#'), Fullname; > > it basically doesnt even put in the Title as a Order By Item... > > so my group by in the outputs dont work.. > oh well. > > i can fake this one.. > look like a good time to use QaQ OK, the r

RE: ORDER BY question

> Error Diagnostic Information > ODBC Error Code = 22005 (Error in assignment) > [Microsoft][ODBC SQL Server Driver][SQL Server]The data type > int is invalid > for the charindex function. > Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. You can only use Strings in string

Re: Tab order

isn't it just an HTML attribute: >>> "Kris Pilles" <[EMAIL PROTECTED]> 05/29/02 10:30AM >>> Anyone know of any good references on setting tab order within some of my complex forms??? I'm sure it's a javascript tutorial I need but I can't find one anywhere. Thanks... I'd also love a PHP to C

RE: CFGRID - Good alternatives?

Now you just have to make sure your DHTML works in every browser, unless of course, you have a very targeted audience. On Wed, 29 May 2002, Shawn Grover wrote: > We have used CFGrid on one of our sites which is running CF 4.5.2. I like > it, but it does have a few issues. It takes longer to l

RE: ORDER BY question

You are using SQL Server. The function name is not the same in SQL Server as in Oracle. I can't remember what the exact function is, but it would be worth your time to look it up... +---+ Bryan Love Macromedia Certified Professional Internet Appli

RE: Tab order

Yeah thanks First day back after memorial day. Need more caffine -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:05 AM To: CF-Talk Subject: Re: Tab order isn't it just an HTML attribute: >>> "Kris Pilles" <[EMAIL PROTECTED]> 05

RE: ColdFusion MX / Studio MX now available!

And then CFTalk goes deathly quiet as everyone rushes off to download MX... LOL -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:10 AM To: CF-Talk Subject: ColdFusion MX / Studio MX now available! Macromedia has just announced the

RE: Partially OT: Returning POP3 x- headers

Howie - thanks for the quick response. Each message_ID is the unique value from my DB. Combined with the mailing_ID, I can have the same address listed numerous times and still have a unique combination. I do have a seperate pop account for each individual mailing - at least things are sorted

RE: Tab order

You'll need more than caffine when you run it in Nutscrape -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 29 May 2002 16:13 To: CF-Talk Subject: RE: Tab order Yeah thanks First day back after memorial day. Need more caffine -Original Message- From

Multiple CFApplication under 1 application.cfm

Hello, Is the following possible under CF 4.5? I would like to setup a timeout of 8 hours for my internal network machines and 1 hour for people for external users? Even though, I get no errors, it seems to time out very quickly ( 15 minutes...) Thanks for the help. Percy

RE: Tab order

Its for our Intranet all IE Somedyas you just luck out I guess -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:19 AM To: CF-Talk Subject: RE: Tab order You'll need more than caffine when you run it in Nutscrape -Original Messag

RE: ORDER BY question

If you only have 4 groupings then the case statement is the best solution IMHO. It will let you create the sequence column dynamically. Justin > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 8:40 AM > To: CF-Talk > Subject: RE: ORDER BY

RE: Tab order

talking of tab indexes, does anyone notice the tab getting stuck in flash? -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 29 May 2002 16:23 To: CF-Talk Subject: RE: Tab order Its for our Intranet all IE Somedyas you just luck out I guess -Original Message

RegEx or something else?

If I am outputting the first n characters of a string to a page, like this: The quick brown fox jumped over... And I want to make sure I never get this: The quick brown fox jumped o Would I used RegEx? Or something else? What's the easiest way to make sure that that last bit of the string

RE: [admin] List status - A CHALLENGE

agreed -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:03 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Sorry , but "armpit of america" status belongs to east lansing, michigan. Believe me , I spent two years there a

RE: RegEx or something else?

Try something like this. It's easier to write than to explain :) #myString# Good Luck! Eric -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:30 AM To: CF-Talk Subject: RegEx or something else? If I am outputting

CFFTP + FileExists = buggy

I've tried using this attribute to check for the existence of a file in a subdirectory on a remote ftp server. Tried changing directories with the changedir attribute, tried using the path etc, and blah,blah,blah. This tag simply does not work under those circumstances. Keep getting an "cfft

When do they ship

Just bought two copies of CF 5.0 w/subscription couple of weeks ago. Just wondering how long after release do subscribers get their copies? __ Signup for the Fusion Authority news alert and keep up with the latest news in Col

OT: Form not posting.....help, please

Does anyone see a problem with this code? It worked perfectly for several months...now the client has moved hosts, and suddenly the form fields are not posting. (Only the hidden field "upload" is being posted, and when I move it to the bottom of the form, it doesn't post, either). What am I missin

RE: CFFTP + FileExists = buggy

> I've tried using this attribute to check for the existence > of a file in a subdirectory on a remote ftp server. Tried > changing directories with the changedir attribute, tried > using the path etc, and blah,blah,blah. > This tag simply does not work under those circumstances. > Keep getting a

manipulating mail server / CFPOP variables...

I am simply passing getdetail.FROM variable into the TO text box of a reply page, however the variables value is ie. "Paul" <[EMAIL PROTECTED]> so when getdetail.FROM is past to the reply page its value is showing up in the debugger as "Paul", is there a way I can pass just the email address? (

Re: generate multiple PDFs automatically

Thanks for the advice.. I checked CFCOMET but I cannot still find an answer to the biggest problem - the number of files that will be generated. I can dynamically populate every single PDF through FDF - no problem. However, with 7,000 or so records it becomes impossible to manually loop over e

RE: ColdFusion MX / Studio MX now available!

I wonder if they will fix the annoying security bug that crashes it every other time I open it. John McKown > -Original Message- > From: Shawn Grover [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 11:15 AM > To: CF-Talk > Subject: RE: ColdFusion MX / Studio MX now avail

RE: manipulating mail server / CFPOP variables...

> I am simply passing getdetail.FROM variable into the TO text > box of a reply page, however the variables value is ie. > "Paul" <[EMAIL PROTECTED]> so when getdetail.FROM is past to > the reply page its value is showing up in the debugger as > "Paul", is there a way I can pass just the email add

RE: manipulating mail server / CFPOP variables...

One simple thing you can do is to try and use single quotes in the value attribute: -Original Message- From: Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:37 PM To: CF-Talk Subject: manipulating mail server / CFPOP variables... I am simply passing getdetail.FROM vari

RE: ColdFusion MX / Studio MX now available!

In DWMX? It's fixed (on my install at least) it took 10 minutes to start the preview release this morning, but I've just ran up the trial problem in 10 seconds :) > -Original Message- > From: John McKown [mailto:[EMAIL PROTECTED]] > Sent: 29 May 2002 17:29 > To: CF-Talk > Subject: RE: Co

Failed to initialize Security Client. Error Code: 110

I refuse to purchase DWMX until they fix this annoying message that crashes it 8 times out of 10 when I open the program: "Failed to initialize Security Client. Error Code: 110" John McKown __ Your ad could be here. Mo

RE: CFFTP  + FileExists  =  buggy

Sure(remember, i found this to work if the ftp server is also the localhost, but not on a remote server) /*So far so good, can do a "getcurrentdir" and can see that I'm in the pdfs directory like I should be */ /* The following line of code will throw an unknown cfftp exception erro

RE: Failed to initialize Security Client. Error Code: 110

WORD! -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:35 PM To: CF-Talk Subject: Failed to initialize Security Client. Error Code: 110 I refuse to purchase DWMX until they fix this annoying message that crashes it 8 times out of 10 when I

RE: generate multiple PDFs automatically

We use active pdf- then the user can query on what they want (ie: individual report card/report card for class/report card for entire grade). It works well but it can get a bit slow-it'll take over a minute to do an entire grade--but the clog is in the cfsets. I did use the fdf too- you should be

RE: manipulating mail server / CFPOP variables...

Thanks, I viewed the source and...this is what shows up TO: "> so the value is being past, just not displayed properly? Still all that is being displayed is that "> and the end of the code. -Paul __ Your ad could be here. Mon

Re: Failed to initialize Security Client. Error Code: 110

Which has nothing to do with DWMX, that's the vbox security client... it won't even be in the full version of DWMX. On Wed, 29 May 2002, John McKown wrote: > I refuse to purchase DWMX until they fix this annoying message > that crashes it 8 times out of 10 when I open the program: > > "F

RE: Multiple CFApplication under 1 application.cfm

Your example should work, but I've always had trouble changing the session timeout. Just keep track of it manually instead. Put this in application.cfm: - expire the session relocate to login page

RE: ColdFusion MX / Studio MX now available!

Yup, here's the link to the press release: http://www.macromedia.com/macromedia/proom/pr/2002/mx_available.html Regards, Christine -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:22 PM To: CF-Talk Subject: RE: ColdFusion MX / Studio MX no

RE: Failed to initialize Security Client. Error Code: 110

My Flash MX still does that, it is like it tried to initialise something too quick! Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/ -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]]

RE: manipulating mail server / CFPOP variables...

Wow haha that was easy. Putting single quotes around VALUE='#Form.MailFrom#'> seems to have fixed the problem Thank you -Paul __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthorit

RE: CFFTP  + FileExists  =  buggy

OK, from experience; Remember that the "directory" of the file has to be as the FTP client sees it Now, come put "/folder/file", others use "drive:/folder/file" and other still use "/drive:/folder/file" - you have to get the right one of the server Connect to it via a FTP client and see how it

debug info to dynamic IP?

We have a problem getting debugging info to users with dynamic IP's. Most of us have static IP's, but some off-site folks have dynamic IP's. Is the trick to put their router in the list of debug IP's, or something? many thanks, Chris Norloff ___

RE: Multiple CFApplication under 1 application.cfm

Make sure you change the maximum session timeout in the CF administrator. It defaults to 20 minutes and if you haven't changed that it won't matter what you put in the cfapplication tag. -Original Message- From: Perez, Percy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:14

Memory problems

We've been having problems lately with our server running out of memory. I've gone over everything looking for unlocked session variables and cfx tags. We've increased the amount of RAM on the server. But still we're having problems, which seem manifest themselves first in errors generated by cf

RE: Memory problems

That's a known "Feature" Schedule a task that restarts all the cold fusion services in the middle of the night using the command line net stop and net start commands. It's documented in the knowledge base somewhere deep in there, but it's pretty simple to get a batch file built to restart the co

RE: CFFTP  + FileExists  =  buggy

Have tried that already. Thanks. Have you connected to a "remote" ftp server using this exact chain of commands ? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topi

RE: Memory problems

I think in the cfusion\bin directory there is a batch file provided that sets up your scheduler to restart cf services at 2am (or so). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Costas Piliotis [

OT: A helpful link

Here's a tutorial on using VBScript dialog boxes. http://www.webreference.com/dhtml/column22/index.html __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: htt

RE: Memory problems

> We've been having problems lately with our server running out > of memory. > I've gone over everything looking for unlocked session > variables and cfx tags. We've increased the amount of RAM on > the server. But still we're having problems, which seem > manifest themselves first in errors gen

CFMX on OSX

Sorry to be a pest but wasn't someone going to post a how-to on how they got CFMX running on OSX? Thanks in advance, John Venable __ Your ad could be here. Monies from ads go to support these lists and provide more resources fo

MAX function problem

Hello, Everytime I use this function I have problems. My code is below. I keep receiving an error saying: "The column THEID is not present in the query named GETID" SELECT MAX(ID) FROM UserInfo AS TheID #GetID.TheID# thanks for your help, Sal

RE: MAX function problem

The problem is that your As TheID needs to appear immediately after Max(ID) like so: SELECT MAX(ID) AS TheID FROM UserInfo The way you have it actually is renaming the table not the result. -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:28 AM To

Re: MAX function problem

Try: SELECT MAX(ID) AS TheID FROM UserInfo HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://w

OT: Image Servers

I'm investigating image servers for Win32. So far, I'm looking at... MGI/Roxio Zoom Server Adobe Altercast Macromedia Generator Can anyone suggest any other image servers that would serve well in an enterprise environment? I'll just add those to my research. Thanks :) Eric _

RE: MAX function problem

SELECT MAX(ID) AS TheID FROM UserInfo Use the above SQL instead. -Matt > -Original Message- > From: S R [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 10:28 AM > To: CF-Talk > Subject: MAX function problem > > Hello, > > Everytime I use this function I have problems. My co

RE: MAX function problem

I believe you should word your query as SELECT MAX(ID) AS TheID FROM UserInfo Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376

RE: Image Servers

> I'm investigating image servers for Win32. So far, I'm looking at... > > MGI/Roxio Zoom Server > Adobe Altercast > Macromedia Generator > > Can anyone suggest any other image servers that would serve well in an > enterprise environment? > I'll just add those to my research. Generator is a "dea

RE: CFMX on OSX

Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/ -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED]] Sent: 29 May 2002 18:26 To: CF-Talk Subject: CFMX on OSX Sorry to be a pest but wasn't

Re: MAX function problem

Try: SELECT MAX(ID) AS TheID FROM UserInfo Please tell me that this query is within a transaction, and that you're only doing this because you're using Access. - Original Message - From: S R <[EMAIL PROTECTED]> Date: Wednesday, May 29, 2002 11:28 am Subject: MAX function problem >

RE: MAX function problem

Thanks this solved the problem. Sal >From: [EMAIL PROTECTED] (Scott Brader) >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: MAX function problem >Date: Wed, 29 May 2002 12:34:21 -0500 > >I believe you should word your query as > >SELECT MAX(ID) AS TheID FROM UserInfo

RE: CFMX on OSX

Oops, got carried away with the send button but...Yep, it was Dick Applebaum. I am intrigued also, he said he would post something in a few days, that was weeks ago! Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/t

RE: Image Servers

how about something free like JGenerator http://www.flashgap.com/ the site even has a comparision between it and Macromedia Generator. Best of all, it's FREE! Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP

Re: OT: Image Servers

Drop Macromedia Generator... no longer available. FlashMX/CFMX replaces that (and, possibly future add-ons, least, I think that's what tincan is, etc.) ~Todd On Wed, 29 May 2002, Carlisle, Eric wrote: > I'm investigating image servers for Win32. So far, I'm looking at... > > MGI/Roxio Zoo

RE: Memory problems

Yup. It's called Cycle.bat Forgot about that... -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:12 AM To: CF-Talk Subject: RE: Memory problems I think in the cfusion\bin directory there is a batch file provided that sets up your sche

  1   2   >