This topic is locked

add/deleting fields in database

3/15/2005 7:14:02 PM
ASPRunnerPro General questions
D
ducmis author

I am deleting a couple of field in my database and adding some new ones. Where do I change the SQL statement to select these new fields and delete the old ones?
I also know that I need to add
if IsNumeric(strSearchFor) or IfNeedQuotes(GetFieldType("NEW FIELD"))="True" or _

strSearchOption="Contains" or strSearchOption="Starts with ..." then

strAdd = strAdd & " or lower(" & AddWrappers("NEW FIELD") & ")" & StrWhere("URL", strSearchFor, strSearchOption, "")

end if
for each of my new field in the _list page, but is there anything else I have to change. ..???

Sergey Kornilov admin 3/17/2005

SQL query can be found in gstrSQL variable in include/..._variables.asp file.
On the list page you basically need to search for the old field name and remove all code snippets that refer to this field.