<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<DEFANGED_META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<DEFANGED_META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#000080 size=2><SPAN class=437390615-19092005>I'm
having a bit of trouble getting my syntax right for this SQL statement. I want
the query to read through all the cat values in the table, and enter the value
"1" in an empty column wherever the cat value is divisible by 60 with no
remainder (cat % 60 == 0). Here's what I enetered:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005> echo 'UPDATE Opil184a_ship_nav_med_smth SET
MOD_60==1 WHERE (cat%60)==0' | db.execute</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN class=437390615-19092005>I know
there has to be something wrong with that WHERE clause, but my SQL's really
bad.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN class=437390615-19092005>Any
ideas?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN class=437390615-19092005>~
Eric.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000080 size=2><SPAN
class=437390615-19092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000080 size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial
size=2>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><STRONG><FONT face=Arial color=#000080>Eric
Patton</FONT></STRONG></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Technologist,
Geo-Spatial Data Services</EM></FONT></DIV>
<DIV align=left><FONT size=2><FONT face=Arial color=#000080><EM>Geological
Survey of Canada (Atlantic)</EM></FONT></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Natural Resources
Canada</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Bedford Institute of
Oceanography</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Dartmouth, Nova
Scotia, Canada B2Y 4A2</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080
size=2><EM></EM></FONT> </DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Postal address: P.O.
Box 1006</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Courier address: 1
Challenger Drive</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080
size=2><EM></EM></FONT> </DIV>
<DIV align=left><FONT face=Arial color=#000080 size=2><EM>Telephone:
(902)426-7732</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080
size=2><EM>Facsimile: (902)426-4104</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#000080
size=2><EM>E-mail: </EM></FONT><A
href="mailto:epatton@NRCan.gc.ca"><FONT face=Arial
size=2><EM>epatton@NRCan.gc.ca</EM></FONT></A></DIV>
<DIV align=left><FONT face=Arial color=#000080
size=2><EM></EM></FONT> </DIV>
<DIV> </DIV></BODY></HTML>