close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Server validate field based value another select field

Thread began 1/09/2020 11:54 am by SCar87011738 | Last modified 1/09/2020 12:42 pm by Ray Borduin | 38 views | 1 replies |

SCar87011738

Server validate field based on value another select field

Hello all,
I have a problem with one form.
I have a select field1 that gets values from db.
Then, I have another field2 that must validate (number validation) based on the selection on the field1.

I cannot make it to work.

Here what I have done:
1. created a recordset that filters a table by form value (field1); this table contains a field containing the value that represent the max value I want to use for validation for field2; just call it value1);
2. created a number validation rule on field2; if the max value is higher than the value1 it must not pass validation.

Since I'm using DB2 I've set the max value for field2 as: $rs_myrecordset->getColumnVal("value1")

Is this right? or have I to use another syntax?

I'm sure the solution is not so far away.

TIA
tony

Sign in to reply to this post

SCar87011738

this is the second time I find the solution just after posting.
It wasn't working because I selected the wrong field as filter in the recordset.
Now it works.
Sorry.
tony

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...