Using a string as an IF statement for validation....possible? 1

[treyball3]

Ok, so the subject doesn't really make sense, but I didn't know how to sum it up very well. Here's what I want to do, and hopefully its possible.

I want to be able to pull a validation rule from the DB and store it in a variable. The reason for this is because the rules could change and we don't want to have to change the code all the time to accommodate. So basically, I want to have a string set to an expression and then use that string for an IF statement, like follows...

sStringFromDB = "nCategoryID = ""1000"""

if sStringFromDB then
    'Do Something
end if

and basically what I want that to do is

if nCategoryID = 1000 then
    'Do Something
end if

Is this even possible?? and if so, how do I go about doing that??



Thanks - Todd

 

[jemminger]

is it just the int value that can change, or the name of the variable too?

if the former, couldn't you just use:

intFromDB = "1000"

if nCategoryID = intFromDB then
    'Do Something
end if

-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big

 

[treyball3]

well, the whole validation could change. I was just using a simple example. It could be anything like the following...

sStringFromDB = "(cint(sVariable) > cint(200) or cint(sVariable) < cint(100))"

sStringFromDB = "nCategoryID = ""1000"""

...and since this can change to whatever to be able to validate a field, I'm hoping I can figure something out for this.



Thanks - Todd

 

[jemminger]

check this out:

http://www.attention-to-details.com/newslog/389-eval-and-execute-commands-in-asp.asp

just beware that if any malicious code is inserted into the database, this would execute it!


-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big

 

[ChrisHirst]

dynamic form fields

for each x in request.form 
'   add in some ifs to ignore the submit buttom
' do processing     
next

where;
x = Name of form field
request.form(x) = value of field




Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[treyball3]

Thanks Jeff!

The eval() function was just what I needed!

(star for you)



Thanks - Todd