model-glue editor

2006-06-13 Thread dave
So I dove into mg but the thing I immediately found was that dw nor cfe has any code hints in them, which I am sure will come but I just happened to be trying out skedit last night and while it doesn't have model-glue specific tags it did making a closing tag for most of the model glue tags

Re: model-glue editor

2006-06-13 Thread massimo
So I dove into mg but the thing I immediately found was that dw nor cfe has any code hints in them For DW, get the DTD from MG's distro. Then: Edit Tag Libraries + DTD or Schema Import XML DTD Massimo ~| Message:

Re: model-glue editor

2006-06-13 Thread dave
well i'll be damned! I wished it closed them tho but thats a good start :) ~Dave - formerly known as the disruptor~ From: [EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 2:40 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: model-glue editor So I

Re: OT: SVN Help

2006-06-13 Thread Tom Chiverton
On Monday 12 June 2006 19:06, Richard Kroll wrote: C:\program files\subversion\bin\svn.exe update C:\webserver\site\ but I get errors on program files due to the space. Could this be our problem and if so how can I get around it? Use the 8.3 version, progra~1 ? Speech marks around it ? --

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Tom Chiverton
On Monday 12 June 2006 18:25, Rob Wilkerson wrote: customers. Ideally, I'd like to extract only the modified files from the source control repository so I can then just roll them up in a tarball without any additional weeding of what's in and what's out. Should be easy enough, you ask SVN for

Re: secure logout

2006-06-13 Thread Tom Chiverton
On Tuesday 13 June 2006 02:22, Andy wrote: Yes, you can set the HTML refresh option to force a page refresh that would allow you to provide a second message. Or have the last-but-one page be the result of a POST. -- Tom Chiverton This

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Michael Traher
I just experimented with tagging just a handful of files (i tried three) and then I replaced the project with the 'tag' and all I had was the necessary folder tree and the files I had tagged! This would then make a nice neat distribution. (I suspect this is what the 'patch' wizard in eclipse may

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Tom Chiverton
On Tuesday 13 June 2006 09:43, Michael Traher wrote: At the risk of crazy people joining the thread eclipse does have very nice source control tools CVS built in and SVN as a plugin. Heh :-) (CVS support is a plugin too, just happens to ship with the base Eclipse distribution). -- Tom

Printing from CF / Browser

2006-06-13 Thread Jenny Gavin-Wear
Hi all, I have an application for a delivery company that generates a bunch of consignment notes to be printed. I'd like to be able to send the job to print from IE, or to have a pdf created on the fly which can then be printed. My basic problem is page feeds. Currently I am generating one

Re: secure logout

2006-06-13 Thread Jochem van Dieten
Christophe Maso wrote: But regardless of the browser's cache settings, isn't there a way to ensure that the back button can't display the previous page at all? No. Once you send HTML to the user-agent of a visitor, you have no control over it anymore. With the proper caching hints (see RFC

Bar codes

2006-06-13 Thread Jenny Gavin-Wear
Does anyone know a good reference site for using bar codes with CF, please? The plan is to print a bar code onto a package label (couriers application) based on the consignment reference. Consignment tracking will then involve scanning packages as they arrive at depots (for example) and are

Re: Bar codes

2006-06-13 Thread Nick Tong - TalkWebSolutions.co.uk
http://wapurl.co.uk/?Q1PK3H3 - here are previous threads on this issue. On 13/06/06, Jenny Gavin-Wear [EMAIL PROTECTED] wrote: Does anyone know a good reference site for using bar codes with CF, please? The plan is to print a bar code onto a package label (couriers application) based on the

Re: Bar codes

2006-06-13 Thread James Holmes
We use Barbecue for this; I wrote a wrapper Java class which I call directly from CF and it works well. This method uses Java graphics routines, so you need a system with a graphics card (likely on Windows) or a virtual graphics environment (e.g. a XServer on UNIX).

Re: Server firewall software

2006-06-13 Thread Jochem van Dieten
Bryan Stevenson wrote: Can ya provide some insight here DaveI took a look at the IP Security Policy GUI and honestly didn't know what I was looking at. Don't use the GUI, use the command line tool. It is documented at the MS website and there are several example policies at

