not a problem

Dann Thombs (Dann - 11/1/2004 1:47:26 PM)
------------------------------------------------------------

In case you haven't visited the Collections of wishlist sections recently, I've added a 'need level' on the wishlist of High/Medium/Low/Minimal, and a quality level on the collections page of Mint with Box/Mint without Box/Excellent/Good/Fair/Poor/Unusable.

So go flesh it out.

Dann Thombs (Dann - 3/1/2005 11:00:37 AM)
------------------------------------------------------------

Hmm, I'm having some serious problems with the collection section. I've just been to add my new Juliets to the list and (this also happens with editing) I get an ASP (500) error. It still seems to add to the list but just generates an error whilst submitting the form. Also I went in to edit what I wrote (this has happened before) and when I submitted the form I got both the error and *poof* the item has vanished from my list.

Help!

Ed Roff (Synergy - 3/1/2005 6:25:55 PM)
------------------------------------------------------------

Can you post the error. There should be a reason about half way down the page along with an error line number. I've just added/changed and deleted a test item and it worked, so let me know.

Dann Thombs (Dann - 3/1/2005 2:12:26 PM)
------------------------------------------------------------

******************

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
MicrosoftODBC Microsoft Access Driver Syntax error in UPDATE statement.
/oakley/collection_Put.asp, line 214

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; DigExt; .NET CLR 1.1.4322)


Page:
POST 126 bytes to /oakley/collection_Put.asp

POST Data:
Mode=Add&ID=&UserID=Synergy&model=test&color=test&family=Jacket&serial=&cost=0&quantity=1&quality=3&photo=&active=Yes&comment=


Time:
Tuesday, March 01, 2005, 3:18:42 PM

******************

Ed Roff (Synergy - 3/1/2005 8:19:44 PM)
------------------------------------------------------------

Cool, should be fixed now. Problem had to do with the totaling of the Glasses and Watches. If you had no glasses, or no watches, it died since 'null' isn't a number. If it were smart it would just make it zero, but I guess that would make too much sense.

Dann Thombs (Dann - 3/1/2005 3:37:30 PM)
------------------------------------------------------------

Dann,
Excellent addition to the collections page with the quality level icons,I was going to suggest something like this to you as well!
I nearly feel embarrassed about how many Mint in box pairs I have........



Lee Silver (banarno - 3/1/2005 9:35:46 PM)
------------------------------------------------------------

Nah, you should be proud.

Dann Thombs (Dann - 3/1/2005 4:37:23 PM)
------------------------------------------------------------

Okay, thanks for fixing that, but I still cannot edit; there's no "finish edit" button so I press enter on one of the edit boxes, the form submits and it's gone from my collection. :(

Ed Roff (Synergy - 3/1/2005 11:06:01 PM)
------------------------------------------------------------

this may sound like a dumb question but if we have worn them are they still counted as mint in box?
cos ive worn all mine but i take such good care of them they dont have any marks or anything so you cant tell.

Alexis Watkins (LEX7 - 3/2/2005 12:14:57 AM)
------------------------------------------------------------

Yeah that should be fine as long as they're spotless.

Ed: no finish button? It should be the same form as if you are adding on, just the button says 'change' instead of 'add'.

Dann Thombs (Dann - 3/1/2005 7:46:30 PM)
------------------------------------------------------------

Dann, I don't see 'unusable' in the dropdown menu. Am I missing something? Unfortunately there are a couple items in my collection that need to be classified that way.

Ed Chiu (eddyc - 3/2/2005 9:20:40 AM)
------------------------------------------------------------

I'll check

Dann Thombs (Dann - 3/2/2005 10:12:21 AM)
------------------------------------------------------------

Stupid me. I copied the code from the wishlist, so all the variables were still named 'need' rather than 'quality'. Fixed now.

Dann Thombs (Dann - 3/2/2005 10:15:35 AM)
------------------------------------------------------------

Ah, got it now Dann. I hadn't realised clicking the link took you to the edit page (assumed it linked to the Glasses section) and was using the trashcan icon (duuuh...) as it seemed to take you to the edit page (obviously submitting the form deletes the item). Would it be possible to make a seperate delete page with just a delete confirmation to eliminate confusion between that and the edit page?

Ed Roff (Synergy - 3/2/2005 5:42:16 PM)
------------------------------------------------------------

Yeah, I suppose that would make more sense.

Dann Thombs (Dann - 3/2/2005 12:55:27 PM)
------------------------------------------------------------