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 co
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(780
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
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
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
__
Thi
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
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
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 tag. Is
there anyway to prevent CF 4.0 from trying to parse this? Cftry doesn't
work. Testing for version in cfif does
8 matches
Mail list logo
