Re: OT: Advice on Max number of files in a dir.

2004-06-29 Thread Chris Maloney
There isn't a limit to the number of files you can have in a
directory.The only time you will begin to notice a performance slow
down is when you list the directory.

Chris 

- Original Message -
From: J M [EMAIL PROTECTED]
Date: Tue, 29 Jun 2004 09:15:30 -0400
Subject: OT: Advice on Max number of files in a dir.
To: CF-Talk [EMAIL PROTECTED]

Hi all,
I am using CFCONTENT to retrieve photos stored off of the root
directory. I didn't think the site would grow so fast, and I have been
allowing users to upload all of the images to one folder. I am now at
about 6000 images and am woried about performance issues both with
CFCONTENT and Win2k.

What is the maximum number of files allowable in a Win2k directory? 10,000?

Any info appreciated.

JM
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Kill the President

2001-07-18 Thread Chris Maloney

What an impressive show of immaturity.

-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, July 18, 2001 6:55 AM
To: CF-Talk
Subject: Re: Kill the President

WOT 

But try this

drop dead you commie puke

lousy hippies
- Original Message - 
From: John McCosker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 5:42 AM
Subject: Kill the President


 Sorry if I ruffle anyone's feathers here not a CF topic, but
 
 I watched the 9 0'clock news last night on BBC 1 and watched an 
 interview
 with the President of the United States,
 George Bush.
 
 This morning we have all been discussing the future career of this 
 man and
 we all agree it will probably be short lived
 if America does realise what they have sitting in the presidential 
 armchair.
 
 A man during his Judicial Congress career in Texas, managed to 
break 
 all
 records and have more Death Row 
 prisoners put to death by 4 times during his residency.
 
 Now as the President of the United States, 
 Bush has made it quite clear he is not interested in the quick turn 
 around
 to Global warming as is the rest of the World, 
 he has declined to get involved with Northern Ireland after so much 
 hard
 work with the Clinton Administration, 
 his involvement and stance with the middle east peace process has 
not 
 been
 made clear,
 
 and the most worrying is that he has decided to set the world back 
15 
 years
 by re-establishing a Nuclear presence.
 
 To quote the President, I have said before to the rest of the 
world 
 there
 is no more cold war, but America must protect 
 itself from a rogue dictator
 
 What kind of signals is this sending out to the rest of the world,
 especially China?  Its not so long ago only in the job by a 
 few weeks he started to play hard ball against China, when their
 reconnaissance aircraft was forced to land after infringing 
 Chinese airspace, their plane never recovered and America forced to
 apologize.
 
 Two years ago India and Afghanistan proceeded to test nuclear 
 missiles and
 America opposed with the rest of Europe intensely, 
 a global united stance, a sense of security and lack of desire for 
 Military
 confrontations, Bush has decided to scrap this idea 
 and restock on nuclear arms.
 
 Where is the political responsibility and consistency of America 
 going, to
 be seen to be undoing all the hard work of a 
 previous administration that sent America to it pest political and
 economical climate for decades, if even hasten to say ever can 
 only be seen as a dictatorship in its own right.
 
 George Bush is not smart enough to be president, he lacks in 
 humility, he is
 not political sound and what's worrying is if he 
 continues to create a global stir someone could effectively try to 
 kill the
 president.
 
 
 JMC
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Need decryptor tag for CFUG presentation

2001-06-08 Thread Chris Maloney

I haven't reviewed how the macromedia license handles these aspects, but
what is interesting to note is this, Yes, it isn't exactly a 'moral' thing
to decrypt someone else's tag and use their code. You could likely be
confronted with some serious copyright infringement legal issues from the
author of the tag.  However, we all know that the world isn't exactly a fair
place and practices like this happen frequently.  Reverse engineering of
programs has been around for a long time and will probably remain until
everyone develops some sort of conscience.

I do find it interesting that technical support can resolve a 'encryption
issue' though...basically tells me that the encryption isn't too secure to
begin with :)

Chris

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 8:45 AM
To: CF-Talk
Subject: RE: Need decryptor tag for CFUG presentation


Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden
of Macromedia, but isn't use of this decryptor illegal? Should we so
casually discuss a piece of a software that is probably illegal to use?

Also, in general, unless you encrypt your OWN files, you should not be
decrypting other people's templates. If you _do_ encrypt your files, you can
contact Tech support for help. Therefore, there is no need for this
software.

Am I wrong here? And let's not discuss wether it's right or wrong, I'm
talking about legality.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

