Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 7th April 2009, 08:00 PM
Sparky12 Sparky12 is offline
Member
 
Join Date: Jan 2006
Posts: 35
Default RaceCensus technical help

Hi All

Quick queries for Chrome or someone who knows their way around the RaceCensus database.

How do I search using more than one item in a field eg: If I want to search for all races run at Doomben and also at Eagle Farm what do I enter in the "Track" field?

Also keen to know how I can search for (say) all races at Doomben excluding 2yo races - ie: is there a "not equal to" sign that can be used in the database?

Thanks in advance

Sparky
Reply With Quote
  #2  
Old 10th April 2009, 01:28 AM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,362
Default

Sparky,

Sorry for the late reply, I've been battling with a health issue recently.

There are two ways to search for Doomben and Eagle Farm.

The easiest is to put B in the State box for Brisbane and this will return only Eagle Farm and Doomben tracks.

Otherwise in the track field put Doomben, then select Requests from the very top menu bar, and then Duplicate request.
Now replace Doomben with Eagle Farm on the second request and hit the search button.
This will also return all relevant records for both Doomben and Eagle Farm.

Just remember that you are dealing with multiple requests, so if you modify one page for some reason, you need to also modify the second page.

You can toggle between requests by clicking the white notepad on the left hand sidebar that has Requests under it.

There are also two ways of excluding 2yo races.

Firstly in the age field (just above the sex field), input >2 for greater than 2yo.

OR

Requests => Duplicate Request

Now input 2 in the age field and tick the Omit tickbox on the left sidemenu.

This will search for all but 2yo's.

The Omit tickbox is useful for omitting words or numbers from searches.

I hope this helps, as soon as I'm up to it, I'm going to redesign the database and write a more comprehensive help file, but this should keep you going in the meantime.

If I were a horse, I think they'd shoot me about now
__________________
RaceCensus - powerful system testing software.
Now with over 398,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 29/02/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #3  
Old 10th April 2009, 06:39 AM
Sparky12 Sparky12 is offline
Member
 
Join Date: Jan 2006
Posts: 35
Default

Many thanks thanks for this CP - much appreciated and I hope your health improves soon.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:22 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655