RE: [SPAM : 5.0] RE: Speaking of cfeclipse/eclipse issues...

2006-06-13 Thread Snake
OK just to give the rest of you some peace, I'm going to reply to the dildo off-list. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 13 June 2006 06:18 To: CF-Talk Subject: Re: [SPAM : 5.0] RE: Speaking of cfeclipse/eclipse issues... I dont think so, i just gotta be

RE: Bar codes

2006-06-13 Thread sana ullah
Hi check this http://www.adobe.com/cfusion/exchange/index.cfm?view=sn130#view=sn131viewName=ColdFusion%20Extensionloc=en_usauthorid=34333534page=0scrollPos=0subcatid=0snid=sn131itemnumber=12extid=1020465catid=0 Thanks Sana Subject: Bar codes From: [EMAIL PROTECTED] To:

Re: model-glue editor

2006-06-13 Thread Mark Drew
Check Rob Rohan's AFAE editor... http://weblog.robrohan.com/Afae/ (notice it has mg support as well as a plethora of other great things!) MD On 6/13/06, dave [EMAIL PROTECTED] wrote: well i'll be damned! I wished it closed them tho but thats a good start :) ~Dave - formerly known as the

Re: Printing from CF / Browser

2006-06-13 Thread Tom Chiverton
On Tuesday 13 June 2006 10:04, Jenny Gavin-Wear wrote: My basic problem is page feeds. Currently I am generating one long page of consignments, is there some way of coding it to send a page feed after each record, please? Google for 'print stylesheets' ? -- Tom Chiverton

RE: Printing from CF / Browser

2006-06-13 Thread Jenny Gavin-Wear
Have been doing so Tom, but I can't see anything on page feeds. I've used print style sheets in the past, but never needed page feeds before. Any ideas ? -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 13 June 2006 11:31 To: CF-Talk Subject: Re: Printing from CF

Re: Printing from CF / Browser

2006-06-13 Thread |Rens| 0
You mean something like this maybe? style=page-break-before: always; Rens Jenny Gavin-Wear wrote: Have been doing so Tom, but I can't see anything on page feeds. I've used print style sheets in the past, but never needed page feeds before. Any ideas ? -Original Message-

RE: Printing from CF / Browser

