Hey Niall!
Weird error dude! I can't see anything wrong with your code...but it IS late
here. ; >
The only thing I can think of is that for some reason the data being
returned to you is in the form of a string or something. Try this:
<@BIND NAME="local$uniqueName" bindtype="out">
And see if its outputting the proper datatype/data.
Have you tried running the stored procedure in just the SQL editor for (I'm
guessing) SQL Server ? You said it works on your dev server but not your
test server? Same datasource? Same configurations and versions for your ODBC
drivers?
These are the only things I can think of mang. Good luck and let us know
what the solution to your problem is!
Jonah Simpson
----- Original Message -----
From: "Niall Merrigan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 1:50 AM
Subject: Witango-Talk: Error: Invalid character value for cast specification
Hi folks
This error has just seemed to pop up. I copied the offending DBMS action
out to a test file in case it was an error somewhere else in the
original taf but it replicates.
TAF File: /idocs/test.taf
Position: call_spGetUniqueFilename
Class: DBMS
Error Number: 0
Description: [Microsoft][ODBC SQL Server Driver]Invalid character value
for cast specification
TAF File: /idocs/test.taf
Position: call_spGetUniqueFilename
Class: Internal
Error Number: -101
Description: General error during data source operation.
I have a Direct DBMS action which calls the following
{call spGetUniqueFileName(
<@BIND NAME=uniqueName BINDTYPE=OUT DATATYPE=INTEGER SCOPE=LOCAL>
)}
The SQL SP it calls is the following
/****** Object: Stored Procedure dbo.spGetUniqueFileName Script
Date: 30/07/2002 14:48:10 ******/
CREATE Procedure spGetUniqueFileName
@UniqueName int OUTPUT
AS
begin tran -- transaction used to ensure only one process at a time does
this
select @UniqueName = (fldFileName+1) from tblFileNameGen
update tblFileNameGen set fldFileName = @UniqueName
commit tran
return (@UniqueName)
GO
The field its reading and updating is a NON NULL field INT(4) with a
value currently of 389.
The thing it works fine on the dev server and this is the test server
that is causing the issue.
Any ideas
Thanks
Niall
********************************************************************
This message is intended only for the use of the person(s) ("the intended
recipient(s)") to whom it is addressed. It may contain information which is
privileged and confidential within the meaning of applicable law. If you
are not the intended recipient, please contact the sender as soon as
possible. The views expressed in this communication may not necessarily
be the views held by LGCSB (Local Government Computer Services Board).
Any attachments have been checked by a virus scanner and appear to be
clean.
Please ensure that you also scan all messages, as LGCSB does not accept
any liability for contamination or damage to your systems.
********************************************************************
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
