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: 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 sure

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

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: cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=http://www.domain.com/url.htm; cfabort Except that this code does not work so well on HTML pages,

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

Re: MS XML Parse

2011-05-03 Thread Ian Skinner
On 5/3/2011 9:14 AM, Torrent Girl wrote: cfset getJobs = '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

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: 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 9:21 AM, Rick Faircloth wrote: So just use: style.cfm - cfcontent type=text/css charset=ISO-8859-1 cfset variables.color = ##fff cfoutput body { color:#variables.color#; } /cfoutput Pretty Close. You only need to double the ## symbols, if the content is

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: 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 they

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 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: 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 of

Re: replacelist question

2011-04-05 Thread Ian Skinner
On 4/5/2011 9:46 AM, Jenny Gavin-Wear wrote: Cfset session.realSearch = lcase(replacelist(session.realSearch, and, or, in, of, at, it, the, on, )) What you probably want is: Cfset session.realSearch = lcase(replacelist(session.realSearch, and,or,in,of,at,it,the,on, )) Assuming you do NOT

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 could set

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 be

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

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 |cfhttp url=https://secure-devsite/pur-loader/ws/ppur_v0.cfc; method=post multipart=yes cfhttpparam name=authentication value= type=formfield cfhttpparam name=ppurfile

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 a binary file

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 not

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 :) div style=-moz-transform: rotate(90deg); -moz-transform-origin: bottom left;font-size:30px This will be rotated 90 degrees. /div In Mozilla based browsers.

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,

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 questions

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 of data is

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

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

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 that

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 it before we

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 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

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 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 settings

Re: Application.cfc cfinclude

2011-01-27 Thread Ian Skinner
On 1/27/2011 3:12 PM, Michael Grant wrote: can't you just docfset onApplicationStart() / 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*.

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

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 for

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: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 probably at

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: 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. form

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 =

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 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

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

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. : cfheader name=Content-Disposition value=buylist_job_#session.projectid#.xls This is the way I usually see and use that tag. cfheader name=Content-Disposition value=filename=Result.xls NOTE the *filename=* part of

Database query - match 1 or more zeros

