How to Access Debugging info (Queries and Execution Time) progr ammatically
Is there a way to access Queries and Execution Time that are part of the debugging information programattically? CF_Dump, can get pretty much everything important in the parameters piece, but it would be nice, say in an error handling script to get an email with all of the information that's contained in the debug info. (not just the error and variable information). __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need SQL Server version of createtable_Access
My suggestion is to write a stored procedure using the t-sql create table
command. You'll have a lot of power to customize it exactly as you wish.
it could be as simple as this:
-- begin code
CREATE PROCEDURE [dbo].[usp_create_table]
@table_name varchar(100) ,
@body varchar(7800)
AS
declare @sql_begin varchar(100)
declare @sql_middle varchar(100)
declare @sql_end varchar(100)
set @sql_begin = 'CREATE TABLE dbo.'
set @sql_middle = '('
set @sql_end = ')'
execute(@sql_begin + @table_name + @sql_middle + @body + @sql_end)
GO
-- end code
@table_name is the name of the table.
@body are the parameters of the create table command.
If you're not familiar with create table, check out Books Online in Query
analyzer.
-Original Message-
From: Vishal Narayan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 7:05 AM
To: CF-Talk
Subject: Need SQL Server version of createtable_Access
I found on the Allaire Developer's Exchange a custom tag called
createtable_Access, which allows me to create a table in any MS Access ODBC
datasource accessible through ColdFusion, in which we can define Primary
Key, Required fields (Not Null), and Unique values.
What I need is a SQL Server version of this tag. Does anyone know if such a
tag is available ? I need to be able to create new tables through a
web-based interface on my SQL 2000 DB.
Vishal.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RecordCount is 0 en Stored Procedure
Your problem is that if no records exist then @count NULL, not 0. Try this. SELECT @Count=coalesce(COUNT(UserName),0) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:31 PM To: CF-Talk Subject: RecordCount is 0 en Stored Procedure Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF @Count=0 BEGIN /*Here I write my action*/ END _ Do You Yahoo!? Informacion de Estados Unidos y America Latina, en Yahoo! Noticias. Visitanos en http://noticias.espanol.yahoo.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Still Need Help with Stored Procedure.
Your problem may be on the database side, and not with your CF code. 1) Is the database owner, dbo, and not the user that created it? 2) Have you granted execute permission on on the stored proc to the SQL id you use on your DSN? Jim -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 10:48 AM To: CF-Talk Subject: Still Need Help with Stored Procedure. Stored Procedure Help!!! We still have not figured out why we cannot access the following stored procedure with cold fusion. We can use do it with ASP, but if we are going to have to use ASP to access all the stored procedures (there are several of them) then the reason to migrate to Cold Fusion is diminished. Following is all the information I could gather about how we are trying to do this. Thanks Ian Skinner [EMAIL PROTECTED] www.ilsweb.com COLD FUSION STORED PROCEDURE CODE CFSTOREDPROC PROCEDURE=sp_ktChgsPmtsByDate DATASOURCE=Paragon USERNAME=sa PASSWORD= PROVIDER=OLEDB DBSERVER=SQL6932440 DBNAME=paragon RETURNCODE=YES DEBUG CFPROCRESULT NAME = YestPayments CFPROCPARAM TYPE=In DBVARNAME=@SDate VALUE='#SDate#' CFSQLTYPE=CF_SQL_DATE CFPROCPARAM TYPE=In DBVARNAME=@EDate VALUE='#EDate#' CFSQLTYPE=CF_SQL_DATE /CFSTOREDPROC MOST COMMON ERROR MESSAGE RECEIVED Error Occurred While Processing Request Error Diagnostic Information OLEDB Error Code = 0 NULL Interface Ptr SQL = sp_ktChgsPmtsByDate Data Source = Paragon The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (18:1) to (26:7) in the template file E:\Inetpub\wwwroot\MarshallReports\YestPaymntsToPatAccts.cfm. Date/Time: 03/22/02 09:50:37 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) Remote Address: 172.16.3.104 WITH SOME CONFIGURATIONS OF THE CFSTOREDPROC TAG, WE RECEIVE THIS ERROR MESSAGE Error Occurred While Processing Request Error Diagnostic InformationData Access Error Unknown Data Access Error. SQL = sp_ktChgsPmtsByDate2 Data Source = Paragon The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (39:1) to (41:18) in the template file E:\Inetpub\wwwroot\MarshallReports\YestPaymntsToPatAccts.cfm.Date/Time: 04/05/02 11:14:08Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)Remote Address: 172.16.3.104 HERE IS THE SQL CODE IN THE STORED PROCEDURE. /* Payments (Detail) to Patient Account made during a Date Range sorted By Visit CREATED BY KEVIN TRAMMEL 3/2002 */ @SDate Datetime=NULL, @EDate Datetime=NULL AS -- Massage the date parameters to suitable boundary values: exec sp_ktDateMaker @SDate,@EDate OUT SELECT RTRIM(VPM300_PAT_VISIT.vst_ext_id) VisitID, Payment=(ISNULL(-1*(VPB110_PMT_ADJ_DETAIL.pmt_pst_at),0)), TPB900_CHG_CODE_MST.chg_cod_ext_id ChargeCd, VPB110_PMT_ADJ_DETAIL.pmt_dtl_ds PaymentDetail, PaymentPostDt=CONVERT(varchar(10),VPB110_PMT_ADJ_DETAIL.pmt_pst_ts,101), PatNam=RTRIM(VSM040_PERSON_HDR.lst_nm) + , + RTRIM(VSM040_PERSON_HDR.fst_nm), AdmitDt=CONVERT(datetime,CONVERT(char(12),VPM300_PAT_VISIT.adm_ts,101)), ExtFinClass, VPB110_PMT_ADJ_DETAIL.vst_int_id FROM VPB110_PMT_ADJ_DETAIL INNER JOIN VPM300_PAT_VISIT ON VPB110_PMT_ADJ_DETAIL.vst_int_id=VPM300_PAT_VISIT.vst_int_id) INNER JOIN VSM040_PERSON_HDR ON VPM300_PAT_VISIT.psn_int_id = VSM040_PERSON_HDR.psn_int_id) LEFT JOIN VPB200_BILLING_INVOICE ON VPB200_BILLING_INVOICE.vst_int_id=VPM300_PAT_VISIT.vst_int_id) INNER JOIN v_FinClassConv ON VPM300_PAT_VISIT.fin_cls_cd=v_FinClassConv.IntFinClass) INNER JOIN TPB900_CHG_CODE_MST ON VPB110_PMT_ADJ_DETAIL.chg_cod_int_id = TPB900_CHG_CODE_MST.chg_cod_int_id WHERE (((VPB110_PMT_ADJ_DETAIL.acc_pcs_dt)=@SDate And (VPB110_PMT_ADJ_DETAIL.acc_pcs_dt)@EDate)) ORDER BY VPM300_PAT_VISIT.vst_ext_id CF ADMINISTRATOR SETTING FOR THE DATA SOURCE (Image may not show) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Directory War Stories
I would like to be able to leverage directory services (ldap, e-directory, active directory, etc) in my cf application. I'm curious what people have done, page level permissions basis to take advantage of a directory. Jim __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Getting the id of the row you just inserted...
It seems to me that there are three basic ways to get the id of the row you just inserted. 1) @@identity and 2) cflocking the insert statement and the select max(id) statement. and 3) qualifying the select max(id) statement to avoid problems caused by multiple threads. I'm curious which method people use and which they find to be the best. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crystal Reports Integration
That error seems typical of some sort of SQL error on the report itself. This could be due to 1) Problem with the DSN on the report 2) Security rights for the report DSN 3) Invalid parameters passed to the report by CFReport Crystal has weak error handling and tends to return meaningless error messages in its web reports piece. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 9:40 PM To: CF-Talk Subject: Crystal Reports Integration Has anyone used crystal Reports in CF5? Do I have to export the reports from Crystal in some special format in order for the CFREPORT tag to read them? This is the error I am getting: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File C:\sites\xxx\reports\summarybygroup.rpt: Invalid export DLL or export format.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16) DLL Version = 8.0, Engine Version = 8.0 Any hints or tips? I thought, naively, that it would all just work :) -Gel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to Handle Multiple CF Versions?
Say I have an application that will be deployed in mulitple environments, some which are CF 4.5, and some which are CF 4.0. In in the CF 4.5 environments, I want to use the cfmailparam tag. Is there anyway to prevent CF 4.0 from trying to parse this? Cftry doesn't work. Testing for version in cfif doesn't work. Any help would be appreciated. Jim Voris ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
