[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ASP results link to editing page

Posted on 2004-10-10
5
Medium Priority
?
185 Views
Last Modified: 2010-03-17
ok have page that does ASP query to datasource and brings back results but having problem putting link into results which takes viewer to an edit page


<!-- Code -->
 <%
strSearch = Request.Form("search")

If strSearch <> "" Then
      Dim strConnect, SQL
      Dim RS
      strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("ITtracking.mdb") & ";"

      SQL = "SELECT * FROM ITTable WHERE INSTR(ITTable.ITNumber,'" & strSearch & "')"

      Set RS = Server.CreateObject("Adodb.Recordset") 'Used for pulling main categories from DB
      RS.Open SQL,strConnect
         ' here's where our custom error goes:
     If Rs.BOF then
        ' no records found so redirect to custom error page.
         response.redirect "sorry.htm"
        End If
      Do Until RS.EOF
            
########################################################
Need the results to this line (ITNumber) to be a link to an edit page I have another page that produces list of all results in database then links to edit page works fine need "ITNumber to be link to same page with item numer ID which was brought back from database
########################################################
                  Response.Write RS("ITNumber") & "<BR><BR>"
                  Response.Write RS("DateArrived") & "<BR><BR>"
                  Response.Write RS("RefNumber") & "<BR><BR>"
                  Response.Write RS("Quantity") & "<BR><BR>"
                  Response.Write RS("PUDate") & "<BR><BR>"
                  Response.Write RS("PUNumber") & "<BR><BR>"
                  Response.Write RS("ID") & "<BR><BR>"
                  Response.Write RS("OriginalIT") & "<BR><BR>"
                  Response.Write RS("ValidatedIT") & "<BR><BR>"
                  Response.Write RS("CustomsRelease") & "<BR><BR>"
                  Response.Write RS("ShippingTally") & "<BR><BR>"
                  Response.Write RS("NVOCCRelease") & "<BR><BR>"
                  Response.Write RS("PaperlessIT") & "<BR><BR>"
            'End If

            RS.MoveNext
      LOOP
      
      RS.Close
      
End If

%>
0
Comment
Question by:Wiredwizard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 53

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 12310728
In your page above, you need to create hyperlinks in order to enable you to click it and go to the edit page. something like:

...
<a href="editdetail.asp?id=<%=Rs("ID")%>">Edit</a>
...

or what's your exact problem?
0
 

Author Comment

by:Wiredwizard
ID: 12335128
tried that got this error


Microsoft VBScript compilation error '800a0400'

Expected statement

/securefiles/edit.asp, line 77

<a href="editdetail.asp?id=<%=Rs("ID")
^
0
 
LVL 53

Expert Comment

by:Ryan Chong
ID: 12335788
Let me know what's the full script for line 77? Are you missing to put a "%>" there??
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question