Re: Make Verity search skip folders
I'm currently hosting with Hostmysite. Since it's shared hosting they say there's no way to get into the settings to use the exclude on certain folders. They've created the collection and said I'd need to use cfindex to do what I needed and they could turn off the recursive feature. I'm guessing the best way is to initially leave it as recursive to grab everything and then turn off recursive and use cfindex to remove the _admin, _images or whatever other folders I want removed. Am I thinking along the right lines? Also, can someone point me to a good source for having that same collection hit a certain SQL table (some fields). I have all 3 of the new CF8 books and I don't find it. I could just be missing it though. Hi Jason - I'm having this same issue and thought that I did have it under control. Can you provide me with an example of what you implemented for Verity to exclude certain directories? Thanks, Adam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DYnamic survey design
Your query is the unchanged. Instead of running the insert query, just
output the query to the screen so you can see what is going on.
On a different not, I've also seen your last few questions to the list and
don't take this any other way than helpful, but you should really invest in
a good CF book.
The latest CF Web Application Construction Kit (CFWACK) is a good start for
any CF beginner
.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
I rewrote the query but it does not seems to be working properly can anyone
take a look at this and tell me whaqt is wrong
cfif isDefined(btnOption)
cfloop index=i from=1 to=#ListLen(form.opt)#
cfset variables.this=ListGetAt(form.opt,i)
cfquery name=getOptions2 datasource=cfelsunrise
dbtype=odbc
select id from questionOptions where questionid=#questionID# and
surveyID=#surveyID# and options='#variables.this#'
/cfquery
cfif getOptions2.recordcount eq 0
cfquery name=qryOptionSave2 datasource=cfelsunrise
dbtype=odbc
update questionOptions set
options='#variables.this#' where id=#getOptions2.id#
/cfquery
/cfif
/cfloop
/cfif
I rewrote the query but it kepp updating the only one box . i dynamically
generate textboxes . that why it form.opt
cfif isDefined(btnOption)
cfloop index=i from=1 to=#ListLen(form.opt)#
cfset variables.this=ListGetAt(form.opt,i)
cfquery name=getOptions datasource=cfelsunrise
dbtype=odbc
Select * from questionOptions where id=#optionID#
order by id
/cfquery
cfif getOptions.recordcount eq 0
cfquery name=qryOptionSave
datasource=cfelsunrise dbtype=odbc
SET NOCOUNT ON
insert into questionOptions
values('#variables.this#',#questionID#,#surveyID#)
SET NOCOUNT OFF
/cfquery
cfelse
cfquery name=qryOptionSave2
datasource=cfelsunrise dbtype=odbc
update questionOptions set
options='#variables.this#' where id=#optionID#
/cfquery
/cfif
/cfloop
cflocation
url=addremoveQuestion.cfm?surveyID=#surveyID#optionID=#optionID#
addtoken=no
/cfif
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304228
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Odd Stack track in the runtime logs
I had a 503 error this morning that was out of the ordinary so I have gone through the logs to find the stack traces below. At the time the server had the error, it's a low load point in time and defrag starts at 03:30 before backups at 04:00. Overall, the server has a record of @1hr40mins downtime over 476 days so as you can imagine, it's not an everyday occurrence that I see things like this. CF 8 Std was installed in Sept/Oct 07 and looking through the SVN commit logs, although things some code has changed in the last few days I can't see anything that looks significant or relevant to the error that I'm seeing. It feels like a JVM/CF issue but I'm not sure where to check beyond the runtime logs. There are no logs in the runtime bin folder and the std CF logs show nothing. Server is W2k3 Std with 3Gb RAM. JVM is the Java6 that shipped with CF8. Min JVM heap size is set to 512Mb. Max 1024Mb. Being a production server, I'm waiting for the next allotted maintenance period to update to 8.0.1. If anyone can shed any light on these traces I'd appreciate it very much as Google etc return nada. (Paths have been changed to protect the innocent!) 25/04 03:18:00 error ERROR: unknown command 0 java.io.IOException: ERROR: unknown command 0 at jrun.servlet.jrpp.ProxyEndpoint.parseHeaders(ProxyEndpoint.java:943) at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:297) at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:143) at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:292) at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:410) at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java:252) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76) 25/04 03:18:20 error Error while reading header VARIABLES.OBJECTFACTORY java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read1(BufferedInputStream.java:258) at java.io.BufferedInputStream.read(BufferedInputStream.java:317) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:581) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:573) at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:591) at jrun.servlet.jrpp.ProxyEndpoint.readString(ProxyEndpoint.java:620) at jrun.servlet.jrpp.ProxyEndpoint.getHeader(ProxyEndpoint.java:762) at javax.servlet.http.HttpServletRequestWrapper.getHeader(HttpServletRequestWrapper.java:124) at javax.servlet.http.HttpServletRequestWrapper.getHeader(HttpServletRequestWrapper.java:124) at coldfusion.thread.HttpServletRequestWrapper.getHeader(HttpServletRequestWrapper.java:295) at coldfusion.runtime.CgiScope.resolve(CgiScope.java:216) at coldfusion.runtime.CgiScope.containsName(CgiScope.java:296) at coldfusion.runtime.CgiScope.search(CgiScope.java:329) at coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:684) at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1642) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1601) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1589) at cfbase2ecfc1483368667$funcFIREEVENT.runFunction(X:\mywwwroot\_cfc\net\newmediadev\base.cfc:542) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2460) at cfspider2ecfc443474148$funcINIT.runFunction(X:\mywwwroot\_cfc\net\newmediadev\util\spider.cfc:65) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at
com object memory leak problem
I am having some really odd issues with a com object. Requests to a single method call such as object.setField(city,arguments.city) are leading to variables being created in variables scope of a cfc. For example if I dump the variables scope before and after the method call above, I see that 2 variables are added to variables scope, one named city and another that is named after the actual value of the argument passed. I also noticed years ago, when we were using a custom tag instead of cfc to access this com object, that if I have a url or form variable with the same name as one of the method parameters it would have problems and set values as blank if I'm remembering correctly. Has anyone seen something like this before? I would expect all of these method calls to just pass data by value and run in a separate memory space. To explain my full situation, I am trying to make the com object available in server scope. This will prevent some threading issues to the data files being accessed by the com object when accessed by multiple cf applications. Everything works fine for a while but then ColdFusion as a whole starts producing the error unable to create new native thread null. I am trying to track down more specific info about that error but my first thought was to check for memory leaks leading to the discovery I mentioned above. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: This is what I need at home.
Opps hit the wrong list Looks like your computer is due for an upgrade ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
Where would I find info on how to use a thread like that? I don't have a clue... the cf docs? Know of a blog about it? The cfdocs should pretty much cover it, you're just throwing a cfthread tag with action=run around the code that does the re-cache. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
So, would this be accurate? cfthread action=run name=update_query cfquery... My huge union all query... /cfquery /cfthread Is that all there is to it? And this creates a running of the query which doesn't involve the browser? Is that what this means (from the cfdocs): run: Creates a thread and starts it processing. Code in the cfthread tag body runs simultaneously and independently of page-level code and code in other cfthread tags. Rick -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 10:32 AM To: CF-Talk Subject: Re: Need some advice on speeding up query... Where would I find info on how to use a thread like that? I don't have a clue... the cf docs? Know of a blog about it? The cfdocs should pretty much cover it, you're just throwing a cfthread tag with action=run around the code that does the re-cache. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DYnamic survey design
First, it does not seem to be working properly is not a useful description
of a problem. WHAT is it doing that makes you think it is not working
properly. You must explain yourself. I have sent over the link to the Smart
Questions page to you on many occasions, but clearly you still have never
read it. http://catb.org/~esr/faqs/smart-questions.html
Second, why aren't you using a list loop to loop over the list?
Third, the cfif is only going to do anything if the recordcount is 0, which
means the second query will never work.
Fourth, you ignored Bobby's advice to actually read a basic ColdFusion book.
Can I turn this into a plea? Can you please, please read a basic ColdFusion
book and a basic SQL book? Why won't you do this?
On Fri, Apr 25, 2008 at 9:17 AM, erik tom [EMAIL PROTECTED] wrote:
Your query is the unchanged. Instead of running the insert query, just
output the query to the screen so you can see what is going on.
On a different not, I've also seen your last few questions to the list and
don't take this any other way than helpful, but you should really invest
in
a good CF book.
The latest CF Web Application Construction Kit (CFWACK) is a good start
for
any CF beginner
.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
I rewrote the query but it does not seems to be working properly can anyone
take a look at this and tell me whaqt is wrong
cfif isDefined(btnOption)
cfloop index=i from=1 to=#ListLen(form.opt)#
cfset variables.this=ListGetAt(form.opt,i)
cfquery name=getOptions2
datasource=cfelsunrise dbtype=odbc
select id from questionOptions where questionid=#questionID# and
surveyID=#surveyID# and options='#variables.this#'
/cfquery
cfif getOptions2.recordcount eq 0
cfquery name=qryOptionSave2
datasource=cfelsunrise dbtype=odbc
update questionOptions set
options='#variables.this#' where id=#getOptions2.id#
/cfquery
/cfif
/cfloop
/cfif
I rewrote the query but it kepp updating the only one box . i dynamically
generate textboxes . that why it form.opt
cfif isDefined(btnOption)
cfloop index=i from=1 to=#ListLen(form.opt)#
cfset variables.this=ListGetAt(form.opt,i)
cfquery name=getOptions datasource=cfelsunrise
dbtype=odbc
Select * from questionOptions where id=#optionID#
order by id
/cfquery
cfif getOptions.recordcount eq 0
cfquery name=qryOptionSave
datasource=cfelsunrise dbtype=odbc
SET NOCOUNT ON
insert into questionOptions
values('#variables.this#',#questionID#,#surveyID#)
SET NOCOUNT OFF
/cfquery
cfelse
cfquery name=qryOptionSave2
datasource=cfelsunrise dbtype=odbc
update questionOptions set
options='#variables.this#' where id=#optionID#
/cfquery
/cfif
/cfloop
cflocation
url=addremoveQuestion.cfm?surveyID=#surveyID#optionID=#optionID#
addtoken=no
/cfif
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304235
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion query question
I have problem updating the DB table. I have 3 text boxes which has specific id. if the value of that boxes changed i wanto compare to DB and update the option for that id and only for that id . Instead it updates for all ids cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop !--- cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no--- /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFHTTPPARAM issue
I'm working with a payment gateway which requires referer authentication. I'm trying to make the call using CFHTTP and I'm using CFHTTPPARAM to spoof the referer. This is the code: cfhttpparam type=cgi name=REFERER value=https://bryanlghsystem.cfwebtools.com/jake.cfm; I've also tried this: cfhttpparam type=cgi name=HTTP_REFERER value=https://bryanlghsystem.cfwebtools.com/jake.cfm; Technically the HTTP_ is not required from what I've read but that's not my issue. When testing this on another page and dumping out the CGI scope, the refer is set to this: https%3A%2F%2Fbryanlghsystem%2Ecfwebtools%2Ecom%2Fjake%2Ecfm It seems like I am almost there but I'm running into a url encoding issue. Does anyone know how I can achieve the result of an http_referer variable set to this: https://bryanlghsystem.cfwebtools.com/jake.cfm Any help is appreciated. Thanks! -- Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion query question
Erik, This is pretty difficult to troubleshoot without looking at the data. I suspect it is your loop and initial query and not your insert code. -mk Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 11:37 AM To: CF-Talk Subject: ColdFusion query question I have problem updating the DB table. I have 3 text boxes which has specific id. if the value of that boxes changed i wanto compare to DB and update the option for that id and only for that id . Instead it updates for all ids cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop !--- cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no--- /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FIXED: CFHTTPPARAM issue
The resolution was simple as it almost always is. Add the attribute encoded=no to the cfhttpparam tag in question. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 Jake Churchill wrote: I'm working with a payment gateway which requires referer authentication. I'm trying to make the call using CFHTTP and I'm using CFHTTPPARAM to spoof the referer. This is the code: cfhttpparam type=cgi name=REFERER value=https://bryanlghsystem.cfwebtools.com/jake.cfm; I've also tried this: cfhttpparam type=cgi name=HTTP_REFERER value=https://bryanlghsystem.cfwebtools.com/jake.cfm; Technically the HTTP_ is not required from what I've read but that's not my issue. When testing this on another page and dumping out the CGI scope, the refer is set to this: https%3A%2F%2Fbryanlghsystem%2Ecfwebtools%2Ecom%2Fjake%2Ecfm It seems like I am almost there but I'm running into a url encoding issue. Does anyone know how I can achieve the result of an http_referer variable set to this: https://bryanlghsystem.cfwebtools.com/jake.cfm Any help is appreciated. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion query question
Did you read my response to this same question in the other thread before you decided to post it yet again as a duplicate thread? On Fri, Apr 25, 2008 at 12:37 PM, erik tom [EMAIL PROTECTED] wrote: I have problem updating the DB table. I have 3 text boxes which has specific id. if the value of that boxes changed i wanto compare to DB and update the option for that id and only for that id . Instead it updates for all ids cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop !--- cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no--- /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion query question
The data is the follow : id idoptionsquestionID SurveyID 160test 82 1 161test2 82 1 162test3 82 1 Erik, This is pretty difficult to troubleshoot without looking at the data. I suspect it is your loop and initial query and not your insert code. -mk Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com I have problem updating the DB table. I have 3 text boxes which has specific id. if the value of that boxes changed i wanto compare to DB and update the option for that id and only for that id . Instead it updates for all ids cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop !--- cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no--- /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DYnamic survey design
The updated query is here. Its updates all fields rather than only modified fields cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no /cfif First, it does not seem to be working properly is not a useful description of a problem. WHAT is it doing that makes you think it is not working properly. You must explain yourself. I have sent over the link to the Smart Questions page to you on many occasions, but clearly you still have never read it. http://catb.org/~esr/faqs/smart-questions.html Second, why aren't you using a list loop to loop over the list? Third, the cfif is only going to do anything if the recordcount is 0, which means the second query will never work. Fourth, you ignored Bobby's advice to actually read a basic ColdFusion book. Can I turn this into a plea? Can you please, please read a basic ColdFusion book and a basic SQL book? Why won't you do this? On Fri, Apr 25, 2008 at 9:17 AM, erik tom [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion query question
Sorry about that I have updated version of the code. What it does is updating all records rathere than updating only changed records. cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no /cfif Did you read my response to this same question in the other thread before you decided to post it yet again as a duplicate thread? On Fri, Apr 25, 2008 at 12:37 PM, erik tom [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DYnamic survey design
Since I have no idea what form.opt contains, or what is in the getOptions query, or what is in getOptions2, it's impossible to help you. Honestly this is so convoluted and has such confusing naming conventions I can't even GUESS at what this is supposed to do. I mean, what kind of names are opt, i, this, and getOptions2? Code is supposed to be self-documenting, and one of the ways it does that is by using meaningful variable names. I really am trying to help you here Erik. You're a very interesting case. I mean, do you have a specific reason for refusing to actually read through a CF book or a SQL book? You do realize that a huge number of the problems you post about would be solved if you would just do that, right? And I guess I'm a glutton for punishment because I keep responding to you to try and nudge you in the right direction. OK, clearly explain to me what you want this code to do. What are you starting with, and what do you want the end result to be? On Fri, Apr 25, 2008 at 1:36 PM, erik tom [EMAIL PROTECTED] wrote: The updated query is here. Its updates all fields rather than only modified fields cfif isDefined(btnOption) cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfloop query=getOptions cfset option2=#getOptions.id# cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no /cfif First, it does not seem to be working properly is not a useful description of a problem. WHAT is it doing that makes you think it is not working properly. You must explain yourself. I have sent over the link to the Smart Questions page to you on many occasions, but clearly you still have never read it. http://catb.org/~esr/faqs/smart-questions.htmlhttp://catb.org/%7Eesr/faqs/smart-questions.html Second, why aren't you using a list loop to loop over the list? Third, the cfif is only going to do anything if the recordcount is 0, which means the second query will never work. Fourth, you ignored Bobby's advice to actually read a basic ColdFusion book. Can I turn this into a plea? Can you please, please read a basic ColdFusion book and a basic SQL book? Why won't you do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
Is that all there is to it? And this creates a running of the query which doesn't involve the browser? Is that what this means (from the cfdocs): Basically, yes, although I wouldn't really think of it in terms of whether or not the browser is involved, it's more to do with the current running thread on the server that is processing the page...it starts a new thread that will call the query which will run independent of the rest of your code and will not have to wait for it to complete before passing the results back to the browser, it sort of just skips over that and keeps running while the new thread is off running at the same time in parallel. The end result being that the page will not take any longer to run as far as the user is concerned than a typical update would. It's something you want to be judicious about using, as you don't want to overtax a server by constantly creating new threads...but it's a nice solution for a situation like this where you have a small number of users that will be only be updating the tables once in awhile. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problems with cflocation and redirect will never complete.
Hi, I'm having troubles with a cflocation script. First Script finds the ID that it needs and then should perform a cflocation the the script that runs a process that generates an xml file. At that end of that script, it should do another cflocation back to the original script and find the next ID that needs and run through this process all over again. When I try running this in the browser, firefox returns the following. Firefox has detected that the server is redirecting the request for this address in a way that will never complete. I'm trying to select 1 ID at a time, run the process, then cflocation back to the original script and run again until it's finished but it only goes through 5 to 10 id's before I hit this error. Coldfusion Scheduled task didn't complete this as I had hoped either. Any ideas of how I can get around this issue. If you need to generate an XML file for 1000 ID's each may end up being 1 to 2 meg in size. This was the best way I could figure to get around script timeouts. Now I get Firefox has detected that the server is redirecting the request for this address in a way that will never complete. -- Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
And to reiterate, don't stick the entire query in there, it should be out in a CFC, or at the very least, in a separate template so if you make any changes, you aren't updating it in multiple files. You would just use a variable for the cachedwithin time sort of like this: cfparam name=Request.CacheTime default=#CreateTimeSpan(0, 1, 0, 0)# cfquery name=ReallyBigQuery datasource=MyDS cachedwithin=#Request.CacheTime# /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
Oops, sorry about that partial post To reiterate, don't stick the entire query in there, it should be out in a CFC, or at the very least, in a separate template so if you make any changes, you aren't updating it in multiple files. You would just use a variable for the cachedwithin time sort of like this: cfparam name=Request.CacheTime default=#CreateTimeSpan(0, 1, 0, 0)# cfquery name=ReallyBigQuery datasource=MyDS cachedwithin=#Request.CacheTime# SQL Here /cfquery And then in your cfthread you would just have something like this, which calls the above code (you wouldn't necessarily need a request variable, depending on your application): cfthread action=run name=refresh_cached_query cfset Request.CacheTime = 0 cfinclude template = path_to_query_page.cfm /cfthread ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DYnamic survey design
Well I started by creating a survey. Once the servey header is created I am creting a question. the question is created well. So mu next step is create a option(label that will assosiated with the choice). Here is the code !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleAdd/Remove Options/title cfquery name=getOptions datasource=cfelsunrise dbtype=odbc select * from questionOptions where questionid=#questionID# and surveyID=#surveyID# /cfquery /head cfoutput !---cfif getOptions.recordcount gt 0 cfset optionID=#ValueList(getOptions.id)# /cfif--- body cfoutputform action=## method=post id=menu name=menu input type=hidden name=questionID id=questionID value=#questionID# / input type=hidden name=surveyID id=surveyID value=#surveyID# / input type=hidden name=optionID id=optionID value=#getOptions.id# / /cfoutput h1 align=centerAdd/Remove Options/h1 cfloop query=getOptions Option nbsp;#getOptions.currentrow#:nbsp;input type=text name=opt id=opt size=40 value=#getOptions.options#/#getOptions.id#br cfoutput input type=hidden name=optionID id=optionID value=#getOptions.id# //cfoutput /cfloop br / br / input type=submit name=btnOption id=btnOption value=Save Options !---input type=submit name=btnAdd id=btnAdd value=Add Option /--- /form cfdump var=#form# cfif isDefined(btnOption) cfloop query=getOptions cfset option2=#getOptions.id# cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no /cfif /cfoutput /body /html Since I have no idea what form.opt contains, or what is in the getOptions query, or what is in getOptions2, it's impossible to help you. Honestly this is so convoluted and has such confusing naming conventions I can't even GUESS at what this is supposed to do. I mean, what kind of names are opt, i, this, and getOptions2? Code is supposed to be self-documenting, and one of the ways it does that is by using meaningful variable names. I really am trying to help you here Erik. You're a very interesting case. I mean, do you have a specific reason for refusing to actually read through a CF book or a SQL book? You do realize that a huge number of the problems you post about would be solved if you would just do that, right? And I guess I'm a glutton for punishment because I keep responding to you to try and nudge you in the right direction. OK, clearly explain to me what you want this code to do. What are you starting with, and what do you want the end result to be? On Fri, Apr 25, 2008 at 1:36 PM, erik tom [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfmail won't send
Is there anything wrong with this? I know the code is called, but I've not been receiving the emails. cfmail TO = [EMAIL PROTECTED] FROM = [EMAIL PROTECTED] REPLYTO = [EMAIL PROTECTED] SUBJECT = Expenditure Request Received TIMEOUT = 30 SERVER = mail.umd.eduWe will respond within 1 working day. If there is a problem, contact Vanessa Greer at (301) 405-2113. Your request number is #get_id.id#. Thank you. /cfmail thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail won't send
It could be a bunch of stuff: 1. Your mail server may not exist (not likely) 2. You may need to pass credentials to your mail server (legitimate username and password) 3. The timeout may be too short, just get rid of it for testing. Do you have access to the webserver where CF is running? If so, log in and check the mail spool to make sure that the email is being generated and is getting to the spool. The spool is here: CFUSIONFOLDER\Mail\Spool There is also a folder is files undeliverable emails named Undelivr It is possible your CF server isnt sending any email, check and see if there is a bunch built up in there. If you have access to the CF Administrator, log in and enable Mail Logging. Then try it a bunch and check the Mail log files to see if an error is being generated. Those are the typical problems HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfmail won't send
Step 1: Check coldfusionroot\Mail\Spool for *.cfmail files. If there are files in the spool not being processed, then your mail spooler might not be running. Step 2: Check the following log file coldfusionroot\logs\mailsent.log and see if the E-mails are encountering errors or sending successfully. If the logs show the mails are being sent, then it may be a problem with your receiving mail server or client. ~Brad -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 1:48 PM To: CF-Talk Subject: cfmail won't send Is there anything wrong with this? I know the code is called, but I've not been receiving the emails. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
Thanks for all the info, Mary Jo! It's been ( and will be ) a big help! Rick -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:24 PM To: CF-Talk Subject: Re: Need some advice on speeding up query... Oops, sorry about that partial post To reiterate, don't stick the entire query in there, it should be out in a CFC, or at the very least, in a separate template so if you make any changes, you aren't updating it in multiple files. You would just use a variable for the cachedwithin time sort of like this: cfparam name=Request.CacheTime default=#CreateTimeSpan(0, 1, 0, 0)# cfquery name=ReallyBigQuery datasource=MyDS cachedwithin=#Request.CacheTime# SQL Here /cfquery And then in your cfthread you would just have something like this, which calls the above code (you wouldn't necessarily need a request variable, depending on your application): cfthread action=run name=refresh_cached_query cfset Request.CacheTime = 0 cfinclude template = path_to_query_page.cfm /cfthread ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfmail won't send
Are you seeing any messages show up in your mail spool folder? Any error messages in the CF Admin logs? Rick -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:48 PM To: CF-Talk Subject: cfmail won't send Is there anything wrong with this? I know the code is called, but I've not been receiving the emails. cfmail TO = [EMAIL PROTECTED] FROM = [EMAIL PROTECTED] REPLYTO = [EMAIL PROTECTED] SUBJECT = Expenditure Request Received TIMEOUT = 30 SERVER = mail.umd.eduWe will respond within 1 working day. If there is a problem, contact Vanessa Greer at (301) 405-2113. Your request number is #get_id.id#. Thank you. /cfmail thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail won't send
If you have access to CF Admin that try verifying the mail server first. On Fri, Apr 25, 2008 at 3:08 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Are you seeing any messages show up in your mail spool folder? Any error messages in the CF Admin logs? Rick -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:48 PM To: CF-Talk Subject: cfmail won't send Is there anything wrong with this? I know the code is called, but I've not been receiving the emails. cfmail TO = [EMAIL PROTECTED] FROM = [EMAIL PROTECTED] REPLYTO = [EMAIL PROTECTED] SUBJECT = Expenditure Request Received TIMEOUT = 30 SERVER = mail.umd.eduWe will respond within 1 working day. If there is a problem, contact Vanessa Greer at (301) 405-2113. Your request number is #get_id.id#. Thank you. /cfmail thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problems with cflocation and redirect will never complete.
Casey, my suggestion is to change your cflocation with Java redirect routine. Please try this: cfscript getPageContext().getResponse().sendRedirect(local.YourURL); /cfscript Cheers Marco Antonio On Fri, Apr 25, 2008 at 3:17 PM, Casey Dougall [EMAIL PROTECTED] wrote: Hi, I'm having troubles with a cflocation script. First Script finds the ID that it needs and then should perform a cflocation the the script that runs a process that generates an xml file. At that end of that script, it should do another cflocation back to the original script and find the next ID that needs and run through this process all over again. When I try running this in the browser, firefox returns the following. Firefox has detected that the server is redirecting the request for this address in a way that will never complete. I'm trying to select 1 ID at a time, run the process, then cflocation back to the original script and run again until it's finished but it only goes through 5 to 10 id's before I hit this error. Coldfusion Scheduled task didn't complete this as I had hoped either. Any ideas of how I can get around this issue. If you need to generate an XML file for 1000 ID's each may end up being 1 to 2 meg in size. This was the best way I could figure to get around script timeouts. Now I get Firefox has detected that the server is redirecting the request for this address in a way that will never complete. -- Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DYnamic survey design
OK first, this is just a perfect example of why mixing presentation code and processing logic together in one file is a horrible idea. Again, just to keep driving this point, any basic CF book will explain to you why this is terrible and how to separate things. So let's break this down in terms of what the code you're showing actually does: If a form button is present... Loop over the options query and for each row... Get the id for that option... Then loop over the list of options passed in the form and for each list item... Query the database looking for an option that is already there... If there are no options already there with the matching option value... Update the option. I would start by dumping the query results and looking at the debug data to confirm that the SQL that is running is actually the SQL you think is running. I suspect that the problem is here: cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery What is the query even for? If this returns no records then the update will always happen. So the problem is probably here. It's quite disturbing that after looking at this for 15 minutes and having you try to explain it twice I still have almost no idea of what this code is supposed to be doing. On Fri, Apr 25, 2008 at 2:25 PM, erik tom [EMAIL PROTECTED] wrote: Well I started by creating a survey. Once the servey header is created I am creting a question. the question is created well. So mu next step is create a option(label that will assosiated with the choice). Here is the code !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleAdd/Remove Options/title cfquery name=getOptions datasource=cfelsunrise dbtype=odbc select * from questionOptions where questionid=#questionID# and surveyID=#surveyID# /cfquery /head cfoutput !---cfif getOptions.recordcount gt 0 cfset optionID=#ValueList(getOptions.id)# /cfif--- body cfoutputform action=## method=post id=menu name=menu input type=hidden name=questionID id=questionID value=#questionID# / input type=hidden name=surveyID id=surveyID value=#surveyID# / input type=hidden name=optionID id=optionID value=#getOptions.id# / /cfoutput h1 align=centerAdd/Remove Options/h1 cfloop query=getOptions Option nbsp;#getOptions.currentrow#:nbsp;input type=text name=opt id=opt size=40 value=#getOptions.options#/#getOptions.id#br cfoutput input type=hidden name=optionID id=optionID value=#getOptions.id# //cfoutput /cfloop br / br / input type=submit name=btnOption id=btnOption value=Save Options !---input type=submit name=btnAdd id=btnAdd value=Add Option /--- /form cfdump var=#form# cfif isDefined(btnOption) cfloop query=getOptions cfset option2=#getOptions.id# cfloop index=i from=1 to=#ListLen(form.opt)# cfset variables.this=ListGetAt(form.opt,i) cfquery name=getOptions2 datasource=cfelsunrise dbtype=odbc select * from questionOptions where id in (#option2#) and options ='#variables.this#' /cfquery cfif getOptions2.recordcount eq 0 cfquery name=qryOptionSave2 datasource=cfelsunrise dbtype=odbc update questionOptions set options='#variables.this#' where id='#option2#' and surveyID=#surveyID# and questionID=#questionID# /cfquery /cfif /cfloop /cfloop cflocation url=addRemoveQuestion.cfm?surveyID=#surveyID# addtoken=no /cfif /cfoutput /body /html Since I have no idea what form.opt contains, or what is in the getOptions query, or what is in getOptions2, it's impossible to help you. Honestly this is so convoluted and has such confusing naming conventions I can't even GUESS at what this is supposed to do. I mean, what kind of names are opt, i, this, and getOptions2? Code is supposed to be self-documenting, and one of the ways it does that is by using meaningful variable names. I really am trying to help you here Erik. You're a very interesting case. I mean, do you have a specific reason for refusing to actually read through a CF book or a SQL book? You do realize that a huge number of the problems you post about would be solved if you would just do that, right? And I guess I'm a glutton for punishment because I keep responding to you to try and nudge you in the right direction. OK, clearly explain to me what you want this code to do. What are you starting with, and what do you want the end result to be? On Fri, Apr 25, 2008 at 1:36 PM, erik tom [EMAIL PROTECTED] wrote:
Re: problems with cflocation and redirect will never complete.
On Fri, Apr 25, 2008 at 3:47 PM, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: Casey, my suggestion is to change your cflocation with Java redirect routine. Please try this: cfscript getPageContext().getResponse().sendRedirect(local.YourURL); /cfscript Cheers Marco Antonio Still no luck... It runs for about the same amount of time and then thinks it's in an infinite loop and quits. This is also a BlueDragon .Net Server. I haven't had a project on one of those before. Maybe there is another way to get around due to this... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problems with cflocation and redirect will never complete.
Casey Dougall wrote: Any ideas of how I can get around this issue. If you need to generate an XML file for 1000 ID's each may end up being 1 to 2 meg in size. This was the best way I could figure to get around script timeouts. What about resetting the script timeouts to a value large enough to accomplish your task either globally in the administrator or locally with the cfsetting... tag? Now I get Firefox has detected that the server is redirecting the request for this address in a way that will never complete. Well, from Firefox's point of view that is exactly what you are doing. It can't see what the server is doing and understand that it is involved in an iterative loop that will eventually end. It can only see that is is getting the same sequence of 301 redirects over and over. The developers of browsers have intelligently made them so that they do not get trapped in an endless loop like this. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problems with cflocation and redirect will never complete.
On Fri, Apr 25, 2008 at 4:03 PM, Ian Skinner [EMAIL PROTECTED] wrote: What about resetting the script timeouts to a value large enough to accomplish your task either globally in the administrator or locally with the cfsetting... tag? Yeah, that may be the only way to get this threw the cracks. Well, from Firefox's point of view that is exactly what you are doing. It can't see what the server is doing and understand that it is involved in an iterative loop that will eventually end. It can only see that is is getting the same sequence of 301 redirects over and over. The developers of browsers have intelligently made them so that they do not get trapped in an endless loop like this. Right, so i tried appending a URL variable to the end that changes everytime the script runs, but that didn't work either. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problems with cflocation and redirect will never complete.
Casey Dougall wrote: Right, so i tried appending a URL variable to the end that changes everytime the script runs, but that didn't work either. Well a different query, AKA url, variable does not change the resource redirected to. If this where to work you would somehow have to change the base path somehow. Probably using some type of Search Safe URL scheme. But my gut tells me that tricking the browser to make 1000 requests|redirects is the best way to resolve this requirement. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problems with cflocation and redirect will never complete.
Cfhttp to the rescue ;) cfloop query=theIds cfhttp url=addressthatProcessesTheId method=get cfhttpparam type=url name=theId value=#theId# / /cfhttp /cfloop HTH Dominic On 25/04/2008, Casey Dougall [EMAIL PROTECTED] wrote: On Fri, Apr 25, 2008 at 4:03 PM, Ian Skinner [EMAIL PROTECTED] wrote: What about resetting the script timeouts to a value large enough to accomplish your task either globally in the administrator or locally with the cfsetting... tag? Yeah, that may be the only way to get this threw the cracks. Well, from Firefox's point of view that is exactly what you are doing. It can't see what the server is doing and understand that it is involved in an iterative loop that will eventually end. It can only see that is is getting the same sequence of 301 redirects over and over. The developers of browsers have intelligently made them so that they do not get trapped in an endless loop like this. Right, so i tried appending a URL variable to the end that changes everytime the script runs, but that didn't work either. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problems with cflocation and redirect will never complete.
Ian Skinner wrote: But my gut tells me that tricking the browser to make 1000 requests|redirects is the best way to resolve this requirement. is **NOT** the best way to resolve this ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Printing Database Structure
I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problems with cflocation and redirect will never complete.
@ Casey You said that it was a problem with Time outs? You can override the servers default time out using cfsetting. ex: cfsetting requestTimeOut = 5000 If that doesn't solve the problem Dom's idea looks good. @Dom Stop making sense. ;) HTH, G On Fri, Apr 25, 2008 at 4:32 PM, Dominic Watson [EMAIL PROTECTED] wrote: Cfhttp to the rescue ;) cfloop query=theIds cfhttp url=addressthatProcessesTheId method=get cfhttpparam type=url name=theId value=#theId# / /cfhttp /cfloop HTH Dominic On 25/04/2008, Casey Dougall [EMAIL PROTECTED] wrote: On Fri, Apr 25, 2008 at 4:03 PM, Ian Skinner [EMAIL PROTECTED] wrote: What about resetting the script timeouts to a value large enough to accomplish your task either globally in the administrator or locally with the cfsetting... tag? Yeah, that may be the only way to get this threw the cracks. Well, from Firefox's point of view that is exactly what you are doing. It can't see what the server is doing and understand that it is involved in an iterative loop that will eventually end. It can only see that is is getting the same sequence of 301 redirects over and over. The developers of browsers have intelligently made them so that they do not get trapped in an endless loop like this. Right, so i tried appending a URL variable to the end that changes everytime the script runs, but that didn't work either. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problems with cflocation and redirect will never complete.
@Dom Stop making sense. ;) Once it was better than chocolate and then I thought no I want to select more than one at a time how can I do that please :p How's that? Back to sense and using cfhttp, you will more than likely still need to set an extended timeout to stop the request timing out (@Gerald, I think the original problem was that the original request was maxing out memory because of huge amounts of Xml strings): cfsetting requesttimeout=#appropriateTimeout# / cfloop query=theIds cfhttp url=addressthatProcessesTheId method=get cfhttpparam type=url name=theId value=#theId# / /cfhttp /cfloop Anyways, Domininc -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Printing Database Structure
Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Could creating a diagram with all the tables on it help here? This can show all tables, column data and relationships. Diagrams can be printed.. Dominic On 25/04/2008, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Printing Database Structure
Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
Diagrams can do this, but I don't have the time to sit down and arrange all the little boxes so that they fit on pages. I was able, some time ago, to make a list of my tables with their columns and the column's data types through a query (I think). Afterwards I was able to copy and paste it into excel for printing. Again, I THINK I did it this way, but who knows, I've slept since then. ~Steve http://lanctr.com/ -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:02 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Could creating a diagram with all the tables on it help here? This can show all tables, column data and relationships. Diagrams can be printed.. Dominic On 25/04/2008, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
AHA! This looks familiar... I'll give it a whirl. Thanks! ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Printing Database Structure
Yep, that did the trick. You rock! This time I saved the query ;) ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
If you're on CF8, cfdbinfo is all you need. -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:16 PM To: CF-Talk Subject: RE: OT: Printing Database Structure AHA! This looks familiar... I'll give it a whirl. Thanks! ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
Cool. Anyway I'll suggest you to know about DataMgr. DataMgr do this job so easy. http://datamgr.riaforge.org/ With getDatabaseTables method and looping over calling getDBTableStruct method. Cheers Marco Antonio On Fri, Apr 25, 2008 at 6:19 PM, Steve Good [EMAIL PROTECTED] wrote: Yep, that did the trick. You rock! This time I saved the query ;) ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem compiling mxml with Flex-SDK-3 and CF
I'm trying to use the Flex 3 SDK to compile a swf file from an mxml text file
using ColdFusion.
I am getting this error:
java.lang.NoSuchMethodError:
flex2.compiler.API.usePathResolver(Lflex2/compiler/common/SinglePathResolver;)V
at flex2.tools.oem.internal.OEMUtil.init(OEMUtil.java:88) at
flex2.tools.oem.internal.OEMUtil.getApplicationConfiguration(OEMUtil.java:226)
at...
Here's the code I'm trying:
cfscript
//set mxml file name
input = expandPath('Test.mxml');
output = expandPath('Test.swf');
//read file
mxmlFile = createObject(Java,java.io.File).Init(input);
//create flex sdk
application =
createObject(Java,flex2.tools.oem.Application).init(mxmlFile);
//create output swf file
swf = createObject(Java,java.io.File).Init(output);
//set output swf
application.setOutput(swf);
//build it
result = application.build(true);
/cfscript
cfdump var=#result# /
Above code adapted from first example here
livedocs.adobe.com/flex/3/compilerAPI_flex3.pdf
I'm on CF8.0.1, the Flex 3 SDK has been added to the classpath, LiveCycle Data
Services ES was also installed.
Any ideas? thanks
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304274
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Printing Database Structure
Cool, thanks for the tip, I'll look into it. ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:30 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Cool. Anyway I'll suggest you to know about DataMgr. DataMgr do this job so easy. http://datamgr.riaforge.org/ With getDatabaseTables method and looping over calling getDBTableStruct method. Cheers Marco Antonio On Fri, Apr 25, 2008 at 6:19 PM, Steve Good [EMAIL PROTECTED] wrote: Yep, that did the trick. You rock! This time I saved the query ;) ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail won't send
1. No, I sent mail from another application 2. No. 3. okay, will give it a shot. I don't have access to the cfserver. It's shared hosting at the U. Since the other application worked, I'll start over and use it's cfmail block to try again. And it did help. It made me check the other application to assure that email was fine. I'll transfer info over one piece at a time to see where I goofed. thanks. It could be a bunch of stuff: 1. Your mail server may not exist (not likely) 2. You may need to pass credentials to your mail server (legitimate username and password) 3. The timeout may be too short, just get rid of it for testing. Do you have access to the webserver where CF is running? If so, log in and check the mail spool to make sure that the email is being generated and is getting to the spool. The spool is here: CFUSIONFOLDER\Mail\Spool There is also a folder is files undeliverable emails named Undelivr It is possible your CF server isnt sending any email, check and see if there is a bunch built up in there. If you have access to the CF Administrator, log in and enable Mail Logging. Then try it a bunch and check the Mail log files to see if an error is being generated. Those are the typical problems HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304276 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
Any way to get number of rows in each table? That would be REALLY useful -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
Cfdbinfo doesnt supply that You can sniff out the ID and so something like this: Select Count(#ID#) as NumberofRecords From #TABLE_NAME# Or some such. On Fri, Apr 25, 2008 at 6:11 PM, Colman, Richard [EMAIL PROTECTED] wrote: Any way to get number of rows in each table? That would be REALLY useful -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Printing Database Structure
SELECT so.name as tableName ,MAX(SIX.rows) as rowCounter FROM sysobjects SO INNER JOIN sysindexes SIX ON SIX.id = OBJECT_ID(SO.name) WHERE SO.xtype = 'U' GROUP BY SO.name ORDER BY 2 DESC On Fri, Apr 25, 2008 at 7:11 PM, Colman, Richard [EMAIL PROTECTED] wrote: Any way to get number of rows in each table? That would be REALLY useful -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problems with cflocation and redirect will never complete.
I'll try this some more in the morning... Thanks Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute - at my wits end!
Do you have quoted values in your arguments? CFEXECUTE won't handle those correctly. However, you can pass an array of arguments (instead of a string), and those should work. Yes! I will check into the array thing. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: problems with cflocation and redirect will never complete.
I'm having troubles with a cflocation script. First Script finds the ID that it needs and then should perform a cflocation the the script that runs a process that generates an xml file. At that end of that script, it should do another cflocation back to the original script and find the next ID that needs and run through this process all over again. When I try running this in the browser, firefox returns the following. Firefox has detected that the server is redirecting the request for this address in a way that will never complete. I'm trying to select 1 ID at a time, run the process, then cflocation back to the original script and run again until it's finished but it only goes through 5 to 10 id's before I hit this error. Coldfusion Scheduled task didn't complete this as I had hoped either. Any ideas of how I can get around this issue. If you need to generate an XML file for 1000 ID's each may end up being 1 to 2 meg in size. This was the best way I could figure to get around script timeouts. Now I get Firefox has detected that the server is redirecting the request for this address in a way that will never complete. Why not do this asynchronously? Redirecting the browser a thousand times strikes me as a bad idea even if it did work. But if you do need a synchronous solution in CF, why not use a META refresh? meta http-equiv=refresh content=5;url=http://yourserver.com/yourfile?id=#whatever#/ Processing #whatever# of #total# ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: com object memory leak problem
I am having some really odd issues with a com object. Requests to a single method call such as object.setField(city,arguments.city) are leading to variables being created in variables scope of a cfc. For example if I dump the variables scope before and after the method call above, I see that 2 variables are added to variables scope, one named city and another that is named after the actual value of the argument passed. I think you'd need to show the relevant CFC code here. I also noticed years ago, when we were using a custom tag instead of cfc to access this com object, that if I have a url or form variable with the same name as one of the method parameters it would have problems and set values as blank if I'm remembering correctly. Has anyone seen something like this before? I would expect all of these method calls to just pass data by value and run in a separate memory space. Not all data is passed by value. Structures and queries, for example, are passed by reference. It doesn't sound like you're passing one of those, but I can't be sure, obviously. To explain my full situation, I am trying to make the com object available in server scope. This will prevent some threading issues to the data files being accessed by the com object when accessed by multiple cf applications. Everything works fine for a while but then ColdFusion as a whole starts producing the error unable to create new native thread null. I am trying to track down more specific info about that error but my first thought was to check for memory leaks leading to the discovery I mentioned above. Well, CF doesn't handle COM objects especially well, in my opinion. If you're using a single COM object a lot, you might consider replacing it with an analogous object in Java or CF. The native thread message doesn't sound like a memory leak problem to me, but I wouldn't be at all surprised if you do encounter memory leaks in CF when using COM. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute - at my wits end!
Okay, I have taken both of your suggestions. I changed coldfusion to run under my user account. That caused it to be able to launch the sox application successfully, SOMETIMES. I did the array of arguments. That didn't affect anything, but I left it that way. So now my problem is that when it works, sox stays in memory. I even tried going with a batch file, and I get the same result. It is like sox isn't closing and leaving memory like it should be, but if I run it directly from the command line, I don't have that problem. Please help with any other ideas. Thanks, Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
ER/Studio auto-arranges tables quite well. But, you pay a pretty price for it. m!ke -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:15 PM To: CF-Talk Subject: RE: OT: Printing Database Structure Diagrams can do this, but I don't have the time to sit down and arrange all the little boxes so that they fit on pages. I was able, some time ago, to make a list of my tables with their columns and the column's data types through a query (I think). Afterwards I was able to copy and paste it into excel for printing. Again, I THINK I did it this way, but who knows, I've slept since then. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute - at my wits end!
It is like sox isn't closing and leaving memory like it should be, but if I run it directly from the command line, I don't have that problem. Try Ben Forta's tip of adding /c as an argument. This tells the command interpreter to run and terminate upon completion. I had a similar problem with ffmpeg and using \c solved it for me. http://www.forta.com/blog/index.cfm/2006/7/31/Using-CFEXECUTE-To-Execute-Command-Line-Utilities ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Make Verity search skip folders
I'm currently hosting with Hostmysite. Since it's shared hosting they say there's no way to get into the settings to use the exclude on certain folders. They've created the collection and said I'd need to use cfindex to do what I needed and they could turn off the recursive feature. I'm guessing the best way is to initially leave it as recursive to grab everything and then turn off recursive and use cfindex to remove the _admin, _images or whatever other folders I want removed. Am I thinking along the right lines? Also, can someone point me to a good source for having that same collection hit a certain SQL table (some fields). I have all 3 of the new CF8 books and I don't find it. I could just be missing it though. Hi Jason - I'm having this same issue and thought that I did have it under control. Can you provide me with an example of what you implemented for Verity to exclude certain directories? Thanks, Adam Adam, I'm still in the ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Make Verity search skip folders
I'm currently hosting with Hostmysite. Since it's shared hosting they say there's no way to get into the settings to use the exclude on certain folders. They've created the collection and said I'd need to use cfindex to do what I needed and they could turn off the recursive feature. I'm guessing the best way is to initially leave it as recursive to grab everything and then turn off recursive and use cfindex to remove the _admin, _images or whatever other folders I want removed. Am I thinking along the right lines? Also, can someone point me to a good source for having that same collection hit a certain SQL table (some fields). I have all 3 of the new CF8 books and I don't find it. I could just be missing it though. Hi Jason - I'm having this same issue and thought that I did have it under control. Can you provide me with an example of what you implemented for Verity to exclude certain directories? Thanks, Adam Adam, I haven't exactly implemented it yet, but here's what I've got. You can use the cfindex action delete to get rid of a file, so I'm guessing you can use it to get rid of a folder. cfindex action=delete collection=docs type=file key=c:\mydocs\new.pdf There's also this: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_06.html Once I get it ironed out I'll post the code here. If you get it first feel free to post yours. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: com object memory leak problem
Not all data is passed by value yeah, I meant passed to the com object method by value which is how I understand that data to be passed. You are correct that I'm not passing queries or structs, just strings to com object methods. Well, CF doesn't handle COM objects especially well, in my opinion. You don't say :-) As I mentioned earlier, I noticed some problems a few years. At that time I reduced my code to the most basic possible call to this com object and I nailed down that having url and form variables with the same names as the com object's setField methods caused problems. That just blew my mind. How could the com object and coldfusion variables possibly be colliding in any way. Now I see that multiple dynamically named variables scoped variables are also being created. (by the way, who's smart idea was it to call it variables scope). If you're using a single COM object a lot, you might consider replacing it with an analogous object in Java or CF. I started looking into some other options. The dll was supplied by a vendor for make calls to their software's api and secure database. Not sure if I can rewrite it but a call it in a different way in java would help I'll definitely pursue that. The native thread message doesn't sound like a memory leak problem to me, but I wouldn't be at all surprised if you do encounter memory leaks in CF when using COM. I haven't been able to find much info online about that error message, mainly google just happened to index a couple dozen cf sites with the same error. I'll double check my code to be sure I'm not messing up a lock somewhere which I suspect could lead to threads building up and eventually causing errors. Thanks for the input. I'll post some code next week when I have access to it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recommend a Workflow Engine in CF
Have you found anything in terms of a CF workflow engine? If not I am currently working on an open source workflow engine, I have the core complete and would like to help you out. -chris I'm looking for a state machine workflow engine written in (or easily consumed by) ColdFusion but I can't seem to find anything. Does anyone know of or (better yet) have experience using one? Do you have a web site where I can read about the CF Workflow Engine? I have heard of something in the .Net arena like Windows Workflow Foundation. I would think this is done in similar lines. Just curious. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
