|
-
Oct 6th, 2002, 05:05 PM
#1
Thread Starter
Lively Member
trouble with submitting html in sql queries
I have been having trouble with submitting html code to my access database. What happends is that when I try to write to the database it ends up corrupting it. the thing is though that it doesnt always corrupt it. (by the way the error is "The search key was not found in any record.")
I was just wondering if anyone else has come up against this problem before and how they fixed it. Also if anyone has any suggestions on how i can successfully submit html code to the DB without it bringing up errors all the time.
Cheers
Last edited by Silverbug; Oct 6th, 2002 at 05:16 PM.
Silverbug,
This space intentionally has nothing but text explaining why this
space has nothing but text explaining that this space would otherwise
have been left blank, and would otherwise have been left blank.
-
Oct 7th, 2002, 02:29 AM
#2
Fanatic Member
if u r using SQL statment to insert data in a database then u get errors..
try this
rs.open "tablename",2,2
rs.addnew
aa = request.form("htmldata")
rs.update
hope u solve it now.
-
Oct 8th, 2002, 09:52 PM
#3
Thread Starter
Lively Member
Sorry could you explain this a little better, where does aa come from?
Silverbug,
This space intentionally has nothing but text explaining why this
space has nothing but text explaining that this space would otherwise
have been left blank, and would otherwise have been left blank.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote