CFLoop timeout

[Richard Brotherton Analyst Programmer IT CS]

Hi,

Is there a way of setting a timeout on a CFLoop?

I have a form that contains a loop, which is waiting for a particular file
to exist (last file in an FTP upload stream).  Because the files that are
being sent to the server via FTP vary in size, the wait time is never the
same.

Problem :- If the file that the loop is looking for never gets to the server
then the loop never stops. The page will timeout, but that does not stop the
loop; and it doesn't take too many loops like this to kill a server.

Thanks

Richard

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

RE: CFLoop timeout

[DeVoil, Nick]

Richard

Why not do a GetTickCount() before the loop starts, then put an extra test
in the WHILE or FOR part of the CFLOOP to check it again.

If the CFLOOP isn't constructed as a WHILE or FOR loop
then you can do the test inside the loop and use .

Although as you say, looping like this does tie up a thread on the server.

HTH
Nick

-Original Message-
From: Richard Brotherton Analyst Programmer IT CS
[mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 10:31 AM
To: CF-Talk
Subject: CFLoop timeout


Hi,

Is there a way of setting a timeout on a CFLoop?

I have a form that contains a loop, which is waiting for a particular file
to exist (last file in an FTP upload stream).  Because the files that are
being sent to the server via FTP vary in size, the wait time is never the
same.

Problem :- If the file that the loop is looking for never gets to the server
then the loop never stops. The page will timeout, but that does not stop the
loop; and it doesn't take too many loops like this to kill a server.

Thanks

Richard


**
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

CF and Cobalt RaQ hosting

[Paul Johnston]

We all know that RaQ hosting is a good idea!  What I want to know is:

1) Has anyone set up CF with a RaQ server and if so which version, RaQ3 or
RaQ4?

2) How good is the hosting on a RaQ? Is it better than on an NT box from the
perspective of stability/speed etc.

3) Does anyone have a HOWTO or something on it? (or would someone like to
write one?)

This is quite urgent, so please can you email the list (or me directly)
asap.

Thanks

Paul



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

RE: padding a variable

[Philip Arnold - ASP]

> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

Help building simply sql query expression

[Paul Sinclair]

I've been struggling with this off and on over the last couple days trying
to figure out how to do some calculations on an MSAccess db. I've looked
through all my sql books but haven't hit on the answer. It is very simple,
but my knowledge of sql is just too limited I'm afraid.

Basic table structure involved is:

tblWinners

ABCName..NOPName..Win
Adam.Nick.abc
Bart.Otto.abc
Caty.Pete.nop
Adam.Nick.abc
Bart.Otto.nop
Caty.Pete.nop
Adam.Nick.nop

I need to figure out the sql query that will run through all records in the
table for each "ABCName" and count the number of times "abc" shows up in the
"Win" column. For the above sample, the query results would be:

Adam - 2
Bart - 1
Caty - 0

Ideally I would like a query that would figure it out for both ABCName and
NOPName (count "abcname" with abc under "win" and "nopname" with nop under
"win") but if this is not easily done, I can run two different queries, one
for each. But if possible I'd like to get query results like this:

Adam - 2
Bart - 1
Caty - 0
Nick - 1
Otto - 1
Pete - 2

Thanks for any help.

Paul Sinclair


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

RE: Help building simply sql query expression

[Ben Forta]

Try this:

SELECT ABCName, COUNT(*) AS num
FROM tblWinners
WHERE Win = 'abc'
GROUP BY ABCName


-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 8:42 AM
To: CF-Talk
Subject: Help building simply sql query expression


I've been struggling with this off and on over the last couple days trying
to figure out how to do some calculations on an MSAccess db. I've looked
through all my sql books but haven't hit on the answer. It is very simple,
but my knowledge of sql is just too limited I'm afraid.

Basic table structure involved is:

tblWinners

ABCName..NOPName..Win
Adam.Nick.abc
Bart.Otto.abc
Caty.Pete.nop
Adam.Nick.abc
Bart.Otto.nop
Caty.Pete.nop
Adam.Nick.nop

I need to figure out the sql query that will run through all records in the
table for each "ABCName" and count the number of times "abc" shows up in the
"Win" column. For the above sample, the query results would be:

Adam - 2
Bart - 1
Caty - 0

Ideally I would like a query that would figure it out for both ABCName and
NOPName (count "abcname" with abc under "win" and "nopname" with nop under
"win") but if this is not easily done, I can run two different queries, one
for each. But if possible I'd like to get query results like this:

Adam - 2
Bart - 1
Caty - 0
Nick - 1
Otto - 1
Pete - 2

Thanks for any help.

Paul Sinclair



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


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

Create Table SQL

[ibtoad]

I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich


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

Uploading Images

[W Luke]

Hi,

I need to allow users to upload images.  Will Access allow images to be
dumped into the database, or do I have to upload to a directory instead?

Thanks

Will


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

CFGRID and security

[Stewart McGowan]

Hi all,

A corporate client is a little nervous about us using the CF Java applets,
can anyone point me to some resources, or does anyone have any views about
their use?

Kind Regards


Stewart

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

RE: Create Table SQL

[Andy Ewings]

To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
..
..
..
)
  
The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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

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

OT: Conference

[Howie Hamlin]

Maybe a stupid question - does anyone know if the curriculum chosen for the
conference will be handed out at the registration or, if not, where we can
get a copy on line?

Thx,

Howie



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

RE: Submitting Form with Javascript in Anchor

[Colin Robinson]

document.forms[index of the form 0 being the first].submit()

or

document.forms.form name.submit()

But 'if your doing that way it's fine !!! :o)

> -Original Message-
> From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]]
> Sent: 03 November 2000 03:25
> To: CF-Talk
> Subject: Submitting Form with Javascript in Anchor
>
>
> I wish to submit the data from a form when the user clicks on a link,
> rather than using a submit button ... isn't this possible in
> Javascript?  If so, can someone tell me the syntax to use in the url?
> thanks.
> --
> __
> _
>   Joseph J. Sanger, M.D.| Phone:
> (212) 263-7410
>   Associate Professor of Clinical Radiology | Fax:
> (212) 263-2039
>   Director, Division of Radiology Informatics   |
>   Co-Director, Division of Nuclear Medicine |
>   Co-Director, Nuclear Cardiology   |
>   New York University School of Medicine|
> [EMAIL PROTECTED]
> __
> _
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]


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

RE: Need help on http Error 405

[Chen, Yung-Chih (CIT)]

hi,
I have add enctype="multipart/form-data"


but I am still getting http Error 405 error, and suggestion

YC

-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 7:02 PM
To: [EMAIL PROTECTED]
Cc: Chen, Yung-Chih (CIT)
Subject: RE: Need help on http Error 405


You need to add "Type=multipart/form-data" to the FORM tag, double check
spelling ;)

Steve

-Original Message-
From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 3:58 PM
To: CF-Talk
Subject: Need help on http Error 405

I have a page allow user to download data in CSV file extension.
it was working at the production server(Unix, netscape web server)
but does not work on my developement server (NT , IIS 4)
here is the code:


when user click submit, it will call download.cfm to download data and open
download.csv with MS Excel.


Is there something I need to do on the Webserver?

any suggestion will be helpful!!

Thanks

YC

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

RE: Uploading Images

[ibtoad]

As far as I know they should go into a directory.
Rich

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:26 AM
To: CF-Talk
Subject: Uploading Images


Hi,

I need to allow users to upload images.  Will Access allow images to be
dumped into the database, or do I have to upload to a directory instead?

Thanks

Will



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


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

Re: Submitting form with Javascript

[Brett Payne-Rhodes]

This is a question I have been wondering about for a while myself...
Thanks to Peter, Rob and David for their contributions, and I have
managed to use the solution on a simple form. But what about a more
complicated form that has three 'submit' buttons; 'Add' 'Update' and
'Delete'? Using the standard 'input type="submit"' method you
differentiate between the buttons by value, but it seems that when using
the javascript solution I don't see the 'button' that was pressed, even
if I name the images. I had a look in Goodman's Javascript Bible but
found little to help - but its a big book and I'll keep looking...

In the meantime, can anyone shed any more light on this please?

Many Thanks,

Brett Payne-Rhodes
B)

"Joseph J. Sanger, M.D." wrote:
> 
> This is simple, but I am not a javascript maven  I wish to submit
> a form by clicking in a link, rather than pressing the submit button.
> Isn't this possible with some javascript function in the URL of the
> anchor?  Could someone remind me what this should look like?  Thanks
> very much.
> --
> 
>Joseph J. Sanger, M.D. |
>Associate Professor of Clinical Radiology  | Phone: (212) 263 - 7410
>Division of Nuclear Medicine   | Fax: (212) 263-7519
>New York University School of Medicine | [EMAIL PROTECTED]
> 
> 
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED]

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

CFLOCK: 4.0.1 and 4.5.1

[Gene Kraybill]

Given the change in parameters and approach, what's the best way to use CFLOCK in 
an app which needs to be able to run under BOTH CF 4.0.1 and 4.5.1?

Gene Kraybill
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net

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

test... disregard

[Jamie Jackson]

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

RE: Create Table SQL

[Andy Ewings]

Sorry my last reply was confusing!.the example I gave was to create the
default and the primary key at the same time as you create the tablenot
afterwards as I suggested!  If you want to do it afterwards here's how

CREATE UNIQUE CLUSTERED INDEX PK_indexname ON tablename(fieldname) - you can
list multiple field names if it is to be a joint primary key

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:23
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
..
..
..
)
  
The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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

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

RE: Conference

[Simon Horwith]

you can go to allaire's site and follow the links to a page that asks for
your username and password... from there you can print ot your schedule... I
don't know if they're handing them out when you resign-in, or not.

~Simon

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:25 AM
To: CF-Talk
Subject: OT: Conference


Maybe a stupid question - does anyone know if the curriculum chosen for the
conference will be handed out at the registration or, if not, where we can
get a copy on line?

Thx,

Howie




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

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

RE: Create Table SQL

[ibtoad]

This isn't working for me and I can't figure out why.  This works:

auction_date   DATE NOT NULL,

however as soon as I ad the Default part

auction_date   DATE NOT NULL   DEFAULT GETDATE(),

I get errors.

Any Ideas,
Rich



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
.
.
.
)

The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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


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

RE: Help building simply sql query expression

[Bob Silverberg]

To get all of your answers in one result set, you can use UNION, like so:

SELECT ABCName, COUNT(*) AS num,'abc' as WinType
FROM tblWinners
WHERE Win = 'abc'
GROUP BY ABCName
union all
SELECT NOPName, COUNT(*) AS num,'nop' as WinType
FROM tblWinners
WHERE Win = 'nop'
GROUP BY NOPName

Bob


-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 8:51 AM
To: CF-Talk
Subject: RE: Help building simply sql query expression


