|
 |
asp_databases thread: Update Records
Message #1 by "urmilla" <urmi_tikoo@m...> on Tue, 26 Jun 2001 10:25:15
|
|
Please explain the following error--->
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'test'.
/submitresumeedit.asp, line 186
Message #2 by "Michiel van Otegem \(lists ONLY\)" <michiel_lists@a...> on Tue, 26 Jun 2001 11:31:11 +0200
|
|
Look at your SQL statement. There is a column name that is incorrect or you
have some invalid characters before it.
If you don't see it, send the resulting SQL statement to the list.
---
Michiel van Otegem
ASP/ASP.NET/XML Teacher
off-list email: michiel@a...
ASPNL.com / IT Composer
www: http://www.aspnl.com
---
----- Original Message -----
From: "urmilla" <urmi_tikoo@m...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, June 26, 2001 10:25 AM
Subject: [asp_databases] Update Records
> Please explain the following error--->
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'test'.
>
> /submitresumeedit.asp, line 186
>
>
Message #3 by workflow <workflow@s...> on Tue, 26 Jun 2001 15:04:49 +0530
|
|
Hi,
The error may be occured when you are try to insert the Undefined
Column in the table or
the object which you R accessed that may be closed invariantly.
But
I'm not sure, Because there is no
code to view. please send the code.
ARun.
> -----Original Message-----
> From: urmilla [SMTP:urmi_tikoo@m...]
> Sent: Tuesday, June 26, 2001 3:55 PM
> To: ASP Databases
> Subject: [asp_databases] Update Records
>
> Please explain the following error--->
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'test'.
>
>
> /submitresumeedit.asp, line 186
Message #4 by Gee Vee <happygv@y...> on Tue, 26 Jun 2001 02:32:19 -0700 (PDT)
|
|
Hi Urmila,
This Occurs only when the Column name that you have
specified in the SQL statement is not present in the
table or it is mis-spelt.
Check for its spelling or its existence.
More over this info is not sufficient, So mail it in
detail, like what was the query you used and the table
name...... etc
Mail me if u need more info on this.
Regards
Vijay.G
--- urmilla <urmi_tikoo@m...> wrote:
> Please explain the following error--->
>
> Microsoft OLE DB Provider for ODBC Drivers error
> '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid column name 'test'.
>
> /submitresumeedit.asp, line 186
>
>
Message #5 by Vivekanand.S@i... on Tue, 26 Jun 2001 15:38:28 +0530
|
|
the error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
comes because the error is not due to ASP code, but in SQL .
so do one thing,try what u were doing with ASP code(like inserting,upda
ting
data in to SQL database) through SQL query Analyser itself.
The only situation where this will occur is if the column named 'test'
is
not present in ur table.
check it out.
"urmilla"
<urmi_tikoo@m... To: "ASP Databases"
ombai.com> <asp_databases@p...>
cc:
06/26/01 03:55 Subject: [asp_databases]
Update Records
PM
Please respond
to "ASP
Databases"
Please explain the following error--->
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'tes
t'.
/submitresumeedit.asp, line 186
Message #6 by "urmilla" <urmi_tikoo@m...> on Tue, 26 Jun 2001 11:49:18
|
|
Hi,
I am sending the code in this the username & action is coming from the
previous prog .
code is as follows
<%
username1=request.querystring("username")
response.write username
useraction=request("action")
set conn=server.createObject("adodb.connection")
conn.open "DRIVER={SQL Server}" &_
";Server=" & sServer & _
";UID=" & _
";PWD=" & _
";DATABASE=""
select case useraction
case "update"
username = trim(Request.Form("User"))
fname = trim(request.form("fname"))
mname = trim(request.form("mname"))
lname = trim(request.form("lname"))
address = trim(request.form("address"))
city = trim(request.form("city"))
state = trim(request.form("state"))
zip = trim(request.form("zip"))
phone = trim(request.form("phone"))
email = trim(request.form("email"))
objective = trim(request.form("objective"))
educationalqulaifications = trim(request.form("educationalqualifications"))
professionalqualifications = trim
(request.form "professionalqualifications"))
experience = trim(request.form("experience"))
salaryexpectations= trim(request.form("salaryexpectations"))
keywords = trim(request.form("keywords"))
mysql= "update resumedetails SET
fname='"&fname&"',mname='"&mname&"',lname='"&lname&"',address='"&address&"'
,city='"&city&"',state='"&state&"',zip='"&zip&"',phone='"&phone&"',email='"
&email&"',objective='"&objective&"',educationalqulaifications='"&educationa
lqulaifications&"',professionalqualifications='"&professionalqualifications
&"',experience='"&experience&"',salaryexpectations='"&salaryexpectations&"'
,keywords='"&keywords&"', where username="&username
conn.execute(mysql)
conn.close
set conn = nothing
response.redirect "rec.asp?username="&username
case "edit"
sql = "select * from resumedetails where username="&username1
set rs = conn.execute(sql)
fname = trim(rs("fname"))
mname = trim(rs("mname"))
lname = trim(rs("lname"))
address = trim(rs("address"))
city = trim(rs("city"))
zip = trim(rs("zip"))
state = trim(rs("state"))
telephone = trim(rs("telephone"))
email = trim(rs("email"))
objective = trim(rs("objective"))
educationalqualification= trim(rs("educationalqualifications"))
professionalqualification= trim(rs("professionalqualifications"))
employmenthistory = trim(rs("employmenthistory"))
experience = trim(rs("experience"))
skillset = trim(rs("keywords"))
conn.close
set conn = nothing
%>
<tr>
<td width="100%" colspan="3" valign="bottom" align="left">
<div align="center">
<center>
<table border="1" cellpadding="2" width="99%"
height="1050" bordercolor="#FFFFFF">
<tr>
<td width="100%" colspan="2" height="34" bgcolor="#0D734B">
<p align="center"><b><font size="2" face="Verdana"
color="#FFFFFF">Please
update your profile<br>
</font></b></td>
</tr>
<tr>
<td width="100%" colspan="2" height="28" bgcolor="#0D734B">
<p align="right"><font face="Verdana" size="1" color="#FFFFFF">*
Indicates compulsory
fields<br>
</font></td>
</tr>
<tr>
<td width="100%" colspan="2" height="34" bgcolor="#0D734B">
<p align="center"><font face="Verdana" size="2"
color="#FFFFFF"><b><u>Personal Details<br>
</u></b></font></td>
</tr>
<form action="submitresumeedit.asp?action=update"
method="post">
<input type="hidden" name="User" value ="<%request.querystring
("username")%>">
<tr>
<td width="41%" height="41" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Name:-</b></font>
<td width="59%" height="41" bgcolor="#0D734B">
<p align="left"><font size="2" face="Verdana"><input type="text"
name="fname" size="12" value="<%=fname%>">
<input type="text" name="mname" size="12" value="<%=mname%
>"><input type="text" name="lname" size="12" value="<%=lname%>"> <br>
<font color="#FFFFFF">
First
Name Middle
Name Last Name</font></font></p>
</td>
</tr>
<tr>
<td width="41%" height="81" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Address:-</b></font></td>
<td width="59%" height="81" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="3" name="address" cols="20"><%=address%
></textarea></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>City</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="city" size="20" value="<%=city%
>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
State:-</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="state" size="20" value="<%=state%
>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
Zip/Postal Code</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="zip" size="20" value="<%=zip%
>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Tel. No:-</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="telephone" size="20" value="<%
=phone%>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Email Address:-</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="email" size="20" value="<%=email%
>"></font></td>
</tr>
<tr>
<td width="100%" colspan="2" height="18" bgcolor="#0D734B">
<p align="center"><b><font size="2" face="Verdana"
color="#FFFFFF"><u>Resume Details</u></font></b></p>
</td>
</tr>
<tr>
<td width="41%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Objective:-</b></font></td>
<td width="59%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="4" name="objective" cols="28" </textarea><%
=objective%></textarea><%=educationalqualification%></font></td>
</tr>
<tr>
<td width="41%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
Educational Qualifications:-</b></font></td>
<td width="59%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="4" name="objective" cols="28" </textarea><%
=educationalqualification%></textarea><%=educationalqualification%
></font></td>
</tr>
<tr>
<td width="41%" height="100" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
Professional Qualifications:-</b></font></td>
<td width="59%" height="100" bgcolor="#0D734B"> <font size="2"
face="Verdana"><textarea rows="4" name="professionalqualifications"
cols="28"><%=professionalqualifications%></textarea></font></td>
</tr>
<tr>
<td width="41%" height="36" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Experience in related
fields</b></font></td>
<td width="59%" height="36" bgcolor="#0D734B"><font
face="Arial"><b><font size="-1"><input CHECKED name="Experience"
type="radio" value="Entry"></font></b><font color="#FFFFFF"><font size="2">
Entry</font><font size="-1"><b> <input
name="Experience" type="radio" value="1-2 Yrs"></b></font><font size="2">
1-2 Yrs <input name="Experience" type="radio"
value="2-4 Yrs">
2-4 Yrs <input name="Experience" type="radio" value="4-
6 Yrs">
4-6 Yrs <input name="Experience" type="radio" value="6-
8 Yrs">
6-8 Yrs <input name="Experience" type="radio"
value="8+ Yrs">
8+ Yrs</font></font></font></td>
</tr>
<tr>
<td width="41%" height="100" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF"> <b>
Employment History:-</b></font></td>
<td width="59%" height="100" bgcolor="#0D734B"> <font size="2"
face="Verdana"><textarea rows="4" name="employmenthistory" cols="28"><%
=employmenthistory%></textarea></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font face="Verdana"
size="1" color="#FFFFFF">*
</font><font face="Arial" size="-1" color="#FFFFFF"><b>Salary
Expectations</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"> <font size="2"
face="Verdana"><input type="text" name="salaryexpectations" size="20"
value="<%=salaryexpectations%>"></font></td>
</tr>
<tr>
<td width="41%" height="165" bgcolor="#0D734B"><font
color="#FFFFFF"><font size="2" face="Verdana">*</font> <font size="2"
face="Verdana"><b>Your
Skill Set:-</b></font></font></td>
<td width="59%" height="165" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="4" name="keywords" cols="25"><%=keywords%
></textarea><%=keywords%><font color="#FFFFFF"></font></font><font
face="Verdana" size="1" color="#FFFFFF">(Enter
words which best describe your skills. For example, an IT
professional may enter Java, C, Unix, Oracle,
Database Management etc. Or a Sales professional may enter Channel
Development, Concept Selling,
Institutional Sales, Sales Management, Direct Sales etc.)
</font></td>
</tr>
</center>
<tr>
<td width="41%" height="10" bgcolor="#0D734B">
<p align="right">
<input type=submit value="update"></td>
<center>
<td width="59%" height="10"
bgcolor="#0D734B"> <input type="reset"
value="Reset" name="reset"></td>
</tr>
<%end select%>
</form>
Message #7 by "urmilla" <urmi_tikoo@m...> on Tue, 26 Jun 2001 12:02:11
|
|
hi,
The column name specified is perfectly alright.i am using the follwing
query where username is coming from querystring.
sql = "select * from resumedetails where username="&username1
this i am using first to select all the table fields
Then i am giving the update statement.
For the above query it is giving me the error Invalid column name.
So can u help me
regards
Message #8 by Gee Vee <happygv@y...> on Tue, 26 Jun 2001 04:21:43 -0700 (PDT)
|
|
Hi Urmila,
if the Username is a string type(not an integer) pls
embed it with quote.
Try this and let me know if it worked.
Or try using "response.write"(comment all the
connection and execution related) line and print the
SQL statement on the browser and copy the same and
execute that query in the backend and see if it
returns error. If possible better send me the sql
query that was displayed by "response.write"......
regards
Vijay.G
Message #9 by workflow <workflow@s...> on Tue, 26 Jun 2001 17:11:18 +0530
|
|
Hi,
Here is the updated version of the code. You can use it now and try it.
<%
username1=request.querystring("username")
response.write username
useraction=request("action")
set conn=server.createObject("adodb.connection")
conn.open "DRIVER={SQL Server}" &_
";Server=" & sServer & _
";UID=" & _
";PWD=" & _
";DATABASE=""
select case useraction
case "update"
username = trim(Request.Form("User"))
fname = trim(request.form("fname"))
mname = trim(request.form("mname"))
lname = trim(request.form("lname"))
address = trim(request.form("address"))
city = trim(request.form("city"))
state = trim(request.form("state"))
zip = trim(request.form("zip"))
phone = trim(request.form("phone"))
email = trim(request.form("email"))
objective = trim(request.form("objective"))
educationalqulaifications = trim(request.form("educationalqualifications"))
professionalqualifications = trim
(request.form "professionalqualifications"))
experience = trim(request.form("experience"))
salaryexpectations= trim(request.form("salaryexpectations"))
keywords = trim(request.form("keywords"))
mysql= "update resumedetails SET
fname="%>&"'" & <%fname%>
&"',mname='"&<% mname%>
&"',lname='"& <%lname%>
&"',address='"&<%address%>
&"',city='"&<%city%>
&"',state='"&<%state%>
&"',zip='"&<%zip%>
&"',phone='"&<%phone%>
&"',email='"&<%email%>
&"',objective='"&<%objective%>
&"',educationalqulaifications='"&<%educationalqulaifications%>
&"',professionalqualifications='"&<%professionalqualifications%>
&"',experience='"&<%experience %>
&"',salaryexpectations='"&<%salaryexpectations%>
&"',keywords='"&<%keywords%>
&"', where username="&<%username%>
<%
conn.execute(mysql)
conn.close
set conn = nothing
response.redirect "rec.asp?username="&username
case "edit"
sql = "select * from resumedetails where username="&username1
set rs = conn.execute(sql)
fname = trim(rs("fname"))
mname = trim(rs("mname"))
lname = trim(rs("lname"))
address = trim(rs("address"))
city = trim(rs("city"))
zip = trim(rs("zip"))
state = trim(rs("state"))
telephone = trim(rs("telephone"))
email = trim(rs("email"))
objective = trim(rs("objective"))
educationalqualification= trim(rs("educationalqualifications"))
professionalqualification= trim(rs("professionalqualifications"))
employmenthistory = trim(rs("employmenthistory"))
experience = trim(rs("experience"))
skillset = trim(rs("keywords"))
conn.close
set conn = nothing
%>
<tr>
<td width="100%" colspan="3" valign="bottom" align="left">
<div align="center">
<center>
<table border="1" cellpadding="2" width="99%"
height="1050" bordercolor="#FFFFFF">
<tr>
<td width="100%" colspan="2" height="34" bgcolor="#0D734B">
<p align="center"><b><font size="2" face="Verdana"
color="#FFFFFF">Please
update your profile<br>
</font></b></td>
</tr>
<tr>
<td width="100%" colspan="2" height="28" bgcolor="#0D734B">
<p align="right"><font face="Verdana" size="1" color="#FFFFFF">*
Indicates compulsory
fields<br>
</font></td>
</tr>
<tr>
<td width="100%" colspan="2" height="34" bgcolor="#0D734B">
<p align="center"><font face="Verdana" size="2"
color="#FFFFFF"><b><u>Personal Details<br>
</u></b></font></td>
</tr>
<form action="submitresumeedit.asp?action=update"
method="post">
<input type="hidden" name="User" value ="<%request.querystring
("username")%>">
<tr>
<td width="41%" height="41" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Name:-</b></font>
<td width="59%" height="41" bgcolor="#0D734B">
<p align="left"><font size="2" face="Verdana"><input type="text"
name="fname" size="12" value="<%=fname%>">
<input type="text" name="mname" size="12" value="<%=mname%
>"><input type="text" name="lname" size="12" value="<%=lname%>"> <br>
<font color="#FFFFFF">
First
Name Middle
Name Last Name</font></font></p>
</td>
</tr>
<tr>
<td width="41%" height="81" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Address:-</b></font></td>
<td width="59%" height="81" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="3" name="address" cols="20"><%=address%
></textarea></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>City</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="city" size="20" value="<%=city%
>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
State:-</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="state" size="20" value="<%=state%
>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
Zip/Postal Code</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="zip" size="20" value="<%=zip%
>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Tel. No:-</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="telephone" size="20" value="<%
=phone%>"></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Email Address:-</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"><font size="2"
face="Verdana"><input type="text" name="email" size="20" value="<%=email%
>"></font></td>
</tr>
<tr>
<td width="100%" colspan="2" height="18" bgcolor="#0D734B">
<p align="center"><b><font size="2" face="Verdana"
color="#FFFFFF"><u>Resume Details</u></font></b></p>
</td>
</tr>
<tr>
<td width="41%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Objective:-</b></font></td>
<td width="59%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="4" name="objective" cols="28" </textarea><%
=objective%></textarea><%=educationalqualification%></font></td>
</tr>
<tr>
<td width="41%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
Educational Qualifications:-</b></font></td>
<td width="59%" height="113" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="4" name="objective" cols="28" </textarea><%
=educationalqualification%></textarea><%=educationalqualification%
></font></td>
</tr>
<tr>
<td width="41%" height="100" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b>
Professional Qualifications:-</b></font></td>
<td width="59%" height="100" bgcolor="#0D734B"> <font size="2"
face="Verdana"><textarea rows="4" name="professionalqualifications"
cols="28"><%=professionalqualifications%></textarea></font></td>
</tr>
<tr>
<td width="41%" height="36" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF">*<b> Experience in related
fields</b></font></td>
<td width="59%" height="36" bgcolor="#0D734B"><font
face="Arial"><b><font size="-1"><input CHECKED name="Experience"
type="radio" value="Entry"></font></b><font color="#FFFFFF"><font size="2">
Entry</font><font size="-1"><b> <input
name="Experience" type="radio" value="1-2 Yrs"></b></font><font size="2">
1-2 Yrs <input name="Experience" type="radio"
value="2-4 Yrs">
2-4 Yrs <input name="Experience" type="radio" value="4-
6 Yrs">
4-6 Yrs <input name="Experience" type="radio" value="6-
8 Yrs">
6-8 Yrs <input name="Experience" type="radio"
value="8+ Yrs">
8+ Yrs</font></font></font></td>
</tr>
<tr>
<td width="41%" height="100" bgcolor="#0D734B"><font size="2"
face="Verdana" color="#FFFFFF"> <b>
Employment History:-</b></font></td>
<td width="59%" height="100" bgcolor="#0D734B"> <font size="2"
face="Verdana"><textarea rows="4" name="employmenthistory" cols="28"><%
=employmenthistory%></textarea></font></td>
</tr>
<tr>
<td width="41%" height="25" bgcolor="#0D734B"><font face="Verdana"
size="1" color="#FFFFFF">*
</font><font face="Arial" size="-1" color="#FFFFFF"><b>Salary
Expectations</b></font></td>
<td width="59%" height="25" bgcolor="#0D734B"> <font size="2"
face="Verdana"><input type="text" name="salaryexpectations" size="20"
value="<%=salaryexpectations%>"></font></td>
</tr>
<tr>
<td width="41%" height="165" bgcolor="#0D734B"><font
color="#FFFFFF"><font size="2" face="Verdana">*</font> <font size="2"
face="Verdana"><b>Your
Skill Set:-</b></font></font></td>
<td width="59%" height="165" bgcolor="#0D734B"><font size="2"
face="Verdana"><textarea rows="4" name="keywords" cols="25"><%=keywords%
></textarea><%=keywords%><font color="#FFFFFF"></font></font><font
face="Verdana" size="1" color="#FFFFFF">(Enter
words which best describe your skills. For example, an IT
professional may enter Java, C, Unix, Oracle,
Database Management etc. Or a Sales professional may enter Channel
Development, Concept Selling,
Institutional Sales, Sales Management, Direct Sales etc.)
</font></td>
</tr>
</center>
<tr>
<td width="41%" height="10" bgcolor="#0D734B">
<p align="right">
<input type=submit value="update"></td>
<center>
<td width="59%" height="10"
bgcolor="#0D734B"> <input type="reset"
value="Reset" name="reset"></td>
</tr>
<%end select%>
</form>
All the best
Arun...
Message #10 by "urmilla" <urmi_tikoo@m...> on Tue, 26 Jun 2001 13:32:18
|
|
Hi,
Vijay
I tried it but i am getting the same error.
I commented all the statements & tried to just write the value of username
it does writ properly but when used in statement it gives me error
Regards
Urmilla
Message #11 by "urmilla" <urmi_tikoo@m...> on Tue, 26 Jun 2001 13:35:37
|
|
hi,
i used the updated code it gave me the same error
regards
urmilla
Message #12 by "Taher Moiyed" <taherm@f...> on Tue, 26 Jun 2001 13:36:34 +0100
|
|
send me your error, i might be bale to assist you...
regards
taher
-----Original Message-----
From: urmilla [mailto:urmi_tikoo@m...]
Sent: 26 June 2001 13:36
To: ASP Databases
Subject: [asp_databases] RE: Update Records
hi,
i used the updated code it gave me the same error
regards
urmilla
|
|
|
View Cart
