RE: Coldfusion Crashing!

2005-07-08 Thread Shahzad.Butt
Thanks a lot for all your help guys. After struggling two days/nights
and done all the audit etc. I sort of gave up and upgraded to MX6.1. It
hasn't really fixed the problem as such but the number of crashes has
been significantly reduced. I've found out in the application, some
third party calls to Visual Fox pro (ODBC) and pages using OPENQUERY 've
been causing the crash at peak hours when the server running that Fox
Pro application is quite busy and not responding in timely fashion.
Coldfusion5.0 was just hanging in there and waiting probably forever for
that thread to respond - result ofcourse crash after few minutes.
However MX is taking care of that side and takes a significant amount of
unresponsive threads before it crashes (3 or 4 times) a day. Now I am
going through the code and trying to avoid the OPENQUERY and also
unnecessary calls to the fox pro DB.

've a great weekend!!
Shaz 

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: 05 July 2005 22:16
To: CF-Talk
Subject: Re: Coldfusion Crashing!

The issues Jennifer and Steven brought up were pretty much spot on. 
If you have something hanging a request and you pile on simultaneous
requests that will do nothing to address the bottleneck.

I would do things a little differently but the same basic principles
apply.  First of all, I'm going to assume this is a crisis situation,
and you need at least a resemblence of stability first and
diagnosis/correction can follow, so long as you stop the system from
dying.

First, REDUCE the number of simultaneous threads to as low of a number
as you can, with one being the minimum and the most stable setting. 
Just because its more likely to be stable doesn't mean it will perform
'well'.  This will indeed introduce a performance bottleneck, but its
meant to.  When in crisis mode this is often the way to stabilize a
server in an emergency, letting it run long enough to work towards a
fix while users get to keep using it.  Be careful (i.e. watch it while
this is going on to make sure you have not created a new problem). 
Still, only the busiest box will time threads out that are queued as
the result of this.

Next enable a CF restart after X threads have hung, where the restart
value is one LESS than the value set in the first step above.  Set the
hung thread count higher than the simultaneous request count and it
will never fire.  In an emergency situation I would set this to one
(1) thread.  Again, pay close attention to what is going on because
the only thing worse than a CF box that keeps dying is one that
restarts itself every 15 seconds.  Yes, this is aggressive but if you
get even one hung thread chances are by the time the second one
arrives CF will be done for and no longer able to restart itself
without human intervention.

Next, enable the tracking of long-running page requests.  If the above
two steps have stabilized your server enough so it can run (bearing in
mind that each or the two in tandem can make things worse for a
heavy-traffic box), this remains an excellent tool for debugging,
despite its noted weaknesses.

lastly, be sure to check your mail spool file.  What is being
described sounds a lot like that problem.  I ran into it on a CF5 box
a few months back and CF was dying and as soon as it got started up
again it instantly croaked until I remembered this problem, checked
for it and deleted the offending file (you have to stop the CF service
first or the file will be locked and is undeletable.

HtH,

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211415
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Coldfusion Crashing!

2005-07-05 Thread Shahzad.Butt
Hi all, I am running Coldfusion 5.0 on Windows 2000 machine using SQL
Server 2000. The system has been working fine for last couple of years
and never had any issue however since yesterday the Coldfusion server is
crashing and I've to restart all the Coldfusion Services to get my
Intranet (or any other Coldfusion app) work. There's been no apparent
cause and nothing is in the log files either apart from just one error
(100s of times) in Webserver.log file, the error goes like 

 

Error,3068,07/05/05,11:18:47,,Request canceled or ignored by
server Server 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)

 

Any help is highly appreciated!!

 

Thanks,

Shaz

+44 7985 884 474

 



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211120
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Coldfusion Crashing!

2005-07-05 Thread Shahzad.Butt
Doubled (previously 10 now 20) the number of simultaneous requests
through Coldfusion Administrator interface but still the same problem.
Any ideas??

Thanks,
Shaz

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 05 July 2005 11:39
To: CF-Talk
Subject: RE: Coldfusion Crashing!

Looks like your system has reached the maximum # of simultaneous
requests -
try upping it via the CFIDE.



-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 05 July 2005 11:36
To: CF-Talk
Subject: Coldfusion Crashing!

Hi all, I am running Coldfusion 5.0 on Windows 2000 machine using SQL
Server 2000. The system has been working fine for last couple of years
and never had any issue however since yesterday the Coldfusion server is
crashing and I've to restart all the Coldfusion Services to get my
Intranet (or any other Coldfusion app) work. There's been no apparent
cause and nothing is in the log files either apart from just one error
(100s of times) in Webserver.log file, the error goes like 

 

Error,3068,07/05/05,11:18:47,,Request canceled or ignored by
server Server 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)

 

Any help is highly appreciated!!

 

Thanks,

Shaz

+44 7985 884 474

 



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211127
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


XML from CF

2005-02-08 Thread Shahzad.Butt
I got .cfm file with some CF code (query and output) in it. A third
party application needs to read the XML file (containing same code but
in XML format). How can get that coldfusion file to output in XML?

 

Thanks,
Shaz



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193594
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Storing CGI vars in text file using HTTP Post

2004-09-16 Thread Shahzad.Butt
Hi 

I am trying to use HTTP POST to send the cgi vars to a cfm file which
store all the cgi vars in a text file. But the text file has all those %
in it. My code is as follows

cfhttp method = post url = "">

cfhttpparam

name = cgiVar type = CGI value =
CGI.AUTH_TYPE:#CGI.AUTH_TYPE# --
CGI.CONTENT_LENGTH:#CGI.CONTENT_LENGTH# --
CGI.CONTENT_TYPE:#CGI.CONTENT_TYPE# -- CGI.PATH_INFO:#CGI.PATH_INFO# --
CGI.PATH_TRANSLATED:#CGI.PATH_TRANSLATED# 

CGI.QUERY_STRING:#CGI.QUERY_STRING# --
CGI.REMOTE_ADDR:#CGI.REMOTE_ADDR# -- CGI.REMOTE_HOST:#CGI.REMOTE_HOST#
#CGI.REMOTE_USER# #CGI.REQUEST_METHOD# #CGI.SCRIPT_NAME#
#CGI.GATEWAY_INTERFACE# #CGI.SERVER_NAME# #CGI.SERVER_PORT#
#CGI.SERVER_PROTOCOL# #CGI.SERVER_SOFTWARE# #CGI.CERT_ISSUER#
#CGI.CERT_SUBJECT# #CGI.CLIENT_CERT_ENCODED# #CGI.HTTP_ACCEPT#
#CGI.HTTP_IF_MODIFIED_SINCE# #CGI.HTTP_USER_AGENT#

/cfhttp

Test.cfm

cffile action="" file=C:\HTTPTest.txt output=

