Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

How to code an SQL command

Quote Reply
How to code an SQL command
Hello!

I want to run a direct SQL command daily, and at first I thought I would set up a CRON job in conjunction with the daily build job... then I thought I might just put the SQL command right into nph-build.cgi

So...... how do I write a command in there to run an SQL command (or am I all wrong asbout doing this anyway???)

I want to run:

Update Links set Hits = '0' where CategoryID = 50

TIA!

Dave

Subject Author Views Date
Thread How to code an SQL command carfac 3590 Oct 17, 2000, 4:39 PM
Thread Re: How to code an SQL command
Stealth 3484 Oct 17, 2000, 5:49 PM
Thread Re: How to code an SQL command
carfac 3466 Oct 18, 2000, 11:12 AM
Thread Re: How to code an SQL command
carfac 3470 Oct 18, 2000, 12:14 PM
Post Re: How to code an SQL command
pugdog 3454 Oct 18, 2000, 12:58 PM