Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Auction 2.0		  New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 11

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  10:48:45  Show Profile  Visit bobby131313's Homepage  Reply with Quote
I see the download was updated today, but the new auction_sellitem.asp still throws the Object required: 'rsAuctItem' error posted above.
Switch the order of your title tags
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 29 July 2010 :  15:34:46  Show Profile  Reply with Quote
Try downloading again Bobby, had to do with stopping users editing their items once a bid had been made, fixed it so should work.
Cheers,

David Greening
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  16:09:27  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Cool, that took care of that, but now when saving a new listing....

Microsoft SQL Server Native Client 10.0 error '80040e14'
Incorrect syntax near ','.
/forum/auction_save.asp, line 135
Switch the order of your title tags
Edited by - bobby131313 on 29 July 2010 16:09:48
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 July 2010 :  17:16:41  Show Profile  Reply with Quote
Change line 94 to say

    strName = chkString(cstr(Request.form("strName")), "SQLString")
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  17:40:22  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Sorry no luck, same thing.
Switch the order of your title tags
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 July 2010 :  18:43:17  Show Profile  Reply with Quote
At line 135, insert two lines. Run it again and give us the output.

Response.Write strSql
Response.End

This will terminate program with data we need.
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  18:46:36  Show Profile  Visit bobby131313's Homepage  Reply with Quote
INSERT INTO FORUM_AUCTIONITEMS (SELLER, ITEMNAME, AUCTIONCATID, ITEMDESC, IMGURL, OPENINGBID, CURRENTBID, STARTDATE, ENDDATE) VALUES('2', 'testing', '1', 'some more testing', 'http://', , 1.00, '20100729184559', '20100801184559')

Looks like an extra space between imgurl and openingbid right?
Switch the order of your title tags
Edited by - bobby131313 on 29 July 2010 18:48:13
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 July 2010 :  18:55:03  Show Profile  Reply with Quote
Found it. Line 134 is incorrect. Change it to say:

				strsql = strsql & " VALUES('" & strUsername & "', '" & strName & "', '" & strCategory & "', '" & strDesc & "', '" & strImage & "', " & curMin & ", " & curMin & ", '" & dtmStart & "', '" & dtmEnd & "')"


Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  19:03:41  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Cool, I was looking at it myself and just did that.

More testing...

Thanks!
Switch the order of your title tags
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 July 2010 :  19:10:21  Show Profile  Reply with Quote
You're welcome.
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  19:45:51  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Looks like same thing needs to be done for the edit mode right above that.
Switch the order of your title tags
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 July 2010 :  20:59:55  Show Profile  Reply with Quote
I'll look later at that one. Have to check field type in the database, to see if it's int or str value.
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 29 July 2010 :  21:05:35  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Well, I was getting the same error on editing on the same value being blank. Since there can be no edit after the first bid, opening bid and current bid will still be the same in edit mode. Right?
Switch the order of your title tags
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 29 July 2010 :  21:24:00  Show Profile  Reply with Quote
Yes. But they are in string format, so logically, it should read like this:

				strSql="UPDATE " & strTablePrefix & "AUCTIONITEMS SET ITEMNAME='" & strName & "', AUCTIONCATID='" & strCategory & "', ITEMDESC='" & strDesc & "', IMGURL='" & strImage & "', OPENINGBID='" & curMin & "', CURRENTBID='" & curMin & "', ENDDATE='" & dtmEnd & "' WHERE AUCTIONID=" & AuctionID


However, since CurMin works below as an integer format, you can try this. One or the other will work. I'm not using the latest version, so can't test it for you.


				strSql="UPDATE " & strTablePrefix & "AUCTIONITEMS SET ITEMNAME='" & strName & "', AUCTIONCATID='" & strCategory & "', ITEMDESC='" & strDesc & "', IMGURL='" & strImage & "', OPENINGBID=" & curMin & ", CURRENTBID=" & curMin & ", ENDDATE='" & dtmEnd & "' WHERE AUCTIONID=" & AuctionID
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 30 July 2010 :  04:18:10  Show Profile  Reply with Quote
Whoops, did the changes on my local test system and forgot (well, I thought I did) to copy the new files to the zip location. Updated now...
Cheers,

David Greening
Go to Top of Page
Page: of 11 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07