How can update two tables in asp ?
It not updates the two tables at a time,
Following error message received.

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Invalid column name 'sect_area'.
/pweb/tp_drawings/dwg_edit3.asp, line 53

<%
usql1="update drawings set "
usql2="name='"& name &"',"
usql3="date_recd='"& date_recd &"',"
usql4="dtype='"& dtype &"',"
usql5="location='"& location &"' ,"
usql6="update sectors set "
usql7="name='"& name &"',"
usql8="sect_area='"& sect_area &"',"
usql9="loc_type='"& loc_type &"' where loc_type='" &loc_type& "' "


usql=usql1+usql2+usql3+usql4+usql5+squl6+usql7+usq l8+usql9

cn.execute usql // line 53 where sect_area columne name is correct

 if err.number=0 then
 Response.write("Record Edited")
 else
 Response.Write("Error found")
 end if

%>

where connection with the database is ok
Please help to solve above coding.

Mateen
[email protected]

Hi,

You need to give more information so we can where the problem lies in your code. I suggest that you print your usql statement on screen through Response.Write. This way you will be able to see if the problem is in your SQL or somewhere else.

Cheers!


Marlon Villarama
Support Team
Web Burner Hosting
[email protected]
www.webburner.com
Toll-Free: 877-535-2876

Multiple statements should be separated by a ;
so change to this

thanks