QUOTE(Kaybin @ 26 Aug, 2008 - 10:01 AM)
CODE
sqlcmd = "Update ProdDisplay set ProdName = '" & trim(Request.Form("ProdName")) & "', ProdPhoto = '" & ProdPhoto & "', ProdType = '" & trim(Request.Form("ProdType")) & "'"
No offense intended, but this query suggests to me that you need to read some books or tutorials on SQL. Not only is it impossible to insert new records with this code, but what you have here will actually update
every single record in the table when it is run. I can't imagine that's what you actually want.
For starters, in SQL you insert records via an INSERT query, not an UPDATE. The basic syntax is
SQL
INSERT INTO tablename (field1, field3, ...)
VALUES ('value1', 'value2', ...);
As for updates, if you want to change just a single record, you need to specify a WHERE clause in your query. Otherwise, the update will affect all records in the table. A basic example is:
SQL
UPDATE tablename SET field1 = 'value1', field2 = 'value2', ...
WHERE table_primary_key = 'primary_key_value';
26 Aug, 2008 - 07:01 AM
| 