Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
server error updating access database.. WHY?
Old 08-11-2005, 12:14 PM server error updating access database.. WHY?
numbenator's Avatar
Webmaster Talker

Posts: 516
Location: London
Trades: 0
Hi all,

I am getting an error on the below :

Im a little confused as to why though. If i remove the line
rs.Fields("studentName") = request.form("studentName")
& rs.Update
then i have no error. Could someone please give me some direction.

Code:
 
<% response.Expires=0 %>
 
 
 
<!--#include file="SSI/_conn.asp"-->

<%   Dim rs, updateSQL
     Set rs = Server.CreateObject("ADODB.RecordSet")
	    updateSQL = "SELECT * FROM comments"	    
	    rs.open updateSQL, Conn
		rs.MoveFirst
			rs.Fields("studentName")  = request.form("studentName")
		rs.Update
		rs.Close   
%>
__________________

Please login or register to view this content. Registration is FREE

Last edited by numbenator; 08-11-2005 at 12:29 PM..
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
 
Register now for full access!
Old 08-11-2005, 12:54 PM
Minaki's Avatar
Defies a Status

Posts: 1,626
Location: Guildford, UK
Trades: 0
What exactly are you trying to do? What error message are you getting?
__________________
Minaki Serinde MCP
"Wow, Linux is nearly on-par with Windows ME!"

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
Minaki is offline
Reply With Quote
View Public Profile Visit Minaki's homepage!
 
Old 08-11-2005, 12:56 PM
numbenator's Avatar
Webmaster Talker

Posts: 516
Location: London
Trades: 0
I have a form from where i retrieve info.
I then check it's validity then go a a save page.
I simply wish to update the form to the database.

http://www.mastech-solutions.com/Stu...ce/collect.asp


Im not that good at asp so have a standard browser server error. Not sure how to put a proper error page in
cheers.
__________________

Please login or register to view this content. Registration is FREE
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
Old 08-11-2005, 03:26 PM
Anacrusis's Avatar
Defies a Status

Posts: 2,099
Name: Adam
Location: Colchester CT
Trades: 0
Make sure your database file and the folder it is in both have write permissions on the server.
Anacrusis is offline
Reply With Quote
View Public Profile
 
Old 08-11-2005, 03:53 PM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,528
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
You are not using an updateable locktype. The default is read only.

Code:
rs.open updateSQL, Conn, adOpenkeyset, adLockOptimistic
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 08-11-2005, 04:02 PM
numbenator's Avatar
Webmaster Talker

Posts: 516
Location: London
Trades: 0
ok. thats helped together with adding permissions to the directory. cheers
__________________

Please login or register to view this content. Registration is FREE
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
Old 08-12-2005, 04:48 AM
Minaki's Avatar
Defies a Status

Posts: 1,626
Location: Guildford, UK
Trades: 0
Quote:
Im not that good at asp so have a standard browser server error. Not sure how to put a proper error page in
It could be the way your browser is set up. Go to Tools - Options, go to the Advanced tab, and make sure 'Show Friendly HTTP Error Messages' is not checked.
__________________
Minaki Serinde MCP
"Wow, Linux is nearly on-par with Windows ME!"

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
Minaki is offline
Reply With Quote
View Public Profile Visit Minaki's homepage!
 
Old 08-12-2005, 05:57 AM
numbenator's Avatar
Webmaster Talker

Posts: 516
Location: London
Trades: 0
yeah have that flag set ok. Im actually reading up on proper error catching now. Figured that would
help lol.
cheers for allyour help. Always appreciated.
Steve
__________________

Please login or register to view this content. Registration is FREE
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
Reply     « Reply to server error updating access database.. WHY?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.56536 seconds with 12 queries