date:20031215

Same result after ds.password = ds_service.encryptPasword("#FORM.pwd#");

Don
> > Line 61, that is, ds.password = ds_service.encryptPasword(FORM.pwd); 
> 
> 
> Cast the password to a string?
> 
> Jochem
> 
> -- 
> When you don't want to be surprised by the revolution
> organize one yourself
 
> - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: cfmail in cf5 spool re-sends to infinity

Maybe you need to up the timeout.  Or maybe it's something else 
entirely, and I'm done being helpful.  :-)

--Ben Doom

j cc wrote:

>  >Since this seems to happen when pageloads get canceled partway through,
>  >one idea might be to generate DB entries as a temporary holding pen,
>  >then use a scheduled task to send the emails.  This way, CF is running
>  >the page that creates & sends the email, so it won't get interrupted.
> 
> Ben,
> 
> good idea but this is what we already do.  the 'event triggers' are 
> stored in a db, and we have a scheduled task that runs every 10 minutes 
> and checks to see what has been triggered.  It then sends emails 
> accordingly.
> 
> it is *this* scheduled page that made the 'troubled' email, and not a 
> user request that could be cancelled in that sense.
> 
> -Jeff
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Adding remote datasource dynamically

Also,
How come urlPath.PORT = 1433;
instead of urlPath.PORT = "1433"?
Shouldn't 1433 be a string, which requires quotes?

And I did not get any error msg.

Thanks.

> 
> CLASS="coldfusion.server.ServiceFactory" NAME="factory">
> 
> 
> ds_service = factory.DataSourceService;
> 
> ds = StructNew();
> ds.CLASS = "macromedia.jdbc.MacromediaDriver";
> ds.DRIVER = "MSSQLServer";
> ds.NAME = FORM.dsName;
> ds.DATABASE = FORM.dbName;
> ds.HOST = FORM.serverName;
> ds.username = FORM.un;
> ds.password = ds_service.encryptPasword(FORM.pwd);
> 
> urlPath = StructNew();		
> 	urlPath.DATABASE = FORM.dbName;
> 	urlPath.HOST = FORM.serverName;
> 	urlPath.PORT = 1433;
> 	urlPath.SELECTMETHOD = "direct";
> 	urlPath.SENDSTRINGPARAMETERSASUNICODE = "false";
> // You might need to fix the following line, don't know if URLMAP 
> is the correct name
> ds.urlmap = urlPath;
> 
> ds_service["datasources"][FORM.dsName] = ds;
> 
>   			
> 
> 
> 
> > Execution results:
> > 1) cfdump displays all datasources of the CFMX installation YET the 
> new ds is not added;
> 
> There are various errors in the code where you use names of 
> objects as strings instead of objects. Also, you assign values 
> twice, which means the first value is overwritten.
> 
> 
> > 2) error code/msg/detail is EMPTY
> 
> The code you gave shouldn't return an error because it is 
> syntactically correct. It just doesn't do what you want it to do 
> either.
> 
> Jochem
> 
> -- 
> When you don't want to be surprised by the revolution
> organize one yourself
 
> - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFMX, JBoss

2003-12-15 Thread Simon Horwith

I've deployed CFMX on JBoss and didn't have any problems.  Any error
messages you can share?

~Simon

Simon Horwith
CTO, Etrilogy Ltd.
Member of Team Macromedia
Macromedia Certified Instructor
Certified Advanced ColdFusion MX Developer
Certified Flash MX Developer
CFDJList - List Administrator
http://www.how2cf.com/

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
  Sent: 15 December 2003 14:02
  To: CF-Talk
  Subject: CFMX, JBoss

  Over the weekend, I have been trying to get CFMX 6.1, JBoss 3.2.3, and
  OS X  Panther 3.1 to play together.

  After a bit of poking around (and some JBoss deployment info from
  NewAtlanta) the effort is mostly successful -- Consuming Web Services
  doesn't work.

  Anyone out there running CFMX 6.1 with JBoss?

  TIA

  Dick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Adding remote datasource dynamically

2003-12-15 Thread Jochem van Dieten

Chunshen (Don) Li wrote:
> 
> 'An exception occurred during method selection process for Method encryptPasword The cause of this exception was that either there are no methods with the the specified method name and argument types, or the method encryptPasword is overloaded with arguments types that Coldfusion can't decipher reliablly. Use javacast function to reduce ambiguity.'
> Line 61, that is, ds.password = ds_service.encryptPasword(FORM.pwd); 

Cast the password to a string?

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: 2003 Dishonest Reporting "Award"

2003-12-15 Thread Tony Weeg

read his apology, and it will all make sense sam. 

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 15, 2003 4:41 PM
To: CF-Talk
Subject: RE: 2003 Dishonest Reporting "Award"

Michael,

I'm confused.  Does being admin mean you ignore the topic of the list?  This
is waaay OT.  :-)

Or did someone spoof your address?

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 3:51 PM
> To: CF-Talk
> Subject: 2003 Dishonest Reporting "Award"
> 
> http://www.honestreporting.com/a/2003dishonest.htm
> 
>   Communique: 15 December 2003
> 
>   2003 DISHONEST REPORTING "AWARD"
> 
>   Dear HonestReporting Subscriber,
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: 2003 Dishonest Reporting "Award"

2003-12-15 Thread Samuel R. Neff

Michael,

I'm confused.  Does being admin mean you ignore the topic of the list?  This
is waaay OT.  :-)

Or did someone spoof your address?

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 15, 2003 3:51 PM
> To: CF-Talk
> Subject: 2003 Dishonest Reporting "Award"
> 
> http://www.honestreporting.com/a/2003dishonest.htm
> 
>   Communique: 15 December 2003
> 
>   2003 DISHONEST REPORTING "AWARD"
> 
>   Dear HonestReporting Subscriber,
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:cfmail in cf5 spool re-sends to infinity

2003-12-15 Thread j cc

>Since this seems to happen when pageloads get canceled partway through, 
>one idea might be to generate DB entries as a temporary holding pen, 
>then use a scheduled task to send the emails.  This way, CF is running 
>the page that creates & sends the email, so it won't get interrupted.

Ben,

good idea but this is what we already do.  the 'event triggers' are stored in a db, and we have a scheduled task that runs every 10 minutes and checks to see what has been triggered.  It then sends emails accordingly.

it is *this* scheduled page that made the 'troubled' email, and not a user request that could be cancelled in that sense. 

-Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFMAIL (MX - 6.0) and multiple email servers

2003-12-15 Thread Ciliotta, Mario

Hi all,

 
I know that in the CFMAIL tag you can specify the email server to use instead
of the one in the admin.

 
I have tried to get CFMAIL to work with our MX-records but I cannot get it to
connect - seems as though CFMAIL cannot hadle MX records for incoming
mail?

 
Does any know of way to specify a second email server to use?  I know that the
CFMAIL in 6.1 has a "failto" but this is an email address and not a server.

 
Also does anyone know of any other options to CFMAIL.  Is there a JSP tag or
library out there that I could use.

 
Thanks
_Mario
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Adding remote datasource dynamically

OK, I messed up with objects.  With your code, the password encryption failed.  Err msg:
'An exception occurred during method selection process for Method encryptPasword The cause of this exception was that either there are no methods with the the specified method name and argument types, or the method encryptPasword is overloaded with arguments types that Coldfusion can't decipher reliablly. Use javacast function to reduce ambiguity.'
Line 61, that is, ds.password = ds_service.encryptPasword(FORM.pwd); 

Thanks.

Don
> 
> CLASS="coldfusion.server.ServiceFactory" NAME="factory">
> 
> 
> ds_service = factory.DataSourceService;
> 
> ds = StructNew();
> ds.CLASS = "macromedia.jdbc.MacromediaDriver";
> ds.DRIVER = "MSSQLServer";
> ds.NAME = FORM.dsName;
> ds.DATABASE = FORM.dbName;
> ds.HOST = FORM.serverName;
> ds.username = FORM.un;
> ds.password = ds_service.encryptPasword(FORM.pwd);
> 
> urlPath = StructNew();		
> 	urlPath.DATABASE = FORM.dbName;
> 	urlPath.HOST = FORM.serverName;
> 	urlPath.PORT = 1433;
> 	urlPath.SELECTMETHOD = "direct";
> 	urlPath.SENDSTRINGPARAMETERSASUNICODE = "false";
> // You might need to fix the following line, don't know if URLMAP 
> is the correct name
> ds.urlmap = urlPath;
> 
> ds_service["datasources"][FORM.dsName] = ds;
> 
>   			
> 
> 
> 
> > Execution results:
> > 1) cfdump displays all datasources of the CFMX installation YET the 
> new ds is not added;
> 
> There are various errors in the code where you use names of 
> objects as strings instead of objects. Also, you assign values 
> twice, which means the first value is overwritten.
> 
> 
> > 2) error code/msg/detail is EMPTY
> 
> The code you gave shouldn't return an error because it is 
> syntactically correct. It just doesn't do what you want it to do 
> either.
> 
> Jochem
> 
> -- 
> When you don't want to be surprised by the revolution
> organize one yourself
 
> - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: cfmail in cf5 spool re-sends to infinity

Since this seems to happen when pageloads get canceled partway through, 
one idea might be to generate DB entries as a temporary holding pen, 
then use a scheduled task to send the emails.  This way, CF is running 
the page that creates & sends the email, so it won't get interrupted.

Not a very handy, simple solution, nor particularly elegant, but maybe a 
stopgap.

--BenD

j cc wrote:

>  >Yup.  Seen this.  Been aggrivated by this.
> 
> yeah, the more research i do the more i see that a lot of people have 
> seen this.  and kudos to macromedia for seemingly pretending that this 
> doesn't even exist.  (do a groups.google search for "cfmail spool" and 
> see all the people who posted to forums about this very problem, without 
> so much as a single response)
> 
> what kills me, is this seems like it could be fixed by what i'm sure is 
> a 2 line code change.  read the mail into memory, delete the file.  if 
> the file deletes, send the mail.  if the file doesn't delete, don't send 
> the mail.
> but instead, we send the mail 25,000 times and drop a 'warning' level 
> error in the logs.
> 
>  >Unfortunately, the only way to fix it I've found is to reboot the box,
>  >stop CF, and move or delete the file myself (so it doesn't send again).
> 
> yeah, this just isn't feasible though :/  -- to monitor the spool 
> 24/7.  A script could poll it, but the script couldn't delete a troubled 
> file -- so the best it could do is notify admins that something is wrong 
> (granted, this is better than the out of box behavior)
> 
> it seems that we'll have to use something other than cfmail.  but what i 
> don't understand -- do cfmail alternatives replace the spooling 
> mechanism that CF uses, or do they use the built-in CF spool?  b/c it's 
> that spooling mechanism that is faulty, and as long as that is till 
> being used then there's no point in going to an alternative...
> 
>  >Fortunately for us, this has only happened (that we know of) when the
>  >mail was unsendable, so we weren't bombarding people with eight billion
>  >copies of an email.
> 
> after reading those other stories on google tho, i'm very happy our 
> customer only got 79 emails.  25,000 would have been a lot worse :)
> 
> thanks Ben,
> 
> -Jeff
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFMAIL --> CDO/CDONTS problems

2003-12-15 Thread Stephen Hait

I have a CF shared hosting provider who is recommending 
switching to CDO/CDONTS from CFMAIL for sending e-mail. I've 
successfully created modifcations for a few sites there to 
accomplish this. 

Now I'm trying to implement this locally for development purposes 
and I'm realizing I'm totally lost so I'm asking if anyone has any 
suggestions or pointers to tutorials about this that might resolve 
the problems I'm having (basically mail doesn't get sent from my 
development machines, it just ends up and stays in the IIS 
mailroot\queue directory.)

I've got 2 development platforms, both connecting to the Internet 
via ADSL connection and I'm able to send mail via this 
connection with a mail client through my ISP's mail servers no 
problem; in fact I'm doing that right now. I'm also able to set up 
CFMAIL in the CF Administrator to use CFMAIL no problem. My 
2 platforms are as follows and I'd welcome solutions pertaining to 
either of them:

W2K Pro running CF5 and IIS5 single mode (or whatever it's 
referred to).
W2003 Server Webserver Edition running CFMX6.1 and IIS6.

When trying to use CDONTS on either of these machines, mail 
ends up in the QUEUE directory but just stays there and is never 
sent out. With CF5 I can specify my mail server as 
mail.bellsouth.net (SMTP server I use with a regular mail client) 
and with CFMX I can specify this server and, additionally, specify 
the proper user/password credentials required by Bellsouth to 
send mail via its mail servers. I don't see how to accomplish this 
via CDO/CDONTS and the IIS SMTP service and I'm not even 
sure this is looking in the correct direction.

This one's had me scratching my head for a few days now so any 
suggestions would be extemely welcome.

Sorry if this is a newbie question but I've been trying to find a 
solution in many places and so far have struck out.

Regards,
Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:cfmail in cf5 spool re-sends to infinity

2003-12-15 Thread j cc

>Yup.  Seen this.  Been aggrivated by this.

yeah, the more research i do the more i see that a lot of people have seen this.  and kudos to macromedia for seemingly pretending that this doesn't even exist.  (do a groups.google search for "cfmail spool" and see all the people who posted to forums about this very problem, without so much as a single response)

what kills me, is this seems like it could be fixed by what i'm sure is a 2 line code change.  read the mail into memory, delete the file.  if the file deletes, send the mail.  if the file doesn't delete, don't send the mail.
but instead, we send the mail 25,000 times and drop a 'warning' level error in the logs.

>Unfortunately, the only way to fix it I've found is to reboot the box, 
>stop CF, and move or delete the file myself (so it doesn't send again).

yeah, this just isn't feasible though :/  -- to monitor the spool 24/7.  A script could poll it, but the script couldn't delete a troubled file -- so the best it could do is notify admins that something is wrong (granted, this is better than the out of box behavior)

it seems that we'll have to use something other than cfmail.  but what i don't understand -- do cfmail alternatives replace the spooling mechanism that CF uses, or do they use the built-in CF spool?  b/c it's that spooling mechanism that is faulty, and as long as that is till being used then there's no point in going to an alternative...

>Fortunately for us, this has only happened (that we know of) when the 
>mail was unsendable, so we weren't bombarding people with eight billion 
>copies of an email.

after reading those other stories on google tho, i'm very happy our customer only got 79 emails.  25,000 would have been a lot worse :)

thanks Ben,

-Jeff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

cfstoredproc, status codes, trapping errors

2003-12-15 Thread Darron J. Schall

I've searched around on google but have come up empty.  I'm running SQL
Server 2K and CFMX 6.1.  I have a stored procedure that handles database
inserts.  It looks something like this (trimmed):

INSERT INTO quiz_results (user_id, question_id, answer_text)
VALUES (@user_id, @question_id, @answer_text)

IF @@ERROR <> 0
BEGIN
 PRINT 'ERROR: Duplicate entry.'
 RETURN -2
END
ELSE
BEGIN
 PRINT 'Success.'
 RETURN 0
END

Then, I'm calling it via the following CFML in a UDF (the fact that this is
in a UDF shouldn't matter, just thought I'd mention it):

returncode="yes">
    
cfsqltype="cf_sql_integer">
    
cfsqltype="cf_sql_integer">
    
cfsqltype="cf_sql_varchar">


.. and I'd like the function to return success or failure.  Easy enough,
right?



However, if the insert fails, CFMX chokes on the error message.  I wanted to
trap the error in my stored procedure, and return '-2' to CFMX, so that
cfstoredproc.StatusCode is -2.  I know I can fix this by just wrapping the
storedproc call in a try block, and setting cfstoredproc.StatusCode
manually, but I want all of the error handling to be done in the stored
procedure.  The UDF should just return the StatusCode that was returned by
the stored proc on the database.

It doesn't look like this is possible, from everything I've seen there are
some errors in SQL Server that you just can't trap.  If I run the stored
proc in Query Analyzer and the insert fails, I see the insert failure error
message, but I also see the 'ERROR' text so I know that the statement is
executing alright.  It's just that as soon as CFMX gets the error message,
it terminates the statement, and cfstoredproc.StatusCode isn't set.

Any ideas, other than wrapping it in a try/catch block and manually setting
the error code?

-d
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: First foray into COM - getting an error

2003-12-15 Thread Nathan Mische

Are you running CFMX. If so make sure you have the proper Java stubs for
Outlook.

See Macromedia TechNote 22922, "Accessing Complex COM Objects in
ColdFusion MX using Java Stubs," for more info.

http://www.macromedia.com/support/coldfusion/ts/documents/tn18211.htm

--Nathan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 15, 2003 5:17 AM
To: CF-Talk
Subject: First foray into COM - getting an error

Why am I getting 

"An exception occurred when instantiating a Com object. 
The cause of this exception was that:
coldfusion.runtime.com.ComObjectInstantiationException: An exception
occurred when instantiating a Com object.. "

