Who's cleverer than us?

[Garry Viner]

This is a multi-part message in MIME format.

--=_NextPart_000_0048_01C0321D.AA1FE030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi all

Certainly the trickiest problem we've found yet...

We are running some stored procs on our site, fairly complex and slightly
time intensive. These incorporate parameters, temporary tables, update,
deletes, inserts, selects and sometimes cursors. ie. basic proc stuff.

The procs work fine when run by a single user, however we have noticed that
when hit by concurrent sessions they go wierd. In these instances the procs
seem to "terminate". They return no result set, but even more than that,
they cease at different apparently random points within through the proc. If
the page is refreshed, no problem. When we have mutliple users just hitting
SQLServer (not running the proc through CF), no problem. When we run normal
queries as opposed to procs through CF, no problem. But for some reason
multiple hits on a proc from CF gives this problem. Could it be threading
via ODBC that's causing the problem? It doesn't even give an error, but
rather says there are no rows in the result set, which is patently not true.
We've proven that even when this happens, the proc is getting run, and the
parameters are being processed properly, so the best we can come up with is
that a thread in the stored proc is getting terminated when another thread
hits it. All CF sessions are locked (both write and read) and we have
discovered that sessions are not being lost and are being handled correctly.
Seems impossible to me, but I'm no expert on the back end stuff.

I know you guys like to see code, but there doesn't seem to be much point.
The code works just fine, and it's long and won't tell you anything that I
haven't already. I'm just interested to know if anyone has heard of such a
thing? Why would a proc be run but not get to the end, but equally not
trigger an error? And how can we fix it? We are stumped with a capital 'st'

TIA

Garry

--=_NextPart_000_0048_01C0321D.AA1FE030
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Hi=20
all
 
Certainly the=20
trickiest problem we've found yet...
 
We are running =
some stored=20
procs on our site, fairly complex and slightly time intensive. These =
incorporate=20
parameters, temporary tables, update, deletes, inserts, selects and =
sometimes=20
cursors. ie. basic proc stuff.
 
The =
procs work fine=20
when run by a single user, however we have noticed that when hit by =
concurrent=20
sessions they go wierd. In these instances the procs seem to =
"terminate".=20
They return no result set, but even more than that, they cease at =
different=20
apparently random points within through the proc. If the page is =
refreshed,=20
no problem. When we have mutliple users just hitting SQLServer (not =
running the=20
proc through CF), no problem. When we run normal queries as opposed to =
procs=20
through CF, no problem. But for some reason multiple hits on a proc from =
CF=20
gives this problem. Could it be threading via ODBC that's causing the =
problem?=20
It doesn't even give an error, but rather says there are no rows in the =
result=20
set, which is patently not true. We've proven that even when this =
happens, the=20
proc is getting run, and the parameters are being processed properly, so =
the=20
best we can come up with is that a thread in the stored proc is getting=20
terminated when another thread hits it. All CF sessions are locked (both =
write=20
and read) and we have discovered that sessions are not being lost and =
are being=20
handled correctly. Seems impossible to me, but I'm no expert on the back =
end=20
stuff.
 

I know =
you guys like=20
to see code, but there doesn't seem to be much point. The code works =
just fine,=20
and it's long and won't tell you anything that I haven't already. I'm =
just=20
interested to know if anyone has heard of such a thing? Why would a =
proc be=20
run but not get to the end, but equally not trigger an error? And how =
can we fix=20
it? We are stumped with a capital 'st'
 
TIA
 
Garry

--=_NextPart_000_0048_01C0321D.AA1FE030--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFMAIL question.

[Gavin Lilley]

I think that the fact that the html is treated as an attachment or not is
more down to the mail client. Outlook 97 and similar will display the
message as blank with an attachment. Newer clients, eg. Outlook 2000 are
smart enough to display the message as html.

Why would you not want the message displayed anyway?

--
Gavin Lilley
Internet / Intranet Developer
Halesowen College
Tel: 0121 550 1451 Ext: 330

-Original Message-
From: John Foulds [mailto:[EMAIL PROTECTED]]
Sent: 09 October 2000 07:46
To: CF-Talk
Subject: Re: CFMAIL question.


Sorry, read to fast... "must have an attachment."  Okay, rename the file
from ".HTM" to something like ".MYFILE" before you CFMAIL it.  The user's
email client will not recognize the format and it will be attached.

John


- Original Message -
From: "John Foulds" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 2:39 AM
Subject: Re: CFMAIL question.


