If you want to update this field for all records, use this: update table set FieldName = 1 Just replace 'table' with your actualy table name, 'FieldName' with your actual field name. This will work. As far as the datatype, it depends on what values you are storing. But if it's a number, I guess a 'Number' will do. If you only want to store a 0 or 1, there is a boolean or True/False field. Mark
[EMAIL PROTECTED] wrote: Yeah i did the response.Write to the browser and i was blank. I will try the other things you suggested. WHat variable type would you suggest to hold this value? I am using access as a database. I added this field and they are all blank now as people have to login first to make a value. In access is there a way to paste a 1 into all the fields at once instead of one at a time? Usually things like this are simple but not this time. Thanks Have a nice day. ----- Original Message ----- From: "Mark E" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 07, 2004 2:07 PM Subject: Re: [AspClassicAnyQuestionIsOk] If then else block very simple? > > Try trimimg the field name/variable: > > If Trim(strLoginAmount) = "" Then > > Or > > If Len(Trim(strLoginAmount)) = 0 Then > > If neither work, response.write your values to the browser to see what > they hold. > > Mark > > [EMAIL PROTECTED] wrote: > I have a field name LoginAmount that is empty in my access DB as I added > it > way after I have 1600 plus members. I have a code block now to test if it > is > emplty and if it is then it will = 1. It is not working. > > > 'If strLoginAmount = "" Then > strLoginAmount = 1 > > 'Else > 'strLoginAmount = strLoginAmount + 1 > > 'End If > > > > I just want it to = 1 if it is emply Else will be incemented. What is the > proper syntax? > > > > Yahoo! Groups SponsorADVERTISEMENT > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Groups Links > > > > > > > > Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
