updating with DRW...? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

brianw -> updating with DRW...? (10/22/2001 20:45:00)

hi everyone,
i have a update page working with a access db that i made with the DRW that works fine, but i would like to delete some of my entries in the database. when i try to do this it gives me a error saying i can not have a zero length string. how can i get around that?

thanks
brian




Stuey -> RE: updating with DRW...? (10/22/2001 20:58:00)

can you post what your typing into the custom box of the DRW

------------------
Stuart Steele
stuart@stuweb.co.uk
http://www.stuweb.co.uk




brianw -> RE: updating with DRW...? (10/22/2001 20:01:00)

quote:
Originally posted by Stuey:
can you post what your typing into the custom box of the DRW

update distinctrow
results
set Team_Name='::Team_Name::',Team_Name2='::Team_Name2::'
where ID=::ID::



Spooky -> RE: updating with DRW...? (10/22/2001 23:51:00)

I thought you were deleting?



brianw -> RE: updating with DRW...? (10/23/2001 20:18:00)

what i am doing is trying to learn asp by building a web site for my fantasy football league. right now i have one form where people can type in all there players and subit that, so everyone can read eachothers lineups for that week on a seperate page. both were done using FP2000 DRW. now i am trying to build a seperate page where people can change there lineups if they had made a mistake typing them in the first time of just change it the next week. Sometimes it is necessary to leave a field blank but then you get a error saying you can not have a zero length string. that is what i am trying to get around.

thanks for the help
Brian




KeithG -> RE: updating with DRW...? (10/23/2001 20:05:00)

Brianw

That error comes from the access database itself. If you go into design view of your table in access, you can change that option for that field. Look at the general tab and change "allow zero length" to yes from no.

Keith

------------------



brianw -> RE: updating with DRW...? (10/25/2001 20:11:00)

Thanks for the help. it works great now!

Brian




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125