> Put the file on the web somewhere, and just put a link to the file in the
> email.
>
>
> - Original Message -
> From: "Warrick, Mark" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, October 09, 2000 2:36 AM
> Subject: RE: CFMAIL question.
>
>
> Hmmm... well let's see.  If you don't want to attach a file and you don't
> want the HTML-based message embedded into the body of the message, then
how
> else could you possibly send something to someone?  I'm confused.
>
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
>
>
> > -Original Message-
> > From: Bill Davidson [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, October 08, 2000 2:33 PM
> > To: CF-Talk
> > Subject: CFMAIL question.
> >
> >
> > I have an application in which I would need to send an HTML attachment
> > rather than putting the HTML in the body of the message.
> >
> > Anyone have any ideas on a simple solution for this?  The HTML is
> > dynamically generated, and I would really rather not write a file and
then
> > attach it.  Using CFMAIL with type HTML seems to just stick the
> > HTML in the
> > body, and doesn't handle this too gracefully.  So maybe writing a file
is
> > the only way... (hope not)
> >
> > -Bill
> > /intraget
> >
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or
send
> a message to [EMAIL PROTECTED] with 'unsubscribe' in the
> body.
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Was it something I said?

[Aidan Whitehall]

> I wondered how come my mailbox only had 7 messages in it 
> after 3 days away
> - somehow I got unsubscribed from this list.Was it 
> something I said? 

I got unsubscribed from CF-Talk and CF-Jobs a couple of weeks ago... had to
resubscribe.


-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: IDENTITY FOR SQL SERVER

[DeVoil, Nick]

> Any idea how to find IDENTITY SEED and IDENTITY
> INCREMENT values from system tables in SQL 7.0?

Gena

SELECT TABLE_NAME, IDENT_SEED(TABLE_NAME), IDENT_INCR(TABLE_NAME)
FROM INFORMATION_SCHEMA.TABLES

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Anyone used CF with package called Clients & Profits?

[Craig Newitt]

Could you tell me more about the software

I have just finished a client program for a client
http://203.36.182.208/timeless - that is the demo site - is it similar

Craig

-Original Message-
From: Susan McNab [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:00 PM
To: CF-Talk
Subject: Anyone used CF with package called Clients & Profits?


I am on the verge of getting a nice new job and I want to recommend Cold
Fusion for the company's Intranet. They have a software package called
"Clients and Profits" which is apparently used a lot by advertising
agencies, graphic design studios, multi-media production companies, and so
on. The company says they hate C&P because it is difficult to use. It was
expensive so they don't just want to throw it out. They asked me if I could
do something to ease the use the use of C&P via an Intranet interface. My
first reaction is if it is really that difficult to use, it might be too
expensive or impractical to continue developing on top of it. I have
absolutely no experience with C&P though. Any one out there used it with
Cold Fusion for anything?

I can see from Clients & Profits Web site that they have a Web version, and
a "SQL version" for Oracle 8 and SQL Server 7. Anyone know anything about
these?

Would appreciate hearing from anyone with experience of this software
package (even off-list if it not relevant to CF).

Sue McNab


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Sending page break to Excel in a csv

[Stephen Collins]

Can anybody enlighten me as to how I might do this?  I try sending chr(12),
but it doesn't work.

Steve
 
| Stephen Collins|
| Consultant - Australian Corporate Information Solutions|
|GPO Box 2962 CANBERRA ACT 2601 Australia|
| Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722|
|  [EMAIL PROTECTED] [EMAIL PROTECTED]  |
| http://www.acis.com.au |
|~~~oOo~~|
|   Before I got into triathlon, I was a normal person.  |
||


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

ACT ColdFusion User Group Meeting - October 2000

[Stephen Collins]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

First, apologies for the short notice.  Due to the problems we've had
with our previous venue, we have sought out a couple of other venues
which we will probably rotate through.

A N N O U N C E M E N T

 ACT ColdFusion User Group Meeting

 This Month - A look at the ACT IT Job Market

 When:   5:30-6:45PM, Thursday 12 October 2000
 Where:  Frontier Recruitment
   Level 1, QBE Building
   33 Ainslie Avenue
   CANBERRA
   ACT 2601

 Agenda:
 * Welcome
 * This month's topic:
IT work in the ACT - Private, public, contract, permanent?  What
skills?  Who's hiring? 
- Ralph Douglas, Frontier Recruitment Pty Ltd
 * Open Q&A

 Light refreshments will be provided.

 NOTE: Date and start time!
 RSVP: Stephen Collins ([EMAIL PROTECTED]) by replying to this
message.

 Please circulate this message to your friends and workmates in the
developer community.

 Stephen Collins

 
| Stephen Collins|
| Consultant - Australian Corporate Information Solutions|
|GPO Box 2962 CANBERRA ACT 2601 Australia|
| Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722|
|  [EMAIL PROTECTED] [EMAIL PROTECTED]  |
| http://www.acis.com.au |
|~~~oOo~~|
|   Before I got into triathlon, I was a normal person.  |
||
 

-BEGIN PGP SIGNATURE-
Version: PGP Personal Privacy 6.5.3

iQA/AwUBOeBpMtBcRJfAaSYUEQJblgCfbqt+dQXZirniJ3RwQp980Qknb4YAnR1h
iAu7Gn1htqcx2V8xY4/lQ7aV
=6j/4
-END PGP SIGNATURE-

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

catching 3 filenames when using cffile

[Nagesh Kumar Deva]

hi all,

can anybody help me out. I've got 3 input type="file" tags on my form. so
user can upload 3 files at a time.
i manage to store the files in the particular directory and the related
filenames in the database.If one input type="file" is there then no problem
ie just use the File.Clientfile to catch the filename given the user but
i've got three file inputs on my form. i'm getting the same filename when i
outputted the 3 filenames selected by the user rather they three are
different.

I tried with using arrayappend in the action form. i mean after one cffile
tag one arrayappend the same way i wrote three arrayappends. But doet it
works i mean my approach is correct? to trap the 3 filenames given by
the user?

i read the documentation, in that they clearly mentioned that "If two
cffiles tags execute, the results of the first are overwritten by the
subsequent cffile operation". 

how should i do this??

thanx in advance

regards
nagesh


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Sending page break to Excel in a csv

[JustinMacCarthy]

Have a look here , you might find something

http://www.sector13.org/jason/xls/

Justin
- Original Message -
From: "Stephen Collins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: "CF-Aussie (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 11:15 AM
Subject: Sending page break to Excel in a csv


> Can anybody enlighten me as to how I might do this?  I try sending
chr(12),
> but it doesn't work.
>
> Steve
>  
> | Stephen Collins|
> | Consultant - Australian Corporate Information Solutions|
> |GPO Box 2962 CANBERRA ACT 2601 Australia|
> | Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722|
> |  [EMAIL PROTECTED] [EMAIL PROTECTED]  |
> | http://www.acis.com.au |
> |~~~oOo~~|
> |   Before I got into triathlon, I was a normal person.  |
> ||
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: catching 3 filenames when using cffile

[Kiran Samudrala]

Buddy,
try writing three different actionpages wif 3 different file names to be
uploaded onto the server.

-Original Message-
From: Nagesh Kumar Deva [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:19 AM
To: CF-Talk
Subject: catching 3 filenames when using cffile


hi all,

can anybody help me out. I've got 3 input type="file" tags on my form. so
user can upload 3 files at a time.
i manage to store the files in the particular directory and the related
filenames in the database.If one input type="file" is there then no problem
ie just use the File.Clientfile to catch the filename given the user but
i've got three file inputs on my form. i'm getting the same filename when i
outputted the 3 filenames selected by the user rather they three are
different.

I tried with using arrayappend in the action form. i mean after one cffile
tag one arrayappend the same way i wrote three arrayappends. But doet it
works i mean my approach is correct? to trap the 3 filenames given by
the user?

i read the documentation, in that they clearly mentioned that "If two
cffiles tags execute, the results of the first are overwritten by the
subsequent cffile operation". 

how should i do this??

thanx in advance

regards
nagesh



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

How do you manage massive CF apps?

[Larry W. Virden]

I recently ran across a developer who had written a suite of CF apps that
were inter-related - literally dozens and dozens of CF pages.  He was
preparing to turn this app over to someone else as he was about to leave
the company.

His method for 'documenting' the app was to print off all the pages, insert
into a 3 ring with tab seperators each one of which summaried each of the
10-15 areas of functionality.

I started wondering what tools people used for documenting and searching
suites like this.  In C++ and Java there are class browsers which are
frequently useful in learning about a system.  In C I have used tools like
cscope, which allows me to generate a giant cross reference listing of all
the variables and where they are used, making it very easy to look at
where side effects may be occuring, etc.  And of course there is lint,
which allows me to feed in a number of related C modules and find out
whether all the interfaces match, etc.

Are there similar tools available for ColdFusion?  Tools that go beyond
Studio to provide additional checking, cross referencing, discovery, etc.?
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden  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.
-><-
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Server Decimal

[Paul Johnston]

Erm, I set it up with a precision of 9 and a scale of 18 (or at least that's
what I thought I'd set up in EM).

Paul

> -Original Message-
> From: Peter Stolz [mailto:[EMAIL PROTECTED]]
> Sent: 07 October 2000 07:33
> To: CF-Talk
> Subject: RE: SQL Server Decimal
>
>
> The digits to the right of the decimal point were truncated because
> SQL Server stores decimal numbers with precision(max total number
> of digits)
> and scale(max digits to the right of the decimal point).
> The default scale is 0, that is no digits to the right of the
> decimal point.
> You can change this in EM.
>
> Also, the use of float data types is not recommended when storing prices,
> money amounts etc. as the representation is approximate : not all numbers
> can be precisely represented.
> Decimal is the data type you need.
>
> P.
>
>
> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 06, 2000 9:08 AM
> To: CF-Talk
> Subject: RE: SQL Server Decimal
>
>
> Actually, I change the field to a float and it's fine!
>
> Sorry to bother everyone with that one, although I do think that
> a data type
> of "decimal" should be able to hold a "decimal" number! Whoever decided it
> shouldn't, was a stupid person.
>
> Paul
>
> > -Original Message-
> > From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> > Sent: 06 October 2000 13:55
> > To: CF-Talk
> > Subject: RE: SQL Server Decimal
> >
> >
> > Paul
> >
> > Take a step back mate..what is getting put into the SQL
> table?  If
> > the wrong data is getting put in there run the same query
> through ISQL and
> > see what happens
> >
> > --
> > Andrew Ewings
> > Project Manager
> > Thoughtbubble Ltd
> > --
> >
> >
> > -Original Message-
> > From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> > Sent: 06 October 2000 13:44
> > To: CF-Talk
> > Subject: RE: SQL Server Decimal
> >
> >
> > By means of an example, here is some test output:
> >
> > --
> > TESTING
> >
> > Source Data
> >
> > Case Price: 133.8
> > Bottle Price: 11.15
> >
> > Web Data
> >
> > Case Price: 133
> > Bottle Price: 11
> > --
> >
> > Erm, I can't figure out why it does this.
> >
> > Here is the query to get the data in:
> >
> > 
> > INSERT INTO hr_wine
> > (
> >  ...
> >
> >  ...
> > ,   CasePrice
> > ,   BottlePrice
> > )
> > VALUES
> > (
> >  ...
> >
> >  ...
> > ,> value="#REReplace(DecimalFormat(caseprice),",","","all")#"
> > cfsqltype="CF_SQL_DECIMAL">
> > ,> value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#"
> > cfsqltype="CF_SQL_DECIMAL">
> > )
> >
> > Can't figure this one out.
> >
> > Paul
> >
> > > -Original Message-
> > > From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> > > Sent: 06 October 2000 13:25
> > > To: CF-Talk
> > > Subject: RE: SQL Server Decimal
> > >
> > >
> > > Paul
> > >
> > > You don't need the quotes around it...
> > >
> > > INSERT INTO  (, )
> > > VALUES (#decimal1#, #decimal2#)
> > >
> > > I'm not sure this is the problem that you were getting the other
> > > day but if
> > > this doesn't work let us know the error message you get.
> > >
> > > --
> > > Andrew Ewings
> > > Project Manager
> > > Thoughtbubble Ltd
> > > --
> > >
> > >
> > > -Original Message-
> > > From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> > > Sent: 06 October 2000 13:22
> > > To: CF-Talk
> > > Subject: SQL Server Decimal
> > >
> > >
> > > I am having problems putting a decimal into a SQL Server field.
> > >
> > > The data type is decimal and I am passing the value in with
> > > DecimalFormat(#var#) with the commas taken out (so that it is
> > > just xx.xx
> > > and no more).
> > >
> > > Exactly what SQL do I need to add in?
> > >
> > > INSERT INTO...
> > >
> > > ...
> > > VALUES
> > > (
> > >   #decimal1#
> > > , #decimal2#
> > > )
> > >
> > > or
> > >
> > > INSERT INTO...
> > >
> > > ...
> > > VALUES
> > > (
> > >   '#decimal1#'
> > > , '#decimal2#'
> > > )
> > >
> > > or what?
> > >
> > > Paul
> > >
> > >
> > > --
> > > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> > send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> > the body.
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> -

Cookie Detector

[W Luke]

My new site uses Cookies lots, but I guess I need to detect whether a user
has Cookies enabled on the browser or not, and redirect them accordingly.

What do you all use for that - Javascript?

Thanks

Will

--
Coming soon: http://www.LocalBounty.com
Local Classified Advertising for the UK

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cookie Detector

[Reynolds, Adam]

Attempt to set a cookie value and then determine if it isdefined

> --
> From: W Luke[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 12:35
> To:   CF-Talk
> Subject:  Cookie Detector
> 
> My new site uses Cookies lots, but I guess I need to detect whether a user
> has Cookies enabled on the browser or not, and redirect them accordingly.
> 
> What do you all use for that - Javascript?
> 
> Thanks
> 
> Will
> 
> --
> Coming soon: http://www.LocalBounty.com
> Local Classified Advertising for the UK
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Cookie Detector

[W Luke]

Well I currently do that when users are meant to log in for the member
areas.  If it's false, then they must login.  But isdefined alone can't
determine whether they have cookies enabled or not.  Afaik?

Will

- Original Message -
From: "Reynolds, Adam" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Monday, October 09, 2000 12:32 PM
Subject: RE: Cookie Detector


> Attempt to set a cookie value and then determine if it isdefined
>
> > --
> > From: W Luke[SMTP:[EMAIL PROTECTED]]
> > Sent: 09 October 2000 12:35
> > To: CF-Talk
> > Subject: Cookie Detector
> >
> > My new site uses Cookies lots, but I guess I need to detect whether a
user
> > has Cookies enabled on the browser or not, and redirect them
accordingly.
> >
> > What do you all use for that - Javascript?
> >
> > Thanks
> >
> > Will
> >
> > --
> > Coming soon: http://www.LocalBounty.com
> > Local Classified Advertising for the UK
> >
>
> --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> >
> **
>  This email and any attachments are confidential and solely
>  for the use of the intended recipient.  They may contain
>  material protected by legal professional or other privilege.
>  If you are not the intended recipient or the person responsible
>  for delivering to the intended recipient, you are not authorised
>  to and must not disclose, copy, distribute or retain this email
>  or its attachments.  Although this email and its attachments
>  are believed to be free of any virus or other defect, it is the
>  responsibility of the recipient to ensure that they are virus free
>  and no responsibility is accepted by the company for any
>  loss or damage arising from receipt or use thereof.
>
> **
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cookie Detector

[Reynolds, Adam]

I think it does...just set a test variable cookie...not your login cookie.
If it sets, then bingo.


> --
> From: W Luke[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 12:42
> To:   CF-Talk
> Subject:  Re: Cookie Detector
> 
> Well I currently do that when users are meant to log in for the member
> areas.  If it's false, then they must login.  But isdefined alone can't
> determine whether they have cookies enabled or not.  Afaik?
> 
> Will
> 
> - Original Message -
> From: "Reynolds, Adam" <[EMAIL PROTECTED]>
> Newsgroups: cf-talk
> Sent: Monday, October 09, 2000 12:32 PM
> Subject: RE: Cookie Detector
> 
> 
> > Attempt to set a cookie value and then determine if it isdefined
> >
> > > --
> > > From: W Luke[SMTP:[EMAIL PROTECTED]]
> > > Sent: 09 October 2000 12:35
> > > To: CF-Talk
> > > Subject: Cookie Detector
> > >
> > > My new site uses Cookies lots, but I guess I need to detect whether a
> user
> > > has Cookies enabled on the browser or not, and redirect them
> accordingly.
> > >
> > > What do you all use for that - Javascript?
> > >
> > > Thanks
> > >
> > > Will
> > >
> > > --
> > > Coming soon: http://www.LocalBounty.com
> > > Local Classified Advertising for the UK
> > >
> >
> >
> --
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> > >
> > **
> >  This email and any attachments are confidential and solely
> >  for the use of the intended recipient.  They may contain
> >  material protected by legal professional or other privilege.
> >  If you are not the intended recipient or the person responsible
> >  for delivering to the intended recipient, you are not authorised
> >  to and must not disclose, copy, distribute or retain this email
> >  or its attachments.  Although this email and its attachments
> >  are believed to be free of any virus or other defect, it is the
> >  responsibility of the recipient to ensure that they are virus free
> >  and no responsibility is accepted by the company for any
> >  loss or damage arising from receipt or use thereof.
> >
> > **
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Craziest damn thing with @@identity.

[G]

Make sure that your @@identity query is immediately following your
insert, otherwise, you can get some pretty strange results.

HTH

Brian

- Original Message -
From: Neil H. <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, October 07, 2000 12:29 AM
Subject: Craziest damn thing with @@identity.


> I only have one identity column (that I Know of and I am pretty sure I
know)
> in this table.  Yet when I query our @@Identity I get a weird number.
I
> Don't know where it comes from and I verified the dbcc checkident and
it
> gives me the number I was looking for?  Any ideas.
>
> Thanks,
>
> Neil
>
> ---
---
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

verity error!

[avex]

Hi gang!

I am getting a little spooked with verity.
For 2 different sites I have gotten 3 of the same verity errors:

Error Occurred While Processing Request

  Error Diagnostic Information

  Error occurred in tag CFSEARCH

  Collection failed to open: super

It has occured at different times, but in any case verity seems to routinely
fuckup and turns the collection to hell.  Once destroyed I can't repair, or
even delete!

Has this happened to anyone else?

How can I stop this from happening?

Is verity reliable?

Will I ask more questions?

anyhoo..I fixed it by creating new collection with new name.  Luckily
the collection name is a variable referenced from the application.cfm.  I
can repair it really fast, but when it happens I get error all over the
administrator (that updates the collection) and the search pages

breaks my heart.

thanks
chad


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: seedy random numbers

[David E. Crawford]

This is a multi-part message in MIME format.

--=_NextPart_000_0184_01C031EF.A36A4790
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

seedy random numbers
Try





#y#

The result of the randomize() function is not random as stated in the
Language Reference.  I generally use a timestamp as the seed value.

DC

  -Original Message-
  From: Gavin Myers [mailto:[EMAIL PROTECTED]]
  Sent: Friday, October 06, 2000 21:35
  To: CF-Talk
  Subject: seedy random numbers


  okay, i've looked into randomize()
  and from b.f.'s book it states:



  Randomize(Number) seed the random number generator with the passed number

  so if I do this:

  
  #Randomize(1)#
  
  #x#
  

  I get:

  0.31415822
  41



  If I put #randomize(2)# instead of 1 i get:

  0.62831643
  50



  with that being said, i could randomze off the timer... but as far as i
can
  see the timer runs only in seconds... wich would be bad.

  So this boils down to:

  Question 1 Is it important to seed the randomizer before using random
  commands? Or does cf automatically do this. The odd part is if it does do
  this automatically then why would we need a seed in the first place?

  Question 2 If it doesnt how can i seed the random number generator? If cf
  doesnt auto-seed the random number generator then I cant do this:

  
  #x#
  

  #randomize(x)#

  because the randrange wouldn't be seedy and random. Wich brings me over to
  question 3

  How can i use randomize(x) in a fasion that would make it not show up?
  Because in order to use it in the way stated above i have to turn it into
a
  variable...

  do i do this:

  #randomize(124, randrange(x))#

  or would it be more like

  #randomize(124, x)#



  i don't understand why we still have to seed the randomizer... I know a
  computer cannot technically whip out random numbers, but the moment you
ask
  like :dd:mm:hh:mm:
  should get a pretty random number... unles again if you have a site that
  gets tons of hits per day, there could be a chance of 2 people calling the
  same thing the same second (or even mili-second) and that may depend on
how
  cold fusion server side works.

  feh

  gavin
  --

  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--=_NextPart_000_0184_01C031EF.A36A4790
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


seedy random numbers



 
Try
 

 

 
#y#
 
The=20
result of the randomize() function is not random as stated in the =
Language=20
Reference.  I generally use a timestamp as the seed=20
value. 
 
DC
 

  -Original Message-From: Gavin Myers=20
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October =
06, 2000=20
  21:35To: CF-TalkSubject: seedy random=20
  numbers
  okay, i've looked into randomize() and=20
  from b.f.'s book it states: 
  Randomize(Number) seed the random number generator =
with the=20
  passed number 
  so if I do this: 
   #Randomize(1)#
  #x#  
  I get: 
  0.31415822 41 =

  If I put #randomize(2)# instead of 1 i get: =

  0.62831643 50 =

  with that being said, i could randomze off the =
timer... but as=20
  far as i can see the timer runs only in =
seconds...=20
  wich would be bad. 
  So this boils down to: 
  Question 1 Is it important to seed the randomizer =
before using=20
  random commands? Or does cf automatically do =
this. The=20
  odd part is if it does do this automatically =
then why=20
  would we need a seed in the first place? 
  Question 2 If it doesnt how can i seed the random =
number=20
  generator? If cf doesnt auto-seed the random =
number=20
  generator then I cant do this: 
   =
#x#  
  #randomize(x)# 
  because the randrange wouldn't be seedy and random. =
Wich=20
  brings me over to question 3 
  How can i use randomize(x) in a fasion that would =
make it not=20
  show up? Because in order to use it in the =
way stated=20
  above i have to turn it into a variable... 
  do i do this: 
  #randomize(124, randrange(x))# 
  or would it be more like 
  #randomize(124, x)# 
  i don't understand why we still have to seed the =
randomizer...=20
  I know a computer cannot technically whip =
out random=20
  numbers, but the moment you ask like=20
  :dd:mm:hh:mm: =
should get a pretty random number... unles again if you have =
a site=20
  that gets tons of hits per day, there could =
be a=20
  chance of 2 people calling the same thing =
the same=20
  second (or even mili-second) and that may 

RE: catching 3 filenames when using cffile

[Nagesh Kumar Deva]

hello kiran,

i think you must have not understand the problem. Here the thing is, i've
got 3 butttons on the same page along with there is one more button called
submit. Once the user selected the 3 files then he submits the page. so
Obviously, there will be only one action page not more than that. In that
only one action page i need to catch the 3 filenames given by the user.

According to the documentation we can have only one filename if it exceeds
then the first one will be overwritten by the second file name.

i hope you must have understand the problem.

thanx



-Original Message-
From: Kiran Samudrala [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 6:32 PM
To: CF-Talk
Subject: RE: catching 3 filenames when using cffile


Buddy,
try writing three different actionpages wif 3 different file names to be
uploaded onto the server.

-Original Message-
From: Nagesh Kumar Deva [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:19 AM
To: CF-Talk
Subject: catching 3 filenames when using cffile


hi all,

can anybody help me out. I've got 3 input type="file" tags on my form. so
user can upload 3 files at a time.
i manage to store the files in the particular directory and the related
filenames in the database.If one input type="file" is there then no problem
ie just use the File.Clientfile to catch the filename given the user but
i've got three file inputs on my form. i'm getting the same filename when i
outputted the 3 filenames selected by the user rather they three are
different.

I tried with using arrayappend in the action form. i mean after one cffile
tag one arrayappend the same way i wrote three arrayappends. But doet it
works i mean my approach is correct? to trap the 3 filenames given by
the user?

i read the documentation, in that they clearly mentioned that "If two
cffiles tags execute, the results of the first are overwritten by the
subsequent cffile operation". 

how should i do this??

thanx in advance

regards
nagesh



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ColdFusion SP2 was Commenting on multiple lines

[Aidan Whitehall]

Oh yeah, here's another one!

If you're writing some code that throws an error and can't figure out what's
wrong, if you put comments around the code to get ColdFusion to skip it, it
still throws the error. I guess the code's being evaluated, even though it's
inside comments.

Is it possible for ColdFusion code inside comments to be overlooked?

Sometimes you just want to comment out sections at a time so you can work
through it and see which bit of code is causing the problem.


-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ColdFusion SP2 was Commenting on multiple lines

[Andy Ewings]

Are you commenting like this: 

automatic page copying

[Peter Benoit]

I thought I would ask if this is possible before actually attempting it, but
once a day(or week) I'd like to schedual a file copy from my mirror server
to the actual content server.  A sort for anything new, and copy it over
type of application.  Possible?  Has anyone done this type of thing before?

-Pete

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Check out CF_Challenge!

[Paul Ihrig]

Scott, Great Idea!

looks like this site will be popular!
best of luck.
-paul

> -Original Message-
> From: Neil H. [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, October 07, 2000 1:36 AM
> To:   CF-Talk
> Subject:  Re: Check out CF_Challenge!
> 
> Very Cool Idea.  I like that :)
> 
> Neil
> 
> - Original Message -
> From: "Scott Knaub" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, October 07, 2000 1:25 AM
> Subject: Check out CF_Challenge!
> 
> 
> > There is a new Web site that is dedicated to helping the newcomers to
> ColdFusion. Inspired by everyone who has ever asked me to help them learn
> ColdFusion, I have set up a Web site to help those who want to learn and
> get
> some experience.
> >
> > Here's the place to hone your CF skills:
> http://www.cfm-resources.com/members/CF_Challenge/
> >
> > CF_Challenge will present scenarios that need a CF solution. You write
> your CF template(s), test your solution and submit it for review and
> critique by experienced ColdFusion developers.
> >
> > You learn in three ways:
> > 1. By writing your CF code to solve the challenge
> > 2. By seeing how other developers have solved the challenge
> > 3. By reviewing comments from other ColdFusion developers
> >
> > I hope you like it...Enjoy!
> > Scott
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: catching 3 filenames when using cffile

[David E. Crawford]

This is a multi-part message in MIME format.

--=_NextPart_000_0194_01C031F2.15EE9DA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

catching 3 filenames when using cffile

You have to save off the file name into a variable after each CFFILE
operation if you want to know the name of each of the 3 files, otherwise you
will only have the last file saved by CFFILE present in the FILE.ClientFile
variable.

DC

  -Original Message-
  From: Nagesh Kumar Deva [mailto:[EMAIL PROTECTED]]
  Sent: Monday, October 09, 2000 10:19
  To: CF-Talk
  Subject: catching 3 filenames when using cffile


  hi all,

  can anybody help me out. I've got 3 input type="file" tags on my form. so
  user can upload 3 files at a time.
  i manage to store the files in the particular directory and the related
  filenames in the database.If one input type="file" is there then no
problem
  ie just use the File.Clientfile to catch the filename given the user but
  i've got three file inputs on my form. i'm getting the same filename when
i
  outputted the 3 filenames selected by the user rather they three are
  different.

  I tried with using arrayappend in the action form. i mean after one cffile
  tag one arrayappend the same way i wrote three arrayappends. But doet it
  works i mean my approach is correct? to trap the 3 filenames given by
  the user?

  i read the documentation, in that they clearly mentioned that "If two
  cffiles tags execute, the results of the first are overwritten by the
  subsequent cffile operation".

  how should i do this??

  thanx in advance

  regards
  nagesh



  --

  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--=_NextPart_000_0194_01C031F2.15EE9DA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


catching 3 filenames when using cffile



 
 
You=20
have to save off the file name into a variable after each CFFILE =
operation if=20
you want to know the name of each of the 3 files, otherwise you will =
only have=20
the last file saved by CFFILE present in the FILE.ClientFile=20
variable.
 
DC
 

  -Original Message-From: Nagesh Kumar Deva=20
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 09, =
2000=20
  10:19To: CF-TalkSubject: catching 3 filenames =
when using=20
  cffile
  hi all, 
  can anybody help me out. I've got 3 input =
type=3D"file" tags on=20
  my form. so user can upload 3 files at a =
time.=20
  i manage to store the files in the particular =
directory and=20
  the related filenames in the database.If one =
input=20
  type=3D"file" is there then no problem ie =
just use the=20
  File.Clientfile to catch the filename given the user but =
i've got three file inputs on my form. i'm getting the same =
filename=20
  when i outputted the 3 filenames selected by =
the user=20
  rather they three are different. 
  I tried with using arrayappend in the action form. i =
mean=20
  after one cffile tag one arrayappend the =
same way i=20
  wrote three arrayappends. But doet it works i mean=20
  my approach is correct? to trap the 3 filenames given by =
the user? 
  i read the documentation, in that they clearly =
mentioned that=20
  "If two cffiles tags execute, the results of =
the first=20
  are overwritten by the subsequent cffile =
operation".=20
  
  how should i do this?? 
  thanx in advance 
  regards nagesh =

  =
--=20
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
  =
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
  To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
  =
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk=20
  or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
  the body.

--=_NextPart_000_0194_01C031F2.15EE9DA0--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ColdFusion SP2 was Commenting on multiple lines

[Reynolds, Adam]

That is cfcommented out. If you use  From: Andy Ewings[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 13:57
> To:   CF-Talk
> Subject:  RE: ColdFusion SP2 was Commenting on multiple lines
> 
> Are you commenting like this:  Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> --
> 
> 
> -Original Message-
> From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> Sent: 09 October 2000 14:02
> To: CF-Talk
> Subject: RE: ColdFusion SP2 was Commenting on multiple lines
> 
> 
> Oh yeah, here's another one!
> 
> If you're writing some code that throws an error and can't figure out
> what's
> wrong, if you put comments around the code to get ColdFusion to skip it,
> it
> still throws the error. I guess the code's being evaluated, even though
> it's
> inside comments.
> 
> Is it possible for ColdFusion code inside comments to be overlooked?
> 
> Sometimes you just want to comment out sections at a time so you can work
> through it and see which bit of code is causing the problem.
> 
> 
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
> 
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ColdFusion SP2 was Commenting on multiple lines

[Andy Ewings]

yup
 From: Andy Ewings[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 13:57
> To:   CF-Talk
> Subject:  RE: ColdFusion SP2 was Commenting on multiple lines
> 
> Are you commenting like this:  Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> --
> 
> 
> -Original Message-
> From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> Sent: 09 October 2000 14:02
> To: CF-Talk
> Subject: RE: ColdFusion SP2 was Commenting on multiple lines
> 
> 
> Oh yeah, here's another one!
> 
> If you're writing some code that throws an error and can't figure out
> what's
> wrong, if you put comments around the code to get ColdFusion to skip it,
> it
> still throws the error. I guess the code's being evaluated, even though
> it's
> inside comments.
> 
> Is it possible for ColdFusion code inside comments to be overlooked?
> 
> Sometimes you just want to comment out sections at a time so you can work
> through it and see which bit of code is causing the problem.
> 
> 
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
> 
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Which Platform is most scabable for CF 4.5?

[Tracy Bost]

This is a multi-part message in MIME format.

--=_NextPart_000_002A_01C031C9.E9ED6290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys,
  Of Solaris,Linux or NT, which OS is considered to be the most scalable =
for a ColdFusion 4.5  driven e-commerce portal? Is there one to avoid  =
more than the other(s) ?
 =20
  Thanks,
   Tracy Bost

--=_NextPart_000_002A_01C031C9.E9ED6290
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi guys,
  Of Solaris,Linux or NT, which OS =
is=20
considered to be the most scalable for a ColdFusion 4.5  driven =
e-commerce=20
portal? Is there one to avoid  more than the other(s) =
?
  
  Thanks,
   =
Tracy=20
Bost

--=_NextPart_000_002A_01C031C9.E9ED6290--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ColdFusion SP2 was Commenting on multiple lines

[Aidan Whitehall]

> That is cfcommented out. If you use 

RE: Which Platform is most scabable for CF 4.5?

[Nagesh Kumar Deva]

NT is considerably faster than LINUX.

-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:21 PM
To: CF-Talk
Subject: Which Platform is most scabable for CF 4.5?


This is a multi-part message in MIME format.

--=_NextPart_000_002A_01C031C9.E9ED6290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys,
  Of Solaris,Linux or NT, which OS is considered to be the most scalable =
for a ColdFusion 4.5  driven e-commerce portal? Is there one to avoid  =
more than the other(s) ?
 =20
  Thanks,
   Tracy Bost

--=_NextPart_000_002A_01C031C9.E9ED6290
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi guys,
  Of Solaris,Linux or NT, which OS =
is=20
considered to be the most scalable for a ColdFusion 4.5  driven =
e-commerce=20
portal? Is there one to avoid  more than the other(s) =
?
  
  Thanks,
   =
Tracy=20
Bost

--=_NextPart_000_002A_01C031C9.E9ED6290--


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cold Fusion SP2 was Commenting on multiple lines

[Larry Juncker]

Another thing -

If you comment out your code using cfcomment  From: Andy Ewings[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 13:57
> To:   CF-Talk
> Subject:  RE: ColdFusion SP2 was Commenting on multiple lines
>
> Are you commenting like this:  Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> --
>
>
> -Original Message-
> From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> Sent: 09 October 2000 14:02
> To: CF-Talk
> Subject: RE: ColdFusion SP2 was Commenting on multiple lines
>
>
> Oh yeah, here's another one!
>
> If you're writing some code that throws an error and can't figure out
> what's
> wrong, if you put comments around the code to get ColdFusion to skip it,
> it
> still throws the error. I guess the code's being evaluated, even though
> it's
> inside comments.
>
> Is it possible for ColdFusion code inside comments to be overlooked?
>
> Sometimes you just want to comment out sections at a time so you can work
> through it and see which bit of code is causing the problem.
>
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
>
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Ryan]

At 21:32 10/9/00 +0800, you wrote:
>NT is considerably faster than LINUX.

This statement is based on what?

And, you really meant (based on the original question)
*Cold Fusion* is faster on NT than Linux, right?

RPS

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: automatic page copying

[Rif Kiamil]

You can use ColdFusion to Tell MS SQL server to run a xp_cmdshell with a
xcopy command

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 09 October 2000 13:59
To: CF-Talk
Subject: automatic page copying



I thought I would ask if this is possible before actually attempting it, but
once a day(or week) I'd like to schedual a file copy from my mirror server
to the actual content server.  A sort for anything new, and copy it over
type of application.  Possible?  Has anyone done this type of thing before?

-Pete


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Cookie Detector

[paul smith]

Sure it can.  It just can't do it on the same page
that attempts to set the cookie.

best,  paul

At 12:42 PM 10/9/00 +0100, you wrote:
>But isdefined alone can't
>determine whether they have cookies enabled or not.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Reynolds, Adam]

Is this true? 

> --
> From: Ryan[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 14:43
> To:   CF-Talk
> Subject:  RE: Which Platform is most scabable for CF 4.5?
> 
> At 21:32 10/9/00 +0800, you wrote:
> >NT is considerably faster than LINUX.
> 
> This statement is based on what?
> 
> And, you really meant (based on the original question)
> *Cold Fusion* is faster on NT than Linux, right?
> 
> RPS
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cold Fusion SP2 was Commenting on multiple lines

[Ryan]

At 08:43 10/9/00 -0500, you wrote:
>Another thing -
>
>If you comment out your code using cfcomment 

Re: Which Platform is most scabable for CF 4.5?

[Tracy Bost]

My question is based on which OS runs better with  CF 4.5. I'm comfortable
with Linux's performance in general, but I'm concerned with how stable CF
4.5 is under the different Operating Systems.
- Original Message -
From: "Ryan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 8:43 AM
Subject: RE: Which Platform is most scabable for CF 4.5?


> At 21:32 10/9/00 +0800, you wrote:
> >NT is considerably faster than LINUX.
>
> This statement is based on what?
>
> And, you really meant (based on the original question)
> *Cold Fusion* is faster on NT than Linux, right?
>
> RPS
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Simon Horwith]

I've no personal experience with CF on Linux, but have been old it runs
quite well, especially in a cluster.  Again, this is only what I've been
told.
~Simon

-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:53 AM
To: CF-Talk
Subject: Re: Which Platform is most scabable for CF 4.5?


My question is based on which OS runs better with  CF 4.5. I'm comfortable
with Linux's performance in general, but I'm concerned with how stable CF
4.5 is under the different Operating Systems.
- Original Message -
From: "Ryan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 8:43 AM
Subject: RE: Which Platform is most scabable for CF 4.5?


> At 21:32 10/9/00 +0800, you wrote:
> >NT is considerably faster than LINUX.
>
> This statement is based on what?
>
> And, you really meant (based on the original question)
> *Cold Fusion* is faster on NT than Linux, right?
>
> RPS
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: automatic page copying

[Rich Wild]

> You can use ColdFusion to Tell MS SQL server to run a 
> xp_cmdshell with a
> xcopy command

I would really really lock this extended proc down if I were you.

Its a hackers dream to have that running on a SQL server.

If you really really need to use it, make sure you lock down the permissions
to the SQL server. (ie give the 'sa' login a strong password).

There are hackers out there that solely look for this crack. 

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 2:30 PM
> To: CF-Talk
> Subject: RE: automatic page copying
> 
> 
> You can use ColdFusion to Tell MS SQL server to run a 
> xp_cmdshell with a
> xcopy command
> 
> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: 09 October 2000 13:59
> To: CF-Talk
> Subject: automatic page copying
> 
> 
> 
> I thought I would ask if this is possible before actually 
> attempting it, but
> once a day(or week) I'd like to schedual a file copy from my 
> mirror server
> to the actual content server.  A sort for anything new, and 
> copy it over
> type of application.  Possible?  Has anyone done this type of 
> thing before?
> 
> -Pete
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: automatic page copying

[DeVoil, Nick]

I would have thought CFSCHEDULE, CFDIRECTORY and CFFTP were
the tools for the job.

Or you can do it in Perl if you're feeling masochistic.

Nick

-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 2:30 PM
To: CF-Talk
Subject: RE: automatic page copying


You can use ColdFusion to Tell MS SQL server to run a xp_cmdshell with a
xcopy command

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 09 October 2000 13:59
To: CF-Talk
Subject: automatic page copying



I thought I would ask if this is possible before actually attempting it, but
once a day(or week) I'd like to schedual a file copy from my mirror server
to the actual content server.  A sort for anything new, and copy it over
type of application.  Possible?  Has anyone done this type of thing before?

-Pete


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Displaying CF code

[John Allred]

I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Anyone used CF with package called Clients & Profits?

[Cameron Childress]

C&P is bad news. I would not use any of that company's products if you can
help it.  I have had to work with it as an IT Manager at an Ad Agency and it
was horrible.  It is very expensive, and they tend to lock you into the
product with very few exit paths back out.  It's buggy as hell, and they are
always tinkering with adding un-needed functionality while neglecting basic
core functions.  I cannot count the number of times all client billings and
invoicing came to a halt because of some problem with C&P.

I never tried to get it to work with CF, thought I did call the company once
to see if they could supply me with a ODBC driver for their DB format.  The
answer at that time was no, but if they now have a "SQL version", then I
guess that may have changed.

I would suggest dumping it entirely.  Take the data you can out of it, and
chuck C&P out the window...  Buy a different solution, build your own
solution, anything!  just stay away from C&P at all costs...

-Cameron


Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: Susan McNab [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 1:00 AM
> To: CF-Talk
> Subject: Anyone used CF with package called Clients & Profits?
>
>
> I am on the verge of getting a nice new job and I want to recommend Cold
> Fusion for the company's Intranet. They have a software package called
> "Clients and Profits" which is apparently used a lot by advertising
> agencies, graphic design studios, multi-media production companies, and so
> on. The company says they hate C&P because it is difficult to use. It was
> expensive so they don't just want to throw it out. They asked me
> if I could
> do something to ease the use the use of C&P via an Intranet interface. My
> first reaction is if it is really that difficult to use, it might be too
> expensive or impractical to continue developing on top of it. I have
> absolutely no experience with C&P though. Any one out there used it with
> Cold Fusion for anything?
>
> I can see from Clients & Profits Web site that they have a Web
> version, and
> a "SQL version" for Oracle 8 and SQL Server 7. Anyone know anything about
> these?
>
> Would appreciate hearing from anyone with experience of this software
> package (even off-list if it not relevant to CF).
>
> Sue McNab
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Between???

[HappyToad.com]

I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Displaying CF code

[Larry Juncker]

Try the following




#HTMLEditFormat(htmlString)#


Larry Juncker
Senior Cold Fusion Programmer
Heartland Communications Group, Inc.


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[DeVoil, Nick]

Rich

Because you're comparing a date field with a set of three strings
instead of with another date.

Either use CreateDate to convert your three values into a CF date
object and CreateODBCDate to convert that into an SQL one, or
use your DBMS' string/date conversion functions to create a valid date.

Nick

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:28 PM
To: CF-Talk
Subject: Between???


I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich



**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[Bob Silverberg]

The problem is that the format you are using (MM,DD,) is not valid for
the database.  CF might like that syntax to describe a date, but the SQL
engine won't recognize it.  Check out the CreateODBCDate() function - use it
to convert your date into SQL friendly format.

Bob


-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:28 AM
To: CF-Talk
Subject: Between???


I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: automatic page copying

[Peter Benoit]

How does CFSCHEDULE work?  If the page isn't open, does it still run the
scheduled event?

*  -Original Message-
*  From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
*  Sent: Monday, October 09, 2000 10:05 AM
*  To: CF-Talk
*  Subject: RE: automatic page copying
*  
*  
*  I would have thought CFSCHEDULE, CFDIRECTORY and CFFTP were
*  the tools for the job.
*  
*  Or you can do it in Perl if you're feeling masochistic.
*  
*  Nick
*  
*  -Original Message-
*  From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
*  Sent: Monday, October 09, 2000 2:30 PM
*  To: CF-Talk
*  Subject: RE: automatic page copying
*  
*  
*  You can use ColdFusion to Tell MS SQL server to run a 
*  xp_cmdshell with a
*  xcopy command
*  
*  -Original Message-
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: 09 October 2000 13:59
*  To: CF-Talk
*  Subject: automatic page copying
*  
*  
*  
*  I thought I would ask if this is possible before actually 
*  attempting it, but
*  once a day(or week) I'd like to schedual a file copy from my 
*  mirror server
*  to the actual content server.  A sort for anything new, and 
*  copy it over
*  type of application.  Possible?  Has anyone done this type 
*  of thing before?
*  
*  -Pete
*  
*  -
*  ---
*  --
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  To Unsubscribe visit
*  http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lis
ts/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Nagesh Kumar Deva]

hi,

I tested based on some code by running around 15 times and I found something
interesting ie

1) I executed a big query and grouped the output: 
On NT: 1655.5 milliseconds 
On Linux: 3264.5 milliseconds 
2) Big query using data caching and grouped the output: 
On NT: 415.5 milliseconds 
On Linux: 1401.5 milliseconds

These are my observations and I still remember i tested this one, after i
find some results regarding this in the list given by somebody lasttime.

nagesh

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:43 PM
To: CF-Talk
Subject: RE: Which Platform is most scabable for CF 4.5?


At 21:32 10/9/00 +0800, you wrote:
>NT is considerably faster than LINUX.

This statement is based on what?

And, you really meant (based on the original question)
*Cold Fusion* is faster on NT than Linux, right?

RPS


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[HappyToad.com]

The order_date field in my database is already set to:  Date()
Is this what you mean??

Rich

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:31 AM
To: CF-Talk
Subject: RE: Between???


The problem is that the format you are using (MM,DD,) is not valid for
the database.  CF might like that syntax to describe a date, but the SQL
engine won't recognize it.  Check out the CreateODBCDate() function - use it
to convert your date into SQL friendly format.

Bob


-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:28 AM
To: CF-Talk
Subject: Between???


I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFContent question

[Kathy Bergman]

I'm not using any MIME type that I know of.  Should this be a part of the CFContent 
tag?

>Since the .xls is opening client-side, Excel has to reside on the client (Excel on 
>the server is only applicable when you're creating .xls >files on the fly, using the 
>Excel com object).  What MIME type are you using with CFContent?
>
>-- 
>Billy Cravens
>[EMAIL PROTECTED] 


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: automatic page copying

[DeVoil, Nick]

> How does CFSCHEDULE work?  If the page isn't open, does it still run the
scheduled event?

Yes. It adds an entry to CF's list of scheduled tasks.
Alternatively you can use the CF Administrator to do this.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Gavin Lilley]

Can I assume that both machines were of the same specification?

I am running CF on NT but have the Linux demo ready to install. So far, I
have found that linux is considerably faster than NT for functions such as
news reading, web browsing, word processing, oracle and mysql databases and
apache web serving. In fact I run Linux on a P2 350 and my NT machine is a
P3 450 and Linux is faster!

How come CF is different? Is CF 5.5 for linux an early development?

-Original Message-
From: Nagesh Kumar Deva [mailto:[EMAIL PROTECTED]]
Sent: 09 October 2000 15:44
To: CF-Talk
Subject: RE: Which Platform is most scabable for CF 4.5?


hi,

I tested based on some code by running around 15 times and I found something
interesting ie

1) I executed a big query and grouped the output:
On NT: 1655.5 milliseconds
On Linux: 3264.5 milliseconds
2) Big query using data caching and grouped the output:
On NT: 415.5 milliseconds
On Linux: 1401.5 milliseconds

These are my observations and I still remember i tested this one, after i
find some results regarding this in the list given by somebody lasttime.

nagesh

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:43 PM
To: CF-Talk
Subject: RE: Which Platform is most scabable for CF 4.5?


At 21:32 10/9/00 +0800, you wrote:
>NT is considerably faster than LINUX.

This statement is based on what?

And, you really meant (based on the original question)
*Cold Fusion* is faster on NT than Linux, right?

RPS


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: catching 3 filenames when using cffile :: some source code

[Paul Ihrig]

here is some code that i was given great help on.

the form::

SELECT * 
FROM tbl_File





SELECT * FROM tbl_File
WHERE FileID = #set_FileID#



 













  
 
   
Image 
  File Info: 
  You can upload up to 3 (*.jpg or *.gif)
images.
  

 
  Upload Image 1:
   

  
 

  
  
  

  


 
 
  Caption 1:
   

  

#File_Type.Caption1#
 
  
  
  

  

 
  Upload Image 2:
   

  
 

  
  
  

  

   


 
  Caption 2:
   

  

#File_Type.Caption2#
 
  
  
  

  

 
  Upload Image 3:
   

  
 

  
  
  

 

   


 
  Caption 3:
   

  

#File_Type.Caption3#
 
  
  
  

  

   
 
  

 
  
  
   

  

 
  


  
















SELECT Max(ContactID) AS MaxOfContactID
FROM tbl_Contact;









SELECT Max(ContactID) AS MaxOfContactID
FROM tbl_Contact;




INSERT INTO tbl_Issue(CategoryTypeID,
AuthorID, SoftwareID, Description, Version, IssueName, Keywords, CreateDate)
VALUES(#CategoryTypeID#,
#GetID.MaxOfContactID#, '#SoftwareID#', '#FORM.Description#',
'#FORM.Version#', '#FORM.IssueName#', '#FORM.Keywords#',
'#FORM.CreateDate#');






 SELECT Max(IssueID) AS MaxOfIssueID
 FROM tbl_Issue;




SELECT c.CategoryTypeName, s.SoftwareName
FROM tbl_CategoryType c, tbl_Software s
WHERE c.CategoryTypeID = #CategoryTypeID#
AND s.SoftwareID = #SoftwareID#;




User - Input









Knowledge Base Data Entered



The Issue:
#Form.IssueName#
   

Description:

#ParagraphFormat(Form.Description)#


Category:
#CategoryTypeName#


Keywords:
#Form.Keywords#


Date Opened:
#Form.CreateDate#
   

Author:
#Form.FirstName#
#Form.LastName#


Email:
mailto:#FORM.Email#">
#Form.Email#


Phone Extension:
#Form.PhoneExt#



Last Updated:
#Fo

RE: Which Platform is most scabable for CF 4.5?

[Reynolds, Adam]

I am very curious about this. Were both installations using a seperate DB
server (to keep data delivery neutral). 

This is the first time I've heard of a NT app beating a Unix app. 

> --
> From: Gavin Lilley[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 15:52
> To:   CF-Talk
> Subject:  RE: Which Platform is most scabable for CF 4.5?
> 
> Can I assume that both machines were of the same specification?
> 
> I am running CF on NT but have the Linux demo ready to install. So far, I
> have found that linux is considerably faster than NT for functions such as
> news reading, web browsing, word processing, oracle and mysql databases
> and
> apache web serving. In fact I run Linux on a P2 350 and my NT machine is a
> P3 450 and Linux is faster!
> 
> How come CF is different? Is CF 5.5 for linux an early development?
> 
> -Original Message-
> From: Nagesh Kumar Deva [mailto:[EMAIL PROTECTED]]
> Sent: 09 October 2000 15:44
> To: CF-Talk
> Subject: RE: Which Platform is most scabable for CF 4.5?
> 
> 
> hi,
> 
> I tested based on some code by running around 15 times and I found
> something
> interesting ie
> 
> 1) I executed a big query and grouped the output:
> On NT: 1655.5 milliseconds
> On Linux: 3264.5 milliseconds
> 2) Big query using data caching and grouped the output:
> On NT: 415.5 milliseconds
> On Linux: 1401.5 milliseconds
> 
> These are my observations and I still remember i tested this one, after i
> find some results regarding this in the list given by somebody lasttime.
> 
> nagesh
> 
> -Original Message-
> From: Ryan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 9:43 PM
> To: CF-Talk
> Subject: RE: Which Platform is most scabable for CF 4.5?
> 
> 
> At 21:32 10/9/00 +0800, you wrote:
> >NT is considerably faster than LINUX.
> 
> This statement is based on what?
> 
> And, you really meant (based on the original question)
> *Cold Fusion* is faster on NT than Linux, right?
> 
> RPS
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Chart and Gaph Utilites

[Gary J. Groomer]

I am developing a ColdFusion application that needs the ability to chart and
graph data pulled dynamically from a database.  I need to be able to
generate bar, pie and line charts.  One that I found on the web is Easy
Charts by ObjectPlanet.  Does anyone have any experience with this Java
component or any others to recommend?

Sincerely,

Gary J. Groomer
DesignFirst, a web design and consulting firm
E-mail: [EMAIL PROTECTED]
Web: www.DesignFirst.com
(503) 723-0964 (Voice or Fax)


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Between???

[Todd Ashworth]

I know that Sybase stores date fields as -mm-dd.  If whatever database
you are using does the same, then checking for mm,dd, isn't going to
work, for example.

Todd Ashworth

- Original Message -
From: "HappyToad.com" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 11:00 AM
Subject: RE: Between???


| The order_date field in my database is already set to:  Date()
| Is this what you mean??
|
| Rich
|
| -Original Message-
| From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
| Sent: Monday, October 09, 2000 10:31 AM
| To: CF-Talk
| Subject: RE: Between???
|
|
| The problem is that the format you are using (MM,DD,) is not valid for
| the database.  CF might like that syntax to describe a date, but the SQL
| engine won't recognize it.  Check out the CreateODBCDate() function - use
it
| to convert your date into SQL friendly format.
|
| Bob
|
|
| -Original Message-
| From: HappyToad.com [mailto:[EMAIL PROTECTED]]
| Sent: Monday, October 09, 2000 10:28 AM
| To: CF-Talk
| Subject: Between???
|
|
| I have set up a form to enter the dates which has the following query on
the
| form action page:
|
| 
| SELECT order_id FROM orders
| WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
| AND ('#to_month#','#to_day#','#to_year#')
| 
|
| Why doesn't this work?
| Rich


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[HappyToad.com]

I am using access.
Rich

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 11:50 AM
To: CF-Talk
Subject: Re: Between???


I know that Sybase stores date fields as -mm-dd.  If whatever database
you are using does the same, then checking for mm,dd, isn't going to
work, for example.

Todd Ashworth

- Original Message -
From: "HappyToad.com" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 11:00 AM
Subject: RE: Between???


| The order_date field in my database is already set to:  Date()
| Is this what you mean??
|
| Rich
|
| -Original Message-
| From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
| Sent: Monday, October 09, 2000 10:31 AM
| To: CF-Talk
| Subject: RE: Between???
|
|
| The problem is that the format you are using (MM,DD,) is not valid for
| the database.  CF might like that syntax to describe a date, but the SQL
| engine won't recognize it.  Check out the CreateODBCDate() function - use
it
| to convert your date into SQL friendly format.
|
| Bob
|
|
| -Original Message-
| From: HappyToad.com [mailto:[EMAIL PROTECTED]]
| Sent: Monday, October 09, 2000 10:28 AM
| To: CF-Talk
| Subject: Between???
|
|
| I have set up a form to enter the dates which has the following query on
the
| form action page:
|
| 
| SELECT order_id FROM orders
| WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
| AND ('#to_month#','#to_day#','#to_year#')
| 
|
| Why doesn't this work?
| Rich



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Ryan]

I think CF SP1 is supposed to speed up the linux version of CF a bit.

Ryan

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Which Platform is most scabable for CF 4.5?

[Chris Lott]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>So far, I
> > have found that linux is considerably faster than NT for functions such
> as news reading, web browsing, word processing, oracle and mysql
> databases and apache web serving. In fact I run Linux on a P2 350 and my
> NT machine is a P3 450 and Linux is faster!

In character mode or in X? I find that (obviously) Linux is much faster
when not running a GUI, but X performance has always been poor to
atrocious...

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeHojNaLYehRBGz9EQKDrACeI8YSOm68pRGJTXOBEJPH1QEbHzMAn20t
7tdkMZtoQY73SKg2ofZXKvcS
=wP/X
-END PGP SIGNATURE-


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[DeVoil, Nick]

Then try something like 

SELECT order_id FROM orders
WHERE order_date BETWEEN CDate('#from_month#' & '/' & '#from_day#' & '/' &
'#from_year#')
AND CDate('#to_month#' & '/' & '#to_day#' &  '/' & '#to_year#')

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[Bob Silverberg]

Rich,

Try this:




Then just use fromDate and toDate in your between statement in your CFQUERY.

This is just off the top of my head - you might not have to use CreateDate
in the middle like that.  The key is to use CreateODBCDate to convert your
date into a format that will be successfully passed via SQL to the database.

Bob

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 11:01 AM
To: CF-Talk
Subject: RE: Between???


The order_date field in my database is already set to:  Date()
Is this what you mean??

Rich

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:31 AM
To: CF-Talk
Subject: RE: Between???


The problem is that the format you are using (MM,DD,) is not valid for
the database.  CF might like that syntax to describe a date, but the SQL
engine won't recognize it.  Check out the CreateODBCDate() function - use it
to convert your date into SQL friendly format.

Bob


-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:28 AM
To: CF-Talk
Subject: Between???


I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Drop down list for display of information

[Sarah Winters]

Hi everyone. I'm brand new to the list, and a real newbie with ColdFusion 
and I'm stuck. I've learned how to display information from a database so 
that when basic info about (lets say a person) is shown, by clicking on the 
person's name another page shows up with other fields drawn from the 
database that I've querried. I understand how to do this, but what I want to 
do is the exact same thing but use a drop down select list. I've got 5 books 
and they talk about CFSELECT and many other ways of doing this, but only to 
insert the selection into the form. I simply want to use the selection list 
to query the database and output the information, not change anything within 
the database.

I know this has got to be ridiculously easy, and I feel stupid even asking. 
I've tried everything, including using hidden fields, to to avail. Anyway, 
could someone tell me how to do this in very plain english, because I'm 
obviously missing something.

Thanks for your patience with a newbie, I'm just utterly stuck.


Sarah Winters
[EMAIL PROTECTED]


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

OT: Java Books

[Lee Surma]

I want to start playing around with Java but I'm only really interested in 
Web/database applications. Should I start out with a JSP book or should I be looking 
for a beginner Java book? Which books do you recommend?
-- 

_
Lee Surma
Public Radio International
[EMAIL PROTECTED]
612-330-9223
_

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[Richard Kern]

Rich,

That's half the answer.  The other half is to use the CreatODBCDate()
function on your form.  Then when it is passed to the action form it will be
posted to the access db is the correct format.  Any existing entries (passed
in without going through this function)  will have to be redone so they are
in the ODBC format before your query will work.  That's a pain to do but I'm
not aware of other solutions for existing entries.

But you might consider that a change in the DB structure to a text field
would then give an opportunity to compare strings and select on them.

Richard

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:01 AM
To: CF-Talk
Subject: RE: Between???


The order_date field in my database is already set to:  Date()
Is this what you mean??

Rich

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:31 AM
To: CF-Talk
Subject: RE: Between???


The problem is that the format you are using (MM,DD,) is not valid for
the database.  CF might like that syntax to describe a date, but the SQL
engine won't recognize it.  Check out the CreateODBCDate() function - use it
to convert your date into SQL friendly format.

Bob


-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:28 AM
To: CF-Talk
Subject: Between???


I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Gavin Lilley]

I usually run my desktop machine under X (usually GNOME). I use Staroffice,
Netscape xnews etc and it is much faster than a higher spec NT box with the
same memory (128Mb) and a larger processor.

I have been involved in testing a linux box running mySql & Oracle on a
linux box and its performance is faster than NT - sometimes by a small
amount - sometimes more.

When I get time - I plan to test Cf on the linux box - should be
interesting!

--
Gavin Lilley
Internet / Intranet Developer
Halesowen College
Tel: 0121 550 1451 Ext: 330

-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: 09 October 2000 16:47
To: CF-Talk
Subject: Re: Which Platform is most scabable for CF 4.5?


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>So far, I
> > have found that linux is considerably faster than NT for functions such
> as news reading, web browsing, word processing, oracle and mysql
> databases and apache web serving. In fact I run Linux on a P2 350 and my
> NT machine is a P3 450 and Linux is faster!

In character mode or in X? I find that (obviously) Linux is much faster
when not running a GUI, but X performance has always been poor to
atrocious...

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeHojNaLYehRBGz9EQKDrACeI8YSOm68pRGJTXOBEJPH1QEbHzMAn20t
7tdkMZtoQY73SKg2ofZXKvcS
=wP/X
-END PGP SIGNATURE-



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Chart and Gaph Utilites

[David E. Crawford]

This is a multi-part message in MIME format.

--=_NextPart_000_0222_01C03207.E911C670
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Chart and Gaph Utilites

You might look at PopChart Server from Corda Technologies, www.corda.com,
which has a CF interface and is built on JRUN.

DC

  -Original Message-
  From: Gary J. Groomer [mailto:[EMAIL PROTECTED]]
  Sent: Monday, October 09, 2000 15:14
  To: CF-Talk
  Subject: Chart and Gaph Utilites


  I am developing a ColdFusion application that needs the ability to chart
and
  graph data pulled dynamically from a database.  I need to be able to
  generate bar, pie and line charts.  One that I found on the web is Easy
  Charts by ObjectPlanet.  Does anyone have any experience with this Java
  component or any others to recommend?

  Sincerely,

  Gary J. Groomer
  DesignFirst, a web design and consulting firm
  E-mail: [EMAIL PROTECTED]
  Web: www.DesignFirst.com
  (503) 723-0964 (Voice or Fax)



  --

  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--=_NextPart_000_0222_01C03207.E911C670
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Chart and Gaph Utilites



 
 
You=20
might look at PopChart Server from Corda Technologies, http://www.corda.com">www.corda.com, which has a CF =
interface and is=20
built on JRUN.
 
DC
 

  -Original Message-From: Gary J. Groomer=20
  [mailto:[EMAIL PROTECTED]]Sent: Monday, October 09, =
2000=20
  15:14To: CF-TalkSubject: Chart and Gaph=20
  Utilites
  I am developing a ColdFusion application that needs =
the=20
  ability to chart and graph data pulled =
dynamically=20
  from a database.  I need to be able to generate=20
  bar, pie and line charts.  One that I found on the web is =
Easy=20
  Charts by ObjectPlanet.  Does anyone have any =
experience=20
  with this Java component or any others to=20
  recommend? 
  Sincerely, 
  Gary J. Groomer DesignFirst, a web=20
  design and consulting firm E-mail:=20
  [EMAIL PROTECTED] Web: =
www.DesignFirst.com=20
  (503) 723-0964 (Voice or Fax) 
  =
--=20
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
  =
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
  To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
  =
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk=20
  or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
  the body.

--=_NextPart_000_0222_01C03207.E911C670--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[HappyToad.com]

PERFECT!!  Thank You :-)
Rich

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 11:37 AM
To: CF-Talk
Subject: RE: Between???


Then try something like

SELECT order_id FROM orders
WHERE order_date BETWEEN CDate('#from_month#' & '/' & '#from_day#' & '/' &
'#from_year#')
AND CDate('#to_month#' & '/' & '#to_day#' &  '/' & '#to_year#')

Nick


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Drop down list for display of information

[Hayes, David]

Welcome, Sarah

I'm assuming you know how to create an HTML form and reference an action
page.

The process should be much the same as your URL link which queries the
database and returns the relevant information.  You just need to change your
query on the results page to something like:

Select  from  where personID =
#form.personID#

If you name your HTML select field "personID", this should give you the
right results.  


-Original Message-
From: Sarah Winters [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:39 AM
To: CF-Talk
Subject: Drop down list for display of information


Hi everyone. I'm brand new to the list, and a real newbie with ColdFusion 
and I'm stuck. I've learned how to display information from a database so 
that when basic info about (lets say a person) is shown, by clicking on the 
person's name another page shows up with other fields drawn from the 
database that I've querried. I understand how to do this, but what I want to

do is the exact same thing but use a drop down select list. I've got 5 books

and they talk about CFSELECT and many other ways of doing this, but only to 
insert the selection into the form. I simply want to use the selection list 
to query the database and output the information, not change anything within

the database.

I know this has got to be ridiculously easy, and I feel stupid even asking. 
I've tried everything, including using hidden fields, to to avail. Anyway, 
could someone tell me how to do this in very plain english, because I'm 
obviously missing something.

Thanks for your patience with a newbie, I'm just utterly stuck.


Sarah Winters
[EMAIL PROTECTED]


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Paul Johnston]

Erm, I have never come across a situation where you would need to run X on
linux whilst the web server is running.  Maybe you need X to install some
things, but after that it's strictly command line.  Why waste resources on a
GUI when you don't need it?

Paul

> -Original Message-
> From: Chris Lott [mailto:[EMAIL PROTECTED]]
> Sent: 09 October 2000 16:47
> To: CF-Talk
> Subject: Re: Which Platform is most scabable for CF 4.5?
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> >So far, I
> > > have found that linux is considerably faster than NT for
> functions such
> > as news reading, web browsing, word processing, oracle and mysql
> > databases and apache web serving. In fact I run Linux on a P2 350 and my
> > NT machine is a P3 450 and Linux is faster!
>
> In character mode or in X? I find that (obviously) Linux is much faster
> when not running a GUI, but X performance has always been poor to
> atrocious...
>
> c
>
> -BEGIN PGP SIGNATURE-
> Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
> Comment: PGP Signed for message verification and/or encryption
> Comment: KeyID: 0xD68B61E851046CFD
>
> iQA/AwUBOeHojNaLYehRBGz9EQKDrACeI8YSOm68pRGJTXOBEJPH1QEbHzMAn20t
> 7tdkMZtoQY73SKg2ofZXKvcS
> =wP/X
> -END PGP SIGNATURE-
>
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Reynolds, Adam]

There is an article on server optimization in the knowledge base. It suggets
that unless it is specifically suporting the CF App Server...it gets binned.

> --
> From: Paul Johnston[SMTP:[EMAIL PROTECTED]]
> Sent: 09 October 2000 16:52
> To:   CF-Talk
> Subject:  RE: Which Platform is most scabable for CF 4.5?
> 
> Erm, I have never come across a situation where you would need to run X on
> linux whilst the web server is running.  Maybe you need X to install some
> things, but after that it's strictly command line.  Why waste resources on
> a
> GUI when you don't need it?
> 
> Paul
> 
> > -Original Message-
> > From: Chris Lott [mailto:[EMAIL PROTECTED]]
> > Sent: 09 October 2000 16:47
> > To: CF-Talk
> > Subject: Re: Which Platform is most scabable for CF 4.5?
> >
> >
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > >So far, I
> > > > have found that linux is considerably faster than NT for
> > functions such
> > > as news reading, web browsing, word processing, oracle and mysql
> > > databases and apache web serving. In fact I run Linux on a P2 350 and
> my
> > > NT machine is a P3 450 and Linux is faster!
> >
> > In character mode or in X? I find that (obviously) Linux is much faster
> > when not running a GUI, but X performance has always been poor to
> > atrocious...
> >
> > c
> >
> > -BEGIN PGP SIGNATURE-
> > Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
> > Comment: PGP Signed for message verification and/or encryption
> > Comment: KeyID: 0xD68B61E851046CFD
> >
> > iQA/AwUBOeHojNaLYehRBGz9EQKDrACeI8YSOm68pRGJTXOBEJPH1QEbHzMAn20t
> > 7tdkMZtoQY73SKg2ofZXKvcS
> > =wP/X
> > -END PGP SIGNATURE-
> >
> >
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Drop down list for display of information

[Dave Hannum]

Query your database and get the values, then build your dropdown dynamically
with the output of the query (use your proper column names where I've
inserted examples)


SELECT *
FROM yourTable





#nameDescription#




Dave

=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



- Original Message -
From: "Sarah Winters" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 11:38 AM
Subject: Drop down list for display of information


Hi everyone. I'm brand new to the list, and a real newbie with ColdFusion
and I'm stuck. I've learned how to display information from a database so
that when basic info about (lets say a person) is shown, by clicking on the
person's name another page shows up with other fields drawn from the
database that I've querried. I understand how to do this, but what I want to
do is the exact same thing but use a drop down select list. I've got 5 books
and they talk about CFSELECT and many other ways of doing this, but only to
insert the selection into the form. I simply want to use the selection list
to query the database and output the information, not change anything within
the database.

I know this has got to be ridiculously easy, and I feel stupid even asking.
I've tried everything, including using hidden fields, to to avail. Anyway,
could someone tell me how to do this in very plain english, because I'm
obviously missing something.

Thanks for your patience with a newbie, I'm just utterly stuck.


Sarah Winters
[EMAIL PROTECTED]


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Between???

[HappyToad.com]

Its all good, This worked Perfectly:

SELECT order_id FROM orders
WHERE order_date BETWEEN CDate('#from_month#' & '/' & '#from_day#' & '/' &
'#from_year#')
AND CDate('#to_month#' & '/' & '#to_day#' &  '/' & '#to_year#')

Thanks for all your help,
Rich

-Original Message-
From: Richard Kern [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 11:42 AM
To: CF-Talk
Subject: RE: Between???


Rich,

That's half the answer.  The other half is to use the CreatODBCDate()
function on your form.  Then when it is passed to the action form it will be
posted to the access db is the correct format.  Any existing entries (passed
in without going through this function)  will have to be redone so they are
in the ODBC format before your query will work.  That's a pain to do but I'm
not aware of other solutions for existing entries.

But you might consider that a change in the DB structure to a text field
would then give an opportunity to compare strings and select on them.

Richard

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:01 AM
To: CF-Talk
Subject: RE: Between???


The order_date field in my database is already set to:  Date()
Is this what you mean??

Rich

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:31 AM
To: CF-Talk
Subject: RE: Between???


The problem is that the format you are using (MM,DD,) is not valid for
the database.  CF might like that syntax to describe a date, but the SQL
engine won't recognize it.  Check out the CreateODBCDate() function - use it
to convert your date into SQL friendly format.

Bob


-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:28 AM
To: CF-Talk
Subject: Between???


I have set up a form to enter the dates which has the following query on the
form action page:


SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')


Why doesn't this work?
Rich


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: [OT: Java Books]

[double-down]

"teach yourself java" by joseph o'neil is a good beginner book

Lee Surma <[EMAIL PROTECTED]> wrote:
I want to start playing around with Java but I'm only really interested in
Web/database applications. Should I start out with a JSP book or should I be
looking for a beginner Java book? Which books do you recommend?
-- 

_
Lee Surma
Public Radio International
[EMAIL PROTECTED]
612-330-9223
_

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Java Books

[JustinMacCarthy]

There are 2 Great Java books for beginners by Wrox

Beginning Java 2
And
Professional Java Server Programming

Also check out java.sun.com for lots of code ,example & help.

Justin MacCarthy


- Original Message -
From: "Lee Surma" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 5:43 PM
Subject: OT: Java Books


> I want to start playing around with Java but I'm only really interested in
Web/database applications. Should I start out with a JSP book or should I be
looking for a beginner Java book? Which books do you recommend?
> --
>
> _
> Lee Surma
> Public Radio International
> [EMAIL PROTECTED]
> 612-330-9223
> _
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Jeremy Allen]

I feel compelled to reply.

That seems like a pretty ANTI-Linux post.

If you configure X properly, try Xfree 4.01, it
really runs fast. Just by nature it will
never be as fast as a GUI done somewhat in
Kernel (thats a whole another story about
Windows and im not gonna get into it)

However, most utilities,  BIND,
Qmail, Samba whatever have some sort of
GUI manager that can simplify their use
and ANY time I have ever needed to run
an X app, I always find it most convenient
to just run the X server on my workstation
(There are some nice X servers for windows)
and just invoke whatever programs remotely.

That is where the true power of X lies,
in that you can invoke an X program over
the net if you had too. Thats the whole
idea behind X, most people never realize
you can even do that, and as for complaining
it take sresources, yes it does any GUI
will.

As for X being slow.. it depends on what
Video card and version of X your using.
I have a G400 Max, and I find it to be
very very responsive (QIII runs fine
ina  window, even over X) so it may not
be as fast as Windows, but comparatively
its not poor unless something is not
really setup properly.

Now, I wouldnt even install X on any
kind of production environment. I wouldnt
even install very much of anything and
then I would look at something like
bastille hardening scripts and always
mandantory is a trip to security focus
and bugtraq..  Any kind of production
system should pretty much have a canned
configuration as much as possible.

Now as to the actual CF question, I think
despite my personal beliefs that Windows
platforms are still the best choice with
ColdFusion (right now). I think that will
change in Linux kernel 2.4 (multi-threaded
TCP/IP stack among a ton of other really
cool stuff that should make Linux up
there with the BSD's as far as network
scalability). I think its pretty much
even either way, you may find CF runs a
bit quicker on NT, but as the Linux
version matures more it should easily
surpass the Windows versions.

It is just whatever you are most comfortable
with tuning and configuring, any well tuned
server is going to perform regardless.

Anyhow enough rambling.

Jeremy Allen
[EMAIL PROTECTED]




-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 11:47 AM
To: CF-Talk
Subject: Re: Which Platform is most scabable for CF 4.5?


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>So far, I
> > have found that linux is considerably faster than NT for functions such
> as news reading, web browsing, word processing, oracle and mysql
> databases and apache web serving. In fact I run Linux on a P2 350 and my
> NT machine is a P3 450 and Linux is faster!

In character mode or in X? I find that (obviously) Linux is much faster
when not running a GUI, but X performance has always been poor to
atrocious...

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeHojNaLYehRBGz9EQKDrACeI8YSOm68pRGJTXOBEJPH1QEbHzMAn20t
7tdkMZtoQY73SKg2ofZXKvcS
=wP/X
-END PGP SIGNATURE-



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Java Books

[Simon Horwith]

java Gently is an excellent beginner's book, too

~Simon

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 12:05 PM
To: CF-Talk
Subject: Re: Java Books


There are 2 Great Java books for beginners by Wrox

Beginning Java 2
And
Professional Java Server Programming

Also check out java.sun.com for lots of code ,example & help.

Justin MacCarthy


- Original Message -
From: "Lee Surma" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 5:43 PM
Subject: OT: Java Books


> I want to start playing around with Java but I'm only really interested in
Web/database applications. Should I start out with a JSP book or should I be
looking for a beginner Java book? Which books do you recommend?
> --
>
> _
> Lee Surma
> Public Radio International
> [EMAIL PROTECTED]
> 612-330-9223
> _
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
>


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Java Books

[Pete Freitag]

Thinking In Java by Bruce Eckel is a great book.

-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 12:43 PM
To: CF-Talk
Subject: OT: Java Books


I want to start playing around with Java but I'm only really interested in
Web/database applications. Should I start out with a JSP book or should I be
looking for a beginner Java book? Which books do you recommend?
--

_
Lee Surma
Public Radio International
[EMAIL PROTECTED]
612-330-9223
_


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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Displaying CF code

[Pete Freitag]

Here's the logic, you can write the code...

If switch=execute
cfinclude the file
if switch=viewsource
cffile the file
output the contents of the file
set the content type of the file to text/plain


__
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM / NETDesign Inc.
ColdFusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code


I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.

Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .

TIA,
--John



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Which Platform is most scabable for CF 4.5?

[Chris Lott]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>I usually run my desktop machine under X (usually GNOME). I use
>Staroffice,
> > Netscape xnews etc and it is much faster than a higher spec NT box with
> the same memory (128Mb) and a larger processor.

Interesting... definitely completely the opposite of my experiences. Star
Office was very buggy and I have yet to see a decent web browser in X. But
I love Linux for other reasons, and use it all the time. Just not with X.
Maybe I'll give it another go sometime.

> I have been involved in testing a linux box running mySql & Oracle on a
> linux box and its performance is faster than NT - sometimes by a small
> amount - sometimes more.

mySql is definitely faster on Linux. 

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeH3NdaLYehRBGz9EQLxqgCfS+JJ67Lv4x7p5EU2w7MgvJTOm2oAoOO8
p4DPorPfCpM9ERleum5i8/W6
=Dmrb
-END PGP SIGNATURE-


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Which Platform is most scabable for CF 4.5?

[Chris Lott]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>Erm, I have never come across a situation where you would need to run X on
> > linux whilst the web server is running.  Maybe you need X to install
some
> things, but after that it's strictly command line.  Why waste resources
> on a GUI when you don't need it?

That wasn't the question. The poster made a statement that news reading,
web browsing, word processing, etc were faster on Linux. I replied that it
might be faster in character mode apps, but not with X (in my experience).

Has nothing to do with the web server. I don't use X at all anymore,
myself.

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeH3ldaLYehRBGz9EQKIpACgisRS1IN1JUcOwaO2NUJHfHuWLVsAoKRL
WKEvoZVqcdEi2OQeYiGWgyYA
=Vn9Q
-END PGP SIGNATURE-


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Chart and Gaph Utilites

[Pete Freitag]

CFX_GraphicsServer at http://www.cfdev.com/

-Original Message-
From: Gary J. Groomer [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 11:14 AM
To: CF-Talk
Subject: Chart and Gaph Utilites


I am developing a ColdFusion application that needs the ability to chart and
graph data pulled dynamically from a database.  I need to be able to
generate bar, pie and line charts.  One that I found on the web is Easy
Charts by ObjectPlanet.  Does anyone have any experience with this Java
component or any others to recommend?

Sincerely,

Gary J. Groomer
DesignFirst, a web design and consulting firm
E-mail: [EMAIL PROTECTED]
Web: www.DesignFirst.com
(503) 723-0964 (Voice or Fax)



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Which Platform is most scabable for CF 4.5?

[Chris Lott]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>That seems like a pretty ANTI-Linux post.
> 
I'm NOT anti-linux. I have a number of linux boxes on both intel and ppc. I
LIKE it. In my experience, though, Windows 2000 on the same hardware with
the apps I like is faster in operation than the equivalent X applications
that I have tried. Others I know have come to the same conclusion. The
answer for me was not to dump Linux, but to dump X. Plus, since most of my
linux boxes are servers of one kind or another, it is just a waste of disk
space to have it and a waste of resources to run it, since I can get it all
done from the CLI.

> If you configure X properly, try Xfree 4.01, it
> really runs fast. Just by nature it will
> never be as fast as a GUI done somewhat in
> Kernel (thats a whole another story about
> Windows and im not gonna get into it)

Fair enough.

> That is where the true power of X lies,
> in that you can invoke an X program over
> the net if you had too. 

Sure. I know that. The point that was raised was about common office
applications being faster in X. There is much utility to running an app
remotely, though again I prefer just to use the character apps for that. 

> so it may not
> be as fast as Windows

Which is all I was saying. It has nothing to do with being anti-Linux. I
am, in fact, quite the opposite.

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeH4+NaLYehRBGz9EQL3BwCfa9PBO/FVA4C3zEV+O12WbRyG1SUAoIXo
iz9iklzbk59zbU53eOANz94S
=qJpg
-END PGP SIGNATURE-


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Send data to Excel

[Neil Robinson]

I'm developing a graphing system using CF and CFXGraphicsServer.  I'd like
to give the user the option to export the graph source data into Excel if
possible.  Does anyone know of a way I can do this?

Thanks in advance

Neil Robinson

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Displaying CF code

[sebastian palmigiani]

on 10/9/00 9:10 AM, John Allred at [EMAIL PROTECTED] wrote:

> I have some CF templates on an intranet for which I'd like to display the
> code in the user's browser. I find myself without my printed manuals, and I
> can't seem to find what I'm looking for in the online help.

HTMLCodeFormat(YourCodeHere)

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

You are a stored Proc god if you can answer this...

[Mark W. Breneman]

I need to do a record count with a CF generated "WHERE" statement.

SELECT  count (*) as noofrecords
FROM xxx
#PreserveSingleQuotes(searchstring)#

Now I need to convert this into a stored proc.

I tried:
CREATE PROCEDURE [Search_RC]  @where varchar(255)
AS

SELECT  count (*) as noofrecords
FROM NPO_IRS_primary
@where

No luck...

Any one have an idea?



Example of the "WHERE" statement:
WHERE (State = 'NC') and ((ActivityCodeOne = '260') or (ActivityCodetwo =
'260') or (ActivityCodethree = '260') or (ActivityCodeOne
 = '261') or (ActivityCodetwo = '261') or (ActivityCodethree = '261') or
(ActivityCodeOne = '262') or (ActivityCodetwo = '262') or (ActivityCodethree
=
  '262') or (ActivityCodeOne = '263') or (ActivityCodetwo = '263') or
(ActivityCodethree = '263') or (ActivityCodeOne = '264') or (ActivityCodetwo
=
  '264') or (ActivityCodethree = '264') or (ActivityCodeOne = '265') or
(ActivityCodetwo = '265') or (ActivityCodethree = '265') or (ActivityCodeOne
=
  '266') or (ActivityCodetwo = '266') or (ActivityCodethree = '266') or
(ActivityCodeOne = '267') or (ActivityCodetwo = '267') or (ActivityCodethree
=
  '267') or (ActivityCodeOne = '268') or (ActivityCodetwo = '268') or
(ActivityCodethree = '268') or (ActivityCodeOne = '269') or (ActivityCodetwo
=
  '269') or (ActivityCodethree = '269') or (ActivityCodeOne = '279')
or (ActivityCodetwo = '279') or (ActivityCodethree = '279') )



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: You are a stored Proc god if you can answer this...

[Jason Powers]

Try an exec statement.
CREATE PROCEDURE [Search_RC]  @where varchar(255)
AS
exec ('SELECT  count (*) as noofrecords
FROM NPO_IRS_primary '+@where)

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 1:09 PM
To: CF-Talk
Subject: You are a stored Proc god if you can answer this...


I need to do a record count with a CF generated "WHERE" statement.

SELECT  count (*) as noofrecords
FROM xxx
#PreserveSingleQuotes(searchstring)#

Now I need to convert this into a stored proc.

I tried:
CREATE PROCEDURE [Search_RC]  @where varchar(255)
AS

SELECT  count (*) as noofrecords
FROM NPO_IRS_primary
@where

No luck...

Any one have an idea?



Example of the "WHERE" statement:
WHERE (State = 'NC') and ((ActivityCodeOne = '260') or (ActivityCodetwo =
'260') or (ActivityCodethree = '260') or (ActivityCodeOne
 = '261') or (ActivityCodetwo = '261') or (ActivityCodethree = '261') or
(ActivityCodeOne = '262') or (ActivityCodetwo = '262') or (ActivityCodethree
=
  '262') or (ActivityCodeOne = '263') or (ActivityCodetwo = '263') or
(ActivityCodethree = '263') or (ActivityCodeOne = '264') or (ActivityCodetwo
=
  '264') or (ActivityCodethree = '264') or (ActivityCodeOne = '265') or
(ActivityCodetwo = '265') or (ActivityCodethree = '265') or (ActivityCodeOne
=
  '266') or (ActivityCodetwo = '266') or (ActivityCodethree = '266') or
(ActivityCodeOne = '267') or (ActivityCodetwo = '267') or (ActivityCodethree
=
  '267') or (ActivityCodeOne = '268') or (ActivityCodetwo = '268') or
(ActivityCodethree = '268') or (ActivityCodeOne = '269') or (ActivityCodetwo
=
  '269') or (ActivityCodethree = '269') or (ActivityCodeOne = '279')
or (ActivityCodetwo = '279') or (ActivityCodethree = '279') )



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF Sessions?

[Robert Sarno]

Can someone please point me to a great example area for CF sessions.  The 
ones in the Allaire Que books are horrible for my needs.

I am trying to use NT Authentication to authenticate persons to particular 
sessions on our corporate sight instead of a login screen.  No such luck 
that I can see an example liek that.

Rob
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF Sessions Examples?

[Robert Sarno]

Can someone please point me to a great example area for CF sessions.  The 
ones in the Allaire Que books are horrible for my needs.

I am trying to use NT Authentication to authenticate persons to particular 
sessions on our corporate sight instead of a login screen.  No such luck 
that I can see an example liek that.

Rob
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

OT: robots.txt

[Chad Gray]

Anyone know what robots.txt is?

thanks
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Which Platform is most scabable for CF 4.5?

[Jeremy Allen]

lol no im not picking on you Chris! :)

Just one thing to point out mySQL is in no way a
true RDBMS like Oracle, and mySQL has to be seriously
beaten with a stick to really scale.

mySQL is designed for a high number of reads low
number of writes (meaning lots of selecting little
saving of information)

It is missing veyr many key components which if
your writing an app make the "faster" question
irrelevant. Here are a few things mySQL is missing.

Foreign Keys (better code good ;)
Stored Procedures
Sub Selects
Transactions
Granular Locking (whole table must be locked)
Along with a few more minor points.

However thsoe are some major features which make
mySQL largely non ANSI-92 compliant. They are
working on being compliant but its not really what
mySQL was ever designed for. Its a very quick way
to setup a site like a web portal thats going to
regurgitate data a lot but not really deal with a
whole lot of gory things like E-commerece, sites
that deal with a lot of data saving / manipulation
etc.

You CAN get away with all of this, but for the
same price I recommend PostgreSQL which has all
of the aformentioned features and scales more than
MySQL (its not quite as quick on some things as
mySQL but then neither is Oracle) PostgreSQL
I have heard a few bad stories about but
my personal experiences (including using its
C API to hook up a C program to a database)
were all very positive.  I found the documentation
Excellent, I found the database to be very solid
and configurable, and overall it has everything
you would look for in a RDBMS.

On top of that in the 4.5 Release notes it is briefly
discussed how to get PostgreSQL working over ODBC
(sorry no native drivers).

So overall if you are looking for a cheap database
that is rather feature rich, I say go with Postgres.

-
Again, I think X with the proper video card is a dream
really, try it out again with XFree 4.01 its worth trying
as long as you dont run to much bloated stuff (Gnome, KDE)
it can be nice.

I agree Star Office tries to be everything for you and it
was rather slow and memory intensive to say the least.

Web browsers, there is Konquerer, The latest releases
of Mozilla (NOT netscape), Opera 4.0bx, Netscape 4.7
and my favorite lynx (hehe it runs in an xterm just fine!:)
I dont follow mozilla to closely, it is still to darn
buggy to be used constantly, and just to pay lip
service to what I have heard, Opera runs very nicely.
-

Really im not picking :)


If the shoe fits wear it, if not dont try!!! :)

Same applies to programming tools and OS.


Jeremy Allen
[EMAIL PROTECTED]





-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 12:50 PM
To: CF-Talk
Subject: Re: Which Platform is most scabable for CF 4.5?


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>I usually run my desktop machine under X (usually GNOME). I use
>Staroffice,
> > Netscape xnews etc and it is much faster than a higher spec NT box with
> the same memory (128Mb) and a larger processor.

Interesting... definitely completely the opposite of my experiences. Star
Office was very buggy and I have yet to see a decent web browser in X. But
I love Linux for other reasons, and use it all the time. Just not with X.
Maybe I'll give it another go sometime.

> I have been involved in testing a linux box running mySql & Oracle on a
> linux box and its performance is faster than NT - sometimes by a small
> amount - sometimes more.

mySql is definitely faster on Linux.

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeH3NdaLYehRBGz9EQLxqgCfS+JJ67Lv4x7p5EU2w7MgvJTOm2oAoOO8
p4DPorPfCpM9ERleum5i8/W6
=Dmrb
-END PGP SIGNATURE-



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: You are a stored Proc god if you can answer this...

[Wjreichard]

In a message dated 10/9/00 1:10:09 PM Eastern Daylight Time, 
[EMAIL PROTECTED] writes:

<<  tried:
 CREATE PROCEDURE [Search_RC]  @where varchar(255)
 AS
 
 SELECT  count (*) as noofrecords
 FROM NPO_IRS_primary
 @where
 
 No luck... >>