Try this:

SELECT ABCName, COUNT(*) AS num
FROM tblWinners
WHERE Win = 'abc'
GROUP BY ABCName


-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 8:42 AM
To: CF-Talk
Subject: Help building simply sql query expression


I've been struggling with this off and on over the last couple days trying
to figure out how to do some calculations on an MSAccess db. I've looked
through all my sql books but haven't hit on the answer. It is very simple,
but my knowledge of sql is just too limited I'm afraid.

Basic table structure involved is:

tblWinners

ABCName..NOPName..Win
Adam.Nick.abc
Bart.Otto.abc
Caty.Pete.nop
Adam.Nick.abc
Bart.Otto.nop
Caty.Pete.nop
Adam.Nick.nop

I need to figure out the sql query that will run through all records in the
table for each "ABCName" and count the number of times "abc" shows up in the
"Win" column. For the above sample, the query results would be:

Adam - 2
Bart - 1
Caty - 0

Ideally I would like a query that would figure it out for both ABCName and
NOPName (count "abcname" with abc under "win" and "nopname" with nop under
"win") but if this is not easily done, I can run two different queries, one
for each. But if possible I'd like to get query results like this:

Adam - 2
Bart - 1
Caty - 0
Nick - 1
Otto - 1
Pete - 2

Thanks for any help.

Paul Sinclair



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



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


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

RE: Conference

[Top-Link Tech (John Ceci)]

Last year you could get a copy at the conference plus you could make changes
if you wanted to, it was handled first rate in my opinion...

John

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 8:25 AM
To: CF-Talk
Subject: OT: Conference


Maybe a stupid question - does anyone know if the curriculum chosen for the
conference will be handed out at the registration or, if not, where we can
get a copy on line?

Thx,

Howie




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


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

RE: Conference

[Nathan Stanford]

Here is a list of what is available:
http://www.allaire.com/conference/conferenceprogramdetails.cfm

They will give you a class schedule with you sign in on Sunday or Monday.

Nathan
www.cftipsplus.com



> -Original Message-
> From: Howie Hamlin [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 8:25 AM
> To:   CF-Talk
> Subject:  OT: Conference
> 
> Maybe a stupid question - does anyone know if the curriculum chosen for
> the
> conference will be handed out at the registration or, if not, where we can
> get a copy on line?
> 
> Thx,
> 
> Howie
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

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

RE: Uploading Images

[Bob Silverberg]

Just my opinion, but I believe that your performance will be better if you
store the images on disk, rather than putting them into the database.

Bob

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:26 AM
To: CF-Talk
Subject: Uploading Images


Hi,

I need to allow users to upload images.  Will Access allow images to be
dumped into the database, or do I have to upload to a directory instead?

Thanks

Will



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


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

RE: Allaire Tag gallery ???

[Aidan Whitehall]

> It is a problem but the fault is the writer of that tag not 
> Allaire. If
> there is not tag in the zip file you download, and often 
> times there isn't,
> sometimes on the Allaire page for the tag with the 
> developer's name and a
> link for the email address. Try emailing the developer and 
> ask if they have
> docs available or a website.

If you are having problems downloading tags from the Gallery, try retyping
the URL with the letters in the name of the .zip file in lowercase.

I had problems ages ago and seem to remember this triggered the download.


-- 
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

DB2 Driver Issue

[James Taavon]

This is a multi-part message in MIME format.
--59B58CAEC45561D0B6E238B1
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have come across an SQL error in my CF application that has been
determined to be a database driver issue that only occurs on my
production web server. Local web server is Win2k running CF 4.51.
Database back-end is AS/400. I am using Client Access OBDC Driver
(32-bit) to connect to the AS/400 from my local web server. Production
web server is running CF 4.51 on Solaris using DB2 Connect to talk to
the AS/400 and using the DB2 Native Driver that is available. 

The SQL error I am getting is SQL 7008 (REXX variable). The error is
caused when I am updating a table that contains 4 date fields and some
other text fields.

Does anyone have any experience in this area and if so what was done to
resolve the issue. 

Let me know if any part of this message is unclear.
--59B58CAEC45561D0B6E238B1
Content-Type: text/x-vcard; charset=us-ascii;
 name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
 filename="jtaavon.vcf"

begin:vcard 
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom 203;Baltimore;MD;21201;
fn:James Taavon
end:vcard

--59B58CAEC45561D0B6E238B1--


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

RE: Uploading Images

[Philip Arnold - ASP]

> I need to allow users to upload images.  Will Access allow images to be
> dumped into the database, or do I have to upload to a directory instead?

OK, there are reasons why you wouldn't want to store images in a database,
the main one is that when writing a file, NT doesn't actually write a file
for a second or so at time - this means that files won't be available when
the page first displays (which can make some browsers display a broken
graphic)

Also, this would add a bit of disk access on to of the HTML request;
Database to get information,
Check if graphic file exists,
Write graphic file

It would be a lot easier to keep a reference to the graphic in the databse,
then just put that into an 

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: 03 November 2000 14:26
> To: CF-Talk
> Subject: Uploading Images
>
>
> Hi,
>
>
> Thanks
>
> Will
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>



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

RE: Conference

[Philip Arnold - ASP]

> Maybe a stupid question - does anyone know if the curriculum
> chosen for the
> conference will be handed out at the registration or, if not, where we can
> get a copy on line?

I'd also like to know this, as the registration form isn't active any
more...

I was hoping to have it emailed to me before I left for the US (tomorrow
morning)

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

CFX

[Neil Clark]

I have a new CFX tag and to be honest have not played around with them much
other than development - it seems to be working fine on the development
server (which is my stand-alone machine running CF etc..)

but when I try to access the site via a different machine's browser and try
the functionality out it doesn't work ? ;-(  I have registered it via
the IDE but not in the registry; does this matter?

Neil

http://www.mcbdigital.com
--->




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

Re: Uploading Images

[W Luke]

> As far as I know they should go into a directory.
> Rich

Right, as I thought.

Cheers,

Will


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

RE: CFX_PRINTREPORT Problem.

[Nardi, Gaston]

Snif ! Nobody helps me with this !
Gaston.

> -Mensaje original-
> De:   Nardi, Gaston 
> Enviado el:   Viernes 20 de Octubre de 2000 13:51
> Para: CF-Talk (Correo electrónico)
> Asunto:   CFX_PRINTREPORT Problem.
> 
> Hi,
> 
> I'm trying to use CFX_PRINTREPORT to print some Crystal Reports whitin CF,
> but i'm getting "Request Cancel by the user" everytime I load the page.
> 
> I've collected very little information regarding the tag, but as far I can
> see, parameters are passed correctly (printer, port, user, etc.).
> 
> Any ideas ?
> 
> If is out there another tag that would do what I want to do, please let me
> know.
> 
> TIA,
> Gaston.
> 

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

TwoSelectsRelated question

[W Luke]

Hi,

I've used TwoSelectsRelated tag before - but for some reason can't get it
working on another section of my site.  I have a table, locations, with
"County" and "Town" - I've populated one of the select with counties, but
the second isn't being populated.  I think it's probably due to my query,
not having a "where" in it - but I don't understand how I *can* put in a
"where" statement, nor why I'd need one.  Should I create another table with
all the counties in it, and link that to the existing table? If anyone can
work out what I need to, it'd be greatly appreciated (code shown below),

Thanks

Will


  SELECT county,town FROM Locations
  ORDER by county
  

  


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

Re: Submitting form with Javascript

[David Shadovitz]

Brett,

That's no problem.  Add a hidden element to the form, with a name but no
value.  Set the appropriate value in each of the onclick handlers.  The
form's action page should then check the value of the hidden form
element.



Click to submit A
Click to submit B

The action page can check the value of FORM.submitType and act
accordingly.

-David

On Fri, 03 Nov 2000 22:28:50 +0800 Brett Payne-Rhodes <[EMAIL PROTECTED]>
writes:
> This is a question I have been wondering about for a while myself...
> Thanks to Peter, Rob and David for their contributions, and I have
> managed to use the solution on a simple form. But what about a more
> complicated form that has three 'submit' buttons; 'Add' 'Update' and
> 'Delete'? Using the standard 'input type="submit"' method you
> differentiate between the buttons by value, but it seems that when 
> using
> the javascript solution I don't see the 'button' that was pressed, 
> even
> if I name the images. I had a look in Goodman's Javascript Bible but
> found little to help - but its a big book and I'll keep looking...
> 
> In the meantime, can anyone shed any more light on this please?
> 
> Many Thanks,
> 
> Brett Payne-Rhodes
> B)
> 
> "Joseph J. Sanger, M.D." wrote:
> > 
> > This is simple, but I am not a javascript maven  I wish to 
> submit
> > a form by clicking in a link, rather than pressing the submit 
> button.
> > Isn't this possible with some javascript function in the URL of 
> the
> > anchor?  Could someone remind me what this should look like?  
> Thanks
> > very much.


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.

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

Re: Paranoid programming...

[Larry W. Virden]

Re: using CFX's (in any languagE)

It was pointed out to me locally that the problem with doing things in
the CFX is that any app could invoke the CFX, thus defeating the purpose
of putting it into the CFX...

The current hope is that whenever Advanced security becomes available for
ColdFusion Solaris, that will go quite a ways towards resolving the problem.
-- 
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Paranoid programming...

[Zachary Bedell]

> some level at which you trust your software & hardware.  If you can't
> trust your own code,

It's not a matter of trusting code - it's a matter of not trusting hostile
programmers...

Then...  I hate to say it, friend, but you really are screwed  If there
are individuals who meet the following:
1) They have access to your source.
2) They have access to execute their own code on the same server.
3) The have any desire to see what's in the database in question.

It is impossible for you to prevent them from getting in given your
situation.  There's just no way.  You can certainly obfuscate to your
heart's content & make it more difficult, but there is literally nothing you
can do to prevent them from getting at your data.  Even scenarios that store
the DB password off server won't work -- your hostile programmers can get
the code that retrieves that password, they can execute that code for
themselves, and they now have the password.

If the security of the data in question is indeed that important to you
and/or your clients, bosses, etc., then you need another computer.  Setup
another CF machine that access the database and to which your hostile
programmers will have no access.  There's literally nothing else that will
work.  If you're into false senses of security, then you can certainly make
things look nice & secure, but you can't do a thing to stop your programmers
from getting at whatever they want to get at.  I mentioned trusting software
& hardware above, but I did forget to mention the one thing you REALLY need
to be able to trust -- your programmers.  If you can't trust the people that
write your code, then you certainly can't trust the code they write, ya
know?

Sorry to bear bad tidings, but...  Reality has a way of asserting itself at
times. 

Best regards,
Zac Bedell

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

RE: padding a variable

[David Gassner]

The LJustify() function is designed for exactly this purpose:

LJustify(myColumn, 30)

> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 5:23 AM
> To: CF-Talk
> Subject: RE: padding a variable
> 
> 
> > how do you pad a variable in CF.
> > for example how can I force a query.columnname to take up exactly 30
> > characters?
> 
> Just using Left() won't work if you're using variable length fields
> (varchar)
> 
> You could use Left(myColumn & RepeatString(" ", 30), 30)
> 
> HTH
> 
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> 
> "Websites for the real world"
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

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

cfinsert

[Jeremy Toevs]

I was using the following query:


INSERT INTO Users
(First,Last,Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')


But it was giving me an error. None of the fields are numeric, they are all texted 
fields. But when I used the following query:



This one worked, but why didn't they other one?

Jeremy


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

Security hole in basic authorization... Solutions?

[Jamie Jackson]

Say I'm a developer, but not a not a SysAdmin.

It is too easy for me to get an administrator's username/password like
this, using Win2k basic authorization:

Hey, administrator, I'm troubleshooting a template, would you see if
the test passes?:


Test Passed! Thanks, for checking, administrator!

#cgi.auth_user#
#cgi.auth_password#



How do I prevent this from working?

Thanks,
Jamie

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

Re: Strange Access Problem

[Christopher S Martin]

Sure. Here you go.  It looks okay to me, but i may be missing something
blindingly obvious.


  INSERT INTO  tblWebpageTest(WebpageName, Website, Directory);
  VALUES   ('#FileList.Name#', #form.Website#, '#form.PageLocation#');
  WHERE   #FileList.Name# NEQ #qcfGetToCompare.WebpageName#;
  and#form.Website# NEQ #qcfGetToCompare.Website#;
 
Chris Martin
- Original Message -
From: "Vaughan Evans" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 02, 2000 20:29
Subject: Re: Strange Access Problem


> CAn you post your code to the list? It may make things easier.
>
> -Original Message-
> From: Christopher S Martin <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Friday, November 03, 2000 11:23 AM
> Subject: Strange Access Problem
>
>
> >Hey everyone.   I am having a very strange problwem with acces.
Basically,
> >it is asking me for a semicolon afgter each sql statement.  I put them
in,
> >and the semicolon errors go away, but new errors come up.   Anyone know
why
> >access would wnat semi colons?
> >
> >Chris Martin
> >
>
>---
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
> >
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

RE: Submitting form with Javascript

[Doyle, Mike]

Brett,

If I read your email correctly, then you can alter the action of your three
javasript-fired links two ways.  First, you could fire different JS
functions, located in the head of your template, according to the link like
this:

Add
Update
Delete

Or, you could submit the form, use the parameters passed by the different
links, and depend on conditional evaluations within your action page to
determine which action to invoke.

Mike

"Those are my principles.  If you don't like them, I have others."  -Groucho
Marx


-Original Message-
From: Brett Payne-Rhodes [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:29 AM
To: CF-Talk
Subject: Re: Submitting form with Javascript


This is a question I have been wondering about for a while myself...
Thanks to Peter, Rob and David for their contributions, and I have
managed to use the solution on a simple form. But what about a more
complicated form that has three 'submit' buttons; 'Add' 'Update' and
'Delete'? Using the standard 'input type="submit"' method you
differentiate between the buttons by value, but it seems that when using
the javascript solution I don't see the 'button' that was pressed, even
if I name the images. I had a look in Goodman's Javascript Bible but
found little to help - but its a big book and I'll keep looking...

In the meantime, can anyone shed any more light on this please?

Many Thanks,

Brett Payne-Rhodes
B)

"Joseph J. Sanger, M.D." wrote:
> 
> This is simple, but I am not a javascript maven  I wish to submit
> a form by clicking in a link, rather than pressing the submit button.
> Isn't this possible with some javascript function in the URL of the
> anchor?  Could someone remind me what this should look like?  Thanks
> very much.
> --
> 
>Joseph J. Sanger, M.D. |
>Associate Professor of Clinical Radiology  | Phone: (212) 263 - 7410
>Division of Nuclear Medicine   | Fax: (212) 263-7519
>New York University School of Medicine | [EMAIL PROTECTED]
> 
>


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


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

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

Re: [RE: padding a variable]

[Alex]

how do i get it to show 30 characters without the browser truncating spaces

"Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote:
> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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



Get free email and a permanent address at http://www.netaddress.com/?N=1

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

Re: Create Table SQL

[Joseph Thompson]

In Access setting  type to "counter" works as an autonumber as well

CREATE TABLE People(
ID COUNTER,
First Char(50) not null,
Last Char(50) not null 
) 


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

RE: Create Table SQL

[Andy Ewings]

Are you using SQL Server?if so neither will work as Date is not a valid
type.  Replace it with Datetime and it'll work

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:55
To: CF-Talk
Subject: RE: Create Table SQL


This isn't working for me and I can't figure out why.  This works:

auction_date   DATE NOT NULL,

however as soon as I ad the Default part

auction_date   DATE NOT NULL   DEFAULT GETDATE(),

I get errors.

Any Ideas,
Rich



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
.
.
.
)

The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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



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

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

RE: Create Table SQL

[Andy Ewings]

Sorry...didn't read your initial mail properly.  If you are using access you
are quite right to use Date.  Replace the function GETDATE() with NOW() for
the default and see what happens

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:55
To: CF-Talk
Subject: RE: Create Table SQL


This isn't working for me and I can't figure out why.  This works:

auction_date   DATE NOT NULL,

however as soon as I ad the Default part

auction_date   DATE NOT NULL   DEFAULT GETDATE(),

I get errors.

Any Ideas,
Rich



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
.
.
.
)

The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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



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

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

Re: Submitting form with Javascript

[Craig Bowes]

I'm not sure I understand.  Are you using form buttons or images as form
butons or just plain images as links.  Are you saying that on the next page
it doesn't give the submit value of which button the user clicked?


-Craig Bowes
Coldfusion Programmer
[EMAIL PROTECTED]
972.243.1171


- Original Message -
From: "Brett Payne-Rhodes" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 8:28 AM
Subject: Re: Submitting form with Javascript


> This is a question I have been wondering about for a while myself...
> Thanks to Peter, Rob and David for their contributions, and I have
> managed to use the solution on a simple form. But what about a more
> complicated form that has three 'submit' buttons; 'Add' 'Update' and
> 'Delete'? Using the standard 'input type="submit"' method you
> differentiate between the buttons by value, but it seems that when using
> the javascript solution I don't see the 'button' that was pressed, even
> if I name the images. I had a look in Goodman's Javascript Bible but
> found little to help - but its a big book and I'll keep looking...
>
> In the meantime, can anyone shed any more light on this please?
>
> Many Thanks,
>
> Brett Payne-Rhodes
> B)
>
> "Joseph J. Sanger, M.D." wrote:
> >
> > This is simple, but I am not a javascript maven  I wish to submit
> > a form by clicking in a link, rather than pressing the submit button.
> > Isn't this possible with some javascript function in the URL of the
> > anchor?  Could someone remind me what this should look like?  Thanks
> > very much.
> > --
> > 
> >Joseph J. Sanger, M.D. |
> >Associate Professor of Clinical Radiology  | Phone: (212) 263 - 7410
> >Division of Nuclear Medicine   | Fax: (212) 263-7519
> >New York University School of Medicine |
[EMAIL PROTECTED]
> > 
>
> --
--
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

RE: Create Table SQL

[ibtoad]

This is a multi-part message in MIME format.

--=_NextPart_000__01C0458B.5EE2DAB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

OK here is what I have so far:

CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEXT(40) NOT NULL,
category   TEXT(10) NOT NULL,
quant  TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration   TEXT(2)  NOT NULL,
auction_id TEXT(25) NOT NULL,
title  TEXT(45) NOT NULL,
auction_date   DATE NOT NULL,
ebaybidareaMEMO NOT NULL
);

This creates a table for the user with 10 fields.  However I still have 2
problems.
1) The Primary Key is not set to auto number, how can I set this? Should I
be using something in place of TEXT(40) I tried using AutoNumber but that
returned errors.

2) I can't get the auction_date field to work.  If I add the DEFAULT Date()
to the SQL statement I get errors.

Thanks,
Rich

--=_NextPart_000__01C0458B.5EE2DAB0
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"

eJ8+IgYQAQaQCAAEAAABAAEAAQeQBgAI5AQAAADoAAEIgAcAGElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAgACAAEGgAMADgAAANAHCwADAAsALAUAIQEB
A5AGAPwGAAAlCwACAAELACMAAAMAJgAACwApAAADADYAAB4AcAAB
FQAAAFJFOiBDcmVhdGUgVGFibGUgU1FMAAIBcQABFgHARbVFxlHiaAhYm02M
rFWE3byy24EAAAIBHQwBGFNNVFA6SUJUT0FEQFBVTktBU1MuQ09NAAsAAQ4AQAAG
DgAIFUS1RcABAgEKDgEYANaQ1++mswRGj2g2rkmyT1nCgAAACwAfDgECAQkQ
AQAAAI4CAACKAgAA9QMAAExaRnUvQwIcAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj
aArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYA5jAFALAwu1IE9LIJJoBJBlIAQAIHcQ8CUFQEkT
8GF2FDBzb3QgZgrAOgqiCoQKgEOAUkVBVEUgVAGgMmwUMCN1ESAFEGQjxRW0KBW0SUQgGLoWsEBY
VCg0MCkHsE8CVAewVUxMIFBSAElNQVJZIEtFfFksFbQXVBj/GgcbVWPpFKBlZwWweRxKD0AdL3xx
dQBwBUAcLB9/CoBz6wGQACBwBRBjFDAhXx2JtmQIcBSgaQIgHEoyGfBtHT5hEsAlwl8cBSZ0NXsk
fyXAdBcRHC0pTyfnZDseQRixRBaiGLIdTWVimGF5YheQCsBlYRiyME1FTU8aBxW0KTv5FbpUaBRR
BQAv0B5QBCBfL+ABkRcRAhAFwHQUACDnF1IUcCpwaCAPQBVgCJAQbGRzLhiwSG93/mUVEAXAFNAj
EAMQAyAU89QyICNgbxcBbTUwFbTuMRnwMkAUMFAFEADAHpHMS2UeoBRRbm8FQBEhzzMgFVAn8Dmx
bnUG0ASQ/iwT8DWAMoADkTXxOYIyUfY/BgA6sHU1EBTBOmA0Af0LgGcVMQeAO5E84QuANtCzC2Aj
kW9mHKgU0HQIgescEDy0QTnxTjpDPHA58KszwRShIAlwdAhwbj9R/wSQA2AREDdlFbQmwRTQOvH6
JwVAZztjFDAs2zTjOaJqdwWwazVBST5QFNBhhmRFMTPhREVGQRpgdRowRB5BKBnwObEz0lP+URqA
IxEeUAeAINEU0EOip0HPMiIAcGtzG1VSDeAWaBW0EeEATEsAAYAIIAYAAMBG
AAOFAwADgAggBgAAwEYAEIUDAAeACCAGAADA
RgBShQAAJ2oBAB4ACYAIIAYAAMBGAFSFAAABBDku
MAAeAAqACCAGAADARgA2hQAAAQEAHgALgAggBgAAwAAA
AEYAN4UAAAEBAB4ADIAIIAYAAMBGADiFAAAB
AQALAA2ACCAGAADARgCChQAAAQsAOoAIIAYAAMAA
AABGAA6FAwA8gAggBgAAwEYAEYUDAD2ACCAG
AADARgAYhQsAW4AIIAYAAMBGAAaFAwBc
gAggBgAAwEYAAYUCAfgPAQAAABDWkNfvprMERo9oNq5Jsk9Z
AgH6DwEQ1pDX76azBEaPaDauSbJPWQIB+w8BnwA4obsQBeUQGqG7CAAr
KlbCAABQU1RQUlguRExMAABOSVRB+b+4AQCqADfZbgAAAEQ6XERvY3VtZW50cyBhbmQg
U2V0dGluZ3NcQWRtaW5pc3RyYXRvclxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1p
Y3Jvc29mdFxPdXRsb29rXG91dGxvb2sucHN0AAADAP4PBQMADTT9NwAAAgF/AAEy
PEFFRUdJUEdJT0FET0pPRk5PSk9LTUVEUENCQUEuaWJ0b2FkQHB1bmthc3MuY29tPgMABhBk
gH7wAwAHED0CAAADABAQAAMAERAAHgAIEAEAAABlT0tIRVJFSVNXSEFUSUhBVkVT
T0ZBUjpDUkVBVEVUQUJMRSNVU0VSSUQjKElEVEVYVCg0MClOT1ROVUxMUFJJTUFSWUtFWSxVU0VS
SURURVhUKDQwKU5PVE5VTEwsQ0FURUdPUgB3lQ==

