Donna French wrote:
I'm trying to plug in CFQUERYPARAM after the trouble earlier. I'm
getting errors and not real sure which data types to specify for each
- or if I should try to specify at all ?
Here's my query and I'll post the actual db field types below that:
SELECT
Donna,
I don't use access, but I'd take a stab at cf_sql_bit for the
true/false and yes/no columns.
-joe
On Tue, 2 Nov 2004 14:34:08 -0600, Donna French [EMAIL PROTECTED] wrote:
I'm trying to plug in CFQUERYPARAM after the trouble earlier. I'm
getting errors and not real sure which data
cf_sql_bit works THANK YOU!
just when i was about to get the sledgehammer...
On Tue, 2 Nov 2004 15:48:29 -0500, Joe Rinehart [EMAIL PROTECTED] wrote:
Donna,
I don't use access, but I'd take a stab at cf_sql_bit for the
true/false and yes/no columns.
-joe
On Tue, 2 Nov 2004
depends entirely on what DB you are using, whether or not you want it to be
searchable, and what you want the max allowable size to be.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
text (for virtually unlimited sizes or input text, though that may be
limited by HTML form limits)
varchar (for input text limited to certain sizes)
will
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 12:54 PM
text would be the best data type to use to store info from a text area
field.
Ben
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 3:54 PM
Subject: Data Types?
CFer's,
I have users who are cutting and pasting from a
All:
Thanks for the advice!
Regards,
JB
Ben Densmore wrote:
text would be the best data type to use to store info from a text area
field.
Ben
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 3:54 PM
Subject: Data
CFers,
I have users who are cutting and pasting from a word
document into a
text area within a form. I need to insert that information
into one
field in SQL Server 7. What is the best data type to use?
Text or if you ever plan to use unicode for internationalization ntext.
s. isaac
8 matches
Mail list logo