Re: SOT: Canadian CF Hosting

2010-09-29 Thread Jim Wright
On Wed, Sep 29, 2010 at 10:45 AM, Larry Lyons larrycly...@gmail.com wrote: Pardon for the slightly off topic posting, but I thought I'd try the collective wisdom of the list here. Anyhow this is a favour I'm doing for a colleague. He's looking for a  Canadian web hosting firm that offer CF

cfreport rtf images

2009-05-28 Thread Jim Wright
I have a cfreport that needs to have images in the footer. The images are working fine if I output the report in PDF or Flashpaper, but don't show up in RTF or Excel (RTF is the needed output). Things I've tried: -using URLs, file paths, and blobs from the db...same result with each -using

Re: cfreport rtf images

2009-05-28 Thread Jim Wright
OK, I answered part of my own question. The RTF output has a empty box placed over the image for some reason (I mistakenly thought that was its attempt to show the image). Now to figure out how to have it not show that box. On Thu, May 28, 2009 at 9:08 AM, Jim Wright wright...@gmail.com wrote

Re: cfreport rtf images

2009-05-28 Thread Jim Wright
Final answer, if anyone ever has this issue: There is a Transparency attribute that defaults to Opaque on the image object. In Flashpaper and PDF, the image shows up with that set...in RTF, it puts a box over top of it. ~|

Re: SQL Help

2008-09-16 Thread Jim Wright
On Tue, Sep 16, 2008 at 8:58 AM, Jeff F [EMAIL PROTECTED] wrote: I've got a table (MySQL) with about 20k records. I'd like to be able to get all fields from the table with distinct email addresses. Essentially, I'm weeding out records with duplicate email addresses. What I'm trying does not

Re: SQL Help

2008-09-16 Thread Jim Wright
On Tue, Sep 16, 2008 at 10:13 AM, Jeff F [EMAIL PROTECTED] wrote: SELECT distinct mytable.email FROM mytable I get 19588 as a recordcount. This number would include email addresses that are duplicated in the table (but only a count of 1 for each distinct address). SELECT

Re: Trying to use cfexecute to run batch file...

2008-09-06 Thread Jim Wright
On Sat, Sep 6, 2008 at 8:17 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Trying the cfexecute this way didn't work, either: cfexecute name=c:\windows\systems32\cmd.exe arguments=/c e:\adobe_site\getfiles.bat timeout=30 /cfexecute I'm guessing the context of the cfexecute is

Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...

2008-07-24 Thread Jim Wright
On Thu, Jul 24, 2008 at 10:52 AM, Claude Schneegans [EMAIL PROTECTED] wrote: It may be a silly question, but why a SELECT * will brake because an unused column was dropped? It shouldn't make a difference if the SELECT * is in a cfquery (though that is bad practice, too), but if it is in a

Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...

2008-07-24 Thread Jim Wright
On Thu, Jul 24, 2008 at 11:20 AM, Claude Schneegans [EMAIL PROTECTED] wrote: A very particular situation though. Perhaps, but the following demonstrates how this kind of issue can be even more problematic when the table is changed in such a way that no error is thrown by the view... CREATE

Re: SOT: Load testing software for website with AD integrated authentication

2008-07-23 Thread Jim Wright
On Wed, Jul 23, 2008 at 3:18 PM, Burns, John D [EMAIL PROTECTED] wrote: Can anyone confirm this or point us toward a product that does it? This may do what you need http://www.iis.net/downloads/default.aspx?tabid=34g=6i=1466

Re: Embedded YouTube movies

2008-04-21 Thread Jim Wright
On Mon, Apr 21, 2008 at 10:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below.

Re: Embedded YouTube movies

2008-04-21 Thread Jim Wright
On Mon, Apr 21, 2008 at 2:34 PM, Torrent Girl [EMAIL PROTECTED] wrote: Is that all of your code? If not would you mind posting it all. The code that I am using is very similar to the code you postedit just makes sure to use the correct URL.

Re: OT - Database schema compare/sync tools for MSSQL

