[thelist] Update Query not running

Tab Alleman talleman at RealMetros.com
Tue Jan 22 14:25:35 CST 2002


well another reason printing your sql string with the values plugged in
can be useful is that you can then copy the string from the browser and
paste it into your database's debugger and sometimes that will give you
some more clues about what's going on.

-----Original Message-----
From: Scott Brady [mailto:evolt at scottbrady.net]
Sent: Tuesday, January 22, 2002 3:08 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Update Query not running


Tab wrote:

> have you tried printing out your sql statement with the values plugged
> in before it tries to run?  sometimes you'll see typos and other
> hose-ups that way..

Well, I'm not getting any errors (if I change the query to force an
error, I
do get an error message), so I don't think there are any typos.  And, if
I
take the WHERE clause out, it works just fine (which means the meat of
the
query works).  It's just the WHERE clause isn't finding the row [yet
doing a
SELECT statement with that exact same WHERE clause does return the row]

I'm also outputting the value of #Request.user_id# and comparing it
manually
with what's in the database and it's correct.

Scott
----------------------------------------------
Scott Brady
http://www.scottbrady.net/



-- 
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 




More information about the thelist mailing list