Search results for query: *

I always caution people against doing things like this in a stored procedure: @param1 is null You are trying to get SQL Server to base its execution plan on something that has noting to do with the database or data in it. This logic is better off in an IF statement than a WHERE clause. You...

Looking at the MS Docs for that audit group, it says that this audit "Indicates that a principal successfully logged in to a contained database." I'm not sure if it's referring to a true Contained Database or not, but if it is that may be your problem (unless you actually are using a Contained...

Unfortunately SQL Server doesn't provide an easy way to do this. There are some third party software products that you can buy that handle this for you. I actually wound up writing my own code to do it. I put it out on GitHub if you're interested, feel free to use it...

This was the #1 Result on Google when searching for "No buffer space available (maximum connections reached?)" http://kb2.adobe.com/cps/400/kb400700.html Hope This Helps! ECAR ECAR Technologies www.ecartech.com www.cfgears.com "My work is a game, a very serious game." - M.C. Escher

I think what your salesperson was referring to was the use of www.mycompanyhere.com, subdomain1.mycompany.com, etc. By "domain going down", he most likely meant that if your DNS record screws up for mycompany.com, then it shuts down all of your websites, whereas if they each had their own name...

He's right. I used to work at a hosting company that had over 100 sites running on CF Standard. Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

Not that this is an actual answer to your question, but here's a list of the top 100 ColdFusion websites according to Alexa and Google. There are some pretty impressive names in there... http://www.coldfusiondeveloper.com.au/go/top100/ Hope This Helps! ECAR ECAR Technologies...

Check out NumberFormat() http://www.cfquickdocs.com/#NumberFormat Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

Woo-Hoo! CF 8 is out! And it is packed with new features! Actually, this release has more new features added to it than any other release in CF history. Here's a good article by Ben Forta that touches on just a few of the new features...

DayOfWeek() returns the ordinal for the day of the week, as an integer in the range 1 (Sunday) to 7 (Saturday). http://livedocs.adobe.com/coldfusion/7/htmldocs/00000444.htm Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

These are good for a chuckle. Some of them are a tad vulgar, but it's all done in humor. I like the way they bash .Net and PHP, so that makes it worth it. [wink] Lenny And Bo, ColdFusion Programmers (Vol. 27) http://www.bennadel.com/blog/818-Lenny-And-Bo-ColdFusion-Programmers-Vol-25-.htm...

Not sure about calling a Job directly. You may can do it via cfobject, but I wouldn't think so (though I've never tried). I would suggest you ask the folks over at the SQL Server Forum (forum183) if there's a way to call a Job from a Stored Procedure. If so, just create the Procedure to call...

You'll need to use a CGI Environment Variable: http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Expressions5.htm I know that cgi.query_string gives you everything after the "?" in a url, but I don't think that's what you need. Maybe cgi.script_name? Not sure... Anyway, all you have to...

If you have the graphic you want displayed, you could easily do this with a few lines of code. Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

CF has built in encryption and decryption functions. I use them all of the time when passing url vars. MX 7 has some new features in the encryption function, and it makes it a little trickier to use, but once you figure it out it's pretty easy...

Did you by chance turn off JavaScript in IE? Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

Did this thread not fix your problem? thread232-1379130 Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

If the query results don't change much, just cache the queries. <cfquery name="" cachedwithin="whatever"> Hope This Helps! ECAR ECAR Technologies www.ecartech.com "My work is a game, a very serious game." - M.C. Escher

If all you need is the SQL Server database, and you have access to the hard drive it's on, then it should be just a matter of looking in the right directory. By default, SQL Server creates a database in 'C:\Program Files\Microsoft SQL Server\MSSQL\Data'. Unless you changed the directory when...

At one company I worked at Brainbench certifications were considered a joke. Applicants resumes with Brainbench listed on them were laughed at and thrown in the trash, and those people were never even called for an interview. I never personally had any dealings with this, as it was all done by...