Listcontains question

[van Wyk, Carlo]

Hi

I have the following piece of code that checks to see if a user can see a
specific pageid or not. Unfortunately it is not doing the job as I have a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all pages
that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFINDEX error

[ChristianWatt]

Been using cfindex for quite sometime now with now problems.  Transfere
everything to a 2000 server and CF5 and it seems to work in testing, switch
machine as the production server...and it fails. 

Error trying to open batchFilename

Can anyone please shed some light on this.  I have searched a few places and
can't seem to come up with anything!

Thank you,
Christian Watt
Webmaster
SkillPath Seminars
[EMAIL PROTECTED]

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

I've lost a week's work!!!

[Michael Lugassy]

I just had to hard reset my computer while editing a cfm template
in coldfusion studio, and when I logged in again found out it was
0 byte!!!

All of my week's work is gone (the file was around 15Kb of code).
I didn't save it in a diffrent location. is there still a place where I 
can find it??

I know the chances are ZERO! but... maybe?? :(((

Michael.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Encrypting files

[Matt Robertson]

well, if you must ftp the files (secure ftp?), how about providing the user with a 
web-based (https) template in a protected admin area?  Give them a field to input the 
decryption key, and a field to paste in the string to be decoded.


---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---

>I need my client to have the ability to decrypt the txt file 
>or the credit card number. Any good suggestions for this?
 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL question about JOIN

[Alistair Davidson]

Chad,

These two queries are NOT doing the same thing!

In your second query, the FROM statement and WHERE clause

FROM JOBINFO, ACTIVITYLOG
WHERE JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM

imply an INNER JOIN, not a LEFT OUTER JOIN. This will only select rows from
either table where the JOBNUM field on both tables match, which is an INNER
JOIN.

In your first query,  the section

FROM JOBINFO LEFT OUTER JOIN ACTIVITYLOG ON JOBINFO.JOBNUM = 
ACTIVITYLOG.JOBNUM

will return ALL records from JOBINFO, and for each of those records, it will
also return all records from ACTIVITYLOG where the JOBNUM field matches. 

Any records on JOBINFO that DON'T have a matching record in ACTIVITYLOG will
still be returned, but the query row for that record will have NULLs in all
fields that come from ACTIVITYLOG.

That's why the LEFT OUTER JOIN query is taking longer.

You should always use explicit join statements in queries for three reasons
-

1) It makes the most of the DB engine's query optimiser - I inherited an old
site where all queries used the implied join, as in your second query. Just
going through and changing them all to explicit join statements cut the
execution time by (on average) 50%.

2) You can force join types to make the best use of memory/cpu resources (at
least on SQL server, anyway). Sometimes, really complicated queries can be
sped up by huge amounts, just by explicitly specifying a HASH JOIN. 

3) It's much clearer syntax, and it allows you to separate the JOIN
conditions from the selection conditions - example:

SELECT Products.Description, Brands.Name AS BrandName, Categories.Title AS
CategoryTitle
FROM products 
 INNER JOIN Brands ON Brands.Code = Products.BrandCode
 INNER JOIN Categories ON Categories.Code = Products.CategoryCode
WHERE products.description LIKE '%#search_string#%'
  AND NOT(products.restricted = 1)

as compared to:

SELECT Products.Description, Brands.Name AS BrandName, Categories.Title AS
CategoryTitle
FROM products, brand, categories
WHERE products.brandcode = brands.code
  AND products.categorycode = categories.code
  AND products.description LIKE '%#search_string#%'
  AND NOT(products.restricted = 1)

Hope that helps

Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.net
"There is no spoon"


-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: 18 September 2001 18:45
To: CF-Talk
Subject: SQL question about JOIN


The first query takes 9seconds to process, the 2second query takes 
1seconds to process.

They return the same data.  Why should you use an LEFT OUTER JOIN, or any 
JOIN for that matter when you can say WHERE JOBINFO.JOBNUM = 
ACTIVITYLOG.JOBNUM???



SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINFO.COMPANYNAME, 
ACTIVITYLOG.LOGIN, ACTIVITYLOG.LOGOUT, ACTIVITYLOG.EMPLOYEENAME, 
ACTIVITYLOG.EMPLOYEENUM, ACTIVITYLOG.ACTIVITYDESCRIPTION
FROM JOBINFO LEFT OUTER JOIN ACTIVITYLOG ON JOBINFO.JOBNUM = 
ACTIVITYLOG.JOBNUM
WHERE ACTIVITYLOG.EMPLOYEENUM = #EMPLOYEENUM# AND
ACTIVITYLOG.LOGOUT is null AND
ACTIVITYLOG.LOGIN is not null
ORDER BY JOBINFO.JOBNUM, ACTIVITYLOG.LOGIN




SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINFO.COMPANYNAME, 
ACTIVITYLOG.LOGIN, ACTIVITYLOG.LOGOUT, ACTIVITYLOG.EMPLOYEENAME, 
ACTIVITYLOG.EMPLOYEENUM, ACTIVITYLOG.ACTIVITYDESCRIPTION
FROM JOBINFO, ACTIVITYLOG
WHERE JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM AND
ACTIVITYLOG.EMPLOYEENUM = #EMPLOYEENUM# AND
ACTIVITYLOG.LOGOUT is null AND
ACTIVITYLOG.LOGIN is not null
ORDER BY JOBINFO.JOBNUM, ACTIVITYLOG.LOGIN


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

lotus domino and cfserver

[Lorenzo Imperatrice]

who use lotus domino server and cold fusion server 4.5???

