Re: Creating columns that aren't included in a query result

2014-12-11 Thread Steve Milburn
Start by showing us the code your using to display the results of your query. On Thu, Dec 11, 2014 at 10:13 AM, Torrent Girl moniqueb...@gmail.com wrote: Steve now my output is off. How do I handle that? (I wish I could attach images to my posts) Your task shouldn't be to handle values

Re: cfmail causing problems for our server

2014-12-10 Thread Steve Milburn
Amazon SES was made for just this type of scenario. On Wed, Dec 10, 2014 at 1:23 PM, Dave Long d...@northgoods.com wrote: My customer's site allows interested visitors to subscribe to intermittent e-mail notifications regarding his annual event. My hosting provider tells me that use of

Re: Creating columns that aren't included in a query result

2014-12-10 Thread Steve Milburn
Your task shouldn't be to handle values that were not returned from the query. You need to think of a way to make sure they are returned. You should be able to accomplish that by using case statements in your query. Syntax may vary depending on your database, but should be something like this

Re: Creating columns that aren't included in a query result

2014-12-10 Thread Steve Milburn
If you implement the query syntax I sent earlier you will have a 0 in the disagree column. On Wednesday, December 10, 2014, Torrent Girl moniqueb...@gmail.com wrote: I am looking for how many people answered disagree etc. BUT, if no one answered disagree I want to be able to put a 0 in

Re: Alternative to shared SMTP server

2014-10-30 Thread Steve Milburn
Maybe Amazon SES? I haven't used it in a CF project so I can't speak to that specifically, but I did use it in a Node.js project and it was a piece of cake. Steve On Thu, Oct 30, 2014 at 4:22 AM, Kevin Parker tras...@internode.on.net wrote: Has anyone had any experience using Send Grid (or

Re: Alternative to shared SMTP server

2014-10-30 Thread Steve Milburn
Good to know, Dave. I figured there wouldn't be any problem using it from CF, but just couldn't speak to it from experience. On Thu, Oct 30, 2014 at 9:17 AM, Dave Watts dwa...@figleaf.com wrote: Maybe Amazon SES? I haven't used it in a CF project so I can't speak to that specifically, but

Re: CFHTTP connection failure

2014-09-11 Thread Steve Milburn
A few questions... first can you show us some code? Second, are you sure it is SFTP and not FTPS? What happens if you try to use an SSH client like Putty? Are you able to connect? The SFTP server should be listening on port 22 - your telnet connection uses port 23 and your ftp connection uses

Re: cfheader

2014-02-10 Thread Steve Milburn
Why not put target=_blank in the a tag on the page that is linked to the pdf? Steve On Mon, Feb 10, 2014 at 9:56 AM, Rob Voyle robvo...@voyle.com wrote: Hi folks I am using cfheader name=Content-disposition value=inline;filename=#handout# cfcontent type=application/pdf

Re: How do I pass this jQuery variable as arguments to a cfc method?

2014-01-16 Thread Steve Milburn
Inside your .each loop you want to push specialID to your array like so: specialIDList.push (specialID). Afterwards when you are preparing your values object to be sent to the server you do specialIDList.join to put them into a string. On Jan 16, 2014 12:32 PM, Rick Faircloth

Re: How do I pass this jQuery variable as arguments to a cfc method?

2014-01-16 Thread Steve Milburn
??? On Thu, Jan 16, 2014 at 12:50 PM, Steve Milburn scmilb...@gmail.com wrote: Inside your .each loop you want to push specialID to your array like so: specialIDList.push (specialID). Afterwards when you are preparing your values object to be sent to the server you do specialIDList.join

Re: cfqueryparam issue

2013-02-08 Thread Steve Milburn
Try to encode the string to base64 before adding it to the db. So it becomes cfqueryparam value=#toBase64(conNote)# cfsqltype=cf_sql_varchar /. When you read the data back out of the db, convert it back to a string like so: #toString(toBinary(field_name))# HTH Steve On Fri, Feb 8, 2013 at

Re: cfqueryparam issue

2013-02-08 Thread Steve Milburn
What if you try to encode it prior to the cfqueryparam tag? cfset tmp = toBase64(CovNote) / cfqueryparam value=#tmp# cfsqltype=cf_sql_varchar / On Fri, Feb 8, 2013 at 12:02 PM, Stephens, Larry V steph...@iu.edu wrote: Thanks - but same error. -Original Message- From: Steve

Re: Difficulty in creating a dynamic query

2013-01-22 Thread Steve Milburn
If you just output the sqlStatement variable, how does it look? Also, any particular reason you are not just building your sql statement inside the cfquery tags? On Tue, Jan 22, 2013 at 3:33 PM, Tom McNeer tmcn...@gmail.com wrote: Hi, I need to build up a complex dynamic query statement.

Re: Lite CFML Editor

2013-01-11 Thread Steve Milburn
You may want to take a look at Brackets - http://brackets.io ~Steve On Thu, Jan 10, 2013 at 7:29 PM, John M Bliss bliss.j...@gmail.com wrote: Hi! Quick poll: I'd like to install a lite, free, CFML editor onto a computer (not my main computer) where the editor is suitable for me to use my

Re: cfftp with SSL (Coldfusion 8)

2012-12-20 Thread Steve Milburn
Really? I've used CF8 with Bitvise and Tumbleweed sFTP servers for a while and it works a treat. I used a blog post by Ben Nadel as a guide: http://www.bennadel.com/blog/1337-My-First-ColdFusion-8-CFFTP-Experience-Rocky-But-Triumphant.htm Anyway, this doesn't address the initial question of

Re: SOT: jquery hide

2012-12-16 Thread Steve Milburn
Try giving your div a class that includes display=none. This will prevent it from being displayed while the page is initially rendered. You can then remove that class in your document.ready() function. HTH Steve On Sunday, December 16, 2012, John M Bliss wrote: Hi! I'm using jquery to

Re: SOT: jquery hide

2012-12-16 Thread Steve Milburn
My personal preference would be to use the display CSS attribute instead of visibility. Also, I would include that setting in a different class that I will not need after the page loads, say myHiddenDiv. Finally, utilize jQuery chaining so you don't have to scan the DOM twice. So your code

Re: SOT: jquery hide

2012-12-16 Thread Steve Milburn
() functions use the display attribute and not the visibility attribute. Not long ago I switched over from using Prototype to jQuery and had to recode hidden divs to use those jQuery functions. On 12/16/12 12:38 PM, Steve Milburn wrote: My personal preference would be to use the display CSS

Re: Opening a template in CF Studio from an HTML link

2012-11-26 Thread Steve Milburn
ColdFusion code runs on the server. Nothing you write in CF is ever processed by a client or web browser. Your cfexecute is attempting to run cfstudio45.exe on the server. To accomplish what you want you will have to send the html files to the user in such a way that they are not rendered by

Re: Multiple Application Files

2012-10-25 Thread Steve Milburn
I needed a solution for this exact problem. I developed a set of web services that applications call in onApplicationStart(). These web services contain functions for, among other things, determining the current school year and marking period based on the current date. -Steve On Wed, Oct

Re: Modern (and free) html/cf editor that is similar to Homesite?

2012-08-13 Thread Steve Milburn
Sublime Text 2 is not free. -Steve On Monday, August 13, 2012, Kym Kovan wrote: Nobody has mentioned Sublime Text 2 http://www.sublimetext.com/2 a superb editor, a natural if you are moving on from Homesite On 14/08/2012 00:15, Pete Ruckelshaus wrote: I teach web design and web

Re: Session variables not working

2012-02-27 Thread Steve Milburn
Have you enabled session management in the application.cfc? On Mon, Feb 27, 2012 at 3:14 PM, Rick Faircloth r...@whitestonemedia.comwrote: It's been awhile since I used session variables, but this is simple. Why won't this work? session-test.cfm cfset session.name =

Re: Session variables not working

2012-02-27 Thread Steve Milburn
Message- From: Steve Milburn [mailto:scmilb...@gmail.com] Sent: Monday, February 27, 2012 3:18 PM To: cf-talk Subject: Re: Session variables not working Have you enabled session management in the application.cfc? On Mon, Feb 27, 2012 at 3:14 PM, Rick Faircloth r

Re: Session variables not working

2012-02-27 Thread Steve Milburn
Correction on my previous post: The variable was stored in variables.session.name (not variables.session.rick)... but you probably knew what I meant.. ;-) On Mon, Feb 27, 2012 at 3:39 PM, Steve Milburn scmilb...@gmail.com wrote: You will need an application.cfc (or .cfm) for session

