ACCESS : ASP database linking assistance [B] you master, I do ASP in a similar forum to be registered and landing, published articles, but the registration total mistake, not the database is not added into the wrong [/b] Wrong suggested as follows : Web site can not be displayed Attempted to visit the website problems that can not be displayed. -------------------------------------------------------------------------------- Please try the following operations : Shoot regeneration button, or later re-examination. 127.0.0.1 opened the home page and then find out the necessary information and related links. HTTP errors 500.100 - Internal server error-ASP error Internet Information Service -------------------------------------------------------------------------------- Information technology (for support staff) Error Type : Microsoft VBScript compiler errors (0x800A0408) Void characters /biye/reg.asp, Line 24 Exec= "Insert Into zhuce (UserCount, UserPasswd, UserTele, UserEmail, UserHomp) Values ( '" +UserCount+ "', '" +UserPasswd+ "' ' "+UserTele+"', ' "+UserEmail+"', ' "+UserHomp+"') " Browser types : Mozilla/4.0 (Windows NT compatible; MSIE ∶ 400 ∶ 100 ∶ 6 Michaelis ， and SV1) Website : POST 91 warring /biye/reg.asp POST Data : UserCount=hlj&UserPasswd=123456&UserTele=6502893&UserEmail=fggj@163.com&UserHomp=www.ok.com Time : May 23, 2005, 20:15:49 Detailed information : Microsoft support My source code is as follows "%@LANGUAGE=" VBSCRIPT "CODEPAGE=" 936 "dilatation "!DOCTYPE HTML PUBLIC" -//W3C//DTD HTML 4.01 Transitional//EN "" http://www.w3.org/TR/html4/loose.dtd "" "Html> "Head are "Meta http-equiv=" Content-Type "content=" text/html; charset=gb2312 "" "Title> Untitled Document" /title> "/head> "Body> "Dim UserCount%, UserPasswd, UserTele, UserEmail, UserHomp, exec Set Conn=Server.CreateObject ( "ADODB.Connection") Conn.Open "Driver={Microsoft Access Driver (*.mdb) };dbq=" &Server.MapPath ( "ziliao.mdb") Action=trim (Request ( "action")) UserCount=trim (Request ( "UserCount")) UserPasswd=trim (Request ( "UserPasswd")) UserTele=trim (Request ( "UserTele")) UserEmail=trim (Request ( "UserEmail")) UserHomp=trim (Request ( "UserHomp")) If action= "reg" then checkpass=true If entrants (UserCount), "then one checkpass=false If entrants (UserPasswd), "then one checkpass=false If entrants (UserEmail), "then one checkpass=false Then if checkpass Exec= "Insert Into zhuce (UserCount, UserPasswd, UserTele, UserEmail, UserHomp) Values ( '" +UserCount+ "', '" +UserPasswd+ "' ' "+UserTele+"', ' "+UserEmail+"', ' "+UserHomp+"') " Conn.Execute (exec) Conn.Close Set conn = Nothing End if %> "A style='mso-footnote-id:ftn1'" http://hq.unhabitat.org/rdmu/isdr/default.asp "and" return "</a> "/body> "/html> Please educated us! Thank you, thank ;)

I suggest that you use Rs.addnew INSERT INTO customer (company name, name of contact person, the host city, telephone number) values ( 'construction company A,' 'Madaha,' 'Shantou,' 'EPI') Insert Into zhuce (UserCount, UserPasswd, UserTele, UserEmail, UserHomp) Values ( ' "+UserCount+"', ' "+UserPasswd+"' ' "+UserTele+"', ' "+UserEmail+"', ' "+UserHomp+"') " 　　 Add their counterparts! Mody look can be resolved, I resolved to issuing a message that good?

Set rs ＝ = Server.CreateObject ( "ADODB.Recordset") Rs.Open "customer" dbconnection, adOpenDynamic, 3 Rs.AddNew Rs ＝ ( "name") = CompanyName Rs ＝ ( "The name of the person") = CName Rs ＝ ( "host city") = City Rs ＝ ( "Tel") = Tel Rs.Update

In Lane, I have not seen you quoted the source code database connectivity code? For example : "!--#include file=." . /conn.asp "TOP 10

Contain themselves!

[ Closed window ]