| Author |
 Topic  |
|
bobby131313
Senior Member
USA
1163 Posts |
 Posted - 31 July 2010 : 18:59:56
|
| Something real screwy now... still showing all closed items that I bid on, and now in the "Items I am Bidding on" table all the ending times are the same which is from the last item in the "Items I'm selling" table. |
Switch the order of your title tags |
 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 31 July 2010 : 19:06:04
|
| There you go. Done (I think). |
Edited by - Carefree on 31 July 2010 19:31:11 |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 01 August 2010 : 20:33:11
|
Another little bug with auction_bidders.asp.
The sorting is not numeric, it's going by the number of characters in the field first so a descending sort looks like this....
756.75
755.75
55555
I'm guessing the column has to be a different type? Or maybe it needs to be formatted to 2 decimal places before inserting in the DB? |
Switch the order of your title tags |
Edited by - bobby131313 on 01 August 2010 20:34:39 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 August 2010 : 10:52:46
|
| I didn't even look at the code, but the database column being a text type, you either convert and order it (which maybe be costly, performance wise) or the ordering will be text based, without the conversion. Likely everything would be easier if the column type was different - probably using a double would fit all 3 databases, if that was the concern, but not too sure the dbs syntax supports doubles. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 02 August 2010 : 14:40:01
|
The DBS syntax does support "double". Syntax should be like this
|
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 02 August 2010 : 18:07:00
|
tried running it and get this...
altering Column MAXPRICE...
ALTER TABLE FORUM_AUCTIONBIDS ALTER COLUMN MAXPRICE double NULL
ALTER TABLE FORUM_AUCTIONBIDS ALTER COLUMN MAXPRICE double NULL
-2147217900 | Incorrect syntax near the keyword 'NULL'.
altering Column OPENINGBID...
ALTER TABLE FORUM_AUCTIONITEMS ALTER COLUMN OPENINGBID double NULL
ALTER TABLE FORUM_AUCTIONITEMS ALTER COLUMN OPENINGBID double NULL
-2147217900 | Incorrect syntax near the keyword 'NULL'.
altering Column CURRENTBID...
ALTER TABLE FORUM_AUCTIONITEMS ALTER COLUMN CURRENTBID double NULL
ALTER TABLE FORUM_AUCTIONITEMS ALTER COLUMN CURRENTBID double NULL
-2147217900 | Incorrect syntax near the keyword 'NULL'. |
Switch the order of your title tags |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 August 2010 : 18:10:34
|
| As I said, double is not supported by the dbs management code, so it's transferred to the output SQL directly. If you replace double by float, it should work for SQL Server. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 August 2010 : 18:42:58
|
| In principle, you should have no issues adding bids but, as I said, didn't look at the code, so maybe check that the new type doesn't bring you any issues while adding bids. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 02 August 2010 : 23:52:31
|
| Float isn't available to Access users, guess there will have to be more than one version. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 August 2010 : 10:18:57
|
| That, or do a quick change in the two dbs handling files to add it. As of now, the dbs syntax does not support floating point types syntax common to all 3 supported databases. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Auction 2.0
.