--=_NextPart_000__01C0458B.5EE2DAB0--


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

RE: Create Table SQL

[Bob Silverberg]

This is just a stab in the dark, but that SQL looks an awful lot like the
SQL you use in SQL Server.  Does it also work in Access (which Rich is
using) or is there an alternate syntax?

Bob

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:55 AM
To: CF-Talk
Subject: RE: Create Table SQL


This isn't working for me and I can't figure out why.  This works:

auction_date   DATE NOT NULL,

however as soon as I ad the Default part

auction_date   DATE NOT NULL   DEFAULT GETDATE(),

I get errors.

Any Ideas,
Rich



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
.
.
.
)

The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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



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


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

RE: Conference

[Philip Arnold - ASP]

> you can go to allaire's site and follow the links to a page that asks for
> your username and password... from there you can print ot your
> schedule... I
> don't know if they're handing them out when you resign-in, or not.

Where abouts on the site is this?
I've been to just about every one of their pages and can't find the login to
get my schedule...

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

Re: TwoSelectsRelated question

[W Luke]

Update:

I swapped a few things round, and have got it working somehow.  Yet, for
some unknown reason, when I choose something from the second list and click
submit it's not submitting what I asked it to.  I clicked on "Reading," and
it submitted "Windsor."  Why's that happening!?

Thanks

Will

- Original Message -
From: "W Luke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 3:59 PM
Subject: TwoSelectsRelated question


> Hi,
>
> I've used TwoSelectsRelated tag before - but for some reason can't get it
> working on another section of my site.  I have a table, locations, with
> "County" and "Town" - I've populated one of the select with counties, but
> the second isn't being populated.  I think it's probably due to my query,
> not having a "where" in it - but I don't understand how I *can* put in a
> "where" statement, nor why I'd need one.  Should I create another table
with
> all the counties in it, and link that to the existing table? If anyone can
> work out what I need to, it'd be greatly appreciated (code shown below),
>
> Thanks
>
> Will
>
> 
>   SELECT county,town FROM Locations
>   ORDER by county
>   
>
> QUERY="findcats"
>  NAME1="thecounty"
>  NAME2="thetown"
>  DISPLAY1="county"
>  DISPLAY2="town"
>  VALUE1="county"
>  VALUE2="town"
>  FORCEWIDTH1="70"
>  FORCEWIDTH2="70"
>  SIZE1="1"
>  SIZE2="1"
>  HTMLBETWEEN=""
>  AUTOSELECTFIRST="Yes"
>  EMPTYTEXT1="(choose a county)"
>  EMPTYTEXT2="(now choose a town)"
>  ONCHANGE=""
>  FORMNAME="MyOtherForm">
>


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

removing character from a variable

[Brian bouldernet]

I'm trying to take a variable item1
and remove the first 10 characters... Should I get the length subtract 11
and go right of that?

-Brian



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

RE: Submitting form with Javascript

[David Gassner]

Add a hidden field to the form; have each of the links set the value of the
field to something you can check from within the action page.

> -Original Message-
> From: Brett Payne-Rhodes [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 6:29 AM
> To: CF-Talk
> Subject: Re: Submitting form with Javascript
>
>
> This is a question I have been wondering about for a while myself...
> Thanks to Peter, Rob and David for their contributions, and I have
> managed to use the solution on a simple form. But what about a more
> complicated form that has three 'submit' buttons; 'Add' 'Update' and
> 'Delete'? Using the standard 'input type="submit"' method you
> differentiate between the buttons by value, but it seems that when using
> the javascript solution I don't see the 'button' that was pressed, even
> if I name the images. I had a look in Goodman's Javascript Bible but
> found little to help - but its a big book and I'll keep looking...
>
> In the meantime, can anyone shed any more light on this please?
>
> Many Thanks,
>
> Brett Payne-Rhodes
> B)
>
> "Joseph J. Sanger, M.D." wrote:
> >
> > This is simple, but I am not a javascript maven  I wish to submit
> > a form by clicking in a link, rather than pressing the submit button.
> > Isn't this possible with some javascript function in the URL of the
> > anchor?  Could someone remind me what this should look like?  Thanks
> > very much.
> > --
> > 
> >Joseph J. Sanger, M.D. |
> >Associate Professor of Clinical Radiology  | Phone: (212) 263 - 7410
> >Division of Nuclear Medicine   | Fax: (212) 263-7519
> >New York University School of Medicine |
> [EMAIL PROTECTED]
> > 
> >
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]


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


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

stripping all white space, CR, Tab and put into one line

[thanh nguyen]

hello everyone,
I have a textarea box asking user to type in and, sometimes user types 
carriage return, tab, new line, then I  insert it into sql server, when I 
retrieve the information and want to write it into a text file. sometimes if 
the user did not hit any return key or tab, so i write into text file it is 
on coutinous one line, if the user  hit return key or tab  then the text 
file show the multiple rows of characters,
what I want to do now is some how in one coutinous line without tab or 
Carriage Return character.I have use StripCF() but it did not work

thanks for any suggestion


_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Submitting form with Javascript

[CAlvarado]

I prefer to do it using this function rather than submitting the entire form
to the action stated in the form tag. Mainly because I may have multiple
submits per pages submitting to various pages

function FunctionName() {
document.forms[0].action="SomeFile.cfm";
document.forms[0].method="Post";
document.forms[0].submit();
}

'forms[0]' will find the first instance of a form where as
'document.formname' will find whatever form you wish to submit.

then the link will need to state

Link

hope this helps,

chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 10:03 AM
To: CF-Talk
Subject: Re: Submitting form with Javascript


Brett,

That's no problem.  Add a hidden element to the form, with a name but no
value.  Set the appropriate value in each of the onclick handlers.  The
form's action page should then check the value of the hidden form
element.



Click to submit A
Click to submit B

The action page can check the value of FORM.submitType and act
accordingly.

-David

On Fri, 03 Nov 2000 22:28:50 +0800 Brett Payne-Rhodes <[EMAIL PROTECTED]>
writes:
> This is a question I have been wondering about for a while myself...
> Thanks to Peter, Rob and David for their contributions, and I have
> managed to use the solution on a simple form. But what about a more
> complicated form that has three 'submit' buttons; 'Add' 'Update' and
> 'Delete'? Using the standard 'input type="submit"' method you
> differentiate between the buttons by value, but it seems that when 
> using
> the javascript solution I don't see the 'button' that was pressed, 
> even
> if I name the images. I had a look in Goodman's Javascript Bible but
> found little to help - but its a big book and I'll keep looking...
> 
> In the meantime, can anyone shed any more light on this please?
> 
> Many Thanks,
> 
> Brett Payne-Rhodes
> B)
> 
> "Joseph J. Sanger, M.D." wrote:
> > 
> > This is simple, but I am not a javascript maven  I wish to 
> submit
> > a form by clicking in a link, rather than pressing the submit 
> button.
> > Isn't this possible with some javascript function in the URL of 
> the
> > anchor?  Could someone remind me what this should look like?  
> Thanks
> > very much.


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.


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

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

RE: Unicode in CF

[Mark Johnson]

Lou,

We have done this.  www.unboundbible.org  many of the bible translations are
in unicode format.  Chinese, Korean, Japanese, etc.  Backend is SQL Server
7.0.  The text is stored in the db in UTF8  everything has worked great.

A couple of issues:
JavaScript doesn't handle UTF8 so if you are using CF in combination with
JavaScript you will have problems.

Also  just be careful with any text parsing you are doing.  We had problems
with some custom tags like  in the way they remove spaces
and other characters that are actually part of an encoding pair.

>From my experience your biggest issue will not be CF it will be the
browsers.  We are making our site available to IE, Netscape for both the PC
and the MAC.  Every combination of platform and browser seemed to handle the
encodings differently. However if you have a more limitted audience things
should go well.

If you have any more specific questions feel free to ask me off the list.

Good Luck,
Mark

-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 12:24 AM
To: CF-Talk
Subject: Re: Unicode in CF


Let me know if you find any info. We may be doing something similar.

David Cummins

Lou Pizzolatto wrote:
>
> Hi.
> I was wondering if any one had any experience using utf-8 or other
multibyte
> character transfer encodings in cold fusion.  We are currently looking
into
> changing our software to handle Chinese , simplified Chinese , Korean and
> Japanese characters. We are basically set up to use cold fusion for both
> presentation and proxying to servlets for external system calls.
>
> If anybody knows of any cold fusion 118n lists or working groups. Or
anyone
> has any warnings/hints/suggestions of successfully or unsuccessfully using
> Unicode and cold fusion we would be interested in hearing from you.
>
> --Thanks


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


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

RE: Uploading Images

[Jaime Garza]

Security problems:

Probably you are not at the point yet, but imagine that you upload an image
to a server. It has to go into a directory that can be reached via http so
that it can be displayed, right?  In some sites they let you do that.  Now,
just imagine a user uploads a cfm or a pl file instead of an image.  What
you get is a new template that could be executed in the server!  With that
they can do anything else, like list your directories, change files, access
your databases, etc.

Make sure that when you have such a mechanism you do some checking.  i.e.
only accept image files, etc.  Also the execute access could be removed from
that directory.



> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 7:54 AM
> To: CF-Talk
> Subject: Re: Uploading Images
>
>
>
> > As far as I know they should go into a directory.
> > Rich
>
> Right, as I thought.
>
> Cheers,
>
> Will
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: padding a variable

[Chapman, Katrina]

That's not the queston boys.  He's not asking how to limit it to 30 but how
to force it up to 30.  IE I have a string that's only 22 chars long I need
it to be thirty.

Try this



#foo# - #len(foo)#











#foo# - #len(foo)#


Of course you can replace the @ with whatever char you want to use.

--K

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:23 AM
To: CF-Talk
Subject: RE: padding a variable


> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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

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

Re: [RE: padding a variable] " "

[Alex]

spaces get truncated. that is my problem

"David Gassner" <[EMAIL PROTECTED]> wrote:
The LJustify() function is designed for exactly this purpose:

LJustify(myColumn, 30)

> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 5:23 AM
> To: CF-Talk
> Subject: RE: padding a variable
> 
> 
> > how do you pad a variable in CF.
> > for example how can I force a query.columnname to take up exactly 30
> > characters?
> 
> Just using Left() won't work if you're using variable length fields
> (varchar)
> 
> You could use Left(myColumn & RepeatString(" ", 30), 30)
> 
> HTH
> 
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> 
> "Websites for the real world"
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

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



Get free email and a permanent address at http://www.netaddress.com/?N=1

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

RE: Strange Access Problem

[Andy Ewings]

I may be well off the mark as I haven't coded SQL for Access but just a
couple of points..

IS NEQ a valid SQL function in Access?I would have used <>.

You definitey shouldn't need semin colons after each statement (as far as I
know!)

If you are at a complete loss try to change the names of your fields to make
sure that 'Directory' or 'Website' aren't reserved words.  Although CF
doesn't parse the SQL it might object to something?

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Christopher S Martin [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 16:23
To: CF-Talk
Subject: Re: Strange Access Problem


Sure. Here you go.  It looks okay to me, but i may be missing something
blindingly obvious.


  INSERT INTO  tblWebpageTest(WebpageName, Website, Directory);
  VALUES   ('#FileList.Name#', #form.Website#, '#form.PageLocation#');
  WHERE   #FileList.Name# NEQ #qcfGetToCompare.WebpageName#;
  and#form.Website# NEQ #qcfGetToCompare.Website#;
 
Chris Martin
- Original Message -
From: "Vaughan Evans" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 02, 2000 20:29
Subject: Re: Strange Access Problem


> CAn you post your code to the list? It may make things easier.
>
> -Original Message-
> From: Christopher S Martin <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Friday, November 03, 2000 11:23 AM
> Subject: Strange Access Problem
>
>
> >Hey everyone.   I am having a very strange problwem with acces.
Basically,
> >it is asking me for a semicolon afgter each sql statement.  I put them
in,
> >and the semicolon errors go away, but new errors come up.   Anyone know
why
> >access would wnat semi colons?
> >
> >Chris Martin
> >
>
>---
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
> >
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



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

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

RE: CFHEADER

[Hoffman, Joe (CIT)]

Maybe this will do?

">
will process as


That is for expire only ... not no cache.

Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 2:39 PM
To: CF-Talk
Subject: CFHEADER


This is a multi-part message in MIME format.

--=_NextPart_000__01C043F8.607059A0
Content-Type: multipart/alternative;
boundary="=_NextPart_001_0001_01C043F8.60798160"


--=_NextPart_001_0001_01C043F8.60798160
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Has anyone used CFHEADER to make a page expire? I've tried several settings
with no luck.

What I'm trying to do is make so when someone logs out of a page and then
uses the BACK feature in their browser, that page is no longer available.

Thanks!

--Dylan

  bromby.com

  web & wireless consulting  dylan bromby

e [EMAIL PROTECTED]
m 949 400 6333
f 707 220 2964
  co-author wap development with wml & wmlscript



--=_NextPart_001_0001_01C043F8.60798160
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable






Has =
anyone used=20
CFHEADER to make a page expire? I've tried several settings with no =
luck.=20

 
What =
I'm trying to=20
do is make so when someone logs out of a page and then uses the BACK =
feature in=20
their browser, that page is no longer available.
 
Thanks!
 
--Dylan
 

  
  

  bromby.com web & wireless consulting=20
  
dylan bromby 
  


  e
  [EMAIL PROTECTED]

  m
  949 400=20
6333

  f
  707 220=20
2964co-author wap =
development with wml=20
  & wmlscript 
 

--=_NextPart_001_0001_01C043F8.60798160--

--=_NextPart_000__01C043F8.607059A0
Content-Type: text/x-vcard;
name="Dylan Bromby.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Dylan Bromby.vcf"

BEGIN:VCARD
VERSION:2.1
N:Bromby;Dylan
FN:Dylan Bromby
ORG:bromby.com
TEL;WORK;VOICE:(949) 400-6333
TEL;WORK;FAX:(707) 220-2964
URL:
URL:http://www.bromby.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20001026T145402Z
END:VCARD

--=_NextPart_000__01C043F8.607059A0--



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

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

can CF figure out user platform??

[S R]

Hi,

I have a problem with some of my pages 'font sizes' appearing differently 
across platforms. For example a 'font size' of 1 on a windows machine is 
unreadable on a linux machine. I was thinking if when this problem page is 
loaded it could figure out what platform the user has and I can dynamically 
specify the font size like that. Is there any function or tag that you know 
of that can find out this info?

thanks

Sal
_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Need help on http Error 405

[David Gassner]

Error 405 means that IIS doesn't understand the requests's file extension
and can't properly dispatch it to the ColdFusion server.  Your action
attribute implies a file extension ".cfm/download.csv" which is meaningless
to the web server.

If you want the user to be able to download a file called download.csv, just
call the download.cfm page; in that page, include the commands:




where the file is the complete path and filename in the server file system.

Also, note that the ENCTYPE attribute in the form is for uploading a file,
not downloading one.

> -Original Message-
> From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 6:32 AM
> To: CF-Talk
> Subject: RE: Need help on http Error 405
>
>
> hi,
> I have add enctype="multipart/form-data"
>  enctype="multipart/form-data" onSubmit="return ck_submit();"
> onReset="clear_lists();">
>
> but I am still getting http Error 405 error, and suggestion
>
> YC
>
> -Original Message-
> From: Steve Bernard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 7:02 PM
> To: [EMAIL PROTECTED]
> Cc: Chen, Yung-Chih (CIT)
> Subject: RE: Need help on http Error 405
>
>
> You need to add "Type=multipart/form-data" to the FORM tag, double check
> spelling ;)
>
> Steve
>
> -Original Message-
> From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 3:58 PM
> To: CF-Talk
> Subject: Need help on http Error 405
>
> I have a page allow user to download data in CSV file extension.
> it was working at the production server(Unix, netscape web server)
> but does not work on my developement server (NT , IIS 4)
> here is the code:
> 
>
> when user click submit, it will call download.cfm to download
> data and open
> download.csv with MS Excel.
>
>
> Is there something I need to do on the Webserver?
>
> any suggestion will be helpful!!
>
> Thanks
>
> YC
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

OT: Security issue

[Brian L. Wolfsohn]

Last night, one of our machines was "hacked"..  we're looking into how, but 
what we've been able to discover so far, is that the I_USE and I_WAM 
accounts were locked out, so all the websites were, in effect, useless at 
that point.

It was explained to me that the I_USE and I_WAM accounts could have been 
locked out through the web when someone tried to access a protected 
directory, and got the basic windows username & password box.  If 
I_USR_MACHINENAME is entered with an incorrect password n times, the 
account would get locked out. same for I_WAM.

While i understand about accounts being locked out, it doesn't make sense 
to me that i haven't head about this before.  it would seem to be a major 
security issue if someone could use a browser to access a protected 
directory, or even easier, use FTP to try and access the domain, and put in 
I_USR_ETC as the user and lock the account out by entering bad passwords 
that way.


Have any of you experienced this ??  does this make any sense ??  Does 
anyone have any suggestions about how to best prevent this ??

This seems like a very easy, and major, albeit easy to fix (nothing else 
appeared to have been compromised, except these 2 accounts), with minimal 
damage, security problem.



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

RE: [RE: padding a variable]

[Hayes, David]

To do that, you'll have to replace the spaces with " " to generate
non-breaking spaces for the browser. 

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 10:24 AM
To: CF-Talk
Subject: Re: [RE: padding a variable]


how do i get it to show 30 characters without the browser truncating spaces

"Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote:
> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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



Get free email and a permanent address at http://www.netaddress.com/?N=1


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

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

RE: cfinsert

[David Gassner]

You might be having problems field names using SQL reserved words.  Try
enclosing all the field names in brackets:


INSERT INTO Users
([First],[Last],Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')


> -Original Message-
> From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 8:14 AM
> To: CF-Talk
> Subject: cfinsert
>
>
> I was using the following query:
>
> 
> INSERT INTO Users
> (First,Last,Ride,Fav_Place)
> VALUES('#First#','#Last#','#Ride#','#Fav_Place#')
> 
>
> But it was giving me an error. None of the fields are numeric,
> they are all texted fields. But when I used the following query:
>
> 
>
> This one worked, but why didn't they other one?
>
> Jeremy
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: CF Server log error???

[Hoffman, Joe (CIT)]

>From the command line:

net helpmsg 109
The pipe has been ended.

Or should be in the resource kit.

Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 9:30 AM
To: CF-Talk
Subject: CF Server log error???



Hello all,
  I am getting a this error in ColdFusion server log
file(Server.Log). 
"Windows NT error number 109 occurred"

Does anyone know what this error is and how i can rectify this
problem.

Appretiate any help.

Thanks
Joe

-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!



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

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

RE: Create Table SQL

[ibtoad]

OK here is what I have so far:

CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEXT(40) NOT NULL,
category   TEXT(10) NOT NULL,
quant  TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration   TEXT(2)  NOT NULL,
auction_id TEXT(25) NOT NULL,
title  TEXT(45) NOT NULL,
auction_date   DATE NOT NULL,
ebaybidareaMEMO NOT NULL
);

This creates a table for the user with 10 fields.  However I still have 2
problems.
1) The Primary Key is not set to auto number, how can I set this? Should I
be using something in place of TEXT(40) I tried using AutoNumber but that
returned errors.

