Solved

DRW Query criteria statements

Posted on 2004-08-20
6
259 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
  • 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
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.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
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 insert an Iframe into WordPress. 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 : Open Page or Post…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

777 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