You are browsing MYSQL Forum.
SEARCH YOUR SOLUTION HERE  

Error when insert to table. assist pls

i fellowed the tutorial from ADO tutiral. in one chapter it teaches how can i insert value to the table. i use the following code snippet but i got error message: 3708, can anybody assist
i have give pertask to the account so that it is leted to modify the mdatabase file.
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open "C: Inetpub wwwroot test test.mdatabase"
sql = "INSERT INTO userAccount (user, password) value ("
sql = sql & "'" & Request.Form("user")& "'"
sql = sql & ", '" & request.Form("password") & "')"
'on error message resume next
conn.Exceute sql, recaffected
if err<>0 then
response.Write("no edit pertasks ")
response.Write(err)
else
response.Write(recaffected & " recorded added")
end if
conn.close
Posted On: Monday, November 12, 2012 Total Views: 31
View Complete with Replies


Hi,

This webpage contains content related to MYSQL. If question related to " Error when insert to table. assist pls" is not helpful or you didn't find the question or answer you were looking for then you can ask a new question through contact form. Our development Team will be happy to help you. This article was posted on Monday, November 12, 2012 and having 31 views till Thursday, July 24, 2014.

Thank You


Related Messages:

Insert into syntax error message?  (17 Views)
It' mercattor again bringing a brand-new error message;
Just for a conscience cleanse: Do you see any wrong statements in this scrap of code snippet:
Code:
, if rs=Server.CreateObject("ADODB.Recordset"), conn is explaind by a .inc file, as follows::
Code:
and art_(num,author and n
View Replies !
Stored procedure error message -scalar variable  (30 Views)

I've Created a SP as given below, how can I pass the output of SP to a varaible x
dim x
dim sql
dim oRS
set sql = "exec [usp_totalusers] '" & dt1 & "','" & dt2 & "'"
oRS = databasename.Execute sql
x = oRS("total_user")
I do not see any value passed to x. What could
View Replies !
sql query error message  (18 Views)
i have a table which hold students info name STUDENTDATA I've another table named SURVEYANSWERS which holds answer from a survey the student fills out.. basically the STUDENTDATA table has a PK (which is studentid) whilst the survey SURVEYANSWERS table has a FK (which is survey table).
i have
View Replies !
Page Audit error message attaching database  (18 Views)
I've a client whose HW dealer formatted their drive to clean off a virus. Tdid not have any valid backkups of their SQL data. We have managed to excerpt the mdf and ldf files from the drive but get the error message on intends to attach the database to a reinstalled copy of MSDE: "Msg 5172 Level 16,
View Replies !
Where's my error message in this statement?  (19 Views)
SELECT table1.* table2.Name, table3.MaintenanceID FROM table1INNER JOIN table2 ON table1.MachineID = table2.ID
LEFT JOIN table3 ON table1.SheetID = table3.ID
ORDER BY table2.Name

It works just fine with out the LEFT JOIN, but as soon as I add that clause in I get the following error m
View Replies !
must use an editable query error message  (21 Views)
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an editable query.
okl common timeedit.asp line 15





Hours = Request.form("Hours")
Mins = Request.form("Mins")
Secs = request.form("Secs")



s
View Replies !
Multiple-step error message  (24 Views)
basically posted by : Robert Ramos (Robert.Ramos@DRMCI.ORG)I am just discovering ASP and I've come across an SQL server error message that I can't find to determine how can i resolve my Program. The error message is 'Microsoft OLE DB Provider for SQL Server error message 80040e21. Multiple-step OL
View Replies !
Help w SQL statement syntax error message  (13 Views)
Here's my SQL statement:
rs_totals.Source = "SELECT SUM (missed_sla_calls) as "total_calls" FROM missed_sla WHERE date_submit BETWEEN #" & request.form("from_date") & "# AND #" & request.form("to_date") & "#"
And just in case its way off here is what I am TRYING to get the sum of my missed_sla
View Replies !
Help wanted with error message '80040e57'  (25 Views)
I've the following edit. I know the error message is pertaining to fields shiftbegin and shiftend- I tested edit and it worked with out these 2 fields. Tare updating an access database with field type medium time. I've tried delimiting # and many other intends and nothing is working. Can anybody
View Replies !
Database login error message  (22 Views)
basically posted by : nick (nick@steenken.co.uk)I am a newcomer to databases but I've setup an Access database executing under IIS on my PC, and eso thing works OK. My web hosting company uses MYSQL, so I downloaded and installed MyODBC 3.51, set up my connection and more to talk to my MYSQL databas
View Replies !
error message  (13 Views)
basically posted by : dimi (dieder@pandora.be)Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DIEDERIKIUSR_DIEDERIK'.I always get this error message when i try to connect to my msql server i use the local server with sa as uid.Conn.Ac
View Replies !
Preventing error messages being presented  (16 Views)
basically posted by : Karsten (edvsk@web.de)i'm using the connection run property. If a run statement fails (i.E. stored procedure name is wrong) the error message is presented. How can I prevent this for generateing my own error message handler.
View Replies !
error message in sql  (14 Views)
basically posted by : stephen (profliz@hotmail.com)my coding:SQL1 = "SELECT m_id m_E-mail, m_subject, m_numReplies, m_entrydate FROM messages "SQL2 = SQL1 & "WHERE m_reply=-1 ORDER BY m_id DESC;"set rs = Server.CreateObject("ADODB.Recordset")connectme="DSN=feedatabaseackDSN"rs.Open SQL2,connectme --
View Replies !
Database error message trapplicationing.  (17 Views)
basically posted by : John (nozomi2310@excite.com)Does anybody have any solution how can i capture sql error message & then replace it wif the error message Created by asp so that user will know what it mean by the easy language instead of sql error message.Thanx.Your assist is applicationlaudd.
View Replies !
Distributed transaction error message  (26 Views)
basically posted by : sabu (sabu_p@usa.net) I encountered this hardy when tried to perform a spread transaction using link server. My goal was to connect 2 data base servers using TCP IP and transfer data. I was able to run single queries using "linkserver.catelog. owner.table". But this message was
View Replies !
error messages and stored procedures  (27 Views)
basically posted by : Gulliver (gulliver@vi.is)I am working with stored procedures a set. Some of the storedprocedures are usingother stored procedures. When an error message occure I wana the name of the procedure that caused the error messageto be returned with the line number where the error mess
View Replies !
Query error message  (13 Views)

I've this query and its gives me an error message saying expected end of statementwhere F Name and L Name are the names of the fields
the error message is at " "Code:
SELECT [F Name] & " " & [L Name] & [S Name] AS FullName from Students
View Replies !
Syntax error message  (8 Views)
I am trying to run a databasecc check on a database 'SHEDAT'. I've not ever done some thing like this but trying to get the syntax down.
View Replies !
Stored procedure error message -scalar variable  (15 Views)

I get this error message "Must declare the scalar variable @LoginName ".. when I try to save this stored procedure.
I do not understand what is wrong. Thank you.
Code:
Create PROCEDURE databaseo.StoredProcedure1
*
(
@LoginName nvarchar(25)
@LoginPass nvarchar(08)
View Replies !
Been awhile but HELP Microsoft VBScript runtime error message '800a01a8'  (31 Views)
I am getting a
Microsoft VBScript runtime error message '800a01a8'
Object required: "
This is the sql statement Maybe you can see what I can't
INSERT INTO Seminar ([thedate][city_state],[one],[2_or_more],[start],[end],[ce_info],[seatsavailble],[location],[seminarname],[AssociatedAppro
View Replies !