IP Geolocation API?

2012-01-23 Thread webmaster
Anybody know of any API services out there (free would be best) that allow the lookup of a person's location based on their IP address? Trying to implement a system for a client that is show me the closest 5 locations to my area type of thing and they don't want to use zip code. Any ideas much

Need selectedIndex of cfselect after bind

2012-01-04 Thread webmaster
Ok I have some code that allows a user to type a word in a cfinput and then it suggests records from the database in a cfselect that is bound to that cfinput. Then I need to be able to submit that record using ajax to insert some data into a database. The problem comes in when I try to

RE: Need selectedIndex of cfselect after bind

2012-01-04 Thread webmaster
Yup figured it out. Thanks. var DD = document.getElementById(ItemNameA); var DDSelIndex = DD.selectedIndex; var DDValue = DD.options[DDSelIndex].value; -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday,

CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
We recently had an API call using a CFHTTP start giving a Connection Failure message. In talking with the other company I found out they updated their security certificate. All the comments I have seen in this list and on blogs etc. pertaining to this issue seem to relate to ColdFusion MX. Does

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Thanks for the reply. I am trying the tutorial found here. Short and simple. http://naveenchhabra.wordpress.com/2010/10/18/trusting-certificate-in-co ldfusion-using-keytool-utility/ However it asks me for the cert password. Is this something I need to get from the owner of the cert or am I

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Ok that gave me the Certificate was added to the keystore message but after I restart ColdFusion and I attempt to CFHTTP to the URL I still get a connection failure message. Not sure what to even try next :( -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday,

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Ok my next question would be how do I get the entire chain? Do I have to get it directly from them? So far I have just saved the Certificate from the browser. I was assuming this saved all of them but perhaps it only saves the root one? -Original Message- From: Dave Watts

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Ok did that and the cfhttp worked one time. Now it tells me Connection Failure again. Any ideas? Seems like it should either work or it shouldn't. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, September 06, 2011 2:39 PM To: cf-talk Subject: Re: CFHTTP

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Nope I tried a restart of the service and it still says connection failure. Says I am using JVM 1.6.0_14 What is the latest supported JVM? Seems like it should work all the time or none at all. Seems odd that it works intermittently. I appreciate all your help. -Original Message-

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Does an updated KeyStore come with an updated JVM? -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, September 06, 2011 3:39 PM To: cf-talk Subject: Re: CFHTTP Connection Failure on SSL Nope I tried a restart of the service and it still says connection

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Yeah I'm not sure what to do next. After a reboot it works fine for about 5 min or so then goes back to Connection Failure. Makes no sense. :( -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, September 06, 2011 3:39 PM To: cf-talk Subject: Re: CFHTTP

RE: CFHTTP Connection Failure on SSL

2011-09-06 Thread webmaster
Ok thank you. My next step is to try to update the JVM and see what that does. Makes no sense why it works for a little bit after a reboot then starts Connection Failure again. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, September 06, 2011 4:59 PM To:

Need DHL Code

2011-04-15 Thread webmaster
Can anyone out there point me in the direction of some CF code or software package free or otherwise that interfaces with DHL both domestic and internationally? I see the one with adminprotools but I can't get a reply from them to questions so looking for other possibilities.

RE: Need DHL Code

2011-04-15 Thread webmaster
I've already done some googling. I was just hoping somebody out there in the CF community already knew of a working solution. -Original Message- From: Pradeep Viswanathan [mailto:pradeepviswanatha...@gmail.com] Sent: Friday, April 15, 2011 11:08 AM To: cf-talk Subject: Re: Need DHL

Performance Issue with CFLOOP

2011-03-09 Thread webmaster
Looking for any ideas here. I'm running a cfloop over a query from a database with a little over 60,000 records in it on MSSQL. I am doing a cfflush so I can watch what record it is on so I can keep up with how quickly or slowly the loop is running. The problem is after about 4850ish records

RE: Performance Issue with CFLOOP

2011-03-09 Thread webmaster
Can simply increasing the size of the JVM max heap fix this? Problem is when this loop slows down all of the CFM pages seems to slow down and timeouts start to occur. -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Wednesday, March 09, 2011 4:14 PM To:

RE: Performance Issue with CFLOOP

2011-03-09 Thread webmaster
Thanks a bunch :) -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Wednesday, March 09, 2011 4:34 PM To: cf-talk Subject: Re: Performance Issue with CFLOOP Yes, tweaking your JVM settings (including max heap) *can* fix this. Of course you are limited to

