RE: I/O Exception: Name in certificate does not match host name

2015-04-09 Thread Ian Chapman
Ok thanks Dave I'll look into that idea. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 08 April 2015 22:47 To: cf-talk Subject: Re: I/O Exception: Name in certificate does not match host name > 3) The dev API is (real domain names replaced with "domain1" and >

RE: I/O Exception: Name in certificate does not match host name

2015-04-08 Thread Ian Chapman
I've tried it that way but no dice, let show you what I have tried: 1) Exported the cert and imported into the Truststore (this should not have been needed as it is a Thawte issued certificate which is already in the trsutstore and lack of record in the truststore causes a different IO error). Th

I/O Exception: Name in certificate does not match host name

2015-04-08 Thread Ian Chapman
s it's a wildcard I don't see what I would add to the hosts as any number of subdomains on domain.net could resovle to a number of IP's. Any ideas? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now

Re: UTF8 encoding issues on response from HTTP request

2014-01-18 Thread Ian Chapman
forcibly reboot after a CF crash and may have upgraded Windows/Java/JVM. I need to look into when last upgrades happened to see if any were recent. Any suggestions on how I can look deeper into the interaction between CF and the API(s)? IIS/Jrun level perhaps? Regards, Ian. On Fri, Jan 17, 2014

RE: UTF8 encoding issues on response from HTTP request

2014-01-17 Thread Ian Chapman
Hi Dave, I've done both of those things. My CFHTTP request has the charset="utf-8" parameter on it btw. On the rogue box when saving the cfhttp output to a file it is still mangled. There is also a json response option from the API and that too does the same to the data. This the cfhttp header

UTF8 encoding issues on response from HTTP request

2014-01-17 Thread Ian Chapman
like: #cfhttp.filecontent# I have tried all the things you do to deal with UTF-8 encoding, but the fact that it only happens on one server makes me think it's a setting in CFadmin or Jrun causing the issue. Any ideas guys? I'm desperate!

Multiple instances of Railo

2013-09-26 Thread Ian Chapman
the previous guy left the company. Regards, 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

RE: Easy CFC question (I hope)

2013-05-09 Thread Ian Chapman
Chnage to -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 09 May 2013 16:57 To: cf-talk Subject: Re: Easy CFC question (I hope) > returntype="query"> ... > > SELECT fname, lname, email, secureHash >

Re: sql injection attempt

2013-01-24 Thread Ian Chapman
to the table. I'd not even thought of that method till we saw it. But something to have an eye on. Regards, Ian. On 23/01/2013 19:09, Pete Freitag wrote: > On Wed, Jan 23, 2013 at 12:57 PM, Rob Voyle wrote: > > >> Hi Greg >> As I continue to update my secur

RE: https connection issues using cfhttp

2013-01-17 Thread Ian Chapman
; webservice, you'll use "https://hub/..."; to access it. I've been > through this before as well and this should do it after you've > imported the certificate from the site. > > -- > Jeff > > > Original Message > > From

RE: https connection issues using cfhttp

2013-01-17 Thread Ian Chapman
your help. Regards, Ian. -Original Message- From: Jeff Garza [mailto:j...@garzasixpack.com] Sent: 17 January 2013 15:37 To: cf-talk Subject: re: https connection issues using cfhttp You are going to have to edit your hosts file and create a pointer for "hub" that directs it t

RE: https connection issues using cfhttp

2013-01-17 Thread Ian Chapman
ate in Windows it says "issued to HUB" and issued by "HUB". But I'm not sure how you'd create a certificate issued from "187.141.14.122". This is the end point so you can see the certificate in question if it helps. https://187.141.14.122:443/asg/ser

https connection issues using cfhttp

2013-01-17 Thread Ian Chapman
sy to resolve, but the latter has caused a lot of head banging. What I can tell is that it seems to be self signed certificate and feel this might be part of the problem. Any ideas? Regards, Ian. ~| Order the Adob

Re:_neo-runtime_xml

2012-12-31 Thread ian . chapman
Thanks for your email. I am currently out of the office until Wednesday 2nd January 2013. Our offices are closed for the Christmas and New Year Holidays. For immediate assistance please contact on the email and numbers below and one of the team will be in touch as soon as possible. For out of ho

