Solved

DRW Query criteria statements

Posted on 2004-08-20
6
260 Views
Last Modified: 2013-12-24
Hi,
I have a database with a field with 6 drop down tournaments as follows:

Grades 6,7 & 8 Girls
Grades 5-6 Boys
Grades 7-8 Boys
Junior Varsity Boys
Junior Varsity Girls
High School Girls
Varsity Boys

I'm trying to use DRW to create an ASP file that will allow users to get a list of teams entered by groups as above, but no matter how I enter the criteria statement in the DRW it comes back with no entries where I know they exist, an error about incorrect characters (, etc),

I'm trying to enter where field = tourney.. and these are the values above.

How do I do this???

0
Comment
Question by:flwebster
[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
  • 3
  • 3
6 Comments
 

Author Comment

by:flwebster
ID: 11857488
Sorry, fp2003
0
 
LVL 12

Accepted Solution

by:
rcmb earned 500 total points
ID: 11860625
I need a little more information to get this to work.

You desire to show all teams in the tournament for Grades 6, 7 & 8 Girls. How is the information stored in the database?

Give me the field names in your database and the name of the dropdown box.

RCMB
0
 

Author Comment

by:flwebster
ID: 11860998
name of drop down field is tourney

Choices are
Grades 7-8 Boys
Junior Varsity Boys
Varsity Boys
Grades 6,7 & 8 Girls  (or Grades 6,7 & 8 Girls)
Junior Varsity Girls
Varsity Girls

I'm not sure how the Grades 6... choice is actually written.

What I'm tryingt to do is to create a page ASP report page that shows the teams entered in each tournament. So, for instance, the Varsity Girls page would show only the varsity girls teams, the Grades 7-8 Boys page would show only those teams and so on..

Thanks,

Marty
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 12

Expert Comment

by:rcmb
ID: 11861848
What you are going to need to do is in your query do something like

SELECT * From TableName WHERE AgeGroup LIKE '::Tourney::%'
(note: AgeGroup would be your database field that contains the age groups you identified in your drop down.)

This should give you what you are looking for.

There may be a problem with the way the information is stored. When you put commas and & symbols sometimes the SQL query tries to read them as part of the statment. Is there anyway you can change the data to read something like:

Grades 7-8 Boys
Junior Varsity Boys
Varsity Boys
Grades 6-8 Girls
Junior Varsity Girls
Varsity Girls

This would help any issues with the query and the above example I gave you would work fine.

RCMB
0
 

Author Comment

by:flwebster
ID: 11862035
thank you for the quick and precise solution.
0
 
LVL 12

Expert Comment

by:rcmb
ID: 11862051
Glad we got it fixed for you.

Have a great evening.

RCMB
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

730 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