|
| |
|
|
brianw
Posts: 40
From: little chute, wi usa
Status: offline
 |
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
Posts: 203
From: Dudley West Midlands, United Kingdom
Status: offline
|
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
Posts: 40
From: little chute, wi usa
Status: offline
|
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
Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: updating with DRW...? - 10/22/2001 23:51:00
I thought you were deleting?
| |
|
|
|
brianw
Posts: 40
From: little chute, wi usa
Status: offline
|
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
Posts: 92
From: Irving TX Irving, Texas, USA
Status: offline
|
RE: updating with DRW...? - 10/23/2001 20:05:00
BrianwThat 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
Posts: 40
From: little chute, wi usa
Status: offline
|
RE: updating with DRW...? - 10/25/2001 20:11:00
Thanks for the help. it works great now!Brian
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 