RE: Performance Issue with CFLOOP

2011-03-09 Thread webmaster
Ok I tried this. I took all the flushes out but one so only one timer per loop and ran it over 5000 records. With all the flushes in place total execution time was 111905 ms With only one flush total execution time for the same query was 74622 ms A difference of a little over 37 seconds With

RE: Performance Issue with CFLOOP

2011-03-09 Thread webmaster
This sounds like a good solution. Do you just call the same page over and over with the cfhttp at the bottom passing a record variable until you reach the end of file or you doing something different? -Original Message- From: Mark Mandel [mailto:mark.man...@gmail.com] Sent:

RE: Performance Issue with CFLOOP

2011-03-09 Thread webmaster
I thought of this but not a lot of experience here since in my loop there are lots of ifs and conditions then updates etc. I'm reading up on it though. -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Wednesday, March 09, 2011 9:07 PM To: cf-talk Subject:

RE: Performance Issue with CFLOOP

2011-03-09 Thread webmaster
This sounds like a good solution. Do you just call the same page over and over with the cfhttp at the bottom passing a record variable until you reach the end of file or you doing something different? -Original Message- From: Mark Mandel [mailto:mark.man...@gmail.com] Sent: Wednesday,

Latest Hot Fix Issues

2011-02-10 Thread webmaster
I am getting this random error after applying the latest security hotfix to our CF 9.01 Enterprise installation. Could not initialize class coldfusion.security.ESAPIUtils I get it anytime I try to use cfwindow and I am also getting it when I try to update the sitewide error template in

CMS for CF

2011-01-13 Thread webmaster
I'm looking for a good open source content management system for Cold Fusion. Something like Joomla. Any suggestions out there? ~| Order the Adobe Coldfusion Anthology now!

RE: cfc bind issue

2010-12-01 Thread webmaster
The root would be c:\mysite\ but I am executing the cfc from the admin folder inside the site root. It is hitting the CFC fine because I can see it return all the values like it should using the ajax debugging window. It just doesn't put those values into the drop downs. -Original

cfc bind issue

2010-11-30 Thread webmaster
Ok this one has me scratching my head. I have a cfc located here. C:\mysite\admin\cfc\GetCategoryData.cfc I put this code on a page where I call it using the dot notation and it does not populate the cfselect. The CFC is running fine according to the debugger window. It just doesn't

RE: cfc bind issue

2010-11-30 Thread webmaster
Renaming the cfc directory didn't seem to make any difference. Really odd. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, November 30, 2010 7:04 PM To: cf-talk Subject: Re: cfc bind issue Your bind code looks fine to me, perhaps CF doesn't like

CF Job Opportunity

2010-06-16 Thread Webmaster
Hi All, Long time lurker, first time poster. Hopefully I'm posting this on the right list--apologies if it's out of place here. My organization is looking to hire a ColdFusion/SQL developer. The job is 70% web/database development, and 30% other IT projects (servers, network, etc.). If

RE: coldfusion.ajax.submitform

2010-04-07 Thread webmaster
Thanks. The '' is what I was missing. Always something simple we overlook in the end :) -Original Message- From: Kris Sisk [mailto:ks...@gckschools.com] Sent: Wednesday, April 07, 2010 9:26 AM To: cf-talk Subject: Re: coldfusion.ajax.submitform You're passing an undefined variable

coldfusion.ajax.submitform

