How to get several resultsets from SP

Hi all I need to know dynamically the number(and metadata) of resultsets returned after executing a Stored Procedure. I'm using CF MX 6 and SQL Server. With CF I can do that? Any tips? Factory methods? Cheers MD ~| Message: ht

css file based in screen resolution

Hi all I'm looking for tips about how to use css files based in screen resolution. By now I'm include in application.cfm a template(screenresolution.cfm) with Ajax. In Ajax I'll store in session var that screen resolution. But when load any template occurs an error: variable session.screenresolu

Version control - how to?

Does anybody have any suggestions for somebody who's never used any source control? We use DW8 as our primary IDE, CF 6.1 in dev/prod server. Subversion is a good application? Works in WindowsXP and CF/IIS(without Apache) with application server? Any example with this settings? Cheers MD ~~

threerelatedselects - do you can help?

I was wondering if anyone had a "fixed" version of the custom tag, ThreeSelectsRelated. The copy that I have doesn't work properly with the default values when using with "edit" mode forms. Only the value of default1 work. I've been banging my head and pulling my hair out trying to get it to wor

Converting application.cfc to application.cfm

Hi all I'm testing stickyCache, a very nice encapsulate model build by Nic Tunney. Your link: http://www.nictunney.com/stickyCache.cfm. stickyCache uses application.cfc to manage your session, init cache.cfc and facade.cfc and so on. Great. Works fine in my dev machine with CF 7. But our prod ser

Re: OT - RegEx gurus - help

Thanx Chris and Ben works fine now. After all your code is great. Simple and clear. Cheers MD 2006/3/6, Michel Deloux <[EMAIL PROTECTED]>: > > Thanx Ben > > We`re using CF 6.1 too |o-) > > Using my regex pattern allows this entries- > A8 (incorrect) > C8 (incorre

Re: OT - RegEx gurus - help

Thanx Ben We`re using CF 6.1 too |o-) Using my regex pattern allows this entries- A8 (incorrect) C8 (incorrect) A9B(incorrect) A1-3B-E|B-E are the correct entry. Any suggestion? Cheers MD 2006/3/6, Ben Doom <[EMAIL PROTECTED]>: > > Michel Deloux wrote: > > ^([Aa]{1}[1-3

Re: OT - RegEx gurus - help

Thanx Chris. Using your sample fails when user enters A6 or B6. Please look my code used for client JS validation? ^([Aa]{1}[1-3]{0,1}[B-Eb-e]{0,1}|[B-Eb-e]{1}) Using RegEx Coach application works fine allowing only the correct chars. But when inserting in CF template fails. What's wrong? Chee

OT - RegEx gurus - help

Hi all sorry for OT but I need your help RegEx gurus. In my form users can insert a field with this pattern: A|1-3|-B|C|D In resume can insert ? A or A1B or A2B or A3B or A1C, A2C, A3C, A1D, A2D, A3D, A1E, A2E, A3E, AB, AC, AD, B, C, D Validating only letters work fine but that all combinations

Re: [SOT] RegEx question

Thanks Claude and Jacob. Works fine. Great job. Cheers MD 2006/2/24, Munson, Jacob <[EMAIL PROTECTED]>: > > Try this: > > > > Original: #myStr# > Extracted: #Mid(myStr,reMatch.pos[3],reMatch.len[3])# > > > > -Original Message- > >

Re: [SOT] RegEx question

;-) Thnx Claude. Great marketer! ;-) 2006/2/24, Claude Schneegans <[EMAIL PROTECTED]>: > > This is for RegEx gurus: > > This is for CF_REextract: > 1. go to > http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm > 2, enter [^a-zA-Zçä]* in RE1 > 2. enter [^a-zA-Zçã]+|$ in RE2

[SOT] RegEx question

Hi all. This is for RegEx gurus: look this example: (;*%3242432424;testing%%*%%from%%regex%*;) How to get all words inside the first (; and ;)? For this simple example will return *%3242432424;delete%%*%%from%%maçã%* Cheers MD ~~~

Re: CFMX errs on Java class .isAuthenticated() method

Hi all It's possible to use .class file with CF MX 6.1? How can I do that? Cheers MD 2006/1/19, RADEMAKERS Tanguy <[EMAIL PROTECTED]>: > >-Original Message- > >Folks--- How do I get around this one? In my CFMX6.1 template > >I instantiate userObj from a Java User class used for > >auth

Crimson is faster than Xerces?

What's the fastest and reliable XML Parser for CF? Crimson, Xerces? Using Crimson(default for CF 6.1) my script runs slowly. Using Xerces I'll see any improvement? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/lin

Creole/Propel for CF World

Hi all CF haves an alternative ORM framework like Propel(PHP)? Propel looks a very interesting framework. But what's Propel? " The propel generator creates a class "Book" for you that has all getter and setter methods for storing and retrieving the data. If you wanted to insert a new book with a c

Re: How to know if a DB is online

Thnx James. Great Ben Forta!! Cheers MD 2006/1/27, James Holmes <[EMAIL PROTECTED]>: > http://www.cflib.org/udf.cfm?ID=685 > > On 1/27/06, Michel Deloux <[EMAIL PROTECTED]> wrote: > > Thanx Pete and John. > > > > That script works fine for me. L

Re: How to know if a DB is online

Thanx Pete and John. That script works fine for me. Looking for improvements. Cheers MD 2006/1/27, John Beynon <[EMAIL PROTECTED]>: > and that's not working? > > the admin API should be able to verify a DSN for you - if not the > factory service can, > > jb. &

How to know if a DB is online

Hi all, do you have suggestions about how to know if a external DB is online? I'm using this simple script: select TOP 1 field from externalDB where 1=1 Error - DB offline Cheers MD ~| Message: http://www.houseoffusi

Re: When CF restart?

And using CFMX 6.1. ;-) 2006/1/24, Dave Watts <[EMAIL PROTECTED]>: > > Thanx Adrian and Dave. What I need to know: when an > > application starts, one event will be run setting a variable. > > If CF controls (via applicationtimeout) the application time > > where I'll view this settings? In se

Re: When CF restart?

Thanx Adrian and Dave. What I need to know: when an application starts, one event will be run setting a variable. If CF controls(via applicationtimeout) the application time where I'll view this settings? In server scope? Factory? MD 2006/1/24, Dave Watts <[EMAIL PROTECTED]>: > > After restart a

When CF restart?

Hi all After restart a server all applications will wake up right? How to know when(MM/DD/ HH:mm:ss) a server restart? Or an application restart? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230293 A

Re: Sorting array

t and then arraysort should work. > > Mike T > > > On 1/19/06, Michel Deloux <[EMAIL PROTECTED]> wrote: > > > > Hi all > > > > I have an array with elements like this: > > > > > > 1 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||2

Sorting array

Hi all I have an array with elements like this: 1 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 2 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 3 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 I need to sort this elements in date format using the final v

The best CFC book is...

Hi all I'm an intermediate CF developer looking for(late 'cause CF 5 version) CFC books to learn how to work with components. Hal Helms wrote Discovering CFCs: ColdFusion MX Components. Do you recommend? Cheers MD ~| Message

isolating transaction - inside loops? or not?

