PHP MapScript queryByAttributes Issue

[Ian Tidy]

Thanks for the help.
 
I have found the problem.  For some reason (which I am about to look
into) the tables have different projections.  I found this when I was
looking in to your suggestions.

Cheers Ian 
______________________
Ian Tidy
GIS Analyst / Developer
Works Asset Department
Napier City Council
mailto:iant at napier.govt.nz
http://www.napier.govt.nz <http://www.napier.govt.nz/>  |
http://maps.napier.govt.nz <http://maps.napier.govt.nz/>  

 

________________________________

From: Delfos, Jacob [mailto:Jacob.Delfos at maunsell.com] 
Sent: Wednesday, 9 January 2008 12:44 p.m.
To: Ian Tidy; MAPSERVER-USERS at LISTS.UMN.EDU
Subject: RE: [UMN_MAPSERVER-USERS] PHP MapScript queryByAttributes Issue


Hi Ian,
 
It's a long shot, but have you checked whether your attribute names (not
just the values) are in upper/lowercase? Because attribute names are
case sensitive.
What does your php log say? Because if you do a search, and it does not
find matching values (as opposed to something else being wrong), it will
report a warning in your php log. If this is what it says, then you will
at least have narrowed it down. But it may give a different error. You
must configure php to display warnings, though.
 
regards,
 
Jacob
 
 


________________________________

	From: UMN MapServer Users List
[mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Ian Tidy
	Sent: 9 January 2008 08:11
	To: MAPSERVER-USERS at LISTS.UMN.EDU
	Subject: [UMN_MAPSERVER-USERS] PHP MapScript queryByAttributes
Issue
	
	

	Hi All, 

	I am running MapServer 4.10 and am having a problem with a
query. 

	My query code is: 
	        $qstring = "/^$street.*/"; 
	        $oLayer = $map->getlayerbyname("smartworx"); 
	        $oLayer->set("status", MS_ON); 
	        @$oLayer->queryByAttributes('STNAME', $qstring,
MS_MULTIPLE); 

	And this fails, but when I run the same code using a different
table it works: 
	        $qstring = "/^$street.*/"; 
	        $oLayer = $map->getlayerbyname("crs_road_centreline"); 
	        $oLayer->set("status", MS_ON); 
	        @$oLayer->queryByAttributes('ROAD_LABEL', $qstring,
MS_MULTIPLE); 

	Now I know the obvious answer is that the item I am searching
for doesn't exist in my table, but I have checked and it does exist.
The only difference between the two (2) shape files is that
crs_road_centreline is a LINE table and smartworx is a POINT table and
have slightly different structures.

	crs_road_centreline is the road centreline network 
	smartworx is a address point file. 

	Any Ideas??? 

	Cheers Ian 
	______________________
	Ian Tidy
	GIS Analyst / Developer
	Works Asset Department
	Napier City Council
	Hastings St, Private Bag 6010, Napier, New Zealand
	Phone +64-6-835-7579 Ext. 8115
	Fax +64-6-834-4195
	mailto:iant at napier.govt.nz <mailto:iant at napier.govt.nz> 
	http://www.napier.govt.nz <http://www.napier.govt.nz>  |
http://maps.napier.govt.nz <http://maps.napier.govt.nz>  



________________________________

	This e-mail message has been scanned for Viruses and Content and
cleared by MailMarshal 
________________________________

	
######################################################################
	Attention: 
	This e-mail message and accompanying data may contain
information that
	is confidential and subject to legal privilege. Any information
	provided is given in good faith. However unless specifically
stated to
	the contrary, Napier City Council accepts no liability for the
	content of this e-mail or for the consequences of any action
taken on
	the basis of the information provided, unless that information
is
	subsequently confirmed in writing. If you are not the intended
recipient,
	you are notified that any use, dissemination, distribution or
copying
	of this message or data is prohibited. If you received this
e-mail
	message in error, please notify us immediately and erase all
copies
	of this message and attachments. Thank you. 

________________________________

This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal 
________________________________

Scanned by Bizo EmailFilter
<http://www.bizoservices.com/services/email_filter.html>  
This email and any attachments are intended solely for the named
recipient and are confidential. The copying or distribution of them or
any information they contain by anyone other than the named recipient is
prohibited. If you have received this document in error, please notify
the sender and delete all copies from your computer system and destroy
all hard copies. It is the recipient's responsibility to check this
email and any attachments to this email for viruses before use.

#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################

######################################################################
Attention: 
This e-mail message and accompanying data may contain information that
is confidential and subject to legal privilege. Any information
provided is given in good faith. However unless specifically stated to
the contrary, Napier City Council accepts no liability for the
content of this e-mail or for the consequences of any action taken on
the basis of the information provided, unless that information is
subsequently confirmed in writing. If you are not the intended recipient,
you are notified that any use, dissemination, distribution or copying
of this message or data is prohibited. If you received this e-mail
message in error, please notify us immediately and erase all copies
of this message and attachments. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080109/f01b684f/attachment.html