Need your opinion - PLEASE!

2001-09-09 Thread ccook22
I need to your opinions: Currently our database allows nulls on all fields besides primary keys and fields we have specified as wanting a default value. We now have database support outside of ourselves and their opinion is to not allow nulls and have a default value of a

Newbie Syntax Help

2001-09-09 Thread Jeffrey Cohen
Help!!! Please!!! OK..I'm new at this, so be kind... I have a pulldown menu, that returns a URL like: marketplace.cfm?request=cat marketplace.cfm?request=twn or marketplace.cfm?request=alpha Then, in marketplace.cfm, I am trying to ORDER BY the variable above, like CFQUERY NAME=GetResults

RE: CF output as PDF

2001-09-09 Thread Peter Tilbrook
Sharon, try ActivePDF (www.activepdf.com). It is expensive, especially for non-US countries, but it works well. I last used it for onlinewills.com.au. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph:

Re: Disabling back button

2001-09-09 Thread Joseph Thompson
All this talk about about disabling back buttons makes me think that the more convulted solution (session/CGI variables) may in fact be the best way? Store the current page and the previous page (from CGI) in the session scope and then simply not alow any actions? That approach is outlined by

Re: Cold Fusion and Webcasting

2001-09-09 Thread Joseph Thompson
I have been playing with an application scoped variable that tracks all users that are logged in. I haven't got it sending messages to specific individuals but that functionality does exist... I may be broaching that subject soon and will let you know what I come up with if yo are interested.

RE: creating excel file in the REQUESTED format

2001-09-09 Thread Wayne Annis
Can you give me an example of the first option. I think I am missing something. Thanks, Wayne -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 8:43 AM To: CF-Talk Subject: RE: creating excel file in the REQUESTED format I'm not sure I

RE: negative numbers

2001-09-09 Thread Brent Goldman
Hi, cfif var lte0 ...CFML... /cfif -Brent -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 3:07 PM To: CF-Talk Subject: negative numbers I want to check to see if this value is a 0 or a negative number. How would I do this?

CFPARAM, structures and array style notation

2001-09-09 Thread Aidan Whitehall
This works... CFPARAM NAME=session.Account DEFAULT=#StructNew()# CFPARAM NAME=session.Account.LoggedIn DEFAULT=no but this throws an error (Invalid token found on line 2 at position 41 - the apostrophe after LoggedIn)... CFPARAM NAME=session.Account DEFAULT=#StructNew()# CFPARAM

Re: Need your opinion - PLEASE!

2001-09-09 Thread Nick Texidor
For what it's worth Casey, I've been developing with SQL Server, and prior to that Subase, for a number of years now, and I have never heard anyone say that fields should be a space instead of NULL. Personally, I'd leave it as it is!! N on 8/9/01 1:52 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]

Re: Newbie Syntax Help

2001-09-09 Thread Nick Texidor
Your syntax should read... CFIF request EQ cat etc N on 9/9/01 4:11 PM, Jeffrey Cohen at [EMAIL PROTECTED] wrote: Help!!! Please!!! OK..I'm new at this, so be kind... I have a pulldown menu, that returns a URL like: marketplace.cfm?request=cat marketplace.cfm?request=twn or

Re: Repeated emails - OT thread

2001-09-09 Thread Michael Dinowitz
I finally nailed it. God I hate Post.Office. I'll be glad once the final piece is moved over to iMS. I'm sorry for the down time and the duplicates. Things should be back to normal and a slight bit faster as well. Mike's email thingamajig is doing wierd stuff. one of my post was there 3 or 4

CFSearch Display Summary from Web Page..

2001-09-09 Thread Angel Stewart
Hi all, I was wondering if it were possible to display a summary from a webpage with a cfsearch? I.e. I want results to look like ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

Re: Get It Together ----- Whatever It Takes

2001-09-09 Thread Michael Dinowitz
The list is back on track. I'm going to be polite and say that I've spent a lot of time with the list getting it rolling again and all. I'm not required to give an excuse to anyone who dosn't appreciate the help that others give of their own free time. And as for the problem being CF driven, it

Re: Get It Together ----- Whatever It Takes

2001-09-09 Thread Dick Applebaum
Thanks Michael The list was missed, while it was unavailable. Your efforts are understood and appreciated by most. In my 4 + years on the web, I have seen only one other list (a Perl list) that even came close to the content, expertise and, yes, reliability of this list. As far as

Re: cfquery Question

2001-09-09 Thread [EMAIL PROTECTED]
sp_tables and sp_databases? Try connecting to the MASTER database ( if you can ) and TRY: SELECT * FROM SYSFILES SELECT * FROM SYSFILES1 SELECT * FROM DATABASES SELECT * FROM SYSPERFINFO Also, sp_databses and sp_tables are in plain text if you go through Enterprise Manager to the Stored

RE: Get It Together ----- Whatever It Takes

2001-09-09 Thread Aidan Whitehall
Let's get this list back on track. Messages shouldn't be receieved more that 1 hour after they're sent. They shouldn't be received more than once. Beyond that, there are no excuses. I share your frustration, but then I also share the fact that you have a delete key, aren't paying

Re: CFPARAM, structures and array style notation

2001-09-09 Thread Jeffry Houser
At 04:39 PM 09/07/2001 +0100, you wrote: This works... CFPARAM NAME=session.Account DEFAULT=#StructNew()# CFPARAM NAME=session.Account.LoggedIn DEFAULT=no but this throws an error (Invalid token found on line 2 at position 41 - the apostrophe after LoggedIn)... CFPARAM NAME=session.Account

Re: how to randomly generate a string of 10

2001-09-09 Thread tom muck
Try this: cfscript theString = ; for (i=0; i LT 10 ; i=i+1) { theNum = RandRange(48,90); if(theNum LTE 64 AND theNum GTE 58) { i=i-1; }else{ theString = theString chr(theNum); } } /cfscript If you have CF 5, you can make a UDF out of it: cfscript function

uk_postcode

2001-09-09 Thread W Luke
Has anyone managed to get the uk_postcode tag (in the gallery) working? Rgds Will ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ:

Re: SOT (long) Need for Standalone CF

2001-09-09 Thread Jon Hall
I've thought about this a little, and I would love there to be a scriptable COM object of the CF engine (imagine using CF for asp/wsh! :-) ). Although with the architecture overhaul to a Java engine, COM/ActiveX is probably out of the picture though. With so many unanswered questions about

print all open files into one file

2001-09-09 Thread rathgar
Ok guys, Does anyone know how to print all files opened in CF Studio 4.5.2 in to one file? I have a full project (about 40 .cfm files) that I want to concatenate into one file for word processing. I can print to an output file ok but when I choose to print 'all open files' , a new file is

RE: Get It Together ----- Whatever It Takes

2001-09-09 Thread Allen Hudson
For what it is worth, this list is an amazing resource. Keep up the good work MD! I was going to say that the benefit that I have received from this list is more than most courses I have taken and certainly more than any magazine I have purchased (except maybe a lasting subscription). My

Re: Newbie Syntax Help

2001-09-09 Thread Steven Durette
You might be able to speed up the query and get it to work if you make a few minor changes. In the form instead of : marketplace.cfm?request=cat marketplace.cfm?request=twn marketplace.cfm?request=alpha change it so the options are: marketplace.cfm?request=category marketplace.cfm?request=town

Re: SOT (long) Need for Standalone CF

2001-09-09 Thread Dick Applebaum
At 11:50 AM -0400 9/9/01, Jon Hall wrote: I've thought about this a little, and I would love there to be a scriptable COM object of the CF engine (imagine using CF for asp/wsh! :-) ). Although with the architecture overhaul to a Java engine, COM/ActiveX is probably out of the picture though. With

Re: SOT (long) Need for Standalone CF

2001-09-09 Thread Jon Hall
response inline... Dick Applebaum wrote: At 11:50 AM -0400 9/9/01, Jon Hall wrote: I've thought about this a little, and I would love there to be a scriptable COM object of the CF engine (imagine using CF for asp/wsh! :-) ). Although with the architecture overhaul to a Java engine, COM/ActiveX

Re: PostGre SQL

2001-09-09 Thread Jochem van Dieten
John Paitel wrote: Has anyone used this with Cold Fusion? How hard was the implementation? We are currently using PostgreSQL 7.1.2 on OpenBSD in conjunction with CF 4.5.1 SP2 on NT with the 7.06 ODBC drivers. Overall, it runs good. The only thing that prevents me from saying smoothless is

OT: CF hosting in NZ and Canada