Hi all, I`m developing an application with several table inserts/updates with relational data with. No problem. But I need your help about this: Please look this code: First query - father table: SET NOCOUNT ON IF

Reporting, listing with CF, Java and so on

Hi all I'm searching experiences about reporting or listing with CF. Html tables or Java reporting tools(like ReportMill)? CFReport is not available(I'm using CFMX 6.1). Give me your comment. Cheers MD ~| Logware (www.logware

Re: Creating dynamically array variables

You're right Dave. Works fine now looking like this: session.forms["#FormVariable#"][1] Cheers MD 2005/11/27, Dave Watts <[EMAIL PROTECTED]>: > > I need to create a dynamically variable inside this code: > > > > > > > > > > > > > >> ArrayAppend(session.forms.["FormVariable

Creating dynamically array variables

Hi all I need to create a dynamically variable inside this code: Using that code CF 6.1 shows me this error: A CFML variable name cannot end with a "." character. What's wrong? Cheers MD ~|

Help system in CF

Hi all I'm looking for examples, tips, tricks, tutorials, ... about how to build a dynamic help system with CF. Data will be stored in DB and users can build the menu and related subjects. Any help will be very appreciated. Cheers MD

CFC - best practice - locks and so on

Hi all I'm looking for comments about cfc instantiation and the best practices for cflock. Please look this code used in my application. When user enters in application i call a cfc. In application.cfm: ---BEGIN application.cfm--- several cfset with session variables re

newbie question - Delete session variable - how?

Hi all I have one simple form with this fields: How to kill that Session.Cart.Data and Session.Cart.GroupID? Thanx for your time Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking appl

Re: SOT - Creating dynamically name field with JS

ById('myContainer').appendChild(document.createElement('b > r')); > } > > > Add New Field > > > > Completely off the top of my head so im sure there are errors in it but > hopefully you get the idea. > > Just look up createElement() and appendChild().

SOT - Creating dynamically name field with JS

Hi all sorry by OT but I need your help in JS. I have a form with only one field. I'll like to present that field with an option for insert more fields like that and/or exclude others fields. This is my form: document.write("

Re: URL Variables

You can encrypt newurl value and decrypt it in your action page. Simple and cool. Or use session vars to store that url vars. Cheers. MD 2005/10/18, B G <[EMAIL PROTECTED]>: > Is this possible? > > I want to pass a string containing URL variables through a URL. For > example: > > www.domain.com

Re: Using cfinclude with component

YE... Extends!!! Great... Cheers MD 2005/10/18, newsight <[EMAIL PROTECTED]>: > Use instead of including a cfc into a cfc the extends param. > Than you can use all the functions of the other cfc. > > Cheers > > Artur > > > > -Original Message-

Using cfinclude with component

Hi all it's possible(recommended) to use cfinclude to include another cfc inside a cfc? I'm using this approach because that cfc is created for other team... Drawbacks? Cheers MD ~| Discover CFTicket - The leading ColdFusion H

Re: Invoking query and fails

set the query in the session scope you should do that after > the call to the function, i.e. > > > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > We endorse

Invoking query and fails

Hi all we have a form with simple fields. If session.nameofquery is not defined I invoke a cfc to get that data. Looks like: #ID_name" This is my simple function: SELECT blablabla FROM blablabla OK, OK, the good CFC practice

Re: Call cfscript inside cfc - its possible?

en as long as you've defined the function and instantiated it, you > > should be able to call it from anywhere on the page. > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --

Call cfscript inside cfc - its possible?

Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :

Re: Logging users actions - DB or Log4J?

Thanks all. Using Michael example could be more robust because I can store what I want. Using trigger this is more hard to do, right? Michael do you can share that example using asinc gateway with us? Thanks all MD 2005/9/20, Michael Dinowitz <[EMAIL PROTECTED]>: > I use an async process to log

Logging users actions - DB or Log4J?

Hi all what's the best choice to store users actions in a CF application(inserts, updates and deletes)? DB or Log4J could be resolve this? Anyone use log4j? Any approaches? Cheers MD ~| Find out how CFTicket can increase your c

Re: Converting DOCs to PDF with CF

sing cfdoc to put it into PDF > > Adam H > > On 9/2/05, Michel Deloux <[EMAIL PROTECTED]> wrote: > > > > Hi all > > > > it's possible to convert DOC and XLS files to PDF using CF MX? Aaron > > Johnson talks about Jakarta Project and POI t

Converting DOCs to PDF with CF

Hi all it's possible to convert DOC and XLS files to PDF using CF MX? Aaron Johnson talks about Jakarta Project and POI to do that. Anyone have experience about? Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk

Re: Get double quotes string inside another string

Right... Great! Great! Thanks guys(especially S. Isaac). Works fine now. Cheers MD 2005/8/30, Claude Schneegans <[EMAIL PROTECTED]>: > >>Oh I just have a habbit of using the bell character to delimit a list > > Ah ah: that rings a bell in my head! ;-) > > -- >

Re: Get double quotes string inside another string

Thanx Claude, Barney and S. Isaac. Why you're using BELL(chr(7)) char like separator for that list? Cheers MD 2005/8/30, S. Isaac Dealey <[EMAIL PROTECTED]>: > > Hi all > > > please look this var: > > > > > > How to get strings inside double quotes("RDM Testing > > string inside > > strin

Get double quotes string inside another string

Hi all please look this var: How to get strings inside double quotes("RDM Testing string inside string and "Fred")? Using GetToken don't work. Any help? Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and

Listing directories and your size

Hi all We're using this sample structure to save all files for our client: -CA(Size: 3154.44KB - Sum of all cities) ---LA(Size: 3154.44KB - Sum of Marketing and Finance) --Marketing(Size: 2490.62KB) ---2005(Size: 264.43KB) ---meetings2005.pps(23.32KB) ---

Replace accented chars with unaccented ones

Hi all. Our client is a canadian airplanes supplier with a multilanguage web site(french-Canada, english-USA, spanish-Mexico). For french and spanish site visitors users can provide info with accented chars. For USA clients users enter all char with unaccented chars because english language(keyboar

file size missing with CFFILE use

Hi all after upload files to our server 20% that files don't have file size properties saved to DB. Do you know why CFFILE file size is missing? Maybe using Java getSize directly could be resolve that? Cheers MD ~| Find out how

Re: Fusebox, Mach-II, GlueCode... the Oscar goes to...

Thanx Barney once more again for your patience in answer questions like that. MD 2005/8/11, Michel Deloux <[EMAIL PROTECTED]>: > Thanks Barney. "Percieved development speed is governed by the > methodology, not a framework.". Really great! > > MD. > >

Re: Fusebox, Mach-II, GlueCode... the Oscar goes to...

prime example is an app with flash and HTML interfaces. Same model, > entirely separate from the C and V. But the HTML C and V are bound, > and the Flash C and V are bound. It's just the nature of the beast. > > cheers, > barneyb > > On 8/11/05, Michel Deloux <[EMA

Re: Fusebox, Mach-II, GlueCode... the Oscar goes to...

Ok, ok. It depends. Other question: framework and speed dev are the same thing? Or not? I believe(my point of view) that using frameworks make development harder to code. I'm right? It's possible to separate 100% between M V C? Thanx MD 2005/8/11, Barney Boisvert <[EMAIL PROTECTED]>: > Same answ

Fusebox, Mach-II, GlueCode... the Oscar goes to...

Personal point of view: choose the best Framework for CF. Thanks MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a clien

Reading CF log files

Hi all, We're looking for all slow templates used in our application. This information is so important to know what's happening. What I need to do: - read CF log to know the name of that slow files. Using CF is possible to do that? Any tips? Cheers MD

Re: Queries Totals

so they might not work > across versions. However, each version will have a way to do what you > want, in general, because the debugging output doesn't change between > versions much. > > cheers, > barneyb > > On 8/2/05, Michel Deloux <[EMAIL PROTECTED]> wrot

Queries Totals

Hi all it's possible to know the number of queries used in a template, including ? May be when you're using CF debug option. Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application htt

OT: Formatting textarea

Hi all Sorry for OT. I am inserting a textarea into a database and when I retrieve the data I would like to show that same user formats with breaks, returns and so on. But only show inline text without formatting. Using HTMLEditFormat, ParagraphFormat, Replace(UserInputText,chr(13),"","all") and

SOT - Tape library

Hi all. Sorry for OT. I'm looking examples about how to develop a tape library with CF7/Oracle for use with backup tapes. How to manage tapes(LTO, DAT, DLT, etc) in use, tapes life time, dates, and so on. Any tips will be very very useful. Thanx MD ~

Re: Using FSO with CF

Thanx S. Isaac Dealey... Sun... i'll be there... ;-) Cheers. MD 2005/7/11, S. Isaac Dealey <[EMAIL PROTECTED]>: > > Thank you S. Isaac... I'll be change our code to > > Java.io.File > > routines... Do you have any example about? Tutorials, how > > to use that > > Java classes? > > > Thanks once

Re: Using FSO with CF

Thank you S. Isaac... I'll be change our code to Java.io.File routines... Do you have any example about? Tutorials, how to use that Java classes? Thanks once more again. MD 2005/7/7, S. Isaac Dealey <[EMAIL PROTECTED]>: > > Thanks S. Isaac Dealey > > > Yes. I need to use FSO with CF(CreateObjec

Re: Using FSO with CF

Thanks S. Isaac Dealey Yes. I need to use FSO with CF(CreateObject). But what I need to setup in our Win2003 Server. With Java I'll get best results? Thanx once more again. MD 2005/7/7, S. Isaac Dealey <[EMAIL PROTECTED]>: > > Hi all > > > I need to know about directories in our Win2003 server

Using FSO with CF

Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Thanx ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start track

Re: Delete spaces inside form fields vars

Thank you Matthew. Great great job. Works fine now... More clear and concise! 2005/6/30, Matthew Walker <[EMAIL PROTECTED]>: > You seem to be asking for all spaces in submitted values to be removed, yet > your code seems to be changing all double-spaces to single spaces. What > exactly do you wan

Delete spaces inside form fields vars

Hi all I need to delete all spaces between words inside form fields. Please look this simple code included in application.cfm: StructUpdate(form, #i#, Replace(#StructFind(form, '#i#')#,' ',' ','All')); Testing with cfabort show me all form fields without spaces. Using Len

Re: Install CF 7 with an existing MX installation

onMX/bin. Each version of > ColdFusion comes with its own wsconfig. Do not attempt to cross them. > > Alternatively, you can choose to install CFMX 7 without choosing to > configure IIS. Then CFMX 7 will run on its built-in webserver, which > will be either 8500 or 8501 in most cas

Re: Install CF 7 with an existing MX installation

Thanks Will. But how IIS will know what CF version need to run with cfm templates? 2005/6/18, Will Tomlinson <[EMAIL PROTECTED]>: > As far as I'm aware, they should run fine side by side. At least mine do with > no problem. > > Will > >

Install CF 7 with an existing MX installation

Hi all please give me your help. Today our intranet run with CF MX. All works fine. But I need to install CF 7 for our new application(cfforms and cfreport) but I need to preserve CF MX installation and applications running with. It's possible to define that? How to do if this application runs wit

Re: Appending requesttimeout to URL via application.cfm

plate that deliberately > pauses past the timeout to see if the correct error is thrown: > > > > On 6/16/05, Michel Deloux <[EMAIL PROTECTED]> wrote: > > Via application.cfm? How to ensure that config works properly? It's > > possible to dump cfsetting? >

Re: Appending requesttimeout to URL via application.cfm

Via application.cfm? How to ensure that config works properly? It's possible to dump cfsetting? Thanx James MD 2005/6/16, James Holmes <[EMAIL PROTECTED]>: > You can use cfsetting to do the same thing. > > On 6/16/05, Michel Deloux <[EMAIL PROTECTED]> wrote: >

Appending requesttimeout to URL via application.cfm

That's possible? I need to check if cgi.query_string exists in URL if yes OK; if no I need to insert that variable to all URL in our application... But... How can do that? Thanx all MD ~| Logware (www.logware.us): a new and

Re: Using XForms with CFFORM in CF7

Thanx Michael... great!!! MD 2005/5/31, Michael Dinowitz <[EMAIL PROTECTED]>: > This article was published recently in Fusion Authority > > XForms: The 'Other' New Forms in CFMX 7 > http://www.fusionauthority.com/Article.cfm/ArticleID:4430 > > - Original Me

Using XForms with CFFORM in CF7

Hi all I'm looking for examples, advantages, disadvantages, requirements about using XForms with CFFORM in CF7. CF Documentation is so small about that subject. Any topic will be very helpful. Thanx MD ~| Logware (www.logware.u

Re: Viewing files in another server/directory outside CF server

Thanx Dave yes and yes. Please look my simple script(viewfiles.cfm): IE show me a screen with save and cancel options. If user chooses Save IE prompt for viewfiles.cfm automatic file name... 2005/5/25, Dave Watts <[EMAIL PROTECTED]>: > > Using attachment or inline options IE don't show Ope

Re: Viewing files in another server/directory outside CF server

Thanx Jim Using attachment or inline options IE don't show Open option only Save and Cancel. And IE recognize original MS Word doc like "unknown". If user clicks Save needs to select a directory, name and so on... Using Mozilla works fine: I click in Open File and MS Word shows that... very cr

Re: Viewing files in another server/directory outside CF server

er <[EMAIL PROTECTED]>: > That's the proper behavior. If you want them to display in the browser, > you'll ned to change your value="attachment; " to value="inline;" > > - Original Message - > From: "Michel Deloux" <[EMAIL PROTE

Re: Viewing files in another server/directory outside CF server

Using CFCONTENT and CFHEADER with MS Word files show me a "Save/Download" screen in IE. Please look my simple code: view_files.cfm?fileX=file://CA_LA_Fresno/systems/Fresno2004_12.doc in view_files I remove file: and change / bar to \ bar and after:: Whta's happened? Thanx

Re: Viewing files in another server/directory outside CF server

Thanx Dave using CFCONTENT and CFHEADER I need to get that file right? After that I can send that file to user browser... Works with users with no server "rights"? 2005/5/24, Dave Watts <[EMAIL PROTECTED]>: > > and that your clients have network logon rights to that > > machine and read acc

Re: Viewing files in another server/directory outside CF server

Thanx Dave. and that your clients have network logon rights to that machine and read access to the share in question... it's impossible! What's UNC? How to setup? Thanx once more again. 2005/5/24, Dave Watts <[EMAIL PROTECTED]>: > > CF lives in CA_LA_WS server and all docs lives in CA_LA_

Re: Viewing files in another server/directory outside CF server

Thanx Dave, CF lives in CA_LA_WS server and all docs lives in CA_LA_Fresno server. How to show for our users docs stored in CA_LA_Fresno server with IE? It's possible? For IE I need to store my files in CF server? 2005/5/24, Dave Watts <[EMAIL PROTECTED]>: > > I'm using this script to show to t

Re: Viewing files in another server/directory outside CF server

.cfm. You have to make sure that coldfusion has access to the > folder. Sandbox security may also prevent this, but then you have to > talk to the server admin. > > > -Original Message- > > From: Michel Deloux [mailto:[EMAIL PROTECTED] > > Sent: 24 May 2005 13:

Re: Viewing files in another server/directory outside CF server

Can help us? Thanks for your time. 2005/5/23, Pascal Peters <[EMAIL PROTECTED]>: > Use cfcontent to do that > > > deletefile="No"> > > Pascal > > > -Original Message- > > From: Michel Deloux [mailto:[EMAIL PROTECTED] > > S

Viewing files in another server/directory outside CF server

Hi all I can upload files to CA_LA_Fresno server using CF user. CF user haves administrator properties. But my user don't have permission to access that server/directory. It's possible to my users see that file in your browser or Word? How? Thanks in advance

Using CFIF inside CFReport Builder

Hi all it's possible to use CFIF statements inside CF Report Builder? I need to use CFIF's for control titles and display selected informations. It's possible? How to? Thanks in advance for any help. Michel ~| Logware (www.logw

[SOT] Reports in HTML with CF

Hi all I'm need to create reports in HTML mode. But how to use pagebreaks, headers in that pagebreaks, footers, and so with HTML? Do you have any example about how to use HTML in reports with CF? Cheers Michel ~| Logware (www.l

Re: [OT] SQL Audit with CF - or maybe triggers?

Yes. Our application is done and tomorrow my boss send an email about Audit Control... ;-( Thanx 2005/5/11, Jochem van Dieten <[EMAIL PROTECTED]>: > Michel Deloux wrote: > > > > We're using SQL Server 2000. Internally? > > Doubt so, I only know of plugins for M

Re: [OT] SQL Audit with CF - or maybe triggers?

Thanks Jochem We're using SQL Server 2000. Internally? But how to pass CF parameters and save that parameters in... AuditTable? It's possible? 2005/5/11, Jochem van Dieten <[EMAIL PROTECTED]>: > Michel Deloux wrote: > > > > I'm a CF newbie and look for any

[OT] SQL Audit with CF - or maybe triggers?

Hi all I'm a CF newbie and look for any sort of help for my application. How to audit update and delete operations in our DB? I have try to use trigger but how to pass parameters for triggers like userID, fields changed, etc? Do you have any example about how to do that? Cheers Michel D