Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 INSERT INTO with WHERE clause		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

aviation_mike
Starting Member

USA
22 Posts
Posted - 20 March 2001 :  19:04:55  Show Profile  Visit aviation_mike's Homepage
Basicly, this is what I want to do:

"INSERT INTO Forum (Posts, MaxDate) VALUES ('" & strPosts & "', #" & now() & "#) WHERE ForumID=" & request("ForumID") & ""

But how do I do this because you can't have the WHERE clause, that I am aware of anyway.

Thanks for the help!

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 20 March 2001 :  19:08:27  Show Profile  Visit HuwR's Homepage
urm, you can not insert with a where clause since you are inserting a record, I presume what you want to do is UPDATE

"UPDATE FORUM SET Posts='" & strPosts & "', MaxDate=#" & now() & "# WHERE ForumID=" & request("ForumID")
Go to Top of Page

aviation_mike
Starting Member

USA
22 Posts
Posted - 21 March 2001 :  21:09:31  Show Profile  Visit aviation_mike's Homepage
hummm.......duh



www.FlightCommunity.com
The Aviation Enthusiast's Site!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07