Hellu,
How do I handle a binary datatype with dbforms ?
I have a binary(8) in the database that contains a hex value. I don't really
want fill a meaning full value ith dbForms, except that I want to put a NULL
value in it.
However if I put a fieldType binary in the dbforms-config.xml dbforms
complains (with the update action):
----------
Unknown parameter datatype:1111
----------
And if I make it a varchar(40) it gives me the following error:
-----
[NL-ROT-L051933]Disallowed implicit conversion from data type nvarchar to
data type binary, table 'M2U_DataMining.dbo.Tbl_Pac_ProjectAction', column
'Pac_TimLastCopy'. Use the CONVERT function to run this query.
----
So how can I change/handle a binary value with dbForms ?
Please some help ?,
Eddie
>From: Luca Fossato <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: [dbforms] accented characters handling
>Date: Sun, 23 Jun 2002 15:58:33 +0200
>
>Sorry,
>
>this is not a DbForm problem !! ;^)
>
>Luca
>
>Luca Fossato wrote:
>
>>Hi,
>>
>>I'd like to know If there is a method to handle accented characters (�, �,
>>�, etc) in DbForms (with JSP1.1 / Servlet 2.2).
>>
>>I played with the "org.dbforms.util.MultipartRequest" class source to try
>>to retrieve and decode a request parameter value (from a multipart form)
>>according to the the locale character-set (using
>>paramPart.getStringValue(myCharcterSet) instead of
>>paramPart.getStringValue()).
>>Then I tried to force the jsp content type using (example)
>>
>>response.setContentType("text/html; charset=ISO-8859-1")
>>... or UTF-8 ...
>>
>>Nope!
>>
>>Accented characters into DbForms varchar-mapped fields are converted and
>>stored into the underlying database (Postgresql 7.2) as '?' characters.
>>(If I use a db client, I can store the accented characters correctly).
>>
>>Any clue ?
>>
>>Thank You,
>>Luca
>
>
>
>
>
>
>-------------------------------------------------------
>Sponsored by:
>ThinkGeek at http://www.ThinkGeek.com/
>_______________________________________________
>DbForms Mailing List
>
>http://www.wap-force.net/dbforms
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
