Select statement error... 4

rjn2001 · Feb 9, 2005

Got a little something wrong with my SQL statement:

Code:

Microsoft VBScript compilation error '800a03fd' 

Expected 'Case' 

/viewjob.asp, line 10 

SELECT * FROM tblJob Where UserID = "' &UserID& '"
-------^

Code:

SELECT * FROM tblJob Where UserID = "' &UserID& '"

Richard Noon

http://www.davidmasonconsultancy.co.uk

pkailas · Feb 9, 2005

change

Code:

SELECT * FROM tblJob Where UserID = "' &UserID& '"

to

[coce]
SELECT * FROM tblJob Where UserID = '" & UserID & "'"
[/code]

FesterSXS · Feb 9, 2005

have you put your SQL string in quotes when you run it?

Show us the code where it is executed.

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

pkailas · Feb 9, 2005

ack, hate when I mispell

your query should be....

Code:

SELECT * FROM tblJob Where UserID = '" & UserID & "'"

SecondToNone · Feb 9, 2005

Try this id UserId is a numeric:

SELECT * FROM tblJob Where UserID = "&UserID

If UserId is a string then use the one suggested by pkailas

SELECT * FROM tblJob Where UserID = '" & UserID & "'"

Also i wouls suggest to wrap UserID in square braces...may be its a key word...something like this

SELECT * FROM tblJob Where [UserID] = '" & UserID & "'"

Hope this helps

-SecondToNone

ChrisHirst · Feb 9, 2005

Code:

[red]"[/red]SELECT * FROM tblJob Where UserID = "' &UserID& '"

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

rjn2001 · Feb 9, 2005

Fester: That is my entire sql statement. I take it is wrong!

Code:

<!--#include file="security.asp" -->
<%

Dim SQL
Dim UserID


UserID = Request.QueryString ("UserID")

"SELECT * FROM tblJob Where UserID = '" & UserID & "'"

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "D:/Websites/richard/admin/db/users.mdb"
Set objRs = conn.Execute(strSQL, , 1) 



'File: viewJob.asp
'Description: Authorised Page
%>

Richard Noon

http://www.davidmasonconsultancy.co.uk

ChrisHirst · Feb 9, 2005

it's more than likely to be the missing strSQL = ...

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

SecondToNone · Feb 9, 2005

strSQL= "SELECT * FROM tblJob Where UserID = '" & UserID & "'"

-SecondToNone

pkailas · Feb 9, 2005

hmm.

please do this.

Code:

UserID = Request.QueryString ("UserID")

strSql = "SELECT * FROM tblJob Where UserID = '" & UserID & "'"

pkailas · Feb 9, 2005

you may also want to try this...

Code:

UserID = Request.QueryString ("UserID")

strSQL = "SELECT * FROM tblJob Where UserID = '" & UserID & "'"

response.write strsql
response.end

rjn2001 · Feb 9, 2005

I must apologise for my stupidity.

this is the output from pkailas post:

Code:

SELECT * FROM tblJob Where UserID = ''

No user ID in there, user ID is a text field, the user can type in any userid they want

Richard Noon

http://www.davidmasonconsultancy.co.uk

pkailas · Feb 9, 2005

was there something in the UserID text box?

is the problem the fact you aren't returning a value?

if the answer is yes then try replacing

Code:

UserID = Request.QueryString ("UserID")

with

Code:

UserID = Request("UserID")

FesterSXS · Feb 9, 2005

where is the code for the link with the querystring value UserID? Maybe the querystring is spelled wrong?

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

rjn2001 · Feb 9, 2005

Hi, I cant get UserID to be returned.

This is the full code of the page, I dont know what is happening!

Code:

<!--#include file="security.asp" -->
<%

UserID =  Request.Form("UserID")


Dim SQL
Dim UserID


UserID = Request("UserID")
strSQL = "SELECT * FROM tblJob Where UserID = '" & UserID & "'"

response.write UserID
response.end

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "D:/Websites/richard/admin/db/users.mdb"
Set objRs = conn.Execute(strSQL, , 1) 