>From the following code ?




  name="objOutlook"
  class="Outlook.Application"
  action="">




  name="objOutlook"
  class="Outlook.Applicaton"
  action="">



Any COM folks shed some light onto this ?

Cheers,

Darren
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFMX, JBoss

2003-12-15 Thread [EMAIL PROTECTED]

Over the weekend, I have been trying to get CFMX 6.1, JBoss 3.2.3, and 
OS X  Panther 3.1 to play together.

After a bit of poking around (and some JBoss deployment info from 
NewAtlanta) the effort is mostly successful -- Consuming Web Services 
doesn't work.

Anyone out there running CFMX 6.1 with JBoss?

TIA

Dick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Adding remote datasource dynamically

2003-12-15 Thread Jochem van Dieten


CLASS="coldfusion.server.ServiceFactory" NAME="factory">


ds_service = factory.DataSourceService;

ds = StructNew();
ds.CLASS = "macromedia.jdbc.MacromediaDriver";
ds.DRIVER = "MSSQLServer";
ds.NAME = FORM.dsName;
ds.DATABASE = FORM.dbName;
ds.HOST = FORM.serverName;
ds.username = FORM.un;
ds.password = ds_service.encryptPasword(FORM.pwd);

urlPath = StructNew();		
	urlPath.DATABASE = FORM.dbName;
	urlPath.HOST = FORM.serverName;
	urlPath.PORT = 1433;
	urlPath.SELECTMETHOD = "direct";
	urlPath.SENDSTRINGPARAMETERSASUNICODE = "false";
// You might need to fix the following line, don't know if URLMAP 
is the correct name
ds.urlmap = urlPath;

ds_service["datasources"][FORM.dsName] = ds;

  			



> Execution results:
> 1) cfdump displays all datasources of the CFMX installation YET the new ds is not added;

There are various errors in the code where you use names of 
objects as strings instead of objects. Also, you assign values 
twice, which means the first value is overwritten.

> 2) error code/msg/detail is EMPTY

The code you gave shouldn't return an error because it is 
syntactically correct. It just doesn't do what you want it to do 
either.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Please disregard

2003-12-15 Thread Michael Dinowitz

That last post on the 2003 dishonest reporting reward was supposed to be send to
CF-Community. Please disregard it from CF-Talk.
Sorry
--
Michael Dinowitz
Finding technical solutions to the problems you didn't know you had yet
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Problems with Nulls

Hi Barney,

To answer your second question the Sybase database is not accessible on that part of the network, that would have made things too easy :)

This is actually a recurring task, how would you suggest to do it better?
  - Original Message - 
  From: Barney Boisvert 
  To: CF-Talk 
  Sent: Monday, December 15, 2003 3:16 PM
  Subject: RE: Problems with Nulls

  I suppose youre kiling your access db.  You could batch them so you only do
  a few hundred at a time, and then just rerequest the page to do the next
  500.  Keep your place in the sybase recordset with a session variable or
  something.  If this is a recurring thing, then you might have to get more
  creative, but from your original post, it sounded like a one-time deal.

  Perhaps a better question to ask would be if you've already got a Sybase
  server set up, why are you using access for this new app?

  Cheers,
  barneyb

  > -Original Message-
  > From: Mickael [mailto:[EMAIL PROTECTED] 
  > Sent: Monday, December 15, 2003 12:06 PM
  > To: CF-Talk
  > Subject: Re: Problems with Nulls
  > 
  > Hi Barney,
  > 
  > Thanks for the tip.  I keep getting this error
  > 
  > Request canceled or ignored by serverServer busy or unable to 
  > fulfill request. The server is unable to fulfill your request 
  > due to extremely high traffic or an unexpected internal 
  > error. Please attempt your request again (if you are 
  > repeatedly unsuccessful you should notify the site 
  > administrator). (Location Code: 26)
  > 
  > I am trying to insert about 36000 account that may have up to 
  > 3 records per account, it seem that I am overloading my 
  > server?  There is nothing else running.  Is there a way to 
  > throttle it back?
  > 
  > Mike
  >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

2003 Dishonest Reporting "Award"

2003-12-15 Thread Michael Dinowitz

http://www.honestreporting.com/a/2003dishonest.htm

  Communique: 15 December 2003

  2003 DISHONEST REPORTING "AWARD"

  Dear HonestReporting Subscriber,

  2003: It was the year of the road map, the year of the hudna. Abu Mazen
and Abu Ala, war in Iraq, targeted strikes in Gaza, the security fence.
Destruction of Maxim in Haifa, Cafe Hillel in Jerusalem, the horrific
"Children's Attack" on bus #2. The year that brought us an Israeli in space, Der
Stuermer in the UK, the homicide donkey, child guinea pigs, and Rachel Corrie.

  2003 was another trying year for Israel ? a nation fighting simultaneous,
uphill battles against terror and for fair coverage in the world media.

  With the year drawing to a close, HonestReporting regretfully presents the
third annual Dishonest Reporting "Award," our yearly recognition of the most
skewed and biased coverage of the Israeli-Palestinian conflict. Thanks for your
nominations and votes! We begin with the ignoble award "winner," followed by
recipients of Dishonorable Mention:

  IGNOBLE AWARD WINNER: REUTERS

   With over 200 news bureaus worldwide, Reuters stakes its claim as "the
largest international multi-media news agency." Though Reuters' own editorial
policy claims the agency's reporters "do not offer subjective opinion," and
intend merely "to enable readers and viewers to form their own judgement," in
fact Reuters' coverage of the Israeli-Palestinian conflict is flagrantly biased
against Israel. Some examples from 2003:

  * In January, Reuters blamed Israel for "killing" Palestinian suicide
bombers:

Iraq has paid millions of dollars to families of Palestinians, including
those of suicide bombers, killed by Israeli forces since the start of the
uprising in September 2000.

  * As Israel prepared to build a wall to protect worshippers at Rachel's
Tomb in Bethlehem, Reuters published this headline:

"Israel to Split Christ's Birthplace with Barrier"

  To emphasize its (completely external) point, Reuters repeated the word
"Christ" or "Christian" in each of the article's first four sentences.

  * On Nov. 18, two Israeli soldiers were killed outside Bethlehem and a
number of Palestinians were wounded in Gaza. Reuters had pictures of both
events, but journalists who subscribe to Reuters' photo service were encouraged
to publish the Palestinian victims in this email (emphasis added):

Dear User of the Reuters Pictures Archive,

Please find below a single picture presentation showing two Palestinians
rushing a wounded Palestinian to hospital in the Rafah refugee camp in the
southern part of the Gaza strip, November 18, 2003 :

  * When Palestinian terrorist groups announced a hudna with the PA, Israel
was not a party in the agreement, and the official road map demanded a full
disarming of terror groups ? not a temporary hudna cease-fire. Yet Reuters took
the opportunity to vilify Israel with the headline:

"Israel Pours Scorn on Truce With Militants"

  And when Israel did show flexibility for Palestinian demands, above and
beyond the roadmap's requirements? On Nov. 3, Reuters reported that Israel
reinstated 15,000 Palestinian work permits, and included this comment in a news
report:

150,000 Palestinians [previously] made a living in Israel, so Sunday's
restoration of 15,000 Israeli work permits is still only a drop in the ocean.

  Actually, 15,000 was fully 10%, and a risky loosening of anti-terror
policy. Even the Palestinian official quoted by Reuters called it "an important
step."

  *   *   *

  The previous examples are specific to particular articles, but Reuters'
anti-Israel bias extends to general editorial policy on terminology and
headlines:

  REUTERS' TERMINOLOGY

  Reuters' refusal to use the term "terrorism" or "terrorist" reached new
levels of absurdity this year. In November, Reuters released a list of "Worst
Guerilla Attacks since September 11" that omitted terror in Israel entirely.

  But beyond distancing itself from the term "terror," Reuters regularly
legitimized Palestinian terrorist groups and their murderous acts by ascribing
to them a worthy (though false) motive ? the pursuit of independence:

  The military wing of the Islamic militant group Hamas claimed
responsibility for the attack in a statement faxed to Reuters. Hamas has
spearheaded a 28-month-old Palestinian militant uprising against Israel for a
state in Gaza and the West Bank. (Feb. 15 - emphasis added)

  Or take this Oct. 3 Reuters photo and caption:

  Members of the Islamic movement Hamas burn the Israeli and the U.S. flag
over a model of the Star of David during a march through the streets of the
Jabalya refugee camp in Gaza and vow to continue the three-year-old uprising for
statehood. (emphasis added)

  Hamas makes it perfectly clear in their official charter that their goal
is the destruction of the State of Israel, and not m

Re:Adding remote datasource dynamically

Revised code:

  TYPE="JAVA"
  CLASS="coldfusion.server.ServiceFactory"
  NAME="factory">

			
  
    ds = 'coldfusion.server.ServiceFactory.DataSourceService.datasources';
    // neither work;  
    // ds = '#factory#.DataSourceService.datasources';			

    ds = StructNew();
    StructInsert(ds, "CLASS", "macromedia.jdbc.MacromediaDriver");
    StructInsert(ds, "DRIVER", "MSSQLServer");
    StructInsert(ds, "NAME", "#FORM.dsName#");
// StructInsert(ds, "DATABASE", "#FORM.dbName#");
// StructInsert(ds, "HOST", "#FORM.serverName#");
// from the ds dump it seems that urlmap is parallel to CLASS etc,
// hence, I changed it to the following, structure inside structure

urlPath = 'coldfusion.server.ServiceFactory.DataSourceService.datasources.urlmap.CONNECTIONPROPS';
urlPath = StructNew();		
 StructInsert(urlPath, "DATABASE", "#FORM.dbName#");
 StructInsert(urlPath, "HOST", "#FORM.serverName#");
StructInsert(urlPath, "PORT", "1433");
StructInsert(urlPath, "SELECTMETHOD", "direct");
StructInsert(urlPath, "SENDSTRINGPARAMETERSASUNICODE", "false");

    StructInsert(ds, "username", "#FORM.un#");
    StructInsert(ds, "password", "coldfusion.server.ServiceFactory..DataSourceService.encryptPasword(FORM.pwd)");
    // StructInsert(ds, "password", "#CFencrypt(FORM.pwd)#");  
			

 
	
	  #var#
	
	
 			

  


  


  





 
result: '#result#'


Execution results:
1) cfdump displays all datasources of the CFMX installation YET the new ds is not added;
2) error code/msg/detail is EMPTY

