[thelist] Update Query not running

[Scott Brady]

Jeff wrote:

> can you paste in a reply the actual sql string being executed please?

It's kind of long, but here goes:

Here's the UPDATE query:
qryUpdateUser (Records=0, Time=20ms)
SQL = 
UPDATE
		userTbl
	SET
		email = ?,
		first_name = ?,
		last_name = ?,
		mailing_address1 = ?,
		mailing_address2 = ?,
		mailing_city = ?,
		mailing_state_id = ?,
		mailing_postal = ?,
		mailing_country_id = ?,
		phone_day = ?,
		phone_night = ?,
		billing_name = ?,
		billing_address1 = ?,
		billing_address2 = ?,
		billing_city = ?,
		billing_state_id = ?,
		billing_postal = ?,
		billing_country_id = ?,
		send_newsYN = 0,
		modified_user = ?
	WHERE
		user_id = ?

Query Parameter Value(s) -
Parameter #1 = dsbrady at scottbrady.net
Parameter #2 = Scott
Parameter #3 = Brady
Parameter #4 = 1935 Grape Ave.
Parameter #5 = Apt. 1
Parameter #6 = Boulder
Parameter #7 = 11
Parameter #8 = 80304
Parameter #9 = 1
Parameter #10 = 720-565-1838
Parameter #11 = 720-244-8420
Parameter #12 = Donald Brady
Parameter #13 = 1935 Grape Ave.
Parameter #14 = 
Parameter #15 = Boulder
Parameter #16 = 11
Parameter #17 = 80304
Parameter #18 = 1
Parameter #19 = dsbrady
Parameter #20 = 354A7537-12E0-4042-9999-68F81E059C05

And here's the SELECT query which returns values:
test (Records=1, Time=0ms)
SQL = 
SELECT *
	FROM userTbl
	WHERE
		user_id = ?

Query Parameter Value(s) -
Parameter #1 = 354A7537-12E0-4042-9999-68F81E059C05

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