'File: viewJob.asp
'Description: Authorised Page
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr xmlns-asp="null" xmlns-shell="null"><HEAD>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="copyright" content="Copyright (C) 2005 Blue Alumni Resourcing">
<META content=en-us name=MS.LOCALE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="Blue Alumni Resourcing" name=keywords>
<link rel="stylesheet" type="text/css" href="css.css">
<META content="<%= Date() %>" name=last-updated>
<title><%= strUsername %>, User Panel</title>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" link="#3366CC" vlink="#008000" alink="#FF0000">
<%= strUsername %>
		<H1><img border="0" src="images/BARLogo.gif" width="125" height="110"> Private Page 2</H1></p>
<p align="center" style="margin-top: -1px; margin-bottom: -1px">
		&nbsp;</p>
		<table border="0" width="100%" id="table1">
			<tr>
				<td>
		<h3>Today:&nbsp;<b><%= Date() %></b> ,Welcome&nbsp;<b><%= rsCheckUser("First_Name") %>&nbsp;<%= rsCheckUser("Last_Name") %>&nbsp;(Login as: <%= strUserName %>)</b>, to 
		<%= strWebsiteName %></h3></td>
			</tr>
			<tr>
			<td>
			<BODY>
<%
If (objRs.EOF) then
%>
<P>Sorry, we do not hold any information about your previous Job history.
Else
<CENTER>
<FONT SIZE="5"><B>
Previous Job History

</B>
</FONT>
</CENTER>

<BODY>

<BR><BR>
<TABLE border=1>
<TR>
<TD>Job Start Date</TD>
<TD>Job End Date</TD>
<TD>Organisation Name</TD>
<TD>Job Title</TD>
<TD>Job Description</TD>
</TR>
<%
Do While Not (objRs.EOF)
%>
<TR>
<TD><%=objRs("JobStart")%></TD>
<TD><%=objRs("JobFinish")%></TD>
<TD><%=objRs("EmployerName")%></TD>
<TD><%=objRs("JobRole")%></TD>
<TD><%=objRs("JobDetail")%></TD>
</TR>
<%
objRs.MoveNext
Loop
%>
</TABLE>
</TABLE>
<BR>
<BR>
<A HREF="menu.asp">Return to the Main Menu</A>

			
			
			
			<tr>
				<td>
		<font face="Arial" size="2">
		<p align="center" style="margin-top: -1px; margin-bottom: -1px"><b>&nbsp;<a href="profile.asp?userid=<%=strUsername %>">View Profile</a> ||
				<a href="edit.asp?.rand=<%= Md5Hash %>">Edit Account</a> ||
				<a href="register.asp">New Sign Up</a> ||
				<a href="forgot.asp?.rand=<%= md5Hash %>">Recover Password</a> 
				|| 
		<a href="logout.asp?<%= Request.ServerVariables("QUERY_STRING")%>">Logout
		</a> </b></p>
		<p align="center" style="margin-top: -1px; margin-bottom: -1px">&nbsp;</p>
		<p>&nbsp;</p>
		<p>&nbsp;</font></td>
			</tr>
		</table>
		<!-- #include file="footer.asp" -->		
<%
End If     
objRs.Close
Set objRs=Nothing
objConn.Close
Set objConn=Nothing
%>
</body>
</html>

Richard Noon

http://www.davidmasonconsultancy.co.uk

FesterSXS · Feb 9, 2005

querystring looks ok - is strUserName appearing correctly on this page?

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

pkailas · Feb 9, 2005

should strUsername be replaced with UserID?

SecondToNone · Feb 9, 2005

if i am not wrong..you are doing this

href="profile.asp?userid=<%=strUsername %> to get the userid

use

UserID = Request.QueryString("userid")

-SecondToNone

FesterSXS · Feb 9, 2005

I think pkailas has got it. Use...

Code:

<a href="profile.asp?userid=<%=UserID%>">

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

rjn2001 · Feb 9, 2005

I cannot get any thing to load.

after following all of your advice.
What else could i try?

Richard Noon

http://www.davidmasonconsultancy.co.uk

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Select statement error... 4

Programmer

Programmer

Programmer

Programmer

Programmer

IS-IT--Management

Programmer

IS-IT--Management

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor