Re: quick SQL question for my add/edit page

2002-03-07 Thread Brian Scandale
this should move the first non-blank entry into the variable hiddenField At 01:05 PM 3/7/02 -0800, you wrote: >Hello, > >I need to add a new hidden field to my add/edit page >that will update the table when a new record it added >or updated..not sure how to write the SQL stmt to >automatical

Re: quick SQL question for my add/edit page

2002-03-07 Thread Hatton Humphrey
Amanda, Sounds more like you want to do a hidden input field with value="#left(programcode, 1)#" in it. HTH Hatton Amanda Stern wrote: > Hello, > > I need to add a new hidden field to my add/edit page > that will update the table when a new record it added > or updated..not sure how to write

quick SQL question for my add/edit page

2002-03-07 Thread Amanda Stern
Hello, I need to add a new hidden field to my add/edit page that will update the table when a new record it added or updated..not sure how to write the SQL stmt to automatically create this hidden field. The user is required to enter a 6 digit program code, which begins with a letter followed by