Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL statement
Message
From
02/03/2003 18:18:51
 
 
To
23/02/2003 22:20:19
General information
Forum:
ASP.NET
Category:
Other
Title:
Miscellaneous
Thread ID:
00756842
Message ID:
00760180
Views:
13
Hi Androcles,

Here are some basic SQL Statements to get you started.
SELECT * FROM MyTable
SELECT * FROM MyTable WHERE MyID = " & Request.QueryString("ID") & "
UPDATE MyTable SET MyField = '" & Request.Form("MyFrmFld") & "' WHERE MyID = " & Request.Form("ID") & "
INSERT INTO MyTable (MyField, MyField2) Values('" & Request.Form("MyFrmFld") & "', '" & Request.Form("MyFrmFld2") & "')
DELETE * FROM MyTable WHERE MyID = " & Request.QueryString("ID") & "
Hope This Helps.

Kind Regards,
Tarran Walker
Previous
Reply
Map
View

Click here to load this message in the networking platform