IMHO, password encryption is critical as well.  Much appreciated.

Don

> Chunshen (Don) Li wrote:
> 
> > I've realized without MM inside knowledge one can't accomplish the 
> task. Have you done anything similar?
> 
> I have done it without the passwords.
> 
> What is the error message?
> 
> Jochem
> 
> -- 
> When you don't want to be surprised by the revolution
> organize one yourself
 
> - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Using CFFile

2003-12-15 Thread S . Isaac Dealey

There's a copytree tag in the onTap framework core code that will copy
a whole directory and another deltree tag to delete, so to move a
directory structure, you'd specify copytree:
source-destination then deltree: source. If that sounds
helpful, all the source code is free on the site (see my sig), mangle
at will. :)

s. isaac dealey    214-823-9345

team macromedia volunteer  http://www.macromedia.com/go/team

chief architect, tapestry cms  http://products.turnkey.to

onTap is open source   http://www.turnkey.to/ontap


> I think you'd use CFDIRECTORY to read all the files in the
> directory and then loop over those results to copy/move
> them  (that's my 5 second analysis) ;-)

> Cheers

> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]

> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
>   - Original Message -
>   From: Robert Orlini
>   To: CF-Talk
>   Sent: Monday, December 15, 2003 11:45 AM
>   Subject: Using CFFile

>   Using CFfile, how do I copy more than one file at a
>   time?

>   The code below works great copying one file, but does
>   not accept more than one. For example lets say I want to
>   copy all the files in the "e:\template\" directory to
>   "d:\template"?

>   
>   source="e:\template\application.cfm"
>   destination="d:\template\">

>   Thanks.

>   Robert O.
>   Wilson

>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFLDAP ColdFusion 5 vs 6.1

2003-12-15 Thread Gormley Patrick-r34220

Tony,
Try changing "DN" to "START"

 

action="" 
START="uid=ozzyozzy, ou=Hong Kong, ou=services, o=cs" 
attributes="relmanager=Aardvark International Bank;The Bumble Bank Inc;"
separator=";" 
modifytype="REPLACE" 
server="test2.server.net" 
port="389" 
timeout="10" 
username="cn=Directory Manager" 
password="mypassword"
>

-Patrick

-Original Message-
From: T Pimm [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 15, 2003 6:33 AM
To: CF-Talk
Subject: CFLDAP ColdFusion 5 vs 6.1

Hi,  I'm having some problems with a couple of CFLDAP actions.  I am migrating an application from ColdFusion 5 to MX6.1 (runningn on Win2k, on IIS).  The following CFLDAP works with no problems on ColdFusion 5.  However, the same command throws an error on ColdFusion MX.


action="" 
DN="uid=ozzyozzy, ou=Hong Kong, ou=services, o=cs" 
attributes="relmanager=Aardvark International Bank;The Bumble Bank Inc;"
separator=";" 
modifytype="REPLACE" 
server="test2.server.net" 
port="389" 
timeout="10" 
username="cn=Directory Manager" 
password="mypassword"
>

How can this work perfectly on ColdFusion 5, and not on ColdFusion MX (both on the same server and another server).

The error thrown is this:

An error has occured while trying to execute modify :
[LDAP: error code 65 - Object Class Violation].  

One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server  

Please suggest any ideas.  I can't think of anything apart from some deprecated features or change to syntax, but I haven't seen anything!

Thanks for your help.
Tony. 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: cfmail in cf5 spool re-sends to infinity

Yup.  Seen this.  Been aggrivated by this.

> 1.  what causes this?  is it coldfusion, something auxillary, allignment 
> of stars?

My best guess is that this happens when the page is interrupted, but CF 
has finished writing the file, or at least a partial file.  Basically, 
Windows thinks CF is still using the file because CF never releases it. 
  However, CF has apparently forgotten all about it.

> 2. more importantly, what can be done to prevent this?  this scenario is 
> absolutely unaccepptable, ever.  It (or something) similar has only 
> happened about twice in 3 or 4 years, but that is 2 times to 
> many.  Should a 3rd party mail server be used to bypass anything 
> coldfusion does?  is this even coldfusion's fault?

Unfortunately, the only way to fix it I've found is to reboot the box, 
stop CF, and move or delete the file myself (so it doesn't send again).

Fortunately for us, this has only happened (that we know of) when the 
mail was unsendable, so we weren't bombarding people with eight billion 
copies of an email.

--Ben Doom
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

cfmail in cf5 spool re-sends to infinity

2003-12-15 Thread j cc

(setup: CF5/WIN2k/IIS)

Nice weekend for a nightmare mail scenario. One of our programs sent an email to one of our customers... think along the lines of "Thanks for triggering #thisEvent#!!!".

So cfmail sends the file to spool. Spool triggers after 60 seconds, and sends the email, and this is where the nightmare begins. After sending the email, spool tries to delete the spooled email:

---
Unable to move the spooled mail file, C:\CFusion\Mail\spool\13B1.cfmail. The process cannot access the file because it is being used by another
---

So after this error, the mail is still in the spool. 60 seconds later, the mail sends again. Again, it tries to move from spool. Again, it returns the same error. Again, the email is sent to the customer.

All in all, this email was sent SEVENTY NINE times to this very dissatisfied customer. as once a minute, every minute, this email was sent until an admin saw what was happening and restarted services.

I know how to stop this once this does happen, I've encountered file lock issues in other aspects of cf (cffile, cfexecute) So my questions, speficially...

1. what causes this? is it coldfusion, something auxillary, allignment of stars?

2. more importantly, what can be done to prevent this? this scenario is absolutely unaccepptable, ever. It (or something) similar has only happened about twice in 3 or 4 years, but that is 2 times to many. Should a 3rd party mail server be used to bypass anything coldfusion does? is this even coldfusion's fault?

any ideas would be greatly appreciated, and TIA

-Jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]

RE: Problems with Nulls

I suppose youre kiling your access db.  You could batch them so you only do
a few hundred at a time, and then just rerequest the page to do the next
500.  Keep your place in the sybase recordset with a session variable or
something.  If this is a recurring thing, then you might have to get more
creative, but from your original post, it sounded like a one-time deal.

Perhaps a better question to ask would be if you've already got a Sybase
server set up, why are you using access for this new app?

Cheers,
barneyb

> -Original Message-
> From: Mickael [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 15, 2003 12:06 PM
> To: CF-Talk
> Subject: Re: Problems with Nulls
> 
> Hi Barney,
> 
> Thanks for the tip.  I keep getting this error
> 
> Request canceled or ignored by serverServer busy or unable to 
> fulfill request. The server is unable to fulfill your request 
> due to extremely high traffic or an unexpected internal 
> error. Please attempt your request again (if you are 
> repeatedly unsuccessful you should notify the site 
> administrator). (Location Code: 26)
> 
> I am trying to insert about 36000 account that may have up to 
> 3 records per account, it seem that I am overloading my 
> server?  There is nothing else running.  Is there a way to 
> throttle it back?
> 
> Mike
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Using CFFile

Come to think of it, you could write a batch file that copies a whole 
directory and just call that.

*Outside* the box, Ben.  :-)

--Ben Doom

Bryan Stevenson wrote:

> Oh yayou could also use a custom tag to zip the entire directory's 
> contentmove that file...un-zip ;-)
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
> 
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
>   - Original Message -
>   From: Ben Doom
>   To: CF-Talk
>   Sent: Monday, December 15, 2003 11:54 AM
>   Subject: Re: Using CFFile
> 
>   Well, a single CFFILE call, as far as I know, can only move one file at
>   a time.  If you need to move a directory, as in your example, you can
>   use CFDIRECTORY and CFLOOP to run through every file in the directory
>   and copy them programatically.
> 
>   HTH.
> 
>   --Ben Doom
> 
>   Robert Orlini wrote:
> 
>   > Using CFfile, how do I copy more than one file at a time?
>   >
>   > The code below works great copying one file, but does not accept more
>   > than one. For example lets say I want to copy all the files in the
>   > "e:\template\" directory to "d:\template"?
>   >
>   > 
>   > destination="d:\template\">
>   >
>   > Thanks.
>   >
>   > Robert O.
>   > Wilson
>   >
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Adding remote datasource dynamically

