invalid CF SQL Type [CF_SQL_TEXT] error

[Nando]

Hi,

I'm getting an error when saving a record to the database:

"invalid CF SQL Type [CF_SQL_TEXT]"

on the following:

<cfqueryparam cfsqltype="cf_sql_text" value="#instance.strText#" />

This works in CFMX7 and I'm not sure if this would be a bug to report.
The database field is a text type (mySQL).

Thanks.

Nando

[Todd Rafferty]

Uh, there is no cf_sql_text:
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm

cf_sql_longvarchar

~Todd Rafferty
Railo Community Manager -- Volunteer
http://getRailo.org/

[Nando]

Years ago, when I wrote this code, cf_sql_longvarchar threw an error
in CFMX 6. cf_sql_text worked, so I used it, and it still works in
CFMX 8. Anyway, cf_sql_longvarchar works just fine in Railo, so a
search and replace did the trick. Thanks Todd.

On Aug 6, 5:04 pm, Todd Rafferty <t...@getrailo.org> wrote:
> Uh, there is no cf_sql_text:http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common...
>
> cf_sql_longvarchar
>
> ~Todd Rafferty
> Railo Community Manager -- Volunteerhttp://getRailo.org/

[Todd Rafferty]

Huh. Interesting.

~Todd Rafferty
Railo Community Manager -- Volunteer
http://getRailo.org/