Your missing the 'WHERE' part of the where clause  should be something 
like:

WHERE [field] = @where

or if the entire where clause text is contained in @where then you will need 
to create the entire SQL statement in SQL and then Execute it.

Bill
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: OT: robots.txt

[Wjreichard]

It is a file that gives instructions to search engines. You can specify whick 
files/directories should be searched by a visiting spider.

However, Not all spiders are nice.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: robots.txt

[JustinMacCarthy]

The robot.txt is a file to control how a web spider , goes though your site
. Not all spiders respect this file.

Try

http://info.webcrawler.com/mak/projects/robots/norobots.html


Justin
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2000 6:24 PM
Subject: OT: robots.txt


> Anyone know what robots.txt is?
>
> thanks
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

padding string with blanks

[Adrian Cesana]

I need to pass a string to a bar-coding process and it must have a fixed
length of 18, so if the string length is 10 I need to pad 8 blanks in front
of it.  Ive been playing with the below code. I know it doesn't work but its
a start, what happens is the value of blanks get appended to the string
rather than appending actual blanks.  Any idea on how to get the blanks in
there or a better method?










Here is my padded string for the BarCode #TrackNo#

Thanks, Adrian

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF Sessions?

[Jim McAtee]

> I am trying to use NT Authentication to authenticate persons to particular
> sessions on our corporate sight instead of a login screen.  No such luck
> that I can see an example liek that.

