I would have to say CF_SQL_VARCHAR. (CHAR doesn't exist in Access) I am not sure that it will work if the field is a CHAR in the other platforms.
-----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: dinsdag 5 maart 2002 8:00 To: CF-Talk Subject: CFQUERYPARAM: a good generic CHAR type? As a follow-on to yesterday's post, where I asked about a generic numeric cfsqltype, (and I've since confirmed that CF_SQL_NUMERIC works on mySQL) I need to find the same thing for a text value: ideally something that will work on Access, SQL Server, mySQL and Oracle. Looks like my choices are CF_SQL_VARCHAR or CF_SQL_CHAR. Anyone familiar with these and the above platforms? Thx, --Matt-- ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
