Classic ASP DatabasesDiscuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
Hey, I have been trying to figure this out for about a day now. And to let you know, I've already googled it. So this is what I'm trying to do...
I have been trying to Select a certain amount of data from my Database.. but I want it to expand the search for my record rather than narrow it..
rs.open "SELECT * from users WHERE toid="¤tID&" and fromid="&CurrentID,Db1,3,3
This narrows the search so that it only selects the records that have toid and fromid = Currentid. This is the problem. I want it to select all the records that have fromid = currentid, and select all the records that have toid = Currentid.