?
Solved

DRW Query criteria statements

Posted on 2004-08-20
6
Medium Priority
?
263 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 2000 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
Suggested Courses

762 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