Data assist!!!!!!!!!!!!!!!!!!!!!

[Cologne]

please, for the next release (I red it will come), remember my wish...

to have the option to enter one or more AND in the WHERE...

like...WHERE id=1 AND product=2 AND flag=9 AND...so on so on :-)

Thanks a lot
Denis

[Ian]

Can't you already specify AND/OR with Data Assist Search in version 2.0?

I'm sure I've been using it for the last 12 months.

Or do you mean Update WHERE x AND y etc

Cheers
Ian

[Cologne]

I mean, WHERE SessionID = ID AND accessID = AC AND admin = 0

something like that.

where I can insert into the database, depending on 1, 2 or 3 reasons that must fit befor it will be inserted in the database.

[Eric Mittman]

Do you mean that I would not be able to insert into the db if I did not have these other values defined? If this is what you are referring to you can do this by applying server validations to the page. I don't think it would be appropriate to have the SQL do the validation for you. It would be better to validate all of the needed info before trying to insert any data.

[SOJO web]

I mean, WHERE SessionID = ID AND accessID = AC AND admin = 0

something like that.

where I can insert into the database, depending on 1, 2 or 3 reasons that must fit befor it will be inserted in the database.

Denis,

Why not use SecurityAssist to create access to the page. Or, if it is the case like I have on some pages where I want to only show the comment form to users that are logged in, you could establish their session user level upon user authentication and then only show the form if the session level meets the required level through the WebAssist "show region" utility. That would be the more efficient way to accomplish that.

Best Regards,

Brian