By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,997 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,997 IT Pros & Developers. It's quick & easy.

changing blanks to ''

P: n/a
I have an Access table with one primary key and am attempting to update
a non-key field, using

UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';

When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key text field in the table, ie, the field gets filled with blanks
to its defined length.

The field is defined as follows, according to Access's Documenter:

fev1timemeth Text 5
AllowZeroLength: True
Attributes: Fixed Size
Collating Order: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
Data Updatable: False
DisplayControl: Text Box
GUID: Long binary data
Ordinal Position: 52
Required: False
Source Field: fev1timemeth

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You will have to replace it with the NULL() value. Blank is in fact and
ASCII value, and I think what you are looking for is to empty the field.
Then NULL() should be the value to use.

Brgds
Rolfern

"William Kossack" <ko******@njc.org> wrote in message
news:40***************@njc.org...h
I have an Access table with one primary key and am attempting to update
a non-key field, using

UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';

When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key text field in the table, ie, the field gets filled with blanks
to its defined length.

The field is defined as follows, according to Access's Documenter:

fev1timemeth Text 5
AllowZeroLength: True
Attributes: Fixed Size
Collating Order: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
Data Updatable: False
DisplayControl: Text Box
GUID: Long binary data
Ordinal Position: 52
Required: False
Source Field: fev1timemeth

Nov 12 '05 #2

P: n/a
William Kossack wrote:
I have an Access table with one primary key and am attempting to update
a non-key field, using

UPDATE tblMethtest SET fev1timemeth = '' WHERE SID = '0041R';

When I do this, the field subsequently contains 5 blanks instead of the
zero-length string I tried to put into it. This problem occurs
regardless of whether I execute the SQL from within Cold Fusion or from
within Access as an Access query. The same problem occurs on any
non-key text field in the table, ie, the field gets filled with blanks
to its defined length.

The field is defined as follows, according to Access's Documenter:

fev1timemeth Text 5
AllowZeroLength: True
Attributes: Fixed Size


You're having a giraffe aren't you?
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.