2010-04-06 Thread webmaster
Is it not possible to have multiple cfforms on a page and submit them using coldfusion.ajax.submitform I tried this which I would think would work but it just gives this JavaScript error myform is not defined cfajaximport script function submitForm(FormName) {

RE: CFIMAGE Path Issue

2010-01-03 Thread webmaster
Yes it has a value. -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Saturday, January 02, 2010 3:02 PM To: cf-talk Subject: RE: CFIMAGE Path Issue Are you sure the TempFileName variable has a value? Aslo, CF9's VFS might be faster/easier for your temp

RE: CFIMAGE Path Issue

2010-01-03 Thread webmaster
I found the problem. It was that I was using both destination and name. Apparently you can not use them both you have to choose one. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Saturday, January 02, 2010 3:08 PM To: cf-talk Subject: RE: CFIMAGE Path Issue

CFIMAGE Path Issue

2010-01-02 Thread webmaster
I'm trying to use CFIMAGE for the first time and running into an issue. I am guess it is because my path has a period in it but I am not sure and I am not sure how to get around it if that is indeed the problem. I'm using ExpandPath to get the directory path but I have tried it other way with

RE: CFIMAGE Path Issue

2010-01-02 Thread webmaster
I really prefer not to. All of my sites are named with this convention. It would be great if there was another way around this. All my other cfdirectory and cffile stuff works fine with this type of pathing so I'm not sure why cfimage won't. -Original Message- From: Rick Faircloth

CFC Mapping Issues

2010-01-01 Thread webmaster
I'm running CF 9 Enterprise and am having trouble getting a cfc to fire. Here is my invoke which is run after a file upload in a form field. cfset args = StructNew() cfset args.MemberID = #FORM.ID# CFSET args.FileUploaded = #FORM.FileUploaded# cfinvoke

RE: CFC Mapping Issues

2010-01-01 Thread webmaster
Thank you. -Original Message- From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] Sent: Friday, January 01, 2010 10:12 PM To: cf-talk Subject: Re: CFC Mapping Issues webmas...@pegweb.com wrote: I'm running CF 9 Enterprise and am having trouble getting a cfc to fire. Here is my

RE: Server Performance

2009-12-18 Thread webmaster
Thanks Mark this actually helped quite a bit. I didn't realize that option was available in perfmon. Thanks, Patrick J. Hedgepath Pegasus Web Productions webmas...@pegweb.com 803-996-0578 -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, December

RE: Server Performance

2009-12-18 Thread webmaster
Thanks. I will look over these. -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Friday, December 18, 2009 9:01 AM To: cf-talk Subject: RE: Server Performance CFMeetup just had a meeting on Homebrewed ColdFusion Monitoring by Wil Genovese. It was

Server Performance

2009-12-17 Thread webmaster
Is there a way through command line or a 3rd party application to see what web sites on a CF Pro 8 server are causing the most requests? On one particular server it is starting to show behavior of page timeouts and longer running requests. In the Performance Monitor in windows I see the running

RE: Faster SMTP

2009-12-11 Thread webmaster
This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. -Original Message- From: Erik-Jan Jaquet [mailto:erik...@toomba.nl] Sent: Thursday, December 10, 2009 10:44 AM To: cf-talk Subject: Re: Faster

Re: Faster SMTP

2009-12-11 Thread webmaster
So all I would need to do is recreate the txt file that is those .cfmail files or is there more to it than that? Thanks, Patrick J Hedgepath Pegasus Web Productions webmas...@pegweb.com (803)-996-0578 On Dec 11, 2009, at 2:11 PM, Justin Scott jscott-li...@gravityfree.com wrote: This is

Faster SMTP

2009-12-10 Thread webmaster
I have a lot of clients with email newsletters and they all seem to send them out at the same time which backs up in the cfspooler. I have one client in particular that can't wait on the emails from the forms on his site so I was looking into some solutions that would allow their mail to go

RE: Faster SMTP

2009-12-10 Thread webmaster
Yeah I'm using smarter mail for my mail server on a separate server. I have clients where some of them have around 30k email lists. So when you get one of those that goes out it takes the CF server several hours to spool it out since it is pro and not enterprise. So any other email sent by CF

AJAX

2009-07-02 Thread webmaster
Can anyone recommend a good book for AJAX? I want to start working on more web 2.0 style apps and with the new CF server it seems to make it easier. I just need to understand more about it and how it all works. I can JavaScript and I can CF so I wouldn't think it would be too hard to pickup. Any