byz...
lore
Lorenzo Imperatrice
Project Manager
[EMAIL PROTECTED]
--
PROMOSnet s.r.l.
Firenze - Via A. di Duccio, 20/22
Tel. +39 055 7135176 - +39 055 7134740
Fax +39 055 7131634 - Cell. +39 347 6009781
[EMAIL PROTECTED] www.promosnet.it
--
contatto immediato


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

Locking database rows

[Thomas Chiverton]

I have an application where one set of people can enter some details about a
set of jobs, and another set can review these and approve or reject them,
which feeds back to the first set.
My problem is how to lock the records in the Oracle database while the 2nd
set is reviewing them, so the 1st set can't edit them, and the 2nd set then
approve something with different details to what they saw.

I've tried using 'select ... for update' to lock the records, and then
'select ... for update nowait' to check for a lock, but ColdFusion is
issuing an implict 'commit' when the page is sent to the browser (I think),
so this never works (the no wait always succceds).

I'm sure some of you must have come across a need to solve this sort of
problem - how did you do it ?
I'm trying to avoid kludgy things like keeping a list if primnary keys in
application.theseAreLocked, and checking that, as the list may become very
large.

Regards,

Thomas Chiverton
Intranet Architect
01565 757 909
The web is the borderless embodiment of every abstraction 


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

RE: Code Red backdoor triggered?

[Matt Robertson]

Frank,

According to CERT, you're out of luck.  You're facing a network disconnect and a 
ground-up reinstall.

http://www.cert.org/tech_tips/win-UNIX-system_compromise.html

Naturally you should research this thoroughly before doing something like that.

Sorry for the downer.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---

>Anybody found a way to get rid of this thing? 
>My Anti Virus software detects but can not do anything about it.

 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

The New worm bites!!!

[net_man]

How are people fighting this thing?  It uses Port 80 so filtering is not working well, 
has anyone else found something to concentrate on to filter at the router or firewall. 
 It is not doing damage since I am patched, but it is creating enough traffic to slow 
website performance.

Thanks,
Robert Filipovich
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Colin Fyfe]

Hi Carlo,

> If the user is allowed to see page 4, then he would be able to see all
> pages that contains a 4, so it does not work correctly.
>
>
> 
>   
(snipped)

Try using ListFind instead of ListContains. ListContains will find list
elements which contain your search string in any part of a list element.
ListFind only finds list elements which match your search string in their
entirety, so using ListContains with pageid 4 would match 4, 14 and 44
while ListFind would only return 4.

Hope this helps,

Colin


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cflocation/javascript

[Shawn Grover]

You're right, the cflocation would execute before the page is sent to the
browser - so the javascript wouldn't get executed.

It sounds to me like your root cause is page caching (or more specifically
in your case, a lack of page caching).  We ran into that "Data Missing"
condition a bunch of times.  The best solution we have found is to use
javascript validation of data, on the submission page (i.e. where the form
is), OR, if you can do it - use form GET methods instead of POST. (not
applicable in all cases).

HTH

Shawn Grover


-Original Message-
From: Garry Red 5 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 7:58 PM
To: CF-Talk
Subject: cflocation/javascript


This is a multi-part message in MIME format.

--=_NextPart_000_0013_01C14102.4BF2FC00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi

We have a problem involving cflocation. In our code we have a user-intensive
form, and when this is processed various (complicated) checks are performed
to ensure data validity. If the numbers entered do not meet certain
conditions, the page uses cflocation to redirect to a standard error page.
However we have received emails suggesting that sometimes when this happens,
and the user pressed back on their browser, their inputted data is lost and
they have to enter it all again.

We hoped to fix it with the following code, which we hoped would open a
smaller window with the error message, while leaving the main window with
data intact for easy modication:

var popupfeatures =
"toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,r
esizable=yes,width=530,height=350";
function showWindow(myurl)
{
 var win = open(myurl,'popupwindow',popupfeatures);
 win.focus();
}



But while this works on my machine, it does not run on my colleague's. He is
using Win2000 whereas I am using NT. Maybe it has something to do with the
javascript running on the client while the cflocation is resolved on the
server (Just a guess. I have no idea.)

So my question is how can I achieve this. I've tried various other things
which open a popup window but continues processing the main window, losing
the entered data display. Any advice would help.

By the way, I know you might suggest that I look into why the page is not
remembering the data on the back button, or that I simply repost back to the
form displaying the error message and data, but believe me, in the context
of this code, this is very very complicated.

Thanks

Garry

--=_NextPart_000_0013_01C14102.4BF2FC00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Hi
 
We =
have a problem=20
involving cflocation. In our code we have a user-intensive form, and =
when this=20
is processed various (complicated) checks are performed to ensure data =
validity.=20
If the numbers entered do not meet certain conditions, the page uses =
cflocation=20
to redirect to a standard error page. However we have received emails =
suggesting=20
that sometimes when this happens, and the user pressed back on their =
browser,=20
their inputted data is lost and they have to enter it all=20
again.
 
We =
hoped to fix it=20
with the following code, which we hoped would open a smaller window with =
the=20
error message, while leaving the main window with data intact for easy=20
modication:
 
   =20
var popupfeatures =3D=20
"toolbar=3Dno,location=3Dno,directories=3Dno,status=3Dno,menubar=3Dno,scr=
ollbars=3Dyes,resizable=3Dyes,width=3D530,height=3D350";  &=
nbsp;=20
function showWindow(myurl)=20
{ var win =3D=20
open(myurl,'popupwindow',popupfeatures); =
;win.focus();   =20
}
 
   =20
=20

 
But =
while this works=20
on my machine, it does not run on my colleague's. He is using Win2000 =
whereas I=20
am using NT. Maybe it has something to do with the javascript running on =
the=20
client while the cflocation is resolved on the server (Just a guess. I =
have no=20
idea.)
 
