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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. pcorreia

    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...
  3. pcorreia

    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...
  4. pcorreia

    Can I use CACHEWITHIN attribute in my stored procedure??

    The documentation says that &quot;cachedwithin&quot; 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...
  5. pcorreia

    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...
  6. pcorreia

    Using the Replace Function to replace &quot; 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=&quot;RENAME&quot; source=&quot;#CFFILE.ServerFile#&quot...
  7. pcorreia

    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 &quot;alive&quot; -- as long as the user...
  8. pcorreia

    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...
  9. pcorreia

    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
  10. 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)...
  11. pcorreia

    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...
  12. pcorreia

    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...
  13. pcorreia

    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 &quot;C:\Temp&quot;, for...
  14. pcorreia

    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...
  15. pcorreia

    print @&lt;variable&gt; 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...
  16. pcorreia

    print @&lt;variable&gt; problem

    I believe ODBC is just a connection syntax, and should &quot;pass through&quot; any SQL regardless of whether it is vendor-specific. The problem is that <CFQUERY> isn't a full-fledged SQL development environment. It expects a single result set, and doesn't support any debugging output (which...
  17. pcorreia

    get record from time selected

    How about this? SELECT * FROM roomHotel WHERE #FORM.from_time# BETWEEN from_time AND to_time OR #FORM.to_time# BETWEEN from_time AND to_time -pcorreia Hope this was a Helpful post!
  18. pcorreia

    problems with ssl (https) on IE 5.0

    Have you verified that the problem is with the SSL? If you disable the SSL and try it with IE5.0, does the problem go away? -pcorreia
  19. pcorreia

    Check Box - Only One Selected In table

    This will have to happen when the page is submitted, but if the &quot;name&quot; attribute of your radio buttons is &quot;key&quot;, you can assign the &quot;value&quot; of the radio button selected to a session variable like this: <cflock scope=&quot;SESSION&quot; type=&quot;EXCLUSIVE&quot...
  20. pcorreia

    help w/ regular expressions

    I can definitely help you with this, but I'm a little unclear on what exactly you want to know. Are you looking for information on how to search the whole document for multiple matches on your RegExp pattern? Or are you looking to retrieve the value of a subpattern within the match? -pcorreia

Part and Inventory Search

Back
Top