[bksvol-discuss] Re: Expansion Initiative Major Bug Fix
- From: "Jake Brownell" <jabrown@xxxxxxxxx>
- To: <bksvol-discuss@xxxxxxxxxxxxx>
- Date: Mon, 17 Apr 2006 21:22:54 -0500
Hi Amber,
Thanks for letting me know about the bug. I'm happy to report that it was
easily fixed. Detailed reasons for its existance follow. All help towards the
project is greatly appreciated.
The bug did not catch my eye when testing because I always entered the numbers
without commas. Amber's error message indicated there was a comma where there
should not have been. For instance 14,777 was the ID number, I, out of habbit
would have entered 14777. I've forced the program to treat 14,777 as a number
and it automatically removed the comma. This bug was introduced when I added
code to the page to double check that a title was not already listed in that
category. This was an attempt to automate cutting down on duplicates.
Thanks again, Amber. Everyone else let me know if you find further problems. I
checked the series add page and it didn't error out with the comma, so I left
the code alone. Other areas might be affected, just let me know.
Jake
----- Original Message -----
From: Amber Wallenstein
To: bksvol-discuss@xxxxxxxxxxxxx
Sent: Monday, April 17, 2006 7:54 PM
Subject: [bksvol-discuss] Re: Expansion Initiative Major Bug Fix
Jake:
I tried to add a title to the new category I created called Historical
Fiction and go this message.
Add Title to Category
Microsoft OLE DB Provider for ODBC Drivers
error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query
expression 'CategoryID=29 AND BKSID=14,671'.
/bks/categoryaddtitle.asp, line 74
Could you email me privately and let me know what's up, or if I'm doing
something wrong?
Thanks, I could get behind this project in a big way!
Amber
Book blog:
http://community.livejournal.com/book_cuddler/
I have accepted a seat in the House of Representatives, and thereby have
consented to my own ruin, to your ruin, and to the ruin of our children. I give
you this warning that you may prepare your mind for your fate.
John Adams
E-Mail: amber.wallens@xxxxxxxxx
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.2/314 - Release Date: 4/16/2006
Other related posts:
