i included just a snippet of code to make it simple. its from an
application i need to build that automatically converts a table into xml.
i need to build the bind_column syntax dynamically because i dont know 'a
priori' how many fields there are in a table. i have a routine that
creates an array with the fields. now knowing that i have n fields i can
build a bind for n fields for futher use in a select * statement.
if this helps...
so .... why does it not work -- any ideas?
<quote who="Brian Raven">
> Mario Sanchez <> wrote:
>> hello
>>
>> the following statement works perfectly:
>>
>> $sth->bind_columns(\$f1data, \$f2data, \$f3data);
>>
>> however, if i do this
>>
>> $bind = "bind_columns(" . "\\" . '$f1data, ' . "\\" . '$f2data, ' .
>> "\\" . '$f3data)';
>> $sth->$bind;
>>
>> when i run the script i get ...
>> Can't locate object method "bind_columns(\$f1data, \$f2data,
>> \$f3data)" via package "DBI::st" at 2makexml.pl line 54.
>>
>> any suggestions????
>
> Yes. Don't do that.
>
> Seriously though, what's wrong with the statement that works perfectly.
> I find it hard to imagine what you are trying to accomplish that makes
> you want to try that. Perhaps you could explain.
>
> HTH
>
> --
> Brian Raven
>
>
>
> =================================
> Atos Euronext Market Solutions Disclaimer
> =================================
> The information contained in this e-mail is confidential and solely for
> the intended addressee(s). Unauthorised reproduction, disclosure,
> modification, and/or distribution of this email may be unlawful.
> If you have received this email in error, please notify the sender
> immediately and delete it from your system. The views expressed in this
> message do not necessarily reflect those of Atos Euronext Market
> Solutions.
>
> L'information contenue dans cet e-mail est confidentielle et uniquement
> destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee.
> Toute copie, publication ou diffusion de cet email est interdite. Si cet
> e-mail vous parvient par erreur, nous vous prions de bien vouloir prevenir
> l'expediteur immediatement et d'effacer le e-mail et annexes jointes de
> votre systeme. Le contenu de ce message electronique ne represente pas
> necessairement la position ou le point de vue d'Atos Euronext Market
> Solutions.
>
>
> _______________________________________________
> ActivePerl mailing list
> [email protected]
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
>
--
Mario R. Sanchez, Ph.D.
High Performance Database Research Center
NASA Regional Application Center
Florida International University
11200 SW 8th ST
Mail Stop ECS 243c
Miami, FL 33199
U.S.A.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