My ally is the Force, and a powerful ally it is. - Yoda

 -Original Message-
 From: Jones, Matt [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 08, 2001 9:37 AM
 To: CF-Talk
 Subject: RE: Need decryptor tag for CFUG presentation


 http://shrewm.net/cfd/

 -Original Message-
 From: Alii Design [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 08, 2001 8:30 AM
 To: CF-Talk
 Subject: RE: Need decryptor tag for CFUG presentation


 That website is gone http://shroom.dv8.org/cfd/ I was looking for it
 recently and it has been down.
 Is there another?
 Rich

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Need decryptor tag for CFUG presentation

2001-06-08 Thread Chris Maloney

True, I think my point was more in finding humor in the fact that a simple
call to technical support would resolve the issue :)

I've never actually looked at what CF generates for encrypted content but I
assume that the key is stored with in the encrypted file or that CF has a
'master' key for decrypting it.  In any event, however, it prevents the
standard user from being unable to read the code.

Chris

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 10:29 AM
To: CF-Talk
Subject: RE: Need decryptor tag for CFUG presentation



 I do find it interesting that technical support can resolve a 'encryption
 issue' though...basically tells me that the encryption isn't too secure to
 begin with :)

I wouldn't say that. Even super-strong encryption things can normally be
decrypted... otherwise, what's the point? Unless your talking about a one
way encryption, but that's something different. (Although I'm no crypto
expert.)

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

My ally is the Force, and a powerful ally it is. - Yoda
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: IE 6

2001-06-07 Thread Chris Maloney

win2k running the beta of IE6 works fine for viewing source and images save
fine.  Only issue I have is that if you hit a non-working url it displays
the error, however if you enter another non-working url it will sit and act
like it's trying to load a page. That's about the biggest bug I've seen.

Chris