Re: cfajax error

2011-11-11 Thread Steve Milburn
Have you tried to quote the last item in the values list (the year)? Depending on how that is defined in the database, it may require quotes. Instead of: #year(foodate)# Try: '#year(foodate)#' HTH Steve On Fri, Nov 11, 2011 at 1:22 PM, Greg Morphis gmorp...@gmail.com wrote: Same error..

Re: Disable submit button after CFFORM validation?

2011-11-07 Thread Steve Milburn
Sounds like you are using CFForm. I haven't used CFForm for years, but I seem to recall a submitonce validation parameter when using cfinput type='submit' /. Maybe check into that. HTH. Steve On Mon, Nov 7, 2011 at 1:36 PM, John Pullam jpul...@mcleansystems.comwrote: I can disable a

Re: Wysiwyg editor

2011-10-25 Thread Steve Milburn
You can customize the ckEditor toolbar and remove the Paste button, leaving only the Paste From Word option available. On Tue, Oct 25, 2011 at 9:30 AM, Rick Faircloth r...@whitestonemedia.comwrote: As one who has never wanted to give (or actually given) so much aesthetic control over

Re: Session Variables

2011-10-18 Thread Steve Milburn
What is the maximum time-out period defined for memory variables on your server? By default session variables have a maximum timeout period of 20 minutes. You can manually specify a timeout of something less than that value, but nothing more. If you want your sessions to timeout in 14 days,

Re: SQL grrr

2011-09-26 Thread Steve Milburn
I'm sure there is a much more efficient way of doing this, but this would work: SELECT distinct ID from table where id in (select ID from table where val = 'A' and id in (select id from table where val = 'B' and ID in (select id from table where val = 'C'))) On Mon, Sep 26, 2011 at 1:18 PM,

Re: giving users a selection of email type

2011-08-04 Thread Steve Milburn
There are some RegEx solutions for stripping HTML tags from a string. You could have a single email containing the tags, but before you send it, check to see if the user prefers plain and if so, run it through the RegEx. Steve On Thu, Aug 4, 2011 at 3:11 PM, Greg Morphis gmorp...@gmail.com

Re: giving users a selection of email type

2011-08-04 Thread Steve Milburn
Maybe I misunderstood the question, but this still seems to require the management of 2 blocks of texts, which I thought is what the original poster was trying to avoid. Using RegEx to strip all HTML markup, only 1 block of text needs to be maintained. Steve On Thu, Aug 4, 2011 at 3:25 PM,

Re: COMPLEX SQL RANDOM

2011-08-03 Thread Steve Milburn
Since the query you have gives you the list of polls that you want, what about dumping the results of that query into a temp table, and doing a random select on the temp table with SELECT TOP 1 and ORDER BY NEWID() ? Steve On Wed, Aug 3, 2011 at 2:43 PM, Robert Harrison

Re: COMPLEX SQL RANDOM

2011-08-03 Thread Steve Milburn
The error message you are getting is because the value of your order by clause, newID(), is not a part of your list of values you are selecting. You could, of course, include it in your list of values by first setting it to a variable, like so: declare @orderClause as uniqueidentifier; set

HOF Site

2011-05-20 Thread Steve Milburn
Just an alert to those who maintain the HOF site (Michael?) - It looks like it's been hacked. Anyone else seeing something unexpected when view the main page? I can navigate to directly to some other pages fine, but the front page (www.houseoffusion.com) has been compromised. Steve

Re: ColdFusion and AJAX choices

2011-05-19 Thread Steve Milburn
So you typically generate the HTML for an ajax call on the server side and send that back to the browser? From a person who is concerned about that extra second and the size of the jQuery library, this approach seems a little contradictory as those ajax responses have to be bloated due to all