neo-runtime xml

2012-12-31 Thread Ian Chapman
quot;Information","main","12/31/12","11:12:45",,"Starting registry..." "Information","main","12/31/12","11:12:45",,"Starting client..." "Error","main",&

Re:_Re:__Re:_URGENT_:_How_to_Detect_screen_resolution_in_COLDFUSION?

2012-12-26 Thread ian . chapman
Thanks for your email. I am currently out of the office until Wednesday 2nd January 2013. Our offices are closed for the Christmas and New Year Holidays. For immediate assistance please contact on the email and numbers below and one of the team will be in touch as soon as possible. For out of ho

Re:_Re:_URGENT_:_How_to_Detect_screen_resolution_in_COLDFUSION?

2012-12-26 Thread ian . chapman
Thanks for your email. I am currently out of the office until Wednesday 2nd January 2013. Our offices are closed for the Christmas and New Year Holidays. For immediate assistance please contact on the email and numbers below and one of the team will be in touch as soon as possible. For out of ho

Re:_Re:_URGENT_:_How_to_Detect_screen_resolution_in_COLDFUSION?

2012-12-24 Thread ian . chapman
Thanks for your email. I am currently out of the office until Wednesday 2nd January 2013. Our offices are closed for the Christmas and New Year Holidays. For immediate assistance please contact on the email and numbers below and one of the team will be in touch as soon as possible. For out of ho

Re:_Re:_URGENT_:_How_to_Detect_screen_resolution_in_COLDFUSION?

2012-12-23 Thread ian . chapman
Thanks for your email. I am currently out of the office until Wednesday 2nd January 2013. Our offices are closed for the Christmas and New Year Holidays. For immediate assistance please contact on the email and numbers below and one of the team will be in touch as soon as possible. For out of ho

Re:_Re:_URGENT_:_How_to_Detect_screen_resolution_in_COLDFUSION?

2012-12-22 Thread ian . chapman
Thanks for your email. I am currently out of the office until Wednesday 2nd January 2013. Our offices are closed for the Christmas and New Year Holidays. For immediate assistance please contact on the email and numbers below and one of the team will be in touch as soon as possible. For out of ho

RE: Huge rowcounts in CFCLIENTS database

2012-11-15 Thread Ian Chapman
nto a more specific database structure (as opposed to the vertical storage [1 row per data element] that is used by client vars) would help you out a lot. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Nov 15, 2012 at 10:42 AM, Ian Chapman wrote: > &g

RE: Huge rowcounts in CFCLIENTS database

2012-11-15 Thread Ian Chapman
Huge rowcounts in CFCLIENTS database how often do you have it set to purge ? We use cookie a sthe default storage method for client variables for years, never had any issues with it so far. On Thu, Nov 15, 2012 at 5:33 PM, Ian Chapman wrote: > > Hi Guys, > > I just decided to t

Huge rowcounts in CFCLIENTS database

2012-11-15 Thread Ian Chapman
. So would this mean that the session data becomes orphaned from real sessions? And if the counts seem high what is the safe way to purge these tables? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http

Web service calling a CFC not outputing query object results

2012-06-25 Thread Ian Chapman
Hi guys, We are running CF MX 7 and I've run into a problem with a CF web service we have. The web service calls a different include depending on the method passed to the web service. And each method will return XML output. For one of the methods/includes I am calling a global CFC function to

cfwindow, cfgridcolumn & href problem

2011-09-22 Thread Ian Bentley
id using Page 2 -- I know I must be missing something. Thank you for any help, Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?t

Re: Can anyone decode this?

2011-05-17 Thread Ian Skinner
On 5/17/2011 6:13 AM, Will Blake wrote: > Will cfqueryparam not protect input sufficiently enough to disrupt this kind > of attack? Yes, cfqueryparam would prevent the SQL code in that attack from executing. Content of parametrized values are never evaluated by the database for SQL statements

Re: screenshots