2) I can't get the auction_date field to work.  If I add the DEFAULT Date()
to the SQL statement I get errors.

Thanks,
Rich


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

Re: Drop down List

[monika kon]

--0-2049339050-973275290=:67150
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline


Hi James and Vaughan Evans!
Thanks a lot for ur reply.
I am now stuck in the query.Please help me.I am 
sending the code as well as the database in excel as
an attachment.I have placed TwoSelectsRelated.cfm in
the folder CFUSION.But my query is not giving me the
proper values.
++

select MnGrp,
MnGrp_Desc,ProductType,ProductType_Desc,
from Global
where MnGrp=Left([ProductType],1)

 
 
 Calling Cusstom Tag below (I have mine in a table)
 
Name:Email:



 
+++
--- James Taavon <[EMAIL PROTECTED]> wrote:
> This is a multi-part message in MIME format.
> --E6147946B6907CB6F06EC99E
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> 
> You place the Tag in your Custom Tag folder under
> CFUSION and then call
> the tag from your cfm file.
> 
> 
> My QUERY:
> 
> 
>   select name, address
>   from oimdbadm.assignee
>   where manager = 'Hub'
> 
> 
> 
> Calling Cusstom Tag below (I have mine in a table)
> 
>size="2">Name:Email:
>   
>  query="GetPerson"
>   name1="assigned"
>   name2="address"
>   display1="name"
>   display2="address"
>   htmlbetween=""
>   size1="1"
>   size2="1">
>size="2">Date:
>size="2">#DateFormat(getassignment.date,
> "mm/dd/")#
> 
> 
> 
> 
> monika kon wrote:
> > 
> > Thanks a lot for considering my problem.
> > I found  on the site
> > http://nateweiss.com/taggallery/
> > but one more question where do I run the query.I
> went
> > through the CF program but no where CFQUERY has
> been
> > run.Please explain..
> > 
> > --- James Taavon <[EMAIL PROTECTED]> wrote:
> > > This is a multi-part message in MIME format.
> > > --79B146EDDC6C8F75FF1B27F5
> > > Content-Type: text/plain; charset=us-ascii
> > > Content-Transfer-Encoding: 7bit
> > >
> > > You can find the custom tag at
> > >
> > >
> > > monika kon wrote:
> > > >
> > > > Please tell me where I can find this custom
> tag.
> > > > Secondly how am I suppose to use Java script
> ,as I
> > > > don't know much of it.
> > > > If I use onchange() of javascript ,I will have
> to
> > > call
> > > > javascript coe in it.
> > > > Please help..
> > > > --- Vaughan Evans <[EMAIL PROTECTED]>
> > > wrote:
> > > > >
> > > > > There is a custom tag called
> twoSelectsRelated
> > > that
> > > > > may be of help.
> > > > >
> > > > >
> > > > > >
> > > > > >Hi every one,
> > > > > >I have 2 drop down lists ,the first one has
> > > options
> > > > > >which are hard coded.
> > > > > >When the user selects one of these options
> from
> > > the
> > > > > >first dropdown list  then the second
> dropdown
> > > list
> > > > > >gets populated from the database
> accordingly.I
> > > want
> > > > > >this to happen in the same template.
> > > > > >Please help>
> > > > > >
> > > > > >Shally
> > > > > >
> > > > >
> > >
> >__
> > > > > >Do You Yahoo!?
> > > > > >Yahoo! Messenger - Talk while you surf! 
> It's
> > > FREE.
> > > > > >http://im.yahoo.com/
> > > > >
> > > >
> > >
> >
>
>---
> > > > > -
> > > > > >Archives:
> > > > >
> > > >
> > >
> >
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > > >Unsubscribe:
> > > > >
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists
> > > > > or send a
> > > > > message with 'unsubscribe' in the body to
> > > > > [EMAIL PROTECTED]
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>

> > > > > Archives:
> > > > >
> > > >
> > >
> >
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > > Unsubscribe:
> > > > >
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists
> > > > > or send a message with 'unsubscribe' in the
> body
> > > to
> > > > [EMAIL PROTECTED]
> > > >
> > > >
> __
> > > > Do You Yahoo!?
> > > > Yahoo! Messenger - Talk while you surf!  It's
> > > FREE.
> > > > http://im.yahoo.com/
> > > >
> > >
> >
>

> > > > Archives:
> > >
> >
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > Unsubscribe:
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists
> > > or send a message with 'unsubscribe' in the body
> to
> > > [EMAIL PROTECTED]
> > > --79B146EDDC6C8F75FF1B27F5
> > > Content-Type: text/x-vcard; charset=us-ascii;
> > >  name="jtaavon.vcf"
> > > Content-Transfer-Encoding: 7bit
> > > Content-Description: Card for James Taavon
> > > Content-Disposition: attachment;
> > >  filename="jtaavon.v

RE: Create Table SQL

[Andy Ewings]

1) Try using counter as the datatype for the field you want to be autonumber

2)  Puzzling meI'll have a think!!

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 16:44
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Create Table SQL


This is a multi-part message in MIME format.

--=_NextPart_000__01C0458B.5EE2DAB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

OK here is what I have so far:

CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEXT(40) NOT NULL,
category   TEXT(10) NOT NULL,
quant  TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration   TEXT(2)  NOT NULL,
auction_id TEXT(25) NOT NULL,
title  TEXT(45) NOT NULL,
auction_date   DATE NOT NULL,
ebaybidareaMEMO NOT NULL
);

This creates a table for the user with 10 fields.  However I still have 2
problems.
1) The Primary Key is not set to auto number, how can I set this? Should I
be using something in place of TEXT(40) I tried using AutoNumber but that
returned errors.

2) I can't get the auction_date field to work.  If I add the DEFAULT Date()
to the SQL statement I get errors.

Thanks,
Rich

--=_NextPart_000__01C0458B.5EE2DAB0
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"

eJ8+IgYQAQaQCAAEAAABAAEAAQeQBgAI5AQAAADoAAEIgAcAGElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAgACAAEGgAMADgAAANAHCwADAAsALAUAIQEB
A5AGAPwGAAAlCwACAAELACMAAAMAJgAACwApAAADADYAAB4AcAAB
FQAAAFJFOiBDcmVhdGUgVGFibGUgU1FMAAIBcQABFgHARbVFxlHiaAhYm02M
rFWE3byy24EAAAIBHQwBGFNNVFA6SUJUT0FEQFBVTktBU1MuQ09NAAsAAQ4AQAAG
DgAIFUS1RcABAgEKDgEYANaQ1++mswRGj2g2rkmyT1nCgAAACwAfDgECAQkQ
AQAAAI4CAACKAgAA9QMAAExaRnUvQwIcAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj
aArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYA5jAFALAwu1IE9LIJJoBJBlIAQAIHcQ8CUFQEkT
8GF2FDBzb3QgZgrAOgqiCoQKgEOAUkVBVEUgVAGgMmwUMCN1ESAFEGQjxRW0KBW0SUQgGLoWsEBY
VCg0MCkHsE8CVAewVUxMIFBSAElNQVJZIEtFfFksFbQXVBj/GgcbVWPpFKBlZwWweRxKD0AdL3xx
dQBwBUAcLB9/CoBz6wGQACBwBRBjFDAhXx2JtmQIcBSgaQIgHEoyGfBtHT5hEsAlwl8cBSZ0NXsk
fyXAdBcRHC0pTyfnZDseQRixRBaiGLIdTWVimGF5YheQCsBlYRiyME1FTU8aBxW0KTv5FbpUaBRR
BQAv0B5QBCBfL+ABkRcRAhAFwHQUACDnF1IUcCpwaCAPQBVgCJAQbGRzLhiwSG93/mUVEAXAFNAj
EAMQAyAU89QyICNgbxcBbTUwFbTuMRnwMkAUMFAFEADAHpHMS2UeoBRRbm8FQBEhzzMgFVAn8Dmx
bnUG0ASQ/iwT8DWAMoADkTXxOYIyUfY/BgA6sHU1EBTBOmA0Af0LgGcVMQeAO5E84QuANtCzC2Aj
kW9mHKgU0HQIgescEDy0QTnxTjpDPHA58KszwRShIAlwdAhwbj9R/wSQA2AREDdlFbQmwRTQOvH6
JwVAZztjFDAs2zTjOaJqdwWwazVBST5QFNBhhmRFMTPhREVGQRpgdRowRB5BKBnwObEz0lP+URqA
IxEeUAeAINEU0EOip0HPMiIAcGtzG1VSDeAWaBW0EeEATEsAAYAIIAYAAMBG
AAOFAwADgAggBgAAwEYAEIUDAAeACCAGAADA
RgBShQAAJ2oBAB4ACYAIIAYAAMBGAFSFAAABBDku
MAAeAAqACCAGAADARgA2hQAAAQEAHgALgAggBgAAwAAA
AEYAN4UAAAEBAB4ADIAIIAYAAMBGADiFAAAB
AQALAA2ACCAGAADARgCChQAAAQsAOoAIIAYAAMAA
AABGAA6FAwA8gAggBgAAwEYAEYUDAD2ACCAG
AADARgAYhQsAW4AIIAYAAMBGAAaFAwBc
gAggBgAAwEYAAYUCAfgPAQAAABDWkNfvprMERo9oNq5Jsk9Z
AgH6DwEQ1pDX76azBEaPaDauSbJPWQIB+w8BnwA4obsQBeUQGqG7CAAr
KlbCAABQU1RQUlguRExMAABOSVRB+b+4AQCqADfZbgAAAEQ6XERvY3VtZW50cyBhbmQg
U2V0dGluZ3NcQWRtaW5pc3RyYXRvclxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1p
Y3Jvc29mdFxPdXRsb29rXG91dGxvb2sucHN0AAADAP4PBQMADTT9NwAAAgF/AAEy
PEFFRUdJUEdJT0FET0pPRk5PSk9LTUVEUENCQUEuaWJ0b2FkQHB1bmthc3MuY29tPgMABhBk
gH7wAwAHED0CAAADABAQAAMAERAAHgAIEAEAAABlT0tIRVJFSVNXSEFUSUhBVkVT
T0ZBUjpDUkVBVE

WOO HOO =)

[William J Wheatley]

Ok i'm happy i just passed my Certification test. So i wanted to celebrate,
and thanks to everyone who has helped me with
problems in the past i appreciate it =)



Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303



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

RE: [RE: padding a variable]

[David Gassner]

Use a non-breaking space:


#myColumn##padding#

