within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Richard Meredith-Hardy
To: CF-Talk
Sent: Wed Feb 28 04:58:19 2007
Subject: RE: Cfstoredproc message
I suppose it's really a mssql question
I suppose it's really a mssql question of trapping the generated message(s)
and putting them in a var which can be returned to CF.
How to do it though?
There may be better alternatives but two possibilities are
- capture the warnings using java/jdbc as Dinner suggested
- create a stored
: Cfstoredproc message
Well if it is success or not then you just use the return
codes. If you want a specific user defined message you will
have to select it into a var and return it as an OUT or as a
resultset.
This e-mail is from Reed Exhibitions (Gateway House, 28 The
Quadrant, Richmond
If you use java DB stuff, I assume it would be available...
Probably not from the built in CF DB stuff tho. :-/
On 2/27/07, Richard Meredith-Hardy [EMAIL PROTECTED] wrote:
Not quite what I'm looking for, I think.
This is actually a sp which contains a RESTORE DATABASE command and I'm
I suppose it's really a mssql question of trapping the generated message(s)
and putting them in a var which can be returned to CF.
How to do it though?
-Original Message-
From: Dinner [mailto:[EMAIL PROTECTED]
Sent: 28 February 2007 00:38
To: CF-Talk
Subject: Re: Cfstoredproc
Simple question, I hope
How does one get back to CF the message a stored proc normally puts in the
messages window when you run it in SQL Server management studio or enterprise
manager?
Thanks in advance
Richard
(I've hunted around but difficult to search for the word 'message'...)
are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Richard Meredith-Hardy
To: CF-Talk
Sent: Tue Feb 27 06:45:39 2007
Subject: Cfstoredproc message
Simple question, I hope
How does one get back to CF the message a stored proc
7 matches
Mail list logo