[#DateFormat(Now())# #TimeFormat(Now())#]

CGI Vars from file are: #CGI.cgiVar# 

 

Is there any other better way of doing it?

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Storing CGI vars in text file using HTTP Post

2004-09-16 Thread Shahzad.Butt
Great thanks

_

From: Pascal Peters [mailto:[EMAIL PROTECTED] 
Sent: 16 September 2004 12:14
To: CF-Talk
Subject: RE: Storing CGI vars in text file using HTTP Post

Use type=formfield and then #form.cgiVar# in the other page

Pascal
 http://www.houseoffusion.com/banners/view.cfm?bannerid=38 

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Assigning value to property using COM

2004-09-15 Thread Shahzad.Butt
I am using COM and trying to assign a value to the property. In the code
below the lines with ***  is VB code and the line beneath is
coldfusion equivalent of that line.

Set Axapta = CreateObject(AxaptaCOMConnector.Axapta)
cfobject action="" class=#Attributes.ProgId# type=COM
name=AXCom

***Axapta.Logon***
CFSet a = Axapta.Logon()

*** MyRecord = Axapta.CreateRecord(CCMCTIInbound)***

CFSet myRecord = Axapta.CreateRecord(CCMCTIInbound)

***MyRecord.field(UserID) = Shaz***

CFSet myRecord.field(UserID) = Shaz

The line above (in bold) throws an error saying

Unable to assign a value to the function field on line 16, column 16.


Which is pretty obvious that we cant assign a value to function though
in VB we could do it as it's a property. Is there any work around for
that.

Thanks

Shaz



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




COM Problem

2004-09-14 Thread Shahzad.Butt
I wonder if someone can write me the Coldfusion Code for the following
VB Code.

Sub CreateCall()

Dim MyRecord As Object

Set Axapta = CreateObject(AxaptaCOMConnector.Axapta)

Axapta.Logon

Set MyRecord = Axapta.CreateRecord(CCMCTIInbound)

MyRecord.InitValue

MyRecord.field(UserID) = gp1

MyRecord.field(Number) = 

MyRecord.Insert

Axapta.Logoff

End Sub

I can only write the first line

cfobject action="" class=#Attributes.ProgId# type=COM name=
Axapta

Thanks

Shaz



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Delete problem

2004-09-08 Thread Shahzad.Butt
I know its more of sql problem. I want to delete just one row of
ProductCode appearing twice in EPIC table.

EPIC

ProductCodecostsell supplier

CHP034 2 ABC

CHP033 2 DEF

...

I just want to delete one CHP03 so I will still have atleast one in my
table.

Any suggestions?

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Delete problem

2004-09-08 Thread Shahzad.Butt
Can't do that as I have thousands of products with different cost
prices. I was just giving an example.

This query finds out all the product codes which appear more than once

select ProductCode

from EPIC

group by ProductCode

Having Count(ProductCode)  1

But this query

DELETE FROM EPIC

WHERE ProductCode IN

(

select ProductCode

from EPIC

group by ProductCode

Having Count(ProductCode)  1

)

Will delete all the ones appearing more than once. I want it to leave
one row for each product code appearing more than once.

Shaz

_

From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: 08 September 2004 11:08
To: CF-Talk
Subject: Re: Delete problem

Do the same as a select, so
DELETE FROM EPIC
WHERE ProductCode = 'CHP03'
AND cost = 3

MD

On Wed, 8 Sep 2004 11:04:24 +0100, Shahzad.Butt
[EMAIL PROTECTED] wrote:
 I know its more of sql problem. I want to delete just one row of
 ProductCode appearing twice in EPIC table.
 
 EPIC
 
 ProductCodecostsell supplier
 
 CHP034 2 ABC
 
 CHP033 2 DEF
 
 ...
 
 I just want to delete one CHP03 so I will still have atleast one in my
 table.
 
 Any suggestions?
 
 **
 This email and any files transmitted with it are confidential
 and intended solely for use by the individual or entity to
 whom it is addressed. If you have received this e-mail in
 error, kindly notify [EMAIL PROTECTED] or call
 +44 1992 701 704. Unless stated otherwise, please note
 that any views or opinions expressed in this e-mail are solely
 that of the author and are not necessarily of
 JJ Fast Food Distribution Limited. The company can not
 assure that the integrity of this communication has been
 maintained nor that it is free of errors, virus, interception or
 interference. The company accepts no liability for any
 damage caused by this email. JJ Fast Food Distribution
 Limited reserves the right to monitor and or record e-mail
 without prior notification.
 **
 


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




RE: Delete problem

2004-09-08 Thread Shahzad.Butt
Can't do that as I have thousands of products with different cost
prices. I was just giving an example.

This query finds out all the product codes which appear more than once

select ProductCode

from EPIC

group by ProductCode

Having Count(ProductCode)  1

But this query

DELETE FROM EPIC

WHERE ProductCode IN

(

select ProductCode

from EPIC

group by ProductCode

Having Count(ProductCode)  1

)

Will delete all the ones appearing more than once. I want it to leave
one row for each product code appearing more than once.

_

From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: 08 September 2004 11:08
To: CF-Talk
Subject: Re: Delete problem

Do the same as a select, so
DELETE FROM EPIC
WHERE ProductCode = 'CHP03'
AND cost = 3

MD
On Wed, 8 Sep 2004 11:04:24 +0100, Shahzad.Butt
[EMAIL PROTECTED] wrote:
 I know its more of sql problem. I want to delete just one row of
 ProductCode appearing twice in EPIC table.

 EPIC
 ProductCodecostsell supplier
 CHP034 2 ABC
 CHP033 2 DEF
 I just want to delete one CHP03 so I will still have atleast one in my
 table.
 
 Any suggestions?



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Delete problem

2004-09-08 Thread Shahzad.Butt
Thanks everyone. I have used some CF to do so

cfquery name=Get datasource=EPICCleanerDSN

SELECT *

FROMItemsMissingFields

ORDER BY Code

/cfquery

cfoutput query=Get

cfquery name=getcode datasource=EPICCleanerDSN

select code

from ItemsMissingFields

where id = #get.id#

/cfquery

cfquery name=checkifduplicate
datasource=EPICCLeanerDSN

Select Count(*) mycount

From itemsmissingfields

where code = '#getcode.code#'

/cfquery

CFIF checkifDuplicate.mycount GT 1

cfquery name=DeleteDuplicates
datasource=EPICCleanerDSN

DELETE FROM ItemsMissingFields

WHERE ID = '#get.id#'

/cfquery

DELETE FROM ItemsMissingFields

WHERE ID = '#get.id#'

br

/CFIF

/cfoutput

_

From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: 08 September 2004 12:32
To: CF-Talk
Subject: Re: Delete problem

Not fully though out.. but .. 
could you not select the distinct by ProductCode into a new table (so
it just gets the first instance?)

MD

On Wed, 8 Sep 2004 12:22:01 +0100, Michael Traher
[EMAIL PROTECTED] wrote:
 I don't think so although my thinking went down this road as well
 It does not work because the product code is the part that repeats, so
 I think this would delete zero rows
 
 
 - Original Message -
 From: Adrian Lynch [EMAIL PROTECTED]
 Date: Wed, 8 Sep 2004 11:59:06 +0100
 Subject: RE: Delete problem
 To: CF-Talk [EMAIL PROTECTED]
 
 DELETE FROM EPIC
 WHERE ProductCode IN (
 SELECT ProductCode
 FROM EPIC
 GROUP BY ProductCode
 HAVING COUNT(ProductCode)  1
 ) AND ProductCode  (
 SELECT TOP 1 ProductCode
 FROM EPIC
 GROUP BY ProductCode
 HAVING COUNT(ProductCode)  1
 )
 
 Would that do it?
 
 Ade
 
 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: 08 September 2004 11:18
 To: CF-Talk
 Subject: RE: Delete problem
 
 Can't do that as I have thousands of products with different cost
 prices. I was just giving an example.
 
 This query finds out all the product codes which appear more than once
 
 select ProductCode
 
 from EPIC
 
 group by ProductCode
 
 Having Count(ProductCode)  1
 
 But this query
 
 DELETE FROM EPIC
 
 WHERE ProductCode IN
 
 (
 
 select ProductCode
 
 from EPIC
 
 group by ProductCode
 
 Having Count(ProductCode)  1
 
 )
 
 Will delete all the ones appearing more than once. I want it to leave
 one row for each product code appearing more than
 once.

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




RE: Delete problem

2004-09-08 Thread Shahzad.Butt
Thanks everyone. I have used some CF to do so

cfquery name=Get datasource=EPICCleanerDSN

SELECT *

FROMItemsMissingFields

ORDER BY Code

/cfquery

cfoutput query=Get

cfquery name=getcode datasource=EPICCleanerDSN

select code

from ItemsMissingFields

where id = #get.id#

/cfquery

cfquery name=checkifduplicate

datasource=EPICCLeanerDSN

Select Count(*) mycount

From itemsmissingfields

where code = '#getcode.code#'

/cfquery

 CFIF checkifDuplicate.mycount GT 1

cfquery name=DeleteDuplicates

datasource=EPICCleanerDSN

DELETE FROM ItemsMissingFields

WHERE ID = '#get.id#'

/cfquery

DELETE FROM ItemsMissingFields

WHERE ID = '#get.id#'

br

/CFIF

/cfoutput



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Delete problem

2004-09-08 Thread Shahzad.Butt
Thanks everyone. I have used some CF to do so

cfquery name=Get datasource=EPICCleanerDSN

SELECT *

FROMItemsMissingFields

ORDER BY Code

/cfquery

cfoutput query=Get

cfquery name=getcode datasource=EPICCleanerDSN

select code

from ItemsMissingFields

where id = #get.id#

/cfquery

cfquery name=checkifduplicate datasource=EPICCLeanerDSN

Select Count(*) mycount

From itemsmissingfields

where code = '#getcode.code#'

/cfquery

 CFIF checkifDuplicate.mycount GT 1

cfquery name=DeleteDuplicates
datasource=EPICCleanerDSN

DELETE FROM ItemsMissingFields

WHERE ID = '#get.id#'

/cfquery

 /CFIF

/cfoutput

Shaz





**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Javascript window.opener error

2004-08-10 Thread Shahzad.Butt
I am trying to populate a select box in FORM1 from a window which is
originally opened by this form (FORM1). My browser is throwing error for
some reason. I wonder if someone can tell me whats wrong with the
following code?

function PopulateLocality()

{

with (window.opener.document.forms[0])

{

locality.options.length=0;

for (var i = 0; i 
Locality.getRowCount(); i++)

{

locality.options[i]= new
Option(Locality.alias_name[i],Locality.id[i]);



}

}

}

When I try to populate the select box in the same window not the parent
then it works fine but that's not what I want



Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Desc Output

2004-08-06 Thread Shahzad.Butt
How can I output the results of the query starting from last record
found by query and finishing at starting record found? Can't change the
Order by from Desc to Asc in the query because of loads of reasons.



Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: XML load

2004-07-27 Thread Shahzad.Butt
Following is the code

cfhttp
url="">
license_code=XE47-EP93-RD59-GW24action="">
tcode=EN8%208RZ

method=GET

resolveUrl=false 

/cfhttp

cfoutput

cfxml variable=myxml

rootelement#cfhttp.filecontent#/rootelement

/cfxml

cfdump var=#myxml#

/cfoutput

It shows no contents in the browser however if you just open the URL in
the browser you can see the file. Is there anything I am missing or
doing wrong?

Shaz

_

From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: 26 July 2004 18:21
To: CF-Talk
Subject: Re: XML load

You probably will need to do something like this to parse it

cfxml variable=myxml
rootelement#mypacket#/rootelement
/cfxml

I believe (though I could be mistaken) that error indicates that there
are multiple tag-pairs at the root. Valid XML must have only one
tag-pair at the root with all other elements contained within them.

 On Monday 26 Jul 2004 15:51 pm, Shahzad.Butt wrote:
 On CFMX6.1 it gives error Document root element is
 missing.

 It probably is.
 What are the first few lines of the XML string ?

 --
 Tom Chiverton
 Advanced ColdFusion Programmer



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




RE: XML load

2004-07-27 Thread Shahzad.Butt
Thanks everyone. I think it must be the CFMX version causing issues
because I have run the code on new server (with fresh CFMX installation)
and it works fine.

Thanks

Shaz

_

From: Pascal Peters [mailto:[EMAIL PROTECTED] 
Sent: 27 July 2004 13:17
To: CF-Talk
Subject: RE: XML load

I ran your code and it worked perfectly. You don't even need the
rootelement tag (there is one). Make sure you don't suppress the output
somehow.

Pascal

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: 27 July 2004 12:07
 To: CF-Talk
 Subject: RE: XML load
 
 Following is the code
 cfhttp

url="">

license_code=XE47-EP93-RD59-GW24action="">
 tcode=EN8%208RZ
 method=GET
 resolveUrl=false
 /cfhttp
 cfoutput
 cfxml variable=myxml

rootelement#cfhttp.filecontent#/rootelement
 /cfxml
 cfdump var=#myxml#
 /cfoutput

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




XML load

2004-07-26 Thread Shahzad.Butt
Hi

How can I load an XML file and display the contents on my CFM page i.e.
there is an XML file at (lets say http://www.abc.com/test.xml). How can
I get the data from this file and loop over a particular item in my CFM
page?

Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: XML load

2004-07-26 Thread Shahzad.Butt
Will XMLParse() work on CF5.0? currently its giving an error on CF5.0.


On CFMX6.1 it gives error Document root element is missing. 



Any ideas on that?

Shaz

_

From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: 26 July 2004 15:47
To: CF-Talk
Subject: Re: XML load

XMLTransform ... duh... :) You can see how much I've used it. :)

 On Monday 26 Jul 2004 15:25 pm, S. Isaac Dealey wrote:
 also XMLTranslate() (?) I think that's the name of the
 XSLT
 function...

 Well, yes :-)
 If the question hadn't so specific, I'd have pointed at
 http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/fun
 cti20.htm#wp3468770
 and
 http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/xml
 .htm

 --
 Tom Chiverton
 Advanced ColdFusion Programmer

s. isaac dealey954.927.5117

new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477DE=1

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




RE: XML load

2004-07-26 Thread Shahzad.Butt
-
http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1
license_code=XE47-EP93-RD59-GW24action="">
e=EN8%208RZ##

PostcodeAnywhere Server=WS02 Version=2.0 Date=26/07/2004
14:35:22 Duration=0.016s

-
http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1
license_code=XE47-EP93-RD59-GW24action="">
e=EN8%208RZ##Schema Items=3

Field Name=id / 

Field Name=seq / 

Field Name=description / 

/Schema

-
http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1
license_code=XE47-EP93-RD59-GW24action="">
e=EN8%208RZ##Data Items=40

Item id=29512157 seq=0 description=1 Westgate Court Waltham
Cross EN8 8OL / 

 

Item id=29512196 seq=39 description=40 Westgate Court Waltham
Cross EN8 8OL / 

 /Data

 /PostcodeAnywhere



_

From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: 26 July 2004 16:03
To: CF-Talk
Subject: Re: XML load

On Monday 26 Jul 2004 15:51 pm, Shahzad.Butt wrote:
 On CFMX6.1 it gives error Document root element is missing.

It probably is.
What are the first few lines of the XML string ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

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




Hidden Varaibles

2004-06-29 Thread Shahzad.Butt
Hi - I know its more of a JS question than CF but I wonder if someone
can help me out. In my _javascript_ function I am assigning values to the
form variable. All I need is an IF statement that if the form variable
is hidden variable then don't assign anything. So in short I need to
find out the way in JS that if the variable is hidden form variable...

Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Hidden Varaibles

2004-06-29 Thread Shahzad.Butt
Hi - I know its more of a JS question than CF but I wonder if someone
can help me out. In my _javascript_ function I am assigning values to the
form variable. All I need is an IF statement that if the form variable
is hidden variable then don't assign anything. So in short I need to
find out the way in JS that if the variable is hidden form variable...

Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Hidden Varaibles

2004-06-29 Thread Shahzad.Butt
Thanks Pascal - yeah I meant hidden form field.

Cheers!

shaz

_

From: Pascal Peters [mailto:[EMAIL PROTECTED] 
Sent: 29 June 2004 10:04
To: CF-Talk
Subject: RE: Hidden Varaibles

Error in my previous mail:
if(document.myform.myfield.type != hidden) {

Pascal

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




Evaluate?

2004-06-24 Thread Shahzad.Butt
Hello - can you please check the code below

CFSet GetAllContactTypes.PK_ContactType_ID =
CAA07070-CD2A-46D6-951F-653630BFD539

cfoutput

CFSet a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)#

/cfoutput



Its giving error though from the previous page value of form variable
named CAA07070-CD2A-46D6-951F-653630BFD539 is passed to this page.





Error Diagnostic Information

An error occurred while evaluating the _expression_: 

 a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)#

Error near line 10, column 18. 

_

An error has occurred while processing the _expression_:

Form.CAA07070-CD2A-46D6-951F-653630BFD539

Invalid parser construct found on line 1 at position 22. ColdFusion was
looking at the following text:

D6



Form Fields:

 
02E4F04B-4893-442D-AEAB-859F607B52B1=
02F2DF44-7063-4217-9052-C5E4179CBC73=
CAA07070-CD2A-46D6-951F-653630BFD539=fdf



**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Evaluate?

2004-06-24 Thread Shahzad.Butt
Good job - thx

CFSET a = Form[GetAllContactTypes.PK_ContactType_ID] works

Shaz

_

From: JediHomer [mailto:[EMAIL PROTECTED] 
Sent: 24 June 2004 10:58
To: CF-Talk
Subject: Re: Evaluate?

Have you tried CFDumping the Form on that page to see if CF can see
the form field

Try changing the code to something like

CFSET a = Form[GetAllContactTypes.PK_ContactType_ID]

maybe wrapping it with a 

CFIF StructKeyExists(Form, GetAllContactTypes.PK_ContactType_ID)

HTH

- Original Message -
From: Shahzad.Butt [EMAIL PROTECTED]
Date: Thu, 24 Jun 2004 10:48:34 +0100
Subject: Evaluate?
To: CF-Talk [EMAIL PROTECTED]

Hello - can you please check the code below

CFSet GetAllContactTypes.PK_ContactType_ID =
CAA07070-CD2A-46D6-951F-653630BFD539

cfoutput
CFSet a = #Evaluate(Form.#GetAllContactTypes.PK_ContactType_ID#)#

/cfoutput

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




Inserting Comma in DB

2004-04-23 Thread Shahzad.Butt
Hi

CFSet myComments = It wasn't the best solution

INSERT INTO tb_JQoS_Results

(Comments)

Values (' #myComments# ')

It gives error because of the comma. How can we make it working?



Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Inserting Comma in DB

2004-04-23 Thread Shahzad.Butt
Thanks a lot. CFQueryParam was the solution

Shaz

_

From: John Beynon [mailto:[EMAIL PROTECTED] 
Sent: 23 April 2004 15:17
To: CF-Talk
Subject: RE: Inserting Comma in DB

Eeeks, that should be cfsqltype=cf_sql_longvarchar

Jb.

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED] 
Sent: 23 April 2004 15:15
To: CF-Talk
Subject: RE: Inserting Comma in DB

Hi friend of muffin man :)

cfqueryparam cfsqltype=longvarchar value=#mycomments#

Jb.

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 23 April 2004 15:18
To: CF-Talk
Subject: Inserting Comma in DB

Hi

CFSet myComments = It wasn't the best solution

INSERT INTO tb_JQoS_Results

(Comments)

Values (' #myComments# ')

It gives error because of the comma. How can we make it working?

Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**

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




Installing dll online

2004-03-18 Thread Shahzad.Butt
Using Cold Fusion (MX or 5) how can we let a dll to be installed on
client's web browser - online i.e. yahoo messenger installation.



Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Encrypt

2004-03-01 Thread Shahzad.Butt
Hi

Does anyone know how I can encrypt my source code in CFMX. Also after
encrypting when I do the modification do I need to encrypt the whole
folder or it would be the only modified files?

Thanks

Shaz

**
This email and any files transmitted with it are confidential
and intended solely for use by the individual or entity to 
whom it is addressed. If you have received this e-mail in 
error, kindly notify [EMAIL PROTECTED] or call 
+44 1992 701 704. Unless stated otherwise, please note 
that any views or opinions expressed in this e-mail are solely
that of the author and are not necessarily of 
JJ Fast Food Distribution Limited. The company can not 
assure that the integrity of this communication has been 
maintained nor that it is free of errors, virus, interception or 
interference. The company accepts no liability for any 
damage caused by this email. JJ Fast Food Distribution 
Limited reserves the right to monitor and or record e-mail 
without prior notification.
**
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Java Files

2004-01-29 Thread Shahzad.Butt
I've installed CFMX6.1 on Websphere. When I run a file say test.cfm it generates a java class which is cftest2ecf9184 Which is fine what I need more is to get the .java file for the same class. Just not familiar with the architecture does CFMX create java files and then compiles it to class file (which I guess it does). If so then where can I find the java source code for that file? Or .java file for test

Thanks

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




Length of CFC

2004-01-27 Thread Shahzad.Butt
Does it really matter if a cfc file is very long. say a couple of
thousand lines. Would it slow down the request including a call to that
cfc?

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Passing List into Stored Proc

2004-01-27 Thread Shahzad.Butt
Just a thought. Try adding the following line at the start of your SP

 
SET QUOTED_IDENTIFIER OFF

 
Also when you run the SP open up a trace in SQL Server Profiler and
check exactly what query has been passed to SQL Server. Copy that query
and send...

 
Shaz

_

From: John mccosker [mailto:[EMAIL PROTECTED] 
Sent: 27 January 2004 11:56
To: CF-Talk
Subject: Passing List into Stored Proc

Hi,

I have wrote a stored proc that will delete items in a table by do
a subquery on a list passed into it.

If I test it in Query Analyzer it runs effectively,

DELETE
FROM DBO.a
WHEREDBO.a.FOLDERNAME IN ('jim','ben','tom')
AND DBO.a.CUSTOMERID = 1

but when I call through cf passing in the list it does not,

cf

CFSTOREDPROC PROCEDURE=p_test
DATASOURCE=#request.d#
USERNAME=#request.u#
PASSWORD=#request.p#

CFPROCPARAM DBVARNAME=@CUSTOMERID 
VALUE=#ListGetAt(cookie.c_userSession,1,';')# 
TYPE=IN 
CFSQLTYPE=CF_SQL_INTEGER
CFPROCPARAM DBVARNAME=@FOLDERLIST 
VALUE=#attributes.delete_list# 
TYPE=IN 
CFSQLTYPE=CF_SQL_VARCHAR

/CFSTOREDPROC

proc code
-

CREATE PROCEDURE p_test

(@CUSTOMERID INT,@FOLDERLIST VARCHAR(2000))

AS

DELETE
FROM DBO.a
WHEREDBO.a.FOLDERNAME IN (@FOLDERLIST)
AND DBO.a.CUSTOMERID = @CUSTOMERID

running ms sql 7.0 and MX 6.1

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




Web Application Archive

2004-01-21 Thread Shahzad.Butt
Hi

 
When you install coldfusion MX (6.0 or 6.1 standard not on J2EE) where
does it deploy the Web Application Archive??

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




CFMX Installation

2004-01-20 Thread Shahzad.Butt
Hi

 
I've installed Websphere on my machine (win2K professional with SP4).
Now I want to install CFMX on the same machine using websphere. I am
following the macromedia online help but problem I am facing is that
when I install CFMX (on IIS) it doesn't ask for the EAR files(which is
mentioned in the notes i am following). Should I continue installtion
and then configre websphere with CF (but then I need to provide the path
of ear files in admin console of websphere which i dont know)?

 
Any ideas

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX Error

2004-01-20 Thread Shahzad.Butt
Just installed CFMX6.0 and getting following error when I open Admin
page

 
javax/crypto/CipherSpi

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX Error

2004-01-20 Thread Shahzad.Butt
I'll try that

 
thanks dave

_

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 20 January 2004 17:25
To: CF-Talk
Subject: RE: CFMX Error

 Just installed CFMX6.0 and getting following error when I open 
 Admin page

 javax/crypto/CipherSpi

Rather than address your specific problem, I'm going to ask you if
you're
installing this on Websphere. If you are, I'd strongly recommend that
you
install CFMX 6.1 instead, which in my experience has worked much better
with
various J2EE servers.

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: CFMX Error

2004-01-20 Thread Shahzad.Butt
I am trying to upgrade CFMX6.1 from CFMX6.0 by choosing EAR option. At
stage 4 (configure coldfusion MX) its says to choose existing web
applicaiton root. I am selecting the path for it which is C:\CFusionMX\
but its not accpeting... any ideas

_

From: Shahzad.Butt 
Sent: 20 January 2004 17:20
To: CF-Talk
Subject: RE: CFMX Error

I'll try that

thanks dave

_

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 20 January 2004 17:25
To: CF-Talk
Subject: RE: CFMX Error

 Just installed CFMX6.0 and getting following error when I open 
 Admin page

 javax/crypto/CipherSpi

Rather than address your specific problem, I'm going to ask you if
you're
installing this on Websphere. If you are, I'd strongly recommend that
you
install CFMX 6.1 instead, which in my experience has worked much better
with
various J2EE servers.

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: DTS from SP

2004-01-14 Thread Shahzad.Butt
Just create a scheduled job (in Sql) 'JOB1' then right click on that
job, properties then click on STEPS tab. Click edit it will give you the
code to run the DTS. You can copy this DTS code and paste it under
DTSRUN

 
e.g

 
master.dbo.xp_cmdshell 'DTSRun
/~Z0x3B2318455D75B2F1BC92AF9FA5AD4F411F72662FE92795909F7E45FD2518C5A3D9A
348AD5FF91DB24B84FC23F9E36EAD2975C5143E87E99773'

 
Now you can run it as a query in coldfusion, SQL or save it as stored
procedure.

 
You can delete the job afterwards as you've created the job just to get
the DTS ID

 
Shaz

_

From: Dan O'Keefe [mailto:[EMAIL PROTECTED] 
Sent: 14 January 2004 14:30
To: CF-Talk
Subject: DTS from SP

I have combed the archives, and then net, and I think I have found the 
info I need to be able to do this.

I used the DTSRUNUI to create this string:
'DTSRun /S TESTDATA /U sa /P password /N frDay01_upload /G 
{F96F01E6-D82C-4ECF-899E-7DDADB1976C6} /W 0 '

When I run it from the DOS prompt, it works. When I try to run it with: 
exec master..xp_cmdshell, both from QA and a SP, I get the following
error:

DTSRun:Loading...
Error:-2147024629 (8007010B); Provider Error:0 (0)
Error string:The directory name is invalid.
Error source:Microsoft Data Transformation Services (DTS) Package
Help file:sqldts80.hlp
Help context:713
NULL

naturally the most frustrating part is trying to find out more info on 
the error. I have looked in the mentioned .hlp file as well as MS  
google. Anybody have any ideas?

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




Get URL

2004-01-09 Thread Shahzad.Butt
How can I get the current URL (from browser)? e.g. I type in
http://abc.com/myTest/test.cfm I need to save this URL in a variable
inside test.cfm...

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




TSQL problem

2004-01-09 Thread Shahzad.Butt
I know its coldfusion group but I wonder if someone can help me with
this query. What the alternative of Evaluate() in TSQL?

 
SELECT 
09/01/2004 + 'CAST(..)' AS myDateTime

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




RE: TSQL problem

2004-01-09 Thread Shahzad.Butt
Following is the query

 
SELECT

DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)),
CHARINDEX('.', CAST(PanelLocalDT AS Decimal(10,5)))-1) AS INT),
'1899-12-30') 

 
 + ' ' 
 
 + 'CAST(((CaST(RIGHT(CONVERT(decimal(10,4),PanelLocalDT),
LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100
* 1440 / 100) / 60 ) AS int(4))

 
:
CAST(((CaST(RIGHT(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal(10,
4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100
* 1440 / 100) / 60 )),
LEN(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal 
(10,4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100
* 1440 / 100) / 60 ))) -
charindex(''.'',CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal(10,4)
,PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS
Float(8)) / 100 * 1440 / 100) / 60  AS Float(8)) / 100 * 60 / 100)
) AS Int(4)) 

 
: 00' myDate

>From dbo.AFxEvents
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Frames

2004-01-06 Thread Shahzad.Butt
Hi

 
My left frame has got a link LOGIN and it opens a Login form on right
frame. I want to get rid of the LOGIN link and give my administrator
direct access to that login form page. So they jus type in
http://www.abc.com/index.htm and they go direct inot login form with
having left and top frames on right place. How can I specify the form
target through URL address bar?

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Log analysis tool

2004-01-02 Thread Shahzad.Butt
Hi

 
Can any tell me free utility to analyse web traffic for IIS?

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




Space between images

2003-12-31 Thread Shahzad.Butt
Folowing is code to show buttons (each button is an image) in my page

 
table cellpadding=0 cellpadding=0width=100%
 tr
td
CFOutput query=GetAllUnitPromotionTypeName
cfswitch
_expression_=#GetAllUnitPromotionTypeName.PK_UnitPromotionType_ID#
 CFCase value=1