> -Original Message-
> From: Alex [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 8:24 AM
> To: CF-Talk
> Subject: Re: [RE: padding a variable]
> 
> 
> how do i get it to show 30 characters without the browser 
> truncating spaces
> 
> "Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote:
> > how do you pad a variable in CF.
> > for example how can I force a query.columnname to take up exactly 30
> > characters?
> 
> Just using Left() won't work if you're using variable length fields
> (varchar)
> 
> You could use Left(myColumn & RepeatString(" ", 30), 30)
> 
> HTH
> 
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> 
> "Websites for the real world"
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a
> message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 
> 
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

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

RE: Create Table SQL

[Andy Ewings]

Yeh your right BobI suggested he used GETDATE() 'cos I didn't realise he
was using Access (I should read my mails properly!!)

I've had a quick look around but I can't see anywhere in the Access
documentation that tells you how to set a default for a filed!  You must be
able to do it as you can using the table design wizard.  It's a pain in the
butt that when you do use the table design wizard you can't view the SQL
that Access writes for you as you can when you use the query design wizard.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 419 4235 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 16:39
To: CF-Talk
Subject: RE: Create Table SQL


This is just a stab in the dark, but that SQL looks an awful lot like the
SQL you use in SQL Server.  Does it also work in Access (which Rich is
using) or is there an alternate syntax?

Bob

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:55 AM
To: CF-Talk
Subject: RE: Create Table SQL


This isn't working for me and I can't figure out why.  This works:

auction_date   DATE NOT NULL,

however as soon as I ad the Default part

auction_date   DATE NOT NULL   DEFAULT GETDATE(),

I get errors.

Any Ideas,
Rich



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
.
.
.
)

The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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



Arch

difficulties with javascript overtones

[t nelson]

Hi everybody,

I am looking for a little help right now. I am trying to make a dynamically 
populated drop down box, of options, so that a user can search for items a 
little bit easier. right now they have to scroll through each record, 25 at 
a time, until they get to the category they want. ultimately want i want 
them to be able to do is to be able to select a category, from the drop down 
box, and then be able to view the items from that category. that being said 
here's the big problem:

how to get the s' listed to function, if the clients browser does 
not accept javascript?

any ideas out there?

HELP!!
_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: cfinsert

[Bob Silverberg]

What is the text of the error message?
As CFINSERT just inserts whatever fields are passed to it, my guess is that
one of '#First#','#Last#','#Ride#','#Fav_Place#' is not being passed to the
template.

Bob

-Original Message-
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: November 3, 2000 11:14 AM
To: CF-Talk
Subject: cfinsert


I was using the following query:


INSERT INTO Users
(First,Last,Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')


But it was giving me an error. None of the fields are numeric, they are all
texted fields. But when I used the following query:



This one worked, but why didn't they other one?

Jeremy



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


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

RE: Create Table SQL

[ibtoad]

I am using Access 2000.
If I manually go into the database I can set the Default to Date() and it
will work however when I try to set it up from the SQL statement, I get
errors.

Rich

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 11:32 AM
To: CF-Talk
Subject: RE: Create Table SQL


Are you using SQL Server?if so neither will work as Date is not a valid
type.  Replace it with Datetime and it'll work

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:55
To: CF-Talk
Subject: RE: Create Table SQL


This isn't working for me and I can't figure out why.  This works:

auction_date   DATE NOT NULL,

however as soon as I ad the Default part

auction_date   DATE NOT NULL   DEFAULT GETDATE(),

I get errors.

Any Ideas,
Rich



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL


To create a primary key create a unique clusted index after you have crated
the table like so

CREATE TABLE 
(   field1 int PRIMARY KEY CLUSTERED
,   field2 datetime DEFAULT GETDATE()
,   field3..
.
.
.
)

The other way is to creat the table and then create an unique clustered
index index afterwards to create the primary key and then perform an alter
table statement to set the default.

hope that helps

Andy


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:13
To: CF-Talk
Subject: Create Table SQL


I have 2 questions, I am writting an CREATE Table SQL statement for MS
Access,

How do I create the table to have a primary key?

What statement do I use to create a date field with default Date()?

Thanks,
Rich



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


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



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


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffus

Re: Security hole in basic authorization... Solutions?

[Ken Wilson]

You could start by hiring a more intelligent Sys Admin.  :)

Ken


- Original Message -
From: "Jamie Jackson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 11:21 AM
Subject: Security hole in basic authorization... Solutions?


Say I'm a developer, but not a not a SysAdmin.

It is too easy for me to get an administrator's username/password like
this, using Win2k basic authorization:

Hey, administrator, I'm troubleshooting a template, would you see if
the test passes?:


Test Passed! Thanks, for checking, administrator!

#cgi.auth_user#
#cgi.auth_password#



How do I prevent this from working?

Thanks,
Jamie


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


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

RE: cfinsert

[Sandra Clark]

What was the error you were given?

-Original Message-
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 8:14 AM
To: CF-Talk
Subject: cfinsert


I was using the following query:


INSERT INTO Users
(First,Last,Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')


But it was giving me an error. None of the fields are numeric, they are all
texted fields. But when I used the following query:



This one worked, but why didn't they other one?

Jeremy



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



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

Re: cfinsert

[Jamie Jackson]

How's about cutting and pasting the error, along with the debug
outputted query.

J

On Fri, 03 Nov 2000 08:13:45 -0800, in cf-talk you wrote:

>I was using the following query:
>
>
>INSERT INTO Users
>(First,Last,Ride,Fav_Place)
>VALUES('#First#','#Last#','#Ride#','#Fav_Place#')
>
>
>But it was giving me an error. None of the fields are numeric, they are all texted 
>fields. But when I used the following query:
>
>
>
>This one worked, but why didn't they other one?
>
>Jeremy
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED]


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

Batch updates

[Bosky, Dave]

I'm trying to display a group of records and give the user the abililty to
update any or all of the fields 
of each record upon clicking the update button.  I have them displaying
inside a form.

Thanks
Dave


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

radius server

[Dirk De Bock]

Is anyone interfacing CF with a radius server for authentication? I am aware
of the cfx_radauth tag by [EMAIL PROTECTED] but I could not get it to work
properly with RadiusNT.


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

Re: CFX

[Billy Cravens]

Registering it in the CF Administrator should suffice; what kind of
functionality isn't working?  Errors for the most part vary by tag.

-- 
Billy Cravens
[EMAIL PROTECTED]


Neil Clark wrote:
> 
> I have a new CFX tag and to be honest have not played around with them much
> other than development - it seems to be working fine on the development
> server (which is my stand-alone machine running CF etc..)
> 
> but when I try to access the site via a different machine's browser and try
> the functionality out it doesn't work ? ;-(  I have registered it via
> the IDE but not in the registry; does this matter?
> 
> Neil
>

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

Decrypt()

[Billy Cravens]

I'm trying to run a routine to decrypt a record in a table.  All records
were encrypted using Encrypt(), with a routine encryption key:




However, some of the encrypted passwords cause this error to appear:

---BEGIN ERROR---
An unexpected system error was detected. (Error code is 20)

This type of error will most likely occur when the server running
ColdFusion is low on memory and/or system resources.
---END ERROR---

The code I'm using is below:


select encryptionKey, encryptedText
from table











I've checked the resources on the server; they're OK.

I prefer to use cfusion_encrypt and cfusion_decrypt; however, that's not
an option here, as I do not have any control over the encryption
process.

Ideas?


-- 
Billy Cravens
[EMAIL PROTECTED]

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

Re: padding a variable

[Billy Cravens]

-- 
Billy Cravens
[EMAIL PROTECTED]


Alex wrote:
> 
> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?
> 
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> 
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED]

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

Re: Action Pages or Coding the Page in Action Attribute of tag

[Peter Theobald]

I think Fusebox may address this problem, since Fusebox always has a form display and 
form action (and everything else) go through the same page, index.cfm.

Any Fusebox experts want to comment on how to avoid the problem of hitting 'BACK' 
resubmits your form instead of displaying the blank form again?

At 02:13 PM 11/2/00 -0500, Rosa, Issac wrote:
>Is it more advantageous to use an action page or code the action in the
> tag?  The submitting page is passing 2 variables - id_market and
>id_category from drop down boxes.
>
>http://some_url.cfm" method="post">
>
>or
>
>
>
>One issue I have noticed with using action pages is that when you hit the
>browser back button from the results page, it tries to execute the action
>page again and doesn't take you to the submitting page.  Is there another
>way around this or a better programming methodology?
>
>If you have any questions or concerns, please feel free to call me at
>407-514-5021.
>
>Thank you,
>
>> Issac Rosa
>> 
>> IT - National Sales & Marketing
>> OLAP Specialist Team Leader
>> Ofc: 407-514-5021
>> Cell: 407-342-0644
>> Fax: 407-514-5988
>> [EMAIL PROTECTED]
>> 
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
>with 'unsubscribe' in the body to [EMAIL PROTECTED] 


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A



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

RE: removing character from a variable

[Dylan Bromby]

you could:

1) get the length
2) subtract 10
3) get the rightmost chars according to the value from step 2.


-Original Message-
From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:17 AM
To: CF-Talk
Subject: removing character from a variable


I'm trying to take a variable item1
and remove the first 10 characters... Should I get the length subtract 11
and go right of that?

-Brian




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


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

Re: cfinsert

[[EMAIL PROTECTED]]

Don't know what database you are using but I would try the following:
1.Include "form." in the variable name to assure there is no name
conflict.
2.Test for empty strings.

I have found in some db's there is inconsistant behavior where an empty
field will cause a problem in some cases and not in others. So I always test
for empty fields. For example:


INSERT INTO Users
(First, )
VALUES
('#First#',... )



Marc Stormes
Relocate-US.com, LLC


- Original Message -
From: "Jeremy Toevs" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 11:13 AM
Subject: cfinsert


I was using the following query:


INSERT INTO Users
(First,Last,Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')


But it was giving me an error. None of the fields are numeric, they are all
texted fields. But when I used the following query:



This one worked, but why didn't they other one?

Jeremy



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



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

RE: padding a variable

[Chris Evans]

Or,





Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com


-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 12:54 PM
To: CF-Talk
Subject: RE: padding a variable


That's not the queston boys.  He's not asking how to limit it to 30 but how
to force it up to 30.  IE I have a string that's only 22 chars long I need
it to be thirty.

Try this



#foo# - #len(foo)#











#foo# - #len(foo)#


Of course you can replace the @ with whatever char you want to use.

--K

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:23 AM
To: CF-Talk
Subject: RE: padding a variable


> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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


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



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

fusebox

[CAlvarado]

Is anyone out there using the fusebox methodology? 

I have recently started this position here and I am the Cold Fusion lead and
I was toying with the idea of recommending that we use the Fusebox method
for the complete REdeployment of our corporate Intranet.


any feedback is well appreciated.

chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



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

Re: removing character from a variable

[Joseph Thompson]

> I'm trying to take a variable item1
> and remove the first 10 characters... 

#RemoveChars(OriginalString,1,10)#



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

RE: [RE: padding a variable]

[Simon Horwith]

or add x number of #Chr(32)# 's to the value (#chr(32)# is the ASCII value
for a space) depends on your needs

