question about TV's

Hi all,
I am trying to build something for my clients web users to update and modify their user information from the main site and was looking into using TV's to accomplish this.

My question is how can I use a etomite function ($etomite->getLoginUserID() ) within a query if using @SELECT (SQL query
I would like to be able to do something like this:

@SELECT email FROM etomite_web_user_attributes WHERE id=$etomite->getLoginUserID()

does this make any sense?

Thanks in advance!

Todd

Hi,

I would use the @EVAL binding instead:



Note the changes to the SQL. Also remember to add email inside the "Field names" property.

The @EVAL binding will allow you to use php scripts inside your TVs. This way you can program your TV to display anything

Hi all,
I am trying to build something for my clients web users to update and modify their user information from the main site and was looking into using TV's to accomplish this.

My question is how can I use a etomite function ($etomite->getLoginUserID() ) within a query if using @SELECT (SQL query
I would like to be able to do something like this:

@SELECT email FROM etomite_web_user_attributes WHERE id=$etomite->getLoginUserID()

does this make any sense?

Thanks in advance!

Todd

Please share your code when you finished the hack

Thanks! i would be happy to share whatever this come out to be. it will be however most definatley a quick hack... so far I have built a couple different chunks for viewing / updating user profile information and passwords. I added a few fields to the web_user_attributes table for company name, city, state. I now have the view profile page working perfect thanks to the above post. thanks again!!

please check out http://d7942.u23.greymatterhosting.com/

login with test/wordpass and it will redirect you to my user mgmt area

you can see the view profile page is fuctioning, and i am able to populate the text boxes with the current info on the update page but I am feeling like a moron trying to figure how to link the submit button into the system to update the database without using an external php file.

if anyone can help point me in the right direction it would be awesome!

thx,

todd

Who is Hello cheryl rentschler

when I press login on your page listed above it logs me in as Hello cheryl rentschler I left the fields black to see what would happen. I thing there is a bug somewhere

Greets Dimmy

thanks good looking out, added some validation to make sure they enter a username when creating an account.