A
href="">
.PK_UnitPromotionType_ID# target=Right class=smlimg align=left
border=0 name=a src="">
 /CFCase
 CFCase value=6
A
href="">
.PK_UnitPromotionType_ID# target=Right class=smlimg align=left
border=0 name=b src="">
 /CFCase
 CFCase value=7
A
href="">
.PK_UnitPromotionType_ID# target=Right class=smlimg align=left
border=0 name=c src="">
 /CFCase
 /cfswitch
/cfoutput
/td
 /tr
/table

 
Problem is that there is space between each button however i want not to
have space between them and look like a strip.

 
Thansk

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Space between images

2003-12-31 Thread Shahzad.Butt
you are the man. it works

 
thanks

_

From: Bailey, Neal [mailto:[EMAIL PROTECTED] 
Sent: 31 December 2003 16:26
To: CF-Talk
Subject: RE: Space between images

Also try adding (hspace=0 vspace=0) to the image tags. 

Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

This email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.
If you are not the named addressee you should not disseminate,
distribute or
copy this e-mail.Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system.If you are not the intended recipient you are hereby notified
that
disclosing, copying, distributing or taking any action in reliance on
the
contents of this information is strictly prohibited.Thank you.

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 31, 2003 10:27 AM
To: CF-Talk
Subject: Re: Space between images

remove line breaks in the code.makes it harder to read, i know, but
should
resolve the space issue.

- Original Message - 
From: Shahzad.Butt 
To: CF-Talk 
Sent: Wednesday, December 31, 2003 9:22 AM
Subject: Space between images

Folowing is code to show buttons (each button is an image) in my page

table cellpadding=0 cellpadding=0width=100%
tr
 td
 CFOutput query=GetAllUnitPromotionTypeName
cfswitch
_expression_=#GetAllUnitPromotionTypeName.PK_UnitPromotionType_ID#
CFCase value=1
 A

 
href="">
.PK_UnitPromotionType_ID# target=Right class=smlimg
align=left
border=0 name=a src="">
/CFCase
CFCase value=6
 A

 
href="">
.PK_UnitPromotionType_ID# target=Right class=smlimg
align=left
border=0 name=b src="">
/CFCase
CFCase value=7
 A

 
href="">
.PK_UnitPromotionType_ID# target=Right class=smlimg
align=left
border=0 name=c src="">
/CFCase
/cfswitch
 /cfoutput
 /td
/tr
/table

Problem is that there is space between each button however i want not
to
have space between them and look like a strip.

Thansk

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Javascript Help Required

2003-12-30 Thread Shahzad.Butt
Hi

 
I am using following script to change the image for a button on
mouseOver (red button) and mouseOut (white button). What I can not
achieve or I dont know how to do is when link is active then display
image which I am using on mouseOver

 
script language=_javascript_

 
 if (browserVer == 1) {
 b1 = new Image(107,36);
 b1.src = "">
 b2 = new Image(107,36);
 b2.src = "">
 }

 //image swapping function:
 function hiLite(imgDocID, imgObjName, comment) {
 if (browserVer == 1) {
 document.images[imgDocID].src = "" + .src); 
 window.status = comment; return true;
 }}
 //end hiding --

/script 

 
Thats where I am using the function in CF

 
A  Login')
 Login')
href="" target=Right class=sml img
border=0 name=b src="">

 
Can anyone explain me when a link is active how can I keep the Redbutton
not the white one??

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Javascript Help Required

2003-12-30 Thread Shahzad.Butt
That must be a mistake writing email however my code works fine. Only
problem is that I dont know how to keep the image active (Red One) when
a link is active.


_