2010-12-17 Thread Ian Skinner
I have a varchar field that can (shouldn't, but can) contain a variable number of zero[0] characters. I want to return all rows where this field only contains zeros, no matter how many zeros it may contain. Due to too much holiday potluck, my lethargic brain can not produce even a glimmer

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 more

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 foutput blocks. cfoutput#pagination.getRenderedHTML()#/cfoutput ... cfoutput#pagination.getRenderedHTML()#/cfoutput ~|

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: 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 Does the user that your

Re: Files Management Question

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

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!

Get day of week of fourth Thursday of month.

2010-11-29 Thread Ian Skinner
I know I've done this in the past, but for the life of me, my mind is not coming up with any ideas at the moment. I'm looking for an algorithm to to find the calendar date for the x-th day of the n-th week of a month. TIA

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!

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!

Re: How to Display lined up Output

2010-11-23 Thread Ian Skinner
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.

Re: How to Display lined up Output

2010-11-23 Thread Ian Skinner
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

New Apache sites return 500 Internal Server Error for all CFML requests.

2010-11-23 Thread Ian Skinner
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

Re: (ot) SQL Server Full-Text Search CONTAINS()

2010-11-23 Thread Ian Skinner
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

Re: New Apache sites return 500 Internal Server Error for all CFML requests.

2010-11-23 Thread Ian Skinner
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

Re: New Apache sites return 500 Internal Server Error for all CFML requests.

2010-11-23 Thread Ian Skinner
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

Re: New Apache sites return 500 Internal Server Error for all CFML requests.

2010-11-23 Thread Ian Skinner
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

Re: coldfusion standard edition version switched to developer edition?!

2010-11-18 Thread Ian Skinner
On 11/18/2010 12:58 PM, Tim Do wrote: I was able to find a key that matched. Server is back up now. Question is, how/why did the config file get set to developer edition... it was never installed as a developer edition to begin with. How long was the server running? If it was something

Re: CFCs for AJAX

2010-11-16 Thread Ian Skinner
On 11/16/2010 12:06 PM, Donnie Carvajal wrote: I thought the onRequest method caused issues with calling CFCs remotely. Can cause problems. The problem usually being that the onRequest, onRequestStart and|or onRequestEnd cause data to be added to the request response that AJAX can not

Re: CF Blog software

2010-11-09 Thread Ian Skinner
On 11/9/2010 9:54 AM, Jason Fisher wrote: Granted they shouldn't have unrestricted access, but I would argue that you should be able to call them within your own application or else the ability to build complex applications begins to be pretty well hampered, no? Well, true. But hosting

Re: cfheader/cfheader not working as expected

2010-11-08 Thread Ian Skinner
On 11/8/2010 9:55 AM, Robert Gallagher wrote: Using attachment forces the user to make a selection on a dialog box and I wanted to bypass that dialog box and have the file open every time. You do not get to make that choice. It is *MY* computer and *MY* browser and *I* get to say what

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 12:14 PM, Rick Faircloth wrote: What am I doing wrong? (Besides mostly likely making this way harder than it should be... just fog on the brain today) Rick I suspect that datatime is a column name in your database scheme. IF so that would mean you are trying to use a

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 12:14 PM, Rick Faircloth wrote: What am I doing wrong? (Besides mostly likely making this way harder than it should be... just fog on the brain today) Rick On 11/5/2010 12:25 PM, Ian Skinner wrote: You need to be using a database function around the database column

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 1:20 PM, Rick Faircloth wrote: Variable dateOfTotal is undefined. How can that column name be undefined? Why is it not being understood in the SQL? Because ColdFusion is NOT your database server, it has NO IDEA what column exist or do not exist. It does not see 'dateOfTotal'

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 12:14 PM, Rick Faircloth wrote: select totalNew from 04a_dailyNumberNewHMLSProperties where '#dateFormat(datetime, 'mmm d, ')#' = '#dateFormat(createODBCDateTime(dateDiff('d', '-1', now())), 'mmm d, ')#' But here is an example of how I would do it on

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 2:44 PM, Rick Faircloth wrote: Anyway, here's what finally worked: select totalNew from 04a_dailyNumberNewHMLSProperties where day(date_add(dateOfTotal, interval -1 day)) = #dateFormat(dateAdd('d', -1, now()), 'd')# I'm glad you got something to work! But you

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 3:31 PM, Rick Faircloth wrote: Something is still not right... I would suggest you stop looking at date-time values as a collection of sub values, such as Days or Minutes. You need to consider it as a single value that you want to compare to another value. Trying me best to

Re: I think I'm just making this way too hard...

2010-11-05 Thread Ian Skinner
On 11/5/2010 3:52 PM, Ian Skinner wrote: WHERE date(date_add(dateOFTotal, interval -1 day))) = date_add(curdate(), interval 01 day) And if I could type and|or proof read: WHERE date(date_add(dateOFTotal, interval -1 day))) = date_add(curdate(), interval -1 day

Re: cfheader/cfheader not working as expected

2010-11-05 Thread Ian Skinner
cfheader name=Content-Disposition value=*inline*;filename=download.xls / Change inline to attachment so that the browser knows this is a separate, attached file to view OR download AND NOT an inline part of the currently viewed file: test.cfm.

Re: Closing Browser expires session/cookie

2010-11-05 Thread Ian Skinner
On 11/5/2010 4:26 PM, Tony Bentley wrote: How can I remove the user from the log when they close the browser? You really can't! Browsers don't go back to all the web servers that the user visted and tell them I'm being closed now. So yeah, the user closes the browser but that doesn't fire

Re: Scheduling lots of ColdFusion tasks in a limited window

2010-11-02 Thread Ian Skinner
Scheduled tasks are just URLs requested by a computerize built-in browser rather then a client in front of a human. If the CFML code being run by the Scheduled task(s) could execute properly if two humans requested the URLs at the same time, their should be no problem with a computer doing

ColdFusion 9 -- Manually installing ODBC services

2010-11-01 Thread Ian Skinner
Can anybody tell me if this technote still applies to ColdFusion 9? http://kb2.adobe.com/cps/191/tn_19135.html What, if anything, might be changed because the server in question is multi-server not standalone. TIA Ian ~|

CF 9.0 Schedule Tasks didn't execute.

2010-10-28 Thread Ian Skinner
Schedule tasks that have been running for weeks, months, or years decided not to exectute this week. I can see in the Schedule Task log that they all executed Monday , then somewhere between Tuesday and Wednesday, the entire list just did not execute. For every task I can see it running

OT Windows Command line HTTP request

2010-10-28 Thread Ian Skinner
In the simplest manner possible. What ways can one make a Windows DOS Command line HTTP request. TIA Ian ~| Order the Adobe Coldfusion Anthology now!

Re: OT Windows Command line HTTP request

2010-10-28 Thread Ian Skinner
On 10/28/2010 10:00 AM, Dave Watts wrote: Use a program like wget or cURL. Any suggestions for where to get wget? My first search attempts ended up in ancient (1997) ports and broken links. TIA Ian ~| Order the Adobe

Re: Installation Instructions Coldfusion Enterprise 9

2010-10-25 Thread Ian Skinner
On 10/25/2010 7:10 AM, Dawn Sekel wrote: Does anyone have installation instructions for Coldfusion Enterprise 9? Do I just try downloading the Developer edition and then upgrade with our upgrade license number? I tried calling Adobe Technical support and got someone in India who

Re: Memory Upgrade - Revisited

2010-10-21 Thread Ian Skinner
On 10/21/2010 6:42 AM, Steve LaBadie wrote: Just to be clear my assumptions are correct that I do not need to purchase the Enterprise version in order to utilize the memory? -Original Message- From: David McGraw [mailto:david.mcg...@gmail.com] There is something wrong with the

Re: generating eticket

2010-10-21 Thread Ian Skinner
On 10/21/2010 7:00 AM, fun and learning wrote: Hi All - I was just curious if this can be done using coldfusion. Can we generate an e-ticket in Coldfusion. Suppose a user books a movie ticket or a bus ticket, can we send an email with eticket embedded in it Is your output going to be

Re: 20 fields to compare

2010-10-14 Thread Ian Skinner
On 10/14/2010 2:01 PM, Robert Harrison wrote: Sorry ... nothing wrong with a loop. Just this particular program has bunches and bunches of loops already (76 and counting). It's beginning to look redundant and make my eyes cross. This program is becoming a loop de loop. :-) Loops are one

Re: Lions, Tigers and Images, Oh My!

2010-10-12 Thread Ian Skinner
On 10/12/2010 11:41 AM, Everett Alexander wrote: /opt/jrun4/servers/DISCOVERY/SERVER-INF/temp/cfusion.war-tmp/neotmp2153518236327741178.tmp That is the temporary location where the web server (IIS or Apache) put the uploaded file after it decoded the data from the HTTP request. It then put

Re: Javascript Cfquery

2010-10-12 Thread Ian Skinner
On 10/12/2010 1:20 PM, fun and learning wrote: Hi All - I am trying to do the following: script language=text/javascript function abc(arg1, arg2) { cfquery name=q datasource=.. select * from table1 where col1 = arg1 /cfquery .. }

Re: CF Site not load - only show HTTP header

2010-10-12 Thread Ian Skinner
On 10/12/2010 3:25 PM, Bryan Stevenson wrote: While I don't have an answer for you, I'd suggest the user try the site from another location (perhaps from home)helps eliminate an office firewall as the culprit or simply an issue of different DNS servers being used from office/home Good

Re: Reading text files

2010-10-01 Thread Ian Skinner
On 10/1/2010 8:32 AM, Dave Watts wrote: No, CF isn't that low-level. But you could do this in Java, then call your Java class from CF. I've found fileSeek () and FileSkipBytes (), that might do the trick. Well then, I was wrong. CF is that low-level in this case! Oh CF, is there

Re: arrays and looping around

2010-09-27 Thread Ian Skinner
On 9/27/2010 7:37 PM, Michael Grant wrote: #form['ExpOrg_ID_' loopCount]# A.K.A. Array Notation and can be applied to any variable scope, not just the form scope, though that is probably the most common. ~| Order the

Re: 3 layers of validation?

2010-09-23 Thread Ian Skinner
On 9/23/2010 7:01 AM, Rick Root wrote: If someone finds your database and executes a stored procedure, you've got *WAY* bigger problems than application coding. Not necessarily. The someone just may be some future developer that has been tasked to do something new with all this great data

Re: cfquery not returning results with apostrophe

2010-09-16 Thread Ian Skinner
On 9/16/2010 6:44 AM, Richard White wrote: thanks for the replies, although the preserveSingleQuotes doesnt work You should be looking at the actual SQL that is being sent to the database. It would be provide clear evidence of what is wrong. Looking at this line: cfset havingClause =

Re: Rounding Numbers

2010-09-16 Thread Ian Skinner
On 9/16/2010 7:37 AM, Jeanmarie Richardson wrote: Hi -- I need to round numbers consistently to the highest 1000. Is there a CF Function that will do this? Combined with some basic math, yes. cfoutput#ceiling(4397/1000) * 1000#/cfoutput Replace the literally value '4397' with useful

Authorization and Security for a web service

2010-09-03 Thread Ian Skinner
I do enjoy when I get to branch out and do things I've never done before. We are getting deep into the planning stage of a new project that will be a web service to be consumed by an outside agency to integrate their data systems with ours. We will want there to be security and

Re: Function to Output a query as an ol or ul

2010-08-26 Thread Ian Skinner
I *THINK* what you are trying to do is a classic problem for a recursive function. Create a function that handles one level of your list with the proper ul and li tags. Then for each record inside the logic for the li... test to see if there is another level, if so call the same function.

Re: Journaling

2010-08-19 Thread Ian Skinner
cfloop collection=form item=field cfoutput#form[field]#cfoutput /cfloop cfloop query=query cfloop list=#query.columinlist# index=column cfoutput#query[column]#/cfoutput /cfloop /cfloop But I think if I was in your shoes, I would be looking at a database solution. Something done with

Regex question

2010-08-19 Thread Ian Skinner
I need to turn some relative links into absolute links in a string. I have this rereplace() working well to do that. rereplace(links,'(href=)([^]*)','\1http://www.cdpr.ca.gov\2','ALL') But there is one link in the string that is already absolute going to a different domain. Is there an

Re: Regex question

2010-08-19 Thread Ian Skinner
On 8/19/2010 8:32 AM, Ian Skinner wrote: I need to turn some relative links into absolute links in a string. I have this rereplace() working well to do that. rereplace(links,'(href=)([^]*)','\1http://www.cdpr.ca.gov\2','ALL') Thank you Ian, adding the forward slash[/] character in two

  1   2   3   4   5   6   7   8   9   10   >