~Simon

-Original Message-
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 1:06 PM
To: CF-Talk
Subject: RE: [RE: padding a variable]


To do that, you'll have to replace the spaces with " " to generate
non-breaking spaces for the browser. 

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 10:24 AM
To: CF-Talk
Subject: Re: [RE: padding a variable]


how do i get it to show 30 characters without the browser truncating spaces

"Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote:
> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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



Get free email and a permanent address at http://www.netaddress.com/?N=1


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


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

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

RE: Strange Access Problem

[Christopher Olive, CIO]

you don't use a where clause for an insert.  if you're trying to just do an
insert, you need to put apostrophes around your #FORM.website# value.

if you're doing an update, change your statement to

UPDATE
tblWebpageTest
SET
WebpageName = '#FileList.Name#',
Website = '#form.Website#',
Directory = '#form.PageLocation#'

and your where clause.  (which, BTW, is "in cold fusion", not "in SQL".)

you have way too many ;'s in there.  they are ususally used to deliniate the
end of an entire SQL statement, not the end of a line of one.

perhaps if you told us what you were trying to do, we could help better.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Christopher S Martin [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 11:23 AM
To: CF-Talk
Subject: Re: Strange Access Problem


Sure. Here you go.  It looks okay to me, but i may be missing something
blindingly obvious.


  INSERT INTO  tblWebpageTest(WebpageName, Website, Directory);
  VALUES   ('#FileList.Name#', #form.Website#, '#form.PageLocation#');
  WHERE   #FileList.Name# NEQ #qcfGetToCompare.WebpageName#;
  and#form.Website# NEQ #qcfGetToCompare.Website#;
 
Chris Martin
- Original Message -
From: "Vaughan Evans" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 02, 2000 20:29
Subject: Re: Strange Access Problem


> CAn you post your code to the list? It may make things easier.
>
> -Original Message-
> From: Christopher S Martin <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Friday, November 03, 2000 11:23 AM
> Subject: Strange Access Problem
>
>
> >Hey everyone.   I am having a very strange problwem with acces.
Basically,
> >it is asking me for a semicolon afgter each sql statement.  I put them
in,
> >and the semicolon errors go away, but new errors come up.   Anyone know
why
> >access would wnat semi colons?
> >
> >Chris Martin
> >
>
>---
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
> >
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



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


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

RE: Need help on http Error 405

[Chen, Yung-Chih (CIT)]

thank you for suggestion, but  why this code


works on Netscape webserver, but does not work on IIS
when user click submit it will let use save that file as download.csv!

YC

-Original Message-
From: David Gassner [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 1:03 PM
To: CF-Talk
Subject: RE: Need help on http Error 405


Error 405 means that IIS doesn't understand the requests's file extension
and can't properly dispatch it to the ColdFusion server.  Your action
attribute implies a file extension ".cfm/download.csv" which is meaningless
to the web server.

If you want the user to be able to download a file called download.csv, just
call the download.cfm page; in that page, include the commands:




where the file is the complete path and filename in the server file system.

Also, note that the ENCTYPE attribute in the form is for uploading a file,
not downloading one.

> -Original Message-
> From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 6:32 AM
> To: CF-Talk
> Subject: RE: Need help on http Error 405
>
>
> hi,
> I have add enctype="multipart/form-data"
>  enctype="multipart/form-data" onSubmit="return ck_submit();"
> onReset="clear_lists();">
>
> but I am still getting http Error 405 error, and suggestion
>
> YC
>
> -Original Message-
> From: Steve Bernard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 7:02 PM
> To: [EMAIL PROTECTED]
> Cc: Chen, Yung-Chih (CIT)
> Subject: RE: Need help on http Error 405
>
>
> You need to add "Type=multipart/form-data" to the FORM tag, double check
> spelling ;)
>
> Steve
>
> -Original Message-
> From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 3:58 PM
> To: CF-Talk
> Subject: Need help on http Error 405
>
> I have a page allow user to download data in CSV file extension.
> it was working at the production server(Unix, netscape web server)
> but does not work on my developement server (NT , IIS 4)
> here is the code:
> 
>
> when user click submit, it will call download.cfm to download
> data and open
> download.csv with MS Excel.
>
>
> Is there something I need to do on the Webserver?
>
> any suggestion will be helpful!!
>
> Thanks
>
> YC
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>



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

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

Need to find a good scheduler for NT

[Chen, Yung-Chih (CIT)]

Hi,
can anyone suggest good scheduler for NT?
I am looking for a scheduler programe that will install as service on
NT(also can be login as different domain user),
so it will run any tasks without user login into NT.



Thanks!

YC

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

Re: [RE: padding a variable]

[Alex]

i can do this BUT not with spaces [ ]
how can i get a query field that takes up 10 or less characters to take up
exactly 30 characters in the browser?


"Chapman, Katrina" <[EMAIL PROTECTED]> wrote:
That's not the queston boys.  He's not asking how to limit it to 30 but how
to force it up to 30.  IE I have a string that's only 22 chars long I need
it to be thirty.

Try this



#foo# - #len(foo)#











#foo# - #len(foo)#


Of course you can replace the @ with whatever char you want to use.

--K

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:23 AM
To: CF-Talk
Subject: RE: padding a variable


> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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

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



Get free email and a permanent address at http://www.netaddress.com/?N=1

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

RE: padding a variable

[Mark Johnson]

Here is a way to do it with less steps.




Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications

-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:54 PM
To: CF-Talk
Subject: RE: padding a variable


That's not the queston boys.  He's not asking how to limit it to 30 but how
to force it up to 30.  IE I have a string that's only 22 chars long I need
it to be thirty.

Try this



#foo# - #len(foo)#











#foo# - #len(foo)#


Of course you can replace the @ with whatever char you want to use.

--K

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:23 AM
To: CF-Talk
Subject: RE: padding a variable


> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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


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


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

CF Administrator

[Simon Horwith]

Happy Friday, Everyone.  I'm polling everyone (informally) via e-mail, to
get your opinions about the ColdFusion Administrator interface and/or
functionality.  Specifically, I'd like to know what you like about it, what
sections you use most and least, what you dislike about it, and WHAT
IMPROVEMENTS YOU'D LIKE TO SEE IN FUTURE RELEASES.
Don't bother to reply on-list if you can help it... just write me at
[EMAIL PROTECTED], and if possible, us CF Administator as your e-mail
subject.
Thanks.

~Simon

> Simon Horwith
> Senior Developer
> Fig Leaf Software, Inc.
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 
> 

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

cfcontent not working properly with IE on a MAC

[Joel Richards]

I am using cfcontent to allow a user to download graphics file to their 
hard drive(mainly tiff and eps files). The script works great with IE and 
Netscape on a PC and also works on a MAC with Netscape. However, When using 
IE with a mac, the file is downloaded to the browser. Any ideas on how to 
get this to work? Thanks



   


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

RE: stripping all white space, CR, Tab and put into one line

[Mark Johnson]

This will remove all returns and tabs with nothing.

ReReplace(string,"(#chr13#|#chr9#)","","ALL")

Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications

-Original Message-
From: thanh nguyen [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:18 PM
To: CF-Talk
Subject: stripping all white space, CR, Tab and put into one line


hello everyone,
I have a textarea box asking user to type in and, sometimes user types
carriage return, tab, new line, then I  insert it into sql server, when I
retrieve the information and want to write it into a text file. sometimes if
the user did not hit any return key or tab, so i write into text file it is
on coutinous one line, if the user  hit return key or tab  then the text
file show the multiple rows of characters,
what I want to do now is some how in one coutinous line without tab or
Carriage Return character.I have use StripCF() but it did not work

thanks for any suggestion


_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


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

RE: [RE: padding a variable] " "

[Mark Johnson]

Using this function another way would be.

ReReplace(LJustify(myColumn, 30)," "," ","ALL")

Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:58 PM
To: CF-Talk
Subject: Re: [RE: padding a variable] " "


spaces get truncated. that is my problem

"David Gassner" <[EMAIL PROTECTED]> wrote:
The LJustify() function is designed for exactly this purpose:

LJustify(myColumn, 30)

> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 5:23 AM
> To: CF-Talk
> Subject: RE: padding a variable
>
>
> > how do you pad a variable in CF.
> > for example how can I force a query.columnname to take up exactly 30
> > characters?
>
> Just using Left() won't work if you're using variable length fields
> (varchar)
>
> You could use Left(myColumn & RepeatString(" ", 30), 30)
>
> HTH
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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



Get free email and a permanent address at http://www.netaddress.com/?N=1


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


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

RE: Create Table SQL

[Hoffman, Joe (CIT)]

>1) The Primary Key is not set to auto number, how can I set this? Should I
>be using something in place of TEXT(40) I tried using AutoNumber but that
>returned errors.

CREATE Table #userid#
(
ID COUNTER CONSTRAINT ID PRIMARY KEY,
userid TEXT(40) NOT NULL,
category   TEXT(10) NOT NULL,
quant  TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration   TEXT(2)  NOT NULL,
auction_id TEXT(25) NOT NULL,
title  TEXT(45) NOT NULL,
auction_date   DATE NOT NULL,
ebaybidareaMEMO NOT NULL
);


>2) I can't get the auction_date field to work.  If I add the DEFAULT Date()
>to the SQL statement I get errors.
I looked long and hard some time ago ... came to the conclusion that 
it can't be done through slq ... maybe through CFX using DAO ... 
I might have even started one but know I never successfully finished it.


Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

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

sorting arrays

[Craig Bowes]

This is a multi-part message in MIME format.

--=_NextPart_000_002D_01C045AB.91D3E0C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've created a 2 dimensional array and wish to sort it by one of the =
"columns" in that array.  I've tried arraysort() function but that =
doesn't keep the data together.  It sorts only 1 dimension of the array =
and leaves the rest alone.  Is there any way to sort an array in the =
same way you use a sql ORDER BY clause where all the "rows" in the array =
remain intact but change order?   Or is there a way to do this using =
programmatically created queries?

-Craig Bowes
Coldfusion Programmer
[EMAIL PROTECTED]
972.243.1171

--=_NextPart_000_002D_01C045AB.91D3E0C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I've created a 2 dimensional array and =
wish to sort=20
it by one of the "columns" in that array.  I've tried arraysort() =
function=20
but that doesn't keep the data together.  It sorts only 1 dimension =
of the=20
array and leaves the rest alone.  Is there any way to sort an array =
in the=20
same way you use a sql ORDER BY clause where all the "rows" in the array =
remain=20
intact but change order?   Or is there a way to do this using=20
programmatically created queries?
-Craig BowesColdfusion =
Programmermailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]972.243.1171

--=_NextPart_000_002D_01C045AB.91D3E0C0--


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