Dirk,
Still some questions about those null values:
- I still see that I have an error in the log4j log file, while everyting
seems to work fine. Should I worry about it ? (I changed all
uniqueidentifier to varchar's in the dbforms-config.xml
-----------
2002-06-13 21:04:06,845 ERROR dbforms.taglib.DbFormTag [
] - java.sql.SQLException: [NL-ROT-L051933]Sy
ntax error converting from a character string to uniqueidentifier.
-----------
Eddie
>From: Dirk Kraemer <[EMAIL PROTECTED]>
>To: Eddie Post <[EMAIL PROTECTED]>
>Subject: Re: [dbforms] Inserting NULL
>Date: Mon, 10 Jun 2002 13:01:25 +0200
>
>Hi Eddie!
>
>It's the 'uniqueidentifier' type that is not known to dbforms.
>Please set it to a known type. If it is alphanumeric, select
>something like 'char', if it is numeric 'integer'.
>It is not really important that dbforms knows the exact type,
>just important to know if it is numeric, alphanumeric, date etc.
>If it is a key in that table don't forget to set 'isKey' attribute.
>If it is generated by database set autoInc="true".
>
>Then restart your application and leave your JSP as it was.
>Please let me know if it works or if you need more help.
>
>Hope this helps
>
>Dirk
>
>
>
>Eddie Post wrote:
> >
> > Dirk,
> >
> > Thanks for the quick response.
> > Here is the declaration of the table. The column that gives problem is
>the
> > one with "Pdt_Tbl_Id":
> > ----------------
> > <table name="Tbl_Pdt_ProjectTableDetails">
> > <field name="Pdt_Id" fieldType="uniqueidentifier"
>size="36" isKey="true"
> > autoInc="true"/>
> > <field name="Pdt_Prj_Id" fieldType="uniqueidentifier"
>size="36"
> > sortable="true"/>
> > <field name="Pdt_Tbl_Id" fieldType="uniqueidentifier"
>size="36"
> > sortable="true"/>
> > <field name="Pdt_DeleteSequence" fieldType="smallint"
>size="5"
> > sortable="true"/>
> > <field name="Pdt_Where" fieldType="varchar" size="100"
>sortable="true"/>
> > <field name="Pdt_OrderBy" fieldType="varchar" size="50"
>sortable="true"/>
> > <field name="Pdt_RowLimit" fieldType="smallint"
>size="5"/>
> > <field name="Pdt_Source" fieldType="bit" size="1"
>sortable="true"/>
> > <field name="Pdt_Tbl_Target"
>fieldType="uniqueidentifier" size="36"
> > sortable="true"/>
> > <field name="Pdt_DateLastCopy" fieldType="datetime"
>size="23"
> > sortable="true"/>
> > </table>
> > -------------
> >
> > BTW:
> > I also tries somthing like:
> > -----
> > <db:select fieldName="Pdt_Tbl_Target"
> > customEntry="$null$,Null,uniqueidentifier">
> > -----
> > But neither dis that work.
> >
> > Thanks,
> > Eddie
> >
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -
http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
