RE: Use CF to delete directory and files in it?
Create a batch file and use cfexecute. -Mark -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 10:36 AM To: CF-Talk Subject: Use CF to delete directory and files in it? I'm trying to find a way to delete a directory with files in it. cfdirectory requires the the directory to be empty before you delete it. What is the best way to delete all the files in the folder? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: get file
You can use cfcontent to serve the file - it does not even need to be inside the web root. -Mark -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 10:29 AM To: CF-Talk Subject: get file Hi, I have files on our server and I want people (once they're logged in) to download a file without knowing hte path of the file.. Right now I was doing a popup with the file (a PDF) and it was alright.. but now that many anti-virus or google toolbar are blocking pop up file, I need another solution.. Do you have an idea? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Server not running...but running...um, help?
I think your service is not being handed the request. I would run the connectors. It looks like an encrypted file being served by IIS (instead of being processed first by CF) - sort of like seeing the source code on an unecrypted file. -mark -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 10:01 AM To: CF-Talk Subject: Server not running...but running...um, help? When I try to go to the admin page on our development server (http://development.ourdomain.com/CFIDE/administrator/index.cfm), I'm seeing nothing but gobbeldygook (first line sample: Allaire Cold Fusion Template Header Size: New Version£~¬h/¥hq¤8X°¿©?P^qv N?F' o¦^9.) However, the service is running, and sites on the server are working correctly (http://development.ourdomain.com/testingsite1/ works for instance). Even when I walk over to the machine and try locally (http://localhost/CFIDE/administrator/index.cfm) it gives me a 404. I've restarted the CF service and even rebooted the entire serverwhere to look now? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Server not running...but running...um, help?
Jeff, I'm speaking of the little batch files buried in the /cfusionmx/ directory that remove and re-add the necessary connectors for the jvm.If you are running CF the process is to remove the extension mappings in the IIS admin for the application. As for your problem - hmmm did you recently upgrade from cf 5 to cfmx? -Mark -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 10:42 AM To: CF-Talk Subject: Re: Server not running...but running...um, help? I think your service is not being handed the request. I would run the connectors. It looks like an encrypted file being served by IIS (instead of being processed first by CF) - sort of like seeing the source code on an unecrypted file. Nah, see, pages *within* the server are working and are being handed off to CF...Here's what I've got: ON THE MACHINE - http://localhost/ - works REMOTELY - http://development.domain.com/ - works ON THE MACHINE - http://localhost/CFIDE/administrator/index.cfm - GobbeldyGook REMOTELY- http://development.domain.com/CFIDE/administrator/index.cfm - GobbeldyGook Also... REMOTELY - http://development.domain.com/ClientSite1 - Works REMOTELY - http://development.domain.com/ClientSite2 - Works etc... Also, how would one run the connectors? Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Server not running...but running...um, help?
Dave, I suggested that earlier - but he says that other .cfm files on the same configured sites run correctly. wouldn't that indicate that the connector was correctly installed? -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 11:40 AM To: CF-Talk Subject: RE: Server not running...but running...um, help? When I try to go to the admin page on our development server (http://development.ourdomain.com/CFIDE/administrator/index.cf m), I'm seeing nothing but gobbeldygook (first line sample: Allaire Cold Fusion Template Header Size: New Version£~¬h/¥hq¤8X°¿©?P^qv N?F' o¦^9.) This indicates that your web server doesn't know to process those files as CF files, and instead is just returning them as if they were HTML files. You'll need to either ensure that your web server is configured correctly, or reinstall the CFMX web server connector, or both. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Automated Scripts?
Richard, Write your script - then use the cf admin scheduled tasks to make it run each morning. If you don't have access to admin but cfschedule is enabled you can use that tag to create a reoccuring task. -mark -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 11:39 AM To: CF-Talk Subject: Automated Scripts? I'm trying to figure out how to run some Cold Fusion scripts automatically. For example: our users have logins that expire every three months.I'd like to set up a script which would run each morning to scan all of the users in the database, and send an e-mail to those users whose logins will be expiring in a week. I've looked through the CF Admin page, and haven't found any settings or anything which would set this up. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Quickbooks IIF files???
You are correct - the iif file is pretty much a comma delimited ascii file. The answer you need is actually in the quickbooks help files - here's an excerpt. -Mark --- You may also want to refer to the Reference Guide to Import Files Note: These instructions are rather long. You may want to print them instead of reading them onscreen. To print them, click Options and then choose Print Topic. If you've been using another financial software product, and you'd like to import information from that product into QuickBooks, you can do so if the product allows you to export to a spreadsheet or text file. You can import lists that correspond to QuickBooks lists, budgets, and individual transactions. Tip: The easiest way to see and understand the format QuickBooks needs to import data is to export some of your QuickBooks lists and view the resulting file in a spreadsheet. If you don't already have a QuickBooks company, you can export lists from the sample data (sample_product-based business. Qbw or sample_service-based business.qbw). 1 Open the spreadsheet that contains the data. 2 Move the contents of all the cells in your spreadsheet one column to the right so that the first column is blank. 3 Move the contents of all the cells down by one row so that the first row is blank. 4 Check the structure of the spreadsheet. If it contains more than one type of listor a mixture of lists, budgets, and transactionsmake sure that each type of information has its own block in the spreadsheet. The blocks should follow each other vertically. Insert a blank row of cells to separate the blocks. For example, it you have a list of customers and a list of vendors, all the customer data should be in one block and all the vendor information should be in another block. 5 In the first cell in the blank row above each block of information, enter one of the keywords shown in this table. Be sure to include the exclamation point (!). Type this text. . . If the block contains !ACCNT Details about your chart of accounts. !CUST A customer address or phone list. !VEND A vendor address or phone list. !EMP A list of employees. !OTHERNAME A list of names you'd like to add to QuickBooks Other Name list. !BUD Budget details. !CLASS A list of general classifications you'd like to add to QuickBooks Class list. !CTYPE A list of customer classifications you'd like to add to QuickBooks Customer Type list. !INVITEM Details about the line items you use on sales and purchase forms. !INVMEMO Messages you'd like to add to QuickBooks Customer Message list. !PAYMETH A list of payment methods you'd like to add to QuickBooks Payment Method list. !SHIPMETH A list of shipping methods you'd like to add to QuickBooks Ship Via list. !TERMS A list of payment terms you'd like to add to QuickBooks Terms list. !TIMEACT Details about activities you timed with the QuickBooks Pro Timer. Works with !TIMERHDR. !TIMERHDR QuickBooks Pro Timer data. !TODO A list of upcoming to do tasks you want QuickBooks to remind you about. !TRNS Transactions. !VTYPE A list of vendor classifications you'd like to add to QuickBooks Vendor Type list. For example, if the spreadsheet contains a list of customers and then a list of vendors, the structure of the spreadsheet would be as follows: !CUST [List of customers] !VEND [List of vendors] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOLUTION: Re: Okay, go here to see what I'm talking about...(cfserver not r unning correctly)
Jeff, And what was the solution prey tell - or did I miss that? -Mark -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 3:56 PM To: CF-Talk Subject: SOLUTION: Re: Okay, go here to see what I'm talking about...(cfserver not r unning correctly) Looks like it's all fixed now. Dave must've been right. Dave, where in the world did you learn that trick??? I've put it up on the DON'T ERASE section of our server room whiteboard. Now, I wonder if spinning on through 720 degrees or just increasing the rotational speed will make the machine run better too!?!?! Okay, I don't actually HAVE a solution...but this is what I DO have... Now, it works... Legit. I mean, now, as of about 5 minutes ago...it just STARTED to work. Yes, out of the blue... I have advanced crippy troubleshooting skills apparently...I'm like, the Gandalf of troubleshooting. I scare the problem so badly that it just fixes itself [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BlueDragon cfinclude issues
You are not modifying it for path so fileexists( ) should crap out - unless BD does relative paths... does it? Also - what's with the evaluate( ) function? Seems superflous to me. -mk -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 9:31 AM To: CF-Talk Subject: BlueDragon cfinclude issues This happens on BD 6.1 as my dev server. I have this code: cfset variables.incfilename = attributes.mode .cfm cfif fileexists(evaluate(variables.incfilename)) cfinclude template=#variables.incfilename# cfelse Which produces the error: CFML Runtime error: billingandshipping.cfm does not exist. So I replaced the whole thing with this code: cfinclude template=billingandshipping.cfm And it all works just fine??? So then I changed the original, just to test, like this: cfset variables.incfilename = billingandshipping.cfm cfif fileexists(evaluate(variables.incfilename)) cfinclude template=#variables.incfilename# cfelse Which produces the error: CFML Runtime error: billingandshipping.cfm does not exist. Has anyone got any bright ideas on why this is so? In both instances where it is throwing the error, it gets to the cfinclude, but thinks the file doesn't exist. But the middle one just including the file straight away works perfectly. Incidentally, the first, second and third code blocks all work fine on my prod server running CFMX. Thanks, Ferg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BlueDragon cfinclude issues
Matt, Yes but... fileexists requires the fule path (i.e. e:\wwwroot\index.cfm - not just index.cfm) so I would definitley expect the cfif to return FALSE - or am I missing something? -mark -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 10:05 AM To: CF-Talk Subject: RE: BlueDragon cfinclude issues In testing locally I found that FileExists() seems to be the problem. Basically, nothing inside the cfif executes. Simply including a template based on a variable without checking to see if it exists works. In fact, the following template shows this strange behavior. cfset foo = index.cfm cfif FileExists(foo) cfabort /cfif cfinclude template=#foo# When called index.cfm will be included. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Ferguson Sent: Thursday, August 19, 2004 10:43 AM To: CF-Talk Subject: RE: BlueDragon cfinclude issues Right, first I had cfif fileexists(variables.incfilename), but it yields the same result, I was just playing around to see if anything would help and my last revolution was trying the evaluate. It doesn't really matter though, because it IS getting past that cfif and into the cfinclude, but then it craps out. Ken Ferguson Fitz and Floyd http://www.fitzandfloyd.com http://www.fitzandfloyd.com http://www.exclusivelyfitz.com http://www.exclusivelyfitz.com/ http://stores.ebay.com/fitzandfloydscharmingtails _ From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 9:40 AM To: CF-Talk Subject: RE: BlueDragon cfinclude issues Maybe I am reading the following line wrong, but it looks like you are trying to evaluate the filename as a variable. cfif fileexists(evaluate(variables.incfilename)) Shouldn't the above be as follows? cfif fileexists(variables.incfilename) -Matt _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BlueDragon cfinclude issues
full path not fule -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 10:12 AM To: CF-Talk Subject: RE: BlueDragon cfinclude issues Matt, Yes but... fileexists requires the fule path (i.e. e:\wwwroot\index.cfm - not just index.cfm) so I would definitley expect the cfif to return FALSE - or am I missing something? -mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: My First Shopping Cart
Adam, I'm with you on the plugins.I had the same experience with foresite coupons in Able commerce. As for CF Webstore - Mary Jo. has a great product - inexpensive with lots of features and easy to work with. More features for the buck than 300.00 really deserves when it comes down to it. If you do a lot of small to medium single tier e-commerce site you can make good money buying her software, adding a few customizations and launching a fully functional ecommerce site with lots of features for the price - and it looks as professional as you want it to look g. Let's not forget that for some things a slightly hoky site can sell quite well (ha). I'm tempted to add a couple of URLs I know that sell gangbusters but don't look that professional (ha) - but I will resist. What really drives most people crazy working with canned apps is the fact that it is not done the way they would do it - it's not in their style.No matter what the framework is, or how well commented it is - it still takes a good bit of leg work just to runsomething down in order to modify it. When, if it was done by you ... you would know exactly where to go to change something. The other issue is modifications themselves. It's hard to modify someone elses code and get it right. But embrace the pain! Modifying existing code or adding a new application to an existing suite of applications - that's really WHY contractors and small shops are necessary. If everything could be bought off the shelf.. if there were no special needs... then companies like microsoft and AOL would own everything and we would all be automatonic grunt coders (ha). Personally, everytime I see a new technology or a messy new standard or approach I simply thank my lucky stars.If it ever gets TOO simple we are all going back to flipping burgers g. That's my take. -Mark P.S. Also, if you do a lot of ecommerce sites, Mary Jo offers a volume discount... so you make a little money on markup. -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 2:40 PM To: CF-Talk Subject: Re: My First Shopping Cart My problem with add ons is that add-ons only work with the original package, once again my experience. We bought foresite design's coupon program, which we knew would never work with our modded version, to get ideas. When I looked at how much recode would be needed, just for fun, to use foresite's package I nearly passed out. I agree fusebox will ease customization but you are limiting your audience by forcing that framework on your clients. At that point and I for one would refuse to purchase it simply based on the fact it uses fusebox. *Puts on flame retardant suite*I also think it looks unprofessional, but hey thats just me :) Don't get me wrong premade packages have their usefulness. Companies just starting out that don't know what they want like our company was. Without the premade package my company probably would have never made it onto the web and I would never have been hired. For $300 its worth it, simply use a storefront out of the box to get something out there. I mean lets face it even at minimum wage I doubt I would get a complete shopping cart coded in $300 worth of labor hours. Adam H On Thu, 19 Aug 2004 14:50:47 -0400, Mary Jo Sminkey [EMAIL PROTECTED] wrote: That being said I have never worked with cfwebstore so I can only speak from my personal experience with Able Commerce. Well, obviously I'm a bit biased. ;-) But you'll find the coding in CFWebstore much much easier to extend than AbleCommerce. It was written in Fusebox for that very reason, to make it relatively easy to customize. There are already a bunch of 3rd party add-ons available as well that you can basically just drop into it. That doesn't necessarily mean it's the right choice for everyone, there certainly are still cases where the needs of a specific site might work best with a custom solution. But so far the response I've got from users has been very positive, particularly those that have had to work with other products in the past. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: A bit confused with links between tables
Try something like this: CFQUERY name=get_tasks datasource=taskomatic SELECTt .taskID, t .taskname, t .status, t .project, p .projectsID, p .projectname, p .client , c.clientName FROM taskst JOINprojectsp ONt.project = p.projectsID JOIN clients c ON p.client= c.clientID /CFQUERY CFOUTPUT query=get_tasks #taskname##status##projectname# #clien Name t# /CFOUTPUT Note a couple of things - using a 1 letter alias makes your column names stand out a bit better.The join syntax is clearer for my money because it describes the actual task at hand - and you can control the type of join with join keywords without additional where clauses. -Mk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: My First Shopping Cart
Yes - nice package.It lacks several of the tools from CF webstore, but there are some things I really like about it. -Mark -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 3:06 PM To: CF-Talk Subject: RE: My First Shopping Cart For high traffic and easily modifiable code, nothing compares to Netready. Check it out: http://www.cfnetready.com http://www.cfnetready.com +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 8:46 AM To: CF-Talk Subject: My First Shopping Cart Okay guys/gals, I am going to start doing the planning for my first custom shopping cart and would like any pointers you all can give me? The best I can tell so far, my best bet is to use session variables because it is a high traffic site - please correct me if I'm wrong. And I plan to have things like a wish list, view past orders, multiple shipping addresses for return customers - just to name a few. At any rate, ANY advice that you can give would be greatly appreciated. Thank you, Donna French _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: My First Shopping Cart
Adam, Sorry - no way I agree with that.I'd say about 2 to 4 % of users ever look at the URL at all - let alone grasp the difference between a document and a string of variables. I would say that the difference is not only superflous but a red herring only noticed by developers. -mk -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 3:50 PM To: CF-Talk Subject: Re: My First Shopping Cart Thats definitely part of it. Its also the fact that it is using the same template to do everything (at least to the user thats what it looks like). Any good professionally made website uses a whole bunch of pages. It is really superficial, I know that and I am ok with it because thats how nontechnical people think, like bosses and end users. I know that fusebox applications can be just as good as others, even better, but it still looks unprofessional to the everyday, uninformed user. Superficial stuff like this can be found everywhere. Power basic makes a function called bloat, it simply makes your exe large. They made this b/c their compiled applications were generally much smaller than similar application built with Visual Basic and many of these (great) applications were being ignored/thrown out by higher ups base on the file size and the managers' common misconceptions how to judge an application. On Thu, 19 Aug 2004 16:19:15 -0400, Damien McKenna [EMAIL PROTECTED] wrote: On Aug 19, 2004, at 3:40 PM, Adam Haskell wrote: At that point and I for one would refuse to purchase it simply based on the fact it uses fusebox. *Puts on flame retardant suite*I also think it looks unprofessional, but hey thats just me :) Is that because of the fuseaction=blah.blah part of the URL?That can be changed to something more reasonable, per a suggestion or three a few weeks ago. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: S/MIME
Has anyone here every implemented S/MIME for server side email?I have a customer who considers it important. -mk Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
S/MIME email question
Folks, What's the best way to go about supporting S/MIME email from a CF server.I can't seem to find any tags that specifically support S/MIME. Anyone? -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: The search is killing the server. Please help!
This works pretty well - but on some RDBMS's you can get a buffer overrun on your IN () list if it grows very large. I've had that happen at 10,000 or so. Actually, it is more likely when using Cfqueryparam because the array allocated for the bind may have a maximum value. If you pass in an actual string, then you are leaving it up to the database server and will likely have better results (in this one case only I might add). -Mark -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 3:47 PM To: CF-Talk Subject: RE: The search is killing the server. Please help! I worked for a DOD lab for years and I disagree. It's not LIKELY, it's a CERTAINTY. Some FOIA sites have to do this sort of thing regardless of whether or not anyone will ever use it. I had to write a report for a clean-up project that often returned several thousand rows of complex chemical data knowing for a fact that nobody would ever look at about 98% of it, but it HAD TO BE THERE. So what I did was this. I ran my query using top and then I wrote the list of ID's into a session var so that the next time they ran the query it would use top to limit the query and use the list of IDs for a id not in(list) type of statement. So, to illustrate: Param idlist defalut = Select top(100) from table where id not in session.idlist... (or you don't even have to put this in the session scope if you don't like, but I was allowing people to leave the search and come back to it...) Set idlist = listofidsfromquery This way your always getting your next chunk of records without what you've already seen. Also, you could even simplify this if the IDs are in numerical order, you'd just have to get the top x number of rows where ID the last one you saw... Let me know if I can clarify any of that. It seems to make sense, but we just had a baby the other day so I'm running on just about ZERO sleep for the last 48 hours or so and still having to work! _ From: G [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 11:34 AM To: CF-Talk Subject: Re: The search is killing the server. Please help! To that end, when you work for the Government as I do, the ridiculous quickly becomes the ordinary.A query returning 5000 records, and a report to display all those records, is not only a possibility, its LIKELY. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Strange server issue
Matt, I'd say your guess that your install has something to do with it is a red herring.Something has changed the way it handles idle time suspension or power or somehting.Also, when you say cannot access the network from the server - what do you mean? Do you mean you can't ping an IP address... can't ping a FQDN or that you simply can't see web content in a browser? -Mark -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 7:55 AM To: CF-Talk Subject: Strange server issue Last weekend, we installed CFMX 6.1 on a server running CF5 on Windows 2000. We are running MX on its standalone web server as well as 1 IIS server, while the remaining IIS servers are running CF5. Since that time, every evening the server loses network connectivity and requires a reboot to get it back. Link lights are on the server and the switch, but we cannot access the network from the server, and the rest of the network cannot see the server. As soon as we reboot the box, everything goes back to normal. I've checked the Windows event logs as well as both CF logs and haven't found anything that would cause this to happen. Has anyone else seen this behavior when running the two side by side? Thanks, Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
possible bug - studio rds
Hey - try this. create a folder on a remote RDS server called help that is inside your web root.Then, using cf studio or homesite, right-click on a file with a long name (longer than 9 characters) and choose copy to - then try to copy that file to the help folder on the remote machine. Does anyone else get an error for long file names not supported? (using CFMX). The save as function doesn't work either - but it doesn not generate the error. It appears to copy but does not succeed.If I change the folder name to something else it works fine. Hmm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: merge data from two queries
did someone say golf??? perk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 10:18 AM To: CF-Talk Subject: Re: merge data from two queries NEVERMIND, im an idiot. queryname.columnName[1] DU!!! must be all that freakin' golf over the past 10 days... :) me snip -- tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: merge data from two queries
Tony, this is a join - not a union. A union query matches 2 different tables or recordsets with the same type in each matching column. select col1, col2, col3 from table1 union select a1, a2, a3 from table2 -- If col1 is an int and a1 is a char, this will fail.They can be named differently but they must have the same type. This is useful sometimes from the same table when you don't have a 'group to work with - like grouping by a date range: -- 30 days ago to present SELECTdateEntered, title, '30 days' as sortOption FROMBooks WHERE dateEntered dateadd(day,-30,getdate()) UNION SELECTdateEntered, title, '60 days' as sortOption FROMBooks WHERE dateEntered BETWEEN dateadd(day,-60,getdate()) ANDdateadd(day,-30,getdate()) UNION SELECTdateEntered, title, '60 days' as sortOption FROMBooks WHERE dateEntered BETWEEN dateadd(day,-90,getdate()) ANDdateadd(day,-60,getdate()) ORDER BY sortOption This would give an ordered result set with groups of books. Of couse, you could overlap or whatever. It's a simple example - but to do the same thing with group by you would need to extract the month, day and year because the dateentered will very likely be unique for each record. making a date group option difficult to impliment. -Mark -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 9:15 AM To: CF-Talk Subject: Re: merge data from two queries can i do a union query with a query like this? select count(r.reportId) as reportCount, v.vehicleName, c.companyName from reports r left outer join vehicleTable v on v.ipAddressNumber = r.ipAddressNumber inner join companyTable c on c.companyIdnumber = r.companyId where r.companyId = 1 and r.date between '07/11/2004 00:00:00.000' and '07/13/2004 23:59:59.999' group by vehicleName, companyName order by reportCount desc snip [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: RAD (was RE: Best choice for ColdFusion Studio IDE...)
Ken, that's not Hal Helms is it? -mk -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 1:45 PM To: CF-Talk Subject: RE: RAD (was RE: Best choice for ColdFusion Studio IDE...) I know you're half-kidding here, but you're not too far off of what people who make these things would just LOVE to do. If you find an editor like this, please let me know so that I can AVOID IT LIKE THE PLAGUE! The worst thing about all these WYSIWYG's and new IDEs is that they won't just get out of the way. I always think that if I type something - that's what I wanted to type. The reason I like CF Studio and Homesite is that they have the handy little code completion things that drop down and you can hit enter or keep typing without them slowing you down or changing stuff without you. But I get so sick of all of this over-automation. I think I might sound like an old man here, but I can easily picture this product coming out, installing it and then screaming at the top of my lungs because it won't leave me alone. ME: Don't change that code please. HAL: I'm going to change it Ken. ME: Please Hal, I want it that way. HAL: I'm going to change it Ken. ME: Hal, I want it written that way! HAL: I was developed to be your superior. I'll make the decisions on what code gets written and where. ME: If you touch that F*%KING code Hal, I'm going to rip out your power cord. HAL: If you touch my power cord, I'll format the hard-drive, Ken. ME... HAL... ME... You see what I mean? We'd all end up smashing our computers with large sledgehammers and moving to Idaho to live in the woods. Who was it that suggested a felt-tip pen...? I think that was the best idea so far. Ferg _ From: Robert Munn [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 11:47 AM To: CF-Talk Subject: Re: RAD (was RE: Best choice for ColdFusion Studio IDE...) So the question isn't whether or not to have tools, but what sort of tools will they be? Personally I'd like a tool that can fill in the blanks on simple coding tasks. Templates and wizards help to some extent, but I'd like something smart enough to go back and fix my mistakes, add missing parameters, that sort of thing. For instance, I wrote a little function on the list not to long ago, and I used _javascript_ notation for a loop in cfscript. I want an editor that is smart enough to not only tell me that's wrong but to suggest changes or even fix code automatically and highlight the changes. This is functionally no different than a spelling and grammar checker in a word processor. Of course, what I'd really like is an editor that wrote code for me so I could tell it what I want and have it produce all the code. It should understand my voice over the cellphone- that way I can spend more time at the beach. ;-) OK, maybe that's a little tongue in cheek but ultimately I don't see why not. In fact, once a system becomes that sophisticated you can just cut out the editor completely and talk directly to the application server. You can call your CF application server using VoIP and just tell it what you want it to build. Voice could be augmented by other forms of input- text, binary file input. CF Server Enterprise, Voice-Enabled Edition. Now that's RAD. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS considers blah.com directories to be executable?
Um I name my directories blah.com all the time without issue.Can you give an example?How is it that you think this? -Mark -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, July 09, 2004 4:05 PM To: CF-Talk Subject: OT: IIS considers blah.com directories to be executable? I just noticed that IIS5 considers directories that end in an extension which is also used for commands (.com or .exe) to be executables and not directories.This means you can't name a directory 123.com, which kinda sucks as I like naming my directories after the domain name.Does MS have a reason for this or is it just another case of them writing bad software? -- Damien McKenna (wishes he could use Apache) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Server Errors - CPU spike swsoc.exe
A couple of things come to mind. First, if you are using Access and under a heavy load you need to move to a different db. Sorry - but there's just not a lot you can do about it. The sequence driver just hangs under a heavy load.Second, if you are using JDBC drivers (for MS SQL for example), make sure an enter a fully qualified domain name in the server spot.Don't use an IP address. If you don't know it or don't have one for the db server add an entry to the host file (sql.mydomain.com) and use that. The JDBC service will waist time with reverse lookups otherwise. Make sure and use the JDBC Drivers by the way - an odbc socket connection is not going to benefit you much in the long run. Third, watch out for that timeout issue that relates to long running queries. These can cause DB requests to build on themselves exponentially. This issue is detailed in a technote - but basically, if your query exceeds the timeout for db connections and is still running it is not released.The workaround is to instantiate 2 datasources - one with maintained connections set true and one with maintain connnections set false - then use the second DSN for long running queries - keeping your pool more tightly managed.This error might be fixed in 6.1 (don't recall). Finally there are several issues list related to dbs at macromedia support - some with hotfixes.If you aren't using the DD 3.3 drivers I'd move to them unless you have a reason not to. -Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 7:45 AM To: CF-Talk Subject: Server Errors - CPU spike swsoc.exe I normally wouldn't post this, but I'm having some crashing server issues. I've optimized the CF settings, but it seems that the ColdFusion MX ODBC Server is eating up resources on our server until it crashes. (Windows Task Manager - Processes)Here's an error I got in the event viewer. I've also done a stack trace dump when starting the server and got the attached results. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. Thank you. DStarting Macromedia JRun 4 (Build 63824), default server 07/06 17:29:15 warning Unable to open D:\CFusionMX\runtime/lib/license.properties 07/06 17:29:18 info JRun Naming Service listening on *:2901 Running on JRun4... Starting ColdFusion services... 07/06 17:29:19 info No JDBC data sources have been configured for this server (see jrun-resources.xml) - Starting logging... 0 [main] INFO coldfusion.server- Starting logging... 07/06 17:29:23 info JRun Proxy Server listening on *:51010 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Query multiple databases
Phil, Try db.username.tablename.If the user is an aliased dbo (ms sql) use db.dbo.tablename. -Mark -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 10:54 AM To: CF-Talk Subject: Query multiple databases I need to write a join that calls to tables in different databases. I created a user that can access both databases. I then created the datasource in CF and it points to the DB that will be hit the most. I then wrote the query select a.*, b.* from db.tablea a inner join db.tableb b Beside the fact that the join is not valid, I get an error Invalid object name. Any suggestions? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Greg, I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them unnecessary by specifying the data type in advance.In this case using a datatype binding (cfqueryparam) means the single quotes would be superflous.the driver creates a query with a placeholder that says character data here - then whatever you pass in as the variable is bound to that type.Adding single quotes would only result having them suddenly appear in the database as a part of the string. There is a bug with a hot fix (fixed permanently in cfmx 6.1 I believe) that causes single quotes that included as a part of the param to be doubled up - but that's not the issue here either. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Dan, I would check the following. Is it an exact type match? For example, is the field a text field and you are using varchar?I would check to make sure that the field is nullable - since you are using the null attribute.And I would try other types if you can. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...(Resolved)
hehe... happens to me all the time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:06 AM To: CF-Talk Subject: RE: Havent seen this error before...(Resolved) Too early the morning after with not enough coffee:) Turns out that I was not using cf_sql_bit (which would have been the next line of the query) in my db, but instead the cf_sql_tinyint type (one area of MySQL I wish they would get with everybody else...) It's always the little things. Thanks for everyone's input. Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Yep - right on! -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:25 AM To: CF-Talk Subject: RE: Havent seen this error before... Wow, I didn't understand what you just said Mark. But my understanding is that you don't need single quotes inside the cfqueryparam. Specifying the cfsqltype should take care of that for you right? Greg -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:44 AM To: CF-Talk Subject: RE: Havent seen this error before... Greg, I don't believe that is correct. The purpose of the single quotes is to identify character data. cfqueryparam makes them unnecessary by specifying the data type in advance.In this case using a datatype binding (cfqueryparam) means the single quotes would be superflous.the driver creates a query with a placeholder that says character data here - then whatever you pass in as the variable is bound to that type.Adding single quotes would only result having them suddenly appear in the database as a part of the string. There is a bug with a hot fix (fixed permanently in cfmx 6.1 I believe) that causes single quotes that included as a part of the param to be doubled up - but that's not the issue here either. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 9:28 AM To: CF-Talk Subject: RE: Havent seen this error before... I don't believe you need those single-quotes inside cfqueryparam. But show more code and I'm sure we'll be able to tell you what's wrong. Show us the whole query at least. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 10:09 AM To: CF-Talk Subject: Re: Havent seen this error before... Looks like you are missing a set of single quotes in your value attribute. Instead of this, 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, try this: 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value='#instance.category#' null=#yesnoformat(not len(trim (instance.category)))#, [EMAIL PROTECTED] ets.com To 2004-07-05 09:50 CF-Talk [EMAIL PROTECTED] cc Please respond to Subject [EMAIL PROTECTED]Re: Havent seen this error sion.combefore... Sorry, HOF cut off some of the message (formatting from CFs error stuff) I am now getting an odd error: Error Executing Database Query. Unknown Types value The error occurred in /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 Called from /home/httpd/[omitted]/system/cfcomponents/com/ [omitted]/boutique/category.cfc: line 43 Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205 Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114 41 : 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype=cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, -- SQL update tblboutcat2 set txtBoutCat = (param 1) , blActive = (param 2) where intBoutCatID = (param 3) DATASOURCE[omitted] SQLSTATES1000 Anybody ever seen this one before? This function is nearly identical to one in another CFC that I currently have running which works perfectly (different table and fields). I've double checked that there are values to my 'instance' vars, that I have the sqltypes set correctly, etc. And I still can't figure it out. Help Cutter Quoting JediHomer [EMAIL PROTECTED]: Whats the other code around that, as I notice you end with a comma but no more code is shown. Might help to scope your vars, so add something like CFSET VAR Cat = after the CFFUNCTION or ommit the name of the CFQUERY if its not going to return anything. Potentially pass the datasource in as an argument rather than trying to access the Application scope HTH Mike - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Mon,5 Jul 2004 08:55:50 -0400 Subject: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] I am now getting an odd error: Error Executing Database Query. Unknown Types value 42 :cffunction name=update access=public output=false returntype=boolean 43 :cfquery name=cat datasource=#application.config.DSN# 44 : update tblboutcat2 45 : settxtBoutCat = cfqueryparam cfsqltype =cf_sql_varchar value=#instance.category# null=#yesnoformat(not len(trim (instance.category)))#, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations
RE: Havent seen this error before...
Greg, no - it would not.What he's (probably) doing is staying away from a data truncation error - where the database chockes on a string that is too long for the field size definition.In this case perhaps his field definition has a size of 100 - doing a left(string,100) makes sure that the string is never too long. -Mark -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:03 AM To: CF-Talk Subject: RE: Havent seen this error before... Your second example is just trimming the left 100 chars, that won't affect the single-quotes will it? -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:57 AM To: CF-Talk Subject: Re: Havent seen this error before... You dont need it to specify that its a string i.e. set sfoo = 'im a sring' It should also escape single quotes embeded into the string, but there is a bug with a hotfix (which is what Mark was refering to I beleive) where if you use a string function within the CFQueryParam which contained a Single quote then it would be doubled up. I.e. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Havent seen this error before...
Mike, Hey ... if your right that has to be a bug right? It must be because of the nested function.I use trim( ) all the time without issues.Your saying that trim( ) combined with Len( ) causes the inner function ref to be passed instead of the return value from both calls? -Mark -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Monday, July 05, 2004 11:27 AM To: CF-Talk Subject: Re: Havent seen this error before... It shouldnt but thats the bug, as its not just a variable but a string function being passed into the tag the single quote doesnt go into the database as a single quote but as 2 single quotes. So basically if you wanted to trim and make sure whats going into the DB is less than 100 chars you have to do this outside of the tag for it to behave as expected. HTH Mike - Original Message - From: Greg Luce [EMAIL PROTECTED] Date: Mon, 5 Jul 2004 12:03:27 -0400 Subject: RE: Havent seen this error before... To: CF-Talk [EMAIL PROTECTED] Your second example is just trimming the left 100 chars, that won't affect the single-quotes will it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX java.lang.OutOfMemoryError
Indeed, we adjust that value automatically when setting up a new installation. The default value (64mg I believe) is simply too low to support a busy application or multiple sites. -Mark -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 3:56 PM To: CF-Talk Subject: RE: CFMX java.lang.OutOfMemoryError Brook, This Technote describes the problem and offers a solution: http://www.macromedia.com/support/coldfusion/ts/documents/java_lang_outofme mory.htm http://www.macromedia.com/support/coldfusion/ts/documents/java_lang_outofmem ory.htm The key characteristic of the error is that it is followed by the no stack trace available line.When the error occurs in this context, the typical solution is to adjust the size of the Permanent Generation in the JVM. See also Pete Freitag's blog: http://www.petefreitag.com/item/139.cfm http://www.petefreitag.com/item/139.cfm http://www.petefreitag.com/articles/gctuning/ http://www.petefreitag.com/articles/gctuning/ -Steven Erat _ From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 4:16 PM To: CF-Talk Subject: CFMX java.lang.OutOfMemoryError I have posted my log file (just todays pertinent bit) to http://www.logiforms.com/default-event.txt. Can anyone look at it and see what the $%^ is going on? Its filled with these entries: [0]java.lang.OutOfMemoryError no stack trace available My Server has 3 gigs of Ram, I don't know whats going on, so many things related to CFMX are acting strange right now... Brook _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Time Tracking
Ian, I would add that the current anti-popup climate has brought on a host of new pop-up blocking tools. If in your onUnload function you are calling another page, I suspect a popup blocker would take issue with that - no? -Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 9:48 AM To: CF-Talk Subject: RE: Time Tracking As was mentioned in another post you can do something with a _javascript_ body function.This is not a perfect solution because you are running against the Stateless nature of the web.Your doSomething can call some kind of page and/or service that would log the user.But this may not work 100% of the time in the Wide World because there is no way to guarantee a user is supporting _javascript_. Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Macromedia Style nav bar
Asim, I've been using ghostwire and I like it - easy to builddynamic menus. http://www.ghostwire.com/ -Mark -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 10:14 AM To: CF-Talk Subject: Macromedia Style nav bar Hi, I am looking for some kind of TOP Horizental mouseover menu. I need something like the macomedia have, when you mouseover the products all products showedup to the next line, and then you select, I need something like same but in 3 states (i.e. three line menu. Did anyone see some _javascript_ / js menu or flash menu which is easily modified like this somewhere? thanks in advance. Regards, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Understanding/Defending Coldfusion connections
A lot depends on what datasources you are talking about - but any resource on JDBC and connection pooling will give you good information. The underlying service is not CF specific. The current version of CF uses drivers from datadirect. Just about everything about the connection is configurable through the cf admin - including the NUMBER of connections that CF is allowed to use, whether or not they are maintained (kept open) and when they time out. That's how you know your friend is blowing smoke g. In addition, you can work with the underlying JDBC service and drivers to configure many other options for connectivity. Having said that maintaining connections is not designed to slow down an ap - but to speed it up.Havingto reinstantiate a connection with every db request is unecessary overhead in many (perhaps most) cases - unless you are using (hold your nose) access dbs - in which case no amount of fine tuning is going to make you scalable on either platform. Here's a url with lots of links - sorry I did not take the time to review them... but a quick google search on jdbc connection pooling will give you as much ammo as you want. http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml -Mark -Original Message- From: Joshua OConnor-Rose [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 10:50 AM To: CF-Talk Subject: Understanding/Defending Coldfusion connections OK so a friend of mine at an office I used to work at is having trouble defending coldfusion over dot net he tells me that this voice of 'authority' (its strange that a man that speaks with confidence is never questioned) said cold fusion [is no good] because it keeps a database connection open all the time and that slows down the program/app and server This particular web professional is converting all his CF to dot net, because of this defense. I've been briefly looking around so that I can understand database connections better and respond to him with the voice of reason (also to possibly optimise the performance of the access back end I have been stuck with on my current contract). But I keep coming up with help files on configuring datasources instead of information on how cf connects to datasources. Anybody have a good reference I can point to. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ODBC Service Hangs on Query
First, make sure the query gives you what you want. Because you have no parenthasise this query is going to give you ALL records from the tables: tblbillingaddr, tblterm That's because the WHERE clause reads Give me everything WHERE where tblmasterclients.clientname = tblbillingaddr.Client Name and tblmasterclients.clientname = tblterm.clientname and tblterm.leaseid = tblbilling.leaseid and tblmasterclients.acctstatus = 'A' OR give me everything WHERE tblmasterclients.acctstatus = 'ACT' Because the second part of the where has no joins - you get it all baby! I suspect you wanted it to look more like this: where tblmasterclients.clientname = tblbillingaddr.Client Name and tblmasterclients.clientname = tblterm.clientname and tblterm.leaseid = tblbilling.leaseid and (tblmasterclients.acctstatus = 'A' OR tblmasterclients.acctstatus = 'ACT') -Mark -Original Message- From: hammerin hankster [mailto:[EMAIL PROTECTED] Sent: Monday, June 21, 2004 11:42 AM To: CF-Talk Subject: ODBC Service Hangs on Query I've got two problems. One is that I'm running a (bad) query that causes the ODBC service to hang during the query attempt. I have to repeatedly try to stop the service and once it finally times out, I can restart it. In a nutshell, I have inherited a database full of relationships (which is good), but poorly designed. All I've done is add a new table to the query and a new field to search on. Here's the query: CFQUERY NAME=readesi DATASOURCE=esidb1 SELECT DISTINCT tblmasterclients.ClientName, AliasName, AlphaPrefix, SiteID, Infinity, AuthCode, POBox, POBoxCombo, tblmasterclients.Comments, DID, SVCType, tblmasterclients.AcctStatus, PreparedDate, URL, TerminationReason, TerminationDesc, billingaddr, billingaddr2, billingstate, billingcity, billingzip, billingcontact, billingemail, billingphone, billingext, billingfaxnumber, billingcellnumber, leaseid FROM tblMasterClients, tblbillingaddr, tblterm where tblmasterclients.clientname = tblbillingaddr.Client Name and tblmasterclients.clientname = tblterm.clientname and tblterm.leaseid = tblbilling.leaseid and tblmasterclients.acctstatus = 'A' OR tblmasterclients.acctstatus = 'ACT' ORDER BY tblmasterclients.clientname /CFQUERY Note: leaseid field and anything related to tblterm is new part I'm adding. Thanks for any help! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Help with CF5 Queued Requests
Frank, You should be looking for code that waits for a response from a third party process. Culprits are (typically) db access, ftp, ldap, pop, file access (cffile), cfhttp etc.All of these services must connect to a service or process outside the CF engine - cf awaits their response... sometimes indefinitely if its set up that way. That's why such tags often include a timeout value.Slow pages is a good place to start. Also look at the scheduled task folder and find out if there's a regular data import or web scraping application or some other ap put there for utility reasons. Sometimes these tasks run for years with no one noticing them and then suddenly start hanging. -Mark -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 12:06 PM To: CF-Talk Subject: Help with CF5 Queued Requests I have been tasked with stabilizing a legacy CF 5 application which had several problems including CF restarts and loss of client variables etc. I managed to solve most of the issues -- many caused by application variables not being locked. There is one issue which I need help with. Using Perfmon, I notice that, at times, ColdFusion requests stay queued and are not processed. They just stay there - forcing me to restart CF. I am tryng to track down what in the code could be causing this by looking at the log entries showing slow page warnings. Is there any known causes for this symptom? What else should I be looking for? Thanks for your help. Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
question about server variable
What does the variable server.Coldfusion.expiration mean? I'm examining a users current host. -mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Argh! Ram upgrade killed CF!
I'd say bad or mismatched memory is at fault. -mk -Original Message- From: Jack Dalaa [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 4:50 PM To: CF-Talk Subject: Re: Argh! Ram upgrade killed CF! jvm.config is just default stuff: # Arguments to VM java.args=-server -Xmx1024m -Dsun.io.useCanonCaches=false -Xbootclasspath/a:{application.home}/../lib/webchartsJava2D.j ar -XX:MaxPermSize=128m -XX:+UseParallelGC -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Character encoding - CFMX and SQL
Folks, I have an international customer who was running on Access and we moved from cfmx 6.0 to cfmx 6.1 and from access to MsSQL 2000. Prior to the move when he updated a table on access it worked fine. After the move when he updates and uses language specific characters (Italian) it changes the characters to a question mark in the DB.Note, the old data in the db is stored and displayed correctly (wiht the right characters) For example: Nel cominciare l'analisi In the old data this phrase is stored correctly, but when it is inserted (using a form and CF template) now it ends up in the database like this: Nel cominciare l?analisi In the application.cfm page we have the following directive: cfprocessingDirective pageencoding=ISO-8859-1 cfset setEncoding(form,ISO-8859-1) cfset setEncoding(url,ISO-8859-1) cfcontent type=text/html; charset=ISO-8859-1 Any one have any helpful hints? -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Character encoding - CFMX and SQL
Yes - I know that one. In fact, the old data is stored, retrieved anddisplayed correctly.All the character columns are unicode columns (nvarchar - ntext). -mark -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 8:28 AM To: CF-Talk Subject: Re: Character encoding - CFMX and SQL you have to create the columns in MS SQL as nVarchar so that they can cope with international chraracters... Regards On Fri, 11 Jun 2004 08:22:31 -0500, Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: Folks, I have an international customer who was running on Access and we moved from cfmx 6.0 to cfmx 6.1 and from access to MsSQL 2000. Prior to the move when he updated a table on access it worked fine. After the move when he updates and uses language specific characters (Italian) it changes the characters to a question mark in the DB.Note, the old data in the db is stored and displayed correctly (wiht the right characters) For example: Nel cominciare l'analisi In the old data this phrase is stored correctly, but when it is inserted (using a form and CF template) now it ends up in the database like this: Nel cominciare l?analisi In the application.cfm page we have the following directive: cfprocessingDirective pageencoding=ISO-8859-1 cfset setEncoding(form,ISO-8859-1) cfset setEncoding(url,ISO-8859-1) cfcontent type=text/html; charset=ISO-8859-1 Any one have any helpful hints? -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Character encoding - CFMX and SQL
Paul, THAT is the answer I'm looking for -thanks! -Mark -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 9:28 AM To: CF-Talk Subject: Re: Character encoding - CFMX and SQL language specific characters (Italian) it changes the characters to a question mark in the DB.Note, the old data in the db is stored and displayed correctly (wiht the right characters) since you're using N datatypes, are you using unicode hinting (for instance VALUES (N'Nel cominciare l'analisi')) for updates inserts or have you turned on the unicode enabled option for that dsn if you're using cfqueryparam? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: someone has to know this... MACROMEDIANS, anyone...cfdump 3rd post
Is there anything IN your servers/lib directory - and how did you figure out that this was the problem?? -Mark -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 11:18 AM To: CF-Talk Subject: someone has to know this... MACROMEDIANS, anyone...cfdump 3rd post if I run this code, with a c:\cfusion\runtime\servers\lib path present on my server cftry cfquery name=tony datasource=#usersDSN# select * from companyTables /cfquery cfcatch type=any cfdump var=#cfcatch# /cfcatch /cftry I get this response... [unknown type] however, if I remove the c:\cfusion\runtime\servers\lib directory, I get the cfcatch struct, as expected.any ideas? thanks ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 visit www.antiwrap.com to send long url emails to your friends! -- dont mistake my perfection as arrogance anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Regular expressions in JS (or in general) for dates
Regex gurus, I have a string and I want to ensure that the date format is: xx/xx/ or x/x/ or x/x/xx (you get the idea) Does anyone have a stock regex for this?Am I going to need more than 1 or can I look at everything (length, format and range of numbers) in 1 regex? -mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regular expressions in JS (or in general) for dates
Thanks! also thanks to Ben. This is what I needed. -Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 12:38 PM To: CF-Talk Subject: RE: Regular expressions in JS (or in general) for dates function daysInMonth(y,m){ if (m == 4 || m == 6 || m == 9 || m == 11) return 30; else if (m == 2) { if (y % 4 0) return 28; else if (y % 100 == 0 y % 400 0) return 28; else return 29; } else return 31; } function isDate(date){ var date_pattern = /^(0?[1-9]|1[0-2])\/(0?[1-9]|[12]\d|3[01])\/(\d{2}){1,2}$/; if(!date_pattern.test(date)) return false; var aDate = date.split(/); if(aDate[2].length==2) aDate[2] = (eval(aDate[2])30)?19:20 + aDate[2]; alert(aDate[2]+-+aDate[0]+-+aDate[1]); if(eval(aDate[1])daysInMonth(eval(aDate[2]),eval(aDate[0]))) return false; return true; } -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 18:41 To: CF-Talk Subject: OT: Regular expressions in JS (or in general) for dates Regex gurus, I have a string and I want to ensure that the date format is: xx/xx/ or x/x/ or x/x/xx (you get the idea) Does anyone have a stock regex for this?Am I going to need more than 1 or can I look at everything (length, format and range of numbers) in 1 regex? -mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Function for days and years...
This function makes sure that the days match the correct number of days for that month... -Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 12:38 PM To: CF-Talk Subject: RE: Regular expressions in JS (or in general) for dates function daysInMonth(y,m){ if (m == 4 || m == 6 || m == 9 || m == 11) return 30; else if (m == 2) { if (y % 4 0) return 28; else if (y % 100 == 0 y % 400 0) return 28; else return 29; } else return 31; } function isDate(date){ var date_pattern = /^(0?[1-9]|1[0-2])\/(0?[1-9]|[12]\d|3[01])\/(\d{2}){1,2}$/; if(!date_pattern.test(date)) return false; var aDate = date.split(/); if(aDate[2].length==2) aDate[2] = (eval(aDate[2])30)?19:20 + aDate[2]; alert(aDate[2]+-+aDate[0]+-+aDate[1]); if(eval(aDate[1])daysInMonth(eval(aDate[2]),eval(aDate[0]))) return false; return true; } -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 18:41 To: CF-Talk Subject: OT: Regular expressions in JS (or in general) for dates Regex gurus, I have a string and I want to ensure that the date format is: xx/xx/ or x/x/ or x/x/xx (you get the idea) Does anyone have a stock regex for this?Am I going to need more than 1 or can I look at everything (length, format and range of numbers) in 1 regex? -mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Function for days and years...
Sorry, I was trying to send that to the guy who needed it. -Mark -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 1:13 PM To: CF-Talk Subject: Function for days and years... This function makes sure that the days match the correct number of days for that month... -Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 12:38 PM To: CF-Talk Subject: RE: Regular expressions in JS (or in general) for dates function daysInMonth(y,m){ if (m == 4 || m == 6 || m == 9 || m == 11) return 30; else if (m == 2) { if (y % 4 0) return 28; else if (y % 100 == 0 y % 400 0) return 28; else return 29; } else return 31; } function isDate(date){ var date_pattern = /^(0?[1-9]|1[0-2])\/(0?[1-9]|[12]\d|3[01])\/(\d{2}){1,2}$/; if(!date_pattern.test(date)) return false; var aDate = date.split(/); if(aDate[2].length==2) aDate[2] = (eval(aDate[2])30)?19:20 + aDate[2]; alert(aDate[2]+-+aDate[0]+-+aDate[1]); if(eval(aDate[1])daysInMonth(eval(aDate[2]),eval(aDate[0]))) return false; return true; } -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juni 2004 18:41 To: CF-Talk Subject: OT: Regular expressions in JS (or in general) for dates Regex gurus, I have a string and I want to ensure that the date format is: xx/xx/ or x/x/ or x/x/xx (you get the idea) Does anyone have a stock regex for this?Am I going to need more than 1 or can I look at everything (length, format and range of numbers) in 1 regex? -mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Message Board
uh what? -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 1:49 PM To: CF-Talk Subject: Re: Message Board Calvin Ward wrote: Idon't agree with the need for free anything, especially something someone crafted. That's an awfully irrational statement coming from a cold fusion developer, whose language depends heavily on FREE software. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Message Board
Rick, Ah. I see your point - although anyone who has done any business with Sun Micro might bridle at the thought that the main purpose of their free psuedo open-source java project is to benefit the world in general without a thought to profit. And let's not forget all those enterprise applications out there that run on Java for thousands of dollars per CPU a year - should they all be free because Java is free?Apache is another story.I personally don't think of software or technology with enough piety to separate it from my profit motive (ha). I'm quite happy to have folks build things and then charge for their use - after all, that's what I do for a living. I suspect that if CF were to become more free I would have to charge less and make less because it would be perceived differently. I'm not interested in giving the gift of CF to the world - there are probably other things more deserving my charity. I'm more interested early retirement (hehe). -Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 2:01 PM To: CF-Talk Subject: Re: Message Board Mark A. Kruger - CFG wrote: uh what? Is not the java programming language free?What about the XML and SOAP parsing stuff from the Apache project.I'm pretty sure that's all free too. - Rick -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 1:49 PM To: CF-Talk Subject: Re: Message Board Calvin Ward wrote: Idon't agree with the need for free anything, especially something someone crafted. That's an awfully irrational statement coming from a cold fusion developer, whose language depends heavily on FREE software. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Message Board
Rick, yeah - me neither (dropping it)... plus I get so dang pompous when I'm arguing - it's not a side of me I like g. -mk -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 2:41 PM To: CF-Talk Subject: Re: Message Board Mark A. Kruger - CFG wrote: Ah. I see your point - although anyone who has done any business with Sun Micro might bridle at the thought that the main purpose of their free psuedo open-source java project is to benefit the world in general without a thought to profit. And let's not forget all those enterprise applications out there that run on Java for thousands of dollars per CPU a year - should they all be free because Java is free?Apache is another story. snip Oh I'm in no way saying that everythin should be free.I'm just glad there is some good quality FREE stuff out there.Ther eare, of course, distandvantages.. I'm experiencing one of those disadvantages right now with JasperReports, in that there is no support, and the mailing list for it is completely inactive... no responses to my questions. I'll let this one drop for now since this whole discussion doesn't really belong here anyway, and I really don't feel like taking it up elsewhere :) - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFQUERY - MySQL Chicken and Egg
Ah... so the truth comes out - as the Gestapo said to the grandfather clock ... ve haf vays to make you tock... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 7:52 AM To: CF-Talk Subject: RE: CFQUERY - MySQL Chicken and Egg I'm a liar, I admit it. You can create new databases through CF DSNs with MySQL as well.You can issue a CREATE DATABASE name from any connection that was authenticated via an account with sufficient privileges.However, since it seemed unlikely Nick had already created a different database and set up a DNS to it, I didn't want to confuse the issue. Cheers, barneyb -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:43 AM To: CF-Talk Subject: RE: CFQUERY - MySQL Chicken and Egg Not exactly true that you have to use the native interface for all rdbms's.In MsSQL (and other rdbms's)if you have the proper permissions you can create multiple databases and use them from a single datasource. The reason it's not often done is that you must know something about the physical location of the .mdf and .ldf files because MSSQL requires a location to be specifified.You must also change around the typical syntax and include the db name in your queries (dbname.username.tablename instead of just tablename or username.tablename).And you have to futz with the permissions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFQUERY - MySQL Chicken and Egg
Not exactly true that you have to use the native interface for all rdbms's.In MsSQL (and other rdbms's)if you have the proper permissions you can create multiple databases and use them from a single datasource. The reason it's not often done is that you must know something about the physical location of the .mdf and .ldf files because MSSQL requires a location to be specifified.You must also change around the typical syntax and include the db name in your queries (dbname.username.tablename instead of just tablename or username.tablename).And you have to futz with the permissions. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 4:16 AM To: CF-Talk Subject: RE: CFQUERY - MySQL Chicken and Egg Just like with any other DBMS, you'll have to create a database through the database's native interface, not via CF.With MySQL, that's the `mysql` command line tool.Call it like this: Mysql -u username -p [ -h hostname ] The -p will make it prompt for your password, and the -h will allow you to connect to a remote host, if needed.The default host is localhost. I suppose you could probably connect from CF via a JDBC connect string, but I've never done that. Cheers, barneyb -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 2:02 AM To: CF-Talk Subject: CFQUERY - MySQL Chicken and Egg I am just now taking a stab at using MySQL, and hit a fundamental snag, i.e., creating the database. MySQL indicates the following statement will do the job cfquery name=CreateaDB CREATE DATABASE [IF NOT EXISTS] Test_DB /cfquery However, as best I can tell CFQUERY wants, among other things, a datasource and I can't create a datasource without a DB. Any help would be appreciated. Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS SQL Syntax/Keyword
John, Your syntax would output like this: where 15 IN (sharedGroupIds) If I'm reading your right this is backwards - it should be column INvalues or sharedGroupIds IN (15) Unfortunatley the IN clause is not going to work for you with a column of values because it uses equals against each value. Consider this scenario: Groupids contains 15,17,7,9 You have a single groupID of 17.You would think that groupids IN (17) would return true - nope..because 15,17,7,9 does NOT equal 17.SQL is not going to treat a single column with delimited lists in it as if it were a query or group of values. To SQL 15,17,7,9 is a single value - not 4 values. Now, you can use like to maybe futz with this so you could do where groupids LIKE ('%,17,%) OR groupids LIKE (17,%) or groupIds LIKE (%,17) But that is a poor excuse for a query (ha).You have to account for wether the 17 is in the middle, end or beginning...AND that is still not perfect. A better choice would probably be a second table of groupids mapping your permissionsthen your query becomes where groupid IN (select groupId from relatedGroups where groupid IN (17,2,0) ) Or you can join it as well... I hope this helps. -Mark -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:24 AM To: CF-Talk Subject: MS SQL Syntax/Keyword I have a table in MS SQL with a column that has a groupID value in it (int) and a column that is sharedGroupIDs (varchar).The groupID holds an int of the group that the record belongs to.The sharedGroupIDs holds a string of IDs that also can see the record.I'm trying to use the IN operator to find all rows where the current GroupID is either the groupID on a row or is IN the sharedGroupIDs column for that row. Here's 2 separate syntaxes I've used and the results I've gotten: select * from table where #groupID# = groupID or #groupID# IN (sharedGroupIDs) The above returns an error because SQL says it can't convert the SharedGroupIDs column to type of INT.When reading about the IN operator, it says that the datatypes you're comparing have to match, so I tried the following: select * from table where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) Notice the single quotes around #groupID# so that it should be seen as a string.This doesn't produce and error, but it does not return any records.A simple data test that I'm trying is #groupID# = 5 and in the SharedGroupIDs column I have this string: 15,7,5 Any ideas on why this isn't working?Any suggestions? Maybe another operator Also, just to stop unneeded responses, I can't use LIKE because if the value I'm searching for is 1 is and 15 is in the column, it will return true because there is a 1 and that's not what I'm looking for. Please help! :-) John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS SQL Syntax/Operator
PS the CAST convert functions won't help here. The problem is in trying to treat a list of values in a single character column as if they were separate entities. SQL doesn't do lists like that. -mark -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:23 AM To: CF-Talk Subject: MS SQL Syntax/Operator I have a table in MS SQL with a column that has a groupID value in it (int) and a column that is sharedGroupIDs (varchar).The groupID holds an int of the group that the record belongs to.The sharedGroupIDs holds a string of IDs that also can see the record.I'm trying to use the IN keyword to find all rows where the current GroupID is either the groupID on a row or is IN the sharedGroupIDs column for that row. Here's 2 separate syntaxes I've used and the results I've gotten: select * from table where #groupID# = groupID or #groupID# IN (sharedGroupIDs) The above returns an error because SQL says it can't convert the SharedGroupIDs column to type of INT.When reading about the IN keyword, it says that the datatypes you're comparing have to match, so I tried the following: select * from table where #groupID# = groupID or '#groupID#' IN (sharedGroupIDs) Notice the single quotes around #groupID# so that it should be seen as a string.This doesn't produce and error, but it does not return any records.A simple data test that I'm trying is #groupID# = 5 and in the SharedGroupIDs column I have this string: 15,7,5 Any ideas on why this isn't working?Any suggestions? Maybe another keyword or something I could use to produce these results? Also, just to stop unneeded responses, I can't use LIKE because if the value I'm searching for is 1 is and 15 is in the column, it will return true because there is a 1 and that's not what I'm looking for. Please help! :-) John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
Barney, I'd love that error handling code.I'll give you a plug on my blog. -mark -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:48 PM To: CF-Talk Subject: RE: Database error messages Whoops, no attachements on cf-talk.That must be cfczone that lets them through.I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Developer Edition
Yes - but all the developers must have a subscription - right? -mk -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:21 AM To: CF-Talk Subject: RE: ColdFusion Developer Edition Ok I know there is a ColdFusion Developer edition, but here is my question. From what I understand it's limited to one IP address. Does Macromedia sell a developer version like Microsoft does where you can use the software in a development version unrestricted without having to be limited? I'm making a development server and the big price item was SQL server, but I found that you can buy a development version of that for $49.95, so would like to find something like this for ColdFusion. You can get a DevNet subscription, which isn't free, but does provide multi-use servers for development. But, out of curiosity, what specifically do you want to do that the single-user version won't let you do? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SMTP
There is a post SP 4 bug that can cause IIS services to hang (including SMTP).I don't know if that's your issue but here is the KB: http://support.microsoft.com/default.aspx?scid=kb;en-us;819019 The patch is only available from MS tech support, but I found it online here. http://www.pubforum.net/postsp4.htm Be careful when you run it - there is probably a reason it's only available from tech support g. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:01 PM To: CF-Talk Subject: SMTP Ok I hae a bunch of mail sitting in my Spool folder. I have bounced IIS and the SMTP server several times. These emails were originally in my Undelivered folder cause SMTP was not started when these emails should have been ran. I just ran an email off the server to another email acount using a form on one of my sites and I received it successfully. I copied all the undelivered emails and paced them in the spool folder but they are not being sent. Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
determining the correct version of MDAC
Does anyone remember how to figure out what version of MDAC is installed on their server? Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: determining the correct version of MDAC
Dave, awesome - that's what I was looking for - thanks! -mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:29 PM To: CF-Talk Subject: RE: determining the correct version of MDAC Does anyone remember how to figure out what version of MDAC is installed on their server? You can use the MDAC Component Checker, available from the MS site: http://msdn.microsoft.com/data/mdac/default.aspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Latest Windows Updates
Bryan, Reboot and hit f8 - then choose last known good configuration from the screen - you may need to do this once or twice. -Mark -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 2:01 PM To: CF-Talk Subject: Re: Latest Windows Updates I don't know what I'm trying to do at this point.The system resources are all used up so I can't really do anything (hell the desktop icons and taskbars vanished). I'll keep trying to uninstall the updates. Of course we have backups of all our work...but there is a hell of a lot of configuring to do to get it back up and running if I format c:\Time to get Ghost ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Friday, April 16, 2004 11:52 AM Subject: RE: Latest Windows Updates So, you are trying to stop McAffee?I would think you could remove it from the registry(in the Run area) then reboot, right? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 2:44 PM To: CF-Talk Subject: Re: Latest Windows Updates Agh.I try and end processes running under the System username and all I get is access denied!!!I'm in as the Administrator!!! It's just getting worsenow CPU is done to 2-4% but anything I try and run says can't be done...not enough resources and RAM is in good shape!!! If I could just get Add/Remove Programs to run I could uninstal the updates from yesterday...but NOOOooOOoo Oh well.time to go find a nice quiet place to shoot myself ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Doug White To: CF-Talk Sent: Friday, April 16, 2004 11:27 AM Subject: Re: Latest Windows Updates Yes, As I understand, McAffee still uses a 16 bit scanning engine - and as a result really slows down some system.So much so, that it has caused many to abandon the product for a more efficient one. Don't hold me to this, as I abandoned McAffee back in the Win98SE days for that reason == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Friday, April 16, 2004 11:47 AM Subject: Re: Latest Windows Updates Oh ya Doug... Isn't F-PROT to do with virus scanning??I've seen an alert about McAfee mabye not having all of the right stuff installedguess that might be that bad guy?? Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Doug White To: CF-Talk Sent: Friday, April 16, 2004 9:32 AM Subject: Re: Latest Windows Updates A place to start: Start looking for 16 bit versions of applications that are running. Such as A/V scanners, software firewalls, etc. Most running processes are running under a system account, so it is time consuming to isolate the offending application. Next try disabling processes running under systemone at a time with the CPU monitor running and observe which one(s) make a big difference. Sometimes a re-install of that particular application will do the trick, but most will require upgrading to a 32 bit version of the process. In my case, I had to update the F-PROT scan engine to a 32 bit version and that solved the runaway issue. Good luck! == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Friday, April 16, 2004 10:35 AM Subject: SOT: Latest Windows Updates Hey All, We applied the latest round or about 5 security updates to our Win2K Advanced Server
RE: Importing Access to MSSQL
I use the DTS package designer wizard in SQL to create a DTS script for this.If you must drop the tables each night then the procedure is: drop tables create tables (no indexes or constraints) copy data in -AT this step can do many things including clean up the data, merge the data etc. Run your script to build indexes, keys, constraints and views etc. Run any clean up scripts you like. All of this - including your FTP task - can be automated using a DTS package. -Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 10:41 PM To: CF-Talk Subject: Re: Importing Access to MSSQL i use this, pretty slick, takes about 30 seconds http://www.data-conversions.net/access2mysqlpro.html Several ways to do this. Use the upsizing wizard -- but I'm told that there are problems using that approach for data -- okay to get the table structures in place I think. Alternatively, create the new tables manually in MSSQL. Once the tables are in place, use CF to query the Access Table and then use CF to Insert recrods into MSSQL table. Another way is to use a Windows app in client-server mode with ODBC drivers to do the Query and Post process -- I use Visual FoxPro and ODBC drivers for this purpose a lot irrespective of what the from and to databases are (Excel, Text, Access, MySQL, MSSQL, Oracle, etc). Both of these processes allow for a lot of data checking and cleanup to be done in the migration process because of FoxPro's extensive string and date manipulation functions.Processing Datetime fields can be a bugger to deal with especially going from other than Access to MSSQL. To give you some performance numbers, I deleted and then created a new MSSQL table located at a hosting service from a local 10,000 record FoxPro DBF file -- the process took about 20 minutes over a 56k modem. Just another two cents -- hope it helps... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: user agent checking and spidering...
Dave, That's not what I'm finding.If you have a robots.txt file that says: disallow /search.cfm It will not index the search.cfm file from the root of the server. But I cannot find anywhere where you can put in something like this: disallow http://www.someothersite.com You see what I mean? The robot.txt file allows you to exclude pages on THIS site that you don't want indexed. -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, April 04, 2004 5:23 PM To: CF-Talk Subject: RE: user agent checking and spidering... Sequelink (the access service for Jrun I think) locks up quickly trying to service hundreds of requests at once to the same access file. As a short-term fix, have you considered a more aggressive caching strategy? That might be pretty easy to implement. Each site has a pretty well thought out robots.txt file, but it doesn't help because the links in question are to external sites - not pages on THIS site (even though these external sites are virtuals on the same server). I don't think I understand this. It shouldn't matter whether the links are internal or external - before a well-written spider requests the link, it should check that server's robots.txt file first. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: user agent checking and spidering...
P.S. Actually he had NO caching and that is our first step - and it has been quite successful. -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, April 04, 2004 5:23 PM To: CF-Talk Subject: RE: user agent checking and spidering... Sequelink (the access service for Jrun I think) locks up quickly trying to service hundreds of requests at once to the same access file. As a short-term fix, have you considered a more aggressive caching strategy? That might be pretty easy to implement. Each site has a pretty well thought out robots.txt file, but it doesn't help because the links in question are to external sites - not pages on THIS site (even though these external sites are virtuals on the same server). I don't think I understand this. It shouldn't matter whether the links are internal or external - before a well-written spider requests the link, it should check that server's robots.txt file first. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: user agent checking and spidering...
STephen, Thanks for the URL.We do have a robots file in the root of each site.Perhaps the meta tags will help.I'll check it out. -Mark -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: Monday, April 05, 2004 8:32 AM To: CF-Talk Subject: Re: user agent checking and spidering... Mark A. Kruger - CFG wrote: Dave, That's not what I'm finding.If you have a robots.txt file that says: disallow /search.cfm It will not index the search.cfm file from the root of the server. But I cannot find anywhere where you can put in something like this: disallow http://www.someothersite.com You see what I mean? The robot.txt file allows you to exclude pages on THIS site that you don't want indexed. You'll need to do one robots.txt file in the root of each site you want to control robot access to. You cannot prevent a robot from spidering another site, but generally the robot will only be working on one URI at a time otherwise it would never complete a task. Check out http://www.robotstxt.org/wc/robots.html for details on the robots exclusion standard.There is also some stuff in there regarding meta tags for robot exclusion. Hope this helps Regards Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
user agent checking and spidering...
Cf talkers, I have a client with many many similar sites on a single server using CFMX.Each of the sites is part of a network of sites that all link together - about 150 to 200 sites in all.Each home page has links to other sites in the network. Periodically, it appears that google or a similar search enginehits a home page and spiders the links - which of course leads it to other sites on the server and other links. This generates (again - this is my hypothesus from examining the logs and behaviour) concurrent requests for similar pages that all hit the same news database (in access). Sequelink (the access service for Jrun I think) locks up quickly trying to service hundreds of requests at once to the same access file. This results in a climbing request queue that climbs into the thousands and requires a restart of the CFMX services. To fix this issue I am migrating the databases over to SQL server which will help greatly with stability, but this will take a little time and there is still the problem of trying to avoid letting a spider hit this single server with so many requests at once.Each site has a pretty well thought out robots.txt file, but it doesn't help because the links in question are to external sites - not pages on THIS site (even though these external sites are virtuals on the same server). I'm considering suggesting a mask be installed for spider agents that eliminates the absolute links and only exposes the internal links - which are controlled by the robots.txt.I'd like to know if: A) in anyone's experience my hypothesis may be correct and B) Is there anything I should watch out for in masking these links C) Does anyone know of a link that gives me the string values of the various user-agents I'm trying to look for. Any help will be appreciated - thanks! -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: user agent checking and spidering...
Jim, Thanks - that might be a good place to start. Can you send it to my email? thanks! -Mark -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, April 04, 2004 1:27 PM To: CF-Talk Subject: RE: user agent checking and spidering... I'm not sure if it's the best way to do things but I may be able to help with the user agents.Basically what I've done is capture all the user agents to hit my sites over the past few years.I go through periodically and (using a bit column in the table) mark whether the agents are bots or not. I'm not saying its 100% accurate (or complete) but whatever is?I can send you the data if you like (let me know how you'd like it).It's sizable. there are many thousands of rows. I use the table to determine which session on the application are generated by bots and a prevent those sessions from being stored in my metrics application (reduces clutter significantly). If you want more accuracy/completeness you may also consider checking out browserhawk (forgot the company name) - it's a user-agent parsing component that works from a regularly updated database of agent information.It'll give you much more than just isBot but will also cost you. Let me know if you want my database. Jim Davis _ From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Sunday, April 04, 2004 2:06 PM To: CF-Talk Subject: user agent checking and spidering... Cf talkers, I have a client with many many similar sites on a single server using CFMX. Each of the sites is part of a network of sites that all link together - about 150 to 200 sites in all.Each home page has links to other sites in the network. Periodically, it appears that google or a similar search enginehits a home page and spiders the links - which of course leads it to other sites on the server and other links. This generates (again - this is my hypothesus from examining the logs and behaviour) concurrent requests for similar pages that all hit the same news database (in access). Sequelink (the access service for Jrun I think) locks up quickly trying to service hundreds of requests at once to the same access file. This results in a climbing request queue that climbs into the thousands and requires a restart of the CFMX services. To fix this issue I am migrating the databases over to SQL server which will help greatly with stability, but this will take a little time and there is still the problem of trying to avoid letting a spider hit this single server with so many requests at once.Each site has a pretty well thought out robots.txt file, but it doesn't help because the links in question are to external sites - not pages on THIS site (even though these external sites are virtuals on the same server). I'm considering suggesting a mask be installed for spider agents that eliminates the absolute links and only exposes the internal links - which are controlled by the robots.txt.I'd like to know if: A) in anyone's experience my hypothesis may be correct and B) Is there anything I should watch out for in masking these links C) Does anyone know of a link that gives me the string values of the various user-agents I'm trying to look for. Any help will be appreciated - thanks! -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: creating 404 page for CFM and JSP files.
make sure and delete all the jsp files. What is probably happening is that CF (i.e. Jrun) is being tasked by IIS to serve the JSP pages, but you have the wrong version to do it (like CF professional).Also, go into the site properties and make sure that CF is NOT tasked with serving JSP pages (click on the configuration button on the web site tab). Make sure the site knows that JSP is persona non grata. -Mark -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:18 AM To: CF-Talk Subject: creating 404 page for CFM and JSP files. I think I'm having a brain fart today because I cannot get this to work. Here is what I'm trying to do. I have a Win2K3 server running CFMX. This site I'm working with used to use JSP pages. All the JSP pages have been rewritten to use CFM. Trouble is, some of the JSP pages are still cached in search engines and people still have them bookmarked. I've made a customer 404 page (in CF) to redirect a user to the main site. The trouble I'm running into is that I can't get the server to pull up my custom 404 when a JSP page is accessed. All I get is the generic error: A License Exception has been thrown Will this not work unless JSP is installed on the server? I'm currently have JSP mapped to be processed by the CFMX engine. TIA Dan Phillips CFXHosting.com 866.239.4678 x112 [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IIS Custom Error Pages in CF?
Yes you can. 1) Go into IIS properties for your site and choose the custom errors tab. 2) Select the 404 error and choose edit. 3) change the message type from file to URL 4) Enter a .cfm page with a path relative to THIS site.So, for example, if you put a missingFile.cfm handler in your root folder you would enter missingFile.cfm - or if it was in a folder called Bob it would be Bob/missingfile.cfm. This can be quite useful.I use this technique for some subscription sites that wish to create unique URL's for their client subscribers.After subscribing the user is instructed to use blah.com/name (i.e. blah.com/MarySmith).Of course the directory MarySmith doesn't exist so the request is forwarded to my .cfm file handler.The file handler parses out MarySmith and sends the user to a customized page for login or whatever. A similar trick uses a wildcard entry on a DNS server to allow a user to go to marySmith.blah.com - both tricks are great for sales CRM tools, real estate sites and the like - any place where you want a use to have a personal website but it actually connected to a larger group or site. -mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 9:03 PM To: CF-Talk Subject: OT: IIS Custom Error Pages in CF? I'm trying to figure out if I can use a .cfm page (or possibly an .asp page) for an IIS 5 custom 404 error page.I'm _not_ trying to configure CF's missing template handler as done through the CF Administrator.That works fine. It appears that if you designate a .cfm page for 404 errors (for example: http://mysite.com/notapage.htm) then the .cfm page doesn't get sent through the CF engine.Can this behaviour be changed?What about .asp pages - same problem?I haven't tried that route yet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cf puzzle
If you are using IIS check out a thread from earlier today http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=31591forumid=4 Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 9:13 AM To: CF-Talk Subject: Cf puzzle Ok folks! I have a directory... c:/cfusionmx/wwwroot/somedir/ That has Application.cfm and index.cfm files. Now... that being said.Lets assume that in order to hit the index.cfm I need to type in the browser http://www.gabrielrobichaud.com/ Now what I would like to do, is catch these types of hits http://www.gabrielrobichaud.com/xyz Xyz is not a directory, it never will be nor is it a file.I would like to catch that xyz, put it invariable and then do some funky treatment. BUT, what I am getting currently is: The page cannot be found error message. How can I get this xyz value and put it in a variable? Any leads would be really appreciated!!! Gabriel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cf puzzle
Gabriel, The web server already has to parse the header, determine if the file exists and point to the file (or 404 handler) - yes I would imagine that there is a bit more overhead than if the file/folder existed in the first place - but I have several sites doing this and similar things, some of them trafficked quite heavily, and I've never noticed an appreciable difference.Obviously a lot depends on the expected load.I would also say that a dedicated IP address (rather than a virtual host) would make a slight difference because the web server wouldn't have the additional task of finding the right site for that Host header before it even looks for a file. But again, I don't know that you would notice the difference except under a near capacity load. -Mark -Original Message- From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 8:37 AM To: CF-Talk Subject: Re: Cf puzzle The only thing is that this is not an error.And I want to make this part of the functionality of the site.So I am concerned that using the error page like this might put a strain on performance.Or am I worrying about nothing? Custom error page through your web server to point to a CFM that evaluates the URL string and strips out what you want into variables. #cgi# scope will help a lot. John Burns -Original Message- From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:13 AM To: CF-Talk Subject: Cf puzzle Ok folks! I have a directory... c:/cfusionmx/wwwroot/somedir/ That has Application.cfm and index.cfm files. Now... that being said.Lets assume that in order to hit the index.cfm I need to type in the browser http://www.gabrielrobichaud.com/ Now what I would like to do, is catch these types of hits http://www.gabrielrobichaud.com/xyz Xyz is not a directory, it never will be nor is it a file.I would like to catch that xyz, put it invariable and then do some funky treatment. BUT, what I am getting currently is: The page cannot be found error message. How can I get this xyz value and put it in a variable? Any leads would be really appreciated!!! Gabriel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Affiliate software
Deos anyone know of any software similar to: http://www.webscribble.com/products/webaffiliate/requirements.shtml That's runs on IIS and (possibly) CF? Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IIS Custom Error Pages in CF?
welcome! -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 1:16 PM To: CF-Talk Subject: Re: IIS Custom Error Pages in CF? Bert Mark: Thanks!I had been trying with the message type still set to 'file'. Jim - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 6:38 AM Subject: RE: IIS Custom Error Pages in CF? Yes you can. 1) Go into IIS properties for your site and choose the custom errors tab. 2) Select the 404 error and choose edit. 3) change the message type from file to URL 4) Enter a .cfm page with a path relative to THIS site.So, for example, if you put a missingFile.cfm handler in your root folder you would enter missingFile.cfm - or if it was in a folder called Bob it would be Bob/missingfile.cfm. This can be quite useful.I use this technique for some subscription sites that wish to create unique URL's for their client subscribers.After subscribing the user is instructed to use blah.com/name (i.e. blah.com/MarySmith).Of course the directory MarySmith doesn't exist so the request is forwarded to my .cfm file handler.The file handler parses out MarySmith and sends the user to a customized page for login or whatever. A similar trick uses a wildcard entry on a DNS server to allow a user to go to marySmith.blah.com - both tricks are great for sales CRM tools, real estate sites and the like - any place where you want a use to have a personal website but it actually connected to a larger group or site. -mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 9:03 PM To: CF-Talk Subject: OT: IIS Custom Error Pages in CF? I'm trying to figure out if I can use a .cfm page (or possibly an .asp page) for an IIS 5 custom 404 error page.I'm _not_ trying to configure CF's missing template handler as done through the CF Administrator. That works fine. It appears that if you designate a .cfm page for 404 errors (for example: http://mysite.com/notapage.htm) then the .cfm page doesn't get sent through the CF engine.Can this behaviour be changed?What about .asp pages - same problem?I haven't tried that route yet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL grouped query help
You know... I love this idea - very cool I had not thought of that. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 8:25 AM To: CF-Talk Subject: Re: SQL grouped query help Now, I want to select only the latest article from each issue in a single query. Any ideas how I would do this? Kind of sneaky, but something like this will do it (substitute the relevant type conversion string concatenation functions for your DBMS) SELECTarticleIssueId, articleTitle, articleDate FROMmyArticles WHERE convert(char(16), articleIssueID) + '_' + convert(char(16), articleID) IN (SELECT convert(char(16), articleIssueID)+ '_' + convert(char(16), MAX(articleid)) FROM myArticles GROUP BY articleIssueID) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sneaky Virus
That is sneaky... -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 12:11 PM To: CF-Talk Subject: OT: Sneaky Virus I just got this sneaky ass virus. The link in the email looked like a URL and it had my domain in it so I thought I would click on it just to see. We do not have webmail so I knew it was bull, but did not realize the apparent URL was actually a link to an attachment! This email did not have an attachment so maybe it was sent earlier!! Start Message: If the message will not displayed automatically, follow the link to read the delivered message. Received message is available at: file://F:\Program Files\Qualcomm\Eudora\Embedded\message3.zlqwww.maracasmedia.com/inbox/blists/read.php?sessionid-22898 -- Just thought I would pass this on, as I think it is rather sneaky. BTW, Zone Alarm Pro Mail Quarantine warned me before actually opening the file when I clicked the link. Brook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Upgrading Problem on CFMX
I believe this was a bug were the page length for compile can't be more than 64 k.If I remember correctly it was fixed in 6.1 when the compiler was moved to direct to bytecode instead of creating intermediate source files and then compiling it. I could be way off... but are you on 6.1? -Original Message- From: chad [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 12:24 PM To: CF-Talk Subject: Upgrading Problem on CFMX My company recently upgraded from CF5 to CFMX server on Windows2000. I have a site that used to work on CF5 and is now getting this error. Any ideas on how to fix it would be greatly appreciated. cfCalcEICTEIAmount2ecfm382194364 (Code of a method longer than 65535 bytes) where cfcalcEICTEIAmount.cfm is my page name. This page is being included on another page. Chad McCue Advanced Media Productions [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Okay, bear with me, I'm not even sure what I'm asking...
Jeff, cfinclude paths are not related to the paths of the web server.You can in fact create arbitrary aliases for paths (mappings) that out of your web root altogether.CF always uses a path that is relative to the current template path. So if your developer is 1 directory below the root he would use ../blah.cfm.Again, don't let him even bring up the image paths and virtual directorys et al.The web server doesnt' control this at all.If he wants a mapping to root he can create one in CF admin (using /) and this is actually done by default - and it's fine if you are not on a shared server or you have control over the environment. But if you are on a shared server be careful because everyone can include from your directory now using the root mapping. savy? Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 10:55 AM To: CF-Talk Subject: Okay, bear with me, I'm not even sure what I'm asking... Okay, here's the deal. One of our programmers has created an include that would be in the root of a site (call it, navbar.cfm) and there's one page (index.cfm) that calls it from the root (cfinclude template=navbar.cfm). Now, in navbar.cfm, there's a path to an image (let's say img src="" for instance). He's using absolute paths because he says slash images should always refer to the root and doesn't understand why he can't include that same file in a page one directory below (about/index.cfm) and it not work. In other words, when the page below (about/index.cfm) tries to reconcile the path, it's seeing the same path that the root page is seeing (img src="" and it's breaking it and not showing the image (so now, when you view source on the page, you see http://devserver.ourdomain.com/images/... and you should see http://devserver.ourdomain.com/ThisSite/images/...) . Now, our development server is set up on a smallish PC running IIS and the site (and all others in development) is set up under the webroot of the IIS server, so that when you're testing it, you simply go to http://devserver.ourdomain.com/ThisSite/ and you can see the root of ThisSite which is the directory ThisSite under webroot (C:\InetPub\wwwroot\ThisSite). Is a virtual directory what he's looking for? Is it a mapping issue? I admit, I'm fairly stupid when it comes to IIS issues and web server administration issues, and will readily admit that I'm no mapping wizard, so I hope I explained it correctly, but I'd love to be able to do this. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Okay, bear with me, I'm not even sure what I'm asking...
Did I misunderstand this - I think he IS asking why he can't use cfinclude exaclty like he uses img... why img src="" works and why cfinclude template=/images/blah.cfm doesn't... right? I don't think he's asking how to use the image tag, I think he's asking how to get at the root using cfinclude - which IS germane to a cf mapping. -mk -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 12:56 PM To: CF-Talk Subject: RE: Okay, bear with me, I'm not even sure what I'm asking... No, mappings in CF have nothing to do with the web path to the images directory.The mappings in CFAdmin only have to do with cfinclude, cfmodule, CFCs and CF related actions.img src.. is an HTTP thing and all of that is managed by your web server.You just have to remember that as far as the browser is concerned, one file is being called (no matter how many includes you're doing) and all of your img src... Tags need to have the right path when they're called by the main document, no matter how many includes are being called or where they're located on the server. John Burns -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 1:43 PM To: CF-Talk Subject: RE: Okay, bear with me, I'm not even sure what I'm asking... Jeff, The easiest way I see to fix this quickly (if you don't have multiple sites each running different image directories) is to make a mapping in the CFAdmin of /images pointing to the images directory. That should clear up the problem. Steve -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:55 AM To: CF-Talk Subject: Okay, bear with me, I'm not even sure what I'm asking... Okay, here's the deal. One of our programmers has created an include that would be in the root of a site (call it, navbar.cfm) and there's one page (index.cfm) that calls it from the root (cfinclude template=navbar.cfm). Now, in navbar.cfm, there's a path to an image (let's say img src="" for instance). He's using absolute paths because he says slash images should always refer to the root and doesn't understand why he can't include that same file in a page one directory below (about/index.cfm) and it not work. In other words, when the page below (about/index.cfm) tries to reconcile the path, it's seeing the same path that the root page is seeing (img src="" and it's breaking it and not showing the image (so now, when you view source on the page, you see http://devserver.ourdomain.com/images/... and you should see http://devserver.ourdomain.com/ThisSite/images/...) . Now, our development server is set up on a smallish PC running IIS and the site (and all others in development) is set up under the webroot of the IIS server, so that when you're testing it, you simply go to http://devserver.ourdomain.com/ThisSite/ and you can see the root of ThisSite which is the directory ThisSite under webroot (C:\InetPub\wwwroot\ThisSite). Is a virtual directory what he's looking for? Is it a mapping issue? I admit, I'm fairly stupid when it comes to IIS issues and web server administration issues, and will readily admit that I'm no mapping wizard, so I hope I explained it correctly, but I'd love to be able to do this. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Okay, bear with me, I'm not even sure what I'm asking...
Ok let's review: This:[src="" not include anything in the page processing.Instead it generates a separate http request AFTER the page is downloaded to the browser. That second request goes to: http://*whateverMyDomainIsCalled*.com/images/image1.jpg This:[cfinclude template = Client1/navbar.cfm]gets executed BEFORE the page is sent to the browser and actually RUNS the code in the file at: c:\*whateverTheCURRENTtemplateDirectoryIs*\Client1\navbar.cfm So if you want to include something from the root which is at: c:\wwwdocs\Client1\ And the template CALLING the included code is in C:wwwdocs\Client1\legal\ and you use cfinclude template=/client1/navbar.cfm the server first looks to see if there is a mapping for / in the cf settings.If there is no mapping for /, it then looks to see if there is a directory (a folder) called /client1 in directory (folder) containing the Calling template (the one in /legal/).It never actually looks at the root of the WEBSITE because CF has no knowledge of those settings IIS hands a request to CF, CF fills a buffer with stuff to send back and hands it back to IIS. That's how it works. In the scenario that you present, and assuming you are using the default installation of CF, if you tried: cfincldue tamplate=/client1/navbar.cfm (what's a tamplate?) the web server would try to include from the / mapping - usually the default web site directory - like inetpub/wwwdocs.If your web site is NOT the default web site on the server, or if the mapping has been removed (maybe a good idea on a shared server), then you will throw an error. If you tried cfinclude template =client1/navbar.cfm from the /legal/ directory - it would be looking for: c:\*whateverTheCURRENTtemplateDirectoryIs*\legal\Client1\navbar.cfm again it would fail. There are only 2 ways to to call a file using CFINCLUDEfrom (for example) c:\sites\mywebsites\client1\legal that resides in c:\sites\mywebsites\client1\ 1)use the ubiquitous 2 periods to move back one dir cfinclude template=../client1 B)Create a mapping in the cf administrator to use.For example, if you created a mapping called /bob/ that pointed to c:\sites\mywebsites\client1\ you could do cfinclude template=/bob/navbar.cfm and it would work.. although it might be a tradmark infringement. I hope this helps. Mark -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 1:56 PM To: CF-Talk Subject: Re: Okay, bear with me, I'm not even sure what I'm asking... - Original Message ----- From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 25, 2004 2:36 PM Subject: RE: Okay, bear with me, I'm not even sure what I'm asking... Did I misunderstand this - I think he IS asking why he can't use cfinclude exaclty like he uses img... why img src="" works and why cfinclude template=/images/blah.cfm doesn't... right? I don't think he's asking how to use the image tag, I think he's asking how to get at the root using cfinclude - which IS germane to a cf mapping. Okay, see? I wasn't sure WHAT I was asking, but I knew I wasn't asking about using the image tag, lol. We've got several clients. They're all located this way. http://development.somedomain.com/client1/ http://development.somedomain.com/client2/ http://development.somedomain.com/client3/ And say, under client1/ (which is located at C://InetPub/wwwroot/client1/ logically) there are a couple of subdirectories (say client1/About/, client1/Contact/, client1/Products/, ) and for the index page in each directory, he'd like to use one include for footer/legal/link stuff in the root, or navigation include in the root (say for example Client1/navbar.cfm, and Client1/disclaimer.cfm) and in those directories, he wants to use absolute paths for the image directory in the root, so in his ONE include, he can say [src="" and it will work whether or not he's in the root, or in the lower (Products) directory. Make sense now? We'd like to have a mapping somehow for: http://development.somedomain.com/client1/ http://development.somedomain.com/client2/ http://development.somedomain.com/client3/ That would make it the root of each site so we could use cfincludes in that manner. Is a CF-Mapping what I'm looking for? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql server
yes... just download the trial and install the client tools only. they do not expire. -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 8:54 AM To: CF-Talk Subject: RE: sql server Is that a free download. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 9:51 AM To: CF-Talk Subject: RE: sql server Enterprise Manager from SQL 7 or SQL 2000 whichever you are using -Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 9:44 AM To: CF-Talk Subject: sql server Hello, I have had a asp/sql app dropped in my lap to make some updates to. Problem is I have very little to no experience with sql server and the site is hosted on a shared box somewhere. I do think Ihave all the proper usernames and passwords. Question is how can I connect to the romote db and see the table layout and what is in those tables. A gui (free) of some type. Thank you for you help. Jeremy _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quick SQL Question...
That's a neat trick- saves a lot of typing. Thanks! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:35 PM To: CF-Talk Subject: RE: Quick SQL Question... thank you! -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:31 PM To: CF-Talk Subject: RE: Quick SQL Question... The numbers in the 3rd position of the convert are qualifiers for how it will convert.In this case 101 = USA = MM/DD/YY. If you look in the SQL Books Online under Cast and Convert it will give you a list of all of the date conversions. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:18 PM To: CF-Talk Subject: RE: Quick SQL Question... WOW! WOW! WOW! Thanks so much. I knew this was possible. what is the significanse of the 101 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:03 PM To: CF-Talk Subject: RE: Quick SQL Question... Che, If you are on MSSql 2K then this is the solution: select count(convert(varchar, creationdate, 101)), convert(varchar, creationdate, 101) from referer group by convert(varchar, creationdate, 101) Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:52 PM To: CF-Talk Subject: RE: Quick SQL Question... mark, i see where you are coming from...alas, i still am having no luck. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:51 PM To: CF-Talk Subject: RE: Quick SQL Question... The 2 are mutually exclusive.One is the group of all the stuff on this day, but the other (the actual date) is not merely a date - but a - by nature a very unique item - down to the second. So you are actually getting the grouping you are asking for.If 2 referals occured at the exact instant (say '3/4/2004 5:07:35 PM') ... then you would see 2 3/4/2004 5:07:35 PM - but since that's unlikey this is more or less like doing a select * from..What you need is a label and an order by clause: SELECT COUNT(creationdate) AS TotalRefsPerDay, datepart(month,creationdate) + '-' + datepart(day,creationdate) + '-' + datepart(year,creationdate) AS datelabel group by datepart(dw,creationdate) order by datelabel or something similar.The DateName( ) function would work as well - maybe better. It usally takes some work to get it exactly right. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject: Quick SQL Question... This SQL Code works: SELECT COUNT(creationdate) AS TotalRefsPerDay FROM Referer GROUP BY DATEPART(dw, creationdate) 197 364 350 294 260 243 196 But when I add a column... this does not): SELECT COUNT(creationdate) AS TotalRefsPerDay, creationdate FROM Referer GROUP BY DATEPART(dw, creationdate), creationdate 1 3/4/2004 5:07:35 PM 1 3/4/2004 5:09:27 PM 1 3/4/2004 5:11:19 PM 1 3/4/2004 5:13:14 PM 1 3/4/2004 5:14:31 PM 1 3/4/2004 5:14:53 PM 1 3/4/2004 5:16:19 PM 1 3/4/2004 5:20:37 PM 1 3/4/2004 5:21:10 PM What am I doing wrong? I'd like a simple two column table: creation date and the total number of referers for each day! TIA...Che _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: HTTPS: what factors disable it?
Reed, If all items on the page are not secure then the page is NOT secure. Unless you have disabled the message you will see all items on the page are not secure - do you still want to display the page? in a pop-up - then you must click ok to continue (that's in the ubiquitous IE 5+).Other browsers do variations of this behavior.Remember, every img tag and script tag (using the src attribute) and every object/embed tag and every link tag with the src attribute generate separate http requests - so even if your initial host page request is secure, can you really consider the page secure if not all the items on the page are secure?Ergo, IE will only show the padlock if everything is secure on the page. check out this example. with an embedded unsecure image: https://www.neirelo.com/testSecure.cfm without the image: https://www.neirelo.com/testSecure.cfm?showImage=false I hope this helps you. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Reed Powell [mailto:[EMAIL PROTECTED] Sent: Sunday, March 14, 2004 3:00 PM To: CF-Talk Subject: HTTPS: what factors disable it? Once again I'm in slightly new territory.Never had to worry about https in the past, everything was inside of the corporate network and no one really cared.Now I'm in the real world and... I have a site with a secure area that works fine when I test with a simple HTML file - in other words, the page renders and the IE padlock appears. But when I put up my CF page, the page still renders fine, but the padlock is not there.What sorts of things could I be doing that would cause this? It has a bunch of HREFs and IMG SRC references to another website on another server. Could that be the problem? I've tried some simple test pages with external references, and they still have the padlock.The references to the external site are via http: and not https: I'm missing something here - any ideas?Are there some things that are not permitted on a page accessed as https?I've checked a number of online https tutorials and haven't seen anything. Thanks, -reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
20 meg updater for DWMX 2004
Wow... that's a hefty updater. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quick SQL Question...
The 2 are mutually exclusive.One is the group of all the stuff on this day, but the other (the actual date) is not merely a date - but a - by nature a very unique item - down to the second. So you are actually getting the grouping you are asking for.If 2 referals occured at the exact instant (say '3/4/2004 5:07:35 PM') ... then you would see 2 3/4/2004 5:07:35 PM - but since that's unlikey this is more or less like doing a select * from..What you need is a label and an order by clause: SELECT COUNT(creationdate) AS TotalRefsPerDay, datepart(month,creationdate) + '-' + datepart(day,creationdate) + '-' + datepart(year,creationdate) AS datelabel group by datepart(dw,creationdate) order by datelabel or something similar.The DateName( ) function would work as well - maybe better. It usally takes some work to get it exactly right. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject: Quick SQL Question... This SQL Code works: SELECT COUNT(creationdate) AS TotalRefsPerDay FROM Referer GROUP BY DATEPART(dw, creationdate) 197 364 350 294 260 243 196 But when I add a column... this does not): SELECT COUNT(creationdate) AS TotalRefsPerDay, creationdate FROM Referer GROUP BY DATEPART(dw, creationdate), creationdate 1 3/4/2004 5:07:35 PM 1 3/4/2004 5:09:27 PM 1 3/4/2004 5:11:19 PM 1 3/4/2004 5:13:14 PM 1 3/4/2004 5:14:31 PM 1 3/4/2004 5:14:53 PM 1 3/4/2004 5:16:19 PM 1 3/4/2004 5:20:37 PM 1 3/4/2004 5:21:10 PM What am I doing wrong? I'd like a simple two column table: creation date and the total number of referers for each day! TIA...Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
How about: WHERE(name LIKE '%Open%'or name LIKE '%Engineering%') AND name NOT LIKE ('%closed%') Personally, this is probably not the best way to handle status.I always have a status field - either an int or a small character field and use a constraint ('open','closed','pending') and always be assured of a proper status. -Mark gets me projects that are closed as well as open -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 10:41 AM To: CF-Talk Subject: SQL Help Hi all I need some help with a query that supplies a report. The issue for me is one of the tables: (simplified) Table UIDNameDescriptionParentProject_id This table contains different information in the same field (name),like the projects status (Initializing, Engineering, etc) , the type of project (Contractor, Govt), and condition (Open, Closed). So projects can have 1, 2 or 3 records in this table. The problem is if the user wants a report of all Open-Engineering-Govt projects. Name is a Text field. So I can get all the open with: WHERE name LIKE '%Open%' (needs to be LIKE because the information is not consistant, ie:Open, is Open,Opened, etc). But WHERE name LIKE '%Open%' and name LIKE '%Engineering%' gets me nothing becuase the field cant be both at same time and WHERE name LIKE '%Open%'or name LIKE '%Engineering%' gets me projects that are closed as well as open I can get the information I need by running mulitple queries: CFQUERY name=first WHERE name LIKE '%Open%' /CFQUERY CFOUTPUT query=first CFQUERY name=second WHERE name LIKE '%Engineering%' and project_ID = #first.project_id# /CFQUERY CFIF second.recordcount GT 0 is both opened and Engineering. /CFIF /CFOUTPUT But this is cumbersome. anyone know a better way? We are using:CF5 and SQL 2000. Thanks Rodney [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help
Don't you hate having to deal with someone elses bad design g.Actually it beats dealing with your own bad design - at least you can point a finger (ha). -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 12:07 PM To: CF-Talk Subject: RE: SQL Help Need to play around with this for awhile and see what I get. For some reason thought I tried NOT LIKE, but dont remember now ;o\ Agreed this is not a very good way to handle this. I did not designed the DB nor can I change it. Have to work with what they gave me. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 10:12 AM To: CF-Talk Subject: RE: SQL Help How about: WHERE(name LIKE '%Open%'or name LIKE '%Engineering%') AND name NOT LIKE ('%closed%') Personally, this is probably not the best way to handle status.I always have a status field - either an int or a small character field and use a constraint ('open','closed','pending') and always be assured of a proper status. -Mark gets me projects that are closed as well as open -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 10:41 AM To: CF-Talk Subject: SQL Help Hi all I need some help with a query that supplies a report. The issue for me is one of the tables: (simplified) Table UIDNameDescriptionParentProject_id This table contains different information in the same field (name),like the projects status (Initializing, Engineering, etc) , the type of project (Contractor, Govt), and condition (Open, Closed). So projects can have 1, 2 or 3 records in this table. The problem is if the user wants a report of all Open-Engineering-Govt projects. Name is a Text field. So I can get all the open with: WHERE name LIKE '%Open%' (needs to be LIKE because the information is not consistant, ie:Open, is Open,Opened, etc). But WHERE name LIKE '%Open%' and name LIKE '%Engineering%' gets me nothing becuase the field cant be both at same time and WHERE name LIKE '%Open%'or name LIKE '%Engineering%' gets me projects that are closed as well as open I can get the information I need by running mulitple queries: CFQUERY name=first WHERE name LIKE '%Open%' /CFQUERY CFOUTPUT query=first CFQUERY name=second WHERE name LIKE '%Engineering%' and project_ID = #first.project_id# /CFQUERY CFIF second.recordcount GT 0 is both opened and Engineering. /CFIF /CFOUTPUT But this is cumbersome. anyone know a better way? We are using:CF5 and SQL 2000. Thanks Rodney _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL custom Order by
David, Yes but this may OR may not return them in the order you are looking for. However, there IS an easy way to use the UNION operator this way (for ordering). You need to stop using the asterisk (stop it! bad programmer!!). Try this: -- SELECTcol1, col2, col3, 1 AS orderCol FROMcategory WHERE CatID = 10 UNION SELECTcol1, col2, col3, 2 AS orderCol FROMcategory WHERE CatID = 8 SELECTcol1, col2, col3, 3 AS orderCol FROMcategory WHERE CatID = 9 UNION SELECTcol1, col2, col3, 4 AS orderCol FROMcategory WHERE CatID = 11 ORDER BY orderCol Obviously you can do it in a loop. Here's a (completely untested) example: Cfset Inx = 1 cfset thisList=10,8,9,11 Cfquery name=blah datasource=blah cfloop list=#thisList# index=lItem SELECTcol1, col2, col3,#Inx# AS orderCol FROMcategory WHERE CatID = #lItem# cfif Inx IS NOT listLen(thisList) UNION /cfif cfset Inx = Inx + 1 /cfloop ORDER BY orderCol /cfquery -- -Mark -Original Message- From: David Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 2:36 PM To: CF-Talk Subject: RE: SQL custom Order by This could be a freak accident that this works for me.. But it did in SQL 2000.This may not be the most efficient way of doing this either. SELECT* FROMcategory WHERE CatID = 10 union all SELECT* FROMcategory WHERE CatID = 3 union all SELECT* FROMcategory WHERE CatID = 5 union all SELECT* FROMcategory WHERE CatID = 1 Try it, David -Original Message- From: Plunkett, Matt [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 1:39 PM To: CF-Talk Subject: RE: SQL custom Order by -Original Message- From: Mark W. Breneman Sent: Tuesday, March 09, 2004 1:24 PM To: CF-Talk Subject: SQL custom Order by I doubt this is possible, but is there a way to do a custom order by based on the order I provide?I need the SQL results to be in a specific order based on the catID, but not in ascending or descending order. The order that I want them in is 10,3,5,1,7,4,9,2,6,8. (Not sure this is possible in Sql Server, cause I don't use that). I would write a custom function to do this.So you would do: select catID, mysort(catID) srt from foo order by srt; In the function, just return what order you want given the catId. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFLUSH Advantages / Disadvantages
Hugo, A couple of folks asked so I posted it to my blog.I just started using this blog ap and I haven't got it quite configured so if you get an error don't bother emailing it to me g. -Mark http://blog.mxconsulting.com/ .. or if that doesn't work try http://dev.mxconsulting.com/mxc-blog/ -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 3:01 PM To: CF-Talk Subject: Re: CFFLUSH Advantages / Disadvantages Mark, would you like to share that movie, it sounds interesting. - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - Original Message From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 22:50 Subject: RE: CFFLUSH Advantages / Disadvantages | Nick, | | I've found cf flush to be useful when you are serving up long tabular | report data.If you are going to output several hundred rows, | cfflush can help a lot.One approach I've used that works great for | intranet sites where the browser is a known item is a combination of | a status bar, _javascript_ and cfflush.I create a flash movie that | has a status bar with frames from 1 to 100 (1 being an empty bar | and 100 being filled) based on a variable I can set using the | SetVariable( ) function in _javascript_. Then, as I'm outputting data | I increment that variable using cfflush and _javascript_. | | For example, using MOD 100 (or whatever threshold makessense to you) | and currrent row I could run a calculation that gives me the percent | commplete of the output. let's say 13 percent at row 200. Then, I | would write this: (scriptmovie.SetVariable(13,13%);/script) .. | the first item is the frame number I want the movie to go to and | stop, the second variable is a label.I use cfflush to send it to | the html page where it is run inline immediately. The result is a | nice looking status bar that climbs incrementally at the top of the | report and lets the user know that data is being sent to the browser | and to please be patient. This approach can be useful for things like | data upload tools where user uploads a spreadsheet or database that | is subsequently inserted into a table or appended to a file. That's | my 0.02. | | -Mark | | | | |-Original Message- |From: Nick Baker [mailto:[EMAIL PROTECTED] |Sent: Wednesday, March 03, 2004 3:25 PM |To: CF-Talk |Subject: CFFLUSH Advantages / Disadvantages | | |CF 4.5.1 and 5.0 | |Any opinions on the use of CFFLUSH? From my understanding you have |to deal with some tradeoff, e.g., it imposes several restrictions |on the use of other tags and the method of client variable storage. |The upside is not so clear, other than CFFLUSH help avoid time outs | on slow Web sites? | |Thanks, | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle / Stored Proc Issues
Did you check all your database settings to ensure they are the same (clobs and blobs and select method etc)?Have you tried creating a datasource on the test server that points to the live server then running your proc to see if it works? -mk -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 10:15 AM To: CF-Talk Subject: Oracle / Stored Proc Issues So basically we've moved some code from dev to production and on production it blew up. (big surprise right?) well the suprise is that whats blowing up is stored procedure calls that return queries. All other proc call are working like a champ but anything that returns a ref cursor throw an error saying Invalid number or types of arguments. As far as my knowledge allows, when you specify a cfprocresult that is interpeted as a argument. So does anyone have any idea why this would be working fine in dev but not production? I can assure you without posting any code that the calls are being made exactly how they should and the pl/sql is error free. I've had about 5-6 other developers take a look at this and everything codewise is airtight. [Adam Wayne Lehman] If you don't fake the funk, the funk will fake you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFLUSH Advantages / Disadvantages
Nick, I've found cf flush to be useful when you are serving up long tabular report data.If you are going to output several hundred rows, cfflush can help a lot.One approach I've used that works great for intranet sites where the browser is a known item is a combination of a status bar, _javascript_ and cfflush.I create a flash movie that has a status bar with frames from 1 to 100 (1 being an empty bar and 100 being filled) based on a variable I can set using the SetVariable( ) function in _javascript_. Then, as I'm outputting data I increment that variable using cfflush and _javascript_. For example, using MOD 100 (or whatever threshold makessense to you) and currrent row I could run a calculation that gives me the percent commplete of the output. let's say 13 percent at row 200. Then, I would write this: (scriptmovie.SetVariable(13,13%);/script) .. the first item is the frame number I want the movie to go to and stop, the second variable is a label.I use cfflush to send it to the html page where it is run inline immediately. The result is a nice looking status bar that climbs incrementally at the top of the report and lets the user know that data is being sent to the browser and to please be patient. This approach can be useful for things like data upload tools where user uploads a spreadsheet or database that is subsequently inserted into a table or appended to a file. That's my 0.02. -Mark -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 3:25 PM To: CF-Talk Subject: CFFLUSH Advantages / Disadvantages CF 4.5.1 and 5.0 Any opinions on the use of CFFLUSH? From my understanding you have to deal with some tradeoff, e.g., it imposes several restrictions on the use of other tags and the method of client variable storage. The upside is not so clear, other than CFFLUSH help avoid time outs on slow Web sites? Thanks, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
Stored procedures are not cached queries - they are compiled execution plans. The thing that makes the difference is the databinding. SQL knows what type a variable is prior to execution of the query. So it does not have to check in the system tables to see what type it should be using.For example, if you do the following: select * from mytable where user_id = 2 SQL doesn't know A) what the column names are and B) what datatype your 2 is.So first it looks in the system tables for that db and says, give me all the columns, which it uses for select, then it goes back to the system tables and says what datatype is the column 'user_id' in the table 'mytable'.Once it knows it's an int (for example) it qualifies the 2 as an int, builds an execution plan and proceeds. Now, a stored proc looks like this: spu_mystoredproce @var1=2, @var2='marcus' SQL knows in advance in this case that @var1 and @var2 are int and char respectively.It doesn't need to check - it just tests var1 to make sure it's an int and moves on. Incidentally, this is why the use of cfqueryparam can significantly improve your performance - it binds the type to a variable.SQL caches execution plans on the server side. When you do databinding you greatly increase the likelyhood of a cache hit for your execution plan. When you do traditional CF (like the query above) you have almost NO chance of finding an execution plan in the cache. -Mark -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 7:47 AM To: CF-Talk Subject: Re: SQL Multiple Inserts But will it help in terms of performance? My understanding is that Stored Procedures are cached queries.But if the query you use has different variable values everytime, then it's just like using a new query.no performance benefit. But if this is not the case, the I would totally use a stored procedure for this part!! - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 7:34 AM Subject: RE: SQL Multiple Inserts No, thats the whole point of a stored procedure...you pass it in variables and it does the processing _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:32 To: CF-Talk Subject: Re: SQL Multiple Inserts Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images.But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: total newbe question
basically cfquery datasource=blah insert into clntnote (thisdate,subject,note,type,compid) values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) /cfquery You will need to debug it of course. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 7:54 AM To: CF-Talk Subject: total newbe question Can you give me an example of how to rewrite this into a CFQUERY? CFINSERT datasource=#application.db# tablename=clntnote formfields=thisdate,subject,note,type,compid At 08:36 AM 2/25/2004, you wrote: From: Steven Sharko Is the word type a reserved word in CFMX? Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. That's a database error, not a CF error It's a reserved word in Access -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Steven, You need single quotes around all char data... as in '#form.subject#'. You will need to correctly format the date as well. Try using #createodbcdate(form.thisdate)#for that item.Also - as has been suggested a couple of times - using CFQUERYPARAM would be a good idea - faster, and safer - like the promise of mass rail transit. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Steven, I would add one more thing. Rather than beat your head agains the wall in CF, get a quick book - the teach yourself SQL in24 hours would do nicely - and use the query analyzer or some other raw tool where you can pass in queries and view results. Take a half a day and learn SELECT , INSERT, UPDATE and possible JOIN - and a few other tricks. Simple SQL is not hard to grasp.It reads pretty easily... you can get what is happening in most queries pretty quickly. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:38 AM To: CF-Talk Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: still having a problem with insert
Steven, yes... if you use createodbcdatetime() or createodbcdate() to massage the variable thisdate into something that looks like {ts '2004-02-25 09:49:00'}Then you must REMOVE the single quotes around that one... also, is the column name really thisdate?Remember the name of the column and the name of the variable don't have to match - that's a nuance of cfinsert (and a limitation).The name of the column is dictated by the table. -Mark -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 8:50 AM To: CF-Talk Subject: RE: still having a problem with insert I tried that and still got an error. Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\netpacq\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values ('#form.thisdate#','#form.subject#','#form.note#','#form.type#',#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values (apos;{ts apos;2004-02-25 09:49:00apos;}apos;,apos;Service Ticket 3173 - apos;,apos;brSubmitted by apos;,apos;tapos;,) At 09:49 AM 2/25/2004, you wrote: Subject: still having a problem with insert Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\serviceorders.cfm: line 127 125 : insert into clntnote (thisdate,subject,note,type,compid) 126 : values (#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#) 127 : /cfquery 128 :/CFIF 129 :CFIF ParameterExists(sta) eq 'true' SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts apos;2004-02-25 09:36:45apos;},Service Ticket 3172 - ,brSubmitted by ,t,) You'll need to delimit non-numeric values with single quotes: INSERT INTO ... VALUES('#Form.subject#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: freelancer
cf folks, A friend of mine (a designer) is working on a job site and needs a contractor. It's not the sort of project that we are interested in at the moment :)It's a job site - searches, job candidates and employers... subscription based I believe. I have no idea of the budget or anything else about it.If any of you have any interest let me know and I will get you in contact with her. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: SQL question
Yes but Query of queries DOES support the union key word. -Mark -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 2:01 PM To: CF-Talk Subject: Re: SOT: SQL question As listed in the original post, my ISP is using MySQL 3.23 (which has no support for union)... Cutter Ubqtous wrote: Cutter, On 2/23/2004 at 14:50, you wrote: CCT **qEventList QofQ** CCT select * CCT fromqHoliday, CCT qHoliday2 CCT order bySDate maybe try this in your QoQ: select * from qHoliday union select * from qHoliday2 order by SDate ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: EMERGENCY HELP NEEDED
A)did you restart both IIS and the Cold fusion? B)Can you resolve HTMLpages in the appropriate directories C) Did you (or did you consider) rerunning the remove/add connector script? -Mark -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 2:45 PM To: CF-Talk Subject: EMERGENCY HELP NEEDED I am running CFMX on Win2K using IIS5. I was uploading my sites to my new server, then I ran into a caching error where all the sites started using a cahced index.cfm page since I use a multi-homed server. So I read the following CF Macromedia article at http://www.macromedia.com/v1/Handlers/index.cfm?ID=23390Method=Full and made the chages as perscribed. Now I can type in the url address for all my sites and they come up. But if I try to go to any page where the page is not the home page I get a 404 file not found error. Inother words www.mysite.com will work, but www.mysite.com/about.cfm will fail. I NEED HELP FAST. PLEASE! Thank you so much in advance. Eric - Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What could be wrong with this code ? Any expertise on this please??
Ian, one guess: cfquery name=recordset_search datasource=#MM_Universe_Connection_DSN# username=#MM_Universe_Connection_USERNAME# password=#MM_Universe_Connection_PASSWORD# Put quotes around the username and password and datasource: cfquery name=recordset_search datasource=#MM_Universe_Connection_DSN# username=#MM_Universe_Connection_USERNAME# password=#MM_Universe_Connection_PASSWORD# If there are any weird characters in them this will alleviate that as a possibility. -Mark -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 9:50 AM To: CF-Talk Subject: What could be wrong with this code ? Any expertise on this please?? I am contacting you for some of your expertise please to see what could be causing this error ... I have set up a connection to an IBM universe database through Windows Administrative Tools ODBC Datasource Administrator, this pings and tests correctly. I then set this up through the ODBC socket option in CFMX administrator and it verfies ok. But when running my code in the browser I am receiving the following error, do you have any ideas on why I am getting this, I have been looking for a solution to this for months but to no avail. When testing in CF 4.5 this worked ok, it is just since we migrated to MX 6.1, could it be something to do with MX ??As I cant find nothing on the Macromedcia site ? Could it be a mapping or permissions problem that is causing to the Invalid argument value inCFMX ? CODE SNIPPET- cfif NOT (isDefined(SESSION.USERNAME)) cflocation url=""> /cfif cfparam name=FORM.P_STAFFNUMBER default= cfparam name=Search__P_STAFFNUMBER default=#FORM.P_STAFFNUMBER# cfif #SESSION.USERNAME# eq MCROW cfquery name=recordset_search datasource=#MM_Universe_Connection_DSN# username=#MM_Universe_Connection_USERNAME# password=#MM_Universe_Connection_PASSWORD# select count(*) staff_valid from SQL_PERS_DATA a where a.EmployeeNumber = '#Search__P_STAFFNUMBER#' and ((a.AA_Section = '#SESSION.SECTION#') OR (a.AA_Section = 'CATERING') OR (a.AA_Section = 'CLEANING')) AND AA_Directorate like '%EDUCATION%' /cfquery cfelse cfquery name=recordset_search datasource=#MM_Universe_Connection_DSN# username=#MM_Universe_Connection_USERNAME# password=#MM_Universe_Connection_PASSWORD# select count(*) staff_valid from SQL_PERS_DATA a where a.EmployeeNumber = '#Search__P_STAFFNUMBER#' and a.BB_PostLocation = '#SESSION.SCHOOL#' /cfquery /cfif END CODE SNIPPET- Error Occurred While Processing Request Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][VMARK][UVODBC][2301524]Invalid argument value. The error occurred in F:\staffno_search.cfm: line 15 13 : from SQL_PERS_DATA a 14 : where a.EmployeeNumber = '#Search__P_STAFFNUMBER#' 15 : and ((a.AA_Section = '#SESSION.SECTION#') 16 : OR (a.AA_Section = 'CATERING') 17 : OR (a.AA_Section = 'CLEANING')) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flash remoting help: UPDATED
Ryan, Yeah - your function is using a var to set your service.The responder is out of scope. get rid of the var. -mark -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: Re: flash remoting help: UPDATED Ok, lets start over :o) The flash movie now connects, well let me explain: The flash movie itself is a 1-frame wonder: // Include the Required NetService class files #include NetDebug.as #include NetServices.as #include DataGlue.as // connect to the Flash Remoting service provider function init () { NetServices.setDefaultGatewayUrl(http://lightwillrise.com:27000/flashservic es/gateway); var conn = NetServices.createGatewayConnection(); var service = conn.getService(cfcremoting.sendMe,this); service.sayHello(); trace('connected'); } function sayHello_Result(result) { trace(result); trace('some text'); } init(); stop(); And the cfc is as follows: cfcomponent cffunction name=sayHello access=remote output=true returntype=string cfset message = hello cfreturn message /cffunction /cfcomponent Now, in the output in flash debug I get ³connected², but nothing from the responder function... Any thoughts? Thanks for ALL the help! Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]