So my =
question is=20
how can I achieve this. I've tried various other things which open a =
popup=20
window but continues processing the main window, losing the entered data =

display. Any advice would help.
 
By the =
way, I know=20
you might suggest that I look into why the page is not remembering the =
data on=20
the back button, or that I simply repost back to the form displaying the =
error=20
message and data, but believe me, in the context of this code, this is =
very very=20
complicated.
 
Thanks
 
Garry

--=_NextPart_000_0013_01C14102.4BF2FC00--

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: htt

RE: Killing a Structure

[ChristianWatt]

Use an onclose javascript to call a page that deletes their name out of the
structure, then close that page via java (since you opened with java,
netscape shouldn't kick an error to the user).  If deleting the struct key
is all your doing, it will be almost invisible.  I Would also check to see
if they have java is enable as they are logging in, and if possible, make
that a requirement.

Christian,
SkillPath Seminars
[EMAIL PROTECTED]

-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 2:08 PM
To: CF-Talk
Subject: Killing a Structure


I am trying to find a good way to clear a structure when a user closes 
their browser window. My application calls for creating a structure of 
users as people log in. This structure will not allow the same Users to 
log in twice or any other user to log in with the same username and 
password as someone who already is logged in. 

The problem is when the user closes their browser,  I need to delete 
that user from the structure. Any ideas for this would be great. 


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

list messages not being distributed?

[Matt Robertson]

Am I the only one not getting list mail?  Correction... I've gotten three messages 
since yesterday afternoon; prior to which I received a steady stream.  So the mail 
hasn't *completely* stopped.  Checked my mail server logs and saw no problems there.

Overall msg traffic *seems* down, but I'm just eyeballing it and making an assumption.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---
 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Listcontains question

[cf refactoring]

You should use ListFind rather than ListContains

--- "van Wyk, Carlo" <[EMAIL PROTECTED]>
wrote:

> 
>   
>   
>   
>   #application.securityerror#
>   
> 
> 
> Regards
> Carlo

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ImageMagick - anyone use with CF?

[Michael Lugassy]

If your project needs to create thumbnails, copy/rename/move images 
alone, just use CFX_IMAGE.
http://www.intrafoundation.com

CFEXECUTE is easy to use, just read the docs,
call the cmd prompt with the right arguments to complete the task for 
you.

Again, I'm not sure how ImageMagik handles multiple calls, but if you 
need image maniupulations
such as "remove red eye", change contrast/brightness - it's the easiest 
tool.

Michael.

  - Original Message - 
  From: Scott Weikert 
  To: CF-Talk 
  Sent: Tuesday, September 18, 2001 9:22 PM
  Subject: Re: ImageMagick - anyone use with CF?


  Thanks guys! Just what I needed to hear :)

  If any of you guys could toss me some examples of how you use 
CFEXECTUTE
  (i.e. the command you pass through it) to do various things, it'd 
probably
  help save me some time. Don't go out of your way, mind you... don't 
want to
  eat up anyone's time :)

  Thanks!
  --Scott
  
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfhttp connection failure

[FARRAH NG]

hi everybody,
i am developing a email outbound system in which the "send out email
page" uses CFHTTP to grap a dynamic page ( data from oracle 
database ) from the same website ( the CF server and the CF source 
codes are on the same server, but the oracle database is on 
a different server ).  Everything works perfect in my development
server ( it hosts the CF server, all my CF codes and the oracle DB).

But the "send out email page" does not work when i promote all my
codes to the live server.  The live site "send out email page" gives
me an error "connection fail".  The "connection fail" problem is
caused by the CFHTTP tag.  i tried to display the cfhttp.statuscode
but the page returns the message "Status code unavailable".  It is
tormenting to figure out what has gone wrong since all the codes in
the development box and the live box is exactly the same. The only
different is on the live site the oracle database resides on a 
different server.

if anyone has any idea please give a hand.

thanks




--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Listcontains question

[Joseph Thompson]

Try ListFind()

Also (if you can) build your lists with a "good" delimiter.  the Bell
character is great.

ListAppend(YourList,YourListItem,chr(7))

Then: ListFind(YourList,AnItem,chr(7))


> Hi
>
> I have the following piece of code that checks to see if a user can see a
> specific pageid or not. Unfortunately it is not doing the job as I have a
> list that looks something like this:
>
> 4,14,3,2,8,44
>
> If the user is allowed to see page 4, then he would be able to see all
pages
> that contains a 4, so it does not work correctly.
>
>
> 
> 
> 
> 
> #application.securityerror#
> 
> 
>
> Regards
> Carlo
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I've lost a week's work!!!

[Duane Boudreau]

> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 7:36 PM
> To: CF-Talk
> Subject: I've lost a week's work!!!
> 
> 
> I just had to hard reset my computer while editing a cfm template
> in coldfusion studio, and when I logged in again found out it was
> 0 byte!!!
> 
> All of my week's work is gone (the file was around 15Kb of code).
> I didn't save it in a diffrent location. is there still a place where I 
> can find it??
> 
> I know the chances are ZERO! but... maybe?? :(((


What version of studio?

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: A New CF-Community Site!

[Michael Dinowitz]

We've been putting up back issues to catch up but things just keep piling
on. I think we're going to jump ahead and do the latest issue and then back
track.


> The weekly alerts (Fusion Authority) are few and far between.
>
> -Original Message-
> From: Erika L. Walker [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 18 September 2001 8:40
> To: CF-Talk
> Subject: A New CF-Community Site!
>
>
> House of Fusion and RUWebby.com are happy to present a new CF-Community
> site! CF-Community.com (http://www.cf-community.com) will talk about all
> things community-related, and be your fun portal and guide to the CF
> world,
> whether it's code related or off-topic. Preferably OT!
>
> We're starting with the biggest community event coming up -- the CF
> Community Suite, taking place during and alongside the Macromedia
> Conference
> in Orlando. Register now and participate in the different events and
> things
> we've got planned.
>
> And of course, there's the raffle that will get you a chance to win a
> one-year subscription to the House of Fusion Tech Digest as well as
> other
> great prizes! This new service, an edited, redacted, digest of all
> pertinent
> Tech posts for CF-Talk and the other Tech lists, normally will be a paid
> subscription. But you will have a chance to win a free subscription,
> once
> each day of the conference, only at the Community Suite.
>
> The best thing is, all proceeds go to help victims of the World Trade
> Center
> attacks, or to Byteback, a non-profit organization that helps train the
> underpriviliged in Web development in Washington, D.C. So you get a
> chance
> to help and to win this great new digest!
>
> Check us out, http://www.cf-community.com, and we'll see you at the
> suite!
>
>
> **
>
> This transmission is intended only for the use of the addressee(s)
> and may contain confidential or legally privileged information. If you are
> not the intended recipient, you are notified that any use or dissemination
> of this communication is strictly prohibited. If you have received this
> transmission in error, please notify the ANZFA IT helpdesk prior to
deleting
> all copies of this transmission together with any attachments.
>
> ANZFA helpdesk:
>
> E-mail:  [EMAIL PROTECTED]
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Neil Clark]

Try using a structure and using Struct Funtions like Find, Get etc...

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

RE: File Upload from MAC to PC-HELP!

[Ben Whalley]

Not totally clear on this but I do remember we had loads of problems
uploading from Macs - think the problem was that some versions of IE didn;t
implement file upload properly. I do have a site that does this but only
with IE5. Maybe you could check your code (which looks fine at a glance)
with the latest browser.

Ben

--
Ben Whalley, Radley Yeldar 
326 City Road, London, EC1V 2SP
--
0207 7130038
[EMAIL PROTECTED]
www.ry.com
--

> --
> From: Steven A. del Sol
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, September 18, 2001 19:13 PM
> To:   CF-Talk
> Subject:  File Upload from MAC to PC-HELP!
> 
> Ok, I am sure this is an easy issue for someone and I am just missing 
> something simple but this is kicking my @$$!
> 
> I have a client who needs to upload images from his Mac to a WIN2K server 
> running CF5. here is the code. If it is easier for you to rewrite the code
> 
> please do.
> Any and all help will be appreciated.
> 
> 
> 
> 
> 
> UPLOAD FORM PAGE
> 
> 
>  
> 
>  
>   id="medIMG" size="35" accept="image/jpg, image/jpeg, image/pjpeg, 
> image/gif, image/tiff, image/png">
>  
>   id="smIMG" size="35" accept="image/jpg, image/jpeg, image/pjpeg,
> image/gif, 
> image/tiff, image/png">
>  
>   id="lgIMG" size="35" accept="image/jpg, image/jpeg, image/pjpeg,
> image/gif, 
> image/tiff, image/png">
> 
> 
>   value="#image#">
>   name="prodid" 
> value="#url.prodid#">
>  
> 
> 
> RESULT PAGE
> 
>  filefield="lgIMG"
> destination="#application.imgsrc#"
> nameconflict="MAKEUNIQUE"
> accept="image/jpg, image/jpeg, image/pjpeg, image/gif">
> 
> #form.prodid#
> 
> select *
> from image
> where prodid = #form.prodid#
> 
> 
> 
> insert into image(prodid, #form.here#)
> values (#form.prodid#, '#file.clientfile#')
> 
> 
> 
> update image
> set
> #form.here# = '#file.clientfile#'
> where prodid = #form.prodid#
> 
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cflocation/javascript

[BEN MORRIS]

Perhaps you should re-think the entire process going on here.

With form validation, and invalid information is entered, I usually give 
an error message at the top of the page, and then show the form populated 
with the information that they have entered.  If you really want to be 
fancy, then highlight the field in error on the form.

If it passes validation, then you can use cflocation after the insert or 
update of the data, which can be good because then they can't refresh and 
insert 5 records in a row on accident.

>From a technical and usability perspective, I think that making someone go 
to a page just to tell them to go to another page is a headache for all 
involved.

 - my $.02
 Ben Morris

>>> "Garry Red 5" <[EMAIL PROTECTED]> 09/18/01 09:57PM >>>
This is a multi-part message in MIME format.

--=_NextPart_000_0013_01C14102.4BF2FC00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi

We have a problem involving cflocation. In our code we have a user-intensiv
e
form, and when this is processed various (complicated) checks are 
performed
to ensure data validity. If the numbers entered do not meet certain
conditions, the page uses cflocation to redirect to a standard error page.
However we have received emails suggesting that sometimes when this 
happens,
and the user pressed back on their browser, their inputted data is lost 
and
they have to enter it all again.

We hoped to fix it with the following code, which we hoped would open a
smaller window with the error message, while leaving the main window with
data intact for easy modication:
var popupfeatures=
"toolbar=no,location=no,directories=no,status=no,menubar=no,scrol
lbars=yes,r
esizable=yes,width=530,height=350";
function showWindow(myurl)
{
 var win = open(myurl,'popupwindow',popupfeatures);
 win.focus();
}



But while this works on my machine, it does not run on my colleague's. He 
is
using Win2000 whereas I am using NT. Maybe it has something to do with the
javascript running on the client while the cflocation is resolved on the
server (Just a guess. I have no idea.)

So my question is how can I achieve this. I've tried various other things
which open a popup window but continues processing the main window, losing
the entered data display. Any advice would help.

By the way, I know you might suggest that I look into why the page is not
remembering the data on the back button, or that I simply repost back to 
the
form displaying the error message and data, but believe me, in the context
of this code, this is very very complicated.

Thanks

Garry

--=_NextPart_000_0013_01C14102.4BF2FC00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable





Hi
 
We =
have a problem=20involving cflocation. In our code we have a user-intensive form, and=
when this=20is processed various (complicated) checks are performed to ensure data=
validity.=20If the numbers entered do not meet certain conditions, the page uses=
cflocation=20to redirect to a standard error page. However we have received emails=
suggesting=20that sometimes when this happens, and the user pressed back on their=
browser,=20
their inputted data is lost and they have to enter it all=20
again.
 
We =
hoped to fix it=20
with the following code, which we hoped would open a smaller window with =
the=20
error message, while leaving the main window with data intact for 
easy=20
modication:
=20
var popupfeatures 
=3D=20"toolbar=3Dno,location=3Dno,directories=3Dno,status=3Dno,menuba=3Dno,sc=
ollbars=3Dyes,resizable=3Dyes,width=3D530,height=3D350";  =
nbsp;=20
function showWindow(myurl)=20
{ var win =3D=20
open(myurl,'popupwindow',popupfeatures); =
;win.focus();   =20
}
=20

=20

 
But=
while this works=20on my machine, it does not run on my colleague's. He is using 
Win2000=
whereas I=20
am using NT. Maybe it has something to do with the javascript running on =
the=20client while the cflocation is resolved on the server (Just a guess. I=
have no=20
idea.)
 
So my=
question is=20how can I achieve this. I've tried various other things which open a=
popup=20
window but continues processing the main window, losing the entered data =

display. Any advice would help.
 
By the=
way, I know=20you might suggest that I look into why the page is not remembering the=
data on=20
the back button, or that I simply repost back to the form displaying the =
error=20message and data, but believe me, in the context of this code, this is=
very very=20
complicated.
 
Thanks
 
Garry

--=_NextPart_000_0013_01C14102.4BF2FC00--

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://w

Re: Suggestion to list

[Michael Dinowitz]

Its been suggested, its been tried and its been abandoned. In its place we
have a TO which is ALWAYS CF-Talk. Filter on that.
P.S. remember not to set up two filters on the same message type as it will
duplicate the message and you'll think your getting double mail.


> I just read the comment of a person who is faced with a lot of e/m to
read.
> I think that it would be better if the subject title of all of the e/m
from
> this
> group starts with [cf-talk].
>
> I am subscribed to some groups of which the posting subjects start with
similar
> heading.
>
> This would allow subscribers to look at the important stuff first and then
> deal with the SPAM and e/m from in-laws.
> Thomas Smith
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Listcontains question

[David Burt]

> 4,14,3,2,8,44
>
> If the user is allowed to see page 4, then he would be able to see all
pages
> that contains a 4, so it does not work correctly.

This code should be what you need:

If the user is allowed to see page 4, then he would be able to see all pages
that contains a 4, so it does not work correctly.







 
  include pageid #t# 
 



 #application.error#










 
  include pageid #t# 
 



 #application.error#


let me know is something is not clear


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFContent problem - need urgent help

[Shawn Grover]

We have a site that uses the CFContent tag for downloading files to the
user.
We ran into problems with it today where it is giving us blank/empty files.
If we check the physical file, everything is fine.  

Funny thing is that this is not happening for ALL files, just most.  Some
files are behaving normally.  

We had the security patches for the Nimda worm applied today, and have since
re-run the service packs for NT, IIS, and CF 4.5 (the server is CF 4.52, on
an NT 4 box).

Examining our code shows that it is most definently the CFCONTENT tag
causing the problems. If we comment it out, and have our debugging code
running, all the debugging code executes just fine, and indicates normal
operation.  Then the CFContent tag is executed, and it dies.  I'm sure this
is a server issue, and not a code issue (code was not changed prior to the
problems occuring).

Any help/suggestions?  I'm checking the forums and web for hints now.  We'd
like to avoid rebuilding the server if we can.

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

Re: I've lost a week's work!!!

[Joseph Thompson]

Ouch.. my sympathies.  Inspired me to zip and save my project on a remote
server!


> I just had to hard reset my computer while editing a cfm template
> in coldfusion studio, and when I logged in again found out it was
> 0 byte!!!
>
> All of my week's work is gone (the file was around 15Kb of code).
> I didn't save it in a diffrent location. is there still a place where I
> can find it??
>
> I know the chances are ZERO! but... maybe?? :(((
>
> Michael.
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfparam on dynamically numbered checkboxes

[Kay Smoljak]

Hi all,

I have a dynamically generated form, with numbered fields. I have the
following code on my action page to set all checkboxes to 0 by default
(the hardcoded 50 is for testing purposes):


 

#str#


The cfoutput bit at the end is displaying the correct formfield names:
form.include001, form.include002 etc etc. These are the same as the
formfields on the form page. 

Later down in the action page, however, trying to display the values of
the formfields is throwing an "Error resolving parameter
FORM.INCLUDE001" if the checkbox on the form is not checked. It's got me
completely stumped. If it is checked it all works fine. So it looks like
there is something wrong with the cfparam statement. Any ideas?

Thanks,
Kay.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Custom 404 Question

[Evan Lavidor]

I have a custom 404 page that I've got set up as the "default missing
template handler" in CF admin, and as the custom 404 in IIS.

I also have a mapping set up in CF Admin named "/includes"

In the template that is my 404 page, I'm trying to do a cfinclude in the
following manner:



figuring that since it's using a mapping it will accept it from anywhere it
tries to run the page.

However, the page chokes (404) on this cfinclude.  If I take it out, the
page runs fine.

Can you not process cfinclude's on a 404?  If you can, what am I doing wrong
here?

Thanks,

Evan

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

What is cfserver.exe doing?

[Justin Hansen]

Is there anyway to tell what page(s) cfserver.exe is running?

Our production server cfserver.exe is running very high usage more often
than it should for a sustained amount of time. Most of our applications are
pretty light and should not be hitting it so hard. So, my boss is freaking
out and told me to look into it.

I know it is not a mass mailing or nimda. We do have some scheduled tasks
that hit it pretty good but I know they are not running right now.

Thanks!

Justin Hansen - [EMAIL PROTECTED] 
Project Leader / Web Application Developer
Interactive Business Solutions, Inc
816-221-5200 ext. 1305
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Best Bulk Emailers

[Darryl Lyons]

What are the best bulk email programs out there that integrate with CF? E.g.
"Dear " functionality

---
Regards,

Darryl Lyons
Senior Systems Developer
Fuzion: http://www.fuzion.com.au

Email : [EMAIL PROTECTED]
Phone : (07) 3620 1000
Fax   : (07) 3620 1001  
Technical Support : 1300 888 480

'merging business + technology'
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

asp help

[Joshua Tipton]

Does anyone see a problem with this
 
' FileName="Connection_odbc_conn_dsn.htm" 
' Type="ADO" 
' HTTP="false" ' Catalog="" 
' Schema="" 
' MM_Lingerie_STRING = "dsn=sales;uid=admin;pwd=safe4176;"
MM_Lingerie_STRING= "Provider=SQLOLEDB.1; Network
Library=dbmssocn;Password=safe4176;User ID=admin;Initial
Catalogue=sales; Data Source=217.204.37.40;" 
Session.Lcid=2057
 
Just to let you know I have the percent signs and > where they are
supposed to be.  Receiving a connection error.  Please help out

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Need help with error message.

[Tilbrook, Peter]

Probably something to do with the key being "URLencoded".

-Original Message-
From: Chris Bohill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 19 September 2001 1:23
To: CF-Talk
Subject: Need help with error message.


Can anyone explain why I am getting this error message, when trying to
encrypt and decrypt details passed through pages as URL's.


Error Occurred While Processing Request Error Diagnostic InformationAnerror occurred 
while evaluating the expression: C=
Decrypt(ToString(ToBinary(URL.Card_Id)),secret_key) Error near line 19,
column 10. 

The value to be decrypted is not valid The error occurred while
processing an element with a general identifier of (CFSET), occupying
document position (19:4) to (19:67).

Thanks,

Chris.

   Chris Bohill 
   WEB APPLICATIONS DEVELOPER

  Biznet 
Head Office 
133-137 Lisburn Road, Belfast 
Northern Ireland BT9 7AG 
T  +44 (0) 28 9022 3224 
F  +44 (0) 28 9022 3223 
E  [EMAIL PROTECTED]
 
W  biznet-solutions.com  

 


**

If you are not the intended recipient, or person responsible for
delivering it to the intended recipient, you are not authorized

to and must not disclose, copy, distribute or retain this message or any
part of it. 

The opinions / views / comments on this e-mail do not necessarily
reflect any views or policies of biznet

The recipient should check this email and any attachments for the
presence of viruses. biznet accepts no liability for any damage caused
by any virus transmitted by this email. biznet 2001.


**


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Don Lundgren]

Good morning,

The ListContains function does not work as you wish it to. You should use
the ListFind and ListFindNoCase functions. Here is what the docs say about
ListFind. I use this quite a bit.

ListFind
Returns the index of the first occurrence of a value within a list. Returns
0 if no value is found. The search is case-sensitive.

See also ListContains and ListFindNoCase.

Syntax
ListFind(list, value [, delimiters ])

list
List being searched.

value
Number or string that is to be found in the items of the list.

delimiters
Set of delimiters used in the list.

Examples




ListFind/TITLE>








Here is the list: #aList#

ListContains checks for the existence of a substring "wo" in the items in
the list.
ListContains

The substring "wo" is in Item #ListContains(aList, "wo")# of the
list.


ListFind cannot check for substrings within items; therefore, in the
following code where ListFind in used in place of ListContains, it will
not find the substring "wo" in the list.
ListFind

The substring "wo" is in Item #ListFind(aList, "wo")# of the list.


However, if you specify the entire string two, both ListContains
and ListFind will find it in the second item in the list.
ListContains

The string "two" is in Item #ListContains(aList, "two")# of the
list.

ListFind

The string "two" is in Item #ListFind(aList, "two")# of the list.





Don Lundgren ;-)


-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 4:28 AM
To: CF-Talk
Subject: Listcontains question


Hi

I have the following piece of code that checks to see if a user can see a
specific pageid or not. Unfortunately it is not doing the job as I have a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all pages
that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

FW: asp help

[Joshua Tipton]

 
 
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 19, 2001 6:29 PM
To: CF-Talk
Subject: asp help
 
Does anyone see a problem with this
 
' FileName="Connection_odbc_conn_dsn.htm" 
' Type="ADO" 
' HTTP="false" ' Catalog="" 
' Schema="" 
' MM_Lingerie_STRING = "dsn=sales;uid=admin;pwd=safe4176;"
MM_Lingerie_STRING= "Provider=SQLOLEDB.1; Network
Library=dbmssocn;Password=safe4176;User ID=admin;Initial
Catalogue=sales; Data Source=217.204.37.40;" 
Session.Lcid=2057
 
Just to let you know I have the percent signs and > where they are
supposed to be.  Receiving a connection error.  Please help out

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

test

[Michael Lugassy]

test

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Joshua Miller]

2 Possible Solutions off the top of my head:

1. Use List Qualify and then add qualifiers around the data being passed.
2. Use the UDF Below if you're running CF5. This is essentially the same as
above, just in UDF form so that it's easy to remember.

usage: #ListContainsUnique(yourlist,'4')#

function ListContainsUnique(list,compare){
var delim = "";
var argc = ArrayLen(arguments);
if (argc EQ 2) {
ArrayAppend(arguments,',');
}
delim = arguments[3];
compare="+#compare#+";
list=ListQualify(list,"+",delim,"ALL");
if(ListContains(list,compare,delim)){
return true;
}else{
return false;
}
}

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[EMAIL PROTECTED]

-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 5:28 AM
To: CF-Talk
Subject: Listcontains question


Hi

I have the following piece of code that checks to see if a user can see a
specific pageid or not. Unfortunately it is not doing the job as I have a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all pages
that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL question about JOIN

[DeVoil, Nick]

There is no reason to, unless you need to make sure that you will
get all the relevant records from one or more of the tables
regardless of whether they have corresponding records in the
other tables. That's what an outer join is for.

If you put a row into JOBINFO with no corresponding rows in
the ACTIVITYLOG, the 2 queries will return different data.

If that's an impossible situation, then the second query is fine.

Nick

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 6:45 PM
To: CF-Talk
Subject: SQL question about JOIN


The first query takes 9seconds to process, the 2second query takes 
1seconds to process.

They return the same data.  Why should you use an LEFT OUTER JOIN, or any 
JOIN for that matter when you can say WHERE JOBINFO.JOBNUM = 
ACTIVITYLOG.JOBNUM???



SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINFO.COMPANYNAME, 
ACTIVITYLOG.LOGIN, ACTIVITYLOG.LOGOUT, ACTIVITYLOG.EMPLOYEENAME, 
ACTIVITYLOG.EMPLOYEENUM, ACTIVITYLOG.ACTIVITYDESCRIPTION
FROM JOBINFO LEFT OUTER JOIN ACTIVITYLOG ON JOBINFO.JOBNUM = 
ACTIVITYLOG.JOBNUM
WHERE ACTIVITYLOG.EMPLOYEENUM = #EMPLOYEENUM# AND
ACTIVITYLOG.LOGOUT is null AND
ACTIVITYLOG.LOGIN is not null
ORDER BY JOBINFO.JOBNUM, ACTIVITYLOG.LOGIN




SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINFO.COMPANYNAME, 
ACTIVITYLOG.LOGIN, ACTIVITYLOG.LOGOUT, ACTIVITYLOG.EMPLOYEENAME, 
ACTIVITYLOG.EMPLOYEENUM, ACTIVITYLOG.ACTIVITYDESCRIPTION
FROM JOBINFO, ACTIVITYLOG
WHERE JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM AND
ACTIVITYLOG.EMPLOYEENUM = #EMPLOYEENUM# AND
ACTIVITYLOG.LOGOUT is null AND
ACTIVITYLOG.LOGIN is not null
ORDER BY JOBINFO.JOBNUM, ACTIVITYLOG.LOGIN



**
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.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moving from Access to SQL server

[Kola Oyedeji]

Hi

I have a site which I would like to move from Access to SQl server are there
any things I need to be aware of code wise things like dates perhaps?

Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Killing a Structure

[Neil Clark]

Chad,

There are probably a few ways to do this; one way I can think of would be to
call something on the onBlur() command when the user close the window...
maybe call another function which in turn calls either a CF or cfscript
function to clear the structure by a popup window.

The small window could be positioned dead centre of the browser and state
something like - "Please wait while be log your session out."  it could call
the structure clear command and then have a timeout to make sure it remains
on screen for a desired amount of time.

Another could be do have a client or session variable with some kind of lock
around it.

HTH

Neil


'I really must buy a watch, but I just cant find the time.'

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

RE: Listcontains question

[Andrew Scott]

Yes listcontains will do this!

What you might need to do is something like this:-) Turn the list into
an array, then run a loop until you find the first occurrence.

Regards,
Andrew Scott


-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, 19 September 2001 19:28 PM
To: CF-Talk
Subject: Listcontains question

Hi

I have the following piece of code that checks to see if a user can see
a
specific pageid or not. Unfortunately it is not doing the job as I have
a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all
pages
that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Encrypting files

[Chad McCue]

I am trying to find the best way to encrypt a .txt file or just a credit 
card number going onto that file. I looked at the encrypt function, but 
after I encrypt the credit card number, I am writing the results to a 
txt document for my client to access via ftp. I need my client to have 
the ability to decrypt the txt file or the credit card number. Any good 
suggestions for this?

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

JMAIL

[Darryl Lyons]

Any ideas how many emails JMAIL can handle? Ie. Could it send 80,000? If
not, most likely worth looking into a complete listserv/mailing list system?

---
Regards,

Darryl Lyons
Senior Systems Developer
Fuzion: http://www.fuzion.com.au

Email : [EMAIL PROTECTED]
Phone : (07) 3620 1000
Fax   : (07) 3620 1001  
Technical Support : 1300 888 480

'merging business + technology'
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Tyson Vanek]

Try using the listFind() function instead.

-Tyson

-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 4:28 AM
To: CF-Talk
Subject: Listcontains question


Hi

I have the following piece of code that checks to see if a user can see a
specific pageid or not. Unfortunately it is not doing the job as I have a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all pages
that contains a 4, so it does not work correctly.






#application.securityerror#



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

Re: Listcontains question

[Koo Pai Lao]

do a list loop instead. it loops through the list and checks it with the 
number u are looking for (line 5).  If it matches, it includes the tmeplate 
and breaks off the loop.  Then on line 11 it checks to see if it has checked 
through everything in the list, and if it has and has gotten this far, it 
means there was no match, and goes ahead and does whatever

1. 
2. 
3. 

5. 
6. 
7. 
8. 

10. 
11. 

13. 
14. #application.securityerror#
15. 

17. 
18. 






>From: "van Wyk, Carlo" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Listcontains question
>Date: Wed, 19 Sep 2001 11:27:54 +0200
>
>Hi
>
>I have the following piece of code that checks to see if a user can see a
>specific pageid or not. Unfortunately it is not doing the job as I have a
>list that looks something like this:
>
>4,14,3,2,8,44
>
>If the user is allowed to see page 4, then he would be able to see all 
>pages
>that contains a 4, so it does not work correctly.
>
>
>
>   
>   
>   
>   #application.securityerror#
>   
>
>
>Regards
>Carlo
>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cflocation/javascript

[cf refactoring]

Reply follows...
--- Garry Red 5 <[EMAIL PROTECTED]> wrote:

> We have a problem involving cflocation. In our code
> we have a user-intensive
> form, and when this is processed various
> (complicated) checks are performed
> to ensure data validity. If the numbers entered do
> not meet certain
> conditions, the page uses cflocation to redirect to
> a standard error page.
> However we have received emails suggesting that
> sometimes when this happens,
> and the user pressed back on their browser, their
> inputted data is lost and
> they have to enter it all again.

Some browsers will clear formfields upon a back
button. There's nothing simple that you can do about
that unless you want to rearchitect how you handle
forms.

One way you can rearchitect is to 
1. when the form submit button is pressed, disable the
submit and send data to a validation script in a
hidden frame.
2. after validating using the hidden frame,
if OK,
  send back javascript which submits the form in the
original form frame
if not OK,
  send back javascript which opens a small window
informing the user what validation was not used.

Since the original form frame isn't actually submitted
until it has been validated, then the browser never
clears the form fields and the user retain his/her
data.

By the way, your cflocation code should not work
because of the client/server issue you cited.

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Need some help...

[phumes1]

Hi,

I'm using  to list files in a specific direectory. What I 
would like to do is have a "preference" page with checkboxes
with all the possible filename extensions. By "checking" a box(s), this 
information will be saved and when the user does another
listing of that directory only the file extensions which were selected in 
the "preference" page would be listed.

Users have to log in with a username/password so I guess the above could be 
done based on authentication.

Has anyone done anything like this? If so, how do I go about doing this.

For example, below would be the directory listing.


+ my documents
+ my work
  |-- text1.txt
  |-- text2.txt
  |-- word1.doc
  |-- word2.doc
  |-- init1.ini
  |-- init2.ini
  |-- pic1.psd
  |-- pic2.psd
  |-- pic1.gif
  |-- pic2.gif
+ software

On the "preference" I would have something like:


My Preferences

By checking the below those file extensions will bee omitted from the 
directory listing.

[   ]  .txt
[   ]  .doc
[   ]  .ini
[   ]  .psd
[   ]  .gif

SUBMIT BUTTON



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Sima Lee]

Hi , Please use ListFind(newlist,"4").

There is a difference between listcontains and ListFind, somehow, the
following code will print "index:2","index2:5":




index: #index#
index2: #index2#

According to the documenttation:
ListFind:Returns the index of the first occurrence of a value within a
list. Returns 0 if no value is found. The search is case-sensitive.

Listcontains():Returns the index of the first item that contains the
specified substring. The search is case-sensitive. If the substring is
not found in any of the list items, it returns zero (0). 

HTH

Sima
 



-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 5:28 AM
To: CF-Talk
Subject: Listcontains question


Hi

I have the following piece of code that checks to see if a user can see
a
specific pageid or not. Unfortunately it is not doing the job as I have
a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all
pages
that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Matthew W Jones]

for that type of comparison, you might be better served staying away from
the listfind or listcontains functions.

try something like











#application.securityerror#



Yes, it is slower, but it would be doing the type of comparisons that you
require
-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 4:28 AM
To: CF-Talk
Subject: Listcontains question


Hi

I have the following piece of code that checks to see if a user can see a
specific pageid or not. Unfortunately it is not doing the job as I have a
list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all pages
that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Killing a Structure

[David Burt]

Can you do an onUnload javascript to open a new window calling a cfm page to
delete that user from the structure and then use javascript to close the
window that was just opened.

only problem I see with this is that javasript has to enabled and the user
has to let the page load without closing the new window before it finishes
loading.


- Original Message -
From: "Chad McCue" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 3:08 PM
Subject: Killing a Structure


> I am trying to find a good way to clear a structure when a user closes
> their browser window. My application calls for creating a structure of
> users as people log in. This structure will not allow the same Users to
> log in twice or any other user to log in with the same username and
> password as someone who already is logged in.
>
> The problem is when the user closes their browser,  I need to delete
> that user from the structure. Any ideas for this would be great.
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF 5.0 Logs

[Neil H.]

I thought there would be a way to say after 5 megs of logs clear them or
archive them in CF 5.0?  Anyone have any ideas on the automation of this?

Thanks,

Neil
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Listcontains question

[Billy Cravens]

Use ListFind() instead 

---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: van Wyk, Carlo [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 19, 2001 4:28 AM
To: CF-Talk
Subject: Listcontains question


Hi

I have the following piece of code that checks to see if a user can see
a specific pageid or not. Unfortunately it is not doing the job as I
have a list that looks something like this:

4,14,3,2,8,44

If the user is allowed to see page 4, then he would be able to see all
pages that contains a 4, so it does not work correctly.






#application.securityerror#



Regards
Carlo
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists