CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Java

 Utils.getUserId(e.getPage()) in SQL Select

Print topic Send  topic

Author Message
Elmar

Posts: 17
Posted: 04/18/2006, 8:01 AM

Hi there.

IŽd like to integrate the userId of the logged in User into my SELECT Statement. Somehow this seems not as easy as I first thougt.

Expressions like:
tp_preset_elemente.trainer_id = "+Utils.getUserId( e.getPage() )+"

wonŽt work because it escapes the double slashes. Also there is no Event Object in the corresponding load method.

How do I do it? Any suggestions?

Thanks in advance,
Elmar
View profile  Send private message
LH_13

Posts: 30
Posted: 04/18/2006, 8:50 AM

Try to add where parameter.
As type specifie Expression.
As value Utils.getUserId( e.getPage() ).

If you use table SQL select field for comparing.
If custom, add to your SQL {<parameter_name>} in place where you want to see parameter's value.
_________________
Sorry my english!
View profile  Send private message
Elmar

Posts: 17
Posted: 04/18/2006, 9:19 AM

Thank you! I tried that already without success. What actually solved the problem was using the session Parameter UserId.

The Java Part seems to be a little undocumented when compared to PHP. The help file consists only of methods and no Session vars or so.


Best regards,
Elmar
View profile  Send private message
LH_13

Posts: 30
Posted: 04/19/2006, 3:30 AM

I'am sorry, but in my case its working (In JSP pattern)
Which pattern did you use?
_________________
Sorry my english!
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.