Search results for query: *

Thanks for the reply. The only problem with changing SP2 was that it would require changing the code of existing functions that already use it. I ended up resolving it by wrapping with another SP that enumerates the result set via a cursor as it requires fewer existing items to be changed.

Environment: W2K server and SQL Server 2000 with ColdFusion Server 5 Having a bit of a problem with a stored proc once I added a cursor as an output param. Error is: "Operand type clash: char is incompatible with cursor" This is the SP declaration: CREATE PROCEDURE...

Using SQLServer 2000 I have a series of SProcs where SP1, invokes SP2, which invokes SP3. All of these return a recordset and all are functioning properly. Issue: I need yet another layer of abstraction - another SP that will invoke SP1 iteratively, storing the return recordsets into a temp...

Found the answer to my own question - so this is for anyone else that may be trying to do this. Public Folder rights can be set through the ACL COM object available from MS (MSDN site) or SlipStick. While I have yet to find any good VB examples of utilizing the ACL object (other than a small...

I am using CDO to delete / recreate a public folder each evening with contact records. When the folder is created, Default permissions are set to Author and we need them to be Editor. I have not been able to find any documentation on changing the folder permissions programmatically through CDO...

Thanks for the reply - I was hoping studio had a way to set the url / parameters that would be used by the page while being debugged. THis would allow me to set a breakpoint on that page and then run that one page, bypassing the application.cfm and any pages in-between.

Using CF Studio 4.52- When debugging a page that requires a parameter to be passed by the referring page in the URL, is there a way to set the URL in the IDE (similar to setting command line parameters within other language environments) so that I can view / debug that page without first going...

A post to my query in the CF Forum on the Allaire site found the issue. Apparently, zero byte files in the mail spool folder can cause this problem. I had several such files and deleting them resolved the issue.

We have been using CF Server 4.0 on NT4 (SP6a) for over 1 year. Processed a mailing today and the service sent the CPU usage to 100%, and boot partition hard drive was filled by a TMP file created by the service. If I stop the service, CPU usage returns to normal and I can delete the file. Upon...

I am looking for a tool that will document or cross-reference a CF project. Specifically, show links between the different pages, all queries with the databases/tables used (insert, delete, select, etc). If anyone knows of a product / tool that does this, please post the product name or vendor...

Thank you for the reply. I have ordered some books and have been doing some additional reading on the Web and now have the basic concepts of how the ISAPI DLL processes the requests. I was under the original misconception that you could mix CF tags in an HTML document, but now see that it is...

Follow-up to my own post: It would appear that I would use JavaScript and the Select object OnChange event and then make a query based upon the selected value, setting the other object to the query result. If so, then I now need to determine how to call a CFQuery from the OnChange event and set...

I recently inherited a Coldfusion application and while I have experience in other languages, I have some very basic questions on CF. 1) Recommendations on any third party books to help me come up to speed on this environment. 2) The application I inherited uses MS SQL 7 on the backend and...