View Single Post
  #7  
Old 08-09-2007, 11:48 AM
mike mike is offline
Administrator
 
Join Date: May 2007
Posts: 288
Send a message via AIM to mike Send a message via MSN to mike Send a message via Yahoo to mike Send a message via Skype™ to mike
Smile Nope!!

Quote:
Originally Posted by sarma View Post
@mike

for add, update and delete data to database, can we use some syntax like this :

INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)

UPDATE tableName SET column_name = new_value WHERE columns1 = [FONT=verdana,geneva,lucida,'lucida grande',arial,helvetica,sans-serif]"1"[/font]

DELETE FROM tableName WHERE column1 = '1'

this syntax ussually i use for insert, update and delete with visual basic 6, but it can use for php, you can see it at
PHP MySQL Delete From

in php, can i call a mesagge box ?
like in vb6, coz i want to confirm first before delete data

thanks,
randy
No Sarma you cannot update items in your Salesforce instance performing SQL statements such as this. The best advice that I could give you is to create scripts that will download your data from Salesforce into local DB tables (I have done this for Oracle and MySQL), manipulate the data locally then use select statements to create insert, update, and upsert script back into your org's instance of salesforce. I have examples of how to create backup scripts on this site

Hope that helps

~Mike
Reply With Quote