This is my sql script: --> to_char conversion breaks the app!!! eliminating
this makes the app work ok! thk u very much!
I'm thinking about putting zetadb to a production environment in a short
time: I'll keep in touch.
alex
select
coalesce(to_char(ALBERGHI_ANAG.ID, 'FM99999999999'), '') as
"ID" <-- to_char here
,coalesce(ALBERGHI_ANAG.DENOMINAZ, '') as "DENOMINAZ"
,coalesce(ALBERGHI_ANAG.FAX, '') as "FAX"
,coalesce(ALBERGHI_ANAG.INDIRIZZO, '') as "INDIRIZZO"
,coalesce(ALBERGHI_ANAG.LOC_FRAZ, '') as "LOC_FRAZ"
,coalesce(ALBERGHI_ANAG.TELEFONO, '') as "TELEFONO"
from ALBERGHI_ANAG
<dtml-sqlgroup where>
<dtml-sqltest p_ID column=ID op=eq type=int
optional> <-- int type here
<dtml-and>
<dtml-sqltest p_DENOMINAZ column=DENOMINAZ op=eq type=nb optional>
<dtml-and>
<dtml-sqltest p_FAX column=FAX op=eq type=string optional>
<dtml-and>
<dtml-sqltest p_INDIRIZZO column=INDIRIZZO op=eq type=nb optional>
<dtml-and>
<dtml-sqltest p_LOC_FRAZ column=LOC_FRAZ op=eq type=string optional>
<dtml-and>
<dtml-sqltest p_TELEFONO column=TELEFONO op=eq type=nb optional>
<dtml-and>
<dtml-if p_search_filter_sql>
<dtml-var p_search_filter_sql>
</dtml-if>
<dtml-and>
<dtml-if p_program_filter_sql>
<dtml-var p_program_filter_sql>
</dtml-if>
<dtml-and>
<dtml-if p_where_sql>
<dtml-var p_where_sql>
</dtml-if>
</dtml-sqlgroup>
<dtml-if p_order_by>
<dtml-var p_order_by>
</dtml-if>
At 11.43 15/01/2004, santi-FB91YooCkDvQT0dZR+AlfA@xxxxxxxxxxxxxxxx wrote:
> Hello!
> First of alla thks for your great product!
> My config is :
> - zope 2.6.3
> - zetadb 0.8.3
> - mysql 4.*
>
> in my table "myTable" I have a field named ID (int, primary_key,
> autoincrement): zetadb converts the ID int value 1500 into 1,500
> (string), so when I try to browse the detail of a record it breaks
> (invalid p_Int value!). I can clean up the ID value using a simple
> script, but what's wrong with it? is it because of my config?
> Thks a lot
> Alex
It seems that zetadb is recognizing your ID field as a numeric with 3
decimals. It is estrange if you are using a int.
Could you send me your creation sql script, in order to test it and fix
the bug, please ?
Thansks for the reporting
Santi Camps
http://zetadb.sourceforge.net
-------------------------------------------------------
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fast Software Configuration Management System offering
advanced branching capabilities and atomic changes on 50+ platforms.
Free Eval! http://www.perforce.com/perforce/loadprog.html
_______________________________________________
zetadb-list mailing list
zetadb-list-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/zetadb-list
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004
|