RE: AJAX

2009-07-02 Thread webmaster
Thanks a lot Andy. I knew there were different frameworks out there but wasn't sure how that fit in with AJAX. I assume they are all AJAX but much like .NET they all have different built in functions etc? -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent:

RE: AJAX

2009-07-02 Thread webmaster
Thanks a lot this is exactly what I needed. -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: Thursday, July 02, 2009 2:54 PM To: cf-talk Subject: Re: AJAX Yes, the frameworks are different, but really, there is only a few that matter, and only one of those that

RE: AJAX

2009-07-02 Thread webmaster
Can you explain in more detail ajaxified widgets? I'm looking to prefetch possible search keywords in a search field. Get a different image from the database when a user clicks and display it without refreshing the page. Change search results without refreshing the page. Stuff like that.

RE: Personalizing a CFLoop

2009-01-05 Thread webmaster
Is the recipient data stored in a table by chance? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:01 PM To: cf-talk Subject: Personalizing a CFLoop CFLoop Problem: I need to take the contents a visitor enters into our form and use

RE: Personalizing a CFLoop

2009-01-05 Thread webmaster
I would just do something like this then. CFQUERY NAME=GetRecipients DATASOURCE=#DataSource# SELECT * FROM Recipients /CFQUERY cfloop query=GetRecipients cfmail to=#GetRecipients.Email# from=#sender_email# subject=My Message To You 2009 #sender_date#

RE: Personalizing a CFLoop

2009-01-05 Thread webmaster
I would just do something like this then. CFQUERY NAME=GetRecipients DATASOURCE=#DataSource# SELECT * FROM Recipients /CFQUERY cfloop query=GetRecipients cfmail to=#GetRecipients.Email# from=#sender_email# subject=My Message To You 2009 #sender_date#

RE: Personalizing a CFLoop - validation error

2009-01-05 Thread webmaster
The only reason it should give you that error is if there is an empty email for one of the records. Try dumping out the same query to a cfoutput to verify. -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 4:14 PM To: cf-talk Subject: RE:

Mail Spooler Woes

2008-10-23 Thread webmaster
I can send 5k emails to my CF8 servers and they each deliver about 1 piece of mail to my mail server every 3 seconds. I can send 5k emails to 1 of my CF7 servers and it sends out the all 5k email to my mail server in about 30 seconds. Does anyone have a suggestion as to where I can look to

RE: Mail Spooler Woes

2008-10-23 Thread webmaster
These 3 servers are on the same network. Using the same mail server. I don't see how network traffic (since they are on the same network using the same router etc.) would make any difference. The only difference I can see if the version of the CF server. I am not seeing any bottlenecks just

RE: Mail Spooler Woes

2008-10-23 Thread webmaster
They are all behind a router together. No routers in-between. I am basically looking to see if anyone else has run into the situation with CF8 Standard. -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2008 5:05 PM To: cf-talk Subject: Re:

RE: Mail Spooler Woes

2008-10-23 Thread webmaster
It's funny you should suggest that. This one machine in particular had CF7 on it and we upgraded to CF8. It used to send mail fine before. :( -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2008 6:42 PM To: cf-talk Subject: Re: Mail Spooler

RE: Mail Spooler

2008-10-22 Thread webmaster
Ok I changed this to every 30 seconds and it still is sending mail from the spooler at about 1 every 3 - 5 seconds. -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 2:51 PM To: cf-talk Subject: Re: Mail Spooler In my opinion having the

RE: Mail Spooler

2008-10-21 Thread webmaster
It goes into the CF Spooler just fine. It just takes forever to go from the spool folder to my actual mail server. -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2008 5:30 PM To: cf-talk Subject: RE: Mail Spooler Is it going to the CFMAIL

RE: Mail Spooler

2008-10-21 Thread webmaster
Is there a setting in the CF8 files to look for? I don't understanf why CF7 spools it out fast and CF8 doesn't. -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2008 5:23 PM To: cf-talk Subject: Re: Mail Spooler One email every five seconds is

RE: Mail Spooler

