Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-02 : 11:36:40
|
Jack writes "We have a page that shows kids designs for a button contest. I have the page working fine, where if you search for the first, last, or school it returns those records that match, and fills in a 4 x 3 table (12 records) with the results. If more than 12, it pages through the recordset. (www.treesforlife.org/buttontest)
My question is how to make sure that the first 12 cells are always filled in. If the returned records only equal 3, for example, how can we add to the recordset 9 more records? I have a recordcount working, so I can see how many are returned, and can come up with a "diff" variable, equaling the number of records we need to add. We want to avoid having a single design showing, the page looks so much better all filled in.
I had thought about using a query using top n records, where n = diff. But how do I add this query to the one that displays the records returned by the search form?
We're using IIS, Access db. New to ASP but take a look at the page, you'll see I've learned plenty in just 3 weeks!
Thanks, Jack" |
|
|
|
|
|
|
|
Joining 2 queries