2006-06-13 Thread Jenny Gavin-Wear
bingo ! thank you :-) -Original Message- From: |Rens| 0 [mailto:[EMAIL PROTECTED] Sent: 13 June 2006 12:05 To: CF-Talk Subject: Re: Printing from CF / Browser You mean something like this maybe? style=page-break-before: always; Rens Jenny Gavin-Wear wrote: Have been doing so Tom,

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Rob Wilkerson
Michael, it sounds like you tried exactly what I'm looking to do, but I need to clarify since you used terminology that I'm not familiar with (read: non-VSS terms). I assume tagging is labeling, but what do you mean you replaced the project? I need to tag a few selected files and then extract -

Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Peterson, Chris
I have a document imaging system in place here that we use for driver documentation (applications, MVR's, etc), our billing system of invoices and proof of deliveries, AP, etc. I currently store all images as Tiff's and use the free Alternatiff (www.alternatiff.com) to view all images. This

Re: OT: SVN Help

2006-06-13 Thread Pete Ruckelshaus
Have you tried using SVNServe and the SVN:// protocol? Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription:

Re: model-glue editor

2006-06-13 Thread Matt Williams
You can also do the XML Buddy plugin for Eclipse, add in the dtd and it will do like Dreamweaver, closing tags even (I think). On 6/13/06, Mark Drew [EMAIL PROTECTED] wrote: Check Rob Rohan's AFAE editor... http://weblog.robrohan.com/Afae/ (notice it has mg support as well as a plethora of

Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread Che Vilnonis
Does anyone have a batch file to Stop/Start ColdFusion MX? Not sure how to write one. Thanks, Che. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4

RE: Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread Adkins, Randy
ECHO OFF REM REM STOPPING SERVICES REM REM NET STOP Macromedia JRun Default Server NET STOP Macromedia JRun CFusion Server REM NET STOP Macromedia JRun Admin Server REM REM STARTING SERVICES REM REM NET START

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Michael Traher
:-) yes, each of these source systems has a language all its own! Fortunately CVS and SVN have the same root so thats one mercy. The project is all stored in the repository (all versions since you first created it there or committed your existing source files for the first time). In eclipse (and

Re: Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread Rob Wilkerson
Assuming this is Windows since you referenced a batch file, just open notepad, type: net stop ColdFusion MX Application Server net start ColdFusion MX Application Server Save the file as bounce.bat (only the extension is important) and that's it. The quoted value is the name of the services you

RE: Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread Che Vilnonis
Rob, Randy... Thank you! It doesn't get any easier than that. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 8:44 AM To: CF-Talk Subject: RE: Batch file to Stop/Start ColdFusion MX... ECHO OFF REM REM STOPPING SERVICES

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Rob Wilkerson
I think it does and it means that SVN offers a capability that VSS is fundamentally lacking. That will make selling this change much easier. Thanks for your help. On 6/13/06, Michael Traher [EMAIL PROTECTED] wrote: :-) yes, each of these source systems has a language all its own! Fortunately

Re: Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Mark Drew
Have you tried the cfdocument tag? I think it would be able to get a tiff and display it as a flash form.. MD On 6/13/06, Peterson, Chris [EMAIL PROTECTED] wrote: I have a document imaging system in place here that we use for driver documentation (applications, MVR's, etc), our billing

Re: Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Mark Drew
I, of course, mean flash paper. MD On 6/13/06, Mark Drew [EMAIL PROTECTED] wrote: Have you tried the cfdocument tag? I think it would be able to get a tiff and display it as a flash form.. MD On 6/13/06, Peterson, Chris [EMAIL PROTECTED] wrote: I have a document imaging system in

RE: Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Peterson, Chris
Mark, I believe the only format's supported by Flashpaper are text, xml, jpg, png, and gif. (when creating using CFDOCUMENT) http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/comm on/html/wwhelp.htm?context=ColdFusion_Documentationfile=0236.htm If only it did tiff and word

Re: Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Jerry Johnson
I have a great reluctance to store and send office documents via the web. To return tiffs and docs, I typically throw them into pdfs for display. (The docs get converted when uploaded, so they are stored on disk as PDF) The tiffs get thrown into a pdf on-the-fly (used to use ghostscript to do

RE: Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Peterson, Chris
Jerry, I know that I can draw text over a document during upload (date time stamp, etc), but how do I allow the user to open the document, then save a note overtop of it, or allow them to draw an arrow to a portion of the document and add a 'sticky' to it, after it has been saved? Chris

Re: Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread Nick Tong - TalkWebSolutions.co.uk
I use something called orbwave service manager ( http://www.orbwave.com/software/index.cfm)- it's great as i don't have a lot of my services start when my machine starts and then i boot them up (as a group or individually) as and when i need them. You can also restart the services. On 13/06/06,

XML - looking to return an XML object original parced format

2006-06-13 Thread Ian Sheridan
My subject line pretty much says it all, but let me clarify. I want to return an XML object back to it's original format after I have used XMLSEARCH on it. I guess it's a matter of aesthetic but I'd like to be able to use the node name as the name of the structure I am accessing. EX. root

cfdocument

2006-06-13 Thread Turetsky, Seth
I've heard that cfdocument uses iText to create pdfs, but does anyone know what it uses to parse the HTML/CFML? We don't have CFMX7 here, but I have a cfc I wrote a long time ago that creates a report from a columnlist, but I would like to see if I can upgrade it to parse the code as well.

Re: Printing from CF / Browser

2006-06-13 Thread Terry L Schmitt
I would use CFREPORT for this. It gives you all the page control that you need and more. Jenny Gavin-Wear [EMAIL PROTECTED] wrote on 06/13/2006 05:04:50 AM: Hi all, I have an application for a delivery company that generates a bunch of consignment notes to be printed. I'd like to be

RE: Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread Jason Crider
How much editing would it take to get that to work on CFMX 7? -Original Message- On 13/06/06, Che Vilnonis [EMAIL PROTECTED] wrote: Rob, Randy... Thank you! It doesn't get any easier than that. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent:

Re: XML - looking to return an XML object original parced format

2006-06-13 Thread Rob Wilkerson
Can you use XMLSearch()? cfset node = XMLSearch ( parsedXML, '/root/goodnode/goodnode_name/text()' ) / cfoutput#node[1].value#/cfoutput I recommend dumping the node value to ensure that the way my code accesses that value is correct. It may be a little off - I'm winging it, here. On 6/13/06,

Re: Batch file to Stop/Start ColdFusion MX...

2006-06-13 Thread John C. Bland II
Sean Tierney had a good blog post about this. Check it out herehttp://www.scrollinondubs.com/?p=13 .. On 6/13/06, Jason Crider [EMAIL PROTECTED] wrote: How much editing would it take to get that to work on CFMX 7? -Original Message- On 13/06/06, Che Vilnonis [EMAIL PROTECTED]

CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Spydersweb Internet Solutions
Dear All I am utilising a SECPAY payment authorisation service to process client payments. I collect data via a form, do a database insert with it and then do a cfhttp post to Secpay's Secure server. I have only just noticed that when I do the post I do not get to see the https in the url

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Russ
When you do a cfhttp request, it does it on the server side. There is nothing that gets shown on the browser. If you're using an https url, it should be secure. If you want to show a browser lock to your users, you will have to use https on your server (and if you're not, then their data is

Re: model-glue editor

2006-06-13 Thread Joe Rinehart
Hey Dave, Try XMLBuddy - the free version makes it easy to associate a given XML file with a given DTD, and it'll close things for you, etc. On 6/13/06, dave [EMAIL PROTECTED] wrote: well i'll be damned! I wished it closed them tho but thats a good start :) ~Dave - formerly known as the

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Spydersweb Internet Solutions
Russ, hi thanks for the help Can I just clarify your response please If the end user is viewing the secpay secure page in this way it is not using the security provided by secpay via their ssl certificate? I am not storing credit cards in the database, just the transaction details, ie name

Re: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Terry L Schmitt
I don't program for payments, but cfhttp is communication between your server and secpay and has nothing to do with what is displayed on the users browser. If you are accepting CC information, then your web server and forms should be secured, in which case you would see the appropriate lock

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Spydersweb Internet Solutions
Russ, hi thanks for the help Can I just clarify your response please If the end user is viewing the secpay secure page in this way it is not using the security provided by secpay via their ssl certificate? I am not storing credit cards in the database, just the transaction details, ie name

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Russ
From what I understand, the user fills out the form on your website with their credit card information, etc. You process that form, put in the transaction details sans the credit card # into your database and then process the payment using the cfhttp post to secpay. The connection from your

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Russ
Actually the lock will only be seen if the page AND all the images on it are secure. So you have to make sure you don't have any http paths hard coded for your image src's. -Original Message- From: Terry L Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 10:31 AM To:

OT: CF-United : Rooms at the north

2006-06-13 Thread Paul Ihrig
any one canceling there room at the north marriot, please email me. would like to get in there. thanks! -paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243340 Archives:

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Spydersweb Internet Solutions
Russ I think I understand, however I just wanted to bring your attention to the process I use. The user selects a product subscription and is sent to a form on my server which asks for their personal details ie home address etc, but not payment information. Once they click on submit the page

Emulate fast compile in other frameworks

2006-06-13 Thread Robert Everland III
I was wondering if anyone has tried to take what the Fusebox team has done so that some of the other frameworks run as fast as Fusebox? Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243342 Archives:

RE: CFHTTP / SSL and Secpay Payments

2006-06-13 Thread Dave Watts
So even if I transfer the user via cfhttp to secpay's secure payment facility, because I am still technically in an unsecure environment I would need to secure it with my own certificate? You can't transfer the user via CFHTTP. The CFHTTP tag lets you use CF as an HTTP client. The user

Re: Slightly OT: Document imaging system in CF, need good viewer?

2006-06-13 Thread Jerry Johnson
I honestly don't know. I have never needed to get imput back from a user in this way. That pretty much precludes a PDF, since you don't want to require your users to have a pdf writer as well as the free reader, and you can't draw over it in a browser (afaik) Jerry On 6/13/06, Peterson, Chris

Problems using aexp.htr

2006-06-13 Thread Brian Yager
I just changed to a new server and the aexp.htr file brings up a wierd error...Our help desk can't fix it so they said just use one of the other aexp files (aexp4.htr). That file loads but doesn't change the password. Does anyone have anything custom that changes the users password? This is

RE: Server firewall software

2006-06-13 Thread Dave Watts
Can ya provide some insight here DaveI took a look at the IP Security Policy GUI and honestly didn't know what I was looking at. If it helps our setup is simple (and yes the network is small...dev web serverfile server...6 workstations. We are using DSL with a D-Link router.

Itext Sample code

2006-06-13 Thread Robert Everland III
Someone had mentioned they were going to offer some sample code showing how to use Itext to load a PDF with fields and fill in the values. Any status on when we can see that? Bob ~| Message:

Re: XML - looking to return an XML object original parced format

2006-06-13 Thread Ian Sheridan
Well this is about returning the data structure to a state that it was in when you first parsed the xml. Which I have figured out how to do. Here it is: cfset xml = xmlparse(xml) cfset xml = xmlsearch(xml,//root/) cfset xml = xml[1].tostring() cfset xml = xmlparse(xml) done... :) - Ian On

cfhttp with https and self generated certificates

2006-06-13 Thread Russ
I am trying to use cfhttp over https and I'm getting I/O Exception: peer not authenticated. A quck google search turns up that I need to import the certificate into my keystore. Isn't there a way to tell CFHTTP to ignore certificate warnings? The certificate in question is a self generated

RE: XML - looking to return an XML object original parced format

2006-06-13 Thread Dawson, Michael
As long as you don't use the same variable xml for all of your function results, you won't have to re-parse the xml. Regardless, of the size of the xml source, it would be a waste of processing to parse it twice in the same request. cfset xmlObj = xmlParse(xmlSource) cfset xmlResult =

RE: cfhttp with https and self generated certificates

2006-06-13 Thread Mark A Kruger
In order to make a successful connection the key has to be imported. Otherwise it cannot unencrypt the stream. Don't confuse this error with the browser warning error. In the case of the browser warning it is giving you a choice - do you want to accept (import into keystore) this certificate?

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Michael Traher
I found the greatest aid to selling CVS/SVN was the price :-) On 6/13/06, Rob Wilkerson [EMAIL PROTECTED] wrote: I think it does and it means that SVN offers a capability that VSS is fundamentally lacking. That will make selling this change much easier. Thanks for your help. On 6/13/06,

RE: cfhttp with https and self generated certificates

2006-06-13 Thread Russ
When you choose to trust a certificate, the browser doesn't import it right away... it imports it for that session only. Why can't cfhttp have a similar setting where it allows you to use a certificate just for that session? How do I know what vendors are in the keystore? Has anyone tried using

index.cfm Conundrum

2006-06-13 Thread Sung Woo
I have a very strange issue with a server running CFMX7. This server initially was running CFMX7 standalone, and when the time came, it was uninstalled and reinstalled as a CFMX7 using IIS. So now here's the wacky issue: no matter the site (on ports 80 and 81), whenever the file index.cfm is

RE: Bar codes

2006-06-13 Thread Ian Skinner
The standard responses to this request. Check out barcode font classes. Check out barcodeZone: http://www.fusionzone.com/applications/barcode/index.cfm. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | |

Re: XML - looking to return an XML object original parced format

2006-06-13 Thread Ian Sheridan
Your right I just was writing that way for brevity. - Ian On 6/13/06, Dawson, Michael [EMAIL PROTECTED] wrote: As long as you don't use the same variable xml for all of your function results, you won't have to re-parse the xml. Regardless, of the size of the xml source, it would be a waste

Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Rick Faircloth
Hi, all. Does MS SQL Server Express 2005 or even MS SQL Server not use a Group By function? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243357 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Rob Wilkerson
True, but in this case we already own VSS so cost is less of a factor. I have to sell added value and less-than-absurd conversion costs. To that end, any conversion resources anyone could offer would be great. Also, any selling points on the value added side would be helpful. On 6/13/06,

Re: index.cfm Conundrum

2006-06-13 Thread Rob Wilkerson
Take a look at your settings in CF Admin. In the Caching settings, ensure that Cache web server paths is unchecked. This is important for servers running multiple sites. On 6/13/06, Sung Woo [EMAIL PROTECTED] wrote: I have a very strange issue with a server running CFMX7. This server

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
I've used it. Can you show us the SQL you are having a problem with? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243360 Archives:

Re: index.cfm Conundrum

2006-06-13 Thread Sung Woo
Hi Rob, Thanks -- it's not checked. Take a look at your settings in CF Admin. In the Caching settings, ensure that Cache web server paths is unchecked. This is important for servers running multiple sites. On 6/13/06, Sung Woo [EMAIL PROTECTED] wrote: I have a very strange issue

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
Here is a simple example using the Northwind database in SQL Server The key to the GROUP BY clause is that is needs to be used in aggregate functions SELECT COUNT(P.ProductID) AS ItemTotal, C.CategoryName FROM Products AS P INNER JOIN Categories AS C ON P.CategoryID = C.CategoryID GROUP BY

RE: index.cfm Conundrum

2006-06-13 Thread Ian Skinner
Hi Rob, Thanks -- it's not checked. Are all three values unchecked? I just unchecked the middle one and it resolved a somewhat similar issue for me. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | |

RE: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Rick Faircloth
Ok...I had read a message that mentioned the aggregate function requirement...but how would I write my example query to include an (unneeded?) aggregate function? (And why would there be an aggregate requirement anyway?) Query (MySQL version): Select * from books group by genre

RE: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Rick Faircloth
I finally did get Express to give me the results I wanted... Here's the solution the Query Builder gave: Select Count(*) as Expr2, Book_Genre from Books Group By Book_Genre Order By Book_Genre Seems strange to require an unneeded aggregate function... Rick -Original Message- From:

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Greg Morphis
But it is needed, that query is returning the count of the books per book_genre On 6/13/06, Rick Faircloth [EMAIL PROTECTED] wrote: I finally did get Express to give me the results I wanted... Here's the solution the Query Builder gave: Select Count(*) as Expr2, Book_Genre from Books Group

RE: cfhttp with https and self generated certificates

2006-06-13 Thread Mark A Kruger
You can find out what is in your keystore using the keytool (if you are using the Sun jvm). Here's the syntax. C:\CFusionMX\runtime\jre\libkeytool -list -storepass changit -noprompt -keystore C:\CFusionMX\runtime\jre\lib\security\cacerts I have a blog post on this issue:

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
Ok, I see what's going on. You want to out put your records in a group, thats a CF issue, not a SQL issue. What you need to do is to use ORDER BY to get your records in the correct order then user the GROUP attribute of the CFOUTPUT tag GROUP BY in SQL is for compiling related data and

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
Are you trying to get a count of all of the books by Genre? Or are you trying to get a list of all of the genres? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message:

Re: index.cfm Conundrum

2006-06-13 Thread Sung Woo
Save class files is checked. I bet I need to restart the server, right? I'll have to wait to do that. Hi Rob, Thanks -- it's not checked. Are all three values unchecked? I just unchecked the middle one and it resolved a somewhat similar issue for me. -- Ian Skinner

RE: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Rick Faircloth
But why does it require that the count be calculated if I don't need that information? -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 1:05 PM To: CF-Talk Subject: Re: Group By function for MS SQL Server Express 2005? But it is needed,

Re: index.cfm Conundrum

2006-06-13 Thread Rob Wilkerson
The save class files simple saves the java byte code of a given file. As I understand it, it's the other option that caches only one location for the file. For example, on a multi-homed server (a web server serving more than one CF site), if the index.cfm file for site1 is rendered first, then

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Greg Morphis
What information are you trying to get then? On 6/13/06, Rick Faircloth [EMAIL PROTECTED] wrote: But why does it require that the count be calculated if I don't need that information? -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006

CF Requred Fields Not Working As Expected

2006-06-13 Thread Claremont, Timothy
Using 7.1 on Win2k3 Server. HTML forms. NOT Flash forms. I have a form with a number of requred fields. Messages are assigned to these fields. If I hit the submit button while leaving requred fields blank, I get a dialog box informing me of the problems with the form, just as expected. But when

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Michael Traher
(At the further risk of crazy people) what IDE are you using, because I found that easy of use for the development team is a key factor. That is what prompted us to switch to eclipse. There are other clients, and good ones, but for me having it integrated in the ide was key. With eclipse all your

announce: ColdFusion Cookbook hits 100

2006-06-13 Thread Raymond Camden
I hope folks don't mind the advertisement (although its for a free resource), but I just wanted to make sure folks were aware that the ColdFusion Cookbook (www.coldfusioncookbook.com) hit 100 entries today. Most of the thanks go to Jeremy Petersen. I built the framework, but he did most of the

SOT: Getting data into a web site

2006-06-13 Thread Chad Gray
Slight rant too let loose of some tension. You know what would be nice is if there was a way for a user sitting in their cubicle to be able to copy data from Excel and paste this data directly into a web page then hit submit to insert it into a database It has to be dummy proof! So

Re: Server firewall software

2006-06-13 Thread Bryan Stevenson
Thanks to Dave, Denny and Jochem for the IP Security Policy infoI see where it's going now and will peruse the tutorials etc to get the full picture Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264

RE: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Dave Watts
Ok...I had read a message that mentioned the aggregate function requirement...but how would I write my example query to include an (unneeded?) aggregate function? (And why would there be an aggregate requirement anyway?) Query (MySQL version): Select * from books group by genre The

Re: Bar codes

2006-06-13 Thread Robert Everland III
Check this out http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=7threadid=973582highlight_key=ykeyword1=itext Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243380 Archives:

Re: index.cfm Conundrum

2006-06-13 Thread Sung Woo
I had this issue with 6.1, but it's the first time I've experienced it with 7. I'm not sure the save class file will help, but I'll give it a shot. Keep in mind that this is only happening with the index.cfm file, nowhere else, and only when it's called from root. So to summarize:

Re: announce: ColdFusion Cookbook hits 100

2006-06-13 Thread Massimo Foti
Thanks for the great resource. Both to Ray and all contributors. Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~|

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Rob Wilkerson
Most of my people use CFEclipse. I have one CFStudio/HS+ holdover. The integration points via the SVN plugin were just one of the attractions of moving to SVN from VSS. On 6/13/06, Michael Traher [EMAIL PROTECTED] wrote: (At the further risk of crazy people) what IDE are you using, because I

RE: cfhttp with https and self generated certificates

2006-06-13 Thread Russ
I decided to skip the hassle and buy a $30 cert from X-Registrar. Took only a few mins and now it works with CF and I get no warning on the browser. I think that's money well spent. (I'll see if I can use the same cert to secure pop3s and smtps, to get rid of those annoying warnings in

Re: SOT: Getting data into a web site

2006-06-13 Thread Chris Mueller
Actually, applications like Google Spreadsheets support this kind of interface (to some extent, at least). I suppose it would be a little difficult to get the Google engineers to let you at their databases, though. ;-) Chris On 6/13/06, Chad Gray [EMAIL PROTECTED] wrote: Slight rant too let

Re: SOT: Getting data into a web site

2006-06-13 Thread Sam Farmer
If the spreadsheets are in a standard layout you could allow users to upload them. Then in CF connect to the spreadsheet via a datasource and get the data that way. Cheers, Sam F On 6/13/06, Chris Mueller [EMAIL PROTECTED] wrote: Actually, applications like Google Spreadsheets support this

Tracking hits/impressions DB design Considerations

2006-06-13 Thread blists
Hello, I am setting out to build a basic split testing program for pages on my site. I am wondering what is the best approach to database design. Basically, I'll have two pages PAGE A and PAGE B that I want to show equally. And I want to track how many times each page is viewed, and how many

Re: OT: Best Practices - Source Control and Hotfixes

2006-06-13 Thread Qasim Rasheed
Not to contradict the usefulness of SVN, there is a plugin for VSS that you use within Eclipse which essentially gives you all the feature from VSS IDE that you are accustomed to. HTH Qasim On 6/13/06, Rob Wilkerson [EMAIL PROTECTED] wrote: Most of my people use CFEclipse. I have one

  1   2   >