-Original Message-
From: Alii Design [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 11:28 AM
To: CF-Talk
Subject: OT: IE 6


Does anyone know why IE 6 will not let me view any source code and will only
let me save pictures in bitmap format?
I just installed the beta, is there a way to adjust these settings?

Rich
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: the dbl devil

2001-05-11 Thread Chris Maloney

Megan,
Provided you are using CF4.5.x you should be able to use the
cfusion_dbconnections_flush() function to release the database. You do need
to make sure that from the time you release the connection to the time you
delete the database or replace it that no database accesses are done,
otherwise the database will again be locked.

The use of 'date' as a field name is a pretty common mistake, it would be
nice if Access provided warnings about this when you create a database but
it does not.

Chris

-Original Message-
From: megan sherman [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 8:27 AM
To: CF-Talk
Subject: the dbl devil


Hi all,
I'm using Access for my database. Sometimes when I need to make changes
to the database on the server there is a .dbl file in the directory. I
can't delete it, and it won't let me upload the database. A couple days
ago someone on this list said to create a query calling a table that
doesn't exist. I did that. Got the error on the screen, but the devilish
dbl was still there. I talked to my cf host and he said, Your code is
holding your database too long..put in your code a time to release the
database after so many minutes. Does anyone know what he was talking
about?
 Also, thanks for your assistance on my syntax error when inserting
date. I was thrown off because cfinsert and cfupdate worked fine. But
all went awry when I tried to use insert in a query in a cfloop. So
changing the field name from date to classdate did the trick.
Thanks!
Megan



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Replace #'s Function!!

2001-05-10 Thread Chris Maloney

try this and see what happens...

cffile action=READ
file=d:\code.txt
variable=code

cfset code = Replace(code, ##, , ALL)
cfoutput#code#/cfoutput

Chris

-Original Message-
From: bfalloon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 1:07 AM
To: CF-Talk
Subject: Replace #'s Function!!


Hello all,

I've encounter a stumbling block...

I'm performing a CFFILE action to read a text document that contains HTML,
but I need to remove any # symbols before I can used the code from the file.

I've included my code below, but the # symbol always throws an error.
I've also tried double pound signed, but that just seems to completely
escape the symbol to replace.

cffile action=READ
file=d:\code.txt
variable=code

cfset temp = #code#
cfset session.source = Replace(temp, #, , ALL)

In the Replace function I am tried to replace all #'s with nothing...
It's not working though.

Your help is greatly appreciated!!

Benjamin
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Post-Spectra Content Management Systems??

2001-05-10 Thread Chris Maloney

I spent 20 mins looking around trying to find information on the 'demise' of
Specta and did not find a thing. I am curious where you obtained this
information, as far as I can tell Spectra is still a completely viable
product.

Chris

-Original Message-
From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 8:05 AM
To: CF-Talk
Subject: Post-Spectra Content Management Systems??


I'm sure this has been discussed already, so apologies up front.

We are a web co that has been developing Spectra apps for our clients mainly
because of its content management (CM) functionality. With the demise of
Spectra, does anyone know of a reliable and robust ColdFusion CMS that is
commercially available?

Thanks
Steve



Development Manager
Vardus Internet Solutions (SA)

Tel: (+27) 21 670 9880
Fax: (+27) 21 674 4549

Email: [EMAIL PROTECTED]
Website: www.vardus.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Post-Spectra Content Management Systems??

2001-05-10 Thread Chris Maloney

Thanks...I finally came across that email, but from what I could tell there
was nothing on the Allaire/Macromedia site about it which seems a little odd
to me.

Chris

-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 8:59 AM
To: CF-Talk
Subject: RE: Post-Spectra Content Management Systems??


This was posted by Charles Teague on the Spectra Forum.

.
Hi everyone. We really appreciate everyone's patience over the last few
weeks. There has been a lot of discussion and concern over the future of
Spectra, and I think that the time is right to shed some light on what we
are thinking.

As you know, Spectra provides developers with a broad set of functionality
and technology. Enough so, sometimes its breadth proves daunting.
Fundamental to the entire product, however, is its foundation - the content
object API. In 1996, when I first started working on Allaire's website, the
foundational change that I went through was around thinking about the site
as composed of 'content objects.' Over the last 5 years, this core concept
has been revised, revolutionized, improved, and expanded. Spectra has been
the product that carried this concept forward. This concept, and the content
object API, have been the most compelling pieces of Spectra since its
inception.

Macromedia's goal is to make dynamic content technology like the content
object API pervasive, approachable, and cost effective for our developers.
To help us better achieve this, we plan to incorporate key components of
Spectra technology - a Java-based version of the COAPI architecture and
other services directly related to dynamic content - into the application
server, as well as delivering next generation dynamic content technologies
such as end-user content contribution and team production through a series
of new product initiatives. This means that version 1.5 will be Spectra's
last feature additive release - we'll invest our resources in making the
core technology that we move into our application server and visual tools
faster, easier, and better.

Macromedia will continue to support Spectra via a community source model,
on-going technical support, training, and consulting, as well as having a
team of engineers working on bug fixes and quality assurance for community
source submissions. Spectra will continue to be offered for sale, using our
partners as the primary sales channel. We also will do our best to give you
early access to technology previews, alphas, and betas of the new
technologies already under development.

In the world we live and work in, technology changes constantly, we've all
thrived because of our ability to adapt to change. This is no different - a
change for the Spectra Product Group, and for every developer, customer and
partner out there who has invested their valuable time and mind share into
Spectra. While I understand the challenge that a change like this can pose,
I am extremely optimistic. The core vision of the Spectra technology is
compelling - the opportunity to make this technology available to more
developers, cheaper, and better, is a chance that I relish. I hope you share
my optimism through this time of change

!-
Neil Clark
Senior Web Applications Engineer
Spectra / ColdFusion / XML / Cerebro
MCB Digital
Macromedia Alliance Member
Tel: 020 8941 3232
Fax: 020 8941 4333
Mobile : 077719 448 227
e-mail: [EMAIL PROTECTED]

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Pinging an email address

2001-05-09 Thread Chris Maloney

There is no explicit way to 'ping' an email address the best and only way to
do it is send an email to that address.  If the host rejects the email the
address is invalid.  If the email is accepted it's likely valid.  Typically
the best way to verify an email address is to have the user click on a link
inside the email that directs to a page you have and then flags the entry in
the database as a valid email address.

Chris

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:59 PM
To: CF-Talk
Subject: Pinging an email address


Is there a way to ping an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Can I run CFML code that I pull form my database?

2001-05-09 Thread Chris Maloney

Robert,
Considering I've seen other replies to this post that were considerably
inaccurate, I'll give you a proper solution.

The way to solve this problem is to take the data from the database write it
to a file and then use cfinclude to include the file back in and thus have
the code executed.

Now, there is a danger in using this method, because someone could fill out
a form and have code written into your database that may cause damage to
your system.  However you could easily filter the users input and strip out
any tags they may have put into the form.

Using evaluate() will work, provided however, you are only using CF
functions and not using tags.  Since you are using tags this method is not
an option.

Chris

-Original Message-
From: Robert J. Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:28 PM
To: CF-Talk
Subject: Can I run CFML code that I pull form my database?


OK, here is what I am doing. I am executing a stored procedure which grabs
some code from my SQL server and then displays it on the page. Mostly what
this is for is my forms, which I would like to keep in the DB so I can
easily change them. The problem being that the CFFORM tag as well as my
CFINPUT tags do not execute when doing this and it displays the tag CFFORM
etc in the browser. I am not good at explaining things so if I did not do a
good enough job trying to ask this question, please let me know. Thanks for
all that will have a solution that I can implement.


Robert J. Bailey
(646) 526-4536
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: syntax error when inserting date

2001-05-09 Thread Chris Maloney

Actually the problem is that you have a field in your database named 'Date'
this is a reserved word and cannot be used as a field name in your db.  Try
changing the field name to something like 'mydate' or some other equivalent
and try your code again, you will likely see better results.

Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:06 PM
To: CF-Talk
Subject: RE: syntax error when inserting date


Your problem is most likely due to the format of the date.
If the data field in the database is of type 'Date' you would have to use
CreateODBCDate(Form.Date) in order to change the text to an ODBC date
format.

Regards,

Rob Rusher

Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
Java Programmer

email: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] phone: 303-885-7044

plan, build and integrate interactive applications and e-business services
to enhance knowledge sharing, e-commerce and business communications
initiatives



-Original Message-
From: megan sherman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 8:02 AM
To: CF-Talk
Subject: syntax error when inserting date


Hi all,
My action template is supposed to insert classID, location and date into
a table in my database. When creating new records in the form I provide,
I want the user to be able to supply a comma delimited list of dates. I
think the loop in the action template successfully extracts individual
dates from the date list, but there is a syntax error in the insert
command. Everything works if I don't try to insert the date, so that
must be where the syntax error occurs. Can anybody tell me what my date
syntax error is?
Thanks in advance!
Megan
The action template code is shown below
CFIF IsDefined(FORM.scheduleID)
 CFUPDATE DATASOURCE=calkayak TABLENAME=class_schedule
CFELSE
cfoutput
cfset dategroup=form.date
cfloop index=x from=1 to=#ListLen(dategroup)#
cfset onedate=ListGetAt(dategroup,#x#)
cfquery datasource=calkayak
insert into class_schedule (classID, location, date)
values(#form.classID#, '#form.location#', '#onedate#')
/cfquery
/cfloop
/cfoutput
/CFIF


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: ASP NumberFormat

2001-05-08 Thread Chris Maloney

Nathan,
At first only your newsletters made me wonder about your lack of
professionalism.

Chris

-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:58 AM
To: CF-Talk
Subject: RE: ASP NumberFormat


Your treading on THIN ICE mentioning that COMPETITOR...   grin

Nathan Stanford
Senior Programmer/Analyst
[EMAIL PROTECTED]


 -Original Message-
 From: Bernd VanSkiver [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, May 08, 2001 10:23 AM
 To:   CF-Talk
 Subject:  OT: ASP NumberFormat

 Sorry about bringing ASP in to the list but am having
 troubles finding the solution and was hoping someone
 here might know the answer.  I am needing a way to
 format a number in ASP similar to the CF function
 NumberFormat()  Is there a function or something in
 ASP for this?  I'm not sure if ASP even has built in
 support for this.  I am programming the ASP in
 VBScript.


 =
 Bernd VanSkiver
 [EMAIL PROTECTED]
 ColdFusion Developer
 ICQ UIN: 916324

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Report

2001-04-26 Thread Chris Maloney

Considering you didn't paste any errors that you have received with this the
first thing I suggest you do is change the name of your date field from
'Date' to something else like 'myDate'. 'Date' is a reserved word in SQL and
frequently causes problems because Access will not warn you of this when you
are creating a table.

Chris

-Original Message-
From: Shally [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:05 AM
To: CF-Talk
Subject: Report


Hi Every one,
I have an access table having 3 fields Date, Quantity
and Amount.
I am working on a report where I have to calculate the
Quantity and Amount on quarterly bases for last year
and this year.
I tried using the function Quarter but an unable to
reach any solution.Please help!!

Thanks in advance
Shally.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: ORACLE DATE INSERT ERROR.. Help.

2001-04-26 Thread Chris Maloney

Your parenthesis are incorrect... your CF code should be this

cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
 VALUES (
'#form.first_name#',
to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-'),
'#form.last_name#')
/cfquery

you missed the closing parenthesis on the to_date() function


-Original Message-
From: Greenberg, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 1:31 PM
To: CF-Talk
Subject: ORACLE DATE INSERT ERROR.. Help.


I'm trying to insert a date into an Oracle table and get the following
error.  Help!!

 Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00917: missing comma.
SQL = INSERT INTO emirf (FIRST_NAME, REQUEST_DATE, LAST_NAME) VALUES (
'Lisa',to_date('26-Apr-2001','DD-MMM-','Lisa' )
Data Source = ADMS
Here is the CF code:
cfquery name=requestInsert datasource=#Application.SMInfo#
INSERT INTO emirf
(FIRST_NAME, REQUEST_DATE, LAST_NAME)
 VALUES (
'#form.first_name#',to_date('#DateFormat(Now(),'DD-MMM-')#','DD-MMM-
','#form.last_name#') /cfquery
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: generating report like crystal report with coldfusion...

2001-02-22 Thread Chris Maloney

Look up the cfreport tag in the manual. It will generate Crystal Reports
for you.

Chris

-Original Message-
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 9:56 AM
To: CF-Talk
Subject: generating report like crystal report with coldfusion...




Hi, all:

I am very new to ColdFusion, does anyone knows any tools or any feature in
ColdFusion of which will help you to generate reports-on-fly on the web? Of
course, the report
need to look and feel like crystal report...

Thanks.

MZ
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: What are some options for generating large outputs

2001-02-14 Thread Chris Maloney

Larry,
The best option I can think of is to use CFScript for the output, and put
the data inside of pre/pre tags so that you can format without having a
table...I can't tell you how much time this would save but it would reduce
the overhead used by the table...however you won't have any nice formatting
with it :)
Example code...

cfquery name="myquery" datasource="mydsn"SELECT username, firstname,
lastname FROM biglist ORDER BY username/cfquery
pre
cfscript
WriteOutput(" Username  First Name Last Name\n");
for(i=1;i LE myquery.recordcount;i=i+1)
{
WriteOutput(" #myquery.username[i]#  #myquery.firstname[i]#
#myquery.lastname[i]\n");
}
/cfscript
/pre

Chris Maloney


-Original Message-
From: Larry W. Virden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 10:17 AM
To: CF-Talk
Subject: What are some options for generating large outputs



A user has specifically requested to see the results of a query where
the resulting output is 32,000 or more records.  It takes more than
15 minutes to generate the huge HTML table that is currently being
generated, the server is slowed down during this time, the potential
for thread conflicts occur, etc.  We also are aware that some versions
of browsers that have severe problems attempting to display or print
massive sized tables.

An attempt was made to turn this data into html data which was then
imported into Excel as an alternate means of display - Excel then reported
with 'out of memory' after an hour

So what are some alternatives?  Perhaps generation of an Excel spreadsheet
directly - except does anyone know of a Solaris ColdFusion tag that runs
efficiently and generates an Excel compatible spreadsheet?  What are some
alternatives means of presenting massive amounts of tabular data?

--
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden mailto:[EMAIL PROTECTED] URL:
http://www.purl.org/NET/lvirden/
Even if explicitly stated to the contrary, nothing in this posting should
be construed as representing my employer's opinions.
--
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Dave's Burning Rant (WAS: virus comments)

2001-02-13 Thread Chris Maloney

Why not have someone else respond to this topic? It seems everyone else has.

As far as group psychology goes in the Lemmings case. If you remember the
movie Men In Black, Tommy Lee Jones has an interesting quote that applies,
"A person is smart, people are stupid." Who can't read a little truth into
that statement?

Chris Maloney


-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 9:43 AM
To: CF-Talk
Subject: RE: Dave's Burning Rant (WAS: virus comments)


30 Million Lemmings can't be wrong

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2001 15:29
To: CF-Talk
Subject: Re: Dave's Burning Rant (WAS: virus comments)


Dave,

I can't argue that people want "openness" on their desktops, but I'm not
sure I can go along with the notion that they're willing to sacrifice
security. As one who lost over 700 files on my desktop to the Melissa virus
(through no fault of my own), I for one want security. I really don't care
what other users on my network want if, through carelessness, they are
willing to risk my work. My time and my files are more valuable to me than
other's convenience.

What people want is not necessarily what they should be given. In other
words, what's popular is not always what's right.

Regards,
--John
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: error?

2001-02-12 Thread Chris Maloney

Jay, if you could include the code that caused the error it would help out.

Chris Maloney

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 5:53 PM
To: CF-Talk
Subject: error?


has anyone ever seen this error? if so what does it mean? ive never seen it
before...

Error:

Just in time compilation error

unknown parser error

The last successfully parsed CFML construct was a CFQUERY tag occupying
document position (1:1) to (1:8).

Thanks,

Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists