Ir al contenido principal.
Enlaces relacionados:  Prensa  Compañía  Clientes  Contáctenos
Solsoft

Foros

Problem in data extraction


Autor Mensaje
Escrito en: 02. 02. 2005 [04:22]
shilpa_deodhar31@yahoo.com
Shilpa Deodhar
Autor del tema
registrado desde: 31.12.1969
Entradas: 0
Hi,

I m extracting data from a record in CDSISIS database
using PHP and Openisis, based on the demo code at
openisis.org. The data is extracted properly except
for some of the records.

The record has some repeatitive fields too. A sample
record can be like

91
711 ddd
100 abc
105 pqr
200 lmn
600 ukkkkkkkkkkkkkkkkvw
300 xyz
490 hhhhhhhh
710 mmmm
710 hh
710 kkk
711 ggg

suppose my record mfn=91 has the above data. Now
displaying problems are
1. contents of tag 711 shows only "ddd" and not "ggg".

2. Contents of tag 300 are displayed as "hhhhhhh"
which actually are the contents of tag 490
3. Contents of tag 490 are displayed as empty

ie it is giving problems where the tags are not in
ascending order and when repeatitive field values are
not continous,Please tell me how to solve this
problem.
Do I have to format my database in order so that tags
are stored in order and repeatitive fields together or
is there a way of solving this problem by modifying my
php code itself?

The problem occurs because on editing a value in a
record, that value is placed at the end of the record.

Please help
Shilpa




__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

------------------------------------------
Posted to Phorum via PhorumMail
Escrito en: 02. 02. 2005 [11:04]
braulio
Braulio Solano Rojas
registrado desde: 16.05.2008
Entradas: 2
Hi!

> I m extracting data from a record in CDSISIS database
> using PHP and Openisis, based on the demo code at
> openisis.org. The data is extracted properly except
> for some of the records.
>
> The record has some repeatitive fields too. A sample
> record can be like
>
> 91
> 711 ddd
> 100 abc
> 105 pqr
> 200 lmn
> 600 ukkkkkkkkkkkkkkkkvw
> 300 xyz
> 490 hhhhhhhh
> 710 mmmm
> 710 hh
> 710 kkk
> 711 ggg
>
> suppose my record mfn=91 has the above data. Now
> displaying problems are
> 1. contents of tag 711 shows only "ddd" and not "ggg".
>
> 2. Contents of tag 300 are displayed as "hhhhhhh"
> which actually are the contents of tag 490
> 3. Contents of tag 490 are displayed as empty
>
> ie it is giving problems where the tags are not in
> ascending order and when repeatitive field values are
> not continous,Please tell me how to solve this
> problem.
> Do I have to format my database in order so that tags
> are stored in order and repeatitive fields together or
> is there a way of solving this problem by modifying my
> php code itself?
>
> The problem occurs because on editing a value in a
> record, that value is placed at the end of the record.

I know there is problem with this. Are you using isis_fetch_array or
isis_fetch_flat_array? isis_fetch_array has a bug that I never fixed. If
the financing I am asking is provided I shall fix it alright.
isis_fetch_flat_array will not give you that problem.

Have you downloaded the PDF files that I presented at Trinidad?

It would be also helpful if you send code in your emails to see what you are
doing.

Best regards,

B.

------------------------------------------
Posted to Phorum via PhorumMail



¿Ha olvidado su contraseña?

Por favor introduzca su nombre de usuario o dirección de correo electrónico. Las instrucciones para restablecer la contraseña serán inmediatamente enviadas por correo electrónico.
Restablecer contraseña

Volver al formulario de inicio de sesión 


Copyright © 2003-2009, Solsoft de Costa Rica S.A.
Declaración de privacidad