2003-12-15 Thread Jochem van Dieten

Chunshen (Don) Li wrote:

> I've realized without MM inside knowledge one can't accomplish the task. Have you done anything similar?

I have done it without the passwords.

What is the error message?

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Problems with Nulls

Hi Barney,

Thanks for the tip.  I keep getting this error

Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26)

I am trying to insert about 36000 account that may have up to 3 records per account, it seem that I am overloading my server?  There is nothing else running.  Is there a way to throttle it back?

Mike

- Original Message - 
  From: Barney Boisvert 
  To: CF-Talk 
  Sent: Monday, December 15, 2003 1:17 PM
  Subject: RE: Problems with Nulls

  Around the dateFormat() call, add a CFIF that'll use isDate() to to decide
  if it should do the dateFormat(), or just insert NULL.  You can also use
  CFQUERYPARAM for the same task:

  #dateFormat(act_date,
  "mm/dd/")#NULL

  Or

  

  > -Original Message-
  > From: Mickael [mailto:[EMAIL PROTECTED] 
  > Sent: Monday, December 15, 2003 10:10 AM
  > To: CF-Talk
  > Subject: Problems with Nulls
  > 
  > Hello All,
  > 
  > I am running in to a problem on something that I do locally 
  > on our intranet.  I query one database(SYBASE) then load the 
  > data that I need in to an access database for a CF app that I 
  > have created.
  > 
  > There is section on the Sybase database where notes are 
  > entered then notes tables looks like this
  > 
  > AccountNumber
  > NoteDate
  > Notetime
  > Note
  > 
  > Then I loop over all these records and insert them in to my 
  > access database it works fine until I hit a record that has no date
  > 
  > I get this error
  > 
  > Error Diagnostic Information
  > ODBC Error Code = 22005 (Error in assignment)
  > 
  > 
  > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch 
  > in criteria _expression_.
  > 
  > 
  > SQL = "Insert into Client_comm (AccountNumber, Act_date, 
  > Act_time, Comments) Values (1081729, '','', '+Match 
  > Search (by SIN Number)---')"
  > 
  > In my access database the fields are as follows 
  > AccountNumber(Number), Act_date(date) Act_Time(text), Comments(text)
  > 
  > 
  > 
  > 
  > My Insert statement looks like this
  > 
  > 
  >    Insert into Client_comm 
  >    (AccountNumber, Act_date, Act_time, Comments)
  >    Values
  >    (#AccountNumber#, '#dateformat(act_date, 
  > "mm/dd/")#','#timeformat(act_time, "hh:mm:ss")#',  '#comments#')
  >    
  > 
  > Thanks
  > 
  > Mike
  > 
  > 
  >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Using CFFile

2003-12-15 Thread Bryan Stevenson

Oh yayou could also use a custom tag to zip the entire directory's contentmove that file...un-zip ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  - Original Message - 
  From: Ben Doom 
  To: CF-Talk 
  Sent: Monday, December 15, 2003 11:54 AM
  Subject: Re: Using CFFile

  Well, a single CFFILE call, as far as I know, can only move one file at 
  a time.  If you need to move a directory, as in your example, you can 
  use CFDIRECTORY and CFLOOP to run through every file in the directory 
  and copy them programatically.

  HTH.

  --Ben Doom

  Robert Orlini wrote:

  > Using CFfile, how do I copy more than one file at a time?
  > 
  > The code below works great copying one file, but does not accept more 
  > than one. For example lets say I want to copy all the files in the 
  > "e:\template\" directory to "d:\template"?
  > 
  > 
  > destination="d:\template\">
  > 
  > Thanks.
  > 
  > Robert O.
  > Wilson
  >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

Whoops, good call Novak, typed before I thought.

> -Original Message-
> From: cf-talk [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 15, 2003 11:43 AM
> To: CF-Talk
> Subject: RE: Scrambling Data
> 
> Actually I don't think there's a need to use varchar(32)... simply use
> char(32)
>  
> -Novak
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Adding remote datasource dynamically

I've realized without MM inside knowledge one can't accomplish the task. Have you done anything similar?  If so, care to share?  Thanks.

Don Li
[EMAIL PROTECTED]

>Rather than editing neo-query.xml directly, though, I'd recommend looking at
>using the appropriate ServiceFactory interface. Jochem has done a lot of
>good stuff documenting this:
>
>http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Using CFFile

Well, a single CFFILE call, as far as I know, can only move one file at 
a time.  If you need to move a directory, as in your example, you can 
use CFDIRECTORY and CFLOOP to run through every file in the directory 
and copy them programatically.

HTH.

--Ben Doom

Robert Orlini wrote:

> Using CFfile, how do I copy more than one file at a time?
> 
> The code below works great copying one file, but does not accept more 
> than one. For example lets say I want to copy all the files in the 
> "e:\template\" directory to "d:\template"?
> 
> 
> destination="d:\template\">
> 
> Thanks.
> 
> Robert O.
> Wilson
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Using CFFile

2003-12-15 Thread Bryan Stevenson

I think you'd use CFDIRECTORY to read all the files in the directory and then loop over those results to copy/move them  (that's my 5 second analysis) ;-)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  - Original Message - 
  From: Robert Orlini 
  To: CF-Talk 
  Sent: Monday, December 15, 2003 11:45 AM
  Subject: Using CFFile

  Using CFfile, how do I copy more than one file at a time?

  The code below works great copying one file, but does not accept more than one. For example lets say I want to copy all the files in the "e:\template\" directory to "d:\template"?

  
  destination="d:\template\">

  Thanks.

  Robert O.
  Wilson
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Using CFFile

2003-12-15 Thread Ian Skinner

With a Loop.

 
I don't think cold fusion was intended to be a heavy lifting file manager.

 
But, you can do a loop.  Combine it with a cfdirctory tag to read the
original directory it would even be fairly self sufficient.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:46 AM
To: CF-Talk
Subject: Using CFFile

Using CFfile, how do I copy more than one file at a time?

The code below works great copying one file, but does not accept more than
one. For example lets say I want to copy all the files in the "e:\template\"
directory to "d:\template"?


destination="d:\template\">

Thanks.

Robert O.
Wilson 
   _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Using CFFile

2003-12-15 Thread Robert Orlini

Using CFfile, how do I copy more than one file at a time?

The code below works great copying one file, but does not accept more than one. For example lets say I want to copy all the files in the "e:\template\" directory to "d:\template"?


destination="d:\template\">

Thanks.

Robert O.
Wilson
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread C. Hatton Humphrey

Thanks for all of the replies!  As I said, the possibility of outside eyes
reaching a database wasn't a worry before but this app is going to be a SSL
app on a shared server which makes me nervous to say the least.

 
The Hash() answer seems to be the most popular and provide the encryption
I'm looking for.  Thanks again!

 
Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread cf-talk

Actually I don't think there's a need to use varchar(32)... simply use
char(32)

 
-Novak

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 15, 2003 10:51 AM
To: CF-Talk
Subject: RE: Scrambling Data

Use hash() on the password before your insert (you'll need a varchar(32)
for
the result), and then when you select, use hash() again.  You'll never
be
able to get the original password out, you'll only be able to check a
password and see if it's the same.  That means you can't tell a user
what
their forgotten password is, you have to reasign it, but that's
generally a
pretty brainless excerise.

Cheers,
barneyb 

> -Original Message-
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 15, 2003 10:43 AM
> To: CF-Talk
> Subject: Scrambling Data
> 
> I am working out a database schema for an intranet and need 
> to figure out
> some way to mask the password field in the users table from 
> simple SELECT
> grabs.
> 
> I know that CF has some built-in encryption tools but I can't 
> remember what
> they are.  Can someone point me in the right direction?
> 
> At this moment I'm just trying to figure out what to store in 
> the database.
> I know I'll need a field for the password but do I need to 
> also provide a
> field for a key or key pair?
> 
> Thanks!
> Hatton
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
>  
> 
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread Mosh Teitelbaum

Sonofa

Learn something new every day.  Jeez.

Thanks Tom.

OK, so let me change that... if you'd like to hash using a different
(non-MD5) algorithm, check out the Dev Exchange 8^).

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/

-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 2:27 PM
To: CF-Talk
Subject: RE: Scrambling Data

How about hash()?
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt1113.
htm#1105551

I think this together with some salt should be fine for most users.

TK
  -Original Message-
  From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
  Sent: Monday, December 15, 2003 2:19 PM
  To: CF-Talk
  Subject: RE: Scrambling Data

  Hatton:

  I prefer salting and hashing passwords stored in a database.  The hashing
  provides one-way encryption and the salting protects against people who
have
  the same password.  MSDN has a good intro to password security at
  http://msdn.microsoft.com/msdnmag/issues/03/08/securitybriefs/default.aspx

  ColdFusion doesn't have any built-in hashing functions but there are some
  good CustomTags available at the Dev Exchange that do hashing.

  --
  Mosh Teitelbaum
  evoch, LLC
  Tel: (301) 942-5378
  Fax: (301) 933-3651
  Email: [EMAIL PROTECTED]
  WWW: http://www.evoch.com/

  -Original Message-
  From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
  Sent: Monday, December 15, 2003 1:43 PM
  To: CF-Talk
  Subject: Scrambling Data

  I am working out a database schema for an intranet and need to figure out
  some way to mask the password field in the users table from simple SELECT
  grabs.

  I know that CF has some built-in encryption tools but I can't remember
what
  they are.  Can someone point me in the right direction?

  At this moment I'm just trying to figure out what to store in the
database.
  I know I'll need a field for the password but do I need to also provide a
  field for a key or key pair?

  Thanks!
  Hatton

  ---
  Outgoing mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: RE: Scrambling Data

2003-12-15 Thread ksuh

CF has the hash() function, which does an MD5 hash.

- Original Message -
From: Mosh Teitelbaum <[EMAIL PROTECTED]>
Date: Monday, December 15, 2003 12:19 pm
Subject: RE: Scrambling Data

