cfencode on Linux
Has anyone got cfencode to work on a Linux install with CF8 ? # /opt/coldfusion8/bin/cfencode.linux /opt/coldfusion8/bin/cfencode.linux: error while loading shared libraries: libporting.so: cannot open shared object file: No such file or directory I can't find that library in the CF install or the system, or with a Google search. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF, Ajax and Autocomplete Problems
Hi All
Ok seem to be getting somewhere now, or at least I'm getting errors
back, the page is internal and not on the web.
On the search form page I am getting a JavaScript error 'bsn is
undefined'? The original code was for php which I think works superb at
http://www.brandspankingnew.net/archive/2007/02/ajax_auto_suggest_v2.htm
l and I can't use the new autosuggest feature in CF 8 as I am on CF 7.
Search form code -
form method=get action=
label for=testinput_xmlPerson/label
input type=text id=testinput_xml name=surname value=
style=width:300px /
br /br /input type=submit value=submit /
/form
script type=text/javascript
var options_xml = {
script: function (input) { return
include.cfm+input++document.getElementsByTagname('rs')[0].getAttribu
te('info').value; },
varname:input };
var as_xml = new bsn.AutoSuggest('testinput_xml', options_xml);
/script
--
Also when trying the include.cfm page on its own independent to the
search form to test it out I get the error
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and
then click the Refresh button, or try again later.
Incorrect syntax was used in a comment. Error processing resource
Include.cfm page is below ---
cfsilent
cfsetting enablecfoutputonly=yes
cfquery name=getNames datasource=dsn
SELECT surname
FROM tablename
WHERE surname LIKE '%#url.as#%'
ORDER by surname ASC
/cfquery
cfcontent type=text/xml; charset=UTF-8
reset=yes/cfoutput#theXML#/cfoutput
cfloop from=1 to=#getNames.recordcount# index=ctr
cfoutput
!--- add the XML config entry ---
rs id=
info=#getNames.surname[ctr]##getNames.surname[ctr]#/rs
/cfoutput
/cfloop
cfoutput
/results
/cfoutput
cfoutput#theXML#/cfoutput
/cfsilent
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312655
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flex CFC Call Problem - Unable to invoke CFC - Could not find the ColdFusion Component or Interface
On Tuesday 16 Sep 2008, Matthew Dolloff wrote: I'm using web services since those were provided to me the database people that I am trying to talk to. If the service you have no part in is throwing an error, shouldn't you be talking to them, not us ? -- Tom Chiverton Helping to elementarily architect low-risk architectures This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error converting data type varchar to int.
I keep getting an error that appears to be in my cfprocresult as follows.
Any quick help would be greatly appreciated
I hope that I have included enough information for some help.
Thanks in advance
TABLE SCHEMA - [dbo].[tbl_Schol]
scholid int Unchecked
namevarchar(50) Checked
schol_type_id int Checked
scholarships_uidint Checked
academic_uidint Checked
tablename varchar(50) Checked
Student_UID int Checked
TABLE DATA - [dbo].[tbl_Schol]
1 Baseball14 14 14 Baseball1
2 Football3 3 1 Football3
3 Football3 1 1 Football4
4 Football3 7 1 Football7
5 Football3 5 1 Football5
6 Football3 8 1 Football8
7 Football3 8 1 Football10
8 Football0 0 0 Football11
9 Football0 0 0 Football12
NULLNULLNULLNULLNULLNULLNULL
STORED PROCEDURE - [dbo].[sp_Schol_ins]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =
-- Author: Larry Juncker
-- Create date: 2008-09-15
-- Description: This SP will insert a new scolarship record into the Athlete
table
-- =
ALTER PROCEDURE [dbo].[sp_Schol_ins]
-- Add the parameters for the stored procedure here
--@Param1, sysname, @p1 Datatype_For_Param1, , int =
Default_Value_For_Param1, , 0,
@name varchar(50) = NULL,
@schol_type_id int = NULL,
@scholarships_uid int = NULL,
@academic_uid int = NULL,
@tablename varchar(50) = NULL,
@Student_UID int = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
--SELECT @Param1, sysname, @p1, @Param2, sysname, @p2
INSERT INTO [dbo].[tbl_Schol]
([name],
[schol_type_id],
[scholarships_uid],
[academic_uid],
[tablename],
[Student_UID])
VALUES
(@name,
@schol_type_id,
@scholarships_uid,
@academic_uid,
@tablename,
@Student_UID)
SELECT TOP 1 * FROM [dbo].[tbl_Schol] ORDER BY ScholID DESC
RETURN
END
COLD FUSION CODE
cftransaction
cfstoredproc procedure=sp_schol_ins
datasource=profilesandgo
cfprocparam type=In cfsqltype=CF_SQL_INTEGER
dbVarName=Student_UID value=#Form.Student_UID# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=TableName value=#FORM.Sport# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=Name value=#FORM.Sport# null=No
cfprocresult name=InsertSchol resultset=1
/cfstoredproc
/cftransaction
COLD FUSION ERROR
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging
purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to int.
The error occurred in
C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm: line 56
54 :cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=Name value=#FORM.Sport# null=No
55 :
56 :cfprocresult name=InsertSchol resultset=1
57 :/cfstoredproc
58 :/cftransaction
SQLSTATE HY000
SQL {call sp_schol_ins( (param 1) , (param 2) , (param 3) )}
VENDORERRORCODE 8114
DATASOURCE profilesandgo
Resources:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
w:PACBHO60
Remote Address 74.33.132.212
Referrer http://www.statsandgo.com/members/student/sports/form2.cfm
Date/Time 17-Sep-08 06:41 AM
Stack Trace (click to expand)
at
cfform2action2ecfm1601602585.runPage(C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm:56)
at
Problem Passing Data
I have a form that is 99% working. All form data is being passed except for 1 item. I am not getting any errors. The form is for registering for a seminar and I need to know how many are attending (there are a total of 7 seminars). Not sure what I am missing. Any guidance would be appreciated. Form Control trtdinput type=checkbox name=wrkshp value=Lean Enterprise - Overview id=1 //td td width=60%Leading Inclusive, Diverse Teams/td td10/23/08/td td$175.00/td td/td td align=centerinput type=text name=att1 size=3 class=formveld //td/tr Action Page Workshop: cfloop list=#form.wrkshp# index=w#w#/cfloop - Attendees: cfif isdefined(form.wrkshp) cfif listfindnocase(form.wrkshp,Leading Inclusive, Diverse Teams) gt 0cfoutput#form.att1#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Performance Management) gt 0cfoutput#form.att2#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Customer Service Made Easier Profitable) gt 0cfoutput#form.att3#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Lean Enterprise - Overview) gt 0cfoutput#form.att4#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Communicating with a Diverse Workforce) gt 0cfoutput#form.att5#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Generation Change - A Job Market Threat) gt 0cfoutput#form.att6#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Ouch! Resolving Conflict at Work) gt 0cfoutput#form.att7#/cfoutput/cfif /cfif Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem Passing Data
Hi Steve, I think it's the checkbox that's your problem, it's because unless it's checked - it is not passed in the FORM scope. Therefore, what you're expecting doesn't get passed. You can cfparam / the expected FORM scope variable and default to false or Zero, whatever suits, to overcome this. If it's not the checkbox - just ensure all your form elements are inside the form you are submitting! Later, Niall. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 13:31 To: CF-Talk Subject: Problem Passing Data I have a form that is 99% working. All form data is being passed except for 1 item. I am not getting any errors. The form is for registering for a seminar and I need to know how many are attending (there are a total of 7 seminars). Not sure what I am missing. Any guidance would be appreciated. Form Control trtdinput type=checkbox name=wrkshp value=Lean Enterprise - Overview id=1 //td td width=60%Leading Inclusive, Diverse Teams/td td10/23/08/td td$175.00/td td/td td align=centerinput type=text name=att1 size=3 class=formveld //td/tr Action Page Workshop: cfloop list=#form.wrkshp# index=w#w#/cfloop - Attendees: cfif isdefined(form.wrkshp) cfif listfindnocase(form.wrkshp,Leading Inclusive, Diverse Teams) gt 0cfoutput#form.att1#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Performance Management) gt 0cfoutput#form.att2#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Customer Service Made Easier Profitable) gt 0cfoutput#form.att3#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Lean Enterprise - Overview) gt 0cfoutput#form.att4#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Communicating with a Diverse Workforce) gt 0cfoutput#form.att5#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Generation Change - A Job Market Threat) gt 0cfoutput#form.att6#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Ouch! Resolving Conflict at Work) gt 0cfoutput#form.att7#/cfoutput/cfif /cfif Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Error converting data type varchar to int.
Hi Larry,
When using cfstoredproc /, you need a cfprocparam / to specify _ALL_
parameters passed to and from the Stored procedure!!
So need to check your CF code where you are calling the Stored Proc.
Later,
Niall.
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]
Sent: 17 September 2008 12:51
To: CF-Talk
Subject: Error converting data type varchar to int.
I keep getting an error that appears to be in my cfprocresult as
follows.
Any quick help would be greatly appreciated
I hope that I have included enough information for some help.
Thanks in advance
TABLE SCHEMA - [dbo].[tbl_Schol]
scholid int Unchecked
namevarchar(50) Checked
schol_type_id int Checked
scholarships_uidint Checked
academic_uidint Checked
tablename varchar(50) Checked
Student_UID int Checked
TABLE DATA - [dbo].[tbl_Schol]
1 Baseball14 14 14 Baseball1
2 Football3 3 1 Football3
3 Football3 1 1 Football4
4 Football3 7 1 Football7
5 Football3 5 1 Football5
6 Football3 8 1 Football8
7 Football3 8 1 Football10
8 Football0 0 0 Football11
9 Football0 0 0 Football12
NULLNULLNULLNULLNULLNULLNULL
STORED PROCEDURE - [dbo].[sp_Schol_ins]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =
-- Author: Larry Juncker
-- Create date: 2008-09-15
-- Description: This SP will insert a new scolarship record into the Athlete
table
-- =
ALTER PROCEDURE [dbo].[sp_Schol_ins]
-- Add the parameters for the stored procedure here
--@Param1, sysname, @p1 Datatype_For_Param1, , int =
Default_Value_For_Param1, , 0,
@name varchar(50) = NULL,
@schol_type_id int = NULL,
@scholarships_uid int = NULL,
@academic_uid int = NULL,
@tablename varchar(50) = NULL,
@Student_UID int = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
--SELECT @Param1, sysname, @p1, @Param2, sysname, @p2
INSERT INTO [dbo].[tbl_Schol]
([name],
[schol_type_id],
[scholarships_uid],
[academic_uid],
[tablename],
[Student_UID])
VALUES
(@name,
@schol_type_id,
@scholarships_uid,
@academic_uid,
@tablename,
@Student_UID)
SELECT TOP 1 * FROM [dbo].[tbl_Schol] ORDER BY ScholID DESC
RETURN
END
COLD FUSION CODE
cftransaction
cfstoredproc procedure=sp_schol_ins
datasource=profilesandgo
cfprocparam type=In cfsqltype=CF_SQL_INTEGER
dbVarName=Student_UID value=#Form.Student_UID# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=TableName value=#FORM.Sport# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=Name value=#FORM.Sport# null=No
cfprocresult name=InsertSchol resultset=1
/cfstoredproc
/cftransaction
COLD FUSION ERROR
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging
purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to int.
The error occurred in
C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm: line
56
54 :cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbVarName=Name value=#FORM.Sport# null=No
55 :
56 :cfprocresult name=InsertSchol resultset=1
57 :/cfstoredproc
58 :/cftransaction
SQLSTATE HY000
SQL {call sp_schol_ins( (param 1) , (param 2) , (param 3) )}
VENDORERRORCODE 8114
DATASOURCE profilesandgo
Resources:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
RE: Problem Passing Data
Would this work? cfparam name=FORM.wrkshp type=string default= / cftry cfparam name=FORM.user_type_id type=numeric default=0 / cfcatch cfset FORM.user_type_id = 0 / /cfcatch /cftry Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:58 AM To: CF-Talk Subject: RE: Problem Passing Data Hi Steve, I think it's the checkbox that's your problem, it's because unless it's checked - it is not passed in the FORM scope. Therefore, what you're expecting doesn't get passed. You can cfparam / the expected FORM scope variable and default to false or Zero, whatever suits, to overcome this. If it's not the checkbox - just ensure all your form elements are inside the form you are submitting! Later, Niall. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 13:31 To: CF-Talk Subject: Problem Passing Data I have a form that is 99% working. All form data is being passed except for 1 item. I am not getting any errors. The form is for registering for a seminar and I need to know how many are attending (there are a total of 7 seminars). Not sure what I am missing. Any guidance would be appreciated. Form Control trtdinput type=checkbox name=wrkshp value=Lean Enterprise - Overview id=1 //td td width=60%Leading Inclusive, Diverse Teams/td td10/23/08/td td$175.00/td td/td td align=centerinput type=text name=att1 size=3 class=formveld //td/tr Action Page Workshop: cfloop list=#form.wrkshp# index=w#w#/cfloop - Attendees: cfif isdefined(form.wrkshp) cfif listfindnocase(form.wrkshp,Leading Inclusive, Diverse Teams) gt 0cfoutput#form.att1#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Performance Management) gt 0cfoutput#form.att2#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Customer Service Made Easier Profitable) gt 0cfoutput#form.att3#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Lean Enterprise - Overview) gt 0cfoutput#form.att4#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Communicating with a Diverse Workforce) gt 0cfoutput#form.att5#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Generation Change - A Job Market Threat) gt 0cfoutput#form.att6#/cfoutput/cfif cfif listfindnocase(form.wrkshp,Ouch! Resolving Conflict at Work) gt 0cfoutput#form.att7#/cfoutput/cfif /cfif Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem Passing Data
Hi Steve, The try catch is _not_ required. All you need is the line: cfparam name=FORM.user_type_id type=numeric default=0 / If FORM.user_type_id does not exist, cfparam will take care of it. That's it. Later, Niall. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 14:12 To: CF-Talk Subject: RE: Problem Passing Data Would this work? cfparam name=FORM.wrkshp type=string default= / cftry cfparam name=FORM.user_type_id type=numeric default=0 / cfcatch cfset FORM.user_type_id = 0 / /cfcatch /cftry Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF and PHP same server
Prefork is essentially the same model as Apache 1.3, so should be able to handle most volumes that you throw at it. Unless, of course, you get enough to need to load-balance :) On Tue, Sep 16, 2008 at 6:56 PM, James Holmes [EMAIL PROTECTED]wrote: PHP requires a single threaded webserver (as some of the libraries it runs aren't thread safe: http://neosmart.net/blog/2008/dont-believe-the-lies-php-isnt-thread-safe-yet/ ), so you need to run the Apache Prefork MPM. This is less than optimal for high volume sites, but it will work. On Wed, Sep 17, 2008 at 1:40 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, Just checking for any major gotchas with running CF and PHP on the same server (a VPS BTW)?? Would be CF 8 and whatever the latest PHP is. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error converting data type varchar to int.
Thank You for the reply... As shown before, my code is below... What are you saying I need to do here? I am still new to Stored Procedures and the use of them. Larry cftransaction cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Student_UID value=#Form.Student_UID# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=TableName value=#FORM.Sport# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=Name value=#FORM.Sport# null=No cfprocresult name=InsertSchol resultset=1 /cfstoredproc /cftransaction Hi Larry, When using cfstoredproc /, you need a cfprocparam / to specify _ALL_ parameters passed to and from the Stored procedure!! So need to check your CF code where you are calling the Stored Proc. Later, Niall. I keep getting an error that appears to be in my cfprocresult as follows. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Period at end of domain name causes SSL warnings
We ran across this a couple of days ago. One of the Mac browsers gave a phishing warning. I just tried it on XP (IE, FF and GC) but got no warning. Mike -Original Message- From: Dan LeGate [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 8:11 PM To: CF-Talk Subject: Period at end of domain name causes SSL warnings An interesting situation arose when someone sent an email with our server URL that included a period (dot) at the end of the domain name like this: http://www.servername.edu. and they actually included the period as part of the link. It throws a nasty SSL warning. Strangely, it does not say server not found. Instead, it goes to the server, but when the SSL portion of the page loads, a big fat SSL warning shows up because www.servername.edu. does NOT match the SSL name of www.servername.edu Even more strange, utilities like ping, nslookup and tracert all allow this convention as well, without throwing not found errors. Interestingly Google Chrome does NOT complain about a mismatched SSL name. Anyway, anyone seen this? Can anyone shed some light as to why a period at the end of a hostname is acceptable? I tried searching Google for [(dot OR period) end of (domain OR server) name] but it didn't come up with much. Any insight is appreciated. Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF, Ajax and Autocomplete Problems
I think your trick will be to first get your CF XML output to match the XML output from PHP. Once you have done that, your problems should be solved. You should be able to view XML in a browser. Firefox works great when viewing XML. IE not so great, sometimes. Mike -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 5:46 AM To: CF-Talk Subject: RE: CF, Ajax and Autocomplete Problems Hi All Ok seem to be getting somewhere now, or at least I'm getting errors back, the page is internal and not on the web. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error converting data type varchar to int.
Hi Larry, You need to add a cfprocparam for every parameter as follows. So your parameters are: @name varchar(50) = NULL, @schol_type_id int = NULL, @scholarships_uid int = NULL, @academic_uid int = NULL, @tablename varchar(50) = NULL, @Student_UID int = NULL Therefore your call to the stored proc should be as follows: cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@schol_type_id value=#FORM.schol_type_id# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@scholarships_uid value=#FORM.scholarships_uid# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@academic_uid value=#FORM.academic_uid# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc I have assumed some FORM scope variables above for the missing parameters but this shouldn't be far off what you require in terms of calling the storedproc. If these are not all required then amend the code and the storedproc to suit. Later, Niall. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Question
Updates: I used a style attribute in the option tag (background-image:(url=images/imagename)) it works in FF3 but does absolutely nothing in IE7 I really really wish that someone would come up with a standard that will work in every browser. Scott Stewart wrote: cfoutput query=getHexID option value=#hex_id# cfif hex_id eq get_category.hex_idselectedcfelse/cfif span style=background-color:#hex_id#; border:medium; width:10px; height:10px;nbsp;/span#hex_id# /option /cfoutput any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem Passing Data
The first checkbox doesn't pass the attendees, the other 6 do Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error converting data type varchar to int.
The only parts that are actually required is the scholid which is automatic. Otherwise as an entry is made as in this case, we are only inserting three variables @student_UID @name @tablename Otherwise, all fields in the table are able to be null. Larry -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:42 AM To: CF-Talk Subject: RE: Error converting data type varchar to int. Hi Larry, You need to add a cfprocparam for every parameter as follows. So your parameters are: @name varchar(50) = NULL, @schol_type_id int = NULL, @scholarships_uid int = NULL, @academic_uid int = NULL, @tablename varchar(50) = NULL, @Student_UID int = NULL Therefore your call to the stored proc should be as follows: cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@schol_type_id value=#FORM.schol_type_id# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@scholarships_uid value=#FORM.scholarships_uid# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@academic_uid value=#FORM.academic_uid# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc I have assumed some FORM scope variables above for the missing parameters but this shouldn't be far off what you require in terms of calling the storedproc. If these are not all required then amend the code and the storedproc to suit. Later, Niall. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSS Question
Or a browser that adheres to the standard? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 9:44 AM To: CF-Talk Subject: Re: CSS Question Updates: I used a style attribute in the option tag (background-image:(url=images/imagename)) it works in FF3 but does absolutely nothing in IE7 I really really wish that someone would come up with a standard that will work in every browser. Scott Stewart wrote: cfoutput query=getHexID option value=#hex_id# cfif hex_id eq get_category.hex_idselectedcfelse/cfif span style=background-color:#hex_id#; border:medium; width:10px; height:10px;nbsp;/span#hex_id# /option /cfoutput any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSS Question
as long as M$ is in the game that will *never* happen Dave Francis wrote: Or a browser that adheres to the standard? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 9:44 AM To: CF-Talk Subject: Re: CSS Question Updates: I used a style attribute in the option tag (background-image:(url=images/imagename)) it works in FF3 but does absolutely nothing in IE7 I really really wish that someone would come up with a standard that will work in every browser. Scott Stewart wrote: cfoutput query=getHexID option value=#hex_id# cfif hex_id eq get_category.hex_idselectedcfelse/cfif span style=background-color:#hex_id#; border:medium; width:10px; height:10px;nbsp;/span#hex_id# /option /cfoutput any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem Passing Data
OK, Steve - think I understand why you're having that problem now... Your problem is not with the checkboxes it's with the attendees att#n#. One of the Seminars is called Leading Inclusive, Diverse Teams. There's a comma in the name which means that this may be interpreted as two items in the list. Try removing the comma from the seminar name for now to see if that helps. Later, Niall. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 14:44 To: CF-Talk Subject: RE: Problem Passing Data The first checkbox doesn't pass the attendees, the other 6 do Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Optimize Query of Query
hi jim i have also had to do alot of work with queries after they come out of the database. i have been through almost every conceivable angle there is to try to optimize it, and have found that at present coldfusion query of queries just isnt built as a database engine and unfortunately is only useful for simple queries and not for what many people are trying to use it for. i had quite a few query of queries progressivley running various queries on some data and found that was taking 110 seconds to complete, and I tried everything to speed it up. however instead i thought 'what if i changed into an array of arrays and replicated my query but with manual cf code'. i created a function that took a query and changed it into an array of arrays (make use of the querycolumntoarray on cflibs if you are also going to do this), then run manual code manipulating it to do the same as the query would, and then created another function that takes the array of arrays and turn it back into a query. like i said it took 110 seconds in query of query but took only 3 seconds with array of arrays. you and others may also see other alternatives but for me this worked like a dream. i know its more work but it is worth it to see the speed increases - it may work for yours as well but obviously depending on what you are doing but it may be worth a go. good luck, i would also be interested in any result you find, or any alternatives you find. but my advice will be to start thinking of alternatives to query of query until a new release is brought out that can act more like a database engine richard I have a process that needs to do about 500 record lookups by ID. I thought I'd do a single query of the table, pulling down the needed data for every record on file (say 1000 records, just three columns) and then use QoQ instead of hitting the database so many times. Is there any way to index or otherwise optimize the dataset that I retrieve to optimize the query of query lookups? If I'm doing lookups using a particular column, would it help to sort the query by that column? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Error converting data type varchar to int.
I got it cftransaction cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=Name value=#FORM.Sport# null=No cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Schol_Type_ID value= null=Yes / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Scholarships_UID value= null=Yes / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Academic_UID value= null=Yes / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=TableName value=#FORM.Sport# null=No cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Student_UID value=#Form.Student_UID# null=No cfprocresult name=InsertSchol resultset=1 /cfstoredproc /cftransaction I had to add the empty cfprocparams for the fields and set them to null=yes Thanks for youyr help Larry -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:51 AM To: CF-Talk Subject: RE: Error converting data type varchar to int. The only parts that are actually required is the scholid which is automatic. Otherwise as an entry is made as in this case, we are only inserting three variables @student_UID @name @tablename Otherwise, all fields in the table are able to be null. Larry -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:42 AM To: CF-Talk Subject: RE: Error converting data type varchar to int. Hi Larry, You need to add a cfprocparam for every parameter as follows. So your parameters are: @name varchar(50) = NULL, @schol_type_id int = NULL, @scholarships_uid int = NULL, @academic_uid int = NULL, @tablename varchar(50) = NULL, @Student_UID int = NULL Therefore your call to the stored proc should be as follows: cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@schol_type_id value=#FORM.schol_type_id# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@scholarships_uid value=#FORM.scholarships_uid# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@academic_uid value=#FORM.academic_uid# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc I have assumed some FORM scope variables above for the missing parameters but this shouldn't be far off what you require in terms of calling the storedproc. If these are not all required then amend the code and the storedproc to suit. Later, Niall. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Error converting data type varchar to int.
OK, if you only need @student_UID @name @tablename Then you can update your Stored Proc and Your ColdFusion code to only pass and accept these parameters. @name varchar(50) = NULL, @tablename varchar(50) = NULL, @Student_UID int = NULL cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc OR Update as follows: cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@schol_type_id value=#FORM.schol_type_id# null=#NOT len(FORM.schol_type_id)# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@scholarships_uid value=#FORM.scholarships_uid# null=#NOT len(FORM.scholarships_uid)# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@academic_uid value=#FORM.academic_uid# null=#NOT len(FORM.academic_uid)# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc I have added the check for NULL to each parameter that requires it null=#NOT len(FORM.schol_type_id)#. Later, Niall. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 14:51 To: CF-Talk Subject: RE: Error converting data type varchar to int. The only parts that are actually required is the scholid which is automatic. Otherwise as an entry is made as in this case, we are only inserting three variables @student_UID @name @tablename Otherwise, all fields in the table are able to be null. Larry -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:42 AM To: CF-Talk Subject: RE: Error converting data type varchar to int. Hi Larry, You need to add a cfprocparam for every parameter as follows. So your parameters are: @name varchar(50) = NULL, @schol_type_id int = NULL, @scholarships_uid int = NULL, @academic_uid int = NULL, @tablename varchar(50) = NULL, @Student_UID int = NULL Therefore your call to the stored proc should be as follows: cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@schol_type_id value=#FORM.schol_type_id# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@scholarships_uid value=#FORM.scholarships_uid# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@academic_uid value=#FORM.academic_uid# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc I have assumed some FORM scope variables above for the missing parameters but this shouldn't be far off what you require in terms of calling the storedproc. If these are not all required then amend the code and the storedproc to suit. Later, Niall. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error converting data type varchar to int.
Hi Larry, If you update the null attribute to be null=#NOT len(FORM.schol_type_id)# then it'll dynamically work out whether to pass the value or not. Oh, and you're welcome. Later, Niall. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 15:05 To: CF-Talk Subject: RE: Error converting data type varchar to int. I got it cftransaction cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=Name value=#FORM.Sport# null=No cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Schol_Type_ID value= null=Yes / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Scholarships_UID value= null=Yes / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Academic_UID value= null=Yes / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=TableName value=#FORM.Sport# null=No cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Student_UID value=#Form.Student_UID# null=No cfprocresult name=InsertSchol resultset=1 /cfstoredproc /cftransaction I had to add the empty cfprocparams for the fields and set them to null=yes Thanks for youyr help Larry -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:51 AM To: CF-Talk Subject: RE: Error converting data type varchar to int. The only parts that are actually required is the scholid which is automatic. Otherwise as an entry is made as in this case, we are only inserting three variables @student_UID @name @tablename Otherwise, all fields in the table are able to be null. Larry -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:42 AM To: CF-Talk Subject: RE: Error converting data type varchar to int. Hi Larry, You need to add a cfprocparam for every parameter as follows. So your parameters are: @name varchar(50) = NULL, @schol_type_id int = NULL, @scholarships_uid int = NULL, @academic_uid int = NULL, @tablename varchar(50) = NULL, @Student_UID int = NULL Therefore your call to the stored proc should be as follows: cfstoredproc procedure=sp_schol_ins datasource=profilesandgo cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@Name value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@schol_type_id value=#FORM.schol_type_id# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@scholarships_uid value=#FORM.scholarships_uid# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@academic_uid value=#FORM.academic_uid# / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=@TableName value=#FORM.Sport# / cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=@Student_UID value=#Form.Student_UID# / cfprocresult name=InsertSchol /cfstoredproc I have assumed some FORM scope variables above for the missing parameters but this shouldn't be far off what you require in terms of calling the storedproc. If these are not all required then amend the code and the storedproc to suit. Later, Niall. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Optimize Query of Query
Richard White wrote: ... found that at present coldfusion query of queries just isnt built as a database engine And probably never will be. That is what ColdFusion engineers told a group of us at a pre-Max conference a couple of years ago. ColdFusion is *NOT* a database engine and is not being designed to replace one. Q-of-Q is only designed for simple tasks. ... 'what if i changed into an array of arrays and replicated my query but with manual cf code'. And this is exactly what they suggested for heavy data lifting inside of ColdFusion. As apposed to a database engine designed around SQL and query record sets, ColdFusion is optimized to use arrays and structures. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Question
I really really wish that someone would come up with a standard that will work in every browser. In my experience: 1. option tag cannot include any HTML child; 2. option style only support color, no background, no bold, italic or so. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Question
Or a browser that adheres to the standard? C'mon, we are in a developer forum here, any developer should be concern by the way their application behaves on the client side, and like it or not, about 80% of client use Explorer. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Optimize Query of Query
ColdFusion is *NOT* a database engine and is not being designed to replace one. thats a shame that they couldnt somehow make it utilise a db engine more instead of replacing one. array of arrays - And this is exactly what they suggested for heavy data lifting inside of ColdFusion. shame i couldnt have been in that meeting, would have saved me days of work!!! but good to know what i am doing in the best option ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Optimize Query of Query
Actually I have dealt with this and did some testing. What I ended up doing was creating an array with the look up vaules like so CFSet ResultsArray= ArrayNew(1) cfloop query = QMyResults CFSet ResultsArray[QuestionID]= QMyResults.SurveyResultsValue cfloop And then instead of doing a QoQ I just feed it the ID I was trying to tease out like so #ResultsArray[MyID]# The QoQ was expensive in terms of execution time. The execution time for the report went from 30 seconds to around a second. I don't know if this is best practices but it did the trick. On Tue, Sep 16, 2008 at 5:54 PM, Jim McAtee [EMAIL PROTECTED]wrote: I have a process that needs to do about 500 record lookups by ID. I thought I'd do a single query of the table, pulling down the needed data for every record on file (say 1000 records, just three columns) and then use QoQ instead of hitting the database so many times. Is there any way to index or otherwise optimize the dataset that I retrieve to optimize the query of query lookups? If I'm doing lookups using a particular column, would it help to sort the query by that column? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSS Question
Can you confirm that putting a background image on an option tag is valid CSS? If it's not then don't blame Microsoft for not supporting it. Don't blindly hate MS. Sure they need to take the blame for lots of things, but not everything they do is wrong. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:57 AM To: CF-Talk Subject: Re: CSS Question as long as M$ is in the game that will *never* happen Dave Francis wrote: Or a browser that adheres to the standard? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 9:44 AM To: CF-Talk Subject: Re: CSS Question Updates: I used a style attribute in the option tag (background-image:(url=images/imagename)) it works in FF3 but does absolutely nothing in IE7 I really really wish that someone would come up with a standard that will work in every browser. Scott Stewart wrote: cfoutput query=getHexID option value=#hex_id# cfif hex_id eq get_category.hex_idselectedcfelse/cfif span style=background-color:#hex_id#; border:medium; width:10px; height:10px;nbsp;/span#hex_id# /option /cfoutput any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Question
and for public sites you're absolutely right. But the application is for a College, the requirements state that it has to work in both...I'm just glad they didn't include Safari and IE7 for the Mac. Claude Schneegans wrote: Or a browser that adheres to the standard? C'mon, we are in a developer forum here, any developer should be concern by the way their application behaves on the client side, and like it or not, about 80% of client use Explorer. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem Passing Data
Nope, still doesn't work. Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 10:01 AM To: CF-Talk Subject: RE: Problem Passing Data OK, Steve - think I understand why you're having that problem now... Your problem is not with the checkboxes it's with the attendees att#n#. One of the Seminars is called Leading Inclusive, Diverse Teams. There's a comma in the name which means that this may be interpreted as two items in the list. Try removing the comma from the seminar name for now to see if that helps. Later, Niall. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 14:44 To: CF-Talk Subject: RE: Problem Passing Data The first checkbox doesn't pass the attendees, the other 6 do Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Problem Passing Data
Disregard - it worked. Thanks Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 10:41 AM To: CF-Talk Subject: RE: Problem Passing Data Nope, still doesn't work. Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] -Original Message- From: houseoffusion [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 10:01 AM To: CF-Talk Subject: RE: Problem Passing Data OK, Steve - think I understand why you're having that problem now... Your problem is not with the checkboxes it's with the attendees att#n#. One of the Seminars is called Leading Inclusive, Diverse Teams. There's a comma in the name which means that this may be interpreted as two items in the list. Try removing the comma from the seminar name for now to see if that helps. Later, Niall. -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: 17 September 2008 14:44 To: CF-Talk Subject: RE: Problem Passing Data The first checkbox doesn't pass the attendees, the other 6 do Steve LaBadie, Web Manger East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312686 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSS Question
I don't blindly hate them, and I'm pretty sure that it's valid CSS. I want a common set of selectors that will work predictably (and in the same way) in every browser, that will cover 98% of what you'd need to do CSS wise. Rewriting entire sites for cross browser compatibility is getting old, and honestly it's a waste of time. Andy Matthews wrote: Can you confirm that putting a background image on an option tag is valid CSS? If it's not then don't blame Microsoft for not supporting it. Don't blindly hate MS. Sure they need to take the blame for lots of things, but not everything they do is wrong. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:57 AM To: CF-Talk Subject: Re: CSS Question as long as M$ is in the game that will *never* happen Dave Francis wrote: Or a browser that adheres to the standard? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 9:44 AM To: CF-Talk Subject: Re: CSS Question Updates: I used a style attribute in the option tag (background-image:(url=images/imagename)) it works in FF3 but does absolutely nothing in IE7 I really really wish that someone would come up with a standard that will work in every browser. Scott Stewart wrote: cfoutput query=getHexID option value=#hex_id# cfif hex_id eq get_category.hex_idselectedcfelse/cfif span style=background-color:#hex_id#; border:medium; width:10px; height:10px;nbsp;/span#hex_id# /option /cfoutput any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error converting data type varchar to int.
cftransaction cfstoredproc procedure=sp_schol_ins datasource=profilesandgo ... /cfstoredproc /cftransaction Why do you have a CFTRANSACTION there? It doesn't seem to be doing anything. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
FireFox 3.0.1 Session Variable
Background: I have a form page within an I-frame. I increment a session var (name=SpageCount) when it posts and then use a js location.href back to form. I also pass a url var (name=uPageCount). Check if both vars match, proceed, if not start over. This is for testing validation to defeat users moving back in browser history to change answers. System has been working well for months. The Issue: With FireFox 3.0.1, the session var SpageCount jumps to 186 on first increment. PC, IE,Chrome function properly. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSS Question
I totally agree. There's no reason that we should have more than ONE version of CSS given that we have a governing body that has written the standard. Browser manufacturers should be participating in this body, not working against it. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 9:44 AM To: CF-Talk Subject: Re: CSS Question I don't blindly hate them, and I'm pretty sure that it's valid CSS. I want a common set of selectors that will work predictably (and in the same way) in every browser, that will cover 98% of what you'd need to do CSS wise. Rewriting entire sites for cross browser compatibility is getting old, and honestly it's a waste of time. Andy Matthews wrote: Can you confirm that putting a background image on an option tag is valid CSS? If it's not then don't blame Microsoft for not supporting it. Don't blindly hate MS. Sure they need to take the blame for lots of things, but not everything they do is wrong. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 8:57 AM To: CF-Talk Subject: Re: CSS Question as long as M$ is in the game that will *never* happen Dave Francis wrote: Or a browser that adheres to the standard? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 9:44 AM To: CF-Talk Subject: Re: CSS Question Updates: I used a style attribute in the option tag (background-image:(url=images/imagename)) it works in FF3 but does absolutely nothing in IE7 I really really wish that someone would come up with a standard that will work in every browser. Scott Stewart wrote: cfoutput query=getHexID option value=#hex_id# cfif hex_id eq get_category.hex_idselectedcfelse/cfif span style=background-color:#hex_id#; border:medium; width:10px; height:10px;nbsp;/span#hex_id# /option /cfoutput any reason why the span tag shouldn't produce a small box colored with the dynamic hex value -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mail
I have this same issue with CFMail, however, i have found times when it will work and times it won't. If I create a list of email addresses with a bad account (to send out in one big TO) from a query, then i will get the error. If i build a static list with bad accounts, then the page kicks off properly and send an undilverable email. Anyone have any idea why this would be? I have verifed all address formats. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FireFox 3.0.1 Session Variable
Background: I have a form page within an I-frame. I increment a session var (name=SpageCount) when it posts and then use a js location.href back to form. I also pass a url var (name=uPageCount). Check if both vars match, proceed, if not start over. This is for testing validation to defeat users moving back in browser history to change answers. System has been working well for months. The Issue: With FireFox 3.0.1, the session var SpageCount jumps to 186 on first increment. PC, IE,Chrome function properly. Additional Note: Pulled sequence out of I-frame and issues still exisits. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
dynamic cftree problem
I have a dynamic cftree that loads off a cfc. The cfc just fires off database queries to get the layout structure. I want the tree to retain state using session variables if the user hits the back or navigates to an intermediary processing page. I've been pounding my head against the wall after going over the yui docs several times and running into a few roadblocks. My js function has the correct node id, but one of two errors constantly occur. Either the getTreeObject says that no tree exists, or else the getnodebyproperty() is null after finding the tree. After that I would use the expand() to default the nodes open where the user left off. I did notice I couldn't get an expandall() to work either. I haven't really used cftree much, but I've spent exceedingly more time than I've been alotted trying to find solutions or bugs online that may be preventing this from working. Anyone have an example or some insight that might help? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FireFox 3.0.1 Session Variable
Background: I have a form page within an I-frame. I increment a session var (name=SpageCount) when it posts and then use a js location.href back to form. I also pass a url var (name=uPageCount). Check if both vars match, proceed, if not start over. This is for testing validation to defeat users moving back in browser history to change answers. System has been working well for months. The Issue: With FireFox 3.0.1, the session var SpageCount jumps to 186 on first increment. PC, IE,Chrome function properly. NOTE: DISREGARD POST. ISSUE STATED INCORRECTLY. sorry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF and PHP same server
Thanks for all the replies folkswe're up and running and it's smooth as silk ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Wed, 2008-09-17 at 08:19 -0500, Shannon Peevey wrote: Prefork is essentially the same model as Apache 1.3, so should be able to handle most volumes that you throw at it. Unless, of course, you get enough to need to load-balance :) On Tue, Sep 16, 2008 at 6:56 PM, James Holmes [EMAIL PROTECTED]wrote: PHP requires a single threaded webserver (as some of the libraries it runs aren't thread safe: http://neosmart.net/blog/2008/dont-believe-the-lies-php-isnt-thread-safe-yet/ ), so you need to run the Apache Prefork MPM. This is less than optimal for high volume sites, but it will work. On Wed, Sep 17, 2008 at 1:40 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, Just checking for any major gotchas with running CF and PHP on the same server (a VPS BTW)?? Would be CF 8 and whatever the latest PHP is. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
debugging when invoking cfc's
hi, i testing my cfc's by using the cfinvoke. and then if there is an error when running the cfc's then i have an exception handler to give me the details of the error however, although it gives me the details of the error it only provides me with the tag context until it hits the cfinvoke tag - any of the processing inside of the cfc's are not included in the tag context and therefore even though it may tell me i have an error with something it doesnt tell me what page and what line the error occured does anyone have a solution for this? not too sure if i have explaine this correctly but basically i want it to point me to the cfc function where the error occured and what line it occured on thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: debugging when invoking cfc's
to provide more details... i have just got an error and it tells that complex error types cannot be converted to simple values... but gives me no clue as to what line of code it is talking about, so i am having to search through the code to find it thanks hi, i testing my cfc's by using the cfinvoke. and then if there is an error when running the cfc's then i have an exception handler to give me the details of the error however, although it gives me the details of the error it only provides me with the tag context until it hits the cfinvoke tag - any of the processing inside of the cfc's are not included in the tag context and therefore even though it may tell me i have an error with something it doesnt tell me what page and what line the error occured does anyone have a solution for this? not too sure if i have explaine this correctly but basically i want it to point me to the cfc function where the error occured and what line it occured on thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JRun issues on Vista 64 bit?
I just got a new workstation running Windows Vista 64 and I am running into some issues with JRun. I pulled the latest release of CF off of the Adobe site this morning, making sure it was for Windows 64-bit. Everything installed right with no issues, but whenever I attempt to do anything with a DSN that points to SQL Server 2005 (also 64-bit), JRun crashes. There is no information in the JRun log files or the Windows event viewer. Has anybody seen anything like this before? Thanks -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: debugging when invoking cfc's
The problem is that you are trying to treat a complex object as a simple value. Take the following example. I am creating array that holds 2 values. If I were to dump it everything would be fine but If I tried to output it like below I would get the same error you are. cfset skills = ArrayNew(1) cfset arrayAppend(skills,ColdFusion) cfset arrayAppend(skills,JavaScript) cfoutput#skills#/cfoutput This is because the compiler does not understand what you are trying to do. If you want to see the string representation of this object you could always use the toString() method. cfoutput#skills.toString()#/cfoutput Hope this clears it up a little. Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org On Wed, Sep 17, 2008 at 12:29 PM, Richard White [EMAIL PROTECTED] wrote: to provide more details... i have just got an error and it tells that complex error types cannot be converted to simple values... but gives me no clue as to what line of code it is talking about, so i am having to search through the code to find it thanks hi, i testing my cfc's by using the cfinvoke. and then if there is an error when running the cfc's then i have an exception handler to give me the details of the error however, although it gives me the details of the error it only provides me with the tag context until it hits the cfinvoke tag - any of the processing inside of the cfc's are not included in the tag context and therefore even though it may tell me i have an error with something it doesnt tell me what page and what line the error occured does anyone have a solution for this? not too sure if i have explaine this correctly but basically i want it to point me to the cfc function where the error occured and what line it occured on thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with CFExecute...
Hi, all... I'm trying to run this cfexecute tag... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\getfiles.bat timeout= 2 /cfexecute which is supposed to fire off this batch file: c:\program files\rhinosoft.com\ftp voyager\ftpvoyager.exe profile=MLXChange get=IF20080917_010257_RES_1.zip local=e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\voyager (Line breaks have been added for readability...) The above batch file runs perfectly from the command line. However, when initialized with cfexecute, the cfthread (if I use one) just runs with no files transferred, or, if I don't use cfthread, the template just runs with no files transferred. There are no errors in the log, except when I use cfthread and have to abort the thread. When cfthread is used, I get a Get_Data:null error. (Get_Data being the name of the thread I have to eventually abort) Suggestions, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with CFExecute...
Rick Faircloth wrote: c:\program files\rhinosoft.com\ftp voyager\ftpvoyager.exe profile=MLXChange get=IF20080917_010257_RES_1.zip local=e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\voyager The above batch file runs perfectly from the command line. However, when initialized with cfexecute, the cfthread (if I use one) just runs with no files transferred, or, if I don't use cfthread, the template just runs with no files transferred. If you execute it from the command line, do you use the same user account as CF uses? I have never used ftp voyager, but from the looks of it MLXChange is a profile that is stored somewhere user specific (like in %APPDATA%). Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: debugging when invoking cfc's
thanks for the reply Dan, although that is a problem i do have at present and as you rightly said it is trying to a reference complex variable as a simple variable although this actual issue is not my problem. my problem is finding the offending code that has this issue. once i can find the offending piece of code then i will be able to fix it. my problem is that i am using cfinvoke to invoke a method in one of my cfc's. that cfc method uses lots of other methods to complete its work. but when i use the cfinvoke the tag context in the resulting error stops at the cfinvoke tag. so the only detail i get of the error is about the complex variable trying to be treated as a simple value. but it has no reference as to what function it is in or what line of code the offending error is occuring. is there a way i can get it to show this? thanks richard The problem is that you are trying to treat a complex object as a simple value. Take the following example. I am creating array that holds 2 values. If I were to dump it everything would be fine but If I tried to output it like below I would get the same error you are. cfset skills = ArrayNew(1) cfset arrayAppend(skills,ColdFusion) cfset arrayAppend(skills,JavaScript) cfoutput#skills#/cfoutput This is because the compiler does not understand what you are trying to do. If you want to see the string representation of this object you could always use the toString() method. cfoutput#skills.toString()#/cfoutput Hope this clears it up a little. Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: debugging when invoking cfc's
actually i must also say that i am not cfinvoking a cfc, i am actually invoking a web service, would this make any difference, and if so then how can i get it to provide me with more details? thanks thanks for the reply Dan, although that is a problem i do have at present and as you rightly said it is trying to a reference complex variable as a simple variable although this actual issue is not my problem. my problem is finding the offending code that has this issue. once i can find the offending piece of code then i will be able to fix it. my problem is that i am using cfinvoke to invoke a method in one of my cfc's. that cfc method uses lots of other methods to complete its work. but when i use the cfinvoke the tag context in the resulting error stops at the cfinvoke tag. so the only detail i get of the error is about the complex variable trying to be treated as a simple value. but it has no reference as to what function it is in or what line of code the offending error is occuring. is there a way i can get it to show this? thanks richard The problem is that you are trying to treat a complex object as a simple value. Take the following example. I am creating array that holds 2 values. If I were to dump it everything would be fine but If I tried to output it like below I would get the same error you are. cfset skills = ArrayNew(1) cfset arrayAppend(skills,ColdFusion) cfset arrayAppend(skills,JavaScript) cfoutput#skills#/cfoutput This is because the compiler does not understand what you are trying to do. If you want to see the string representation of this object you could always use the toString() method. cfoutput#skills.toString()#/cfoutput Hope this clears it up a little. Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: debugging when invoking cfc's
I am interested here as well, as debugging coldfusion code is mostly involving cfdump tags in strategic places... Does the Eclipse plug-in give any more information than the CF Debugging output? Hope this doesn't hi-jack the thread, speeves On Wed, Sep 17, 2008 at 1:23 PM, Richard White [EMAIL PROTECTED] wrote: thanks for the reply Dan, although that is a problem i do have at present and as you rightly said it is trying to a reference complex variable as a simple variable although this actual issue is not my problem. my problem is finding the offending code that has this issue. once i can find the offending piece of code then i will be able to fix it. my problem is that i am using cfinvoke to invoke a method in one of my cfc's. that cfc method uses lots of other methods to complete its work. but when i use the cfinvoke the tag context in the resulting error stops at the cfinvoke tag. so the only detail i get of the error is about the complex variable trying to be treated as a simple value. but it has no reference as to what function it is in or what line of code the offending error is occuring. is there a way i can get it to show this? thanks richard The problem is that you are trying to treat a complex object as a simple value. Take the following example. I am creating array that holds 2 values. If I were to dump it everything would be fine but If I tried to output it like below I would get the same error you are. cfset skills = ArrayNew(1) cfset arrayAppend(skills,ColdFusion) cfset arrayAppend(skills,JavaScript) cfoutput#skills#/cfoutput This is because the compiler does not understand what you are trying to do. If you want to see the string representation of this object you could always use the toString() method. cfoutput#skills.toString()#/cfoutput Hope this clears it up a little. Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun issues on Vista 64 bit?
I can say that I've got CF8 running on Vista 64, no issues whatsoever. I don't know how to help you. Maybe try a CF reinstall? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] On Wed, Sep 17, 2008 at 10:38 AM, Jeff Chastain [EMAIL PROTECTED] wrote: I just got a new workstation running Windows Vista 64 and I am running into some issues with JRun. I pulled the latest release of CF off of the Adobe site this morning, making sure it was for Windows 64-bit. Everything installed right with no issues, but whenever I attempt to do anything with a DSN that points to SQL Server 2005 (also 64-bit), JRun crashes. There is no information in the JRun log files or the Windows event viewer. Has anybody seen anything like this before? Thanks -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: kickass vps disk space allotment
I am looking at the KickAss Entry package with 10 gigs. http://www.kickassvps.com/services/windows_vps/plans.php How much disk space is actually available on a 10 gig partition? Is that 10 gigs above and beyond the base Windows install. If not how much space it available for sites software and Databases etc.? How much head room (free disk space) is needed to make sure performance is not effected? Many TIA G -- We would be eternally miserable if our errors worried us too much because as we push forward we will make plenty more. Ernest O. Lawrence ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: debugging when invoking cfc's
hi shannon, i dont know if my example is exactly the same as what you were asking as my problem was specifically to do with debugging the cfc's when calling them as a web service. but i just worked out that i shouldnt be calling them as a web service until i have thorougly debugged them!!!. instead of cfinvoking the webservice, i cfinvoke the component directly and then it tells me all about the problem again (as the webservice is just a bridge to the cfc anyway) thanks anyway :) in relation to your question i havent seen any additional debugging provided by the cfeclipse plug in, but not familiar with it enough to say that with confidence :) so will be looking at others responses as well good luck richard I am interested here as well, as debugging coldfusion code is mostly involving cfdump tags in strategic places... Does the Eclipse plug-in give any more information than the CF Debugging output? Hope this doesn't hi-jack the thread, speeves ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JRun issues on Vista 64 bit?
Thanks Nathan. Do you happen to have it running with SQL Server 2005 Express, 64-bit? I am just trying to isolate the real problem here and the service only appears to crash when I do anything db related with a DSN connected to SQL 2005. Thanks -- Jeff -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 1:39 PM To: CF-Talk Subject: Re: JRun issues on Vista 64 bit? I can say that I've got CF8 running on Vista 64, no issues whatsoever. I don't know how to help you. Maybe try a CF reinstall? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] On Wed, Sep 17, 2008 at 10:38 AM, Jeff Chastain [EMAIL PROTECTED] wrote: I just got a new workstation running Windows Vista 64 and I am running into some issues with JRun. I pulled the latest release of CF off of the Adobe site this morning, making sure it was for Windows 64-bit. Everything installed right with no issues, but whenever I attempt to do anything with a DSN that points to SQL Server 2005 (also 64-bit), JRun crashes. There is no information in the JRun log files or the Windows event viewer. Has anybody seen anything like this before? Thanks -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with CFExecute...
Changing CF log on as to my personal account seems to have done the trick. Any ramifications for changing the log on as for CF that I should be aware of? Thanks, Jochem. Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 2:15 PM To: CF-Talk Subject: Re: Problem with CFExecute... Rick Faircloth wrote: c:\program files\rhinosoft.com\ftp voyager\ftpvoyager.exe profile=MLXChange get=IF20080917_010257_RES_1.zip local=e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\voyager The above batch file runs perfectly from the command line. However, when initialized with cfexecute, the cfthread (if I use one) just runs with no files transferred, or, if I don't use cfthread, the template just runs with no files transferred. If you execute it from the command line, do you use the same user account as CF uses? I have never used ftp voyager, but from the looks of it MLXChange is a profile that is stored somewhere user specific (like in %APPDATA%). Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF, JQuery and IE
On Tue, Sep 16, 2008 at 9:55 AM, Scott Stewart [EMAIL PROTECTED] wrote: As far as it happening in all plugins, the answer is yes. It'll work like a champ in FF3 and fail completely in IE7 Probably not the issue, but note that IE barfs if you try script ... / instead of script .../script -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with CFExecute...
Rick Faircloth wrote: Changing CF log on as to my personal account seems to have done the trick. Any ramifications for changing the log on as for CF that I should be aware of? Use an account with the least privileges and never use an account that is used by a user as well. (Just imagine what would happen if that user enters his password incorrectly 3 times and is locked out.) Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFILE and Ajax file uploads
Hi all, So I did some googling and searched through the threads here as well. I'm not finding what I need to know. What I'm trying to do: Upload a file to the server via ajax and an iFrame using the tool from: (http://www.webtoolkit.info/ajax-file-upload.html) I've got the code in a test file, and can get the form var in the receiving (cfm) page to output the file var (it results in a path to the file I choose) but it won't upload. Any ideas? Anyone using this and getting it to work? I've zipped my files and posted them here (http://www.cflhd.gov/cffileajax.zip) for you to look at. The code from the AIM toolkit is unchanged except the form tag, I played around with that a bit. CHANGES: added enctype - none prior renamed the file input from 'form[file]' to FILE_LOC changed action to cffile.cfm Really I just need to know what the CFILE tag is expecting. I've used it no problem in the past, but I think I'm not quite understanding something here. (Oh, I know there are sofware packages I can buy and flash solutions.. I don't want either. This is govt...) Thanks for your time and effort. Brent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with CFExecute...
Jochem van Dieten wrote: (Just imagine what would happen if that user enters his password incorrectly 3 times and is locked out.) Or leaves the company and the user account is deactivated. Or changes their password after three months as often is network policy. I've seen it all. Do as Jochem suggests and create a user account just for the ColdFusion service and give it only what permissions you know you want ColdFusion applications working with. But otherwise this is a very common setup. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: kickass vps disk space allotment
Hi, Gerald. I've been using a KAVPS for about 3 months now and have had zero problems and good support when I needed something. (I spoke to them about needing good support before getting an account...) At setup, I wanted to mirror my local dev environment, so I asked for an additional 10 GB of hard drive space on an e: drive. I asked if they could just take the space from my c: drive, since I didn't think I'd need 20GB of system/program drive space, but they just added an extra 10GB for the e: drive. (I'm not sure if I'm charged separately for that, since I worked out a package deal based on things I did and didn't need in their package offerings) I've got the Basic package, which allows for 20 GB on the c:drive, which would have to be used for sites, I'm sure. You also get 1GB of space for MySQL or MSSQL in addition to the 10GB on the Entry package, for $5 and $10 per month, respectively. Drive space is cheap...ask for a deal! I don't work for KAVPS, but I'm just a satisfied customer... To be sure about your info, however, I'd email or call them and get your info straight from the horse's, or rather, donkey's, mouth! :o) Rick -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 2:41 PM To: CF-Talk Subject: SOT: kickass vps disk space allotment I am looking at the KickAss Entry package with 10 gigs. http://www.kickassvps.com/services/windows_vps/plans.php How much disk space is actually available on a 10 gig partition? Is that 10 gigs above and beyond the base Windows install. If not how much space it available for sites software and Databases etc.? How much head room (free disk space) is needed to make sure performance is not effected? Many TIA G -- We would be eternally miserable if our errors worried us too much because as we push forward we will make plenty more. -Ernest O. Lawrence ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JRun issues on Vista 64 bit?
And as a follow on, a complete uninstall, delete the JRun folder and reinstall did not do anything different. When I try to create the new MSSQL 2005 datasource, the browser window hangs for a few seconds and then I get a Windows popup window that simply says that JRun failed and is restarting. The JRun log files contain no details regarding the issue either. -- Jeff -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 2:07 PM To: 'cf-talk@houseoffusion.com' Subject: RE: JRun issues on Vista 64 bit? Thanks Nathan. Do you happen to have it running with SQL Server 2005 Express, 64-bit? I am just trying to isolate the real problem here and the service only appears to crash when I do anything db related with a DSN connected to SQL 2005. Thanks -- Jeff -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 1:39 PM To: CF-Talk Subject: Re: JRun issues on Vista 64 bit? I can say that I've got CF8 running on Vista 64, no issues whatsoever. I don't know how to help you. Maybe try a CF reinstall? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] On Wed, Sep 17, 2008 at 10:38 AM, Jeff Chastain [EMAIL PROTECTED] wrote: I just got a new workstation running Windows Vista 64 and I am running into some issues with JRun. I pulled the latest release of CF off of the Adobe site this morning, making sure it was for Windows 64-bit. Everything installed right with no issues, but whenever I attempt to do anything with a DSN that points to SQL Server 2005 (also 64-bit), JRun crashes. There is no information in the JRun log files or the Windows event viewer. Has anybody seen anything like this before? Thanks -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with CFExecute...
Thanks for the feedback, guys! Rick -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 4:04 PM To: CF-Talk Subject: Re: Problem with CFExecute... Jochem van Dieten wrote: (Just imagine what would happen if that user enters his password incorrectly 3 times and is locked out.) Or leaves the company and the user account is deactivated. Or changes their password after three months as often is network policy. I've seen it all. Do as Jochem suggests and create a user account just for the ColdFusion service and give it only what permissions you know you want ColdFusion applications working with. But otherwise this is a very common setup. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: kickass vps disk space allotment
Thanx Rick, How long did it take for them to set up the server? ;) I had a coupon for a 1 gig MSSQL DB for free so it turned out to be a great deal. I really miss having a server ever since I got out of the hosting biz. ~G~ On Wed, Sep 17, 2008 at 4:06 PM, Rick Faircloth [EMAIL PROTECTED]wrote: Hi, Gerald. I've been using a KAVPS for about 3 months now and have had zero problems and good support when I needed something. (I spoke to them about needing good support before getting an account...) At setup, I wanted to mirror my local dev environment, so I asked for an additional 10 GB of hard drive space on an e: drive. I asked if they could just take the space from my c: drive, since I didn't think I'd need 20GB of system/program drive space, but they just added an extra 10GB for the e: drive. (I'm not sure if I'm charged separately for that, since I worked out a package deal based on things I did and didn't need in their package offerings) I've got the Basic package, which allows for 20 GB on the c:drive, which would have to be used for sites, I'm sure. You also get 1GB of space for MySQL or MSSQL in addition to the 10GB on the Entry package, for $5 and $10 per month, respectively. Drive space is cheap...ask for a deal! I don't work for KAVPS, but I'm just a satisfied customer... To be sure about your info, however, I'd email or call them and get your info straight from the horse's, or rather, donkey's, mouth! :o) Rick -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 2:41 PM To: CF-Talk Subject: SOT: kickass vps disk space allotment I am looking at the KickAss Entry package with 10 gigs. http://www.kickassvps.com/services/windows_vps/plans.php How much disk space is actually available on a 10 gig partition? Is that 10 gigs above and beyond the base Windows install. If not how much space it available for sites software and Databases etc.? How much head room (free disk space) is needed to make sure performance is not effected? Many TIA G -- We would be eternally miserable if our errors worried us too much because as we push forward we will make plenty more. -Ernest O. Lawrence ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun issues on Vista 64 bit?
As a test case, can you create a datasource with the built in DB (Derby)? It would probably help to figure out if the issue is with datasources in general or with mssql 2005 in particular. Judah On Wed, Sep 17, 2008 at 1:26 PM, Jeff Chastain [EMAIL PROTECTED] wrote: And as a follow on, a complete uninstall, delete the JRun folder and reinstall did not do anything different. When I try to create the new MSSQL 2005 datasource, the browser window hangs for a few seconds and then I get a Windows popup window that simply says that JRun failed and is restarting. The JRun log files contain no details regarding the issue either. -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Empty error message in a query of queries
Here's the beginning of the error message for a query of queries: Message [empty string] StackTrace java.lang.ClassCastException at coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156) at coldfusion.sql.imq.TableSorter.compareTo The query of queries goes: cfelseif qSelectReports.currentrow gt 1 cfquery name=qReportSummary dbtype=query select * from qSummary union select * from qReportSummary /cfquery The query has worked for months until today. It continues to work for certain report summaries, but not in this one in particular. I'm thinking it's because of the data specific to that report. Anyone know of any special characters to look out for which might be causing the failure in the QofQ? ( ? So glad to have this forum to post to so; I'd like to keep my hair, Brent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: JRun issues on Vista 64 bit?
Judah, Creating a data source to Derby works just fine. I can verify the existing data sources as well as create a new one. The issue only appears when I am trying to connect to SQL 2005. Thanks -- Jeff -Original Message- From: Judah McAuley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 4:19 PM To: CF-Talk Subject: Re: JRun issues on Vista 64 bit? As a test case, can you create a datasource with the built in DB (Derby)? It would probably help to figure out if the issue is with datasources in general or with mssql 2005 in particular. Judah On Wed, Sep 17, 2008 at 1:26 PM, Jeff Chastain [EMAIL PROTECTED] wrote: And as a follow on, a complete uninstall, delete the JRun folder and reinstall did not do anything different. When I try to create the new MSSQL 2005 datasource, the browser window hangs for a few seconds and then I get a Windows popup window that simply says that JRun failed and is restarting. The JRun log files contain no details regarding the issue either. -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Empty error message in a query of queries
Brent, Without seeing the two queries that your are joining together, I can only guess at the problem. Likely, one of the columns in qReportSummary doesn't match the datatype of the corresponding column in qSummary, or you don't have the same number of columns in both queries. HTH, Carl Brent Shaub wrote: Here's the beginning of the error message for a query of queries: Message [empty string] StackTrace java.lang.ClassCastException at coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156) at coldfusion.sql.imq.TableSorter.compareTo The query of queries goes: cfelseif qSelectReports.currentrow gt 1 cfquery name=qReportSummary dbtype=query select * from qSummary union select * from qReportSummary /cfquery The query has worked for months until today. It continues to work for certain report summaries, but not in this one in particular. I'm thinking it's because of the data specific to that report. Anyone know of any special characters to look out for which might be causing the failure in the QofQ? ( ? So glad to have this forum to post to so; I'd like to keep my hair, Brent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun issues on Vista 64 bit?
Try creating a system ODBC connection in Windows and see if that works. If it does, try creating an ODBC datasource connection in the CF Admin. That should tell you if it is the windows connection to the db, the CF jdbc driver for mssql or something else. Judah On Wed, Sep 17, 2008 at 2:22 PM, Jeff Chastain [EMAIL PROTECTED] wrote: Judah, Creating a data source to Derby works just fine. I can verify the existing data sources as well as create a new one. The issue only appears when I am trying to connect to SQL 2005. Thanks -- Jeff -Original Message- From: Judah McAuley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 4:19 PM To: CF-Talk Subject: Re: JRun issues on Vista 64 bit? As a test case, can you create a datasource with the built in DB (Derby)? It would probably help to figure out if the issue is with datasources in general or with mssql 2005 in particular. Judah On Wed, Sep 17, 2008 at 1:26 PM, Jeff Chastain [EMAIL PROTECTED] wrote: And as a follow on, a complete uninstall, delete the JRun folder and reinstall did not do anything different. When I try to create the new MSSQL 2005 datasource, the browser window hangs for a few seconds and then I get a Windows popup window that simply says that JRun failed and is restarting. The JRun log files contain no details regarding the issue either. -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 and Crystal Reports v2008 or v8.5
Is anyone running CF8 and calling a crystal report (created with either version 8.5 or 2008) via the cfreport tag? We use Crystal Reports 8.5 with our VB6 apps but have never tried to use them with Coldfusion. I'm attempting that now (with either crystal v8.5 or with a 30-trial of the 2008 version) with no luck. My cfm page runs but I just get a blank screen. If I were doing this from scratch, what are the steps I need to take? Install Crystal 8.5 or 2008 on the server? I assume I need to install it on the server, or do I install it on my machine and then copy some of the dlls to the server and register them? Then call with the tag as follows: cfreport report = c:\inetpub\wwwroot\Database\Military_Billings\CFR_Templates\SBA.rpt/cfreport? What are the steps? And, what am I missing? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun issues on Vista 64 bit?
Actually, I think I had 2k5 personal edition or something, whatever installed with visual studio, I hadn't been using it, but I dumped that last weekend and installed SQL Server 2008 Express x64, which is working really great with CF8. Speaking of features, I don't think 2008 is much different except mainly in dev tools and stuff, so any SQL you write on 2008 will likely run in 2005, so it probably wouldn't hurt to do that. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] On Wed, Sep 17, 2008 at 12:06 PM, Jeff Chastain [EMAIL PROTECTED] wrote: Thanks Nathan. Do you happen to have it running with SQL Server 2005 Express, 64-bit? I am just trying to isolate the real problem here and the service only appears to crash when I do anything db related with a DSN connected to SQL 2005. Thanks -- Jeff -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 1:39 PM To: CF-Talk Subject: Re: JRun issues on Vista 64 bit? I can say that I've got CF8 running on Vista 64, no issues whatsoever. I don't know how to help you. Maybe try a CF reinstall? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] On Wed, Sep 17, 2008 at 10:38 AM, Jeff Chastain [EMAIL PROTECTED] wrote: I just got a new workstation running Windows Vista 64 and I am running into some issues with JRun. I pulled the latest release of CF off of the Adobe site this morning, making sure it was for Windows 64-bit. Everything installed right with no issues, but whenever I attempt to do anything with a DSN that points to SQL Server 2005 (also 64-bit), JRun crashes. There is no information in the JRun log files or the Windows event viewer. Has anybody seen anything like this before? Thanks -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
mssql 2008 dev tools
To take this to a new thread... Does anyone know how to write sql that will return the results in an editable grid? If I do a right click on a table I can choose to edit top 200 rows and it returns the results in an editable grid and then I can open up the sql pane above and rewrite the sql and keep the results editable. But when I just want to open up a new blank query and write my own, I cannot for the life of me figure out how to return the results in an editable grid. Any thoughts? SQL Server Management Studio 2008 under XP Pro for what its worth. Judah ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Trouble getting this loop to work ...
Having trouble getting this loop to work. I'm not sure anymore if it is even possible, but it seemed like a good way to go at the start. What I'm trying to do is have the loop take the list (it can be anything from 1 to 42 items long) from a form and then run the function in the cfquery for each item in the list and keep the output from each iteration of the query in #mcategories# cfloop list=#mcategory# index=mcategories delimiters=, cfquery name=qGetMList datasource=ROL select * from ROL.getcategorydetailnames(#mcategories#); /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML-RPC with CF8?
I've found some web references to consuming XMP-RPC using CF8's built-in
funcitonality, but no examples. I took it to mean that it may be possible
to use cfinvoke to consume XML-RPC data, but I'm not really sure if I'm
on the right track.
cfinvoke webservice=http://xml.a.com;
method=getReport
returnvariable=rpt
cfinvokeargument name=userid value=company22
cfinvokeargument name=password value=abcdef
cfinvokeargument name=args value=17
/cfinvoke
When I try this I get the following errors:
Cannot generate stub objects for web service invocation.
Name: http://xml.y.com. WSDL: http://xml.aa.com.
WSDLException (at /methodResponse): faultCode=INVALID_WSDL: Expected
element '{http://schemas.xmlsoap.org/wsdl/}definitions'.: It is
recommended that you use a web browser to retrieve and examine the
requested WSDL document to ensure it is correct. If the requested WSDL
document cannot be retrieved or is dynamically generated, it is likely
that the target web service has programming errors.
So I take it that it's trying to retrieve a WSDL document and one doesn't
exist? Am I on the right track to using CF8's facilities for doing this?
I can successfully make the same XML-RPC call using cfhttp.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312727
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML-RPC with CF8?
I've found some web references to consuming XMP-RPC using CF8's built-in funcitonality, but no examples. I took it to mean that it may be possible to use cfinvoke to consume XML-RPC data, but I'm not really sure if I'm on the right track. cfinvoke webservice=http://xml.a.com; ... CFINVOKE lets you call SOAP services. I don't think it supports XML-RPC. For that, you're basically on your own. You'll have to use CFHTTP and CF's XML parser. Someone may have written code for this already, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Totally Baffling Extra being added in a plain text email. What the heck?
ARRRGGHH This is the kind of thing that makes you tear ALL your hair out! If anybody can figure this one out, I'll treat you at Starbucks in some future life! Seems simple enough - I'm just ending an plain text email: cfmail to=somebody.somewhere.com subject=Just a quick test from=[EMAIL PROTECTED] failto=[EMAIL PROTECTED] cfinclude template=textEMAIL_BODY.cfm //cfmail textEMAIL_BODY.cfm - for testing right now is: cfoutputFrom #request.someNAME#, I'm testing plain text email!!!/cfoutput That's *IT*!! Nothing else to screw up. When I send this, in the body of the email I'm getting (minus the quotes): From Tom Now, before you say, well, you've got an extra somewhere you just haven't found yet.. If I change the first letter in From to lower case from, the goes away. In fact, if I change it to ANYTHING else, lower or upper case, the goes away If I change it BACK to a cap From, the returns. Now, it's gets even MORE weird! Let's CHANGE textEMAIL_BODY.cfm to: cfoutput cfif isDEFINED(req.DATE)#req.DATE# /cfifFrom #request.someNAME#, I'm testing plain text email!!!/cfoutput Happens AGAIN - it seems that any combination of code that puts F together, results in the displaying in the email! Yes, I can find a way to move the From away from a tag - but then it messes with the spacing requested by the client. I've written dozens of richtext email systems for clients, and have never run into anything like this! I'M TOTALLY STUMPED!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem loading data from text file...
I'm using this query to load data into a table from a text file: cfquery name=load_data datasource=c21ar load data infile 'e:/inetpub/webroot/real_estate_data/hmls/data/#today#_idx_custom/active_photos.txt' into table hmls_active_photos_temp lines terminated by '\r\n' ignore 1 lines /cfquery It runs fine except for the fact that at the end of each day's new active_photos.txt file, there are a couple of blanks lines, like the ENTER key has been struck a couple of times after the last line of data. The load data infile command is trying to read these lines and throws an error because of the empty lines. Is there some way to cause this query not to process, or to skip, empty lines? The empty lines are always at the end of the file and prevent me from automating the loading of data. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun issues on Vista 64 bit?
The issue is in CF. I can created a system ODBC connection without any issue and can create and ODBC connection in CF. I have tried both MSSQL 2005 and MSSQL 2008, as well as CF8 in standalone and multi-server. All combinations fail when trying to create an MSSQL datasource. Thanks -- Jeff ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312731 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE and Ajax file uploads
I used this jQuery plugin http://www.phpletter.com/Demo/AjaxFileUpload-Demo/ On Thu, Sep 18, 2008 at 5:02 AM, Brent Nicholas [EMAIL PROTECTED]wrote: Hi all, So I did some googling and searched through the threads here as well. I'm not finding what I need to know. What I'm trying to do: Upload a file to the server via ajax and an iFrame using the tool from: ( http://www.webtoolkit.info/ajax-file-upload.html) I've got the code in a test file, and can get the form var in the receiving (cfm) page to output the file var (it results in a path to the file I choose) but it won't upload. Any ideas? Anyone using this and getting it to work? I've zipped my files and posted them here ( http://www.cflhd.gov/cffileajax.zip) for you to look at. The code from the AIM toolkit is unchanged except the form tag, I played around with that a bit. CHANGES: added enctype - none prior renamed the file input from 'form[file]' to FILE_LOC changed action to cffile.cfm Really I just need to know what the CFILE tag is expecting. I've used it no problem in the past, but I think I'm not quite understanding something here. (Oh, I know there are sofware packages I can buy and flash solutions.. I don't want either. This is govt...) Thanks for your time and effort. Brent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun issues on Vista 64 bit?
In addition, I tried creating a MSSQL datasource, connecting to another server I have running MSSQL 2005 and JRun crashed trying to setup that datasource as well, so it is something local to the JRun/CF install and its connection ability with MSSQL. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Totally Baffling Extra being added in a plain text email. What the heck?
Les, Kind of weird for sure. How about trying to store the contents of the include file into a local var, and then use that in the body of the email. cfsavecontent variable=email_body cfinclude template=textEMAIL_BODY.cfm / /cfsavecontent cfmail to=somebody.somewhere.com subject=Just a quick test from=[EMAIL PROTECTED] failto=[EMAIL PROTECTED] #email_body#/cfmail Dan On Wed, Sep 17, 2008 at 7:53 PM, Les Mizzell [EMAIL PROTECTED] wrote: ARRRGGHH This is the kind of thing that makes you tear ALL your hair out! If anybody can figure this one out, I'll treat you at Starbucks in some future life! Seems simple enough - I'm just ending an plain text email: cfmail to=somebody.somewhere.com subject=Just a quick test from=[EMAIL PROTECTED] failto=[EMAIL PROTECTED] cfinclude template=textEMAIL_BODY.cfm //cfmail textEMAIL_BODY.cfm - for testing right now is: cfoutputFrom #request.someNAME#, I'm testing plain text email!!!/cfoutput That's *IT*!! Nothing else to screw up. When I send this, in the body of the email I'm getting (minus the quotes): From Tom Now, before you say, well, you've got an extra somewhere you just haven't found yet.. If I change the first letter in From to lower case from, the goes away. In fact, if I change it to ANYTHING else, lower or upper case, the goes away If I change it BACK to a cap From, the returns. Now, it's gets even MORE weird! Let's CHANGE textEMAIL_BODY.cfm to: cfoutput cfif isDEFINED(req.DATE)#req.DATE# /cfifFrom #request.someNAME#, I'm testing plain text email!!!/cfoutput Happens AGAIN - it seems that any combination of code that puts F together, results in the displaying in the email! Yes, I can find a way to move the From away from a tag - but then it messes with the spacing requested by the client. I've written dozens of richtext email systems for clients, and have never run into anything like this! I'M TOTALLY STUMPED!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Developing an order form for an application
Just wondering what the easiest way might be to complete the following task I have a client that has requested that they display an order form on their website. Basically they want the form to look like the following: Product NamePrice QTY Total Product 13.00 2 6.00 Product 25.00 1 5.00 Product 36.00 318.00 Total 29.00 Developing the form is easy - just wanting to know what the best way would be to do the calculations in the form prior to the user submitting the form. Thanks in advance Here is the code that I have so far: form action=## id=orderform1 cfoutput table width=100% border=0 cellspacing=0 cellpadding=0 tr thProduct/th thDescription/th thUnit Price /th thQuantity/th thSubtotoal/th /tr tr tdProduct 1 /td tdProd 1 desc /td td align=center3.00/td td align=centerinput name=qty1 type=text value=#1# size=3 onBlur=cleanField(this)/td td align=center3.00 * qty1 /tr tr tdProduct 2 /td tdProd 2 desc /td td align=center5.00/td td align=centerinput name=qty2 type=text value=## size=3 onBlur=cleanField(this)/td td align=center5.00/td /tr tr tdProduct 3 /td tdProd 3 desc /td td align=center6.00/td td align=centerinput name=qty3 type=text value=## size=3 onBlur=cleanField(this)/td td align=center18.00/td /tr tr td align=centerTotal/td td align=centernbsp;/td td align=centernbsp;/td td align=centernbsp;/td td align=center29.00/td /tr tr td align=centernbsp;/td td align=centernbsp;/td td align=centernbsp;/td td align=centernbsp;/td td align=centernbsp;/td /tr /table /cfoutput /form Thanks in advance. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Totally Baffling Extra being added in a plain text email. What the heck?
Try adding a server=some non-existent server attribute to the cfmail tag. This will cause the mail spool file to end up in the Udelivr folder (alternatively you can just try to catch the file in the Spool directory before it gets picked up). Now you can look at the raw email, does the problem exist there? If not then your email client or something else is adding it. -Ryan From: Les Mizzell [EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 5:55 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Totally Baffling Extra being added in a plain text email. What the heck? ARRRGGHH This is the kind of thing that makes you tear ALL your hair out! If anybody can figure this one out, I'll treat you at Starbucks in some future life! ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML-RPC with CF8?
I actually just got done doing a project that consumed an XML-RPC web service. There is a CFC Roger Benningfield wrote that will translate xml-rpc xml to ColdFusion vars and back again. There is a link in the comments of my blog here: http://www.codersrevolution.com/index.cfm/2008/8/30/XMLRPC-Alive-yes-but-still-kicking Basically, you call the webservice with a cfhttp tag, and you simply pass the XML as the body of the request and parse the XML that comes back. Here's a snippet of code that goes with the CFC I mentioned above (error checking removed). cfset local.request_xml = CFML2XMLRPC(local.inputs_array,'call') cfhttp url=#arguments.web_service_location# method=POST timeout=60 result=local.cfhttp cfhttpparam name=request_body value=#local.request_xml# type=xml /cfhttp cfset local.response = XMLRPC2CFML(local.cfhttp.filecontent) ~Brad - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 17, 2008 6:12 PM Subject: RE: XML-RPC with CF8? I've found some web references to consuming XMP-RPC using CF8's built-in funcitonality, but no examples. I took it to mean that it may be possible to use cfinvoke to consume XML-RPC data, but I'm not really sure if I'm on the right track. cfinvoke webservice=http://xml.a.com; ... CFINVOKE lets you call SOAP services. I don't think it supports XML-RPC. For that, you're basically on your own. You'll have to use CFHTTP and CF's XML parser. Someone may have written code for this already, though. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Empty error message in a query of queries
I'm guessing it's a datatype problem. As a guess you could try a union all, since it would keep it from comparing every record in the second query to the first to eliminate dupes. How are these queries being created? Are the columns all identical data types? If you are creating them with querynew() are you specifying data types? ~Brad - Original Message - From: Carl Von Stetten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 17, 2008 4:30 PM Subject: Re: Empty error message in a query of queries Brent, Without seeing the two queries that your are joining together, I can only guess at the problem. Likely, one of the columns in qReportSummary doesn't match the datatype of the corresponding column in qSummary, or you don't have the same number of columns in both queries. HTH, Carl Brent Shaub wrote: Here's the beginning of the error message for a query of queries: Message [empty string] StackTrace java.lang.ClassCastException at coldfusion.sql.imq.GenericComparator.compare(Comparator.java:67) at coldfusion.sql.imq.TableSorter.compareTo(TableSorter.java:156) at coldfusion.sql.imq.TableSorter.compareTo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Nested sets under load
I'm designing an application that will require a whole series of heirarchies - its an action plan where the plans can be quite complex. The idea is a business event happens (a sale or a project is started ) and that triggers a whole set of events that must follow. I'm thinking of using nested sets to lay out the heirarchies of events, because they are so flexible adn its so easy to move things about with them. But i'm a bit worried about how it might perform under load. I've used nested sets for ages in my CMS and had no problems at all. But you dont make hundreds of updates a day to a CMS node structure. Has anyone used an application using nested sets where there are lots of updates a day? Did it perform ok? My environment is Windows2003, CF7, MSSQLServer.We are provisioned ok for RAM and processor capacity, but dont want to clog it with too much activity from any one application. There are 400+ offices using this site - it's an extranet app. Can anyone give me any experience with nested sets and coldfusion/MSSQLServer with volumes of updates like that? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Nested sets under load
My advice is stay away. Nested sets (left right node) are great for calculating ancestor and descendant nodes, but they are a brittle data structure meaning if some math goes wrong and the wrong nodes get pointed at the wrong parent you can get fubared. (or if a developer tries to go in and fix the nesting by hand) If your data is changing on a regular basis, updates are going to be Hades. You will get locks happening all over the table any time you add a new node because of the ripple affect. Also, the logic to copy and paste a node with its children elsewhere in the tree can be enough to make you want to shoot yourself. Truthfully, I would stick with an adjacency list (parent_id). You can update the table often and not bother the other records. It is harder to screw up the data. Moving subtrees around is as simple as updating the top node of the subtree to have a new parent. The only real downside is if you find yourself needing to calculate descendant and ancestor nodes. That being said, there are ways to mitigate the short-comings of both systems but I don't care for them much because they usually require keeping de-normalized data updated. ~Brad - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 17, 2008 11:30 PM Subject: Nested sets under load I'm designing an application that will require a whole series of heirarchies - its an action plan where the plans can be quite complex. The idea is a business event happens (a sale or a project is started ) and that triggers a whole set of events that must follow. I'm thinking of using nested sets to lay out the heirarchies of events, because they are so flexible adn its so easy to move things about with them. But i'm a bit worried about how it might perform under load. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Nested sets under load
What version mssql? I though 2005 had native support for hierarchical data sets? Much like Oracle. Mark On Thu, Sep 18, 2008 at 3:00 PM, Brad Wood [EMAIL PROTECTED] wrote: My advice is stay away. Nested sets (left right node) are great for calculating ancestor and descendant nodes, but they are a brittle data structure meaning if some math goes wrong and the wrong nodes get pointed at the wrong parent you can get fubared. (or if a developer tries to go in and fix the nesting by hand) If your data is changing on a regular basis, updates are going to be Hades. You will get locks happening all over the table any time you add a new node because of the ripple affect. Also, the logic to copy and paste a node with its children elsewhere in the tree can be enough to make you want to shoot yourself. Truthfully, I would stick with an adjacency list (parent_id). You can update the table often and not bother the other records. It is harder to screw up the data. Moving subtrees around is as simple as updating the top node of the subtree to have a new parent. The only real downside is if you find yourself needing to calculate descendant and ancestor nodes. That being said, there are ways to mitigate the short-comings of both systems but I don't care for them much because they usually require keeping de-normalized data updated. ~Brad - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 17, 2008 11:30 PM Subject: Nested sets under load I'm designing an application that will require a whole series of heirarchies - its an action plan where the plans can be quite complex. The idea is a business event happens (a sale or a project is started ) and that triggers a whole set of events that must follow. I'm thinking of using nested sets to lay out the heirarchies of events, because they are so flexible adn its so easy to move things about with them. But i'm a bit worried about how it might perform under load. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFILE and Ajax file uploads
Dojo has a /pimp/ file upload deal-- it'll even do the flash multi-file one that degrades into a normal AJAX file upload thingie. That toolkit just freaking rocks. Dunno if the problem is with the toolkit tho... sounds like it's one of the I can't believe I forgot /that/ type deals, like I had the other night. Freaking hours, and I hadn't set the content-type right. Bah! -- The poor are prevented from thinking by the discipline of others, the rich by their own. Theodor Adorno On Wed, Sep 17, 2008 at 6:52 PM, AJ Mercer wrote: I used this jQuery plugin http://www.phpletter.com/Demo/AjaxFileUpload-Demo/ On Thu, Sep 18, 2008 at 5:02 AM, Brent Nicholas [EMAIL PROTECTED]wrote: Hi all, So I did some googling and searched through the threads here as well. I'm not finding what I need to know. What I'm trying to do: Upload a file to the server via ajax and an iFrame using the tool from: ( http://www.webtoolkit.info/ajax-file-upload.html) I've got the code in a test file, and can get the form var in the receiving (cfm) page to output the file var (it results in a path to the file I choose) but it won't upload. Any ideas? Anyone using this and getting it to work? I've zipped my files and posted them here ( http://www.cflhd.gov/cffileajax.zip) for you to look at. The code from the AIM toolkit is unchanged except the form tag, I played around with that a bit. CHANGES: added enctype - none prior renamed the file input from 'form[file]' to FILE_LOC changed action to cffile.cfm Really I just need to know what the CFILE tag is expecting. I've used it no problem in the past, but I think I'm not quite understanding something here. (Oh, I know there are sofware packages I can buy and flash solutions.. I don't want either. This is govt...) Thanks for your time and effort. Brent ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Nested sets under load
@Brad: thanks for the advice. Throws my plans into a spin, but not
as much as it might have it if the whole shebang gor fubared. (I
didnt know 'fubar' was a verb!).
@Mark: It's MSSql 2005. Thanks for the tip Mark, I'll have a look at that.
What is going to happen is event type {a} happens (lets say it's a
sale). That triggers a default action plan of umpteen things that
have to follow based on that event, documents that have to be filed,
people notified, approvals gained etc, then the the default plan has
to be modified to allow for the specifics of this particular
transaction.
So the event has to trigger the generation of a whole heirarchy of
maybe up to 50 things that have to happen, some of which rely on
previous things being done
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/mont
On Thu, Sep 18, 2008 at 4:01 PM, Mark Mandel [EMAIL PROTECTED] wrote:
What version mssql?
I though 2005 had native support for hierarchical data sets? Much like Oracle.
Mark
On Thu, Sep 18, 2008 at 3:00 PM, Brad Wood [EMAIL PROTECTED] wrote:
My advice is stay away.
Nested sets (left right node) are great for calculating ancestor and
descendant nodes, but they are a brittle data structure meaning if some math
goes wrong and the wrong nodes get pointed at the wrong parent you can get
fubared. (or if a developer tries to go in and fix the nesting by hand)
If your data is changing on a regular basis, updates are going to be Hades.
You will get locks happening all over the table any time you add a new node
because of the ripple affect. Also, the logic to copy and paste a node with
its children elsewhere in the tree can be enough to make you want to shoot
yourself.
Truthfully, I would stick with an adjacency list (parent_id). You can
update the table often and not bother the other records. It is harder to
screw up the data. Moving subtrees around is as simple as updating the top
node of the subtree to have a new parent. The only real downside is if you
find yourself needing to calculate descendant and ancestor nodes.
That being said, there are ways to mitigate the short-comings of both
systems but I don't care for them much because they usually require keeping
de-normalized data updated.
~Brad
- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, September 17, 2008 11:30 PM
Subject: Nested sets under load
I'm designing an application that will require a whole series of
heirarchies - its an action plan where the plans can be quite complex.
The idea is a business event happens (a sale or a project is started
) and that triggers a whole set of events that must follow.
I'm thinking of using nested sets to lay out the heirarchies of
events, because they are so flexible adn its so easy to move things
about with them. But i'm a bit worried about how it might perform
under load.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312743
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Nested sets under load
I've never had performance issues with nested sets, though I've not used them in an app with super-heavy updates like you describe. Update performance is bound by the number of nodes in the tree, of course, so if you have 400 sites with 100 trees each, but each tree is only 50 nodes, it's the 50 that matters, not the 40,000. I don't know what your estimated tree size is, but that'd be the question to ask, rather than the horizontal scaling. It would be easy to do some load testing to see what the results would be with different tree sizes. Though if you care about the performance of the event responses, the bennies of nested sets on the front end might be worth a a little lag on the back end. Totally app/customer specific, of course. And make sure you have fast disks. DB IO has been the limiting factor (not RAM or CPU) on the last couple apps I've worked on, and optimizing that is a bitch. Don't know if that helps, but I wouldn't rule our nested sets without some good numbers. I've found MSSQL to be lickety-split, in general. Though now that I'm thinking about it, you might run some load tests with adjacency lists for storage (fast update) and recursive CTEs for recall. I haven't done recursion that way a whole lot, but the few times I've used it, I've been quite pleased with performance, even with fairly large, deep trees. cheers, barneys --- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com On Sep 17, 2008, at 9:30 PM, Mike Kear [EMAIL PROTECTED] wrote: I'm designing an application that will require a whole series of heirarchies - its an action plan where the plans can be quite complex. The idea is a business event happens (a sale or a project is started ) and that triggers a whole set of events that must follow. I'm thinking of using nested sets to lay out the heirarchies of events, because they are so flexible adn its so easy to move things about with them. But i'm a bit worried about how it might perform under load. I've used nested sets for ages in my CMS and had no problems at all. But you dont make hundreds of updates a day to a CMS node structure. Has anyone used an application using nested sets where there are lots of updates a day? Did it perform ok? My environment is Windows2003, CF7, MSSQLServer.We are provisioned ok for RAM and processor capacity, but dont want to clog it with too much activity from any one application. There are 400+ offices using this site - it's an extranet app. Can anyone give me any experience with nested sets and coldfusion/MSSQLServer with volumes of updates like that? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun issues on Vista 64 bit?
Short of reinstalling CF (which seems like a good idea at this point) I'd suggest perhaps looking at your JRE version and reinstalling/upgrading the JRE version and see if that fixes the obviously borked jdbc driver for mssql. If you really want to get to the bottom of this and figure out the root cause instead of just reinstalling and hoping it solves it, you might try creating a java app outside of CF using JRun and see if you can connect with that and you could also try running CF atop another J2EE server like JBoss to see if JRun is the culprit. Personally, I'd just try reinstalling to see if it fixes the issue. Judah On Wed, Sep 17, 2008 at 5:52 PM, Jeff Chastain [EMAIL PROTECTED]wrote: In addition, I tried creating a MSSQL datasource, connecting to another server I have running MSSQL 2005 and JRun crashed trying to setup that datasource as well, so it is something local to the JRun/CF install and its connection ability with MSSQL. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFILE and Ajax file uploads
I should note that the flash multi-file upload stuff doesn't look like it will work with flash player 10, IIRC. The real solution is to pressure the browsers, as came up in Rick's thread. -- The recent past always presents itself as if destroyed by catastrophes. Theodor Adorno On Wed, Sep 17, 2008 at 11:04 PM, denstar wrote: Dojo has a /pimp/ file upload deal-- it'll even do the flash multi-file one that degrades into a normal AJAX file upload thingie. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Software Engineer
Spam. On Mon, Sep 15, 2008 at 4:09 PM, Phillip Senn [EMAIL PROTECTED] wrote: About me: I'm honest and hard working. Someone who enjoys working a lot. I am looking for telecommute positions. Have you considered hosting web sites on your own? Here's an example of a company charging up to $200 per page: http://www.passoftware.com/design1.html And this site: http://clubsitethatworks.com/ charges $250 for first year. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:4003 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
