> Is there such ting as a CFSQLTYPE for an Access field?
These 2 resources are what I use to address datatype issues with CFQUERYPARAM;
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetaccess_data_types.asp
http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
--Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]
> Sent: 26 October 2004 18:22
> To: CF-Talk
> Subject: Re: cfsqltype question with Access database
>
> Pascal,
>
> You said
>
> "CF_SQL_VARCHAR wouldn't accept values greater than tha
Pascal,
You said
"CF_SQL_VARCHAR wouldn't accept values greater than that length"
Did you mean CF_SQL_LONGVARCHAR ?
I've never had trouble with the 'long' version, but then again I
haven't tried too hard to stress out an Access db with a load of text.
Maybe 2-3k tops using longvarchar.
Had ne
On Tue, 26 Oct 2004 08:45:36 +0200, Pascal Peters wrote:
> I think that depends on the version of CF you are using: CF5 =>
> LONGVARCHAR, CFMX => CLOB (but I'm not a 100% certain)
Well, I guess I'll try to start using CLOB instead of LONGVARCHAR,
then. I wonder why the latest version of HS+ doesn
> What might CF_SQL_CLOB do that CF_SQL_VARCHAR doesn't when
> addressing an Access memo field?
I don't know enough about Access to answer this, but I can take a guess. If
the length of an Access memo field is greater than 8,000 characters, then
presumably CF_SQL_VARCHAR wouldn't accept values gr
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 25, 2004 12:45 PM
Subject: RE: cfsqltype question with Access database
>> I have a tag input that needs cfsqltype for a give
I think that depends on the version of CF you are using: CF5 =>
LONGVARCHAR, CFMX => CLOB (but I'm not a 100% certain)
Pascal
> -Original Message-
> From: Scott Brady [mailto:[EMAIL PROTECTED]
> Sent: 25 October 2004 20:46
> To: CF-Talk
> Subject: Re: cfsq
On Mon, 25 Oct 2004 14:45:30 -0400, Dave Watts wrote:
> You should use CF_SQL_VARCHAR for a text field in Access. I would guess that
> you want to use CF_SQL_CLOB for a memo field.
My version of Homesite+ 5.5 doesn't list "CF_SQL_CLOB" as one of the
options. Is that undocumented? For memo fields
cf_sql_char should work.
On Mon, 25 Oct 2004 14:30:53 -0400, Jeffrey Fongemie
<[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I have a tag input that needs cfsqltype for a given field. Would be CF_SQL_VARCHAR
> or CF_SQL_NUMERIC but I'm using Access database and the field in question is just a
>
> I have a tag input that needs cfsqltype for a given field.
> Would be CF_SQL_VARCHAR or CF_SQL_NUMERIC but I'm using
> Access database and the field in question is just a simple
> text field. Is there such ting as a CFSQLTYPE for an Access
> field?
You should use CF_SQL_VARCHAR for a text f
10 matches
Mail list logo