Using NT authentication can be pretty straightforward.  The simplest
scenario is to just set the desired NTFS permissions on a directory where
your protected templates reside.  Windows will present a login dialog box to
the user and will authenticate against the NT SAM.

Jim

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: [padding string with blanks]

[double-down]

here is a perl example you might be able to change  to CF.

#pad with leading spaces
while (length($FullTrackNo) < 18){
  $FullTrackNo=" " . $FullTrackNo;
}

"Adrian Cesana" <[EMAIL PROTECTED]> wrote:
I need to pass a string to a bar-coding process and it must have a fixed
length of 18, so if the string length is 10 I need to pad 8 blanks in front
of it.  Ive been playing with the below code. I know it doesn't work but its
a start, what happens is the value of blanks get appended to the string
rather than appending actual blanks.  Any idea on how to get the blanks in
there or a better method?










Here is my padded string for the BarCode #TrackNo#

Thanks, Adrian

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: padding string with blanks

[Hayes, David]

The specific problem is that blanks is a numeric value; repeatString is a
function you should look at.

A simple one-liner, which will always give you a string of 18 characters,
padded as necessary:




-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 12:41 PM
To: CF-Talk
Subject: padding string with blanks


I need to pass a string to a bar-coding process and it must have a fixed
length of 18, so if the string length is 10 I need to pad 8 blanks in front
of it.  Ive been playing with the below code. I know it doesn't work but its
a start, what happens is the value of blanks get appended to the string
rather than appending actual blanks.  Any idea on how to get the blanks in
there or a better method?










