Click here to Skip to main content
15,896,111 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Asynchronous web search Pin
Shog915-Feb-06 8:40
sitebuilderShog915-Feb-06 8:40 
GeneralRe: Asynchronous web search Pin
sammyl3315-Feb-06 12:13
sammyl3315-Feb-06 12:13 
QuestionDetect Windows XP SP2 Pin
Chintoo72315-Feb-06 1:59
Chintoo72315-Feb-06 1:59 
AnswerRe: Detect Windows XP SP2 Pin
DJLarZ16-Feb-06 2:55
DJLarZ16-Feb-06 2:55 
Questionbeginner problem with databinding Pin
Bart Blommerde14-Feb-06 22:30
Bart Blommerde14-Feb-06 22:30 
AnswerRe: beginner problem with databinding Pin
Bart Blommerde15-Feb-06 9:47
Bart Blommerde15-Feb-06 9:47 
GeneralRe: beginner problem with databinding Pin
George L. Jackson15-Feb-06 13:19
George L. Jackson15-Feb-06 13:19 
Questionproblem in Insert Querey on ASP page Pin
Murtuza Husain Miyan Patel14-Feb-06 21:11
professionalMurtuza Husain Miyan Patel14-Feb-06 21:11 
dear friends

I have simple page for enquirey form which contains the code as below
<%
Function ChkString(string)
If string = "" Then string = " "
ChkString = Replace(string, "'", "''")
End Function

dim First_Name,Last_Name,Title,Company,Address1,CmbCountry,ZipCode,cmbEtype,EmailId,Comments,entdate
dim sql_insert

FirstName=ChkString(Request.form("First_Name"))
LastName=ChkString(Request.form("LastName"))
Title=ChkString(Request.form("Title"))
Company=ChkString(Request.form("Company"))
Address1=ChkString(Request.form("Address1"))
CmbCountry=ChkString(Request.form("CmbCountry"))
ZipCode=ChkString(Request.form("ZipCode"))
EmailId=ChkString(Request.form("EmailId"))
cmbEtype=ChkString(Request.form("cmbEtype"))
Comments=ChkString(Request.form("Comments"))
entdate=now()
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open("c:/inetpub/wwwroot/altadawi/Database/AlTadawi.mdb")
set rs = Server.CreateObject("ADODB.recordset")
rs.cursorlocation =3

sql_insert = "insert into EnqDetail (Fname, Lname, Etitle, Ecompany,Address1,Country,ZipCode,EType,emailId,EnqDet,EntryDate) values ('"
sql_insert=sql_insert & FirstName & "', '" & LastName & "', '" & Title & "', '" & Company & "', '" & Address1 & "', '" & CmbCountry & "', '" & ZipCode & "', '" & cmbEtype & "', '" & EmailId & "', '" & Comments & "','" & entdate & "')"
response.write(sql_insert)
rs.Open sql_insert, conn,1,2
rs.close
Set RS = Nothing
conn.close

%>
when I submit this page it gives me error as below

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/altadawi/EnqSubmit.asp, line 38

Please can u tell me where is the problem in my code.
Your quick response will be highly appreciated.

Thankx
Murtuza Patel
AnswerRe: problem in Insert Querey on ASP page Pin
Guffa14-Feb-06 21:57
Guffa14-Feb-06 21:57 
AnswerRe: problem in Insert Querey on ASP page Pin
George L. Jackson15-Feb-06 13:25
George L. Jackson15-Feb-06 13:25 
QuestionUPnP media server Pin
bijeesh114-Feb-06 19:55
bijeesh114-Feb-06 19:55 
QuestionScripting Languages Pin
JimmyRopes14-Feb-06 10:43
professionalJimmyRopes14-Feb-06 10:43 
AnswerRe: Scripting Languages Pin
Jeremy Thornton14-Feb-06 12:06
Jeremy Thornton14-Feb-06 12:06 
GeneralRe: Scripting Languages Pin
JimmyRopes14-Feb-06 20:44
professionalJimmyRopes14-Feb-06 20:44 
GeneralRe: Scripting Languages Pin
Stephen Hewitt16-Feb-06 18:46
Stephen Hewitt16-Feb-06 18:46 
GeneralRe: Scripting Languages Pin
Jeremy Thornton18-Feb-06 6:14
Jeremy Thornton18-Feb-06 6:14 
Questionto change email_id's Pin
vivek132314-Feb-06 9:09
vivek132314-Feb-06 9:09 
AnswerRe: to change email_id's Pin
JimmyRopes14-Feb-06 20:55
professionalJimmyRopes14-Feb-06 20:55 
QuestionGroup membership / Windows authentication question Pin
dels_cpp14-Feb-06 6:43
dels_cpp14-Feb-06 6:43 
QuestionABOUT WEBSITE Pin
vivek132314-Feb-06 1:57
vivek132314-Feb-06 1:57 
AnswerRe: ABOUT WEBSITE Pin
vivek-g15-Feb-06 0:36
vivek-g15-Feb-06 0:36 
Questionsearching word or text in web page using ASP Pin
vivek-g14-Feb-06 0:32
vivek-g14-Feb-06 0:32 
QuestionRe: searching word or text in web page using ASP Pin
CWIZO14-Feb-06 1:39
CWIZO14-Feb-06 1:39 
AnswerRe: searching word or text in web page using ASP Pin
enjoycrack14-Feb-06 19:36
enjoycrack14-Feb-06 19:36 
QuestionModal Dialog Box Pin
nokiasony13-Feb-06 22:04
nokiasony13-Feb-06 22:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.