2001-09-09 Thread W Luke
Hi, I'm looking into hosting for 2 companies in NZ and Canada. Are there any New Zealanders on this list, and can they recommend a well-establised and well connected hosting company that supports CF? Same with Canada if possible. Any recommendations and advice will be much appreciated. TIA

Re: SOT (long) Need for Standalone CF

2001-09-09 Thread Dick Applebaum
At 3:39 PM -0400 9/9/01, Jon Hall wrote: Snip or .Net's CLR. We are able to develop .Net apps in Javascript, VBScript, Perl, Python (same as wsh)... I'd love to see CF added to that list. Why reinvent the wheel? .Net is an open spec...and preinstalled on all future machines. A few

Index of array

2001-09-09 Thread John Allred
Is there a way to compare the content of a variable with the members of an array to get the index position of the corresponding array element? Maybe there's a better way to do this, but this seems like the right direction. What I have is a query with two columns, one alpha and one numeric

Re: OT: CF hosting in NZ and Canada

2001-09-09 Thread Peter Mott
At 10/09/2001 08:13, you wrote: Hi, I'm looking into hosting for 2 companies in NZ and Canada. Are there any New Zealanders on this list, and can they recommend a well-establised and well connected hosting company that supports CF? www.2day.com is your best choice for CF hosting in New Zealand

Re: Index of array

2001-09-09 Thread Antonio Mokarzel
An easy question to finish this sunday: Does the function Now() show me the server time or the client time? I run a city guide and I want to show what time is it in my city and in other cities around the world. I need to show my server time. If Now() couldn´t do it, which one should I use?

RE: Index of array

2001-09-09 Thread Chip Griffin
now() shows server time -Original Message- From: Antonio Mokarzel [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 09, 2001 5:45 PM To: CF-Talk Subject: Re: Index of array An easy question to finish this sunday: Does the function Now() show me the server time or the client time? I

ColdFusion International Language Search Pack

2001-09-09 Thread Antonio Mokarzel
I would like to index data in Portuguese. I asked Macromedia where could I purchase the Language Search Pack and they answered me that they don´t sell it anymore. What can I do to solve this problem? Does anyone know where can I purchase it? Thanks in advance. Antonio Mokarzel --- Visite a

Re: Repeating Messages

2001-09-09 Thread Gonzo Rock
Nope... I've been getting them on and off again for weeks UnSubscribed and ReSubscribed trying to fix it... Not much seems to help. I figure Michael is working on it... it's just the waiting that's making me crazy :-) At 11:59 AM 9/6/01 -0500, you wrote: Is it just me or am I seeing a

RE: CF and MS Word Docs

2001-09-09 Thread Greg Saunders
I can't help much with cleaning up Word's HTML, but as far as converting a Word doc to HTML via CF, see: http://www.cfcomet.com/cfcomet/Word/index.cfm?ArticleID=B70AD80E-3DAF-4CDC-AEA1E8059FD78D43 It's CF rather than CFX, and I know how to find the author of this one ;-) If you find it

RE: SOT (long) Need for Standalone CF

2001-09-09 Thread Dave Watts
What is .net CLR? CLR is the Common Language Runtime, a core part of Microsoft's .NET plan. The idea is that you can write code in many languages, and they'll all use the same runtime library, making code very portable (at least across platforms that support the runtime). Is it supported on

Re: ColdFusion International Language Search Pack

2001-09-09 Thread Paul Hastings
I would like to index data in Portuguese. I asked Macromedia where could I purchase the Language Search Pack and they answered me that they don´t sell it anymore. thats right. i think it comes free with cf5 anymore. ~~ Get the mailserver that

RE: SOT (long) Need for Standalone CF

2001-09-09 Thread Dave Watts
But, what about Java and the millions of $ and man-years invested in that? I think that Microsoft has come to the (correct) conclusion that Windows is not going to be considered the ideal platform for Java servers. Even if it were, Microsoft can't provide Java functionality that is

RE: SOT (long) Need for Standalone CF

2001-09-09 Thread Kwang Suh
I'm taking a Java course currently; the teacher stated that Java has something like 80% of the server programming market at present. If this is true, MS is going to have a very tough time penetrating the Java's inroads. Also, with Java's RMI, having different OSs on the backend finally seems to

Create Excel document

2001-09-09 Thread zap005
Hi There, My hosting provider does not allow cfcontent or COM objects. I need a way to insert the excel document type into the header of a document without using cfcontent, or launching excel on the server...does anybody have any ideas. Thanks Doug