Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pcorreia
-
cfobject to load a dll - asp vs cfm
Thanks for that information, thedrider. I didn't know about the ReleaseCOMObject() function (it's documented here). Even if you don't use that function, the JVM will release the object during garbage collection, but on a heavily-loaded server, freeing up the memory earlier could be a real... -
cfobject to load a dll - asp vs cfm
This is a lengthy topic, so I posted the answer off-forum on my own blog. Here's a synopsis: Search the HKEY_CLASSES_ROOT\CLSID key in the registry for a key containing a key named InProcServer32 whose default value is a path to the DLL in question. Take the name of that key (the CLSID of the... -
Blanking Dates and Text Truncation
I'm not sure if this is a factor in your first issue, but keep in mind that if you delete everything from a text form field, the field will not be submitted with the form and will not show up in the form scope on the handler page. If you check for the existence of the field in the form scope... -
Can I use CACHEWITHIN attribute in my stored procedure??
The documentation says that "cachedwithin" is only valid for the <CFQUERY> tag. However, you could roll your own caching mechanism by executing the procedure once, then copying the result set into a persistent memory store like the session, application, or server scopes. If you also... -
Top1 record for each employee
I think what you want is this: SELECT a1.SocSec, a1.BeginAbsenceDate, a1.AbsenceCode FROM tblAttendance AS a1 WHERE a1.BeginAbsenceDate = ( SELECT MAX(a2.BeginAbsenceDate) FROM a2.tblAttendance WHERE a2.SocSec = a1.SocSec ) ORDER BY SocSec The columns of... -
Using the Replace Function to replace " and ,
So, what I think you're saying is that you'd like to take the file name from the uploaded file and remove any comma, apostrophe, and quote characters. Try this: <cffile action="RENAME" source="#CFFILE.ServerFile#"... -
Easy Question on Session Timeouts
Just a clarification -- the session variables persist as long as the session is alive. The session counter is reset any time a page is requested in that session. So, it's not necessary to read or write to a session variable in each page just to keep it "alive" -- as long as the user... -
Problems querying Active Directory in SQL 2000
I am trying to use ADSI to query our domain's Active Directory. I used ADSI successfully to query the Exchange directory when we were on Exchange 5.5 but now that we are migrating to Exchange 2000 I need to query the Active Directory for the information I need. After running the following code...- pcorreia
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Sending a ColdFusion e-mail in both plain text and html
Falcao and moonriver, you should have just received the custom tag via e-mail. Let me know if you have any problems... pcorreia -
CFMX Updater 3 Released
Macromedia has released the ColdFusion MX Updater, version 3. The updater is Macromedia's version of a service pack for CFMX. General Information http://www.macromedia.com/software/coldfusion/special/updater/faq/ Release Notes (including list of fixes)... -
Executing an application on client side
Righto, Carl. Clearly, my solution is only viable if you are developing an internal application where you know the audience only uses a single browser on a limited set of OSes, and that single browser is IE and those OSes are Windows 2000 and above. A lot of ifs, I know. But, that begs the... -
Executing an application on client side
Using the WScript.Shell ActiveXObject, you could execute a command-line application on the client using JScript in your web page. Limitations are:The client must be running Windows and have the Windows Scripting Host installed (comes with Windows 2000 and later, I think)Depending on the... -
web page title
It would probably be faster to use <CFFILE>, because then you're doing a direct file access instead of requesting the page from the web server. Then, use REReplaceNoCase() to find the contents of the <title> and <meta> tags. If the directory you wanted to search was "C:\Temp", for... -
encrypt password before submit
If your purpose is to protect the password during transmission from the client to the server, that means you need to encode it on the client, but in a manner that you can reproduce on the server. ColdFusion's Hash() function encrypts a string with the MD5 algorithm, and a JavaScript library to... -
print @<variable> problem
Admittedly, I know very little about ODBC. What I meant was, when I put SQL Server-specific syntax in a <CFQUERY>, it is executed properly on the SQL Server even though it is going through ODBC, so clearly you can use SQL commands that are not part of the ANSI spec. I think DBAssam should...
