LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-b16.htm

coldfusion/6.1/htmldocs/tags-b16.htm

gana78 — 2005-01-12T00:58:46

There appears to be a bug in 6.1 with regards to returning unicode data using OUT parameters.

is not returning unicode data properly. Chinese, Russian etc show up as ???.

Exact same code works fine in our 6.0 server.

(Yes, the string format unicode option is checked on both servers for the ODBC connection).

coldfusion/6.1/htmldocs/tags-b16.htm

tanguyr — 2004-11-25T08:54:04

It should be noted that the value parameter of this tag must be a string - this is a problem when you try to pass binary data in to a stored procedure with CFSQLType="CF_SQL_BLOB". If you create a variable using and then try to pass it to a you will get an error reporting that "The value cannot be converted to a string because it is not a simple value."

coldfusion/6.1/htmldocs/tags-b16.htm

2004-10-14T11:31:49

Ditto... we also need a solution to the 'table of datatype' issue.

coldfusion/6.1/htmldocs/tags-b16.htm

rmdv — 2004-10-01T01:09:58

We have exactly the same problem, using the "TABLE OF datatype" method in our existing code. Please help!

coldfusion/6.1/htmldocs/tags-b16.htm

son42uk — 2004-09-29T07:03:11

We have stored procedures with "TABLE OF datatype" kind of output
parameters. We've been using CF 5 and used the MAXROWS attribute.
Now with CF MX, the MAXROWS attribute has been obsoleted. How can
we migrate code without having to rewrite the Stored Procedures to use
reference cursors?

coldfusion/6.1/htmldocs/tags-b16.htm

Shiny7 — 2004-08-01T09:34:17

null="Yes" is supposed to ignore the value attribute, right? Then why, when I have this:

I get the error: "Element PHOTO is undefined in ATTRIBUTES." ?

coldfusion/6.1/htmldocs/tags-b16.htm

jrunrandy — 2004-04-14T09:54:33

Try CF_SQL_VARCHAR, per http://www.blinex.com/~sam/CF_SQL_TYPES.cfm

coldfusion/6.1/htmldocs/tags-b16.htm

davidsatz — 2004-04-14T08:46:54

For SQL Server, what are you supposed to select for nvarchar columns ?

coldfusion/6.1/htmldocs/tags-b16.htm

halL — 2004-02-02T07:39:52

We have added an enhancement request (54101) for this change.

coldfusion/6.1/htmldocs/tags-b16.htm

Showfax TJ — 2004-01-30T21:07:10

This tag needs to support a default attribute, where having default="yes" will pass the string "default" as an argument to the SP. for example if in my SP I have

create proc [dbo].[sp_EchoDate]
@thedate datetime='1/1/1970'
as
print @thedate
go

and in CF I do

Doing the above only puts the value NULL as the SP arguement, and the SP will use the value NULL instead of the default. This should be fixed, as SQL 2000 allows for opting to use the default value of the arguement via use of the "default" keyword.

-Thomas Olaes
Breakdown Services
Application Developer

coldfusion/6.1/htmldocs/tags-b16.htm

isaac dealey — 2004-01-24T22:02:32

If you're using MS SQL Server you need to use cf_sql_timestamp for _all_ date, time and datetime columns and parameters. SQL Server doesn't understand any of the other date or date/time types.

coldfusion/6.1/htmldocs/tags-b16.htm

CFH4X0R — 2004-01-12T02:36:28

somebody have any problem using ??

If I use this instance:

I only recibe this error

Error Occurred While Processing Request
1

The error occurred in \\XXX.cfm: line 53

Please help!

coldfusion/6.1/htmldocs/tags-b16.htm

Rob Rusher — 2003-12-08T08:21:35

The docs state that a value of zero in the scale attribute will allow any number of decimal places. This is incorrect. Not setting the scale attribute will default to zero and limit the value passed in to an integer.

You must add a value to the scale attribute for decimal numbers.