2011-05-16 Thread Ian Skinner
On 5/16/2011 1:11 PM, John M Bliss wrote: > Hi! Has anyone built anything with CF that'd take as an argument a URL and > would return an image representing a screenshot of that page? Is this crazy > talk? Yes, it is pretty crazy, ColdFusion has NO SCREEN of which to take a SHOT. There is the

Re: CF 301 Redirect on an HTML page

2011-05-05 Thread Ian Skinner
On 5/5/2011 3:55 PM, Jenny Gavin-Wear wrote: > I'd be interested in what everyone thinks about using the above, I've always > used the meta way before. My understanding is that it is better the META tags from search engines point of view. But it is slightly more work on the servers part then le

Re: CF 301 Redirect on an HTML page

2011-05-05 Thread Ian Skinner
On 5/5/2011 1:26 PM, Jacob wrote: > If not, then you can use something like this which I have used in the past: > > > http://www.domain.com/url.htm";> > Except that this code does not work so well on HTML pages, which is what the OP was asking for help with. ~

Re: CF 301 Redirect on an HTML page

2011-05-05 Thread Ian Skinner
On 5/5/2011 12:05 PM, Chris Bracciano wrote: Yes, Application.cfm|cfc files are only executed in conjunction with other cfml templates. If worst comes to worst, you could do META and|or JavaScript redirects, but these would probably be little better then the current situation. The better answ

Re: how to restart a specific CF application (not app server)

2011-05-05 Thread Ian Skinner
> I know I could restart the ColdFusion service and that would probably > do the trick. However I'm anticipating needing to do modify > onApplicationStart several times during the course of development, and > I would prefer to find a way to restart just this particular > application. Set the

Re: Help us Please - CF 5 Server Licenses

2011-05-05 Thread Ian Skinner
On 5/5/2011 5:11 AM, Ralph B Littleleaf wrote: > PS A friend tried our legacy code on their CF 8 box, and it works. So CF 5-8 > versions are possibilities so long as we can get the licenses at a price we > can afford. I can not speak to the affordability for you, but I just wanted to make sur

Re: MS XML Parse

2011-05-03 Thread Ian Skinner
On 5/3/2011 10:18 AM, Torrent Girl wrote: > Actually, I can dump the contents of the cfhttp.filecontent return > with no problem. That is because at that point, the data is still flat text. One can fit a WHOLE LOT of flat text into a gigabyte or two of ram memory. The problem will occur when

Re: MS XML Parse

2011-05-03 Thread Ian Skinner
On 5/3/2011 9:14 AM, Torrent Girl wrote: > 'http://www.microsoft-careers.com/Microsoft-Diversity-AAWIT116obs.xml'> That looks to be a pretty large XML document. There are definite limits on how large of document that xmlParse() can process. As xmlParse uses a DOM parsing methodology, the ent

Re: Strange Hack... WHY?

2011-04-15 Thread Ian Skinner
On 4/15/2011 10:47 AM, Mark A. Kruger wrote: > I'd say they want to steal any leads that come in to you guys through the > website. And|or deliver malicious content to those visitors that accidentally end up there. ~| Order the

Re: Parsing .css files with CF

2011-04-14 Thread Ian Skinner
On 4/14/2011 10:43 AM, Rick Faircloth wrote: > Nevermind... duh... wrong file path... I was about to suggest typing the CSS path into your browser url bar to make sure there is actually a file located there. ~| Order the Adobe

Re: Parsing .css files with CF

2011-04-14 Thread Ian Skinner
On 4/14/2011 9:21 AM, Rick Faircloth wrote: > So just use: > > style.cfm > - > > > > > > > body { color:#variables.color#; } > > Pretty Close. You only need to double the ## symbols, if the content is INSIDE a block. As you start the block on the next line, you do not need to

Re: Custom tags in CF 9

2011-04-12 Thread Ian Skinner
On 4/12/2011 1:21 PM, Raymond Camden wrote: > Don't forget that in CF8 you gained the ability to specify custom tag > folders in your Application.cfc file instead. I know you are looking > for the simplest solution, but this is an option as well. I do forget about that cool option all to often.

Re: Custom tags in CF 9

2011-04-12 Thread Ian Skinner
On 4/12/2011 12:28 PM, Donnie Carvajal wrote: > Thanks for the feedback. > > The intention is to set up a multi-server instance. I did find the > customtags and the cfx directories for this instance; however, the customtags > are more of a library that we use across servers. Is there a generic

Re: Custom tags in CF 9

2011-04-12 Thread Ian Skinner
On 4/12/2011 12:04 PM, Donnie Carvajal wrote: > Hi, > > I recently installed an enterprise version of CF9 and the default directory > is c:\jrun4 and there is no CustomTags directory. I added my customtags > directory from my MX7 server and the custom tags calls are returning errors > that the

Re: replacelist question

2011-04-05 Thread Ian Skinner
On 4/5/2011 9:46 AM, Jenny Gavin-Wear wrote: > in, of, at, it, the, on", ""))> What you probably want is: Assuming you do NOT want to replace these strings when they are part of larger words. ~| Order the Adobe Coldfusio

Re: replacelist question

2011-04-05 Thread Ian Skinner
On 4/5/2011 9:46 AM, Jenny Gavin-Wear wrote: > I can't understand how "the" is not replaced when it is the first word in > the list. When the word is at the beginning of the string it DOES NOT have a white space character in front of it. Your list is including a white space character in front o

Re: CFSEARCH puzzle

2011-03-29 Thread Ian Skinner
On 3/29/2011 3:32 PM, Kevin Parker wrote: > That's correct - context is working fine but no mark-up. > > Now that's actually quite interesting - I added a cfdump as you hinted and > the markup is in the dump but when I output the context to the page as part > of the search results it's not. Is it

Re: What event specifically triggers OnApplicationStart?

2011-03-28 Thread Ian Skinner
On 3/28/2011 11:10 AM, Dave Burns wrote: > My code looks like this: > > configName = "dev" > if CGI.SERVER_NAME contains "blah.com" > configName = "production" Which means that if I (or any joker poking at your site to see if they can do something) who requests your site by its IP address c

RE: Errors calling a asmx web service

2011-03-23 Thread Ian Vaughan
Hi Dave et al Could the problem with the .NET web service be because CF7 apache axis and commons HTTPClient Axis will use the HTTPClient library for it HTTP needs. Since the HTTPClient library supports NT Authentication, you just set the username/password on the Stub object as you would no

RE: Errors calling a asmx web service

2011-03-15 Thread Ian Vaughan
Hi Dave I ran the http://domain/EyeTest_ws.asmx url path from my pc and from the server where CF is installed but could not test it as it says the form is only available for requests from the local machine. The service description looks fine though -Original Message- From: Dave Watts

RE: Errors calling a asmx web service

2011-03-15 Thread Ian Vaughan
Hi Yes the .asmx file looks fine, could it be a user authentication issue? If so how do you register the web service? Is it done in CF Admin - and how does this change path that is called? At the moment it looks like this? http://domain/EyeTest_ws.asmx?wsdl";> ... etc -Original Message--

Errors calling a asmx web service

2011-03-15 Thread Ian Vaughan
Hi Any ideas why I am getting the following error when calling a .asmx webservice in CF7?? Is it permissions or does it have to be WSDL?? ERROR- Could not generate stub objects for web service invocation. Name: http://edrmservices/edrmsWeb/EyeTest_ws.asmx. WSDL: http://DOMAIN/EyeTest_

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
Thanks dean, that's great -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: 14 March 2011 13:21 To: cf-talk Subject: Re: RE: Database Lookup - Possible with CF? Ian, again you are mixing things up.CFJSON is not what calls the webservice. CFJSON is used to e

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
d any cf8/cf9 specific code. just Google "using jquery with coldfusion" and you will get plenty of hits. On Mon, Mar 14, 2011 at 10:12 AM, Ian Vaughan < i.vaug...@neath-porttalbot.gov.uk> wrote: > > Thanks but where are the tutorials on how to do this in CF7, they all >

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
] Sent: 11 March 2011 18:30 To: cf-talk Subject: Re: RE: Database Lookup - Possible with CF? It's very easy to do in CF7. However, it appears you don't have the knowledge or desire to learn. You have to possess one. On Mar 11, 2011 8:22am, Ian Vaughan wrote: > Thanks all for you

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
] Sent: 11 March 2011 18:30 To: cf-talk Subject: Re: RE: Database Lookup - Possible with CF? It's very easy to do in CF7. However, it appears you don't have the knowledge or desire to learn. You have to possess one. On Mar 11, 2011 8:22am, Ian Vaughan wrote: > Thanks all for you