From: MILAN MUSHRAN [mailto:[EMAIL PROTECTED] 
Sent: 30 December 2003 14:10
To: CF-Talk
Subject: RE: _javascript_ Help Required

You have a Syntax error...

You missed the double quotes on the first image.

b1.src = "">

From: Shahzad.Butt [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: _javascript_ Help Required
Date: Tue, 30 Dec 2003 11:40:34 -

Hi

I am using following script to change the image for a button on
mouseOver (red button) and mouseOut (white button). What I can not
achieve or I dont know how to do is when link is active then display
image which I am using on mouseOver

script language=_javascript_

if (browserVer == 1) {
b1 = new Image(107,36);
b1.src = "">
b2 = new Image(107,36);
b2.src = "">
}



//image swapping function:
function hiLite(imgDocID, imgObjName, comment) {
if (browserVer == 1) {
document.images[imgDocID].src = "" + .src);
window.status = comment; return true;
}}
//end hiding --

/script

Thats where I am using the function in CF

A  Login')
 Login')
href="" target=Right class=sml img
border=0 name=b src="">

Can anyone explain me when a link is active how can I keep the
Redbutton
not the white one??



Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604


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




Password encryption

2003-12-16 Thread Shahzad.Butt
Hi

 
I am storing user name and password in Access DB and running a query to
match the combination when user attempts to login. Authorised users can
do everything with the DB. Whats the best way to make it secure?
encrypting passwords stored in DB? or some other way..

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




Solution/suggetion...

2003-12-10 Thread Shahzad.Butt
Hi

 I am providing user a form to add new employees in the system. Problem
I am facing is that users are adding same employees twice (as adding is
managed by different departments). Now this adding form
(dsp_addEmployee.cfm) is quite complicated and I dont want to touch it
at all neither do I want to touch its act page (act_addEmployee.cfm)
where its acutally adding looking at loads of different criterias.
Solution we came up with is that check the date of birth in the form as
user submits the form and provide the user with list a of all employees
for that date of birth and a message that checks if the employee already
exist. If h/she does then go somewhere (doesn't matter where), if no
then click on CONTINUE and it will run the act page. This CONTINUE seems
a bit tricky as I can have a new page called
dsp_ShowEmployeesForSameDOB.cfm between dsp_addEmployee.cfm and
act_addEmployee. But on continue that dsp_ShowEmployeesForSameDOB.cfm
needs to carry all form variables (attributes here as i am using FB3). I
cannot store them again in hidden variables as its too complicated and
messy.

 
So whats the solution for this problem?

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




Refresh left frame

2003-12-09 Thread Shahzad.Butt
Hi

 
I have Login link on left frame which opens login screen on right frame.
On successfull login I want to refresh the left frame. But as I am at
right frame it just refreshes right one. Reason I want to do is that
some links in left are enabled only when appropriate user is logged in.
Without refreshing it doesn't show the links to authorised users.

 
Thanks

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Looping through checkbox

2003-12-08 Thread Shahzad.Butt
How can we loop through only selected checkbox items in action page. I
dont want to loop through entire items and then use CFIF to check if
selected then run the statement

 
Thanks

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Looping through checkbox

2003-12-08 Thread Shahzad.Butt
- they all have different names
- user is selecting the check boxes

 
following is the code the way i am using 

 
cfloop query=GetAllUnitPromotionForType

tr
tdinput type=checkbox name=Unit#Counter#
value=#GetAllUnitPromotionForType.PK_UnitPromotion_ID/td
 ...
/cfloop

_

From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 08 December 2003 18:04
To: CF-Talk
Subject: RE: Looping through checkbox

are they all the same name? 

...tony

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

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2003 1:02 PM
To: CF-Talk
Subject: Looping through checkbox

How can we loop through only selected checkbox items in action page. I
dont
want to loop through entire items and then use CFIF to check if selected
then run the statement

Thanks

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




HTML

2003-12-04 Thread Shahzad.Butt
Hi

 
I am displaying an image on background of everypage. It works perfect by
having bgproperties = fixed in body tag means its watermark. Problem I
am having is that all TEXTAREA tags are showing a white box and hiding
the background image. How would I make TEXTAREA to behave in same
manner and show the background image as well? Must be some DHTML or
stylesheet function to do that.

Thanks
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Date format in access

2003-12-01 Thread Shahzad.Butt
Hi

 
Can someone tell the date format to use in CFQuery in select/insert
statement for an access DB?

 
thanks

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Getting last inserted idenity value

2003-11-28 Thread Shahzad.Butt


 
Hi

 
I am using CFMX and Access2000. In my action page I've got two insertion
queries one inserts in table1 and other one inserts in table2. Both of
these tables has got primary key as autoincrement number. Second query
needs to add the primary key generated from first query as a foreign
key. How would I get the PK of the record just inserted. I know in
SQLServer we could use @@IDENTITY but unfortunately I am using access at
the moment

Thanks

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604

 

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




RE: Getting last inserted idenity value

2003-11-28 Thread Shahzad.Butt
Which scope i.e queryname.MaxID...?Is it CF Function?

_

From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 28 November 2003 13:31
To: CF-Talk
Subject: RE: Getting last inserted idenity value

Try MaxID.

_

From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 28 November 2003 13:25
To: CF-Talk
Subject: Getting last inserted idenity value



Hi

I am using CFMX and Access2000. In my action page I've got two insertion
queries one inserts in table1 and other one inserts in table2. Both of
these tables has got primary key as autoincrement number. Second query
needs to add the primary key generated from first query as a foreign
key. How would I get the PK of the record just inserted. I know in
SQLServer we could use @@IDENTITY but unfortunately I am using access at
the moment

Thanks

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604

_

_


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




TDateTime conversion

2003-11-18 Thread Shahzad.Butt
Hi

 
Has anyone written any UDF or something to convert TDateTime value (in
Delphi) to normal ODBC date/time format? Even a TSQL command will help
me as well..

Thanks

 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604

 

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




CFMX in SAP

2003-11-05 Thread Shahzad.Butt
Hi

 
I wonder if anyone has used any CF (doesn't have to be CFMX) with SAP's
Web Portal (using Sap web application server)? I am having some
configuration issues. I want to install CFMX on Sap's Application Server
not JRUN. I would highly appreciate if some one explain me how you have
configured it?

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604

 

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




RE: Custom tags in CFMX

2003-10-29 Thread Shahzad.Butt
I had C++ custom tags in CF when i migrated to CFMX and didn't have any
issue migrating to MX 6.1 either.

 
Shaz

	-Original Message-
	From: chad [mailto:[EMAIL PROTECTED] 
	Sent: 28 October 2003 16:27
	To: CF-Talk
	Subject: Custom tags in CFMX
	
	
	I have recently upgraded my CF server from 5 to MX 6.1. In doing
so one of my Java CFX tags is now not working. When I try to run this
tag, it errors out because it applies an extra CFX_ to the tag name.
So what used to be CFX_Tagname is now CFX_CFX_Tagname and because of
this it no longer works.. When I log into my CF admin and go to Custom
Tag Paths I have two, D:\CFusion\CustomTags and
D:\CFusionMX\CustomTags. I do have 4 other CFX tags that are working
properly.
	
	Any help would be greatly appreciated. 
	
_

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




RE: CFFTP - putfile problem

2003-10-29 Thread Shahzad.Butt
Just stick all the files in a directory then you can loop over a
directory and then pass the dynamic file name to FTP.

 
cfdirectory action="" directory=#Request.myDir# name=dirs
filter=*

cfoutput query=dirs
cfftp action = "" file=#Request.myDir#\#dirs.name#
/cfoutput

Shaz

	-Original Message-
	From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
	Sent: 29 October 2003 12:39
	To: CF-Talk
	Subject: Re: CFFTP - putfile problem
	
	
	On Wednesday 29 Oct 2003 12:24 pm, Pedro Mendes wrote:
	 Can I pass the names of the files dinamically (#name#), so
that in one
	 cfftp I can transfer them all?
	
	You can, yes, but only one name at a time, you'll have to loop
over the 
	cfdirectory results to get these names.
	-- 
	Tom Chiverton 
	Advanced ColdFusion Programmer
	
	Tel: +44(0)1749 834997
	email: [EMAIL PROTECTED]
	BlueFinger Limited
	Underwood Business Park
	Wookey Hole Road, WELLS. BA5 1AF
	Tel: +44 (0)1749 834900
	Fax: +44 (0)1749 834901
	web: www.bluefinger.com
	Company Reg No: 4209395 Registered Office: 2 Temple Back East,
Temple
	Quay, BRISTOL. BS1 6EG.
	*** This E-mail contains confidential information for the
addressee
	only. If you are not the intended recipient, please notify us
	immediately. You should not use, disclose, distribute or copy
this
	communication if received in error. No binding contract will
result from
	this e-mail until such time as a written document is signed on
behalf of
	the company. BlueFinger Limited cannot accept responsibility for
the
	completeness or accuracy of this message as it has been
transmitted over
	public networks.***
	
_

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




DWMX Database Connection

2003-10-01 Thread Shahzad.Butt
I've set up RDS and can view my datasourcees in Dreamweaver. Problem is
that the font (font size) is weird and I cannot read anything. I can
click on a datasource by guessing and then i can see tables as well but
font is soweird that I am unable to read anything. Can someone tell me
how to make it readable (under database)?
 
 
Thanks
 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 

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




RE: DWMX Database Connection

2003-10-01 Thread Shahzad.Butt
Problem solved - changed the fonts to SMALL under display - settings -
advance

	-Original Message-
	From: Shahzad.Butt 
	Sent: 01 October 2003 10:21
	To: CF-Talk
	Subject: DWMX Database Connection
	
	
	I've set up RDS and can view my datasourcees in Dreamweaver.
Problem is
	that the font (font size) is weird and I cannot read anything. I
can
	click on a datasource by guessing and then i can see tables as
well but
	font is soweird that I am unable to read anything. Can someone
tell me
	how to make it readable (under database)?
	
	
	Thanks
	
	Shahzad.Butt
	Ph:+44 (0) 1992 701 722
	Fax: +44 (0) 1992 701 604
	
	
_

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




CFMX6.1 ODBC services

2003-09-24 Thread Shahzad.Butt
Hi 
 
I've just installed CFMX6.1 in my production environment. Problem I am
facing is that I can not start 'ColdFusion MX ODBC Agent' and
'ColdFusion MX ODBC Server' services. I am using domain account to run
coldfusion services. However I can start Application Server services
(using same domain account) and other two mentioned above I cannot
start. Is there any known reason why this is happening?
 
Thanks
 
Shahzad.Butt
Ph:  +44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 

~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138255
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: CFMX6.1 ODBC services

2003-09-24 Thread Shahzad.Butt
Thanks a lot. This article has solved my problem.

-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED] 
Sent: 24 September 2003 14:24
To: CF-Talk
Subject: Re: CFMX6.1 ODBC services


Check out the front page of http://houseoffusion.com/

Mike has an explination there that may help.

Dan Phillips
CFXHosting.com


- Original Message - 
From: Shahzad.Butt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 5:08 AM
Subject: CFMX6.1 ODBC services


 Hi

 I've just installed CFMX6.1 in my production environment. Problem I am

 facing is that I can not start 'ColdFusion MX ODBC Agent' and 
 'ColdFusion MX ODBC Server' services. I am using domain account to run

 coldfusion services. However I can start Application Server services 
 (using same domain account) and other two mentioned above I cannot 
 start. Is there any known reason why this is happening?

 Thanks

 Shahzad.Butt
 Ph:  +44 (0) 1992 701 722
 Fax: +44 (0) 1992 701 604


 

~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138281
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Running Batch Script

2003-09-10 Thread Shahzad.Butt
I want to stop a service on SERVERA from SERVERB. I am using following
command to run a batchfile
 
cfexecute name=c:\WINNT\system32\cmd
arguments=X:\WWWRoot\Services\StopLoadBalancing.bat/cfexecute
 
 
Following is command in batch script
 
psexec \\SERVERA WLBS stop

 
This batch file works perfect when I run it and stops the service but it
doesn't work through CFEXECUTE. Dont know whats going on there
NOTE: CFEXECUTE is not disabled from CFAdmin
 
Any suggetions..
 
Thanks
 
Shahzad.Butt
Ph:  +44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Running Batch Script

2003-09-10 Thread Shahzad.Butt
Coldfusion runs under domain account and that user has got
Administrative Access.


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 10 September 2003 15:43
To: CF-Talk
Subject: RE: Running Batch Script


 I want to stop a service on SERVERA from SERVERB. I am using
 following command to run a batchfile
  
 cfexecute name=c:\WINNT\system32\cmd 
 arguments=X:\WWWRoot\Services\StopLoadBalancing.bat
 /cfexecute
   
 Following is command in batch script
  
 psexec \\SERVERA WLBS stop
  
 This batch file works perfect when I run it and stops the
 service but it
 doesn't work through CFEXECUTE. Dont know whats going on there
 NOTE: CFEXECUTE is not disabled from CFAdmin

It's probably a permissions problem. Is the CF service running as a user
with rights to stop services on SERVERA? By default, the CF services
runs as SYSTEM, which has no rights to network resources at all.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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


RE: Running Batch Script

2003-09-10 Thread Shahzad.Butt
This user has got administrative access. I've tried login with that
account and ran that script it WORKS. It just doesn't work thru
CFEXECUTE
What shall I do???

Shaz

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 10 September 2003 15:57
To: CF-Talk
Subject: RE: Running Batch Script


 Coldfusion runs under domain account and that user has got 
 Administrative Access.

Does the account have a persistent drive mapping to the X drive, where
the batch file is located? I'm guessing it does, but it doesn't hurt to
ask. And, while you've confirmed that account, you might want to login
with that account and run the batch file from an interactive console
session to see if it works.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Running Batch Script

2003-09-10 Thread Shahzad.Butt
Fixed

Thanks dave

D:
CD\
cd ABCD
cd EFGH

psexec \\ WLBS stop


Should be in batch script and

cfexecute
name=D:\WWWRoot\JJCServices\StopLoadBalancing.bat/cfexecute  should
be withing CFExecute

It works

Thanks

Shaz
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 10 September 2003 16:38
To: CF-Talk
Subject: RE: Running Batch Script


 This user has got administrative access. I've tried login with
 that account and ran that script it WORKS. It just doesn't work 
 thru CFEXECUTE What shall I do???

I'm out of obvious ideas. I'd recommend that you try to break the
problem down into smaller components. For example, can you run any other
things through CFEXECUTE?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Load Balancing

2003-09-02 Thread Shahzad.Butt
Hi

I've load balanced my webservers using windows load balancing. Specs of
both load balanced servers (Server1 and Server2) are

Win2K advanced server
CFMX

SQL2K (running on third box Server3)


My code is replicated between Server1 and Server2. If I shut down one
box then second one takes over automatically. And if both are running
then traffic is distributed between both (with no intelligence what so
ever that which server is doing more work and which less). Problem I am
having is that if for some reason IIS services stops or CFMX server
crashes (services are started in SERVICES but giving no response) then
traffic which is dedicated to that server is still going there and user
is getting no response. 

So all I need is that if for some reason either IIS or CF server is
crashed or stopped then either it shuts down the server or it restart
that services. I cant set page time out in CFAdmin because some of my
apps take about 45 minutes to be completed as they are running backup of
some files. I know CFProbe can do that but thats for ClusterCAT which
unfortunately I dont have.

Any suggetions

Thanks

Shahzad.Butt
Ph:  +44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Load Balancing

2003-09-02 Thread Shahzad.Butt
How does that batch file know when to be executed. Or shall I schedule
every 1 min? which I don't feel is right. Because I want to start the
restart the services whenever it crashes not just one off. Also can I
have a copy of that batch file (to stop or restart IIS/CFMX services) if
someone has written

Thanks
Shaz

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: 02 September 2003 10:40
To: CF-Talk
Subject: Re: Load Balancing


On Tuesday 02 Sep 2003 09:20 am, Shahzad.Butt wrote:
 So all I need is that if for some reason either IIS or CF server is 
 crashed or stopped then either it shuts down the server or it restart 
 that services.

Seems easy enough - write a batch file that requests a file from your 
webserver, and if it doesn't get it, stops the service.
I use CygWin for stuff like this.

-- 
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Text Field

2003-08-21 Thread Shahzad.Butt
I am adding data in text field in sql server 2000. User can see a memo
box and they can type in long description. All I want is to keep the
format user typed in so I want to keep all enters, spaces extra entered
by user in DB. And then when I display result it should show in same
format but it should also fit in page (with table of 100% width).
Fitting in page is fine just having 100% width does the job. But how can
I save data entered by user in same format in DB? When I use
Pre#data#/pre when inserting in DB then it doesn't fit in page but
shows everything in one line. Any help??
 
Thanks
Shahzad.Butt
Ph:  +44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Dev Notes (fusebox)

2003-08-14 Thread Shahzad.Butt
Hi
 
If someone has used Devnotes (you can find it from
http://www.halhelms.com/index.cfm?fuseaction=code.detail
http://www.halhelms.com ). Is there anyway that it seperates notes for
each page. Currently its showing devnotes for entire Wireframe
application. So if I add note for one wire frame then person working on
other wireframe will see those notes as well so its whole one big note
conversation going on throughout whole wireframe app. I want different
notes for each wireframe
 
P.S: wireframe app is written in Fusebox
 
 
Thanks
Shaz
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7739 556 280
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



UTC Again

2003-07-25 Thread Shahzad.Butt
I remember once I asked to convert UTC date format (in milliseconds
starting from midnight 1970 jan) to normal date. And solution was
 
#dateformat(dateadd(s,1057580739,1/1/1970),/mmm/dd)#

= 2003/Jul/07

 

Now how to do the reverse. Means now I've got 7th July 2003, how do i
convert it to milliseconds starting from midnight jan 1970 (UTC)?

Thanks

Shaz

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: JSP/Java in CF Page

2003-07-09 Thread Shahzad.Butt
There was no reason no following that approach. Its perfect and does
what I want.

Thanks

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: 08 July 2003 18:33
To: CF-Talk
Subject: Re: JSP/Java in CF Page


 First time writing Java/JSP code in CF. What should be the syntax to 
 include this java file in cf page and print results.

is there any reason for not taking this approach?

cfscript
 aSimpleDateFormat = createObject(java, java.text.SimpleDateFormat);
millseconds = javaCast(double,1057580739 * 1000);
thisDateMask=javaCast(string,/MM/dd HH:mm:ss);
thisDate=aSimpleDateFormat.init(thisDateMask).format(millseconds);
 writeoutput(#thisDate#);
/cfscript


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



JSP/Java in CF Page

2003-07-08 Thread Shahzad.Butt
Hi
 
First time writing Java/JSP code in CF. What should be the syntax to
include this java file in cf page and print results.
 
%@ import java.text.SimpleDateFormat;%
%@ import java.util.*;%
% public class formatDate{
public static void main(String args[]) {
 String seconds = args[0];
 long secs = Integer.parseInt(1057580739);
 long millseconds = secs * 1000;
 Date dateObj = new Date(millseconds);
 SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss);
 String formattedDate = sdf.format(dateObj);
 System.out.println(formattedDate);
}
}
%
 
 
Shaz

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: JSP/Java in CF Page

2003-07-08 Thread Shahzad.Butt
Getting this error

\u201cUTCDate, on line 9, column 31, is not a valid identifer name.  
The CFML compiler was processing:

an expression beginning with \u201cUTCDate.jsp\u201d, on line 9,
column 31.This message is usually caused by a problem in the expressions
structure.
an expression beginning with GetPageContext, on line 9, column 6.This
message is usually caused by a problem in the expressions structure.
a script statement beginning with GetPageContext on line 9, column 6.
a CFSCRIPT tag beginning on line 8, column 2.
 
  
The error occurred in C:\Test\UTC.cfm: line 9
 
7 : body
8 : CFSCRIPT
9 :  GetPageContext().include(UTCDate.jsp);
10 : /CFSCRIPT

 

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED] 
Sent: 08 July 2003 11:46
To: CF-Talk
Subject: RE: JSP/Java in CF Page


CFSCRIPT
 GetPageContext().include(hello.jsp);
/CFSCRIPT

Full details here...
http://www.macromedia.com/devnet/mx/coldfusion/articles/java.html

WG

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 08 July 2003 10:14
To: CF-Talk
Subject: JSP/Java in CF Page


Hi

First time writing Java/JSP code in CF. What should be the syntax to
include this java file in cf page and print results.

%@ import java.text.SimpleDateFormat;%
%@ import java.util.*;%
% public class formatDate{
public static void main(String args[]) {
 String seconds = args[0];
 long secs = Integer.parseInt(1057580739);
 long millseconds = secs * 1000;
 Date dateObj = new Date(millseconds);
 SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss);
String formattedDate = sdf.format(dateObj);
System.out.println(formattedDate);
}
}
%


Shaz



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: JSP/Java in CF Page

2003-07-08 Thread Shahzad.Butt
Default in Dreamweaver charset=iso-8859-1 I guess.

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED] 
Sent: 08 July 2003 13:23
To: CF-Talk
Subject: RE: JSP/Java in CF Page


Looks like a unicode issue, what encoding are you using ?

WG

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 08 July 2003 13:10
To: CF-Talk
Subject: RE: JSP/Java in CF Page


Getting this error

\u201cUTCDate, on line 9, column 31, is not a valid identifer name.
The CFML compiler was processing:

an expression beginning with \u201cUTCDate.jsp\u201d, on line 9,
column 31.This message is usually caused by a problem in the expressions
structure. an expression beginning with GetPageContext, on line 9,
column 6.This message is usually caused by a problem in the expressions
structure. a script statement beginning with GetPageContext on line 9,
column 6. a CFSCRIPT tag beginning on line 8, column 2.


The error occurred in C:\Test\UTC.cfm: line 9

7 : body
8 : CFSCRIPT
9 :  GetPageContext().include(UTCDate.jsp);
10 : /CFSCRIPT



-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 08 July 2003 11:46
To: CF-Talk
Subject: RE: JSP/Java in CF Page


CFSCRIPT
 GetPageContext().include(hello.jsp);
/CFSCRIPT

Full details here...
http://www.macromedia.com/devnet/mx/coldfusion/articles/java.html

WG

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 08 July 2003 10:14
To: CF-Talk
Subject: JSP/Java in CF Page


Hi

First time writing Java/JSP code in CF. What should be the syntax to
include this java file in cf page and print results.

%@ import java.text.SimpleDateFormat;%
%@ import java.util.*;%
% public class formatDate{
public static void main(String args[]) {
 String seconds = args[0];
 long secs = Integer.parseInt(1057580739);
 long millseconds = secs * 1000;
 Date dateObj = new Date(millseconds);
 SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss);
String formattedDate = sdf.format(dateObj);
System.out.println(formattedDate);
}
}
%


Shaz





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Date Time (GMT 1970)

2003-07-07 Thread Shahzad.Butt
Any custom tag / UDF which can convert date/time value with GMT
(Starting from Midnight January 1970) and it should go backward as well
converting GMT (1970) to normal date/time?
 
Thanks
Shaz
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Date Time (GMT 1970)

2003-07-07 Thread Shahzad.Butt
We have got a software running to LOG telephone calls and that software
has got its own DB and date/time it is logging call is in seconds
starting from Midnight (00:00:00) January 1, 1970.  Now I want to run
report with some understandable date/time format - so I need a
conversion mechanism.

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED] 
Sent: 07 July 2003 12:55
To: CF-Talk
Subject: RE: Date Time (GMT 1970)