2008-10-21 Thread webmaster
I have it set to every 5 seconds which is the fastest amount. There is no option for to disk or to memory in the Standard version. I think this is an enterprise feature only. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 12:57 PM

RE: Mail Spooler

2008-10-21 Thread webmaster
Wouldn't increasing the spool interval just increase my problem? -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 1:53 PM To: cf-talk Subject: Re: Mail Spooler The 5 second spool interval is a too quick if you are sending large batches of

RE: Mail Spooler

2008-10-21 Thread webmaster
I'll give this a shot. Thanks for the advice. -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 2:51 PM To: cf-talk Subject: Re: Mail Spooler In my opinion having the spool interval value at 5 seconds is contributing to the problem. If you

Mail Spooler

2008-10-20 Thread webmaster
Upon the heels of my CFMail tag questions I have run some tests. I have a CF8 Standard server and a CFMX7 Standard server that I tested this on. I monitored the CF8 spool folder for a couple of hours. It sent 1 piece of mail every 5 seconds. So when I have a clients newsletter that goes

RE: CFMail Alternatives

2008-10-17 Thread webmaster
Are there any side effects to turn off the spooler? How does it treat the mail then? Does it just send it directly to the mail server each time the cfmail tag is processed? -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 12:52 AM To: cf-talk

RE: CFMail Alternatives

2008-10-17 Thread webmaster
How can I control sending mail to the cf spooler or not from the cfmail tag itself? This seems like it would be the best option. -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2008 10:19 PM To: cf-talk Subject: Re: CFMail Alternatives I

RE: CFMail Alternatives

2008-10-17 Thread webmaster
I also am using SmarterMail Enterprise. The main reason I don't think it is SmarterMail is because I have sent mail to that same mail server from an enterprise version of CF and it went out plenty fast. I have also sent mail to that same Mail Server from ListServ products and it also goes out

CFMail Alternatives

2008-10-16 Thread webmaster
I have clients with large newsletters and if more than 1 of them send them at a time it could potentially send over 10k emails to the cfmail spooler. So naturally I have other clients that are complaining about how long it takes the mail to get delivered. I know there are alternatives out there to

RE: CFMail Alternatives

2008-10-16 Thread webmaster
I think it would be much more cost effective to buy a mail tag than to shell out the $ for Enterprise though. Even if you tell it to use different mail servers it is still using the CF spooler. My mail server isn't the issue the cf spooler is :( -Original Message- From: Raymond Camden

RE: CFMail Alternatives