Here is my padded string for the BarCode #TrackNo#

Thanks, Adrian


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: padding string with blanks

[mherbene]

My cheesy solution to this type of problem has always been

cfset result = right((' ' & fulltrackno), 18)

-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 1:41 PM
To: CF-Talk
Subject: padding string with blanks


I need to pass a string to a bar-coding process and it must have a fixed
length of 18, so if the string length is 10 I need to pad 8 blanks in front
of it.  Ive been playing with the below code. I know it doesn't work but its
a start, what happens is the value of blanks get appended to the string
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: padding string with blanks

[Jim McAtee]

> I need to pass a string to a bar-coding process and it must have a fixed
> length of 18, so if the string length is 10 I need to pad 8 blanks in
front
> of it.  Ive been playing with the below code. I know it doesn't work but
its
> a start, what happens is the value of blanks get appended to the string
> rather than appending actual blanks.  Any idea on how to get the blanks in
> there or a better method?


Use CF's RJustify() function.  There's also a LJustify() and CJustify().

Jim


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

MySQL [was Re: Which Platform is most scabable for CF 4.5?]

[Chris Lott]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>lol no im not picking on you Chris! :)
> > 
> Just one thing to point out mySQL is in no way a
> true RDBMS like Oracle, and mySQL has to be seriously
> beaten with a stick to really scale.

Oh yeah.  What I was getting at was that MySQL on linux is faster than
MySQL on NT. I wasn't comparing MySQL and any other db :)

The missing features are a whole other story that I agree with. It
certainly doesn't compare to a real enterprise level db. But it's great for
smaller linux sites with, say, PHP.

c

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8ckt -  http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD

iQA/AwUBOeIHytaLYehRBGz9EQJ8dQCdFhz6hhZ8gFHJ1t2ti9Au1FunhzwAnifO
m/7hcDwYjvjRfVN+N9lKCCt7
=Xlvw
-END PGP SIGNATURE-


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.