By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,978 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,978 IT Pros & Developers. It's quick & easy.

Microsoft VBScript compilation (0x800A03EE)

P: 15
{asp code}
Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'
/web/company_ind.asp, line 35, column 37
Response.Write(objrs("investor_name")""<a href=""investor_ind.asp?investor_name="&objrs("inv estor_name")&""">"</a>"
Jan 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: 30
{asp code}
Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'
/web/company_ind.asp, line 35, column 37
Response.Write(objrs("investor_name")""<a href=""investor_ind.asp?investor_name="&objrs("inv estor_name")&""">"</a>"
hi sonasiva,

try with line in your code,

<% Response.Write(objrs("investor_name"))%><a href="investor_ind.asp?investor_name= "&objrs("investor_name")&""> "<%= objrs("investor_name")%>"</a>

and let me know if it has solved your error. Gud luck!

cheers,
jai
Jan 10 '07 #2

P: 15
Hi jai
my problem got solved i got output for that query


thankss......................

and i didnt get output for my register code
I need to write a code for register page of my website
i have written the following code,
<%
DIM strusername, strpassword, stremail
strUsername =request.form("username")
strPassword = request.form("password")
strEmail = request.form("email")


DIM my_SQL, objRS

my_sql= "SELECT username FROM User_list WHERE username='"&strusername&"'"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorType = 1
objRS.lockType = 3
objRS.Open mySQL, objConn
if objrs.EOF Then


objRS.AddNew
objRS("Username")=strUsername
objRS("Password")=strPassword
objRS("Email")=strEmail
objRS("date")=date()
objRS.Update
objRS.Close
Set objRS = Nothing
Response.Write "You have been successfully registered as: " & strUsername

ELSE

DIM X, strTempUsername, intCount, mySQL2, objRS2
DO UNTIL X=True
intCount = intCount + 1
strTempUsername = strUsername & intCount
strUsername = strTempUsername

mySQL2 = "SELECT * FROM tblMembers WHERE fUsername = ' " & strUsername & " ' "
Set objRS2 = Server.CreateObject("ADODB.Recordset")
objRS2.Open mySQL2, objConn, adOpenKeyset, adLockPessimistic, adCmdText
IF objRS2.EOF THEN
X=True
ELSE
intCount = intCount
END IF
LOOP

objRS2.Close
Set objRS2 = Nothing

Response.Write "That username has already been registered. Please click Back on your browser and try a different username. "
Response.Write "We suggest you try the below available username:</p>"
Response.Write "<b> " & strUsername2 & "</b>"
END IF
%>
problem is without checking existing username ,data are storing in database

please guide me to correct this logic ....

Regards
sona
Jan 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.