Solved

DRW Query criteria statements

Posted on 2004-08-20
6
261 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
Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

 
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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

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 exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

695 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