How to ask CF9 ORM to use CHAR(2)?

How to ask CF9 ORM to use CHAR(2)? Thanks.

This topic has been closed for replies.

Known Participant

I don't have CF9 installed at home. However, when I tried before with sqltype="char(2)", I got Export DDL exception.

I'm using MS-SQL 2005.

Inspiring

I'm using SQL Server 2008 (express ed.), but it shouldn't matter which specific version it is with this sort of thing, I would have thought?

Can you flick me the exact code that you were running which yielded that exception?

--

Adam

Known Participant

I'll have to get back to you on Monday. Thank you!

Inspiring

You should find what you need in the docs, here: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSB7BEC0B4-8096-498d-8F9B-77C88878AC6C.html

Scroll down to where it discusses the DDL properties.

--

Adam

Known Participant

thanks, but CHAR(2) does not work as sqltype. ormType always uses varchar(2).

Inspiring

Ah, OK. I have to concede I just expected the docs to be accurate in this regard; I didn't actually verify them.

Let me have a play around with some code & will come back to you shortly.

--

Adam

Sign up