Posted by smaran on Mar 07, 2011; 2:19pm
URL: https://discuss.orbeon.com/p-param-type-input-name-instance-tp3338458p3339067.html

Thanks a lot.can you explain me how the flow is going on like from PFC how the crud.xpl is called.
Regards,
Smaran

-----Original Message-----
From: Florian Schmitt [mailto:[hidden email]]
Sent: Monday, March 07, 2011 7:33 PM
To: [hidden email]
Subject: [ops-users] Re: RE: Re: RE: Re: RE: Re: RE: Re: <p:param type="input" name="instance"/>

Smaran,

> Actually I want  user-id also to be inserted in database. Like I need  
> to add column  userID.Is that possible. If so please tell me where I  
> need to modify  the code exactly.so that we can go ahead and close  
> this poc before we  purchase your PE of orbeon

to guard against misunderstandings, i can't speak for orbeon, i'm just a simple user trying to assist you. So i can't promise that it's possible to implement any feature.

Regarding the user ID: the easier part would be to modify the persistence layer (adapting the db scheme and the crud.xpl). In crud.xpl, the sql commands are created based on literals and modified using XSLT. Basically, crud.xpl calls the SQL processor (1), offering a very flexible way to connect OF with SQL databases. To make an additional db column accesible, you just could insert another sql:param element in lines 356-372 of crud.xpl.

But i can't tell you how to handle that data in FormBuilder / FormRunner, because i don't use FB/FR in my own XForms application, so i don't know where the data structures are defined inside  FB/FR.

HTH
florian

(1) http://www.orbeon.com/orbeon/doc/processors-sql



Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws