Get column values to use in sql select statement

QuestionsGet column values to use in sql select statement
edwardw asked 11 years ago

Hi
I've gone through documentation and I don't see the answer. I have a grid with a cascading dropdown. The dependent dropdown will be populated using a sql statement. I'd like to use a value from the first dropdown and a date value from my grid to use in the sql statement. I was wondering how this is done.

Thank you

4 Answers
Abu Ghufran answered 11 years ago

To use more than one fields values in sql is currently not supported. I looks to be a genuine requirement and i'll be working on it.

edwardw answered 11 years ago

Thanks Abu
Do you think I could use the onblur event for the column then use javascript to get the values from other columns?

Abu Ghufran answered 11 years ago

Yes, onchange event will be used but it may need some customization in core lib, that might break again with the next version update. I'll be emailing you a guide where you need to change code if you wish.

edwardw answered 11 years ago

Hi Abu
Your solution worked perfectly! Thank you so much for taking time to help me.

Your Answer

16 + 7 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?