Windows 2008 r2 server(64 bit ) and Web services

2010-09-03 Thread Matthew Allen
Has anyone ran into endless loop problems whilst trying to invoke a web service on windows 2008 server? I was barking up the wrong tree at first, I'd wrongly assumed that it was the recently upgraded cf9.0.1 that was causing the problems but ran the same code on a different server (Windows

Re: Windows 2008 r2 server(64 bit ) and Web services

2010-09-03 Thread Matthew Allen
Success!! if anyone is interested. On closer inspection of the application logs I found the error below: Cannot perform web service invocation CheckUserAuthenticates.The fault returned when invoking the web service operation is:br preAxisFault faultCode:

RE: getting server name

2010-09-03 Thread Eric Roberts
Thanks!!! That did it!! Eric -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Thursday, September 02, 2010 1:56 PM To: cf-talk Subject: RE: getting server name Hah! I just implemented this same thing in our system the other day. This code snippet will

Re: Need some fresh eyes on an application

2010-09-03 Thread Paul Day
I have created a test account with the following credentials: Server name: sql1100.shared-servers.com Port number: 1086 Username: hof_test Password: hof_test I'm not allowed to do anything with the user accounts or adding databases, since this is on a shared database hosting server. All

Re: Need some fresh eyes on an application

2010-09-03 Thread Paul Day
(Sorry, forgot the demo URL...) I have created a test account with the following credentials: Demo URL: http://www.nucomsolutions.com/dbDiscover Server name: sql1100.shared-servers.com Port number: 1086 Username: hof_test Password: hof_test I'm not allowed to do anything with the user accounts

Bind issues - observation

2010-09-03 Thread Stephens, Larry V
I'm sure this isn't news to most of you but perhaps there are one or two people out there struggling with CF and Ajax. Rewriting an application for CF that was originally done in Access has some challenges. Among them is display fields that are updated by an associated field. In my case (and

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: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Michael Grant
*bump* No one has any insight into this? Please please please. On Thu, Sep 2, 2010 at 11:47 AM, Michael Grant mgr...@modus.bz wrote: Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so that the field best matches the data going into it. As an example if I was

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Russ Michaels
With MSSQL you are limited to about 8000 bytes per row and anything beyond this will be chopped, so you need to be careful how much data you are storing. Using BLOBS will overcome this as a pointer to the blog is the only thing stored in the row, and the blog is actually stored separately. Using

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Won Lee
On Fri, Sep 3, 2010 at 12:04 PM, Michael Grant mgr...@modus.bz wrote: *bump* No one has any insight into this? Please please please. On Thu, Sep 2, 2010 at 11:47 AM, Michael Grant mgr...@modus.bz wrote: Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Michael Grant
Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any advantage to using varchar(150) over say TEXT or any of the other text type fields? that's what I'm trying to get at. So is a table that's got 20 TEXT datatype fields

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Won Lee
On Fri, Sep 3, 2010 at 12:23 PM, Michael Grant mgr...@modus.bz wrote: Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any advantage to using varchar(150) over say TEXT or any of the other text type fields? that's

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Michael Grant
thank you sir. On Fri, Sep 3, 2010 at 12:34 PM, Won Lee won...@gmail.com wrote: On Fri, Sep 3, 2010 at 12:23 PM, Michael Grant mgr...@modus.bz wrote: Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any

Authorization and Security for a web service

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

Re: Bind issues - observation

2010-09-03 Thread Tony Bentley
Larry, It sounds like your problem is mainly the architecture that you're dealing with. It is really important to understand modern Ajax (not the old Async JavaSript XML) and how to finely tune Ajax JavaScript libraries to do what you want. More specifically how to handle Ajax debugging and

RE: Bind issues - observation

2010-09-03 Thread Stephens, Larry V
Thanks. I do understand most of this and do use javascript in many cases. Looks like I need to bone up on jquery. -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Friday, September 03, 2010 1:13 PM To: cf-talk Subject: Re: Bind issues - observation

RE: Moving to Apache

2010-09-03 Thread Steve LaBadie
Russ, We tried both ISAPI_rewrite3_0075_lite and ISAPI_rewrite3_0069_lite with no luck. I am not sure how you know the difference between what rules WordPress is giving you (Apache/IIS). Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301

RE: Bind issues - observation

2010-09-03 Thread Rick Faircloth
Amen to jQuery! -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Friday, September 03, 2010 1:13 PM To: cf-talk Subject: Re: Bind issues - observation Larry, It sounds like your problem is mainly the architecture that you're dealing with. It is really

RE: Moving to Apache

2010-09-03 Thread Terry Troxel
I would love to install Apache on my laptop/windows7 for a development server, but have no idea how to set it up where I can put the 192.168.1.8 testdomain.com in the hosts file and then add the website in Apache because IIS only allows 1 default site unless its running on a server. Anyone have

Re: Moving to Apache

2010-09-03 Thread Russ Michaels
Terry, you edit the hosts file exactly as you do now, it makes no difference that you are using Apache. The hosts file is simply telling your machine to resolve a domain to a specific IP address, e.g. your local machine. IIS6 only allows 1 site to be active at a time, but you can have multiple

Re: Moving to Apache

2010-09-03 Thread Russ Michaels
Steve. The difference is quite obvious. If you are using the latest wordpress then i'm quite sure it detects your webserver and gives you the right rules, but as IIS6 has no such feature then it may not be detecting either. The IIS rules are web.config entries, the Apache rules are htacces

Re: Authorization and Security for a web service

2010-09-03 Thread Eric Cobb
Check out these presentations by Simone Free. He's got some really good pointers in them. http://www.simonfree.com/presentations/cfobjective.html http://www.simonfree.com/presentations/cfunited-09---washington-dc.html http://www.simonfree.com/presentations/nashville-cfug.html Thanks, Eric

Preserve HTML format when inserting into HTML

2010-09-03 Thread Jake Munson
I have an XML object that was populated from an XML file. This XML comes from an external system that I do not control. Here is the bit of XML that I'm struggling with: parks park SiteAbstract ![CDATA[font color=#045172bLoveridge Bridge North/b/font]] /SiteAbstract /park

RE: Bind issues - observation

2010-09-03 Thread Andrew Scott
Or even cfajaxproxy built into ColdFusion. Check these tutorials out. http://www.andyscott.id.au/2010/8/27/How-to-handle-ColdFusion-session-time-o uts-with-Ajax-calls-and-ExtJS http://www.andyscott.id.au/2010/7/25/ColdFusion-and-populating-a-dropdown-ba sed-on-the-selection-of-another

RE: Moving to Apache

2010-09-03 Thread Terry Troxel
Terry, you edit the hosts file exactly as you do now, it makes no difference that you are using Apache. The hosts file is simply telling your machine to resolve a domain to a specific IP address, e.g. your local machine. IIS6 only allows 1 site to be active at a time, but you can have multiple