> Hatton:
> 
> I prefer salting and hashing passwords stored in a database.  The 
> hashingprovides one-way encryption and the salting protects 
> against people who have
> the same password.  MSDN has a good intro to password security at
> http://msdn.microsoft.com/msdnmag/issues/03/08/securitybriefs/default.aspx
> 
> ColdFusion doesn't have any built-in hashing functions but there 
> are some
> good CustomTags available at the Dev Exchange that do hashing.
> 
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 942-5378
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
> 
> -Original Message-
> From: C. Hatton Humphrey [EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 1:43 PM
> To: CF-Talk
> Subject: Scrambling Data
> 
> 
> I am working out a database schema for an intranet and need to 
> figure out
> some way to mask the password field in the users table from simple 
> SELECTgrabs.
> 
> I know that CF has some built-in encryption tools but I can't 
> remember what
> they are.  Can someone point me in the right direction?
> 
> At this moment I'm just trying to figure out what to store in the 
> database.I know I'll need a field for the password but do I need 
> to also provide a
> field for a key or key pair?
> 
> Thanks!
> Hatton
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread Tom Kitta

How about hash()?
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt1113.
htm#1105551

I think this together with some salt should be fine for most users.

TK
  -Original Message-
  From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
  Sent: Monday, December 15, 2003 2:19 PM
  To: CF-Talk
  Subject: RE: Scrambling Data

  Hatton:

  I prefer salting and hashing passwords stored in a database.  The hashing
  provides one-way encryption and the salting protects against people who
have
  the same password.  MSDN has a good intro to password security at
  http://msdn.microsoft.com/msdnmag/issues/03/08/securitybriefs/default.aspx

  ColdFusion doesn't have any built-in hashing functions but there are some
  good CustomTags available at the Dev Exchange that do hashing.

  --
  Mosh Teitelbaum
  evoch, LLC
  Tel: (301) 942-5378
  Fax: (301) 933-3651
  Email: [EMAIL PROTECTED]
  WWW: http://www.evoch.com/

  -Original Message-
  From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
  Sent: Monday, December 15, 2003 1:43 PM
  To: CF-Talk
  Subject: Scrambling Data

  I am working out a database schema for an intranet and need to figure out
  some way to mask the password field in the users table from simple SELECT
  grabs.

  I know that CF has some built-in encryption tools but I can't remember
what
  they are.  Can someone point me in the right direction?

  At this moment I'm just trying to figure out what to store in the
database.
  I know I'll need a field for the password but do I need to also provide a
  field for a key or key pair?

  Thanks!
  Hatton

  ---
  Outgoing mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread Dave Watts

> ColdFusion doesn't have any built-in hashing functions ...

Sure it does - Hash().

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread Dave Watts

> I am working out a database schema for an intranet and need 
> to figure out some way to mask the password field in the 
> users table from simple SELECT grabs.
> 
> I know that CF has some built-in encryption tools but I can't 
> remember what they are. Can someone point me in the right 
> direction?
> 
> At this moment I'm just trying to figure out what to store in 
> the database. I know I'll need a field for the password but do 
> I need to also provide a field for a key or key pair?

Lots of other people have directly addressed this by suggesting the use of
hashes (which is good if you can do that). I'll add to this by suggesting
the exclusive use of stored procedures and database rights to prevent the
selection of multiple user records within your application, also.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread Mosh Teitelbaum

Hatton:

I prefer salting and hashing passwords stored in a database.  The hashing
provides one-way encryption and the salting protects against people who have
the same password.  MSDN has a good intro to password security at
http://msdn.microsoft.com/msdnmag/issues/03/08/securitybriefs/default.aspx

ColdFusion doesn't have any built-in hashing functions but there are some
good CustomTags available at the Dev Exchange that do hashing.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 1:43 PM
To: CF-Talk
Subject: Scrambling Data

I am working out a database schema for an intranet and need to figure out
some way to mask the password field in the users table from simple SELECT
grabs.

I know that CF has some built-in encryption tools but I can't remember what
they are.  Can someone point me in the right direction?

At this moment I'm just trying to figure out what to store in the database.
I know I'll need a field for the password but do I need to also provide a
field for a key or key pair?

Thanks!
Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Oracle Sequences

2003-12-15 Thread kpeterson

You might need to increase your Sequence Number Cache size

You can read about it on OTN.

http://download-west.oracle.com/docs/cd/A87860_01/doc/index.htm

---cut---
When designing applications for Oracle Parallel Server, use sequence
numbers whenever possible. To maximize the use of sequences, each
instance's cache must be large enough to accommodate the sequences. The
default cache size holds 20 sequence numbers. To increase this, for example
to hold 200, use this syntax:

ALTER SEQUENCE SEQUENCE_NAME CACHE 200;

---cut---

---cut---
If sequences are insufficiently cached or not cached at all, severe
performance problems may result with an increase in service times. This may
also result in reduced scalability.

If you experience performance problems, examine statistics in the
V$SYSTEM_EVENT view as described below to determine whether the problem is
due to the use of Oracle sequences:

A problem with sequences appears in V$SYSTEM_EVENT as extended average wait
times for "row cache locks" in the range of a few hundred milliseconds. The
proportion of time waited for row cache locks of the total time waited for
non-idle events will be very high.

For the DC_SEQUENCES parameter, the ratio of DLM_CONFLICTS to DLM_REQUESTS
will be very high. If this ratio exceeds 10 to 15% and the row cache lock
wait time is a significant portion of the total wait time, then it is
likely that the deterioration of service times is due to insufficiently
cached sequences.

---cut---

Kore Peterson



  
<[EMAIL PROTECTED]
u.ac.uk> To: CF-Talk <[EMAIL PROTECTED]>  
 cc:  
12/15/2003   Subject: Oracle Sequences
06:43 AM  
Please respond
to cf-talk
  
  


Anybody ever had problems with the request for a sequence timing out?
I thought the database would have just queued them up?  Why would CF
keep hanging on them?

I've put a lock around the offending sequence to see if that solves it
but was wondering if there was any other possible problems out there?

This sequence is getting hit pretty heavily at the moment

Cheers

--
-dc  [ cf5, ora8.1.7, iis5 ]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread C. Hatton Humphrey

Systems that I have worked with in the past stored the password in a simple
VarChar field.  Therefore anyone with access to the database could do a
simple SELECT from the users table and get the password.

 
I'll take a look at HASH() and see what it does.

 
Hatton

   _  

From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 15, 2003 1:47 PM
To: CF-Talk
Subject: RE: Scrambling Data

Not sure what you mean by a SELECT grab, but I usually HASH() my passwords.
Of course this means you can never "tell" a user their forgotten password,
you'll have to use a verified reassignment process.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 10:43 AM
To: CF-Talk
Subject: Scrambling Data

I am working out a database schema for an intranet and need to figure out
some way to mask the password field in the users table from simple SELECT
grabs.

I know that CF has some built-in encryption tools but I can't remember what
they are.  Can someone point me in the right direction?

At this moment I'm just trying to figure out what to store in the database.
I know I'll need a field for the password but do I need to also provide a
field for a key or key pair?

Thanks!
Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003 
   _ 
   _  

[HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=t:4"Todays Threads]
[HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=i:4:147116"This
Message] [HYPERLINK
"http://www.houseoffusion.com/lists.cfm?link=s:4"Subscription] [HYPERLINK
"http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2581.2460.4"Fast
Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings]

   _  

HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=37" \n 

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Scrambling Data

2003-12-15 Thread Rick Root

The only really secure way is to store the password encrypted.

For example, in mysql:

INSERT INTO USERS (USERNAME, PWORD) VALUES ('foo', MD5('bar');

SELECT FROM USERS WHERE USERNAME='foo' AND PWORD=MD5('bar');

Like the other person said.. you can never "retrieve a forgotten 
password" when you do this... you'd have to reset it for them and then 
provide the new password to them, because there is no way of decrypting 
the password that's stored in the database (theoretically)

  - Rick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

Use hash() on the password before your insert (you'll need a varchar(32) for
the result), and then when you select, use hash() again.  You'll never be
able to get the original password out, you'll only be able to check a
password and see if it's the same.  That means you can't tell a user what
their forgotten password is, you have to reasign it, but that's generally a
pretty brainless excerise.

Cheers,
barneyb 

> -Original Message-
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 15, 2003 10:43 AM
> To: CF-Talk
> Subject: Scrambling Data
> 
> I am working out a database schema for an intranet and need 
> to figure out
> some way to mask the password field in the users table from 
> simple SELECT
> grabs.
> 
> I know that CF has some built-in encryption tools but I can't 
> remember what
> they are.  Can someone point me in the right direction?
> 
> At this moment I'm just trying to figure out what to store in 
> the database.
> I know I'll need a field for the password but do I need to 
> also provide a
> field for a key or key pair?
> 
> Thanks!
> Hatton
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
>  
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CF Dir

2003-12-15 Thread Robert Orlini

Hi,

I'm new to using cffile and cfdirectory. I need to create a template that will create a folder and a series of files in the folder after I submit a template with the info I type in. Is the code below for creating the new directory OK? Each new directory will be copied to the main directory which is "d:\_promotrials". The #name# will come from the form submission template. Thanks. 


directory name="d:\_promotrials\"
newdirectory="#name#">

Roberto O.
HWW
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Scrambling Data

2003-12-15 Thread Ian Skinner

Not sure what you mean by a SELECT grab, but I usually HASH() my passwords.
Of course this means you can never "tell" a user their forgotten password,
you'll have to use a verified reassignment process.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 10:43 AM
To: CF-Talk
Subject: Scrambling Data

I am working out a database schema for an intranet and need to figure out
some way to mask the password field in the users table from simple SELECT
grabs.

I know that CF has some built-in encryption tools but I can't remember what
they are.  Can someone point me in the right direction?

At this moment I'm just trying to figure out what to store in the database.
I know I'll need a field for the password but do I need to also provide a
field for a key or key pair?

Thanks!
Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003 
   _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Oracle Sequences

2003-12-15 Thread Deanna Schneider

I've never had a problem with them. But, our sites aren't extremely high
traffic.
-d

- Original Message - 
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 15, 2003 6:43 AM
Subject: Oracle Sequences

> Anybody ever had problems with the request for a sequence timing out?
> I thought the database would have just queued them up?  Why would CF
> keep hanging on them?
>
> I've put a lock around the offending sequence to see if that solves it
> but was wondering if there was any other possible problems out there?
>
> This sequence is getting hit pretty heavily at the moment
>
> Cheers
>
> -- 
> -dc  [ cf5, ora8.1.7, iis5 ]
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Scrambling Data

2003-12-15 Thread C. Hatton Humphrey

I am working out a database schema for an intranet and need to figure out
some way to mask the password field in the users table from simple SELECT
grabs.

I know that CF has some built-in encryption tools but I can't remember what
they are.  Can someone point me in the right direction?

At this moment I'm just trying to figure out what to store in the database.
I know I'll need a field for the password but do I need to also provide a
field for a key or key pair?

Thanks!
Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Active Directory: Finding user common name using username and password

2003-12-15 Thread Ian Skinner

I feel your pain, it took me a lot of fiddling to get the parameters just
right so that my cfldap tag got the information I needed.

 
  
   
"(&(objectCategory=CN=Person,CN=Schema,CN=Configuration,DC=smfbc,DC=org)(|(n
ame=#arguments.name#)(displayname=#arguments.name#)(givenName=#arguments.nam
e#)(sn=#arguments.name#)))">
  
   
"(&(objectCategory=CN=Person,CN=Schema,CN=Configuration,DC=smfbc,DC=org)(nam
e=#arguments.name#))">  


  
   name="Entity" username="xx" password="**"
   server="aServer"
   action="" attributes="displayname,mail,sn,cn,givenName,name"
   scope="subtree" start="DC=smfbc,DC=org"
   filter = "#filtersetting#">

The trick, as I remember it, is the grouping of the filter clause with
parentheses.  

 
HTH, feel free to ask more detailed questions, I'll answer them to the best
of my limited knowledge.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: kamran asli [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 4:30 AM
To: CF-Talk
Subject: Active Directory: Finding user common name using username and
password

Hi all.
I have come to this group after getting disappointed from so many 
places. I hope u ppl will be able to solve my problem.
I m trying to use cfladp tag to authenticate user against our domain. 
The problem I m having is that we have users divided in different 
groups. I m having problem in applying the filter attribute of the 
cfldap tag because having the username and password of the user I 
can't make his commmon name.
I m using the following code.

server = "myServer"   
action = "query" 
    attributes = "givenname,sn,mail,cn,memberOf" 
scope  = "subtree" 
start  = "dc=Wizzle,dc=360training,dc=com" 
filter = "(cn=?)"  
    username   = "mydomain\#loginInfo.username#" 
password   = "#loginInfo.password#" 
>
Any help is highly appreciated. 
   _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFLDAP ColdFusion 5 vs 6.1

2003-12-15 Thread T Pimm

Hi,  I'm having some problems with a couple of CFLDAP actions.  I am migrating an application from ColdFusion 5 to MX6.1 (runningn on Win2k, on IIS).  The following CFLDAP works with no problems on ColdFusion 5.  However, the same command throws an error on ColdFusion MX.


	action="" 
	DN="uid=ozzyozzy, ou=Hong Kong, ou=services, o=cs" 
	attributes="relmanager=Aardvark International Bank;The Bumble Bank Inc;"
	separator=";" 
	modifytype="REPLACE" 
	server="test2.server.net" 
	port="389" 
	timeout="10" 
	username="cn=Directory Manager" 
	password="mypassword"
>

How can this work perfectly on ColdFusion 5, and not on ColdFusion MX (both on the same server and another server).

The error thrown is this:

An error has occured while trying to execute modify :
[LDAP: error code 65 - Object Class Violation].  

One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server  

Please suggest any ideas.  I can't think of anything apart from some deprecated features or change to syntax, but I haven't seen anything!

Thanks for your help.
Tony.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: First foray into COM - getting an error

2003-12-15 Thread ksuh

Is outlook installed on the server where CF is installed?

- Original Message -
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Date: Monday, December 15, 2003 3:16 am
Subject: First foray into COM -  getting an error

> Why am I getting 
> 
> "An exception occurred when instantiating a Com object. 
> The cause of this exception was that:
> coldfusion.runtime.com.ComObjectInstantiationException: An exception
> occurred when instantiating a Com object.. "
> 
> 
> From the following code ?
> 
> 
> 	
> 	
>  name="objOutlook"
>  class="Outlook.Application"
>  action="">
> 	
> 	
>	
>	
>  name="objOutlook"
>  class="Outlook.Applicaton"
>  action="">
> 	
> 
> 
> Any COM folks shed some light onto this ?
> 
> Cheers,
> 
> Darren
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Active Directory: Finding user common name using username and password

2003-12-15 Thread kamran asli

Hi all.
I have come to this group after getting disappointed from so many 
places. I hope u ppl will be able to solve my problem.
I m trying to use cfladp tag to authenticate user against our domain. 
The problem I m having is that we have users divided in different 
groups. I m having problem in applying the filter attribute of the 
cfldap tag because having the username and password of the user I 
can't make his commmon name.
I m using the following code.

		server = "myServer"  
		action = "query"		
	   	attributes = "givenname,sn,mail,cn,memberOf"	 
		scope  = "subtree"			
		start  = "dc=Wizzle,dc=360training,dc=com"	
		filter = "(cn=?)"		
    username   = "mydomain\#loginInfo.username#"	
	password   = "#loginInfo.password#" 
		>
Any help is highly appreciated.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

First foray into COM - getting an error

2003-12-15 Thread [EMAIL PROTECTED]

Why am I getting 

"An exception occurred when instantiating a Com object. 
The cause of this exception was that:
coldfusion.runtime.com.ComObjectInstantiationException: An exception
occurred when instantiating a Com object.. "

>From the following code ?


	
	
  name="objOutlook"
  class="Outlook.Application"
  action="">
	
	
		
		
  name="objOutlook"
  class="Outlook.Applicaton"
  action="">
	


Any COM folks shed some light onto this ?

Cheers,

Darren
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Slightly OT: Building up a VBscript with CF then running it clien t side.

2003-12-15 Thread [EMAIL PROTECTED]

As I have been having trouble usign COM directly through CF  I've decided to
play arround with it using VBScript.
This works fine  locally but, once I run it on the server it  errors.

My Plan is to build up this script with CF so by the time it runs the values
have been set by data taken out of the database.
(the stage after that is to create a new contact item using a custom form)

Correctly me if I am wrong but,  won't this be run on client side  and thus
should run locally even if it has been built by CF on the server ?



Dim objOutlook

Dim itmContact

Dim strMsg



Const olContactItem = 2



'Create Outlook Object and Contact Item

    Set objOutlook = CreateObject("Outlook.application")

    Set itmContact = objOutlook.CreateItem(olContactItem)



'Query the User for the Contact Info

    itmContact.FullName = "Darren" 

	itmContact.Title = "Mr."

    itmContact.EMail1Address = "[EMAIL PROTECTED]" 

    itmContact.PrimaryTelephoneNumber = "123 456 7890" 

    itmContact.BusinessAddressStreet = "abc street" 

    itmContact.BusinessAddressCity = "ABCTown" 

    itmContact.BusinessAddressState = "ABC County" 

    itmContact.BusinessAddressPostalCode = "B11 1rr" 



'Save and display the Contact

    itmContact.Save

    itmContact.Display



'Clean up

    Set itmContact = Nothing

    Set objOutlook = Nothing


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Problems with Nulls

Around the dateFormat() call, add a CFIF that'll use isDate() to to decide
if it should do the dateFormat(), or just insert NULL.  You can also use
CFQUERYPARAM for the same task:

#dateFormat(act_date,
"mm/dd/")#NULL

Or



> -Original Message-
> From: Mickael [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 15, 2003 10:10 AM
> To: CF-Talk
> Subject: Problems with Nulls
> 
> Hello All,
> 
> I am running in to a problem on something that I do locally 
> on our intranet.  I query one database(SYBASE) then load the 
> data that I need in to an access database for a CF app that I 
> have created.
> 
> There is section on the Sybase database where notes are 
> entered then notes tables looks like this
> 
> AccountNumber
> NoteDate
> Notetime
> Note
> 
> Then I loop over all these records and insert them in to my 
> access database it works fine until I hit a record that has no date
> 
> I get this error
> 
> Error Diagnostic Information
> ODBC Error Code = 22005 (Error in assignment)
> 
> 
> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch 
> in criteria _expression_.
> 
> 
> SQL = "Insert into Client_comm (AccountNumber, Act_date, 
> Act_time, Comments) Values (1081729, '','', '+Match 
> Search (by SIN Number)---')"
> 
> In my access database the fields are as follows 
> AccountNumber(Number), Act_date(date) Act_Time(text), Comments(text)
> 
> 
> 
> 
> My Insert statement looks like this
> 
> 
>    Insert into Client_comm 
>    (AccountNumber, Act_date, Act_time, Comments)
>    Values
>    (#AccountNumber#, '#dateformat(act_date, 
> "mm/dd/")#','#timeformat(act_time, "hh:mm:ss")#',  '#comments#')
>    
> 
> Thanks
> 
> Mike
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Problems with Nulls

2003-12-15 Thread Janine Jakim

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 10:28 AM
To: CF-Talk
Subject: Problems with Nulls

Hello All,

I am running in to a problem on something that I do locally on our intranet.
I query one database(SYBASE) then load the data that I need in to an access
database for a CF app that I have created.

There is section on the sysbase database where notes are entered then notes
tables looks like this

AccountNumber
NoteDate
Notetime
Note

Then I loop over all these records and insert them in to my access database
it works fine until I hit a record that has no date

I get this error

Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
_expression_.

SQL = "Insert into Client_comm (AccountNumber, Act_date, Act_time, Comments)
Values (1081729, '','', '+Match Search (by SIN Number)---')"

In my access database the fields are as follows AccountNumber(Number),
Act_date(date) Act_Time(text), Comments(text)

My Insert statment looks like this


   Insert into Client_comm 
   (AccountNumber, Act_date, Act_time, Comments)
   Values
   (#AccountNumber#, '#dateformat(act_date,
"mm/dd/")#','#timeformat(act_time, "hh:mm:ss")#',  '#comments#')
   

Thanks

Mike 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Problems with Nulls

Hello All,

I am running in to a problem on something that I do locally on our intranet.  I query one database(SYBASE) then load the data that I need in to an access database for a CF app that I have created.

There is section on the sysbase database where notes are entered then notes tables looks like this

AccountNumber
NoteDate
Notetime
Note

Then I loop over all these records and insert them in to my access database it works fine until I hit a record that has no date

I get this error

Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria _expression_.

SQL = "Insert into Client_comm (AccountNumber, Act_date, Act_time, Comments) Values (1081729, '','', '+Match Search (by SIN Number)---')"

In my access database the fields are as follows AccountNumber(Number), Act_date(date) Act_Time(text), Comments(text)


My Insert statment looks like this


   Insert into Client_comm 
   (AccountNumber, Act_date, Act_time, Comments)
   Values
   (#AccountNumber#, '#dateformat(act_date, "mm/dd/")#','#timeformat(act_time, "hh:mm:ss")#',  '#comments#')
   

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:[OT] Looking for some pre-build solutions

>Author: Richard Crawford
>Second, how about a web-based project/task management or tracking tool?

Hi,

This is part of an application for a real estate contractor for fixing home/apartment problems.
There are four User Roles, backend db can either be MS SQL Server or MS Access.  
URL, http://68.32.61.40/richardp/login.cfm
Test accounts: userName/password pair below.

System Admin / Owner: tpr/root
Builder: builder/123
Contractor: contractor/123
Customer: customer/123

Feel free to play with it.  Tons of junk data.  Your comments are welcome.

Don Li
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Oracle Sequences

2003-12-15 Thread d.a.collie

Anybody ever had problems with the request for a sequence timing out?  
I thought the database would have just queued them up?  Why would CF
keep hanging on them?

I've put a lock around the offending sequence to see if that solves it
but was wondering if there was any other possible problems out there?

This sequence is getting hit pretty heavily at the moment

Cheers

-- 
-dc  [ cf5, ora8.1.7, iis5 ]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Problems with Nulls