Re: Data types?

2004-11-02 Thread Jordan Michaels
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

Re: Data types?

2004-11-02 Thread Joe Rinehart
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

Re: Data types?

2004-11-02 Thread Donna French
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

RE: Data Types?

2003-07-01 Thread Bryan Love
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

Re: Data Types?

2003-07-01 Thread William Bowen
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

Re: Data Types?

2003-07-01 Thread Ben Densmore
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

Re: Data Types?

2003-07-01 Thread James Blaha
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

Re: Data Types?

2003-07-01 Thread S . Isaac Dealey
CFer’s, 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