tbh I don't quite understand what you are trying to do.

Are you trying to convert a java/javascript milliseconds from epoch
value to GMT?

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 07 July 2003 12:51
To: CF-Talk
Subject: Date Time (GMT 1970)


Any custom tag / UDF which can convert date/time value with GMT
(Starting from Midnight January 1970) and it should go backward as well
converting GMT (1970) to normal date/time?
 
Thanks
Shaz
 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Date Time (GMT 1970)

2003-07-07 Thread Shahzad.Butt
That's an example

1057580739

I think it should be converted to 7th July 2003, 13:25 or something like
that.

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 07 July 2003 13:17
To: CF-Talk
Subject: RE: Date Time (GMT 1970)


is it logging in julian format? or actually in seconds? can you provide
an example of what a log looks like...

-Original Message-
From: Tom Smith [mailto:[EMAIL PROTECTED]
Sent: 07 July 2003 13:14
To: CF-Talk
Subject: Re: Date Time (GMT 1970)


are you getting the date in seconds, if so, use dateFormat() and it
should work fine:)


- Original Message - 
From: Shahzad.Butt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 07, 2003 1:09 PM
Subject: RE: Date Time (GMT 1970)


 We have got a software running to LOG telephone calls and that 
 software has got its own DB and date/time it is logging call is in 
 seconds starting from Midnight (00:00:00) January 1, 1970.  Now I want

 to run report with some understandable date/time format - so I need a 
 conversion mechanism.

 -Original Message-
 From: Craig Dudley [mailto:[EMAIL PROTECTED]
 Sent: 07 July 2003 12:55
 To: CF-Talk
 Subject: RE: Date Time (GMT 1970)


 tbh I don't quite understand what you are trying to do.

 Are you trying to convert a java/javascript milliseconds from epoch 
 value to GMT?

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: 07 July 2003 12:51
 To: CF-Talk
 Subject: Date Time (GMT 1970)


 Any custom tag / UDF which can convert date/time value with GMT 
 (Starting from Midnight January 1970) and it should go backward as 
 well converting GMT (1970) to normal date/time?

 Thanks
 Shaz




 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Date Time (GMT 1970)

2003-07-07 Thread Shahzad.Butt
I've been told that DateAdd() sucks on MX if the date is within DST??

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED] 
Sent: 07 July 2003 14:04
To: CF-Talk
Subject: RE: Date Time (GMT 1970)


