Ir al contenido principal.
Enlaces relacionados:  Press Room  Company  Clients  Contact us
Solsoft

Forum

Problem in data extraction


Author Message
Written on: 02. 02. 2005 [04:22]
shilpa_deodhar31@yahoo.com
Shilpa Deodhar
Topic creator
registered since: 31.12.1969
Posts: 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
Written on: 02. 02. 2005 [11:04]
braulio
Braulio Solano Rojas
registered since: 16.05.2008
Posts: 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



Forgot your password?

Please enter your username or email address. Instructions for resetting the password will be immediately emailed to you.
Reset Password

Return to login form 


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