2008-04-13 Thread Jim Wright
On Thu, Apr 3, 2008 at 11:16 AM, Gerald Guido [EMAIL PROTECTED] wrote: Does anyone know of a good tool that compares and/or syncs up Database schema's for two tables/DBs. I want to grab fresh data off of production and at the same time not have to manually update the schema for all the

Re: How to write this query?

2008-04-13 Thread Jim Wright
On Sun, Apr 13, 2008 at 8:27 AM, Kris Jones [EMAIL PROTECTED] wrote: How about something like: select sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks03, sa.list_price, (select top 1 sap.photo_filename from smlc_acr_photos sap where

Re: Search opinion needed

2008-03-26 Thread Jim Wright
On Tue, Mar 25, 2008 at 9:31 AM, Stone, Lori [EMAIL PROTECTED] wrote: We have a verity search that searches db and docs. They want to combine the results and then sort by relevance then date. I have done the combination before by just putting it in a structure. Any better ideas? You may

Re: ColdFusion: Some People Just Don't Know Any Better

2008-02-05 Thread Jim Wright
On 2/5/08, Todd Rafferty [EMAIL PROTECTED] wrote: Too late. Looks like they've already converted ( http://www.uline.com/ ). I don't think there has been any conversion there, or any CF...looking in the wayback machine, that site has been the same ASP classic stuff since around 2002...

Re: syntax issue between Access and MS SQL

2008-01-23 Thread Jim Wright
On 1/23/08, Ben Conner [EMAIL PROTECTED] wrote: SQL = SELECT Products.*, Categories.*, Manufacturers.* FROM Products, Categories, Manufacturers WHERE Products.ManufacturerID IN (Select ManufacturerID from Manufacturers WHERE Manufacturers.ManufacturerName Like '%spank%') AND

Re: IP Address to Country API

2008-01-16 Thread Jim Wright
On 1/15/08, Coldfusion Monkey [EMAIL PROTECTED] wrote: Just wondering if you guys are aware of any negatives in using this service like updates to db, uptime,speed etc. I've had some issues with coverage and accuracy with hostip...when I was first testing it, I had a friend in New Bern, NC

Re: ColdFusion LMS Systems

2008-01-06 Thread Jim Wright
On 1/6/08, Philip Hayes [EMAIL PROTECTED] wrote: Is anybody familiar with any SCORM Learning Management Systems (LMS) that are built in ColdFusion? The Webmentor LMS from Avilar seems to be built on CF. We use the hosted version, however, so I have not had a look at the insides.

Re: sql clear data

2008-01-04 Thread Jim Wright
On 1/4/08, Chad Gray [EMAIL PROTECTED] wrote: Is there anyway to clear the data in a row in a database without using UPDATE table SET foo = '', Moo = '', Goo = '' WHERE ID = 1 I don't want to clear the ID just the other fields. My table has 50 fields and I don't feel like typing

Re: sql question: contains space' '

2008-01-03 Thread Jim Wright
On 1/3/08, Paul Ihrig [EMAIL PROTECTED] wrote: just fond out why man this db is so messed up... 'Joe Garth ' so i would i look for NOT LIKE '% % ' OR... ltrim(rtrim(contact)) NOT LIKE '% %' ~| Adobe® ColdFusion® 8

Re: mssql pagination

2008-01-03 Thread Jim Wright
On 1/2/08, Jonathon Stierman [EMAIL PROTECTED] wrote: You can see in the All Samples section that records 20-30 should be: [147, 148, 149, 150, 63, 36, 40, 382, 383, 384]. But the Total Wrapper query returns: [146, 147, 148, 149, 150, 63, 382, 383, 384, 440]. What happened to record 40? It's

Re: cfquery order by question

2007-12-19 Thread Jim Wright
How do I get my numberic sort fields to take priority and come up first without maybe having TWO queries defined and two output blocks? Use something like ORDER BY COALESCE(sortORD,) ASC, #getPAGE.sortMETH# ~| Adobe®

Re: CFDOCUMENT creating a PDF - ARGH!

2007-12-18 Thread Jim Wright
head link rel=stylesheet type=text/css href=css/makePDF.css / /head Try an absolute path to your css file. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: Filemaker Pro

2007-12-12 Thread Jim Wright
It's possible, but the performance was horrible. You have to connect via a system ODBC (at least, on Win2k3 server) and FMP just wasn't up to the task of serving any sort of query except a direct dump. I'd suggest to the client that they move to a more internet-ready DB. I'll second

Re: SOT: ExtJS 2.0 Released

2007-12-05 Thread Jim Wright
On 12/5/07, Cutter (CFRelated) [EMAIL PROTECTED] wrote: BTW, the ExtJS 2.0 framework was officially released yesterday. I had a chance to preview this prior to public beta, and I have to say that it is spectacular. I'll second this...I've got some reports using the grid grouping and rollup in

Re: Getting a computer name by ip address.

2007-11-05 Thread Jim Wright
On 11/5/07, Ian Skinner [EMAIL PROTECTED] wrote: Earlier this year (at a different company) I created a script that would run a windows dos command that would return a computer name and other information by IP address across a cooperate LAN. I was able to run this command with cfexecute,

Re: PDF from other document format: sever side processing

2007-10-29 Thread Jim Wright
I'm tracking down my options for converting an uploaded document (variety of document formats or images) to PDF. Need to do this automatically, server side. As we're running CF8 - we can do lots of stuff to the PDF afterwards, but it's the conversion into PDF that's getting to me at the

Re: Why wouldn't the first cell alternate colors with this code?

2007-09-27 Thread Jim Wright
On 9/27/07, Rick Faircloth [EMAIL PROTECTED] wrote: Assuming all other related issues with this code are correct, why wouldn't this first cell alternate colors coded like this? The background color attribute seems to be ignored. cfif get_events.recordcount mod 2 I think you meant to use

Re: Shared Hosting vs VPS

2007-09-23 Thread Jim Wright
On 9/23/07, Rick Faircloth [EMAIL PROTECTED] wrote: The choice is between shared hosting for $30 per month or a VPS for $70 per month. Rick, If you don't mind my asking, where are you getting a Win2003/CF8 VPS for $70/month? That seems pretty low to me.

Re: charting solution for using with CF

2007-09-10 Thread Jim Wright
I got curious about whether you could output those gauge charts...and this code works, but it outputs the Developer Edition watermark on the output...even though the server is a licensed version of CF7 (the data and style were just straight from the example one in the webcharts builder)

Re: charting solution for using with CF

2007-09-10 Thread Jim Wright
A warning for anyone that might want to try the code I sent earlier. I noticed after sending it that all charts produced with cfchart on that server now had the Developer Edition watermark. Restarting CF clears it up, but as soon as I run the code that connects directly to the webcharts class, it

Re: charting solution for using with CF

2007-09-06 Thread Jim Wright
On 9/6/07, Rob Parkhill [EMAIL PROTECTED] wrote: So how does one leverage the webcharts design app? it is a cool tool which I had no idea existed until yesterday. I played around with it quite a bit and designed a couple of charts (actually the gauges are going to get me in good with the

Re: charting solution for using with CF

2007-09-05 Thread Jim Wright
On 9/5/07, Peter Tanswell [EMAIL PROTECTED] wrote: Hi there I'm trying to find a good charting tool to use with CF and also with a MSSQL database to produce graphs and also dashboard style reports/graphs. Wondering what tools software people have used for doing this. CFChart can be

Re: FCK Styles

2007-08-28 Thread Jim Wright
When I go to my browser to edit the page, I do not see this new attribute. Likewise if I remove a style that is already there, it still shows in the editor. From what I am reading I am changing the correct file. Is anyone else having similar issues? Try clearing your browser cache or doing

Re: cfimage resize running very slow

2007-08-21 Thread Jim Wright
I had done some tests recently to try to determine if I wanted to move some code over to using cfimage...here are some results. I tried to just run these tests with the defaults of each method. This was run on a shared host. Not scientific, but I don't think I will move away from Efflare quite

Re: cfimage resize running very slow

2007-08-21 Thread Jim Wright
On 8/21/07, Raymond Camden [EMAIL PROTECTED] wrote: Again though Jim - you can't just look at speed - but quality of output. Remember that Adobe erred on the side of quality over speed, but lets you change the quality to speed up performance. Very true, but if I change the interpolation on

Re: Coldfusion 8 hosting

2007-08-20 Thread Jim Wright
On 8/20/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hi: Is there any reliable Coldfusion 8 hosting server right now? I found by googling the following company but never heard of them before. http://www.bmchosting.com/features.cfm Do you know any good hosting with reasonable price which

Re: OT: SQL Manager?

2007-08-15 Thread Jim Wright
On 8/15/07, Adkins, Randy [EMAIL PROTECTED] wrote: Problem with that is, I do not run the server. It is a shared hosting server I think he as referring to using the Client Network Utility to set up a local alias. No access to the server is required. Look in your program group for EM.

Re: Need CF Studio 5

2007-08-14 Thread Jim Wright
On 8/14/07, Alan Rother [EMAIL PROTECTED] wrote: You can buy Homesite 5.5 by itself from the Adobe store for $99. https://store1.adobe.com/cfusion/store/index.cfm?store=OLS-USview=ols_catcatType=PRODUCTSnr=0 Note that this is just Homesite, not Homesite+. It does not have RDS, the CF docs

Re: cfdocument issues.

2007-08-07 Thread Jim Wright
On 8/7/07, Raymond Camden [EMAIL PROTECTED] wrote: One of the tips I learned from Dean Harmon of Adobe was to try to make your pages complete web pages. By that he meant (if I rememeber right), use everything you would in a normal HTML page: TItle, Head, Body, etc. I'll second this

Re: Adobe Nails ColdFusion Cofin

2007-08-02 Thread Jim Wright
On 8/2/07, Eric Roberts [EMAIL PROTECTED] wrote: I did look into getting RHE at one point for my dev server since that was the supported version. You cannot just download a copy of RHE without the support package. Of course, you could download the sources for RHEL and build it yourself,

Re: Adobe Nails ColdFusion Cofin

2007-07-31 Thread Jim Wright
With the price gap getting wider, maybe it's time for a third version, let's call it a Business version. That provides some of the least costly new features and provides a bridge (or stepping stone) from standard to enterprise. I think that would solve a lot of issues with this and take

Re: CF 8 and CFDOCUMENT

2007-07-27 Thread Jim Wright
Jim is your code working in 7 or 8? or both? 7 (with all updates...I believe that was necessary)...haven't tried it in 8. The code I'm using looks like what you were trying to do, except that I don't have a overall document header...the first page is just a different section.

Re: CF 8 and CFDOCUMENT

2007-07-26 Thread Jim Wright
Does anyone know if the horrendously broken CFRDOCUMENT tag actually works as advertised in CF 8? Big broken item for me was only 1 header/footer per document regardless of how many CFDOCUNTSECTIONS (even though docs said you could have a header and footer per section and not just for the

Re: SQL to Retrieve One Record from Several Possible Records

2007-06-28 Thread Jim Wright
,CASE WHEN A.addr_type IS NOT NULL THEN A.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NOT NULL THEN B.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NULL THEN C.myAddressField ELSE 'No Address Found' END AS SeasonAddress

Re: CF Editor

2007-06-26 Thread Jim Wright
2. In Home Site (a new install of HS5.5) I'm getting a warning message about every CFtag I use (not in current version) and the CF documentation no longer shows up in Home Site. Can I fix this? My guess on this is that you are running just HS and not HS+. I'm running into this as well, and

Re: cfml.exe conversion to wget

2007-06-21 Thread Jim Wright
On 6/20/07, Asad Khan [EMAIL PROTECTED] wrote: Hi All: I have an existing website that was running fine on cf5, but ever since we have moved over to CFMX7, we are having issues with CFML.exe I just found out it is not supported anymore. Here is my current code that uses the cfml. I am

Re: Query Based Verity Issue

2007-06-20 Thread Jim Wright
Thank you for your response. I would normally agree with you however in my specific case I feel I need to use verity. I neglected to mention all the other search criteria that is involved in order to simplify the question and not cause confusion. Doing a simple price range search in SQL

Re: server failover/multiple instances

2007-06-19 Thread Jim Wright
Any opinions/advice on this? On 6/18/07, Jim Wright [EMAIL PROTECTED] wrote: I am working towards beefing up our current environment, and wondered if I could get some opinions on server failover and using multiple instances. So I have: Production Site Training Site, duplication

Re: FW: server failover/multiple instances

2007-06-19 Thread Jim Wright
I would recommend keeping your testing/training environment separate from production. Your testing environment may require newly developed code which has not been migrated to production. You probably will want a separate database as well for training and testing for similar reasons. That

Re: FW: server failover/multiple instances

2007-06-19 Thread Jim Wright
On 6/19/07, Brad Wood [EMAIL PROTECTED] wrote: Also, sometimes you may want to install a windows patch to your test server first and test it, THEN put it on production. And of course, in this case, test should be the exact same environment as production, meaning CF Enterprise there as well.

Re: server failover/multiple instances

2007-06-19 Thread Jim Wright
I've never set up the weighted scenario, but it should be possible. http://livedocs.adobe.com/jrun/4/JRun_Administrators_Guide/clustering3.htm Thanks, Russ...that is what I was looking for. ~| ColdFusion 8 beta – Build

server failover/multiple instances

2007-06-18 Thread Jim Wright
I am working towards beefing up our current environment, and wondered if I could get some opinions on server failover and using multiple instances. So I have: Production Site Training Site, duplication of the production site which is used by our training department Testing Site In addition we

Re: Conditional SQL

2007-06-13 Thread Jim Wright
On 6/13/07, James Smith [EMAIL PROTECTED] wrote: AND ProductGroupID = CASE WHEN @productgroupid 0 THEN @productgroupid ELSE ProductGroupID END This is the simplest to read but has a drawback, it the stored ProductGroupID is null then the statement becomes AND ProductGroupID =

Re: Conditional SQL

2007-06-13 Thread Jim Wright
On 6/13/07, Gaulin, Mark [EMAIL PROTECTED] wrote: This seems like a really complicated way of saying AND ((ProductGroupID = @productgroupid) OR (@productgroupid = 0)). Am I missing something? I think really complicated is a bit harsh...perhaps more complicated...and the previous version

Re: Conditional SQL

2007-06-12 Thread Jim Wright
I wish to move this query into MSSQL server for performance reasons, how do I go about running the conditional code? I have tried... I'm not sure you are going to get the performance benefit you are looking for. Doing the conditional processing in SQL isn't necessarily going to be

Re: How many CF developers does it take to manage a site ???

2007-06-11 Thread Jim Wright
On 6/11/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 11 Jun 2007, [EMAIL PROTECTED] wrote: average CF developer manage? Define 'manage'. Does that mean 'have needed development work in the last 12 months' or 'are running on the live server' ? Also define site...are you talking

Re: PDF to Image

2007-06-07 Thread Jim Wright
On 6/7/07, Mark Lewis [EMAIL PROTECTED] wrote: Hi, I am trying to convert the front page of a PDF doc to an image. My target server is Coldfusion 5 but if necessary Colfusion mx 7 can be used. Is it possible for this to be done, if so could I have some directions on how to do this. I

Re: Access query doesn't work

2007-06-01 Thread Jim Wright
On 6/1/07, Will Tomlinson [EMAIL PROTECTED] wrote: Need help figuring out why Access throws up on this query. I don't see anything wrong with it. select a.id, a.title, a.body, a.projectidfk, a.useridfk, a.posted, p.name as project, u.name as author from lh_announcements a left join

final CF 4.5 upgrade

2007-06-01 Thread Jim Wright
Sorry for the fluff message, but I'm just very happy that I got my final client (and as of last month, full time employer), off of CF 4.5 as of today. No more supporting anything earlier than 7! ~| Upgrade to Adobe ColdFusion

Re: CF8 beta ready for download...

2007-05-30 Thread Jim Wright
On 5/30/07, Raymond Camden [EMAIL PROTECTED] wrote: http://ray.camdenfamily.com/index.cfm/2007/5/29/Adobe-releases-public-release-candidate-of-ColdFusion-8--AKA-Scorpio#comments Also folks - in the comments you will find a Digg/DZone url. _Please_ vote to get these stories up on the front

Re: creating xml formatted out from table in database

2007-05-28 Thread Jim Wright
Ray Camden has a handy CFC that will help with that... http://ray.camdenfamily.com/projects/toxml/ On 5/28/07, Peter Tanswell [EMAIL PROTECTED] wrote: Hi there Just trying to figure something out. I have a form and an action page to write data to a table in the database. I am collecting a

Re: DataSource Help

2007-05-24 Thread Jim Wright
On 5/24/07, D Suresh [EMAIL PROTECTED] wrote: The Error msg is: Connection verification failed for data source: TestDB java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException:

Re: Voting only once - how to enforce ???

2007-05-23 Thread Jim Wright
On 5/23/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I'm creating a voting application for a photo contest and the non-technical person running the show doesn't want voters to have to verify their email address before their vote is counted. Although this method isn't fool proof, it does

Re: Project Time Tracking Software?

2007-05-22 Thread Jim Wright
On 5/22/07, Aaron Roberson [EMAIL PROTECTED] wrote: Does anyone know of a good project time management application that would be good for consulting jobs? I am thinking of something that has a stop watch you can click to start and stop and automatically calculate expenses incurred. It would be

other charting tools

2007-04-27 Thread Jim Wright
I'm hitting a few roadblocks with cfchart, and wonder what other people are using that might be a bit more feature rich. Specifically, I'm looking for more formatting control, such as series value labels that may extend past the borders of a bar, specific bar width, and specific colors

Re: Access Query Question

2007-04-19 Thread Jim Wright
Donna Martin wrote: In the newer versions, Access can be locked at the record level, and does not effect changes made to other records within the same table. *If you are using the oledb driver with the correct settings, IIRC. Of course, that doesn't prevent something else from connecting

Re: Opinions of Thumbnail Generation

2007-04-19 Thread Jim Wright
Rey Bango wrote: I wanted to get everyone's opinion on best practices for generating thumbnails. I'm have a screen that allows users to upload pics which will later be displayed as thumbnails. When the user clicks on the thumbnail, the pics will display to its full size. Does it make

Re: Hostmysite down...

2007-04-13 Thread Jim Wright
Mary Jo Sminkey wrote: So there's a good chance you might even be able to correct it just by asking HMS to move you to a different server. They do run multiple datacenters, so I would check with them to make sure your shared web server and mysql server are in the same datacenter.

Re: CFHTTP not working?

2007-04-13 Thread Jim Wright
Neil Middleton wrote: Can anyone think of a reason why when I CFHTTP it doesn't connect to external URL's when the sites work perfectly in a browser on the same machine? I am using WinXP / CFMX7 Dev Edition Is the browser on that machine going through a proxy server?

Re: file do more than one scheduled task ??

2007-04-09 Thread Jim Wright
Seamus Campbell wrote: is there any way to have a scheduled task do more than one task. My situation is this: I have a shared hosting space (Windows Servers) with Crystaltech. They only allow me 5 scheduled tasks but I have more than 5 sites which each need to run a file on a regular

Re: Adobe takes UK price hikes to new level with CS3

2007-04-06 Thread Jim Wright
Sean Corfield wrote: On 4/5/07, Tom Chiverton [EMAIL PROTECTED] wrote: I've not bought 'real' boxed software for years. Software comes in boxes? :) I think the last software I bought that wasn't just a download was Visio Professional 5.0, based on the almost complete lack of boxes in my

Re: Hostmysite down...

2007-04-06 Thread Jim Wright
Scott Stewart wrote: Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. Probably just the server you are on...I just checked a few of my clients, and they are still up. They generally are monitoring

Re: Hostmysite down...

2007-04-06 Thread Jim Wright
Russ wrote: I wonder if HMS has FusionReactor installed? I think it can really help with these type of issues. I believe they started using SeeFusion about 3 or 4 months ago. Since then, the services have seemed to restart faster when there is a problem, but I'm not sure the number of

Re: Syntax error in FROM clause.

2007-04-05 Thread Jim Wright
sheldon turchin wrote: Installed CF7 and get error but do not get the error in CF6. cfquery name=GetMonths datasource=Master SELECT Month FROM Month WHERE MonthID = #GetStatRecords.MonthID# /cfquery Is Month reserved and cannont be used in CF7? CF would not see that as a

Re: SQL Like

2007-03-30 Thread Jim Wright
Steve Milburn wrote: 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. if there are no NULLs in x.

Re: Need help instantating a COM object in CF7... It's my first time... :o(

2007-03-27 Thread Jim Wright
Try running this at a command prompt... regsvr32 x:\path\com\bbapi.dll Then use... CreateObject(COM, BBAPI.API) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2

Re: OT: Sitemaps

2007-03-23 Thread Jim Wright
Steve LaBadie wrote: Is anyone aware of a product that can accurately count how many pages are on a web server for a specific domain? I am not looking to create a web-based sitemap but to know how many (.htm, .cfm, etc.) pages exist without having to count by hand. Maybe use a link checker

Re: Need More SQL help - DRIVING ME NUTS!

2007-03-21 Thread Jim Wright
Three things I noted... 1. There are a lot of duplicated columns in the result list...I removed those to make it easier to read and debug 2. It looks to me like tblevalanswerresults needs to be joined to both tblquestions and tblanswers...see below 3. When you join on tblEvaluations like you did

Re: How do I display a message if update was successful?

2007-03-21 Thread Jim Wright
Dave Watts wrote: If your SQL update query doesn't return an error, that indicates your update was successful. Well...it indicates that there wasn't an error. It doesn't actually indicate that anything was updated. UPDATE sometable SET somecolumn = 'somevalue' WHERE 1=0 won't throw an

Re: How do I display a message if update was successful?

2007-03-21 Thread Jim Wright
Dave Watts wrote: Well...it indicates that there wasn't an error. It doesn't actually indicate that anything was updated. UPDATE sometable SET somecolumn = 'somevalue' WHERE 1=0 won't throw an error...but it also doesn't do anything. If you run a query that filters out all rows, it

Re: Query output - based on date range

2007-03-20 Thread Jim Wright
[EMAIL PROTECTED] wrote: Ahhh, I have an events database that lists the details of an event and the date range of number days the event runs. If it's a one day event, eventdate is the same as eventdate2. I've got the events outputting over a calendar so all the events show a single

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

2007-03-20 Thread Jim Wright
Steve Milburn wrote: In my opinion, and I would be the majority of people in this list, that would not be good for business. However, when they click on that first site on the gotcfm list...12listen.com...the one most people will probably click on...the psychic friends site...by golly,

Re: Can anyone tell me why someone would do this?

2007-03-19 Thread Jim Wright
Peterson, Chris wrote: I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now,

Re: Using cfquery to select from multiple datasources

2007-03-18 Thread Jim Wright
Kristin Collins wrote: I need to write an sql statement within a cfquery tag that pulls from two seperate datasources. But it's coming back with Invalid object name Below is the what I have written: cfquery datasource=#request.dsn# name=towns SELECT townid as tid, town as cityname

Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Jim Wright
Andrew Peterson wrote: Can someone recommend a good help desk/trouble ticket system? The ideal application would be cf based and open source. Thanks. While not CF based, I know quite a few people who swear by RT... http://bestpractical.com/rt

Re: SQL Server Syntax - Converting this CF Code

2007-03-14 Thread Jim Wright
Andrew Peterson wrote: Hi, I'd like to see how this is done, even though it is not necessary and I like my ColdFusion thank you very much. Can someone give me a general idea of how this code would look in SQL Server? It takes literally 5 minutes to write in CF; but for me to put it into

Re: What is wrong with this?

2007-03-12 Thread Jim Wright
Ashish Gohri wrote: Something like this works - cfset a = NumberFormat(1234567,) I believe in older CF versions (5 maybe, 4.5 for sure), you had to have as many places (or more) in your mask as you had in the number it is formatting. Is this a older version of CF?

Re: What is wrong with this?

2007-03-12 Thread Jim Wright
Rick Faircloth wrote: That got me closer, Jim. I tried #NumberFormat(Trim(Get_Property_Details.Sale_Price), 999)# and it did take off the decimal and rounded the number to 255900, however the 255900 was then preceded by about 4 blank spaces in the form field. Yeah...now that

Re: Creating HTML Content Wrapper for Email

2007-03-06 Thread Jim Wright
When I was creating some HTML email templates recently, I found this article to be very valuable... http://www.sitepoint.com/article/code-html-email-newsletters ~| Deploy Web Applications Quickly across the enterprise with

Re: SQL for Access vs MySQL

2007-03-06 Thread Jim Wright
Pete wrote: Hi Hoping someone might be able to assist - its 4am and I have just been called by a client coz their system crashed. They have just moved from using an Access DB to MySQL. They have a piece of code: select * into visaudactvols from visualauditrecs I don't believe

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

2007-03-05 Thread Jim Wright
Rey's site is meant to evangelize CF...and one thing that will evangelize CF is some really good CF sites. If someone is going in to look at sites that use CF, I'd rather have them see a really well designed adult toy shop that has a kick-ass search engine to help you find that perfect lube

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

2007-03-05 Thread Jim Wright
Rick Faircloth wrote: Isn't anyone else doing anything worth noting? This was exactly my point...and the conversation should go to this and how best to rate and showcase them rather than whether adult sites should be included (which is, as far as we know, still theoretical...Rey, have any

HMS Down?

2007-03-02 Thread Jim Wright
Is anyone else having problems with HMS sites? The two of mine that I can get to have JRun errors, and have for a while, where usually they are on top of those. And their main site is unreachable from my location. ~|

Re: HMS Down?

2007-03-02 Thread Jim Wright
Les Mizzell wrote: Whoop - me too ... bunch of stuff down ... Calling them now... The tech that I just talked to said they were having networking problems in one of their data centers. They are in the process of replacing some equipment. So apparently no cable cut this time...but it

Re: Image manipulation

2007-03-01 Thread Jim Wright
Asim Manzur wrote: What is the best tool in the market to resize/crop the uploaded images in coldfusion. The scnerio will be like the visitor will upload the image and then he/she should have resize, rotate, crop and the other smiliar kind of functionality available. I don't mind buying

Re: Image manipulation

2007-03-01 Thread Jim Wright
Ian Skinner wrote: Sorry. Sounds like it's time to get a new host. HMS does have ImageCR3 installed on their systems. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity.

Re: Converting MS Word-exported HTML to clean HTML

2007-02-27 Thread Jim Wright
Dov Katz wrote: I know there's something like this in fckEditor, but I'm looking for it to be server-side. The js used to do this in FCK is in FCKEditor/editor/dialog/fck_paste.html...it is just a bunch of regex replaces...perhaps you could massage those over to some cfscript.

Re: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism

2007-02-27 Thread Jim Wright
Rey Bango wrote: But, by no fault of Ben, its not all encompassing, its not up-to-date and it doesn't appear to include sites built using other technologies like Ralio, Coral or BlueDragon. Just curious if you have plans to keep yours up to date? Sites get upgraded to a new version of

  1   2   3   4   5   6   >