#dateformat(dateadd(s,1057580739,1/1/1970),/mmm/dd)#

= 2003/Jul/07

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 07 July 2003 13:58
To: CF-Talk
Subject: RE: Date Time (GMT 1970)


That's an example

1057580739

I think it should be converted to 7th July 2003, 13:25 or something like
that.

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 07 July 2003 13:17
To: CF-Talk
Subject: RE: Date Time (GMT 1970)


is it logging in julian format? or actually in seconds? can you provide
an example of what a log looks like...

-Original Message-
From: Tom Smith [mailto:[EMAIL PROTECTED]
Sent: 07 July 2003 13:14
To: CF-Talk
Subject: Re: Date Time (GMT 1970)


are you getting the date in seconds, if so, use dateFormat() and it
should work fine:)


- Original Message - 
From: Shahzad.Butt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 07, 2003 1:09 PM
Subject: RE: Date Time (GMT 1970)


 We have got a software running to LOG telephone calls and that 
 software has got its own DB and date/time it is logging call is in 
 seconds starting from Midnight (00:00:00) January 1, 1970.  Now I want

 to run report with some understandable date/time format - so I need a 
 conversion mechanism.

 -Original Message-
 From: Craig Dudley [mailto:[EMAIL PROTECTED]
 Sent: 07 July 2003 12:55
 To: CF-Talk
 Subject: RE: Date Time (GMT 1970)


 tbh I don't quite understand what you are trying to do.

 Are you trying to convert a java/javascript milliseconds from epoch 
 value to GMT?

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: 07 July 2003 12:51
 To: CF-Talk
 Subject: Date Time (GMT 1970)


 Any custom tag / UDF which can convert date/time value with GMT 
 (Starting from Midnight January 1970) and it should go backward as 
 well converting GMT (1970) to normal date/time?

 Thanks
 Shaz




 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Dreamweaver Problem

2003-07-03 Thread Shahzad.Butt
Hi
 
I have just installed Dreamweaver MX on my machine. Text for Insert
Panel (Common, Layout, Tables, Forms, Templates, Characters) is quite
weird and I cant see anything at all. How can I change and increase
fontsize?
 
 
Shahzad Butt (Development Engineer)
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Locking Vars

2003-06-26 Thread Shahzad.Butt
 
Hi,
 
I am running a query and setting my application, request and client vars
in the loop like that
 
CFOutput Query=GetVars
CFParam name=#VariableName# Default= #VariableValue# 
/cfQuery
 
I am not using session varaibles at all but only CLIENT, REQUEST,
APPLICATION. Which type of LOCK and which order is recommended in this
particular scenario - provided that deadlocks are avoided as well..
 
Thanks
Shaz

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Session Hijack

2003-06-25 Thread Shahzad.Butt
Hi,
 
How do we prevent our site showing critical information to hacker if
someone hijacks the session and start using site of some other (admin's)
session and admin's current session gets disconnected. I've been told
that it has happened in past. My coding is totally irrelevant of any
such hack and my security is simply session based so everone is welcome
provided h/she is authorised and session is defined. What is recommended
way of preventing such act in your code?
 
Any suggetions
 
Thanks
Shaz
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Limit Simultaneous Requests

2003-06-20 Thread Shahzad.Butt
Hi
 
My machine specs are
 
P3 Dual Processor 1.266 GHz (512 Cache)
 
RAM = 1.0 GB
 
(This is just application server as DB server is different machine)
 
How many simultaneous requests (in CFMX Admin) should I make as default
for better performance of our Intranet system running (CFMX uses 10 as
default). In my company concurrent users at any time are somthing like
90 - 100. I am using CFMX and its load balanced using Windows Load
Balancing.
 

Thanks
 
Shahzad Butt (Development Engineer)
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7739 556 280
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Schedule in MX

2003-06-18 Thread Shahzad.Butt
Hi

I've got 4 schedules running in my CFMX admin - every 5 mins. If I run
each app direct through browser but not scheduled task then it doesn't
even take a second to finish. And log is not written on SERVER.LOG
(which i've set to log each page taking more than 2 secs). Thats fine -
but problem is that each schedule runs every 5 mins and each app in
schedule is logged in my SERVER.LOG taking 120 secs or more. Why is it?
why same app which takes 1 sec to run is taking 120 sec to run through
schedule in MX? Any idea, suggetions My MX server is crashing
sporadically (each time I'd to restart CFMX services) and that's only
problem I've found so far that may be some apps (scheduled tasks) taking
so long are causing the damage.

Thanks

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7739 556 280
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Schedule in MX

2003-06-18 Thread Shahzad.Butt
Any help/articles on Wget? How to use it?

Thanks

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED] 
Sent: 18 June 2003 11:55
To: CF-Talk
Subject: RE: Schedule in MX


Personally I never use scheduling in  CF, the scheduled tasks sytem in
windows works way better, I simply use wget to hit templates at
scheduled intervals, this works extremely well. I also use a java
program I wrote which does a similar thing for monitoring ftp
directories for uploaded files.

I'd go with wget and windows scheduled tasks.



-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: 18 June 2003 11:49
To: CF-Talk
Subject: Schedule in MX


Hi

I've got 4 schedules running in my CFMX admin - every 5 mins. If I run
each app direct through browser but not scheduled task then it doesn't
even take a second to finish. And log is not written on SERVER.LOG
(which i've set to log each page taking more than 2 secs). Thats fine -
but problem is that each schedule runs every 5 mins and each app in
schedule is logged in my SERVER.LOG taking 120 secs or more. Why is it?
why same app which takes 1 sec to run is taking 120 sec to run through
schedule in MX? Any idea, suggetions My MX server is crashing
sporadically (each time I'd to restart CFMX services) and that's only
problem I've found so far that may be some apps (scheduled tasks) taking
so long are causing the damage.

Thanks

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7739 556 280
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: MS AD

2003-06-17 Thread Shahzad.Butt
Domain Controller (in AD)

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 17 June 2003 12:04
To: CF-Talk
Subject: RE: MS AD


I would assume it stands for Data Connection

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 12:07
To: CF-Talk
Subject: Re: MS AD


Correction. I have no clue what it stands for. I thought you asked DN.

:-)


- Original Message - 
From: Michael T. Tangorre [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 7:04 AM
Subject: Re: MS AD


 it stands for Distinguished Name.

 - Original Message -
 From: Frank Mamone [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, June 16, 2003 3:18 PM
 Subject: Re: MS AD


  Just for reference, what is DC?
 
  - Original Message -
  From: Shahzad.Butt [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, June 16, 2003 12:48 PM
  Subject: RE: MS AD
 
 
   Got it working. Dc was missing
  
   thx
  
   -Original Message-
   From: Shahzad.Butt
   Sent: 16 June 2003 17:25
   To: CF-Talk
   Subject: RE: MS AD
  
  
   Same error man, using port 389
  
   -Original Message-
   From: Allan Clarke [mailto:[EMAIL PROTECTED]
   Sent: 16 June 2003 17:17
   To: CF-Talk
   Subject: RE: MS AD
  
  
   the 'port' attribute is missing. Adding this will fix your problem
  
   --- Marlon Moyer [EMAIL PROTECTED] wrote:
Have you tried giving it a username and password?
   
   
   
-Original Message-
From: Shahzad.Butt
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 10:54 AM
To: CF-Talk
Subject: MS AD
   
   
How can I query MS Active Directory and get a list
of all emails for
users in AD?? My impression was that something like
   
cfldap
   server = TestServer
   action = query
   name = results
   start = cn = shaz,c = US
   filter = (cn = shaz)
   attributes =
cn,o,l,st,c,mail,telephonenumber
   sort = cn ASC
   
   
should work but its giving following error
   

An error has occured while trying to execute query operation on 
the LDAP Server.
One or more of the required attributes may be missing/incorrect
or
you
  
do not have permissions to execute this operation on the server
   

Thanks
Shaz
   
   
  
  
  
  
 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



MS AD

2003-06-16 Thread Shahzad.Butt
How can I query MS Active Directory and get a list of all emails for
users in AD?? My impression was that something like

cfldap
   server = TestServer
   action = query
   name = results
   start = cn = shaz,c = US
   filter = (cn = shaz)
   attributes = cn,o,l,st,c,mail,telephonenumber
   sort = cn ASC


should work but its giving following error


An error has occured while trying to execute query operation on the LDAP
Server. 
One or more of the required attributes may be missing/incorrect or you
do not have permissions to execute this operation on the server 


Thanks
Shaz
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: MS AD

2003-06-16 Thread Shahzad.Butt
Did try passing username and password. No luck

-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED] 
Sent: 16 June 2003 17:11
To: CF-Talk
Subject: RE: MS AD


Have you tried giving it a username and password?



-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 10:54 AM
To: CF-Talk
Subject: MS AD


How can I query MS Active Directory and get a list of all emails for
users in AD?? My impression was that something like

cfldap
   server = TestServer
   action = query
   name = results
   start = cn = shaz,c = US
   filter = (cn = shaz)
   attributes = cn,o,l,st,c,mail,telephonenumber
   sort = cn ASC


should work but its giving following error


An error has occured while trying to execute query operation on the LDAP
Server. One or more of the required attributes may be missing/incorrect
or you do not have permissions to execute this operation on the server


Thanks
Shaz


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: MS AD

2003-06-16 Thread Shahzad.Butt
Same error man, using port 389

-Original Message-
From: Allan Clarke [mailto:[EMAIL PROTECTED] 
Sent: 16 June 2003 17:17
To: CF-Talk
Subject: RE: MS AD


the 'port' attribute is missing. Adding this will fix
your problem

--- Marlon Moyer [EMAIL PROTECTED] wrote:
 Have you tried giving it a username and password?
 
 
 
 -Original Message-
 From: Shahzad.Butt
 [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2003 10:54 AM
 To: CF-Talk
 Subject: MS AD
 
 
 How can I query MS Active Directory and get a list
 of all emails for
 users in AD?? My impression was that something like
 
 cfldap
server = TestServer
action = query
name = results
start = cn = shaz,c = US
filter = (cn = shaz)
attributes =
 cn,o,l,st,c,mail,telephonenumber
sort = cn ASC
 
 
 should work but its giving following error
 
 
 An error has occured while trying to execute query
 operation on the LDAP
 Server.
 One or more of the required attributes may be missing/incorrect or you
 do not have permissions to execute this operation on
 the server
 
 
 Thanks
 Shaz
 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: MS AD

2003-06-16 Thread Shahzad.Butt
Got it working. Dc was missing

thx

-Original Message-
From: Shahzad.Butt 
Sent: 16 June 2003 17:25
To: CF-Talk
Subject: RE: MS AD


Same error man, using port 389

-Original Message-
From: Allan Clarke [mailto:[EMAIL PROTECTED] 
Sent: 16 June 2003 17:17
To: CF-Talk
Subject: RE: MS AD


the 'port' attribute is missing. Adding this will fix
your problem

--- Marlon Moyer [EMAIL PROTECTED] wrote:
 Have you tried giving it a username and password?
 
 
 
 -Original Message-
 From: Shahzad.Butt
 [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2003 10:54 AM
 To: CF-Talk
 Subject: MS AD
 
 
 How can I query MS Active Directory and get a list
 of all emails for
 users in AD?? My impression was that something like
 
 cfldap
server = TestServer
action = query
name = results
start = cn = shaz,c = US
filter = (cn = shaz)
attributes =
 cn,o,l,st,c,mail,telephonenumber
sort = cn ASC
 
 
 should work but its giving following error
 
 
 An error has occured while trying to execute query
 operation on the LDAP
 Server.
 One or more of the required attributes may be missing/incorrect or you

 do not have permissions to execute this operation on the server
 
 
 Thanks
 Shaz
 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Prevent Refresh

2003-06-11 Thread Shahzad.Butt
Great job! That works fine.

Thanks


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: 10 June 2003 22:00
To: CF-Talk
Subject: Re: Prevent Refresh


Isaac wrote:
You could do that -- you'd have to use javascript to submit
the form and set the value of the field after the form is 
submitted.

Nope.  I use something very close to the code below.  The user is
assigned a form ID on arrival.  This ID is checked for using both the
persistent var you see here and later on when its time to hit the db and
do an insert.  Kind of a double check in case somehow the cvar-based
test doesn't work.  I know the 'UID' isn't perfect.  A UUID with the
dashes stripped out is probably smarter.

Honestly I forget exactly.  This has just worked so well over the last
couple years that I pretty much forgot about it.

!---
this goes on the form page.  This is shorter than a UUID
---
cfset DateStamp=#NumberFormat(Now(),_)#
cfset TimeStamp=MID(Now(),16,9)
cfset TimeStamp=REPLACE(TimeStamp,:,,ALL)
cfset TimeStamp=REPLACE(TimeStamp, ,,ALL)
cfset OriginIP=REPLACE(CGI.REMOTE_ADDR,.,,ALL)
cfset FormUID=myUID  DateStamp  TimeStamp  OriginIP input 
type=hidden 
name=FormUID 
value=Frm#variables.FormUID#

!--- on the action page: ---  
cfset VarPart1=client.
cfif isdefined (#VarPart1##form.FormUID#)
error message goes here
cfabort
cfelse
cfset client.#form.FormUID#=form.FormUID
/cfif
---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---


-- Original Message --
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue, 10 Jun 2003 15:22:33 -0500

You could do that -- you'd have to use javascript to submit the form 
and set the value of the field after the form is submitted.

 can always add a hidden field to the form with a specified value
 and then on the processing page add something like:

 !--- check for duplicate form submissions ---
 cfif #form.submissionCheck# EQ submitted
 Geezo have some patients, you already submitted the form! /cfif

 but then again, i know jack squat about cf





 - Original Message -
 From: Charlie Griefer [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2003 3:42 PM
 Subject: Re: Prevent Refresh


 I agree with just about everything Isaac said, but wanted to chime 
 in and say that the easiest solution would be the cflocation
 on the form's
 action
 page.  This is generally how I prevent the duplicate submissions.

 The form's action page contains no HTML, just the insert query.  
 After the query successfully runs, I do a cflocation to a Thank
 You page.  This
 way, a refresh only refreshes that page.



 - Original Message -
 From: S. Isaac Dealey [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2003 12:34 PM
 Subject: Re: Prevent Refresh


   What is best way of preventing multiple entries in DB through 
   form submission when user clicks on REFRESH or BACK button
   of
   browser?
 
   Thanks
   Shaz
 
  I usually use cflocation to move the browser to a confirmation 
  template
 which informs the user that the record has been updated.
 
  In my case, this is often the form page, or in other words, they 
  go back
 to the form with a information saved confirmation
 message at the top of
 the form, usually with all the info they just enterred filled in on 
 the
 form
 again. I also like to use the pengoworks qForms API
 (www.pengoworks.com)
 to
 prevent multiple form submissions in browsers that
 support the DOM. If I
 have to use cfflush on a page,
 
  I move from cflocation to the javascript
  location.replace() which does
 the
 same thing client-side by replacing the current address
 in the browser
 history. It's available in Netscape as far back as
 version 3 and IE
 similarly. I'm not certain about other browsers, although
 I would assume
 at
 least Mozilla supports it since it was implemented in NS prior to 
 Mozilla becoming available. There's a UDF implementation of it in
 the Tapestry API
 in my sig file also.
 
  hth
 
  s. isaac dealey972-490-6624
 
  new epoch  http://www.turnkey.to
 
  lead architect, tapestry cms
  http://products.turnkey.to
 
  tapestry api is opensource
  http://www.turnkey.to/tapi
 
  certified advanced coldfusion 5 developer 
  http://www.macromedia.com/v1/handlers/index.cfm?ID=2181
  6
 
 
 

 ~~
 ~~~|
 Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

 Your ad could be here. Monies from ads go to support these lists and 
 provide more resources for the community. 
 

Prevent Refresh

2003-06-10 Thread Shahzad.Butt
What is best way of preventing multiple entries in DB through form
submission when user clicks on REFRESH or BACK button of browser?
 
Thanks
Shaz

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Prevent Refresh

2003-06-10 Thread Shahzad.Butt
I cant use session scope in my app because of load balancing and stuff.
So need a work around using request scope. Any suggetions???

Shaz

-Original Message-
From: Critz [mailto:[EMAIL PROTECTED] 
Sent: 10 June 2003 14:48
To: CF-Talk
Subject: Re: Prevent Refresh


oi Critz!!

whoops.. request scope won't work doh! session will..





Tuesday, June 10, 2003, 9:32:55 AM, you wrote:

C oi Shahzad.Butt!!

C on the preceding page...

C script
C window.history.forward();
C /script

C this will prevent use of the back button...


C on your form page.. for the refresh problem you can do this...

C if not isDefined(request.pageHit)

C ... do page stuff.
C set request.pageHit = true

C cfelse
C page has already been accessed
C /cfif

C Crit




C 
C Tuesday, June 10, 2003, 9:18:17 AM, you wrote:

SB What is best way of preventing multiple entries in DB through form 
SB submission when user clicks on REFRESH or BACK button of browser?
 
SB Thanks
SB Shaz

SB 
C 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



On Browser Close

2003-06-05 Thread Shahzad.Butt
I know its more or less javascript question. How can I update a row in
DB when user closes browser? If user closes browser then message should
be popped up saying you will be Unavailable YES (button1) NO (button2).
and each Yes and No will have approriate actions.
 
 
Thanks
 
Shahzad Butt (Development Engineer)
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7739 556 280
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: On Browser Close

2003-06-05 Thread Shahzad.Butt
onLoad of which page cos user could be anywhere??? Don't tell me
application.cfm :)

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: 04 June 2003 16:50
To: CF-Talk
Subject: Re: On Browser Close


On Wednesday 04 Jun 2003 16:46 pm, Shahzad.Butt wrote:
 I know its more or less javascript question. How can I update a row in

 DB when user closes browser? If user closes browser then message 
 should be popped up saying you will be Unavailable YES (button1) NO 
 (button2).

There is an onUnLoad/onClose event you can attach to body to check for
that.

-- 
Tom C
Land of the free, home of the brave... you have to be brave to live
there and 
enjoy the freedoms

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



question

2003-04-04 Thread Shahzad.Butt
CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Shahzad.Butt
OK, it display 34 but how can I set it to 1. I was a bit screwed up and
said it displays 1. Actually it is displaying 34 but I want it to
display 1



-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: 04 April 2003 18:01
To: CF-Talk
Subject: RE: question


It displays 34(or rather the equivalent on my result set) on my test.

Ade

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 17:13
To: CF-Talk
Subject: RE: question


Because you reset it with your cfset


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:11 AM
To: CF-Talk
Subject: question


CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



  1   2   >