RE: Could use some inputs

2009-08-05 Thread Mark Kruger
Don, You are giving us the wrong information here. What you should post is the code in question and a description of the former environment (cf8 + what? MSSQL?) and the new environment. -mark -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Wednesday, August 05, 2009

RE: Web service error

2009-08-05 Thread Mark Kruger
You need to set the access level for the function to remote if you wish to use it as a WS. cffunction name=echoString Access=remote -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: ch g

RE: Web service error

2009-08-05 Thread Mark Kruger
A quick test on my own server shows that your function works fine. cfset x = createobject(webservice,http://www.ecodes.biz/UserVerif.cfc?wsdl;).echoSt ring(hello World)/ cfoutput#x#/cfoutput I suspect you have compiled the WSDL and the stub is being cached. You need to refresh the cache...

(ot) Twitter down

2009-08-06 Thread Mark Kruger
H I just tried to tweet on one of my blog posts and noticed that twitter is down and I've heard facebook is having problems as well. In a completely unrelated story palid teenagers are emerging from basement hideaways and over-garage bedrooms by the thousands, blinking and squinting at

RE: (ot) Twitter down

2009-08-06 Thread Mark Kruger
Charlie, (lol) ... I didn't get it either but I didn't say anything because I didn't want to appear du... (doh!) ... Never mind. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Charlie Griefer

RE: CF and Java

2009-08-07 Thread Mark Kruger
Alan, Getting in on this late (sorry). This tag decoder allows you to do what - get at the dimensions of the stage in the swf file? Pretty cool. Does it allow for anything else? Like extracting the embedded assets etc? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105

RE: Excel File Parser for ColdFusion

2009-08-07 Thread Mark Kruger
Well here's one approach. Keep in mind that CF9 will have some good features for this sort of thing. http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original

RE: Excel File Parser for ColdFusion

2009-08-07 Thread Mark Kruger
, Aug 7, 2009 at 11:17 AM, Mark Kruger mkru...@cfwebtools.com wrote: Well here's one approach. Keep in mind that CF9 will have some good features for this sort of thing. http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105

RE: cftable query

2009-08-12 Thread Mark Kruger
I suspect you won't get much help with this. I've never seen CFTABLE used to produce Excel content - although under the hood it produces HTML so I guess why not. Still, I think most of us (myself included) would suggest a different method with more control over formatting ... Like creating HTML

RE: cftable query

2009-08-12 Thread Mark Kruger
Cool...glad I could help. -Mark -Original Message- From: vidya yegnaraman [mailto:viduka...@gmail.com] Sent: Wednesday, August 12, 2009 4:45 PM To: cf-talk Subject: Re: cftable query Thanks Mark, I used html table and that worked I suspect you won't get much help with this. I've

RE: CFDOCUMENT SRC= and Dynamic HTML

2009-08-14 Thread Mark Kruger
Brook, I don't think that DHTML will render correctly for cfdocument no matter what you do. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent:

RE: ColdFusion Web Service question

2009-08-19 Thread Mark Kruger
I would suspect the WSDL file and examine it first. If the WSDL file is missing some node then perhaps the compiler is creating path information but has not methods to stub out. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com

RE: submit one big form post of all tabs

2009-08-25 Thread Mark Kruger
Glyn, I have done this using cflayout and wrapping the whole set of tabs in from tabs. What problems are you experiencing? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Glyn Jackson

RE: submit one big form post of all tabs

2009-08-25 Thread Mark Kruger
Sorry I meant wrapping the whole set of tabs in 'form tags' ... I didn't mean to confuse you :) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com

RE: Cfemail issue(s)

2009-08-27 Thread Mark Kruger
Victor, Do you mean you are passing a list of 500 addresses in a single attribute? As in: cfmail to=b...@blah.com,bl...@blah.com ... If that is what you are doing I would not be surprised if there is a buffer for that attribute that truncates your string at some point. You would be better

RE: submit one big form post of all tabs

2009-08-28 Thread Mark Kruger
Ah... Right ... Actually I think it treats those includes more like frames or ajaxian innerHTML elements. You would likely have to write some JS to extract the form elements prior to submission. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com

RE: Stung by HostMySite price increase?

2009-09-04 Thread Mark Kruger
Yes the proc license is really the only way to go... The difficulty in switching depends greatly on your code. IT could be quite easy - or require rewriting every query. I recently helped a customer go from MySQL to MSSQL and I wrote a couple of posts on it. It will give you an idea of the type

RE: Coldfusion + Cloud

2009-09-16 Thread Mark Kruger
If you are using EC2 you might find a saved instance with CF (trial) pre installed (I know there is one for Blue Dragon/MySQL/CentOS for example). Spool up the instance amd use it - keep in mind that the CF license agreements are probably violated by production cloud usage (not sure on this point

RE: coldfusion barcode

2009-09-18 Thread Mark Kruger
Friend and Guru Ryan Stille produced a bar code component for us that uses an inexpensive commercial java class. http://www.stillnetstudios.com/2d-barcodes-coldfusion/ -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com

RE: Help: DSN across VPN with virtual IP

2009-09-20 Thread Mark Kruger
Kris, I would take the time to create a test script and try to access ANY file on the share (like a text file). You must use the unc path formatted correctly (\\servername\sharename\path\filename.mbd). One other thing that is often forgotten is that the ODBC system in MX is a separate

RE: Help: DSN across VPN with virtual IP

2009-09-21 Thread Mark Kruger
Kris, No problem. Send me a note if you get it figured out. I'll be curious. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Sunday, September

RE: Form Output Iteration/Looping Question

2009-09-23 Thread Mark Kruger
Something bothers me about your code below... tr#form.vendor_id5#td#form.nvc_id5#/td/tr Shouldn't there be a td after the tr Anyway, you could do the same thing like so... cfoutput cfloop from=4 to=49 index=x trtd#form['vendor_id' x]#/tdtd#form['nvc_id' x]#/td/tr /cfloop /cfoutput

RE: cfc's above the webroot

2009-09-24 Thread Mark Kruger
Phil, You can create a CF mapping that points to your data directory ... Say 'cfclib' ... And then use it as in: Component=cfclib.cfcfilename Keep in mind that a CFC outside the web root is going to be innaccessible via Ajax or remoting (of course you could extend it using a component inside

RE: cfc's above the webroot

2009-09-24 Thread Mark Kruger
It's always good to be security conscious :) Without the ability to fully control the server here's one trick (a little clunky but serviceable). You can put your CFCs in a subfolder and include an application.cfc in the subfolder that aborts any requests directly to that folder.

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Robert, Find the serial number (in license.properties) and go to an existing CF installation - even one on your dev box - and update the serial number. Then look at the server settings. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Original Message Subject: RE: Cold Fusion Enterprise or Standard Installed? From: Mark Kruger mkru...@cfwebtools.com Date: Mon, September 28, 2009 2:21 pm To: cf-talk cf-talk@houseoffusion.com Robert, Find the serial number (in license.properties) and go to an existing CF installation - even

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Log into he CF admin (i.e. http://127.0.0.1/cfide/administrator/. On the left hand side under server settings there is a link to settings summary. Click on it and at the top you will see something like the following: Server Product ColdFusion MX Version 7,0,2,142559 Edition Standard

RE: Cold Fusion Enterprise or Standard Installed?

2009-09-28 Thread Mark Kruger
Er Uh Hmmm Good question. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Monday, September 28, 2009 3:41 PM To: cf-talk Subject: Re: Cold Fusion

RE: CF load times on VPS

2009-10-07 Thread Mark Kruger
Chip, As Jordan pointed out much of the stuff to check will be up to your NOC support guys. Here's things that come to the top of my head. Sometimes hosts use virtual network to isolate your system from other systems in the same data center or on the same rack. In that case the connection is

RE: Rather big log

2009-10-08 Thread Mark Kruger
You may also need to delete the client key. It could be that the Registry is full and new entries are not able to be written. If you switch to something else (DB or cookie), the CF routine that handles purging will still attempt to clear out these variables. If you do decide to clear navigate

RE: cfcontent create file

2009-10-14 Thread Mark Kruger
Richard, You don't really need CFCONTENT (which actually sets up headers in the browser). You are not trying to send your content to the output buffer of IIS. Try cfsavecontent instead. cfsavecontent variable=content {\rtf1\ansi\ansicpg1252\uc1\deff0=stshfdbch0 etc... /cfsavecontent cffile

RE: CF8, 64 bit, and Microsoft Access

2009-10-15 Thread Mark Kruger
There IS an Access driver that is 64 bit. It is httx. You can also jury rig a proxy ws to a 32bit server (which is how I handled it for a data export). That approach assumes you have access to both types of server and on a shared host is probably out of the question. The 64bit driver may be out

RE: After the fact: SQL Injection Scanner

2009-10-21 Thread Mark Kruger
If the injection was the one that went around a few months ago - check out this post http://www.coldfusionmuse.com/index.cfm/2008/7/18/Injection-Using-CAST-And-A SCII There is a reverse stored procedure that can undo the damage down in the comments. Be sure and read the post and comments (and

RE: Education

2009-10-23 Thread Mark Kruger
Rick, That is so funny I have a BA in Theology, a BA in Music and I'm just shy of a master in Sociology - and here I am working in computer development :) It's not surprising how many folks have Music as a part of their skill set who are also programmers. There's a natural synergy there I

RE: Trouble with query...

2009-10-24 Thread Mark Kruger
Not ifnull ... I'ts isnull .. ISNULL(col,0) AS alias Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Saturday, October 24, 2009 6:04 PM To: cf-talk

RE: Hosting options

2009-11-10 Thread Mark Kruger
James, Have you thought of cloud hosting using BD or Ralio? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Tuesday, November 10, 2009 9:16 AM

RE: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Mark Kruger
You cannot use the ODBC service on a 64bit server. It will not work. You will have to go to plan B. Might I suggestion the Access driver from httx - or moving away from access (which is your best option). -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com

RE: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Mark Kruger
Take a look at this post... And read the comments as well. http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Yves Arsenault

RE: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Mark Kruger
that to work? Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. On Mon, Nov 16, 2009 at 2:59 PM, Mark Kruger mkru...@cfwebtools.com wrote: Take a look at this post... And read the comments as well. http://www.coldfusionmuse.com

RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph

2009-11-19 Thread Mark Kruger
Dom, That is a GREAT play by play... Thanks! Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Thursday, November 19, 2009 9:09 AM To: cf-talk

RE: CFHTTP Connection Failure

2009-11-19 Thread Mark Kruger
I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent:

RE: CFHTTP Connection Failure

2009-11-19 Thread Mark Kruger
: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.comwrote: I would say to check the keystore and make sure the cert (and any intermediate certs

RE: CFHTTP Connection Failure

2009-11-19 Thread Mark Kruger
with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. On Thu, Nov 19, 2009 at 11:53 AM, Mark Kruger mkru...@cfwebtools.comwrote: Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore

RE: How to register Fonts for CF8 Enterprise installation?

2009-11-22 Thread Mark Kruger
Dave, That's a new one It kind of looks like it's blowing up trying to enumerate. Perhaps it has a permissions problem? What's the service settings for the CF Ap server? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com

RE: How to register Fonts for CF8 Enterprise installation?

2009-11-23 Thread Mark Kruger
H Try copying some true type files into a separate directory somewhere ... Maybe in the ColdFusion directory itself Although I'm struggling to come up with a theory why that would help :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com

RE: How to register Fonts for CF8 Enterprise installation?

2009-11-23 Thread Mark Kruger
Aha! ... I missed that one. Indeed.. You should be inside of each of your separate instance managers - yes? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Maureen Barger [mailto:m...@cornell.edu]

RE: remote FTP directly from client browser

2009-11-23 Thread Mark Kruger
Robert, I don't think you will be able to do this Unless perhaps you can use a unc path or mnt to some other server (although I fail to see how this would be more secure). What you need is to be able to FTP from the client directly to the FTP server. I guess you will need to look for a Java

RE: remote FTP directly from client browser

2009-11-23 Thread Mark Kruger
Ben, But wouldn't the file be written to physical memory? And if so, you could not guarantee that the OS isn't caching part of the file in the Swap (Unless I'm misunderstanding). Still, it might be enough to check off his requirement. I suspect they won't want the web server to touch the file at

RE: cfsqltype error

2009-11-30 Thread Mark Kruger
If you change something on the server (add a column to a table for example) ColdFusion still holds onto the old schema. Consequently it tries to insert into a column that is incorrectly mapped (via the tableid or whatever in the system tables of the db in question). Here's a post with the scoop.

RE: CF7 multiserver config with JRun and SSL = 500 errors

2009-12-02 Thread Mark Kruger
Am I wrong... It sounds like you are trying to get the site to be served via SSL - that would not require you to do anything with the keystore. The keystore comes into play when CF has to make HTTP calls to an SSL URL (cfhttp, web service etc). -mark Mark A. Kruger, CFG, MCSE (402) 408-3733

RE: Writing query to a csv file

2009-12-09 Thread Mark Kruger
Well.. The code below would uh... Create the same file over and over with only the last row... Unless I'm reading it wrong ;) What you needs is something like Cfsavecontent variable =csvcfoutput query=get_all ##TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed

RE: convert this cfscript back to tag?

2009-12-10 Thread Mark Kruger
Ok... But why? Other than the pound signs it seems fine to me... Except that form.ID will always be the last item in the list once you are done with the loop. cfloop list=#form.whattoupdate# index=tempval cfset form.id = tempval/ cfset form.newRank = form[rank_ tempval]/

RE: Load-balancing servers

2009-12-10 Thread Mark Kruger
Rick, The questions to ask are - what are you doing with session variabls and client variables, and .. What are the capabilities of your chosen load balancing method. Remember that the potential here is for a user to bounce back and forth between your servers while surfing your site - so you

RE: Long Running Processes in ColdFusion

2009-12-10 Thread Mark Kruger
Great rundown Brad -mk -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] It has always been my understanding that CF was better suited to fast running processes. In general, fast request times are desired when they are a response to a web request. Nobody is

RE: Faster SMTP

2009-12-11 Thread Mark Kruger
There is more to it than that. Javamail translates the spooler file into smtp commands which result in the file on the SMTP server. Get ahold of one of the .eml files from the /queue directory of the IIS SMTP server.. That's the one you need to emulate. -Mark Mark A. Kruger, CFG, MCSE (402)

RE: For consideration...

2009-12-11 Thread Mark Kruger
I like it in principle but what is your idea of ajax based server side validation... Server side validation needs to always be done prior to the server uitlizing the inputs (inserting into the DB etc). You can't validate using an ajax request and THEN submit the form values using a submit

RE: For consideration...

2009-12-11 Thread Mark Kruger
place. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/12 Mark Kruger mkru...@cfwebtools.com: You can't validate using an ajax request and THEN submit the form values using a submit request... You sumbit the form and then validate

RE: Server Performance

2009-12-18 Thread Mark Kruger
2 things for you. First, check the DB for blocks and locks - about 9 times out of ten queuing requests are due to DB requests that are hanging. For some reason we web developers bang our head against CF over and over thinking there is something we can do on the web server to solve problems that

RE: Server Performance

2009-12-18 Thread Mark Kruger
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 18, 2009 8

RE: SQLServer Express and SQLServer - totally compatible?

2010-01-04 Thread Mark Kruger
Leaving aside the advisability of doing this :) I have detached and reattached SQL 05 express DBs to prod servers and vice versa - and I will give you a qualified Yes that what you want to do will work. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com

RE: SQLServer Express and SQLServer - totally compatible?

2010-01-04 Thread Mark Kruger
Dave, I didn't catch that it was an external drive - I think if it's an external USB drive you might be right - I was thinking more along the lines of a hot swap sata drive on a sled that plugs into a empty bay. I know with 2000 you could only do direct attached, but now days there are so

RE: Recent SQL Injection attacks

2010-01-13 Thread Mark Kruger
Michael, Yes... Certain types of installations of MySQL are subject to character injection attacks. http://www.coldfusionmuse.com/index.cfm/2008/2/22/sql-injection-on-a-charact er-field Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com

RE: ColdFusion|JRun CPU and|or memory problem.

2010-01-20 Thread Mark Kruger
Ian, Doing triage I always look at (in order). 1) client vars - are they stored in the registry? If so you could have an issue deleting that that shows up as the purge process starts hitting actual values to attempt to delete. 2) DB issues - Trouble on the DB spells trouble for the CF Server

RE: 64bit CF Server and System DSNs - Solved

2010-01-20 Thread Mark Kruger
That is an outstanding tip... Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: Wednesday, January 20, 2010 8:14 PM To: cf-talk Subject: Re: 64bit CF Server and

RE: ColdFusion|JRun CPU and|or memory problem.

2010-01-20 Thread Mark Kruger
I'll second that on the memory tracking - I wish I could disable the button so an unwary admin doesn't accidentaly crash the server for me (yikes). Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From:

<    1   2   3   4