QueryString Syntax error 1

csiwa28 · Aug 7, 2001

I'm getting this syntax error for a query string that I can't figure out why. It gives me an error at the question mark. What the asp page does is read from a database and then write the names on the page as links, and each link is supposed to pass a value. What am I doing wrong?

Response.Write "<a href = "/products/company.asp?<%="Name=" & objRec("Name&quot

%>">" & objRec("Name&quot

& "</a>" & "<BR>"

Databaseguy · Aug 7, 2001

Here's how I did it.

<%

Option Explicit

Dim cnnDB, strQuery, rsInfo

'Create an instance of the Connection object.
Set cnnDB = Server.CreateObject("ADODB.Connection&quot

'And open it.
cnnDB.Open "Test" 'Test is my ODBC DSN

'Build our SQL query string.
strQuery = "SELECT File,Namez,FileSize,LAstMod FROM tblDocumentIndex Where File Not Like 'c:\%' ORDER BY File"

'Execute the query and return a recordset.
Set rsInfo = cnnDB.Execute(strQuery)

%>

<HTML>
<HEAD>
</HEAD>
<BODY>
<BODY LINK="#0000ff" VLINK="#800080" BACKGROUND="Image3.jpg">
<CENTER><H2>
Microsoft Access Files at Tempo</H2>
<CENTER><p>
This report was created using IIS 4.0, Microsoft Access and Active Server Pages (ASP)</p>
<CENTER><p>
This report is "Live"</p>
<P><HR></P>
<BR>
<TABLE>
<TR>
<TH align="left">

File Name and Path
</TH>
<td width="15"><br></td>
<TH align="left">
File Name
</TH>
<td width="15"><br></td>
<TH align="left">
Size
</TH>
</TH>
<td width="15"><br></td>
<TH align="left">
Date Last Modified
</TH>

</TR>

<%
'Iterate through the recordset, pull
'out the required data, and insert it
'into an HTML table.
Do While Not rsInfo.EOF
%>

<TR>
<TD><A HREF=<% =rsInfo("File&quot %>><% =rsInfo("File&quot %></A></TD>
<td width="15"><br></td>
<TD><% =rsInfo("Namez&quot

%></TD>
<td width="15"><br></td>
<TD><% =formatnumber(rsInfo("FileSize&quot

/1000000,2) %></TD>
<td width="15"><br></td>
<TD><% =formatdatetime(rsInfo("LastMod&quot

,vbShortDate) %></TD>
<td width="15"><br></td>
</TR>

<%
'Move to the next record in the
'recordset
rsInfo.MoveNext

Loop

'Close the recordset.
rsInfo.Close

'And close the database connection.
cnnDB.Close
%>

</TABLE>
</CENTER>

</BODY>
</HTML>

shaddow · Aug 7, 2001

U have to put something like this
/products/company.asp?myvariable=myvalue?...

Response.Write "<a href = "/products/company.asp?Name="<%= Server.URLEncode(objRec("Name&quot

)%>">" & objRec("Name&quot

& "</a>" & "<BR>"

and use then Request.QuerryString("Name&quot

________

George

shaddow · Aug 7, 2001

sorry this should look like this...

Response.Write "<a href = "/products/company.asp?Name="& Server.URLEncode(objRec("Name&quot

)&">" & objRec("Name&quot

& "</a>" & "<BR>"
________

George

dianal · Aug 7, 2001

Hello,
I'm sure you get the error
Invalid character
/bbb.asp, line 8, column 48
because you didn't pay attention for corresponding quotes.
Also, you cannot nest <% %>

Try:
lnk = "<a href=""" & "/products/company.asp?" & "Name=" & Server.URLEncode(objRec("Name&quot

) & """>" & objRec("Name&quot

& "</a>" & "<BR>"
Response.Write lnk

"" - two times quote escapes quote and you can use it.
I put URLEncode function because in my case I had intervals(spaces) in the Name field.

D.

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!

QueryString Syntax error 1

csiwa28

Programmer

Databaseguy

MIS

shaddow

Programmer

shaddow

Programmer

dianal

Instructor

Similar threads

Part and Inventory Search

Sponsor