I'll check on the field types and give it a whirl.

thanks!

On Nov 19, 2008, at 12:58 PM, Cheryl Hewitt wrote:

You are using MS SQL, right? If you are using a view then you can set rights as to what the view can do (i.e. select, update, delete) for a specific user role. It is just a level of protection. Same thing goes for stored procedures.

If those are integer fields, then do this:
update Customers set zipcode= 12345 where CustomerId= 23456
(no single quotes/ticks)

HTH,

Cheryl


____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
      Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk

________________  http://www.wdvl.com  _______________________

You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016

Please include the email address which you have been contacted with.

Reply via email to