Re: scoping

2011-05-18 Thread Steve Milburn
Ray Camden has blogged about this in the past, as you can read here: http://www.coldfusionjedi.com/index.cfm/2011/1/26/ColdFusion-and-Unscoped-Variables In summary, there are theoretical performance gains by scoping all variables and there are some security concerns by not scoping vars. Both are

Re: SOT: jQuery help

2011-04-15 Thread Steve Milburn
Try this: function jqCheckAll2(id,name) { $(input[name=' + name + ']).each(function() { $(this).attr(checked,true); }) } Hope this helps Steve On Fri, Apr 15, 2011 at 12:20 PM, Greg Morphis gmorp...@gmail.com wrote: I have a page with a bunch of groups of checkboxes. I'm trying to

Re: What's everybody using?

2011-04-13 Thread Steve Milburn
+1 for highcharts. Been using that on my latest project and I'm very pleased. There is a bit of a learning curve (for me) as I've struggled occasionally trying to figure out how to pass data to the chart on the fly, but once I've figured it out it makes sense. Steve On Wed, Apr 13, 2011 at

Re: The vagaries of QueryNew

2011-03-23 Thread Steve Milburn
Can you show us some code? On Wed, Mar 23, 2011 at 7:18 AM, Kevin Parker tras...@internode.on.net wrote: I have a query where I need to add some extra stuff not in the database so decide to create another query object with QueryNew. I loop over a query of the table to set cell values and

Re: jQuery and Session Timeout

2011-03-21 Thread Steve Milburn
...@gmail.com wrote: I don't think your issue is 1.4.2 versus 1.5. Did you read the followup linked to from the article? http://www.coldfusionjedi.com/index.cfm/2010/9/15/Handling-session-timeouts-in-Ajax-applications--Follow-up On Fri, Mar 18, 2011 at 10:14 AM, Steve Milburn scmilb...@gmail.com wrote

jQuery and Session Timeout

2011-03-18 Thread Steve Milburn
Hello all. I've been using the technique detailed in a blog post by Ray Camden ( http://www.coldfusionjedi.com/index.cfm/2010/9/8/Example-of-handling-session-time-outs-in-an-Ajax-application) to detect a session timeout during an ajax request and take appropriate action. This has been serving

jQuery and Session Timeout

2011-03-18 Thread Steve Milburn
Hello all (sorry if this is posted twice...) I've been using the technique detailed in a blog post by Ray Camden (http://www.coldfusionjedi.com/index.cfm/2010/9/8/Example-of-handling-session-time-outs-in-an-Ajax-application) to detect a session timeout during an ajax request and take appropriate

Promote ColdFusion - Nettuts.com

2011-02-11 Thread Steve Milburn
Hi Folks. I came across this article on Nettuts http://net.tutsplus.com/articles/news/language-wars-sign-up/. Perhaps this may be a fun and beneficial exercise for some of our senior CF evangelists out there... Ben? Ray? I'd hate to see this pass without CF being represented. Each team can

Re: Watermarking images

2011-02-03 Thread Steve Milburn
If you are running a version of CF that supports cfimage, have a look at this http://www.bennadel.com/blog/775-Learning-ColdFusion-8-CFImage-Part-III-Watermarks-And-Transparency.htm On Thu, Feb 3, 2011 at 11:14 AM, wabba must...@wabba.net wrote: Anyone have a good tool for watermarking images

Re: multiple Application.cfcs

2011-01-20 Thread Steve Milburn
Greg I would advise against using multiple application.cfc within the same site. You're best approach may be to define a single application.cfc at the root of your site, and use that single application.cfc to check if a user is attempting to access a protected folder and take appropriate

Re: Bind issues - observation

2010-09-03 Thread Steve Milburn
Check out Firebug Lite that works among all major browsers, including IE - http://getfirebug.com/firebuglite http://getfirebug.com/firebuglite On Fri, Sep 3, 2010 at 11:18 AM, Stephens, Larry V steph...@indiana.eduwrote: I'm sure this isn't news to most of you but perhaps there are one or two

Re: Journaling