2008-10-16 Thread webmaster
8 Standard Edition. -Original Message- From: Wil Genovese [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2008 6:00 PM To: cf-talk Subject: Re: CFMail Alternatives What version of Coldfusion are you using? Older versions of CF could take a long time to send spooled messages. It

RE: CFMail Alternatives

2008-10-16 Thread webmaster
Yes I am sure it is the spooler. I sit there and watch it. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2008 9:33 PM To: cf-talk Subject: Re: CFMail Alternatives Are you sure it is the spooler? All you said was that it took a long for

RE: Script on one site

2008-09-03 Thread webmaster
Yeah I did that already. It is in the .cfm files themselves. I also have code in place to prevent SQL injection attacks. I'm hoping these were files I just missed on the first cleanup. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03,

Script on one site

2008-09-02 Thread webmaster
I have one site in particular that keeps getting this kind of stuff on the bottom of .cfm pages right above the /body tag. I have already recreated their FTP account once with a strong password. It seems odd this is only happening to .cfm pages though and only on this site on the server. Any

FCKeditor

2008-08-11 Thread webmaster
Here is my code yet the editor does not seem to work correctly. No toolbar is visible etc. CFFORM ACTION=update_categories.cfm METHOD=POST CFTEXTAREA NAME=Comments ROWS=4 COLS=60 richtext=yes toolbar=Basic#Comments#/CFTEXTAREA /CFFORM Any ideas where I should start to look for problems?

RE: FCKeditor

2008-08-11 Thread webmaster
No this is not working actually. So this means I just need to add a mapping in IIS for the CFIDE directory for this site and it should work? I think I tried that with no joy. -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 12:03 PM To:

RE: FCKeditor

2008-08-11 Thread webmaster
I readded this virtual directory and this time it works. Thanks for the help. -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 12:03 PM To: CF-Talk Subject: RE: FCKeditor If you were to use a cfinput with the 'required='yes'' and the

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
I actually want that field to be a 0 if no data was entered on the form. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, May 23, 2008 4:22 PM To: CF-Talk Subject: Re: Syntax Error In Update Statement On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
One that is not very helpful :( Error Executing Database Query. Syntax error in UPDATE statement. The error occurred in C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line 71 69 : '' 70 : /cfif 71 : WHERE ID=cfqueryparam value=#FORM.ID# cfsqltype=cf_sql_numeric 72 :

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
Even if it is a numeric field in the database? I have tried removing the entire statement from the update query and it still gives an error. Thanks, Patrick J. Hedgepath Pegasus Web Productions [EMAIL PROTECTED] 803-996-0578 -Original Message- From: Charlie Griefer [mailto:[EMAIL

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
Location is a number field. When I try changing it to cfqueryparam value=#FORM.Location# cfsqltype=CF_SQL_NUMERIC maxlength=15 I still get an error. In fact when I remove the statement entirely I still get the error. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED]

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
Ack sorry :( Having the same problem with another DW created query on another page. Here is the correct error. Error Executing Database Query. Syntax error in UPDATE statement. The error occurred in C:\users\respiratorydiagnosticsllc.com\www\admin\EditCompany.cfm: line 71 69 : '' 70 : /cfif 71

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
When I change it to CF_SQL_NUMERIC the error persists. Even if I remove the entire statement , Location=cfif IsDefined(FORM.Location) AND #FORM.Location# NEQ cfqueryparam value=#FORM.Location# cfsqltype=CF_SQL_NUMERIC maxlength=15 cfelse 0 /cfif The error still persists. -Original

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
It is a number field in an Access DB. Below is the entire query. cfif IsDefined(FORM.MM_UpdateRecord) AND FORM.MM_UpdateRecord EQ form1 cfquery datasource=#DSN# name=UpdateCompany UPDATE HomeCareCompany SET Active=cfif IsDefined(FORM.Active) 1 cfelse 0 /cfif , Location=cfif

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
Well first off this was code generated by Dream Weaver using the testing server environment so yell at Adobe. Can I write it from scratch myself sure but I was trying to save time. All it appears to have done is waste time. Why would this give you a heart attack. This query was working until I

RE: Syntax Error In Update Statement

2008-05-23 Thread webmaster
I would assume it is because it is a keyword used in SQL or Database syntax. Again Dream Weaver wrote the code. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, May 23, 2008 5:30 PM To: CF-Talk Subject: Re: Syntax Error In Update Statement why is the

RE: IO error on server communication

2008-04-16 Thread webmaster
I think it is just port 80 and yes that is open. Thanks, Patrick J. Hedgepath Pegasus Web Productions [EMAIL PROTECTED] 803-996-0578 -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 3:44 AM To: CF-Talk Subject: Re: IO error on

RE: IO error on server communication

2008-04-16 Thread webmaster
I ran this and it showed RDS as true but I still get the IO error when I browse for a database in the admin etc. Thanks, Patrick J. Hedgepath Pegasus Web Productions [EMAIL PROTECTED] 803-996-0578 -Original Message- From: Vamseekrishna Manneboina [mailto:[EMAIL PROTECTED] Sent:

IO error on server communication

2008-04-15 Thread webmaster
I am getting this IO error on server communication when I try to browser for a file in the CF administrator. I understand this might be related to RDS and since I cannot seem to connect with RDS either I'm pretty sure RDS is the root of my problems. However I'm not sure how to fix it. Anybody run

RE: IO error on server communication

2008-04-15 Thread webmaster
I checked the web.xml file and according to it RDS is enabled. Thanks, Patrick J. Hedgepath Pegasus Web Productions [EMAIL PROTECTED] 803-996-0578 -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 10:42 PM To: CF-Talk Subject: Re: IO error

CFMDIRECTORY

2007-06-01 Thread webmaster
Where can I get a copy of the custom tag by Pablo Verando called CFMDIRECTORY? I see it was available on CFM-Resources.com but alas, it has been taken down :(. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard

Re: Form Post Capture

2006-09-16 Thread webmaster
I guess the main issue is that we need to post the video to Google first, using our Google account, ( I found this on Google's site... working on integrating it into our app now http://code.google.com/apis/accounts/AuthForInstalledApps.html )and all we would need would be just the reference

Form Post Capture

2006-09-15 Thread webmaster
Anyone have any suggestion how we can capture in our database, our video post data we post to google so we can post it automatically on our site in a list linking to the Google Video page? We don't really need the upload itself... we just need the name of the video we post to google video

Escaping #'s in outputting a CSS

2006-04-19 Thread webmaster
Stupid beginner question I know but it's been a long time since I've done any REAL CF coding. I am trying to create an HTML code generator for a client and am having problems escaping the #'s in the CSS. I tried the good ole ## but that's not working. It throws an error. If I just remove

Re: Need query help please

2005-11-03 Thread Webmaster at FastTrack On Line
The way I do it on a couple of sites is to store large images in one folder and thumbs in another. I store one file name in the db table and just use: #application.photos#\#table.jpeg_name# or #application.photos_thumb#\#table.jpeg_name# Jenny

Re: SHOUTING

2005-10-30 Thread Webmaster at FastTrack On Line
Maybe the Lcase function? Jenny - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 24, 2005 6:02 PM Subject: stop: SHOUTING Hi guys, Just wondering if anyone knows a good way to recognise when all the

Re: WAY OT: Configuring FCKEditor

2005-10-30 Thread Webmaster at FastTrack On Line
Hi Jay, I'm having a real headache with this fck config, do you have any install notes I could take a look at please? I've got it all working but the graphics upload :-S Thanks, Jenny - Original Message - From: Jay Greer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent:

Re: timed event in CF

2005-10-25 Thread Webmaster at FastTrack On Line
Hi Roberto, I think this is what you need ... http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt229.htm cfschedule .. Hope this helps, Jenny - Original Message - From: Roberto Perez [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26,

Re: godaddy.com now has CFMX7 hosting!

2005-10-15 Thread Webmaster at FastTrack On Line
or about 50p uk ;) also j/k .. hehe - Original Message - From: Ray Champagne [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, October 14, 2005 10:08 PM Subject: Re: godaddy.com now has CFMX7 hosting! $24.95 Canadian, eh? What's that, like $5.00/ mo US$? J/K,

Re: CFFTP thru Corporate Firewall

2005-10-11 Thread Webmaster at FastTrack On Line
Hi Mario, Perhaps this is the case: The cfftp is running from your CF server and the ftp is running from your workstation. Assumption being your development pc and server pc aren't one and the same? So, you'd need to see how the firewall rules differ from your server to your workstation. I

Re: Time management

2005-10-11 Thread Webmaster at FastTrack On Line
Hi Donna, Number 1, don't have people coming to your desk if you can at all help it. Tell them all requests for change have to be at least emailed, better still sent to you on a form. Get buy in to your need to manage your time from your line manager or you are really up there without a

Re: image manipulation in coldfusion?

2005-10-10 Thread Webmaster at FastTrack On Line
I'm catching up on this thread, but ... I do think CF should have image manipulation. I'm not about to go and learn Java or anything vaguely codey if i can possibly help it, not enough hours in the day and I bought CF for the very reason I would never have to learn Java! Programming at that

Carriage returns

2005-10-10 Thread Webmaster at FastTrack On Line
I'm using a form text area inout to store data into an ms sql nvartext field. My problem is that when the field is displayed all of the carriage returns are lost and it ends up one big blob of hard to read text. Is there some way I can format so that the carriage returns work, please? Jenny

Re: Carriage returns - sorted

2005-10-10 Thread Webmaster at FastTrack On Line
PROTECTED] -Original Message- From: Webmaster at FastTrack On Line [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 9:19 AM To: CF-Talk Subject: Carriage returns I'm using a form text area inout to store data into an ms sql nvartext field. My problem is that when the field

  1   2   3   4   >