...

View Full Version : SQL code for UPDATE in dreamweaver



fvnbab
04-09-2012, 01:57 PM
<cfquery datasource="b1008321-access">
UPDATE member
SET First Name='# Form.first_name#', Last Name='# Form.last_name#', Address='# Form.address#', Town='# Form.Town#', Date Joined='# Form.date_joined#'
WHERE memberID = #memberID#
</cfquery>
<html>
<body>
<h1>File Updated</h1></body>
</html>
this is my current code for UPDATE statement but wen i view it on the server it shows

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Plzz help?:(

myfayt
04-09-2012, 03:19 PM
Please give more information and place your code inside of code tags. Also it's best to post this in the forum that pertains to the language you are coding in.

fvnbab
04-09-2012, 03:39 PM
the aim is for the client(fictious) to update their details
so i hav created 4 cfm pages
1st page to search for a member
2nd page is the results page
3rd page to update the details for example details such as name is update
4th page finaaaly update into my database and the message should come up as "member updated" All this pages are put on the server as well.
My problems are well first of all i can only edit one client out of 10 this code is in the 2nd page and the currrent code is

<cfquery name = "Recordset1" datasource = "b1008321-access">
SELECT * FROM Member WHERE first_name LIKE '%seth%'
</cfquery>
<html>
<head><title>Search for Member</title></head>
<body bgcolor="#FFFFFF">
<table border="1">
<tr><td>Member Name</td></tr>
<cfoutput query = "Recordset1">
<tr><td><a href = "memberupdate3.cfm?memberID=#memberID#"> #first_name#</a></td></tr>
</cfoutput>
</table>
</body>
</html>
i want to be able to search for all the clients not just one
And the other problem is on the 4th page error message comes up
Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
And the code i put for tht is

<cfquery datasource="b1008321-access">
UPDATE Member
SET first name='# FORM.first_name#', last name='# FORM.last_name#', address='# FORM.address#', Town='# FORM.Town#', date joined='# FORM.date_joined#'
WHERE memberID = #memberID#
</cfquery>
<html>
<body>
<h1>File Updated</h1></body>
</html>
Thanks for the reply!



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum