Re: Cfstoredproc message

2007-02-28 Thread Robertson-Ravo, Neil (RX)
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

Re: Cfstoredproc message

2007-02-28 Thread Janet MacKay
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

RE: Cfstoredproc message

2007-02-27 Thread Richard Meredith-Hardy
: 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

Re: Cfstoredproc message

2007-02-27 Thread Dinner
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

RE: Cfstoredproc message

2007-02-27 Thread Richard Meredith-Hardy
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

Re: Cfstoredproc message

2007-02-26 Thread Robertson-Ravo, Neil (RX)
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, Surrey, TW9 1DN, United