2010-08-19 Thread Steve Milburn
I'm not sure what database you are using, but SQL Server 2008 has a built-in option for change tracking. You simply specify which table(s) you want to monitor, and SQL Server will automatically track any changes to those tables. On Thu, Aug 19, 2010 at 10:02 AM, Stephens, Larry V

Re: CFQUERY Question

2010-03-31 Thread Steve Milburn
You are correct, the record count for an empty query object does exist (and should be 0). What exactly is not working? Are you getting an error message? On Wed, Mar 31, 2010 at 1:59 PM, Dave Sueltenfuss dsueltenf...@gmail.comwrote: I'm running into an odd behavior with CFQUERY (at least I

Re: Scheduled Task Running twice

2010-01-13 Thread Steve Milburn
We had this problem a long time ago and I don't remember the exact details, but it happened after an upgrade if I remember correctly. The problem, I believe, was that we had 2 versions of CF running that were each running the tasks. I disabled the older CF service and all was well again. So I

Re: (ot) SQL Guru Needed

2010-01-13 Thread Steve Milburn
How about this: Select min(optprice) as minprice, max(optprice) as maxprice fromoptions where optID in (select optID fromproductOptions where productID = cfqueryparam value=#pid# cfsqltype=cf_sql_integer) On Wed, Jan 13, 2010 at 11:02 AM, Che Vilnonis ch...@asitv.com wrote:

Re: cfcontent with excel 2007

2010-01-04 Thread Steve Milburn
I have not tried this, but what if you change the cfcontent type to unknown? Like so: cfcontent type=unknown cfheader name=Content-Disposition value=filename=report.xlsx On Thu, Dec 31, 2009 at 2:37 AM, Christophe Maso zum...@hotmail.com wrote: Have seen a few posts around the web with

Re: Missing Form Fields

2009-11-10 Thread Steve Milburn
Do you have other types of inputs on the page than text inputs? If no option is selected for radio buttons and checkbox inputs, then nothing is submitted to the processing page. Also, you must be passing a list of field names to the processing page somehow, maybe via a hidden input. You could

Re: javascript and coldfusion

2009-10-20 Thread Steve Milburn
I think you'll find a lot of varying opinions on which library is best, but the only way you're going to be able to make the decision that works best for you is to get your hands dirty with several different libraries and decide for yourself. Personally, I started with Spry and have since moved

Re: javascript / coldfusion ajax communication

2009-09-29 Thread Steve Milburn
Richard In your js, use encodeURIComponent on any user entered data to properly encode the string. Have a look at the CF function URLDecode on the backend if CF doesn't properly decode your string automatically. Steve On Mon, Sep 28, 2009 at 9:31 AM, Richard White rich...@j7is.co.uk wrote:

cfwindow binding

2007-12-06 Thread Steve Milburn
I am attempting to bind a url parameter for a cfwindow to a text input box. The value for the input box is set programmatically. The first time the window is displayed it properly binds to the value that has been set in the input box (the value is not set at load time, but when a certain

See cfwindow contents on page load

2007-12-04 Thread Steve Milburn
Hi all I'm using cfwindow and defining the HTML elements inside the cfwindow tags - in other words, I'm not using the src= attribute. The problem is that as the page is being rendered, I can see the contents of the cfwindow. Once the page completes loading, the contents are hidden (as they

RE: CFLayout and Spry

2007-11-29 Thread Steve Milburn
Hi Dave I actually tried using just content and full HTML code but could get neither to work. However, I was unaware of the cfhtmlhead tag. That looks like it may be pointing me in the right direction. I tried it and I'm still having problems. Here is the code on the spry page: cfsavecontent

RE: CFLayout and Spry

2007-11-29 Thread Steve Milburn
. The parent page is already loaded, how would cfhtmlhead on the page being called when the tab is selected insert it's content into the head of the page already loaded? Am I making any sense? -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29

RE: CFLayout and Spry

2007-11-29 Thread Steve Milburn
to double check your code. On Nov 28, 2007 8:25 PM, Steve Milburn [EMAIL PROTECTED] wrote: Hi all I'm using a tabbed cflayout. The source for a particular tab points to a page that uses spry. When viewed on its own, the spry page works fine, but it does not work in the cflayout. Apparently

CFLayout and Spry

2007-11-28 Thread Steve Milburn
Hi all I'm using a tabbed cflayout. The source for a particular tab points to a page that uses spry. When viewed on its own, the spry page works fine, but it does not work in the cflayout. Apparently there are issues with using spry and cflayout like this. Has anyone successfully

Globalization Question

2007-11-17 Thread Steve Milburn
Hi folks I am developing an applications that is eventually going to required support for multiple languages.  I'm new to I18N, etc, and have a question I'm hoping somebody gave help with.  Based on what I'm reading in the CFWACK books and by various posting on Paul Hastings blogs and articles

Re: Globalization Question

2007-11-17 Thread Steve Milburn
Hi Paul Thanks for the response.  I'm obviously new to this, but in response to your questions (1) would the process of managing translations for a db be that much different than managing translations for resource bundle properties files?  (2) I'm certainly not trying to re-invent the wheel,

Re: cfsprydataset JSON question

2007-11-09 Thread Steve Milburn
It looks like the field names being returned are in all-caps, and the your bindings are not.  Try to capitalize your bindings in your spry output, ie {FNAME} and {LNAME}. Steve -Original Message- From: Dan Vega [EMAIL PROTECTED] Sent 11/9/2007 6:45:30 PM To: CF-Talk

Re: Archiving SQL table data

2007-09-21 Thread Steve Milburn
What database are you using?  Any enterprise DBMS is built to handle millions of records.  If its running on decent hardware there should be no problem.  Given your scenario, there seems to be no reason to worry about archiving your data into other tables.  20k-40k records is nothing. Steve

RE: need help with updating date field

2007-05-30 Thread Steve Milburn
The word Date is a reserved word. It is good practice to avoid naming fields with a reserved word. In this case, wrap it in hard brackets such as [date] = '#createODBCDate(now())#' HTH Steve -Original Message- From: Imperial, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May

RE: How to Random Pick records from a 10k record table via SQL

2007-04-02 Thread Steve Milburn
The newID() function generates a new identifier for the rows in the table. So when you order by newID(), it is ordering the records in the table by a new database generated and unique ID that will change with each query. The select top 20 is simply limiting the return to 20 records. It will not

RE: SQL Like

2007-03-30 Thread Steve Milburn
T-SQL will return every record in this case. % is a placeholder for any characters, so your query would essentially tell the database where x = any pattern of characters and would return everything. You could just run a query with that syntax in Query Analyzer or Management Studio and see for

RE: SQL Like

2007-03-30 Thread Steve Milburn
Correct - I should have stated that in my original email. Thanks for the clarification. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 3:48 PM To: CF-Talk Subject: Re: SQL Like Steve Milburn wrote: T-SQL will return every record in this case

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-20 Thread Steve Milburn
I really wish this thread would just die, but before it does I'll add my $0.02 ;-) . I'm not sure anyone is suggesting that a client would chose not to go with CF because somebody in the porn industry is using it. I really don't think that is the basis of the argument. I simply think people

Re: @@identity

2007-03-19 Thread Steve Milburn
Mik Muller wrote: For years I've been using SELECT @@IDENTITY AS ID in my code to get the record ID for a newly inserted record. And now I'm wondering... would this, or something similar, work inside an insert statement? I'm working on some insert code right now and one of the fields is a

IIS Scripts

2007-03-13 Thread Steve Milburn
Hi Folks Sorry if this is too OT. I am looking for a script that can add a MIME type for IIS 6 for a specific web site. I can find scripts that will add MIME types for the IIS server, but not just for a specific web site. Anyone out there have or know where I could find a script to do

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-05 Thread Steve Milburn
Rey Bango wrote: Okay, so we have 1 vote yes, 2 votes no. Rey... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive:

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-05 Thread Steve Milburn
. Steve -- Steve Milburn Allegany County Public Schools 108 Washington Street Cumberland, MD 21502 301.759.2045 301.759.2019 (Fax) --- --- ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new

Re: Wtf time: name can't be empty??

2007-02-28 Thread Steve Milburn
Damien McKenna wrote: OK. Major confusion here with something that should be drop-dead simple. CFMX 6.1 hitting a SQL Server 2000 server. cfquery name=msg_details datasource=#application.dsn# select title, content from content_misc_text where

Re: Wtf time: name can't be empty??

2007-02-28 Thread Steve Milburn
I just looked it up - name does not seem to be a reserved word in SQL Server 2000, but it still may be worth a shot to enclose it in brackets (like Mik suggested as well). Steve Damien McKenna wrote: OK. Major confusion here with something that should be drop-dead simple. CFMX 6.1

Secure CFIDE

2007-02-24 Thread Steve Milburn
Hi all What do most people do to secure their CFIDE directory? How do you prevent people from going to http://your_server_ip/cfide/administrator and trying to hack your server? I've read various methods such as moving the cfide folder, or having it only accessible by using ColdFusions

Re: SQL Enterprise Manager equivalent for 2005

2007-02-24 Thread Steve Milburn
Mike | NZSolutions Ltd wrote: Hi guys, Did a bit of research on this topic, but a little confused. What should I be using as an enterprise manager equivalent for sql server 2005 (hosted at my webhost). I wish to be able to connect to the db and create/organise tables - including reordering

Re: SQL Enterprise Manager equivalent for 2005

2007-02-24 Thread Steve Milburn
I'm not sure this came through properly the first time so here it goes again... sorry if this is a duplicate post. In SQL Server 2005, the Enterprise Manager has been replaced with the SQL Server Management Studio. There is a version called SQL Server Management Studio Express Edition that is

Re: programmatically create an Access Datasource

2007-02-03 Thread Steve Milburn
Have you looked at the new Administrator API? It should do everything you need regarding adding, deleting, and modifying datasources. Specifically, look at the datasource.cfc component. I dont know what version of CF your running, but it is only available in CF 7. The components are

Re: Flash Forms size limit

2007-01-11 Thread Steve Milburn
Jacob I had this problem as well when developing a complex flash form. That blog entry is accurate (as long as you have applied the latest CF updates). You may come across this problem again down the road, but every time it happened to me it always went away after adding some more code and/or

Re: Flash Forms size limit

2007-01-11 Thread Steve Milburn
. -- Steve Milburn Allegany County Public Schools 108 Washington Street Cumberland, MD 21502 301.759.2045 301.759.2019 (Fax) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http

Session variables

2006-12-13 Thread Steve Milburn
Hi all, Just a quick question. When is it necessary to pass the session information for a user in the URL as that user navigates a site? If I remember correctly, some of this depends on whether cookies are enabled on the browser and whether J2EE session variables are enabled. Can anyone

Re: Wierd IE 7 issue

2006-12-12 Thread Steve Milburn
I would not hold my breath. I have noticed this behavior on IE 6 as well. Steve Bruce Sorge wrote: Cool, so I am not the only one. I am sure that M$ is aware of this and hopefully will issue a fix. On 12/12/06, Jake Churchill [EMAIL PROTECTED] wrote: I encountered the same thing when I

Re: cftry and transactions

2006-10-30 Thread Steve Milburn
/cftry Lori -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 14:50 To: CF-Talk Subject: cftry and transactions Hi folks Can anyone tell me what is wrong with the following code? It is a snippet of code from a cfc I am working

Re: cftry and transactions

2006-10-30 Thread Steve Milburn
Maya I tried something similar to what you are showing as suggested by somebody earlier in the thread. Same result. By the way, the fact that the commit occurs before the catch should not be an issue (should it?). If there is an error above the commit statement, it will jump over the

Re: cftry and transactions

2006-10-30 Thread Steve Milburn
Doug I thought that too, so I commented out the stored proc and just ran through the queries inside the loop.nbsp; Same problem - if the loop fails on query #3, queries 1 and 2 are still recorded in the DB.br Douglas Knudsen wrote: I'd bet your SP is performing a commit. DK --- ---

cftry and transactions

2006-10-26 Thread Steve Milburn
Hi folks Can anyone tell me what is wrong with the following code? It is a snippet of code from a cfc I am working on. The problem I am having if that if one of the queries inside the loop fails for whatever reason (ie, db constraint error), the previous inserts are not removed from the db.

Re: cftry and transactions

2006-10-26 Thread Steve Milburn
running CF7 and SQL Server 2005. thanks Steve Milburn wrote: Hi folks Can anyone tell me what is wrong with the following code? It is a snippet of code from a cfc I am working on. The problem I am having if that if one of the queries inside the loop fails for whatever reason (ie, db

Flash Forms - Combo Box Help

2006-07-19 Thread Steve Milburn
Hi Folks I am using flash forms and have a combo box control. I am binding it to the results of a query which returns several fields. Obviously, I want to select 1 field to be the field that is displayed in the combo box and another field to be the value for the selected item (without

Weird cfdocument issue

2006-05-24 Thread Steve Milburn
I've just spent the last 30 minutes experiencing a strange issue with cfdocument. I've figured out the problem, but perhaps somebody here can explain why this happens. I had a dev server setup that I normally access just by IP address. I have a number of pages that use cfdocument to generate

Re: Hiding Files from a client with access

2006-05-12 Thread Steve Milburn
Really Dave? I'll take your word for it, but I thought the opposite was true. If somebody is paying you to write code, then the code is theirs unless you have a written agreement to the contrary. At least that's the way I understood it. I'm probably wrong though. Steve dave wrote: Les,

ColdFusion ISP Project

2006-03-29 Thread Steve Milburn
I need to come up with a project for a class I am taking, and thought starting up a fictitious ColdFusion ISP company might be something fun and a good learning experience. I've written a fair amount of CF code, but everything I have done is hosted on our own servers for our intranet. I

Re: CFIF and null values

2006-03-24 Thread Steve Milburn
What is the data type of the field in the database? If it is a char, it could be an empty string of the length of the field specification, ie char(10). In which case, adding a trim to the function should work - trim(len(expr3)) eq 0 Steve Richard Colman wrote: I have a null value being

Re: OT: Typing Service

2006-03-13 Thread Steve Milburn
Rick My wife has done some of this in the past. If your interested, contact me off list. Steve Rick Root wrote: Anyone out there ever used any cheap typing services? I have a 60 page PDF document that was scanned quite poorly (ie, the lines are crooked) that I need turned to electronic

Re: Flash form popup window

2006-03-12 Thread Steve Milburn
getURL(put your url in here to your cfm page); Need to use the quotes :) - Original Message - From: Steve Milburn To: CF-Talk Sent: Friday, March 10, 2006 1:25 PM Subject: Flash form popup window Can anyone point me in the right direction for creating

Re: Flash form popup window

2006-03-10 Thread Steve Milburn
:) - Original Message - From: Steve Milburn To: CF-Talk Sent: Friday, March 10, 2006 1:25 PM Subject: Flash form popup window Can anyone point me in the right direction for creating a popup window when using flash forms? I am looking for similar functionality to what Ben

Re: Flash form popup window

2006-03-10 Thread Steve Milburn
Hi Kevin Thats what I'm looking for. I am displaying a flash form. When a button is clicked, I want to display another flash form (contained in another cfm template) as a popup. I am using the popup manager class, and get a popup window. However, I cant get it to display my other form. I

Re: CFFORM Flash form

2006-03-09 Thread Steve Milburn
Hi Wally. Check the archives. This has come up a few times in the last couple months. The most complained about aspect is speed. I am currently working on a project using flash forms and have noticed some other things that I (and some users) dont really like. I'm very much a novice at it,

Flash form popup window

2006-03-09 Thread Steve Milburn
Can anyone point me in the right direction for creating a popup window when using flash forms? I am looking for similar functionality to what Ben Forta has on his web site for submitting a review for an ISP. It creates a new window with a new form allowing you to complete the review. I've

Re: In Theory - Database Table Layout Questions

2006-03-05 Thread Steve Milburn
The only thing I think I would change is you don't need the surveyID in the SurveryAnswers table. Since you have the questionID, and the SurveyQuestions table ties back to the SurveyMaster table, you can join those tables (which you would most likely be doing any when displaying the results)

  1   2   >