Re: Text to voice

2011-03-11 Thread Ian Skinner
On 3/11/2011 2:06 PM, Judah McAuley wrote: > someone says, "Hello?" it will trigger a Human CPA event and > restart your dialog that plays the "we really need help" message. I would also hope this project is being done with the cooperation and assistance of the authorities that will potentially

RE: Database Lookup - Possible with CF?

2011-03-11 Thread Ian Vaughan
MVC2 which will be a similar learning curve as trying to get it done in CF7 but would give better long term prospects -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: 11 March 2011 14:06 To: cf-talk Subject: RE: Database Lookup - Possible with CF? Ian, Now yo

RE: Database Lookup - Possible with CF?

2011-03-11 Thread Ian Vaughan
[mailto:dean...@gmail.com] Sent: 10 March 2011 15:04 To: cf-talk Subject: Re: Database Lookup - Possible with CF? Ian, I think your a little confused about a couple of things. First off, AJAX really has no direct relationship with ColdFusion. AJAX runs on the client side and ColdFusion runs on the

Re: How to pass a file to a web service.

2011-03-10 Thread Ian Skinner
On 3/10/2011 8:05 AM, Dean Lawrence wrote: > Ian, you would need to convert the uploaded file to base64 before > submitting it to the web service. This essentially will transfer the > file as text. What would be the result of converting a text file to base64? I'm not dealing with

How to pass a file to a web service.

2011-03-10 Thread Ian Skinner
What would be the web service equivalent of this HTTP request? wsTest.cfm |https://secure-devsite/pur-loader/ws/ppur_v0.cfc"; method="post" multipart="yes"> #htmlEditFormat(cfhttp.FileContent)# | ppur_v0.cfc | ...

Re: ColdFusion License and Builder

2011-03-10 Thread Ian Skinner
On 3/10/2011 6:47 AM, DURETTE, STEVEN J (ATTASIAIT) wrote: > I swear that I saw somewhere (I thought on this list but couldn't find > it) that the licensing for CF9 was a change for what I had said before > about the dev/hot spare, and it didn't have the ip restrictions. Yes, the EULA for CF9 has

RE: Database Lookup - Possible with CF?

2011-03-10 Thread Ian Vaughan
? -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: 09 March 2011 12:01 To: cf-talk Subject: Re: Database Lookup - Possible with CF? Ian, Your query logic goes inside your cfc method. (pseudocode) component function a

RE: Database Lookup - Possible with CF?

2011-03-09 Thread Ian Vaughan
e. Finally you mention about CF7 I have had a look at RIA but could not find anything to convert data to a js string - not sure if you know of any? - and how does this conversion fit into your example code? Many Thanks, Ian -Original Message- From: Dan G. Switzer, II [mailto:dswit...@pengowork

Re: file upload - preventing double or more full stops in file name

2011-03-07 Thread Ian Skinner
On 3/7/2011 12:52 PM, Don wrote: > 200 > Content-Disposition: form-data; name="b_file"; filename="C:\Documents and > Settings\dsdfsd\Desktop\clean up\test.docupload.doc" And that is different from the cffile.clientFile property? Do note that cffile.clientFile is the full file name, cffile.cli

Re: Aligning text from top to bottom

2011-03-07 Thread Ian Skinner
On 3/7/2011 11:54 AM, Torrent Girl wrote: > Disregard - I found it :) > > > This will be rotated 90 degrees. > In Mozilla based browsers. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-An

Re: file upload - preventing double or more full stops in file name

2011-03-07 Thread Ian Skinner
On 3/7/2011 11:40 AM, Don wrote: >>> Why do you need to do this before you process it with CFFILE? > Because once its uploaded the server hacks off the last (.) > > For example: > > original file: somefile.mack.txt > > renamed file on server: somefile.mack Well, as Dave indicated, ColdFusion is n

RE: Database Lookup - Possible with CF?

2011-03-03 Thread Ian Vaughan
Hi Dave I'm willing to give CF a go, even though here the move is away from CF onto .NET and Java (ADF) Do you have any step by step tutorials that I could follow that I can use to implement the feature below in CF, if they can see what it can do it would certainly help its case. All I am looki

RE: Database Lookup - Possible with CF?

2011-03-03 Thread Ian Vaughan
Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-deskto p-style-user-interfaces/book "The best way to predict the future is to help create it" On 3/2/2011 9:30 AM, Ian Vaughan wrote: > Hi Craig et al > >

RE: Database Lookup - Possible with CF?

2011-03-03 Thread Ian Vaughan
tps://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-deskto p-style-user-interfaces/book "The best way to predict the future is to help create it" On 3/2/2011 9:30 AM, Ian Vaughan wrote: > Hi Craig et al > > Thanks for this > > So download JQuery and link to the

RE: Database Lookup - Possible with CF?

2011-03-02 Thread Ian Vaughan
ilt-in cf functionality. All you need is well described >in CF Developer's Guide (download pdf from adobe.com) and numerous >blogs. > >Azadi > >On 02/03/2011 17:37 , Ian Vaughan wrote: >the >> corner of Coldfu

RE: Database Lookup - Possible with CF?

2011-03-02 Thread Ian Vaughan
then use the built-in cf functionality. All you need is well described in CF Developer's Guide (download pdf from adobe.com) and numerous blogs. Azadi On 02/03/2011 17:37 , Ian Vaughan wrote: > Hi > > I have created a web form, but what I would like it to do (and I'm not &g

Database Lookup - Possible with CF?

2011-03-02 Thread Ian Vaughan
Hi I have created a web form, but what I would like it to do (and I'm not sure if this is possible with Coldfusion?) is when a user enters their employee number into a text field without a page refresh it runs a database lookup and populates other fields in the form with that employees informatio

Re: Calculating Percentage

2011-03-01 Thread Ian Skinner
On 3/1/2011 12:31 PM, John Eubanks wrote: > I know this is probably a dumb question, but I need help anyways. I am > building a test in coldfusion for end users. I need to calculate the total > percentage and display it. How do I do that? For example, if a user gets > six out of ten questio

Re: 2r hour time format

2011-02-07 Thread Ian Skinner
On 2/7/2011 8:24 AM, Orlini, Robert wrote: > Ahh. Good question. It is just numeric. I beleive I need to change it to > date-time object? You will need to convert it, if you want to use the timeFormat() function. Otherwise you could just use some basic string manipulation functions to format t

Re: 2r hour time format

2011-02-07 Thread Ian Skinner
On 2/7/2011 8:14 AM, Orlini, Robert wrote: > Thank you all. > > I looked over the livedocs for CF and formatted it this way: > > #TimeFormat(get.prodreccounttime, "hh:mm:ss")# > > However, instaed of the time "1630" becoming "16:30" I get "12:00:00". > > What did I do wrong here? > > RO What type

Re: Math weirdness

2011-02-03 Thread Ian Skinner
On 2/3/2011 12:56 PM, Jen McVicker wrote: > Can someone explain it to me in small words so > that I will understand? ;-) Computers do not understand decimal (base 10) numbers. They only truly understand binary (base 2) numbers. Sometimes when converting back and forth between the base 10 num

Re: SQL query question

2011-02-01 Thread Ian Skinner
On 2/1/2011 2:21 PM, Charlie Stell wrote: > I assume this is something on CF's side - > as restarting the CF service also fixes it. Not ColdFusion itself, but the database drivers used by ColdFusion and the cached (pooled) data source settings. Changing the Datasource to not used pooled setting

Re: SQL query question

2011-02-01 Thread Ian Skinner
On 2/1/2011 1:23 PM, Debbie Morris wrote: > What am I overlooking? The evil of using * in SELECT clauses. When that is done, database drivers are know to cache the columns and datatypes of the SQL queries. Then somebody comes along and changes the database structure, like you adding a field.

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: > On another note, the > query that brought back 98 results may have been working right, i found > another 78 records in another table for race car radiators, i'm almost > guessing that the last few are in another table that would make the total > 200 r

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: > But i'm now getting an error that the part_number field > is ambiguous. Ugh That just means that the field is in both (multiple) tables and the database wants you to tell it which table you want to use to get the value for this column to use in

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
On 2/1/2011 10:22 AM, Aaron Renfroe wrote: > Hello Ian and thank you! > > But my query was still running wrong, correct? Not necessarily, maybe your data is wrong. You may need to provide some more description on what data is in each of these tables and how you are trying to utilize

Re: SQL Join Woes

2011-02-01 Thread Ian Skinner
On 2/1/2011 9:41 AM, Aaron Renfroe wrote: > Hello All! > > SELECT DISTINCT PartNumber FROM GriffinDataRevised > INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number > WHERE Top200.part_number = GriffinDataRevised.PartNumber INNER JOIN will enforce a filter tha

Re: Application.cfc & cfinclude

2011-01-27 Thread Ian Skinner
On 1/27/2011 3:12 PM, Michael Grant wrote: > can't you just do to get the method to fire? > Do you really need to rename the app scope? Yes, you can /fire/ the method that way. But that is OFTEN not exactly the same as triggering the onApplicaitonStart *event*. Sometimes one just really want

Re: Session variables security

2011-01-24 Thread Ian Skinner
On 1/24/2011 8:57 AM, Richard White wrote: > Hi, > > When the user logs in, I save their username to the session scope. > > Would i need to re-validate that username at the top of every page that uses > it in a database query? > > I previously thought this was not necessary but if it is possible

Re: URL variable security

2011-01-24 Thread Ian Skinner
On 1/24/2011 8:50 AM, Richard White wrote: > ok thanks for the help I just wanted to add that your question, concerns and the replies DO NOT just apply to URL variables. They apply to ANY and ALL data received from the client. Including form POST values, COOKIE values, ect. Anything and ever

Oh The evils: .NET on a Unix w/ Apache web server

2011-01-20 Thread Ian Skinner
Is this even possible. Some internet searching is giving me hints about projects like Mono and DotGNU. Are these (or something else) viable ways to run an .NET web application on a Unix box? Or is this just a crazy idea. Our organization has a contract to produce an external web application

Re: CF Permanent Redirect (301)???

2011-01-18 Thread Ian Skinner
On 1/18/2011 1:41 PM, Aaron M Renfroe wrote: > Would i place that in my application.cfm or at the top of my pages? > Technically the same thing. The purpose of Application.cfm|cfc is that is is code that is run before (at the top of) all normal pages.

Re: CF Permanent Redirect (301)???

2011-01-18 Thread Ian Skinner
On 1/18/2011 1:31 PM, Justin Scott wrote: > There are also non-CF ways of doing this such as URLRewrite engines. > IIS 7 has a "preferred domain" URL filter which makes this really, > really easy and applicable to the entire site with a few clicks. > > > -Justin Scott Of which the best is probab

Re: Beta Tester Wanted for new CF (MVC) Framework

2011-01-04 Thread Ian Skinner
Both mime types and file extensions can be spoofed by a hacker as both are just data that hackers can manipulate on their end of the client-server relationship. Unless you are running code that actually inspects the content of the file to confirm that it matches the file type and the mime t

Re: SOT: Show time in field on click

2011-01-04 Thread Ian Skinner
On 1/4/2011 10:05 AM, Russ Michaels wrote: > Michael, > > you do indeed need an ID to be defined to use getElementById(), True, if you use the getElementByID() function. But Russ was showing the docuement.formName.inputName syntax which is based on names and thus you do not need to use IDs w

Re: SOT: Show time in field on click

2011-01-04 Thread Ian Skinner
On 1/4/2011 7:44 AM, Orlini, Robert wrote: > Russ/Mike, > > Is there a way just to show the time and not the date? Ok, looking closer at the full date object reference. http://www.w3schools.com/jsref/jsref_obj_date.asp toTimeString() OR toLocalTimeString() are probably what you are looking for

Re: SOT: Show time in field on click

2011-01-04 Thread Ian Skinner
On 1/4/2011 7:44 AM, Orlini, Robert wrote: > Russ/Mike, > > Is there a way just to show the time and not the date? Use the appropriate methods of the date object. http://www.w3schools.com/js/js_obj_date.asp I would probably start with the getTime() method. document.myForm.myField.value = my_

Re: SOT: Show time in field on click

2011-01-04 Thread Ian Skinner
On 1/4/2011 7:16 AM, Orlini, Robert wrote: > Still not showing when I click the button. I also tried putting my_time into > the field. > > RO document.myForm.myDate.value = my_time; IIRC, I believe that those refer to the ID's of DOM elements, not names. Try changing your form to.

Re: Exporting a Spreadsheet file

2010-12-20 Thread Ian Skinner
On 12/20/2010 10:41 AM, Rick Colman wrote: > This works fine in IE, etc. : > > value="buylist_job_#session.projectid#.xls"> This is the way I usually see and use that tag. NOTE the *filename=* part of the value parameter. ~~

Re: Tutorial on creating this pagination?

2010-12-17 Thread Ian Skinner
On 12/17/2010 12:54 PM, Adam Parker wrote: > What am I doing wrong? > You need to put them inside of blocks. #pagination.getRenderedHTML()# ... #pagination.getRenderedHTML()# ~| Order the Adobe Coldfusion Anthology now! h

Re: Database query - match 1 or more zeros

2010-12-17 Thread Ian Skinner
On 12/17/2010 11:41 AM, Michael Grant wrote: > I think regex is the way to go for you. > WHERE field = [0]* I think would work. Thanks, that was the seed of the idea I needed. WHERE REGEXP_LIKE(grower_id, '0+') I just changed it to 0+ because I wanted to match one or more zeros NOT zero or mor

Database query - match 1 or more zeros

2010-12-17 Thread Ian Skinner
immer of an idea of a concept for this. TIA for any suggestions or guidance. Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: CFMail problem since upgrading to CF9

2010-12-10 Thread Ian Skinner
On 12/10/2010 9:04 AM, Rick Root wrote: > ["Error","scheduler-4","12/10/10","11:40:51",,"Could not connect to > SMTP host: 69.41.172.242, port: 25, response: 421" > and > ["Error","mailWorker-6","12/10/10","10:50:29",,"Could not connect to > SMTP host: 69.41.172.242, port: 25, response: 421 > D

Re: Log That Keeps Track of Scheduled Tasks

2010-12-10 Thread Ian Skinner
On 12/10/2010 8:53 AM, Asaf Peleg wrote: > Is there a log that CF keeps that records when it ran a task or something of > this nature. > You have to enable it from the ColdFusion Administrator. But then it will record the execution and scheduling of all the tasks. ~~

Re: Files Management Question

2010-12-09 Thread Ian Skinner
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_d-e_03.html http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_02.html ~| Order the Adobe Coldfusion Anthology now! http://www.amaz

Re: REQUEST.cfdumpinited

2010-11-30 Thread Ian Skinner
On 11/30/2010 11:23 AM, Sean Henderson wrote: > CF9 workaround? The output format property of CF9 that allows you only output a text version of the cfdump content? ~| Order the Adobe Coldfusion Anthology now! http://www.amaz

Re: Get day of week of fourth Thursday of month.

2010-11-29 Thread Ian Skinner
On 11/29/2010 4:18 PM, Matt Quackenbush wrote: > Heh. Sometimes, like when your brain feels like mush, no thinking involved > is a good thing. ;-) IT SURE i...@#! +infinity ~| Order the Adobe Coldfusion Anthology now! http:/

Re: Get day of week of fourth Thursday of month.

2010-11-29 Thread Ian Skinner
On 11/29/2010 2:56 PM, Matt Quackenbush wrote: > http://www.cflib.org/udf/GetNthOccOfDayInMonth Thanks no thinking involved. Though I was half way there on my own. ~| Order the Adobe Coldfusion Anthology now! http://www.amaz

  1   2   3   4   5   6   7   8   9   10   >