function parameters problem
hi , I'm writing a code to insert some values to my database , and there are 7 of them . but when I run it , CF tells me that the function takes 3 parameters .the code is really simple and I don't get what's wrong . so anyone has any experience with this , I'll be appriciated if you can help. here's my code : cfcomponent cfprocessingdirective pageencoding=utf-8 cfset setEncoding(form,utf-8) cfset setEncoding(url,utf-8) cfcontent type=text/html ; charset=UTF-8 cffunction name=insert access=remote returntype=void cfargument name=username type=string required=true cfargument name=password type=string required=true cfargument name=fname type=string required=true cfargument name=lname type=string required=true cfargument name=ncard type=numeric required=true cfargument name=age type=numeric required=true cfargument name=sex type=string required=true cfquery name=qInsert datasource=Library insert into Users(username,password,fname,lname,nationalCard,age,sex) values(cfqueryparam value=#username# cfsqltype=cf_sql_varchar,cfqueryparam value=#password# cfsqltype=cf_sql_varchar,cfqueryparam value=#fname# cfsqltype=cf_sql_varchar,cfqueryparam value=#lname# cfsqltype=cf_sql_varchar,cfqueryparam value=#ncard# cfsqltype=cf_sql_numeric,cfqueryparam value=#age# cfsqltype=cf_sql_numeric,cfqueryparam value=#sex# cfsqltype=cf_sql_varchar) /cfquery /cffunction cfdump var=#insert(gk,ad,fo,ew,32444,43,male)#/ /cfcontent /cfcomponent ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: function parameters problem
The error not with your arguments. It is on this line: cfdump var=#insert(gk,ad,fo,ew,32444,43,male)#/ The insert function takes only three parameters. insert(substring,string,position) On Tue, Nov 23, 2010 at 12:08 AM, mojtaba tabatabaie mojtaba_tabatab...@yahoo.com wrote: hi , I'm writing a code to insert some values to my database , and there are 7 of them . but when I run it , CF tells me that the function takes 3 parameters .the code is really simple and I don't get what's wrong . so anyone has any experience with this , I'll be appriciated if you can help. here's my code : cfcomponent cfprocessingdirective pageencoding=utf-8 cfset setEncoding(form,utf-8) cfset setEncoding(url,utf-8) cfcontent type=text/html ; charset=UTF-8 cffunction name=insert access=remote returntype=void cfargument name=username type=string required=true cfargument name=password type=string required=true cfargument name=fname type=string required=true cfargument name=lname type=string required=true cfargument name=ncard type=numeric required=true cfargument name=age type=numeric required=true cfargument name=sex type=string required=true cfquery name=qInsert datasource=Library insert into Users(username,password,fname,lname,nationalCard,age,sex) values(cfqueryparam value=#username# cfsqltype=cf_sql_varchar,cfqueryparam value=#password# cfsqltype=cf_sql_varchar,cfqueryparam value=#fname# cfsqltype=cf_sql_varchar,cfqueryparam value=#lname# cfsqltype=cf_sql_varchar,cfqueryparam value=#ncard# cfsqltype=cf_sql_numeric,cfqueryparam value=#age# cfsqltype=cf_sql_numeric,cfqueryparam value=#sex# cfsqltype=cf_sql_varchar) /cfquery /cffunction cfdump var=#insert(gk,ad,fo,ew,32444,43,male)#/ /cfcontent /cfcomponent ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: function parameters problem
In other words, call your own function something other than insert because that's already the name of a CF function. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 23 November 2010 16:49, Maureen mamamaur...@gmail.com wrote: The error not with your arguments. It is on this line: cfdump var=#insert(gk,ad,fo,ew,32444,43,male)#/ The insert function takes only three parameters. insert(substring,string,positio ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFDocument and Images
Hi, Unfortunately this doesn't seem to cure the problem either. Calling iText directly with Image.getInstance() and document.add() doesn't show the problem, but due to the complexity of the reports, it's something I'd rather only do as a 'no other option' scenario. Kind regards Jedi On 22 November 2010 18:35, Jochem van Dieten joch...@gmail.com wrote: On Mon, Nov 22, 2010 at 5:18 PM, JediHomer wrote: I've tried toggleing the localURL with the img src set to ./image1.png and using ExpandPath to get the full path to the file so that the img src is set to the full physical path to the file. I'm on linux, so the path then becomes /home/jedi/blah... but the problem is still the same... Try a file:///home/jedi/... path. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Performance Monitoring
Hi All, Does anyone know if there is any performance issues with enabling performance monitoring settings? This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. Is this setting ok to enable in a production environment? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RSA encryption/decryption coldfusion
Hi guys, Need some help on Asymmetric Encryption in coldfusion webservice first, I need generate rsa public/private key pair. I am using CF8 Enterprise version I download the Bouncy Castle API java cryptography library to do that. My code looks like this [code] !--- Get the Bouncy Castle Asymmetric Key Generator --- cfset kpgo = createObject('java', 'org.bouncycastle.jce.provider.asymmetric.ec.KeyPairGenerator') / !--- Get an instance of the provider for the RSA algorithm. --- cfset kpg = kpgo.getInstance(RSA) / !--- Get an instance of secureRandom, we'll need this to initialize the key generator --- cfset sr = createObject('java', 'java.security.SecureRandom').init() / !--- Initialize the generator by passing in the size of key we want, and a strong pseudo-random number generator (PRNG) --- cfset kpg.initialize(2048, createObject('java', 'java.security.SecureRandom')) / !--- This will create two keys, one public, and one private --- cfset kp = kpg.generateKeyPair() / !--- Get the two keys. --- cfset privateKey = kp.getPrivate() / cfset publicKey = kp.getPublic() / cffunction name=encryptString access=public returntype=Any output= false !--- Take in the string to encrypt and the key to encrypt with --- cfargument name=inputString type=string / cfargument name=key type=any / !--- Create a Java Cipher object and get a mode --- cfset var cipher = createObject('java', 'javax.crypto.Cipher').getInstance(RSA) / !--- The mode tells the Cipher whether is will be encrypting or decrypting --- cfset var encMode = cipher.ENCRYPT_MODE / cfset var encryptedValue = / !--- Return variable --- !--- Initialize the Cipher with the mode and the key --- cfset cipher.init(encMode, key) / !--- Convert the string to bytes --- cfset stringBytes = inputString.getBytes(UTF8) / !--- Perform encryption --- cfset encryptedValue = cipher.doFinal(stringBytes, 0, len(inputString)) / cfreturn encryptedValue / /cffunction [/code] I am actually trying to implement the example from this link http://www.12robots.com/index.cfm/2010/7/19/Using-Asymmetric-Cryptography-in-your-ColdFusion-Application--Security-Series-1610 I need to use this as a webservice My webservice will receive 3 parameters (randomTxt, username, password) and based on that will return the session id along with the public key. can someone direct me to the correct path? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Detect users based on country???
I've ran into this issue before and have found the best solution to detecting a county is by asking the customer for it via a modal window. EXAMPLES http://www.xerox.com/ http://www.edmundoptics.com/ I know some people really like using geo-location, but I've found this method to be not always accurate. I've found in the US is usually more accurate than overseas. -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Monday, November 22, 2010 5:41 PM To: cf-talk Subject: Re: Detect users based on country??? Use a public geo-location service: cfhttp method=get URL=http://ipinfodb.com/ip_query.php?ip=#cgi.REMOTE_ADDR#; result=response / Then use the response XML tree to extract the country or zip: cfset xmmm = xmlparse(response.filecontent) cfset countryname = xmmm.response.countryname.xmltext cfif countryname neq Canada div id=price#price#/div /cfif I wouldn't actually do it in this order because of the lag in http posts. I've had good luck with this method but it isn't perfect because web services can go down and then your checking system breaks. If the location service isn't working, then don't allow anyone to use the module you've built with the integrated geo-location service. Use cookies as you stated to keep from having to do this every time. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RSA encryption/decryption
Hi guys, Need some help on Asymmetric Encryption in coldfusion webservice first, I need generate rsa public/private key pair. I am using CF8 Enterprise version I download the Bouncy Castle API java cryptography library to do that. My code looks like this [code] !--- Get the Bouncy Castle Asymmetric Key Generator --- cfset kpgo = createObject('java', 'org.bouncycastle.jce.provider.asymmetric.ec.KeyPairGenerator') / !--- Get an instance of the provider for the RSA algorithm. --- cfset kpg = kpgo.getInstance(RSA) / !--- Get an instance of secureRandom, we'll need this to initialize the key generator --- cfset sr = createObject('java', 'java.security.SecureRandom').init() / !--- Initialize the generator by passing in the size of key we want, and a strong pseudo-random number generator (PRNG) --- cfset kpg.initialize(2048, createObject('java', 'java.security.SecureRandom')) / !--- This will create two keys, one public, and one private --- cfset kp = kpg.generateKeyPair() / !--- Get the two keys. --- cfset privateKey = kp.getPrivate() / cfset publicKey = kp.getPublic() / cffunction name=encryptString access=public returntype=Any output=false !--- Take in the string to encrypt and the key to encrypt with --- cfargument name=inputString type=string / cfargument name=key type=any / !--- Create a Java Cipher object and get a mode --- cfset var cipher = createObject('java', 'javax.crypto.Cipher').getInstance(RSA) / !--- The mode tells the Cipher whether is will be encrypting or decrypting --- cfset var encMode = cipher.ENCRYPT_MODE / cfset var encryptedValue = / !--- Return variable --- !--- Initialize the Cipher with the mode and the key --- cfset cipher.init(encMode, key) / !--- Convert the string to bytes --- cfset stringBytes = inputString.getBytes(UTF8) / !--- Perform encryption --- cfset encryptedValue = cipher.doFinal(stringBytes, 0, len(inputString)) / cfreturn encryptedValue / /cffunction [/code] I am actually trying to implement the example from this link http://www.12robots.com/index.cfm/2010/7/19/Using-Asymmetric-Cryptography-in-your-ColdFusion-Application--Security-Series-1610 I need to use this as a webservice My webservice will receive 3 parameters (randomTxt, username, password) and based on that will return the session id along with the public key. can someone direct me to the correct path? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Detect users based on country???
Just a word regarding the ipinfodb geolocation service: The URL for the API has changed, and they now require registration for a free application key that must be included in the request. Go to http://www.ipinfodb.com for info. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339455 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) SQL Server Full-Text Search CONTAINS()
SQL Server 2005 For the life of me, I cannot figure out why the hell this... WHERE CONTAINS (EventName,' my NEAR chemical NEAR romance ') ...returns 0 results, yet this... WHERE CONTAINS (EventName,' chemical NEAR romance ') ...returns the correct records. Why does my exclude any records? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339456 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Performance Monitoring
Paul, Which version of ColdFusion is running? Some settings in the CF8 and CF9 Enterprise edition may have some performance hit on high load servers. In rare cases the Server Monitor may have a large impact on performance with certain settings (Enable Memory Tracking) enabled. In general the Debug settings should be disabled on production servers be cause there is a performance hit. It's a small one and may never be noticed on minimally used sites. Highly used high load sites may experience performance issues with the Debug settings enabled. In my experience none of them will completely crash the server. Wil Genovese Owner / Sr Web Application Developer / Systems Administrator Trunkful Technologies, inc. http://www.trunkful.com 729 Dodd Road Saint Paul, MN 55107 | m: 651-894-4238 | wilg...@trunkful.com On Nov 23, 2010, at 10:35 AM, Paul Alkema wrote: Hi All, Does anyone know if there is any performance issues with enabling performance monitoring settings? This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. Is this setting ok to enable in a production environment? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to Display lined up Output
I have a lot of nucleotide data coming back from a query, that looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. I want to display it in lines and columns like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) etc. so users can actually make some sense out of it. I may just put it into a table, or may need to display it within a form in a textarea. Any idea on how to process the text string to get a nice, lined up display? (I am sorry about constantly bothering the list about these kinds of things, but I am not much of a programmer and you guys are really great about helping out.) Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
The display in my original message below is not correct. It looks like one long text string and when displayed, it is a jumble because it just seems to wrap whereever. I want it to look like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. On 11/23/2010 10:18 AM, Rick Colman wrote: I have a lot of nucleotide data coming back from a query, that looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. I want to display it in lines and columns like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) etc. so users can actually make some sense out of it. I may just put it into a table, or may need to display it within a form in a textarea. Any idea on how to process the text string to get a nice, lined up display? (I am sorry about constantly bothering the list about these kinds of things, but I am not much of a programmer and you guys are really great about helping out.) Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
A fast simple way would be to use CFGRID. This gives you a dynamic sortable data grid. OR Put the data in an HTML table. The old fashion way is still preferred for tabular data even though CSS is all the rage these days. Wil Genovese Owner / Sr Web Application Developer / Systems Administrator Trunkful Technologies, inc. http://www.trunkful.com 729 Dodd Road Saint Paul, MN 55107 | m: 651-894-4238 | wilg...@trunkful.com On Nov 23, 2010, at 12:18 PM, Rick Colman wrote: I have a lot of nucleotide data coming back from a query, that looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V GTT) (L CTG) (I ATT) (H CAC) (M ATG) (K AAA) (E GAA) (L CTG) (T ACT) (Q CAG) (H CAC) (N AAC) (V GTT) (T ACC) (P CCA) (E GAA) (D GAT) (M ATG) (S TCT) (A GCT) (F TTC) (R CGT) (S TCT) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. I want to display it in lines and columns like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) etc. so users can actually make some sense out of it. I may just put it into a table, or may need to display it within a form in a textarea. Any idea on how to process the text string to get a nice, lined up display? (I am sorry about constantly bothering the list about these kinds of things, but I am not much of a programmer and you guys are really great about helping out.) Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to Display lined up Output
It looks like one long text string and when displayed, it is a jumble because it just seems to wrap whereever. You could use the pre HTML tag and ensure that the output has the proper spacing and line breaks (ASCII character 10) in the right places and the browser will output it as it appears in the code in a mono-space font such as Times New Roman. You can use CSS to adjust the output as needed. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
If you don't want to use a table or grid, you may also want to try then under utilized pre.../pre tags that gives you old fashioned character alignment, over riding the HTML default to ignore spaces and character in output. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) SQL Server Full-Text Search CONTAINS()
Are there any results that actually have those 3 words near each other ? Russ -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: 23 November 2010 18:01 To: cf-talk Subject: (ot) SQL Server Full-Text Search CONTAINS() SQL Server 2005 For the life of me, I cannot figure out why the hell this... WHERE CONTAINS (EventName,' my NEAR chemical NEAR romance ') ...returns 0 results, yet this... WHERE CONTAINS (EventName,' chemical NEAR romance ') ...returns the correct records. Why does my exclude any records? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339463 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
I may need to copy and paste the text string into another form field. Putting in extra ascii characters (like a line break) may screw things up because of the way the text is later processed. apparently, pre does not work with textarea ... On 11/23/2010 10:29 AM, Justin Scott wrote: It looks like one long text string and when displayed, it is a jumble because it just seems to wrap whereever. You could use the pre HTML tag and ensure that the output has the proper spacing and line breaks (ASCII character 10) in the right places and the browser will output it as it appears in the code in a mono-space font such as Times New Roman. You can use CSS to adjust the output as needed. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
pre by itself works great, but then I get one giant long 500 character text line ... On 11/23/2010 10:29 AM, Ian Skinner wrote: If you don't want to use a table or grid, you may also want to try then under utilizedpre.../pre tags that gives you old fashioned character alignment, over riding the HTML default to ignore spaces and character in output. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Display lined up Output
On 11/23/2010 10:40 AM, Rick Colman wrote: pre by itself works great, but then I get one giant long 500 character text line ... Well, either populate the string with some carriage returns and|or new line characters. OR You can apply CSS to the pre element, it's falls somewhere between a paragraph and a division tag contextually. But it can be given a width and height and all that fun CSS stuff. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Ayep. The band name is My Chemical Romance. I'd say that definitely qualifies as NEAR. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
I'm not overly familiar with NEAR but most of the examples I've seen where NEAR is strung together show it without the quotes. CONTAINS (EventName,'my NEAR chemical NEAR romance') That's probably no help, but I thought I'd share. On Tue, Nov 23, 2010 at 1:00 PM, Matt Quackenbush quackfu...@gmail.comwrote: SQL Server 2005 For the life of me, I cannot figure out why the hell this... WHERE CONTAINS (EventName,' my NEAR chemical NEAR romance ') ...returns 0 results, yet this... WHERE CONTAINS (EventName,' chemical NEAR romance ') ...returns the correct records. Why does my exclude any records? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
@ Michael- Unfortunately, you are correct: That's no help. Same result without the quotes. :-( I know that noise words are ignored, but what appears to be happening is that it is ignoring the entire thing, rather than just the (possible) noise word my. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Performance Monitoring
On Tue, Nov 23, 2010 at 5:35 PM, Paul Alkema wrote: This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. I am not aware of any problems with enabling *that* setting. The Memory Monitoring option in the Server Monitoring is a killer in production though. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Performance Monitoring
Paul, I don't believe it works under multi-server mode -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Tuesday, November 23, 2010 10:36 AM To: cf-talk Subject: Performance Monitoring Hi All, Does anyone know if there is any performance issues with enabling performance monitoring settings? This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. Is this setting ok to enable in a production environment? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) SQL Server Full-Text Search CONTAINS()
Try this: CONTAINS (EventName,' my NEAR chemical AND romance ') I have found that since SQL2000 that the Near operator does weird things. In my search pages we parse the input, remove noise words and if there are more than 2 terms structure the query as term1 NEAR Term2 AND term3 AND term4. Essentially we only use NEAR one in a search and always as the first operator http://support.microsoft.com/kb/888008 http://support.microsoft.com/kb/970909 -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, November 23, 2010 2:07 PM To: cf-talk Subject: Re: (ot) SQL Server Full-Text Search CONTAINS() I'm not overly familiar with NEAR but most of the examples I've seen where NEAR is strung together show it without the quotes. CONTAINS (EventName,'my NEAR chemical NEAR romance') That's probably no help, but I thought I'd share. On Tue, Nov 23, 2010 at 1:00 PM, Matt Quackenbush quackfu...@gmail.comwrote: SQL Server 2005 For the life of me, I cannot figure out why the hell this... WHERE CONTAINS (EventName,' my NEAR chemical NEAR romance ') ...returns 0 results, yet this... WHERE CONTAINS (EventName,' chemical NEAR romance ') ...returns the correct records. Why does my exclude any records? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: function parameters problem
thanks , I renamed the function to insertUsers and it worked fine . thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Performance Monitoring
I'm on ColdFusion 8. :) -Original Message- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Tuesday, November 23, 2010 1:18 PM To: cf-talk Subject: Re: Performance Monitoring Paul, Which version of ColdFusion is running? Some settings in the CF8 and CF9 Enterprise edition may have some performance hit on high load servers. In rare cases the Server Monitor may have a large impact on performance with certain settings (Enable Memory Tracking) enabled. In general the Debug settings should be disabled on production servers be cause there is a performance hit. It's a small one and may never be noticed on minimally used sites. Highly used high load sites may experience performance issues with the Debug settings enabled. In my experience none of them will completely crash the server. Wil Genovese Owner / Sr Web Application Developer / Systems Administrator Trunkful Technologies, inc. http://www.trunkful.com 729 Dodd Road Saint Paul, MN 55107 | m: 651-894-4238 | wilg...@trunkful.com On Nov 23, 2010, at 10:35 AM, Paul Alkema wrote: Hi All, Does anyone know if there is any performance issues with enabling performance monitoring settings? This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. Is this setting ok to enable in a production environment? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Thanks for the tip on using just a single NEAR keyword. In this particular example (my chemical romance), it still results in no records being returned. The only thing I can figure is that 'my' is a noise word, and all searching is ignored once a noise word is hit. For the time being, I've merely added 'my' to the list of words that are parsed out of the search string, and am getting the desired results. Maybe one day I'll actually have time to figure out what and why. :-) Thanks everyone for your help. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Matt, I googled on sql server noise words and found this link: http://arcanecode.com/2008/05/29/creating-and-customizing-noise-words-in-sql-server-2005-full-text-search/ I followed the directions and found the noise lookup file being used by SQL Server 2005 on my computer, and confirmed that my is in the list. If you need my to be included in your searches, you could remove it from your list. However, if you ever migrate SQL to another server, you'll have to remember to update the noise list on that server. HTH, Carl Thanks for the tip on using just a single NEAR keyword. In this particular example (my chemical romance), it still results in no records being returned. The only thing I can figure is that 'my' is a noise word, and all searching is ignored once a noise word is hit. For the time being, I've merely added 'my' to the list of words that are parsed out of the search string, and am getting the desired results. Maybe one day I'll actually have time to figure out what and why. :-) Thanks everyone for your help. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Carl, Thanks for that link. I appreciate it. :-) I guess I am simply totally misunderstanding noise/stop words in SQL Server. My understanding was that they were ignored in a query. But the behavior I am seeing indicates that the entire search string is ignored if such a word is encountered. shrug ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) SQL Server Full-Text Search CONTAINS()
I now recall having this issue myself many years ago, and the reason it doesn't work is because the noise words (now called stop words) are not actually indexed, rather than being stripped from the search which is what you assumed. On SQL 2000 you couldn't even use the stop words period or you get an error, so you had to parse the noise file and strip and noise words out of the CONTAINS clause so that they were not used. Obviously the error no longer occurs since SQL 2005, you just don;t get any search results. Here is a better explanation of full text and stop words for you. http://msdn.microsoft.com/en-us/library/ms142551.aspx -- Russ Michaels http://www.bluethunderinternet.com : B2B hosting, VPS's, Exchange, CF, Railo www.cfmldeveloper.com : CFML community, FREE ColdFusion/Railo hosting http://www.michaels.me.uk : My Blog skype me : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
New Apache sites return 500 Internal Server Error for all CFML requests.
This is an ugly one. I think it is an Apache2 - ColdFusion 9 web server connector problem. I have two Solaris Unix web servers. Each of these servers have a dozen and a half Apache web sites each one connected to one of five ColdFusion instances. All, but *TWO* of them are working properly. We created two new Apache web sites and connected them to a new ColdFusion instance. This worked fine on one of our boxes, the development one, but not on the other, production of course. Whenever we try to request a cfm url from one of these sites on the production server we get a 500 Internal Server Error. HTML pages serve up just fine, and the new instance's Administrator runs fine on its 8305 port. So both Apache and ColdFusion seem to be working independently, but they are not talking to each other. All the other Apache sites connected to the other four ColdFusion instances also work properly. This has led me to investigate the web server connectors. They have always been tricky and problematic to set up on these boxes. The built in tools have never worked for us on these boxes and we have always had to manually compile the connectors and configure the connections in the web sites.. But, as far as I can tell, all the connection setups are the same between working examples and these non-working sites. Any insights into what else I should be checking and|or how web server connectors actually work (they have alwasy been mysterious black boxes to me) would be greatly appreciated. TIA Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Just an off-the-wall idea. Did you try a different order to the words? I.E. chemical NEAR romance AND my I was speculating what might happen of the 'noise' word came later in the list. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
@ Russ- Thanks for the reply. I've read that page so many times that it's all just gibberish right now. My brain is mush. LOL Suffice it to say, as you stated, when encountered in a FTS search string, noise/stop words block any results from being delivered. @ Ian- I had not tried that prior to your asking, but I have now. No change in the results. @ Everyone- Thank you for your responses. I am putting this one to bed now. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) SQL Server Full-Text Search CONTAINS()
Matt, I did actually give an explanation of why it doesn't work, perhaps you skipped that. So moving the words around wouldn't work as you are still searching for 3 words near to each other which are not near each other as my is not in your collection index. As I said, you need to parse the noise word list to make sure you do not search on any of them, especially if you are dynamically search on values passed from a form. if you want to search on noise words you will need to remove them from the noise list and re-index your collection, then it should work. Russ -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: 23 November 2010 22:07 To: cf-talk Subject: Re: (ot) SQL Server Full-Text Search CONTAINS() @ Russ- Thanks for the reply. I've read that page so many times that it's all just gibberish right now. My brain is mush. LOL Suffice it to say, as you stated, when encountered in a FTS search string, noise/stop words block any results from being delivered. @ Ian- I had not tried that prior to your asking, but I have now. No change in the results. @ Everyone- Thank you for your responses. I am putting this one to bed now. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL Server Full-Text Search CONTAINS()
Russ, You did, of course, state why, but it did not click until you just reworded it. Thank you! It makes perfect sense now. (And yes, I had already changed to removing noise words from the search string.) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
I have two Solaris Unix web servers. Each of these servers have a dozen and a half Apache web sites each one connected to one of five ColdFusion instances. All, but *TWO* of them are working properly. We created two new Apache web sites and connected them to a new ColdFusion instance. This worked fine on one of our boxes, the development one, but not on the other, production of course. Whenever we try to request a cfm url from one of these sites on the production server we get a 500 Internal Server Error. HTML pages serve up just fine, and the new instance's Administrator runs fine on its 8305 port. So both Apache and ColdFusion seem to be working independently, but they are not talking to each other. All the other Apache sites connected to the other four ColdFusion instances also work properly. This has led me to investigate the web server connectors. They have always been tricky and problematic to set up on these boxes. The built in tools have never worked for us on these boxes and we have always had to manually compile the connectors and configure the connections in the web sites.. But, as far as I can tell, all the connection setups are the same between working examples and these non-working sites. Any insights into what else I should be checking and|or how web server connectors actually work (they have alwasy been mysterious black boxes to me) would be greatly appreciated. In the directory in which the connector modules are installed, there should also be a text file. You should be able to enable the log level from this text file. That said, my guess would be that this is a permissions issue - perhaps the user context of Apache (and thus the connector which runs inline with Apache) doesn't allow execute access to the .cfm files in those sites. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
On 11/23/2010 2:48 PM, Dave Watts wrote: In the directory in which the connector modules are installed, there should also be a text file. You should be able to enable the log level from this text file. What text file where? I looked into the /opt/jrun4/lib/wsconfig folder and each 'connector' folder under that, and I do not see any text files, let alone any text files that I recognize as affecting logging details. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
In the directory in which the connector modules are installed, there should also be a text file. You should be able to enable the log level from this text file. What text file where? I looked into the /opt/jrun4/lib/wsconfig folder and each 'connector' folder under that, and I do not see any text files, let alone any text files that I recognize as affecting logging details. Welll, I don't have a copy of CF in front of me. But I think it's a dotfile in one of the subfolders of wsconfig (wsconfig/1, wsconfig/2, etc). I'll see if I can get to a CF server and take a look. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
In the mean time, I took a closer look at the logs (I wasn't looking in the Apache logs before). I found this block for the last attempt to request a cfm page. [Tue Nov 23 15:17:17 2010] [notice] jrApache[18177: 60758] could not open serverstore /opt/jrun4/lib/wsconfig/www/jrunserver.store: No such file or directory[Tue Nov 23 15:17:17 2010] [notice] jrApache[18177: 60758] Couldn't initialize from remote server, JRun server(s) probably down. What I don't understand is why could it not open that file, it is there and it has the same permissions as all the other web server connectors. /opt/jrun4/lib/wsconfig/www $ ls -al total 166 drwxr-xr-x 2 root root 512 May 29 13:51 . drwxr-xr-x 8 root root 512 May 29 13:51 .. -rw-r--r-- 1 root root 14 May 29 13:51 jrunservers.store -rwxr-xr-x 1 root root 81528 May 29 13:51 mod_jrun20.so The following is the 'calpip' connector folder that is working just fine. /opt/jrun4/lib/wsconfig/calpip $ ls -al total 166 drwxr-xr-x 2 root root 512 May 29 13:51 . drwxr-xr-x 8 root root 512 May 29 13:51 .. -rw-r--r-- 1 root root 14 May 29 13:51 jrunservers.store -rwxr-xr-x 1 root root 81528 May 29 13:51 mod_jrun20.so ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
In the mean time, I took a closer look at the logs (I wasn't looking in the Apache logs before). I found this block for the last attempt to request a cfm page. [Tue Nov 23 15:17:17 2010] [notice] jrApache[18177: 60758] could not open serverstore /opt/jrun4/lib/wsconfig/www/jrunserver.store: No such file or directory[Tue Nov 23 15:17:17 2010] [notice] jrApache[18177: 60758] Couldn't initialize from remote server, JRun server(s) probably down. What I don't understand is why could it not open that file, it is there and it has the same permissions as all the other web server connectors. /opt/jrun4/lib/wsconfig/www $ ls -al total 166 drwxr-xr-x 2 root root 512 May 29 13:51 . drwxr-xr-x 8 root root 512 May 29 13:51 .. -rw-r--r-- 1 root root 14 May 29 13:51 jrunservers.store -rwxr-xr-x 1 root root 81528 May 29 13:51 mod_jrun20.so The following is the 'calpip' connector folder that is working just fine. /opt/jrun4/lib/wsconfig/calpip $ ls -al total 166 drwxr-xr-x 2 root root 512 May 29 13:51 . drwxr-xr-x 8 root root 512 May 29 13:51 .. -rw-r--r-- 1 root root 14 May 29 13:51 jrunservers.store -rwxr-xr-x 1 root root 81528 May 29 13:51 mod_jrun20.so I don't think the file should be jrunservers.store. I'm not sure why that's working in the existing directories (maybe it isn't being read properly in those directories either, though). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authori ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
On 11/23/2010 3:59 PM, Dave Watts wrote: I don't think the file should be jrunservers.store. I'm not sure why that's working in the existing directories (maybe it isn't being read properly in those directories either, though). I would guess not either, which leads me back to why I find these web server connectors to be such a black box! They just make so little sense to me. Especially since each and every system I have looked at that file is a single, empty, proxyservers= line. But changing those file names on the working public servers is not something I can do today. If I bring down the working sites 30 minutes before the end of the last day before my five day holiday, might just ruin that holiday for me. So I will come back to this issue on Monday and advise you all on what the results are then. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Apache sites return 500 Internal Server Error for all CFML requests.
I would guess not either, which leads me back to why I find these web server connectors to be such a black box! They just make so little sense to me. Especially since each and every system I have looked at that file is a single, empty, proxyservers= line. Yeah, they're a mystery to me too. Looking at the docs, it looks like you can enable logging directly in Apache: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf363a5d-7ffb.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
moving data from sub-window into a form
Here is what I am trying to do: a) open a form - several form fields will have an IMPORT button b) IMPORT button opens a sub-window (cfwindow) which runs a query and displays the query results in a table c) select one of the rows in the sub-window with another button. Take the data from the sub-window row and punch it into the correct form field in the main window. close the sub-window d) maybe do this several times for different form fields. e) submit the main form WHEW! I have a) and b) working OK with CFWindow. c) d) and e) are a little mysterious. Can someone point out a resource that might provide some insights? TNX. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: moving data from sub-window into a form
To answer my own question, I did find this link for using Ajax in CF8: http://www.coldfusionjedi.com/index.cfm/2008/12/25/Using-CF8-Ajax-features-to-solve-the-pick-one-of-thousands-issue however, I need to be able to EITHER select from a sub-window OR type in some data directly into the form field. On 11/23/2010 5:41 PM, Rick Colman wrote: Here is what I am trying to do: a) open a form - several form fields will have an IMPORT button b) IMPORT button opens a sub-window (cfwindow) which runs a query and displays the query results in a table c) select one of the rows in the sub-window with another button. Take the data from the sub-window row and punch it into the correct form field in the main window. close the sub-window d) maybe do this several times for different form fields. e) submit the main form WHEW! I have a) and b) working OK with CFWindow. c) d) and e) are a little mysterious. Can someone point out a resource that might provide some insights? TNX. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm