Data assist!!!!!!!!!!!!!!!!!!!!!
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
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
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
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.
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.
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
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.